ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
46 rows where deaths = 140 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases
state 1
- Iowa · 46 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2331117 | 2331117 | 2022-03-22 | Dallas | Iowa | 19049 | 22919 | 140 |
2327865 | 2327865 | 2022-03-21 | Dallas | Iowa | 19049 | 22919 | 140 |
2324612 | 2324612 | 2022-03-20 | Dallas | Iowa | 19049 | 22919 | 140 |
2321358 | 2321358 | 2022-03-19 | Dallas | Iowa | 19049 | 22919 | 140 |
2318104 | 2318104 | 2022-03-18 | Dallas | Iowa | 19049 | 22919 | 140 |
2314851 | 2314851 | 2022-03-17 | Dallas | Iowa | 19049 | 22919 | 140 |
2311598 | 2311598 | 2022-03-16 | Dallas | Iowa | 19049 | 22919 | 140 |
2308372 | 2308372 | 2022-03-15 | Johnson | Iowa | 19103 | 33776 | 140 |
2305121 | 2305121 | 2022-03-14 | Johnson | Iowa | 19103 | 33776 | 140 |
2301869 | 2301869 | 2022-03-13 | Johnson | Iowa | 19103 | 33776 | 140 |
2298617 | 2298617 | 2022-03-12 | Johnson | Iowa | 19103 | 33776 | 140 |
2295365 | 2295365 | 2022-03-11 | Johnson | Iowa | 19103 | 33776 | 140 |
2292113 | 2292113 | 2022-03-10 | Johnson | Iowa | 19103 | 33776 | 140 |
2288861 | 2288861 | 2022-03-09 | Johnson | Iowa | 19103 | 33776 | 140 |
2262814 | 2262814 | 2022-03-01 | Clinton | Iowa | 19045 | 11417 | 140 |
2259563 | 2259563 | 2022-02-28 | Clinton | Iowa | 19045 | 11417 | 140 |
2256312 | 2256312 | 2022-02-27 | Clinton | Iowa | 19045 | 11417 | 140 |
2253061 | 2253061 | 2022-02-26 | Clinton | Iowa | 19045 | 11417 | 140 |
2249810 | 2249810 | 2022-02-25 | Clinton | Iowa | 19045 | 11417 | 140 |
2246559 | 2246559 | 2022-02-24 | Clinton | Iowa | 19045 | 11417 | 140 |
2243308 | 2243308 | 2022-02-23 | Clinton | Iowa | 19045 | 11417 | 140 |
2149056 | 2149056 | 2022-01-25 | Webster | Iowa | 19187 | 9430 | 140 |
2145804 | 2145804 | 2022-01-24 | Webster | Iowa | 19187 | 9430 | 140 |
2142549 | 2142549 | 2022-01-23 | Webster | Iowa | 19187 | 9430 | 140 |
2139294 | 2139294 | 2022-01-22 | Webster | Iowa | 19187 | 9430 | 140 |
2136038 | 2136038 | 2022-01-21 | Webster | Iowa | 19187 | 9430 | 140 |
2132786 | 2132786 | 2022-01-20 | Webster | Iowa | 19187 | 9430 | 140 |
2129533 | 2129533 | 2022-01-19 | Webster | Iowa | 19187 | 9430 | 140 |
1060870 | 1060870 | 2021-02-24 | Pottawattamie | Iowa | 19155 | 9666 | 140 |
1057624 | 1057624 | 2021-02-23 | Pottawattamie | Iowa | 19155 | 9666 | 140 |
1054378 | 1054378 | 2021-02-22 | Pottawattamie | Iowa | 19155 | 9666 | 140 |
1051131 | 1051131 | 2021-02-21 | Pottawattamie | Iowa | 19155 | 9666 | 140 |
1047884 | 1047884 | 2021-02-20 | Pottawattamie | Iowa | 19155 | 9666 | 140 |
1044639 | 1044639 | 2021-02-19 | Pottawattamie | Iowa | 19155 | 9666 | 140 |
1041394 | 1041394 | 2021-02-18 | Pottawattamie | Iowa | 19155 | 9662 | 140 |
1038149 | 1038149 | 2021-02-17 | Pottawattamie | Iowa | 19155 | 9647 | 140 |
1034904 | 1034904 | 2021-02-16 | Pottawattamie | Iowa | 19155 | 9627 | 140 |
908282 | 908282 | 2021-01-08 | Dubuque | Iowa | 19061 | 11036 | 140 |
905036 | 905036 | 2021-01-07 | Dubuque | Iowa | 19061 | 10952 | 140 |
901791 | 901791 | 2021-01-06 | Dubuque | Iowa | 19061 | 10866 | 140 |
814229 | 814229 | 2020-12-10 | Woodbury | Iowa | 19193 | 11237 | 140 |
801249 | 801249 | 2020-12-06 | Woodbury | Iowa | 19193 | 11001 | 140 |
798004 | 798004 | 2020-12-05 | Woodbury | Iowa | 19193 | 10946 | 140 |
794759 | 794759 | 2020-12-04 | Woodbury | Iowa | 19193 | 10819 | 140 |
710348 | 710348 | 2020-11-08 | Linn | Iowa | 19113 | 8922 | 140 |
707104 | 707104 | 2020-11-07 | Linn | Iowa | 19113 | 8416 | 140 |
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);