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-07 and state = "South Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths
fips 46
- 45001 1
- 45003 1
- 45005 1
- 45007 1
- 45009 1
- 45011 1
- 45013 1
- 45015 1
- 45017 1
- 45019 1
- 45021 1
- 45023 1
- 45025 1
- 45027 1
- 45029 1
- 45031 1
- 45033 1
- 45035 1
- 45037 1
- 45039 1
- 45041 1
- 45043 1
- 45045 1
- 45047 1
- 45049 1
- 45051 1
- 45053 1
- 45055 1
- 45057 1
- 45059 1
- 45061 1
- 45063 1
- 45065 1
- 45067 1
- 45069 1
- 45071 1
- 45073 1
- 45075 1
- 45077 1
- 45079 1
- 45081 1
- 45083 1
- 45085 1
- 45087 1
- 45089 1
- 45091 1
county 46
- 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
- Lee 1
- Lexington 1
- Marion 1
- Marlboro 1
- McCormick 1
- Newberry 1
- Oconee 1
- Orangeburg 1
- Pickens 1
- Richland 1
- Saluda 1
- Spartanburg 1
- Sumter 1
- Union 1
- Williamsburg 1
- York 1
state 1
- South Carolina · 46 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1494198 | 1494198 | 2021-07-07 | Abbeville | South Carolina | 45001 | 2599 | 41 |
1494199 | 1494199 | 2021-07-07 | Aiken | South Carolina | 45003 | 17598 | 224 |
1494200 | 1494200 | 2021-07-07 | Allendale | South Carolina | 45005 | 945 | 15 |
1494201 | 1494201 | 2021-07-07 | Anderson | South Carolina | 45007 | 23303 | 532 |
1494202 | 1494202 | 2021-07-07 | Bamberg | South Carolina | 45009 | 1599 | 53 |
1494203 | 1494203 | 2021-07-07 | Barnwell | South Carolina | 45011 | 2621 | 58 |
1494204 | 1494204 | 2021-07-07 | Beaufort | South Carolina | 45013 | 17178 | 210 |
1494205 | 1494205 | 2021-07-07 | Berkeley | South Carolina | 45015 | 18064 | 208 |
1494206 | 1494206 | 2021-07-07 | Calhoun | South Carolina | 45017 | 1338 | 37 |
1494207 | 1494207 | 2021-07-07 | Charleston | South Carolina | 45019 | 44071 | 517 |
1494208 | 1494208 | 2021-07-07 | Cherokee | South Carolina | 45021 | 6230 | 158 |
1494209 | 1494209 | 2021-07-07 | Chester | South Carolina | 45023 | 4273 | 76 |
1494210 | 1494210 | 2021-07-07 | Chesterfield | South Carolina | 45025 | 4936 | 108 |
1494211 | 1494211 | 2021-07-07 | Clarendon | South Carolina | 45027 | 3485 | 113 |
1494212 | 1494212 | 2021-07-07 | Colleton | South Carolina | 45029 | 3717 | 132 |
1494213 | 1494213 | 2021-07-07 | Darlington | South Carolina | 45031 | 8629 | 180 |
1494214 | 1494214 | 2021-07-07 | Dillon | South Carolina | 45033 | 4438 | 85 |
1494215 | 1494215 | 2021-07-07 | Dorchester | South Carolina | 45035 | 18489 | 223 |
1494216 | 1494216 | 2021-07-07 | Edgefield | South Carolina | 45037 | 3177 | 43 |
1494217 | 1494217 | 2021-07-07 | Fairfield | South Carolina | 45039 | 2429 | 83 |
1494218 | 1494218 | 2021-07-07 | Florence | South Carolina | 45041 | 18049 | 425 |
1494219 | 1494219 | 2021-07-07 | Georgetown | South Carolina | 45043 | 6811 | 141 |
1494220 | 1494220 | 2021-07-07 | Greenville | South Carolina | 45045 | 75720 | 1035 |
1494221 | 1494221 | 2021-07-07 | Greenwood | South Carolina | 45047 | 8318 | 174 |
1494222 | 1494222 | 2021-07-07 | Hampton | South Carolina | 45049 | 1929 | 52 |
1494223 | 1494223 | 2021-07-07 | Horry | South Carolina | 45051 | 39856 | 585 |
1494224 | 1494224 | 2021-07-07 | Jasper | South Carolina | 45053 | 2436 | 50 |
1494225 | 1494225 | 2021-07-07 | Kershaw | South Carolina | 45055 | 7570 | 140 |
1494226 | 1494226 | 2021-07-07 | Lancaster | South Carolina | 45057 | 10977 | 173 |
1494227 | 1494227 | 2021-07-07 | Laurens | South Carolina | 45059 | 7551 | 173 |
1494228 | 1494228 | 2021-07-07 | Lee | South Carolina | 45061 | 1944 | 64 |
1494229 | 1494229 | 2021-07-07 | Lexington | South Carolina | 45063 | 33856 | 480 |
1494230 | 1494230 | 2021-07-07 | Marion | South Carolina | 45067 | 3572 | 108 |
1494231 | 1494231 | 2021-07-07 | Marlboro | South Carolina | 45069 | 3511 | 59 |
1494232 | 1494232 | 2021-07-07 | McCormick | South Carolina | 45065 | 1035 | 28 |
1494233 | 1494233 | 2021-07-07 | Newberry | South Carolina | 45071 | 5116 | 109 |
1494234 | 1494234 | 2021-07-07 | Oconee | South Carolina | 45073 | 9959 | 140 |
1494235 | 1494235 | 2021-07-07 | Orangeburg | South Carolina | 45075 | 9885 | 255 |
1494236 | 1494236 | 2021-07-07 | Pickens | South Carolina | 45077 | 19097 | 304 |
1494237 | 1494237 | 2021-07-07 | Richland | South Carolina | 45079 | 47852 | 580 |
1494238 | 1494238 | 2021-07-07 | Saluda | South Carolina | 45081 | 1812 | 48 |
1494239 | 1494239 | 2021-07-07 | Spartanburg | South Carolina | 45083 | 42092 | 833 |
1494240 | 1494240 | 2021-07-07 | Sumter | South Carolina | 45085 | 10654 | 211 |
1494241 | 1494241 | 2021-07-07 | Union | South Carolina | 45087 | 3183 | 84 |
1494242 | 1494242 | 2021-07-07 | Williamsburg | South Carolina | 45089 | 4126 | 103 |
1494243 | 1494243 | 2021-07-07 | York | South Carolina | 45091 | 32199 | 393 |
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);