states_info
Data source: Big Local News · About: big-local-datasette
14 rows where totalTestResultsField = "Total Test Encounters (PCR)"
This data as json, copyable, CSV (advanced)
Suggested facets: pui
| Link | rowid ▼ | state | notes | covid19Site | covid19SiteSecondary | covid19SiteTertiary | covid19SiteQuaternary | covid19SiteQuinary | covid19SiteOld | covidTrackingProjectPreferredTotalTestUnits | covidTrackingProjectPreferredTotalTestField | totalTestResultsField | pui | pum | name | fips | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7 | 7 | CO | The **Recovered** data point we report for Colorado reflects the number of COVID-19 patients discharged from the hospital and therefore does not represent the total number of people who have recovered from COVID-19, since many people with COVID are never hospitalized.Negative test results reported in our API and CSVs are calculated by subtracting **Confirmed cases** from **Total PCR tests (specimens)** in the absence of better data.On February 10, 2021, Colorado noted that a temporary technical issue occurring on February 9, 2021, caused their dashboard to show incomplete case counts, while testing and percent positivity data did not update. As a result, we were unable to update testing data on February 10, 2021. A full update for all affected metrics is anticipated on February 11, 2021.On January 26, 2021, Colorado [reported](https://covid19.colorado.gov/press-release/cdphe-adding-past-dated-cases-into-electronic-laboratory-reporting-system) that it would be adding over 3,000 past-dated cases from last year, particularly November and December 2020, reported by email and fax to its cumulative figures. This will cause larger than normal case counts over the next few days. We urge caution when using data from this period.As of December 11, 2020, we are switching our deaths source for Colorado from deaths due to COVID to deaths among cases because of a processing lag. On September 1, 2020, there was only a 97 difference between the two figures: 1946 deaths among cases, vs. 1849 deaths due to COVID. On December 11, 2020, there is now a 759 difference—3759 deaths among cases, as opposed to 3005 deaths due to COVID. This means 20% of deaths among cases do not have death certificate data, vs. 5% in September, indicating a lag. Previously, on July 1, 2020, we had revised our historical data to reflect the death-certificate metric instead of the deaths-among-cases metric to comply with federal standards from the National Center for Health Statistics. We are also capturing a confirmed/probable breakdown from May 15, 2020 o… | https://public.tableau.com/views/Colorado_COVID19_Data/CO_Hospital?%3Aembed=y&%3AshowVizHome=no | https://public.tableau.com/views/Colorado_COVID19_Data/CO_Case_Summary?%3Aembed=y&%3AshowVizHome=no | https://services3.arcgis.com/66aUo8zsujfVXRIT/arcgis/rest/services/colorado_covid19_laboratory_positivity_data/FeatureServer/0/query?where=Metric%3D%27Number+of+positive+tests%27+AND+Desc_+LIKE+%27Daily+COVID-19+Antibody%25%27&outStatistics=%5B%7B%27statisticType%27%3A+%27max%27%2C+%27onStatisticField%27%3A+%27Attr_Date%27%7D%2C+%7B%27statisticType%27%3A+%27sum%27%2C+%27onStatisticField%27%3A+%27Value%27%2C+%27outStatisticFieldName%27%3A+%27antibody_pos%27%7D%5D | https://services3.arcgis.com/66aUo8zsujfVXRIT/arcgis/rest/services/colorado_covid19_laboratory_positivity_data/FeatureServer/0/query?where=Metric%3D%27Number+of+negative+tests%27+AND+Desc_+LIKE+%27Daily+COVID-19+Antibody%25%27&outStatistics=%5B%7B%27statisticType%27%3A+%27max%27%2C+%27onStatisticField%27%3A+%27Attr_Date%27%7D%2C+%7B%27statisticType%27%3A+%27sum%27%2C+%27onStatisticField%27%3A+%27Value%27%2C+%27outStatisticFieldName%27%3A+%27antibody_neg%27%7D%5D | https://covid19.colorado.gov/data | @cdphe | https://www.colorado.gov/pacific/cdphe/2019-novel-coronavirus | Encounters | totalTestEncountersViral | Total Test Encounters (PCR) | Positives + Negatives | false | Colorado | 8 |
| 9 | 9 | DC | On February 16, 2021, the District of Columbia announced that their testing data for the day would be delayed. As a result, we were unable to update their Total PCR tests (test encounters) or Total PCR tests (people).On February 14, 2021, the District of Columbia’s Total PCR Tests (people), dropped by 1,987 from 426,830 to 424,843 without explanation.On February 13, 2021, the District of Columbia's Total PCR tests (people) decreased by 751 without explanation. On December 25, 2020, the District of Columbia announced on their [COVID-19 page](https://coronavirus.dc.gov/data) that there would be no update to their data on December 25, 2020 due to the Christmas holiday. Additionally, they noted that the data reported on December 26, 2020 will include numbers from December 24, 2020 and the data reported on December 27, 2020 will include numbers from December 25, 2020 and December 26, 2020.As of September 18, 2020, District of Columbia's total test results are drawn from our total`TestEncountersViral` field instead of calculated via positive+negative.As of August 29, 2020, we store the “total overall tested” timeseries in our **Total Test Encounters (PCR)** field despite the following: According to our outreach, the District of Columbia’s “total overall tested” figure on its dashboard represents test encounters, the number of unique individuals tested per day, with one exception, if an individual receives a positive and a negative test on the same day, they are counted twice rather than once. On May 25, 2020, the District of Columbia decreased the district's **total tests** number by 11,000 to reflect only DC residents.On February 12, 2021, the District of Columbia announced that their testing data for the day would be delayed. As a result, we were unable to update their Total PCR tests (test encounters) or Total PCR tests (people). | https://coronavirus.dc.gov/page/coronavirus-surveillance-data | https://coronavirus.dc.gov/page/hospital-status-data | https://microstrategy.dc.gov/MicroStrategyLibrary/app/E52A533B11EA01A28FE80080EFC53DA4/30FE682111EA6FB5A6620080EF357B1F/WEF49494DFBDE44548AFB2A631C5233CC--K46 | @_DCHealth | https://coronavirus.dc.gov/ | Encounters | totalTestEncountersViral | Total Test Encounters (PCR) | All data | false | District of Columbia | 11 | ||
| 10 | 10 | DE | On February 5, 2021, Delaware [announced]() via the official Delaware Department of Health and Social Services twitter that 54 of the deaths reported on February 5, 2021 were identified as the result of a data quality review. As a result, the majority of new deaths reported on February 5, 2021 were not identified in the previous 24 hour period. On February 7, 2021, Delaware noted that due to a technical issue it was reporting 260 cases reported to DPH on February 5 as well as the new cases reported on February 6.On December 18, 2020, Delaware announced that due to laboratory reporting delays, the number of cases reported for December 17, 2020 is lower than previous days, and the number of cases reported for December 18, 2020 would be higher than previous days to make up for it. Because Delaware reports their data as of the previous day, this affects our data for December 18, 2020 and December 19, 2020.Throughout the week of December 17, 2020, Delaware experienced technical issues with lab reporting. Please exercise caution when looking at their data from this period and be aware that 7 day averages are a more reliable metric than individual figures.On December 7, 2020, Delaware announced that they would no longer be reporting **Recovered** as it was “no longer a true reflection of the number of persons that recovered from the disease” because this metric included only cases who had self-reported their recovery to the Division of Public Health. Due to this we cannot continue reporting **Recovered**, however the time series for this metric is available in the historical data, and our data downloads. On October 29, 2020, we moved the data in our **Total Tests (PCR)** field for Delaware to the **Total Test Encounters (PCR)** field after learning that it represents encounters from Delaware's state health department. However, Delaware appears to include antigen tests in its totals, so if an individual is tested using two different test types on the same day, it will get counted twice. Also as of October 29, 2020, Delaw… | https://myhealthycommunity.dhss.delaware.gov/locations/state#testing | https://myhealthycommunity.dhss.delaware.gov/locations/state#testing | @Delaware_DHSS | https://dhss.delaware.gov/dhss/dph/epi/2019novelcoronavirus.html | Encounters | totalTestEncountersViral | Total Test Encounters (PCR) | All data | false | Delaware | 10 | |||
| 11 | 11 | FL | Florida combines PCR and antigen tests in the total tests figure reported on the state's dashboard (first noted July 2, 2020). We include data for Florida non-residents in our deaths and hospitalizations figures but not in cases and tests. For some metrics, we use machine queries against the Florida Department of Health's raw data, which may not be displayed on its [dashboard](https://experience.arcgis.com/experience/96dd742462124fa0b38ddedb9b25e429/).[Per reporting](https://www.miamiherald.com/news/coronavirus/article241882491.html), the number of **pending tests** (available in our API and CSVs) may include only results from public labs, and may therefore be an undercount.On January 1, 2020, Florida [announced](https://twitter.com/healthyfla/status/1345054200800157699?s=21) that they would not be updating their data on January 1, 2021 due to the New Year holiday. We were able to update **Now hospitalized** from Florida's separate [hospitalization source](https://bi.ahca.myflorida.com/t/ABICC/views/Public/COVIDHospitalizationsCounty?:isGuestRedirectFromVizportal=y&:embed=y). On December 25, 2020, Florida [announced](https://twitter.com/healthyfla/status/1342511673261711360?s=21) via the official Florida Department of Health twitter that they would not be updating their data on December 25, 2020 due to the Christmas holiday. We were able to update **Now hospitalized** from Florida's separate [hospitalization source](https://bi.ahca.myflorida.com/t/ABICC/views/Public/COVIDHospitalizationsCounty?:isGuestRedirectFromVizportal=y&:embed=y). On December 10, 2020, we cleared **Deaths (confirmed)** from August 12 onward and are reporting them as **Deaths (confirmed and probable)**. On August 11, Florida added antigen tests to its data definition for deaths, which were previously PCR only.On November 26, 2020, Florida did not update their data, presumably due to the Thanksgiving holiday.On November 3, 2020, Florida’s **Positive PCR Tests (specimens)** dropped by over 200 with no explanation.On October 30, 2020, the numbe… | https://experience.arcgis.com/experience/96dd742462124fa0b38ddedb9b25e429/ | http://ww11.doh.state.fl.us/comm/_partners/covid19_report_archive/total-antibody-results/serology-reports/serology_latest.pdf | https://bi.ahca.myflorida.com/t/ABICC/views/Public/COVIDHospitalizationsCounty?%3AshowAppBanner=false&%3Adisplay_count=n&%3AshowVizHome=n&%3Aorigin=viz_share_link&%3AisGuestRedirectFromVizportal=y&%3Aembed=y | http://ww11.doh.state.fl.us/comm/_partners/covid19_report_archive/cases-monitoring-and-pui-information/state-report/state_reports_latest.pdf | https://services1.arcgis.com/CY1LXxl9zlJeBuRZ/ArcGIS/rest/services/Florida_COVID19_Cases/FeatureServer/0/query?where=countyname%3D%27a+state%27&objectIds=&time=&geometry=&geometryType=esriGeometryEnvelope&inSR=&spatialRel=esriSpatialRelIntersects&resultType=none&distance=0.0&units=esriSRUnit_Meter&returnGeodetic=false&outFields=*&returnGeometry=true&returnCentroid=false&featureEncoding=esriDefault&multipatchOption=xyFootprint&maxAllowableOffset=&geometryPrecision=&outSR=&datumTransformation=&applyVCSProjection=false&returnIdsOnly=false&returnUniqueIdsOnly=false&returnCountOnly=false&returnExtentOnly=false&returnQueryGeometry=false&returnDistinctValues=false&cacheHint=false&orderByFields=&groupByFieldsForStatistics=&outStatistics=&having=&resultOffset=&resultRecordCount=&returnZ=false&returnM=false&returnExceededLimitFeatures=true&quantizationParameters=&sqlFormat=none&f=html&token= | @HealthyFla | http://www.floridahealth.gov/diseases-and-conditions/COVID-19/ | Encounters | totalTestEncountersViral | Total Test Encounters (PCR) | All data | false | Florida | 12 |
| 14 | 14 | HI | Hawaii’s data is on a 1 day lag in our timeseries due to consistently updating after 7:30 pm Eastern Time, when we publish our daily update.On February 2, 2021, Hawaii's **Total PCR Tests (Test Encounters)** decreased by more than 15,000 and **Positive PCR Tests (specimens)** decreased by more than 150 without explanation. On January 26, 2021, Hawaii reported 60 Deaths (confirmed + probable), the many of which may be due to a [death record review](https://www.hawaiinewsnow.com/2021/01/25/state-finds-additional-covid-deaths-hawaii-following-records-review/). As a result, not all new deaths reported on January 26, 2021 may have been reported in the previous 24 hour period.On December 25, 2020, Hawaii’s **Total PCR tests (test encounters)** decreased by 6184 without explanation.On November 10, 2020, we switched the source for Hawaii’s **Currently Hospitalized** to the Hawaii Emergency Management Agency’s COVID-19 dashboard. As a result, current hospitalizations decreased by 14. On November 6, 2020, Hawaii removed the Recovered metric from their dashboards. Due to this we cannot continue reporting **Recovered**, but the time series for this metric is available in the historical data and in our data downloads. As of October 9, 2020, Hawaii’s total test results are drawn from our `totalTestEncountersViral` field instead of calculated via positive+negative. On October 7, 2020, Hawaii stopped reporting **Total PCR tests (people)** and **Total PCR tests (specimens)** and began reporting **Total PCR tests (test encounters)**. Due to this we cannot continue reporting **Total tests PCR (people)**, **Total PCR tests (specimens)** and `negative`, which was calculated by subtracting **Confirmed cases** from **Total PCR tests (people)**, however the time series for the metrics are available in the historical data, and our data downloads. On September 3, 2020, Hawaii included cases which had been previously diagnosed in their daily update due to an electronic laboratory reporting error." As a result, new cases reported may not h… | https://health.hawaii.gov/coronavirusdisease2019/ | https://health.hawaii.gov/coronavirusdisease2019/what-you-should-know/current-situation-in-hawaii/ | https://hiema.maps.arcgis.com/apps/opsdashboard/index.html#/9a19e1adeceb46c58185cb0396faf36b | https://hiema.maps.arcgis.com/apps/opsdashboard/index.html#/9a19e1adeceb46c58185cb0396faf36b | https://hawaiicovid19.com/dashboard/ | @HIgov_Health | https://health.hawaii.gov/docd/advisories/novel-coronavirus-2019/ | Encounters | totalTestEncountersViral | Total Test Encounters (PCR) | Only positives | false | Hawaii | 15 |
| 26 | 26 | MN | Negative test results reported in our API and CSVs are calculated by subtracting **Confirmed cases** from **Total PCR tests (people)**.On January 28, 2021, Minnesota reported a delay in hospital data for January 27th, 2021. Reporting for both dates will be available tomorrow.On January 11, 2021, Minnesota reported that their cases were lower than they otherwise would be by 598 due to data deduplication and that 9193 test results from January 10, 2021 will be reported on January 12, 2021 instead of January 11, 2021.On January 4, 2021, Minnesota reported more new **Positive PCR tests (people)** than **Total PCR tests (people)**. As a result, **Negative PCR tests (people)**, which is calculated as **Total PCR tests (people)** minus **Positive PCR tests (people)**, decreased. Minnesota also noted during a [press conference](https://www.facebook.com/MPRnews/videos/885740615534664/) that roughly 650 of the cases reported on January 4, 2021, were a result of a backlog.On December 25, 2020, Minnesota announced on their [COVID-19 page](https://www.health.state.mn.us/diseases/coronavirus/situation.html) that there would be no update to their data on December 25, 2020 due to the holiday. On January 1, 2021, they announced that there would be no update to their data on January 1, 2021 due to the holiday. Additionally, they noted that data reported on January 3, 2021, would include data for both January 1, 2021 and January 2, 2021.On November 28, 2020 Minnesota announced on their COVID-19 page that the data reported on that day, would include data for both November 26, 2020, and November 27, 2020 due to the fact that they did not update their data on November 26, 2020 because of the Thanksgiving holiday. As a result, figures reported on November 28, 2020 include data reported during the previous 48 hour period, as opposed to the previous 24 hours.On November 26, 2020, Minnesota announced on their COVID-19 page that there would be no update to their data on November 26, 2020 due to the Thanksgiving holiday. Because Minnesota’s… | https://www.health.state.mn.us/diseases/coronavirus/situation.html | https://mn.gov/covid19/data/response-prep/response-capacity.jsp | @mnhealth | https://www.health.state.mn.us/diseases/coronavirus/index.html | Encounters | totalTestEncountersViral | Total Test Encounters (PCR) | All data | false | Minnesota | 27 | |||
| 32 | 32 | ND | On February 13, 2021 North Dakota's reported **Total Tests (PCR)** declined by 822 without explanation.On February 10, 2021, North Dakota's Confirmed cases decreased by 32 due to an [assessment of software malfunction](https://www.health.nd.gov/news/update-public-health-laboratory-completes-assessment-software-malfunction).On February 9, 2021, North Dakota’s Confirmed cases dropped by 62 due to an [assessment of software malfunction](https://www.health.nd.gov/news/update-public-health-laboratory-completes-assessment-software-malfunction), from 93,610 to 93,548. Additionally, their Cases (confirmed + probable) dropped by 11.On February 6, 2021, North Dakota’s Confirmed cases decreased by 36 due to an [assessment of software malfunction](https://www.health.nd.gov/news/update-public-health-laboratory-completes-assessment-software-malfunction). On December 30, 2020, North Dakota began reporting antigen in addition to PCR testing. From December 30, 2020 to January 3, 2021, we captured those numbers combined in our Total Tests (PCR) and Total Test Encounters (PCR) fields. On January 4, 2021, we began reporting these figures separately and revised our historical data to reflect the separate antigen and PCR numbers North Dakota provides.On December 25, 2020, North Dakota announced on their [COVID-19 dashboard](https://www.health.nd.gov/diseases-conditions/coronavirus/north-dakota-coronavirus-cases) that there would be no update to their data on December 25, 2020 due to the Christmas holiday. On January 1, 2020, they noted that there would be no update on January 1, 2020 due to the New Years holiday.On December 15, 2020 through December 17, 2020, North Dakota announced that they were resolving a technical issue with their dashboard. As a result, the hospitalization dashboard was unavailable, and we were unable to update their **Now in ICU**, **Ever hospitalized**, and **Ever in ICU** metrics.On December 10, 2020, we backfilled **Confirmed cases**, **Probable Cases** and **Total cases** from March 10, 2020 until December 9… | https://www.health.nd.gov/diseases-conditions/coronavirus/north-dakota-coronavirus-cases | @NDDOH | https://www.health.nd.gov/diseases-conditions/coronavirus | Encounters | totalTestEncountersViral | Total Test Encounters (PCR) | @NDDOH | false | North Dakota | 38 | ||||
| 37 | 37 | NV | The Nevada Department of Health and Human Services states that due to testing performed on environmental samples, the number of Total PCR Tests (test encounters) reported is higher than the number of test encounters including only tests performed on people.Negative test results reported in our API and CSVs are calculated by subtracting **Confirmed cases** from **Total PCR tests (people)**.On November 19, 2020, we removed the timseries of **Recovered** in Nevada because it reflected only recoveries in licensed facilities. As of October 30, 2020, Nevada's total test results are drawn from our `totalTestEncountersViral` field instead of calculated via positive+negative. The number of unique people tested is available in our API as `totalTestsPeopleViral`.On October 29, 2020, Nevada’s Total Tests (PCR) increased by a smaller amount than the increase in Cases. Because Negative test results are calculated by subtracting Confirmed cases from Total PCR tests (people), Negative test results decreased on October 29, 2020.On October 15, 2020, Nevada stopped reporting the number of unique people who tested negative on their dashboard without explanation. We carried forward the last reported number of people tested negative between October 15 and October 21 (our policy when a metric goes missing without notice is to “freeze” the number for up to seven days to allow states to recover from temporary reporting problems). Since our API uses the sum of positive+negative tests to calculate the total number of tests in Nevada, this caused the number of total tests on those dates to increase only by the number of positives. On October 21, 2020, we updated the number of Nevada’s negative tests for October 15 through October 20 based on a calculation of (Total people tested – Cases)On October 15, 2020, Nevada stopped reporting **Total PCR tests (specimens)** and began reporting **Total PCR tests (test encounters)**. Due to this we cannot continue reporting **Total PCR tests (specimens)**, however the time series for the specimens metri… | https://app.powerbigov.us/view?r=eyJrIjoiMjA2ZThiOWUtM2FlNS00MGY5LWFmYjUtNmQwNTQ3Nzg5N2I2IiwidCI6ImU0YTM0MGU2LWI4OWUtNGU2OC04ZWFhLTE1NDRkMjcwMzk4MCJ9 | https://app.powerbigov.us/view?r=eyJrIjoiMjA2ZThiOWUtM2FlNS00MGY5LWFmYjUtNmQwNTQ3Nzg5N2I2IiwidCI6ImU0YTM0MGU2LWI4OWUtNGU2OC04ZWFhLTE1NDRkMjcwMzk4MCJ9&pageName=ReportSection713122d051caa3096e41 | https://app.powerbigov.us/view?r=eyJrIjoiMjA2ZThiOWUtM2FlNS00MGY5LWFmYjUtNmQwNTQ3Nzg5N2I2IiwidCI6ImU0YTM0MGU2LWI4OWUtNGU2OC04ZWFhLTE1NDRkMjcwMzk4MCJ9&pageName=ReportSection966ce53550e53608e0a6 | https://app.powerbigov.us/view?r=eyJrIjoiMjA2ZThiOWUtM2FlNS00MGY5LWFmYjUtNmQwNTQ3Nzg5N2I2IiwidCI6ImU0YTM0MGU2LWI4OWUtNGU2OC04ZWFhLTE1NDRkMjcwMzk4MCJ9&pageName=ReportSection966ce53550e53608e0a6 | @dhhsnevada | http://dpbh.nv.gov/coronavirus/ | Encounters | totalTestEncountersViral | Total Test Encounters (PCR) | All data | false | Nevada | 32 | |
| 38 | 38 | NY | New York City reports **Deaths (probable)** from COVID-19 that New York State does not include in its data reporting. Because we collect state data, not city or county data, these New York City probable deaths from COVID-19 are not included in our dataset. The total number of deaths from COVID-19 for New York State reported by the CDC is significantly larger than the total number of deaths from COVID-19 reported by New York State. The **Recovered** data point we report for New York reflects the number of lab-confirmed COVID-19 patients discharged from the hospital and therefore does not represent the total number of people who have recovered from COVID-19, since many people with COVID are never hospitalized.New York State has not reported new **Ever hospitalized** data since June 2, 2020.As of November 23, 2020, New York's `totalTestResults` are drawn from our `totalTestEncountersViral` field instead of calculated via positive+negative. | https://coronavirus.health.ny.gov/county-county-breakdown-positive-cases | https://covid19tracker.health.ny.gov/views/NYS-COVID19-Tracker/NYSDOHCOVID-19Tracker-Fatalities?%3Aembed=yes&%3Atoolbar=no&%3Atabs=n | https://www.governor.ny.gov/news | https://forward.ny.gov/daily-hospitalization-summary-region | https://forward.ny.gov/daily-hospitalization-summary-region | @healthnygov | https://www.health.ny.gov/diseases/communicable/coronavirus/ | Encounters | totalTestEncountersViral | Total Test Encounters (PCR) | Only positives | false | New York | 36 |
| 42 | 42 | PA | On February 9, 2021, Pennsylvania [announced](https://www.media.pa.gov/pages/health-details.aspx?newsid=1286) via a press release that case data for February 8, 2021 would be low as a result of “technical maintenance to the data server on Sunday”. Data for February 9, 2021, will include cases from “catch-up reporting because of lengthy server downtime”. Additionally, they noted that death data is sourced from a different server and was not affected.As of February 2, 2021, Pennsylvania's totalTestResults field is drawn from the 'totalTestEncountersViral' field instead of being calculated from positive+negative.On February 1, 2021, we backfilled the full time series of **Total Test Encounters (PCR)**, from data now available on [Open Data Pennsylvania](https://data.pa.gov/Health/COVID-19-PCR-Test-Counts-March-2020-Current-Statew/r6ti-va88), and cleared our **Total Tests (PCR)** column. Going forward, we will enter PA's "Total PCR Tests" into Our **Total Test Encounters (PCR)** column rather than **Total Tests (PCR)**, as the state's site describes the data as encounters.On January 28, 2021, Pennsylvania [noted](https://www.media.pa.gov/pages/health-details.aspx?newsid=1273) that their case counts included backlogged antigen testing data from urgent care centers collected over a week ago. Pennsylvania will continue to report this data over the next few days, which will in turn affect our reported case counts.On January 4, 2021, Pennsylvania [announced](https://www.media.pa.gov/pages/health-details.aspx?newsid=1231) "3,226 additional positive cases of COVID-19, in addition to 4,579 new cases reported Sunday, January 3 for a two-day total of 8,992 additional positive cases of COVID-19." In addition, case counts for January 4, 2021 are "atypically low" due to technical maintenance.On December 28, 2020, Pennsylvania's Total PCR tests (specimens) value increased by ~690,000 from 7,202,533 tests to 7,892,184 tests. On December 29, 2020, this Total PCR tests value decreased by ~580,000 to 7,312,858 tests. We were unable to… | https://www.health.pa.gov/topics/disease/coronavirus/Pages/Cases.aspx | https://padoh.maps.arcgis.com/apps/opsdashboard/index.html#/5662e22517b644ba874ca51fa7b61c94 | @PAHealthDept | https://www.health.pa.gov/topics/disease/Pages/Coronavirus.aspx | Encounters | totalTestEncountersViral | Total Test Encounters (PCR) | Only positives | false | Pennsylvania | 42 | |||
| 44 | 44 | RI | Rhode Island combines PCR and antigen tests in the total tests figure reported on the state's dashboard.The **Recovered** data point we report for Rhode Island reflects the number of COVID-19 patients discharged from the hospital and therefore does not represent the total number of people who have recovered from COVID-19, since many people with COVID are never hospitalized.On February 9, 2021, Rhode Island’s Total PCR tests (people) and Negative PCR tests (people) decreased by roughly 34,000 without explanation.On January 18, 2021, Rhode Island announced on their [COVID-19 dashboard](https://ri-department-of-health-covid-19-data-rihealth.hub.arcgis.com/) that there will be no daily update due to the holiday, and that their data will next be updated on Tuesday, January 19, 2021.On December 31, 2020, Rhode Island announced on their [COVID-19 dashboard](https://ri-department-of-health-covid-19-data-rihealth.hub.arcgis.com) that their data would not be updated on December 31, 2020 through January 3, 2021. Their data will next be updated on January 4, 2021.On December 26, 2020, we cleared Rhode Island's **Confirmed cases** field as we learned from outreach it includes antigen tests in the figure. The full history remains available in the **Positive** field.On December 24, 2020, Rhode Island announced on their COVID-19 dashboard that their data would not be updated on December 24, 2020 through December 27, 2020. Their data will next be updated on December 28, 2020.On November 26, 2020, Rhode Island did not update their data by the time of our daily update, presumably due to the Thanksgiving holiday.On November 25, 2020, Rhode Island’s **Total PCR tests (people)** decreased by roughly 500 and **Negative tests (people)** decreased by roughly 1400 without explanation.On September 25, 2020, Rhode Island removed 240 duplicate cases from its case count, resulting in a drop from 24,311 cases to 24,181. As of August 17, 2020, our **Total tests** metrics include Rhode Island's **Total tests (in test encounters)**. | https://health.ri.gov/data/covid-19/ | https://docs.google.com/spreadsheets/d/1c2QrNMz8pIbYEKzMJL7Uh2dtThOJa2j1sSMwiDo5Gz4/edit#gid=264100583 | https://docs.google.com/spreadsheets/d/1c2QrNMz8pIbYEKzMJL7Uh2dtThOJa2j1sSMwiDo5Gz4/gviz/tq?tqx=out:csv&sheet=1592746937 | @rihealth | https://health.ri.gov/diseases/respiratory/?parm=163 | Encounters | totalTestEncountersViral | Total Test Encounters (PCR) | All data | false | Rhode Island | 44 | ||
| 50 | 50 | VA | The **Recovered** data point we report for Virginia reflects the number of COVID-19 patients discharged from the hospital and therefore does not represent the total number of people who have recovered from COVID-19, since many people with COVID are never hospitalized.On February 22, 2021 through March 1, 2021, Virginia announced that the Virginia Department of Health was processing 2021 death certificates resulting from a “post-holiday surge of COVID-19 cases”. As a result, new deaths from this time period may be larger than usual. We urge caution when interpreting data from this period, and encourage the use of 7 and 14-day averages as more reliable metrics.On January 31, 2021 through February 1, 2021, Virginia noted that “Surveillance system upgrades occurring on Saturday, January 30, 2021, will affect the data on the COVID-19 Cases & Testing Dashboards on January 31 and February 1, 2021. A decrease in the number of cases and tests reported on January 31, and an increase in the number of cases and tests reported on February 1 is anticipated because of these upgrades”. On January 12, 2021, we backfilled antibody (`totalTestsAntibody`, `positiveTestsAntibody`) and antigen (`totalTestsAntigen`, `positiveTestsAntigen`) testing time series from the states dataset. The data from the state describes *testing encounters* for both antibody and antigen testing, since we do not track testing encounters for antibody and antigen testing, we're using the testing specimens fields.Antigen testing is reported as starting from January 26th, 2020, which is very early for antigen testing, we'll ask the state for clarifications.On December 8, 2020, Virginia’s **Recovered** decreased by 200 without explanation.On December 5, 2020, Virginia announced that some of the cases reported that day were part of a backlog. As a result, not all cases reported on December 5, 2020 were reported within the previous 24 hour period.On December 2, 2020, we switched our source for Virginia’s **Ever hospitalized**, and shifted our entire time series f… | https://www.vdh.virginia.gov/coronavirus/covid-19-in-virginia/ | https://www.vhha.com/communications/virginia-hospital-covid-19-data-dashboard/ | https://data.virginia.gov/resource/3u5k-c2gr.json?%24query=select+sum%28number_of_pcr_testing%29+as+pcr_testing%2C+sum%28number_of_positive_pcr_testing%29+as+pos_pcr_testing | @vdhgov | http://www.vdh.virginia.gov/surveillance-and-investigation/novel-coronavirus/ | Encounters | totalTestEncountersViral | Total Test Encounters (PCR) | Positives + Negatives | false | Virginia | 51 | ||
| 53 | 53 | WA | Washington’s data is on a 1 day lag in our timeseries due to consistently updating after 7:30 pm Eastern Time, when we publish our daily update.Washington State reports **confirmed cases**, **laboratory tests**, and **deaths** as of the previous day. We report the most recent hospitalization data available for Washington. In some cases, this data may be reviewed and revised by the Washington State Department of Health. As a result, Washington considers hospitalization data complete after a 18-day lag period. In our data this lag is 20 days.Currently and since November 21, 2020, Washington [is reporting](https://www.doh.wa.gov/Emergencies/COVID19/DataDashboard) a variety of technical difficulties and an increased laboratory report volume. As a result, their data through these dates is incomplete and may include duplicate cases, missing negative test results, spikes due to backlog processing, and other abnormalities. Please exercise caution when looking at this data and be aware that 7 day averages are a more reliable metric than individual figures.On February 15, 2021, Washington announced that there would be no update to their data due to the President’s day holiday. Because Washington’s data is on a one day lag in our timeseries, we were unable to update their data on February 16, 2021.On February 10, 2021, Washington [announced](https://covid-tracking-project-data.s3.us-east-1.amazonaws.com/state_screenshots/WA/WA-20210211-123942.png) that their cumulative hospitalizations decreased by 14, noting that “in some cases, after a detailed information review, local health departments reclassify cases as not hospitalized or hospitalized for a reason other than COVID-19.” Because Washington’s data is on a one day lag in our timeseries, this affects our data for February 11, 2021.On February 9, 2021, Washington [announced](https://covid-tracking-project-data.s3.us-east-1.amazonaws.com/state_screenshots/WA/WA-20210210-123423.png) that the higher number of deaths was due to a “data processing backlog” from February 8, 202… | https://www.doh.wa.gov/Emergencies/NovelCoronavirusOutbreak2020COVID19/DataDashboard | https://coronavirus.wa.gov/what-you-need-know/covid-19-risk-assessment-dashboard | https://coronavirus.wa.gov/what-you-need-know/covid-19-risk-assessment-dashboard | https://coronavirus.wa.gov/what-you-need-know/covid-19-risk-assessment-dashboard | @WADeptHealth | https://www.doh.wa.gov/Emergencies/Coronavirus | Encounters | totalTestEncountersViral | Total Test Encounters (PCR) | Positives + Negatives | false | Washington | 53 | |
| 54 | 54 | WI | On February 8, 2021, Wisconsin's Total PCR tests (test encounters) decreased by roughly 13,000 without explanation.On February 1, 2021, Wisconsin’s Total PCR tests (test encounters) decreased by roughly 17,000 without explanation.On January 9, 2021, Wisconsin’s **Recovered** metric decreased by approximately 20,000, however on their [official twitter](https://twitter.com/DHSWI/status/1348020141674487808) Wisconsin indicated a problem with this metric. The metric was updated, and then patched in our data, later on January 9, 2021.On October 29, we populated the full time series for **Total Test Encounters (PCR)** from a time series provided by Wisconsin via CSV on their dashboard. Also as of October 29, Wisconsin's `totalTestResults` represent total test encounters instead of being calculated via pos+neg. The number of unique people ever tested remains available in the API in the `totalTestsPeopleViral` field. On October 20, Wisconsin started providing a total tests number on their dashboard and we started to collect that data into **Total Test Encounters (PCR)**. In early June of 2020, Wisconsin started reporting **Probable deaths** from COVID-19 separately from **Confirmed deaths** from COVID-19. We did not discover this data until June 29, 2020, and so our time series only has data for this metric beginning on that date. In early June of 2020, Wisconsin started reporting **Probable cases** of COVID-19 separately from **Confirmed cases** of COVID-19. On June 25, 2020, we added more than two weeks' worth of **Probable cases** to our **Cases (confirmed plus probable)** for WI, initially causing a large single day increase in cases. We subsequently updated our historical Cases data using data provided to us by the state, which eliminated this one-day increase. On March 30, 2020, Wisconsin revised its cumulative **Negative PCR tests (people)** data downward without explanation." | https://www.dhs.wisconsin.gov/covid-19/data.htm | https://www.dhs.wisconsin.gov/covid-19/hosp-data.htm | https://bi.wisconsin.gov/t/DHS/views/PercentofconfirmedprobableCOVID-19casesby-group-MOBILE/CaseDB2/butleoljdl@accounts.wistate.us/ed25311e-7f8a-4c7d-aee8-97b28850f0ac?:embed=y&:display_spinner=no&:showAppBanner=false&:embed_code_version=3&:loadOrderID=4&:display_count=n&:showVizHome=n&:origin=viz_share_link | https://bi.wisconsin.gov/t/DHS/views/PercentofCOVID-19deathsby-group-MOBILE/DeathDB2?:embed_code_version=3&:embed=y&:loadOrderID=2&:display_spinner=no&:showAppBanner=false&:display_count=n&:showVizHome=n&:origin=viz_share_link | https://bi.wisconsin.gov/t/DHS/views/PercentofCOVID-19deathsby-group-MOBILE/DeathDB2?:embed_code_version=3&:embed=y&:loadOrderID=2&:display_spinner=no&:showAppBanner=false&:display_count=n&:showVizHome=n&:origin=viz_share_link | @DHSWI | https://www.dhs.wisconsin.gov/disease/covid-19.htm | Encounters | totalTestEncountersViral | Total Test Encounters (PCR) | All data | false | Wisconsin | 55 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [states_info] ( [state] TEXT, [notes] TEXT, [covid19Site] TEXT, [covid19SiteSecondary] TEXT, [covid19SiteTertiary] TEXT, [covid19SiteQuaternary] TEXT, [covid19SiteQuinary] TEXT, [twitter] TEXT, [covid19SiteOld] TEXT, [covidTrackingProjectPreferredTotalTestUnits] TEXT, [covidTrackingProjectPreferredTotalTestField] TEXT, [totalTestResultsField] TEXT, [pui] TEXT, [pum] TEXT, [name] TEXT, [fips] INTEGER );