ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
189 rows where deaths = 70 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
2285598 | 2285598 | 2022-03-08 | Hamilton | Iowa | 19079 | 3462 | 70 |
2282346 | 2282346 | 2022-03-07 | Hamilton | Iowa | 19079 | 3462 | 70 |
2279093 | 2279093 | 2022-03-06 | Hamilton | Iowa | 19079 | 3462 | 70 |
2275840 | 2275840 | 2022-03-05 | Hamilton | Iowa | 19079 | 3462 | 70 |
2272587 | 2272587 | 2022-03-04 | Hamilton | Iowa | 19079 | 3462 | 70 |
2269335 | 2269335 | 2022-03-03 | Hamilton | Iowa | 19079 | 3462 | 70 |
2266082 | 2266082 | 2022-03-02 | Hamilton | Iowa | 19079 | 3462 | 70 |
2262831 | 2262831 | 2022-03-01 | Hamilton | Iowa | 19079 | 3464 | 70 |
2262862 | 2262862 | 2022-03-01 | O'Brien | Iowa | 19141 | 3396 | 70 |
2259580 | 2259580 | 2022-02-28 | Hamilton | Iowa | 19079 | 3464 | 70 |
2259611 | 2259611 | 2022-02-28 | O'Brien | Iowa | 19141 | 3396 | 70 |
2256329 | 2256329 | 2022-02-27 | Hamilton | Iowa | 19079 | 3464 | 70 |
2256360 | 2256360 | 2022-02-27 | O'Brien | Iowa | 19141 | 3396 | 70 |
2253078 | 2253078 | 2022-02-26 | Hamilton | Iowa | 19079 | 3464 | 70 |
2253109 | 2253109 | 2022-02-26 | O'Brien | Iowa | 19141 | 3396 | 70 |
2249827 | 2249827 | 2022-02-25 | Hamilton | Iowa | 19079 | 3464 | 70 |
2249858 | 2249858 | 2022-02-25 | O'Brien | Iowa | 19141 | 3396 | 70 |
2246576 | 2246576 | 2022-02-24 | Hamilton | Iowa | 19079 | 3464 | 70 |
2246607 | 2246607 | 2022-02-24 | O'Brien | Iowa | 19141 | 3396 | 70 |
2243325 | 2243325 | 2022-02-23 | Hamilton | Iowa | 19079 | 3464 | 70 |
2243356 | 2243356 | 2022-02-23 | O'Brien | Iowa | 19141 | 3396 | 70 |
2240087 | 2240087 | 2022-02-22 | Jones | Iowa | 19105 | 5386 | 70 |
2240105 | 2240105 | 2022-02-22 | O'Brien | Iowa | 19141 | 3388 | 70 |
2236836 | 2236836 | 2022-02-21 | Jones | Iowa | 19105 | 5386 | 70 |
2236854 | 2236854 | 2022-02-21 | O'Brien | Iowa | 19141 | 3388 | 70 |
2233585 | 2233585 | 2022-02-20 | Jones | Iowa | 19105 | 5386 | 70 |
2233603 | 2233603 | 2022-02-20 | O'Brien | Iowa | 19141 | 3388 | 70 |
2230334 | 2230334 | 2022-02-19 | Jones | Iowa | 19105 | 5386 | 70 |
2230352 | 2230352 | 2022-02-19 | O'Brien | Iowa | 19141 | 3388 | 70 |
2227083 | 2227083 | 2022-02-18 | Jones | Iowa | 19105 | 5386 | 70 |
2227101 | 2227101 | 2022-02-18 | O'Brien | Iowa | 19141 | 3388 | 70 |
2223832 | 2223832 | 2022-02-17 | Jones | Iowa | 19105 | 5386 | 70 |
2223850 | 2223850 | 2022-02-17 | O'Brien | Iowa | 19141 | 3388 | 70 |
2220581 | 2220581 | 2022-02-16 | Jones | Iowa | 19105 | 5386 | 70 |
2220599 | 2220599 | 2022-02-16 | O'Brien | Iowa | 19141 | 3388 | 70 |
2217307 | 2217307 | 2022-02-15 | Dickinson | Iowa | 19059 | 4064 | 70 |
2217310 | 2217310 | 2022-02-15 | Fayette | Iowa | 19065 | 3943 | 70 |
2217348 | 2217348 | 2022-02-15 | O'Brien | Iowa | 19141 | 3370 | 70 |
2214056 | 2214056 | 2022-02-14 | Dickinson | Iowa | 19059 | 4064 | 70 |
2214059 | 2214059 | 2022-02-14 | Fayette | Iowa | 19065 | 3943 | 70 |
2214097 | 2214097 | 2022-02-14 | O'Brien | Iowa | 19141 | 3370 | 70 |
2210804 | 2210804 | 2022-02-13 | Dickinson | Iowa | 19059 | 4064 | 70 |
2210807 | 2210807 | 2022-02-13 | Fayette | Iowa | 19065 | 3943 | 70 |
2210845 | 2210845 | 2022-02-13 | O'Brien | Iowa | 19141 | 3370 | 70 |
2207551 | 2207551 | 2022-02-12 | Dickinson | Iowa | 19059 | 4064 | 70 |
2207554 | 2207554 | 2022-02-12 | Fayette | Iowa | 19065 | 3943 | 70 |
2207592 | 2207592 | 2022-02-12 | O'Brien | Iowa | 19141 | 3370 | 70 |
2204298 | 2204298 | 2022-02-11 | Dickinson | Iowa | 19059 | 4064 | 70 |
2204301 | 2204301 | 2022-02-11 | Fayette | Iowa | 19065 | 3943 | 70 |
2204339 | 2204339 | 2022-02-11 | O'Brien | Iowa | 19141 | 3370 | 70 |
2201045 | 2201045 | 2022-02-10 | Dickinson | Iowa | 19059 | 4064 | 70 |
2201048 | 2201048 | 2022-02-10 | Fayette | Iowa | 19065 | 3943 | 70 |
2201086 | 2201086 | 2022-02-10 | O'Brien | Iowa | 19141 | 3370 | 70 |
2197791 | 2197791 | 2022-02-09 | Dickinson | Iowa | 19059 | 4064 | 70 |
2197794 | 2197794 | 2022-02-09 | Fayette | Iowa | 19065 | 3943 | 70 |
2197832 | 2197832 | 2022-02-09 | O'Brien | Iowa | 19141 | 3370 | 70 |
2194578 | 2194578 | 2022-02-08 | O'Brien | Iowa | 19141 | 3319 | 70 |
2191324 | 2191324 | 2022-02-07 | O'Brien | Iowa | 19141 | 3319 | 70 |
2188071 | 2188071 | 2022-02-06 | O'Brien | Iowa | 19141 | 3319 | 70 |
2184818 | 2184818 | 2022-02-05 | O'Brien | Iowa | 19141 | 3319 | 70 |
2181566 | 2181566 | 2022-02-04 | O'Brien | Iowa | 19141 | 3319 | 70 |
2178315 | 2178315 | 2022-02-03 | O'Brien | Iowa | 19141 | 3319 | 70 |
2175062 | 2175062 | 2022-02-02 | O'Brien | Iowa | 19141 | 3319 | 70 |
2171744 | 2171744 | 2022-02-01 | Benton | Iowa | 19011 | 5637 | 70 |
2171809 | 2171809 | 2022-02-01 | O'Brien | Iowa | 19141 | 3248 | 70 |
2168491 | 2168491 | 2022-01-31 | Benton | Iowa | 19011 | 5637 | 70 |
2168556 | 2168556 | 2022-01-31 | O'Brien | Iowa | 19141 | 3248 | 70 |
2165236 | 2165236 | 2022-01-30 | Benton | Iowa | 19011 | 5637 | 70 |
2165301 | 2165301 | 2022-01-30 | O'Brien | Iowa | 19141 | 3248 | 70 |
2161981 | 2161981 | 2022-01-29 | Benton | Iowa | 19011 | 5637 | 70 |
2162046 | 2162046 | 2022-01-29 | O'Brien | Iowa | 19141 | 3248 | 70 |
2158726 | 2158726 | 2022-01-28 | Benton | Iowa | 19011 | 5637 | 70 |
2158791 | 2158791 | 2022-01-28 | O'Brien | Iowa | 19141 | 3248 | 70 |
2155472 | 2155472 | 2022-01-27 | Benton | Iowa | 19011 | 5637 | 70 |
2155537 | 2155537 | 2022-01-27 | O'Brien | Iowa | 19141 | 3248 | 70 |
2152219 | 2152219 | 2022-01-26 | Benton | Iowa | 19011 | 5637 | 70 |
2152284 | 2152284 | 2022-01-26 | O'Brien | Iowa | 19141 | 3248 | 70 |
2149046 | 2149046 | 2022-01-25 | Story | Iowa | 19169 | 17185 | 70 |
2149054 | 2149054 | 2022-01-25 | Washington | Iowa | 19183 | 5015 | 70 |
2145794 | 2145794 | 2022-01-24 | Story | Iowa | 19169 | 17185 | 70 |
2145802 | 2145802 | 2022-01-24 | Washington | Iowa | 19183 | 5015 | 70 |
2142539 | 2142539 | 2022-01-23 | Story | Iowa | 19169 | 17185 | 70 |
2142547 | 2142547 | 2022-01-23 | Washington | Iowa | 19183 | 5015 | 70 |
2139284 | 2139284 | 2022-01-22 | Story | Iowa | 19169 | 17185 | 70 |
2139292 | 2139292 | 2022-01-22 | Washington | Iowa | 19183 | 5015 | 70 |
2136028 | 2136028 | 2022-01-21 | Story | Iowa | 19169 | 17185 | 70 |
2136036 | 2136036 | 2022-01-21 | Washington | Iowa | 19183 | 5015 | 70 |
2132776 | 2132776 | 2022-01-20 | Story | Iowa | 19169 | 17185 | 70 |
2132784 | 2132784 | 2022-01-20 | Washington | Iowa | 19183 | 5015 | 70 |
2129523 | 2129523 | 2022-01-19 | Story | Iowa | 19169 | 17185 | 70 |
2129531 | 2129531 | 2022-01-19 | Washington | Iowa | 19183 | 5015 | 70 |
1898651 | 1898651 | 2021-11-09 | Bremer | Iowa | 19017 | 3665 | 70 |
1895401 | 1895401 | 2021-11-08 | Bremer | Iowa | 19017 | 3665 | 70 |
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);