ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
41 rows where cases = 271 and state = "Montana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1984020 | 1984020 | 2021-12-05 | Wheatland | Montana | 30107 | 271 | 13 |
1980770 | 1980770 | 2021-12-04 | Wheatland | Montana | 30107 | 271 | 13 |
1977520 | 1977520 | 2021-12-03 | Wheatland | Montana | 30107 | 271 | 13 |
1974270 | 1974270 | 2021-12-02 | Wheatland | Montana | 30107 | 271 | 13 |
1971021 | 1971021 | 2021-12-01 | Wheatland | Montana | 30107 | 271 | 13 |
1967771 | 1967771 | 2021-11-30 | Wheatland | Montana | 30107 | 271 | 13 |
1961244 | 1961244 | 2021-11-28 | Meagher | Montana | 30059 | 271 | 9 |
1957993 | 1957993 | 2021-11-27 | Meagher | Montana | 30059 | 271 | 9 |
1954742 | 1954742 | 2021-11-26 | Meagher | Montana | 30059 | 271 | 9 |
1873493 | 1873493 | 2021-11-01 | McCone | Montana | 30055 | 271 | 3 |
1847509 | 1847509 | 2021-10-24 | Powder River | Montana | 30075 | 271 | 9 |
1844259 | 1844259 | 2021-10-23 | Powder River | Montana | 30075 | 271 | 9 |
1841009 | 1841009 | 2021-10-22 | Powder River | Montana | 30075 | 271 | 9 |
1837760 | 1837760 | 2021-10-21 | Powder River | Montana | 30075 | 271 | 9 |
964253 | 964253 | 2021-01-25 | Fallon | Montana | 30025 | 271 | 2 |
961008 | 961008 | 2021-01-24 | Fallon | Montana | 30025 | 271 | 2 |
957762 | 957762 | 2021-01-23 | Fallon | Montana | 30025 | 271 | 2 |
954517 | 954517 | 2021-01-22 | Fallon | Montana | 30025 | 271 | 2 |
951272 | 951272 | 2021-01-21 | Fallon | Montana | 30025 | 271 | 2 |
948026 | 948026 | 2021-01-20 | Fallon | Montana | 30025 | 271 | 2 |
944779 | 944779 | 2021-01-19 | Fallon | Montana | 30025 | 271 | 2 |
941534 | 941534 | 2021-01-18 | Fallon | Montana | 30025 | 271 | 2 |
938289 | 938289 | 2021-01-17 | Fallon | Montana | 30025 | 271 | 2 |
935044 | 935044 | 2021-01-16 | Fallon | Montana | 30025 | 271 | 2 |
931799 | 931799 | 2021-01-15 | Fallon | Montana | 30025 | 271 | 2 |
928554 | 928554 | 2021-01-14 | Fallon | Montana | 30025 | 271 | 2 |
925308 | 925308 | 2021-01-13 | Fallon | Montana | 30025 | 271 | 2 |
922063 | 922063 | 2021-01-12 | Fallon | Montana | 30025 | 271 | 2 |
918818 | 918818 | 2021-01-11 | Fallon | Montana | 30025 | 271 | 2 |
915573 | 915573 | 2021-01-10 | Fallon | Montana | 30025 | 271 | 2 |
912328 | 912328 | 2021-01-09 | Fallon | Montana | 30025 | 271 | 2 |
909083 | 909083 | 2021-01-08 | Fallon | Montana | 30025 | 271 | 2 |
772801 | 772801 | 2020-11-27 | Phillips | Montana | 30071 | 271 | 6 |
769528 | 769528 | 2020-11-26 | Chouteau | Montana | 30015 | 271 | 3 |
769556 | 769556 | 2020-11-26 | Phillips | Montana | 30071 | 271 | 6 |
698151 | 698151 | 2020-11-04 | Fergus | Montana | 30027 | 271 | 2 |
685197 | 685197 | 2020-10-31 | Park | Montana | 30067 | 271 | 0 |
662463 | 662463 | 2020-10-24 | Blaine | Montana | 30005 | 271 | 2 |
630018 | 630018 | 2020-10-14 | Deer Lodge | Montana | 30023 | 271 | 0 |
381113 | 381113 | 2020-07-29 | Big Horn | Montana | 30003 | 271 | 5 |
291827 | 291827 | 2020-07-01 | Gallatin | Montana | 30031 | 271 | 1 |
Advanced export
JSON shape: default, array, newline-delimited
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);