pa-gov/covid19-aggregate-cases-current-daily-county-j72v-r42c

  • case
  • covid
  • covid-19
  • covid19
  • doh
  • + 2

COVID-19 Aggregate Cases Current Daily County Health

COVID-19 Aggregate Cases Current Daily County Health

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.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
LatitudelatitudelatitudeTextThis is a latitude generic point within the county to help create map visualizations.
LongitudelongitudelongitudeTextThis is a longitude generic point within the county to help create map visualizations.
New Case Ratecases_ratecases_rateNumberNumber of new confirmed and probable cases reported that date per 100,000 population
Population (2019)populationpopulationNumberMost current population data available
County FIPS Codecounty_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
Cumulative casescases_cumecases_cumeNumberCumulative confirmed and probable cases reported through that date
Municipality Boundary:@computed_region_amqz_jbr4:@computed_region_amqz_jbr4NumberThis column was automatically created in order to record in what polygon from the dataset 'Municipality Boundary' (amqz-jbr4) the point in column 'georeferenced_lat__long' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.
Pa Senatorial Districts (2020-01):@computed_region_d3gw_znnf:@computed_region_d3gw_znnfNumberThis column was automatically created in order to record in what polygon from the dataset 'Pa Senatorial Districts (2020-01)' (d3gw-znnf) the point in column 'georeferenced_lat__long' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.
Pennsylvania County Boundaries:@computed_region_nmsq_hqvv:@computed_region_nmsq_hqvvNumberThis column was automatically created in order to record in what polygon from the dataset 'Pennsylvania County Boundaries' (nmsq-hqvv) the point in column 'georeferenced_lat__long' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.
Pa School Districts (2019-06):@computed_region_rayf_jjgk:@computed_region_rayf_jjgkNumberThis column was automatically created in order to record in what polygon from the dataset 'Pa School Districts (2019-06)' (rayf-jjgk) the point in column 'georeferenced_lat__long' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.
7-Day Average New Case Ratecases_avg_new_ratecases_avg_new_rateNumberRolling 7-day average of new confirmed and probable cases per 100,000 population
DatedatedateCalendar dateDate
7-day Average New Casescases_avg_newcases_avg_newNumberRolling 7-day average of new confirmed and probable cases
Georeferenced Lat & Longgeoreferenced_lat__longgeoreferenced_lat__longPointGeoreferenced column for use in creating mapping visualizations with both a generic latitude and longitude of the county
JurisdictioncountycountyTextCounty of residence, or Pennsylvania
New CasescasescasesNumberNumber of new confirmed and probable cases first reported to the Department of Health on that date
Cumulative Case Ratecases_cume_ratecases_cume_rateNumberNumber of cumulative confirmed and probable cases reported through that date per 100,000 population
Pa House Districts (2020-01):@computed_region_r6rf_p9et:@computed_region_r6rf_p9etNumberThis column was automatically created in order to record in what polygon from the dataset 'Pa House Districts (2020-01)' (r6rf-p9et) the point in column 'georeferenced_lat__long' is located. This enables the creation of region maps (choropleths) in the visualization canvas and data lens.

Upstream Metadata