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 descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 1
- Virginia · 133 ✖
date | county ▲ | state | fips | cases | deaths | population | deaths_per_million | cases_per_million |
---|---|---|---|---|---|---|---|---|
2022-05-13 | York | Virginia | 51199 | 10189 | 109 | 68280 | 1596 | 149223 |
2022-05-13 | Wythe | Virginia | 51197 | 7557 | 149 | 28684 | 5194 | 263456 |
2022-05-13 | Wise | Virginia | 51195 | 10306 | 199 | 37383 | 5323 | 275686 |
2022-05-13 | Winchester city | Virginia | 51840 | 6440 | 80 | 28078 | 2849 | 229361 |
2022-05-13 | Williamsburg city | Virginia | 51830 | 1837 | 22 | 14954 | 1471 | 122843 |
2022-05-13 | Westmoreland | Virginia | 51193 | 3284 | 52 | 18015 | 2886 | 182292 |
2022-05-13 | Waynesboro city | Virginia | 51820 | 6033 | 69 | 22630 | 3049 | 266593 |
2022-05-13 | Washington | Virginia | 51191 | 13910 | 215 | 53740 | 4000 | 258838 |
2022-05-13 | Warren | Virginia | 51187 | 8675 | 157 | 40164 | 3908 | 215989 |
2022-05-13 | Virginia Beach city | Virginia | 51810 | 91483 | 824 | 449974 | 1831 | 203307 |
2022-05-13 | Tazewell | Virginia | 51185 | 10329 | 175 | 40595 | 4310 | 254440 |
2022-05-13 | Sussex | Virginia | 51183 | 2419 | 42 | 11159 | 3763 | 216775 |
2022-05-13 | Surry | Virginia | 51181 | 1110 | 20 | 6422 | 3114 | 172843 |
2022-05-13 | Suffolk city | Virginia | 51800 | 19133 | 302 | 92108 | 3278 | 207723 |
2022-05-13 | Staunton city | Virginia | 51790 | 5737 | 115 | 24932 | 4612 | 230105 |
2022-05-13 | Stafford | Virginia | 51179 | 31265 | 177 | 152882 | 1157 | 204504 |
2022-05-13 | Spotsylvania | Virginia | 51177 | 27655 | 301 | 136215 | 2209 | 203024 |
2022-05-13 | Southampton | Virginia | 51175 | 3446 | 93 | 17631 | 5274 | 195451 |
2022-05-13 | Smyth | Virginia | 51173 | 8896 | 171 | 30104 | 5680 | 295508 |
2022-05-13 | Shenandoah | Virginia | 51171 | 10936 | 222 | 43616 | 5089 | 250733 |
2022-05-13 | Scott | Virginia | 51169 | 5845 | 111 | 21566 | 5146 | 271028 |
2022-05-13 | Salem city | Virginia | 51775 | 5745 | 97 | 25301 | 3833 | 227066 |
2022-05-13 | Russell | Virginia | 51167 | 6877 | 114 | 26586 | 4287 | 258669 |
2022-05-13 | Rockingham | Virginia | 51165 | 14648 | 228 | 81948 | 2782 | 178747 |
2022-05-13 | Rockbridge | Virginia | 51163 | 3300 | 79 | 22573 | 3499 | 146192 |
2022-05-13 | Roanoke city | Virginia | 51770 | 21671 | 376 | 99143 | 3792 | 218583 |
2022-05-13 | Roanoke | Virginia | 51161 | 21633 | 282 | 94186 | 2994 | 229683 |
2022-05-13 | Richmond city | Virginia | 51760 | 46245 | 515 | 230436 | 2234 | 200684 |
2022-05-13 | Richmond | Virginia | 51159 | 2601 | 25 | 9023 | 2770 | 288263 |
2022-05-13 | Rappahannock | Virginia | 51157 | 1051 | 10 | 7370 | 1356 | 142605 |
2022-05-13 | Radford city | Virginia | 51750 | 5018 | 53 | 18249 | 2904 | 274973 |
2022-05-13 | Pulaski | Virginia | 51155 | 7343 | 138 | 34027 | 4055 | 215799 |
2022-05-13 | Prince William | Virginia | 51153 | 97967 | 748 | 470335 | 1590 | 208291 |
2022-05-13 | Prince George | Virginia | 51149 | 8917 | 79 | 38353 | 2059 | 232498 |
2022-05-13 | Prince Edward | Virginia | 51147 | 5107 | 71 | 22802 | 3113 | 223971 |
2022-05-13 | Powhatan | Virginia | 51145 | 5257 | 59 | 29652 | 1989 | 177289 |
2022-05-13 | Portsmouth city | Virginia | 51740 | 21144 | 338 | 94398 | 3580 | 223987 |
2022-05-13 | Poquoson city | Virginia | 51735 | 2388 | 30 | 12271 | 2444 | 194605 |
2022-05-13 | Pittsylvania | Virginia | 51143 | 14301 | 199 | 60354 | 3297 | 236951 |
2022-05-13 | Petersburg city | Virginia | 51730 | 8297 | 140 | 31346 | 4466 | 264690 |
2022-05-13 | Patrick | Virginia | 51141 | 3706 | 98 | 17608 | 5565 | 210472 |
2022-05-13 | Page | Virginia | 51139 | 5660 | 122 | 23902 | 5104 | 236800 |
2022-05-13 | Orange | Virginia | 51137 | 6928 | 86 | 37051 | 2321 | 186985 |
2022-05-13 | Nottoway | Virginia | 51135 | 4300 | 92 | 15232 | 6039 | 282300 |
2022-05-13 | Norton city | Virginia | 51720 | 1310 | 22 | 3981 | 5526 | 329063 |
2022-05-13 | Northumberland | Virginia | 51133 | 2216 | 46 | 12095 | 3803 | 183216 |
2022-05-13 | Northampton | Virginia | 51131 | 2183 | 65 | 11710 | 5550 | 186421 |
2022-05-13 | Norfolk city | Virginia | 51710 | 43091 | 476 | 242742 | 1960 | 177517 |
2022-05-13 | Newport News city | Virginia | 51700 | 37189 | 404 | 179225 | 2254 | 207498 |
2022-05-13 | New Kent | Virginia | 51127 | 4742 | 32 | 23091 | 1385 | 205361 |
2022-05-13 | Nelson | Virginia | 51125 | 2589 | 36 | 14930 | 2411 | 173409 |
2022-05-13 | Montgomery | Virginia | 51121 | 19403 | 154 | 98535 | 1562 | 196914 |
2022-05-13 | Middlesex | Virginia | 51119 | 1874 | 48 | 10582 | 4536 | 177093 |
2022-05-13 | Mecklenburg | Virginia | 51117 | 6217 | 123 | 30587 | 4021 | 203256 |
2022-05-13 | Mathews | Virginia | 51115 | 1524 | 27 | 8834 | 3056 | 172515 |
2022-05-13 | Martinsville city | Virginia | 51690 | 3478 | 124 | 12554 | 9877 | 277043 |
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 | Madison | Virginia | 51113 | 2451 | 41 | 13261 | 3091 | 184827 |
2022-05-13 | Lynchburg city | Virginia | 51680 | 19760 | 267 | 82168 | 3249 | 240482 |
2022-05-13 | Lunenburg | Virginia | 51111 | 2460 | 39 | 12196 | 3197 | 201705 |
2022-05-13 | Louisa | Virginia | 51109 | 6842 | 85 | 37591 | 2261 | 182011 |
2022-05-13 | Loudoun | Virginia | 51107 | 71890 | 383 | 413538 | 926 | 173841 |
2022-05-13 | Lexington city | Virginia | 51678 | 2857 | 40 | 7446 | 5372 | 383695 |
2022-05-13 | Lee | Virginia | 51105 | 6185 | 93 | 23423 | 3970 | 264056 |
2022-05-13 | Lancaster | Virginia | 51103 | 1846 | 31 | 10603 | 2923 | 174101 |
2022-05-13 | King and Queen | Virginia | 51097 | 1146 | 12 | 7025 | 1708 | 163131 |
2022-05-13 | King William | Virginia | 51101 | 3767 | 43 | 17148 | 2507 | 219675 |
2022-05-13 | King George | Virginia | 51099 | 5119 | 39 | 26836 | 1453 | 190751 |
2022-05-13 | James City | Virginia | 51095 | 15461 | 121 | 76523 | 1581 | 202043 |
2022-05-13 | Isle of Wight | Virginia | 51093 | 7395 | 119 | 37109 | 3206 | 199277 |
2022-05-13 | Hopewell city | Virginia | 51670 | 6141 | 118 | 22529 | 5237 | 272582 |
2022-05-13 | Highland | Virginia | 51091 | 387 | 7 | 2190 | 3196 | 176712 |
2022-05-13 | Henry | Virginia | 51089 | 12205 | 266 | 50557 | 5261 | 241410 |
2022-05-13 | Henrico | Virginia | 51087 | 67513 | 934 | 330818 | 2823 | 204078 |
2022-05-13 | Harrisonburg city | Virginia | 51660 | 13492 | 160 | 53016 | 3017 | 254489 |
2022-05-13 | Hanover | Virginia | 51085 | 22386 | 286 | 107766 | 2653 | 207727 |
2022-05-13 | Hampton city | Virginia | 51650 | 28527 | 330 | 134510 | 2453 | 212080 |
2022-05-13 | Halifax | Virginia | 51083 | 7217 | 159 | 33911 | 4688 | 212821 |
2022-05-13 | Greensville | Virginia | 51081 | 3341 | 40 | 11336 | 3528 | 294724 |
2022-05-13 | Greene | Virginia | 51079 | 4074 | 62 | 19819 | 3128 | 205560 |
2022-05-13 | Grayson | Virginia | 51077 | 4059 | 83 | 15550 | 5337 | 261028 |
2022-05-13 | Goochland | Virginia | 51075 | 4153 | 53 | 23753 | 2231 | 174841 |
2022-05-13 | Gloucester | Virginia | 51073 | 7453 | 104 | 37348 | 2784 | 199555 |
2022-05-13 | Giles | Virginia | 51071 | 4115 | 50 | 16720 | 2990 | 246112 |
2022-05-13 | Galax city | Virginia | 51640 | 2561 | 78 | 6347 | 12289 | 403497 |
2022-05-13 | Fredericksburg city | Virginia | 51630 | 5498 | 42 | 29036 | 1446 | 189351 |
2022-05-13 | Frederick | Virginia | 51069 | 20904 | 249 | 89313 | 2787 | 234053 |
2022-05-13 | Franklin city | Virginia | 51620 | 2395 | 52 | 7967 | 6526 | 300615 |
2022-05-13 | Franklin | Virginia | 51067 | 10984 | 198 | 56042 | 3533 | 195995 |
2022-05-13 | Fluvanna | Virginia | 51065 | 5260 | 46 | 27270 | 1686 | 192885 |
2022-05-13 | Floyd | Virginia | 51063 | 2587 | 49 | 15749 | 3111 | 164264 |
2022-05-13 | Fauquier | Virginia | 51061 | 13267 | 144 | 71222 | 2021 | 186276 |
2022-05-13 | Falls Church city | Virginia | 51610 | 2226 | 17 | 14617 | 1163 | 152288 |
2022-05-13 | Fairfax city | Virginia | 51600 | 2056 | 43 | 24019 | 1790 | 85598 |
2022-05-13 | Fairfax | Virginia | 51059 | 188156 | 1453 | 1147532 | 1266 | 163965 |
2022-05-13 | Essex | Virginia | 51057 | 2285 | 33 | 10953 | 3012 | 208618 |
2022-05-13 | Emporia city | Virginia | 51595 | 1187 | 55 | 5346 | 10288 | 222035 |
2022-05-13 | Dinwiddie | Virginia | 51053 | 5442 | 93 | 28544 | 3258 | 190653 |
2022-05-13 | Dickenson | Virginia | 51051 | 3321 | 49 | 14318 | 3422 | 231945 |
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;