ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103,128 rows where state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 51059 586
- 51810 585
- 51107 584
- 51013 582
- 51147 582
- 51153 582
- 51085 581
- 51095 581
- 51510 581
- 51177 580
- 51660 580
- 51041 579
- 51179 578
- 51199 578
- 51830 577
- 51075 576
- 51087 576
- 51540 576
- 51760 576
- 51036 575
- 51700 574
- 51710 574
- 51740 574
- 51001 573
- 51073 573
- 51117 573
- 51800 573
- 51003 572
- 51023 572
- 51067 572
- …
county >30
- Fairfax 586
- Virginia Beach city 585
- Loudoun 584
- Arlington 582
- Prince Edward 582
- Prince William 582
- Alexandria city 581
- Hanover 581
- James City 581
- Harrisonburg city 580
- Spotsylvania 580
- Chesterfield 579
- Stafford 578
- York 578
- Williamsburg city 577
- Charlottesville city 576
- Goochland 576
- Henrico 576
- Richmond city 576
- Charles City 575
- Newport News city 574
- Norfolk city 574
- Portsmouth city 574
- Accomack 573
- Gloucester 573
- Mecklenburg 573
- Suffolk city 573
- Albemarle 572
- Botetourt 572
- Franklin 572
- …
state 1
- Virginia · 74,992 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1816359 | 1816359 | 2021-10-14 | Lancaster | Virginia | 51103 | 1044 | 21 |
1816360 | 1816360 | 2021-10-14 | Lee | Virginia | 51105 | 3597 | 57 |
1816361 | 1816361 | 2021-10-14 | Lexington city | Virginia | 51678 | 1537 | 34 |
1816362 | 1816362 | 2021-10-14 | Loudoun | Virginia | 51107 | 33482 | 294 |
1816363 | 1816363 | 2021-10-14 | Louisa | Virginia | 51109 | 3084 | 44 |
1816364 | 1816364 | 2021-10-14 | Lunenburg | Virginia | 51111 | 1049 | 19 |
1816365 | 1816365 | 2021-10-14 | Lynchburg city | Virginia | 51680 | 11575 | 183 |
1816366 | 1816366 | 2021-10-14 | Madison | Virginia | 51113 | 958 | 20 |
1816367 | 1816367 | 2021-10-14 | Manassas Park city | Virginia | 51685 | 1263 | 12 |
1816368 | 1816368 | 2021-10-14 | Manassas city | Virginia | 51683 | 5009 | 51 |
1816369 | 1816369 | 2021-10-14 | Martinsville city | Virginia | 51690 | 1986 | 87 |
1816370 | 1816370 | 2021-10-14 | Mathews | Virginia | 51115 | 872 | 20 |
1816371 | 1816371 | 2021-10-14 | Mecklenburg | Virginia | 51117 | 3317 | 81 |
1816372 | 1816372 | 2021-10-14 | Middlesex | Virginia | 51119 | 927 | 27 |
1816373 | 1816373 | 2021-10-14 | Montgomery | Virginia | 51121 | 11565 | 99 |
1816374 | 1816374 | 2021-10-14 | Nelson | Virginia | 51125 | 1297 | 16 |
1816375 | 1816375 | 2021-10-14 | New Kent | Virginia | 51127 | 2288 | 22 |
1816376 | 1816376 | 2021-10-14 | Newport News city | Virginia | 51700 | 20146 | 288 |
1816377 | 1816377 | 2021-10-14 | Norfolk city | Virginia | 51710 | 23908 | 324 |
1816378 | 1816378 | 2021-10-14 | Northampton | Virginia | 51131 | 1132 | 40 |
1816379 | 1816379 | 2021-10-14 | Northumberland | Virginia | 51133 | 1175 | 30 |
1816380 | 1816380 | 2021-10-14 | Norton city | Virginia | 51720 | 541 | 13 |
1816381 | 1816381 | 2021-10-14 | Nottoway | Virginia | 51135 | 2536 | 62 |
1816382 | 1816382 | 2021-10-14 | Orange | Virginia | 51137 | 3545 | 51 |
1816383 | 1816383 | 2021-10-14 | Page | Virginia | 51139 | 3253 | 73 |
1816384 | 1816384 | 2021-10-14 | Patrick | Virginia | 51141 | 1963 | 55 |
1816385 | 1816385 | 2021-10-14 | Petersburg city | Virginia | 51730 | 5154 | 106 |
1816386 | 1816386 | 2021-10-14 | Pittsylvania | Virginia | 51143 | 7859 | 105 |
1816387 | 1816387 | 2021-10-14 | Poquoson city | Virginia | 51735 | 1304 | 19 |
1816388 | 1816388 | 2021-10-14 | Portsmouth city | Virginia | 51740 | 12347 | 232 |
1816389 | 1816389 | 2021-10-14 | Powhatan | Virginia | 51145 | 2730 | 27 |
1816390 | 1816390 | 2021-10-14 | Prince Edward | Virginia | 51147 | 2882 | 50 |
1816391 | 1816391 | 2021-10-14 | Prince George | Virginia | 51149 | 4851 | 38 |
1816392 | 1816392 | 2021-10-14 | Prince William | Virginia | 51153 | 53952 | 548 |
1816393 | 1816393 | 2021-10-14 | Pulaski | Virginia | 51155 | 3965 | 80 |
1816394 | 1816394 | 2021-10-14 | Radford city | Virginia | 51750 | 2850 | 31 |
1816395 | 1816395 | 2021-10-14 | Rappahannock | Virginia | 51157 | 554 | 4 |
1816396 | 1816396 | 2021-10-14 | Richmond | Virginia | 51159 | 1702 | 13 |
1816397 | 1816397 | 2021-10-14 | Richmond city | Virginia | 51760 | 23430 | 332 |
1816398 | 1816398 | 2021-10-14 | Roanoke | Virginia | 51161 | 11469 | 161 |
1816399 | 1816399 | 2021-10-14 | Roanoke city | Virginia | 51770 | 11762 | 230 |
1816400 | 1816400 | 2021-10-14 | Rockbridge | Virginia | 51163 | 2041 | 57 |
1816401 | 1816401 | 2021-10-14 | Rockingham | Virginia | 51165 | 9079 | 144 |
1816402 | 1816402 | 2021-10-14 | Russell | Virginia | 51167 | 3635 | 58 |
1816403 | 1816403 | 2021-10-14 | Salem city | Virginia | 51775 | 3329 | 57 |
1816404 | 1816404 | 2021-10-14 | Scott | Virginia | 51169 | 2974 | 74 |
1816405 | 1816405 | 2021-10-14 | Shenandoah | Virginia | 51171 | 6155 | 154 |
1816406 | 1816406 | 2021-10-14 | Smyth | Virginia | 51173 | 4659 | 110 |
1816407 | 1816407 | 2021-10-14 | Southampton | Virginia | 51175 | 2355 | 63 |
1816408 | 1816408 | 2021-10-14 | Spotsylvania | Virginia | 51177 | 14522 | 144 |
1816409 | 1816409 | 2021-10-14 | Stafford | Virginia | 51179 | 15534 | 103 |
1816410 | 1816410 | 2021-10-14 | Staunton city | Virginia | 51790 | 3311 | 81 |
1816411 | 1816411 | 2021-10-14 | Suffolk city | Virginia | 51800 | 10670 | 224 |
1816412 | 1816412 | 2021-10-14 | Surry | Virginia | 51181 | 590 | 10 |
1816413 | 1816413 | 2021-10-14 | Sussex | Virginia | 51183 | 1533 | 26 |
1816414 | 1816414 | 2021-10-14 | Tazewell | Virginia | 51185 | 5540 | 95 |
1816415 | 1816415 | 2021-10-14 | Virginia Beach city | Virginia | 51810 | 48851 | 523 |
1816416 | 1816416 | 2021-10-14 | Warren | Virginia | 51187 | 4791 | 78 |
1816417 | 1816417 | 2021-10-14 | Washington | Virginia | 51191 | 7333 | 139 |
1816418 | 1816418 | 2021-10-14 | Waynesboro city | Virginia | 51820 | 3410 | 42 |
1816419 | 1816419 | 2021-10-14 | Westmoreland | Virginia | 51193 | 1772 | 32 |
1816420 | 1816420 | 2021-10-14 | Williamsburg city | Virginia | 51830 | 1121 | 14 |
1816421 | 1816421 | 2021-10-14 | Winchester city | Virginia | 51840 | 3655 | 53 |
1816422 | 1816422 | 2021-10-14 | Wise | Virginia | 51195 | 5028 | 122 |
1816423 | 1816423 | 2021-10-14 | Wythe | Virginia | 51197 | 4332 | 93 |
1816424 | 1816424 | 2021-10-14 | York | Virginia | 51199 | 5306 | 73 |
1813044 | 1813044 | 2021-10-13 | Accomack | Virginia | 51001 | 3944 | 73 |
1813045 | 1813045 | 2021-10-13 | Albemarle | Virginia | 51003 | 7788 | 95 |
1813046 | 1813046 | 2021-10-13 | Alexandria city | Virginia | 51510 | 13971 | 148 |
1813047 | 1813047 | 2021-10-13 | Alleghany | Virginia | 51005 | 2037 | 63 |
1813048 | 1813048 | 2021-10-13 | Amelia | Virginia | 51007 | 1363 | 39 |
1813049 | 1813049 | 2021-10-13 | Amherst | Virginia | 51009 | 4235 | 54 |
1813050 | 1813050 | 2021-10-13 | Appomattox | Virginia | 51011 | 2316 | 35 |
1813051 | 1813051 | 2021-10-13 | Arlington | Virginia | 51013 | 18195 | 266 |
1813052 | 1813052 | 2021-10-13 | Augusta | Virginia | 51015 | 9981 | 115 |
1813053 | 1813053 | 2021-10-13 | Bath | Virginia | 51017 | 445 | 14 |
1813054 | 1813054 | 2021-10-13 | Bedford | Virginia | 51019 | 9603 | 142 |
1813055 | 1813055 | 2021-10-13 | Bland | Virginia | 51021 | 1042 | 15 |
1813056 | 1813056 | 2021-10-13 | Botetourt | Virginia | 51023 | 3675 | 44 |
1813057 | 1813057 | 2021-10-13 | Bristol city | Virginia | 51520 | 2212 | 47 |
1813058 | 1813058 | 2021-10-13 | Brunswick | Virginia | 51025 | 1758 | 32 |
1813059 | 1813059 | 2021-10-13 | Buchanan | Virginia | 51027 | 2273 | 57 |
1813060 | 1813060 | 2021-10-13 | Buckingham | Virginia | 51029 | 2589 | 37 |
1813061 | 1813061 | 2021-10-13 | Buena Vista city | Virginia | 51530 | 1237 | 23 |
1813062 | 1813062 | 2021-10-13 | Campbell | Virginia | 51031 | 6924 | 132 |
1813063 | 1813063 | 2021-10-13 | Caroline | Virginia | 51033 | 3752 | 49 |
1813064 | 1813064 | 2021-10-13 | Carroll | Virginia | 51035 | 3753 | 90 |
1813065 | 1813065 | 2021-10-13 | Charles City | Virginia | 51036 | 662 | 19 |
1813066 | 1813066 | 2021-10-13 | Charlotte | Virginia | 51037 | 1225 | 25 |
1813067 | 1813067 | 2021-10-13 | Charlottesville city | Virginia | 51540 | 5227 | 57 |
1813068 | 1813068 | 2021-10-13 | Chesapeake city | Virginia | 51550 | 28139 | 347 |
1813069 | 1813069 | 2021-10-13 | Chesterfield | Virginia | 51041 | 38524 | 524 |
1813070 | 1813070 | 2021-10-13 | Clarke | Virginia | 51043 | 1313 | 22 |
1813071 | 1813071 | 2021-10-13 | Colonial Heights city | Virginia | 51570 | 2528 | 64 |
1813072 | 1813072 | 2021-10-13 | Covington city | Virginia | 51580 | 739 | 15 |
1813073 | 1813073 | 2021-10-13 | Craig | Virginia | 51045 | 519 | 6 |
1813074 | 1813074 | 2021-10-13 | Culpeper | Virginia | 51047 | 6262 | 79 |
1813075 | 1813075 | 2021-10-13 | Cumberland | Virginia | 51049 | 696 | 13 |
1813076 | 1813076 | 2021-10-13 | Danville city | Virginia | 51590 | 6097 | 179 |
1813077 | 1813077 | 2021-10-13 | Dickenson | Virginia | 51051 | 1556 | 26 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);