ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 45091 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 |
---|---|---|---|---|---|---|---|
1419588 | 1419588 | 2021-06-14 | York | South Carolina | 45091 | 31961 | 391 |
1416343 | 1416343 | 2021-06-13 | York | South Carolina | 45091 | 31940 | 391 |
1413097 | 1413097 | 2021-06-12 | York | South Carolina | 45091 | 31937 | 391 |
1409852 | 1409852 | 2021-06-11 | York | South Carolina | 45091 | 31937 | 391 |
1406607 | 1406607 | 2021-06-10 | York | South Carolina | 45091 | 31921 | 389 |
1403361 | 1403361 | 2021-06-09 | York | South Carolina | 45091 | 31944 | 389 |
1400116 | 1400116 | 2021-06-08 | York | South Carolina | 45091 | 31928 | 387 |
1396871 | 1396871 | 2021-06-07 | York | South Carolina | 45091 | 31919 | 387 |
1393624 | 1393624 | 2021-06-06 | York | South Carolina | 45091 | 31916 | 387 |
1390379 | 1390379 | 2021-06-05 | York | South Carolina | 45091 | 31916 | 387 |
1387134 | 1387134 | 2021-06-04 | York | South Carolina | 45091 | 31903 | 387 |
1383889 | 1383889 | 2021-06-03 | York | South Carolina | 45091 | 31910 | 386 |
1380643 | 1380643 | 2021-06-02 | York | South Carolina | 45091 | 31909 | 385 |
1377398 | 1377398 | 2021-06-01 | York | South Carolina | 45091 | 31880 | 385 |
1374152 | 1374152 | 2021-05-31 | York | South Carolina | 45091 | 31880 | 385 |
1370907 | 1370907 | 2021-05-30 | York | South Carolina | 45091 | 31858 | 385 |
1367661 | 1367661 | 2021-05-29 | York | South Carolina | 45091 | 31844 | 385 |
1364415 | 1364415 | 2021-05-28 | York | South Carolina | 45091 | 31824 | 385 |
1361169 | 1361169 | 2021-05-27 | York | South Carolina | 45091 | 31770 | 385 |
1357923 | 1357923 | 2021-05-26 | York | South Carolina | 45091 | 31736 | 385 |
1354677 | 1354677 | 2021-05-25 | York | South Carolina | 45091 | 31710 | 385 |
1351431 | 1351431 | 2021-05-24 | York | South Carolina | 45091 | 31693 | 384 |
1348185 | 1348185 | 2021-05-23 | York | South Carolina | 45091 | 31669 | 384 |
1344937 | 1344937 | 2021-05-22 | York | South Carolina | 45091 | 31629 | 384 |
1341689 | 1341689 | 2021-05-21 | York | South Carolina | 45091 | 31589 | 383 |
1338441 | 1338441 | 2021-05-20 | York | South Carolina | 45091 | 31538 | 383 |
1335194 | 1335194 | 2021-05-19 | York | South Carolina | 45091 | 31502 | 383 |
1331947 | 1331947 | 2021-05-18 | York | South Carolina | 45091 | 31455 | 383 |
1328700 | 1328700 | 2021-05-17 | York | South Carolina | 45091 | 31438 | 383 |
1325454 | 1325454 | 2021-05-16 | York | South Carolina | 45091 | 31409 | 383 |
1322208 | 1322208 | 2021-05-15 | York | South Carolina | 45091 | 31381 | 383 |
1318962 | 1318962 | 2021-05-14 | York | South Carolina | 45091 | 31289 | 383 |
1315714 | 1315714 | 2021-05-13 | York | South Carolina | 45091 | 31247 | 383 |
1312468 | 1312468 | 2021-05-12 | York | South Carolina | 45091 | 31219 | 380 |
1309221 | 1309221 | 2021-05-11 | York | South Carolina | 45091 | 31197 | 380 |
1305975 | 1305975 | 2021-05-10 | York | South Carolina | 45091 | 31166 | 380 |
1302729 | 1302729 | 2021-05-09 | York | South Carolina | 45091 | 31141 | 379 |
1299482 | 1299482 | 2021-05-08 | York | South Carolina | 45091 | 31099 | 378 |
1296235 | 1296235 | 2021-05-07 | York | South Carolina | 45091 | 31039 | 378 |
1292989 | 1292989 | 2021-05-06 | York | South Carolina | 45091 | 30980 | 378 |
1289743 | 1289743 | 2021-05-05 | York | South Carolina | 45091 | 30927 | 378 |
1286497 | 1286497 | 2021-05-04 | York | South Carolina | 45091 | 30862 | 377 |
1283251 | 1283251 | 2021-05-03 | York | South Carolina | 45091 | 30823 | 377 |
1280004 | 1280004 | 2021-05-02 | York | South Carolina | 45091 | 30774 | 377 |
1276757 | 1276757 | 2021-05-01 | York | South Carolina | 45091 | 30720 | 377 |
1273510 | 1273510 | 2021-04-30 | York | South Carolina | 45091 | 30574 | 377 |
1270263 | 1270263 | 2021-04-29 | York | South Carolina | 45091 | 30497 | 377 |
1267016 | 1267016 | 2021-04-28 | York | South Carolina | 45091 | 30445 | 376 |
1263769 | 1263769 | 2021-04-27 | York | South Carolina | 45091 | 30411 | 372 |
1260522 | 1260522 | 2021-04-26 | York | South Carolina | 45091 | 30373 | 372 |
1257275 | 1257275 | 2021-04-25 | York | South Carolina | 45091 | 30329 | 372 |
1254028 | 1254028 | 2021-04-24 | York | South Carolina | 45091 | 30273 | 371 |
1250781 | 1250781 | 2021-04-23 | York | South Carolina | 45091 | 30101 | 371 |
1247534 | 1247534 | 2021-04-22 | York | South Carolina | 45091 | 30035 | 370 |
1244287 | 1244287 | 2021-04-21 | York | South Carolina | 45091 | 29991 | 370 |
1241040 | 1241040 | 2021-04-20 | York | South Carolina | 45091 | 29929 | 370 |
1237793 | 1237793 | 2021-04-19 | York | South Carolina | 45091 | 29879 | 370 |
1234546 | 1234546 | 2021-04-18 | York | South Carolina | 45091 | 29827 | 370 |
1231298 | 1231298 | 2021-04-17 | York | South Carolina | 45091 | 29769 | 369 |
1228050 | 1228050 | 2021-04-16 | York | South Carolina | 45091 | 29678 | 369 |
1224802 | 1224802 | 2021-04-15 | York | South Carolina | 45091 | 29570 | 369 |
1221555 | 1221555 | 2021-04-14 | York | South Carolina | 45091 | 29501 | 369 |
1218307 | 1218307 | 2021-04-13 | York | South Carolina | 45091 | 29422 | 369 |
1215059 | 1215059 | 2021-04-12 | York | South Carolina | 45091 | 29361 | 369 |
1211812 | 1211812 | 2021-04-11 | York | South Carolina | 45091 | 29318 | 369 |
1208563 | 1208563 | 2021-04-10 | York | South Carolina | 45091 | 29258 | 369 |
1205315 | 1205315 | 2021-04-09 | York | South Carolina | 45091 | 29213 | 368 |
1202067 | 1202067 | 2021-04-08 | York | South Carolina | 45091 | 29127 | 367 |
1198818 | 1198818 | 2021-04-07 | York | South Carolina | 45091 | 29065 | 364 |
1195569 | 1195569 | 2021-04-06 | York | South Carolina | 45091 | 29018 | 364 |
1192321 | 1192321 | 2021-04-05 | York | South Carolina | 45091 | 28924 | 364 |
1189072 | 1189072 | 2021-04-04 | York | South Carolina | 45091 | 28832 | 364 |
1185825 | 1185825 | 2021-04-03 | York | South Carolina | 45091 | 28832 | 364 |
1182578 | 1182578 | 2021-04-02 | York | South Carolina | 45091 | 28765 | 364 |
1179331 | 1179331 | 2021-04-01 | York | South Carolina | 45091 | 28694 | 363 |
1176084 | 1176084 | 2021-03-31 | York | South Carolina | 45091 | 28620 | 363 |
1172837 | 1172837 | 2021-03-30 | York | South Carolina | 45091 | 28550 | 358 |
1169590 | 1169590 | 2021-03-29 | York | South Carolina | 45091 | 28509 | 358 |
1166342 | 1166342 | 2021-03-28 | York | South Carolina | 45091 | 28450 | 358 |
1163094 | 1163094 | 2021-03-27 | York | South Carolina | 45091 | 28408 | 357 |
1159845 | 1159845 | 2021-03-26 | York | South Carolina | 45091 | 28331 | 357 |
1156598 | 1156598 | 2021-03-25 | York | South Carolina | 45091 | 28282 | 357 |
1153351 | 1153351 | 2021-03-24 | York | South Carolina | 45091 | 28212 | 356 |
1150104 | 1150104 | 2021-03-23 | York | South Carolina | 45091 | 28163 | 348 |
1146857 | 1146857 | 2021-03-22 | York | South Carolina | 45091 | 28106 | 348 |
1143610 | 1143610 | 2021-03-21 | York | South Carolina | 45091 | 28061 | 348 |
1140363 | 1140363 | 2021-03-20 | York | South Carolina | 45091 | 27995 | 347 |
1137117 | 1137117 | 2021-03-19 | York | South Carolina | 45091 | 27903 | 347 |
1133871 | 1133871 | 2021-03-18 | York | South Carolina | 45091 | 27838 | 345 |
1130623 | 1130623 | 2021-03-17 | York | South Carolina | 45091 | 27745 | 344 |
1127376 | 1127376 | 2021-03-16 | York | South Carolina | 45091 | 27676 | 341 |
1124130 | 1124130 | 2021-03-15 | York | South Carolina | 45091 | 27637 | 341 |
1120884 | 1120884 | 2021-03-14 | York | South Carolina | 45091 | 27559 | 341 |
1117637 | 1117637 | 2021-03-13 | York | South Carolina | 45091 | 27535 | 341 |
1114390 | 1114390 | 2021-03-12 | York | South Carolina | 45091 | 27382 | 341 |
1111144 | 1111144 | 2021-03-11 | York | South Carolina | 45091 | 27265 | 341 |
1107898 | 1107898 | 2021-03-10 | York | South Carolina | 45091 | 27238 | 341 |
1104652 | 1104652 | 2021-03-09 | York | South Carolina | 45091 | 27158 | 340 |
1101406 | 1101406 | 2021-03-08 | York | South Carolina | 45091 | 27120 | 340 |
1098160 | 1098160 | 2021-03-07 | York | South Carolina | 45091 | 27073 | 340 |
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);