ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
39 rows where deaths = 30, fips = 19015 and state = "Iowa" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1161435 | 1161435 | 2021-03-27 | Boone | Iowa | 19015 | 2506 | 30 |
1158187 | 1158187 | 2021-03-26 | Boone | Iowa | 19015 | 2504 | 30 |
1154940 | 1154940 | 2021-03-25 | Boone | Iowa | 19015 | 2503 | 30 |
1151693 | 1151693 | 2021-03-24 | Boone | Iowa | 19015 | 2498 | 30 |
1148446 | 1148446 | 2021-03-23 | Boone | Iowa | 19015 | 2494 | 30 |
1145199 | 1145199 | 2021-03-22 | Boone | Iowa | 19015 | 2487 | 30 |
1141952 | 1141952 | 2021-03-21 | Boone | Iowa | 19015 | 2485 | 30 |
1138706 | 1138706 | 2021-03-20 | Boone | Iowa | 19015 | 2485 | 30 |
1135460 | 1135460 | 2021-03-19 | Boone | Iowa | 19015 | 2484 | 30 |
1132213 | 1132213 | 2021-03-18 | Boone | Iowa | 19015 | 2482 | 30 |
1128965 | 1128965 | 2021-03-17 | Boone | Iowa | 19015 | 2480 | 30 |
1125719 | 1125719 | 2021-03-16 | Boone | Iowa | 19015 | 2477 | 30 |
1122473 | 1122473 | 2021-03-15 | Boone | Iowa | 19015 | 2475 | 30 |
1119226 | 1119226 | 2021-03-14 | Boone | Iowa | 19015 | 2470 | 30 |
1115979 | 1115979 | 2021-03-13 | Boone | Iowa | 19015 | 2469 | 30 |
1112733 | 1112733 | 2021-03-12 | Boone | Iowa | 19015 | 2466 | 30 |
1109487 | 1109487 | 2021-03-11 | Boone | Iowa | 19015 | 2459 | 30 |
1106241 | 1106241 | 2021-03-10 | Boone | Iowa | 19015 | 2457 | 30 |
1102995 | 1102995 | 2021-03-09 | Boone | Iowa | 19015 | 2451 | 30 |
1099749 | 1099749 | 2021-03-08 | Boone | Iowa | 19015 | 2448 | 30 |
1096501 | 1096501 | 2021-03-07 | Boone | Iowa | 19015 | 2431 | 30 |
1093255 | 1093255 | 2021-03-06 | Boone | Iowa | 19015 | 2431 | 30 |
1090009 | 1090009 | 2021-03-05 | Boone | Iowa | 19015 | 2431 | 30 |
1086764 | 1086764 | 2021-03-04 | Boone | Iowa | 19015 | 2430 | 30 |
1083518 | 1083518 | 2021-03-03 | Boone | Iowa | 19015 | 2424 | 30 |
1080272 | 1080272 | 2021-03-02 | Boone | Iowa | 19015 | 2419 | 30 |
1077027 | 1077027 | 2021-03-01 | Boone | Iowa | 19015 | 2414 | 30 |
1073781 | 1073781 | 2021-02-28 | Boone | Iowa | 19015 | 2408 | 30 |
1070535 | 1070535 | 2021-02-27 | Boone | Iowa | 19015 | 2408 | 30 |
1067290 | 1067290 | 2021-02-26 | Boone | Iowa | 19015 | 2408 | 30 |
1064045 | 1064045 | 2021-02-25 | Boone | Iowa | 19015 | 2404 | 30 |
1060800 | 1060800 | 2021-02-24 | Boone | Iowa | 19015 | 2380 | 30 |
1057554 | 1057554 | 2021-02-23 | Boone | Iowa | 19015 | 2380 | 30 |
1054308 | 1054308 | 2021-02-22 | Boone | Iowa | 19015 | 2380 | 30 |
1051061 | 1051061 | 2021-02-21 | Boone | Iowa | 19015 | 2380 | 30 |
1047814 | 1047814 | 2021-02-20 | Boone | Iowa | 19015 | 2380 | 30 |
1044569 | 1044569 | 2021-02-19 | Boone | Iowa | 19015 | 2380 | 30 |
1041324 | 1041324 | 2021-02-18 | Boone | Iowa | 19015 | 2376 | 30 |
1038079 | 1038079 | 2021-02-17 | Boone | Iowa | 19015 | 2368 | 30 |
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);