ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
695 rows where county = "Fergus" and state = "Montana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501206 | 2501206 | 2022-05-13 | Fergus | Montana | 30027 | 2515 | 56 |
2497948 | 2497948 | 2022-05-12 | Fergus | Montana | 30027 | 2512 | 56 |
2494690 | 2494690 | 2022-05-11 | Fergus | Montana | 30027 | 2512 | 56 |
2491432 | 2491432 | 2022-05-10 | Fergus | Montana | 30027 | 2512 | 56 |
2488174 | 2488174 | 2022-05-09 | Fergus | Montana | 30027 | 2512 | 56 |
2484917 | 2484917 | 2022-05-08 | Fergus | Montana | 30027 | 2512 | 56 |
2481659 | 2481659 | 2022-05-07 | Fergus | Montana | 30027 | 2512 | 56 |
2478401 | 2478401 | 2022-05-06 | Fergus | Montana | 30027 | 2512 | 56 |
2475143 | 2475143 | 2022-05-05 | Fergus | Montana | 30027 | 2512 | 56 |
2471886 | 2471886 | 2022-05-04 | Fergus | Montana | 30027 | 2511 | 56 |
2468630 | 2468630 | 2022-05-03 | Fergus | Montana | 30027 | 2511 | 56 |
2465374 | 2465374 | 2022-05-02 | Fergus | Montana | 30027 | 2511 | 56 |
2462119 | 2462119 | 2022-05-01 | Fergus | Montana | 30027 | 2511 | 56 |
2458863 | 2458863 | 2022-04-30 | Fergus | Montana | 30027 | 2511 | 56 |
2455607 | 2455607 | 2022-04-29 | Fergus | Montana | 30027 | 2511 | 56 |
2452351 | 2452351 | 2022-04-28 | Fergus | Montana | 30027 | 2511 | 56 |
2449095 | 2449095 | 2022-04-27 | Fergus | Montana | 30027 | 2511 | 56 |
2445838 | 2445838 | 2022-04-26 | Fergus | Montana | 30027 | 2511 | 56 |
2442583 | 2442583 | 2022-04-25 | Fergus | Montana | 30027 | 2511 | 56 |
2439327 | 2439327 | 2022-04-24 | Fergus | Montana | 30027 | 2511 | 55 |
2436071 | 2436071 | 2022-04-23 | Fergus | Montana | 30027 | 2511 | 55 |
2432815 | 2432815 | 2022-04-22 | Fergus | Montana | 30027 | 2511 | 55 |
2429559 | 2429559 | 2022-04-21 | Fergus | Montana | 30027 | 2511 | 55 |
2426303 | 2426303 | 2022-04-20 | Fergus | Montana | 30027 | 2511 | 55 |
2423047 | 2423047 | 2022-04-19 | Fergus | Montana | 30027 | 2511 | 55 |
2419790 | 2419790 | 2022-04-18 | Fergus | Montana | 30027 | 2511 | 55 |
2416535 | 2416535 | 2022-04-17 | Fergus | Montana | 30027 | 2509 | 55 |
2413279 | 2413279 | 2022-04-16 | Fergus | Montana | 30027 | 2509 | 55 |
2410023 | 2410023 | 2022-04-15 | Fergus | Montana | 30027 | 2509 | 55 |
2406767 | 2406767 | 2022-04-14 | Fergus | Montana | 30027 | 2509 | 55 |
2403511 | 2403511 | 2022-04-13 | Fergus | Montana | 30027 | 2509 | 55 |
2400256 | 2400256 | 2022-04-12 | Fergus | Montana | 30027 | 2509 | 55 |
2397001 | 2397001 | 2022-04-11 | Fergus | Montana | 30027 | 2509 | 55 |
2393746 | 2393746 | 2022-04-10 | Fergus | Montana | 30027 | 2509 | 55 |
2390490 | 2390490 | 2022-04-09 | Fergus | Montana | 30027 | 2509 | 55 |
2387234 | 2387234 | 2022-04-08 | Fergus | Montana | 30027 | 2509 | 55 |
2383979 | 2383979 | 2022-04-07 | Fergus | Montana | 30027 | 2509 | 55 |
2380724 | 2380724 | 2022-04-06 | Fergus | Montana | 30027 | 2509 | 55 |
2377469 | 2377469 | 2022-04-05 | Fergus | Montana | 30027 | 2509 | 55 |
2374216 | 2374216 | 2022-04-04 | Fergus | Montana | 30027 | 2509 | 55 |
2370964 | 2370964 | 2022-04-03 | Fergus | Montana | 30027 | 2509 | 55 |
2367711 | 2367711 | 2022-04-02 | Fergus | Montana | 30027 | 2509 | 55 |
2364458 | 2364458 | 2022-04-01 | Fergus | Montana | 30027 | 2509 | 55 |
2361204 | 2361204 | 2022-03-31 | Fergus | Montana | 30027 | 2508 | 55 |
2357950 | 2357950 | 2022-03-30 | Fergus | Montana | 30027 | 2508 | 54 |
2354697 | 2354697 | 2022-03-29 | Fergus | Montana | 30027 | 2509 | 54 |
2351444 | 2351444 | 2022-03-28 | Fergus | Montana | 30027 | 2507 | 54 |
2348192 | 2348192 | 2022-03-27 | Fergus | Montana | 30027 | 2507 | 54 |
2344939 | 2344939 | 2022-03-26 | Fergus | Montana | 30027 | 2507 | 54 |
2341686 | 2341686 | 2022-03-25 | Fergus | Montana | 30027 | 2507 | 54 |
2338433 | 2338433 | 2022-03-24 | Fergus | Montana | 30027 | 2507 | 54 |
2335179 | 2335179 | 2022-03-23 | Fergus | Montana | 30027 | 2507 | 54 |
2331925 | 2331925 | 2022-03-22 | Fergus | Montana | 30027 | 2505 | 54 |
2328672 | 2328672 | 2022-03-21 | Fergus | Montana | 30027 | 2499 | 54 |
2325420 | 2325420 | 2022-03-20 | Fergus | Montana | 30027 | 2500 | 54 |
2322166 | 2322166 | 2022-03-19 | Fergus | Montana | 30027 | 2500 | 54 |
2318912 | 2318912 | 2022-03-18 | Fergus | Montana | 30027 | 2500 | 54 |
2315659 | 2315659 | 2022-03-17 | Fergus | Montana | 30027 | 2499 | 54 |
2312406 | 2312406 | 2022-03-16 | Fergus | Montana | 30027 | 2497 | 54 |
2309153 | 2309153 | 2022-03-15 | Fergus | Montana | 30027 | 2496 | 54 |
2305901 | 2305901 | 2022-03-14 | Fergus | Montana | 30027 | 2494 | 54 |
2302650 | 2302650 | 2022-03-13 | Fergus | Montana | 30027 | 2492 | 54 |
2299398 | 2299398 | 2022-03-12 | Fergus | Montana | 30027 | 2492 | 54 |
2296146 | 2296146 | 2022-03-11 | Fergus | Montana | 30027 | 2492 | 54 |
2292894 | 2292894 | 2022-03-10 | Fergus | Montana | 30027 | 2492 | 54 |
2289642 | 2289642 | 2022-03-09 | Fergus | Montana | 30027 | 2492 | 54 |
2286390 | 2286390 | 2022-03-08 | Fergus | Montana | 30027 | 2491 | 54 |
2283138 | 2283138 | 2022-03-07 | Fergus | Montana | 30027 | 2490 | 54 |
2279885 | 2279885 | 2022-03-06 | Fergus | Montana | 30027 | 2489 | 54 |
2276632 | 2276632 | 2022-03-05 | Fergus | Montana | 30027 | 2489 | 54 |
2273379 | 2273379 | 2022-03-04 | Fergus | Montana | 30027 | 2489 | 54 |
2270127 | 2270127 | 2022-03-03 | Fergus | Montana | 30027 | 2477 | 54 |
2266874 | 2266874 | 2022-03-02 | Fergus | Montana | 30027 | 2474 | 54 |
2263623 | 2263623 | 2022-03-01 | Fergus | Montana | 30027 | 2469 | 53 |
2260372 | 2260372 | 2022-02-28 | Fergus | Montana | 30027 | 2464 | 53 |
2257121 | 2257121 | 2022-02-27 | Fergus | Montana | 30027 | 2463 | 52 |
2253870 | 2253870 | 2022-02-26 | Fergus | Montana | 30027 | 2463 | 52 |
2250619 | 2250619 | 2022-02-25 | Fergus | Montana | 30027 | 2463 | 52 |
2247368 | 2247368 | 2022-02-24 | Fergus | Montana | 30027 | 2462 | 52 |
2244117 | 2244117 | 2022-02-23 | Fergus | Montana | 30027 | 2461 | 52 |
2240866 | 2240866 | 2022-02-22 | Fergus | Montana | 30027 | 2453 | 52 |
2237615 | 2237615 | 2022-02-21 | Fergus | Montana | 30027 | 2434 | 52 |
2234364 | 2234364 | 2022-02-20 | Fergus | Montana | 30027 | 2434 | 52 |
2231113 | 2231113 | 2022-02-19 | Fergus | Montana | 30027 | 2434 | 52 |
2227862 | 2227862 | 2022-02-18 | Fergus | Montana | 30027 | 2434 | 52 |
2224611 | 2224611 | 2022-02-17 | Fergus | Montana | 30027 | 2386 | 52 |
2221360 | 2221360 | 2022-02-16 | Fergus | Montana | 30027 | 2363 | 52 |
2218109 | 2218109 | 2022-02-15 | Fergus | Montana | 30027 | 2358 | 52 |
2214858 | 2214858 | 2022-02-14 | Fergus | Montana | 30027 | 2328 | 52 |
2211606 | 2211606 | 2022-02-13 | Fergus | Montana | 30027 | 2314 | 52 |
2208353 | 2208353 | 2022-02-12 | Fergus | Montana | 30027 | 2314 | 52 |
2205100 | 2205100 | 2022-02-11 | Fergus | Montana | 30027 | 2314 | 52 |
2201847 | 2201847 | 2022-02-10 | Fergus | Montana | 30027 | 2308 | 52 |
2198593 | 2198593 | 2022-02-09 | Fergus | Montana | 30027 | 2286 | 52 |
2195339 | 2195339 | 2022-02-08 | Fergus | Montana | 30027 | 2271 | 52 |
2192085 | 2192085 | 2022-02-07 | Fergus | Montana | 30027 | 2267 | 52 |
2188832 | 2188832 | 2022-02-06 | Fergus | Montana | 30027 | 2248 | 52 |
2185579 | 2185579 | 2022-02-05 | Fergus | Montana | 30027 | 2248 | 52 |
2182327 | 2182327 | 2022-02-04 | Fergus | Montana | 30027 | 2248 | 52 |
2179075 | 2179075 | 2022-02-03 | Fergus | Montana | 30027 | 2209 | 52 |
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);