ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
36,091 rows where state = "South Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 45019 115
- 45055 115
- 45083 113
- 45057 110
- 45013 107
- 45063 107
- 45007 106
- 45045 106
- 45051 106
- 45039 105
- 45017 104
- 45079 104
- 45091 104
- 45061 103
- 45001 102
- 45035 102
- 45081 102
- 45003 101
- 45015 101
- 45027 101
- 45031 101
- 45041 101
- 45075 101
- 45077 101
- 45085 101
- 45033 100
- 45037 100
- 45047 100
- 45053 100
- 45069 100
- …
county >30
- Charleston 115
- Kershaw 115
- Spartanburg 113
- Lancaster 110
- Beaufort 107
- Lexington 107
- Anderson 106
- Greenville 106
- Horry 106
- Fairfield 105
- Calhoun 104
- Richland 104
- York 104
- Lee 103
- Abbeville 102
- Dorchester 102
- Saluda 102
- Aiken 101
- Berkeley 101
- Clarendon 101
- Darlington 101
- Florence 101
- Orangeburg 101
- Pickens 101
- Sumter 101
- Dillon 100
- Edgefield 100
- Greenwood 100
- Jasper 100
- Marlboro 100
- …
state 1
- South Carolina · 4,624 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
283124 | 283124 | 2020-06-28 | Abbeville | South Carolina | 45001 | 103 | 0 |
283125 | 283125 | 2020-06-28 | Aiken | South Carolina | 45003 | 345 | 9 |
283126 | 283126 | 2020-06-28 | Allendale | South Carolina | 45005 | 48 | 3 |
283127 | 283127 | 2020-06-28 | Anderson | South Carolina | 45007 | 563 | 10 |
283128 | 283128 | 2020-06-28 | Bamberg | South Carolina | 45009 | 91 | 1 |
283129 | 283129 | 2020-06-28 | Barnwell | South Carolina | 45011 | 75 | 1 |
283130 | 283130 | 2020-06-28 | Beaufort | South Carolina | 45013 | 1125 | 17 |
283131 | 283131 | 2020-06-28 | Berkeley | South Carolina | 45015 | 949 | 21 |
283132 | 283132 | 2020-06-28 | Calhoun | South Carolina | 45017 | 82 | 1 |
283133 | 283133 | 2020-06-28 | Charleston | South Carolina | 45019 | 3381 | 23 |
283134 | 283134 | 2020-06-28 | Cherokee | South Carolina | 45021 | 142 | 7 |
283135 | 283135 | 2020-06-28 | Chester | South Carolina | 45023 | 171 | 1 |
283136 | 283136 | 2020-06-28 | Chesterfield | South Carolina | 45025 | 359 | 13 |
283137 | 283137 | 2020-06-28 | Clarendon | South Carolina | 45027 | 407 | 42 |
283138 | 283138 | 2020-06-28 | Colleton | South Carolina | 45029 | 307 | 21 |
283139 | 283139 | 2020-06-28 | Darlington | South Carolina | 45031 | 427 | 14 |
283140 | 283140 | 2020-06-28 | Dillon | South Carolina | 45033 | 289 | 8 |
283141 | 283141 | 2020-06-28 | Dorchester | South Carolina | 45035 | 594 | 3 |
283142 | 283142 | 2020-06-28 | Edgefield | South Carolina | 45037 | 73 | 2 |
283143 | 283143 | 2020-06-28 | Fairfield | South Carolina | 45039 | 280 | 21 |
283144 | 283144 | 2020-06-28 | Florence | South Carolina | 45041 | 1134 | 49 |
283145 | 283145 | 2020-06-28 | Georgetown | South Carolina | 45043 | 435 | 3 |
283146 | 283146 | 2020-06-28 | Greenville | South Carolina | 45045 | 4741 | 80 |
283147 | 283147 | 2020-06-28 | Greenwood | South Carolina | 45047 | 458 | 7 |
283148 | 283148 | 2020-06-28 | Hampton | South Carolina | 45049 | 65 | 2 |
283149 | 283149 | 2020-06-28 | Horry | South Carolina | 45051 | 2987 | 44 |
283150 | 283150 | 2020-06-28 | Jasper | South Carolina | 45053 | 121 | 3 |
283151 | 283151 | 2020-06-28 | Kershaw | South Carolina | 45055 | 628 | 15 |
283152 | 283152 | 2020-06-28 | Lancaster | South Carolina | 45057 | 421 | 12 |
283153 | 283153 | 2020-06-28 | Laurens | South Carolina | 45059 | 407 | 5 |
283154 | 283154 | 2020-06-28 | Lee | South Carolina | 45061 | 283 | 22 |
283155 | 283155 | 2020-06-28 | Lexington | South Carolina | 45063 | 1901 | 48 |
283156 | 283156 | 2020-06-28 | Marion | South Carolina | 45067 | 191 | 7 |
283157 | 283157 | 2020-06-28 | Marlboro | South Carolina | 45069 | 298 | 4 |
283158 | 283158 | 2020-06-28 | McCormick | South Carolina | 45065 | 12 | 1 |
283159 | 283159 | 2020-06-28 | Newberry | South Carolina | 45071 | 221 | 4 |
283160 | 283160 | 2020-06-28 | Oconee | South Carolina | 45073 | 244 | 1 |
283161 | 283161 | 2020-06-28 | Orangeburg | South Carolina | 45075 | 670 | 10 |
283162 | 283162 | 2020-06-28 | Pickens | South Carolina | 45077 | 778 | 4 |
283163 | 283163 | 2020-06-28 | Richland | South Carolina | 45079 | 3285 | 81 |
283164 | 283164 | 2020-06-28 | Saluda | South Carolina | 45081 | 203 | 1 |
283165 | 283165 | 2020-06-28 | Spartanburg | South Carolina | 45083 | 1472 | 45 |
283166 | 283166 | 2020-06-28 | Sumter | South Carolina | 45085 | 1003 | 23 |
283167 | 283167 | 2020-06-28 | Union | South Carolina | 45087 | 73 | 0 |
283168 | 283168 | 2020-06-28 | Williamsburg | South Carolina | 45089 | 383 | 15 |
283169 | 283169 | 2020-06-28 | York | South Carolina | 45091 | 1095 | 12 |
279978 | 279978 | 2020-06-27 | Abbeville | South Carolina | 45001 | 103 | 0 |
279979 | 279979 | 2020-06-27 | Aiken | South Carolina | 45003 | 335 | 9 |
279980 | 279980 | 2020-06-27 | Allendale | South Carolina | 45005 | 48 | 3 |
279981 | 279981 | 2020-06-27 | Anderson | South Carolina | 45007 | 552 | 10 |
279982 | 279982 | 2020-06-27 | Bamberg | South Carolina | 45009 | 84 | 1 |
279983 | 279983 | 2020-06-27 | Barnwell | South Carolina | 45011 | 73 | 1 |
279984 | 279984 | 2020-06-27 | Beaufort | South Carolina | 45013 | 1066 | 17 |
279985 | 279985 | 2020-06-27 | Berkeley | South Carolina | 45015 | 892 | 21 |
279986 | 279986 | 2020-06-27 | Calhoun | South Carolina | 45017 | 78 | 1 |
279987 | 279987 | 2020-06-27 | Charleston | South Carolina | 45019 | 3142 | 22 |
279988 | 279988 | 2020-06-27 | Cherokee | South Carolina | 45021 | 136 | 7 |
279989 | 279989 | 2020-06-27 | Chester | South Carolina | 45023 | 162 | 1 |
279990 | 279990 | 2020-06-27 | Chesterfield | South Carolina | 45025 | 354 | 13 |
279991 | 279991 | 2020-06-27 | Clarendon | South Carolina | 45027 | 406 | 42 |
279992 | 279992 | 2020-06-27 | Colleton | South Carolina | 45029 | 295 | 21 |
279993 | 279993 | 2020-06-27 | Darlington | South Carolina | 45031 | 416 | 14 |
279994 | 279994 | 2020-06-27 | Dillon | South Carolina | 45033 | 263 | 8 |
279995 | 279995 | 2020-06-27 | Dorchester | South Carolina | 45035 | 551 | 3 |
279996 | 279996 | 2020-06-27 | Edgefield | South Carolina | 45037 | 73 | 2 |
279997 | 279997 | 2020-06-27 | Fairfield | South Carolina | 45039 | 279 | 21 |
279998 | 279998 | 2020-06-27 | Florence | South Carolina | 45041 | 1104 | 48 |
279999 | 279999 | 2020-06-27 | Georgetown | South Carolina | 45043 | 426 | 3 |
280000 | 280000 | 2020-06-27 | Greenville | South Carolina | 45045 | 4546 | 80 |
280001 | 280001 | 2020-06-27 | Greenwood | South Carolina | 45047 | 448 | 7 |
280002 | 280002 | 2020-06-27 | Hampton | South Carolina | 45049 | 63 | 2 |
280003 | 280003 | 2020-06-27 | Horry | South Carolina | 45051 | 2803 | 44 |
280004 | 280004 | 2020-06-27 | Jasper | South Carolina | 45053 | 110 | 3 |
280005 | 280005 | 2020-06-27 | Kershaw | South Carolina | 45055 | 615 | 15 |
280006 | 280006 | 2020-06-27 | Lancaster | South Carolina | 45057 | 412 | 12 |
280007 | 280007 | 2020-06-27 | Laurens | South Carolina | 45059 | 372 | 4 |
280008 | 280008 | 2020-06-27 | Lee | South Carolina | 45061 | 276 | 22 |
280009 | 280009 | 2020-06-27 | Lexington | South Carolina | 45063 | 1846 | 47 |
280010 | 280010 | 2020-06-27 | Marion | South Carolina | 45067 | 176 | 7 |
280011 | 280011 | 2020-06-27 | Marlboro | South Carolina | 45069 | 297 | 4 |
280012 | 280012 | 2020-06-27 | McCormick | South Carolina | 45065 | 11 | 1 |
280013 | 280013 | 2020-06-27 | Newberry | South Carolina | 45071 | 190 | 4 |
280014 | 280014 | 2020-06-27 | Oconee | South Carolina | 45073 | 224 | 1 |
280015 | 280015 | 2020-06-27 | Orangeburg | South Carolina | 45075 | 643 | 10 |
280016 | 280016 | 2020-06-27 | Pickens | South Carolina | 45077 | 751 | 4 |
280017 | 280017 | 2020-06-27 | Richland | South Carolina | 45079 | 3192 | 80 |
280018 | 280018 | 2020-06-27 | Saluda | South Carolina | 45081 | 200 | 1 |
280019 | 280019 | 2020-06-27 | Spartanburg | South Carolina | 45083 | 1429 | 45 |
280020 | 280020 | 2020-06-27 | Sumter | South Carolina | 45085 | 996 | 23 |
280021 | 280021 | 2020-06-27 | Union | South Carolina | 45087 | 73 | 0 |
280022 | 280022 | 2020-06-27 | Williamsburg | South Carolina | 45089 | 381 | 15 |
280023 | 280023 | 2020-06-27 | York | South Carolina | 45091 | 1047 | 12 |
276830 | 276830 | 2020-06-26 | Abbeville | South Carolina | 45001 | 100 | 0 |
276831 | 276831 | 2020-06-26 | Aiken | South Carolina | 45003 | 325 | 9 |
276832 | 276832 | 2020-06-26 | Allendale | South Carolina | 45005 | 47 | 3 |
276833 | 276833 | 2020-06-26 | Anderson | South Carolina | 45007 | 525 | 10 |
276834 | 276834 | 2020-06-26 | Bamberg | South Carolina | 45009 | 83 | 0 |
276835 | 276835 | 2020-06-26 | Barnwell | South Carolina | 45011 | 69 | 1 |
276836 | 276836 | 2020-06-26 | Beaufort | South Carolina | 45013 | 1012 | 17 |
276837 | 276837 | 2020-06-26 | Berkeley | South Carolina | 45015 | 854 | 21 |
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);