ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,447 rows where deaths = 3 and state = "Montana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Garfield 267
- Pondera 216
- Prairie 128
- Madison 53
- Lincoln 52
- Lewis and Clark 49
- Missoula 47
- Teton 43
- Gallatin 41
- McCone 36
- Sanders 35
- Chouteau 33
- Golden Valley 32
- Fallon 31
- Stillwater 31
- Wheatland 30
- Yellowstone 27
- Beaverhead 26
- Daniels 23
- Hill 22
- Carter 18
- Big Horn 16
- Park 16
- Powell 16
- Sheridan 16
- Toole 15
- Custer 14
- Flathead 14
- Liberty 13
- Sweet Grass 11
- …
state 1
- Montana · 1,447 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501209 | 2501209 | 2022-05-13 | Garfield | Montana | 30033 | 225 | 3 |
2501232 | 2501232 | 2022-05-13 | Prairie | Montana | 30079 | 263 | 3 |
2497951 | 2497951 | 2022-05-12 | Garfield | Montana | 30033 | 225 | 3 |
2497974 | 2497974 | 2022-05-12 | Prairie | Montana | 30079 | 263 | 3 |
2494693 | 2494693 | 2022-05-11 | Garfield | Montana | 30033 | 225 | 3 |
2494716 | 2494716 | 2022-05-11 | Prairie | Montana | 30079 | 263 | 3 |
2491435 | 2491435 | 2022-05-10 | Garfield | Montana | 30033 | 225 | 3 |
2491458 | 2491458 | 2022-05-10 | Prairie | Montana | 30079 | 263 | 3 |
2488177 | 2488177 | 2022-05-09 | Garfield | Montana | 30033 | 225 | 3 |
2488200 | 2488200 | 2022-05-09 | Prairie | Montana | 30079 | 263 | 3 |
2484920 | 2484920 | 2022-05-08 | Garfield | Montana | 30033 | 225 | 3 |
2484943 | 2484943 | 2022-05-08 | Prairie | Montana | 30079 | 263 | 3 |
2481662 | 2481662 | 2022-05-07 | Garfield | Montana | 30033 | 225 | 3 |
2481685 | 2481685 | 2022-05-07 | Prairie | Montana | 30079 | 263 | 3 |
2478404 | 2478404 | 2022-05-06 | Garfield | Montana | 30033 | 225 | 3 |
2478427 | 2478427 | 2022-05-06 | Prairie | Montana | 30079 | 263 | 3 |
2475146 | 2475146 | 2022-05-05 | Garfield | Montana | 30033 | 225 | 3 |
2475169 | 2475169 | 2022-05-05 | Prairie | Montana | 30079 | 263 | 3 |
2471889 | 2471889 | 2022-05-04 | Garfield | Montana | 30033 | 225 | 3 |
2471912 | 2471912 | 2022-05-04 | Prairie | Montana | 30079 | 263 | 3 |
2468633 | 2468633 | 2022-05-03 | Garfield | Montana | 30033 | 225 | 3 |
2468656 | 2468656 | 2022-05-03 | Prairie | Montana | 30079 | 263 | 3 |
2465377 | 2465377 | 2022-05-02 | Garfield | Montana | 30033 | 225 | 3 |
2465400 | 2465400 | 2022-05-02 | Prairie | Montana | 30079 | 263 | 3 |
2462122 | 2462122 | 2022-05-01 | Garfield | Montana | 30033 | 225 | 3 |
2462145 | 2462145 | 2022-05-01 | Prairie | Montana | 30079 | 263 | 3 |
2458866 | 2458866 | 2022-04-30 | Garfield | Montana | 30033 | 225 | 3 |
2458889 | 2458889 | 2022-04-30 | Prairie | Montana | 30079 | 263 | 3 |
2455610 | 2455610 | 2022-04-29 | Garfield | Montana | 30033 | 225 | 3 |
2455633 | 2455633 | 2022-04-29 | Prairie | Montana | 30079 | 263 | 3 |
2452354 | 2452354 | 2022-04-28 | Garfield | Montana | 30033 | 225 | 3 |
2452377 | 2452377 | 2022-04-28 | Prairie | Montana | 30079 | 263 | 3 |
2449098 | 2449098 | 2022-04-27 | Garfield | Montana | 30033 | 225 | 3 |
2449121 | 2449121 | 2022-04-27 | Prairie | Montana | 30079 | 263 | 3 |
2445841 | 2445841 | 2022-04-26 | Garfield | Montana | 30033 | 225 | 3 |
2445864 | 2445864 | 2022-04-26 | Prairie | Montana | 30079 | 263 | 3 |
2442586 | 2442586 | 2022-04-25 | Garfield | Montana | 30033 | 225 | 3 |
2442609 | 2442609 | 2022-04-25 | Prairie | Montana | 30079 | 263 | 3 |
2439330 | 2439330 | 2022-04-24 | Garfield | Montana | 30033 | 225 | 3 |
2439353 | 2439353 | 2022-04-24 | Prairie | Montana | 30079 | 263 | 3 |
2436074 | 2436074 | 2022-04-23 | Garfield | Montana | 30033 | 225 | 3 |
2436097 | 2436097 | 2022-04-23 | Prairie | Montana | 30079 | 263 | 3 |
2432818 | 2432818 | 2022-04-22 | Garfield | Montana | 30033 | 225 | 3 |
2432841 | 2432841 | 2022-04-22 | Prairie | Montana | 30079 | 263 | 3 |
2429562 | 2429562 | 2022-04-21 | Garfield | Montana | 30033 | 225 | 3 |
2429585 | 2429585 | 2022-04-21 | Prairie | Montana | 30079 | 263 | 3 |
2426306 | 2426306 | 2022-04-20 | Garfield | Montana | 30033 | 225 | 3 |
2426329 | 2426329 | 2022-04-20 | Prairie | Montana | 30079 | 263 | 3 |
2423050 | 2423050 | 2022-04-19 | Garfield | Montana | 30033 | 225 | 3 |
2423073 | 2423073 | 2022-04-19 | Prairie | Montana | 30079 | 263 | 3 |
2419793 | 2419793 | 2022-04-18 | Garfield | Montana | 30033 | 225 | 3 |
2419816 | 2419816 | 2022-04-18 | Prairie | Montana | 30079 | 263 | 3 |
2416538 | 2416538 | 2022-04-17 | Garfield | Montana | 30033 | 225 | 3 |
2416561 | 2416561 | 2022-04-17 | Prairie | Montana | 30079 | 263 | 3 |
2413282 | 2413282 | 2022-04-16 | Garfield | Montana | 30033 | 225 | 3 |
2413305 | 2413305 | 2022-04-16 | Prairie | Montana | 30079 | 263 | 3 |
2410026 | 2410026 | 2022-04-15 | Garfield | Montana | 30033 | 225 | 3 |
2410049 | 2410049 | 2022-04-15 | Prairie | Montana | 30079 | 263 | 3 |
2406770 | 2406770 | 2022-04-14 | Garfield | Montana | 30033 | 225 | 3 |
2406793 | 2406793 | 2022-04-14 | Prairie | Montana | 30079 | 263 | 3 |
2403514 | 2403514 | 2022-04-13 | Garfield | Montana | 30033 | 225 | 3 |
2403537 | 2403537 | 2022-04-13 | Prairie | Montana | 30079 | 263 | 3 |
2400259 | 2400259 | 2022-04-12 | Garfield | Montana | 30033 | 225 | 3 |
2400282 | 2400282 | 2022-04-12 | Prairie | Montana | 30079 | 263 | 3 |
2397004 | 2397004 | 2022-04-11 | Garfield | Montana | 30033 | 225 | 3 |
2397027 | 2397027 | 2022-04-11 | Prairie | Montana | 30079 | 263 | 3 |
2393749 | 2393749 | 2022-04-10 | Garfield | Montana | 30033 | 225 | 3 |
2393772 | 2393772 | 2022-04-10 | Prairie | Montana | 30079 | 263 | 3 |
2390493 | 2390493 | 2022-04-09 | Garfield | Montana | 30033 | 225 | 3 |
2390516 | 2390516 | 2022-04-09 | Prairie | Montana | 30079 | 263 | 3 |
2387237 | 2387237 | 2022-04-08 | Garfield | Montana | 30033 | 225 | 3 |
2387260 | 2387260 | 2022-04-08 | Prairie | Montana | 30079 | 263 | 3 |
2383982 | 2383982 | 2022-04-07 | Garfield | Montana | 30033 | 225 | 3 |
2384005 | 2384005 | 2022-04-07 | Prairie | Montana | 30079 | 263 | 3 |
2380727 | 2380727 | 2022-04-06 | Garfield | Montana | 30033 | 225 | 3 |
2380750 | 2380750 | 2022-04-06 | Prairie | Montana | 30079 | 262 | 3 |
2377472 | 2377472 | 2022-04-05 | Garfield | Montana | 30033 | 225 | 3 |
2377495 | 2377495 | 2022-04-05 | Prairie | Montana | 30079 | 262 | 3 |
2374219 | 2374219 | 2022-04-04 | Garfield | Montana | 30033 | 225 | 3 |
2374242 | 2374242 | 2022-04-04 | Prairie | Montana | 30079 | 262 | 3 |
2370967 | 2370967 | 2022-04-03 | Garfield | Montana | 30033 | 225 | 3 |
2370990 | 2370990 | 2022-04-03 | Prairie | Montana | 30079 | 262 | 3 |
2367714 | 2367714 | 2022-04-02 | Garfield | Montana | 30033 | 225 | 3 |
2367737 | 2367737 | 2022-04-02 | Prairie | Montana | 30079 | 262 | 3 |
2364461 | 2364461 | 2022-04-01 | Garfield | Montana | 30033 | 225 | 3 |
2364484 | 2364484 | 2022-04-01 | Prairie | Montana | 30079 | 262 | 3 |
2361207 | 2361207 | 2022-03-31 | Garfield | Montana | 30033 | 225 | 3 |
2361230 | 2361230 | 2022-03-31 | Prairie | Montana | 30079 | 262 | 3 |
2357953 | 2357953 | 2022-03-30 | Garfield | Montana | 30033 | 225 | 3 |
2357976 | 2357976 | 2022-03-30 | Prairie | Montana | 30079 | 262 | 3 |
2354700 | 2354700 | 2022-03-29 | Garfield | Montana | 30033 | 225 | 3 |
2354723 | 2354723 | 2022-03-29 | Prairie | Montana | 30079 | 262 | 3 |
2351447 | 2351447 | 2022-03-28 | Garfield | Montana | 30033 | 225 | 3 |
2351470 | 2351470 | 2022-03-28 | Prairie | Montana | 30079 | 262 | 3 |
2348195 | 2348195 | 2022-03-27 | Garfield | Montana | 30033 | 225 | 3 |
2348218 | 2348218 | 2022-03-27 | Prairie | Montana | 30079 | 262 | 3 |
2344942 | 2344942 | 2022-03-26 | Garfield | Montana | 30033 | 225 | 3 |
2344965 | 2344965 | 2022-03-26 | Prairie | Montana | 30079 | 262 | 3 |
2341689 | 2341689 | 2022-03-25 | Garfield | Montana | 30033 | 225 | 3 |
2341712 | 2341712 | 2022-03-25 | Prairie | Montana | 30079 | 262 | 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);