ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
23 rows where cases = 521 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1395210 | 1395210 | 2021-06-07 | Audubon | Iowa | 19009 | 521 | 10 |
1249209 | 1249209 | 2021-04-23 | Wayne | Iowa | 19185 | 521 | 23 |
1245962 | 1245962 | 2021-04-22 | Wayne | Iowa | 19185 | 521 | 23 |
1242715 | 1242715 | 2021-04-21 | Wayne | Iowa | 19185 | 521 | 23 |
1239468 | 1239468 | 2021-04-20 | Wayne | Iowa | 19185 | 521 | 23 |
1236221 | 1236221 | 2021-04-19 | Wayne | Iowa | 19185 | 521 | 23 |
1232974 | 1232974 | 2021-04-18 | Wayne | Iowa | 19185 | 521 | 23 |
1229725 | 1229725 | 2021-04-17 | Wayne | Iowa | 19185 | 521 | 23 |
1226477 | 1226477 | 2021-04-16 | Wayne | Iowa | 19185 | 521 | 23 |
1145271 | 1145271 | 2021-03-22 | Ringgold | Iowa | 19159 | 521 | 22 |
992722 | 992722 | 2021-02-03 | Van Buren | Iowa | 19177 | 521 | 16 |
989476 | 989476 | 2021-02-02 | Van Buren | Iowa | 19177 | 521 | 16 |
882385 | 882385 | 2020-12-31 | Worth | Iowa | 19195 | 521 | 3 |
840167 | 840167 | 2020-12-18 | Monona | Iowa | 19133 | 521 | 13 |
801171 | 801171 | 2020-12-06 | Clarke | Iowa | 19039 | 521 | 4 |
775263 | 775263 | 2020-11-28 | Osceola | Iowa | 19143 | 521 | 1 |
713538 | 713538 | 2020-11-09 | Allamakee | Iowa | 19005 | 521 | 9 |
677954 | 677954 | 2020-10-29 | Winnebago | Iowa | 19189 | 521 | 19 |
664944 | 664944 | 2020-10-25 | Louisa | Iowa | 19115 | 521 | 15 |
648669 | 648669 | 2020-10-20 | Benton | Iowa | 19011 | 521 | 1 |
622765 | 622765 | 2020-10-12 | Mahaska | Iowa | 19123 | 521 | 21 |
373948 | 373948 | 2020-07-27 | Tama | Iowa | 19171 | 521 | 29 |
265946 | 265946 | 2020-06-23 | Story | Iowa | 19169 | 521 | 3 |
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);