ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
22 rows where cases = 2001 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 4
- Calhoun 7
- Madison 7
- Winneshiek 7
- Henry 1
state 1
- Iowa · 22 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1989661 | 1989661 | 2021-12-07 | Calhoun | Iowa | 19025 | 2001 | 19 |
1986411 | 1986411 | 2021-12-06 | Calhoun | Iowa | 19025 | 2001 | 19 |
1983161 | 1983161 | 2021-12-05 | Calhoun | Iowa | 19025 | 2001 | 19 |
1979911 | 1979911 | 2021-12-04 | Calhoun | Iowa | 19025 | 2001 | 19 |
1976661 | 1976661 | 2021-12-03 | Calhoun | Iowa | 19025 | 2001 | 19 |
1973412 | 1973412 | 2021-12-02 | Calhoun | Iowa | 19025 | 2001 | 19 |
1970162 | 1970162 | 2021-12-01 | Calhoun | Iowa | 19025 | 2001 | 19 |
1762235 | 1762235 | 2021-09-28 | Madison | Iowa | 19121 | 2001 | 20 |
1758987 | 1758987 | 2021-09-27 | Madison | Iowa | 19121 | 2001 | 20 |
1755739 | 1755739 | 2021-09-26 | Madison | Iowa | 19121 | 2001 | 20 |
1752491 | 1752491 | 2021-09-25 | Madison | Iowa | 19121 | 2001 | 20 |
1749242 | 1749242 | 2021-09-24 | Madison | Iowa | 19121 | 2001 | 20 |
1745992 | 1745992 | 2021-09-23 | Madison | Iowa | 19121 | 2001 | 20 |
1742743 | 1742743 | 2021-09-22 | Madison | Iowa | 19121 | 2001 | 20 |
1534883 | 1534883 | 2021-07-20 | Winneshiek | Iowa | 19191 | 2001 | 35 |
1531636 | 1531636 | 2021-07-19 | Winneshiek | Iowa | 19191 | 2001 | 35 |
1528389 | 1528389 | 2021-07-18 | Winneshiek | Iowa | 19191 | 2001 | 35 |
1525142 | 1525142 | 2021-07-17 | Winneshiek | Iowa | 19191 | 2001 | 35 |
1521894 | 1521894 | 2021-07-16 | Winneshiek | Iowa | 19191 | 2001 | 35 |
1518646 | 1518646 | 2021-07-15 | Winneshiek | Iowa | 19191 | 2001 | 35 |
1515399 | 1515399 | 2021-07-14 | Winneshiek | Iowa | 19191 | 2001 | 35 |
801195 | 801195 | 2020-12-06 | Henry | Iowa | 19087 | 2001 | 8 |
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);