Socrata

Close
Author
Jere Matthews
Description
This dataset contains aggregate COVID-19 case counts and rates by date of first report for all counties in Pennsylvania and for the state as a whole. Counts include both confirmed and probable cases as defined by the Council of State and Territorial Epidemiologists (CSTE). At present, a person is counted as a case only once. Note that case counts by date of report are influenced by a variety of factors, including but not limited to testing availability, test ordering patterns (such as day of week patterns), labs reporting backlogged test results, and mass screenings in nursing homes, workplaces, schools, etc. Case reports received without a patient address are assigned to the county of the ordering provider or facility based on provider zip code. Cases reported with a residential address that does not match to a known postal address per the commonwealth geocoding service are assigned to a county based on the zip code of residence. Many zip codes cross county boundaries so there is some degree of misclassification of county. All counts may change on a daily basis due to reassignment of jurisdiction, removal of duplicate case reports, correction of errors, and other daily data cleaning activities. Downloaded data represents the best information available as of the previous day. <br> Data will be updated between 9-11 am every day.
Category
Covid 19
Tags
covid, covid-19, health, case, doh, covid19, virus
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:

Jurisdiction
county
Date
date
New Cases
cases
7-day Average New Cases
cases_avg_new
Cumulative cases
cases_cume
Population (2019)
population
New Case Rate
cases_rate
7-Day Average New Case Rate
cases_avg_new_rate
Cumulative Case Rate
cases_cume_rate
County FIPS Code
county_fips_code
Longitude
longitude
Latitude
latitude
Georeferenced Lat & Long
georeferenced_lat__long
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.