AndreaBozzo/ceres-open-data-index huggingface dataset:
Housing Market Value Analysis 2021

In 2021, Allegheny County Economic Development (ACED), in partnership with Urban Redevelopment Authority of Pittsburgh(URA), completed the a Market Value Analysis (MVA) for Allegheny County.  This analysis services as both an update to previous MVA’s commissioned separately by ACED and the URA and combines the MVA for the whole of Allegheny County (inclusive of the City of Pittsburgh). The MVA is a unique tool for characterizing markets because it creates an internally referenced index of a municipality’s residential real estate market. It identifies areas that are the highest demand markets as well as areas of greatest distress, and the various markets types between. The MVA offers insight into the variation in market strength and weakness within and between traditional community boundaries because it uses Census block groups as the unit of analysis. Where market types abut each other on the map becomes instructive about the potential direction of market change, and ultimately, the appropriateness of types of investment or intervention strategies.  

This MVA utilized data that helps to define the local real estate market. The  data used covers the 2017-2019 period, and data used in the analysis includes:

* Residential Real Estate Sales
* Mortgage Foreclosures
* Residential Vacancy
* Parcel Year Built
* Parcel Condition
* Building Violations
* Owner Occupancy
* Subsidized Housing Units

The MVA uses a statistical technique known as cluster analysis, forming groups of areas (i.e., block groups) that are similar along the MVA descriptors, noted above. The goal is to form groups within which there is a similarity of characteristics within each group, but each group itself different from the others. Using this technique, the MVA condenses vast amounts of data for the universe of all properties to a manageable, meaningful typology of market types that can inform area-appropriate programs and decisions regarding the allocation of resources.

Please refer to the presentation and executive summary for more information about the data, methodology, and findings.

Tags: aced, affordable-housing, block-groups, business-and-economy, census-block-groups, economic-development, foreclosures, housing, housing-and-properties, mva, properties, property, ura, urban-redevelopment-authority
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
2020 Census Redistricting Data Extracts (PL 94-171)

Chris Briem of the University of Pittsburgh Center for Social and Urban Research has been producing extracts from the Census Bureau's PL 94-171 redistricting file.

On August 12th, the U.S. Census Bureau released the first detailed data from the 2020 Decennial Census of Population and Housing. Before this, the only data that has been released from the 2020 Census has been total population counts by state needed for the reapportionment of congressional seats. The data just released is known as PL 94-171 data and includes the final census enumeration of the population by race and ethnicity for counties, municipalities, and smaller levels of geography.

PL 94-171 data is used in the redrawing of the boundaries for federal, state, and local legislative districts, a process known as redistricting. This data includes housing unit counts, occupancy status for housing units, population totals, and population by race Hispanic/Latino origin, voting-age population (age 18+), and group quarters counts. The Census Bureau will be releasing additional data, including more detailed population and household statistics from the 2020 Census in the future.

Tags: 2010, 2020, block, census-2020, census-bureau, county-subarea, demographics, municipality, neighborhood, pl-94-171, population, redistricting
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Childhood Asthma Healthcare Utilization

This data shows healthcare utilization for asthma by Allegheny County residents 18 years of age and younger. It counts asthma-related visits to the Emergency Department (ED), hospitalizations, urgent care visits, and asthma controller medication dispensing events.

The asthma data was compiled as part of the Allegheny County Health Department’s Asthma Task Force, which was established in 2018. The Task Force was formed to identify strategies to decrease asthma inpatient and emergency utilization among children (ages 0-18), with special focus on children receiving services funded by Medicaid. Data is being used to improve the understanding of asthma in Allegheny County, and inform the recommended actions of the task force. Data will also be used to evaluate progress toward the goal of reducing asthma-related hospitalization and ED visits.

