states_matrix
Data source: Big Local News · About: big-local-datasette
57 rows sorted by Source Links
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 | |
---|---|---|---|---|---|---|---|---|
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 | |||
8 | 8 | CO | CO | CO primary > "Data is updated by about 4pm and includes cases reported through the previous day"yesterday / 23:59 | FALSE | |||
10 | 10 | DC | DC | DC primary > datedate / 0:00 | 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 | |||
18 | 18 | IL | IL | FALSE | IL primary > "Information to be updated daily" today's date / 0:00 | 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 | |||
30 | 30 | MS | MS | MS primary > "New Cases and Deaths as of...""as of" date / 0:00 | FALSE | |||
41 | 41 | OK | OK | OK primary > tile "OK Summary" > "Cases updated as of:" above date / 0:00 | 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 | |||
1 | 1 | Primary Source | name | Data Dashboard | Positives Include Deaths | Other Notes | Local Time | |
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 | ||
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 | ||
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 | ||
38 | 38 | NV | NV | https://app.powerbigov.us/view?r=eyJrIjoiMjA2ZThiOWUtM2FlNS00MGY5LWFmYjUtNmQwNTQ3Nzg5N2I2IiwidCI6ImU0YTM0MGU2LWI4OWUtNGU2OC04ZWFhLTE1NDRkMjcwMzk4MCJ9 | NV dash > "Data as of..."above date / 0:00 | 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 | |
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 | ||
29 | 29 | MP | MP | https://cnmichcc.maps.arcgis.com/apps/opsdashboard/index.html#/4061b674fc964efe84f7774b7979d2b5 | MP query > "MAX_reportdt:" date/ 0:00 | 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 | ||
16 | 16 | IA | IA | https://coronavirus.iowa.gov/#CurrentStatus | IA dash > "Last updated on: [date]" date above / 0:00 | 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 | ||
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 | ||
32 | 32 | NC | NC | https://covid19.ncdhhs.gov/dashboard | NC primary > "Last updated…"above date / above time | FALSE | ||
36 | 36 | NJ | NJ | https://covid19.nj.gov/#live-updates | NJ dash > "Updated:"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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
12 | 12 | FL | FL | https://experience.arcgis.com/experience/96dd742462124fa0b38ddedb9b25e429/ | TRUE | PDFFL primary > link "See State Report" > "Data through..."above date / 23:59 | 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 | ||
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 | ||
43 | 43 | PA | PA | https://experience.arcgis.com/experience/ed2def13f9b045eda9f7d22dbc9b500e | PA dash > "Information last updated at..."above date / above time | 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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | |
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 | ||
28 | 28 | MO | MO | https://showmestrong.mo.gov/data/statewide-public-health/ | MO dash > "Includes data reported through...."yesterday / 23:59 | FALSE | ||
49 | 49 | TX | TX | https://txdshs.maps.arcgis.com/apps/opsdashboard/index.html#/ed483ecd702b4298ab01e8b9cafc8b83 | TX dash > "Last Updated:"above date / above time | 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 | ||
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 | ||
52 | 52 | VI | VI | https://www.covid19usvi.com | VI primary > title "COVID-19 Summary" > "Last updated" above date / above time | 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 | ||
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 | ||
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 | ||
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 | ||
35 | 35 | NH | NH | https://www.nh.gov/covid19/dashboard/case-summary.htm | NH primary > "data updated as of..."above date / above time | FALSE | ||
19 | 19 | IN | IN | https://www.regenstrief.org/covid-dashboard/ | IN primary > "Below results are as of…"above date / above time | 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 | ||
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 |
Advanced export
JSON shape: default, array, newline-delimited
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 );