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-17 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 |
---|---|---|---|---|---|---|---|
939077 | 939077 | 2021-01-17 | Abbeville | South Carolina | 45001 | 1495 | 27 |
939078 | 939078 | 2021-01-17 | Aiken | South Carolina | 45003 | 11139 | 153 |
939079 | 939079 | 2021-01-17 | Allendale | South Carolina | 45005 | 625 | 11 |
939080 | 939080 | 2021-01-17 | Anderson | South Carolina | 45007 | 15353 | 327 |
939081 | 939081 | 2021-01-17 | Bamberg | South Carolina | 45009 | 1121 | 43 |
939082 | 939082 | 2021-01-17 | Barnwell | South Carolina | 45011 | 1841 | 39 |
939083 | 939083 | 2021-01-17 | Beaufort | South Carolina | 45013 | 11691 | 126 |
939084 | 939084 | 2021-01-17 | Berkeley | South Carolina | 45015 | 11182 | 121 |
939085 | 939085 | 2021-01-17 | Calhoun | South Carolina | 45017 | 997 | 25 |
939086 | 939086 | 2021-01-17 | Charleston | South Carolina | 45019 | 29043 | 352 |
939087 | 939087 | 2021-01-17 | Cherokee | South Carolina | 45021 | 3744 | 96 |
939088 | 939088 | 2021-01-17 | Chester | South Carolina | 45023 | 2809 | 48 |
939089 | 939089 | 2021-01-17 | Chesterfield | South Carolina | 45025 | 2933 | 70 |
939090 | 939090 | 2021-01-17 | Clarendon | South Carolina | 45027 | 2215 | 81 |
939091 | 939091 | 2021-01-17 | Colleton | South Carolina | 45029 | 2464 | 66 |
939092 | 939092 | 2021-01-17 | Darlington | South Carolina | 45031 | 6029 | 112 |
939093 | 939093 | 2021-01-17 | Dillon | South Carolina | 45033 | 3139 | 65 |
939094 | 939094 | 2021-01-17 | Dorchester | South Carolina | 45035 | 10801 | 132 |
939095 | 939095 | 2021-01-17 | Edgefield | South Carolina | 45037 | 1933 | 27 |
939096 | 939096 | 2021-01-17 | Fairfield | South Carolina | 45039 | 1671 | 58 |
939097 | 939097 | 2021-01-17 | Florence | South Carolina | 45041 | 13639 | 313 |
939098 | 939098 | 2021-01-17 | Georgetown | South Carolina | 45043 | 4919 | 103 |
939099 | 939099 | 2021-01-17 | Greenville | South Carolina | 45045 | 48934 | 625 |
939100 | 939100 | 2021-01-17 | Greenwood | South Carolina | 45047 | 5332 | 110 |
939101 | 939101 | 2021-01-17 | Hampton | South Carolina | 45049 | 1331 | 38 |
939102 | 939102 | 2021-01-17 | Horry | South Carolina | 45051 | 25610 | 385 |
939103 | 939103 | 2021-01-17 | Jasper | South Carolina | 45053 | 1648 | 28 |
939104 | 939104 | 2021-01-17 | Kershaw | South Carolina | 45055 | 4854 | 87 |
939105 | 939105 | 2021-01-17 | Lancaster | South Carolina | 45057 | 6789 | 103 |
939106 | 939106 | 2021-01-17 | Laurens | South Carolina | 45059 | 4713 | 106 |
939107 | 939107 | 2021-01-17 | Lee | South Carolina | 45061 | 1442 | 44 |
939108 | 939108 | 2021-01-17 | Lexington | South Carolina | 45063 | 21739 | 321 |
939109 | 939109 | 2021-01-17 | Marion | South Carolina | 45067 | 2624 | 82 |
939110 | 939110 | 2021-01-17 | Marlboro | South Carolina | 45069 | 2343 | 35 |
939111 | 939111 | 2021-01-17 | McCormick | South Carolina | 45065 | 583 | 11 |
939112 | 939112 | 2021-01-17 | Newberry | South Carolina | 45071 | 3435 | 76 |
939113 | 939113 | 2021-01-17 | Oconee | South Carolina | 45073 | 6659 | 81 |
939114 | 939114 | 2021-01-17 | Orangeburg | South Carolina | 45075 | 6578 | 165 |
939115 | 939115 | 2021-01-17 | Pickens | South Carolina | 45077 | 13302 | 186 |
939116 | 939116 | 2021-01-17 | Richland | South Carolina | 45079 | 31831 | 377 |
939117 | 939117 | 2021-01-17 | Saluda | South Carolina | 45081 | 1181 | 30 |
939118 | 939118 | 2021-01-17 | Spartanburg | South Carolina | 45083 | 25167 | 494 |
939119 | 939119 | 2021-01-17 | Sumter | South Carolina | 45085 | 6986 | 132 |
939120 | 939120 | 2021-01-17 | Union | South Carolina | 45087 | 1860 | 53 |
939121 | 939121 | 2021-01-17 | Williamsburg | South Carolina | 45089 | 2905 | 69 |
939122 | 939122 | 2021-01-17 | York | South Carolina | 45091 | 19555 | 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);