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-24 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 |
---|---|---|---|---|---|---|---|
565969 | 565969 | 2020-09-24 | Abbeville | South Carolina | 45001 | 553 | 12 |
565970 | 565970 | 2020-09-24 | Aiken | South Carolina | 45003 | 4053 | 80 |
565971 | 565971 | 2020-09-24 | Allendale | South Carolina | 45005 | 378 | 6 |
565972 | 565972 | 2020-09-24 | Anderson | South Carolina | 45007 | 4277 | 171 |
565973 | 565973 | 2020-09-24 | Bamberg | South Carolina | 45009 | 635 | 33 |
565974 | 565974 | 2020-09-24 | Barnwell | South Carolina | 45011 | 681 | 16 |
565975 | 565975 | 2020-09-24 | Beaufort | South Carolina | 45013 | 5524 | 82 |
565976 | 565976 | 2020-09-24 | Berkeley | South Carolina | 45015 | 5407 | 88 |
565977 | 565977 | 2020-09-24 | Calhoun | South Carolina | 45017 | 447 | 17 |
565978 | 565978 | 2020-09-24 | Charleston | South Carolina | 45019 | 15682 | 261 |
565979 | 565979 | 2020-09-24 | Cherokee | South Carolina | 45021 | 1132 | 35 |
565980 | 565980 | 2020-09-24 | Chester | South Carolina | 45023 | 1021 | 21 |
565981 | 565981 | 2020-09-24 | Chesterfield | South Carolina | 45025 | 1206 | 36 |
565982 | 565982 | 2020-09-24 | Clarendon | South Carolina | 45027 | 1087 | 66 |
565983 | 565983 | 2020-09-24 | Colleton | South Carolina | 45029 | 1008 | 42 |
565984 | 565984 | 2020-09-24 | Darlington | South Carolina | 45031 | 2020 | 52 |
565985 | 565985 | 2020-09-24 | Dillon | South Carolina | 45033 | 1004 | 36 |
565986 | 565986 | 2020-09-24 | Dorchester | South Carolina | 45035 | 4089 | 88 |
565987 | 565987 | 2020-09-24 | Edgefield | South Carolina | 45037 | 801 | 17 |
565988 | 565988 | 2020-09-24 | Fairfield | South Carolina | 45039 | 759 | 34 |
565989 | 565989 | 2020-09-24 | Florence | South Carolina | 45041 | 4873 | 187 |
565990 | 565990 | 2020-09-24 | Georgetown | South Carolina | 45043 | 1875 | 45 |
565991 | 565991 | 2020-09-24 | Greenville | South Carolina | 45045 | 14076 | 299 |
565992 | 565992 | 2020-09-24 | Greenwood | South Carolina | 45047 | 2183 | 72 |
565993 | 565993 | 2020-09-24 | Hampton | South Carolina | 45049 | 632 | 25 |
565994 | 565994 | 2020-09-24 | Horry | South Carolina | 45051 | 10227 | 196 |
565995 | 565995 | 2020-09-24 | Jasper | South Carolina | 45053 | 790 | 20 |
565996 | 565996 | 2020-09-24 | Kershaw | South Carolina | 45055 | 1918 | 37 |
565997 | 565997 | 2020-09-24 | Lancaster | South Carolina | 45057 | 2111 | 49 |
565998 | 565998 | 2020-09-24 | Laurens | South Carolina | 45059 | 1634 | 56 |
565999 | 565999 | 2020-09-24 | Lee | South Carolina | 45061 | 705 | 34 |
566000 | 566000 | 2020-09-24 | Lexington | South Carolina | 45063 | 7012 | 157 |
566001 | 566001 | 2020-09-24 | Marion | South Carolina | 45067 | 857 | 23 |
566002 | 566002 | 2020-09-24 | Marlboro | South Carolina | 45069 | 903 | 11 |
566003 | 566003 | 2020-09-24 | McCormick | South Carolina | 45065 | 230 | 6 |
566004 | 566004 | 2020-09-24 | Newberry | South Carolina | 45071 | 1218 | 24 |
566005 | 566005 | 2020-09-24 | Oconee | South Carolina | 45073 | 1373 | 26 |
566006 | 566006 | 2020-09-24 | Orangeburg | South Carolina | 45075 | 3072 | 123 |
566007 | 566007 | 2020-09-24 | Pickens | South Carolina | 45077 | 2821 | 45 |
566008 | 566008 | 2020-09-24 | Richland | South Carolina | 45079 | 14833 | 234 |
566009 | 566009 | 2020-09-24 | Saluda | South Carolina | 45081 | 685 | 20 |
566010 | 566010 | 2020-09-24 | Spartanburg | South Carolina | 45083 | 6618 | 194 |
566011 | 566011 | 2020-09-24 | Sumter | South Carolina | 45085 | 3169 | 77 |
566012 | 566012 | 2020-09-24 | Union | South Carolina | 45087 | 560 | 12 |
566013 | 566013 | 2020-09-24 | Williamsburg | South Carolina | 45089 | 1325 | 44 |
566014 | 566014 | 2020-09-24 | York | South Carolina | 45091 | 5243 | 70 |
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);