ny_times_us_counties

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

17 rows where cases = 676 and state = "Michigan" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips 10

state 1

  • Michigan · 17 ✖
Link rowid date ▲ county state fips cases deaths
1655477 1655477 2021-08-26 Montmorency Michigan 26119 676 20
1652230 1652230 2021-08-25 Montmorency Michigan 26119 676 20
1648982 1648982 2021-08-24 Montmorency Michigan 26119 676 20
1645733 1645733 2021-08-23 Montmorency Michigan 26119 676 20
1373002 1373002 2021-05-31 Oscoda Michigan 26135 676 30
1369757 1369757 2021-05-30 Oscoda Michigan 26135 676 30
1366511 1366511 2021-05-29 Oscoda Michigan 26135 676 30
1249563 1249563 2021-04-23 Alcona Michigan 26001 676 26
1132724 1132724 2021-03-18 Presque Isle Michigan 26141 676 28
1126198 1126198 2021-03-16 Kalkaska Michigan 26079 676 15
756183 756183 2020-11-22 Chippewa Michigan 26033 676 2
752937 752937 2020-11-21 Chippewa Michigan 26033 676 2
688100 688100 2020-11-01 Oceana Michigan 26127 676 6
684856 684856 2020-10-31 Oceana Michigan 26127 676 6
477523 477523 2020-08-28 St. Joseph Michigan 26149 676 11
358279 358279 2020-07-22 Calhoun Michigan 26025 676 39
93667 93667 2020-04-27 Jackson Michigan 26075 676 28

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
CREATE INDEX [idx_ny_times_us_counties_state]
    ON [ny_times_us_counties] ([state]);
CREATE INDEX [idx_ny_times_us_counties_county]
    ON [ny_times_us_counties] ([county]);
CREATE INDEX [idx_ny_times_us_counties_fips]
    ON [ny_times_us_counties] ([fips]);
CREATE INDEX [idx_ny_times_us_counties_date]
    ON [ny_times_us_counties] ([date] desc);