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-02-16 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 |
---|---|---|---|---|---|---|---|
1036445 | 1036445 | 2021-02-16 | Abbeville | South Carolina | 45001 | 2124 | 34 |
1036446 | 1036446 | 2021-02-16 | Aiken | South Carolina | 45003 | 14643 | 193 |
1036447 | 1036447 | 2021-02-16 | Allendale | South Carolina | 45005 | 790 | 14 |
1036448 | 1036448 | 2021-02-16 | Anderson | South Carolina | 45007 | 19211 | 432 |
1036449 | 1036449 | 2021-02-16 | Bamberg | South Carolina | 45009 | 1400 | 48 |
1036450 | 1036450 | 2021-02-16 | Barnwell | South Carolina | 45011 | 2264 | 46 |
1036451 | 1036451 | 2021-02-16 | Beaufort | South Carolina | 45013 | 14736 | 172 |
1036452 | 1036452 | 2021-02-16 | Berkeley | South Carolina | 45015 | 14173 | 160 |
1036453 | 1036453 | 2021-02-16 | Calhoun | South Carolina | 45017 | 1186 | 35 |
1036454 | 1036454 | 2021-02-16 | Charleston | South Carolina | 45019 | 36497 | 428 |
1036455 | 1036455 | 2021-02-16 | Cherokee | South Carolina | 45021 | 5136 | 126 |
1036456 | 1036456 | 2021-02-16 | Chester | South Carolina | 45023 | 3474 | 62 |
1036457 | 1036457 | 2021-02-16 | Chesterfield | South Carolina | 45025 | 4002 | 91 |
1036458 | 1036458 | 2021-02-16 | Clarendon | South Carolina | 45027 | 2820 | 93 |
1036459 | 1036459 | 2021-02-16 | Colleton | South Carolina | 45029 | 3097 | 106 |
1036460 | 1036460 | 2021-02-16 | Darlington | South Carolina | 45031 | 7588 | 153 |
1036461 | 1036461 | 2021-02-16 | Dillon | South Carolina | 45033 | 3811 | 76 |
1036462 | 1036462 | 2021-02-16 | Dorchester | South Carolina | 45035 | 14323 | 171 |
1036463 | 1036463 | 2021-02-16 | Edgefield | South Carolina | 45037 | 2584 | 34 |
1036464 | 1036464 | 2021-02-16 | Fairfield | South Carolina | 45039 | 2020 | 68 |
1036465 | 1036465 | 2021-02-16 | Florence | South Carolina | 45041 | 16151 | 372 |
1036466 | 1036466 | 2021-02-16 | Georgetown | South Carolina | 45043 | 5992 | 132 |
1036467 | 1036467 | 2021-02-16 | Greenville | South Carolina | 45045 | 61269 | 813 |
1036468 | 1036468 | 2021-02-16 | Greenwood | South Carolina | 45047 | 6785 | 153 |
1036469 | 1036469 | 2021-02-16 | Hampton | South Carolina | 45049 | 1616 | 41 |
1036470 | 1036470 | 2021-02-16 | Horry | South Carolina | 45051 | 32560 | 502 |
1036471 | 1036471 | 2021-02-16 | Jasper | South Carolina | 45053 | 2085 | 41 |
1036472 | 1036472 | 2021-02-16 | Kershaw | South Carolina | 45055 | 6270 | 109 |
1036473 | 1036473 | 2021-02-16 | Lancaster | South Carolina | 45057 | 8887 | 126 |
1036474 | 1036474 | 2021-02-16 | Laurens | South Carolina | 45059 | 6055 | 149 |
1036475 | 1036475 | 2021-02-16 | Lee | South Carolina | 45061 | 1729 | 53 |
1036476 | 1036476 | 2021-02-16 | Lexington | South Carolina | 45063 | 27731 | 413 |
1036477 | 1036477 | 2021-02-16 | Marion | South Carolina | 45067 | 3158 | 94 |
1036478 | 1036478 | 2021-02-16 | Marlboro | South Carolina | 45069 | 2879 | 50 |
1036479 | 1036479 | 2021-02-16 | McCormick | South Carolina | 45065 | 866 | 23 |
1036480 | 1036480 | 2021-02-16 | Newberry | South Carolina | 45071 | 4123 | 92 |
1036481 | 1036481 | 2021-02-16 | Oconee | South Carolina | 45073 | 8130 | 116 |
1036482 | 1036482 | 2021-02-16 | Orangeburg | South Carolina | 45075 | 8350 | 206 |
1036483 | 1036483 | 2021-02-16 | Pickens | South Carolina | 45077 | 15703 | 254 |
1036484 | 1036484 | 2021-02-16 | Richland | South Carolina | 45079 | 39097 | 473 |
1036485 | 1036485 | 2021-02-16 | Saluda | South Carolina | 45081 | 1526 | 42 |
1036486 | 1036486 | 2021-02-16 | Spartanburg | South Carolina | 45083 | 33932 | 644 |
1036487 | 1036487 | 2021-02-16 | Sumter | South Carolina | 45085 | 8948 | 161 |
1036488 | 1036488 | 2021-02-16 | Union | South Carolina | 45087 | 2461 | 70 |
1036489 | 1036489 | 2021-02-16 | Williamsburg | South Carolina | 45089 | 3603 | 84 |
1036490 | 1036490 | 2021-02-16 | York | South Carolina | 45091 | 24668 | 300 |
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);