Regarding this data, asthma is defined using the International Classification of Diseases, Tenth Revision [(IDC-10) classification system code J45.xxx](https://icd.who.int/browse10/2016/en#/J40-J47). The ICD-10 system is used to classify diagnoses, symptoms, and procedures in the U.S. healthcare system. 

Children seeking care for an asthma-related claim in 2017 are represented in the data. Data is compiled by the Health Department from medical claims submitted to three health plans (UPMC, Gateway Health, and Highmark). Claims may also come from people enrolled in Medicaid plans managed by these insurers. The Health Department estimates that 74% of the County’s population aged 0-18 is represented in the data.

Users should be cautious of using administrative claims data as a measure of disease prevalence and interpreting trends over time. Missing from the data are the uninsured, members in participating plans enrolled for less than 90 continuous days in 2017, children with an asthma-related condition that did not file a claim in 2017, and children participating in plans managed by insurers that did not share data with the Health Department. 

Data users should also be aware that diagnoses may also be subject to misclassification, and that children with an asthmatic condition may not be diagnosed. It is also possible that some children may be counted more than once in the data if they are enrolled in a plan by more than one participating insurer and file a claim on each policy in the same calendar year.

Tags: children, disparity, equity, health, health-insurance, healthcare, public-health, social-determinants-of-health
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Butler County Crash Data

Contains locations and information about every crash incident reported to the police in Butler County from 2011 to 2015. Fields include injury severity, fatalities, information about the vehicles involved, location information, and factors that may have contributed to the crash. Data is provided by PennDOT and is subject to PennDOT's data privacy restrictions, which are noted in the metadata information section below.

**This data is historical only, but new data can be found on PennDOT's Crash Download Map tool linked in the Resources section.

Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Westmoreland County Crash Data

Contains locations and information about every crash incident reported to the police in Westmoreland County from 2011 to 2015. Fields include injury severity, fatalities, information about the vehicles involved, location information, and factors that may have contributed to the crash. Data is provided by PennDOT and is subject to PennDOT's data privacy restrictions, which are noted in the metadata information section below.

**This data is historical only, but new data can be found on PennDOT's Crash Download Map tool linked in the Resources section.

Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Beaver County Crash Data

Contains locations and information about every crash incident reported to the police in Beaver County from 2011 to 2015. Fields include injury severity, fatalities, information about the vehicles involved, location information, and factors that may have contributed to the crash. Data is provided by PennDOT and is subject to PennDOT's data privacy restrictions, which are noted in the metadata information section below.

**This data is historical only, but new data can be found on PennDOT's Crash Download Map tool linked in the Resources section.

Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Washington County Crash Data

Contains locations and information about every crash incident reported to the police in Washington County from 2011 to 2015. Fields include injury severity, fatalities, information about the vehicles involved, location information, and factors that may have contributed to the crash. Data is provided by PennDOT and is subject to PennDOT's data privacy restrictions, which are noted in the metadata information section below.

**This data is historical only, but new data can be found on PennDOT's Crash Download Map tool linked in the Resources section.

Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Allegheny County Mortality Indicators

This data includes counts of deaths by race (total, Black, white) by age grouping and cause of death by Census Tract aggregated over a five-year period (2014-18). Data extracted from Pennsylvania's Electronic Death Registry System (EDRS) with the following disclaimer: "These data were provided by the Pennsylvania Department of Health.  The Department specifically disclaims responsibility for any analyses, interpretations, or conclusions."

Census tract of residence was determined using address-level data.  Records were excluded from analysis if address was missing or unmatched to a census tract (≈1% records).  Census tracts starting with 980x.xx, 981x.xx, and 982x.xx were also excluded due to a geocoding error.

For cause of death by census tract, counts were assessed using census tract by age and race;  records were excluded if age, race, or location data were missing. Census-tract level counts < 5 are censored and displayed as NULL. Census-tract-level counts may not equal county-level counts when summed due to censored data or missing data.

Tags: cause-of-death, deaths, health, mortality
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Allegheny County Kane Regional Center Census

Total number of residents in each Kane Regional Center facility by race and gender. The Kane Regional Centers are skilled nursing and rehabilitation centers run by Allegheny County. 

A census of residents recorded once a week.

**NOTE: The feed updating this dataset is currently not functioning. We're working to update the available data and get a new feed working.**

**The reports from the legacy system broke before that system was taken offline, and so the reports from September 2019 to February 2020 cannot be run.**

Tags: _etl, aging, census, nursing, nursing-homes, seniors
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Allegheny County Birth Outcomes

This data includes several different tables presenting counts of births by race (total, Black, white) by Census Tract aggregated over a five-year period (2014-18). Data extracted from Pennsylvania's Vital Statistics Database with the following disclaimer: "These data were provided by the Pennsylvania Department of Health.  The Department specifically disclaims responsibility for any analyses, interpretations, or conclusions."

Census tract of residence was determined using address-level data.  Records were excluded from analysis if address was missing or unmatched to a census tract (≈1% records).  Census tracts starting with 980x.xx, 981x.xx, and 982x.xx were also excluded due to a geocoding error.  2014 used a different methodology to assign census tract compared to years 2015-2018. 

Counts < 5 are censored and displayed as "None". Census-tract-level counts may not equal county-level counts when summed due to censored data or missing data. For cause of death, underlying cause of death from the death certificate is used and is categorized based on ICD-10 codes, defined below.

Tags: births, natality
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
ACED Allegheny Home Improvement Loan Program (AHILP)

The Allegheny Home Improvement Loan Program (AHILP) is the most affordable way for eligible Allegheny County residents to rehabilitate and improve their homes. AHILP provides low interest home improvement loans to qualified owner occupiers. The program is administered by the Redevelopment Authority of Allegheny County (RAAC). This dataset contains quarterly loan amounts by municipality.

Tags: business-and-economy, housing-and-properties
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Pittsburgh Regional Transit Bus Stop Usage

This dataset shows stop-level boardings and alightings for selected months from 2019 onwards. Typically ridership is highest in September. This dataset will update each month with the latest data. 

There is also a deprecated dataset showing all bus stops active in Pittsburgh Regional Transit's fiscal year 2019 (7/1/2018 to 6/30/2019) along with latitude/longitude, stop type and amenities, and average boardings and alightings.

The boardings and alightings are available as an average for the schedule pick and the fiscal year average. A schedule "pick" is a four digit year-month ID for the quarterly schedule period, e.g. 1809 is the schedule period starting September 2018.

Rail stops/stations are not included as riders either pay at the platform (unable to join to specific route) or on the railcar (unable to join to specific platform).

Tags: bus, bus-stop, busway, incline, light-rail, port-authority, public-transit, the-t, tranportation, transit-stop
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
True Time API Link (real time arrival info)

This link will take you to the site where you can create an account to access Pittsburgh Regional Transit's real time arrival information. To request access to Pittsburgh Regional Transit's real-time API, login or create an account at http://truetime.portauthority.org. Once you log in, go to "My Account", under "Developer API", click the link to request access.

Tags: api, arrival, bus, light-rail, lrt, paac, port-authority, real-time, subway, transportation, true-time
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Pittsburgh Regional Transit Transit Stops

All transit stops within the Pittsburgh Regional Transit's service area for the 1909 schedule period: 9/1/2019 to 11/23/2019.

Tags: bus, incline, light-rail, port-authority, port-authority-of-allegheny-county, routes, shelter, station, stop, transit, transportation
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Pittsburgh Regional Transit Transit Routes

Shapefiles of Pittsburgh Regional Transit routes. Routes change over time. The 4-digit code corresponds to the "pick" or schedule period of that route; for example, the schedule period beginning in September 2019 is known as the 1909 pick.

Tags: bus, gis, incline, light-rail, port-authority, port-authority-of-allegheny-county, routes, transit, transportation
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Pittsburgh Regional Transit Scheduled Trip Counts

This dataset lists Pittsburgh Regional Transit scheduled bus and rail trip counts and distances since November 2016. 

For convenience, this data is published in several formats:
- Daily Scheduled Trips: Aggregated total trip count and trip distances for each route per day.
- Monthly Scheduled Trips: Aggregated total trip count and trip distances for each route per month and day type (weekday, Saturday, and Sunday). This can be joined with the Monthly Ridership dataset on DateKey, Route, and DayType to normalize the average riders per trip.
- Detailed Daily Scheduled Trips: This dataset lists the detailed daily schedule for each route, including the start and end times for each trip. This can be used to see the earliest and latest runs and study peak- and off-peak trip frequencies.

Port Authority makes quarterly schedule adjustments that include adding and removing trips on certain routes to better serve riders.  These schedule adjustments are called "picks" and correspond to the year and month of the schedule change, e.g. the November 2016 pick is known as 1611.

Tags: bus, picks, public-transit, rail, schedules, timetable, transit, transportation, trip-count, trip-distance, trips
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Pittsburgh Regional Transit Schedule Period Lookup

Pittsburgh Regional Transit makes schedule adjustments quarterly. These schedule adjustments are called "picks" and correspond with operators picking their assignments.

Tags: 1711, 1803, 1806, 1809, 1811, 1903, 1906, 1909, bus, incline, light-rail, pick, public-transit, rail, schedule, transit, transportation
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Parcel Centroids in Allegheny County with Geographic Identifiers

Parcel centroids in Allegheny County. Centroids created by the Western PA Regional Data Center using County parcel shapes found on PASDA or WPRDC. Centroids have been drawn within the parcel boundary in most cases. The Data Center also appended a number of geographic codes to the data, including 2010 Census Blocks, Blockgroups, and Census Tracts, County Subdivisions (Municipalities), School Districts, State House and Senate Districts, and Allegheny County Council Districts.

Tags: centroid, coordinate, crosswalk, latitude, longitude, parcel, xy
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Healthy Ride Trip Data (archive)

A dataset that shows trips taken using the Healthy Ride system by quarter. The dataset includes bike number, membership type, trip start and end timestamp, and origin and destination information. A trip is defined as any valid rental one minute or longer.

The Healthy Ride system was replaced by POGOH in May 2022. Data for POGOH may be found here: https://data.wprdc.org/organization/pogoh

Tags: bike, bike-share, rental, trip
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Allegheny County Crash Data

Contains locations and information about every crash incident reported to the police in Allegheny County from 2004 to 2020. Fields include injury severity, fatalities, information about the vehicles involved, location information, and factors that may have contributed to the crash. Data is provided by PennDOT and is subject to PennDOT's data privacy restrictions, which are noted in the metadata information section below.

The map below shows car crashes in Allegheny County during 2016, with the color indicating whether it was a rear end collision or not.

Tags: _etl, _jupyter, accident, bicycle, bus, car, crash, incident, motorcycle, pedestrian, speed, traffic, transportation, truck, vehicle
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Healthy Ride Stations (archive)

Healthy Ride station locations, names, id numbers, and dock capacities.

The Healthy Ride system was replaced by POGOH in May 2022.  Data for the POGOH system may be found here: https://data.wprdc.org/organization/pogoh

Tags: bike-share, return, station
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Current Bike Availability by Station (archive)

A structured data feed that provides current bike availability at Healthy Ride stations in Pittsburgh.

The Healthy Ride system was replaced by POGOH in May 2022.  Data for the POGOH system may be found here: https://data.wprdc.org/organization/pogoh

Tags: bikeshare, real-time, transportation
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Pediatric Emergency Department and Primary Care Visits (UPMC)

This dataset captures  data maintained by the [Record Research Request Service (R3)](http://rio.pitt.edu/services) at the University of Pittsburgh. R3 is a service of the Department of Biomedical Informatics (DBMI), provisioning UPMC clinical data and authorizing additional UPMC data sources for research. 

Data captures  emergency department (ED) visits  and primary care visits for the pediatric population (ages 0-17) served by UPMC  in Allegheny County by Census Block Group geography (using 2010 U.S. Census geographies).

ED Data captures total visits, along with visits related to asthma, injury, low-acuity visits, and respiratory tract infections. Low acuity visits are often defined as visits by patients that didn't arrive by ambulance and visits that were less-serious or less-urgent where the patient was discharged to their normal place of residence.

The primary care visit data includes total visits, well child visits, and asthma diagnoses.

Each dataset includes the estimated population in each blockgroup. This estimate was obtained from the U.S. Census Bureau's 2015-19 5-year American Community Survey. Pediatric populations are defined as those under age 18.

UPMC data captures a large share of ED visits due to the health system's role with UPMC Children's Hospital of Pittsburgh.

The Regional Data Center teamed with colleagues at the University of Pittsburgh Center for Social Research to geocode data to blockgroup, and the totals were computed by R3.

Special thanks to partners at The Pittsburgh Study for helping us make this data available, and the [Data Across Sectors for Health](https://dashconnect.org/) program for providing financial support for this work.

Tags: asthma, child, emergency-department, emergency-room, health, injury, low-acuity, pediatric, primary-care, r3, respiratory-tract-infection, tps, well-child
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Right-of-Way Permits and Traffic-Obstruction Permits

Submitted permits which affect the public right of way, including; road openings, machinery, valet parking, traffic obstructions, and more.

**NOTE: This data feed is no longer functioning. We're working on getting access to the missing records and restoring the feed.**

Tags: _etl, construction, machines, obstructions, permits, right-of-way, road-closures, streets, traffic
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Pre 2018 DPW Divisions

City of Pittsburgh Department of Public Works Divsions Pre 2018. This data has Division 4 in it.  In the most current DPW Division layer Division 4 has been removed and its area split between Divisions 3 and 5.

Tags: civic-vitality-and-governance, civic-vitality-governance, harvested, pittsburgh
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center