ny_times_us_states

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

25 rows where deaths = 0 and state = "Hawaii" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: cases

state 1

  • Hawaii · 25 ✖
Link rowid date ▲ state fips cases deaths
1512 1512 2020-03-30 Hawaii 15 204 0
1457 1457 2020-03-29 Hawaii 15 175 0
1402 1402 2020-03-28 Hawaii 15 151 0
1348 1348 2020-03-27 Hawaii 15 120 0
1294 1294 2020-03-26 Hawaii 15 106 0
1240 1240 2020-03-25 Hawaii 15 95 0
1186 1186 2020-03-24 Hawaii 15 90 0
1132 1132 2020-03-23 Hawaii 15 77 0
1078 1078 2020-03-22 Hawaii 15 56 0
1024 1024 2020-03-21 Hawaii 15 48 0
970 970 2020-03-20 Hawaii 15 37 0
916 916 2020-03-19 Hawaii 15 26 0
862 862 2020-03-18 Hawaii 15 16 0
808 808 2020-03-17 Hawaii 15 14 0
755 755 2020-03-16 Hawaii 15 10 0
702 702 2020-03-15 Hawaii 15 7 0
649 649 2020-03-14 Hawaii 15 4 0
598 598 2020-03-13 Hawaii 15 2 0
550 550 2020-03-12 Hawaii 15 2 0
504 504 2020-03-11 Hawaii 15 2 0
463 463 2020-03-10 Hawaii 15 2 0
426 426 2020-03-09 Hawaii 15 2 0
391 391 2020-03-08 Hawaii 15 2 0
357 357 2020-03-07 Hawaii 15 1 0
328 328 2020-03-06 Hawaii 15 1 0

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [ny_times_us_states] (
   [date] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);