# states_matrix

1: AK
unnamed: AK
Other Notes: AK is tracking cases by date of onset.
Check if data actually exists, but we're saying No Data in the source notes. Used for conditional formatting on Source Notes: FALSE
Source Links:
  https://alaska-coronavirus-vaccine-outreach-alaska-dhss.hub.arcgis.com/app/ed1c874ca60b4c15ab09095a070065ca

Per Metric, Per State Source Notes:
  AK primary > "All data are updated once daily by noon and are current through the previous day"yesterday / 23:59


1: AR
unnamed: AR
Source Links: https://experience.arcgis.com/experience/c2ef4a4fcbe5458fbf2e48a21e4fece9
Check if data actually exists, but we're saying No Data in the source notes. Used for conditional formatting on Source Notes: FALSE
Per Metric, Per State Source Notes:
  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.


1: AS
unnamed: AS
Check if data actually exists, but we're saying No Data in the source notes. Used for conditional formatting on Source Notes: FALSE
Per Metric, Per State Source Notes:
  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


1: CA
unnamed: CA
Per Metric, Per State Source Notes: CA primary > "...with data from… " > yesterday / 23:59
Check if data actually exists, but we're saying No Data in the source notes. Used for conditional formatting on Source Notes: FALSE
Source Links:
  https://public.tableau.com/views/COVID-19CasesDashboard_15931020425010/Cases?:embed=y&:showVizHome=no

Other Notes:
  As of 6/1, an additional 3,481 hospitalized, 618 in the ICU, are listed as "Suspected COVID-19 cases"


1: CO
unnamed: CO
Check if data actually exists, but we're saying No Data in the source notes. Used for conditional formatting on Source Notes: FALSE
Per Metric, Per State Source Notes:
  CO primary > "Data is updated by about 4pm and includes cases reported through the previous day"yesterday / 23:59


1: GU
unnamed: GU
Source Links: http://dphss.guam.gov/covid-19/
Check if data actually exists, but we're saying No Data in the source notes. Used for conditional formatting on Source Notes: FALSE
Per Metric, Per State Source Notes:
  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


1: HI
unnamed: HI
Check if data actually exists, but we're saying No Data in the source notes. Used for conditional formatting on Source Notes: FALSE
Per Metric, Per State Source Notes:
  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


1: ID
unnamed: ID
Check if data actually exists, but we're saying No Data in the source notes. Used for conditional formatting on Source Notes: FALSE
Source Links:
[cell repeats an earlier one in this file: 107 characters]

Per Metric, Per State Source Notes:
  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


1: KY
unnamed: KY
Source Links: https://kygeonet.maps.arcgis.com/apps/opsdashboard/index.html#/543ac64bc40445918cf8bc34dc40e334
Check if data actually exists, but we're saying No Data in the source notes. Used for conditional formatting on Source Notes: FALSE
Per Metric, Per State Source Notes:
  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


1: LA
unnamed: LA
Source Links: http://ldh.la.gov/Coronavirus/
Check if data actually exists, but we're saying No Data in the source notes. Used for conditional formatting on Source Notes: FALSE
Per Metric, Per State Source Notes:
  LA dash > "This dashboard is updated daily by noon, except on Saturday.today / 12:00note: If no values have updated carry over previous timestamp.


1: MA
unnamed: MA
Check if data actually exists, but we're saying No Data in the source notes. Used for conditional formatting on Source Notes: FALSE
Per Metric, Per State Source Notes:
  MA primary > title "COVID-19 Interactive Data Dashboard" > "Data as of:"date from above / 23:59pmnote: the time is visible on hover


1: MD
unnamed: MD
Source Links: https://coronavirus.maryland.gov/
Check if data actually exists, but we're saying No Data in the source notes. Used for conditional formatting on Source Notes: FALSE
Per Metric, Per State Source Notes:
  MD dash > "Note: Maryland Department of Health updates these data daily during the 10am hour"today / 10:00


1: ME
unnamed: ME
Source Links: https://www.maine.gov/dhhs/mecdc/infectious-disease/epi/airborne/coronavirus/data.shtml
Check if data actually exists, but we're saying No Data in the source notes. Used for conditional formatting on Source Notes: FALSE
Per Metric, Per State Source Notes:
  ME dash > "...COVID-19 case investigation data included as of 11:59 PM the previous day"yesterday / 23:59


1: MN
unnamed: MN
Source Links: https://mndps.maps.arcgis.com/apps/opsdashboard/index.html#/f28f84968c1148129932c3bebb1d3a1a
Check if data actually exists, but we're saying No Data in the source notes. Used for conditional formatting on Source Notes: FALSE
Per Metric, Per State Source Notes:
  MN primary > "Updated daily at 11 a.m., with data current as of 4 p.m. the previous day."yesterday / 16:00


