COVID_COVID19Tracker: states_info: 31 rows where where covid19SiteTertiary = ""

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

31 rows where covid19SiteTertiary = ""

descending

This data as json, copyable, CSV (advanced)

Link	rowid ▼	state	notes	covid19Site	covid19SiteSecondary	covid19SiteQuaternary	twitter	covid19SiteOld	covidTrackingProjectPreferredTotalTestUnits	covidTrackingProjectPreferredTotalTestField	totalTestResultsField	name	fips	pum
4	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)	American Samoa	60	false
7	7	CO	On May 15, Colorado started reporting deaths for which COVID-19 is listed on the death certificate, in addition to the figure it already provided, deaths among laboratory-confirmed and probable cases (whether or not COVID was a cause of death). On July 1, 2020, we revised our historical data to reflect the death-certificate metric instead of the deaths-among-cases metric. Because of this change in methodology, there is a drop from 1,091 deaths on May 15 to 878 on May 16 in our data. Colorado also reports subsets of confirmed and probable COVID-19 deaths, but these metrics correspond to the deaths-among-cases metric we no longer report, so we do not compile this data.On June 14, 2020, Colorado revised previous "daily discharged" numbers. This caused an overall decline in their Recovered data.On July 27, 2020, Colorado posted a notice that, "Due to a server issue yesterday and today with our electronic laboratory reporting system, the number of tests completed and cases reported today, July 27, 2020, may be artificially low." We report Colorado data a day after posting due to timing, so this note applies to the data published on July 28.As of August 13, 2020, Colorado's total test results reflect total test encounters. The number of unique people tested is available in our API as `totalTestsPeopleViral`.Negative test results reported in our API and CSVs are calculated by subtracting Positive PCR tests (people) from Total PCR tests (specimens) in the absence of better data.	https://covid19.colorado.gov/data	https://public.tableau.com/views/Colorado_COVID19_Data/CO_Hospital?%3Aembed=y&%3AshowVizHome=no		@cdphe	https://www.colorado.gov/pacific/cdphe/2019-novel-coronavirus	Encounters	totalTestEncountersViral	Total Test Encounters (PCR)	Colorado	8	false
8	8	CT	On May 27, 2020, Connecticut deduplicated some of its data, resulting in a decrease in Cases and Total PCR tests (specimens).On May 29, 2020, Connecticut hospitalization data changed due to reporting laboratory-confirmed cases only. These changes resulted in a decrease in the numbers for Ever hospitalized and Recovered (which can be found in our API and CSVs). On June 18, 2020, Connecticut corrected some errors in its data, resulting in a decrease in Total PCR tests (specimens).On June 24, 2020, Connecticut corrected some errors in its data, resulting in a decrease in Negative PCR tests (specimens) (which can be found in our API and CSVs).Negative test results reported in our API and CSVs are calculated by subtracting Positive PCR tests (people) from Total PCR tests (specimens) in the absence of better data.	https://data.ct.gov/coronavirus			@ctdph	https://portal.ct.gov/Coronavirus	Specimens	posNeg	posNeg	Connecticut	9	false
9	9	DC	On May 25, 2020, the District of Columbia decreased the district's total tests number by 11,000 to reflect only DC residents.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.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. As of August 29, 2020, we store the “total overall tested” timeseries in our Total PCR Tests (encounters) field, despite this difference in definition.Negative test results reported in our API and CSVs are calculated by subtracting Positive PCR tests (people, confirmed + probable) from Total PCR tests (specimens) in the absence of better data.	https://coronavirus.dc.gov/page/coronavirus-surveillance-data			@_DCHealth	https://coronavirus.dc.gov/	Encounters	totalTestEncountersViral	Total Test Encounters (PCR)	District of Columbia	11	false
10	10	DE	On April 11, 2020, Delaware revised down negative test results from 10,415 to 9,624.On July 25, 2020, Delaware revised down total cases, confirmed positives, and total tests.On August 27, 2020, Delaware revised down total cases and confirmed positives. This is a semi-regular occurrence which will impact Delware's number occasionally. On September 6, 2020, the Division of Public Health reported a technical issue which caused between 175-200 positive cases to be excluded from Delaware's cumulative confirmed case count. These cases will be added in the coming days. As a result new cases reported may not have been diagnosed in the past 24 hour period.On September 9, 2020, Delaware reported that data from September 8, 2020 and September 9, 2020 would not be available until September 10, 2020 due to a maintenance issue with their electronic reporting system. We will backfill data for September 8, 2020 and September 9, 2020 to the best of our abilities when data is released	https://myhealthycommunity.dhss.delaware.gov/locations/state#testing			@Delaware_DHSS	https://dhss.delaware.gov/dhss/dph/epi/2019novelcoronavirus.html	People	posNeg	posNeg	Delaware	10	false
13	13	GU	Guam's counts include 11 people tested at the San Diego naval base.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 Guams's total case count.	http://dphss.guam.gov/covid-19/			@guamdphss	https://ghs.guam.gov/coronavirus-covid-19	Unclear Units	posNeg	posNeg	Guam	66	false
14	14	HI	As of August 5, 2020, we are collecting Now hospitalized, Now in ICU, and Now on ventilator data from the Lt. Governor of Hawaii's Instagram account, as we have determined that these are official statistics not available elsewhere. We have backfilled our time series for all available data from this source.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 have been diagnosed in the previous 24 hours.Negative test results reported in our API and CSVs are calculated by subtracting Positive PCR tests (people, confirmed + probable) from Total PCR tests (people) in the absence of better data.	https://health.hawaii.gov/coronavirusdisease2019/	https://health.hawaii.gov/coronavirusdisease2019/what-you-should-know/current-situation-in-hawaii/		@HIgov_Health	https://health.hawaii.gov/docd/advisories/novel-coronavirus-2019/	People	posNeg	posNeg	Hawaii	15	false
16	16	ID	As of April 9, 2020, Idaho reports probable and confirmed cases separately. On June 5, 2020, Idaho reported a large batch of previously unreported tests. The state's Total tests number rose by approximately 2,500 more tests on June 5 than the seven-day average for new tests at that time.On July 3, 2020, Idaho revised down their Recovered data by about 1,500, noting that "an error in auto-calculation was discovered."On July 8, 2020, Idaho revised its historical numers for Hospitalized now. We updated our hospitalization figures for Idaho from March 23 to July 13, 2020 to match on July 17, 2020.From July 13 through July 21, 2020, Idaho was unable to report Hospitalized now data due to HHS regulation changes. Idaho retroactively made figures available for these days on July 21, 2020, and we revised our figures to match.On July 22, 2020, Idaho reported 126 total deaths but also reported 103 lab-confirmed deaths and 33 probable deaths, for a calculated total of 136 deaths. We treated the 33 probable deaths data point as an error and reported 126 total deaths for this date, including 103 confirmed and 23 probable deaths. See Idaho state page screenshots for July 22. On August 4, 2020, after another period of missing data for Hospitalized now, Idaho reported current hospitalizations of 106, down from the previous report of 223 on July 31. It reported a similar drop in ICU patients from 51 on July 31 to 22 on August 4.As of September 18, 2020, Idaho's total test results are drawn from our `totalTestsViral` field instead of calculated via positive+negative.Negative test results reported in our API and CSVs are calculated by subtracting Positive PCR tests (people) from Total PCR tests (specimens) in the absence of better data.	https://coronavirus.idaho.gov/	https://public.tableau.com/views/DPHIdahoCOVID-19Dashboard_V2/Story1?%3Aembed=y&%3AshowVizHome=no&%3Adisplay_count=y&%3Adisplay_static_image=y&%3AbootstrapWhenNotified=true		@IDHW	https://coronavirus.idaho.gov/	Specimens	totalTestsViral	Total Tests (PCR)	Idaho	16	false
17	17	IL	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." Negative test results reported in our API and CSVs are calculated by subtracting Positive PCR tests (people) from Total PCR tests (specimens) in the absence of better data.	http://www.dph.illinois.gov/topics-services/diseases-and-conditions/diseases-a-z-list/coronavirus	http://www.dph.illinois.gov/covid19/hospitalization-utilization		@IDPH	http://www.dph.illinois.gov/topics-services/diseases-and-conditions/diseases-a-z-list/coronavirus	Specimens	posNeg	posNeg	Illinois	17	false
18	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 Positive PCR tests (people, confirmed + probable) from Total PCR tests (people) in the absence of better data.	https://www.in.gov/isdh/28470.htm	https://www.regenstrief.org/covid-dashboard/		@statehealthin	https://www.in.gov/isdh/28470.htm	People	posNeg	posNeg	Indiana	18	false
21	21	LA	Between April 20 and April 24, 2020, Louisiana did not report testing data from commercial labs due to a state review of data.On June 19, 2020, Louisiana's data changed due to deduplication and the state's removal of out-of-state cases.On August 30 Louisiana's reported data included 532 older cases that had not previously been reported; these cases had specimen collection dates ranging back to July 1.On August 26, 2020, Louisiana started reporting Probable cases, this caused a notable increase in Total cases.Louisiana reports probable deaths on a weekly basis.Negative test results reported in our API and CSVs are calculated by subtracting Positive PCR tests (people)* from Total PCR tests (people) in the absence of better data.	http://ldh.la.gov/Coronavirus/	https://services5.arcgis.com/O5K6bb5dZVZcTo5M/arcgis/rest/services/Combined_COVID_Reporting/FeatureServer/0/query?groupByFieldsForStatistics=Measure&outStatistics=%5B%7B%27statisticType%27%3A+%27sum%27%2C+%27onStatisticField%27%3A+%27Value%27%7D%5D&where=1%3D1		@LADeptHealth	http://ldh.la.gov/Coronavirus/	People	posNeg	posNeg	Louisiana	22	false
22	22	MA	On June 1, 2020, Massachusetts began to report probable cases and *probable deaths, causing Total cases and Total deaths to appear to increase sharply in our data. On June 30, 2020, Massachusetts decreased the number of cumulative hospitalizations and confirmed and probable deaths "due to ongoing data cleaning which identifies and removes duplicate reports."On July 31, 2020, Massachusetts noted that "Delays in the reporting of test results to DPH from multiple laboratories, including large national commercial laboratories, are reflected in today’s case counts. However, these positive test results have been assigned retrospectively to the appropriate date of test." We will backfill case data for Massachusetts in the near future.On August 12, 2020, Massachusetts began reporting probable cases weekly instead of daily. This can lead to apparent spikes in the data when the weekly numbers are incorporated, as happened on August 19. Beginning August 20, 2020, we will use the daily total case count from the race and ethnicity section of the dashboard, which includes both confirmed and probable cases, and will backfill the previous week's case counts.On August 31, 2020 we updated Massachusetts' Total PCR Tests (specimens) before August 12, 2020 based on the state's "Tests by Date" dataset, extending the column back to January 22, 2020.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. 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`.Negative test results reported in our API and CSVs are c…	https://www.mass.gov/info-details/covid-19-cases-quarantine-and-monitoring			@massdph	https://www.mass.gov/resource/information-on-the-outbreak-of-coronavirus-disease-2019-covid-19	Specimens	totalTestsViral	Total Tests (PCR)	Massachusetts	25	false
23	23	MD	Between March 12 and March 28, 2020, Maryland did not report data for negative tests.On July 31, 2020, we began capturing Maryland's data for Positive PCR tests (specimens). 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.	https://coronavirus.maryland.gov/			@MDHealthDept	https://phpa.health.maryland.gov/Pages/Novel-coronavirus.aspx	Specimens	totalTestsViral	posNeg	Maryland	24	false
24	24	ME	Maine combines PCR and antigen tests in the total tests figure reported on the state's dashboard.As of May 20, 2020, Maine reports PCR tests and antibody tests separately.On June 23, 2020, Maine began reporting the dates of cases, deaths, recoveries, and hospitalizations on the day they occurred instead of the day the event was reported. Maine also began providing separate figures for Deaths (probable) and Deaths (confirmed).Negative test results reported in our API and CSVs are calculated by subtracting Positive PCR tests (people) from Total PCR tests (specimens) in the absence of better data.	https://www.maine.gov/dhhs/mecdc/infectious-disease/epi/airborne/coronavirus/data.shtml			@mainedhhs	https://www.maine.gov/dhhs/mecdc/infectious-disease/epi/airborne/coronavirus.shtml	Specimens	posNeg	posNeg	Maine	23	false
25	25	MI	On June 11, 2020, we updated our historical data from a spreadsheet provided by Michigan's Department of Health and Human Services in order to reflect the lab-reported dates of probable and confirmed cases and probable and confirmed deaths by date of death.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.Michigan updates its Recovered metric weekly and does not update any data on Sundays. Michigan combines PCR and antigen tests in the total tests figure reported on the state's dashboard. Since March 10, 2020, Michigan has reported each day's Positive and Negative tests (people) by county but has never totaled these metrics for the state. We add new Positive and Negative tests (people) values daily to a running sum and report the total.	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		@MichiganHHS	https://www.michigan.gov/coronavirus	Specimens	totalTestsViral	posNeg	Michigan	26	false
26	26	MN	On September 17, 2020, we switched Minnesota's specimens timeseries to Total Test Encounters (PCR) based on correspondence with the state, which revealed that their "total approximate number of completed tests" reflects individuals tested per day.Negative test results reported in our API and CSVs are calculated by subtracting Positive PCR tests (people) from Total PCR tests (people).As of September 18, 2020, Minnesota 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`.	https://www.health.state.mn.us/diseases/coronavirus/situation.html			@mnhealth	https://www.health.state.mn.us/diseases/coronavirus/index.html	Encounters	totalTestEncountersViral	Total Test Encounters (PCR)	Minnesota	27	false
28	28	MP	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.Negative test results reported in our API and CSVs are calculated by subtracting Positive PCR tests (people) from Total PCR tests (people).	https://www.chcc.gov.mp/coronavirusinformation.php	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	@cnmichcc	https://www.chcc.gov.mp/coronavirusinformation.php	People	posNeg	posNeg	Northern Mariana Islands	69	false
29	29	MS	As of May 23, 2020, Mississippi is separating out PCR and antibody tests. We now report both separately.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 September 11, 2020, we discovered a new source for Mississippi current hospitalizations and current ICU admissions on the Mississippi State Department of Health website.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.Negative test results reported in our API and CSVs are calculated by subtracting Positive PCR tests (people) from Total PCR tests (specimens) in the absence of better data.	https://msdh.ms.gov/msdhsite/_static/14,0,420.html			@msdh	https://msdh.ms.gov/msdhsite/_static/14,0,420.html	Specimens	posNeg	posNeg	Mississippi	28	false
30	30	MT	Negative test results reported in our API and CSVs are calculated by subtracting Positive PCR tests (people) from Total PCR tests (specimens) in the absence of better data.	https://montana.maps.arcgis.com/apps/MapSeries/index.html?appid=7c34f3412536439491adcc2103421d4b	https://dphhs.mt.gov/publichealth/cdepi/diseases/coronavirusmt/demographics		@dphhsmt	https://dphhs.mt.gov/publichealth/cdepi/diseases/coronavirusmt	Specimens	totalTestsViral	posNeg	Montana	30	false
32	32	ND	On May 3, 2020, North Dakota began reporting two additional death metrics: deaths of people with lab-confirmed cases of COVID-19 whose death records are still pending and deaths of people with lab-confirmed cases of COVID-19 whose death certificates do not list COVID-19 as a cause of death. As of July 1, 2020, we have edited our historical figures to exclude these numbers from our death counts, resulting in an apparent drop from 24 deaths on May 2 to 16 on May 3. On August 19, 2020, North Dakota launched a new dashboard with a number of new data points, including race and ethnicity data and ICU data. On September 9, 2020, North Dakota began reporting “Susceptible Encounters” on its dashboard, which are defined as test encounters excluding those who have tested positive after the first time. We have begun recording the value in our Total PCR tests (test encounters) field.As of September 11, 2020, North Dakota’s total test results reflect total test encounters. The number of unique people tested is available in our API as `totalTestsPeopleViral`.	https://www.health.nd.gov/diseases-conditions/coronavirus/north-dakota-coronavirus-cases			@NDDOH	https://www.health.nd.gov/diseases-conditions/coronavirus	Encounters	totalTestEncountersViral	Total Test Encounters (PCR)	North Dakota	38	false
33	33	NE	Nebraska combines PCR and antigen tests in the total tests figure reported on the state's dashboard.	https://experience.arcgis.com/experience/ece0db09da4d4ca68252c3967aa1e9dd			@NEDHHS	http://dhhs.ne.gov/Pages/Coronavirus.aspx	People	totalTestsPeopleViral	posNeg	Nebraska	31	false
35	35	NJ	On May 16, 2020, a backfill effort by New Jersey caused the state's data for Recovered to rise by approximately 7,000 people. On July 16, 2020, New Jersey's Recovered figure decreased.On July 19, 2020, New Jersey's Total cases decreased, perhaps due to reclassification of probable cases.On August 4, 2020, New Jersey's Now hospitalized* number decreased by 268 people.On August 7, 2020, we back-filled New Jersey's Probable deaths with data provided by the state. This removed apparent spikes in deaths due to the state's irregulat reporting.On September 1, New Jersey did not update their total PCR test figure by the time of our update, however total cases increased from 191160 to 192290.Negative test results reported in our API and CSVs are calculated by subtracting Positive PCR tests (people) from Total PCR tests (specimens).	https://covid19.nj.gov/#live-updates	https://maps.arcgis.com/apps/MapSeries/index.html?appid=c2efd1898e48452e83d7218329e953d7&entry=2		@NJDeptofHealth	https://www.nj.gov/health/cd/topics/ncov.shtml	Specimens	posNeg	posNeg	New Jersey	34	false
36	36	NM	Negative test results reported in our API and CSVs are calculated by subtracting Positive PCR tests (people) from Total PCR tests (people).	https://cvprovider.nmhealth.org/public-dashboard.html			@NMDOH	https://cv.nmhealth.org/	Specimens	posNeg	posNeg	New Mexico	35	false
37	37	NV		https://app.powerbigov.us/view?r=eyJrIjoiMjA2ZThiOWUtM2FlNS00MGY5LWFmYjUtNmQwNTQ3Nzg5N2I2IiwidCI6ImU0YTM0MGU2LWI4OWUtNGU2OC04ZWFhLTE1NDRkMjcwMzk4MCJ9	http://dpbh.nv.gov/coronavirus/		@dhhsnevada	http://dpbh.nv.gov/coronavirus/	People	posNeg	posNeg	Nevada	32	false
40	40	OK	Prior to April 10, 2020, Oklahoma reported "Positive (Out-of-State)" results. We excluded these figures from our data, as we assumed these individuals were isolated outside the state.Oklahoma noted that reported Total cases numbers for July 19 and July 20 were inaccurately low due to technical issues.	https://coronavirus.health.ok.gov/			@HealthyOklahoma	https://coronavirus.health.ok.gov	Specimens	posNeg	posNeg	Oklahoma	40	false
43	43	PR	On April 22, 2020, Puerto Rico's data changed due to deduplication. This resulted in a decrease in Total cases.On May 6, 2020, Puerto Rico stopped reporting Negative PCR tests.On July 7, 2020, we updated Negative PCR tests based on press releases from May and June.Reported Deaths include both confirmed and probable COVID-19 deaths.Puerto Rico reports both confirmed cases, which are identified by positive PCR tests, and probable cases, which the territory reports are identified by positive antibody tests. It is not clear whether Puerto Rico requires additional epidemiological, clinical, or vital records evidence to classify a person with a positive antibody test as a probable case. The combined case number in our dataset includes Puerto Rico's confirmed and probable cases as the territory reports them.	https://estadisticas.pr/en/covid-19	https://bioseguridad.maps.arcgis.com/apps/opsdashboard/index.html#/3bfb64c9a91944bc8c41edd8ff27e6df		@DeptSaludPR	http://www.salud.gov.pr/Pages/coronavirus.aspx	Specimens	posNeg	posNeg	Puerto Rico	72	false
46	46	SD	On July 27, 2020, Negative PCR tests decreased by 148 for unclear reasons.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 case increase. They have provided historical case counts, and we are working to backfill our data.As of September 18, 2020, South Dakota's total test results are drawn from our `totalTestsPeopleViral` field instead of calculated via positive+negative.	https://doh.sd.gov/news/Coronavirus.aspx			@SDDOH	https://doh.sd.gov/news/Coronavirus.aspx	People	totalTestsPeopleViral	Total PCR Tests (People)	South Dakota	46	false
49	49	UT	Utah combines PCR and antigen tests in the top-line total tests figure reported on the state's dashboard. We get our cumulative PCR and antigen testing numbers from summing the daily testing figures on a graph with a timeseries that Utah continuously revises. We do our best to capture any backfilling manually, but the graph does not have an option to download the data automatically, which would allow us to better capture these revisions.As of June 11, 2020, Utah reports a combined case count for total intubated patients and patients on a ventilator. We report this figure as Ever on ventilator.As of July 16, 2020, Utah is reporting both specimens and people tested. We report positives and negatives based on the number of people tested. Negative test results reported in our API and CSVs are calculated by subtracting Positive PCR tests (people) from Total PCR tests (people).	https://coronavirus-dashboard.utah.gov/	https://coronavirus-dashboard.utah.gov/#hospitalizations		@utahdepofhealth	https://health.utah.gov/coronavirus	People	posNeg	posNeg	Utah	49	false
51	51	VI	Total PCR tests in the Virgin Islands is the sum of Positive PCR tests, Negative PCR tests, and Pending tests.	https://doh.vi.gov/covid19usvi	https://www.covid19usvi.com		@usvidoh	https://doh.vi.gov/	Unclear units	posNeg	posNeg	US Virgin Islands	78	false
52	52	VT	Between May 15 and May 16, 2020, Vermont's total tests decreased by about 1,000 tests with no explanation.On August 19, 2020, Vermont's total tests decreased by about 200 tests with no explanation. On September 23, 2020, Vermont's total tests decreased by about 80 tests with no explanation. Negative test results reported in our API and CSVs are calculated by subtracting Positive PCR tests (people) from Total PCR tests (people).	https://experience.arcgis.com/experience/85f43bd849e743cb957993a545d17170	https://www.healthvermont.gov/response/coronavirus-covid-19/current-activity-vermont#dashboard		@healthvermont	https://www.healthvermont.gov/response/infectious-disease/2019-novel-coronavirus	People	posNeg	posNeg	Vermont	50	false
53	53	WA	Between March 31 and April 15, 2020, Washington state did not report Negative PCR tests (people). On April 18, 2020, Washington state removed 190 confirmed cases that were discovered to be out-of-state residents tested in Washington laboratories. On June 18, 2020, Washington revised its Total PCR tests (people) downward. On the same date, Washington decreased its count of COVID-19 deaths by 7, because it determined that even though those 7 people had tested positive for COVID-19, COVID-19 was not a contributing cause in their deaths.On June 22, 2020, we updated previous values for cases and total tests in our time-series using data from Washington state's dashboard. This update caused an artificial decrease in cases and tests between June 21 and June 22.On July 14, 2020, Washington state revised its count of COVID-19 deaths downward by 39, because it determined that even though those 39 people had tested positive for COVID-19, COVID-19 was not a contributing cause in their deaths.On August 2, 2020, Washington state Department of Health reported that "DOH is continuing to experience issues with its reporting system today. We are able to report cases, deaths and hospitalizations but have not reported new negative test results since 8/1."On August 26, 2020, Washington switched its total tests units to testing encounters, excluding future encounters from individuals who test positive. It also provided a full timeseries of the figure. This testing encounters figure is slightly different from how we define testing encounters in two ways: first, our definition of testing encounters includes encounters after a positive test, and second, it should be calculated not by summing resulted tests but by counting all daily tests in a separate reporting stream. Despite these differences, the historical and current values of Washington’s figure are still stored in our Total PCR tests (test encounters) field.Washington State reports confirmed cases, laboratory tests, and deaths as of the …	https://www.doh.wa.gov/Emergencies/NovelCoronavirusOutbreak2020COVID19/DataDashboard	https://www.doh.wa.gov/Emergencies/Coronavirus		@WADeptHealth	https://www.doh.wa.gov/Emergencies/Coronavirus	Encounters	totalTestEncountersViral	Total Test Encounters (PCR)	Washington	53	false

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE [states_info] (
   [state] TEXT,
   [notes] TEXT,
   [covid19Site] TEXT,
   [covid19SiteSecondary] TEXT,
   [covid19SiteTertiary] TEXT,
   [covid19SiteQuaternary] TEXT,
   [covid19SiteQuinary] TEXT,
   [twitter] TEXT,
   [covid19SiteOld] TEXT,
   [covidTrackingProjectPreferredTotalTestUnits] TEXT,
   [covidTrackingProjectPreferredTotalTestField] TEXT,
   [totalTestResultsField] TEXT,
   [name] TEXT,
   [fips] INTEGER,
   [pui] TEXT,
   [pum] TEXT
);