AndreaBozzo/ceres-open-data-index huggingface dataset:
Allegheny County Public Swimming Pool, Hot Tub, and Spa Inspections

**The data feed for this dataset is under maintenance. We're working to restore it.**

This dataset includes information from inspection reports of permitted swimming pools, recirculating spray pads, and hot tubs/spas in Allegheny County. In conjunction with the National Environmental Health Association (NEHA), and under the framework of their SAFE Aquatic Data Standard, a selection of fields was identified to be pulled from aquatic facility inspection reports into this compiled dataset. 

The fields represent information that would be collected at a typical inspection of an aquatic facility not only in Allegheny County, but in other jurisdictions across the United States. These fields include things like disinfectant level, if the water was clear during the inspection, if appropriate safety equipment was present & in good repair, etc. The ultimate hope is that if other jurisdictions establish an online open data portal with information that corresponds with the SAFE Aquatic Data Standard, data could be compared and analyzed in a standardized way across the US, something that cannot currently be accomplished in an efficient manner due to the lack of a standardized data collection system. Allegheny County is one of only a handful of other jurisdictions that was selected by NEHA to be the pioneers of this new SAFE aquatic data standard. 

___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, hot tub, inspections, pools, spa
Organization: Allegheny County
Pittsburgh Regional Transit Monthly Average Ridership by Route

This dataset contains the average weekday, Saturday, and Sunday ridership by route for every month since January 2017. The aggregated ridership data allows quick study of trends over time and identification of problem areas for further analysis.

Bus, light rail (the "T"), and incline ridership data is included.

Routes and bus stops may change at every "pick" or quarterly schedule change in March, June, September, and November. 

Tags: _etl, bus, guiderails, incline, light rail, riders, ridership, the T, transit
Organization: Pittsburgh Regional Transit
PRT Monthly On Time Performance by Route

This dataset contains the monthly average on time performance (OTP) percentage by route and service day type (weekday, Saturday, and Sunday/Holiday service). A vehicle is considered on time if it is no more than one minute early or five minutes late to a timepoint.

PRT has an OTP goal of 73% for bus and 80% for rail service.

OTP provided for the last two year. Historic data available upon request. 

Tags: OTP, _etl, bus, calls for service, on time performance, performance, rail, reliability, transit
Organization: Pittsburgh Regional Transit
Police Incident Blotter (30 Day)

**This data ceased updating with the transition to a new records management system on 11/14/2023. Access to the updated data source will be provided in the future.**

The 30-Day Police Blotter contains the most recent initial crime incident data, updated on a nightly basis. All data is reported at the block/intersection level, with the exception of sex crimes, which are reported at the police zone level. The information is "semi-refined" meaning a police report was taken, but it has not made its way through the court system. This data is subject to change once it is processed and republished using Uniform Crime Reporting (UCR) standards. The UCR coding process creates a necessary delay before processed data is available for publication. Therefore, the 30-Day blotter will provide information for users seeking the most current information available.   

