ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
156 rows where deaths = 42 and state = "South Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Colleton 26
- Abbeville 21
- Edgefield 16
- Clarendon 10
- Lee 8
- Bamberg 6
- Hampton 6
- Lexington 6
- Marlboro 6
- Kershaw 5
- Barnwell 4
- Chesterfield 4
- Greenville 4
- Horry 4
- Fairfield 3
- Lancaster 3
- Saluda 3
- Aiken 2
- Oconee 2
- Pickens 2
- Sumter 2
- Williamsburg 2
- Cherokee 1
- Chester 1
- Darlington 1
- Florence 1
- Georgetown 1
- Jasper 1
- Laurens 1
- Orangeburg 1
- …
state 1
- South Carolina · 156 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1689077 | 1689077 | 2021-09-05 | Abbeville | South Carolina | 45001 | 3068 | 42 |
1685827 | 1685827 | 2021-09-04 | Abbeville | South Carolina | 45001 | 3068 | 42 |
1682576 | 1682576 | 2021-09-03 | Abbeville | South Carolina | 45001 | 3068 | 42 |
1679326 | 1679326 | 2021-09-02 | Abbeville | South Carolina | 45001 | 3041 | 42 |
1676078 | 1676078 | 2021-09-01 | Abbeville | South Carolina | 45001 | 3019 | 42 |
1672831 | 1672831 | 2021-08-31 | Abbeville | South Carolina | 45001 | 3010 | 42 |
1669583 | 1669583 | 2021-08-30 | Abbeville | South Carolina | 45001 | 2977 | 42 |
1666336 | 1666336 | 2021-08-29 | Abbeville | South Carolina | 45001 | 2918 | 42 |
1663088 | 1663088 | 2021-08-28 | Abbeville | South Carolina | 45001 | 2918 | 42 |
1659840 | 1659840 | 2021-08-27 | Abbeville | South Carolina | 45001 | 2918 | 42 |
1656591 | 1656591 | 2021-08-26 | Abbeville | South Carolina | 45001 | 2896 | 42 |
1653344 | 1653344 | 2021-08-25 | Abbeville | South Carolina | 45001 | 2874 | 42 |
1650097 | 1650097 | 2021-08-24 | Abbeville | South Carolina | 45001 | 2866 | 42 |
1646848 | 1646848 | 2021-08-23 | Abbeville | South Carolina | 45001 | 2857 | 42 |
1643599 | 1643599 | 2021-08-22 | Abbeville | South Carolina | 45001 | 2809 | 42 |
1640349 | 1640349 | 2021-08-21 | Abbeville | South Carolina | 45001 | 2809 | 42 |
1637099 | 1637099 | 2021-08-20 | Abbeville | South Carolina | 45001 | 2809 | 42 |
1633849 | 1633849 | 2021-08-19 | Abbeville | South Carolina | 45001 | 2793 | 42 |
1630602 | 1630602 | 2021-08-18 | Abbeville | South Carolina | 45001 | 2783 | 42 |
1627355 | 1627355 | 2021-08-17 | Abbeville | South Carolina | 45001 | 2777 | 42 |
1624108 | 1624108 | 2021-08-16 | Abbeville | South Carolina | 45001 | 2770 | 42 |
1406580 | 1406580 | 2021-06-10 | Edgefield | South Carolina | 45037 | 3167 | 42 |
1403334 | 1403334 | 2021-06-09 | Edgefield | South Carolina | 45037 | 3166 | 42 |
1400089 | 1400089 | 2021-06-08 | Edgefield | South Carolina | 45037 | 3165 | 42 |
1396844 | 1396844 | 2021-06-07 | Edgefield | South Carolina | 45037 | 3163 | 42 |
1393597 | 1393597 | 2021-06-06 | Edgefield | South Carolina | 45037 | 3163 | 42 |
1390352 | 1390352 | 2021-06-05 | Edgefield | South Carolina | 45037 | 3163 | 42 |
1296208 | 1296208 | 2021-05-07 | Edgefield | South Carolina | 45037 | 3124 | 42 |
1292962 | 1292962 | 2021-05-06 | Edgefield | South Carolina | 45037 | 3121 | 42 |
1289716 | 1289716 | 2021-05-05 | Edgefield | South Carolina | 45037 | 3114 | 42 |
1286470 | 1286470 | 2021-05-04 | Edgefield | South Carolina | 45037 | 3101 | 42 |
1283224 | 1283224 | 2021-05-03 | Edgefield | South Carolina | 45037 | 3101 | 42 |
1279977 | 1279977 | 2021-05-02 | Edgefield | South Carolina | 45037 | 3101 | 42 |
1276730 | 1276730 | 2021-05-01 | Edgefield | South Carolina | 45037 | 3099 | 42 |
1273483 | 1273483 | 2021-04-30 | Edgefield | South Carolina | 45037 | 3092 | 42 |
1270236 | 1270236 | 2021-04-29 | Edgefield | South Carolina | 45037 | 3081 | 42 |
1266989 | 1266989 | 2021-04-28 | Edgefield | South Carolina | 45037 | 3080 | 42 |
1081910 | 1081910 | 2021-03-02 | Jasper | South Carolina | 45053 | 2147 | 42 |
1062435 | 1062435 | 2021-02-24 | Hampton | South Carolina | 45049 | 1654 | 42 |
1059190 | 1059190 | 2021-02-23 | Hampton | South Carolina | 45049 | 1649 | 42 |
1055944 | 1055944 | 2021-02-22 | Hampton | South Carolina | 45049 | 1649 | 42 |
1052698 | 1052698 | 2021-02-21 | Hampton | South Carolina | 45049 | 1646 | 42 |
1049451 | 1049451 | 2021-02-20 | Hampton | South Carolina | 45049 | 1632 | 42 |
1046204 | 1046204 | 2021-02-19 | Hampton | South Carolina | 45049 | 1624 | 42 |
1039730 | 1039730 | 2021-02-17 | Saluda | South Carolina | 45081 | 1528 | 42 |
1036485 | 1036485 | 2021-02-16 | Saluda | South Carolina | 45081 | 1526 | 42 |
1033240 | 1033240 | 2021-02-15 | Saluda | South Carolina | 45081 | 1519 | 42 |
991039 | 991039 | 2021-02-02 | Marlboro | South Carolina | 45069 | 2652 | 42 |
987793 | 987793 | 2021-02-01 | Marlboro | South Carolina | 45069 | 2646 | 42 |
984518 | 984518 | 2021-01-31 | Barnwell | South Carolina | 45011 | 2063 | 42 |
984546 | 984546 | 2021-01-31 | Marlboro | South Carolina | 45069 | 2636 | 42 |
981270 | 981270 | 2021-01-30 | Bamberg | South Carolina | 45009 | 1241 | 42 |
981271 | 981271 | 2021-01-30 | Barnwell | South Carolina | 45011 | 2046 | 42 |
981299 | 981299 | 2021-01-30 | Marlboro | South Carolina | 45069 | 2615 | 42 |
978024 | 978024 | 2021-01-29 | Bamberg | South Carolina | 45009 | 1228 | 42 |
978025 | 978025 | 2021-01-29 | Barnwell | South Carolina | 45011 | 2037 | 42 |
978053 | 978053 | 2021-01-29 | Marlboro | South Carolina | 45069 | 2598 | 42 |
974779 | 974779 | 2021-01-28 | Bamberg | South Carolina | 45009 | 1219 | 42 |
974780 | 974780 | 2021-01-28 | Barnwell | South Carolina | 45011 | 2026 | 42 |
974808 | 974808 | 2021-01-28 | Marlboro | South Carolina | 45069 | 2571 | 42 |
929346 | 929346 | 2021-01-14 | Bamberg | South Carolina | 45009 | 1080 | 42 |
926101 | 926101 | 2021-01-13 | Bamberg | South Carolina | 45009 | 1073 | 42 |
922855 | 922855 | 2021-01-12 | Bamberg | South Carolina | 45009 | 1060 | 42 |
906656 | 906656 | 2021-01-07 | Lee | South Carolina | 45061 | 1284 | 42 |
903410 | 903410 | 2021-01-06 | Lee | South Carolina | 45061 | 1267 | 42 |
900165 | 900165 | 2021-01-05 | Lee | South Carolina | 45061 | 1251 | 42 |
896920 | 896920 | 2021-01-04 | Lee | South Carolina | 45061 | 1240 | 42 |
893674 | 893674 | 2021-01-03 | Lee | South Carolina | 45061 | 1229 | 42 |
890428 | 890428 | 2021-01-02 | Lee | South Carolina | 45061 | 1206 | 42 |
890441 | 890441 | 2021-01-02 | Union | South Carolina | 45087 | 1563 | 42 |
887181 | 887181 | 2021-01-01 | Lee | South Carolina | 45061 | 1194 | 42 |
883936 | 883936 | 2020-12-31 | Lee | South Carolina | 45061 | 1194 | 42 |
848222 | 848222 | 2020-12-20 | Chester | South Carolina | 45023 | 1993 | 42 |
789827 | 789827 | 2020-12-02 | Oconee | South Carolina | 45073 | 3466 | 42 |
786582 | 786582 | 2020-12-01 | Oconee | South Carolina | 45073 | 3426 | 42 |
754112 | 754112 | 2020-11-21 | Fairfield | South Carolina | 45039 | 1002 | 42 |
750866 | 750866 | 2020-11-20 | Fairfield | South Carolina | 45039 | 998 | 42 |
747620 | 747620 | 2020-11-19 | Fairfield | South Carolina | 45039 | 990 | 42 |
660028 | 660028 | 2020-10-23 | Chesterfield | South Carolina | 45025 | 1455 | 42 |
656784 | 656784 | 2020-10-22 | Chesterfield | South Carolina | 45025 | 1450 | 42 |
653539 | 653539 | 2020-10-21 | Chesterfield | South Carolina | 45025 | 1442 | 42 |
650294 | 650294 | 2020-10-20 | Chesterfield | South Carolina | 45025 | 1435 | 42 |
647065 | 647065 | 2020-10-19 | Kershaw | South Carolina | 45055 | 2345 | 42 |
643819 | 643819 | 2020-10-18 | Kershaw | South Carolina | 45055 | 2338 | 42 |
640571 | 640571 | 2020-10-17 | Kershaw | South Carolina | 45055 | 2325 | 42 |
637325 | 637325 | 2020-10-16 | Kershaw | South Carolina | 45055 | 2306 | 42 |
634079 | 634079 | 2020-10-15 | Kershaw | South Carolina | 45055 | 2286 | 42 |
624335 | 624335 | 2020-10-12 | Colleton | South Carolina | 45029 | 1142 | 42 |
621092 | 621092 | 2020-10-11 | Colleton | South Carolina | 45029 | 1134 | 42 |
617849 | 617849 | 2020-10-10 | Colleton | South Carolina | 45029 | 1129 | 42 |
614607 | 614607 | 2020-10-09 | Colleton | South Carolina | 45029 | 1122 | 42 |
611366 | 611366 | 2020-10-08 | Colleton | South Carolina | 45029 | 1112 | 42 |
608124 | 608124 | 2020-10-07 | Colleton | South Carolina | 45029 | 1101 | 42 |
604877 | 604877 | 2020-10-06 | Cherokee | South Carolina | 45021 | 1261 | 42 |
604881 | 604881 | 2020-10-06 | Colleton | South Carolina | 45029 | 1091 | 42 |
601639 | 601639 | 2020-10-05 | Colleton | South Carolina | 45029 | 1081 | 42 |
598396 | 598396 | 2020-10-04 | Colleton | South Carolina | 45029 | 1074 | 42 |
595153 | 595153 | 2020-10-03 | Colleton | South Carolina | 45029 | 1068 | 42 |
591912 | 591912 | 2020-10-02 | Colleton | South Carolina | 45029 | 1057 | 42 |
588671 | 588671 | 2020-10-01 | Colleton | South Carolina | 45029 | 1054 | 42 |
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);