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 118
- 45055 118
- 45083 116
- 45057 113
- 45013 110
- 45063 110
- 45007 109
- 45045 109
- 45051 109
- 45039 108
- 45017 107
- 45079 107
- 45091 107
- 45061 106
- 45001 105
- 45035 105
- 45081 105
- 45003 104
- 45015 104
- 45027 104
- 45031 104
- 45041 104
- 45075 104
- 45077 104
- 45085 104
- 45033 103
- 45037 103
- 45047 103
- 45053 103
- 45069 103
- …
county >30
- Charleston 118
- Kershaw 118
- Spartanburg 116
- Lancaster 113
- Beaufort 110
- Lexington 110
- Anderson 109
- Greenville 109
- Horry 109
- Fairfield 108
- Calhoun 107
- Richland 107
- York 107
- Lee 106
- Abbeville 105
- Dorchester 105
- Saluda 105
- Aiken 104
- Berkeley 104
- Clarendon 104
- Darlington 104
- Florence 104
- Orangeburg 104
- Pickens 104
- Sumter 104
- Dillon 103
- Edgefield 103
- Greenwood 103
- Jasper 103
- Marlboro 103
- …
state 1
- South Carolina · 4,762 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
292572 | 292572 | 2020-07-01 | Abbeville | South Carolina | 45001 | 113 | 0 |
292573 | 292573 | 2020-07-01 | Aiken | South Carolina | 45003 | 406 | 10 |
292574 | 292574 | 2020-07-01 | Allendale | South Carolina | 45005 | 50 | 3 |
292575 | 292575 | 2020-07-01 | Anderson | South Carolina | 45007 | 635 | 11 |
292576 | 292576 | 2020-07-01 | Bamberg | South Carolina | 45009 | 117 | 1 |
292577 | 292577 | 2020-07-01 | Barnwell | South Carolina | 45011 | 82 | 1 |
292578 | 292578 | 2020-07-01 | Beaufort | South Carolina | 45013 | 1282 | 18 |
292579 | 292579 | 2020-07-01 | Berkeley | South Carolina | 45015 | 1170 | 23 |
292580 | 292580 | 2020-07-01 | Calhoun | South Carolina | 45017 | 99 | 2 |
292581 | 292581 | 2020-07-01 | Charleston | South Carolina | 45019 | 4289 | 33 |
292582 | 292582 | 2020-07-01 | Cherokee | South Carolina | 45021 | 158 | 8 |
292583 | 292583 | 2020-07-01 | Chester | South Carolina | 45023 | 189 | 1 |
292584 | 292584 | 2020-07-01 | Chesterfield | South Carolina | 45025 | 373 | 14 |
292585 | 292585 | 2020-07-01 | Clarendon | South Carolina | 45027 | 418 | 42 |
292586 | 292586 | 2020-07-01 | Colleton | South Carolina | 45029 | 333 | 21 |
292587 | 292587 | 2020-07-01 | Darlington | South Carolina | 45031 | 452 | 14 |
292588 | 292588 | 2020-07-01 | Dillon | South Carolina | 45033 | 307 | 10 |
292589 | 292589 | 2020-07-01 | Dorchester | South Carolina | 45035 | 773 | 3 |
292590 | 292590 | 2020-07-01 | Edgefield | South Carolina | 45037 | 83 | 3 |
292591 | 292591 | 2020-07-01 | Fairfield | South Carolina | 45039 | 302 | 22 |
292592 | 292592 | 2020-07-01 | Florence | South Carolina | 45041 | 1230 | 53 |
292593 | 292593 | 2020-07-01 | Georgetown | South Carolina | 45043 | 489 | 3 |
292594 | 292594 | 2020-07-01 | Greenville | South Carolina | 45045 | 5118 | 83 |
292595 | 292595 | 2020-07-01 | Greenwood | South Carolina | 45047 | 506 | 7 |
292596 | 292596 | 2020-07-01 | Hampton | South Carolina | 45049 | 73 | 2 |
292597 | 292597 | 2020-07-01 | Horry | South Carolina | 45051 | 3550 | 48 |
292598 | 292598 | 2020-07-01 | Jasper | South Carolina | 45053 | 138 | 3 |
292599 | 292599 | 2020-07-01 | Kershaw | South Carolina | 45055 | 695 | 15 |
292600 | 292600 | 2020-07-01 | Lancaster | South Carolina | 45057 | 493 | 13 |
292601 | 292601 | 2020-07-01 | Laurens | South Carolina | 45059 | 489 | 7 |
292602 | 292602 | 2020-07-01 | Lee | South Carolina | 45061 | 293 | 22 |
292603 | 292603 | 2020-07-01 | Lexington | South Carolina | 45063 | 2161 | 50 |
292604 | 292604 | 2020-07-01 | Marion | South Carolina | 45067 | 212 | 7 |
292605 | 292605 | 2020-07-01 | Marlboro | South Carolina | 45069 | 307 | 4 |
292606 | 292606 | 2020-07-01 | McCormick | South Carolina | 45065 | 17 | 2 |
292607 | 292607 | 2020-07-01 | Newberry | South Carolina | 45071 | 264 | 4 |
292608 | 292608 | 2020-07-01 | Oconee | South Carolina | 45073 | 271 | 1 |
292609 | 292609 | 2020-07-01 | Orangeburg | South Carolina | 45075 | 777 | 14 |
292610 | 292610 | 2020-07-01 | Pickens | South Carolina | 45077 | 855 | 5 |
292611 | 292611 | 2020-07-01 | Richland | South Carolina | 45079 | 3632 | 84 |
292612 | 292612 | 2020-07-01 | Saluda | South Carolina | 45081 | 215 | 1 |
292613 | 292613 | 2020-07-01 | Spartanburg | South Carolina | 45083 | 1663 | 48 |
292614 | 292614 | 2020-07-01 | Sumter | South Carolina | 45085 | 1080 | 23 |
292615 | 292615 | 2020-07-01 | Union | South Carolina | 45087 | 91 | 0 |
292616 | 292616 | 2020-07-01 | Williamsburg | South Carolina | 45089 | 412 | 15 |
292617 | 292617 | 2020-07-01 | York | South Carolina | 45091 | 1257 | 12 |
289420 | 289420 | 2020-06-30 | Abbeville | South Carolina | 45001 | 113 | 0 |
289421 | 289421 | 2020-06-30 | Aiken | South Carolina | 45003 | 387 | 10 |
289422 | 289422 | 2020-06-30 | Allendale | South Carolina | 45005 | 48 | 3 |
289423 | 289423 | 2020-06-30 | Anderson | South Carolina | 45007 | 608 | 11 |
289424 | 289424 | 2020-06-30 | Bamberg | South Carolina | 45009 | 113 | 1 |
289425 | 289425 | 2020-06-30 | Barnwell | South Carolina | 45011 | 79 | 1 |
289426 | 289426 | 2020-06-30 | Beaufort | South Carolina | 45013 | 1223 | 18 |
289427 | 289427 | 2020-06-30 | Berkeley | South Carolina | 45015 | 1069 | 22 |
289428 | 289428 | 2020-06-30 | Calhoun | South Carolina | 45017 | 87 | 1 |
289429 | 289429 | 2020-06-30 | Charleston | South Carolina | 45019 | 4027 | 26 |
289430 | 289430 | 2020-06-30 | Cherokee | South Carolina | 45021 | 154 | 7 |
289431 | 289431 | 2020-06-30 | Chester | South Carolina | 45023 | 185 | 1 |
289432 | 289432 | 2020-06-30 | Chesterfield | South Carolina | 45025 | 366 | 14 |
289433 | 289433 | 2020-06-30 | Clarendon | South Carolina | 45027 | 413 | 42 |
289434 | 289434 | 2020-06-30 | Colleton | South Carolina | 45029 | 329 | 21 |
289435 | 289435 | 2020-06-30 | Darlington | South Carolina | 45031 | 445 | 14 |
289436 | 289436 | 2020-06-30 | Dillon | South Carolina | 45033 | 304 | 9 |
289437 | 289437 | 2020-06-30 | Dorchester | South Carolina | 45035 | 712 | 3 |
289438 | 289438 | 2020-06-30 | Edgefield | South Carolina | 45037 | 76 | 3 |
289439 | 289439 | 2020-06-30 | Fairfield | South Carolina | 45039 | 298 | 21 |
289440 | 289440 | 2020-06-30 | Florence | South Carolina | 45041 | 1199 | 51 |
289441 | 289441 | 2020-06-30 | Georgetown | South Carolina | 45043 | 458 | 3 |
289442 | 289442 | 2020-06-30 | Greenville | South Carolina | 45045 | 5009 | 81 |
289443 | 289443 | 2020-06-30 | Greenwood | South Carolina | 45047 | 493 | 7 |
289444 | 289444 | 2020-06-30 | Hampton | South Carolina | 45049 | 71 | 2 |
289445 | 289445 | 2020-06-30 | Horry | South Carolina | 45051 | 3321 | 45 |
289446 | 289446 | 2020-06-30 | Jasper | South Carolina | 45053 | 132 | 3 |
289447 | 289447 | 2020-06-30 | Kershaw | South Carolina | 45055 | 665 | 15 |
289448 | 289448 | 2020-06-30 | Lancaster | South Carolina | 45057 | 475 | 12 |
289449 | 289449 | 2020-06-30 | Laurens | South Carolina | 45059 | 471 | 5 |
289450 | 289450 | 2020-06-30 | Lee | South Carolina | 45061 | 289 | 22 |
289451 | 289451 | 2020-06-30 | Lexington | South Carolina | 45063 | 2071 | 49 |
289452 | 289452 | 2020-06-30 | Marion | South Carolina | 45067 | 208 | 7 |
289453 | 289453 | 2020-06-30 | Marlboro | South Carolina | 45069 | 302 | 4 |
289454 | 289454 | 2020-06-30 | McCormick | South Carolina | 45065 | 17 | 2 |
289455 | 289455 | 2020-06-30 | Newberry | South Carolina | 45071 | 252 | 4 |
289456 | 289456 | 2020-06-30 | Oconee | South Carolina | 45073 | 260 | 1 |
289457 | 289457 | 2020-06-30 | Orangeburg | South Carolina | 45075 | 747 | 11 |
289458 | 289458 | 2020-06-30 | Pickens | South Carolina | 45077 | 835 | 5 |
289459 | 289459 | 2020-06-30 | Richland | South Carolina | 45079 | 3518 | 83 |
289460 | 289460 | 2020-06-30 | Saluda | South Carolina | 45081 | 208 | 1 |
289461 | 289461 | 2020-06-30 | Spartanburg | South Carolina | 45083 | 1609 | 48 |
289462 | 289462 | 2020-06-30 | Sumter | South Carolina | 45085 | 1059 | 23 |
289463 | 289463 | 2020-06-30 | Union | South Carolina | 45087 | 90 | 0 |
289464 | 289464 | 2020-06-30 | Williamsburg | South Carolina | 45089 | 400 | 15 |
289465 | 289465 | 2020-06-30 | York | South Carolina | 45091 | 1204 | 12 |
286269 | 286269 | 2020-06-29 | Abbeville | South Carolina | 45001 | 106 | 0 |
286270 | 286270 | 2020-06-29 | Aiken | South Carolina | 45003 | 358 | 9 |
286271 | 286271 | 2020-06-29 | Allendale | South Carolina | 45005 | 48 | 3 |
286272 | 286272 | 2020-06-29 | Anderson | South Carolina | 45007 | 578 | 11 |
286273 | 286273 | 2020-06-29 | Bamberg | South Carolina | 45009 | 103 | 1 |
286274 | 286274 | 2020-06-29 | Barnwell | South Carolina | 45011 | 77 | 1 |
286275 | 286275 | 2020-06-29 | Beaufort | South Carolina | 45013 | 1152 | 18 |
286276 | 286276 | 2020-06-29 | Berkeley | South Carolina | 45015 | 1007 | 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);