ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
13 rows where date = "2020-03-20" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
fips 13
county 13
- Adair 1
- Allamakee 1
- Black Hawk 1
- Carroll 1
- Dallas 1
- Dubuque 1
- Harrison 1
- Johnson 1
- Muscatine 1
- Polk 1
- Pottawattamie 1
- Washington 1
- Winneshiek 1
state 1
- Iowa · 13 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
5453 | 5453 | 2020-03-20 | Adair | Iowa | 19001 | 1 | 0 |
5454 | 5454 | 2020-03-20 | Allamakee | Iowa | 19005 | 3 | 0 |
5455 | 5455 | 2020-03-20 | Black Hawk | Iowa | 19013 | 1 | 0 |
5456 | 5456 | 2020-03-20 | Carroll | Iowa | 19027 | 1 | 0 |
5457 | 5457 | 2020-03-20 | Dallas | Iowa | 19049 | 5 | 0 |
5458 | 5458 | 2020-03-20 | Dubuque | Iowa | 19061 | 1 | 0 |
5459 | 5459 | 2020-03-20 | Harrison | Iowa | 19085 | 1 | 0 |
5460 | 5460 | 2020-03-20 | Johnson | Iowa | 19103 | 22 | 0 |
5461 | 5461 | 2020-03-20 | Muscatine | Iowa | 19139 | 1 | 0 |
5462 | 5462 | 2020-03-20 | Polk | Iowa | 19153 | 6 | 0 |
5463 | 5463 | 2020-03-20 | Pottawattamie | Iowa | 19155 | 1 | 0 |
5464 | 5464 | 2020-03-20 | Washington | Iowa | 19183 | 1 | 0 |
5465 | 5465 | 2020-03-20 | Winneshiek | Iowa | 19191 | 1 | 0 |
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);