This dataset will be continually overwritten and any records older than thirty days will be removed. Validated incidents will be moved to the [Police Blotter Archive dataset](https://data.wprdc.org/dataset/uniform-crime-reporting-data). Data in the archived file is of a higher quality and is the file most appropriate for reporting crime statistics. 

This dataset only contains information reported by City of Pittsburgh Police, and does not contain incidents that solely involve other police departments operating within the city (campus police, Port Authority, etc.)

More documentation is available in our [Crime Data Guide](https://wiki.tessercat.net/wiki/Crime,_Courts,_and_Corrections_in_the_City_of_Pittsburgh).

Tags: _etl, arrests, blotter, crimes, incidents, police, public safety
Organization: City of Pittsburgh
Pittsburgh Fish Fry Locations

Lenten Fish Fry records for the Greater Pittsburgh region. Data is collected before and during the Lenten fish fry season each year by Code for Pittsburgh. Data is sourced from news outlets, social media, and public requests.

Tags: _etl, baked goods, fish, fish fry, food, fry, haluski, pierogi, pierogies, pirohi, pyrohi
Organization: Western Pennsylvania Regional Data Center
City of Pittsburgh Permit Summary (archive)

**This is now a historical archive. For current PLI permits, and permits dating back to 2019-06-01, see the new [PLI Permits dataset](https://data.wprdc.org/dataset/pli-permits).**

Summary of building permits Issued by the City of Pittsburgh's Department of Permits Licenses and Inspections (PLI).

Tags: building, building permits, department of permits licenses and inspections, permits, pittsburgh, pli
Organization: City of Pittsburgh
211 Service Requests

## Overview

Every day, thousands of people in our region are struggling to put food on the table, keep the lights on, and keep a roof over their head. 2-1-1 is a 24/7 telephone helpline (also available via text and chat) that helps prevent hunger, utility shut-offs and homelessness when people have nowhere else to turn. During each call, our Resource Navigators skillfully identify an individual’s immediate needs and connect them to services and resources that address the full spectrum of needs discovered through a thoughtful and compassionate conversation.

## Preprocessing/Formatting

When working with the data tables below, it's important to understand that they were obtained from different data management systems. Consequently, while the field names are consistent across the two tables, some of the actual values will differ. For instance, the `county` value is inferred from ZIP code in the 2020-2023 table (sometimes resulting in ambiguity, represented by a pipe-delimited list of possible `county` values), while in the 2023-2025 table, the `county` value is pulled directly from the raw data. Another difference is that the 2020-2023 table was obtained from the United Way of Southwestern PA and represents all calls/requests fielded through their system. The 2023-2025 table was obtained from the United Way of Pennsylvania, and represents the result of filtering requests down to those in the 25 counties in Western Pennsylvania.

Tags: 2-1-1, 2-1-1 counts, 211, 211 counts, _etl, human services, referrals, social services, united way
Organization: United Way of Southwestern Pennsylvania
Pittsburgh Police Firearm Seizures

**NOTE: This dataset has not been updated since 2022 due to data pipeline issues.**

This data includes counts of  firearms by type seized by the Pittsburgh Bureau of Police. Each row describes a seizure incident involving one or more firearms.
 
Firearm seizures can occur for several reasons. One of the Bureau of Police justifications for seizing a firearm involves a suspicion that a firearm was used in a criminal offense. Seizures may also occur to protect officer or public safety. For example, a weapon held by someone involved in a serious medical emergency, or an unattended  weapon found in a public space may be seized and held for safekeeping.
 
The Bureau’s firearms tracking unit conducts investigations to determine the rightful owner of firearms that have been seized. Where possible, the Bureau makes every effort to return firearms that have been seized to their rightful owners.
 
Firearms seized by non-City of Pittsburgh law enforcement agencies within the City of Pittsburgh may not be included in this data. Federal, State, County, and other special law enforcement agencies (e.g. campus, transit, hospital, etc.) operate within the City limits.
 
Data collected through supplemental reports filled out by Pittsburgh Bureau of Police officers upon taking possession of a firearm.
 
Locations where the seizure occurred  are anonymized to the address block or nearest intersection. It's not always possible to geocode these anonymized addresses.  In cases where geocoding fails, the latitude and longitude fields are left empty.  These will display as "None" in table views on the WPRDC site.
 
Exact date and report numbers have been removed to protect the privacy of individuals and any active investigations.

Tags: fire arms, firearm, guns, pistol, pistols, public safety, revolvers, rifles, seize, seizures, shotguns, weapons
Organization: City of Pittsburgh
Pennsylvania Vacant Addresses

Mail carriers routinely collect data on address no longer receiving mail due to vacancy. This vacancy data is reported quarterly at census tract geographies in the United States for residential, commercial, and industrial properties along with counts of total mailing addresses.

## Preprocessing/Formatting ##

The data is split into separate tables because different decades of data use different US Census geographies (e.g., 2010 U.S. Census tracts).

___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, EMBRACE, Structural Racism, pennsylvania vacant addresses, postal, postal service, social determinants of health, usps, vacant addresses, vacant property
Organization: Allegheny County
City of Pittsburgh Traffic Count

This traffic-count data is provided by the City of Pittsburgh's Department of Mobility & Infrastructure (DOMI). Counters were deployed as part of traffic studies, including intersection studies, and studies covering where or whether to install speed humps. In some cases, data may have been collected by the Southwestern Pennsylvania Commission (SPC) or BikePGH.

Data is currently available for only the most-recent count at each location. 

Traffic count data is important to the process for deciding where to install speed humps. According to DOMI, they may only be legally installed on streets where traffic counts fall below a minimum threshhold. Residents can [request an evaluation](https://apps.pittsburghpa.gov/redtail/images/6554_application.pdf) of their street as part of DOMI's [Neighborhood Traffic Calming Program](https://pittsburghpa.gov/domi/traffic-calming). The City has also shared [data on the impact of the Neighborhood Traffic Calming Program](https://pittsburghpa.gov/domi/traffic-calming-data) in reducing speeds. 

Different studies may collect different data. Speed hump studies capture counts and speeds.  SPC and BikePGH conduct  counts of cyclists. Intersection studies included in this dataset may not include traffic counts, but reports of individual studies may be requested from the City. Despite the lack of count data, intersection studies are included to facilitate data requests. 

Data captured by different types of counting devices are included in this data.  StatTrak counters are  in use by the City, and capture data on counts and speeds. More information about these devices may be found on the [company's website](https://www.alltrafficsolutions.com/stattrakvehiclecounterclassifier/).  Data includes traffic counts and average speeds, and may also include separate counts of bicycles.

Tubes are deployed by both SPC and BikePGH and used to count cyclists. SPC may also deploy video counters to collect data. 

**NOTE: The data in this dataset has not updated since 2021 because of a broken data feed. We're working to fix it.**

Tags: _etl, bike, car, city property, count, counter, cyclist, mobility, pittsburgh-open-data, speed limit, traffic, traffic count
Organization: City of Pittsburgh
GTFS Archive

## Overview

The General Transit Feed Specification (GTFS) is an Open Standard used to distribute relevant information about transit systems to riders. It allows public transit agencies to publish their transit data in a format that can be consumed by a wide variety of software applications.

This dataset contains historical static GTFS feeds for the Port Authority / Pittsburgh Regional Transit (PRT) system. As of March 2026, feeds are available for selected picks (schedule periods) from November 2007-November 2011, and for all schedule periods from November 2011 – present.

The current GTFS feed files are pulled daily from [https://www.rideprt.org/developerresources/](https://www.rideprt.org/developerresources/) and, when a new file is detected, it is added to the list below.

For detailed documentation on the GTFS standard, the feed formats archived in this dataset, and availability of feeds by time range and format, see the [PRT GTFS Tech Doc](https://data.wprdc.org/dataset/gtfs-archive/resource/b07e2fd6-95fa-4310-93b5-4b89fabc9c49). The [Feed Notes](https://data.wprdc.org/dataset/gtfs-archive/resource/fe35cfa1-70a0-49e6-836c-095a073f7748) spreadsheet file provides additional information about the GTFS feed .zip files and their formats.

Tags: _etl, gtfs
Organization: Pittsburgh Regional Transit
Allegheny County Election Results

Official, certified results of primary, general, and special elections held in Allegheny County. (Note that the most recent results may not yet be certified. Please check the link at https://www.alleghenycounty.us/Government/Elections/Election-Results to determine whether the results have been certified.)

Tags: EMBRACE, Structural Racism, elections, government, politics, voter, voting
Organization: Allegheny County
Allegheny County Farmers Market Nutrition Program

This dataset provides information about Allegheny County vendors accepting WIC who participate in the Pennsylvania Department of Agriculture's Farmers Market Nutrition Program (FMNP). These markets provide the public, including WIC recipients, with fresh, nutritious, locally grown fruits, vegetables, and herbs from approved farmers in Pennsylvania. 

Each row in the data includes details about location, days/hours of operation, and the length of the season. Additional directions and affiliations have also been provided when available.

Users may also be interested in the PA Department of Agriculture's new **PA FMNP Market Locator app,** a free mobile tool to help residents find markets closest to them across the entire state. The FMNP Market Locator app is available both in the Apple Store (https://apple.co/2KNJ4dk) and Google Play (http://bit.ly/2Z86Ytg).

___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: WIC, _etl, agriculture, farmers, food, health, social services, vegetables
Organization: Allegheny County
City-Owned Properties

# Overview
These data contain city-owned properties from the eProperties Plus database. The data describe basic aspects of the property (square footage, location, identification, etc.) and its geographically based assignment of various components of city infrastructure (police zone, council district, etc.). 

---
# Motivation
These data are useful for anyone (e.g., the URA) in identifying properties that are unused throughout the city.

---  
# Collection
These data are taken directly from the city's property management system (EProperty) database, one of several independent systems used by the City to track property-level data.

---
# Preprocessing

The latitude and longitude for these properties have to be geocoded from the parcel identifier (that is, the latitude and longitude are not contained in the source data). The various geographic zones (police zone, etc.) are then reverse geocoded from the derived coordinates. The parcel identifiers in the source data can follow several syntax conventions. The original city-formatted parcel identifier is in the `parc` field, and the normalized version (using a uniform 16-character format) is in the `pin` field. The `id` and `census_tract` fields are categorical/not intended for mathematical operations and are therefore converted to strings.

---
# Known Uses
The URA uses this data for vacant-property identification.

---
# Recommended Uses

Users can analyze the location of city-owned vacant properties and the property size/classification. These can be used to understand zonal conditions (e.g., neighborhood conditions), concentrations of vacant land spanning zones (across two police zones), etc. 

Care should be taken, however, when inferring socioeconomic attributes, city resource allocation, or other higher level variables of interest. There may be a link between vacant land and these factors, but the complexities of city operations and high-order variables can be influenced by lurking/hidden/latent variables. It could be advantageous to consider multivariate models and/or construction of component variables (e.g., using PCA or Factor Analysis).

The city is in the process of publishing other property-based datasets (all city-owned properties, treasury sale properties, condemned properties, and tax-delinquent properties). The city also publishes information on PLI code enforcement violations/permit applications which could be informative of property conditions in a given area. 

---
# Known Limitations/Biases

These data describe only city-owned properties (not privately held properties). The city is currently (2023) overhauling its property management databases. These data represent the best descriptions of city-owned vacant properties that are currently available. 

Tags: _etl, eproperty, pittsburgh, property, vacancy
Organization: City of Pittsburgh
Allegheny County Addressing Address Points

This dataset shows the Address Points in Allegheny County. The Address Points were created by GDR for the Allegheny County CAD project, October 2008. Data is updated by County staff as changes and corrections are found, on a continuous basis. Updates are sent to PASDA monthly.

The most authoritative source for this data is now the PASDA page (https://www.pasda.psu.edu/uci/DataSummary.aspx?dataset=1219), which includes links to historical versions of the shapefile representations of this data.

Tags: _etl, address, allegheny county, points
Organization: Allegheny County
Allegheny County Parcel Boundaries

This dataset contains boundaries of individual parcels in Allegheny County, including the county block and lot number. As this is a very large dataset, you may wish to use our property information extractor (http://tools.wprdc.org/parcels-n-at/) to download filtered versions of this parcel dataset.

The most authoritative source for this data is now the PASDA page (https://www.pasda.psu.edu/uci/DataSummary.aspx?dataset=1214), which includes links to historical versions of the shapefile representations of this data.

Tags: _etl, _gisds, boundaries, parcel, planning, property
Organization: Allegheny County
Allegheny County Finished Property Assessment Appeals

Lists property assessment appeals filed and heard with the Board of Property Assessment Appeals and Review (BPAAR) and the hearing results, for tax years 2015 to 2026. 

_Note: Assessment Appeals heard at the Board of Viewers are NOT included. See Data Notes and the Data Dictionary for further details._

Tags: appeal, appraisal, assessed value, assessments, building value, housing, property, property condition, property tax, real estate, valuation
Organization: Allegheny County
Air Temperature Inversions

This dataset contains the daily morning surface temperature inversion reports for the Pittsburgh, PA area. A temperature inversion occurs when the temperature increases with height as opposed to decreasing with height. Temperature inversions are common during the evening, nighttime, and morning hours. These inversions can sometimes result in poor air quality posing health risks especially for those who are immuno-compromised. To determine whether a surface temperature inversion is present, one must analyze a vertical profile of the atmosphere. The National Weather Service (NWS) office in Pittsburgh launches a weather balloon every morning to collect this data. The data are released publicly, and the data is then programmatically analyzed by the Air Quality division of the Allegheny County Health Department.

Sometimes, the weather balloon launch does not happen. Most of the time this occurs because the NWS in Pittsburgh has a helium shortage. If this occurs, then the measured fields (`temperature_c`, `depth_m`, and `strength`) are assigned null values, and the reason why is put in the `notes` field.

Tags: _etl, air quality, temperature inversions
Organization: Allegheny County
Allegheny County Schools (Public, Private, Charter, and Career and Technical Centers)

## Overview

These geocoded locations for Allegheny County schools (public, private, charter, and career and technical centers) are based on the Allegheny County extract of Public and Private school names, addresses and enrollment data via [Education Demographics and Geographic Estimates from the National Center for Education Statistics](https://nces.ed.gov/programs/edge/geographic/schoollocations) and [Enrollment Reports as of October 1 submitted to the Pennsylvania Department of Education](https://www.pa.gov/agencies/education/data-and-reporting/enrollment#accordion-cb5f3bee47-item-9b3fcf9ab9). The address data for public schools are based on data reported in the NCES Common Core of Data, which is an annual collection of enrollment, staffing and program participation for schools as reported to the Unites States Department of Education. 

**Department:** Allegheny County Department of Children Initiatives

**Data Notes:** Coordinate System: WGS 1984 Web Mercator (auxiliary sphere)

**Data Steward Name:** See [PA Enrollment | Department of Education](https://www.pa.gov/agencies/education/data-and-reporting/enrollment#accordion-cb5f3bee47-item-9b3fcf9ab9) and [NCES- EDGE School Geocodes and Geoassignments](https://nces.ed.gov/programs/edge/geographic/schoollocations) for more information.

**Data Steward Email:** Ra-DDQDataCollection@pa.gov and EDGE@ed.gov (Data Collection Team)

---

## Further Documentation and Resources

This data and documentation was pulled from [a dataset](https://openac-alcogis.opendata.arcgis.com/datasets/AlCoGIS::allegheny-county-schools-1/about) on the [Allegheny County GIS server](https://openac-alcogis.opendata.arcgis.com/).

An earlier version of this dataset (listing Allegheny County schools from 2018), may be found at [https://data.wprdc.org/dataset/allegheny-county-public-schools-local-education-agency-leas-locations](https://data.wprdc.org/dataset/allegheny-county-public-schools-local-education-agency-leas-locations).

Tags: _etl, schools
Organization: Allegheny County