ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where deaths = 116 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
county 11
state 1
- Iowa · 64 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2148990 | 2148990 | 2022-01-25 | Des Moines | Iowa | 19057 | 8123 | 116 |
2145738 | 2145738 | 2022-01-24 | Des Moines | Iowa | 19057 | 8123 | 116 |
2142483 | 2142483 | 2022-01-23 | Des Moines | Iowa | 19057 | 8123 | 116 |
2139228 | 2139228 | 2022-01-22 | Des Moines | Iowa | 19057 | 8123 | 116 |
2135972 | 2135972 | 2022-01-21 | Des Moines | Iowa | 19057 | 8123 | 116 |
2132720 | 2132720 | 2022-01-20 | Des Moines | Iowa | 19057 | 8123 | 116 |
2129467 | 2129467 | 2022-01-19 | Des Moines | Iowa | 19057 | 8123 | 116 |
2126240 | 2126240 | 2022-01-18 | Lee | Iowa | 19111 | 6742 | 116 |
2122988 | 2122988 | 2022-01-17 | Lee | Iowa | 19111 | 6742 | 116 |
2119736 | 2119736 | 2022-01-16 | Lee | Iowa | 19111 | 6742 | 116 |
2116484 | 2116484 | 2022-01-15 | Lee | Iowa | 19111 | 6742 | 116 |
2113233 | 2113233 | 2022-01-14 | Lee | Iowa | 19111 | 6742 | 116 |
2109981 | 2109981 | 2022-01-13 | Lee | Iowa | 19111 | 6742 | 116 |
2106730 | 2106730 | 2022-01-12 | Lee | Iowa | 19111 | 6742 | 116 |
2103515 | 2103515 | 2022-01-11 | Warren | Iowa | 19181 | 9705 | 116 |
2100264 | 2100264 | 2022-01-10 | Warren | Iowa | 19181 | 9705 | 116 |
2097013 | 2097013 | 2022-01-09 | Warren | Iowa | 19181 | 9705 | 116 |
2093761 | 2093761 | 2022-01-08 | Warren | Iowa | 19181 | 9705 | 116 |
2090509 | 2090509 | 2022-01-07 | Warren | Iowa | 19181 | 9705 | 116 |
2087258 | 2087258 | 2022-01-06 | Warren | Iowa | 19181 | 9705 | 116 |
2084006 | 2084006 | 2022-01-05 | Warren | Iowa | 19181 | 9705 | 116 |
2080714 | 2080714 | 2022-01-04 | Johnson | Iowa | 19103 | 22358 | 116 |
2077462 | 2077462 | 2022-01-03 | Johnson | Iowa | 19103 | 22358 | 116 |
2074211 | 2074211 | 2022-01-02 | Johnson | Iowa | 19103 | 22358 | 116 |
2070960 | 2070960 | 2022-01-01 | Johnson | Iowa | 19103 | 22358 | 116 |
2067709 | 2067709 | 2021-12-31 | Johnson | Iowa | 19103 | 22358 | 116 |
2064458 | 2064458 | 2021-12-30 | Johnson | Iowa | 19103 | 22358 | 116 |
2061208 | 2061208 | 2021-12-29 | Johnson | Iowa | 19103 | 22358 | 116 |
2057959 | 2057959 | 2021-12-28 | Johnson | Iowa | 19103 | 21585 | 116 |
2054710 | 2054710 | 2021-12-27 | Johnson | Iowa | 19103 | 21585 | 116 |
2051460 | 2051460 | 2021-12-26 | Johnson | Iowa | 19103 | 21585 | 116 |
2048210 | 2048210 | 2021-12-25 | Johnson | Iowa | 19103 | 21585 | 116 |
2044960 | 2044960 | 2021-12-24 | Johnson | Iowa | 19103 | 21585 | 116 |
2041711 | 2041711 | 2021-12-23 | Johnson | Iowa | 19103 | 21585 | 116 |
2038461 | 2038461 | 2021-12-22 | Johnson | Iowa | 19103 | 21585 | 116 |
2012427 | 2012427 | 2021-12-14 | Clinton | Iowa | 19045 | 8421 | 116 |
2009176 | 2009176 | 2021-12-13 | Clinton | Iowa | 19045 | 8421 | 116 |
2005925 | 2005925 | 2021-12-12 | Clinton | Iowa | 19045 | 8421 | 116 |
2002674 | 2002674 | 2021-12-11 | Clinton | Iowa | 19045 | 8421 | 116 |
1999424 | 1999424 | 2021-12-10 | Clinton | Iowa | 19045 | 8421 | 116 |
1996173 | 1996173 | 2021-12-09 | Clinton | Iowa | 19045 | 8421 | 116 |
1992922 | 1992922 | 2021-12-08 | Clinton | Iowa | 19045 | 8421 | 116 |
1875990 | 1875990 | 2021-11-02 | Webster | Iowa | 19187 | 7012 | 116 |
1872741 | 1872741 | 2021-11-01 | Webster | Iowa | 19187 | 7012 | 116 |
1869492 | 1869492 | 2021-10-31 | Webster | Iowa | 19187 | 7012 | 116 |
1866243 | 1866243 | 2021-10-30 | Webster | Iowa | 19187 | 7012 | 116 |
1862994 | 1862994 | 2021-10-29 | Webster | Iowa | 19187 | 7012 | 116 |
1859745 | 1859745 | 2021-10-28 | Webster | Iowa | 19187 | 7012 | 116 |
1856496 | 1856496 | 2021-10-27 | Webster | Iowa | 19187 | 7012 | 116 |
1174509 | 1174509 | 2021-03-31 | Wapello | Iowa | 19179 | 4219 | 116 |
1171262 | 1171262 | 2021-03-30 | Wapello | Iowa | 19179 | 4215 | 116 |
1168014 | 1168014 | 2021-03-29 | Wapello | Iowa | 19179 | 4209 | 116 |
1164766 | 1164766 | 2021-03-28 | Wapello | Iowa | 19179 | 4207 | 116 |
1161518 | 1161518 | 2021-03-27 | Wapello | Iowa | 19179 | 4204 | 116 |
1158270 | 1158270 | 2021-03-26 | Wapello | Iowa | 19179 | 4203 | 116 |
823951 | 823951 | 2020-12-13 | Scott | Iowa | 19163 | 12929 | 116 |
820705 | 820705 | 2020-12-12 | Scott | Iowa | 19163 | 12819 | 116 |
817459 | 817459 | 2020-12-11 | Scott | Iowa | 19163 | 12739 | 116 |
762308 | 762308 | 2020-11-24 | Woodbury | Iowa | 19193 | 9985 | 116 |
733003 | 733003 | 2020-11-15 | Black Hawk | Iowa | 19013 | 9125 | 116 |
603306 | 603306 | 2020-10-06 | Linn | Iowa | 19113 | 4472 | 116 |
600063 | 600063 | 2020-10-05 | Linn | Iowa | 19113 | 4425 | 116 |
596821 | 596821 | 2020-10-04 | Linn | Iowa | 19113 | 4387 | 116 |
593579 | 593579 | 2020-10-03 | Linn | Iowa | 19113 | 4372 | 116 |
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);