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

14 rows where cases = 907 and state = "Montana" sorted by date descending

✎ View and edit SQL

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

fips 8

state 1

  • Montana · 14 ✖
Link rowid date ▲ county state fips cases deaths
2244136 2244136 2022-02-23 Musselshell Montana 30065 907 26
1675278 1675278 2021-09-01 Blaine Montana 30005 907 24
1574627 1574627 2021-08-01 Valley Montana 30105 907 18
1571379 1571379 2021-07-31 Valley Montana 30105 907 18
1568131 1568131 2021-07-30 Valley Montana 30105 907 18
1460940 1460940 2021-06-27 Carbon Montana 30009 907 17
1457695 1457695 2021-06-26 Carbon Montana 30009 907 17
1454450 1454450 2021-06-25 Carbon Montana 30009 907 17
951281 951281 2021-01-21 Jefferson Montana 30043 907 7
912329 912329 2021-01-09 Fergus Montana 30027 907 15
850664 850664 2020-12-21 Custer Montana 30017 907 8
847419 847419 2020-12-20 Custer Montana 30017 907 8
844173 844173 2020-12-19 Custer Montana 30017 907 8
808504 808504 2020-12-08 Rosebud Montana 30087 907 25

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