ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
30 rows where date = "2020-03-24" and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
fips 30
county 30
- Adair 1
- Allamakee 1
- Black Hawk 1
- Buchanan 1
- Carroll 1
- Cedar 1
- Cerro Gordo 1
- Dallas 1
- Dubuque 1
- Fayette 1
- Hancock 1
- Harrison 1
- Henry 1
- Jasper 1
- Johnson 1
- Kossuth 1
- Linn 1
- Muscatine 1
- Polk 1
- Pottawattamie 1
- Poweshiek 1
- Scott 1
- Sioux 1
- Story 1
- Tama 1
- Wapello 1
- Warren 1
- Washington 1
- Winneshiek 1
- Woodbury 1
state 1
- Iowa · 30 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
9888 | 9888 | 2020-03-24 | Adair | Iowa | 19001 | 1 | 0 |
9889 | 9889 | 2020-03-24 | Allamakee | Iowa | 19005 | 6 | 0 |
9890 | 9890 | 2020-03-24 | Black Hawk | Iowa | 19013 | 4 | 0 |
9891 | 9891 | 2020-03-24 | Buchanan | Iowa | 19019 | 1 | 0 |
9892 | 9892 | 2020-03-24 | Carroll | Iowa | 19027 | 1 | 0 |
9893 | 9893 | 2020-03-24 | Cedar | Iowa | 19031 | 1 | 0 |
9894 | 9894 | 2020-03-24 | Cerro Gordo | Iowa | 19033 | 2 | 0 |
9895 | 9895 | 2020-03-24 | Dallas | Iowa | 19049 | 7 | 0 |
9896 | 9896 | 2020-03-24 | Dubuque | Iowa | 19061 | 6 | 1 |
9897 | 9897 | 2020-03-24 | Fayette | Iowa | 19065 | 1 | 0 |
9898 | 9898 | 2020-03-24 | Hancock | Iowa | 19081 | 2 | 0 |
9899 | 9899 | 2020-03-24 | Harrison | Iowa | 19085 | 3 | 0 |
9900 | 9900 | 2020-03-24 | Henry | Iowa | 19087 | 1 | 0 |
9901 | 9901 | 2020-03-24 | Jasper | Iowa | 19099 | 1 | 0 |
9902 | 9902 | 2020-03-24 | Johnson | Iowa | 19103 | 37 | 0 |
9903 | 9903 | 2020-03-24 | Kossuth | Iowa | 19109 | 1 | 0 |
9904 | 9904 | 2020-03-24 | Linn | Iowa | 19113 | 6 | 0 |
9905 | 9905 | 2020-03-24 | Muscatine | Iowa | 19139 | 5 | 0 |
9906 | 9906 | 2020-03-24 | Polk | Iowa | 19153 | 17 | 0 |
9907 | 9907 | 2020-03-24 | Pottawattamie | Iowa | 19155 | 2 | 0 |
9908 | 9908 | 2020-03-24 | Poweshiek | Iowa | 19157 | 2 | 0 |
9909 | 9909 | 2020-03-24 | Scott | Iowa | 19163 | 1 | 0 |
9910 | 9910 | 2020-03-24 | Sioux | Iowa | 19167 | 1 | 0 |
9911 | 9911 | 2020-03-24 | Story | Iowa | 19169 | 2 | 0 |
9912 | 9912 | 2020-03-24 | Tama | Iowa | 19171 | 4 | 0 |
9913 | 9913 | 2020-03-24 | Wapello | Iowa | 19179 | 1 | 0 |
9914 | 9914 | 2020-03-24 | Warren | Iowa | 19181 | 1 | 0 |
9915 | 9915 | 2020-03-24 | Washington | Iowa | 19183 | 4 | 0 |
9916 | 9916 | 2020-03-24 | Winneshiek | Iowa | 19191 | 1 | 0 |
9917 | 9917 | 2020-03-24 | Woodbury | Iowa | 19193 | 2 | 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);