ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
39 rows where cases = 1062 and state = "Montana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
state 1
- Montana · 39 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2449117 | 2449117 | 2022-04-27 | Phillips | Montana | 30071 | 1062 | 28 |
2445860 | 2445860 | 2022-04-26 | Phillips | Montana | 30071 | 1062 | 28 |
2442605 | 2442605 | 2022-04-25 | Phillips | Montana | 30071 | 1062 | 28 |
2439349 | 2439349 | 2022-04-24 | Phillips | Montana | 30071 | 1062 | 28 |
2436093 | 2436093 | 2022-04-23 | Phillips | Montana | 30071 | 1062 | 28 |
2432837 | 2432837 | 2022-04-22 | Phillips | Montana | 30071 | 1062 | 28 |
2429581 | 2429581 | 2022-04-21 | Phillips | Montana | 30071 | 1062 | 28 |
2426325 | 2426325 | 2022-04-20 | Phillips | Montana | 30071 | 1062 | 28 |
2423069 | 2423069 | 2022-04-19 | Phillips | Montana | 30071 | 1062 | 28 |
2419812 | 2419812 | 2022-04-18 | Phillips | Montana | 30071 | 1062 | 28 |
2416557 | 2416557 | 2022-04-17 | Phillips | Montana | 30071 | 1062 | 28 |
2413301 | 2413301 | 2022-04-16 | Phillips | Montana | 30071 | 1062 | 28 |
2410045 | 2410045 | 2022-04-15 | Phillips | Montana | 30071 | 1062 | 28 |
2406789 | 2406789 | 2022-04-14 | Phillips | Montana | 30071 | 1062 | 28 |
2403533 | 2403533 | 2022-04-13 | Phillips | Montana | 30071 | 1062 | 28 |
2400278 | 2400278 | 2022-04-12 | Phillips | Montana | 30071 | 1062 | 28 |
2397023 | 2397023 | 2022-04-11 | Phillips | Montana | 30071 | 1062 | 28 |
2393768 | 2393768 | 2022-04-10 | Phillips | Montana | 30071 | 1062 | 28 |
2390512 | 2390512 | 2022-04-09 | Phillips | Montana | 30071 | 1062 | 28 |
2387256 | 2387256 | 2022-04-08 | Phillips | Montana | 30071 | 1062 | 28 |
2384001 | 2384001 | 2022-04-07 | Phillips | Montana | 30071 | 1062 | 28 |
2380746 | 2380746 | 2022-04-06 | Phillips | Montana | 30071 | 1062 | 28 |
2377491 | 2377491 | 2022-04-05 | Phillips | Montana | 30071 | 1062 | 28 |
2374238 | 2374238 | 2022-04-04 | Phillips | Montana | 30071 | 1062 | 28 |
2370986 | 2370986 | 2022-04-03 | Phillips | Montana | 30071 | 1062 | 28 |
2367733 | 2367733 | 2022-04-02 | Phillips | Montana | 30071 | 1062 | 28 |
2364480 | 2364480 | 2022-04-01 | Phillips | Montana | 30071 | 1062 | 28 |
2361226 | 2361226 | 2022-03-31 | Phillips | Montana | 30071 | 1062 | 28 |
2357972 | 2357972 | 2022-03-30 | Phillips | Montana | 30071 | 1062 | 28 |
2338455 | 2338455 | 2022-03-24 | Phillips | Montana | 30071 | 1062 | 28 |
2335201 | 2335201 | 2022-03-23 | Phillips | Montana | 30071 | 1062 | 28 |
1779292 | 1779292 | 2021-10-03 | Valley | Montana | 30105 | 1062 | 21 |
1776042 | 1776042 | 2021-10-02 | Valley | Montana | 30105 | 1062 | 21 |
1772792 | 1772792 | 2021-10-01 | Valley | Montana | 30105 | 1062 | 21 |
1759771 | 1759771 | 2021-09-27 | Madison | Montana | 30057 | 1062 | 8 |
1100573 | 1100573 | 2021-03-08 | Fergus | Montana | 30027 | 1062 | 27 |
1097326 | 1097326 | 2021-03-07 | Fergus | Montana | 30027 | 1062 | 27 |
1094079 | 1094079 | 2021-03-06 | Fergus | Montana | 30027 | 1062 | 27 |
578152 | 578152 | 2020-09-28 | Flathead | Montana | 30029 | 1062 | 17 |
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);