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-06 and state = "South Carolina" sorted by county
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 |
---|---|---|---|---|---|---|---|
407631 | 407631 | 2020-08-06 | Abbeville | South Carolina | 45001 | 313 | 8 |
407632 | 407632 | 2020-08-06 | Aiken | South Carolina | 45003 | 1788 | 33 |
407633 | 407633 | 2020-08-06 | Allendale | South Carolina | 45005 | 204 | 3 |
407634 | 407634 | 2020-08-06 | Anderson | South Carolina | 45007 | 2237 | 55 |
407635 | 407635 | 2020-08-06 | Bamberg | South Carolina | 45009 | 455 | 20 |
407636 | 407636 | 2020-08-06 | Barnwell | South Carolina | 45011 | 390 | 5 |
407637 | 407637 | 2020-08-06 | Beaufort | South Carolina | 45013 | 3921 | 54 |
407638 | 407638 | 2020-08-06 | Berkeley | South Carolina | 45015 | 4049 | 64 |
407639 | 407639 | 2020-08-06 | Calhoun | South Carolina | 45017 | 371 | 10 |
407640 | 407640 | 2020-08-06 | Charleston | South Carolina | 45019 | 12019 | 190 |
407641 | 407641 | 2020-08-06 | Cherokee | South Carolina | 45021 | 599 | 28 |
407642 | 407642 | 2020-08-06 | Chester | South Carolina | 45023 | 613 | 13 |
407643 | 407643 | 2020-08-06 | Chesterfield | South Carolina | 45025 | 729 | 21 |
407644 | 407644 | 2020-08-06 | Clarendon | South Carolina | 45027 | 817 | 51 |
407645 | 407645 | 2020-08-06 | Colleton | South Carolina | 45029 | 791 | 33 |
407646 | 407646 | 2020-08-06 | Darlington | South Carolina | 45031 | 1189 | 35 |
407647 | 407647 | 2020-08-06 | Dillon | South Carolina | 45033 | 607 | 24 |
407648 | 407648 | 2020-08-06 | Dorchester | South Carolina | 45035 | 2968 | 47 |
407649 | 407649 | 2020-08-06 | Edgefield | South Carolina | 45037 | 303 | 6 |
407650 | 407650 | 2020-08-06 | Fairfield | South Carolina | 45039 | 554 | 23 |
407651 | 407651 | 2020-08-06 | Florence | South Carolina | 45041 | 3258 | 108 |
407652 | 407652 | 2020-08-06 | Georgetown | South Carolina | 45043 | 1345 | 19 |
407653 | 407653 | 2020-08-06 | Greenville | South Carolina | 45045 | 10635 | 201 |
407654 | 407654 | 2020-08-06 | Greenwood | South Carolina | 45047 | 1336 | 17 |
407655 | 407655 | 2020-08-06 | Hampton | South Carolina | 45049 | 405 | 7 |
407656 | 407656 | 2020-08-06 | Horry | South Carolina | 45051 | 8371 | 145 |
407657 | 407657 | 2020-08-06 | Jasper | South Carolina | 45053 | 560 | 14 |
407658 | 407658 | 2020-08-06 | Kershaw | South Carolina | 45055 | 1357 | 23 |
407659 | 407659 | 2020-08-06 | Lancaster | South Carolina | 45057 | 1138 | 23 |
407660 | 407660 | 2020-08-06 | Laurens | South Carolina | 45059 | 1275 | 42 |
407661 | 407661 | 2020-08-06 | Lee | South Carolina | 45061 | 542 | 27 |
407662 | 407662 | 2020-08-06 | Lexington | South Carolina | 45063 | 4839 | 108 |
407663 | 407663 | 2020-08-06 | Marion | South Carolina | 45067 | 535 | 13 |
407664 | 407664 | 2020-08-06 | Marlboro | South Carolina | 45069 | 468 | 4 |
407665 | 407665 | 2020-08-06 | McCormick | South Carolina | 45065 | 108 | 2 |
407666 | 407666 | 2020-08-06 | Newberry | South Carolina | 45071 | 828 | 9 |
407667 | 407667 | 2020-08-06 | Oconee | South Carolina | 45073 | 787 | 8 |
407668 | 407668 | 2020-08-06 | Orangeburg | South Carolina | 45075 | 2304 | 61 |
407669 | 407669 | 2020-08-06 | Pickens | South Carolina | 45077 | 1793 | 26 |
407670 | 407670 | 2020-08-06 | Richland | South Carolina | 45079 | 8464 | 148 |
407671 | 407671 | 2020-08-06 | Saluda | South Carolina | 45081 | 443 | 8 |
407672 | 407672 | 2020-08-06 | Spartanburg | South Carolina | 45083 | 3961 | 98 |
407673 | 407673 | 2020-08-06 | Sumter | South Carolina | 45085 | 2419 | 47 |
407674 | 407674 | 2020-08-06 | Union | South Carolina | 45087 | 346 | 3 |
407675 | 407675 | 2020-08-06 | Unknown | South Carolina | 0 | 1 | |
407676 | 407676 | 2020-08-06 | Williamsburg | South Carolina | 45089 | 961 | 29 |
407677 | 407677 | 2020-08-06 | York | South Carolina | 45091 | 3402 | 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);