ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
45 rows where cases = 91 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
fips >30
county >30
- Monona 8
- Osceola 3
- Adams 2
- Grundy 2
- Jefferson 2
- Keokuk 2
- Wayne 2
- Audubon 1
- Buchanan 1
- Carroll 1
- Delaware 1
- Des Moines 1
- Emmet 1
- Floyd 1
- Hamilton 1
- Jasper 1
- Kossuth 1
- Lyon 1
- Madison 1
- Mahaska 1
- Mitchell 1
- Monroe 1
- Muscatine 1
- O'Brien 1
- Pottawattamie 1
- Poweshiek 1
- Sac 1
- Union 1
- Webster 1
- Winneshiek 1
- …
state 1
- Iowa · 45 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
697320 | 697320 | 2020-11-04 | Adams | Iowa | 19003 | 91 | 1 |
694078 | 694078 | 2020-11-03 | Adams | Iowa | 19003 | 91 | 1 |
596858 | 596858 | 2020-10-04 | Wayne | Iowa | 19185 | 91 | 3 |
593616 | 593616 | 2020-10-03 | Wayne | Iowa | 19185 | 91 | 3 |
583805 | 583805 | 2020-09-30 | Audubon | Iowa | 19009 | 91 | 1 |
554694 | 554694 | 2020-09-21 | Keokuk | Iowa | 19107 | 91 | 1 |
551455 | 551455 | 2020-09-20 | Keokuk | Iowa | 19107 | 91 | 1 |
519133 | 519133 | 2020-09-10 | Worth | Iowa | 19195 | 91 | 0 |
470621 | 470621 | 2020-08-26 | Union | Iowa | 19175 | 91 | 3 |
467370 | 467370 | 2020-08-25 | Mitchell | Iowa | 19131 | 91 | 0 |
464147 | 464147 | 2020-08-24 | Osceola | Iowa | 19143 | 91 | 0 |
460918 | 460918 | 2020-08-23 | Osceola | Iowa | 19143 | 91 | 0 |
457687 | 457687 | 2020-08-22 | Monroe | Iowa | 19135 | 91 | 8 |
457691 | 457691 | 2020-08-22 | Osceola | Iowa | 19143 | 91 | 0 |
444789 | 444789 | 2020-08-18 | Sac | Iowa | 19161 | 91 | 0 |
441520 | 441520 | 2020-08-17 | Grundy | Iowa | 19075 | 91 | 1 |
438294 | 438294 | 2020-08-16 | Grundy | Iowa | 19075 | 91 | 1 |
438307 | 438307 | 2020-08-16 | Jefferson | Iowa | 19101 | 91 | 0 |
435081 | 435081 | 2020-08-15 | Jefferson | Iowa | 19101 | 91 | 0 |
425420 | 425420 | 2020-08-12 | Monona | Iowa | 19133 | 91 | 0 |
422199 | 422199 | 2020-08-11 | Monona | Iowa | 19133 | 91 | 0 |
418976 | 418976 | 2020-08-10 | Monona | Iowa | 19133 | 91 | 0 |
415743 | 415743 | 2020-08-09 | Kossuth | Iowa | 19109 | 91 | 0 |
415755 | 415755 | 2020-08-09 | Monona | Iowa | 19133 | 91 | 0 |
412535 | 412535 | 2020-08-08 | Monona | Iowa | 19133 | 91 | 0 |
409316 | 409316 | 2020-08-07 | Monona | Iowa | 19133 | 91 | 0 |
406096 | 406096 | 2020-08-06 | Monona | Iowa | 19133 | 91 | 0 |
406126 | 406126 | 2020-08-06 | Winneshiek | Iowa | 19191 | 91 | 1 |
402878 | 402878 | 2020-08-05 | Monona | Iowa | 19133 | 91 | 0 |
399623 | 399623 | 2020-08-04 | Delaware | Iowa | 19055 | 91 | 1 |
380355 | 380355 | 2020-07-29 | Madison | Iowa | 19121 | 91 | 2 |
377137 | 377137 | 2020-07-28 | Lyon | Iowa | 19119 | 91 | 0 |
373872 | 373872 | 2020-07-27 | Buchanan | Iowa | 19019 | 91 | 1 |
345050 | 345050 | 2020-07-18 | Floyd | Iowa | 19067 | 91 | 2 |
313183 | 313183 | 2020-07-08 | Emmet | Iowa | 19063 | 91 | 0 |
313222 | 313222 | 2020-07-08 | O'Brien | Iowa | 19141 | 91 | 1 |
310010 | 310010 | 2020-07-07 | Des Moines | Iowa | 19057 | 91 | 2 |
294178 | 294178 | 2020-07-02 | Carroll | Iowa | 19027 | 91 | 1 |
228580 | 228580 | 2020-06-11 | Webster | Iowa | 19187 | 91 | 1 |
219233 | 219233 | 2020-06-08 | Hamilton | Iowa | 19079 | 91 | 0 |
203847 | 203847 | 2020-06-03 | Poweshiek | Iowa | 19157 | 91 | 8 |
185421 | 185421 | 2020-05-28 | Mahaska | Iowa | 19123 | 91 | 8 |
137053 | 137053 | 2020-05-12 | Pottawattamie | Iowa | 19155 | 91 | 2 |
93278 | 93278 | 2020-04-27 | Jasper | Iowa | 19099 | 91 | 0 |
49211 | 49211 | 2020-04-11 | Muscatine | Iowa | 19139 | 91 | 1 |
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);