AndreaBozzo/ceres-open-data-index huggingface dataset:
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.

___Support for Health Equity datasets and tools provided by [Amazon Web Services (AWS)](https://aws.amazon.com/) through their [Health Equity Initiative](https://aws.amazon.com/government-education/nonprofits/global-social-impact/health-equity/).___

Tags: asthma, child, emergency department, emergency room, health, injury, low acuity, pediatric, primary care, r3, respiratory tract infection, tps, well child
Organization: University of Pittsburgh
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.


___Support for Health Equity datasets and tools provided by [Amazon Web Services (AWS)](https://aws.amazon.com/) through their [Health Equity Initiative](https://aws.amazon.com/government-education/nonprofits/global-social-impact/health-equity/).___

Tags: births, natality
Organization: Allegheny County
State of Aging in Allegheny County Survey

For more than three decades UCSUR has documented the status of older adults in the County along multiple life domains.  Every decade we issue a comprehensive report on aging in Allegheny County and this report represents our most recent effort.  It documents important shifts in the demographic profile of the population in the last three decades, characterizes the current status of the elderly in multiple life domains, and looks ahead to the future of aging in the County.  This report is unique in that we examine not only those aged 65 and older, but also the next generation old persons, the Baby Boomers.  Collaborators on this project include the Allegheny County Area Agency on Aging, the United Way of Allegheny County, and the Aging Institute of UPMC Senior Services and the University of Pittsburgh.

 The purpose of this report is to provide a comprehensive analysis of aging in Allegheny County.  To this end, we integrate survey data collected from a representative sample of older county residents with secondary data available from Federal, State, and County agencies to characterize older individuals on multiple dimensions, including demographic change and population projections, income, work and retirement, neighborhoods and housing, health, senior service use, transportation, volunteering, happiness and life satisfaction, among others.  Since baby boomers represent the future of aging in the County we include data for those aged 55-64 as well as those aged 65 and older.

___Support for Health Equity datasets and tools provided by [Amazon Web Services (AWS)](https://aws.amazon.com/) through their [Health Equity Initiative](https://aws.amazon.com/government-education/nonprofits/global-social-impact/health-equity/).___

Tags: aging, allegheny county, gerontology, older adults, survey
Organization: University of Pittsburgh
Allegheny County Median Age at Death

The median age at death is calculated for each municipality in Allegheny County. Data is based on the decedent's residence at the time of death, not the location where the death occurred. Median age by municipality is based on “official” death records that have been released by the Pennsylvania Department of Health. Data is broken out by race (white/black), and also includes a count of deaths for City of Pittsburgh neighborhoods and Allegheny County Municipalities.

___Support for Health Equity datasets and tools provided by [Amazon Web Services (AWS)](https://aws.amazon.com/) through their [Health Equity Initiative](https://aws.amazon.com/government-education/nonprofits/global-social-impact/health-equity/).___

Tags: ACHD DASH, death, median age, mortality, social determinants of health
Organization: Allegheny County
Allegheny County Clean Indoor Air Act Exemptions

List and location of all the businesses and social clubs who have received an exemption from the Pennsylvania Clean Indoor Air Act. “The Clean Indoor Air Act, Act 27 of 2008, was signed into law on June 13, 2008. The legislation prohibits smoking in a public place or a workplace and lists examples of what is considered a public place. The bill allows for some exceptions, including a private residence (except those licensed as a child care facility), a private social function where the site involved is under the control of the sponsor (except where the site is owned , leased, or operated by a state or local government agency) and a wholesale or retail tobacco shop. It also imposes penalties for those establishments in noncompliance, as well as those individuals smoking in prohibited areas.”

___Support for Health Equity datasets and tools provided by [Amazon Web Services (AWS)](https://aws.amazon.com/) through their [Health Equity Initiative](https://aws.amazon.com/government-education/nonprofits/global-social-impact/health-equity/).___

Tags: ACHD DASH, CIAA, Tobacco, clean indoor air act, social determinants of health
Organization: Allegheny County
Allegheny County Assets

This dataset contains lists of various kinds of assets (open prior to or as of March 1, 2020), derived from a variety of local, state, and federal data sources. Not all of this data has been verified. Some geocoding is either missing or incorrect. Improvements and updates are pending.

This data was assembled to support 2020 Census outreach efforts, and can also be used to support COVID-19 response efforts.

A [companion map](https://assets.wprdc.org/) displaying this data has also been created to support Census outreach. It too is a work in progress, and we'll be adding new features in the coming weeks. 

Types of assets reflected in the data include 

Allegheny County Housing Authority community sites, Allegheny County Health Department clinics, affordable housing properties, apartment buildings, banks, barbershops, bars, bus stops, child care centers, coffee shops, community nonprofit organizations, dentists, doctor's offices, faith-based facilities, family support centers, farmers' markets, food banks, gas stations, hair salons, health centers, homeless shelters, laundromats, libraries, museums, nail salons, nursing homes, park and rides, parks and facilities, pharmacies, polling places, post offices, public buildings, recreation centers, restaurants, schools, senior centers, supermarkets, universities, VA facilities, veterans social orgs, WIC offices, and WIC vendors.

___Support for Health Equity datasets and tools provided by [Amazon Web Services (AWS)](https://aws.amazon.com/) through their [Health Equity Initiative](https://aws.amazon.com/government-education/nonprofits/global-social-impact/health-equity/).___

Tags: Fast food, _etl, assets, businesses, child, civic, early childhood, faith, food, grocery, health, housing, medical, museums, parks, pharmacy, post offices, restaurant, restaurants, schools, supermarket, supermarkets, transportation
Organization: Western Pennsylvania Regional Data Center
Allegheny County Air Quality

Air quality data is collected from the Allegheny County Health Department monitors throughout the county. This data must be verified by qualified individuals before it can be considered official. The following data is unverified. This means that any electrical disruption or equipment malfunction can report erroneous monitored data.

<!--The dashboard featured in the image below uses the data provided through this source.--> For more information about the Health Department's Air Quality Program or to view a live version of the dashboard, please visit the ACHD website: https://www.alleghenycounty.us/Services/Health-Department/Air-Quality

___Support for Health Equity datasets and tools provided by [Amazon Web Services (AWS)](https://aws.amazon.com/) through their [Health Equity Initiative](https://aws.amazon.com/government-education/nonprofits/global-social-impact/health-equity/).___

Tags: Ozone, PM 2.5, Sulfur Dioxide SO2, _etl, air, air pollution, air quality, fine particulate matter, health, pollution
Organization: Allegheny County
Aggregated Parking Transactions

This dataset records Pittsburgh Parking Authority parking transactions for street parking and parking lots, aggregated in ten-minute bins by parking zone. Each row includes the start and end times of the ten-minute bin, the parking zone or lot, the number of transactions, and the payments made during that time span.

**DATA ADVISORY UPDATE (May 2026)**: The Parking Authority changed its mobile payments system in April/May 2021, some mobile transactions are missing from the data in this dataset between April 2021 and October 2023. Data after October 2023 does not have this problem. We're working on restoring the missing records.

_The first resource below is big enough that the download link will time out and not let you download the file. As a workaround, you may use this download link:_ https://tools.wprdc.org/downstream/1ad5394f-d158-46c1-9af7-90a9ef4e0ce1

Tags: _etl, parking
Organization: Pittsburgh Parking Authority
Pittsburgh 311 Data

City of Pittsburgh has transitioned to a new 311 system February 4, 2025 - this is the data from the new system.

This data set shows 311 service requests in the City of Pittsburgh. This data is collected from the request intake software used by the 311 Response Center in the Department of Innovation & Performance. Requests are collected from phone calls, tweets, emails, a form on the City website, and through the 311 mobile application.

The dataset contains both the new 311 system records and all records dating back to the 2015 launch of the previous system. 



Tags: 3-1-1, 311, _etl, paving, potholes, service requests
Organization: City of Pittsburgh
Allegheny County Plumbers

All master plumbers must be registered with the Allegheny County Health Department. 

Only Registered Master Plumbers who possess a current plumbing license or owner/occupant of an existing single family dwelling may apply for a plumbing permit. Plumbing permits are required to construct, enlarge, alter, repair, move, demolish or change occupancy of a building or structure. 

**NOTE:** At present, the list of active plumbers is being generated from inspection records, so if an active plumber hasn’t had any work inspected since July 30, their name won’t appear in the Plumbers table.

___Support for Health Equity datasets and tools provided by [Amazon Web Services (AWS)](https://aws.amazon.com/) through their [Health Equity Initiative](https://aws.amazon.com/government-education/nonprofits/global-social-impact/health-equity/).___

Tags: _etl, health, plumbing
Organization: Allegheny County
Allegheny County Restaurant/Food Facility Inspections and Locations

**We've re-established an Inspections feed (see new table below); we are still working to restore the other feeds for this dataset.**

Facilities located within Allegheny County that produce, distribute and sell food products are subject to mandatory, routine inspection by one of the health department's staff of environmental health specialists.

This dataset contains the violation data from the searchable inspection reports posted online here: http://webapps.achd.net/Restaurant/. The inspection date ranges from January 2014 to present. A table of geocoded facility locations is also included. New data will be added monthly. 

___Support for Health Equity datasets and tools provided by [Amazon Web Services (AWS)](https://aws.amazon.com/) through their [Health Equity Initiative](https://aws.amazon.com/government-education/nonprofits/global-social-impact/health-equity/).___

Tags: _etl, achd, food, health, inspections, public safety, restaurant, violations
Organization: Allegheny County
Allegheny County Asbestos Permits

Current asbestos permit data issued by the County for commercial building demolitions and renovations as required by the EPA. This file is updated daily and can be downloaded below.

If you're looking for the documents themselves, click on the link directly below to navigate to Allegheny County's Open Document Portal. Here you can search for printable PDFs of the applications and permits for posting at job sites. Start with the 'Select Search Type' drop down field. http://documents.alleghenycounty.us/publicaccess/DatasourceTemplate.aspx

**NOTE:** In the County's system, asbestos permits with status "in progress” status currently includes both permits that have already been issued and those still awaiting review. Until this is resolved, the data published here will exclude all permits marked as "in progress", which does exclude some issued permits.

___Support for Health Equity datasets and tools provided by [Amazon Web Services (AWS)](https://aws.amazon.com/) through their [Health Equity Initiative](https://aws.amazon.com/government-education/nonprofits/global-social-impact/health-equity/).___

Tags: _etl, achd, health, inspections, permits, properties, public safety, violations
Organization: Allegheny County
Greenways

Pittsburgh Greenways

From [https://engage.pittsburghpa.gov/greenways-expansion-planning](https://engage.pittsburghpa.gov/greenways-expansion-planning):
"A greenway is a _permanently_ conserved, public open space that is primarily stewarded by the community and provides benefits such as minimizing landslide risk, reducing the effects of extreme heat, preserving tree canopy, and creating recreation opportunities."

Tags: _etl, environment, pittsburgh
Organization: City of Pittsburgh
Allegheny County Human Services Community Profiles

The Allegheny County data warehouse was created to support integrated social services for people and to improve decision-making to create better systems to serve people in the County.  The warehouse is managed by the Allegheny County Department of Human Services (DHS).

This resource uses information from the warehouse and provides Municipality and Pittsburgh Neighborhood level information for specific community indicators and for individuals receiving specific DHS services.



Tags: _etl, human services, programs, social services
Organization: Allegheny County
Allegheny County Municipal Building Energy and Water Use

This dataset contains energy and water use information from 2010 up through 90 days prior the last refresh date for County-operated buildings. Metrics include: kBtu (thousand British thermal units), site and source EUI (energy use intensity), annual electricity, natural gas and steam consumption and cost, and water and sewer use and cost. Weather-normalized data enable building performance comparisons over time, despite unusual weather events.

Tags: EUI, _etl, buildings, energy, energy efficiency, sewer, water
Organization: Allegheny County
IRISE Regional Landslide Inventory for Southwestern Pennsylvania

![IRISE logo](https://www.engineering.pitt.edu/contentassets/95adc5a838744acca4e94a9a668ad015/irise-new-logo-nobottomtext.png)

Landslide data (1920-present) for the 12 county region within PennDOT Districts 10, 11, and 12. Landslide locations are provided as points and are attributed with an extensive list of landslide relevant data (the complete list is provided [here](https://www.engineering.pitt.edu/contentassets/3d8715ebbb8746d4aa0daf5420880612/rba01-iriselandslidedatabaserep.pdf)).

Tags: freeze-thaw, hillslope processes, landslide, mining history, redbeds, rockfall
Organization: University of Pittsburgh
Parking Purchases (historical)

This dataset contains transaction-level records of purchases of parking from the Pittsburgh Parking Authority, from Q4 2015 through 2018.

Individual transactions are published with information including the zone or meter where the purchase was made, start time of the interval paid for, end time of the interval paid for,  purchase time (for meter transactions), date recorded in the database (a good proxy for purchase time for mobile transactions), amount paid in that transaction, whether the transaction was made through a smart phone (a "mobile" transaction) or at a meter (in which case the means of payment will be identified as cash, credit card, or a combination of the two), and whether a given purchase started a new parking session or extended an existing session.

The payment-interval start times are the same for all transactions in a given session: If someone pays to park at 9am and then 15 minutes later adds more money to extend their parking session, there will be two rows in the table (one for the 9am purchase and one for the 9:15am purchase), but both rows will have the same payment-interval start time (9am) since the payment interval is at the parking-session level.

Tags: parking
Organization: Pittsburgh Parking Authority
ACDBE/DBE Certified Businesses by the Department of Equity and Inclusion (DEI)

This dataset includes Pennsylvania Unified Certification Program (PA UCP) Firms certified as Airport Concessionaire Disadvantaged Business Enterprises (ACDBE)/Disadvantage Business Enterprises (DBEs) by the Department of Equity and Inclusion. It does not include all PA UCP certified businesses in Allegheny County. A complete list of firms certified by the PA UCP is available at [dotsbe.pa.gov](https://paucp.dbesystem.com/). Allegheny County is one of five certifying participant in the PA UCP. Firms wishing to be certified can do so at no cost through DEI.

According to the Federal Department of Transportation, Disadvantaged Business Enterprises (DBE) are for-profit small business concerns where socially and economically disadvantaged individuals own at least a 51% interest and control management and daily business operations. To encourage participation in government contracting, these businesses can be eligible for contract set-asides and help organizations meet participation goals. To participate in these programs, a small business owned and controlled by socially and economically disadvantaged individuals must receive DBE certification from the relevant state– generally through the state Uniform Certification Program (UCP). The PA UCP is established in accordance with 49 CFR Part 26 and 49 CFR Part 23. More information can be found at [Electronic Code of Federal Regulations](https://www.ecfr.gov). 

Automatic updates to this dataset have been restored. The source for this data is the the [PAUCP web site](https://paucp.dbesystem.com/).

Tags: _etl, business, business and economy, dbe, disadvantaged, equity, minority, mwbe
Organization: Allegheny County
Weekly Pennsylvania COVID-19 Vaccinations Stats Archive (archived)

**This dataset is now archived and purely historical. The state of Pennsylvania stopped updating the source data at the end of June, 2023.**

Weekly archive of some State of Pennsylvania datasets found in this list: https://data.pa.gov/browse?q=vaccinations

For most of these datasets, the "date_saved" field is the date that the WPRDC pulled the data from the state data portal and the archive combines all the saved records into one table. The exception to this is the "COVID-19 Vaccinations by Day by County of Residence Current Health (archive)" which is already published by the state as an entire history.

The "date_updated" field is based on the date that the "updatedAt" field from the corresponding data.pa.gov dataset. Changes to this field have turned out to not be a good indicator of whether records have updated, which is why we are archiving this data on a weekly basis without regard to the "updatedAt" value. The "date_saved" field is the one you should sort on to see the variation in vaccinations over time.

Most of the source tables have gone through schema changes or expansions. In some cases, we've kept the old archives under a separate resource with something like "[Orphaned Schema]" added to the resource name. In other cases, we've adjusted our schema to accommodate new column names, but there will be a date range during which the new columns have null values because we did not start pulling them until we became aware of them.

___Support for Health Equity datasets and tools provided by [Amazon Web Services (AWS)](https://aws.amazon.com/) through their [Health Equity Initiative](https://aws.amazon.com/government-education/nonprofits/global-social-impact/health-equity/).___

Tags: archived, covid-19, vaccinations
Organization: Western Pennsylvania Regional Data Center