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-11-18 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 |
---|---|---|---|---|---|---|---|
744355 | 744355 | 2020-11-18 | Abbeville | South Carolina | 45001 | 882 | 19 |
744356 | 744356 | 2020-11-18 | Aiken | South Carolina | 45003 | 5840 | 95 |
744357 | 744357 | 2020-11-18 | Allendale | South Carolina | 45005 | 442 | 8 |
744358 | 744358 | 2020-11-18 | Anderson | South Carolina | 45007 | 7186 | 215 |
744359 | 744359 | 2020-11-18 | Bamberg | South Carolina | 45009 | 715 | 36 |
744360 | 744360 | 2020-11-18 | Barnwell | South Carolina | 45011 | 931 | 26 |
744361 | 744361 | 2020-11-18 | Beaufort | South Carolina | 45013 | 6693 | 94 |
744362 | 744362 | 2020-11-18 | Berkeley | South Carolina | 45015 | 6774 | 102 |
744363 | 744363 | 2020-11-18 | Calhoun | South Carolina | 45017 | 537 | 18 |
744364 | 744364 | 2020-11-18 | Charleston | South Carolina | 45019 | 18867 | 289 |
744365 | 744365 | 2020-11-18 | Cherokee | South Carolina | 45021 | 1878 | 59 |
744366 | 744366 | 2020-11-18 | Chester | South Carolina | 45023 | 1412 | 32 |
744367 | 744367 | 2020-11-18 | Chesterfield | South Carolina | 45025 | 1659 | 52 |
744368 | 744368 | 2020-11-18 | Clarendon | South Carolina | 45027 | 1300 | 69 |
744369 | 744369 | 2020-11-18 | Colleton | South Carolina | 45029 | 1424 | 49 |
744370 | 744370 | 2020-11-18 | Darlington | South Carolina | 45031 | 2847 | 70 |
744371 | 744371 | 2020-11-18 | Dillon | South Carolina | 45033 | 1455 | 51 |
744372 | 744372 | 2020-11-18 | Dorchester | South Carolina | 45035 | 5401 | 109 |
744373 | 744373 | 2020-11-18 | Edgefield | South Carolina | 45037 | 1083 | 22 |
744374 | 744374 | 2020-11-18 | Fairfield | South Carolina | 45039 | 987 | 41 |
744375 | 744375 | 2020-11-18 | Florence | South Carolina | 45041 | 6271 | 209 |
744376 | 744376 | 2020-11-18 | Georgetown | South Carolina | 45043 | 2635 | 63 |
744377 | 744377 | 2020-11-18 | Greenville | South Carolina | 45045 | 21343 | 378 |
744378 | 744378 | 2020-11-18 | Greenwood | South Carolina | 45047 | 2839 | 78 |
744379 | 744379 | 2020-11-18 | Hampton | South Carolina | 45049 | 827 | 32 |
744380 | 744380 | 2020-11-18 | Horry | South Carolina | 45051 | 13872 | 253 |
744381 | 744381 | 2020-11-18 | Jasper | South Carolina | 45053 | 1000 | 23 |
744382 | 744382 | 2020-11-18 | Kershaw | South Carolina | 45055 | 2787 | 58 |
744383 | 744383 | 2020-11-18 | Lancaster | South Carolina | 45057 | 3143 | 64 |
744384 | 744384 | 2020-11-18 | Laurens | South Carolina | 45059 | 2254 | 67 |
744385 | 744385 | 2020-11-18 | Lee | South Carolina | 45061 | 844 | 36 |
744386 | 744386 | 2020-11-18 | Lexington | South Carolina | 45063 | 10583 | 223 |
744387 | 744387 | 2020-11-18 | Marion | South Carolina | 45067 | 1269 | 46 |
744388 | 744388 | 2020-11-18 | Marlboro | South Carolina | 45069 | 1291 | 16 |
744389 | 744389 | 2020-11-18 | McCormick | South Carolina | 45065 | 309 | 7 |
744390 | 744390 | 2020-11-18 | Newberry | South Carolina | 45071 | 1988 | 62 |
744391 | 744391 | 2020-11-18 | Oconee | South Carolina | 45073 | 2888 | 37 |
744392 | 744392 | 2020-11-18 | Orangeburg | South Carolina | 45075 | 3598 | 133 |
744393 | 744393 | 2020-11-18 | Pickens | South Carolina | 45077 | 5504 | 74 |
744394 | 744394 | 2020-11-18 | Richland | South Carolina | 45079 | 19199 | 290 |
744395 | 744395 | 2020-11-18 | Saluda | South Carolina | 45081 | 771 | 25 |
744396 | 744396 | 2020-11-18 | Spartanburg | South Carolina | 45083 | 10967 | 258 |
744397 | 744397 | 2020-11-18 | Sumter | South Carolina | 45085 | 3950 | 97 |
744398 | 744398 | 2020-11-18 | Union | South Carolina | 45087 | 942 | 24 |
744399 | 744399 | 2020-11-18 | Williamsburg | South Carolina | 45089 | 1574 | 50 |
744400 | 744400 | 2020-11-18 | York | South Carolina | 45091 | 8486 | 123 |
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);