ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
18 rows where cases = 271 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
892025 | 892025 | 2021-01-03 | Adams | Iowa | 19003 | 271 | 2 |
720081 | 720081 | 2020-11-11 | Lucas | Iowa | 19117 | 271 | 6 |
632478 | 632478 | 2020-10-15 | Humboldt | Iowa | 19091 | 271 | 3 |
613049 | 613049 | 2020-10-09 | Page | Iowa | 19145 | 271 | 0 |
600067 | 600067 | 2020-10-05 | Madison | Iowa | 19121 | 271 | 2 |
596767 | 596767 | 2020-10-04 | Allamakee | Iowa | 19005 | 271 | 6 |
583822 | 583822 | 2020-09-30 | Clayton | Iowa | 19043 | 271 | 3 |
583839 | 583839 | 2020-09-30 | Guthrie | Iowa | 19077 | 271 | 10 |
574090 | 574090 | 2020-09-27 | Butler | Iowa | 19023 | 271 | 2 |
551497 | 551497 | 2020-09-20 | Winnebago | Iowa | 19189 | 271 | 11 |
541709 | 541709 | 2020-09-17 | Clay | Iowa | 19041 | 271 | 3 |
538548 | 538548 | 2020-09-16 | Winneshiek | Iowa | 19191 | 271 | 5 |
444743 | 444743 | 2020-08-18 | Franklin | Iowa | 19069 | 271 | 16 |
441511 | 441511 | 2020-08-17 | Des Moines | Iowa | 19057 | 271 | 2 |
441517 | 441517 | 2020-08-17 | Franklin | Iowa | 19069 | 271 | 15 |
319515 | 319515 | 2020-07-10 | Cerro Gordo | Iowa | 19033 | 271 | 1 |
213064 | 213064 | 2020-06-06 | Jasper | Iowa | 19099 | 271 | 17 |
84846 | 84846 | 2020-04-24 | Marshall | Iowa | 19127 | 271 | 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);