ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
36 rows where county = "Green" and deaths = 17 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1375982 | 1375982 | 2021-06-01 | Green | Kentucky | 21087 | 1230 | 17 |
1372737 | 1372737 | 2021-05-31 | Green | Kentucky | 21087 | 1230 | 17 |
1369492 | 1369492 | 2021-05-30 | Green | Kentucky | 21087 | 1230 | 17 |
1366246 | 1366246 | 2021-05-29 | Green | Kentucky | 21087 | 1230 | 17 |
1363000 | 1363000 | 2021-05-28 | Green | Kentucky | 21087 | 1227 | 17 |
1359753 | 1359753 | 2021-05-27 | Green | Kentucky | 21087 | 1227 | 17 |
1356507 | 1356507 | 2021-05-26 | Green | Kentucky | 21087 | 1225 | 17 |
1353261 | 1353261 | 2021-05-25 | Green | Kentucky | 21087 | 1226 | 17 |
1350015 | 1350015 | 2021-05-24 | Green | Kentucky | 21087 | 1224 | 17 |
1346768 | 1346768 | 2021-05-23 | Green | Kentucky | 21087 | 1224 | 17 |
1343520 | 1343520 | 2021-05-22 | Green | Kentucky | 21087 | 1224 | 17 |
1340272 | 1340272 | 2021-05-21 | Green | Kentucky | 21087 | 1224 | 17 |
1337025 | 1337025 | 2021-05-20 | Green | Kentucky | 21087 | 1224 | 17 |
1333778 | 1333778 | 2021-05-19 | Green | Kentucky | 21087 | 1224 | 17 |
1330531 | 1330531 | 2021-05-18 | Green | Kentucky | 21087 | 1224 | 17 |
1327284 | 1327284 | 2021-05-17 | Green | Kentucky | 21087 | 1223 | 17 |
1324038 | 1324038 | 2021-05-16 | Green | Kentucky | 21087 | 1223 | 17 |
1320792 | 1320792 | 2021-05-15 | Green | Kentucky | 21087 | 1222 | 17 |
1317545 | 1317545 | 2021-05-14 | Green | Kentucky | 21087 | 1221 | 17 |
1314298 | 1314298 | 2021-05-13 | Green | Kentucky | 21087 | 1220 | 17 |
1311051 | 1311051 | 2021-05-12 | Green | Kentucky | 21087 | 1219 | 17 |
1307805 | 1307805 | 2021-05-11 | Green | Kentucky | 21087 | 1217 | 17 |
1304559 | 1304559 | 2021-05-10 | Green | Kentucky | 21087 | 1214 | 17 |
1301312 | 1301312 | 2021-05-09 | Green | Kentucky | 21087 | 1214 | 17 |
1298065 | 1298065 | 2021-05-08 | Green | Kentucky | 21087 | 1214 | 17 |
1294819 | 1294819 | 2021-05-07 | Green | Kentucky | 21087 | 1212 | 17 |
1291573 | 1291573 | 2021-05-06 | Green | Kentucky | 21087 | 1211 | 17 |
1288327 | 1288327 | 2021-05-05 | Green | Kentucky | 21087 | 1209 | 17 |
1285081 | 1285081 | 2021-05-04 | Green | Kentucky | 21087 | 1207 | 17 |
1281834 | 1281834 | 2021-05-03 | Green | Kentucky | 21087 | 1206 | 17 |
975534 | 975534 | 2021-01-28 | Green | Wisconsin | 55045 | 2773 | 17 |
972289 | 972289 | 2021-01-27 | Green | Wisconsin | 55045 | 2756 | 17 |
969044 | 969044 | 2021-01-26 | Green | Wisconsin | 55045 | 2730 | 17 |
965800 | 965800 | 2021-01-25 | Green | Wisconsin | 55045 | 2716 | 17 |
962555 | 962555 | 2021-01-24 | Green | Wisconsin | 55045 | 2712 | 17 |
959310 | 959310 | 2021-01-23 | Green | Wisconsin | 55045 | 2705 | 17 |
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);