1: MT
unnamed: MT
Source Links: https://montana.maps.arcgis.com/apps/MapSeries/index.html?appid=7c34f3412536439491adcc2103421d4b
Check if data actually exists, but we're saying No Data in the source notes. Used for conditional formatting on Source Notes: FALSE
Per Metric, Per State Source Notes:
  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


1: ND
unnamed: ND
Source Links: https://www.health.nd.gov/diseases-conditions/coronavirus/north-dakota-coronavirus-cases
Check if data actually exists, but we're saying No Data in the source notes. Used for conditional formatting on Source Notes: FALSE
Per Metric, Per State Source Notes:
  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


1: NE
unnamed: NE
Source Links: https://experience.arcgis.com/experience/ece0db09da4d4ca68252c3967aa1e9dd/page/page_0/
Check if data actually exists, but we're saying No Data in the source notes. Used for conditional formatting on Source Notes: FALSE
Per Metric, Per State Source Notes:
  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. 


1: NM
unnamed: NM
Source Links: https://cvprovider.nmhealth.org/public-dashboard.html
Check if data actually exists, but we're saying No Data in the source notes. Used for conditional formatting on Source Notes: FALSE
Per Metric, Per State Source Notes:
  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. 


1: NY
unnamed: NY
Check if data actually exists, but we're saying No Data in the source notes. Used for conditional formatting on Source Notes: FALSE
Source Links:
[cell repeats an earlier one in this file: 125 characters]

Per Metric, Per State Source Notes:
  NY dash > "Testing data as of:" above date / 14:00note: in upper right corner of dash, make sure to use "as of" date/time


1: OR
unnamed: OR
Check if data actually exists, but we're saying No Data in the source notes. Used for conditional formatting on Source Notes: FALSE
Source Links:
  https://public.tableau.com/profile/oregon.health.authority.covid.19#!/vizhome/OregonCOVID-19Update/CaseandTesting

Per Metric, Per State Source Notes:
  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


1: PR
unnamed: PR
Source Links: https://bioseguridad.maps.arcgis.com/apps/opsdashboard/index.html#/d7308c1abb4747e584329adf1215125e
Check if data actually exists, but we're saying No Data in the source notes. Used for conditional formatting on Source Notes: FALSE
Per Metric, Per State Source Notes:
  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.


1: RI
unnamed: RI
Check if data actually exists, but we're saying No Data in the source notes. Used for conditional formatting on Source Notes: FALSE
Per Metric, Per State Source Notes:
  RI primary > "Updated Monday through Friday by 1pm"today / 13:00 on weekdays, Fri date / 13:00 on weekends


1: SC
unnamed: SC
Per Metric, Per State Source Notes: SC primary > "As of ..."above date / time
Check if data actually exists, but we're saying No Data in the source notes. Used for conditional formatting on Source Notes: FALSE
Source Links:
  https://scdhec.gov/infectious-diseases/viruses/coronavirus-disease-2019-covid-19/monitoring-testing-covid-19


1: TN
unnamed: TN
Source Links: https://www.tn.gov/content/tn/health/cedep/ncov/data.html
Check if data actually exists, but we're saying No Data in the source notes. Used for conditional formatting on Source Notes: FALSE
Per Metric, Per State Source Notes:
  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


1: UT
unnamed: UT
Source Links: https://coronavirus-dashboard.utah.gov/
Check if data actually exists, but we're saying No Data in the source notes. Used for conditional formatting on Source Notes: FALSE
Per Metric, Per State Source Notes:
  UT dash > "Data for this report were accessed on…"above date / above timenote: on bottom of the page


1: WA
unnamed: WA
Source Links: https://www.doh.wa.gov/Emergencies/NovelCoronavirusOutbreak2020COVID19/DataDashboard
Check if data actually exists, but we're saying No Data in the source notes. Used for conditional formatting on Source Notes: FALSE
Per Metric, Per State Source Notes:
  WA dash > "Data as of.."above date / above timenote: WA is on a permanent 1 day lag due to late updates. 


1: WV
unnamed: WV
Source Links: https://dhhr.wv.gov/COVID-19/Pages/default.aspx
Check if data actually exists, but we're saying No Data in the source notes. Used for conditional formatting on Source Notes: FALSE
Per Metric, Per State Source Notes:
  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


1: WY
unnamed: WY
Check if data actually exists, but we're saying No Data in the source notes. Used for conditional formatting on Source Notes: FALSE
Source Links:
[cell repeats an earlier one in this file: 127 characters]

Per Metric, Per State Source Notes:
  WY dash > hover over "Lab Confirmed Cases" > "there are XXXXX lab-confirmed cases of COVID-19 in Wyoming as of..." above date / above time


