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-09-27 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 |
---|---|---|---|---|---|---|---|
575696 | 575696 | 2020-09-27 | Abbeville | South Carolina | 45001 | 579 | 12 |
575697 | 575697 | 2020-09-27 | Aiken | South Carolina | 45003 | 4149 | 82 |
575698 | 575698 | 2020-09-27 | Allendale | South Carolina | 45005 | 383 | 6 |
575699 | 575699 | 2020-09-27 | Anderson | South Carolina | 45007 | 4463 | 176 |
575700 | 575700 | 2020-09-27 | Bamberg | South Carolina | 45009 | 645 | 33 |
575701 | 575701 | 2020-09-27 | Barnwell | South Carolina | 45011 | 709 | 16 |
575702 | 575702 | 2020-09-27 | Beaufort | South Carolina | 45013 | 5622 | 83 |
575703 | 575703 | 2020-09-27 | Berkeley | South Carolina | 45015 | 5512 | 88 |
575704 | 575704 | 2020-09-27 | Calhoun | South Carolina | 45017 | 454 | 17 |
575705 | 575705 | 2020-09-27 | Charleston | South Carolina | 45019 | 15817 | 260 |
575706 | 575706 | 2020-09-27 | Cherokee | South Carolina | 45021 | 1163 | 36 |
575707 | 575707 | 2020-09-27 | Chester | South Carolina | 45023 | 1043 | 21 |
575708 | 575708 | 2020-09-27 | Chesterfield | South Carolina | 45025 | 1230 | 37 |
575709 | 575709 | 2020-09-27 | Clarendon | South Carolina | 45027 | 1101 | 66 |
575710 | 575710 | 2020-09-27 | Colleton | South Carolina | 45029 | 1031 | 42 |
575711 | 575711 | 2020-09-27 | Darlington | South Carolina | 45031 | 2056 | 53 |
575712 | 575712 | 2020-09-27 | Dillon | South Carolina | 45033 | 1039 | 37 |
575713 | 575713 | 2020-09-27 | Dorchester | South Carolina | 45035 | 4173 | 91 |
575714 | 575714 | 2020-09-27 | Edgefield | South Carolina | 45037 | 814 | 18 |
575715 | 575715 | 2020-09-27 | Fairfield | South Carolina | 45039 | 765 | 35 |
575716 | 575716 | 2020-09-27 | Florence | South Carolina | 45041 | 4931 | 190 |
575717 | 575717 | 2020-09-27 | Georgetown | South Carolina | 45043 | 1893 | 45 |
575718 | 575718 | 2020-09-27 | Greenville | South Carolina | 45045 | 14356 | 299 |
575719 | 575719 | 2020-09-27 | Greenwood | South Carolina | 45047 | 2213 | 72 |
575720 | 575720 | 2020-09-27 | Hampton | South Carolina | 45049 | 645 | 26 |
575721 | 575721 | 2020-09-27 | Horry | South Carolina | 45051 | 10353 | 196 |
575722 | 575722 | 2020-09-27 | Jasper | South Carolina | 45053 | 814 | 20 |
575723 | 575723 | 2020-09-27 | Kershaw | South Carolina | 45055 | 1985 | 37 |
575724 | 575724 | 2020-09-27 | Lancaster | South Carolina | 45057 | 2167 | 52 |
575725 | 575725 | 2020-09-27 | Laurens | South Carolina | 45059 | 1676 | 56 |
575726 | 575726 | 2020-09-27 | Lee | South Carolina | 45061 | 719 | 34 |
575727 | 575727 | 2020-09-27 | Lexington | South Carolina | 45063 | 7278 | 158 |
575728 | 575728 | 2020-09-27 | Marion | South Carolina | 45067 | 881 | 24 |
575729 | 575729 | 2020-09-27 | Marlboro | South Carolina | 45069 | 932 | 11 |
575730 | 575730 | 2020-09-27 | McCormick | South Carolina | 45065 | 234 | 6 |
575731 | 575731 | 2020-09-27 | Newberry | South Carolina | 45071 | 1249 | 27 |
575732 | 575732 | 2020-09-27 | Oconee | South Carolina | 45073 | 1419 | 26 |
575733 | 575733 | 2020-09-27 | Orangeburg | South Carolina | 45075 | 3115 | 126 |
575734 | 575734 | 2020-09-27 | Pickens | South Carolina | 45077 | 2937 | 45 |
575735 | 575735 | 2020-09-27 | Richland | South Carolina | 45079 | 15250 | 240 |
575736 | 575736 | 2020-09-27 | Saluda | South Carolina | 45081 | 689 | 21 |
575737 | 575737 | 2020-09-27 | Spartanburg | South Carolina | 45083 | 6917 | 198 |
575738 | 575738 | 2020-09-27 | Sumter | South Carolina | 45085 | 3215 | 77 |
575739 | 575739 | 2020-09-27 | Union | South Carolina | 45087 | 565 | 12 |
575740 | 575740 | 2020-09-27 | Williamsburg | South Carolina | 45089 | 1335 | 44 |
575741 | 575741 | 2020-09-27 | York | South Carolina | 45091 | 5371 | 75 |
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);