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

18 rows where deaths = 682 sorted by date descending

✎ View and edit SQL

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

Suggested facets: fips, cases, date (date)

Link rowid date ▲ state fips cases deaths
46928 46928 2022-06-28 Vermont 50 135030 682
46872 46872 2022-06-27 Vermont 50 135030 682
46816 46816 2022-06-26 Vermont 50 135030 682
46760 46760 2022-06-25 Vermont 50 135030 682
46704 46704 2022-06-24 Vermont 50 135030 682
46648 46648 2022-06-23 Vermont 50 135030 682
46592 46592 2022-06-22 Vermont 50 135030 682
20419 20419 2021-03-08 Wyoming 56 54903 682
20364 20364 2021-03-07 Wyoming 56 54764 682
20309 20309 2021-03-06 Wyoming 56 54764 682
20254 20254 2021-03-05 Wyoming 56 54764 682
20199 20199 2021-03-04 Wyoming 56 54685 682
20144 20144 2021-03-03 Wyoming 56 54616 682
20089 20089 2021-03-02 Wyoming 56 54527 682
14697 14697 2020-11-24 West Virginia 54 42083 682
9293 9293 2020-08-18 Oklahoma 40 49326 682
2610 2610 2020-04-19 Georgia 13 17619 682
2174 2174 2020-04-11 Illinois 17 19180 682

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
);