ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
43 rows where cases = 85 and state = "Montana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
fips 16
county 16
- Judith Basin 18
- Beaverhead 4
- Ravalli 4
- Fallon 3
- Silver Bow 2
- Yellowstone 2
- Broadwater 1
- Carbon 1
- Custer 1
- Deer Lodge 1
- Liberty 1
- Lincoln 1
- Madison 1
- Phillips 1
- Stillwater 1
- Treasure 1
state 1
- Montana · 43 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1850773 | 1850773 | 2021-10-25 | Treasure | Montana | 30103 | 85 | 1 |
1071368 | 1071368 | 2021-02-27 | Judith Basin | Montana | 30045 | 85 | 1 |
1068123 | 1068123 | 2021-02-26 | Judith Basin | Montana | 30045 | 85 | 1 |
1064878 | 1064878 | 2021-02-25 | Judith Basin | Montana | 30045 | 85 | 1 |
1061634 | 1061634 | 2021-02-24 | Judith Basin | Montana | 30045 | 85 | 1 |
1058388 | 1058388 | 2021-02-23 | Judith Basin | Montana | 30045 | 85 | 1 |
1055142 | 1055142 | 2021-02-22 | Judith Basin | Montana | 30045 | 85 | 1 |
1051895 | 1051895 | 2021-02-21 | Judith Basin | Montana | 30045 | 85 | 1 |
1048648 | 1048648 | 2021-02-20 | Judith Basin | Montana | 30045 | 85 | 1 |
1045402 | 1045402 | 2021-02-19 | Judith Basin | Montana | 30045 | 85 | 1 |
1042157 | 1042157 | 2021-02-18 | Judith Basin | Montana | 30045 | 85 | 1 |
1038912 | 1038912 | 2021-02-17 | Judith Basin | Montana | 30045 | 85 | 1 |
1035667 | 1035667 | 2021-02-16 | Judith Basin | Montana | 30045 | 85 | 1 |
1032422 | 1032422 | 2021-02-15 | Judith Basin | Montana | 30045 | 85 | 1 |
1029175 | 1029175 | 2021-02-14 | Judith Basin | Montana | 30045 | 85 | 1 |
1025929 | 1025929 | 2021-02-13 | Judith Basin | Montana | 30045 | 85 | 1 |
1022684 | 1022684 | 2021-02-12 | Judith Basin | Montana | 30045 | 85 | 1 |
1019439 | 1019439 | 2021-02-11 | Judith Basin | Montana | 30045 | 85 | 1 |
1016194 | 1016194 | 2021-02-10 | Judith Basin | Montana | 30045 | 85 | 1 |
776036 | 776036 | 2020-11-28 | Liberty | Montana | 30051 | 85 | 1 |
691665 | 691665 | 2020-11-02 | Fallon | Montana | 30025 | 85 | 0 |
688420 | 688420 | 2020-11-01 | Fallon | Montana | 30025 | 85 | 0 |
685176 | 685176 | 2020-10-31 | Fallon | Montana | 30025 | 85 | 0 |
681924 | 681924 | 2020-10-30 | Broadwater | Montana | 30007 | 85 | 0 |
591147 | 591147 | 2020-10-02 | Stillwater | Montana | 30095 | 85 | 2 |
578138 | 578138 | 2020-09-28 | Beaverhead | Montana | 30001 | 85 | 1 |
574897 | 574897 | 2020-09-27 | Beaverhead | Montana | 30001 | 85 | 1 |
571654 | 571654 | 2020-09-26 | Beaverhead | Montana | 30001 | 85 | 1 |
568412 | 568412 | 2020-09-25 | Beaverhead | Montana | 30001 | 85 | 1 |
539277 | 539277 | 2020-09-16 | Custer | Montana | 30017 | 85 | 2 |
526336 | 526336 | 2020-09-12 | Deer Lodge | Montana | 30023 | 85 | 0 |
474588 | 474588 | 2020-08-27 | Carbon | Montana | 30009 | 85 | 0 |
471377 | 471377 | 2020-08-26 | Lincoln | Montana | 30053 | 85 | 2 |
442337 | 442337 | 2020-08-17 | Ravalli | Montana | 30081 | 85 | 2 |
439098 | 439098 | 2020-08-16 | Madison | Montana | 30057 | 85 | 1 |
439110 | 439110 | 2020-08-16 | Ravalli | Montana | 30081 | 85 | 2 |
435885 | 435885 | 2020-08-15 | Ravalli | Montana | 30081 | 85 | 2 |
432654 | 432654 | 2020-08-14 | Phillips | Montana | 30071 | 85 | 0 |
432659 | 432659 | 2020-08-14 | Ravalli | Montana | 30081 | 85 | 2 |
413328 | 413328 | 2020-08-08 | Silver Bow | Montana | 30093 | 85 | 0 |
410108 | 410108 | 2020-08-07 | Silver Bow | Montana | 30093 | 85 | 0 |
152775 | 152775 | 2020-05-17 | Yellowstone | Montana | 30111 | 85 | 2 |
149764 | 149764 | 2020-05-16 | Yellowstone | Montana | 30111 | 85 | 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);