ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,558 rows where county = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500420 | 2500420 | 2022-05-13 | Iowa | Iowa | 19095 | 3711 | 50 |
2502762 | 2502762 | 2022-05-13 | Iowa | Wisconsin | 55049 | 5424 | 29 |
2497162 | 2497162 | 2022-05-12 | Iowa | Iowa | 19095 | 3711 | 50 |
2499504 | 2499504 | 2022-05-12 | Iowa | Wisconsin | 55049 | 5420 | 29 |
2493904 | 2493904 | 2022-05-11 | Iowa | Iowa | 19095 | 3711 | 50 |
2496246 | 2496246 | 2022-05-11 | Iowa | Wisconsin | 55049 | 5406 | 29 |
2490646 | 2490646 | 2022-05-10 | Iowa | Iowa | 19095 | 3699 | 50 |
2492988 | 2492988 | 2022-05-10 | Iowa | Wisconsin | 55049 | 5394 | 28 |
2487389 | 2487389 | 2022-05-09 | Iowa | Iowa | 19095 | 3699 | 50 |
2489730 | 2489730 | 2022-05-09 | Iowa | Wisconsin | 55049 | 5385 | 28 |
2484131 | 2484131 | 2022-05-08 | Iowa | Iowa | 19095 | 3699 | 50 |
2486473 | 2486473 | 2022-05-08 | Iowa | Wisconsin | 55049 | 5366 | 28 |
2480873 | 2480873 | 2022-05-07 | Iowa | Iowa | 19095 | 3699 | 50 |
2483215 | 2483215 | 2022-05-07 | Iowa | Wisconsin | 55049 | 5366 | 28 |
2477615 | 2477615 | 2022-05-06 | Iowa | Iowa | 19095 | 3699 | 50 |
2479957 | 2479957 | 2022-05-06 | Iowa | Wisconsin | 55049 | 5366 | 28 |
2474357 | 2474357 | 2022-05-05 | Iowa | Iowa | 19095 | 3699 | 50 |
2476699 | 2476699 | 2022-05-05 | Iowa | Wisconsin | 55049 | 5355 | 28 |
2471100 | 2471100 | 2022-05-04 | Iowa | Iowa | 19095 | 3699 | 50 |
2473441 | 2473441 | 2022-05-04 | Iowa | Wisconsin | 55049 | 5339 | 28 |
2467844 | 2467844 | 2022-05-03 | Iowa | Iowa | 19095 | 3689 | 50 |
2470184 | 2470184 | 2022-05-03 | Iowa | Wisconsin | 55049 | 5326 | 28 |
2464589 | 2464589 | 2022-05-02 | Iowa | Iowa | 19095 | 3689 | 50 |
2466928 | 2466928 | 2022-05-02 | Iowa | Wisconsin | 55049 | 5323 | 28 |
2461333 | 2461333 | 2022-05-01 | Iowa | Iowa | 19095 | 3689 | 50 |
2463673 | 2463673 | 2022-05-01 | Iowa | Wisconsin | 55049 | 5315 | 28 |
2458077 | 2458077 | 2022-04-30 | Iowa | Iowa | 19095 | 3689 | 50 |
2460417 | 2460417 | 2022-04-30 | Iowa | Wisconsin | 55049 | 5315 | 28 |
2454821 | 2454821 | 2022-04-29 | Iowa | Iowa | 19095 | 3689 | 50 |
2457161 | 2457161 | 2022-04-29 | Iowa | Wisconsin | 55049 | 5315 | 28 |
2451565 | 2451565 | 2022-04-28 | Iowa | Iowa | 19095 | 3689 | 50 |
2453905 | 2453905 | 2022-04-28 | Iowa | Wisconsin | 55049 | 5310 | 28 |
2448309 | 2448309 | 2022-04-27 | Iowa | Iowa | 19095 | 3689 | 50 |
2450649 | 2450649 | 2022-04-27 | Iowa | Wisconsin | 55049 | 5299 | 28 |
2445053 | 2445053 | 2022-04-26 | Iowa | Iowa | 19095 | 3684 | 50 |
2447393 | 2447393 | 2022-04-26 | Iowa | Wisconsin | 55049 | 5286 | 28 |
2441797 | 2441797 | 2022-04-25 | Iowa | Iowa | 19095 | 3684 | 50 |
2444137 | 2444137 | 2022-04-25 | Iowa | Wisconsin | 55049 | 5280 | 28 |
2438541 | 2438541 | 2022-04-24 | Iowa | Iowa | 19095 | 3684 | 50 |
2440881 | 2440881 | 2022-04-24 | Iowa | Wisconsin | 55049 | 5275 | 28 |
2435285 | 2435285 | 2022-04-23 | Iowa | Iowa | 19095 | 3684 | 50 |
2437625 | 2437625 | 2022-04-23 | Iowa | Wisconsin | 55049 | 5275 | 28 |
2432029 | 2432029 | 2022-04-22 | Iowa | Iowa | 19095 | 3684 | 50 |
2434369 | 2434369 | 2022-04-22 | Iowa | Wisconsin | 55049 | 5275 | 28 |
2428773 | 2428773 | 2022-04-21 | Iowa | Iowa | 19095 | 3684 | 50 |
2431113 | 2431113 | 2022-04-21 | Iowa | Wisconsin | 55049 | 5271 | 28 |
2425517 | 2425517 | 2022-04-20 | Iowa | Iowa | 19095 | 3684 | 50 |
2427857 | 2427857 | 2022-04-20 | Iowa | Wisconsin | 55049 | 5267 | 28 |
2422261 | 2422261 | 2022-04-19 | Iowa | Iowa | 19095 | 3677 | 50 |
2424601 | 2424601 | 2022-04-19 | Iowa | Wisconsin | 55049 | 5264 | 28 |
2419005 | 2419005 | 2022-04-18 | Iowa | Iowa | 19095 | 3677 | 50 |
2421345 | 2421345 | 2022-04-18 | Iowa | Wisconsin | 55049 | 5264 | 28 |
2415749 | 2415749 | 2022-04-17 | Iowa | Iowa | 19095 | 3677 | 50 |
2418089 | 2418089 | 2022-04-17 | Iowa | Wisconsin | 55049 | 5259 | 28 |
2412493 | 2412493 | 2022-04-16 | Iowa | Iowa | 19095 | 3677 | 50 |
2414833 | 2414833 | 2022-04-16 | Iowa | Wisconsin | 55049 | 5259 | 28 |
2409237 | 2409237 | 2022-04-15 | Iowa | Iowa | 19095 | 3677 | 50 |
2411577 | 2411577 | 2022-04-15 | Iowa | Wisconsin | 55049 | 5259 | 28 |
2405981 | 2405981 | 2022-04-14 | Iowa | Iowa | 19095 | 3677 | 50 |
2408321 | 2408321 | 2022-04-14 | Iowa | Wisconsin | 55049 | 5256 | 28 |
2402725 | 2402725 | 2022-04-13 | Iowa | Iowa | 19095 | 3677 | 50 |
2405065 | 2405065 | 2022-04-13 | Iowa | Wisconsin | 55049 | 5255 | 28 |
2399471 | 2399471 | 2022-04-12 | Iowa | Iowa | 19095 | 3672 | 50 |
2401810 | 2401810 | 2022-04-12 | Iowa | Wisconsin | 55049 | 5254 | 28 |
2396215 | 2396215 | 2022-04-11 | Iowa | Iowa | 19095 | 3672 | 50 |
2398555 | 2398555 | 2022-04-11 | Iowa | Wisconsin | 55049 | 5250 | 28 |
2392960 | 2392960 | 2022-04-10 | Iowa | Iowa | 19095 | 3672 | 50 |
2395300 | 2395300 | 2022-04-10 | Iowa | Wisconsin | 55049 | 5246 | 28 |
2389704 | 2389704 | 2022-04-09 | Iowa | Iowa | 19095 | 3672 | 50 |
2392044 | 2392044 | 2022-04-09 | Iowa | Wisconsin | 55049 | 5246 | 28 |
2386448 | 2386448 | 2022-04-08 | Iowa | Iowa | 19095 | 3672 | 50 |
2388788 | 2388788 | 2022-04-08 | Iowa | Wisconsin | 55049 | 5246 | 28 |
2383194 | 2383194 | 2022-04-07 | Iowa | Iowa | 19095 | 3672 | 50 |
2385533 | 2385533 | 2022-04-07 | Iowa | Wisconsin | 55049 | 5242 | 28 |
2379939 | 2379939 | 2022-04-06 | Iowa | Iowa | 19095 | 3672 | 50 |
2382278 | 2382278 | 2022-04-06 | Iowa | Wisconsin | 55049 | 5241 | 28 |
2376684 | 2376684 | 2022-04-05 | Iowa | Iowa | 19095 | 3661 | 50 |
2379023 | 2379023 | 2022-04-05 | Iowa | Wisconsin | 55049 | 5237 | 28 |
2373432 | 2373432 | 2022-04-04 | Iowa | Iowa | 19095 | 3661 | 50 |
2375769 | 2375769 | 2022-04-04 | Iowa | Wisconsin | 55049 | 5232 | 28 |
2370179 | 2370179 | 2022-04-03 | Iowa | Iowa | 19095 | 3661 | 50 |
2372517 | 2372517 | 2022-04-03 | Iowa | Wisconsin | 55049 | 5229 | 28 |
2366926 | 2366926 | 2022-04-02 | Iowa | Iowa | 19095 | 3661 | 50 |
2369264 | 2369264 | 2022-04-02 | Iowa | Wisconsin | 55049 | 5229 | 28 |
2363673 | 2363673 | 2022-04-01 | Iowa | Iowa | 19095 | 3661 | 50 |
2366011 | 2366011 | 2022-04-01 | Iowa | Wisconsin | 55049 | 5229 | 28 |
2360419 | 2360419 | 2022-03-31 | Iowa | Iowa | 19095 | 3661 | 50 |
2362758 | 2362758 | 2022-03-31 | Iowa | Wisconsin | 55049 | 5226 | 28 |
2357165 | 2357165 | 2022-03-30 | Iowa | Iowa | 19095 | 3661 | 50 |
2359504 | 2359504 | 2022-03-30 | Iowa | Wisconsin | 55049 | 5226 | 28 |
2353912 | 2353912 | 2022-03-29 | Iowa | Iowa | 19095 | 3662 | 50 |
2356250 | 2356250 | 2022-03-29 | Iowa | Wisconsin | 55049 | 5221 | 27 |
2350660 | 2350660 | 2022-03-28 | Iowa | Iowa | 19095 | 3662 | 50 |
2352997 | 2352997 | 2022-03-28 | Iowa | Wisconsin | 55049 | 5214 | 27 |
2347407 | 2347407 | 2022-03-27 | Iowa | Iowa | 19095 | 3662 | 50 |
2349745 | 2349745 | 2022-03-27 | Iowa | Wisconsin | 55049 | 5211 | 27 |
2344154 | 2344154 | 2022-03-26 | Iowa | Iowa | 19095 | 3662 | 50 |
2346492 | 2346492 | 2022-03-26 | Iowa | Wisconsin | 55049 | 5211 | 27 |
2340901 | 2340901 | 2022-03-25 | Iowa | Iowa | 19095 | 3662 | 50 |
2343239 | 2343239 | 2022-03-25 | Iowa | Wisconsin | 55049 | 5211 | 27 |
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);