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-01-19 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 |
---|---|---|---|---|---|---|---|
945569 | 945569 | 2021-01-19 | Abbeville | South Carolina | 45001 | 1510 | 27 |
945570 | 945570 | 2021-01-19 | Aiken | South Carolina | 45003 | 11380 | 154 |
945571 | 945571 | 2021-01-19 | Allendale | South Carolina | 45005 | 644 | 11 |
945572 | 945572 | 2021-01-19 | Anderson | South Carolina | 45007 | 15596 | 327 |
945573 | 945573 | 2021-01-19 | Bamberg | South Carolina | 45009 | 1142 | 43 |
945574 | 945574 | 2021-01-19 | Barnwell | South Carolina | 45011 | 1880 | 39 |
945575 | 945575 | 2021-01-19 | Beaufort | South Carolina | 45013 | 11829 | 126 |
945576 | 945576 | 2021-01-19 | Berkeley | South Carolina | 45015 | 11341 | 122 |
945577 | 945577 | 2021-01-19 | Calhoun | South Carolina | 45017 | 1006 | 26 |
945578 | 945578 | 2021-01-19 | Charleston | South Carolina | 45019 | 29418 | 353 |
945579 | 945579 | 2021-01-19 | Cherokee | South Carolina | 45021 | 3774 | 96 |
945580 | 945580 | 2021-01-19 | Chester | South Carolina | 45023 | 2882 | 48 |
945581 | 945581 | 2021-01-19 | Chesterfield | South Carolina | 45025 | 2968 | 70 |
945582 | 945582 | 2021-01-19 | Clarendon | South Carolina | 45027 | 2264 | 81 |
945583 | 945583 | 2021-01-19 | Colleton | South Carolina | 45029 | 2509 | 66 |
945584 | 945584 | 2021-01-19 | Darlington | South Carolina | 45031 | 6175 | 112 |
945585 | 945585 | 2021-01-19 | Dillon | South Carolina | 45033 | 3223 | 65 |
945586 | 945586 | 2021-01-19 | Dorchester | South Carolina | 45035 | 11021 | 133 |
945587 | 945587 | 2021-01-19 | Edgefield | South Carolina | 45037 | 1963 | 27 |
945588 | 945588 | 2021-01-19 | Fairfield | South Carolina | 45039 | 1690 | 58 |
945589 | 945589 | 2021-01-19 | Florence | South Carolina | 45041 | 13886 | 316 |
945590 | 945590 | 2021-01-19 | Georgetown | South Carolina | 45043 | 5004 | 103 |
945591 | 945591 | 2021-01-19 | Greenville | South Carolina | 45045 | 49626 | 625 |
945592 | 945592 | 2021-01-19 | Greenwood | South Carolina | 45047 | 5445 | 110 |
945593 | 945593 | 2021-01-19 | Hampton | South Carolina | 45049 | 1352 | 38 |
945594 | 945594 | 2021-01-19 | Horry | South Carolina | 45051 | 25959 | 386 |
945595 | 945595 | 2021-01-19 | Jasper | South Carolina | 45053 | 1654 | 28 |
945596 | 945596 | 2021-01-19 | Kershaw | South Carolina | 45055 | 4934 | 87 |
945597 | 945597 | 2021-01-19 | Lancaster | South Carolina | 45057 | 6914 | 103 |
945598 | 945598 | 2021-01-19 | Laurens | South Carolina | 45059 | 4819 | 106 |
945599 | 945599 | 2021-01-19 | Lee | South Carolina | 45061 | 1469 | 44 |
945600 | 945600 | 2021-01-19 | Lexington | South Carolina | 45063 | 22147 | 323 |
945601 | 945601 | 2021-01-19 | Marion | South Carolina | 45067 | 2680 | 82 |
945602 | 945602 | 2021-01-19 | Marlboro | South Carolina | 45069 | 2370 | 35 |
945603 | 945603 | 2021-01-19 | McCormick | South Carolina | 45065 | 596 | 11 |
945604 | 945604 | 2021-01-19 | Newberry | South Carolina | 45071 | 3491 | 77 |
945605 | 945605 | 2021-01-19 | Oconee | South Carolina | 45073 | 6739 | 81 |
945606 | 945606 | 2021-01-19 | Orangeburg | South Carolina | 45075 | 6730 | 168 |
945607 | 945607 | 2021-01-19 | Pickens | South Carolina | 45077 | 13541 | 186 |
945608 | 945608 | 2021-01-19 | Richland | South Carolina | 45079 | 32201 | 382 |
945609 | 945609 | 2021-01-19 | Saluda | South Carolina | 45081 | 1196 | 31 |
945610 | 945610 | 2021-01-19 | Spartanburg | South Carolina | 45083 | 25479 | 494 |
945611 | 945611 | 2021-01-19 | Sumter | South Carolina | 45085 | 7090 | 132 |
945612 | 945612 | 2021-01-19 | Union | South Carolina | 45087 | 1880 | 53 |
945613 | 945613 | 2021-01-19 | Williamsburg | South Carolina | 45089 | 2943 | 70 |
945614 | 945614 | 2021-01-19 | York | South Carolina | 45091 | 19958 | 204 |
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);