COVID-19 Aggregate Cases Current Daily County Health

data.pa.gov | Last Updated 4 Jan 2021

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.

Tags: covid, covid-19, health, case, doh, covid19, virus

This dataset has the following 13 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
JurisdictioncountytextCounty of residence, or Pennsylvania
Datedatecalendar_dateDate
New CasescasesnumberNumber of new confirmed and probable cases first reported to the Department of Health on that date
7-day Average New Casescases_avg_newnumberRolling 7-day average of new confirmed and probable cases
Cumulative casescases_cumenumberCumulative confirmed and probable cases reported through that date
Population (2019)populationnumberMost current population data available
New Case Ratecases_ratenumberNumber of new confirmed and probable cases reported that date per 100,000 population
7-Day Average New Case Ratecases_avg_new_ratenumberRolling 7-day average of new confirmed and probable cases per 100,000 population
Cumulative Case Ratecases_cume_ratenumberNumber of cumulative confirmed and probable cases reported through that date per 100,000 population
County FIPS Codecounty_fips_codetextThis 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/geo/reference/codes/cou.html
LongitudelongitudetextThis is a longitude generic point within the county to help create map visualizations.
LatitudelatitudetextThis is a latitude generic point within the county to help create map visualizations.
Georeferenced Lat & Longgeoreferenced_lat__longpointGeoreferenced column for use in creating mapping visualizations with both a generic latitude and longitude of the county