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 2021-07-18 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 |
---|---|---|---|---|---|---|---|
1529913 | 1529913 | 2021-07-18 | Abbeville | South Carolina | 45001 | 2598 | 41 |
1529914 | 1529914 | 2021-07-18 | Aiken | South Carolina | 45003 | 17690 | 225 |
1529915 | 1529915 | 2021-07-18 | Allendale | South Carolina | 45005 | 951 | 15 |
1529916 | 1529916 | 2021-07-18 | Anderson | South Carolina | 45007 | 23394 | 533 |
1529917 | 1529917 | 2021-07-18 | Bamberg | South Carolina | 45009 | 1601 | 53 |
1529918 | 1529918 | 2021-07-18 | Barnwell | South Carolina | 45011 | 2638 | 59 |
1529919 | 1529919 | 2021-07-18 | Beaufort | South Carolina | 45013 | 17277 | 210 |
1529920 | 1529920 | 2021-07-18 | Berkeley | South Carolina | 45015 | 18234 | 208 |
1529921 | 1529921 | 2021-07-18 | Calhoun | South Carolina | 45017 | 1340 | 37 |
1529922 | 1529922 | 2021-07-18 | Charleston | South Carolina | 45019 | 44361 | 517 |
1529923 | 1529923 | 2021-07-18 | Cherokee | South Carolina | 45021 | 6249 | 159 |
1529924 | 1529924 | 2021-07-18 | Chester | South Carolina | 45023 | 4305 | 77 |
1529925 | 1529925 | 2021-07-18 | Chesterfield | South Carolina | 45025 | 4954 | 108 |
1529926 | 1529926 | 2021-07-18 | Clarendon | South Carolina | 45027 | 3497 | 113 |
1529927 | 1529927 | 2021-07-18 | Colleton | South Carolina | 45029 | 3745 | 132 |
1529928 | 1529928 | 2021-07-18 | Darlington | South Carolina | 45031 | 8650 | 181 |
1529929 | 1529929 | 2021-07-18 | Dillon | South Carolina | 45033 | 4470 | 85 |
1529930 | 1529930 | 2021-07-18 | Dorchester | South Carolina | 45035 | 18682 | 225 |
1529931 | 1529931 | 2021-07-18 | Edgefield | South Carolina | 45037 | 3186 | 43 |
1529932 | 1529932 | 2021-07-18 | Fairfield | South Carolina | 45039 | 2435 | 83 |
1529933 | 1529933 | 2021-07-18 | Florence | South Carolina | 45041 | 18129 | 426 |
1529934 | 1529934 | 2021-07-18 | Georgetown | South Carolina | 45043 | 6842 | 141 |
1529935 | 1529935 | 2021-07-18 | Greenville | South Carolina | 45045 | 76000 | 1039 |
1529936 | 1529936 | 2021-07-18 | Greenwood | South Carolina | 45047 | 8343 | 174 |
1529937 | 1529937 | 2021-07-18 | Hampton | South Carolina | 45049 | 1962 | 52 |
1529938 | 1529938 | 2021-07-18 | Horry | South Carolina | 45051 | 40342 | 588 |
1529939 | 1529939 | 2021-07-18 | Jasper | South Carolina | 45053 | 2451 | 49 |
1529940 | 1529940 | 2021-07-18 | Kershaw | South Carolina | 45055 | 7631 | 140 |
1529941 | 1529941 | 2021-07-18 | Lancaster | South Carolina | 45057 | 11035 | 173 |
1529942 | 1529942 | 2021-07-18 | Laurens | South Carolina | 45059 | 7578 | 172 |
1529943 | 1529943 | 2021-07-18 | Lee | South Carolina | 45061 | 1956 | 64 |
1529944 | 1529944 | 2021-07-18 | Lexington | South Carolina | 45063 | 34173 | 481 |
1529945 | 1529945 | 2021-07-18 | Marion | South Carolina | 45067 | 3580 | 108 |
1529946 | 1529946 | 2021-07-18 | Marlboro | South Carolina | 45069 | 3531 | 62 |
1529947 | 1529947 | 2021-07-18 | McCormick | South Carolina | 45065 | 1037 | 28 |
1529948 | 1529948 | 2021-07-18 | Newberry | South Carolina | 45071 | 5128 | 109 |
1529949 | 1529949 | 2021-07-18 | Oconee | South Carolina | 45073 | 10020 | 141 |
1529950 | 1529950 | 2021-07-18 | Orangeburg | South Carolina | 45075 | 9929 | 255 |
1529951 | 1529951 | 2021-07-18 | Pickens | South Carolina | 45077 | 19141 | 305 |
1529952 | 1529952 | 2021-07-18 | Richland | South Carolina | 45079 | 48187 | 581 |
1529953 | 1529953 | 2021-07-18 | Saluda | South Carolina | 45081 | 1814 | 48 |
1529954 | 1529954 | 2021-07-18 | Spartanburg | South Carolina | 45083 | 42210 | 829 |
1529955 | 1529955 | 2021-07-18 | Sumter | South Carolina | 45085 | 10748 | 212 |
1529956 | 1529956 | 2021-07-18 | Union | South Carolina | 45087 | 3188 | 84 |
1529957 | 1529957 | 2021-07-18 | Williamsburg | South Carolina | 45089 | 4146 | 103 |
1529958 | 1529958 | 2021-07-18 | York | South Carolina | 45091 | 32445 | 394 |
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);