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 fips
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 | Colonial Heights city | Virginia | 51570 | 4958 | 97 | 17370 | 5584 | 285434 |
2022-05-13 | Covington city | Virginia | 51580 | 1299 | 26 | 5538 | 4694 | 234561 |
2022-05-13 | Danville city | Virginia | 51590 | 11226 | 282 | 40044 | 7042 | 280341 |
2022-05-13 | Emporia city | Virginia | 51595 | 1187 | 55 | 5346 | 10288 | 222035 |
2022-05-13 | Fairfax city | Virginia | 51600 | 2056 | 43 | 24019 | 1790 | 85598 |
2022-05-13 | Falls Church city | Virginia | 51610 | 2226 | 17 | 14617 | 1163 | 152288 |
2022-05-13 | Franklin city | Virginia | 51620 | 2395 | 52 | 7967 | 6526 | 300615 |
2022-05-13 | Fredericksburg city | Virginia | 51630 | 5498 | 42 | 29036 | 1446 | 189351 |
2022-05-13 | Galax city | Virginia | 51640 | 2561 | 78 | 6347 | 12289 | 403497 |
2022-05-13 | Hampton city | Virginia | 51650 | 28527 | 330 | 134510 | 2453 | 212080 |
2022-05-13 | Harrisonburg city | Virginia | 51660 | 13492 | 160 | 53016 | 3017 | 254489 |
2022-05-13 | Hopewell city | Virginia | 51670 | 6141 | 118 | 22529 | 5237 | 272582 |
2022-05-13 | Lexington city | Virginia | 51678 | 2857 | 40 | 7446 | 5372 | 383695 |
2022-05-13 | Lynchburg city | Virginia | 51680 | 19760 | 267 | 82168 | 3249 | 240482 |
2022-05-13 | Manassas city | Virginia | 51683 | 9281 | 71 | 41085 | 1728 | 225897 |
2022-05-13 | Manassas Park city | Virginia | 51685 | 3828 | 27 | 17478 | 1544 | 219018 |
2022-05-13 | Martinsville city | Virginia | 51690 | 3478 | 124 | 12554 | 9877 | 277043 |
2022-05-13 | Newport News city | Virginia | 51700 | 37189 | 404 | 179225 | 2254 | 207498 |
2022-05-13 | Norfolk city | Virginia | 51710 | 43091 | 476 | 242742 | 1960 | 177517 |
2022-05-13 | Norton city | Virginia | 51720 | 1310 | 22 | 3981 | 5526 | 329063 |
2022-05-13 | Petersburg city | Virginia | 51730 | 8297 | 140 | 31346 | 4466 | 264690 |
2022-05-13 | Poquoson city | Virginia | 51735 | 2388 | 30 | 12271 | 2444 | 194605 |
2022-05-13 | Portsmouth city | Virginia | 51740 | 21144 | 338 | 94398 | 3580 | 223987 |
2022-05-13 | Radford city | Virginia | 51750 | 5018 | 53 | 18249 | 2904 | 274973 |
2022-05-13 | Richmond city | Virginia | 51760 | 46245 | 515 | 230436 | 2234 | 200684 |
2022-05-13 | Roanoke city | Virginia | 51770 | 21671 | 376 | 99143 | 3792 | 218583 |
2022-05-13 | Salem city | Virginia | 51775 | 5745 | 97 | 25301 | 3833 | 227066 |
2022-05-13 | Staunton city | Virginia | 51790 | 5737 | 115 | 24932 | 4612 | 230105 |
2022-05-13 | Suffolk city | Virginia | 51800 | 19133 | 302 | 92108 | 3278 | 207723 |
2022-05-13 | Virginia Beach city | Virginia | 51810 | 91483 | 824 | 449974 | 1831 | 203307 |
2022-05-13 | Waynesboro city | Virginia | 51820 | 6033 | 69 | 22630 | 3049 | 266593 |
2022-05-13 | Williamsburg city | Virginia | 51830 | 1837 | 22 | 14954 | 1471 | 122843 |
2022-05-13 | Winchester city | Virginia | 51840 | 6440 | 80 | 28078 | 2849 | 229361 |
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;