ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
648 rows where county = "Prairie" and fips = 30079 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501232 | 2501232 | 2022-05-13 | Prairie | Montana | 30079 | 263 | 3 |
2497974 | 2497974 | 2022-05-12 | Prairie | Montana | 30079 | 263 | 3 |
2494716 | 2494716 | 2022-05-11 | Prairie | Montana | 30079 | 263 | 3 |
2491458 | 2491458 | 2022-05-10 | Prairie | Montana | 30079 | 263 | 3 |
2488200 | 2488200 | 2022-05-09 | Prairie | Montana | 30079 | 263 | 3 |
2484943 | 2484943 | 2022-05-08 | Prairie | Montana | 30079 | 263 | 3 |
2481685 | 2481685 | 2022-05-07 | Prairie | Montana | 30079 | 263 | 3 |
2478427 | 2478427 | 2022-05-06 | Prairie | Montana | 30079 | 263 | 3 |
2475169 | 2475169 | 2022-05-05 | Prairie | Montana | 30079 | 263 | 3 |
2471912 | 2471912 | 2022-05-04 | Prairie | Montana | 30079 | 263 | 3 |
2468656 | 2468656 | 2022-05-03 | Prairie | Montana | 30079 | 263 | 3 |
2465400 | 2465400 | 2022-05-02 | Prairie | Montana | 30079 | 263 | 3 |
2462145 | 2462145 | 2022-05-01 | Prairie | Montana | 30079 | 263 | 3 |
2458889 | 2458889 | 2022-04-30 | Prairie | Montana | 30079 | 263 | 3 |
2455633 | 2455633 | 2022-04-29 | Prairie | Montana | 30079 | 263 | 3 |
2452377 | 2452377 | 2022-04-28 | Prairie | Montana | 30079 | 263 | 3 |
2449121 | 2449121 | 2022-04-27 | Prairie | Montana | 30079 | 263 | 3 |
2445864 | 2445864 | 2022-04-26 | Prairie | Montana | 30079 | 263 | 3 |
2442609 | 2442609 | 2022-04-25 | Prairie | Montana | 30079 | 263 | 3 |
2439353 | 2439353 | 2022-04-24 | Prairie | Montana | 30079 | 263 | 3 |
2436097 | 2436097 | 2022-04-23 | Prairie | Montana | 30079 | 263 | 3 |
2432841 | 2432841 | 2022-04-22 | Prairie | Montana | 30079 | 263 | 3 |
2429585 | 2429585 | 2022-04-21 | Prairie | Montana | 30079 | 263 | 3 |
2426329 | 2426329 | 2022-04-20 | Prairie | Montana | 30079 | 263 | 3 |
2423073 | 2423073 | 2022-04-19 | Prairie | Montana | 30079 | 263 | 3 |
2419816 | 2419816 | 2022-04-18 | Prairie | Montana | 30079 | 263 | 3 |
2416561 | 2416561 | 2022-04-17 | Prairie | Montana | 30079 | 263 | 3 |
2413305 | 2413305 | 2022-04-16 | Prairie | Montana | 30079 | 263 | 3 |
2410049 | 2410049 | 2022-04-15 | Prairie | Montana | 30079 | 263 | 3 |
2406793 | 2406793 | 2022-04-14 | Prairie | Montana | 30079 | 263 | 3 |
2403537 | 2403537 | 2022-04-13 | Prairie | Montana | 30079 | 263 | 3 |
2400282 | 2400282 | 2022-04-12 | Prairie | Montana | 30079 | 263 | 3 |
2397027 | 2397027 | 2022-04-11 | Prairie | Montana | 30079 | 263 | 3 |
2393772 | 2393772 | 2022-04-10 | Prairie | Montana | 30079 | 263 | 3 |
2390516 | 2390516 | 2022-04-09 | Prairie | Montana | 30079 | 263 | 3 |
2387260 | 2387260 | 2022-04-08 | Prairie | Montana | 30079 | 263 | 3 |
2384005 | 2384005 | 2022-04-07 | Prairie | Montana | 30079 | 263 | 3 |
2380750 | 2380750 | 2022-04-06 | Prairie | Montana | 30079 | 262 | 3 |
2377495 | 2377495 | 2022-04-05 | Prairie | Montana | 30079 | 262 | 3 |
2374242 | 2374242 | 2022-04-04 | Prairie | Montana | 30079 | 262 | 3 |
2370990 | 2370990 | 2022-04-03 | Prairie | Montana | 30079 | 262 | 3 |
2367737 | 2367737 | 2022-04-02 | Prairie | Montana | 30079 | 262 | 3 |
2364484 | 2364484 | 2022-04-01 | Prairie | Montana | 30079 | 262 | 3 |
2361230 | 2361230 | 2022-03-31 | Prairie | Montana | 30079 | 262 | 3 |
2357976 | 2357976 | 2022-03-30 | Prairie | Montana | 30079 | 262 | 3 |
2354723 | 2354723 | 2022-03-29 | Prairie | Montana | 30079 | 262 | 3 |
2351470 | 2351470 | 2022-03-28 | Prairie | Montana | 30079 | 262 | 3 |
2348218 | 2348218 | 2022-03-27 | Prairie | Montana | 30079 | 262 | 3 |
2344965 | 2344965 | 2022-03-26 | Prairie | Montana | 30079 | 262 | 3 |
2341712 | 2341712 | 2022-03-25 | Prairie | Montana | 30079 | 262 | 3 |
2338459 | 2338459 | 2022-03-24 | Prairie | Montana | 30079 | 262 | 3 |
2335205 | 2335205 | 2022-03-23 | Prairie | Montana | 30079 | 262 | 3 |
2331951 | 2331951 | 2022-03-22 | Prairie | Montana | 30079 | 262 | 3 |
2328698 | 2328698 | 2022-03-21 | Prairie | Montana | 30079 | 262 | 3 |
2325446 | 2325446 | 2022-03-20 | Prairie | Montana | 30079 | 262 | 3 |
2322192 | 2322192 | 2022-03-19 | Prairie | Montana | 30079 | 262 | 3 |
2318938 | 2318938 | 2022-03-18 | Prairie | Montana | 30079 | 262 | 3 |
2315685 | 2315685 | 2022-03-17 | Prairie | Montana | 30079 | 262 | 3 |
2312432 | 2312432 | 2022-03-16 | Prairie | Montana | 30079 | 262 | 3 |
2309179 | 2309179 | 2022-03-15 | Prairie | Montana | 30079 | 262 | 3 |
2305927 | 2305927 | 2022-03-14 | Prairie | Montana | 30079 | 262 | 3 |
2302676 | 2302676 | 2022-03-13 | Prairie | Montana | 30079 | 262 | 3 |
2299424 | 2299424 | 2022-03-12 | Prairie | Montana | 30079 | 262 | 3 |
2296172 | 2296172 | 2022-03-11 | Prairie | Montana | 30079 | 262 | 3 |
2292920 | 2292920 | 2022-03-10 | Prairie | Montana | 30079 | 262 | 3 |
2289668 | 2289668 | 2022-03-09 | Prairie | Montana | 30079 | 262 | 3 |
2286416 | 2286416 | 2022-03-08 | Prairie | Montana | 30079 | 262 | 3 |
2283164 | 2283164 | 2022-03-07 | Prairie | Montana | 30079 | 262 | 3 |
2279911 | 2279911 | 2022-03-06 | Prairie | Montana | 30079 | 262 | 3 |
2276658 | 2276658 | 2022-03-05 | Prairie | Montana | 30079 | 262 | 3 |
2273405 | 2273405 | 2022-03-04 | Prairie | Montana | 30079 | 262 | 3 |
2270153 | 2270153 | 2022-03-03 | Prairie | Montana | 30079 | 262 | 3 |
2266900 | 2266900 | 2022-03-02 | Prairie | Montana | 30079 | 262 | 3 |
2263649 | 2263649 | 2022-03-01 | Prairie | Montana | 30079 | 262 | 3 |
2260398 | 2260398 | 2022-02-28 | Prairie | Montana | 30079 | 262 | 3 |
2257147 | 2257147 | 2022-02-27 | Prairie | Montana | 30079 | 262 | 3 |
2253896 | 2253896 | 2022-02-26 | Prairie | Montana | 30079 | 262 | 3 |
2250645 | 2250645 | 2022-02-25 | Prairie | Montana | 30079 | 262 | 3 |
2247394 | 2247394 | 2022-02-24 | Prairie | Montana | 30079 | 262 | 3 |
2244143 | 2244143 | 2022-02-23 | Prairie | Montana | 30079 | 262 | 3 |
2240892 | 2240892 | 2022-02-22 | Prairie | Montana | 30079 | 262 | 3 |
2237641 | 2237641 | 2022-02-21 | Prairie | Montana | 30079 | 260 | 3 |
2234390 | 2234390 | 2022-02-20 | Prairie | Montana | 30079 | 260 | 3 |
2231139 | 2231139 | 2022-02-19 | Prairie | Montana | 30079 | 260 | 3 |
2227888 | 2227888 | 2022-02-18 | Prairie | Montana | 30079 | 260 | 3 |
2224637 | 2224637 | 2022-02-17 | Prairie | Montana | 30079 | 260 | 3 |
2221386 | 2221386 | 2022-02-16 | Prairie | Montana | 30079 | 259 | 3 |
2218135 | 2218135 | 2022-02-15 | Prairie | Montana | 30079 | 259 | 3 |
2214884 | 2214884 | 2022-02-14 | Prairie | Montana | 30079 | 259 | 3 |
2211632 | 2211632 | 2022-02-13 | Prairie | Montana | 30079 | 259 | 3 |
2208379 | 2208379 | 2022-02-12 | Prairie | Montana | 30079 | 259 | 3 |
2205126 | 2205126 | 2022-02-11 | Prairie | Montana | 30079 | 259 | 3 |
2201873 | 2201873 | 2022-02-10 | Prairie | Montana | 30079 | 257 | 3 |
2198619 | 2198619 | 2022-02-09 | Prairie | Montana | 30079 | 256 | 3 |
2195365 | 2195365 | 2022-02-08 | Prairie | Montana | 30079 | 255 | 3 |
2192111 | 2192111 | 2022-02-07 | Prairie | Montana | 30079 | 249 | 3 |
2188858 | 2188858 | 2022-02-06 | Prairie | Montana | 30079 | 249 | 3 |
2185605 | 2185605 | 2022-02-05 | Prairie | Montana | 30079 | 249 | 3 |
2182353 | 2182353 | 2022-02-04 | Prairie | Montana | 30079 | 249 | 3 |
2179101 | 2179101 | 2022-02-03 | Prairie | Montana | 30079 | 243 | 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);