ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

784 rows where fips = 19087 and state = "Iowa" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

  • Iowa · 784 ✖

fips 1

  • 19087 · 784 ✖

county 1

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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);