ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
38 rows where cases = 106 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
716781 | 716781 | 2020-11-10 | Adams | Iowa | 19003 | 106 | 1 |
622797 | 622797 | 2020-10-12 | Wayne | Iowa | 19185 | 106 | 3 |
600011 | 600011 | 2020-10-05 | Audubon | Iowa | 19009 | 106 | 1 |
557924 | 557924 | 2020-09-22 | Ida | Iowa | 19093 | 106 | 0 |
525533 | 525533 | 2020-09-12 | Davis | Iowa | 19051 | 106 | 4 |
522297 | 522297 | 2020-09-11 | Davis | Iowa | 19051 | 106 | 4 |
499723 | 499723 | 2020-09-04 | Van Buren | Iowa | 19177 | 106 | 1 |
496490 | 496490 | 2020-09-03 | Van Buren | Iowa | 19177 | 106 | 1 |
480297 | 480297 | 2020-08-29 | Mitchell | Iowa | 19131 | 106 | 0 |
477065 | 477065 | 2020-08-28 | Monona | Iowa | 19133 | 106 | 1 |
473832 | 473832 | 2020-08-27 | Monona | Iowa | 19133 | 106 | 1 |
460894 | 460894 | 2020-08-23 | Iowa | Iowa | 19095 | 106 | 1 |
457692 | 457692 | 2020-08-22 | Page | Iowa | 19145 | 106 | 0 |
447990 | 447990 | 2020-08-19 | Kossuth | Iowa | 19109 | 106 | 0 |
444741 | 444741 | 2020-08-18 | Fayette | Iowa | 19065 | 106 | 0 |
441537 | 441537 | 2020-08-17 | Kossuth | Iowa | 19109 | 106 | 0 |
438311 | 438311 | 2020-08-16 | Kossuth | Iowa | 19109 | 106 | 0 |
431902 | 431902 | 2020-08-14 | Winneshiek | Iowa | 19191 | 106 | 1 |
422154 | 422154 | 2020-08-11 | Clayton | Iowa | 19043 | 106 | 3 |
409295 | 409295 | 2020-08-07 | Humboldt | Iowa | 19091 | 106 | 1 |
399655 | 399655 | 2020-08-04 | Lyon | Iowa | 19119 | 106 | 0 |
377118 | 377118 | 2020-07-28 | Hancock | Iowa | 19081 | 106 | 2 |
367493 | 367493 | 2020-07-25 | Jones | Iowa | 19105 | 106 | 1 |
364239 | 364239 | 2020-07-24 | Benton | Iowa | 19011 | 106 | 1 |
364249 | 364249 | 2020-07-24 | Cedar | Iowa | 19031 | 106 | 1 |
364286 | 364286 | 2020-07-24 | Jones | Iowa | 19105 | 106 | 1 |
361042 | 361042 | 2020-07-23 | Cedar | Iowa | 19031 | 106 | 1 |
348288 | 348288 | 2020-07-19 | O'Brien | Iowa | 19141 | 106 | 1 |
338652 | 338652 | 2020-07-16 | Emmet | Iowa | 19063 | 106 | 0 |
319507 | 319507 | 2020-07-10 | Bremer | Iowa | 19017 | 106 | 7 |
306892 | 306892 | 2020-07-06 | Poweshiek | Iowa | 19157 | 106 | 8 |
287943 | 287943 | 2020-06-30 | Shelby | Iowa | 19165 | 106 | 0 |
262754 | 262754 | 2020-06-22 | Clay | Iowa | 19041 | 106 | 0 |
259627 | 259627 | 2020-06-21 | Clay | Iowa | 19041 | 106 | 0 |
225423 | 225423 | 2020-06-10 | Hamilton | Iowa | 19079 | 106 | 0 |
188502 | 188502 | 2020-05-29 | Story | Iowa | 19169 | 106 | 1 |
62697 | 62697 | 2020-04-16 | Washington | Iowa | 19183 | 106 | 4 |
33878 | 33878 | 2020-04-05 | Johnson | Iowa | 19103 | 106 | 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);