ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Iowa" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500420 | 2500420 | 2022-05-13 | Iowa | Iowa | 19095 | 3711 | 50 |
2497162 | 2497162 | 2022-05-12 | Iowa | Iowa | 19095 | 3711 | 50 |
2493904 | 2493904 | 2022-05-11 | Iowa | Iowa | 19095 | 3711 | 50 |
2490646 | 2490646 | 2022-05-10 | Iowa | Iowa | 19095 | 3699 | 50 |
2487389 | 2487389 | 2022-05-09 | Iowa | Iowa | 19095 | 3699 | 50 |
2484131 | 2484131 | 2022-05-08 | Iowa | Iowa | 19095 | 3699 | 50 |
2480873 | 2480873 | 2022-05-07 | Iowa | Iowa | 19095 | 3699 | 50 |
2477615 | 2477615 | 2022-05-06 | Iowa | Iowa | 19095 | 3699 | 50 |
2474357 | 2474357 | 2022-05-05 | Iowa | Iowa | 19095 | 3699 | 50 |
2471100 | 2471100 | 2022-05-04 | Iowa | Iowa | 19095 | 3699 | 50 |
2467844 | 2467844 | 2022-05-03 | Iowa | Iowa | 19095 | 3689 | 50 |
2464589 | 2464589 | 2022-05-02 | Iowa | Iowa | 19095 | 3689 | 50 |
2461333 | 2461333 | 2022-05-01 | Iowa | Iowa | 19095 | 3689 | 50 |
2458077 | 2458077 | 2022-04-30 | Iowa | Iowa | 19095 | 3689 | 50 |
2454821 | 2454821 | 2022-04-29 | Iowa | Iowa | 19095 | 3689 | 50 |
2451565 | 2451565 | 2022-04-28 | Iowa | Iowa | 19095 | 3689 | 50 |
2448309 | 2448309 | 2022-04-27 | Iowa | Iowa | 19095 | 3689 | 50 |
2445053 | 2445053 | 2022-04-26 | Iowa | Iowa | 19095 | 3684 | 50 |
2441797 | 2441797 | 2022-04-25 | Iowa | Iowa | 19095 | 3684 | 50 |
2438541 | 2438541 | 2022-04-24 | Iowa | Iowa | 19095 | 3684 | 50 |
2435285 | 2435285 | 2022-04-23 | Iowa | Iowa | 19095 | 3684 | 50 |
2432029 | 2432029 | 2022-04-22 | Iowa | Iowa | 19095 | 3684 | 50 |
2428773 | 2428773 | 2022-04-21 | Iowa | Iowa | 19095 | 3684 | 50 |
2425517 | 2425517 | 2022-04-20 | Iowa | Iowa | 19095 | 3684 | 50 |
2422261 | 2422261 | 2022-04-19 | Iowa | Iowa | 19095 | 3677 | 50 |
2419005 | 2419005 | 2022-04-18 | Iowa | Iowa | 19095 | 3677 | 50 |
2415749 | 2415749 | 2022-04-17 | Iowa | Iowa | 19095 | 3677 | 50 |
2412493 | 2412493 | 2022-04-16 | Iowa | Iowa | 19095 | 3677 | 50 |
2409237 | 2409237 | 2022-04-15 | Iowa | Iowa | 19095 | 3677 | 50 |
2405981 | 2405981 | 2022-04-14 | Iowa | Iowa | 19095 | 3677 | 50 |
2402725 | 2402725 | 2022-04-13 | Iowa | Iowa | 19095 | 3677 | 50 |
2399471 | 2399471 | 2022-04-12 | Iowa | Iowa | 19095 | 3672 | 50 |
2396215 | 2396215 | 2022-04-11 | Iowa | Iowa | 19095 | 3672 | 50 |
2392960 | 2392960 | 2022-04-10 | Iowa | Iowa | 19095 | 3672 | 50 |
2389704 | 2389704 | 2022-04-09 | Iowa | Iowa | 19095 | 3672 | 50 |
2386448 | 2386448 | 2022-04-08 | Iowa | Iowa | 19095 | 3672 | 50 |
2383194 | 2383194 | 2022-04-07 | Iowa | Iowa | 19095 | 3672 | 50 |
2379939 | 2379939 | 2022-04-06 | Iowa | Iowa | 19095 | 3672 | 50 |
2376684 | 2376684 | 2022-04-05 | Iowa | Iowa | 19095 | 3661 | 50 |
2373432 | 2373432 | 2022-04-04 | Iowa | Iowa | 19095 | 3661 | 50 |
2370179 | 2370179 | 2022-04-03 | Iowa | Iowa | 19095 | 3661 | 50 |
2366926 | 2366926 | 2022-04-02 | Iowa | Iowa | 19095 | 3661 | 50 |
2363673 | 2363673 | 2022-04-01 | Iowa | Iowa | 19095 | 3661 | 50 |
2360419 | 2360419 | 2022-03-31 | Iowa | Iowa | 19095 | 3661 | 50 |
2357165 | 2357165 | 2022-03-30 | Iowa | Iowa | 19095 | 3661 | 50 |
2353912 | 2353912 | 2022-03-29 | Iowa | Iowa | 19095 | 3662 | 50 |
2350660 | 2350660 | 2022-03-28 | Iowa | Iowa | 19095 | 3662 | 50 |
2347407 | 2347407 | 2022-03-27 | Iowa | Iowa | 19095 | 3662 | 50 |
2344154 | 2344154 | 2022-03-26 | Iowa | Iowa | 19095 | 3662 | 50 |
2340901 | 2340901 | 2022-03-25 | Iowa | Iowa | 19095 | 3662 | 50 |
2337648 | 2337648 | 2022-03-24 | Iowa | Iowa | 19095 | 3662 | 50 |
2334394 | 2334394 | 2022-03-23 | Iowa | Iowa | 19095 | 3662 | 50 |
2331140 | 2331140 | 2022-03-22 | Iowa | Iowa | 19095 | 3662 | 50 |
2327888 | 2327888 | 2022-03-21 | Iowa | Iowa | 19095 | 3662 | 50 |
2324635 | 2324635 | 2022-03-20 | Iowa | Iowa | 19095 | 3662 | 50 |
2321381 | 2321381 | 2022-03-19 | Iowa | Iowa | 19095 | 3662 | 50 |
2318127 | 2318127 | 2022-03-18 | Iowa | Iowa | 19095 | 3662 | 50 |
2314874 | 2314874 | 2022-03-17 | Iowa | Iowa | 19095 | 3662 | 50 |
2311621 | 2311621 | 2022-03-16 | Iowa | Iowa | 19095 | 3663 | 50 |
2308368 | 2308368 | 2022-03-15 | Iowa | Iowa | 19095 | 3663 | 49 |
2305117 | 2305117 | 2022-03-14 | Iowa | Iowa | 19095 | 3663 | 49 |
2301865 | 2301865 | 2022-03-13 | Iowa | Iowa | 19095 | 3663 | 49 |
2298613 | 2298613 | 2022-03-12 | Iowa | Iowa | 19095 | 3663 | 49 |
2295361 | 2295361 | 2022-03-11 | Iowa | Iowa | 19095 | 3663 | 49 |
2292109 | 2292109 | 2022-03-10 | Iowa | Iowa | 19095 | 3663 | 49 |
2288857 | 2288857 | 2022-03-09 | Iowa | Iowa | 19095 | 3663 | 49 |
2285606 | 2285606 | 2022-03-08 | Iowa | Iowa | 19095 | 3653 | 48 |
2282354 | 2282354 | 2022-03-07 | Iowa | Iowa | 19095 | 3653 | 48 |
2279101 | 2279101 | 2022-03-06 | Iowa | Iowa | 19095 | 3653 | 48 |
2275848 | 2275848 | 2022-03-05 | Iowa | Iowa | 19095 | 3653 | 48 |
2272595 | 2272595 | 2022-03-04 | Iowa | Iowa | 19095 | 3653 | 48 |
2269343 | 2269343 | 2022-03-03 | Iowa | Iowa | 19095 | 3653 | 48 |
2266090 | 2266090 | 2022-03-02 | Iowa | Iowa | 19095 | 3653 | 48 |
2262839 | 2262839 | 2022-03-01 | Iowa | Iowa | 19095 | 3646 | 47 |
2259588 | 2259588 | 2022-02-28 | Iowa | Iowa | 19095 | 3646 | 47 |
2256337 | 2256337 | 2022-02-27 | Iowa | Iowa | 19095 | 3646 | 47 |
2253086 | 2253086 | 2022-02-26 | Iowa | Iowa | 19095 | 3646 | 47 |
2249835 | 2249835 | 2022-02-25 | Iowa | Iowa | 19095 | 3646 | 47 |
2246584 | 2246584 | 2022-02-24 | Iowa | Iowa | 19095 | 3646 | 47 |
2243333 | 2243333 | 2022-02-23 | Iowa | Iowa | 19095 | 3646 | 47 |
2240082 | 2240082 | 2022-02-22 | Iowa | Iowa | 19095 | 3635 | 46 |
2236831 | 2236831 | 2022-02-21 | Iowa | Iowa | 19095 | 3635 | 46 |
2233580 | 2233580 | 2022-02-20 | Iowa | Iowa | 19095 | 3635 | 46 |
2230329 | 2230329 | 2022-02-19 | Iowa | Iowa | 19095 | 3635 | 46 |
2227078 | 2227078 | 2022-02-18 | Iowa | Iowa | 19095 | 3635 | 46 |
2223827 | 2223827 | 2022-02-17 | Iowa | Iowa | 19095 | 3635 | 46 |
2220576 | 2220576 | 2022-02-16 | Iowa | Iowa | 19095 | 3635 | 46 |
2217325 | 2217325 | 2022-02-15 | Iowa | Iowa | 19095 | 3592 | 45 |
2214074 | 2214074 | 2022-02-14 | Iowa | Iowa | 19095 | 3592 | 45 |
2210822 | 2210822 | 2022-02-13 | Iowa | Iowa | 19095 | 3592 | 45 |
2207569 | 2207569 | 2022-02-12 | Iowa | Iowa | 19095 | 3592 | 45 |
2204316 | 2204316 | 2022-02-11 | Iowa | Iowa | 19095 | 3592 | 45 |
2201063 | 2201063 | 2022-02-10 | Iowa | Iowa | 19095 | 3592 | 45 |
2197809 | 2197809 | 2022-02-09 | Iowa | Iowa | 19095 | 3592 | 45 |
2194555 | 2194555 | 2022-02-08 | Iowa | Iowa | 19095 | 3509 | 44 |
2191301 | 2191301 | 2022-02-07 | Iowa | Iowa | 19095 | 3509 | 44 |
2188048 | 2188048 | 2022-02-06 | Iowa | Iowa | 19095 | 3509 | 44 |
2184795 | 2184795 | 2022-02-05 | Iowa | Iowa | 19095 | 3509 | 44 |
2181543 | 2181543 | 2022-02-04 | Iowa | Iowa | 19095 | 3509 | 44 |
2178292 | 2178292 | 2022-02-03 | Iowa | Iowa | 19095 | 3509 | 44 |
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);