ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
47 rows where "date" is on date 2020-08-13 and state = "South Carolina" sorted by date
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 · 47 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
430183 | 430183 | 2020-08-13 | Abbeville | South Carolina | 45001 | 355 | 8 |
430184 | 430184 | 2020-08-13 | Aiken | South Carolina | 45003 | 2017 | 42 |
430185 | 430185 | 2020-08-13 | Allendale | South Carolina | 45005 | 242 | 6 |
430186 | 430186 | 2020-08-13 | Anderson | South Carolina | 45007 | 2489 | 70 |
430187 | 430187 | 2020-08-13 | Bamberg | South Carolina | 45009 | 482 | 26 |
430188 | 430188 | 2020-08-13 | Barnwell | South Carolina | 45011 | 439 | 8 |
430189 | 430189 | 2020-08-13 | Beaufort | South Carolina | 45013 | 4256 | 60 |
430190 | 430190 | 2020-08-13 | Berkeley | South Carolina | 45015 | 4324 | 70 |
430191 | 430191 | 2020-08-13 | Calhoun | South Carolina | 45017 | 384 | 13 |
430192 | 430192 | 2020-08-13 | Charleston | South Carolina | 45019 | 12631 | 209 |
430193 | 430193 | 2020-08-13 | Cherokee | South Carolina | 45021 | 692 | 31 |
430194 | 430194 | 2020-08-13 | Chester | South Carolina | 45023 | 716 | 14 |
430195 | 430195 | 2020-08-13 | Chesterfield | South Carolina | 45025 | 803 | 22 |
430196 | 430196 | 2020-08-13 | Clarendon | South Carolina | 45027 | 874 | 55 |
430197 | 430197 | 2020-08-13 | Colleton | South Carolina | 45029 | 837 | 34 |
430198 | 430198 | 2020-08-13 | Darlington | South Carolina | 45031 | 1362 | 36 |
430199 | 430199 | 2020-08-13 | Dillon | South Carolina | 45033 | 661 | 25 |
430200 | 430200 | 2020-08-13 | Dorchester | South Carolina | 45035 | 3176 | 53 |
430201 | 430201 | 2020-08-13 | Edgefield | South Carolina | 45037 | 349 | 7 |
430202 | 430202 | 2020-08-13 | Fairfield | South Carolina | 45039 | 578 | 24 |
430203 | 430203 | 2020-08-13 | Florence | South Carolina | 45041 | 3614 | 123 |
430204 | 430204 | 2020-08-13 | Georgetown | South Carolina | 45043 | 1498 | 25 |
430205 | 430205 | 2020-08-13 | Greenville | South Carolina | 45045 | 11109 | 222 |
430206 | 430206 | 2020-08-13 | Greenwood | South Carolina | 45047 | 1489 | 20 |
430207 | 430207 | 2020-08-13 | Hampton | South Carolina | 45049 | 457 | 13 |
430208 | 430208 | 2020-08-13 | Horry | South Carolina | 45051 | 8743 | 167 |
430209 | 430209 | 2020-08-13 | Jasper | South Carolina | 45053 | 611 | 18 |
430210 | 430210 | 2020-08-13 | Kershaw | South Carolina | 45055 | 1425 | 27 |
430211 | 430211 | 2020-08-13 | Lancaster | South Carolina | 45057 | 1297 | 27 |
430212 | 430212 | 2020-08-13 | Laurens | South Carolina | 45059 | 1354 | 47 |
430213 | 430213 | 2020-08-13 | Lee | South Carolina | 45061 | 564 | 30 |
430214 | 430214 | 2020-08-13 | Lexington | South Carolina | 45063 | 5078 | 116 |
430215 | 430215 | 2020-08-13 | Marion | South Carolina | 45067 | 573 | 14 |
430216 | 430216 | 2020-08-13 | Marlboro | South Carolina | 45069 | 529 | 4 |
430217 | 430217 | 2020-08-13 | McCormick | South Carolina | 45065 | 131 | 2 |
430218 | 430218 | 2020-08-13 | Newberry | South Carolina | 45071 | 881 | 11 |
430219 | 430219 | 2020-08-13 | Oconee | South Carolina | 45073 | 854 | 12 |
430220 | 430220 | 2020-08-13 | Orangeburg | South Carolina | 45075 | 2494 | 70 |
430221 | 430221 | 2020-08-13 | Pickens | South Carolina | 45077 | 1897 | 27 |
430222 | 430222 | 2020-08-13 | Richland | South Carolina | 45079 | 9142 | 159 |
430223 | 430223 | 2020-08-13 | Saluda | South Carolina | 45081 | 469 | 9 |
430224 | 430224 | 2020-08-13 | Spartanburg | South Carolina | 45083 | 4299 | 111 |
430225 | 430225 | 2020-08-13 | Sumter | South Carolina | 45085 | 2604 | 53 |
430226 | 430226 | 2020-08-13 | Union | South Carolina | 45087 | 383 | 4 |
430227 | 430227 | 2020-08-13 | Unknown | South Carolina | 0 | 2 | |
430228 | 430228 | 2020-08-13 | Williamsburg | South Carolina | 45089 | 1042 | 31 |
430229 | 430229 | 2020-08-13 | York | South Carolina | 45091 | 3705 | 29 |
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);