ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
22 rows where county = "Crawford", deaths = 22 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
943971 | 943971 | 2021-01-19 | Crawford | Iowa | 19047 | 2310 | 22 |
940726 | 940726 | 2021-01-18 | Crawford | Iowa | 19047 | 2295 | 22 |
937481 | 937481 | 2021-01-17 | Crawford | Iowa | 19047 | 2283 | 22 |
934236 | 934236 | 2021-01-16 | Crawford | Iowa | 19047 | 2283 | 22 |
930991 | 930991 | 2021-01-15 | Crawford | Iowa | 19047 | 2277 | 22 |
927746 | 927746 | 2021-01-14 | Crawford | Iowa | 19047 | 2274 | 22 |
924500 | 924500 | 2021-01-13 | Crawford | Iowa | 19047 | 2266 | 22 |
921255 | 921255 | 2021-01-12 | Crawford | Iowa | 19047 | 2260 | 22 |
918010 | 918010 | 2021-01-11 | Crawford | Iowa | 19047 | 2254 | 22 |
914765 | 914765 | 2021-01-10 | Crawford | Iowa | 19047 | 2242 | 22 |
911520 | 911520 | 2021-01-09 | Crawford | Iowa | 19047 | 2235 | 22 |
908275 | 908275 | 2021-01-08 | Crawford | Iowa | 19047 | 2224 | 22 |
905029 | 905029 | 2021-01-07 | Crawford | Iowa | 19047 | 2216 | 22 |
901784 | 901784 | 2021-01-06 | Crawford | Iowa | 19047 | 2199 | 22 |
898539 | 898539 | 2021-01-05 | Crawford | Iowa | 19047 | 2180 | 22 |
895294 | 895294 | 2021-01-04 | Crawford | Iowa | 19047 | 2148 | 22 |
892047 | 892047 | 2021-01-03 | Crawford | Iowa | 19047 | 2134 | 22 |
888801 | 888801 | 2021-01-02 | Crawford | Iowa | 19047 | 2135 | 22 |
885555 | 885555 | 2021-01-01 | Crawford | Iowa | 19047 | 2133 | 22 |
882310 | 882310 | 2020-12-31 | Crawford | Iowa | 19047 | 2127 | 22 |
879065 | 879065 | 2020-12-30 | Crawford | Iowa | 19047 | 2107 | 22 |
875820 | 875820 | 2020-12-29 | Crawford | Iowa | 19047 | 2104 | 22 |
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);