ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
206 rows where deaths = 78 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500387 | 2500387 | 2022-05-13 | Cass | Iowa | 19029 | 2962 | 78 |
2497129 | 2497129 | 2022-05-12 | Cass | Iowa | 19029 | 2962 | 78 |
2493871 | 2493871 | 2022-05-11 | Cass | Iowa | 19029 | 2962 | 78 |
2490613 | 2490613 | 2022-05-10 | Cass | Iowa | 19029 | 2962 | 78 |
2487356 | 2487356 | 2022-05-09 | Cass | Iowa | 19029 | 2962 | 78 |
2484098 | 2484098 | 2022-05-08 | Cass | Iowa | 19029 | 2962 | 78 |
2480840 | 2480840 | 2022-05-07 | Cass | Iowa | 19029 | 2962 | 78 |
2477582 | 2477582 | 2022-05-06 | Cass | Iowa | 19029 | 2962 | 78 |
2474324 | 2474324 | 2022-05-05 | Cass | Iowa | 19029 | 2962 | 78 |
2471067 | 2471067 | 2022-05-04 | Cass | Iowa | 19029 | 2962 | 78 |
2467811 | 2467811 | 2022-05-03 | Cass | Iowa | 19029 | 2960 | 78 |
2464556 | 2464556 | 2022-05-02 | Cass | Iowa | 19029 | 2960 | 78 |
2461300 | 2461300 | 2022-05-01 | Cass | Iowa | 19029 | 2960 | 78 |
2458044 | 2458044 | 2022-04-30 | Cass | Iowa | 19029 | 2960 | 78 |
2454788 | 2454788 | 2022-04-29 | Cass | Iowa | 19029 | 2960 | 78 |
2451532 | 2451532 | 2022-04-28 | Cass | Iowa | 19029 | 2960 | 78 |
2448276 | 2448276 | 2022-04-27 | Cass | Iowa | 19029 | 2960 | 78 |
2445020 | 2445020 | 2022-04-26 | Cass | Iowa | 19029 | 2961 | 78 |
2441764 | 2441764 | 2022-04-25 | Cass | Iowa | 19029 | 2961 | 78 |
2438508 | 2438508 | 2022-04-24 | Cass | Iowa | 19029 | 2961 | 78 |
2435252 | 2435252 | 2022-04-23 | Cass | Iowa | 19029 | 2961 | 78 |
2431996 | 2431996 | 2022-04-22 | Cass | Iowa | 19029 | 2961 | 78 |
2428740 | 2428740 | 2022-04-21 | Cass | Iowa | 19029 | 2961 | 78 |
2425484 | 2425484 | 2022-04-20 | Cass | Iowa | 19029 | 2961 | 78 |
2422228 | 2422228 | 2022-04-19 | Cass | Iowa | 19029 | 2958 | 78 |
2418972 | 2418972 | 2022-04-18 | Cass | Iowa | 19029 | 2958 | 78 |
2415716 | 2415716 | 2022-04-17 | Cass | Iowa | 19029 | 2958 | 78 |
2412460 | 2412460 | 2022-04-16 | Cass | Iowa | 19029 | 2958 | 78 |
2409204 | 2409204 | 2022-04-15 | Cass | Iowa | 19029 | 2958 | 78 |
2405948 | 2405948 | 2022-04-14 | Cass | Iowa | 19029 | 2958 | 78 |
2402692 | 2402692 | 2022-04-13 | Cass | Iowa | 19029 | 2958 | 78 |
2194516 | 2194516 | 2022-02-08 | Bremer | Iowa | 19017 | 5258 | 78 |
2191262 | 2191262 | 2022-02-07 | Bremer | Iowa | 19017 | 5258 | 78 |
2188009 | 2188009 | 2022-02-06 | Bremer | Iowa | 19017 | 5258 | 78 |
2184756 | 2184756 | 2022-02-05 | Bremer | Iowa | 19017 | 5258 | 78 |
2181504 | 2181504 | 2022-02-04 | Bremer | Iowa | 19017 | 5258 | 78 |
2178253 | 2178253 | 2022-02-03 | Bremer | Iowa | 19017 | 5258 | 78 |
2175000 | 2175000 | 2022-02-02 | Bremer | Iowa | 19017 | 5258 | 78 |
2126268 | 2126268 | 2022-01-18 | Sioux | Iowa | 19167 | 7028 | 78 |
2123016 | 2123016 | 2022-01-17 | Sioux | Iowa | 19167 | 7028 | 78 |
2119764 | 2119764 | 2022-01-16 | Sioux | Iowa | 19167 | 7028 | 78 |
2116512 | 2116512 | 2022-01-15 | Sioux | Iowa | 19167 | 7028 | 78 |
2113261 | 2113261 | 2022-01-14 | Sioux | Iowa | 19167 | 7028 | 78 |
2110009 | 2110009 | 2022-01-13 | Sioux | Iowa | 19167 | 7028 | 78 |
2106758 | 2106758 | 2022-01-12 | Sioux | Iowa | 19167 | 7028 | 78 |
2103507 | 2103507 | 2022-01-11 | Sioux | Iowa | 19167 | 6677 | 78 |
2100256 | 2100256 | 2022-01-10 | Sioux | Iowa | 19167 | 6677 | 78 |
2097005 | 2097005 | 2022-01-09 | Sioux | Iowa | 19167 | 6677 | 78 |
2093753 | 2093753 | 2022-01-08 | Sioux | Iowa | 19167 | 6677 | 78 |
2090501 | 2090501 | 2022-01-07 | Sioux | Iowa | 19167 | 6677 | 78 |
2087250 | 2087250 | 2022-01-06 | Sioux | Iowa | 19167 | 6677 | 78 |
2083998 | 2083998 | 2022-01-05 | Sioux | Iowa | 19167 | 6677 | 78 |
2080746 | 2080746 | 2022-01-04 | Sioux | Iowa | 19167 | 6520 | 78 |
2077494 | 2077494 | 2022-01-03 | Sioux | Iowa | 19167 | 6520 | 78 |
2074243 | 2074243 | 2022-01-02 | Sioux | Iowa | 19167 | 6520 | 78 |
2070992 | 2070992 | 2022-01-01 | Sioux | Iowa | 19167 | 6520 | 78 |
2067741 | 2067741 | 2021-12-31 | Sioux | Iowa | 19167 | 6520 | 78 |
2064490 | 2064490 | 2021-12-30 | Sioux | Iowa | 19167 | 6520 | 78 |
2061240 | 2061240 | 2021-12-29 | Sioux | Iowa | 19167 | 6520 | 78 |
2057991 | 2057991 | 2021-12-28 | Sioux | Iowa | 19167 | 6462 | 78 |
2054742 | 2054742 | 2021-12-27 | Sioux | Iowa | 19167 | 6462 | 78 |
2051492 | 2051492 | 2021-12-26 | Sioux | Iowa | 19167 | 6462 | 78 |
2048242 | 2048242 | 2021-12-25 | Sioux | Iowa | 19167 | 6462 | 78 |
2044992 | 2044992 | 2021-12-24 | Sioux | Iowa | 19167 | 6462 | 78 |
2041743 | 2041743 | 2021-12-23 | Sioux | Iowa | 19167 | 6462 | 78 |
2038493 | 2038493 | 2021-12-22 | Sioux | Iowa | 19167 | 6462 | 78 |
2035245 | 2035245 | 2021-12-21 | Tama | Iowa | 19171 | 2958 | 78 |
2031995 | 2031995 | 2021-12-20 | Tama | Iowa | 19171 | 2958 | 78 |
2028744 | 2028744 | 2021-12-19 | Tama | Iowa | 19171 | 2958 | 78 |
2025493 | 2025493 | 2021-12-18 | Tama | Iowa | 19171 | 2958 | 78 |
2022242 | 2022242 | 2021-12-17 | Tama | Iowa | 19171 | 2958 | 78 |
2018991 | 2018991 | 2021-12-16 | Tama | Iowa | 19171 | 2958 | 78 |
2015741 | 2015741 | 2021-12-15 | Tama | Iowa | 19171 | 2958 | 78 |
2012459 | 2012459 | 2021-12-14 | Kossuth | Iowa | 19109 | 3040 | 78 |
2012490 | 2012490 | 2021-12-14 | Tama | Iowa | 19171 | 2891 | 78 |
2009208 | 2009208 | 2021-12-13 | Kossuth | Iowa | 19109 | 3040 | 78 |
2009239 | 2009239 | 2021-12-13 | Tama | Iowa | 19171 | 2891 | 78 |
2005957 | 2005957 | 2021-12-12 | Kossuth | Iowa | 19109 | 3040 | 78 |
2005988 | 2005988 | 2021-12-12 | Tama | Iowa | 19171 | 2891 | 78 |
2002706 | 2002706 | 2021-12-11 | Kossuth | Iowa | 19109 | 3040 | 78 |
2002737 | 2002737 | 2021-12-11 | Tama | Iowa | 19171 | 2891 | 78 |
1999456 | 1999456 | 2021-12-10 | Kossuth | Iowa | 19109 | 3040 | 78 |
1999487 | 1999487 | 2021-12-10 | Tama | Iowa | 19171 | 2891 | 78 |
1996205 | 1996205 | 2021-12-09 | Kossuth | Iowa | 19109 | 3040 | 78 |
1996236 | 1996236 | 2021-12-09 | Tama | Iowa | 19171 | 2891 | 78 |
1992954 | 1992954 | 2021-12-08 | Kossuth | Iowa | 19109 | 3040 | 78 |
1992985 | 1992985 | 2021-12-08 | Tama | Iowa | 19171 | 2891 | 78 |
1989734 | 1989734 | 2021-12-07 | Tama | Iowa | 19171 | 2837 | 78 |
1986484 | 1986484 | 2021-12-06 | Tama | Iowa | 19171 | 2837 | 78 |
1983234 | 1983234 | 2021-12-05 | Tama | Iowa | 19171 | 2837 | 78 |
1979984 | 1979984 | 2021-12-04 | Tama | Iowa | 19171 | 2837 | 78 |
1976734 | 1976734 | 2021-12-03 | Tama | Iowa | 19171 | 2837 | 78 |
1973485 | 1973485 | 2021-12-02 | Tama | Iowa | 19171 | 2837 | 78 |
1970235 | 1970235 | 2021-12-01 | Tama | Iowa | 19171 | 2837 | 78 |
1944184 | 1944184 | 2021-11-23 | Harrison | Iowa | 19085 | 2303 | 78 |
1940934 | 1940934 | 2021-11-22 | Harrison | Iowa | 19085 | 2303 | 78 |
1937684 | 1937684 | 2021-11-21 | Harrison | Iowa | 19085 | 2303 | 78 |
1934434 | 1934434 | 2021-11-20 | Harrison | Iowa | 19085 | 2303 | 78 |
1931183 | 1931183 | 2021-11-19 | Harrison | Iowa | 19085 | 2303 | 78 |
1927932 | 1927932 | 2021-11-18 | Harrison | Iowa | 19085 | 2303 | 78 |
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);