ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
19 rows where cases = 400 and state = "Montana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- Montana · 19 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2224627 | 2224627 | 2022-02-17 | Meagher | Montana | 30059 | 400 | 10 |
2221376 | 2221376 | 2022-02-16 | Meagher | Montana | 30059 | 400 | 10 |
2218125 | 2218125 | 2022-02-15 | Meagher | Montana | 30059 | 400 | 10 |
1892980 | 1892980 | 2021-11-07 | Granite | Montana | 30039 | 400 | 5 |
1889730 | 1889730 | 2021-11-06 | Granite | Montana | 30039 | 400 | 5 |
1886480 | 1886480 | 2021-11-05 | Granite | Montana | 30039 | 400 | 5 |
1357124 | 1357124 | 2021-05-26 | Sweet Grass | Montana | 30097 | 400 | 7 |
1353878 | 1353878 | 2021-05-25 | Sweet Grass | Montana | 30097 | 400 | 7 |
1350632 | 1350632 | 2021-05-24 | Sweet Grass | Montana | 30097 | 400 | 7 |
1347386 | 1347386 | 2021-05-23 | Sweet Grass | Montana | 30097 | 400 | 7 |
1344138 | 1344138 | 2021-05-22 | Sweet Grass | Montana | 30097 | 400 | 7 |
1340890 | 1340890 | 2021-05-21 | Sweet Grass | Montana | 30097 | 400 | 7 |
1337642 | 1337642 | 2021-05-20 | Sweet Grass | Montana | 30097 | 400 | 7 |
996747 | 996747 | 2021-02-04 | Teton | Montana | 30099 | 400 | 5 |
701390 | 701390 | 2020-11-05 | Custer | Montana | 30017 | 400 | 5 |
636521 | 636521 | 2020-10-16 | Lake | Montana | 30047 | 400 | 1 |
626783 | 626783 | 2020-10-13 | Hill | Montana | 30041 | 400 | 5 |
458465 | 458465 | 2020-08-22 | Missoula | Montana | 30063 | 400 | 3 |
455237 | 455237 | 2020-08-21 | Missoula | Montana | 30063 | 400 | 3 |
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);