COVID_COVID19Tracker: states_info: 10 rows where where totalTestResultsField = "Total Tests (PCR)"

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

10 rows where totalTestResultsField = "Total Tests (PCR)"

descending

This data as json, copyable, CSV (advanced)

Link	rowid ▼	state	notes	covid19Site	covid19SiteSecondary	covid19SiteTertiary	twitter	covid19SiteOld	covidTrackingProjectPreferredTotalTestUnits	covidTrackingProjectPreferredTotalTestField	totalTestResultsField	name	fips	pum
1	1	AK	Alaska combines PCR and antigen tests in the total tests figure reported on the state's dashboard.Alaska reports a "Total count" of people who have been hospitalized, but we do not record that count in our Ever hospitalized metric, since it does not include people who are currently in the hospital.As of July 16, 2020, we are reporting non-resident cases as part of Cases or Positive PCR tests (people) for Alaska.As of September 18, 2020, Alaska'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.	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	@Alaska_DHSS	http://dhss.alaska.gov/dph/Epi/id/Pages/COVID-19/default.aspx	Specimens	totalTestsViral	Total Tests (PCR)	Alaska	2	false
2	2	AL	Alabama combines PCR and antigen tests in the total tests figure reported on the state's dashboard.On July 11, 2020, Alabama began using direct reports from hospitals for cumulative hospitalizations (which we report in our Ever hospitalized metric), rather than state case surveillance. Its number of cumulative hospitalizations increased by over 3,000 as a result. On July 15, 2020, we changed our data reporting to reflect that Alabama reports test totals in specimens rather than unique people tested, as we had initially believed. All test results were moved into the correct API field and metric.On September 1, 2020, Alabama began displaying the number of people tested by antibody, over 50,000 individuals, separately from its main total tested field, which it clarified represents antigen and PCR testing. Its main total tested number dropped by over 25,000 the same day. We have reached out to the Alabama Department of Public Health to confirm this drop was due to the removal of the individuals tested by antibody.As of September 18, 2020, Alabama'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://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	@alpublichealth	http://www.alabamapublichealth.gov/infectiousdiseases/2019-coronavirus.html	Unclear units	totalTestsViral	Total Tests (PCR)	Alabama	1	false
3	3	AR	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.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 September 16, 2020, Arkansas’ 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 that Arkansas reversed. It also added 140 probable deaths, not all of which dated to September 16.As of September 18, 2020, Arkansas' total test results are drawn from our `totalTestsViral` field instead of calculated via positive+negative.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.	https://www.healthy.arkansas.gov/programs-services/topics/novel-coronavirus	https://experience.arcgis.com/experience/c2ef4a4fcbe5458fbf2e48a21e4fece9	https://experience.arcgis.com/experience/c2ef4a4fcbe5458fbf2e48a21e4fece9	@adhpio	https://www.healthy.arkansas.gov/programs-services/topics/novel-coronavirus	Specimens	totalTestsViral	Total Tests (PCR)	Arkansas	5	false
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
6	6	CA	Prior to April 1, 2020, we used county data sources for more reliably timely reporting of California's COVID-19 data. At the start of April, we began reporting primarily from the state data dashboard(s). This led to a modest drop in cases and deaths, as the state's data lags behind the county sources.On April 4 and April 22, 2020, California reported large batches of backlogged negative test 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 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.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.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.As of September 18, 2020, California'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://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	@CAPublicHealth	https://www.cdph.ca.gov/Programs/CID/DCDC/Pages/Immunization/ncov2019.aspx	Specimens	totalTestsViral	Total Tests (PCR)	California	6	false
12	12	GA	As of May 27, 2020, Georgia reports antibody tests separately from PCR tests. This change reduced the number for total tests by approximately 74,000.As of August 28, 2020, we started reporting patients Now hospitalized from the [Georgia Geospatial Information Office](https://www.arcgis.com/apps/opsdashboard/index.html#/e40c39564f724af7bfe8fd5d88deadb6). The new count includes both patients with a confirmed COVID-19 diagnosis and patients under investigation, as is our standard practice where possible.As of September 18, 2020, Georgia'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://dph.georgia.gov/covid-19-daily-status-report	https://augustagis.maps.arcgis.com/apps/opsdashboard/index.html#/4eec20925b6b4f338368df0ffcba472d	https://www.arcgis.com/apps/opsdashboard/index.html#/e40c39564f724af7bfe8fd5d88deadb6	@GaDPH	https://dph.georgia.gov/novelcoronavirus	Specimens	totalTestsViral	Total Tests (PCR)	Georgia	13	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
20	20	KY	On May 23, 2020, Kentucky revised down the state's figure for Total tests.As of May 27, 2020, Kentucky reports antibody tests separately from PCR tests. As of September 18, 2020, Kentucky'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://kygeonet.maps.arcgis.com/apps/opsdashboard/index.html#/543ac64bc40445918cf8bc34dc40e334	https://chfs.ky.gov/agencies/dph/Pages/covid19.aspx	https://chfs.ky.gov/agencies/dph/covid19/COVID19DailyReport.pdf	@CHFSKy	https://chfs.ky.gov/agencies/dph/Pages/covid19.aspx	Specimens	totalTestsViral	Total Tests (PCR)	Kentucky	21	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
34	34	NH	As of May 25, 2020, New Hampshire reports PCR tests separately from antibody tests.On September 2, 2020, New Hampshire did not update their dashboards or summary report by the time of our update.On September 9, 2020, New Hampshire did not update their dashboards or summary report by the time of our update.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, 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`.	https://www.dhhs.nh.gov/dphs/cdcs/2019-ncov.htm	https://www.nh.gov/covid19/dashboard/summary.htm	https://www.nh.gov/covid19/dashboard/overview.htm#dash	@NHPubHealth	https://www.dhhs.nh.gov/dphs/cdcs/2019-ncov.htm	Specimens	totalTestsViral	Total Tests (PCR)	New Hampshire	33	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
);