ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
23 rows where cases = 1141 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 11
state 1
- Iowa · 23 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1898709 | 1898709 | 2021-11-09 | Monona | Iowa | 19133 | 1141 | 39 |
1895459 | 1895459 | 2021-11-08 | Monona | Iowa | 19133 | 1141 | 39 |
1892209 | 1892209 | 2021-11-07 | Monona | Iowa | 19133 | 1141 | 39 |
1888959 | 1888959 | 2021-11-06 | Monona | Iowa | 19133 | 1141 | 39 |
1885709 | 1885709 | 2021-11-05 | Monona | Iowa | 19133 | 1141 | 39 |
1882460 | 1882460 | 2021-11-04 | Monona | Iowa | 19133 | 1141 | 39 |
1879211 | 1879211 | 2021-11-03 | Monona | Iowa | 19133 | 1141 | 39 |
1739501 | 1739501 | 2021-09-21 | Monroe | Iowa | 19135 | 1141 | 33 |
1736252 | 1736252 | 2021-09-20 | Monroe | Iowa | 19135 | 1141 | 33 |
1733002 | 1733002 | 2021-09-19 | Monroe | Iowa | 19135 | 1141 | 33 |
1729752 | 1729752 | 2021-09-18 | Monroe | Iowa | 19135 | 1141 | 33 |
1726502 | 1726502 | 2021-09-17 | Monroe | Iowa | 19135 | 1141 | 33 |
1723253 | 1723253 | 2021-09-16 | Monroe | Iowa | 19135 | 1141 | 33 |
1720004 | 1720004 | 2021-09-15 | Monroe | Iowa | 19135 | 1141 | 33 |
1103033 | 1103033 | 2021-03-09 | Humboldt | Iowa | 19091 | 1141 | 25 |
1064069 | 1064069 | 2021-02-25 | Emmet | Iowa | 19063 | 1141 | 40 |
976481 | 976481 | 2021-01-29 | Sac | Iowa | 19161 | 1141 | 15 |
969929 | 969929 | 2021-01-27 | Chickasaw | Iowa | 19037 | 1141 | 12 |
934270 | 934270 | 2021-01-16 | Louisa | Iowa | 19115 | 1141 | 30 |
885579 | 885579 | 2021-01-01 | Iowa | Iowa | 19095 | 1141 | 21 |
765465 | 765465 | 2020-11-25 | Buchanan | Iowa | 19019 | 1141 | 10 |
570910 | 570910 | 2020-09-26 | Plymouth | Iowa | 19149 | 1141 | 21 |
406114 | 406114 | 2020-08-06 | Story | Iowa | 19169 | 1141 | 14 |
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);