ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Henry" 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 |
---|---|---|---|---|---|---|---|
2500416 | 2500416 | 2022-05-13 | Henry | Iowa | 19087 | 5573 | 74 |
2497158 | 2497158 | 2022-05-12 | Henry | Iowa | 19087 | 5573 | 74 |
2493900 | 2493900 | 2022-05-11 | Henry | Iowa | 19087 | 5573 | 74 |
2490642 | 2490642 | 2022-05-10 | Henry | Iowa | 19087 | 5566 | 74 |
2487385 | 2487385 | 2022-05-09 | Henry | Iowa | 19087 | 5566 | 74 |
2484127 | 2484127 | 2022-05-08 | Henry | Iowa | 19087 | 5566 | 74 |
2480869 | 2480869 | 2022-05-07 | Henry | Iowa | 19087 | 5566 | 74 |
2477611 | 2477611 | 2022-05-06 | Henry | Iowa | 19087 | 5566 | 74 |
2474353 | 2474353 | 2022-05-05 | Henry | Iowa | 19087 | 5566 | 74 |
2471096 | 2471096 | 2022-05-04 | Henry | Iowa | 19087 | 5566 | 74 |
2467840 | 2467840 | 2022-05-03 | Henry | Iowa | 19087 | 5567 | 74 |
2464585 | 2464585 | 2022-05-02 | Henry | Iowa | 19087 | 5567 | 74 |
2461329 | 2461329 | 2022-05-01 | Henry | Iowa | 19087 | 5567 | 74 |
2458073 | 2458073 | 2022-04-30 | Henry | Iowa | 19087 | 5567 | 74 |
2454817 | 2454817 | 2022-04-29 | Henry | Iowa | 19087 | 5567 | 74 |
2451561 | 2451561 | 2022-04-28 | Henry | Iowa | 19087 | 5567 | 74 |
2448305 | 2448305 | 2022-04-27 | Henry | Iowa | 19087 | 5567 | 74 |
2445049 | 2445049 | 2022-04-26 | Henry | Iowa | 19087 | 5563 | 74 |
2441793 | 2441793 | 2022-04-25 | Henry | Iowa | 19087 | 5563 | 74 |
2438537 | 2438537 | 2022-04-24 | Henry | Iowa | 19087 | 5563 | 74 |
2435281 | 2435281 | 2022-04-23 | Henry | Iowa | 19087 | 5563 | 74 |
2432025 | 2432025 | 2022-04-22 | Henry | Iowa | 19087 | 5563 | 74 |
2428769 | 2428769 | 2022-04-21 | Henry | Iowa | 19087 | 5563 | 74 |
2425513 | 2425513 | 2022-04-20 | Henry | Iowa | 19087 | 5563 | 74 |
2422257 | 2422257 | 2022-04-19 | Henry | Iowa | 19087 | 5558 | 74 |
2419001 | 2419001 | 2022-04-18 | Henry | Iowa | 19087 | 5558 | 74 |
2415745 | 2415745 | 2022-04-17 | Henry | Iowa | 19087 | 5558 | 74 |
2412489 | 2412489 | 2022-04-16 | Henry | Iowa | 19087 | 5558 | 74 |
2409233 | 2409233 | 2022-04-15 | Henry | Iowa | 19087 | 5558 | 74 |
2405977 | 2405977 | 2022-04-14 | Henry | Iowa | 19087 | 5558 | 74 |
2402721 | 2402721 | 2022-04-13 | Henry | Iowa | 19087 | 5558 | 74 |
2399467 | 2399467 | 2022-04-12 | Henry | Iowa | 19087 | 5557 | 73 |
2396211 | 2396211 | 2022-04-11 | Henry | Iowa | 19087 | 5557 | 73 |
2392956 | 2392956 | 2022-04-10 | Henry | Iowa | 19087 | 5557 | 73 |
2389700 | 2389700 | 2022-04-09 | Henry | Iowa | 19087 | 5557 | 73 |
2386444 | 2386444 | 2022-04-08 | Henry | Iowa | 19087 | 5557 | 73 |
2383190 | 2383190 | 2022-04-07 | Henry | Iowa | 19087 | 5557 | 73 |
2379935 | 2379935 | 2022-04-06 | Henry | Iowa | 19087 | 5557 | 73 |
2376680 | 2376680 | 2022-04-05 | Henry | Iowa | 19087 | 5551 | 73 |
2373428 | 2373428 | 2022-04-04 | Henry | Iowa | 19087 | 5551 | 73 |
2370175 | 2370175 | 2022-04-03 | Henry | Iowa | 19087 | 5551 | 73 |
2366922 | 2366922 | 2022-04-02 | Henry | Iowa | 19087 | 5551 | 73 |
2363669 | 2363669 | 2022-04-01 | Henry | Iowa | 19087 | 5551 | 73 |
2360415 | 2360415 | 2022-03-31 | Henry | Iowa | 19087 | 5551 | 73 |
2357161 | 2357161 | 2022-03-30 | Henry | Iowa | 19087 | 5551 | 73 |
2353908 | 2353908 | 2022-03-29 | Henry | Iowa | 19087 | 5547 | 73 |
2350656 | 2350656 | 2022-03-28 | Henry | Iowa | 19087 | 5547 | 73 |
2347403 | 2347403 | 2022-03-27 | Henry | Iowa | 19087 | 5547 | 73 |
2344150 | 2344150 | 2022-03-26 | Henry | Iowa | 19087 | 5547 | 73 |
2340897 | 2340897 | 2022-03-25 | Henry | Iowa | 19087 | 5547 | 73 |
2337644 | 2337644 | 2022-03-24 | Henry | Iowa | 19087 | 5547 | 73 |
2334390 | 2334390 | 2022-03-23 | Henry | Iowa | 19087 | 5547 | 73 |
2331136 | 2331136 | 2022-03-22 | Henry | Iowa | 19087 | 5543 | 72 |
2327884 | 2327884 | 2022-03-21 | Henry | Iowa | 19087 | 5543 | 72 |
2324631 | 2324631 | 2022-03-20 | Henry | Iowa | 19087 | 5543 | 72 |
2321377 | 2321377 | 2022-03-19 | Henry | Iowa | 19087 | 5543 | 72 |
2318123 | 2318123 | 2022-03-18 | Henry | Iowa | 19087 | 5543 | 72 |
2314870 | 2314870 | 2022-03-17 | Henry | Iowa | 19087 | 5543 | 72 |
2311617 | 2311617 | 2022-03-16 | Henry | Iowa | 19087 | 5543 | 72 |
2308364 | 2308364 | 2022-03-15 | Henry | Iowa | 19087 | 5540 | 70 |
2305113 | 2305113 | 2022-03-14 | Henry | Iowa | 19087 | 5540 | 70 |
2301861 | 2301861 | 2022-03-13 | Henry | Iowa | 19087 | 5540 | 70 |
2298609 | 2298609 | 2022-03-12 | Henry | Iowa | 19087 | 5540 | 70 |
2295357 | 2295357 | 2022-03-11 | Henry | Iowa | 19087 | 5540 | 70 |
2292105 | 2292105 | 2022-03-10 | Henry | Iowa | 19087 | 5540 | 70 |
2288853 | 2288853 | 2022-03-09 | Henry | Iowa | 19087 | 5540 | 70 |
2285602 | 2285602 | 2022-03-08 | Henry | Iowa | 19087 | 5524 | 67 |
2282350 | 2282350 | 2022-03-07 | Henry | Iowa | 19087 | 5524 | 67 |
2279097 | 2279097 | 2022-03-06 | Henry | Iowa | 19087 | 5524 | 67 |
2275844 | 2275844 | 2022-03-05 | Henry | Iowa | 19087 | 5524 | 67 |
2272591 | 2272591 | 2022-03-04 | Henry | Iowa | 19087 | 5524 | 67 |
2269339 | 2269339 | 2022-03-03 | Henry | Iowa | 19087 | 5524 | 67 |
2266086 | 2266086 | 2022-03-02 | Henry | Iowa | 19087 | 5524 | 67 |
2262835 | 2262835 | 2022-03-01 | Henry | Iowa | 19087 | 5509 | 65 |
2259584 | 2259584 | 2022-02-28 | Henry | Iowa | 19087 | 5509 | 65 |
2256333 | 2256333 | 2022-02-27 | Henry | Iowa | 19087 | 5509 | 65 |
2253082 | 2253082 | 2022-02-26 | Henry | Iowa | 19087 | 5509 | 65 |
2249831 | 2249831 | 2022-02-25 | Henry | Iowa | 19087 | 5509 | 65 |
2246580 | 2246580 | 2022-02-24 | Henry | Iowa | 19087 | 5509 | 65 |
2243329 | 2243329 | 2022-02-23 | Henry | Iowa | 19087 | 5509 | 65 |
2240078 | 2240078 | 2022-02-22 | Henry | Iowa | 19087 | 5485 | 65 |
2236827 | 2236827 | 2022-02-21 | Henry | Iowa | 19087 | 5485 | 65 |
2233576 | 2233576 | 2022-02-20 | Henry | Iowa | 19087 | 5485 | 65 |
2230325 | 2230325 | 2022-02-19 | Henry | Iowa | 19087 | 5485 | 65 |
2227074 | 2227074 | 2022-02-18 | Henry | Iowa | 19087 | 5485 | 65 |
2223823 | 2223823 | 2022-02-17 | Henry | Iowa | 19087 | 5485 | 65 |
2220572 | 2220572 | 2022-02-16 | Henry | Iowa | 19087 | 5485 | 65 |
2217321 | 2217321 | 2022-02-15 | Henry | Iowa | 19087 | 5434 | 64 |
2214070 | 2214070 | 2022-02-14 | Henry | Iowa | 19087 | 5434 | 64 |
2210818 | 2210818 | 2022-02-13 | Henry | Iowa | 19087 | 5434 | 64 |
2207565 | 2207565 | 2022-02-12 | Henry | Iowa | 19087 | 5434 | 64 |
2204312 | 2204312 | 2022-02-11 | Henry | Iowa | 19087 | 5434 | 64 |
2201059 | 2201059 | 2022-02-10 | Henry | Iowa | 19087 | 5434 | 64 |
2197805 | 2197805 | 2022-02-09 | Henry | Iowa | 19087 | 5434 | 64 |
2194551 | 2194551 | 2022-02-08 | Henry | Iowa | 19087 | 5350 | 62 |
2191297 | 2191297 | 2022-02-07 | Henry | Iowa | 19087 | 5350 | 62 |
2188044 | 2188044 | 2022-02-06 | Henry | Iowa | 19087 | 5350 | 62 |
2184791 | 2184791 | 2022-02-05 | Henry | Iowa | 19087 | 5350 | 62 |
2181539 | 2181539 | 2022-02-04 | Henry | Iowa | 19087 | 5350 | 62 |
2178288 | 2178288 | 2022-02-03 | Henry | Iowa | 19087 | 5350 | 62 |
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);