states_matrix

Table actions
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

57 rows

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Common Assumptions

Link rowid ▼ 1 Source Links Common Assumptions Other Notes Per Metric, Per State Source Notes Check if data actually exists, but we're saying No Data in the source notes. Used for conditional formatting on Source Notes
1 1 Primary Source name Data Dashboard Positives Include Deaths Other Notes Local Time  
2 2 AK AK https://alaska-coronavirus-vaccine-outreach-alaska-dhss.hub.arcgis.com/app/ed1c874ca60b4c15ab09095a070065ca   AK is tracking cases by date of onset. AK primary > "All data are updated once daily by noon and are current through the previous day"yesterday / 23:59 FALSE
3 3 AL AL https://alpublichealth.maps.arcgis.com/apps/opsdashboard/index.html#/6d2771faa9da4a2786a509d82c8cf0f7     AL dash > "Updates daily at 10am"today / 10:00 FALSE
4 4 AR AR https://experience.arcgis.com/experience/c2ef4a4fcbe5458fbf2e48a21e4fece9     AR primary > image COVID-19 Update current day / 0:00note: If page graphic is not updated, check state social media. AR often posts the graphic on twitter before they update the page. FALSE
5 5 AS AS       date of the updated emergency declaration/press release/news articlenote: if you find an updated source and have questions about the timestamp open a state thread and tag the shift leads FALSE
6 6 AZ AZ https://www.azdhs.gov/preparedness/epidemiology-disease-control/infectious-disease-epidemiology/covid-19/dashboards/index.php     AZ dash > "Date Updated"that date / 0:00 FALSE
7 7 CA CA https://public.tableau.com/views/COVID-19CasesDashboard_15931020425010/Cases?:embed=y&:showVizHome=no   As of 6/1, an additional 3,481 hospitalized, 618 in the ICU, are listed as "Suspected COVID-19 cases" CA primary > "...with data from… " > yesterday / 23:59 FALSE
8 8 CO CO       CO primary > "Data is updated by about 4pm and includes cases reported through the previous day"yesterday / 23:59 FALSE
9 9 CT CT https://data.ct.gov/stories/s/COVID-19-data/wa3g-tfvc/     CT primary > in text at top of page "As of..."above date / 23:59note: if time is 8:30pm, use 20:30 FALSE
10 10 DC DC       DC primary > datedate / 0:00 FALSE
11 11 DE DE https://myhealthycommunity.dhss.delaware.gov/locations/state     DE dash > "Data are current as of 6pm the previous day" yesterday / 18:00 FALSE
12 12 FL FL https://experience.arcgis.com/experience/96dd742462124fa0b38ddedb9b25e429/ TRUE   PDFFL primary > link "See State Report" > "Data through..."above date / 23:59 FALSE
13 13 GA GA https://augustagis.maps.arcgis.com/apps/opsdashboard/index.html#/4eec20925b6b4f338368df0ffcba472d TRUE   GA primary > "...as of..."above date / above time FALSE
14 14 GU GU http://dphss.guam.gov/covid-19/     GU primary > "Posted on" date and time from most recent JIC releasenote: if information comes from a JIC Release without the table use date and time of publish of that releasenote: if deaths are sourced from a recent press release, use the publish time of that one if it is the most recent FALSE
15 15 HI HI       long calculationThis formula presents the update time in the correct time zone.long calculation > hover over "# HI PCR Test Encounters" > click play button > "Update time:" above date / above time FALSE
16 16 IA IA https://coronavirus.iowa.gov/#CurrentStatus     IA dash > "Last updated on: [date]" date above / 0:00 FALSE
17 17 ID ID https://public.tableau.com/profile/idaho.division.of.public.health#!/vizhome/DPHIdahoCOVID-19Dashboard/Home     ID primary > "Page last updated on..."above date / above timenote: do not update the timestamp if data is unchanged.note: ID is on a one dag lag, since 5:00 MT is after we publish on most days FALSE
18 18 IL IL   FALSE   IL primary > "Information to be updated daily" today's date / 0:00 FALSE
19 19 IN IN https://www.regenstrief.org/covid-dashboard/     IN primary > "Below results are as of…"above date / above time FALSE
20 20 KS KS https://www.coronavirus.kdheks.gov/160/COVID-19-in-Kansas     updates: Monday, Wednesday, FridayKS dash > “Last updated:” above date / above time FALSE
21 21 KY KY https://kygeonet.maps.arcgis.com/apps/opsdashboard/index.html#/543ac64bc40445918cf8bc34dc40e334     KY primary > "Current as of..."above date / 0:00or (On Sundays only)KY primary > link (pdf) KY COVID-19 Daily Report use date at top / 0:00 FALSE
22 22 LA LA http://ldh.la.gov/Coronavirus/     LA dash > "This dashboard is updated daily by noon, except on Saturday.today / 12:00note: If no values have updated carry over previous timestamp. FALSE
23 23 MA MA       MA primary > title "COVID-19 Interactive Data Dashboard" > "Data as of:"date from above / 23:59pmnote: the time is visible on hover FALSE
24 24 MD MD https://coronavirus.maryland.gov/     MD dash > "Note: Maryland Department of Health updates these data daily during the 10am hour"today / 10:00 FALSE
25 25 ME ME https://www.maine.gov/dhhs/mecdc/infectious-disease/epi/airborne/coronavirus/data.shtml     ME dash > "...COVID-19 case investigation data included as of 11:59 PM the previous day"yesterday / 23:59 FALSE
26 26 MI MI https://www.michigan.gov/coronavirus/0,9753,7-406-98163_98173---,00.html     MI dash > tab "Current Status" > on right-hand side under "MICHIGAN" > [date]above date / 0:00 FALSE
27 27 MN MN https://mndps.maps.arcgis.com/apps/opsdashboard/index.html#/f28f84968c1148129932c3bebb1d3a1a     MN primary > "Updated daily at 11 a.m., with data current as of 4 p.m. the previous day."yesterday / 16:00 FALSE
28 28 MO MO https://showmestrong.mo.gov/data/statewide-public-health/     MO dash > "Includes data reported through...."yesterday / 23:59 FALSE
29 29 MP MP https://cnmichcc.maps.arcgis.com/apps/opsdashboard/index.html#/4061b674fc964efe84f7774b7979d2b5     MP query > "MAX_reportdt:" date/ 0:00 FALSE
30 30 MS MS       MS primary > "New Cases and Deaths as of...""as of" date / 0:00 FALSE
31 31 MT MT https://montana.maps.arcgis.com/apps/MapSeries/index.html?appid=7c34f3412536439491adcc2103421d4b     MT dash > tab "MT COVID-19 Cases" > "Updates are made by 10:00am daily. Information is reported based on the previous day"yesterday / 23:59 FALSE
32 32 NC NC https://covid19.ncdhhs.gov/dashboard     NC primary > "Last updated…"above date / above time FALSE
33 33 ND ND https://www.health.nd.gov/diseases-conditions/coronavirus/north-dakota-coronavirus-cases     ND primary > "The North Dakota Department of Health dashboard is updated daily by 11 am and includes cases reported through the previous day. "yesterday / 23:59 FALSE
34 34 NE NE https://experience.arcgis.com/experience/ece0db09da4d4ca68252c3967aa1e9dd/page/page_0/     NE dash > tab "Last 14 Day Positive Cases" > "Last updated:"above date / above time (see note below)note: the time is presented in the viewer's local time (your timezone), even though it says CDT. This needs to be entered into the spreadsheet as Central Time. If you are in ET subtract 1 hour. If you are in MT add 1 hour. If you are in PT add 2 hours. FALSE
35 35 NH NH https://www.nh.gov/covid19/dashboard/case-summary.htm     NH primary > "data updated as of..."above date / above time FALSE
36 36 NJ NJ https://covid19.nj.gov/#live-updates     NJ dash > "Updated:"above date / 0:00 FALSE
37 37 NM NM https://cvprovider.nmhealth.org/public-dashboard.html     NM dash > "Last Updated"above date / above time (see note below)note: the time is presented in the viewer's local time (your timezone), but it needs to be entered into the spreadsheet as Mountain Time. If you are in ET subtract 2 hours. If you are in CT subtract 1 hour. If you are in PT add 1 hour. FALSE
38 38 NV NV https://app.powerbigov.us/view?r=eyJrIjoiMjA2ZThiOWUtM2FlNS00MGY5LWFmYjUtNmQwNTQ3Nzg5N2I2IiwidCI6ImU0YTM0MGU2LWI4OWUtNGU2OC04ZWFhLTE1NDRkMjcwMzk4MCJ9     NV dash > "Data as of..."above date / 0:00 FALSE
39 39 NY NY https://covid19tracker.health.ny.gov/views/NYS-COVID19-Tracker/NYSDOHCOVID-19Tracker-Map?%3Aembed=yes&%3Atoolbar=no&%3Atabs=n     NY dash > "Testing data as of:" above date / 14:00note: in upper right corner of dash, make sure to use "as of" date/time FALSE
40 40 OH OH https://coronavirus.ohio.gov/wps/portal/gov/covid-19/dashboards/overview/     OH dash > "Last updated" & "Updated daily at..."above date / 14:00 FALSE
41 41 OK OK       OK primary > tile "OK Summary" > "Cases updated as of:" above date / 0:00 FALSE
42 42 OR OR https://public.tableau.com/profile/oregon.health.authority.covid.19#!/vizhome/OregonCOVID-19Update/CaseandTesting     OR primary > title "Situation in Oregon" > "Data from..."or (Sunday and Monday only)on Sunday and Monday, previous day's press release > "... as of..."yesterday / 00:01 FALSE
43 43 PA PA https://experience.arcgis.com/experience/ed2def13f9b045eda9f7d22dbc9b500e     PA dash > "Information last updated at..."above date / above time FALSE
44 44 PR PR https://bioseguridad.maps.arcgis.com/apps/opsdashboard/index.html#/d7308c1abb4747e584329adf1215125e     PR primary > "Datos al…"above date / 0:00or (if page date is not updated, but dash is) current day / 0:00note: do not use the "Útilima actualization..." date on dash. FALSE
45 45 RI RI       RI primary > "Updated Monday through Friday by 1pm"today / 13:00 on weekdays, Fri date / 13:00 on weekends FALSE
46 46 SC SC https://scdhec.gov/infectious-diseases/viruses/coronavirus-disease-2019-covid-19/monitoring-testing-covid-19     SC primary > "As of ..."above date / time FALSE
47 47 SD SD https://doh.sd.gov/COVID/Dashboard.aspx     SD primary > "...include cases reported through 1p.m. the previous day."yesterday / 13:00 FALSE
48 48 TN TN https://www.tn.gov/content/tn/health/cedep/ncov/data.html     TN dash > "These figures are updated daily at 2 p.m. Central time and reflect all cases reported to TDH as of that time"today / 14:00 FALSE
49 49 TX TX https://txdshs.maps.arcgis.com/apps/opsdashboard/index.html#/ed483ecd702b4298ab01e8b9cafc8b83     TX dash > "Last Updated:"above date / above time FALSE
50 50 UT UT https://coronavirus-dashboard.utah.gov/     UT dash > "Data for this report were accessed on…"above date / above timenote: on bottom of the page FALSE
51 51 VA VA https://www.vdh.virginia.gov/coronavirus/covid-19-in-virginia/ TRUE   VA primary > dash > "Data entered by 5:00 PM the prior day."yesterday / 17:00 FALSE
52 52 VI VI https://www.covid19usvi.com     VI primary > title "COVID-19 Summary" > "Last updated" above date / above time FALSE
53 53 VT VT https://experience.arcgis.com/experience/85f43bd849e743cb957993a545d17170     VT dash > tab Info "...reflecting counts as of end of previous day."yesterday / 23:59 FALSE
54 54 WA WA https://www.doh.wa.gov/Emergencies/NovelCoronavirusOutbreak2020COVID19/DataDashboard     WA dash > "Data as of.."above date / above timenote: WA is on a permanent 1 day lag due to late updates. FALSE
55 55 WI WI https://www.dhs.wisconsin.gov/covid-19/data.htm     WI dash > title "Wisconsin COVID-19 Summary Statistics" > "Cumulative Data, Updated:"today / 0:00 FALSE
56 56 WV WV https://dhhr.wv.gov/COVID-19/Pages/default.aspx     WV dash > "Data posted on dashboard is from 12:00 midnight the previous day"yesterday / 23:59note: we know it's a confusing statement, but we checked the raw data and it lines up with our suggestion of yesterday/23:59 FALSE
57 57 WY WY https://health.wyo.gov/publichealth/infectious-disease-epidemiology-unit/disease/novel-coronavirus/covid-19-map-and-statistics/     WY dash > hover over "Lab Confirmed Cases" > "there are XXXXX lab-confirmed cases of COVID-19 in Wyoming as of..." above date / above time FALSE

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [states_matrix] (
   [1] TEXT,
   [] TEXT,
   [Source Links] TEXT,
   [Common Assumptions] TEXT,
   [Other Notes] TEXT,
   [Per Metric, Per State Source Notes] TEXT,
   [Check if data actually exists, but we're saying No Data in the source notes. Used for conditional formatting on Source Notes] TEXT
);