latest_ny_times_counties_with_populations (view)
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
46 rows where state = "South Carolina" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 1
- South Carolina · 46 ✖
date | county ▼ | state | fips | cases | deaths | population | deaths_per_million | cases_per_million |
---|---|---|---|---|---|---|---|---|
2022-05-13 | Abbeville | South Carolina | 45001 | 6655 | 69 | 24527 | 2813 | 271333 |
2022-05-13 | Aiken | South Carolina | 45003 | 41767 | 437 | 170872 | 2557 | 244434 |
2022-05-13 | Allendale | South Carolina | 45005 | 2093 | 24 | 8688 | 2762 | 240906 |
2022-05-13 | Anderson | South Carolina | 45007 | 58025 | 998 | 202558 | 4926 | 286461 |
2022-05-13 | Bamberg | South Carolina | 45009 | 3446 | 75 | 14066 | 5332 | 244987 |
2022-05-13 | Barnwell | South Carolina | 45011 | 5834 | 103 | 20866 | 4936 | 279593 |
2022-05-13 | Beaufort | South Carolina | 45013 | 43530 | 380 | 192122 | 1977 | 226574 |
2022-05-13 | Berkeley | South Carolina | 45015 | 52240 | 450 | 227907 | 1974 | 229216 |
2022-05-13 | Calhoun | South Carolina | 45017 | 2799 | 61 | 14553 | 4191 | 192331 |
2022-05-13 | Charleston | South Carolina | 45019 | 112905 | 945 | 411406 | 2297 | 274436 |
2022-05-13 | Cherokee | South Carolina | 45021 | 14761 | 322 | 57300 | 5619 | 257609 |
2022-05-13 | Chester | South Carolina | 45023 | 10134 | 153 | 32244 | 4745 | 314291 |
2022-05-13 | Chesterfield | South Carolina | 45025 | 11836 | 191 | 45650 | 4184 | 259277 |
2022-05-13 | Clarendon | South Carolina | 45027 | 8776 | 159 | 33745 | 4711 | 260068 |
2022-05-13 | Colleton | South Carolina | 45029 | 8913 | 221 | 37677 | 5865 | 236563 |
2022-05-13 | Darlington | South Carolina | 45031 | 18939 | 311 | 66618 | 4668 | 284292 |
2022-05-13 | Dillon | South Carolina | 45033 | 9729 | 144 | 30479 | 4724 | 319203 |
2022-05-13 | Dorchester | South Carolina | 45035 | 56325 | 496 | 162809 | 3046 | 345957 |
2022-05-13 | Edgefield | South Carolina | 45037 | 6779 | 71 | 27260 | 2604 | 248679 |
2022-05-13 | Fairfield | South Carolina | 45039 | 6007 | 107 | 22347 | 4788 | 268805 |
2022-05-13 | Florence | South Carolina | 45041 | 41861 | 631 | 138293 | 4562 | 302697 |
2022-05-13 | Georgetown | South Carolina | 45043 | 15958 | 227 | 62680 | 3621 | 254594 |
2022-05-13 | Greenville | South Carolina | 45045 | 173338 | 2008 | 523542 | 3835 | 331087 |
2022-05-13 | Greenwood | South Carolina | 45047 | 22607 | 305 | 70811 | 4307 | 319258 |
2022-05-13 | Hampton | South Carolina | 45049 | 5024 | 86 | 19222 | 4474 | 261367 |
2022-05-13 | Horry | South Carolina | 45051 | 97534 | 1159 | 354081 | 3273 | 275456 |
2022-05-13 | Jasper | South Carolina | 45053 | 5924 | 93 | 30073 | 3092 | 196987 |
2022-05-13 | Kershaw | South Carolina | 45055 | 21623 | 261 | 66551 | 3921 | 324908 |
2022-05-13 | Lancaster | South Carolina | 45057 | 25276 | 281 | 98012 | 2866 | 257886 |
2022-05-13 | Laurens | South Carolina | 45059 | 18667 | 295 | 67493 | 4370 | 276576 |
2022-05-13 | Lee | South Carolina | 45061 | 4272 | 95 | 16828 | 5645 | 253862 |
2022-05-13 | Lexington | South Carolina | 45063 | 96569 | 872 | 298750 | 2918 | 323243 |
2022-05-13 | Marion | South Carolina | 45067 | 8564 | 163 | 30657 | 5316 | 279348 |
2022-05-13 | Marlboro | South Carolina | 45069 | 7880 | 105 | 26118 | 4020 | 301707 |
2022-05-13 | McCormick | South Carolina | 45065 | 2244 | 40 | 9463 | 4226 | 237134 |
2022-05-13 | Newberry | South Carolina | 45071 | 13355 | 195 | 38440 | 5072 | 347424 |
2022-05-13 | Oconee | South Carolina | 45073 | 24348 | 343 | 79546 | 4311 | 306087 |
2022-05-13 | Orangeburg | South Carolina | 45075 | 23425 | 420 | 86175 | 4873 | 271830 |
2022-05-13 | Pickens | South Carolina | 45077 | 46111 | 632 | 126884 | 4980 | 363410 |
2022-05-13 | Richland | South Carolina | 45079 | 123578 | 947 | 415759 | 2277 | 297234 |
2022-05-13 | Saluda | South Carolina | 45081 | 3968 | 78 | 20473 | 3809 | 193816 |
2022-05-13 | Spartanburg | South Carolina | 45083 | 95357 | 1548 | 319785 | 4840 | 298190 |
2022-05-13 | Sumter | South Carolina | 45085 | 28100 | 394 | 106721 | 3691 | 263303 |
2022-05-13 | Union | South Carolina | 45087 | 7750 | 150 | 27316 | 5491 | 283716 |
2022-05-13 | Williamsburg | South Carolina | 45089 | 8557 | 146 | 30368 | 4807 | 281776 |
2022-05-13 | York | South Carolina | 45091 | 78263 | 678 | 280979 | 2412 | 278536 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW latest_ny_times_counties_with_populations AS select ny_times_us_counties.date, ny_times_us_counties.county, ny_times_us_counties.state, ny_times_us_counties.fips, ny_times_us_counties.cases, ny_times_us_counties.deaths, us_census_county_populations_2019.population, 1000000 * ny_times_us_counties.deaths / us_census_county_populations_2019.population as deaths_per_million, 1000000 * ny_times_us_counties.cases / us_census_county_populations_2019.population as cases_per_million from ny_times_us_counties join us_census_county_populations_2019 on ny_times_us_counties.fips = us_census_county_populations_2019.fips where "date" = ( select max(date) from ny_times_us_counties ) order by deaths_per_million desc;