ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where county = "Charleston" and state = "South Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419552 | 1419552 | 2021-06-14 | Charleston | South Carolina | 45019 | 43896 | 511 |
1416307 | 1416307 | 2021-06-13 | Charleston | South Carolina | 45019 | 43881 | 511 |
1413061 | 1413061 | 2021-06-12 | Charleston | South Carolina | 45019 | 43894 | 511 |
1409816 | 1409816 | 2021-06-11 | Charleston | South Carolina | 45019 | 43894 | 511 |
1406571 | 1406571 | 2021-06-10 | Charleston | South Carolina | 45019 | 43891 | 511 |
1403325 | 1403325 | 2021-06-09 | Charleston | South Carolina | 45019 | 43886 | 511 |
1400080 | 1400080 | 2021-06-08 | Charleston | South Carolina | 45019 | 43874 | 511 |
1396835 | 1396835 | 2021-06-07 | Charleston | South Carolina | 45019 | 43861 | 511 |
1393588 | 1393588 | 2021-06-06 | Charleston | South Carolina | 45019 | 43861 | 511 |
1390343 | 1390343 | 2021-06-05 | Charleston | South Carolina | 45019 | 43858 | 511 |
1387098 | 1387098 | 2021-06-04 | Charleston | South Carolina | 45019 | 43846 | 511 |
1383853 | 1383853 | 2021-06-03 | Charleston | South Carolina | 45019 | 43833 | 511 |
1380607 | 1380607 | 2021-06-02 | Charleston | South Carolina | 45019 | 43814 | 511 |
1377362 | 1377362 | 2021-06-01 | Charleston | South Carolina | 45019 | 43802 | 510 |
1374116 | 1374116 | 2021-05-31 | Charleston | South Carolina | 45019 | 43802 | 510 |
1370871 | 1370871 | 2021-05-30 | Charleston | South Carolina | 45019 | 43790 | 509 |
1367625 | 1367625 | 2021-05-29 | Charleston | South Carolina | 45019 | 43780 | 509 |
1364379 | 1364379 | 2021-05-28 | Charleston | South Carolina | 45019 | 43757 | 509 |
1361133 | 1361133 | 2021-05-27 | Charleston | South Carolina | 45019 | 43730 | 509 |
1357887 | 1357887 | 2021-05-26 | Charleston | South Carolina | 45019 | 43701 | 509 |
1354641 | 1354641 | 2021-05-25 | Charleston | South Carolina | 45019 | 43683 | 509 |
1351395 | 1351395 | 2021-05-24 | Charleston | South Carolina | 45019 | 43674 | 508 |
1348149 | 1348149 | 2021-05-23 | Charleston | South Carolina | 45019 | 43641 | 508 |
1344901 | 1344901 | 2021-05-22 | Charleston | South Carolina | 45019 | 43630 | 508 |
1341653 | 1341653 | 2021-05-21 | Charleston | South Carolina | 45019 | 43621 | 508 |
1338405 | 1338405 | 2021-05-20 | Charleston | South Carolina | 45019 | 43583 | 508 |
1335158 | 1335158 | 2021-05-19 | Charleston | South Carolina | 45019 | 43561 | 508 |
1331911 | 1331911 | 2021-05-18 | Charleston | South Carolina | 45019 | 43532 | 507 |
1328664 | 1328664 | 2021-05-17 | Charleston | South Carolina | 45019 | 43525 | 507 |
1325418 | 1325418 | 2021-05-16 | Charleston | South Carolina | 45019 | 43507 | 507 |
1322172 | 1322172 | 2021-05-15 | Charleston | South Carolina | 45019 | 43482 | 505 |
1318926 | 1318926 | 2021-05-14 | Charleston | South Carolina | 45019 | 43236 | 505 |
1315678 | 1315678 | 2021-05-13 | Charleston | South Carolina | 45019 | 43195 | 504 |
1312432 | 1312432 | 2021-05-12 | Charleston | South Carolina | 45019 | 43168 | 504 |
1309185 | 1309185 | 2021-05-11 | Charleston | South Carolina | 45019 | 43144 | 504 |
1305939 | 1305939 | 2021-05-10 | Charleston | South Carolina | 45019 | 43130 | 504 |
1302693 | 1302693 | 2021-05-09 | Charleston | South Carolina | 45019 | 43111 | 504 |
1299446 | 1299446 | 2021-05-08 | Charleston | South Carolina | 45019 | 43072 | 503 |
1296199 | 1296199 | 2021-05-07 | Charleston | South Carolina | 45019 | 43035 | 502 |
1292953 | 1292953 | 2021-05-06 | Charleston | South Carolina | 45019 | 42994 | 501 |
1289707 | 1289707 | 2021-05-05 | Charleston | South Carolina | 45019 | 42938 | 501 |
1286461 | 1286461 | 2021-05-04 | Charleston | South Carolina | 45019 | 42905 | 501 |
1283215 | 1283215 | 2021-05-03 | Charleston | South Carolina | 45019 | 42882 | 501 |
1279968 | 1279968 | 2021-05-02 | Charleston | South Carolina | 45019 | 42841 | 501 |
1276721 | 1276721 | 2021-05-01 | Charleston | South Carolina | 45019 | 42785 | 500 |
1273474 | 1273474 | 2021-04-30 | Charleston | South Carolina | 45019 | 42727 | 500 |
1270227 | 1270227 | 2021-04-29 | Charleston | South Carolina | 45019 | 42615 | 498 |
1266980 | 1266980 | 2021-04-28 | Charleston | South Carolina | 45019 | 42564 | 496 |
1263733 | 1263733 | 2021-04-27 | Charleston | South Carolina | 45019 | 42513 | 494 |
1260486 | 1260486 | 2021-04-26 | Charleston | South Carolina | 45019 | 42473 | 494 |
1257239 | 1257239 | 2021-04-25 | Charleston | South Carolina | 45019 | 42432 | 494 |
1253992 | 1253992 | 2021-04-24 | Charleston | South Carolina | 45019 | 42348 | 493 |
1250745 | 1250745 | 2021-04-23 | Charleston | South Carolina | 45019 | 42294 | 493 |
1247498 | 1247498 | 2021-04-22 | Charleston | South Carolina | 45019 | 42233 | 491 |
1244251 | 1244251 | 2021-04-21 | Charleston | South Carolina | 45019 | 42181 | 490 |
1241004 | 1241004 | 2021-04-20 | Charleston | South Carolina | 45019 | 42123 | 489 |
1237757 | 1237757 | 2021-04-19 | Charleston | South Carolina | 45019 | 42075 | 489 |
1234510 | 1234510 | 2021-04-18 | Charleston | South Carolina | 45019 | 42004 | 489 |
1231262 | 1231262 | 2021-04-17 | Charleston | South Carolina | 45019 | 41917 | 489 |
1228014 | 1228014 | 2021-04-16 | Charleston | South Carolina | 45019 | 41849 | 489 |
1224766 | 1224766 | 2021-04-15 | Charleston | South Carolina | 45019 | 41741 | 489 |
1221519 | 1221519 | 2021-04-14 | Charleston | South Carolina | 45019 | 41647 | 489 |
1218271 | 1218271 | 2021-04-13 | Charleston | South Carolina | 45019 | 41587 | 489 |
1215023 | 1215023 | 2021-04-12 | Charleston | South Carolina | 45019 | 41540 | 489 |
1211776 | 1211776 | 2021-04-11 | Charleston | South Carolina | 45019 | 41471 | 489 |
1208527 | 1208527 | 2021-04-10 | Charleston | South Carolina | 45019 | 41390 | 489 |
1205279 | 1205279 | 2021-04-09 | Charleston | South Carolina | 45019 | 41310 | 489 |
1202031 | 1202031 | 2021-04-08 | Charleston | South Carolina | 45019 | 41231 | 489 |
1198782 | 1198782 | 2021-04-07 | Charleston | South Carolina | 45019 | 41134 | 487 |
1195533 | 1195533 | 2021-04-06 | Charleston | South Carolina | 45019 | 41076 | 484 |
1192285 | 1192285 | 2021-04-05 | Charleston | South Carolina | 45019 | 40971 | 484 |
1189036 | 1189036 | 2021-04-04 | Charleston | South Carolina | 45019 | 40891 | 484 |
1185789 | 1185789 | 2021-04-03 | Charleston | South Carolina | 45019 | 40891 | 484 |
1182542 | 1182542 | 2021-04-02 | Charleston | South Carolina | 45019 | 40800 | 484 |
1179295 | 1179295 | 2021-04-01 | Charleston | South Carolina | 45019 | 40707 | 484 |
1176048 | 1176048 | 2021-03-31 | Charleston | South Carolina | 45019 | 40599 | 480 |
1172801 | 1172801 | 2021-03-30 | Charleston | South Carolina | 45019 | 40535 | 480 |
1169554 | 1169554 | 2021-03-29 | Charleston | South Carolina | 45019 | 40504 | 478 |
1166306 | 1166306 | 2021-03-28 | Charleston | South Carolina | 45019 | 40436 | 478 |
1163058 | 1163058 | 2021-03-27 | Charleston | South Carolina | 45019 | 40370 | 477 |
1159809 | 1159809 | 2021-03-26 | Charleston | South Carolina | 45019 | 40259 | 477 |
1156562 | 1156562 | 2021-03-25 | Charleston | South Carolina | 45019 | 40172 | 477 |
1153315 | 1153315 | 2021-03-24 | Charleston | South Carolina | 45019 | 40088 | 477 |
1150068 | 1150068 | 2021-03-23 | Charleston | South Carolina | 45019 | 40025 | 475 |
1146821 | 1146821 | 2021-03-22 | Charleston | South Carolina | 45019 | 39983 | 475 |
1143574 | 1143574 | 2021-03-21 | Charleston | South Carolina | 45019 | 39929 | 475 |
1140327 | 1140327 | 2021-03-20 | Charleston | South Carolina | 45019 | 39837 | 475 |
1137081 | 1137081 | 2021-03-19 | Charleston | South Carolina | 45019 | 39695 | 475 |
1133835 | 1133835 | 2021-03-18 | Charleston | South Carolina | 45019 | 39601 | 470 |
1130587 | 1130587 | 2021-03-17 | Charleston | South Carolina | 45019 | 39463 | 469 |
1127340 | 1127340 | 2021-03-16 | Charleston | South Carolina | 45019 | 39379 | 466 |
1124094 | 1124094 | 2021-03-15 | Charleston | South Carolina | 45019 | 39317 | 466 |
1120848 | 1120848 | 2021-03-14 | Charleston | South Carolina | 45019 | 39244 | 466 |
1117601 | 1117601 | 2021-03-13 | Charleston | South Carolina | 45019 | 39165 | 466 |
1114354 | 1114354 | 2021-03-12 | Charleston | South Carolina | 45019 | 39069 | 465 |
1111108 | 1111108 | 2021-03-11 | Charleston | South Carolina | 45019 | 38977 | 465 |
1107862 | 1107862 | 2021-03-10 | Charleston | South Carolina | 45019 | 38914 | 461 |
1104616 | 1104616 | 2021-03-09 | Charleston | South Carolina | 45019 | 38857 | 460 |
1101370 | 1101370 | 2021-03-08 | Charleston | South Carolina | 45019 | 38794 | 460 |
1098124 | 1098124 | 2021-03-07 | Charleston | South Carolina | 45019 | 38724 | 460 |
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);