ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
68 rows where county = "Chester", deaths = 76 and state = "South Carolina" 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 |
---|---|---|---|---|---|---|---|
1520182 | 1520182 | 2021-07-15 | Chester | South Carolina | 45023 | 4299 | 76 |
1516934 | 1516934 | 2021-07-14 | Chester | South Carolina | 45023 | 4295 | 76 |
1513687 | 1513687 | 2021-07-13 | Chester | South Carolina | 45023 | 4293 | 76 |
1510441 | 1510441 | 2021-07-12 | Chester | South Carolina | 45023 | 4291 | 76 |
1507194 | 1507194 | 2021-07-11 | Chester | South Carolina | 45023 | 4278 | 76 |
1503948 | 1503948 | 2021-07-10 | Chester | South Carolina | 45023 | 4278 | 76 |
1500702 | 1500702 | 2021-07-09 | Chester | South Carolina | 45023 | 4278 | 76 |
1497456 | 1497456 | 2021-07-08 | Chester | South Carolina | 45023 | 4274 | 76 |
1494209 | 1494209 | 2021-07-07 | Chester | South Carolina | 45023 | 4273 | 76 |
1490962 | 1490962 | 2021-07-06 | Chester | South Carolina | 45023 | 4272 | 76 |
1487715 | 1487715 | 2021-07-05 | Chester | South Carolina | 45023 | 4271 | 76 |
1484468 | 1484468 | 2021-07-04 | Chester | South Carolina | 45023 | 4266 | 76 |
1481222 | 1481222 | 2021-07-03 | Chester | South Carolina | 45023 | 4266 | 76 |
1477975 | 1477975 | 2021-07-02 | Chester | South Carolina | 45023 | 4266 | 76 |
1474729 | 1474729 | 2021-07-01 | Chester | South Carolina | 45023 | 4267 | 76 |
1471483 | 1471483 | 2021-06-30 | Chester | South Carolina | 45023 | 4267 | 76 |
1468238 | 1468238 | 2021-06-29 | Chester | South Carolina | 45023 | 4268 | 76 |
1464993 | 1464993 | 2021-06-28 | Chester | South Carolina | 45023 | 4268 | 76 |
1461748 | 1461748 | 2021-06-27 | Chester | South Carolina | 45023 | 4264 | 76 |
1458503 | 1458503 | 2021-06-26 | Chester | South Carolina | 45023 | 4264 | 76 |
1455258 | 1455258 | 2021-06-25 | Chester | South Carolina | 45023 | 4264 | 76 |
1452013 | 1452013 | 2021-06-24 | Chester | South Carolina | 45023 | 4265 | 76 |
1448767 | 1448767 | 2021-06-23 | Chester | South Carolina | 45023 | 4267 | 76 |
1445522 | 1445522 | 2021-06-22 | Chester | South Carolina | 45023 | 4268 | 76 |
1442277 | 1442277 | 2021-06-21 | Chester | South Carolina | 45023 | 4268 | 76 |
1439032 | 1439032 | 2021-06-20 | Chester | South Carolina | 45023 | 4268 | 76 |
1435785 | 1435785 | 2021-06-19 | Chester | South Carolina | 45023 | 4268 | 76 |
1432538 | 1432538 | 2021-06-18 | Chester | South Carolina | 45023 | 4268 | 76 |
1429292 | 1429292 | 2021-06-17 | Chester | South Carolina | 45023 | 4272 | 76 |
1426047 | 1426047 | 2021-06-16 | Chester | South Carolina | 45023 | 4274 | 76 |
1422800 | 1422800 | 2021-06-15 | Chester | South Carolina | 45023 | 4279 | 76 |
1419554 | 1419554 | 2021-06-14 | Chester | South Carolina | 45023 | 4279 | 76 |
1416309 | 1416309 | 2021-06-13 | Chester | South Carolina | 45023 | 4274 | 76 |
1413063 | 1413063 | 2021-06-12 | Chester | South Carolina | 45023 | 4275 | 76 |
1409818 | 1409818 | 2021-06-11 | Chester | South Carolina | 45023 | 4275 | 76 |
1406573 | 1406573 | 2021-06-10 | Chester | South Carolina | 45023 | 4276 | 76 |
1403327 | 1403327 | 2021-06-09 | Chester | South Carolina | 45023 | 4275 | 76 |
1400082 | 1400082 | 2021-06-08 | Chester | South Carolina | 45023 | 4264 | 76 |
1396837 | 1396837 | 2021-06-07 | Chester | South Carolina | 45023 | 4262 | 76 |
1393590 | 1393590 | 2021-06-06 | Chester | South Carolina | 45023 | 4264 | 76 |
1390345 | 1390345 | 2021-06-05 | Chester | South Carolina | 45023 | 4265 | 76 |
1387100 | 1387100 | 2021-06-04 | Chester | South Carolina | 45023 | 4267 | 76 |
1383855 | 1383855 | 2021-06-03 | Chester | South Carolina | 45023 | 4269 | 76 |
1380609 | 1380609 | 2021-06-02 | Chester | South Carolina | 45023 | 4264 | 76 |
1377364 | 1377364 | 2021-06-01 | Chester | South Carolina | 45023 | 4264 | 76 |
1374118 | 1374118 | 2021-05-31 | Chester | South Carolina | 45023 | 4264 | 76 |
1370873 | 1370873 | 2021-05-30 | Chester | South Carolina | 45023 | 4261 | 76 |
1367627 | 1367627 | 2021-05-29 | Chester | South Carolina | 45023 | 4258 | 76 |
1364381 | 1364381 | 2021-05-28 | Chester | South Carolina | 45023 | 4260 | 76 |
1361135 | 1361135 | 2021-05-27 | Chester | South Carolina | 45023 | 4253 | 76 |
1357889 | 1357889 | 2021-05-26 | Chester | South Carolina | 45023 | 4250 | 76 |
1354643 | 1354643 | 2021-05-25 | Chester | South Carolina | 45023 | 4245 | 76 |
1351397 | 1351397 | 2021-05-24 | Chester | South Carolina | 45023 | 4245 | 76 |
1348151 | 1348151 | 2021-05-23 | Chester | South Carolina | 45023 | 4244 | 76 |
1344903 | 1344903 | 2021-05-22 | Chester | South Carolina | 45023 | 4233 | 76 |
1341655 | 1341655 | 2021-05-21 | Chester | South Carolina | 45023 | 4230 | 76 |
1338407 | 1338407 | 2021-05-20 | Chester | South Carolina | 45023 | 4225 | 76 |
1335160 | 1335160 | 2021-05-19 | Chester | South Carolina | 45023 | 4220 | 76 |
1331913 | 1331913 | 2021-05-18 | Chester | South Carolina | 45023 | 4216 | 76 |
1328666 | 1328666 | 2021-05-17 | Chester | South Carolina | 45023 | 4216 | 76 |
1325420 | 1325420 | 2021-05-16 | Chester | South Carolina | 45023 | 4215 | 76 |
1322174 | 1322174 | 2021-05-15 | Chester | South Carolina | 45023 | 4210 | 76 |
1318928 | 1318928 | 2021-05-14 | Chester | South Carolina | 45023 | 4200 | 76 |
1315680 | 1315680 | 2021-05-13 | Chester | South Carolina | 45023 | 4200 | 76 |
1312434 | 1312434 | 2021-05-12 | Chester | South Carolina | 45023 | 4196 | 76 |
1309187 | 1309187 | 2021-05-11 | Chester | South Carolina | 45023 | 4192 | 76 |
1305941 | 1305941 | 2021-05-10 | Chester | South Carolina | 45023 | 4191 | 76 |
1302695 | 1302695 | 2021-05-09 | Chester | South Carolina | 45023 | 4186 | 76 |
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);