AndreaBozzo/ceres-open-data-index huggingface dataset:
Allegheny County Employee Salaries

This dataset includes annual salary, regular pay, incentive pay, and gross pay for employees under the County Executive and independently elected County officials for the years 2016 to the present, and is updated quarterly.

For December files, Annual Salary is the employee's annual salary or annualized wage as of the last pay period for the year, and the pay data fields (Regular Pay, Incentive Pay and Gross Pay) are payments made to the employee through the last pay period of the year. The June file contains the Annual Salary, and the pay data as of the last pay period in June. *Note that the June file is replaced by the December file each year.*

Union contracted salaries and wages which were not settled during the calendar year reflect the wage as of the end of the year. Regular Pay for these positions includes salaries and wages for the year it was paid, not the year it was earned. 

In addition to salary or wages for days worked and retroactively settled contract payments, Regular Pay also includes pay for days such as holidays, sick days, and vacation days. Overtime Pay includes pay for extra work typically at a wage rate different from regular wages as set forth in a collective bargaining agreement. Incentive Pay includes such things as a wellness incentive and longevity pay.

Employee names are included in the dataset with the following exceptions permitted by the Pennsylvania Right to Know Law:

* The names of individuals who were active sworn law enforcement officers during the year; and
* Information that would disclose individually identifiable health information.

