ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
46 rows where "date" is on date 2021-04-06 and state = "South Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Abbeville 1
- Aiken 1
- Allendale 1
- Anderson 1
- Bamberg 1
- Barnwell 1
- Beaufort 1
- Berkeley 1
- Calhoun 1
- Charleston 1
- Cherokee 1
- Chester 1
- Chesterfield 1
- Clarendon 1
- Colleton 1
- Darlington 1
- Dillon 1
- Dorchester 1
- Edgefield 1
- Fairfield 1
- Florence 1
- Georgetown 1
- Greenville 1
- Greenwood 1
- Hampton 1
- Horry 1
- Jasper 1
- Kershaw 1
- Lancaster 1
- Laurens 1
- …
state 1
- South Carolina · 46 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195524 | 1195524 | 2021-04-06 | Abbeville | South Carolina | 45001 | 2467 | 38 |
1195525 | 1195525 | 2021-04-06 | Aiken | South Carolina | 45003 | 16602 | 216 |
1195526 | 1195526 | 2021-04-06 | Allendale | South Carolina | 45005 | 901 | 15 |
1195527 | 1195527 | 2021-04-06 | Anderson | South Carolina | 45007 | 21977 | 499 |
1195528 | 1195528 | 2021-04-06 | Bamberg | South Carolina | 45009 | 1518 | 51 |
1195529 | 1195529 | 2021-04-06 | Barnwell | South Carolina | 45011 | 2483 | 54 |
1195530 | 1195530 | 2021-04-06 | Beaufort | South Carolina | 45013 | 16360 | 199 |
1195531 | 1195531 | 2021-04-06 | Berkeley | South Carolina | 45015 | 16418 | 185 |
1195532 | 1195532 | 2021-04-06 | Calhoun | South Carolina | 45017 | 1277 | 36 |
1195533 | 1195533 | 2021-04-06 | Charleston | South Carolina | 45019 | 41076 | 484 |
1195534 | 1195534 | 2021-04-06 | Cherokee | South Carolina | 45021 | 5806 | 148 |
1195535 | 1195535 | 2021-04-06 | Chester | South Carolina | 45023 | 3989 | 71 |
1195536 | 1195536 | 2021-04-06 | Chesterfield | South Carolina | 45025 | 4598 | 98 |
1195537 | 1195537 | 2021-04-06 | Clarendon | South Carolina | 45027 | 3308 | 107 |
1195538 | 1195538 | 2021-04-06 | Colleton | South Carolina | 45029 | 3417 | 122 |
1195539 | 1195539 | 2021-04-06 | Darlington | South Carolina | 45031 | 8162 | 172 |
1195540 | 1195540 | 2021-04-06 | Dillon | South Carolina | 45033 | 4262 | 81 |
1195541 | 1195541 | 2021-04-06 | Dorchester | South Carolina | 45035 | 16554 | 208 |
1195542 | 1195542 | 2021-04-06 | Edgefield | South Carolina | 45037 | 2987 | 41 |
1195543 | 1195543 | 2021-04-06 | Fairfield | South Carolina | 45039 | 2291 | 79 |
1195544 | 1195544 | 2021-04-06 | Florence | South Carolina | 45041 | 17228 | 397 |
1195545 | 1195545 | 2021-04-06 | Georgetown | South Carolina | 45043 | 6499 | 138 |
1195546 | 1195546 | 2021-04-06 | Greenville | South Carolina | 45045 | 70626 | 952 |
1195547 | 1195547 | 2021-04-06 | Greenwood | South Carolina | 45047 | 7731 | 167 |
1195548 | 1195548 | 2021-04-06 | Hampton | South Carolina | 45049 | 1858 | 48 |
1195549 | 1195549 | 2021-04-06 | Horry | South Carolina | 45051 | 37246 | 558 |
1195550 | 1195550 | 2021-04-06 | Jasper | South Carolina | 45053 | 2249 | 43 |
1195551 | 1195551 | 2021-04-06 | Kershaw | South Carolina | 45055 | 7117 | 134 |
1195552 | 1195552 | 2021-04-06 | Lancaster | South Carolina | 45057 | 10199 | 159 |
1195553 | 1195553 | 2021-04-06 | Laurens | South Carolina | 45059 | 6875 | 165 |
1195554 | 1195554 | 2021-04-06 | Lee | South Carolina | 45061 | 1839 | 59 |
1195555 | 1195555 | 2021-04-06 | Lexington | South Carolina | 45063 | 31884 | 471 |
1195556 | 1195556 | 2021-04-06 | Marion | South Carolina | 45067 | 3447 | 101 |
1195557 | 1195557 | 2021-04-06 | Marlboro | South Carolina | 45069 | 3142 | 51 |
1195558 | 1195558 | 2021-04-06 | McCormick | South Carolina | 45065 | 1000 | 27 |
1195559 | 1195559 | 2021-04-06 | Newberry | South Carolina | 45071 | 4710 | 97 |
1195560 | 1195560 | 2021-04-06 | Oconee | South Carolina | 45073 | 9046 | 131 |
1195561 | 1195561 | 2021-04-06 | Orangeburg | South Carolina | 45075 | 9378 | 236 |
1195562 | 1195562 | 2021-04-06 | Pickens | South Carolina | 45077 | 17762 | 282 |
1195563 | 1195563 | 2021-04-06 | Richland | South Carolina | 45079 | 44271 | 530 |
1195564 | 1195564 | 2021-04-06 | Saluda | South Carolina | 45081 | 1717 | 48 |
1195565 | 1195565 | 2021-04-06 | Spartanburg | South Carolina | 45083 | 39503 | 767 |
1195566 | 1195566 | 2021-04-06 | Sumter | South Carolina | 45085 | 10153 | 196 |
1195567 | 1195567 | 2021-04-06 | Union | South Carolina | 45087 | 2911 | 84 |
1195568 | 1195568 | 2021-04-06 | Williamsburg | South Carolina | 45089 | 3941 | 95 |
1195569 | 1195569 | 2021-04-06 | York | South Carolina | 45091 | 29018 | 364 |
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);