Tyler Data & Insights

Close
Author
Jere Matthews
Description
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.
Category
Covid 19
Tags
covid, health, doh, death
Rating
Current value: 0 out of 5
Data Provided By
Department of Health
Source Link
https://www.health.pa.gov/topics/disease/coronavirus/Pages/Cases.aspx
License
Public Domain U.S. Government
This view cannot be displayed
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size
  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

County Name
county
Date of Death
date
New Deaths
deaths
7-day Average New Deaths
deaths_avg_new
Total Deaths
deaths_cume
2019 Population
population
New Deaths Rate
deaths_rate
7-day Average New Death Rate
deaths_avg_new_rate
Total Death Rate
deaths_cume_rate
County FIPS Code
county_fips_code
Longitude
longitude
Latitude
latitude
Georeferenced Latitude & Longitude
georeferenced_latitude__longitude
Pennsylvania County Boundaries
:@computed_region_nmsq_hqvv
Pa Senatorial Districts (2020-01)
:@computed_region_d3gw_znnf
Municipality Boundary
:@computed_region_amqz_jbr4
Pa House Districts (2020-01)
:@computed_region_r6rf_p9et
Pa School Districts (2019-06)
:@computed_region_rayf_jjgk

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.