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 2020-12-26 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 |
---|---|---|---|---|---|---|---|
867681 | 867681 | 2020-12-26 | Abbeville | South Carolina | 45001 | 1228 | 24 |
867682 | 867682 | 2020-12-26 | Aiken | South Carolina | 45003 | 8665 | 131 |
867683 | 867683 | 2020-12-26 | Allendale | South Carolina | 45005 | 499 | 9 |
867684 | 867684 | 2020-12-26 | Anderson | South Carolina | 45007 | 11235 | 275 |
867685 | 867685 | 2020-12-26 | Bamberg | South Carolina | 45009 | 903 | 38 |
867686 | 867686 | 2020-12-26 | Barnwell | South Carolina | 45011 | 1331 | 27 |
867687 | 867687 | 2020-12-26 | Beaufort | South Carolina | 45013 | 9051 | 99 |
867688 | 867688 | 2020-12-26 | Berkeley | South Carolina | 45015 | 8687 | 110 |
867689 | 867689 | 2020-12-26 | Calhoun | South Carolina | 45017 | 755 | 19 |
867690 | 867690 | 2020-12-26 | Charleston | South Carolina | 45019 | 23221 | 320 |
867691 | 867691 | 2020-12-26 | Cherokee | South Carolina | 45021 | 2872 | 76 |
867692 | 867692 | 2020-12-26 | Chester | South Carolina | 45023 | 2103 | 45 |
867693 | 867693 | 2020-12-26 | Chesterfield | South Carolina | 45025 | 2217 | 58 |
867694 | 867694 | 2020-12-26 | Clarendon | South Carolina | 45027 | 1720 | 74 |
867695 | 867695 | 2020-12-26 | Colleton | South Carolina | 45029 | 1815 | 54 |
867696 | 867696 | 2020-12-26 | Darlington | South Carolina | 45031 | 4260 | 87 |
867697 | 867697 | 2020-12-26 | Dillon | South Carolina | 45033 | 2223 | 58 |
867698 | 867698 | 2020-12-26 | Dorchester | South Carolina | 45035 | 7761 | 125 |
867699 | 867699 | 2020-12-26 | Edgefield | South Carolina | 45037 | 1500 | 26 |
867700 | 867700 | 2020-12-26 | Fairfield | South Carolina | 45039 | 1309 | 51 |
867701 | 867701 | 2020-12-26 | Florence | South Carolina | 45041 | 9624 | 246 |
867702 | 867702 | 2020-12-26 | Georgetown | South Carolina | 45043 | 3703 | 77 |
867703 | 867703 | 2020-12-26 | Greenville | South Carolina | 45045 | 34541 | 480 |
867704 | 867704 | 2020-12-26 | Greenwood | South Carolina | 45047 | 4023 | 92 |
867705 | 867705 | 2020-12-26 | Hampton | South Carolina | 45049 | 1042 | 36 |
867706 | 867706 | 2020-12-26 | Horry | South Carolina | 45051 | 19022 | 306 |
867707 | 867707 | 2020-12-26 | Jasper | South Carolina | 45053 | 1278 | 25 |
867708 | 867708 | 2020-12-26 | Kershaw | South Carolina | 45055 | 3705 | 73 |
867709 | 867709 | 2020-12-26 | Lancaster | South Carolina | 45057 | 4901 | 81 |
867710 | 867710 | 2020-12-26 | Laurens | South Carolina | 45059 | 3336 | 78 |
867711 | 867711 | 2020-12-26 | Lee | South Carolina | 45061 | 1135 | 41 |
867712 | 867712 | 2020-12-26 | Lexington | South Carolina | 45063 | 15478 | 262 |
867713 | 867713 | 2020-12-26 | Marion | South Carolina | 45067 | 1816 | 60 |
867714 | 867714 | 2020-12-26 | Marlboro | South Carolina | 45069 | 1812 | 27 |
867715 | 867715 | 2020-12-26 | McCormick | South Carolina | 45065 | 452 | 9 |
867716 | 867716 | 2020-12-26 | Newberry | South Carolina | 45071 | 2707 | 71 |
867717 | 867717 | 2020-12-26 | Oconee | South Carolina | 45073 | 4923 | 60 |
867718 | 867718 | 2020-12-26 | Orangeburg | South Carolina | 45075 | 4768 | 146 |
867719 | 867719 | 2020-12-26 | Pickens | South Carolina | 45077 | 9551 | 137 |
867720 | 867720 | 2020-12-26 | Richland | South Carolina | 45079 | 25200 | 327 |
867721 | 867721 | 2020-12-26 | Saluda | South Carolina | 45081 | 958 | 27 |
867722 | 867722 | 2020-12-26 | Spartanburg | South Carolina | 45083 | 18477 | 366 |
867723 | 867723 | 2020-12-26 | Sumter | South Carolina | 45085 | 5267 | 114 |
867724 | 867724 | 2020-12-26 | Union | South Carolina | 45087 | 1479 | 39 |
867725 | 867725 | 2020-12-26 | Williamsburg | South Carolina | 45089 | 2060 | 60 |
867726 | 867726 | 2020-12-26 | York | South Carolina | 45091 | 14279 | 178 |
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);