ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
36 rows where cases = 1355 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2217313 | 2217313 | 2022-02-15 | Fremont | Iowa | 19071 | 1355 | 21 |
2214062 | 2214062 | 2022-02-14 | Fremont | Iowa | 19071 | 1355 | 21 |
2210810 | 2210810 | 2022-02-13 | Fremont | Iowa | 19071 | 1355 | 21 |
2207557 | 2207557 | 2022-02-12 | Fremont | Iowa | 19071 | 1355 | 21 |
2204304 | 2204304 | 2022-02-11 | Fremont | Iowa | 19071 | 1355 | 21 |
2201051 | 2201051 | 2022-02-10 | Fremont | Iowa | 19071 | 1355 | 21 |
2197797 | 2197797 | 2022-02-09 | Fremont | Iowa | 19071 | 1355 | 21 |
2080699 | 2080699 | 2022-01-04 | Greene | Iowa | 19073 | 1355 | 18 |
2077447 | 2077447 | 2022-01-03 | Greene | Iowa | 19073 | 1355 | 18 |
2074196 | 2074196 | 2022-01-02 | Greene | Iowa | 19073 | 1355 | 18 |
2070945 | 2070945 | 2022-01-01 | Greene | Iowa | 19073 | 1355 | 18 |
2067694 | 2067694 | 2021-12-31 | Greene | Iowa | 19073 | 1355 | 18 |
2064443 | 2064443 | 2021-12-30 | Greene | Iowa | 19073 | 1355 | 18 |
2061193 | 2061193 | 2021-12-29 | Greene | Iowa | 19073 | 1355 | 18 |
1580304 | 1580304 | 2021-08-03 | Jefferson | Iowa | 19101 | 1355 | 35 |
1577055 | 1577055 | 2021-08-02 | Jefferson | Iowa | 19101 | 1355 | 35 |
1573807 | 1573807 | 2021-08-01 | Jefferson | Iowa | 19101 | 1355 | 35 |
1570559 | 1570559 | 2021-07-31 | Jefferson | Iowa | 19101 | 1355 | 35 |
1567311 | 1567311 | 2021-07-30 | Jefferson | Iowa | 19101 | 1355 | 35 |
1564063 | 1564063 | 2021-07-29 | Jefferson | Iowa | 19101 | 1355 | 35 |
1560815 | 1560815 | 2021-07-28 | Jefferson | Iowa | 19101 | 1355 | 35 |
1385502 | 1385502 | 2021-06-04 | Emmet | Iowa | 19063 | 1355 | 40 |
1265388 | 1265388 | 2021-04-28 | Grundy | Iowa | 19075 | 1355 | 32 |
1262141 | 1262141 | 2021-04-27 | Grundy | Iowa | 19075 | 1355 | 32 |
1245906 | 1245906 | 2021-04-22 | Grundy | Iowa | 19075 | 1355 | 32 |
1242659 | 1242659 | 2021-04-21 | Grundy | Iowa | 19075 | 1355 | 32 |
1034874 | 1034874 | 2021-02-16 | Iowa | Iowa | 19095 | 1355 | 23 |
1031628 | 1031628 | 2021-02-15 | Iowa | Iowa | 19095 | 1355 | 23 |
1012111 | 1012111 | 2021-02-09 | Allamakee | Iowa | 19005 | 1355 | 41 |
1008903 | 1008903 | 2021-02-08 | Hancock | Iowa | 19081 | 1355 | 26 |
931032 | 931032 | 2021-01-15 | Mills | Iowa | 19129 | 1355 | 16 |
872567 | 872567 | 2020-12-28 | Cedar | Iowa | 19031 | 1355 | 18 |
836897 | 836897 | 2020-12-17 | Hardin | Iowa | 19083 | 1355 | 22 |
710347 | 710347 | 2020-11-08 | Lee | Iowa | 19111 | 1355 | 14 |
664910 | 664910 | 2020-10-25 | Crawford | Iowa | 19047 | 1355 | 14 |
370681 | 370681 | 2020-07-26 | Dubuque | Iowa | 19061 | 1355 | 26 |
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);