ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
87 rows where deaths = 91 and state = "South Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 21
county 21
- Dorchester 15
- Aiken 6
- Chester 6
- Fairfield 6
- Jasper 6
- Lee 6
- Union 6
- Berkeley 5
- Beaufort 4
- Chesterfield 4
- Clarendon 4
- Newberry 4
- Williamsburg 4
- Marion 3
- Greenwood 2
- Barnwell 1
- Darlington 1
- Florence 1
- Georgetown 1
- Pickens 1
- Sumter 1
state 1
- South Carolina · 87 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2280707 | 2280707 | 2022-03-06 | Lee | South Carolina | 45061 | 4228 | 91 |
2277454 | 2277454 | 2022-03-05 | Lee | South Carolina | 45061 | 4228 | 91 |
2274201 | 2274201 | 2022-03-04 | Lee | South Carolina | 45061 | 4228 | 91 |
2270948 | 2270948 | 2022-03-03 | Lee | South Carolina | 45061 | 4213 | 91 |
2267696 | 2267696 | 2022-03-02 | Lee | South Carolina | 45061 | 4211 | 91 |
2264443 | 2264443 | 2022-03-01 | Lee | South Carolina | 45061 | 4210 | 91 |
2241683 | 2241683 | 2022-02-22 | Jasper | South Carolina | 45053 | 5851 | 91 |
2238432 | 2238432 | 2022-02-21 | Jasper | South Carolina | 45053 | 5833 | 91 |
2235181 | 2235181 | 2022-02-20 | Jasper | South Carolina | 45053 | 5833 | 91 |
2231930 | 2231930 | 2022-02-19 | Jasper | South Carolina | 45053 | 5833 | 91 |
2228679 | 2228679 | 2022-02-18 | Jasper | South Carolina | 45053 | 5833 | 91 |
2225428 | 2225428 | 2022-02-17 | Jasper | South Carolina | 45053 | 5833 | 91 |
2199390 | 2199390 | 2022-02-09 | Barnwell | South Carolina | 45011 | 5673 | 91 |
1763814 | 1763814 | 2021-09-28 | Fairfield | South Carolina | 45039 | 3160 | 91 |
1763838 | 1763838 | 2021-09-28 | Union | South Carolina | 45087 | 4057 | 91 |
1760565 | 1760565 | 2021-09-27 | Fairfield | South Carolina | 45039 | 3154 | 91 |
1760589 | 1760589 | 2021-09-27 | Union | South Carolina | 45087 | 4048 | 91 |
1757317 | 1757317 | 2021-09-26 | Fairfield | South Carolina | 45039 | 3137 | 91 |
1757341 | 1757341 | 2021-09-26 | Union | South Carolina | 45087 | 3996 | 91 |
1754069 | 1754069 | 2021-09-25 | Fairfield | South Carolina | 45039 | 3137 | 91 |
1754093 | 1754093 | 2021-09-25 | Union | South Carolina | 45087 | 3996 | 91 |
1750821 | 1750821 | 2021-09-24 | Fairfield | South Carolina | 45039 | 3137 | 91 |
1750845 | 1750845 | 2021-09-24 | Union | South Carolina | 45087 | 3996 | 91 |
1747572 | 1747572 | 2021-09-23 | Fairfield | South Carolina | 45039 | 3127 | 91 |
1747596 | 1747596 | 2021-09-23 | Union | South Carolina | 45087 | 3953 | 91 |
1718320 | 1718320 | 2021-09-14 | Chester | South Carolina | 45023 | 5666 | 91 |
1715072 | 1715072 | 2021-09-13 | Chester | South Carolina | 45023 | 5639 | 91 |
1711826 | 1711826 | 2021-09-12 | Chester | South Carolina | 45023 | 5532 | 91 |
1708579 | 1708579 | 2021-09-11 | Chester | South Carolina | 45023 | 5532 | 91 |
1705332 | 1705332 | 2021-09-10 | Chester | South Carolina | 45023 | 5532 | 91 |
1702082 | 1702082 | 2021-09-09 | Chester | South Carolina | 45023 | 5459 | 91 |
1085174 | 1085174 | 2021-03-03 | Williamsburg | South Carolina | 45089 | 3815 | 91 |
1081928 | 1081928 | 2021-03-02 | Williamsburg | South Carolina | 45089 | 3811 | 91 |
1078682 | 1078682 | 2021-03-01 | Williamsburg | South Carolina | 45089 | 3808 | 91 |
1075437 | 1075437 | 2021-02-28 | Williamsburg | South Carolina | 45089 | 3803 | 91 |
1039702 | 1039702 | 2021-02-17 | Chesterfield | South Carolina | 45025 | 4032 | 91 |
1036457 | 1036457 | 2021-02-16 | Chesterfield | South Carolina | 45025 | 4002 | 91 |
1033212 | 1033212 | 2021-02-15 | Chesterfield | South Carolina | 45025 | 3983 | 91 |
1029966 | 1029966 | 2021-02-14 | Chesterfield | South Carolina | 45025 | 3967 | 91 |
1029967 | 1029967 | 2021-02-14 | Clarendon | South Carolina | 45027 | 2808 | 91 |
1029989 | 1029989 | 2021-02-14 | Newberry | South Carolina | 45071 | 4091 | 91 |
1026720 | 1026720 | 2021-02-13 | Clarendon | South Carolina | 45027 | 2764 | 91 |
1026742 | 1026742 | 2021-02-13 | Newberry | South Carolina | 45071 | 4056 | 91 |
1023475 | 1023475 | 2021-02-12 | Clarendon | South Carolina | 45027 | 2743 | 91 |
1023497 | 1023497 | 2021-02-12 | Newberry | South Carolina | 45071 | 4040 | 91 |
1020230 | 1020230 | 2021-02-11 | Clarendon | South Carolina | 45027 | 2715 | 91 |
1020252 | 1020252 | 2021-02-11 | Newberry | South Carolina | 45071 | 4014 | 91 |
1017004 | 1017004 | 2021-02-10 | Marion | South Carolina | 45067 | 3046 | 91 |
1013759 | 1013759 | 2021-02-09 | Marion | South Carolina | 45067 | 3038 | 91 |
1010514 | 1010514 | 2021-02-08 | Marion | South Carolina | 45067 | 3024 | 91 |
909892 | 909892 | 2021-01-08 | Georgetown | South Carolina | 45043 | 4305 | 91 |
880676 | 880676 | 2020-12-30 | Darlington | South Carolina | 45031 | 4495 | 91 |
844989 | 844989 | 2020-12-19 | Greenwood | South Carolina | 45047 | 3780 | 91 |
841743 | 841743 | 2020-12-18 | Greenwood | South Carolina | 45047 | 3715 | 91 |
789829 | 789829 | 2020-12-02 | Pickens | South Carolina | 45077 | 6633 | 91 |
734619 | 734619 | 2020-11-15 | Aiken | South Carolina | 45003 | 5688 | 91 |
731373 | 731373 | 2020-11-14 | Aiken | South Carolina | 45003 | 5650 | 91 |
728129 | 728129 | 2020-11-13 | Aiken | South Carolina | 45003 | 5582 | 91 |
724885 | 724885 | 2020-11-12 | Aiken | South Carolina | 45003 | 5534 | 91 |
721642 | 721642 | 2020-11-11 | Aiken | South Carolina | 45003 | 5493 | 91 |
718399 | 718399 | 2020-11-10 | Aiken | South Carolina | 45003 | 5469 | 91 |
695736 | 695736 | 2020-11-03 | Sumter | South Carolina | 45085 | 3644 | 91 |
669755 | 669755 | 2020-10-26 | Beaufort | South Carolina | 45013 | 6123 | 91 |
666511 | 666511 | 2020-10-25 | Beaufort | South Carolina | 45013 | 6103 | 91 |
663266 | 663266 | 2020-10-24 | Beaufort | South Carolina | 45013 | 6072 | 91 |
660022 | 660022 | 2020-10-23 | Beaufort | South Carolina | 45013 | 6059 | 91 |
634069 | 634069 | 2020-10-15 | Dorchester | South Carolina | 45035 | 4528 | 91 |
630824 | 630824 | 2020-10-14 | Dorchester | South Carolina | 45035 | 4485 | 91 |
627570 | 627570 | 2020-10-13 | Berkeley | South Carolina | 45015 | 5701 | 91 |
627580 | 627580 | 2020-10-13 | Dorchester | South Carolina | 45035 | 4465 | 91 |
624328 | 624328 | 2020-10-12 | Berkeley | South Carolina | 45015 | 5679 | 91 |
624338 | 624338 | 2020-10-12 | Dorchester | South Carolina | 45035 | 4431 | 91 |
621085 | 621085 | 2020-10-11 | Berkeley | South Carolina | 45015 | 5649 | 91 |
621095 | 621095 | 2020-10-11 | Dorchester | South Carolina | 45035 | 4413 | 91 |
617842 | 617842 | 2020-10-10 | Berkeley | South Carolina | 45015 | 5641 | 91 |
617852 | 617852 | 2020-10-10 | Dorchester | South Carolina | 45035 | 4400 | 91 |
614600 | 614600 | 2020-10-09 | Berkeley | South Carolina | 45015 | 5626 | 91 |
614610 | 614610 | 2020-10-09 | Dorchester | South Carolina | 45035 | 4375 | 91 |
611369 | 611369 | 2020-10-08 | Dorchester | South Carolina | 45035 | 4352 | 91 |
608127 | 608127 | 2020-10-07 | Dorchester | South Carolina | 45035 | 4321 | 91 |
588674 | 588674 | 2020-10-01 | Dorchester | South Carolina | 45035 | 4201 | 91 |
585434 | 585434 | 2020-09-30 | Dorchester | South Carolina | 45035 | 4197 | 91 |
582194 | 582194 | 2020-09-29 | Dorchester | South Carolina | 45035 | 4193 | 91 |
578954 | 578954 | 2020-09-28 | Dorchester | South Carolina | 45035 | 4185 | 91 |
575713 | 575713 | 2020-09-27 | Dorchester | South Carolina | 45035 | 4173 | 91 |
572469 | 572469 | 2020-09-26 | Dorchester | South Carolina | 45035 | 4163 | 91 |
385132 | 385132 | 2020-07-30 | Florence | South Carolina | 45041 | 2789 | 91 |
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);