Data provided by Big Local News and snapshotted daily from the COVID19 Tracker, https://covidtracking.com/.

Data source: Big Local News · About: big-local-datasette

56 rows

View and edit SQL

Suggested facets: covidTrackingProjectPreferredTotalTestUnits, covidTrackingProjectPreferredTotalTestField, totalTestResultsField, pui

Link rowid ▼ state notes covid19Site covid19SiteSecondary covid19SiteTertiary covid19SiteQuaternary covid19SiteQuinary covid19SiteOld covidTrackingProjectPreferredTotalTestUnits covidTrackingProjectPreferredTotalTestField totalTestResultsField pui pum name fips
1 AK Alaska combines PCR and antigen tests in the total tests figure reported on the state's dashboard.As of February 6, 2021, [Alaska no longer updates](https://twitter.com/alaska_dhss/status/1355349178335944708?s=21) their COVID-19 dashboards on weekends. As a result, we will be unable to update their data on Saturdays and Sundays. On February 12, 2021, Alaska [announced](https://twitter.com/Alaska_DHSS/status/1360413364065767424?s=20) via the official Alaska Department of Health and Social Services twitter that there would be no update to their data on February 15, 2021 due to the Presidents Day holiday.On January 20, 2021, Alaska [reported](https://www.adn.com/alaska-news/2021/01/20/tracking-covid-19-in-alaska-record-23-deaths-and-167-infections-reported-wednesday/) a comparatively large increase of 23 deaths due to a review of death certificates.On January 4, 2020, Alaska noted that "counted deaths in Alaska include COVID-19 cases confirmed through a lab result as well as probable deaths based on confirmed COVID-19 clinical and epidemiological criteria as defined by the CDC with no confirmatory lab testing." Due to this change we are unable to update the **Confirmed deaths** metric after January 4, 2020.On January 1, 2021, Alaska noted that there would be no update to their data on January 1, 2021.On December 25, 2020, Alaska announced on their dashboard that there would be no update to their data on December 25, 2020. On November 17, 2020, Alaska [announced](https://alaska-coronavirus-vaccine-outreach-alaska-dhss.hub.arcgis.com/datasets/cases-frequently-asked-questions) that “As of 11/17/2020, the cases dashboard will not be showing data on recovered and active cases due to the increasing State case load”. 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 November 16, 2020 we updated the **Cases (confirmed plus probable)** field to include only residents. We also deleted the time series for **Confirmed c… http://dhss.alaska.gov/dph/Epi/id/Pages/COVID-19/monitoring.aspx https://experience.arcgis.com/experience/ed1c874ca60b4c15ab09095a070065ca https://alaska-dhss.maps.arcgis.com/apps/opsdashboard/index.html#/8782a14ef52342e99f866a3b8a3e624a https://services1.arcgis.com/WzFsmainVTuD5KML/arcgis/rest/services/Tests_Dataset/FeatureServer/0/query?where=Test_Result+%3D+%27Negative%27&outStatistics=%5B%7B%27statisticType%27%3A+%27count%27%2C+%27onStatisticField%27%3A+%27FID%27%2C+%27outStatisticFieldName%27%3A+%27tests_negative%27%7D%5D https://services1.arcgis.com/WzFsmainVTuD5KML/arcgis/rest/services/Tests_Dataset/FeatureServer/0/query?where=Test_Result+%3D+%27Positive%27&outStatistics=%5B%7B%27statisticType%27%3A+%27count%27%2C+%27onStatisticField%27%3A+%27FID%27%2C+%27outStatisticFieldName%27%3A+%27tests_positive%27%7D%5D http://dhss.alaska.gov/dph/Epi/id/Pages/COVID-19/default.aspx Specimens totalTestsViral Total Tests (PCR) All data false Alaska 2
2 AL Alabama combines PCR and antigen tests in the total tests figure reported on the state's dashboard.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 6, 2021, Alabama's **Total antibody tests (people)** decreased from 140,376 to 108,818 without explanation.On February 5, 2021, Alabama announced that they were experiencing a technical issue with their testing data. As a result, we were unable to update their Total antibody tests (people), Total PCR tests (people), and Negative PCR tests (people), which is calculated as Total PCR tests (people) minus Confirmed cases.On February 02, 2021, Alabama reported a large increase in Total antibody tests (people) of approximately 33,000 without explanation. Additionally, **Total PCR tests (people)** decreased by approximately 11,000 without explanation, resulting in a decrease in Negative PCR tests (people).On January 30, 2021, Alabama noted on their data dashboard that due to maintenance and upgrades, the Alabama NEDSS Base System did not run on the evening of January 29, 2021, and as as result there would be no update to their dashboard on January 30, 2021. We were only able to update their Currently hospitalized and Ever hospitalized on January 30, 2021.On January 22, 2021, Alabama noted that the Alabama Department of Public Health processed a backlog of 409 positive PCR tests dating back to November 19, 2020 through January 20, 2021, and that these tests would be included in their Confirmed cases and Cases (confirmed + probable) for January 22, 2021. As a result, not all new cases reported on January 22, 2021 were reported within the previous 24 hour period.On January 13, 2021, Alabama reported that it is reviewing a large number of deaths from the Alabama Center for Health Statistics (ACHS), an endeavor which began on November 11, 2020 and will continue until further notice. As a result, death numbers during this time period reported may inclu… https://alpublichealth.maps.arcgis.com/apps/opsdashboard/index.html#/6d2771faa9da4a2786a509d82c8cf0f7 https://alpublichealth.maps.arcgis.com/apps/opsdashboard/index.html#/6d2771faa9da4a2786a509d82c8cf0f7 https://services7.arcgis.com/4RQmZZ0yaZkGR1zy/arcgis/rest/services/HospitalizedPatientTemporal_READ_ONLY/FeatureServer/1/query?where=1%3D1&orderbyfields=DateTxt+desc&outFields=%2A&resultRecordCount=1     http://www.alabamapublichealth.gov/infectiousdiseases/2019-coronavirus.html People totalTestsPeopleViral Total PCR Tests (People) No data false Alabama 1
3 AR Arkansas reports a category of “non-COVID deaths,” representing individuals who died with COVID positive but of causes unrelated to COVID. We do not count these individuals in our deaths metric, consistent with our policy of tracking only individuals with COVID as a cause of death where possible.On February 28, 2021, Arkansas’s total Deaths decreased by over 200. Arkansas [stated](https://twitter.com/ADHPIO/status/1366163333225799682) that this decrease was because of data clean-up and deduplication.During the week of September 20, 2020, Arkansas made some continual adjustments to its antigen people tested numbers, resulting in some fluctuation in its negatives and totals.As of September 18, 2020, Arkansas's total test results are drawn from our `totalTestsViral` field instead of calculated via positive+negative. The totals do not include repeat positives—counting individuals only for their first positive—but do count repeat negative tests.On September 16, 2020, Arkansas’s **Negative Tests (PCR)** dropped by 26,801 tests, causing its **Total Tests (PCR)** to drop by 26,195 tests due to the reversal of a data dump of negative test results. It also added 140 **Probable deaths**, not all of which dated to September 16.On September 3, 2020, Arkansas began reporting **Probable cases** according to the most recent CSTE definitions, in addition to confirmed cases. This added 423 new cases to AR’s **Total cases** number.On Aug 15, 2020, Arkansas data changed due to deduplication and the state's removal of out-of-state cases from its dataset. These changes resulted in reductions in **Total cases**, **Ever hospitalized**, and **Ever in ICU** data. Between July 30, 2020 and September 17, 2020, Arkansas provided Total, Positive, and Negative Antigen tests (specimens) sporadically and then stopped reporting them. This data can be found in our API. https://www.healthy.arkansas.gov/programs-services/topics/novel-coronavirus https://experience.arcgis.com/experience/c2ef4a4fcbe5458fbf2e48a21e4fece9 https://adem.maps.arcgis.com/apps/opsdashboard/index.html#/fd6874664d404993814de4d5a65d5cfd https://adem.maps.arcgis.com/apps/opsdashboard/index.html#/fd6874664d404993814de4d5a65d5cfd https://adem.maps.arcgis.com/apps/opsdashboard/index.html#/fd6874664d404993814de4d5a65d5cfd https://www.healthy.arkansas.gov/programs-services/topics/novel-coronavirus Specimens totalTestsViral Total Tests (PCR) All data false Arkansas 5
4 AS American Samoa does not have a regularly updated data source. We monitor their social media, emergency declarations, and local media for updates.As of September 18, 2020, American Samoa's total test results are drawn from our `totalTestsViral` field instead of calculated via positive+negative. https://www.americansamoa.gov/covid-19-advisories https://www.facebook.com/amsamgov/       http://www.samoagovt.ws/2020/03/ministry-of-health-coronavirus-covid-19-update-14-march-2020/ Specimens totalTestsViral Total Tests (PCR) No Data false American Samoa 60
5 AZ Arizona combines PCR and antigen tests in the total tests figure reported on the state’s dashboardArizona regularly reviews and removes duplicate records which may occasionally result in minor decreases of cumulative figures. The **Recovered** data point we report for Arizona 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 (people)** in the absence of better data.On March 1, 2021, Arizona [announced](https://twitter.com/AZDHS/status/1366405875754291212?s=20) via the official Arizona Department of Health Twitter that due to death certificate matching, Confirmed deaths increased by 1, and Probable deaths decreased by 2. As a result, Deaths (confirmed + probable) decreased by 1.On February 22, 2021, Arizona [announced](https://twitter.com/AZDHS/status/1363869914356994054?s=20) via the Department of Health's official Twitter that no new deaths were reported. Additionally, there was a decrease of 3 deaths (confirmed and probable) due to death certificate matching.On January 18, 2021 Arizona [announced](https://twitter.com/AZDHS/status/1351183189100867586) via the official Arizona Department of Health twitter that their reported Deaths (confirmed and probable) decreased by one due to de-duplication of the data.On January 9, 2021, Arizona [announced](https://twitter.com/AZDHS/status/1347930259170021376?s=20) that the number of COVID-19 patients in ICU was incomplete on their COVID-19 dashboard, and we sourced Currently in ICU from the official Arizona Department of Health twitter.On December 28, 2020, Arizona [noted](https://twitter.com/AZDHS/status/1343575976026886144) that due to the holiday weekend, multiple days of case reviews were completed, resulting in the data for December 28, 2020 being higher than usual. As a result, they … https://www.azdhs.gov/preparedness/epidemiology-disease-control/infectious-disease-epidemiology/covid-19/dashboards/index.php https://tableau.azdhs.gov/views/Hospitalization/HospitalizedCOVID-19Cases?:embed=y&:showVizHome=no&:host_url=https%3A%2F%2Ftableau.azdhs.gov%2F&:embed_code_version=3&:tabs=no&:toolbar=no&:showAppBanner=false&:display_spinner=no&iframeSizedToWindow=true&:loadOrderID=3 https://tableau.azdhs.gov/views/ExternalEMResourceCOVIDSpecificDashboard/InpatientCOVID-19?:embed=y&:showVizHome=no&:host_url=https%3A%2F%2Ftableau.azdhs.gov%2F&:embed_code_version=3&:tabs=yes&:toolbar=no&:showAppBanner=false&:display_spinner=no&iframeSizedToWindow=true&:loadOrderID=4 https://tableau.azdhs.gov/views/ExternalEMResourceCOVIDSpecificDashboard/VentilatorsinUseCOVID-19?%3Aembed=y&%3AshowVizHome=no&%3Ahost_url=https%3A%2F%2Ftableau.azdhs.gov%2F&%3Aembed_code_version=3&%3Atabs=yes&%3Atoolbar=no&%3AshowAppBanner=false&%3Adisplay_spinner=no&iframeSizedToWindow=true&%3AloadOrderID=1 https://www.azdhs.gov/preparedness/epidemiology-disease-control/infectious-disease-epidemiology/covid-19/dashboards/index.php https://www.azdhs.gov/preparedness/epidemiology-disease-control/infectious-disease-epidemiology/covid-19/dashboards/index.php Specimens totalTestsViral Total Tests (PCR) All data false Arizona 4
6 CA On February 25, 2021, California announced that their deaths included a backlog of 806 deaths initially not reported as COVID-19 deaths from Los Angeles County. As a result, many of the deaths reported on February 25, 2021 occurred between December 3, 2020 and February 3, 2021. We urge caution when interpreting numbers from this period, and encourage the use of 7 and 14-day averages as more reliable metrics than individual figures.On December 16, 2020, California [announced](https://www.cdph.ca.gov/Programs/OPA/Pages/NR20-338.aspx) that their cases for December 16, 2020 include 15,337 cases from previous days due to a change in case processing. It appears this new process will regularly include a higher volume of cases that were not identified within the previous 24 hours.As of September 18, 2020, California's total test results are drawn from our `totalTestsViral` field instead of calculated via positive+negative.From July 23 through July 28, 2020, California reported that its **Now hospitalized** and **Now in ICU** were incomplete due to its transition to the HHS reporting system. We carried over hospitalization figures until July 28. We will backfill the complete numbers for this period if the complete data becomes available.From June 29 to July 5, 2020, California made revisions to daily **case** numbers. On July 17, we updated the values based on the most recent data from the state dashboard.On July 8, 2020, California data included a backlog from Los Angeles County, which had not reported for several days. Approximately 1,000 of the 11,000 new cases were attributed to this backlog data.As of April 22, 2020, California has reported specimens tested instead of people tested. Because some people may be tested more than once, this number is probably higher than the number of people tested.On April 4 and April 22, 2020, California reported large batches of backlogged **negative test** data. Prior to April 1, 2020, we used county data sources for more reliably timely reporting of California's COVID-19 data. At th… https://update.covid19.ca.gov https://public.tableau.com/views/COVID-19CasesDashboard_15931020425010/Cases?:embed=y&:showVizHome=no https://public.tableau.com/views/COVID-19HospitalsDashboard/Hospitals?:embed=y&:showVizHome=no     https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/Immunization/ncov2019.aspx Specimens totalTestsViral Total Tests (PCR) Only positives false California 6
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 https://www.colorado.gov/pacific/cdphe/2019-novel-coronavirus Encounters totalTestEncountersViral Total Test Encounters (PCR) Positives + Negatives false Colorado 8
8 CT 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.The **Recovered** data point we report for Connecticut 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. Connecticut stopped reporting hospital discharges on October 22, 2020, but the time series for the metric is available in the historical data, and our data downloads. As of February 23, 2021, Connecticut's `totalTestResults` field is taken directly from `totalTestsViral` instead of calculated from positive + negative. We also cleared the history of Negative (people or cases) since it was calculated using mixed units.On February 3, 2021, we updated the **Total Antigen Tests** and backfilled **Positive Antigen Tests** and **Negative Antigen Tests** from Connecticut's testing dataset provided by the state. Going forward, we'll be updating all these 3 metrics on weekdays. On February 23, we backfilled **Total PCR Tests (specimens)** from the same source so that it would only include PCR tests. This resulted in a drop at the topline of 345,693 tests, distributed over the timeseries.On December 25, 2020, Connecticut announced on their [COVID-19 page](https://portal.ct.gov/Coronavirus/COVID-19-Data-Tracker) that there would be no update to their data on December 25, 2020 through December 27, 2020 or on January 1, 2021 due to the holidays.On November 26, 2020, Connecticut announced via a [press release](https://portal.ct.gov/Office-of-the-Governor/News/Press-Releases/2020/11-2020/Governor-Lamont-Coronavirus-Update-November-25) that there would be no update to their data on November 26, 2020 due to the Thanksgiving holiday. Additionally, the data for November 26, 2020 and November 27, 2020 will both be included in the November 27, 2020 update.On November 5, 2020, Connecticut announced that … https://data.ct.gov/coronavirus https://data.ct.gov/stories/s/q5as-kyim https://data.ct.gov/api/id/rf3k-f8fg.json?%24query=select+%2A+order+by+date+desc+limit+1     https://portal.ct.gov/Coronavirus Specimens totalTestsViral Total Tests (PCR) All data false Connecticut 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     https://coronavirus.dc.gov/ Encounters totalTestEncountersViral Total Test Encounters (PCR) All data false District of Columbia 11
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       https://dhss.delaware.gov/dhss/dph/epi/2019novelcoronavirus.html Encounters totalTestEncountersViral Total Test Encounters (PCR) All data false Delaware 10
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= http://www.floridahealth.gov/diseases-and-conditions/COVID-19/ Encounters totalTestEncountersViral Total Test Encounters (PCR) All data false Florida 12
12 GA On February 3, 2021, we moved Georgia’s history of Positive Antigen Tests (people) to Probable Cases, since the state calls the metric “antigen positive cases.” We also backfilled Positive (people, confirmed + probable) to include these values. This change resulted in the addition of 162,028 cases in Georgia distributed over the timeseries from November 3, 2020 onward. Georgia does not provide a full history of this number, so on November 3, 2020 we record 29,937 probable cases for Georgia, many of which do not date to that day.On January 6, 2021, Georgia stated on its dashboard that its data would be delayed several hours “due to a high volume of data to process.” Georgia’s data did not update before for our publication time. We were able to update their Currently hospitalized from their separate [hospitalization source](https://www.arcgis.com/apps/opsdashboard/index.html#/e40c39564f724af7bfe8fd5d88deadb6).On November 13, 2020, we backfilled the **Total PCR tests (specimens)** time series to include only PCR testing, reported by the state in their data download file. This updates the previously reported series that until May 27, 2020 included both PCR and antibody tests.On November 3, 2020, Georgia started reporting probable deaths and antigen positive cases in their COVID-19 Daily Status report. On November 4, we added the probable deaths in our **Deaths (probable)** field for November 3 and 4, causing the daily rise in deaths on the 3rd to appear as 480. This large increase includes the data dump of 450 probable deaths, many of which are not from the most recent 24 hour period. We also began recording the 29,937 antigen positive cases in our `positiveTestsPeopleAntigen` API field. We have reached out to Georgia's health department for clarity on the definition of this number. On October 21, 2020, Georgia did not update their "COVID-19 Daily Status Report" by the time of our daily update due to technical issues. In order to provide the most up to date data possible, we updated only **Current Hospitalizations**,… https://dph.georgia.gov/covid-19-daily-status-report https://www.arcgis.com/apps/opsdashboard/index.html#/e40c39564f724af7bfe8fd5d88deadb6 https://augustagis.maps.arcgis.com/apps/opsdashboard/index.html#/4eec20925b6b4f338368df0ffcba472d     https://dph.georgia.gov/novelcoronavirus Specimens totalTestsViral Total Tests (PCR) Only positives false Georgia 13
13 GU As of November 21, 2020, Guam’s 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.Guam's counts include 11 people tested at the San Diego naval base.As of December 7, 2020, Guam’s Total PCR tests (specimens), Total antigen tests (specimens), Total antibody tests (specimens) will include all specimens reported. Previously they did not include follow up testing for known cases.On November 21, 2020, we cleared Guam’s **Total PCR tests (People)** timeseries. Prior to November 21, we had believed that Guam’s negative counts represented people. However after outreach to Guam’s health department, we learned that the negatives represented specimens (while its positives represent cases). This change means Guam’s totalTestResults represent specimens excluding repeat positive results.On November 18, 2020, Guam [announced](https://ghs.guam.gov/jic-release-no-454-results-112-test-positive-covid-19-two-gdoe-employees-test-positive-covid-19) that “Beginning next week, the Department of Public Health and Social Services (DPHSS) will shift from daily situation reports to weekly reports in order to provide for more comprehensive data analysis. To reflect this, the Joint Information Center (JIC) will report profiles of confirmed cases on a weekly basis only.” As a result, Positive antigen tests (specimens) and Positive antibody tests (specimens) will only be updated once weekly going forward.On September 3, 2020, Guam reported that it had shifted to using the more restrictive August 5 definition of probable cases released by the CSTE. From March 12, 2020 to September 2, 2020 Guam reported eight probable cases under the previous probable case definition. Due to the change, Guam has no cases that classify as probable cases as of September 3, 2020, and 8 cases have been removed from Guam's total case count. http://dphss.guam.gov/covid-19/ https://drive.google.com/file/d/1FVW6sNbdgyV5-CYkOorYvOGivkmOED8t/view https://drive.google.com/file/d/1n-vrUGzEzs7rjcxXBFEbIMmeUQykuyO9/view     https://ghs.guam.gov/coronavirus-covid-19 Specimens posNeg posNeg All Data false Guam 66
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/ https://health.hawaii.gov/docd/advisories/novel-coronavirus-2019/ Encounters totalTestEncountersViral Total Test Encounters (PCR) Only positives false Hawaii 15
15 IA On December 13, 2020, Iowa’s Total antigen tests (people) decreased by 77 and their Negative antigen tests (people) decreased by 206 without explanation.On October 16, 2020, Iowa removed 12,831 tests from the state’s PCR test total. On the same day, 19,308 tests were added to the state’s antigen test total. We were unable to locate an official explanation, but these changes were likely the result of data cleaning and reorganization work.On September 26, 2020, Iowa announced that due to a data update, roughly 27,000 antigen tests from long-term care facilities will be added to their COVID-19 antigen test data. This update will occur from September 26, 2020 to September 27, 2020, and will result in an increased number of antigen test tests reported in our data for Iowa. (Antigen data is available in our CSVs and API.)As of May 19, 2020, Iowa reports PCR and antibody tests separately. https://coronavirus.iowa.gov/ https://coronavirus.iowa.gov/pages/case-counts https://coronavirus.iowa.gov/pages/rmcc-data https://coronavirus.iowa.gov/pages/serology-testing   https://idph.iowa.gov/Emerging-Health-Issues/Novel-Coronavirus People posNeg posNeg All data false Iowa 19
16 ID Idaho'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. Negative test results reported in our API and CSVs are calculated by subtracting **Confirmed cases** from **Total PCR tests (people)** in the absence of better data. As of January 31, 2021, Idaho does not update their COVID-19 data on Sundays, and data reported on Mondays includes data for both Sunday and Monday. Because their data is on a one day lag in our timeseries due to late updates, we will be unable to update their data on Mondays, and data reported on Tuesdays will include two days of data. On February 12, 2021, Idaho [announced](https://twitter.com/IDHW/status/1360362916973744131) via the official Idaho Department of Health and Welfare Twitter that there would be no update to their data on February 15, 2021 due to the President’s day holiday. Because Idaho’s data is on a one day lag in our timeseries, we were unable to update their data on February 16, 2021.On January 20, 2021, Idaho [announced](https://twitter.com/IDHW/status/1352057437608583168) that two deaths had been removed from their total after updated records indicated that they were not due to COVID-19. Because Idaho’s data is on a one day lag due to late updates, this affects our Deaths (confirmed + probable) and Deaths (confirmed) for January 21, 2021On January 18, 2021, Idaho [announced](https://twitter.com/IDHW/status/1351318456206032903) via the official Idaho Department of Health and Welfare twitter that there would be no update to their data due to the Martin Luther King Jr. Day holiday. Additionally, they noted that the data published on January 19, 2021 would include two days of data. Because Idaho’s data is on a one day lag in our timeseries this affects our data for January 19, 2021 and January 20, 2021.On January 12, 2021, Idaho reported 10 cumulative probable deaths on their dashboard, a decrease from the 179 probable deaths reported the day before. We suspect that this is an error, and in or… https://coronavirus.idaho.gov/ https://public.tableau.com/views/DPHIdahoCOVID-19Dashboard/Testing?%3Aembed=y&%3AshowVizHome=no&%3Adisplay_count=y https://public.tableau.com/views/DPHIdahoCOVID-19Dashboard/Demographics?%3Aembed=y&%3AshowVizHome=no&%3Adisplay_count=y https://public.tableau.com/views/DPHIdahoCOVID-19Dashboard/Hospitalizations?%3Aembed=y&%3Aembed=y&%3AshowVizHome=no&%3AshowVizHome=n&%3Adisplay_count=y&%3Adisplay_static_image=y&%3Alanguage=en&%3AapiID=host0#navType=0&navSrc=Parse On February 13, 2021, the District of Columbia reported 426,830 **Total Test Encounters**, which is a decrease of 751 from the figure reported for the previous day. No explanation was available for this decrease.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).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.idaho.gov/ People totalTestsPeopleViral Total PCR Tests (People) All data false Idaho 16
17 IL Negative test results reported in our API and CSVs are calculated by subtracting **Total cases** from **Total PCR tests (specimens)** in the absence of better data. On January 22, 2021, Illinois began including all probable deaths reported since the beginning of the pandemic in the total case count. This means all 1,903 Probable deaths were included in the cases reported on January 22, 2021.On November 6, 2020, Illinois [announced](http://www.dph.illinois.gov/news/public-health-officials-announce-10376-new-confirmed-cases-coronavirus-disease) that they "will report confirmed cases and probable cases combined.” Due to this we cannot continue reporting **Confirmed** and **Probable cases** separately, however the time series for these metrics are available in the historical data, and our data downloads. As of October 15, 2020, Illinois combines PCR and antigen tests in the total tests figure reported on the state's dashboard.On September 4, 2020, Illinois reported over 140,000 new **Total PCR tests (in specimens)** and over 5,000 new **Cases.** According to the [Chicago Tribune](https://www.chicagotribune.com/coronavirus/ct-covid-19-pandemic-chicago-illinois-news-20200904-qun7unon5fhjbfhnsml4edwqia-story.html), "The Illinois Department of Public Health said Friday there was significant slowdown in the agency's test reporting earlier this week that it is just catching up with." http://www.dph.illinois.gov/topics-services/diseases-and-conditions/diseases-a-z-list/coronavirus http://www.dph.illinois.gov/covid19/hospitalization-utilization       http://www.dph.illinois.gov/topics-services/diseases-and-conditions/diseases-a-z-list/coronavirus Specimens posNeg posNeg All data false Illinois 17
18 IN Indiana combines PCR and antigen tests in the total tests figure reported on the state's dashboard.Negative test results reported in our API and CSVs are calculated by subtracting **Total cases** from **Total PCR tests (people)** in the absence of better data.On February 26, 2021, Indiana announced that due to a historic load of negative tests, 663 older Total PCR tests (people) and 2150 Total PCR tests (specimens) would be included in their data for the day.On February 4, 2021, Indiana announced that their deaths included “1,507 historical deaths identified through an audit of 2020 and 2021 COVID death records and test results”. As a result, the majority of new Deaths (confirmed + probable) and Deaths (confirmed) reported on February 4, 2021 were not reported in the previous 24 hours. We urge caution when looking at this figure.On January 5, 2021, Indiana’s Currently in ICU decreased by 9 without explanation.On November 29, 2020, Indiana announced that a historical backlog of roughly 2200 Total PCR tests (people) and about 4000 Total PCR tests (specimens) would be included in their data for November 29, 2020. The `Negative` field in the API will also be affected. As a result, new tests reported on November 29, 2020 were not all reported in the previous 24 hour period.As of October 16, 2020, Indiana’s total test results are drawn from our totalTestsViral field instead of calculated via positive+negative. https://www.in.gov/isdh/28470.htm https://www.regenstrief.org/covid-dashboard/ https://hub.mph.in.gov/dataset/covid-19-beds-and-vents/resource/882a7426-886f-48cc-bbe0-a8d14e3012e4/view/05961851-c7ab-4ac7-92bf-fdf9881ecdab https://hub.mph.in.gov/api/3/action/datastore_search_sql?sql=SELECT+sum%28%22COVID_POSITIVE_TESTS_ADMIN%22%29+as+pos_tests+from+%22afaa225d-ac4e-4e80-9190-f6800c366b58%22   https://www.in.gov/isdh/28470.htm Specimens totalTestsViral Total Tests (PCR) Only positives false Indiana 18
19 KS Kansas combines PCR and antigen tests in the total tests figure reported on the state's dashboard.Kansas reports most of its data on Mondays, Wednesdays, and Fridays only, so there are often large changes in the values, which can represent 2-3 days of data.The **Recovered** data point we report for Kansas 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. Kansas notes that this metric only includes cases with available discharge information reported to the Kansas Department of Health and Environment.On December 25, 2020, Kansas announced on their [COVID-19 page](https://www.coronavirus.kdheks.gov/160/COVID-19-in-Kansas) that there would be no update to their data on December 25, 2020 due to the holiday.On December 3, 2020, Kansas’ **Currently hospitalized** decreased by 342 without explanation. Kansas does not usually update their data on Thursdays.On November 13, 2020, Kansas announced that there was a "technical issue with displaying the number of negative tests and people tested" but that no other metrics were effected. The values for **Total tests (people)**, and the `Negative` field in the API, were carried over and will be updated if they become available.On November 12, 2020, Kansas’s **Total tests (people)** and `Negative` decreased without explanation.On October 21, 2020, the **Currently in Icu** value for KS dropped from 81 to 1 on the state's dashboard. We recorded it, but expect it to be revised at another point. On July 15, 2020, Kansas began reporting additional data from hospitals, and at that time, data for the **Now hospitalized** metric was only available through July 10.From July 1–July 3, 2020, we reported incorrect numbers for Kansas **Cases or Confirmed cases**. We have corrected the error.As of May 7, 2020, **confirmed and probable cases** are included in the case totals. https://www.coronavirus.kdheks.gov/160/COVID-19-in-Kansas https://public.tableau.com/views/COVID-19TableauVersion2/HospitalCapacity?%3Aembed=y&%3AshowVizHome=no https://public.tableau.com/views/COVID-19TableauVersion2/TestingRates?%3Aembed=y&%3AshowVizHome=no https://public.tableau.com/views/COVID-19TableauVersion2/HospitalSummary?%3Aembed=y&%3AshowVizHome=no   http://www.kdheks.gov/coronavirus/ People posNeg posNeg All data false Kansas 20
20 KY On December 24, 2020, December 25, 2020, December 31, 2020 and January 1, 2021, Kentucky did not update their data by the time of our daily update, presumably due to the holidays.On November 26, 2020, Kentucky did not update their data by the time of our daily update, presumably due to the Thanksgiving holiday.On November 12, 2020, Kentucky began reporting **Currently on ventilator** in their [COVID-19 Daily Summaries](https://covid-tracking-project-data.s3.us-east-1.amazonaws.com/state_screenshots/KY/KY-tertiary-20201112-172508.pdf).On November 7, 2020, Kentucky [reported](https://chfs.ky.gov/cvdaily/COVID19DailyReport1107.pdf) that "due to a keystroke error, the PCR and total tested figures were incorrectly reported on 11/6/2020." This caused our **Total PCR tests (specimens)** to go up by ~168k on November 6, and to go down by ~130k on November 7. If we find an official source with a corrected value we will backfill it.As of September 18, 2020, Kentucky's total test results are drawn from our `totalTestsViral` field instead of calculated via positive+negative.As of May 27, 2020, Kentucky reports antibody tests separately from PCR tests. On May 23, 2020, Kentucky revised down the state's figure for **Total tests**. https://govstatus.egov.com/kycovid19 https://chfs.ky.gov/agencies/dph/covid19/COVID19DailyReport.pdf       https://chfs.ky.gov/agencies/dph/Pages/covid19.aspx Specimens totalTestsViral Total Tests (PCR) All data false Kentucky 21
21 LA Louisiana reports probable deaths on a weekly basis.Negative test results reported in our API and CSVs are calculated by subtracting **Confirmed cases** from **Total tests (PCR)** in the absence of better data.On February 16, 2021, Louisiana announced that there would be no update to their data due to Mardi Gras.On February 10, 2021, Louisiana [announced](https://twitter.com/LADeptHealth/status/1359562769205522436?s=20) that due to a processing error, the day's case and test counts are incomplete.On February 7, 2021, Louisiana [noted](https://twitter.com/LADeptHealth/status/1358475247410905091?s=20) on its Department of Health's twitter that "due to a technical issue, today’s reported case and test counts only include one day of data. Because of the daily removal of newly identified duplicates and out of state cases, the new case increase may not match the difference between today’s and yesterday's total case count." Subsequently, on February 8, 2021, Louisiana [noted](https://twitter.com/LADeptHealth/status/1358838000961134593?s=20) that case and test counts reported on February 8, 2021 included two days of data.On January 24, 2021, Louisiana [announced](https://twitter.com/ladepthealth/status/1353399882674016256?s=21) via the official Louisiana Department of Health twitter that the data reported on January 24, 2021 would only include lab reports from January 23, 2021. The remainder of the data that would normally have been reported on January 24, 2021 will be included in the data for January 25, 2021. On January 17, 2021, Louisiana announced that their deaths reflected deaths reported to the Louisiana Department of Health since January 14, 2021.On January 15, 2021, Louisiana announced on their [COVID-19 Dashboard](https://ldh.la.gov/coronavirus/) that deaths will not be updated due to a system error. As a result, we were unable to update Deaths (confirmed and probable), Deaths (confirmed), and Deaths (probable).On January 14, 2021, Louisiana announced that their data included a backlog of 916 cases dating back … http://ldh.la.gov/Coronavirus/         http://ldh.la.gov/Coronavirus/ Specimens posNeg posNeg Only positives false Louisiana 22
22 MA Negative test results reported in our API and CSVs are calculated by subtracting **Confirmed cases** from **Total PCR tests (people)**.On December 25, 2020, Massachusetts announced on their [COVID-19 page](https://www.mass.gov/info-details/covid-19-response-reporting) that there would be no update to their data on December 25, 2020, or on January 1, 2021. Additionally, they noted that data reported on December 26, 2020 and January 2, 2021 would each include two days of data.On November 26, 2020, Massachusetts announced on their COVID-19 page that there would be no update to their data on November 26, 2020 due to the the Thanksgiving holiday. Additionally, they announced that the data for November 27, 2020 would include both the data for November 26, 2020 and November 27, 2020.On November 25, 2020, Massachusetts reported that their data “was delayed today due to a technological issue that resulted in an interruption of the data download. As a result, today’s numbers reflect case counts from up to a 30 hour period" instead of the usual previous 24-hour period.As of November 2, 2020, Massachusetts’ **Currently Hospitalized**, **Currently in ICU**, and **Currently on Ventilator** figures include only confirmed cases. Previously these numbers included confirmed and probable hospitalizations.As of September 11, 2020, Massachusetts’ total test results reflect total specimens. The number of unique people tested is available in our API as `totalTestsPeopleViral`.On September 2, 2020, MA [reported](https://www.mass.gov/doc/covid-19-dashboard-september-2-2020/download) that it had shifted to using the more restrictive August 6 definition of probable cases released by the CSTE. This change caused a significant decrease in several data points where probable cases or probable deaths were included, particularly the overall case count, which dropped by more than 7,000. Historical data was also affected. On August 31, 2020 we updated Massachusetts' **Total PCR Tests (specimens)** before August 12, 2020 based on the state's "Tests… https://www.mass.gov/doc/covid-19-dashboard-march-1-2021/download https://www.mass.gov/doc/weekly-covid-19-public-health-report-march-1-2021/download       https://www.mass.gov/resource/information-on-the-outbreak-of-coronavirus-disease-2019-covid-19 Specimens totalTestsViral Total Tests (PCR) Only positives false Massachusetts 25
23 MD As of October 16, 2020, Maryland’s total test results are drawn from our totalTestsViral field instead of calculated via positive+negative. This will result in TotalTestResults only going back to 3/24 instead of 3/5.On August 31, 2020, we updated Maryland's **Total PCR tests (specimens)** and **Positive PCR tests (specimens)** prior to 8/16 to match state-provided "Testing Volume" data.On July 31, 2020, we began capturing Maryland's data for **Positive PCR tests (specimens)**. Between March 12 and March 28, 2020, Maryland did not report data for **negative tests**. https://coronavirus.maryland.gov/ https://services.arcgis.com/njFNhDsUCentVYJW/arcgis/rest/services/MDCOVID19_TestingVolume/FeatureServer/0/query?where=1%3D1&outFields=*&outStatistics=[%7B%22statisticType%22%3A+%22sum%22%2C+%22onStatisticField%22%3A+%22number_of_positives%22%2C+%22outStatisticFieldName%22%3A+%22total_number_of_positives%22%7D] https://services.arcgis.com/njFNhDsUCentVYJW/arcgis/rest/services/MDCOVID19_SerologyTests/FeatureServer/0/query?where=1%3D1&outFields=%2A     https://phpa.health.maryland.gov/Pages/Novel-coronavirus.aspx Specimens totalTestsViral Total Tests (PCR) All data false Maryland 24
24 ME 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 December 25, 2020, Maine announced on their [COVID-19 page](https://www.maine.gov/dhhs/mecdc/infectious-disease/epi/airborne/coronavirus/data.shtml) that some of their data would not be updated between December 25, 2020 and December 27, 2020 due to the holiday. As a result, we were unable to update Maine’s testing and current hospitalization data on December 25, 2020, and unable to update any data on December 26, 2020.On December 9, 2020, Maine’s **Total Antigen Tests (specimens)** decreased by 248 on their COVID-19 page, which we believe was an error. The sum of **Positive Antigen Tests,** **Negative Antigen Tests,** and indeterminate antigen tests is 38,632 and Maine reported 36,632. In order to ensure that our data is as accurate as possible, we did not update Maine’s Total Antigen Tests (specimens) on December 9, 2020. (Antigen data is available in our CSVs and API.)On November 30, 2020, Maine’s Total antigen tests (specimens) and Negative antigen tests (specimens) increased by roughly 11,000, and their Positive antigen tests (specimens) increased by about 400 without explanation. On November 26, 2020, Maine announced on their COVID-19 page that there would only be partial updates to their data from November 26, 2020 to November 29, 2020 due to the Thanksgiving holiday. As a result, we were unable to update testing data, and current hospitalization data on November 26, 2020, and unable to update all data points except for Currently hospitalized, Currently in ICU, and Currently on ventilator on November 27, 2020.On November 11, 2020, Maine did not update testing and hospitalization data: only **Cases,** **Deaths,** and **Recovered** were updated.On November 2, 2020, Maine started reporting antigen and molecular tests separately on the state's dashboard.On June 23, 2020, Maine began reporting the dates of **cases**, **deaths**, **recoveries**,… https://www.maine.gov/dhhs/mecdc/infectious-disease/epi/airborne/coronavirus/data.shtml https://www.maine.gov/dhhs/mecdc/infectious-disease/epi/airborne/coronavirus/data.shtml https://www.maine.gov/dhhs/mecdc/infectious-disease/epi/airborne/coronavirus/data.shtml https://analytics.maine.gov/t/CDCExternal/views/covid-19-maine-cdc-dashboard-nav-buttons/1_Casetrendsbycounty?:embed=y&:showVizHome=no&:host_url=https%3A%2F%2Fanalytics.maine.gov%2F&:embed_code_version=3&:tabs=no&:toolbar=yes&:showAppBanner=false&:display_spinner=no&:loadOrderID=1 https://analytics.maine.gov/t/CDCExternal/views/covid-19-maine-cdc-dashboard-nav-buttons/1_Casetrendsbycounty?:embed=y&:showVizHome=no&:host_url=https%3A%2F%2Fanalytics.maine.gov%2F&:embed_code_version=3&:tabs=no&:toolbar=yes&:showAppBanner=false&:display_spinner=no&:loadOrderID=1 https://www.maine.gov/dhhs/mecdc/infectious-disease/epi/airborne/coronavirus.shtml Specimens posNeg posNeg Only positives false Maine 23
25 MI Michigan updates its **Recovered** metric weekly and does not update any data on Sundays.Our source for **Now hospitalized** and **Now in ICU** data in Michigan generally updates on Mondays and Fridays only. Michigan combines PCR and antigen tests in the total tests figure reported on the state's dashboard. Michigan does not update their COVID-19 data on Sundays. As a result, new referrals of confirmed cases to the MDSS regularly affect the Confirmed cases we report on Mondays and over the weekend.As of July 7, 2020, Michigan updates its death figures three times a week after conducting reviews of death certificates. As a result, "new" deaths may not always reflect deaths in the past 24 hours.On January 2, 2021, Michigan did not publish updated testing data by the time of our daily update. As a result, we were unable to update Total Antibody Tests, Total Tests (PCR), Positive Tests (PCR), Negative Tests (PCR), or Negative (People or Cases) on January 2, 2021.On December 23, 2020, Michigan announced via a [press release](https://www.michigan.gov/coronavirus/0,9753,7-406-98158-548250--,00.html) that their data would not be updated on December 24, 2020, December 25, 2020, December 31, 2020, or January 1, 2021 due to the holidays.On November 24, 2020, Michigan announced via a [press release](https://www.michigan.gov/coronavirus/0,9753,7-406-98158-545993--,00.html) that there would be no update to their data on November 26, 2020 due to Thanksgiving holiday. On November 27, 2020, the state resumed data reporting where case counts would include cases since Wednesday, November 25, 2020. The state estimated that the average number of cases across November 26 and November 27, 2020 would be 8,581 cases per day.On October 29, 2020, Michigan experienced connectivity issues resulting in some cases that would have been reported tomorrow to be reported today. This is due to the fact that the state has a strict 10AM cutoff for daily data reporting. This means the daily increase in cases encompasses more than one day's worth of da… https://www.michigan.gov/coronavirus/0,9753,7-406-98163_98173---,00.html https://www.michigan.gov/coronavirus/0,9753,7-406-98159-523641--,00.html https://www.michigan.gov/coronavirus/0,9753,7-406-98163_98173-531113--,00.html https://app.powerbigov.us/view?r=eyJrIjoiNDY0ZGVlMDItMzUzNC00ZGE5LWFjYzQtNzliOGJkZWQ4YTgzIiwidCI6ImQ1ZmI3MDg3LTM3NzctNDJhZC05NjZhLTg5MmVmNDcyMjVkMSJ9   https://www.michigan.gov/coronavirus Specimens totalTestsViral posNeg All data false Michigan 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       https://www.health.state.mn.us/diseases/coronavirus/index.html Encounters totalTestEncountersViral Total Test Encounters (PCR) All data false Minnesota 27
27 MO Negative test results reported in our API and CSVs are calculated by subtracting **Confirmed cases** from **Total PCR tests (people)**.On November 21, 2020, Missouri’s **Total PCR Tests (People)** increased by less than **Confirmed cases**. As a result, **Negative (People or Cases)** saw a decline from the previous day since it is calculated by subtracting **Confirmed cases** from **Total PCR tests (people)**.On November 10, 2020, Missouri’s Total PCR tests (specimens), Negative PCR tests (specimens), Total PCR tests (people), Total antibody tests (specimens), Total antibody tests (people), Negative antibody tests (specimens), Total antigen tests (specimens), and Negative antigen tests (specimens) dropped without explanation.On November 8, 2020, Missouri's **Total PCR Tests (specimens)** decreased from 2,672,288 to 2,654,691 with no explanation.On October 14, 2020, Missouri testing numbers by people decreased. This resulted in a decrease in all total testing numbers (people) and negative cases. Testing numbers by specimen are unaffected.On October 11, 2020, [Missouri announced that a database error had resulted in an “incorrect inflation” of cases in its October 10, 2020 report](https://www.kshb.com/news/coronavirus/missouri-covid-19-database-error-causes-incorrect-inflation-of-cases). When The COVID Tracking Project is able to obtain correct official data for October 10 from Missouri, we will update our dataset to reflect the correction.On October 8, 2020, Missouri added current hospitalizations to their COVID-19 dashboard, and we began to capture this metric. Historical data is also available and we are working on backfilling our data for days where this metric was unavailable.As of October 7, 2020, Missouri's total test results are drawn from our `totalTestsViral` field instead of calculated via positive+negative. The number of unique people tested is available in our API as `totalTestsPeopleViral`. On September 28, 2020, Missouri removed the Positive and Negative antibody tests (people) metrics from their das… https://showmestrong.mo.gov/data/statewide-public-health/ https://showmestrong.mo.gov/public-healthcare-testing/ https://showmestrong.mo.gov/public-healthcare/     https://health.mo.gov/living/healthcondiseases/communicable/novel-coronavirus/ Specimens totalTestsViral Total Tests (PCR) Only positives false Missouri 29
28 MP The Northern Mariana Islands have not posted a new **Recovered** number since July 15, 2020. Negative test results reported in our API and CSVs are calculated by subtracting **Confirmed cases** from **Total PCR tests (people)**.The Northern Mariana Islands **Total PCR tests (specimens)** values decrease occasionally without explanation. We suspect this is due to some sort of data quality assurance or de-deduplication.The Northern Mariana Islands provides irregular data updates, so changes in values often represent multiple days of data.On July 23, 2020, we switched our **Total tests** units to the people-tested metric reported by the Northern Mariana Islands, which led to a drop in total tests. We will backfill total tests data for the territory as soon as we are able to do so. https://cnmichcc.maps.arcgis.com/apps/opsdashboard/index.html#/4061b674fc964efe84f7774b7979d2b5 https://services8.arcgis.com/zkkZCub5I6ydvXQj/ArcGIS/rest/services/Coronavirus_PublicDashboardView/FeatureServer/3/query?where=1%3D1&outStatistics=%5B%7B%27statisticType%27%3A+%27max%27%2C+%27onStatisticField%27%3A+%27reportdt%27%7D%2C+%7B%27statisticType%27%3A+%27sum%27%2C+%27onStatisticField%27%3A+%27confirmedcases%27%7D%2C+%7B%27statisticType%27%3A+%27sum%27%2C+%27onStatisticField%27%3A+%27totalspeccnmi%27%7D%2C+%7B%27statisticType%27%3A+%27sum%27%2C+%27onStatisticField%27%3A+%27deaths%27%7D%2C+%7B%27statisticType%27%3A+%27sum%27%2C+%27onStatisticField%27%3A+%27recovered%27%7D%2C+%7B%27statisticType%27%3A+%27sum%27%2C+%27onStatisticField%27%3A+%27hospitalized%27%7D%5D https://cnmichcc.maps.arcgis.com/apps/opsdashboard/index.html#/4061b674fc964efe84f7774b7979d2b5 https://cnmichcc.maps.arcgis.com/apps/opsdashboard/index.html#/4061b674fc964efe84f7774b7979d2b5   https://www.chcc.gov.mp/coronavirusinformation.php People posNeg posNeg No Data false Northern Mariana Islands 69
29 MS Mississippi started updating testing totals on a weekly schedule on September, 27, 2020, so each update includes many days worth of testing. 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.From May 21, 2020 through May 26, 2020, we briefly captured Mississippi's Positive antibody tests (specimens) through state press conferences. As of May 26, 2020, Mississippi no longer reports this metric. On February 11, 2021, we cleared Mississippi's Positive antibody tests (specimens) timeseries to ensure that our data is as accurate and consistent as possible.On October 25, 2020, Mississippi announced that COVID-19 data for October 24, 2020 and October 25, 2020 would be published on Monday. As a result, Mississippi did not update on October 24, 2020 and October 25, 2020.On September 15, 2020, Mississippi resumed reporting current hospitalizations, ICU, and ventilations on the source we have historically used for this metric. We are working to backfill these data points in our historical data.On September 11, 2020, we discovered a new source for Mississippi current hospitalizations and current ICU admissions on the Mississippi State Department of Health website.Between June 17 and June 22, 2020, Mississippi experienced technical difficulties with their reporting system. We filled in five days of **case** and **death** data on June 22, 2020.On May 26, 2020, news reports indicated that 95 antibody tests had returned positive in Mississippi, but we have not found more recent data since then for this metric.As of May 23, 2020, Mississippi is separating out PCR and antibody tests. We now report both separately. https://msdh.ms.gov/msdhsite/_static/14,0,420.html https://msdh.ms.gov/msdhsite/_static/14,21994,420,873.html       https://msdh.ms.gov/msdhsite/_static/14,0,420.html Specimens posNeg posNeg Only positives false Mississippi 28
30 MT 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. Prior to January 27, 2021, it was calculated by subtracting **Cases (confirmed + probable)** from **Total PCR tests (specimens)**On February 25, 2021, Montana’s Confirmed cases decreased by 83 without explanation.On February 24, 2021, Montana’s **Confirmed cases** decreased by 117 without explanation.On January 27, 2021, we discovered that the **Confirmed cases** figure we had been capturing for Montana included both confirmed and probable cases, and cleared their **Confirmed cases** timeseries from April 30, 2020 through January 26, 2021 as a result. Beginning on January 27, 2021, we will capture **Confirmed cases** and **Probable cases** from the demographics tab of their dashboard, and will backfill our timeseries as we are able to.On December 25, 2020, Montana announced on their [COVID-19 dashboard](https://montana.maps.arcgis.com/apps/MapSeries/index.html?appid=7c34f3412536439491adcc2103421d4b) that there would be no update to their data on December 25, 2020, or on January 1, 2021 due to the holidays. We were able to update Currently in ICU and Currently on Ventilator from Montana's separate [hospitalization source](https://dphhs.mt.gov/publichealth/cdepi/diseases/coronavirusmt/demographics).On December 14, 2020, Montana announced that due to updates to their data reporting system on December 13, 2020, no new cases could be reported on December 13, 2020. We were unable to update Cases (confirmed + probable) and Negative PCR tests (people) on December 14, 2020.On November 16, 2020, Montana’s Confirmed cases increased by more than their Total PCR tests (specimens) without explanation. As a result Negative test results which are calculated by subtracting Confirmed cases from Total PCR tests (specimens) decreased.On November 8, 2020, Montana's reported **Recovered** value decreased by 32 with no explanation. https://montana.maps.arcgis.com/apps/MapSeries/index.html?appid=7c34f3412536439491adcc2103421d4b https://dphhs.mt.gov/publichealth/cdepi/diseases/coronavirusmt/demographics https://dphhs.mt.gov/Portals/85/publichealth/documents/CDEpi/DiseasesAtoZ/2019-nCoV/Status%20Update%20Data%20Report_2282021.pdf     https://dphhs.mt.gov/publichealth/cdepi/diseases/coronavirusmt Specimens totalTestsViral posNeg All data false Montana 30
31 NC The metric reported in our API as `totalTestsAntigen` only includes tests reported after September, 22, 2020. If previous values become available from North Carolina we will backfill the complete time series. 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 28, 2021, North Carolina [noted](https://covidtracking.com/screenshots/NC/NC-20210228-115701.png) that its data dashboards would not update on that day in order to make changes to improve system performance.On February 3, 2021, the North Carolina Department of Health and Human Services [reported](https://twitter.com/ncdhhs/status/1357052211252068354) that the day's case counts were much larger than usual because of the inclusion of a backlog of nearly 8,000 cases identified at FastMed clinics during December 2020 and January 2021. On January 18, 2021, North Carolina announced on their [COVID-19 dashboard](https://covid19.ncdhhs.gov/dashboard) 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 January 13, 2021, North Carolina reported that technical issues occurring on January 12, 2021 prevented processing of case and testing data into their COVID reporting system. As a result, case and testing data reported on January 13, 2021 are lower than they would have been had all the data been processed, and case and testing data on January 14, 2021 will be increased, since it will include the previous day's data.On December 30, 2020, North Carolina announced on its [dashboard](https://covid19.ncdhhs.gov/dashboard) that due to holiday-related disruptions and technical issues, data reported on December 30, 2020 was artificially higher than usual and includes 36 hours of data, while data reported on December 31, 2020 was artificially lower than usual and includes only 12 hours of data.On December 24, 2020, North Carolina announced on their COVID-19 dashboard that the… https://www.ncdhhs.gov/covid-19-case-count-nc https://files.nc.gov/covid/documents/dashboard/Weekly-COVID19-Patients-Presumed-to-be-Recovered.pdf https://public.tableau.com/views/NCDHHS_COVID-19_Dashboard_HospitalizationsE/Hospitalizations?:embed=y&:showVizHome=no&:host_url=https%3A%2F%2Fpublic.tableau.com%2F&:embed_code_version=3&:tabs=no&:toolbar=no&:animate_transition=yes&:display_static_image=no&:display_spinner=no&:display_overlay=yes&:display_count=no&:language=en&publish=yes&:loadOrderID=0 https://public.tableau.com/views/NCDHHS_COVID-19_Dashboard_Cases_County/NCDHHS_Dashboard_Cases2?:embed=y&:showVizHome=no&:host_url=https%3A%2F%2Fpublic.tableau.com%2F&:embed_code_version=3&:tabs=no&:toolbar=no&:animate_transition=yes&:display_static_image=no&:display_spinner=no&:display_overlay=yes&:display_count=yes&:language=en&publish=yes&:loadOrderID=0   https://www.ncdhhs.gov/divisions/public-health/coronavirus-disease-2019-covid-19-response-north-carolina Specimens posNeg posNeg Only positives false North Carolina 37
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         https://www.health.nd.gov/diseases-conditions/coronavirus Encounters totalTestEncountersViral Total Test Encounters (PCR) @NDDOH false North Dakota 38
33 NE Nebraska combines PCR and antigen tests in the total tests figure reported on the state's dashboard, and thus antigen tests are included in our "Total Tests (PCR)" metric. Nebraska's cumulative data values often decrease without explanation, likely due to deduplication or other data corrections.Nebraska’s **Recovered** numbers occasionally decrease without explanation.On January 20, 2021, Nebraska reported that its dashboard would be down until “later in the week” due to system maintenance. The Nebraska Department of Health reported **Deaths** and **Now hospitalized** values manually.On January 13, 2021, Nebraska’s Recovered decreased by 1864 without explanation.On January 9, 2021, Nebraska’s Deaths (confirmed + probable) decreased by 78 without explanation.On January 3, 2021, Nebraska’s **Recovered** value decreased by nearly 4,000 without explanation.On December 26, 2020, Nebraska’s **Ever hospitalized** decreased by 3, their Recovered decreased by 4265, and their Deaths (confirmed + probable) decreased by 10 without explanation.On November 13, 2020, Nebraska's cumulative hospitalized count dropped by 21 without explanation.On November 6, 2020, Nebraska removed 114 recoveries without explanation.On October 30, 2020, we backfilled the full time series for Nebraska's Total Tests into our "Total Tests (PCR)" metric from a Nebraska GIS query. At the same time, we filled our Positive Tests (PCR) and Negative Tests (PCR) from the same query.On September 20, 2020, Nebraska started publishing **Total Tests (in specimens)** in addition to **People Tested (in people)**, and we started collecting the Total Tests daily into our Total Tests (PCR) metric.On November 22, 2020, Nebraska's **Recovered** metric dropped from 56,605 to 16,068 without explanation. https://experience.arcgis.com/experience/ece0db09da4d4ca68252c3967aa1e9dd https://gis.ne.gov/enterprise/rest/services/Covid19MapV5/MapServer/11/query?where=1%3D1&outFields=%2A&orderByFields=LAB_REPORT_DATE+desc&resultRecordCount=1&f=json https://experience.arcgis.com/experience/ece0db09da4d4ca68252c3967aa1e9dd https://experience.arcgis.com/experience/ece0db09da4d4ca68252c3967aa1e9dd https://experience.arcgis.com/experience/ece0db09da4d4ca68252c3967aa1e9dd http://dhhs.ne.gov/Pages/Coronavirus.aspx Specimens totalTestsViral Total Tests (PCR) All data false Nebraska 31
34 NH Negative test results reported in our API and CSVs are calculated by subtracting **Confirmed cases** from **Total PCR tests (people)**.On March 1, 2021, New Hampshire's **Total PCR Tests (people)** decreased by 563 without explanation. This in turn affected **Negative PCR tests (people)**, which is calculated as **Total PCR Tests (people)** minus **Confirmed cases**.On February 8, 2021, New Hampshire's **Total antigen tests (specimens)** decreased by 102 without explanation.On January 10, 2021, New Hampshire’s **Total antigen tests (specimens)** increased by 41167 without explanation.On January 1, 2021, New Hampshire did not update their COVID-19 data by the time of our daily update.On December 26, 2020, we began capturing New Hampshire's "Antigen Positive" cases as **Probable cases** instead of **Positive antigen tests (people)** and revised its historical numbers so that **Confirmed cases** reflected only PCR positives. We also modified *Negative (people or cases)* to subtract these confirmed cases. Because negatives are calculated from lumped figures including antigen before November 20, negatives are artificially high on that day.On December 25, 2020, New Hampshire did not update their data, presumably due to the Christmas holiday.On November 13, 2020, New Hampshire announced: "The Dashboard Service is currently undergoing system maintenance and will be restored by November 16, 4:00 PM EST." This means **Total tests (in specimens)**, **Ever hospitalized**, **Ever in ICU**, and **Total Antibody Tests** will not be updated during this time.As of September 18, 2020, New Hampshire's total test results are drawn from our `totalTestsViral` field instead of calculated via positive+negative. The number of unique people tested is available in our API as `totalTestsPeopleViral`.On September 9, 2020, New Hampshire did not update their dashboards or summary report by the time of our update. On September 2, 2020, New Hampshire did not update their dashboards or summary report by the time of our update.As of May 25, 2020,… https://www.dhhs.nh.gov/dphs/cdcs/2019-ncov.htm https://www.nh.gov/covid19/documents/case-summary.pdf https://www.nh.gov/covid19/dashboard/overview.htm#dash https://nh.gov/t/DHHS/views/COVID19TrendsDashboard/TrendsDashboard?:isGuestRedirectFromVizportal=y&:embed=y   https://www.dhhs.nh.gov/dphs/cdcs/2019-ncov.htm Specimens totalTestsViral Total Tests (PCR) All data false New Hampshire 33
35 NJ The **Recovered** data point we report for New Jersey 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)**.New Jersey does not update their **Total PCR tests (specimens)** everyday. If **Total PCR tests (specimens)** is not updated, we are unable to update their **Negative PCR tests (specimens)**, which is calculated as **Total PCR tests (specimens)** minus **Confirmed cases**.On February 8, 2021, New Jersey [reported](https://twitter.com/GovMurphy/status/1358841345859870721) that today's data is artificially low due to electronic lab reporting issues. Data reported on February 9, 2021 is expected to correct the backlog.On January 15, 2021, New Jersey’s Probable cases decreased from 59,881 to 31,717 on their [data dashboard](https://covid19.nj.gov/#live-updates) without explanation. We believe this decrease may have been a mistake and sourced this data point from the [underlying data layer](https://services7.arcgis.com/Z0rixLlManVefxqY/arcgis/rest/services/DailyCaseCounts/Feat[…]27%2C+%27onStatisticField%27%3A+%27TOTAL_AG_CASES%27%7D%5D) (today's value is 60,791) in order to avoid the decrease.On January 8, 2021 New Jersey’s Probable cases increased from 53,967 to 72,123 without explanation. This affected their Cases (confirmed + probable), which is calculated as Confirmed cases plus Probable cases in the absence of an explicit total case number. On January 9, 2021, their Probable cases decreased from 72,123 to 56,147. Because of this, we believe that the figure reported on January 8, 2021 was a mistake, and have corrected the number in our timeseries. On October 23, New Jersey's reported **Ever hospitalized** value increased dramatically from 24,517 to 37,222 with no explanation we could find: this was probably a one… https://covid19.nj.gov/#live-updates https://www.arcgis.com/apps/MapSeries/index.html?appid=c2efd1898e48452e83d7218329e953d7 https://njhealth.maps.arcgis.com/apps/opsdashboard/index.html#/81a17865cb1a44db92eb8eb421703635 https://services7.arcgis.com/Z0rixLlManVefxqY/arcgis/rest/services/PPE_Capacity/FeatureServer/0/query?where=survey_period%3E%3Dtimestamp+%272020-04-27+07%3A00%3A00%27+AND+structure_measure_identifier+LIKE+%27%25ischarge%25Excluding+Deaths%25%27&outStatistics=%5B%7B%27statisticType%27%3A+%27sum%27%2C+%27onStatisticField%27%3A+%27Value%27%2C+%27outStatisticFieldName%27%3A+%27recoveries%27%7D%5D   https://www.nj.gov/health/cd/topics/ncov.shtml Specimens posNeg posNeg All data false New Jersey 34
36 NM Negative test results reported in our API and CSVs are calculated by subtracting **Confirmed cases** from **Total PCR tests (people)**. On January 15, 2021, New Mexico’s **Total PCR tests (specimens)** decreased by approximately 13,000 without explanation.On November 18, 2020, we shifted the entire time series of New Mexico metrics by one day to match the date that the state reports on its dashboard. https://cvprovider.nmhealth.org/public-dashboard.html         https://cv.nmhealth.org/ Specimens posNeg posNeg All data false New Mexico 35
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   http://dpbh.nv.gov/coronavirus/ Encounters totalTestEncountersViral Total Test Encounters (PCR) All data false Nevada 32
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 https://www.health.ny.gov/diseases/communicable/coronavirus/ Encounters totalTestEncountersViral Total Test Encounters (PCR) Only positives false New York 36
39 OH Since February 10, 2021, Ohio has been reconciling their death data. As a result, death figures may fluctuate more than normal, and may include deaths which were not reported in the previous 24 hours. We urge caution when interpreting data from this period and encourage the use of 7 and 14-day averages as more reliable metrics. Our data quality team will continue to investigate how best to handle changes to their data.Ohio continually updates its **Currently hospitalized / Now hospitalized** data which can cause slight differences between their historic data and ours. On February 10, 2021, Ohio [announced](https://odh.ohio.gov/wps/portal/gov/odh/media-center/odh-news-releases/odh-news-release-02-10-20) that up to 4,000 COVID-19 deaths were underreported in the state’s reporting system and on their COVID-29 dashboard. These deaths will be added to their counts over the week on February 11, 2021. As a result, new deaths will be substantially higher than normal throughout this period. We urge caution when interpreting data from this period. Our data quality team will continue to investigate how best to handle the addition of these death. Approximately 650 of the deaths reported on February 11, 2021, 2500 of the deaths reported on February 12, 2021, and 1125 of the deaths reported on February 13, 2021 are a result of this reconciliation. On February 15, 2021, Ohio noted that they were continuing to reconcile deaths through a deep review of data which may result in fluctuations in death data.On January 6, 2021, we switched Ohio's `totalTestResults` to draw from `totalTestsViral` instead of by calculating from positive+negative. On December 29, 2020, Ohio provided a timeseries of Total Tests (PCR), Positive Tests (PCR), Total Antigen Tests, and Positive Antigen Tests. On January 6, 2021, we backfilled all 4 metrics from this download, which resulted in the addition of three new metrics (positive tests PCR, positive tests antigen, total tests antigen) and a full history for Total Tests (PCR).On December 25, 2020, Ohio a… https://coronavirus.ohio.gov/wps/portal/gov/covid-19/dashboards/overview/ https://coronavirus.ohio.gov/wps/portal/gov/covid-19/dashboards/key-metrics/cases https://coronavirus.ohio.gov/wps/portal/gov/covid-19/dashboards/key-metrics/hospitalizations     https://odh.ohio.gov/wps/portal/gov/odh/know-our-programs/Novel-Coronavirus/welcome/ Specimens totalTestsViral Total Tests (PCR) All data false Ohio 39
40 OK On February 27, 2021, Oklahoma's Total PCR Tests dropped by 3,314 without explanation.On February 11, 2021, Oklahoma announced via a [press release](https://oklahoma.gov/covid19/newsroom/2021/february/situation-update--covid-19-02-11-2021.html) that due to delayed reporting by facilities, and time taken to investigate previously deferred cases, the “majority” of new deaths reported on February 11, 2021 occurred in November, 2020.On February 3, 2020, the Oklahoma Department of Health [cautioned](https://twitter.com/healthyoklahoma/status/1357016405586178050?s=21) that the 52 deaths reported on this date occurred between January 4, 2021 and February 1, 2021, with 32 of them having occurred since January 27, 2021.On January 10, 2021, Oklahoma [noted](https://oklahoma.gov/covid19/newsroom/2021/january/state-department-of-health-comments-on-spike-in-covid-19-case-nu.html) that the rise in COVID-19 cases was in part due to a “decrease in testing and a less consistent reporting schedule over the holidays”. We urge caution when interpreting their data from this time period, and encourage the use of 7 and 14-day averages as more reliable figures than individual numbers. On December 27, 2020, we cleared Oklahoma's **Confirmed cases** field from October 19 onward. On September 8, 2020, Oklahoma [announced](https://oklahoma.gov/covid19/newsroom/2020/september/situation-update-covid-19-09082020.html) in a press release that it would transition to counting both confirmed and probable cases, instead of just confirmed cases. This change appears to have taken effect on October 19, 2020, when OK [stopped calling](https://oklahoma.gov/covid19/newsroom/2020/october/situation-update-covid-19-10192020.html) its cases "confirmed positive cases" in press releases, as it had before, switching the wording to "cases." On December 22, 2020, Oklahoma noted via a [press release](https://oklahoma.gov/covid19/newsroom/2020/december/osdh-releases-covid-19-reporting-cadence-for-upcoming-holidays.html) that there would be no update to their data … https://oklahoma.gov/covid19.html https://coronavirus.health.ok.gov/sites/g/files/gmc786/f/eo_-_covid-19_report_-_2-28-21.pdf https://coronavirus.health.ok.gov/sites/g/files/gmc786/f/2020.2.28_weekly_epi_report.pdf     https://coronavirus.health.ok.gov Specimens posNeg posNeg All data false Oklahoma 40
41 OR As of January 13, 2021, Oregon’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 8, 2021, we cleared the history of our confirmed and probable cases fields in Oregon. Before Oregon switched to reporting tests in units of specimens, we had used its figures for people testing positive to represent confirmed cases and subtracted that number from total cases to get probable cases. However, it turned out that Oregon's people tested figure included people testing positive with antigen, so the positive people tested figure did not accurately reflect confirmed cases.On January 29, 2021, Oregon [announced](https://twitter.com/ohaoregon/status/1355286471687745537?s=21) that their COVID-19 case database would be down “for server and file migration maintenance” on January 30, 2021, and as a result there would be no update to their data on January 31, 2021. Because Oregon’s data is on a one day lag in our timeseries due to late updates, we were unable to update their data on February 1, 2021.As of December 9, 2020, Oregon’s total test results are drawn from our `totalTestsViral` field instead of calculated via positive+negative. This change will cause Oregon’s `totalTestResults` to begin on March 29, 2020 instead of March 4, 2020. Because Oregon’s totalTestsViral represent only electronic laboratory reporting, whereas its cases and negatives represented tests from all sources, this change causes a decrease of 10,296 tests in `totalTestResults` on March 29. The old numbers remain available by summing the positive and negative fields of our API.In addition, Oregon has not reported their total tests in people units since December 2, 2020 and they indicated that they will not continue to report total tests in people, so we have removed any values in **Total PCR tests (people)** we previously carried over.On December 3, 2020, Oregon removed its total people tested metric, after adding total specimens on December 1. Because they did not p… https://www.oregon.gov/oha/PH/DISEASESCONDITIONS/DISEASESAZ/Pages/emerging-respiratory-infections.aspx https://public.tableau.com/profile/oregon.health.authority.covid.19#!/vizhome/OregonCOVID-19Update/CaseandTesting https://public.tableau.com/profile/oregon.health.authority.covid.19#!/vizhome/OregonCOVID-19TestingandOutcomesbyCounty/OregonsCOVID-19TestingandOutcomesbyCounty?:display_count=y&:toolbar=n&:origin=viz_share_link&:showShareOptions=false https://public.tableau.com/profile/oregon.health.authority.covid.19#!/vizhome/OregonCOVID-19Update/HospitalCapacity   https://www.oregon.gov/oha/PH/DISEASESCONDITIONS/DISEASESAZ/Pages/emerging-respiratory-infections.aspx Specimens totalTestsViral Total Tests (PCR) All data false Oregon 41
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       https://www.health.pa.gov/topics/disease/Pages/Coronavirus.aspx Encounters totalTestEncountersViral Total Test Encounters (PCR) Only positives false Pennsylvania 42
43 PR Reported **Deaths** include both confirmed and probable COVID-19 deaths.Puerto Rico does not report test data on its data dashboard. Data for **Total PCR Tests (in specimens)** and **Positive PCR Tests (in specimens)** is taken from infrequent press reports. The most recent test data for Puerto Rico is taken from a [Departamento de Salud press release](https://github.com/COVID19Tracking/issues/files/5307568/Actualizacion.de.los.resultados.de.las.pruebas.moleculares.y.serologicas.para.Covid-19.registradas.en.Bioportal.del.Depto.de.Salud.pdf) from August 28, 2020. Puerto Rico’s **Recovered** numbers occasionally decrease without explanation. We suspect this is due to some sort of data quality assurance or de-deduplication.On November 7, 2020, Puerto Rico switched from using antibody tests to antigen tests to identify probable cases in accordance with August 2020 CSTE guidelines. This caused probable cases to drop by 33,888. We cleared the history of our **Probable Cases** field to match the new definition. We also modified our **Cases (confirmed + probable)** field to remove probables identified via antibody from April 24, 2020 onward, when we have access to a breakdown.On November 2, 2020, Puerto Rico removed 551 recoveries without explanation.On July 7, 2020, we updated **Negative PCR tests** based on press releases from May and June.On May 6, 2020, Puerto Rico stopped reporting **Negative PCR tests**.On April 22, 2020, Puerto Rico's data changed due to deduplication. This resulted in a decrease in **Total cases**. https://services5.arcgis.com/klquQoHA0q9zjblu/ArcGIS/rest/services/Datos_Totales_View7/FeatureServer/0/query?where=1%3D1&outFields=T_Muertes_COVID_RD%2CT_Fatalidades%2CT_Muertes_Combinadas%2CT_Pacientes_Int_Covid%2CT_Vent_Covid%2CT_Serologicos_Pos%2CT_Casos_Unicos%2CT_Molecular_Pos%2CT_Fatalidades%2CT_Hospitalizados%2CT_Recuperados https://bioseguridad.maps.arcgis.com/apps/opsdashboard/index.html#/3bfb64c9a91944bc8c41edd8ff27e6df http://www.salud.gov.pr/Pages/coronavirus.aspx https://services5.arcgis.com/klquQoHA0q9zjblu/ArcGIS/rest/services/Datos_Totales_View7/FeatureServer/0/query?where=1%3D1&outFields=T_Muertes_COVID_RD%2CT_Muertes_Combinadas%2CT_Pacientes_Int_Covid%2CT_Vent_Covid%2CT_Serologicos_Pos%2CT_Casos_Unicos%2CT_Molecular_Pos%2CT_Fatalidades%2CT_Hospitalizados   http://www.salud.gov.pr/Pages/coronavirus.aspx Specimens posNeg posNeg No Data false Puerto Rico 72
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     https://health.ri.gov/diseases/respiratory/?parm=163 Encounters totalTestEncountersViral Total Test Encounters (PCR) All data false Rhode Island 44
45 SC 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 23, 2021 through March 1, 2021, South Carolina’s Recovered metric was absent from their data dashboard, potentially due to [technical issues](https://twitter.com/scdhec/status/1364619613313634304). As a result, we were unable to update their Recovered.On February 23, 2021, South Carolina’s testing and recovery data was not available from their [dashboard](https://scdhec.gov/covid19/south-carolina-county-level-data-covid-19) due to [“technical issues”](https://twitter.com/scdhec/status/1364619613313634304) As a result, we were unable to update their testing data on February 23, 2021.On February 5, 2021, South Carolina [announced](https://twitter.com/scdhec/status/1357822265258369027) via the official South Carolina Department of Health and Environmental Control twitter that roughly 29,000 positive and negative test results from December 22, 2020 through January 16, 2021 would be included in their data. This backlog will account for approximately 23,000 Negative PCR tests (specimens) and 3500 cases reported on February 5, 2021.On February 1, 2021, South Carolina [announced](https://twitter.com/scdhec/status/1356322670170746888) via the official South Carolina Department of Health and Environmental control twitter that due to a vital statistics system update, they were reporting over 240 Deaths (confirmed + probable) from the last several weeks. As a result, not all new deaths reported on February 1, 2021 were identified in the previous 24 hour period.On January 28, 2021, South Carolina [announced](https://twitter.com/scdhec/status/1354893317398556673) via the official South Carolina Department of Health and Environmental control twitter that due to a vital statistics system update, they were reporting over 230 Deaths (confirmed + probable) from the last several weeks. As a result, not all new deaths reported on January 28, 2021 were ident… https://scdhec.gov/health/infectious-diseases/viruses/coronavirus-disease-2019-covid-19/monitoring-testing-covid-19 https://www.scdhec.gov/infectious-diseases/viruses/coronavirus-disease-2019-covid-19/sc-demographic-data-covid-19 https://www.scdhec.gov/infectious-diseases/viruses/coronavirus-disease-2019-covid-19/hospital-bed-capacity-covid-19 https://scdhec.gov/infectious-diseases/viruses/coronavirus-disease-2019-covid-19/south-carolina-county-level-data-covid-19 https://public.tableau.com/views/MainDashboard_15964746061440/Testing?%3Aembed=y&%3AshowVizHome=no&%3Ahost_url=https%3A%2F%2Fpublic.tableau.com%2F&%3Aembed_code_version=3&%3Atabs=no&%3Atoolbar=no&%3Aanimate_transition=no&%3Adisplay_static_image=no&%3Adisplay_spinner=no&%3Adisplay_overlay=no&%3Adisplay_count=yes&%3Alanguage=en&publish=yes&%3AloadOrderID=2 https://scdhec.gov/health/infectious-diseases/viruses/coronavirus-disease-2019-covid-19 Specimens posNeg posNeg All data false South Carolina 45
46 SD On February 11, 2021, South Dakota [announced](https://twitter.com/SDDOH/status/1359925746219814916?s=20) on the official South Dakota Department of Health twitter that “a large number of COVID-19 test results are reported in today’s update due to IT system updates completed on one of several reporting methods”. As a result, not all new tests reported on February 11, 2021 were reported in the previous 24 hour period.On December 24, 2020, South Dakota [announced](https://twitter.com/SDDOH/status/1342173217918746626) via the official South Dakota Department of Health twitter that there would be no update to their data on December 25, 2020 due to the holiday. Additionally, they noted that the data reported on December 26, 2020, would be the data which normally would have been reported on December 25, 2020, and the data reported on December 27, 2020 would include two days of data. On December 31, 2020, they noted that there would be no update to their data on January 1, 2021 due to the New Years holiday, and that the data reported on January 2, 2021, would be the data which normally would have been reported on January 1, 2021, and the data reported on January 3, 2021 would include two days of data.On November 26, 2020, South Dakota [announced](https://twitter.com/SDDOH/status/1332017785560576001?ref_src=twsrc%5Egoogle%7Ctwcamp%5Eserp%7Ctwgr%5Etweet) via the official South Dakota Department of Health twitter that there would be no update to their data on November 26, 2020. Additionally, data for both November 26, 2020 and November 27, 2020, will be published on November 27, 2020.On October, 7, 2020 South Dakota started reporting **Probable cases**. This added 473 new cases to South Dakota's **Total cases** number.As of September 18, 2020, South Dakota's total test results are drawn from our `totalTestsPeopleViral` field instead of calculated via positive+negative.On August 27, the South Dakota Department of Health included cases from August 25 and 26 in their update due to a reporting aberration, resulting in a 343 ca… https://doh.sd.gov/COVID/Dashboard.aspx         https://doh.sd.gov/news/Coronavirus.aspx People totalTestsPeopleViral Total PCR Tests (People) All data false South Dakota 46
47 TN 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.Tennessee continually updates its **Currently hospitalized / Now hospitalized** data which can cause differences between their historic data and ours. As of March 1, 2021, Tennessee's `totalTestResults` field is taken directly from `totalTestsViral` instead of calculated from positive + negative. We backfilled the data for March 24, 2020 through March 1, 2021 using the time-series posted in Tennessee's [Downloadable Datasets](https://www.tn.gov/health/cedep/ncov/data/downloadable-datasets.html). We also cleared the history of Negative (people or cases) since it was calculated using mixed units.On January 1, 2021, the Tennessee Department of Health [announced](https://twitter.com/TNDeptofHealth/status/1345117770543996940?s=20) that its update for January 2, 2021 would include data from both January 1 and January 2, presumably because of the holiday. We were able to update **Now hospitalized** from Tennessee’s separate [hospitalization source](https://www.tn.gov/health/cedep/ncov/data/hospitalization-data/current-covid-hospitalizations.html).On December 25, 2020, Tennessee did not provide a data update, likely due to the holiday. We were able to update **Now hospitalized** from Tennessee’s separate [hospitalization source](https://www.tn.gov/health/cedep/ncov/data/hospitalization-data/current-covid-hospitalizations.html). Additionally, they [noted](https://twitter.com/TNDeptofHealth/status/1342952651022086147) that the data reported on December 26, 2020, included two days of data, and that the number of deaths reported were “limited” due to the holiday.On December 19, 2020, Tennessee announced that due to the volume of tests being processed they will likely release a combined report with data from both December 19, 2020 and December 20, 2020 on December 20, 2020. As a result, we were unable to update their data on December 20, 2020.On December 12, 20… https://www.tn.gov/health/cedep/ncov.html https://apps.health.tn.gov/AEM_embed/TDH-2019-Novel-Coronavirus-Epi-and-Surveillance.pdf#toolbar=0 https://data.tn.gov/t/Public/views/HospitalizedPatients/HospitalizedPatients?:embed=y     https://www.tn.gov/health/cedep/ncov.html Specimens totalTestsViral Total Tests (PCR) Only positives false Tennessee 47
48 TX The Texas Department of State Health Services regularly includes older cases identified by labs in their cumulative confirmed case counts. As a result, new cases reported may not necessarily have occurred in the past 24 hour period. When these increases are significant, we will specifically mention them in our daily update on Twitter.On February 21, 2021, Texas’s Positive PCR tests (specimens) decreased by over 10,000 without explanation. Throughout the week, Texas has experienced multiple weather-related issues which have impacted their data reporting. We urge caution when interpreting data from this period.On February 20, 2021, Texas’s Total PCR tests (specimens) decreased by roughly 85,000 without explanation. Throughout the week, Texas has experienced multiple weather-related issues which have impacted their data reporting. We urge caution when interpreting data from this period.During the week of February 17, 2021, Texas experienced several weather-related issues and power outages which affected their data reporting. They [noted](https://twitter.com/TexasDSHS/status/1362111931578945538?s=20) via the official Texas Department of State Health Services Twitter that new cases will be “artificially low” until the reporting resumes normally. On February 15, 2021 through February 18, 2021, they could not update their testing data due to outages. As a result, we were unable to update their testing data on these dates. We urge caution when interpreting data from this period.On December 29, 2020, Texas noted that “New cases reported today (12/29) may include several days of cases for some counties as some local health departments did not report over the holiday weekend.As of December 15, 2020, Texas’s total test results are drawn from our `totalTestsViral` field instead of calculated via positive+negative. On December 14 2020, we backfilled the full time series of **Total PCR tests (specimens)**, **Positive PCR tests (specimens)** from data available on [Texas ArcGis Layer](https://services5.arcgis.com/ACaLB9ifngzawsp… https://txdshs.maps.arcgis.com/apps/opsdashboard/index.html#/ed483ecd702b4298ab01e8b9cafc8b83 https://services5.arcgis.com/ACaLB9ifngzawspq/ArcGIS/rest/services/TX_DSHS_COVID19_Test[…]&outFields=%2A&orderByFields=Date+desc&resultRecordCount=1 https://www.dshs.texas.gov/coronavirus/TexasCOVID-19HospitalizationsOverTimebyTSA.xlsx https://txdshs.maps.arcgis.com/apps/opsdashboard/index.html#/0d8bdf9be927459d9cb11b9eaef6101f   https://dshs.texas.gov/coronavirus/ Specimens totalTestsViral Total Tests (PCR) Only positives false Texas 48
49 UT On February 12, 2021, we cleared the history of Utah's **Confirmed cases** field, which we previously filled using data from its positive people tested via PCR number. Utah does not present this figure as confirmed cases and instead calls its main case number, which includes both PCR and antigen tests, "lab-confirmed cases." We did not duplicate Utah's main case number into Confirmed cases to replace this positive PCR individuals number because the definition the state uses for "confirmed" is not in accordance with CSTE definitions.On December 25, 2020, Utah did not update their data by the time of our daily update, presumably due to the Christmas holiday.On November 25, 2020, Utah [announced](https://twitter.com/UtahCoronavirus/status/1331703634942451715) via their official Utah COVID-19 response twitter that there would be no update to their data on November 26, 2020. Additionally, the data that would normally have been published on November 26, 2020 will be included in the November 27, 2020 update.As of November 9, 2020, our **Confirmed cases** metric for Utah is sourced from the data download available on the [Utah dashboard](https://coronavirus-dashboard.utah.gov/), which separates PCR and antigen tests. This caused a slight decrease in the number of **Confirmed Cases**.As of November 6, 2020, our **Total PCR tests (people)** and **Negative PCR tests (people)** metrics for Utah are sourced from the data download available on the [Utah dashboard](https://coronavirus-dashboard.utah.gov/), which separates PCR and antigen tests.As of October 28, 2020, our **Total PCR tests (specimens)** and **Positive PCR tests (specimens)** metrics for Utah are sourced from the data download available on the [Utah dashboard](https://coronavirus-dashboard.utah.gov/), which separates PCR and antigen tests. **Total PCR tests (specimens)** is calculated by adding positive and negative PCR tests from this [download](https://coronavirus-dashboard.utah.gov/Utah_COVID19_data.zip).As of October 29, 2020, Utah's `totalTestResults` field … https://coronavirus-dashboard.utah.gov/ https://coronavirus-dashboard.utah.gov/#hospitalizations-mortality       https://health.utah.gov/coronavirus Specimens totalTestsViral Total Tests (PCR) Only positives false Utah 49
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     http://www.vdh.virginia.gov/surveillance-and-investigation/novel-coronavirus/ Encounters totalTestEncountersViral Total Test Encounters (PCR) Positives + Negatives false Virginia 51
51 VI Total PCR tests in the Virgin Islands is the sum of **Positive PCR tests**, **Negative PCR tests**, and **Pending tests**.The Virgin Islands provides irregular data updates, so changes in values often represent multiple days of data. https://doh.vi.gov/covid19usvi         https://doh.vi.gov/ People posNeg posNeg Positives Only false US Virgin Islands 78
52 VT Negative test results reported in our API and CSVs are calculated by subtracting **Confirmed cases** from **Total PCR tests (people)**. On February 13, 2021 Vermont's reported **Total Tests (PCR)** declined from 961,542 to 958,666 without explanation.On February 02, 2021, Vermont reported a decrease in Total PCR Tests (specimens) of around 23K without explanation.On January 4, 2020, Vermont posted that "the numbers of COVID-19 deaths now includes deaths among probable cases since September 6, 2020." Due to this change we are unable to update the **Confirmed deaths** metric after January 4, 2020.On December 23, 2020, Vermont announced on their [COVID-19 page](https://www.healthvermont.gov/response/infectious-disease/2019-novel-coronavirus)that there would be no update to their data on December 24, 2020 or December 25, 2020. On January 1, 2020, they noted that there would be no update to their data on January 1, 2020. On December 23, 2020, Vermont reported more new **Confirmed cases** than new **Total PCR Tests (people)**, which caused a decrease in the value of **Negative PCR tests (people)** in our API.On December 4, 2020, Vermont provided a timeseries for both confirmed and probable cases. We backfilled **Total cases**, **Confirmed cases** and **Probable cases** and updated **Total Tests (in People)** and **Negative** to match the new confirmed series.On December 2, 2020, Vermont added approximately 120 cases to its case count, representing **Probable cases** since the beginning of September in the state (previously, the state had only reported PCR-confirmed cases). It provided a timeseries, and we backfilled our **Total cases** field to avoid the impression of an additional 120 case rise on December 2.On November 26, 2020, Vermont announced on their [COVID-19 page](https://www.healthvermont.gov/covid-19) that there would be no update to their data on November 26, 2020.On November 3, 2020, Vermont’s **Total PCR tests (people)** decreased without explanation. As a result, Vermont’s negative test results, which ar… https://experience.arcgis.com/experience/85f43bd849e743cb957993a545d17170 https://www.healthvermont.gov/response/coronavirus-covid-19/current-activity-vermont#dashboard       https://www.healthvermont.gov/response/infectious-disease/2019-novel-coronavirus Specimens totalTestsViral Total Tests (PCR) Positives + Negatives false Vermont 50
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   https://www.doh.wa.gov/Emergencies/Coronavirus Encounters totalTestEncountersViral Total Test Encounters (PCR) Positives + Negatives false Washington 53
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 https://www.dhs.wisconsin.gov/disease/covid-19.htm Encounters totalTestEncountersViral Total Test Encounters (PCR) All data false Wisconsin 55
55 WV West Virginia reports new antibody tests daily. We sum these numbers in a running total to report a value for the total number of antibody tests West Virginia has conducted. 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 July 4, 2020, West Virginia began making continual changes to its previous data for antibody testing, so its historical time series might not match the time series we collected.On May 23, 2020, West Virginia began reporting PCR and antibody tests separately. Total test values before this date might include both PCR and antibody tests.On April 16, 2020, West Virginia began reporting current hospitalization, ICU, and ventilator metrics from 49 of 55 counties. Before April 16, 2020, those counts were less complete, as they were based on completed investigations rather than on hospital data. https://dhhr.wv.gov/Coronavirus%20Disease-COVID-19/Pages/default.aspx https://dhhr.wv.gov/Coronavirus%20Disease-COVID-19/Pages/default.aspx https://dhhr.wv.gov/Coronavirus%20Disease-COVID-19/Pages/default.aspx https://dhhr.wv.gov/Coronavirus%20Disease-COVID-19/Pages/default.aspx   https://dhhr.wv.gov/Coronavirus%20Disease-COVID-19/Pages/default.aspx Specimens posNeg posNeg All data false West Virginia 54
56 WY As of February 13, 2021, Wyoming does not update their COVID-19 data on Saturdays.Wyoming’s metrics do not update every day, and don’t always update together. As a result, please exercise extra caution when using numbers that are calculated from daily changes, especially if these calculations use multiple metrics. If anomalies are observed, numbers from previous days will be carried over until corrections are made.Wyoming reports the number of people *Ever hospitalized* with COVID-19 as a percentage of “Lab Confirmed Cases by Reported Hospitalization” on their [Statistics page](https://health.wyo.gov/publichealth/infectious-disease-epidemiology-unit/disease/novel-coronavirus/covid-19-map-and-statistics/). In the absence of a better data source we convert this percentage to an integer, and as a result of the calculation, this value may fluctuate.Negatives reported in our API and CSVs are calculated by subtracting **Confirmed cases** from **Total PCR tests (people)**.On February 9, 2021, Wyoming’s Total PCR tests (specimens) fell from 704,836 to 595,970. We carried the previous day’s number as we believed this may have been an error. On February 10, 2021, we learned that the decrease was "Due to recent changes in reporting by commercial laboratories, some test results were being counted twice. Testing numbers have been corrected to reflect these changes therefore a decrease in the testing numbers will be observed for Non-WPHL labs. That decrease is attributed to the removal of duplicate tests being reported". As a result of this new information, we are backfilling our Total PCR tests (specimens) to reflect this new information and ensure that our data aligns as closely as possible with Wyoming's.On February 7, 2021, Wyoming’s **Confirmed cases** decreased by 36 and **Recovered** decreased by 2 with no explanation.On February 02, 2021, Wyoming’s Total PCR tests (specimens) decreased by roughly 4,600 and their Total PCR tests (people) decreased by approximately 1,500 without explanation. As a result, Negative PCR tes… https://health.wyo.gov/publichealth/infectious-disease-epidemiology-unit/disease/novel-coronavirus/ https://health.wyo.gov/publichealth/infectious-disease-epidemiology-unit/disease/novel-coronavirus/covid-19-map-and-statistics/ https://health.wyo.gov/publichealth/infectious-disease-epidemiology-unit/disease/novel-coronavirus/covid-19-testing-data/ https://sites.google.com/wyo.gov/exec-covid19/hospital-resources https://public.tableau.com/views/StateandCountyDashboard/Dashboard1?:embed=y&:showVizHome=no&:host_url=https%3A%2F%2Fpublic.tableau.com%2F&:embed_code_version=3&:tabs=no&:toolbar=yes&:animate_transition=yes&:display_static_image=no&:display_spinner=no&:display_overlay=yes&:display_count=yes&:language=en&publish=yes&:loadOrderID=0 https://health.wyo.gov/publichealth/infectious-disease-epidemiology-unit/disease/novel-coronavirus/ Specimens totalTestsViral Total Tests (PCR) No data false Wyoming 56

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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
);