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 148
- 45055 148
- 45083 146
- 45057 143
- 45013 140
- 45063 140
- 45007 139
- 45045 139
- 45051 139
- 45039 138
- 45017 137
- 45079 137
- 45091 137
- 45061 136
- 45001 135
- 45035 135
- 45081 135
- 45003 134
- 45015 134
- 45027 134
- 45031 134
- 45041 134
- 45075 134
- 45077 134
- 45085 134
- 45033 133
- 45037 133
- 45047 133
- 45053 133
- 45069 133
- …
county >30
- Charleston 148
- Kershaw 148
- Spartanburg 146
- Lancaster 143
- Beaufort 140
- Lexington 140
- Anderson 139
- Greenville 139
- Horry 139
- Fairfield 138
- Calhoun 137
- Richland 137
- York 137
- Lee 136
- Abbeville 135
- Dorchester 135
- Saluda 135
- Aiken 134
- Berkeley 134
- Clarendon 134
- Darlington 134
- Florence 134
- Orangeburg 134
- Pickens 134
- Sumter 134
- Dillon 133
- Edgefield 133
- Greenwood 133
- Jasper 133
- Marlboro 133
- …
state 1
- South Carolina · 6,142 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388329 | 388329 | 2020-07-31 | Abbeville | South Carolina | 45001 | 282 | 7 |
388330 | 388330 | 2020-07-31 | Aiken | South Carolina | 45003 | 1491 | 24 |
388331 | 388331 | 2020-07-31 | Allendale | South Carolina | 45005 | 173 | 3 |
388332 | 388332 | 2020-07-31 | Anderson | South Carolina | 45007 | 1939 | 43 |
388333 | 388333 | 2020-07-31 | Bamberg | South Carolina | 45009 | 423 | 16 |
388334 | 388334 | 2020-07-31 | Barnwell | South Carolina | 45011 | 320 | 4 |
388335 | 388335 | 2020-07-31 | Beaufort | South Carolina | 45013 | 3503 | 47 |
388336 | 388336 | 2020-07-31 | Berkeley | South Carolina | 45015 | 3760 | 57 |
388337 | 388337 | 2020-07-31 | Calhoun | South Carolina | 45017 | 295 | 7 |
388338 | 388338 | 2020-07-31 | Charleston | South Carolina | 45019 | 11345 | 162 |
388339 | 388339 | 2020-07-31 | Cherokee | South Carolina | 45021 | 528 | 25 |
388340 | 388340 | 2020-07-31 | Chester | South Carolina | 45023 | 532 | 11 |
388341 | 388341 | 2020-07-31 | Chesterfield | South Carolina | 45025 | 670 | 19 |
388342 | 388342 | 2020-07-31 | Clarendon | South Carolina | 45027 | 749 | 50 |
388343 | 388343 | 2020-07-31 | Colleton | South Carolina | 45029 | 739 | 31 |
388344 | 388344 | 2020-07-31 | Darlington | South Carolina | 45031 | 1023 | 33 |
388345 | 388345 | 2020-07-31 | Dillon | South Carolina | 45033 | 541 | 23 |
388346 | 388346 | 2020-07-31 | Dorchester | South Carolina | 45035 | 2702 | 39 |
388347 | 388347 | 2020-07-31 | Edgefield | South Carolina | 45037 | 273 | 6 |
388348 | 388348 | 2020-07-31 | Fairfield | South Carolina | 45039 | 525 | 23 |
388349 | 388349 | 2020-07-31 | Florence | South Carolina | 45041 | 2853 | 93 |
388350 | 388350 | 2020-07-31 | Georgetown | South Carolina | 45043 | 1237 | 18 |
388351 | 388351 | 2020-07-31 | Greenville | South Carolina | 45045 | 10034 | 184 |
388352 | 388352 | 2020-07-31 | Greenwood | South Carolina | 45047 | 1197 | 15 |
388353 | 388353 | 2020-07-31 | Hampton | South Carolina | 45049 | 320 | 8 |
388354 | 388354 | 2020-07-31 | Horry | South Carolina | 45051 | 7975 | 126 |
388355 | 388355 | 2020-07-31 | Jasper | South Carolina | 45053 | 483 | 11 |
388356 | 388356 | 2020-07-31 | Kershaw | South Carolina | 45055 | 1260 | 22 |
388357 | 388357 | 2020-07-31 | Lancaster | South Carolina | 45057 | 1018 | 21 |
388358 | 388358 | 2020-07-31 | Laurens | South Carolina | 45059 | 1189 | 34 |
388359 | 388359 | 2020-07-31 | Lee | South Carolina | 45061 | 487 | 26 |
388360 | 388360 | 2020-07-31 | Lexington | South Carolina | 45063 | 4531 | 97 |
388361 | 388361 | 2020-07-31 | Marion | South Carolina | 45067 | 511 | 12 |
388362 | 388362 | 2020-07-31 | Marlboro | South Carolina | 45069 | 423 | 4 |
388363 | 388363 | 2020-07-31 | McCormick | South Carolina | 45065 | 99 | 2 |
388364 | 388364 | 2020-07-31 | Newberry | South Carolina | 45071 | 745 | 8 |
388365 | 388365 | 2020-07-31 | Oconee | South Carolina | 45073 | 716 | 6 |
388366 | 388366 | 2020-07-31 | Orangeburg | South Carolina | 45075 | 2120 | 57 |
388367 | 388367 | 2020-07-31 | Pickens | South Carolina | 45077 | 1683 | 22 |
388368 | 388368 | 2020-07-31 | Richland | South Carolina | 45079 | 7780 | 131 |
388369 | 388369 | 2020-07-31 | Saluda | South Carolina | 45081 | 398 | 7 |
388370 | 388370 | 2020-07-31 | Spartanburg | South Carolina | 45083 | 3656 | 82 |
388371 | 388371 | 2020-07-31 | Sumter | South Carolina | 45085 | 2227 | 43 |
388372 | 388372 | 2020-07-31 | Union | South Carolina | 45087 | 324 | 2 |
388373 | 388373 | 2020-07-31 | Williamsburg | South Carolina | 45089 | 860 | 24 |
388374 | 388374 | 2020-07-31 | York | South Carolina | 45091 | 3077 | 27 |
385112 | 385112 | 2020-07-30 | Abbeville | South Carolina | 45001 | 285 | 7 |
385113 | 385113 | 2020-07-30 | Aiken | South Carolina | 45003 | 1444 | 24 |
385114 | 385114 | 2020-07-30 | Allendale | South Carolina | 45005 | 172 | 3 |
385115 | 385115 | 2020-07-30 | Anderson | South Carolina | 45007 | 1882 | 41 |
385116 | 385116 | 2020-07-30 | Bamberg | South Carolina | 45009 | 414 | 15 |
385117 | 385117 | 2020-07-30 | Barnwell | South Carolina | 45011 | 313 | 4 |
385118 | 385118 | 2020-07-30 | Beaufort | South Carolina | 45013 | 3398 | 44 |
385119 | 385119 | 2020-07-30 | Berkeley | South Carolina | 45015 | 3731 | 57 |
385120 | 385120 | 2020-07-30 | Calhoun | South Carolina | 45017 | 284 | 6 |
385121 | 385121 | 2020-07-30 | Charleston | South Carolina | 45019 | 11260 | 158 |
385122 | 385122 | 2020-07-30 | Cherokee | South Carolina | 45021 | 515 | 24 |
385123 | 385123 | 2020-07-30 | Chester | South Carolina | 45023 | 523 | 10 |
385124 | 385124 | 2020-07-30 | Chesterfield | South Carolina | 45025 | 660 | 19 |
385125 | 385125 | 2020-07-30 | Clarendon | South Carolina | 45027 | 740 | 50 |
385126 | 385126 | 2020-07-30 | Colleton | South Carolina | 45029 | 727 | 31 |
385127 | 385127 | 2020-07-30 | Darlington | South Carolina | 45031 | 994 | 33 |
385128 | 385128 | 2020-07-30 | Dillon | South Carolina | 45033 | 536 | 23 |
385129 | 385129 | 2020-07-30 | Dorchester | South Carolina | 45035 | 2653 | 37 |
385130 | 385130 | 2020-07-30 | Edgefield | South Carolina | 45037 | 264 | 6 |
385131 | 385131 | 2020-07-30 | Fairfield | South Carolina | 45039 | 517 | 23 |
385132 | 385132 | 2020-07-30 | Florence | South Carolina | 45041 | 2789 | 91 |
385133 | 385133 | 2020-07-30 | Georgetown | South Carolina | 45043 | 1211 | 17 |
385134 | 385134 | 2020-07-30 | Greenville | South Carolina | 45045 | 9876 | 175 |
385135 | 385135 | 2020-07-30 | Greenwood | South Carolina | 45047 | 1174 | 15 |
385136 | 385136 | 2020-07-30 | Hampton | South Carolina | 45049 | 309 | 8 |
385137 | 385137 | 2020-07-30 | Horry | South Carolina | 45051 | 7873 | 121 |
385138 | 385138 | 2020-07-30 | Jasper | South Carolina | 45053 | 474 | 11 |
385139 | 385139 | 2020-07-30 | Kershaw | South Carolina | 45055 | 1246 | 22 |
385140 | 385140 | 2020-07-30 | Lancaster | South Carolina | 45057 | 1003 | 21 |
385141 | 385141 | 2020-07-30 | Laurens | South Carolina | 45059 | 1176 | 33 |
385142 | 385142 | 2020-07-30 | Lee | South Carolina | 45061 | 485 | 26 |
385143 | 385143 | 2020-07-30 | Lexington | South Carolina | 45063 | 4488 | 97 |
385144 | 385144 | 2020-07-30 | Marion | South Carolina | 45067 | 498 | 12 |
385145 | 385145 | 2020-07-30 | Marlboro | South Carolina | 45069 | 409 | 4 |
385146 | 385146 | 2020-07-30 | McCormick | South Carolina | 45065 | 100 | 2 |
385147 | 385147 | 2020-07-30 | Newberry | South Carolina | 45071 | 737 | 8 |
385148 | 385148 | 2020-07-30 | Oconee | South Carolina | 45073 | 699 | 6 |
385149 | 385149 | 2020-07-30 | Orangeburg | South Carolina | 45075 | 2061 | 52 |
385150 | 385150 | 2020-07-30 | Pickens | South Carolina | 45077 | 1653 | 20 |
385151 | 385151 | 2020-07-30 | Richland | South Carolina | 45079 | 7617 | 129 |
385152 | 385152 | 2020-07-30 | Saluda | South Carolina | 45081 | 395 | 7 |
385153 | 385153 | 2020-07-30 | Spartanburg | South Carolina | 45083 | 3609 | 81 |
385154 | 385154 | 2020-07-30 | Sumter | South Carolina | 45085 | 2201 | 42 |
385155 | 385155 | 2020-07-30 | Union | South Carolina | 45087 | 307 | 2 |
385156 | 385156 | 2020-07-30 | Williamsburg | South Carolina | 45089 | 848 | 23 |
385157 | 385157 | 2020-07-30 | York | South Carolina | 45091 | 3022 | 27 |
381894 | 381894 | 2020-07-29 | Abbeville | South Carolina | 45001 | 279 | 6 |
381895 | 381895 | 2020-07-29 | Aiken | South Carolina | 45003 | 1403 | 24 |
381896 | 381896 | 2020-07-29 | Allendale | South Carolina | 45005 | 163 | 3 |
381897 | 381897 | 2020-07-29 | Anderson | South Carolina | 45007 | 1816 | 41 |
381898 | 381898 | 2020-07-29 | Bamberg | South Carolina | 45009 | 387 | 11 |
381899 | 381899 | 2020-07-29 | Barnwell | South Carolina | 45011 | 300 | 3 |
381900 | 381900 | 2020-07-29 | Beaufort | South Carolina | 45013 | 3285 | 39 |
381901 | 381901 | 2020-07-29 | Berkeley | South Carolina | 45015 | 3636 | 56 |
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);