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 county
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 | Prince William | Virginia | 51153 | 97967 | 748 | 470335 | 1590 | 208291 |
2022-05-13 | Pulaski | Virginia | 51155 | 7343 | 138 | 34027 | 4055 | 215799 |
2022-05-13 | Radford city | Virginia | 51750 | 5018 | 53 | 18249 | 2904 | 274973 |
2022-05-13 | Rappahannock | Virginia | 51157 | 1051 | 10 | 7370 | 1356 | 142605 |
2022-05-13 | Richmond | Virginia | 51159 | 2601 | 25 | 9023 | 2770 | 288263 |
2022-05-13 | Richmond city | Virginia | 51760 | 46245 | 515 | 230436 | 2234 | 200684 |
2022-05-13 | Roanoke | Virginia | 51161 | 21633 | 282 | 94186 | 2994 | 229683 |
2022-05-13 | Roanoke city | Virginia | 51770 | 21671 | 376 | 99143 | 3792 | 218583 |
2022-05-13 | Rockbridge | Virginia | 51163 | 3300 | 79 | 22573 | 3499 | 146192 |
2022-05-13 | Rockingham | Virginia | 51165 | 14648 | 228 | 81948 | 2782 | 178747 |
2022-05-13 | Russell | Virginia | 51167 | 6877 | 114 | 26586 | 4287 | 258669 |
2022-05-13 | Salem city | Virginia | 51775 | 5745 | 97 | 25301 | 3833 | 227066 |
2022-05-13 | Scott | Virginia | 51169 | 5845 | 111 | 21566 | 5146 | 271028 |
2022-05-13 | Shenandoah | Virginia | 51171 | 10936 | 222 | 43616 | 5089 | 250733 |
2022-05-13 | Smyth | Virginia | 51173 | 8896 | 171 | 30104 | 5680 | 295508 |
2022-05-13 | Southampton | Virginia | 51175 | 3446 | 93 | 17631 | 5274 | 195451 |
2022-05-13 | Spotsylvania | Virginia | 51177 | 27655 | 301 | 136215 | 2209 | 203024 |
2022-05-13 | Stafford | Virginia | 51179 | 31265 | 177 | 152882 | 1157 | 204504 |
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 | Surry | Virginia | 51181 | 1110 | 20 | 6422 | 3114 | 172843 |
2022-05-13 | Sussex | Virginia | 51183 | 2419 | 42 | 11159 | 3763 | 216775 |
2022-05-13 | Tazewell | Virginia | 51185 | 10329 | 175 | 40595 | 4310 | 254440 |
2022-05-13 | Virginia Beach city | Virginia | 51810 | 91483 | 824 | 449974 | 1831 | 203307 |
2022-05-13 | Warren | Virginia | 51187 | 8675 | 157 | 40164 | 3908 | 215989 |
2022-05-13 | Washington | Virginia | 51191 | 13910 | 215 | 53740 | 4000 | 258838 |
2022-05-13 | Waynesboro city | Virginia | 51820 | 6033 | 69 | 22630 | 3049 | 266593 |
2022-05-13 | Westmoreland | Virginia | 51193 | 3284 | 52 | 18015 | 2886 | 182292 |
2022-05-13 | Williamsburg city | Virginia | 51830 | 1837 | 22 | 14954 | 1471 | 122843 |
2022-05-13 | Winchester city | Virginia | 51840 | 6440 | 80 | 28078 | 2849 | 229361 |
2022-05-13 | Wise | Virginia | 51195 | 10306 | 199 | 37383 | 5323 | 275686 |
2022-05-13 | Wythe | Virginia | 51197 | 7557 | 149 | 28684 | 5194 | 263456 |
2022-05-13 | York | Virginia | 51199 | 10189 | 109 | 68280 | 1596 | 149223 |
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;