ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
23 rows where cases = 224 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
840102 | 840102 | 2020-12-18 | Adams | Iowa | 19003 | 224 | 2 |
687589 | 687589 | 2020-11-01 | Adair | Iowa | 19001 | 224 | 1 |
687624 | 687624 | 2020-11-01 | Fremont | Iowa | 19071 | 224 | 2 |
629256 | 629256 | 2020-10-14 | Monroe | Iowa | 19135 | 224 | 11 |
587114 | 587114 | 2020-10-01 | Palo Alto | Iowa | 19147 | 224 | 0 |
577358 | 577358 | 2020-09-28 | Grundy | Iowa | 19075 | 224 | 3 |
541698 | 541698 | 2020-09-17 | Buchanan | Iowa | 19019 | 224 | 1 |
541748 | 541748 | 2020-09-17 | Lyon | Iowa | 19119 | 224 | 3 |
535218 | 535218 | 2020-09-15 | Allamakee | Iowa | 19005 | 224 | 5 |
512649 | 512649 | 2020-09-08 | Shelby | Iowa | 19165 | 224 | 1 |
509345 | 509345 | 2020-09-07 | Butler | Iowa | 19023 | 224 | 2 |
509416 | 509416 | 2020-09-07 | Shelby | Iowa | 19165 | 224 | 1 |
502938 | 502938 | 2020-09-05 | O'Brien | Iowa | 19141 | 224 | 8 |
493263 | 493263 | 2020-09-02 | Winneshiek | Iowa | 19191 | 224 | 4 |
490030 | 490030 | 2020-09-01 | Winneshiek | Iowa | 19191 | 224 | 4 |
470553 | 470553 | 2020-08-26 | Clarke | Iowa | 19039 | 224 | 3 |
444722 | 444722 | 2020-08-18 | Carroll | Iowa | 19027 | 224 | 2 |
383519 | 383519 | 2020-07-30 | Boone | Iowa | 19015 | 224 | 2 |
316342 | 316342 | 2020-07-09 | Cerro Gordo | Iowa | 19033 | 224 | 1 |
275362 | 275362 | 2020-06-26 | Warren | Iowa | 19181 | 224 | 2 |
76469 | 76469 | 2020-04-21 | Marshall | Iowa | 19127 | 224 | 0 |
76486 | 76486 | 2020-04-21 | Tama | Iowa | 19171 | 224 | 6 |
59963 | 59963 | 2020-04-15 | Polk | Iowa | 19153 | 224 | 7 |
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);