latest_ny_times_counties_with_populations (view)
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
133 rows where state = "Virginia" sorted by cases_per_million descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- Virginia · 133 ✖
date | county | state | fips | cases | deaths | population | deaths_per_million | cases_per_million ▲ |
---|---|---|---|---|---|---|---|---|
2022-05-13 | Dinwiddie | Virginia | 51053 | 5442 | 93 | 28544 | 3258 | 190653 |
2022-05-13 | Fredericksburg city | Virginia | 51630 | 5498 | 42 | 29036 | 1446 | 189351 |
2022-05-13 | Orange | Virginia | 51137 | 6928 | 86 | 37051 | 2321 | 186985 |
2022-05-13 | Northampton | Virginia | 51131 | 2183 | 65 | 11710 | 5550 | 186421 |
2022-05-13 | Fauquier | Virginia | 51061 | 13267 | 144 | 71222 | 2021 | 186276 |
2022-05-13 | Madison | Virginia | 51113 | 2451 | 41 | 13261 | 3091 | 184827 |
2022-05-13 | Clarke | Virginia | 51043 | 2679 | 42 | 14619 | 2872 | 183254 |
2022-05-13 | Northumberland | Virginia | 51133 | 2216 | 46 | 12095 | 3803 | 183216 |
2022-05-13 | Westmoreland | Virginia | 51193 | 3284 | 52 | 18015 | 2886 | 182292 |
2022-05-13 | Louisa | Virginia | 51109 | 6842 | 85 | 37591 | 2261 | 182011 |
2022-05-13 | Rockingham | Virginia | 51165 | 14648 | 228 | 81948 | 2782 | 178747 |
2022-05-13 | Norfolk city | Virginia | 51710 | 43091 | 476 | 242742 | 1960 | 177517 |
2022-05-13 | Powhatan | Virginia | 51145 | 5257 | 59 | 29652 | 1989 | 177289 |
2022-05-13 | Middlesex | Virginia | 51119 | 1874 | 48 | 10582 | 4536 | 177093 |
2022-05-13 | Highland | Virginia | 51091 | 387 | 7 | 2190 | 3196 | 176712 |
2022-05-13 | Goochland | Virginia | 51075 | 4153 | 53 | 23753 | 2231 | 174841 |
2022-05-13 | Lancaster | Virginia | 51103 | 1846 | 31 | 10603 | 2923 | 174101 |
2022-05-13 | Loudoun | Virginia | 51107 | 71890 | 383 | 413538 | 926 | 173841 |
2022-05-13 | Nelson | Virginia | 51125 | 2589 | 36 | 14930 | 2411 | 173409 |
2022-05-13 | Surry | Virginia | 51181 | 1110 | 20 | 6422 | 3114 | 172843 |
2022-05-13 | Mathews | Virginia | 51115 | 1524 | 27 | 8834 | 3056 | 172515 |
2022-05-13 | Charles City | Virginia | 51036 | 1191 | 27 | 6963 | 3877 | 171046 |
2022-05-13 | Albemarle | Virginia | 51003 | 18671 | 163 | 109330 | 1490 | 170776 |
2022-05-13 | Floyd | Virginia | 51063 | 2587 | 49 | 15749 | 3111 | 164264 |
2022-05-13 | Fairfax | Virginia | 51059 | 188156 | 1453 | 1147532 | 1266 | 163965 |
2022-05-13 | King and Queen | Virginia | 51097 | 1146 | 12 | 7025 | 1708 | 163131 |
2022-05-13 | Falls Church city | Virginia | 51610 | 2226 | 17 | 14617 | 1163 | 152288 |
2022-05-13 | York | Virginia | 51199 | 10189 | 109 | 68280 | 1596 | 149223 |
2022-05-13 | Rockbridge | Virginia | 51163 | 3300 | 79 | 22573 | 3499 | 146192 |
2022-05-13 | Rappahannock | Virginia | 51157 | 1051 | 10 | 7370 | 1356 | 142605 |
2022-05-13 | Cumberland | Virginia | 51049 | 1366 | 27 | 9932 | 2718 | 137535 |
2022-05-13 | Williamsburg city | Virginia | 51830 | 1837 | 22 | 14954 | 1471 | 122843 |
2022-05-13 | Fairfax city | Virginia | 51600 | 2056 | 43 | 24019 | 1790 | 85598 |
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;