This dataset contains aggregate death data at the state and county level for Pennsylvania residents. The data are displayed by county, date, death counts, averages, rates based on population. Pennsylvania statewide numbers are listed with Pennsylvania named as the county for the statewide totals. Do not add up the entire file (all rows) or counts will be duplicated.
This dataset has the following 13 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| County Name | county | text | County or state name | Adams Allegheny Armstrong Beaver Bedford view top 100 |
| Date of Death | date | calendar_date | Date of death | 2020-03-18T00:00:00.000 2020-03-19T00:00:00.000 2020-03-20T00:00:00.000 2020-03-21T00:00:00.000 2020-03-22T00:00:00.000 view top 100 |
| New Deaths | deaths | number | New deaths | 0 1 2 3 4 view top 100 |
| 7-day Average New Deaths | deaths_avg_new | number | New deaths, 7-day average | 0 0.1 0.3 0.4 0.6 view top 100 |
| Total Deaths | deaths_cume | number | Total deaths | 0 1 2 3 6 view top 100 |
| 2019 Population | population | number | Population (2019) | 4447 6066 7247 14530 16526 view top 100 |
| New Deaths Rate | deaths_rate | number | New deaths per 100,000 | 0 0.48 0.71 0.18 0.32 view top 100 |
| 7-day Average New Death Rate | deaths_avg_new_rate | number | New deaths per 100,000, 7-day average | 0 0.35 0.17 0.05 0.22 view top 100 |
| Total Death Rate | deaths_cume_rate | number | Total deaths per 100,000 | 0 289.78 2.3 2.55 2.17 view top 100 |
| County FIPS Code | county_fips_code | text | his is the 5-digit Federal Information Processing Standard (FIPS) code that designate the State association. Each State has its own 2-digit number and each County within the state has its own 3-digit number which are combined into a 5-digit number to uniquely identify every US county. For more technical details : Federal Information Processing Standards Publications (FIPS PUBS) are issued by the National Institute of Standards and Technology (NIST) after approval by the Secretary of Commerce pursuant to Section 111 (d) of the Federal Property and Administrative Services Act of 1949 as amended by the Computer Security Act of 1987, Public Law 100-235. Federal Information Processing Standard (FIPS) 6-4, Counties and Equivalent Entities of the U.S., Its Possessions, and Associated Areas -- 90 Aug 31 , provides the names and codes that represent the counties and other entities treated as equivalent legal and/or statistical subdivisions of the 50 States, the District of Columbia, and the possessions and freely associated areas of the United States. Counties are considered to be the "first-order subdivisions" of each State and statistically equivalent entity, regardless of their local designations (county, parish, borough, etc.). Information gathered from census data - https://www.census.gov/library/reference/code-lists/ansi.html | 42000 42001 42003 42005 42007 view top 100 |
| Longitude | longitude | text | This is a longitude generic point within the county to help create map visualizations. | -79.91711779 -77.25788076 -77.06415803 -75.60099481 -80.22943817 view top 100 |
| Latitude | latitude | text | This is a latitude generic point within the county to help create map visualizations. | 39.346129 39.85480393 39.87209565 39.91657867 39.9194478 view top 100 |
| Georeferenced Latitude & Longitude | georeferenced_latitude__longitude | point | Georeferenced column for use in creating mapping visualizations with both a generic latitude and longitude of the county | {"coordinates":[-75.60099481,40.61464794],"type":"Point"} {"coordinates":[-79.03100206,39.97146299],"type":"Point"} {"coordinates":[-76.71188423,40.85150926],"type":"Point"} {"coordinates":[-78.34907687,40.48555024],"type":"Point"} {"coordinates":[-75.11291241,40.33501133],"type":"Point"} view top 100 |