ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
121 rows where deaths = 91 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2240077 | 2240077 | 2022-02-22 | Harrison | Iowa | 19085 | 3388 | 91 |
2236826 | 2236826 | 2022-02-21 | Harrison | Iowa | 19085 | 3388 | 91 |
2233575 | 2233575 | 2022-02-20 | Harrison | Iowa | 19085 | 3388 | 91 |
2230324 | 2230324 | 2022-02-19 | Harrison | Iowa | 19085 | 3388 | 91 |
2227073 | 2227073 | 2022-02-18 | Harrison | Iowa | 19085 | 3388 | 91 |
2223822 | 2223822 | 2022-02-17 | Harrison | Iowa | 19085 | 3388 | 91 |
2220571 | 2220571 | 2022-02-16 | Harrison | Iowa | 19085 | 3388 | 91 |
2080712 | 2080712 | 2022-01-04 | Jasper | Iowa | 19099 | 6855 | 91 |
2077460 | 2077460 | 2022-01-03 | Jasper | Iowa | 19099 | 6855 | 91 |
2074209 | 2074209 | 2022-01-02 | Jasper | Iowa | 19099 | 6855 | 91 |
2070958 | 2070958 | 2022-01-01 | Jasper | Iowa | 19099 | 6855 | 91 |
2067707 | 2067707 | 2021-12-31 | Jasper | Iowa | 19099 | 6855 | 91 |
2064456 | 2064456 | 2021-12-30 | Jasper | Iowa | 19099 | 6855 | 91 |
2061206 | 2061206 | 2021-12-29 | Jasper | Iowa | 19099 | 6855 | 91 |
2057957 | 2057957 | 2021-12-28 | Jasper | Iowa | 19099 | 6720 | 91 |
2054708 | 2054708 | 2021-12-27 | Jasper | Iowa | 19099 | 6720 | 91 |
2051458 | 2051458 | 2021-12-26 | Jasper | Iowa | 19099 | 6720 | 91 |
2048208 | 2048208 | 2021-12-25 | Jasper | Iowa | 19099 | 6720 | 91 |
2044958 | 2044958 | 2021-12-24 | Jasper | Iowa | 19099 | 6720 | 91 |
2041709 | 2041709 | 2021-12-23 | Jasper | Iowa | 19099 | 6720 | 91 |
2038459 | 2038459 | 2021-12-22 | Jasper | Iowa | 19099 | 6720 | 91 |
2035209 | 2035209 | 2021-12-21 | Jasper | Iowa | 19099 | 6596 | 91 |
2031959 | 2031959 | 2021-12-20 | Jasper | Iowa | 19099 | 6596 | 91 |
2028708 | 2028708 | 2021-12-19 | Jasper | Iowa | 19099 | 6596 | 91 |
2025457 | 2025457 | 2021-12-18 | Jasper | Iowa | 19099 | 6596 | 91 |
2022206 | 2022206 | 2021-12-17 | Jasper | Iowa | 19099 | 6596 | 91 |
2018955 | 2018955 | 2021-12-16 | Jasper | Iowa | 19099 | 6596 | 91 |
2015705 | 2015705 | 2021-12-15 | Jasper | Iowa | 19099 | 6596 | 91 |
2012454 | 2012454 | 2021-12-14 | Jasper | Iowa | 19099 | 6446 | 91 |
2009203 | 2009203 | 2021-12-13 | Jasper | Iowa | 19099 | 6446 | 91 |
2005952 | 2005952 | 2021-12-12 | Jasper | Iowa | 19099 | 6446 | 91 |
2002701 | 2002701 | 2021-12-11 | Jasper | Iowa | 19099 | 6446 | 91 |
1999451 | 1999451 | 2021-12-10 | Jasper | Iowa | 19099 | 6446 | 91 |
1996200 | 1996200 | 2021-12-09 | Jasper | Iowa | 19099 | 6446 | 91 |
1992949 | 1992949 | 2021-12-08 | Jasper | Iowa | 19099 | 6446 | 91 |
1989698 | 1989698 | 2021-12-07 | Jasper | Iowa | 19099 | 6317 | 91 |
1986448 | 1986448 | 2021-12-06 | Jasper | Iowa | 19099 | 6317 | 91 |
1983198 | 1983198 | 2021-12-05 | Jasper | Iowa | 19099 | 6317 | 91 |
1979948 | 1979948 | 2021-12-04 | Jasper | Iowa | 19099 | 6317 | 91 |
1976698 | 1976698 | 2021-12-03 | Jasper | Iowa | 19099 | 6317 | 91 |
1973449 | 1973449 | 2021-12-02 | Jasper | Iowa | 19099 | 6317 | 91 |
1970199 | 1970199 | 2021-12-01 | Jasper | Iowa | 19099 | 6317 | 91 |
1966949 | 1966949 | 2021-11-30 | Jasper | Iowa | 19099 | 6219 | 91 |
1963697 | 1963697 | 2021-11-29 | Jasper | Iowa | 19099 | 6219 | 91 |
1960446 | 1960446 | 2021-11-28 | Jasper | Iowa | 19099 | 6219 | 91 |
1957195 | 1957195 | 2021-11-27 | Jasper | Iowa | 19099 | 6219 | 91 |
1953944 | 1953944 | 2021-11-26 | Jasper | Iowa | 19099 | 6219 | 91 |
1950693 | 1950693 | 2021-11-25 | Jasper | Iowa | 19099 | 6219 | 91 |
1947442 | 1947442 | 2021-11-24 | Jasper | Iowa | 19099 | 6219 | 91 |
1898706 | 1898706 | 2021-11-09 | Marshall | Iowa | 19127 | 6529 | 91 |
1895456 | 1895456 | 2021-11-08 | Marshall | Iowa | 19127 | 6529 | 91 |
1892206 | 1892206 | 2021-11-07 | Marshall | Iowa | 19127 | 6529 | 91 |
1888956 | 1888956 | 2021-11-06 | Marshall | Iowa | 19127 | 6529 | 91 |
1885706 | 1885706 | 2021-11-05 | Marshall | Iowa | 19127 | 6529 | 91 |
1882457 | 1882457 | 2021-11-04 | Marshall | Iowa | 19127 | 6529 | 91 |
1879208 | 1879208 | 2021-11-03 | Marshall | Iowa | 19127 | 6529 | 91 |
1853215 | 1853215 | 2021-10-26 | Marion | Iowa | 19125 | 5081 | 91 |
1849966 | 1849966 | 2021-10-25 | Marion | Iowa | 19125 | 5081 | 91 |
1846716 | 1846716 | 2021-10-24 | Marion | Iowa | 19125 | 5081 | 91 |
1843466 | 1843466 | 2021-10-23 | Marion | Iowa | 19125 | 5081 | 91 |
1840216 | 1840216 | 2021-10-22 | Marion | Iowa | 19125 | 5081 | 91 |
1836967 | 1836967 | 2021-10-21 | Marion | Iowa | 19125 | 5081 | 91 |
1833718 | 1833718 | 2021-10-20 | Marion | Iowa | 19125 | 5081 | 91 |
1830469 | 1830469 | 2021-10-19 | Marion | Iowa | 19125 | 5000 | 91 |
1827220 | 1827220 | 2021-10-18 | Marion | Iowa | 19125 | 5000 | 91 |
1823971 | 1823971 | 2021-10-17 | Marion | Iowa | 19125 | 5000 | 91 |
1820722 | 1820722 | 2021-10-16 | Marion | Iowa | 19125 | 5000 | 91 |
1817473 | 1817473 | 2021-10-15 | Marion | Iowa | 19125 | 5000 | 91 |
1814225 | 1814225 | 2021-10-14 | Marion | Iowa | 19125 | 5000 | 91 |
1810976 | 1810976 | 2021-10-13 | Marion | Iowa | 19125 | 5000 | 91 |
1453720 | 1453720 | 2021-06-25 | Warren | Iowa | 19181 | 5841 | 91 |
1450474 | 1450474 | 2021-06-24 | Warren | Iowa | 19181 | 5841 | 91 |
1447229 | 1447229 | 2021-06-23 | Warren | Iowa | 19181 | 5840 | 91 |
1443984 | 1443984 | 2021-06-22 | Warren | Iowa | 19181 | 5839 | 91 |
1440739 | 1440739 | 2021-06-21 | Warren | Iowa | 19181 | 5838 | 91 |
1437492 | 1437492 | 2021-06-20 | Warren | Iowa | 19181 | 5837 | 91 |
1434245 | 1434245 | 2021-06-19 | Warren | Iowa | 19181 | 5838 | 91 |
1430999 | 1430999 | 2021-06-18 | Warren | Iowa | 19181 | 5839 | 91 |
1427754 | 1427754 | 2021-06-17 | Warren | Iowa | 19181 | 5837 | 91 |
1424509 | 1424509 | 2021-06-16 | Warren | Iowa | 19181 | 5837 | 91 |
1421261 | 1421261 | 2021-06-15 | Warren | Iowa | 19181 | 5838 | 91 |
1418016 | 1418016 | 2021-06-14 | Warren | Iowa | 19181 | 5837 | 91 |
1414770 | 1414770 | 2021-06-13 | Warren | Iowa | 19181 | 5834 | 91 |
1411525 | 1411525 | 2021-06-12 | Warren | Iowa | 19181 | 5832 | 91 |
1408280 | 1408280 | 2021-06-11 | Warren | Iowa | 19181 | 5830 | 91 |
1405034 | 1405034 | 2021-06-10 | Warren | Iowa | 19181 | 5831 | 91 |
1401714 | 1401714 | 2021-06-09 | Cerro Gordo | Iowa | 19033 | 5516 | 91 |
1249138 | 1249138 | 2021-04-23 | Clinton | Iowa | 19045 | 5423 | 91 |
1245891 | 1245891 | 2021-04-22 | Clinton | Iowa | 19045 | 5419 | 91 |
1242644 | 1242644 | 2021-04-21 | Clinton | Iowa | 19045 | 5417 | 91 |
1239397 | 1239397 | 2021-04-20 | Clinton | Iowa | 19045 | 5402 | 91 |
1239469 | 1239469 | 2021-04-20 | Webster | Iowa | 19187 | 5086 | 91 |
1236222 | 1236222 | 2021-04-19 | Webster | Iowa | 19187 | 5084 | 91 |
1232975 | 1232975 | 2021-04-18 | Webster | Iowa | 19187 | 5083 | 91 |
1229726 | 1229726 | 2021-04-17 | Webster | Iowa | 19187 | 5082 | 91 |
1226478 | 1226478 | 2021-04-16 | Webster | Iowa | 19187 | 5078 | 91 |
1223231 | 1223231 | 2021-04-15 | Webster | Iowa | 19187 | 5078 | 91 |
1219983 | 1219983 | 2021-04-14 | Webster | Iowa | 19187 | 5076 | 91 |
1216735 | 1216735 | 2021-04-13 | Webster | Iowa | 19187 | 5064 | 91 |
1213488 | 1213488 | 2021-04-12 | Webster | Iowa | 19187 | 5061 | 91 |
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);