ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
40 rows where cases = 162 and state = "Montana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 11
state 1
- Montana · 40 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2058742 | 2058742 | 2021-12-28 | Garfield | Montana | 30033 | 162 | 3 |
2055493 | 2055493 | 2021-12-27 | Garfield | Montana | 30033 | 162 | 3 |
2052243 | 2052243 | 2021-12-26 | Garfield | Montana | 30033 | 162 | 3 |
2048993 | 2048993 | 2021-12-25 | Garfield | Montana | 30033 | 162 | 3 |
2045743 | 2045743 | 2021-12-24 | Garfield | Montana | 30033 | 162 | 3 |
2042493 | 2042493 | 2021-12-23 | Garfield | Montana | 30033 | 162 | 3 |
2039244 | 2039244 | 2021-12-22 | Garfield | Montana | 30033 | 162 | 3 |
2035994 | 2035994 | 2021-12-21 | Garfield | Montana | 30033 | 162 | 3 |
2032744 | 2032744 | 2021-12-20 | Garfield | Montana | 30033 | 162 | 3 |
2029493 | 2029493 | 2021-12-19 | Garfield | Montana | 30033 | 162 | 3 |
2026242 | 2026242 | 2021-12-18 | Garfield | Montana | 30033 | 162 | 3 |
2022991 | 2022991 | 2021-12-17 | Garfield | Montana | 30033 | 162 | 3 |
2019740 | 2019740 | 2021-12-16 | Garfield | Montana | 30033 | 162 | 3 |
2016490 | 2016490 | 2021-12-15 | Garfield | Montana | 30033 | 162 | 3 |
2013239 | 2013239 | 2021-12-14 | Garfield | Montana | 30033 | 162 | 3 |
2009988 | 2009988 | 2021-12-13 | Garfield | Montana | 30033 | 162 | 3 |
2006737 | 2006737 | 2021-12-12 | Garfield | Montana | 30033 | 162 | 3 |
2003486 | 2003486 | 2021-12-11 | Garfield | Montana | 30033 | 162 | 3 |
2000236 | 2000236 | 2021-12-10 | Garfield | Montana | 30033 | 162 | 3 |
1996985 | 1996985 | 2021-12-09 | Garfield | Montana | 30033 | 162 | 3 |
1993734 | 1993734 | 2021-12-08 | Garfield | Montana | 30033 | 162 | 3 |
1990483 | 1990483 | 2021-12-07 | Garfield | Montana | 30033 | 162 | 3 |
1828030 | 1828030 | 2021-10-18 | Wibaux | Montana | 30109 | 162 | 7 |
990234 | 990234 | 2021-02-02 | McCone | Montana | 30055 | 162 | 0 |
886370 | 886370 | 2021-01-01 | Granite | Montana | 30039 | 162 | 2 |
883125 | 883125 | 2020-12-31 | Granite | Montana | 30039 | 162 | 2 |
879880 | 879880 | 2020-12-30 | Granite | Montana | 30039 | 162 | 2 |
876635 | 876635 | 2020-12-29 | Granite | Montana | 30039 | 162 | 2 |
873390 | 873390 | 2020-12-28 | Granite | Montana | 30039 | 162 | 2 |
870145 | 870145 | 2020-12-27 | Granite | Montana | 30039 | 162 | 2 |
866900 | 866900 | 2020-12-26 | Granite | Montana | 30039 | 162 | 2 |
863655 | 863655 | 2020-12-25 | Granite | Montana | 30039 | 162 | 2 |
860410 | 860410 | 2020-12-24 | Granite | Montana | 30039 | 162 | 2 |
665741 | 665741 | 2020-10-25 | Phillips | Montana | 30071 | 162 | 0 |
646248 | 646248 | 2020-10-19 | Dawson | Montana | 30021 | 162 | 1 |
623562 | 623562 | 2020-10-12 | Richland | Montana | 30083 | 162 | 2 |
526342 | 526342 | 2020-09-12 | Glacier | Montana | 30035 | 162 | 1 |
422971 | 422971 | 2020-08-11 | Lewis and Clark | Montana | 30049 | 162 | 2 |
410070 | 410070 | 2020-08-07 | Cascade | Montana | 30013 | 162 | 3 |
216897 | 216897 | 2020-06-07 | Gallatin | Montana | 30031 | 162 | 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);