ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 45025 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 |
---|---|---|---|---|---|---|---|
1419555 | 1419555 | 2021-06-14 | Chesterfield | South Carolina | 45025 | 4910 | 107 |
1416310 | 1416310 | 2021-06-13 | Chesterfield | South Carolina | 45025 | 4907 | 107 |
1413064 | 1413064 | 2021-06-12 | Chesterfield | South Carolina | 45025 | 4903 | 106 |
1409819 | 1409819 | 2021-06-11 | Chesterfield | South Carolina | 45025 | 4903 | 106 |
1406574 | 1406574 | 2021-06-10 | Chesterfield | South Carolina | 45025 | 4903 | 106 |
1403328 | 1403328 | 2021-06-09 | Chesterfield | South Carolina | 45025 | 4904 | 106 |
1400083 | 1400083 | 2021-06-08 | Chesterfield | South Carolina | 45025 | 4902 | 106 |
1396838 | 1396838 | 2021-06-07 | Chesterfield | South Carolina | 45025 | 4901 | 106 |
1393591 | 1393591 | 2021-06-06 | Chesterfield | South Carolina | 45025 | 4900 | 106 |
1390346 | 1390346 | 2021-06-05 | Chesterfield | South Carolina | 45025 | 4896 | 106 |
1387101 | 1387101 | 2021-06-04 | Chesterfield | South Carolina | 45025 | 4893 | 105 |
1383856 | 1383856 | 2021-06-03 | Chesterfield | South Carolina | 45025 | 4888 | 105 |
1380610 | 1380610 | 2021-06-02 | Chesterfield | South Carolina | 45025 | 4887 | 105 |
1377365 | 1377365 | 2021-06-01 | Chesterfield | South Carolina | 45025 | 4887 | 105 |
1374119 | 1374119 | 2021-05-31 | Chesterfield | South Carolina | 45025 | 4887 | 105 |
1370874 | 1370874 | 2021-05-30 | Chesterfield | South Carolina | 45025 | 4885 | 105 |
1367628 | 1367628 | 2021-05-29 | Chesterfield | South Carolina | 45025 | 4885 | 105 |
1364382 | 1364382 | 2021-05-28 | Chesterfield | South Carolina | 45025 | 4887 | 105 |
1361136 | 1361136 | 2021-05-27 | Chesterfield | South Carolina | 45025 | 4880 | 105 |
1357890 | 1357890 | 2021-05-26 | Chesterfield | South Carolina | 45025 | 4875 | 105 |
1354644 | 1354644 | 2021-05-25 | Chesterfield | South Carolina | 45025 | 4869 | 105 |
1351398 | 1351398 | 2021-05-24 | Chesterfield | South Carolina | 45025 | 4867 | 105 |
1348152 | 1348152 | 2021-05-23 | Chesterfield | South Carolina | 45025 | 4863 | 105 |
1344904 | 1344904 | 2021-05-22 | Chesterfield | South Carolina | 45025 | 4859 | 105 |
1341656 | 1341656 | 2021-05-21 | Chesterfield | South Carolina | 45025 | 4853 | 105 |
1338408 | 1338408 | 2021-05-20 | Chesterfield | South Carolina | 45025 | 4840 | 105 |
1335161 | 1335161 | 2021-05-19 | Chesterfield | South Carolina | 45025 | 4833 | 105 |
1331914 | 1331914 | 2021-05-18 | Chesterfield | South Carolina | 45025 | 4832 | 104 |
1328667 | 1328667 | 2021-05-17 | Chesterfield | South Carolina | 45025 | 4831 | 104 |
1325421 | 1325421 | 2021-05-16 | Chesterfield | South Carolina | 45025 | 4829 | 104 |
1322175 | 1322175 | 2021-05-15 | Chesterfield | South Carolina | 45025 | 4824 | 104 |
1318929 | 1318929 | 2021-05-14 | Chesterfield | South Carolina | 45025 | 4814 | 104 |
1315681 | 1315681 | 2021-05-13 | Chesterfield | South Carolina | 45025 | 4811 | 104 |
1312435 | 1312435 | 2021-05-12 | Chesterfield | South Carolina | 45025 | 4804 | 104 |
1309188 | 1309188 | 2021-05-11 | Chesterfield | South Carolina | 45025 | 4796 | 104 |
1305942 | 1305942 | 2021-05-10 | Chesterfield | South Carolina | 45025 | 4796 | 104 |
1302696 | 1302696 | 2021-05-09 | Chesterfield | South Carolina | 45025 | 4796 | 104 |
1299449 | 1299449 | 2021-05-08 | Chesterfield | South Carolina | 45025 | 4798 | 104 |
1296202 | 1296202 | 2021-05-07 | Chesterfield | South Carolina | 45025 | 4795 | 103 |
1292956 | 1292956 | 2021-05-06 | Chesterfield | South Carolina | 45025 | 4785 | 103 |
1289710 | 1289710 | 2021-05-05 | Chesterfield | South Carolina | 45025 | 4780 | 103 |
1286464 | 1286464 | 2021-05-04 | Chesterfield | South Carolina | 45025 | 4774 | 103 |
1283218 | 1283218 | 2021-05-03 | Chesterfield | South Carolina | 45025 | 4774 | 103 |
1279971 | 1279971 | 2021-05-02 | Chesterfield | South Carolina | 45025 | 4765 | 103 |
1276724 | 1276724 | 2021-05-01 | Chesterfield | South Carolina | 45025 | 4756 | 103 |
1273477 | 1273477 | 2021-04-30 | Chesterfield | South Carolina | 45025 | 4744 | 103 |
1270230 | 1270230 | 2021-04-29 | Chesterfield | South Carolina | 45025 | 4740 | 103 |
1266983 | 1266983 | 2021-04-28 | Chesterfield | South Carolina | 45025 | 4731 | 103 |
1263736 | 1263736 | 2021-04-27 | Chesterfield | South Carolina | 45025 | 4720 | 103 |
1260489 | 1260489 | 2021-04-26 | Chesterfield | South Carolina | 45025 | 4717 | 103 |
1257242 | 1257242 | 2021-04-25 | Chesterfield | South Carolina | 45025 | 4713 | 103 |
1253995 | 1253995 | 2021-04-24 | Chesterfield | South Carolina | 45025 | 4702 | 103 |
1250748 | 1250748 | 2021-04-23 | Chesterfield | South Carolina | 45025 | 4692 | 103 |
1247501 | 1247501 | 2021-04-22 | Chesterfield | South Carolina | 45025 | 4684 | 103 |
1244254 | 1244254 | 2021-04-21 | Chesterfield | South Carolina | 45025 | 4677 | 103 |
1241007 | 1241007 | 2021-04-20 | Chesterfield | South Carolina | 45025 | 4670 | 103 |
1237760 | 1237760 | 2021-04-19 | Chesterfield | South Carolina | 45025 | 4667 | 103 |
1234513 | 1234513 | 2021-04-18 | Chesterfield | South Carolina | 45025 | 4667 | 103 |
1231265 | 1231265 | 2021-04-17 | Chesterfield | South Carolina | 45025 | 4657 | 102 |
1228017 | 1228017 | 2021-04-16 | Chesterfield | South Carolina | 45025 | 4649 | 102 |
1224769 | 1224769 | 2021-04-15 | Chesterfield | South Carolina | 45025 | 4642 | 102 |
1221522 | 1221522 | 2021-04-14 | Chesterfield | South Carolina | 45025 | 4635 | 101 |
1218274 | 1218274 | 2021-04-13 | Chesterfield | South Carolina | 45025 | 4627 | 101 |
1215026 | 1215026 | 2021-04-12 | Chesterfield | South Carolina | 45025 | 4621 | 101 |
1211779 | 1211779 | 2021-04-11 | Chesterfield | South Carolina | 45025 | 4615 | 101 |
1208530 | 1208530 | 2021-04-10 | Chesterfield | South Carolina | 45025 | 4610 | 101 |
1205282 | 1205282 | 2021-04-09 | Chesterfield | South Carolina | 45025 | 4608 | 100 |
1202034 | 1202034 | 2021-04-08 | Chesterfield | South Carolina | 45025 | 4603 | 100 |
1198785 | 1198785 | 2021-04-07 | Chesterfield | South Carolina | 45025 | 4600 | 99 |
1195536 | 1195536 | 2021-04-06 | Chesterfield | South Carolina | 45025 | 4598 | 98 |
1192288 | 1192288 | 2021-04-05 | Chesterfield | South Carolina | 45025 | 4594 | 98 |
1189039 | 1189039 | 2021-04-04 | Chesterfield | South Carolina | 45025 | 4594 | 98 |
1185792 | 1185792 | 2021-04-03 | Chesterfield | South Carolina | 45025 | 4594 | 98 |
1182545 | 1182545 | 2021-04-02 | Chesterfield | South Carolina | 45025 | 4583 | 98 |
1179298 | 1179298 | 2021-04-01 | Chesterfield | South Carolina | 45025 | 4579 | 98 |
1176051 | 1176051 | 2021-03-31 | Chesterfield | South Carolina | 45025 | 4569 | 98 |
1172804 | 1172804 | 2021-03-30 | Chesterfield | South Carolina | 45025 | 4562 | 98 |
1169557 | 1169557 | 2021-03-29 | Chesterfield | South Carolina | 45025 | 4557 | 98 |
1166309 | 1166309 | 2021-03-28 | Chesterfield | South Carolina | 45025 | 4554 | 98 |
1163061 | 1163061 | 2021-03-27 | Chesterfield | South Carolina | 45025 | 4553 | 98 |
1159812 | 1159812 | 2021-03-26 | Chesterfield | South Carolina | 45025 | 4548 | 98 |
1156565 | 1156565 | 2021-03-25 | Chesterfield | South Carolina | 45025 | 4533 | 98 |
1153318 | 1153318 | 2021-03-24 | Chesterfield | South Carolina | 45025 | 4521 | 99 |
1150071 | 1150071 | 2021-03-23 | Chesterfield | South Carolina | 45025 | 4511 | 99 |
1146824 | 1146824 | 2021-03-22 | Chesterfield | South Carolina | 45025 | 4508 | 99 |
1143577 | 1143577 | 2021-03-21 | Chesterfield | South Carolina | 45025 | 4500 | 99 |
1140330 | 1140330 | 2021-03-20 | Chesterfield | South Carolina | 45025 | 4479 | 99 |
1137084 | 1137084 | 2021-03-19 | Chesterfield | South Carolina | 45025 | 4462 | 99 |
1133838 | 1133838 | 2021-03-18 | Chesterfield | South Carolina | 45025 | 4446 | 99 |
1130590 | 1130590 | 2021-03-17 | Chesterfield | South Carolina | 45025 | 4426 | 99 |
1127343 | 1127343 | 2021-03-16 | Chesterfield | South Carolina | 45025 | 4421 | 99 |
1124097 | 1124097 | 2021-03-15 | Chesterfield | South Carolina | 45025 | 4414 | 98 |
1120851 | 1120851 | 2021-03-14 | Chesterfield | South Carolina | 45025 | 4405 | 98 |
1117604 | 1117604 | 2021-03-13 | Chesterfield | South Carolina | 45025 | 4395 | 98 |
1114357 | 1114357 | 2021-03-12 | Chesterfield | South Carolina | 45025 | 4381 | 98 |
1111111 | 1111111 | 2021-03-11 | Chesterfield | South Carolina | 45025 | 4369 | 98 |
1107865 | 1107865 | 2021-03-10 | Chesterfield | South Carolina | 45025 | 4361 | 98 |
1104619 | 1104619 | 2021-03-09 | Chesterfield | South Carolina | 45025 | 4354 | 98 |
1101373 | 1101373 | 2021-03-08 | Chesterfield | South Carolina | 45025 | 4346 | 98 |
1098127 | 1098127 | 2021-03-07 | Chesterfield | South Carolina | 45025 | 4341 | 98 |
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);