Tyler Data & Insights

COVID-19 Aggregate Cases NO FURTHER UPDATESWeekly updates have finished with the June 28th update. Some information may be found here: https://covid.cdc.gov/covid-data-tracker/#maps_new-admissions-rate-state <br> 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 11:30 am to 1:30pm each Wednesday.Visit the full page to view this data.

This view cannot be displayed

Embed this Dataset

      <div><iframe width="_width_px" title="COVID-19 Aggregate Cases NO FURTHER UPDATES" height="_height_px" src="https://data.pa.gov/w/j72v-r42c/33ch-zxdi?cur=4rIpzQlItZq&from=6n3dmIDXJxt" frameborder="0"scrolling="no"><a href="https://data.pa.gov/Covid-19/COVID-19-Aggregate-Cases-NO-FURTHER-UPDATES/j72v-r42c" title="COVID-19 Aggregate Cases NO FURTHER UPDATES" target="_blank">COVID-19 Aggregate Cases NO FURTHER UPDATES</a></iframe></div>

Size

500x425
760x646
950x808

Custom Size

425x425 is the minimum size

Width

Height

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.

Tyler Data & Insights

API Endpoint:

Field Names:

OData V4 Endpoint:

OData V2 Endpoint:

Want to leave a comment?

You are leaving data.pa.gov.

Notice