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 678
- 51810 676
- 51107 675
- 51013 674
- 51085 673
- 51095 673
- 51147 673
- 51153 673
- 51510 673
- 51660 672
- 51041 671
- 51177 671
- 51179 669
- 51199 669
- 51075 668
- 51087 668
- 51540 668
- 51830 668
- 51036 667
- 51760 667
- 51001 665
- 51073 665
- 51700 665
- 51710 665
- 51740 665
- 51003 664
- 51023 664
- 51067 664
- 51093 664
- 51117 664
- 51800 664
- 51009 663
- 51019 663
- 51047 663
- 51065 663
- 51105 663
- 51109 663
- 51165 663
- 51163 662
- 51590 662
- 51083 661
- 51550 661
- 51069 660
- 51113 660
- 51115 660
- 51125 660
- 51135 660
- 51137 660
- 51161 660
- 51171 660
- 51630 660
- 51683 660
- 51007 659
- 51061 659
- 51079 659
- 51099 659
- 51131 659
- 51143 659
- 51149 659
- 51175 659
- 51187 659
- 51191 659
- 51650 659
- 51680 659
- 51735 659
- 51750 659
- 51520 658
- 51640 658
- 51770 658
- 51103 657
- 51121 657
- 51127 657
- 51133 657
- 51145 657
- 51670 657
- 51005 656
- 51081 656
- 51185 656
- 51197 656
- 51685 656
- 51840 656
- 51089 655
- 51101 655
- 51173 655
- 51730 655
- 51025 654
- 51029 654
- 51031 654
- 51035 654
- 51043 654
- 51097 654
- 51139 654
- 51181 654
- 51620 654
- 51820 654
- 51015 653
- 51183 653
- 51049 652
- 51775 652
- 51033 651
- 51155 651
- 51159 651
- 51193 651
- 51195 651
- 51530 651
- 51595 651
- 51678 651
- 51037 650
- 51790 650
- 51011 648
- 51071 648
- 51167 648
- 51027 647
- 51045 647
- 51053 647
- 51111 647
- 51157 647
- 51063 645
- 51119 645
- 51169 644
- 51570 644
- 51600 644
- 51610 641
- 51057 638
- 51141 633
- 51720 633
- 51091 632
- 51077 626
- 51690 626
- 51580 615
- 51051 577
- 51021 574
- 51017 555
- - 33
county 134
- Fairfax 678
- Virginia Beach city 676
- Loudoun 675
- Arlington 674
- Alexandria city 673
- Hanover 673
- James City 673
- Prince Edward 673
- Prince William 673
- Harrisonburg city 672
- Chesterfield 671
- Spotsylvania 671
- Stafford 669
- York 669
- Charlottesville city 668
- Goochland 668
- Henrico 668
- Williamsburg city 668
- Charles City 667
- Richmond city 667
- Accomack 665
- Gloucester 665
- Newport News city 665
- Norfolk city 665
- Portsmouth city 665
- Albemarle 664
- Botetourt 664
- Franklin 664
- Isle of Wight 664
- Mecklenburg 664
- Suffolk city 664
- Amherst 663
- Bedford 663
- Culpeper 663
- Fluvanna 663
- Lee 663
- Louisa 663
- Rockingham 663
- Danville city 662
- Rockbridge 662
- Chesapeake city 661
- Halifax 661
- Frederick 660
- Fredericksburg city 660
- Madison 660
- Manassas city 660
- Mathews 660
- Nelson 660
- Nottoway 660
- Orange 660
- Roanoke 660
- Shenandoah 660
- Amelia 659
- Fauquier 659
- Greene 659
- Hampton city 659
- King George 659
- Lynchburg city 659
- Northampton 659
- Pittsylvania 659
- Poquoson city 659
- Prince George 659
- Radford city 659
- Southampton 659
- Warren 659
- Washington 659
- Bristol city 658
- Galax city 658
- Roanoke city 658
- Hopewell city 657
- Lancaster 657
- Montgomery 657
- New Kent 657
- Northumberland 657
- Powhatan 657
- Alleghany 656
- Greensville 656
- Manassas Park city 656
- Tazewell 656
- Winchester city 656
- Wythe 656
- Henry 655
- King William 655
- Petersburg city 655
- Smyth 655
- Brunswick 654
- Buckingham 654
- Campbell 654
- Carroll 654
- Clarke 654
- Franklin city 654
- King and Queen 654
- Page 654
- Surry 654
- Waynesboro city 654
- Augusta 653
- Sussex 653
- Cumberland 652
- Salem city 652
- Buena Vista city 651
- Caroline 651
- Emporia city 651
- Lexington city 651
- Pulaski 651
- Richmond 651
- Westmoreland 651
- Wise 651
- Charlotte 650
- Staunton city 650
- Appomattox 648
- Giles 648
- Russell 648
- Buchanan 647
- Craig 647
- Dinwiddie 647
- Lunenburg 647
- Rappahannock 647
- Floyd 645
- Middlesex 645
- Colonial Heights city 644
- Fairfax city 644
- Scott 644
- Falls Church city 641
- Essex 638
- Norton city 633
- Patrick 633
- Highland 632
- Grayson 626
- Martinsville city 626
- Covington city 615
- Dickenson 577
- Bland 574
- Bath 555
- Unknown 33
state 1
- Virginia · 87,162 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2112058 | 2112058 | 2022-01-13 | Accomack | Virginia | 51001 | 5532 | 84 |
2112059 | 2112059 | 2022-01-13 | Albemarle | Virginia | 51003 | 11479 | 120 |
2112060 | 2112060 | 2022-01-13 | Alexandria city | Virginia | 51510 | 24719 | 163 |
2112061 | 2112061 | 2022-01-13 | Alleghany | Virginia | 51005 | 2755 | 90 |
2112062 | 2112062 | 2022-01-13 | Amelia | Virginia | 51007 | 2011 | 44 |
2112063 | 2112063 | 2022-01-13 | Amherst | Virginia | 51009 | 5495 | 64 |
2112064 | 2112064 | 2022-01-13 | Appomattox | Virginia | 51011 | 2956 | 38 |
2112065 | 2112065 | 2022-01-13 | Arlington | Virginia | 51013 | 33070 | 284 |
2112066 | 2112066 | 2022-01-13 | Augusta | Virginia | 51015 | 14298 | 149 |
2112067 | 2112067 | 2022-01-13 | Bath | Virginia | 51017 | 663 | 15 |
2112068 | 2112068 | 2022-01-13 | Bedford | Virginia | 51019 | 12748 | 179 |
2112069 | 2112069 | 2022-01-13 | Bland | Virginia | 51021 | 1287 | 18 |
2112070 | 2112070 | 2022-01-13 | Botetourt | Virginia | 51023 | 5508 | 67 |
2112071 | 2112071 | 2022-01-13 | Bristol city | Virginia | 51520 | 3036 | 58 |
2112072 | 2112072 | 2022-01-13 | Brunswick | Virginia | 51025 | 2227 | 37 |
2112073 | 2112073 | 2022-01-13 | Buchanan | Virginia | 51027 | 3433 | 89 |
2112074 | 2112074 | 2022-01-13 | Buckingham | Virginia | 51029 | 3069 | 41 |
2112075 | 2112075 | 2022-01-13 | Buena Vista city | Virginia | 51530 | 1636 | 34 |
2112076 | 2112076 | 2022-01-13 | Campbell | Virginia | 51031 | 9116 | 163 |
2112077 | 2112077 | 2022-01-13 | Caroline | Virginia | 51033 | 5607 | 59 |
2112078 | 2112078 | 2022-01-13 | Carroll | Virginia | 51035 | 5114 | 113 |
2112079 | 2112079 | 2022-01-13 | Charles City | Virginia | 51036 | 949 | 22 |
2112080 | 2112080 | 2022-01-13 | Charlotte | Virginia | 51037 | 1791 | 32 |
2112081 | 2112081 | 2022-01-13 | Charlottesville city | Virginia | 51540 | 7454 | 65 |
2112082 | 2112082 | 2022-01-13 | Chesapeake city | Virginia | 51550 | 40623 | 383 |
2112083 | 2112083 | 2022-01-13 | Chesterfield | Virginia | 51041 | 57307 | 611 |
2112084 | 2112084 | 2022-01-13 | Clarke | Virginia | 51043 | 2142 | 33 |
2112085 | 2112085 | 2022-01-13 | Colonial Heights city | Virginia | 51570 | 3704 | 72 |
2112086 | 2112086 | 2022-01-13 | Covington city | Virginia | 51580 | 852 | 20 |
2112087 | 2112087 | 2022-01-13 | Craig | Virginia | 51045 | 852 | 11 |
2112088 | 2112088 | 2022-01-13 | Culpeper | Virginia | 51047 | 9493 | 97 |
2112089 | 2112089 | 2022-01-13 | Cumberland | Virginia | 51049 | 971 | 19 |
2112090 | 2112090 | 2022-01-13 | Danville city | Virginia | 51590 | 8344 | 213 |
2112091 | 2112091 | 2022-01-13 | Dickenson | Virginia | 51051 | 2437 | 39 |
2112092 | 2112092 | 2022-01-13 | Dinwiddie | Virginia | 51053 | 4228 | 63 |
2112093 | 2112093 | 2022-01-13 | Emporia city | Virginia | 51595 | 950 | 46 |
2112094 | 2112094 | 2022-01-13 | Essex | Virginia | 51057 | 1828 | 22 |
2112095 | 2112095 | 2022-01-13 | Fairfax | Virginia | 51059 | 145736 | 1217 |
2112096 | 2112096 | 2022-01-13 | Fairfax city | Virginia | 51600 | 1728 | 36 |
2112097 | 2112097 | 2022-01-13 | Falls Church city | Virginia | 51610 | 1460 | 14 |
2112098 | 2112098 | 2022-01-13 | Fauquier | Virginia | 51061 | 10723 | 96 |
2112099 | 2112099 | 2022-01-13 | Floyd | Virginia | 51063 | 1985 | 33 |
2112100 | 2112100 | 2022-01-13 | Fluvanna | Virginia | 51065 | 3667 | 33 |
2112101 | 2112101 | 2022-01-13 | Franklin | Virginia | 51067 | 8308 | 134 |
2112102 | 2112102 | 2022-01-13 | Franklin city | Virginia | 51620 | 2075 | 43 |
2112103 | 2112103 | 2022-01-13 | Frederick | Virginia | 51069 | 17156 | 188 |
2112104 | 2112104 | 2022-01-13 | Fredericksburg city | Virginia | 51630 | 4416 | 27 |
2112105 | 2112105 | 2022-01-13 | Galax city | Virginia | 51640 | 1953 | 70 |
2112106 | 2112106 | 2022-01-13 | Giles | Virginia | 51071 | 2832 | 38 |
2112107 | 2112107 | 2022-01-13 | Gloucester | Virginia | 51073 | 5510 | 83 |
2112108 | 2112108 | 2022-01-13 | Goochland | Virginia | 51075 | 3026 | 36 |
2112109 | 2112109 | 2022-01-13 | Grayson | Virginia | 51077 | 2747 | 65 |
2112110 | 2112110 | 2022-01-13 | Greene | Virginia | 51079 | 3113 | 47 |
2112111 | 2112111 | 2022-01-13 | Greensville | Virginia | 51081 | 2655 | 30 |
2112112 | 2112112 | 2022-01-13 | Halifax | Virginia | 51083 | 5284 | 127 |
2112113 | 2112113 | 2022-01-13 | Hampton city | Virginia | 51650 | 22337 | 258 |
2112114 | 2112114 | 2022-01-13 | Hanover | Virginia | 51085 | 17186 | 209 |
2112115 | 2112115 | 2022-01-13 | Harrisonburg city | Virginia | 51660 | 10488 | 118 |
2112116 | 2112116 | 2022-01-13 | Henrico | Virginia | 51087 | 51281 | 754 |
2112117 | 2112117 | 2022-01-13 | Henry | Virginia | 51089 | 8599 | 212 |
2112118 | 2112118 | 2022-01-13 | Highland | Virginia | 51091 | 271 | 4 |
2112119 | 2112119 | 2022-01-13 | Hopewell city | Virginia | 51670 | 4971 | 99 |
2112120 | 2112120 | 2022-01-13 | Isle of Wight | Virginia | 51093 | 5946 | 92 |
2112121 | 2112121 | 2022-01-13 | James City | Virginia | 51095 | 11227 | 100 |
2112122 | 2112122 | 2022-01-13 | King George | Virginia | 51099 | 4045 | 27 |
2112123 | 2112123 | 2022-01-13 | King William | Virginia | 51101 | 2949 | 27 |
2112124 | 2112124 | 2022-01-13 | King and Queen | Virginia | 51097 | 926 | 9 |
2112125 | 2112125 | 2022-01-13 | Lancaster | Virginia | 51103 | 1442 | 24 |
2112126 | 2112126 | 2022-01-13 | Lee | Virginia | 51105 | 4370 | 71 |
2112127 | 2112127 | 2022-01-13 | Lexington city | Virginia | 51678 | 1972 | 38 |
2112128 | 2112128 | 2022-01-13 | Loudoun | Virginia | 51107 | 55231 | 315 |
2112129 | 2112129 | 2022-01-13 | Louisa | Virginia | 51109 | 4873 | 53 |
2112130 | 2112130 | 2022-01-13 | Lunenburg | Virginia | 51111 | 1511 | 24 |
2112131 | 2112131 | 2022-01-13 | Lynchburg city | Virginia | 51680 | 15285 | 223 |
2112132 | 2112132 | 2022-01-13 | Madison | Virginia | 51113 | 1579 | 25 |
2112133 | 2112133 | 2022-01-13 | Manassas Park city | Virginia | 51685 | 1809 | 16 |
2112134 | 2112134 | 2022-01-13 | Manassas city | Virginia | 51683 | 7610 | 57 |
2112135 | 2112135 | 2022-01-13 | Martinsville city | Virginia | 51690 | 2656 | 100 |
2112136 | 2112136 | 2022-01-13 | Mathews | Virginia | 51115 | 1157 | 24 |
2112137 | 2112137 | 2022-01-13 | Mecklenburg | Virginia | 51117 | 4261 | 99 |
2112138 | 2112138 | 2022-01-13 | Middlesex | Virginia | 51119 | 1364 | 34 |
2112139 | 2112139 | 2022-01-13 | Montgomery | Virginia | 51121 | 14462 | 121 |
2112140 | 2112140 | 2022-01-13 | Nelson | Virginia | 51125 | 2075 | 25 |
2112141 | 2112141 | 2022-01-13 | New Kent | Virginia | 51127 | 3472 | 28 |
2112142 | 2112142 | 2022-01-13 | Newport News city | Virginia | 51700 | 29593 | 320 |
2112143 | 2112143 | 2022-01-13 | Norfolk city | Virginia | 51710 | 34173 | 371 |
2112144 | 2112144 | 2022-01-13 | Northampton | Virginia | 51131 | 1586 | 51 |
2112145 | 2112145 | 2022-01-13 | Northumberland | Virginia | 51133 | 1722 | 39 |
2112146 | 2112146 | 2022-01-13 | Norton city | Virginia | 51720 | 873 | 20 |
2112147 | 2112147 | 2022-01-13 | Nottoway | Virginia | 51135 | 3232 | 72 |
2112148 | 2112148 | 2022-01-13 | Orange | Virginia | 51137 | 5473 | 69 |
2112149 | 2112149 | 2022-01-13 | Page | Virginia | 51139 | 4602 | 93 |
2112150 | 2112150 | 2022-01-13 | Patrick | Virginia | 51141 | 2791 | 72 |
2112151 | 2112151 | 2022-01-13 | Petersburg city | Virginia | 51730 | 6916 | 111 |
2112152 | 2112152 | 2022-01-13 | Pittsylvania | Virginia | 51143 | 10282 | 147 |
2112153 | 2112153 | 2022-01-13 | Poquoson city | Virginia | 51735 | 1860 | 24 |
2112154 | 2112154 | 2022-01-13 | Portsmouth city | Virginia | 51740 | 17624 | 256 |
2112155 | 2112155 | 2022-01-13 | Powhatan | Virginia | 51145 | 3935 | 33 |
2112156 | 2112156 | 2022-01-13 | Prince Edward | Virginia | 51147 | 3646 | 54 |
2112157 | 2112157 | 2022-01-13 | Prince George | Virginia | 51149 | 6435 | 53 |
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);