ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
36 rows where cases = 136 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
732998 | 732998 | 2020-11-15 | Adams | Iowa | 19003 | 136 | 1 |
642225 | 642225 | 2020-10-18 | Keokuk | Iowa | 19107 | 136 | 1 |
638978 | 638978 | 2020-10-17 | Keokuk | Iowa | 19107 | 136 | 1 |
635732 | 635732 | 2020-10-16 | Keokuk | Iowa | 19107 | 136 | 1 |
603286 | 603286 | 2020-10-06 | Greene | Iowa | 19073 | 136 | 0 |
570839 | 570839 | 2020-09-26 | Appanoose | Iowa | 19007 | 136 | 3 |
567597 | 567597 | 2020-09-25 | Appanoose | Iowa | 19007 | 136 | 3 |
561164 | 561164 | 2020-09-23 | Jefferson | Iowa | 19101 | 136 | 1 |
554655 | 554655 | 2020-09-21 | Cass | Iowa | 19029 | 136 | 2 |
512614 | 512614 | 2020-09-08 | Iowa | Iowa | 19095 | 136 | 1 |
509388 | 509388 | 2020-09-07 | Kossuth | Iowa | 19109 | 136 | 0 |
499671 | 499671 | 2020-09-04 | Grundy | Iowa | 19075 | 136 | 1 |
499698 | 499698 | 2020-09-04 | Mills | Iowa | 19129 | 136 | 1 |
489978 | 489978 | 2020-09-01 | Howard | Iowa | 19089 | 136 | 2 |
477016 | 477016 | 2020-08-28 | Cherokee | Iowa | 19035 | 136 | 2 |
467364 | 467364 | 2020-08-25 | Lyon | Iowa | 19119 | 136 | 2 |
464116 | 464116 | 2020-08-24 | Hancock | Iowa | 19081 | 136 | 2 |
464135 | 464135 | 2020-08-24 | Lyon | Iowa | 19119 | 136 | 2 |
460906 | 460906 | 2020-08-23 | Lyon | Iowa | 19119 | 136 | 2 |
457679 | 457679 | 2020-08-22 | Lyon | Iowa | 19119 | 136 | 2 |
441543 | 441543 | 2020-08-17 | Madison | Iowa | 19121 | 136 | 2 |
438284 | 438284 | 2020-08-16 | Delaware | Iowa | 19055 | 136 | 1 |
435083 | 435083 | 2020-08-15 | Jones | Iowa | 19105 | 136 | 2 |
431821 | 431821 | 2020-08-14 | Cedar | Iowa | 19031 | 136 | 1 |
431858 | 431858 | 2020-08-14 | Jones | Iowa | 19105 | 136 | 2 |
425397 | 425397 | 2020-08-12 | Henry | Iowa | 19087 | 136 | 4 |
409320 | 409320 | 2020-08-07 | O'Brien | Iowa | 19141 | 136 | 2 |
399657 | 399657 | 2020-08-04 | Mahaska | Iowa | 19123 | 136 | 17 |
396441 | 396441 | 2020-08-03 | Mahaska | Iowa | 19123 | 136 | 17 |
393225 | 393225 | 2020-08-02 | Mahaska | Iowa | 19123 | 136 | 17 |
383590 | 383590 | 2020-07-30 | Poweshiek | Iowa | 19157 | 136 | 8 |
370713 | 370713 | 2020-07-26 | Marion | Iowa | 19125 | 136 | 0 |
291018 | 291018 | 2020-07-01 | Boone | Iowa | 19015 | 136 | 1 |
287868 | 287868 | 2020-06-30 | Boone | Iowa | 19015 | 136 | 1 |
110383 | 110383 | 2020-05-03 | Dubuque | Iowa | 19061 | 136 | 5 |
93316 | 93316 | 2020-04-27 | Washington | Iowa | 19183 | 136 | 6 |
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);