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-04-28 and state = "South Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
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 |
---|---|---|---|---|---|---|---|
97425 | 97425 | 2020-04-28 | Abbeville | South Carolina | 45001 | 29 | 0 |
97426 | 97426 | 2020-04-28 | Aiken | South Carolina | 45003 | 94 | 6 |
97427 | 97427 | 2020-04-28 | Allendale | South Carolina | 45005 | 10 | 1 |
97428 | 97428 | 2020-04-28 | Anderson | South Carolina | 45007 | 152 | 6 |
97429 | 97429 | 2020-04-28 | Bamberg | South Carolina | 45009 | 9 | 0 |
97430 | 97430 | 2020-04-28 | Barnwell | South Carolina | 45011 | 17 | 0 |
97431 | 97431 | 2020-04-28 | Beaufort | South Carolina | 45013 | 259 | 10 |
97432 | 97432 | 2020-04-28 | Berkeley | South Carolina | 45015 | 174 | 9 |
97433 | 97433 | 2020-04-28 | Calhoun | South Carolina | 45017 | 6 | 1 |
97434 | 97434 | 2020-04-28 | Charleston | South Carolina | 45019 | 438 | 7 |
97435 | 97435 | 2020-04-28 | Cherokee | South Carolina | 45021 | 15 | 0 |
97436 | 97436 | 2020-04-28 | Chester | South Carolina | 45023 | 27 | 0 |
97437 | 97437 | 2020-04-28 | Chesterfield | South Carolina | 45025 | 47 | 0 |
97438 | 97438 | 2020-04-28 | Clarendon | South Carolina | 45027 | 194 | 14 |
97439 | 97439 | 2020-04-28 | Colleton | South Carolina | 45029 | 26 | 4 |
97440 | 97440 | 2020-04-28 | Darlington | South Carolina | 45031 | 110 | 2 |
97441 | 97441 | 2020-04-28 | Dillon | South Carolina | 45033 | 44 | 0 |
97442 | 97442 | 2020-04-28 | Dorchester | South Carolina | 45035 | 91 | 2 |
97443 | 97443 | 2020-04-28 | Edgefield | South Carolina | 45037 | 26 | 1 |
97444 | 97444 | 2020-04-28 | Fairfield | South Carolina | 45039 | 33 | 2 |
97445 | 97445 | 2020-04-28 | Florence | South Carolina | 45041 | 273 | 10 |
97446 | 97446 | 2020-04-28 | Georgetown | South Carolina | 45043 | 40 | 2 |
97447 | 97447 | 2020-04-28 | Greenville | South Carolina | 45045 | 661 | 22 |
97448 | 97448 | 2020-04-28 | Greenwood | South Carolina | 45047 | 46 | 0 |
97449 | 97449 | 2020-04-28 | Hampton | South Carolina | 45049 | 22 | 0 |
97450 | 97450 | 2020-04-28 | Horry | South Carolina | 45051 | 211 | 15 |
97451 | 97451 | 2020-04-28 | Jasper | South Carolina | 45053 | 19 | 1 |
97452 | 97452 | 2020-04-28 | Kershaw | South Carolina | 45055 | 229 | 10 |
97453 | 97453 | 2020-04-28 | Lancaster | South Carolina | 45057 | 90 | 4 |
97454 | 97454 | 2020-04-28 | Laurens | South Carolina | 45059 | 38 | 1 |
97455 | 97455 | 2020-04-28 | Lee | South Carolina | 45061 | 58 | 7 |
97456 | 97456 | 2020-04-28 | Lexington | South Carolina | 45063 | 347 | 12 |
97457 | 97457 | 2020-04-28 | Marion | South Carolina | 45067 | 32 | 1 |
97458 | 97458 | 2020-04-28 | Marlboro | South Carolina | 45069 | 42 | 0 |
97459 | 97459 | 2020-04-28 | McCormick | South Carolina | 45065 | 6 | 1 |
97460 | 97460 | 2020-04-28 | Newberry | South Carolina | 45071 | 23 | 1 |
97461 | 97461 | 2020-04-28 | Oconee | South Carolina | 45073 | 24 | 0 |
97462 | 97462 | 2020-04-28 | Orangeburg | South Carolina | 45075 | 63 | 1 |
97463 | 97463 | 2020-04-28 | Pickens | South Carolina | 45077 | 54 | 0 |
97464 | 97464 | 2020-04-28 | Richland | South Carolina | 45079 | 864 | 21 |
97465 | 97465 | 2020-04-28 | Saluda | South Carolina | 45081 | 41 | 0 |
97466 | 97466 | 2020-04-28 | Spartanburg | South Carolina | 45083 | 258 | 8 |
97467 | 97467 | 2020-04-28 | Sumter | South Carolina | 45085 | 220 | 7 |
97468 | 97468 | 2020-04-28 | Union | South Carolina | 45087 | 25 | 0 |
97469 | 97469 | 2020-04-28 | Williamsburg | South Carolina | 45089 | 60 | 0 |
97470 | 97470 | 2020-04-28 | York | South Carolina | 45091 | 188 | 3 |
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);