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-09-21 and state = "South Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
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 |
---|---|---|---|---|---|---|---|
1741054 | 1741054 | 2021-09-21 | Abbeville | South Carolina | 45001 | 3472 | 44 |
1741055 | 1741055 | 2021-09-21 | Aiken | South Carolina | 45003 | 25148 | 289 |
1741056 | 1741056 | 2021-09-21 | Allendale | South Carolina | 45005 | 1298 | 19 |
1741057 | 1741057 | 2021-09-21 | Anderson | South Carolina | 45007 | 33279 | 613 |
1741058 | 1741058 | 2021-09-21 | Bamberg | South Carolina | 45009 | 2032 | 61 |
1741059 | 1741059 | 2021-09-21 | Barnwell | South Carolina | 45011 | 3666 | 74 |
1741060 | 1741060 | 2021-09-21 | Beaufort | South Carolina | 45013 | 25812 | 272 |
1741061 | 1741061 | 2021-09-21 | Berkeley | South Carolina | 45015 | 29024 | 262 |
1741062 | 1741062 | 2021-09-21 | Calhoun | South Carolina | 45017 | 1679 | 49 |
1741063 | 1741063 | 2021-09-21 | Charleston | South Carolina | 45019 | 61576 | 625 |
1741064 | 1741064 | 2021-09-21 | Cherokee | South Carolina | 45021 | 8968 | 196 |
1741065 | 1741065 | 2021-09-21 | Chester | South Carolina | 45023 | 5869 | 95 |
1741066 | 1741066 | 2021-09-21 | Chesterfield | South Carolina | 45025 | 6527 | 126 |
1741067 | 1741067 | 2021-09-21 | Clarendon | South Carolina | 45027 | 4631 | 133 |
1741068 | 1741068 | 2021-09-21 | Colleton | South Carolina | 45029 | 5389 | 173 |
1741069 | 1741069 | 2021-09-21 | Darlington | South Carolina | 45031 | 11160 | 207 |
1741070 | 1741070 | 2021-09-21 | Dillon | South Carolina | 45033 | 5922 | 103 |
1741071 | 1741071 | 2021-09-21 | Dorchester | South Carolina | 45035 | 31489 | 310 |
1741072 | 1741072 | 2021-09-21 | Edgefield | South Carolina | 45037 | 4126 | 50 |
1741073 | 1741073 | 2021-09-21 | Fairfield | South Carolina | 45039 | 3111 | 88 |
1741074 | 1741074 | 2021-09-21 | Florence | South Carolina | 45041 | 25068 | 481 |
1741075 | 1741075 | 2021-09-21 | Georgetown | South Carolina | 45043 | 9055 | 158 |
1741076 | 1741076 | 2021-09-21 | Greenville | South Carolina | 45045 | 97273 | 1201 |
1741077 | 1741077 | 2021-09-21 | Greenwood | South Carolina | 45047 | 10822 | 186 |
1741078 | 1741078 | 2021-09-21 | Hampton | South Carolina | 45049 | 2942 | 67 |
1741079 | 1741079 | 2021-09-21 | Horry | South Carolina | 45051 | 57882 | 760 |
1741080 | 1741080 | 2021-09-21 | Jasper | South Carolina | 45053 | 3738 | 65 |
1741081 | 1741081 | 2021-09-21 | Kershaw | South Carolina | 45055 | 11030 | 176 |
1741082 | 1741082 | 2021-09-21 | Lancaster | South Carolina | 45057 | 14663 | 198 |
1741083 | 1741083 | 2021-09-21 | Laurens | South Carolina | 45059 | 10228 | 186 |
1741084 | 1741084 | 2021-09-21 | Lee | South Carolina | 45061 | 2370 | 68 |
1741085 | 1741085 | 2021-09-21 | Lexington | South Carolina | 45063 | 50892 | 640 |
1741086 | 1741086 | 2021-09-21 | Marion | South Carolina | 45067 | 5012 | 123 |
1741087 | 1741087 | 2021-09-21 | Marlboro | South Carolina | 45069 | 4504 | 70 |
1741088 | 1741088 | 2021-09-21 | McCormick | South Carolina | 45065 | 1257 | 29 |
1741089 | 1741089 | 2021-09-21 | Newberry | South Carolina | 45071 | 6974 | 128 |
1741090 | 1741090 | 2021-09-21 | Oconee | South Carolina | 45073 | 14046 | 176 |
1741091 | 1741091 | 2021-09-21 | Orangeburg | South Carolina | 45075 | 13618 | 303 |
1741092 | 1741092 | 2021-09-21 | Pickens | South Carolina | 45077 | 25533 | 378 |
1741093 | 1741093 | 2021-09-21 | Richland | South Carolina | 45079 | 64918 | 703 |
1741094 | 1741094 | 2021-09-21 | Saluda | South Carolina | 45081 | 2377 | 50 |
1741095 | 1741095 | 2021-09-21 | Spartanburg | South Carolina | 45083 | 56675 | 987 |
1741096 | 1741096 | 2021-09-21 | Sumter | South Carolina | 45085 | 14656 | 258 |
1741097 | 1741097 | 2021-09-21 | Union | South Carolina | 45087 | 3937 | 90 |
1741098 | 1741098 | 2021-09-21 | Williamsburg | South Carolina | 45089 | 5345 | 115 |
1741099 | 1741099 | 2021-09-21 | York | South Carolina | 45091 | 43473 | 443 |
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);