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-12-30 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 |
---|---|---|---|---|---|---|---|
880661 | 880661 | 2020-12-30 | Abbeville | South Carolina | 45001 | 1265 | 24 |
880662 | 880662 | 2020-12-30 | Aiken | South Carolina | 45003 | 9036 | 133 |
880663 | 880663 | 2020-12-30 | Allendale | South Carolina | 45005 | 507 | 9 |
880664 | 880664 | 2020-12-30 | Anderson | South Carolina | 45007 | 11889 | 278 |
880665 | 880665 | 2020-12-30 | Bamberg | South Carolina | 45009 | 948 | 39 |
880666 | 880666 | 2020-12-30 | Barnwell | South Carolina | 45011 | 1437 | 30 |
880667 | 880667 | 2020-12-30 | Beaufort | South Carolina | 45013 | 9429 | 104 |
880668 | 880668 | 2020-12-30 | Berkeley | South Carolina | 45015 | 9003 | 110 |
880669 | 880669 | 2020-12-30 | Calhoun | South Carolina | 45017 | 796 | 20 |
880670 | 880670 | 2020-12-30 | Charleston | South Carolina | 45019 | 23874 | 320 |
880671 | 880671 | 2020-12-30 | Cherokee | South Carolina | 45021 | 3014 | 77 |
880672 | 880672 | 2020-12-30 | Chester | South Carolina | 45023 | 2219 | 45 |
880673 | 880673 | 2020-12-30 | Chesterfield | South Carolina | 45025 | 2307 | 60 |
880674 | 880674 | 2020-12-30 | Clarendon | South Carolina | 45027 | 1804 | 74 |
880675 | 880675 | 2020-12-30 | Colleton | South Carolina | 45029 | 1900 | 54 |
880676 | 880676 | 2020-12-30 | Darlington | South Carolina | 45031 | 4495 | 91 |
880677 | 880677 | 2020-12-30 | Dillon | South Carolina | 45033 | 2329 | 59 |
880678 | 880678 | 2020-12-30 | Dorchester | South Carolina | 45035 | 8181 | 127 |
880679 | 880679 | 2020-12-30 | Edgefield | South Carolina | 45037 | 1534 | 26 |
880680 | 880680 | 2020-12-30 | Fairfield | South Carolina | 45039 | 1355 | 53 |
880681 | 880681 | 2020-12-30 | Florence | South Carolina | 45041 | 10361 | 257 |
880682 | 880682 | 2020-12-30 | Georgetown | South Carolina | 45043 | 3888 | 78 |
880683 | 880683 | 2020-12-30 | Greenville | South Carolina | 45045 | 36838 | 501 |
880684 | 880684 | 2020-12-30 | Greenwood | South Carolina | 45047 | 4205 | 93 |
880685 | 880685 | 2020-12-30 | Hampton | South Carolina | 45049 | 1074 | 36 |
880686 | 880686 | 2020-12-30 | Horry | South Carolina | 45051 | 20062 | 312 |
880687 | 880687 | 2020-12-30 | Jasper | South Carolina | 45053 | 1326 | 25 |
880688 | 880688 | 2020-12-30 | Kershaw | South Carolina | 45055 | 3846 | 73 |
880689 | 880689 | 2020-12-30 | Lancaster | South Carolina | 45057 | 5158 | 83 |
880690 | 880690 | 2020-12-30 | Laurens | South Carolina | 45059 | 3563 | 81 |
880691 | 880691 | 2020-12-30 | Lee | South Carolina | 45061 | 1185 | 41 |
880692 | 880692 | 2020-12-30 | Lexington | South Carolina | 45063 | 16446 | 269 |
880693 | 880693 | 2020-12-30 | Marion | South Carolina | 45067 | 1931 | 63 |
880694 | 880694 | 2020-12-30 | Marlboro | South Carolina | 45069 | 1886 | 27 |
880695 | 880695 | 2020-12-30 | McCormick | South Carolina | 45065 | 470 | 9 |
880696 | 880696 | 2020-12-30 | Newberry | South Carolina | 45071 | 2766 | 71 |
880697 | 880697 | 2020-12-30 | Oconee | South Carolina | 45073 | 5192 | 61 |
880698 | 880698 | 2020-12-30 | Orangeburg | South Carolina | 45075 | 5032 | 147 |
880699 | 880699 | 2020-12-30 | Pickens | South Carolina | 45077 | 10131 | 146 |
880700 | 880700 | 2020-12-30 | Richland | South Carolina | 45079 | 26050 | 334 |
880701 | 880701 | 2020-12-30 | Saluda | South Carolina | 45081 | 988 | 28 |
880702 | 880702 | 2020-12-30 | Spartanburg | South Carolina | 45083 | 19613 | 388 |
880703 | 880703 | 2020-12-30 | Sumter | South Carolina | 45085 | 5477 | 115 |
880704 | 880704 | 2020-12-30 | Union | South Carolina | 45087 | 1542 | 39 |
880705 | 880705 | 2020-12-30 | Williamsburg | South Carolina | 45089 | 2184 | 61 |
880706 | 880706 | 2020-12-30 | York | South Carolina | 45091 | 14939 | 178 |
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);