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 134
- 51059 465
- 51810 463
- 51107 462
- 51013 461
- 51085 460
- 51095 460
- 51147 460
- 51153 460
- 51510 460
- 51660 459
- 51041 458
- 51177 458
- 51179 456
- 51199 456
- 51075 455
- 51087 455
- 51540 455
- 51830 455
- 51036 454
- 51760 454
- 51001 452
- 51073 452
- 51700 452
- 51710 452
- 51740 452
- 51003 451
- 51023 451
- 51067 451
- 51093 451
- 51117 451
- 51800 451
- 51009 450
- 51019 450
- 51047 450
- 51065 450
- 51105 450
- 51109 450
- 51165 450
- 51163 449
- 51590 449
- 51083 448
- 51550 448
- 51069 447
- 51113 447
- 51115 447
- 51125 447
- 51135 447
- 51137 447
- 51161 447
- 51171 447
- 51630 447
- 51683 447
- 51007 446
- 51061 446
- 51079 446
- 51099 446
- 51131 446
- 51143 446
- 51149 446
- 51175 446
- 51187 446
- 51191 446
- 51650 446
- 51680 446
- 51735 446
- 51750 446
- 51520 445
- 51640 445
- 51770 445
- 51103 444
- 51121 444
- 51127 444
- 51133 444
- 51145 444
- 51670 444
- 51005 443
- 51081 443
- 51185 443
- 51197 443
- 51685 443
- 51840 443
- 51089 442
- 51101 442
- 51173 442
- 51730 442
- 51025 441
- 51029 441
- 51031 441
- 51035 441
- 51043 441
- 51097 441
- 51139 441
- 51181 441
- 51620 441
- 51820 441
- 51015 440
- 51183 440
- 51049 439
- 51775 439
- 51033 438
- 51155 438
- 51159 438
- 51193 438
- 51195 438
- 51530 438
- 51595 438
- 51678 438
- 51037 437
- 51790 437
- 51011 435
- 51071 435
- 51167 435
- 51027 434
- 51045 434
- 51053 434
- 51111 434
- 51157 434
- 51063 432
- 51119 432
- 51169 431
- 51570 431
- 51600 431
- 51610 428
- 51057 425
- 51141 420
- 51720 420
- 51091 419
- 51077 413
- 51690 413
- 51580 402
- 51051 364
- 51021 361
- 51017 342
- - 31
county 134
- Fairfax 465
- Virginia Beach city 463
- Loudoun 462
- Arlington 461
- Alexandria city 460
- Hanover 460
- James City 460
- Prince Edward 460
- Prince William 460
- Harrisonburg city 459
- Chesterfield 458
- Spotsylvania 458
- Stafford 456
- York 456
- Charlottesville city 455
- Goochland 455
- Henrico 455
- Williamsburg city 455
- Charles City 454
- Richmond city 454
- Accomack 452
- Gloucester 452
- Newport News city 452
- Norfolk city 452
- Portsmouth city 452
- Albemarle 451
- Botetourt 451
- Franklin 451
- Isle of Wight 451
- Mecklenburg 451
- Suffolk city 451
- Amherst 450
- Bedford 450
- Culpeper 450
- Fluvanna 450
- Lee 450
- Louisa 450
- Rockingham 450
- Danville city 449
- Rockbridge 449
- Chesapeake city 448
- Halifax 448
- Frederick 447
- Fredericksburg city 447
- Madison 447
- Manassas city 447
- Mathews 447
- Nelson 447
- Nottoway 447
- Orange 447
- Roanoke 447
- Shenandoah 447
- Amelia 446
- Fauquier 446
- Greene 446
- Hampton city 446
- King George 446
- Lynchburg city 446
- Northampton 446
- Pittsylvania 446
- Poquoson city 446
- Prince George 446
- Radford city 446
- Southampton 446
- Warren 446
- Washington 446
- Bristol city 445
- Galax city 445
- Roanoke city 445
- Hopewell city 444
- Lancaster 444
- Montgomery 444
- New Kent 444
- Northumberland 444
- Powhatan 444
- Alleghany 443
- Greensville 443
- Manassas Park city 443
- Tazewell 443
- Winchester city 443
- Wythe 443
- Henry 442
- King William 442
- Petersburg city 442
- Smyth 442
- Brunswick 441
- Buckingham 441
- Campbell 441
- Carroll 441
- Clarke 441
- Franklin city 441
- King and Queen 441
- Page 441
- Surry 441
- Waynesboro city 441
- Augusta 440
- Sussex 440
- Cumberland 439
- Salem city 439
- Buena Vista city 438
- Caroline 438
- Emporia city 438
- Lexington city 438
- Pulaski 438
- Richmond 438
- Westmoreland 438
- Wise 438
- Charlotte 437
- Staunton city 437
- Appomattox 435
- Giles 435
- Russell 435
- Buchanan 434
- Craig 434
- Dinwiddie 434
- Lunenburg 434
- Rappahannock 434
- Floyd 432
- Middlesex 432
- Colonial Heights city 431
- Fairfax city 431
- Scott 431
- Falls Church city 428
- Essex 425
- Norton city 420
- Patrick 420
- Highland 419
- Grayson 413
- Martinsville city 413
- Covington city 402
- Dickenson 364
- Bland 361
- Bath 342
- Unknown 31
state 1
- Virginia · 58,831 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1420053 | 1420053 | 2021-06-14 | Accomack | Virginia | 51001 | 2866 | 45 |
1420054 | 1420054 | 2021-06-14 | Albemarle | Virginia | 51003 | 5811 | 84 |
1420055 | 1420055 | 2021-06-14 | Alexandria city | Virginia | 51510 | 11854 | 137 |
1420056 | 1420056 | 2021-06-14 | Alleghany | Virginia | 51005 | 1367 | 49 |
1420057 | 1420057 | 2021-06-14 | Amelia | Virginia | 51007 | 927 | 34 |
1420058 | 1420058 | 2021-06-14 | Amherst | Virginia | 51009 | 2975 | 40 |
1420059 | 1420059 | 2021-06-14 | Appomattox | Virginia | 51011 | 1621 | 26 |
1420060 | 1420060 | 2021-06-14 | Arlington | Virginia | 51013 | 15293 | 257 |
1420061 | 1420061 | 2021-06-14 | Augusta | Virginia | 51015 | 5966 | 75 |
1420062 | 1420062 | 2021-06-14 | Bath | Virginia | 51017 | 271 | 11 |
1420063 | 1420063 | 2021-06-14 | Bedford | Virginia | 51019 | 6640 | 109 |
1420064 | 1420064 | 2021-06-14 | Bland | Virginia | 51021 | 683 | 10 |
1420065 | 1420065 | 2021-06-14 | Botetourt | Virginia | 51023 | 2579 | 38 |
1420066 | 1420066 | 2021-06-14 | Bristol city | Virginia | 51520 | 1578 | 36 |
1420067 | 1420067 | 2021-06-14 | Brunswick | Virginia | 51025 | 1337 | 24 |
1420068 | 1420068 | 2021-06-14 | Buchanan | Virginia | 51027 | 1511 | 45 |
1420069 | 1420069 | 2021-06-14 | Buckingham | Virginia | 51029 | 2143 | 32 |
1420070 | 1420070 | 2021-06-14 | Buena Vista city | Virginia | 51530 | 927 | 22 |
1420071 | 1420071 | 2021-06-14 | Campbell | Virginia | 51031 | 4584 | 88 |
1420072 | 1420072 | 2021-06-14 | Caroline | Virginia | 51033 | 2674 | 38 |
1420073 | 1420073 | 2021-06-14 | Carroll | Virginia | 51035 | 2718 | 78 |
1420074 | 1420074 | 2021-06-14 | Charles City | Virginia | 51036 | 507 | 16 |
1420075 | 1420075 | 2021-06-14 | Charlotte | Virginia | 51037 | 870 | 21 |
1420076 | 1420076 | 2021-06-14 | Charlottesville city | Virginia | 51540 | 4024 | 57 |
1420077 | 1420077 | 2021-06-14 | Chesapeake city | Virginia | 51550 | 21167 | 304 |
1420078 | 1420078 | 2021-06-14 | Chesterfield | Virginia | 51041 | 28200 | 447 |
1420079 | 1420079 | 2021-06-14 | Clarke | Virginia | 51043 | 991 | 20 |
1420080 | 1420080 | 2021-06-14 | Colonial Heights city | Virginia | 51570 | 1717 | 62 |
1420081 | 1420081 | 2021-06-14 | Covington city | Virginia | 51580 | 613 | 14 |
1420082 | 1420082 | 2021-06-14 | Craig | Virginia | 51045 | 323 | 6 |
1420083 | 1420083 | 2021-06-14 | Culpeper | Virginia | 51047 | 4696 | 67 |
1420084 | 1420084 | 2021-06-14 | Cumberland | Virginia | 51049 | 508 | 10 |
1420085 | 1420085 | 2021-06-14 | Danville city | Virginia | 51590 | 4490 | 141 |
1420086 | 1420086 | 2021-06-14 | Dickenson | Virginia | 51051 | 956 | 18 |
1420087 | 1420087 | 2021-06-14 | Dinwiddie | Virginia | 51053 | 2140 | 45 |
1420088 | 1420088 | 2021-06-14 | Emporia city | Virginia | 51595 | 673 | 42 |
1420089 | 1420089 | 2021-06-14 | Essex | Virginia | 51057 | 781 | 10 |
1420090 | 1420090 | 2021-06-14 | Fairfax | Virginia | 51059 | 77017 | 1106 |
1420091 | 1420091 | 2021-06-14 | Fairfax city | Virginia | 51600 | 567 | 20 |
1420092 | 1420092 | 2021-06-14 | Falls Church city | Virginia | 51610 | 429 | 8 |
1420093 | 1420093 | 2021-06-14 | Fauquier | Virginia | 51061 | 4756 | 69 |
1420094 | 1420094 | 2021-06-14 | Floyd | Virginia | 51063 | 881 | 23 |
1420095 | 1420095 | 2021-06-14 | Fluvanna | Virginia | 51065 | 1925 | 20 |
1420096 | 1420096 | 2021-06-14 | Franklin | Virginia | 51067 | 4094 | 80 |
1420097 | 1420097 | 2021-06-14 | Franklin city | Virginia | 51620 | 1136 | 33 |
1420098 | 1420098 | 2021-06-14 | Frederick | Virginia | 51069 | 8092 | 102 |
1420099 | 1420099 | 2021-06-14 | Fredericksburg city | Virginia | 51630 | 2149 | 25 |
1420100 | 1420100 | 2021-06-14 | Galax city | Virginia | 51640 | 1170 | 53 |
1420101 | 1420101 | 2021-06-14 | Giles | Virginia | 51071 | 1314 | 22 |
1420102 | 1420102 | 2021-06-14 | Gloucester | Virginia | 51073 | 2260 | 49 |
1420103 | 1420103 | 2021-06-14 | Goochland | Virginia | 51075 | 1468 | 23 |
1420104 | 1420104 | 2021-06-14 | Grayson | Virginia | 51077 | 1505 | 37 |
1420105 | 1420105 | 2021-06-14 | Greene | Virginia | 51079 | 1297 | 18 |
1420106 | 1420106 | 2021-06-14 | Greensville | Virginia | 51081 | 1590 | 26 |
1420107 | 1420107 | 2021-06-14 | Halifax | Virginia | 51083 | 2834 | 78 |
1420108 | 1420108 | 2021-06-14 | Hampton city | Virginia | 51650 | 10691 | 180 |
1420109 | 1420109 | 2021-06-14 | Hanover | Virginia | 51085 | 8221 | 166 |
1420110 | 1420110 | 2021-06-14 | Harrisonburg city | Virginia | 51660 | 6515 | 95 |
1420111 | 1420111 | 2021-06-14 | Henrico | Virginia | 51087 | 25597 | 625 |
1420112 | 1420112 | 2021-06-14 | Henry | Virginia | 51089 | 4671 | 124 |
1420113 | 1420113 | 2021-06-14 | Highland | Virginia | 51091 | 110 | 1 |
1420114 | 1420114 | 2021-06-14 | Hopewell city | Virginia | 51670 | 2631 | 79 |
1420115 | 1420115 | 2021-06-14 | Isle of Wight | Virginia | 51093 | 3171 | 70 |
1420116 | 1420116 | 2021-06-14 | James City | Virginia | 51095 | 4662 | 72 |
1420117 | 1420117 | 2021-06-14 | King George | Virginia | 51099 | 1739 | 20 |
1420118 | 1420118 | 2021-06-14 | King William | Virginia | 51101 | 1248 | 14 |
1420119 | 1420119 | 2021-06-14 | King and Queen | Virginia | 51097 | 410 | 8 |
1420120 | 1420120 | 2021-06-14 | Lancaster | Virginia | 51103 | 718 | 17 |
1420121 | 1420121 | 2021-06-14 | Lee | Virginia | 51105 | 2432 | 49 |
1420122 | 1420122 | 2021-06-14 | Lexington city | Virginia | 51678 | 1207 | 32 |
1420123 | 1420123 | 2021-06-14 | Loudoun | Virginia | 51107 | 28015 | 281 |
1420124 | 1420124 | 2021-06-14 | Louisa | Virginia | 51109 | 2008 | 34 |
1420125 | 1420125 | 2021-06-14 | Lunenburg | Virginia | 51111 | 790 | 14 |
1420126 | 1420126 | 2021-06-14 | Lynchburg city | Virginia | 51680 | 7838 | 154 |
1420127 | 1420127 | 2021-06-14 | Madison | Virginia | 51113 | 593 | 14 |
1420128 | 1420128 | 2021-06-14 | Manassas Park city | Virginia | 51685 | 1219 | 11 |
1420129 | 1420129 | 2021-06-14 | Manassas city | Virginia | 51683 | 4309 | 47 |
1420130 | 1420130 | 2021-06-14 | Martinsville city | Virginia | 51690 | 1622 | 78 |
1420131 | 1420131 | 2021-06-14 | Mathews | Virginia | 51115 | 599 | 12 |
1420132 | 1420132 | 2021-06-14 | Mecklenburg | Virginia | 51117 | 2348 | 67 |
1420133 | 1420133 | 2021-06-14 | Middlesex | Virginia | 51119 | 574 | 20 |
1420134 | 1420134 | 2021-06-14 | Montgomery | Virginia | 51121 | 9414 | 96 |
1420135 | 1420135 | 2021-06-14 | Nelson | Virginia | 51125 | 894 | 13 |
1420136 | 1420136 | 2021-06-14 | New Kent | Virginia | 51127 | 1522 | 18 |
1420137 | 1420137 | 2021-06-14 | Newport News city | Virginia | 51700 | 14270 | 235 |
1420138 | 1420138 | 2021-06-14 | Norfolk city | Virginia | 51710 | 17963 | 267 |
1420139 | 1420139 | 2021-06-14 | Northampton | Virginia | 51131 | 807 | 36 |
1420140 | 1420140 | 2021-06-14 | Northumberland | Virginia | 51133 | 745 | 20 |
1420141 | 1420141 | 2021-06-14 | Norton city | Virginia | 51720 | 290 | 7 |
1420142 | 1420142 | 2021-06-14 | Nottoway | Virginia | 51135 | 1924 | 49 |
1420143 | 1420143 | 2021-06-14 | Orange | Virginia | 51137 | 2240 | 39 |
1420144 | 1420144 | 2021-06-14 | Page | Virginia | 51139 | 2119 | 58 |
1420145 | 1420145 | 2021-06-14 | Patrick | Virginia | 51141 | 1391 | 43 |
1420146 | 1420146 | 2021-06-14 | Petersburg city | Virginia | 51730 | 3934 | 88 |
1420147 | 1420147 | 2021-06-14 | Pittsylvania | Virginia | 51143 | 5590 | 82 |
1420148 | 1420148 | 2021-06-14 | Poquoson city | Virginia | 51735 | 896 | 18 |
1420149 | 1420149 | 2021-06-14 | Portsmouth city | Virginia | 51740 | 9167 | 202 |
1420150 | 1420150 | 2021-06-14 | Powhatan | Virginia | 51145 | 1923 | 17 |
1420151 | 1420151 | 2021-06-14 | Prince Edward | Virginia | 51147 | 2172 | 35 |
1420152 | 1420152 | 2021-06-14 | Prince George | Virginia | 51149 | 3639 | 32 |
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);