ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
55 rows where cases = 27 and state = "Montana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2084767 | 2084767 | 2022-01-05 | Petroleum | Montana | 30069 | 27 | 1 |
2081515 | 2081515 | 2022-01-04 | Petroleum | Montana | 30069 | 27 | 1 |
2078263 | 2078263 | 2022-01-03 | Petroleum | Montana | 30069 | 27 | 1 |
2075012 | 2075012 | 2022-01-02 | Petroleum | Montana | 30069 | 27 | 1 |
2071761 | 2071761 | 2022-01-01 | Petroleum | Montana | 30069 | 27 | 1 |
2068510 | 2068510 | 2021-12-31 | Petroleum | Montana | 30069 | 27 | 1 |
2065259 | 2065259 | 2021-12-30 | Petroleum | Montana | 30069 | 27 | 1 |
2062009 | 2062009 | 2021-12-29 | Petroleum | Montana | 30069 | 27 | 1 |
2058760 | 2058760 | 2021-12-28 | Petroleum | Montana | 30069 | 27 | 1 |
2055511 | 2055511 | 2021-12-27 | Petroleum | Montana | 30069 | 27 | 1 |
2052261 | 2052261 | 2021-12-26 | Petroleum | Montana | 30069 | 27 | 1 |
2049011 | 2049011 | 2021-12-25 | Petroleum | Montana | 30069 | 27 | 1 |
2045761 | 2045761 | 2021-12-24 | Petroleum | Montana | 30069 | 27 | 1 |
2042511 | 2042511 | 2021-12-23 | Petroleum | Montana | 30069 | 27 | 1 |
740336 | 740336 | 2020-11-17 | Mineral | Montana | 30061 | 27 | 1 |
665715 | 665715 | 2020-10-25 | Daniels | Montana | 30019 | 27 | 1 |
662470 | 662470 | 2020-10-24 | Daniels | Montana | 30019 | 27 | 1 |
655981 | 655981 | 2020-10-22 | Daniels | Montana | 30019 | 27 | 1 |
633264 | 633264 | 2020-10-15 | Fallon | Montana | 30025 | 27 | 0 |
630019 | 630019 | 2020-10-14 | Fallon | Montana | 30025 | 27 | 0 |
630032 | 630032 | 2020-10-14 | Liberty | Montana | 30051 | 27 | 0 |
630045 | 630045 | 2020-10-14 | Powell | Montana | 30077 | 27 | 0 |
626775 | 626775 | 2020-10-13 | Fallon | Montana | 30025 | 27 | 0 |
626788 | 626788 | 2020-10-13 | Liberty | Montana | 30051 | 27 | 0 |
626801 | 626801 | 2020-10-13 | Powell | Montana | 30077 | 27 | 0 |
623533 | 623533 | 2020-10-12 | Fallon | Montana | 30025 | 27 | 0 |
623546 | 623546 | 2020-10-12 | Liberty | Montana | 30051 | 27 | 0 |
613840 | 613840 | 2020-10-09 | Sheridan | Montana | 30091 | 27 | 0 |
610581 | 610581 | 2020-10-08 | McCone | Montana | 30055 | 27 | 0 |
610590 | 610590 | 2020-10-08 | Powder River | Montana | 30075 | 27 | 0 |
610598 | 610598 | 2020-10-08 | Sheridan | Montana | 30091 | 27 | 0 |
607339 | 607339 | 2020-10-07 | McCone | Montana | 30055 | 27 | 0 |
607348 | 607348 | 2020-10-07 | Powder River | Montana | 30075 | 27 | 0 |
607356 | 607356 | 2020-10-07 | Sheridan | Montana | 30091 | 27 | 0 |
604096 | 604096 | 2020-10-06 | McCone | Montana | 30055 | 27 | 0 |
600854 | 600854 | 2020-10-05 | McCone | Montana | 30055 | 27 | 0 |
597611 | 597611 | 2020-10-04 | McCone | Montana | 30055 | 27 | 0 |
594370 | 594370 | 2020-10-03 | McCone | Montana | 30055 | 27 | 0 |
532829 | 532829 | 2020-09-14 | Musselshell | Montana | 30065 | 27 | 1 |
429403 | 429403 | 2020-08-13 | Dawson | Montana | 30021 | 27 | 0 |
410085 | 410085 | 2020-08-07 | Jefferson | Montana | 30043 | 27 | 0 |
406865 | 406865 | 2020-08-06 | Jefferson | Montana | 30043 | 27 | 0 |
403647 | 403647 | 2020-08-05 | Jefferson | Montana | 30043 | 27 | 0 |
400430 | 400430 | 2020-08-04 | Jefferson | Montana | 30043 | 27 | 0 |
397216 | 397216 | 2020-08-03 | Jefferson | Montana | 30043 | 27 | 0 |
377895 | 377895 | 2020-07-28 | Beaverhead | Montana | 30001 | 27 | 0 |
320322 | 320322 | 2020-07-10 | Glacier | Montana | 30035 | 27 | 0 |
304459 | 304459 | 2020-07-05 | Carbon | Montana | 30009 | 27 | 0 |
301295 | 301295 | 2020-07-04 | Carbon | Montana | 30009 | 27 | 0 |
288671 | 288671 | 2020-06-30 | Custer | Montana | 30017 | 27 | 0 |
288692 | 288692 | 2020-06-30 | Ravalli | Montana | 30081 | 27 | 0 |
285521 | 285521 | 2020-06-29 | Custer | Montana | 30017 | 27 | 0 |
285542 | 285542 | 2020-06-29 | Ravalli | Montana | 30081 | 27 | 0 |
282375 | 282375 | 2020-06-28 | Cascade | Montana | 30013 | 27 | 2 |
279227 | 279227 | 2020-06-27 | Cascade | Montana | 30013 | 27 | 2 |
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);