ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
62 rows where cases = 1588 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
county 11
state 1
- Iowa · 62 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500373 | 2500373 | 2022-05-13 | Adair | Iowa | 19001 | 1588 | 50 |
2497115 | 2497115 | 2022-05-12 | Adair | Iowa | 19001 | 1588 | 50 |
2493857 | 2493857 | 2022-05-11 | Adair | Iowa | 19001 | 1588 | 50 |
2490599 | 2490599 | 2022-05-10 | Adair | Iowa | 19001 | 1588 | 50 |
2487342 | 2487342 | 2022-05-09 | Adair | Iowa | 19001 | 1588 | 50 |
2484084 | 2484084 | 2022-05-08 | Adair | Iowa | 19001 | 1588 | 50 |
2480826 | 2480826 | 2022-05-07 | Adair | Iowa | 19001 | 1588 | 50 |
2477568 | 2477568 | 2022-05-06 | Adair | Iowa | 19001 | 1588 | 50 |
2474310 | 2474310 | 2022-05-05 | Adair | Iowa | 19001 | 1588 | 50 |
2471053 | 2471053 | 2022-05-04 | Adair | Iowa | 19001 | 1588 | 50 |
2331168 | 2331168 | 2022-03-22 | Pocahontas | Iowa | 19151 | 1588 | 27 |
2327916 | 2327916 | 2022-03-21 | Pocahontas | Iowa | 19151 | 1588 | 27 |
2324663 | 2324663 | 2022-03-20 | Pocahontas | Iowa | 19151 | 1588 | 27 |
2321409 | 2321409 | 2022-03-19 | Pocahontas | Iowa | 19151 | 1588 | 27 |
2318155 | 2318155 | 2022-03-18 | Pocahontas | Iowa | 19151 | 1588 | 27 |
2314902 | 2314902 | 2022-03-17 | Pocahontas | Iowa | 19151 | 1588 | 27 |
2311649 | 2311649 | 2022-03-16 | Pocahontas | Iowa | 19151 | 1588 | 27 |
1739471 | 1739471 | 2021-09-21 | Grundy | Iowa | 19075 | 1588 | 35 |
1736222 | 1736222 | 2021-09-20 | Grundy | Iowa | 19075 | 1588 | 35 |
1732972 | 1732972 | 2021-09-19 | Grundy | Iowa | 19075 | 1588 | 35 |
1729722 | 1729722 | 2021-09-18 | Grundy | Iowa | 19075 | 1588 | 35 |
1726472 | 1726472 | 2021-09-17 | Grundy | Iowa | 19075 | 1588 | 35 |
1723223 | 1723223 | 2021-09-16 | Grundy | Iowa | 19075 | 1588 | 35 |
1719974 | 1719974 | 2021-09-15 | Grundy | Iowa | 19075 | 1588 | 35 |
1534865 | 1534865 | 2021-07-20 | Poweshiek | Iowa | 19157 | 1588 | 36 |
1531618 | 1531618 | 2021-07-19 | Poweshiek | Iowa | 19157 | 1588 | 36 |
1528371 | 1528371 | 2021-07-18 | Poweshiek | Iowa | 19157 | 1588 | 36 |
1525124 | 1525124 | 2021-07-17 | Poweshiek | Iowa | 19157 | 1588 | 36 |
1521876 | 1521876 | 2021-07-16 | Poweshiek | Iowa | 19157 | 1588 | 36 |
1518628 | 1518628 | 2021-07-15 | Poweshiek | Iowa | 19157 | 1588 | 36 |
1515381 | 1515381 | 2021-07-14 | Poweshiek | Iowa | 19157 | 1588 | 36 |
1440707 | 1440707 | 2021-06-21 | Lyon | Iowa | 19119 | 1588 | 41 |
1437460 | 1437460 | 2021-06-20 | Lyon | Iowa | 19119 | 1588 | 41 |
1434213 | 1434213 | 2021-06-19 | Lyon | Iowa | 19119 | 1588 | 41 |
1430967 | 1430967 | 2021-06-18 | Lyon | Iowa | 19119 | 1588 | 41 |
1427722 | 1427722 | 2021-06-17 | Lyon | Iowa | 19119 | 1588 | 41 |
1424477 | 1424477 | 2021-06-16 | Lyon | Iowa | 19119 | 1588 | 41 |
1421229 | 1421229 | 2021-06-15 | Lyon | Iowa | 19119 | 1588 | 41 |
1417984 | 1417984 | 2021-06-14 | Lyon | Iowa | 19119 | 1588 | 41 |
1414738 | 1414738 | 2021-06-13 | Lyon | Iowa | 19119 | 1588 | 41 |
1411493 | 1411493 | 2021-06-12 | Lyon | Iowa | 19119 | 1588 | 41 |
1408248 | 1408248 | 2021-06-11 | Lyon | Iowa | 19119 | 1588 | 41 |
1405002 | 1405002 | 2021-06-10 | Lyon | Iowa | 19119 | 1588 | 41 |
1401757 | 1401757 | 2021-06-09 | Lyon | Iowa | 19119 | 1588 | 41 |
1398512 | 1398512 | 2021-06-08 | Lyon | Iowa | 19119 | 1588 | 41 |
1395265 | 1395265 | 2021-06-07 | Lyon | Iowa | 19119 | 1588 | 41 |
1392020 | 1392020 | 2021-06-06 | Lyon | Iowa | 19119 | 1588 | 41 |
1388775 | 1388775 | 2021-06-05 | Lyon | Iowa | 19119 | 1588 | 41 |
1385530 | 1385530 | 2021-06-04 | Lyon | Iowa | 19119 | 1588 | 41 |
1271878 | 1271878 | 2021-04-30 | Floyd | Iowa | 19067 | 1588 | 42 |
1268631 | 1268631 | 2021-04-29 | Floyd | Iowa | 19067 | 1588 | 42 |
1239439 | 1239439 | 2021-04-20 | Mills | Iowa | 19129 | 1588 | 20 |
1236192 | 1236192 | 2021-04-19 | Mills | Iowa | 19129 | 1588 | 20 |
1086768 | 1086768 | 2021-03-04 | Butler | Iowa | 19023 | 1588 | 31 |
1060814 | 1060814 | 2021-02-24 | Clayton | Iowa | 19043 | 1588 | 53 |
1057568 | 1057568 | 2021-02-23 | Clayton | Iowa | 19043 | 1588 | 53 |
1054322 | 1054322 | 2021-02-22 | Clayton | Iowa | 19043 | 1588 | 53 |
1051075 | 1051075 | 2021-02-21 | Clayton | Iowa | 19043 | 1588 | 53 |
1047828 | 1047828 | 2021-02-20 | Clayton | Iowa | 19043 | 1588 | 53 |
1044583 | 1044583 | 2021-02-19 | Clayton | Iowa | 19043 | 1588 | 53 |
979662 | 979662 | 2021-01-30 | Cedar | Iowa | 19031 | 1588 | 19 |
237812 | 237812 | 2020-06-14 | Buena Vista | Iowa | 19021 | 1588 | 6 |
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);