Additionally, records related to Court of Common Pleas employees would need to be requested from the [Courts](https://www.alleghenycourts.us/).

*In March 2022, the salary data files prior to 2021 were updated so that all columns matched for consistent presentation.*

Tags: local government
Organization: Allegheny County
Allegheny County Census Tracts 2020

This is an Allegheny County extract of the 2020 US Census Tracts downloaded from the following website: https://www.census.gov/geographies/mapping-files/time-series/geo/tiger-geodatabase-file.html

**Department:**  Geographic Information Systems Group; Department of Information Technology

Tags: _etl, census, census tracts
Organization: Allegheny County
Landslides Pomeroy Study

This dataset is harvested on a weekly basis from [Allegheny County's GIS data portal](https://openac.alcogis.opendata.arcgis.com/).

For more information about landslides in Allegheny County, visit the [Allegheny County Landslide Portal](https://landslide-portal-alcogis.opendata.arcgis.com/).

Tags: _etl, landslide
Organization: Allegheny County
Allegheny County Land Use Areas

Allegheny County land use as ascribed to areas of land. The Land Use
Feature Dataset contains photogrammetrically compiled information concerning
vegetation and limited open areas of ground. The Land Use Feature Dataset
contains Woodlands, Nurseries and Orchards, Cultivated Fields and Athletic
Fields. Woodlands are groups of trees, whether coniferous or deciduous.
Woodland areas that are one (1) acre or greater in size are digitized from the
aerial photography. Nurseries and Orchards are areas that indicate cultivated
trees. These areas are usually identified because the trees are found in evenly
spaced rows. Nursery and Orchard areas that are one (1) acre or greater in size
are digitized from the aerial photography. Cultivated Fields are those areas
that are used for crops. Pasture land and land that, according to the aerial
photographs and aerial interpretation, has been permitted to lie fallow for an
extended period is not considered cultivated areas. Cultivated Field areas that
are one (1) acre or greater in size are digitized from the aerial photography.
Athletic Fields are sport fields that have a natural surface. The apparent
outline of the land area used for athletic purposes is digitized from the
aerial photography and not just the actual athletic field.



Tags: _etl, _gisds, boundaries, field, nursery, orchard, planning, property, woodland
Organization: Allegheny County
Allegheny County Addressing Landmarks

This dataset shows the address points in Allegheny County.

## Usage
The value in the `ADDRESS_ID` field lets you look up more information about the landmark locations in the Addressing Address Points dataset (https://data.wprdc.org/dataset/allegheny-county-addressing-address-points2), including the geocoordinates (though they are in the State Plane coordinate system, in that table's `point_x` and `point_y` fields).

## Limitations
Since the CSV file currently does not provide geocoordinates, we can't generate a GeoJSON file from it; until we do, the GeoJSON link will remain as a broken placeholder.

Tags: _etl, address, allegheny county, landmarks, poi, points, points of interest
Organization: Allegheny County
Snow Plow Activity (2018-2020)

Snow Plow GPS readings during declared City of Pittsburgh Snow Events. Includes readings on plow (up or down) and salt spreader speed.

Please note: The system tracking snow plows was not fully deployed for the 2018-2019 or 2019-2020 seasons. Therefore readings from these events may not include all the vehicles or entirely accurate plow position or spreader speeds.

Tags: environment, events, plowing, plows, salt, snow, snowfall, spreaders, spreading
Organization: City of Pittsburgh
Municipal Building Energy Usage

This data set contains energy use data from 2009-2014 for 139 municipally operated buildings. Metrics include: Site & Source EUI, annual electricity, natural gas and district steam consumption, greenhouse gas emissions and energy cost. Weather-normalized data enable building performance comparisons over time, despite unusual weather events.

Tags: EUI, address, building, building energy use, conservation, district steam, electricity, energy, energy cost, energy cost intensity, energy use intensity, government, greenhouse gas emissions, gross floor area, natural gas, sustainability, usage, weather-normalized
Organization: City of Pittsburgh
Healthy Ride Trip Data (archived)

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: archived, bike, bike share, rental, trip
Organization: Healthy Ride
Snow Plow Activity (2015-2016)

Snow Plow data from the the City of Pittsburgh's [Snow Plow Tracker](http://pittsburghpa.gov/snow/snow-plow-tracker).

These data are collected from the Snow Plow Tracker's Fusion Table and converted to geoJSON. Each file is named using the timestamp representation of the date and time the corresponding 'Snow Event' started.

Tags: 2015, 2016, plow, plowing, road, snow, snowfall, street, tracker, winter
Organization: City of Pittsburgh
Parking Meters Pittsburgh Parking Authority

This parking-meters dataset used to mirror the dataset located at 
https://pghgishub-pittsburghpa.opendata.arcgis.com/datasets/e9f766897c9148a4951696f27f13820a_0/explore
but has been updated to mirror a more current dataset located at 
https://pghgishub-pittsburghpa.opendata.arcgis.com/datasets/cca443f3ffdb4856bcb0167e1e204fff_0/explore

Tags: _etl, parking meters, pittsburgh, transportation
Organization: City of Pittsburgh
Allegheny County Weights and Measures Inspections

Inspections conducted by the Allegheny County Bureau of Weights and Measures. The Bureau inspects weighing and timing devices such as gas pumps, laundromat timers, parking meters, and produce scales. The Bureau also conducts price scan verifications on a regular basis to ensure consumers are being charged fairly. 

Tags: _etl, food, gas, gas station, government, grocery, laundromat, meters, parking, pump, retail, scale, store, supermarket, weights and measures
Organization: Allegheny County
Pittsburgh CDBG Block Groups

This dataset now hosts multiple versions of the Pittsburgh Community Development Block Grant (CDBG) Census Block Group areas, obtained from the [Pittsburgh GIS portal](https://pghgishub-pittsburghpa.opendata.arcgis.com/): one from 2014 and one from 2018.

The WPRDC also hosts a dataset containing [CDBG Census Block Group tracts](https://data.wprdc.org/dataset/pittsburgh-2014-cdbg-census-tracts).

Tags: _etl, cdbg, census block groups, demographics, pittsburgh
Organization: City of Pittsburgh
Pittsburgh CDBG Census Tracts

This dataset now hosts multiple versions of the Pittsburgh Community Development Block Grant (CDBG) Census Tract areas, obtained from the [Pittsburgh GIS portal](https://pghgishub-pittsburghpa.opendata.arcgis.com/): one from 2014 and one from 2018.

The WPRDC also hosts a dataset containing [CDBG Census Block Group areas](https://data.wprdc.org/dataset/pittsburgh-2014-cdbg-block-groups).


Tags: _etl, cdbg, census tracts, demographics, pittsburgh
Organization: City of Pittsburgh
Division of Tenement House Inspection Annual Reports 1907/1913

This data was prepared by Rosalie Garfinkle as a course project for LIS 2970 Open Government Data in the Master of Library Program at the University of Pittsburgh.

These six historical datasets are transcribed from the annual reports done by the Division of Tenement House Inspection for the Bureau/Department of Public Health of the City of Pittsburgh. The goal of this Division was to canvas working-class housing and improve the living conditions of these tenement houses. Reports were published each year from 1907 to 1913 (with 1907 only showing data for ten months of the year, March-December). In 1914, the Division of Tenement House Inspection and the Division of Sanitary Inspection were combined and began to work together. For a more in-depth history of the Bureau/Department of Public Health and the reports from the Division of Tenement House Inspection, see the readme file included here. 
 
The six datasets included here are data on the violations corrected in tenements houses from 1907-1913; a summary of inspections conducted from 1907-1913; a record of tenement houses in the city in 1912, the number of apartments in houses in 1912; height of tenement houses by story for the front and rear of the building in 1912.

For all 1912 datasets, please refer to this map linked below for context regarding the wards listed in the data. 
 
This data was published by the Department of Public Health and obtained through the University of Pittsburgh’s Archives & Special Collections. 

A guide to data from the City's health department can be found here: https://digital.library.pitt.edu/islandora/object/pitt:US-PPiU-ais197428/from_search/3debdacfbde1f422c76e36d68ea54a7f-3

___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: archives, community profiles, historic pittsburgh, history, housing, housing units, violations
Organization: University of Pittsburgh
City of Pittsburgh Intersection Markings

Intersection markings including crosswalk and stop line locations and information.

**NOTE: The data in this dataset has not updated since 2021 (or 2018, in the case of the crosswalks data) because of a broken data feed. We're working to fix it.**

Tags: _etl, crossings, crosswalks, intersection, markings, pedestrians, transportation, travel
Organization: City of Pittsburgh
Allegheny County Anxiety Medication

These Census Tract-level datasets described here provide de-identified diagnosis data for customers of three managed care organizations in Allegheny County (Gateway Health Plan, Highmark Health, and UPMC) that have filed a claim for anxiety medications in 2015 and 2016. The data also includes the number of enrolled members in the three participating managed care organizations in 2015 and 2016.

Disclaimer: Users should be cautious of using administrative claims data as a measure of disease prevalence and interpreting trends over time, as data provided were collected for purposes other than surveillance.  Limitations of these data include but are not limited to: misclassification, duplicate individuals, exclusion of individuals who did not seek care in past two years and those who are: uninsured, enrolled in plans not represented in the dataset, or were not enrolled in one of the represented plans for at least 90 days.

___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, ACHD DASH, DASH, Health, anxiety, anxiety medication, depression, social determinants of health
Organization: Allegheny County
Grow Pittsburgh Food Gardens

Food growing locations registered with Grow Pittsburgh. Data includes community gardens, community farms, schoolyard gardens, or urban farms. This data is included in Grow Pittsburgh's Grower's Map

___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: civic vitality, environment, farms, food, gardens, health, healthy food, land use, properties, property, school gardens, sustainability, vacant land
Organization: Grow Pittsburgh
City Traffic Signs

City of Pittsburgh Traffic signs such as; Stop, Stop Ahead, and Yield Signs, and Wayfinder signs.

This is an on-going inventory of Signs, as the Department of Public Works is able to update its inventory new sign types will be added.

**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, signs, stop, traffic, transit, yield
Organization: City of Pittsburgh
Autonomous Vehicle Survey of Bicyclists and Pedestrians in Pittsburgh

In Pittsburgh, Autonomous Vehicle (AV) companies have been testing autonomous vehicles since September 2016. However, the tech is new, and there have been some high-profile behavior that we believe warrants a larger conversation. So in early 2017, we set out to design a survey to see both how BikePGH donor-members, and Pittsburgh residents at large, feel about about sharing the road with AVs as a bicyclist and/or as a pedestrian. Our survey asked participants how they feel about being a fellow road user with AVs, either walking or biking. We also wanted to collect stories about people’s experiences interacting with this nascent technology. We are unaware of any public surveys about people’s feelings or understanding of this new technology.
We hope that our results will help add to the body of data and help the public and politicians understand the complexity of possible futures that different economic models AV technology can bring to our cities and towncenters.

We conducted our 2017 survey in two parts. First, we launched the survey exclusively to donor-members, yielding 321 responses (out of 2,900) via email. Once we closed the survey, we launched it again, but allowed the general public to take it. Through promoting it on our website, social media channels, and a few news articles, we yielded 798 responses (mostly from people in the Pittsburgh region), for a combined total of 1,119 responses.

Regarding the 2019 survey: In total, 795 people responded. BikePGH solicited responses from their blog, website, and email list. There were also a few local news articles about the survey. While many questions were kept similar to the 2017 survey, BikePGH wanted to dig a bit deeper into regulations as well as demographics this time around.

The 2019 follow up survey also aims to see how the landscape has changed, and how specifically, Pittsburghers on bike and on foot feel about sharing the road with AVs so that we’re all better prepared to deal with this new reality and help make sure that it is introduced as safely as humanly possible.

Tags: accident, argo, auto, automobile, autonomous vehicle, av, avs, bicycle, bicyclists, bike, bike lane, bikepgh, car, crash, crosswalk, ford, pedestrian, pittsburgh, public safety, robot, robots, safety, self driving car, self-driving car, share the road, sidewalk, streets, survey, taxi, tech, technology, transportation, uber, waymo
Organization: BikePGH
A Community Profile of Pittsburgh Neighborhoods, 1974

These data include four historical datasets that were transcribed from the Community Profiles of Pittsburgh reports, which were published in 1974. The Community Profiles were prepared for 71 Pittsburgh neighborhoods by the City of Pittsburgh's Department of City Planning and include demographic information, housing, socio-economic conditions, and community facilities. 

The four datasets included here are data on building permits issued in 1972, arrests for major crimes in 1972, public assistance given in 1972, and community facilities serving and located in Pittsburgh neighborhoods. 

Tags: archives, arrests, building permits, community facilities, crimes, historic pittsburgh, history, neighborhood indicators, parks, public assistance, recreation
Organization: University of Pittsburgh
Allegheny County Food Facilities

A link to a search engine for kitchens, restaurants, and other food facilities from the Allegheny County Health Department.

Also see https://data.wprdc.org/dataset/allegheny-county-restaurant-food-facility-inspection-violations/resource/112a3821-334d-4f3f-ab40-4de1220b1a0a for a listing of Allegheny County Food Facilities with some extra fields.

___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: bakery, eatery, food, kitchen, restaurant
Organization: Allegheny County
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.

___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: cause of death, deaths, health, mortality
Organization: Allegheny County
Allegheny County Particulate Matter 2.5

The U.S. Environmental Protection Agency provides information on the particulate matter concentration for Allegheny County that have a diameter greater or equal to 2.5 mm. The data is based on a combination of 2012 model and monitor data reported by the U.S. Environmental Protection Agency’s Office of Air and Radiation. The data represents the mean PM 2.5 measurement in micrograms per cubic meter for each census tract in Allegheny County. This data was obtained from the U.S. Department of Environmental Protection’s Environmental Justice Screen tool.

___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, PM 2.5, Particulate Matter, air, air pollution, air quality, social determinants of health
Organization: Allegheny County
Allegheny County Poor Housing Conditions

This estimate of the percent of distressed housing units in each Census Tract was prepared using data from the American Community Survey and the Allegheny County Property Assessment database. The estimate was produced by the Reinvestment Fund in their work with the Allegheny County Department of Economic Development.

___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, Parcel information, housing, parcel, property condition, real estate, social determinants of health
Organization: Allegheny County
COVID-19 Resources

As the situation is changing quickly, we're just listing here some links to local and statewide information pertaining to the COVID-19 epidemic.

___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: covid-19, covid19, food, pandemic
Organization: Western Pennsylvania Regional Data Center
Allegheny County Older Housing

Older housing can impact the quality of the occupant's health in a number of ways, including lead exposure, housing quality, and factors that may exacerbate respiratory conditions, like asthma. Data from the U.S. Census Bureau contains Census Tract estimates of housing age, and Allegheny County assessment data provides parcel-level information on the year residential properties were built.

___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, housing, housing age, social determinants of health
Organization: Allegheny County
Allegheny County Illegal Dump Sites

The Illegal Dump Site dataset includes information on illegal dump sites, their type of trash, and the estimate tons of trash at each site. The information was provided by Allegheny Cleanways, and collected as part of a 2005 survey in Allegheny County.

___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, Illegal Dump Site, social determinants of health
Organization: Allegheny County