ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
101 rows where deaths = 92 and state = "South Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips 24
county 24
- Newberry 32
- Jasper 13
- Greenwood 10
- Barnwell 6
- Dillon 6
- Sumter 5
- Berkeley 4
- Lee 3
- Marlboro 3
- Beaufort 2
- Chesterfield 2
- Laurens 2
- Williamsburg 2
- Aiken 1
- Anderson 1
- Chester 1
- Clarendon 1
- Dorchester 1
- Georgetown 1
- Lancaster 1
- Marion 1
- Pickens 1
- Richland 1
- Spartanburg 1
state 1
- South Carolina · 101 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2290463 | 2290463 | 2022-03-09 | Lee | South Carolina | 45061 | 4235 | 92 |
2287211 | 2287211 | 2022-03-08 | Lee | South Carolina | 45061 | 4235 | 92 |
2283955 | 2283955 | 2022-03-07 | Jasper | South Carolina | 45053 | 5882 | 92 |
2283959 | 2283959 | 2022-03-07 | Lee | South Carolina | 45061 | 4234 | 92 |
2280703 | 2280703 | 2022-03-06 | Jasper | South Carolina | 45053 | 5875 | 92 |
2277450 | 2277450 | 2022-03-05 | Jasper | South Carolina | 45053 | 5875 | 92 |
2274197 | 2274197 | 2022-03-04 | Jasper | South Carolina | 45053 | 5875 | 92 |
2270944 | 2270944 | 2022-03-03 | Jasper | South Carolina | 45053 | 5871 | 92 |
2267692 | 2267692 | 2022-03-02 | Jasper | South Carolina | 45053 | 5867 | 92 |
2264439 | 2264439 | 2022-03-01 | Jasper | South Carolina | 45053 | 5866 | 92 |
2261189 | 2261189 | 2022-02-28 | Jasper | South Carolina | 45053 | 5864 | 92 |
2257938 | 2257938 | 2022-02-27 | Jasper | South Carolina | 45053 | 5857 | 92 |
2254687 | 2254687 | 2022-02-26 | Jasper | South Carolina | 45053 | 5857 | 92 |
2251436 | 2251436 | 2022-02-25 | Jasper | South Carolina | 45053 | 5857 | 92 |
2248185 | 2248185 | 2022-02-24 | Jasper | South Carolina | 45053 | 5854 | 92 |
2244934 | 2244934 | 2022-02-23 | Jasper | South Carolina | 45053 | 5854 | 92 |
2218905 | 2218905 | 2022-02-15 | Barnwell | South Carolina | 45011 | 5738 | 92 |
2215654 | 2215654 | 2022-02-14 | Barnwell | South Carolina | 45011 | 5733 | 92 |
2212403 | 2212403 | 2022-02-13 | Barnwell | South Carolina | 45011 | 5680 | 92 |
2209150 | 2209150 | 2022-02-12 | Barnwell | South Carolina | 45011 | 5680 | 92 |
2205897 | 2205897 | 2022-02-11 | Barnwell | South Carolina | 45011 | 5680 | 92 |
2202644 | 2202644 | 2022-02-10 | Barnwell | South Carolina | 45011 | 5680 | 92 |
2176648 | 2176648 | 2022-02-02 | Marlboro | South Carolina | 45069 | 7384 | 92 |
2173394 | 2173394 | 2022-02-01 | Marlboro | South Carolina | 45069 | 7352 | 92 |
2170142 | 2170142 | 2022-01-31 | Marlboro | South Carolina | 45069 | 7343 | 92 |
1721568 | 1721568 | 2021-09-15 | Chester | South Carolina | 45023 | 5704 | 92 |
1692342 | 1692342 | 2021-09-06 | Dillon | South Carolina | 45033 | 5394 | 92 |
1689093 | 1689093 | 2021-09-05 | Dillon | South Carolina | 45033 | 5277 | 92 |
1685843 | 1685843 | 2021-09-04 | Dillon | South Carolina | 45033 | 5277 | 92 |
1682592 | 1682592 | 2021-09-03 | Dillon | South Carolina | 45033 | 5277 | 92 |
1679342 | 1679342 | 2021-09-02 | Dillon | South Carolina | 45033 | 5244 | 92 |
1676094 | 1676094 | 2021-09-01 | Dillon | South Carolina | 45033 | 5211 | 92 |
1133861 | 1133861 | 2021-03-18 | Newberry | South Carolina | 45071 | 4563 | 92 |
1130613 | 1130613 | 2021-03-17 | Newberry | South Carolina | 45071 | 4532 | 92 |
1127366 | 1127366 | 2021-03-16 | Newberry | South Carolina | 45071 | 4511 | 92 |
1124120 | 1124120 | 2021-03-15 | Newberry | South Carolina | 45071 | 4509 | 92 |
1120874 | 1120874 | 2021-03-14 | Newberry | South Carolina | 45071 | 4503 | 92 |
1117627 | 1117627 | 2021-03-13 | Newberry | South Carolina | 45071 | 4497 | 92 |
1114380 | 1114380 | 2021-03-12 | Newberry | South Carolina | 45071 | 4491 | 92 |
1111134 | 1111134 | 2021-03-11 | Newberry | South Carolina | 45071 | 4476 | 92 |
1107888 | 1107888 | 2021-03-10 | Newberry | South Carolina | 45071 | 4471 | 92 |
1104642 | 1104642 | 2021-03-09 | Newberry | South Carolina | 45071 | 4460 | 92 |
1101396 | 1101396 | 2021-03-08 | Newberry | South Carolina | 45071 | 4449 | 92 |
1098150 | 1098150 | 2021-03-07 | Newberry | South Carolina | 45071 | 4445 | 92 |
1094902 | 1094902 | 2021-03-06 | Newberry | South Carolina | 45071 | 4431 | 92 |
1091656 | 1091656 | 2021-03-05 | Newberry | South Carolina | 45071 | 4424 | 92 |
1091665 | 1091665 | 2021-03-05 | Williamsburg | South Carolina | 45089 | 3830 | 92 |
1088410 | 1088410 | 2021-03-04 | Newberry | South Carolina | 45071 | 4420 | 92 |
1088419 | 1088419 | 2021-03-04 | Williamsburg | South Carolina | 45089 | 3823 | 92 |
1085165 | 1085165 | 2021-03-03 | Newberry | South Carolina | 45071 | 4415 | 92 |
1081919 | 1081919 | 2021-03-02 | Newberry | South Carolina | 45071 | 4410 | 92 |
1078673 | 1078673 | 2021-03-01 | Newberry | South Carolina | 45071 | 4403 | 92 |
1075428 | 1075428 | 2021-02-28 | Newberry | South Carolina | 45071 | 4390 | 92 |
1072182 | 1072182 | 2021-02-27 | Newberry | South Carolina | 45071 | 4380 | 92 |
1068936 | 1068936 | 2021-02-26 | Newberry | South Carolina | 45071 | 4359 | 92 |
1065691 | 1065691 | 2021-02-25 | Newberry | South Carolina | 45071 | 4348 | 92 |
1062446 | 1062446 | 2021-02-24 | Newberry | South Carolina | 45071 | 4328 | 92 |
1059201 | 1059201 | 2021-02-23 | Newberry | South Carolina | 45071 | 4305 | 92 |
1055955 | 1055955 | 2021-02-22 | Newberry | South Carolina | 45071 | 4292 | 92 |
1052709 | 1052709 | 2021-02-21 | Newberry | South Carolina | 45071 | 4270 | 92 |
1049462 | 1049462 | 2021-02-20 | Newberry | South Carolina | 45071 | 4238 | 92 |
1046192 | 1046192 | 2021-02-19 | Chesterfield | South Carolina | 45025 | 4107 | 92 |
1046215 | 1046215 | 2021-02-19 | Newberry | South Carolina | 45071 | 4203 | 92 |
1042947 | 1042947 | 2021-02-18 | Chesterfield | South Carolina | 45025 | 4061 | 92 |
1042970 | 1042970 | 2021-02-18 | Newberry | South Carolina | 45071 | 4175 | 92 |
1039725 | 1039725 | 2021-02-17 | Newberry | South Carolina | 45071 | 4152 | 92 |
1036480 | 1036480 | 2021-02-16 | Newberry | South Carolina | 45071 | 4123 | 92 |
1033213 | 1033213 | 2021-02-15 | Clarendon | South Carolina | 45027 | 2814 | 92 |
1033235 | 1033235 | 2021-02-15 | Newberry | South Carolina | 45071 | 4108 | 92 |
1020249 | 1020249 | 2021-02-11 | Marion | South Carolina | 45067 | 3073 | 92 |
913137 | 913137 | 2021-01-09 | Georgetown | South Carolina | 45043 | 4382 | 92 |
909900 | 909900 | 2021-01-08 | Laurens | South Carolina | 45059 | 4033 | 92 |
906655 | 906655 | 2021-01-07 | Laurens | South Carolina | 45059 | 3953 | 92 |
903408 | 903408 | 2021-01-06 | Lancaster | South Carolina | 45057 | 5734 | 92 |
877439 | 877439 | 2020-12-29 | Greenwood | South Carolina | 45047 | 4186 | 92 |
874194 | 874194 | 2020-12-28 | Greenwood | South Carolina | 45047 | 4118 | 92 |
870949 | 870949 | 2020-12-27 | Greenwood | South Carolina | 45047 | 4100 | 92 |
867704 | 867704 | 2020-12-26 | Greenwood | South Carolina | 45047 | 4023 | 92 |
864459 | 864459 | 2020-12-25 | Greenwood | South Carolina | 45047 | 3966 | 92 |
861214 | 861214 | 2020-12-24 | Greenwood | South Carolina | 45047 | 3966 | 92 |
857969 | 857969 | 2020-12-23 | Greenwood | South Carolina | 45047 | 3901 | 92 |
854724 | 854724 | 2020-12-22 | Greenwood | South Carolina | 45047 | 3861 | 92 |
851479 | 851479 | 2020-12-21 | Greenwood | South Carolina | 45047 | 3848 | 92 |
848234 | 848234 | 2020-12-20 | Greenwood | South Carolina | 45047 | 3820 | 92 |
793074 | 793074 | 2020-12-03 | Pickens | South Carolina | 45077 | 6736 | 92 |
737863 | 737863 | 2020-11-16 | Aiken | South Carolina | 45003 | 5737 | 92 |
711953 | 711953 | 2020-11-08 | Sumter | South Carolina | 45085 | 3730 | 92 |
708709 | 708709 | 2020-11-07 | Sumter | South Carolina | 45085 | 3726 | 92 |
705466 | 705466 | 2020-11-06 | Sumter | South Carolina | 45085 | 3680 | 92 |
702223 | 702223 | 2020-11-05 | Sumter | South Carolina | 45085 | 3665 | 92 |
698979 | 698979 | 2020-11-04 | Sumter | South Carolina | 45085 | 3652 | 92 |
676240 | 676240 | 2020-10-28 | Beaufort | South Carolina | 45013 | 6148 | 92 |
672997 | 672997 | 2020-10-27 | Beaufort | South Carolina | 45013 | 6138 | 92 |
640551 | 640551 | 2020-10-17 | Berkeley | South Carolina | 45015 | 5802 | 92 |
637305 | 637305 | 2020-10-16 | Berkeley | South Carolina | 45015 | 5782 | 92 |
637315 | 637315 | 2020-10-16 | Dorchester | South Carolina | 45035 | 4554 | 92 |
634059 | 634059 | 2020-10-15 | Berkeley | South Carolina | 45015 | 5749 | 92 |
630814 | 630814 | 2020-10-14 | Berkeley | South Carolina | 45015 | 5723 | 92 |
462457 | 462457 | 2020-08-23 | Anderson | South Carolina | 45007 | 2879 | 92 |
401235 | 401235 | 2020-08-04 | Spartanburg | South Carolina | 45083 | 3838 | 92 |
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);