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 147
- 51810 145
- 51107 144
- 51013 143
- 51085 142
- 51095 142
- 51147 142
- 51153 142
- 51510 142
- 51660 141
- 51041 140
- 51177 140
- 51179 138
- 51199 138
- 51075 137
- 51087 137
- 51540 137
- 51830 137
- 51036 136
- 51760 136
- 51001 134
- 51073 134
- 51700 134
- 51710 134
- 51740 134
- 51003 133
- 51023 133
- 51067 133
- 51093 133
- 51117 133
- 51800 133
- 51009 132
- 51019 132
- 51047 132
- 51065 132
- 51105 132
- 51109 132
- 51165 132
- 51163 131
- 51590 131
- 51083 130
- 51550 130
- 51069 129
- 51113 129
- 51115 129
- 51125 129
- 51135 129
- 51137 129
- 51161 129
- 51171 129
- 51630 129
- 51683 129
- 51007 128
- 51061 128
- 51079 128
- 51099 128
- 51131 128
- 51143 128
- 51149 128
- 51175 128
- 51187 128
- 51191 128
- 51650 128
- 51680 128
- 51735 128
- 51750 128
- 51520 127
- 51640 127
- 51770 127
- 51103 126
- 51121 126
- 51127 126
- 51133 126
- 51145 126
- 51670 126
- 51005 125
- 51081 125
- 51185 125
- 51197 125
- 51685 125
- 51840 125
- 51089 124
- 51101 124
- 51173 124
- 51730 124
- 51025 123
- 51029 123
- 51031 123
- 51035 123
- 51043 123
- 51097 123
- 51139 123
- 51181 123
- 51620 123
- 51820 123
- 51015 122
- 51183 122
- 51049 121
- 51775 121
- 51033 120
- 51155 120
- 51159 120
- 51193 120
- 51195 120
- 51530 120
- 51595 120
- 51678 120
- 51037 119
- 51790 119
- 51011 117
- 51071 117
- 51167 117
- 51027 116
- 51045 116
- 51053 116
- 51111 116
- 51157 116
- 51063 114
- 51119 114
- 51169 113
- 51570 113
- 51600 113
- 51610 110
- 51057 107
- 51141 102
- 51720 102
- 51091 101
- 51077 95
- 51690 95
- 51580 84
- 51051 46
- 51021 43
- - 31
- 51017 24
county 134
- Fairfax 147
- Virginia Beach city 145
- Loudoun 144
- Arlington 143
- Alexandria city 142
- Hanover 142
- James City 142
- Prince Edward 142
- Prince William 142
- Harrisonburg city 141
- Chesterfield 140
- Spotsylvania 140
- Stafford 138
- York 138
- Charlottesville city 137
- Goochland 137
- Henrico 137
- Williamsburg city 137
- Charles City 136
- Richmond city 136
- Accomack 134
- Gloucester 134
- Newport News city 134
- Norfolk city 134
- Portsmouth city 134
- Albemarle 133
- Botetourt 133
- Franklin 133
- Isle of Wight 133
- Mecklenburg 133
- Suffolk city 133
- Amherst 132
- Bedford 132
- Culpeper 132
- Fluvanna 132
- Lee 132
- Louisa 132
- Rockingham 132
- Danville city 131
- Rockbridge 131
- Chesapeake city 130
- Halifax 130
- Frederick 129
- Fredericksburg city 129
- Madison 129
- Manassas city 129
- Mathews 129
- Nelson 129
- Nottoway 129
- Orange 129
- Roanoke 129
- Shenandoah 129
- Amelia 128
- Fauquier 128
- Greene 128
- Hampton city 128
- King George 128
- Lynchburg city 128
- Northampton 128
- Pittsylvania 128
- Poquoson city 128
- Prince George 128
- Radford city 128
- Southampton 128
- Warren 128
- Washington 128
- Bristol city 127
- Galax city 127
- Roanoke city 127
- Hopewell city 126
- Lancaster 126
- Montgomery 126
- New Kent 126
- Northumberland 126
- Powhatan 126
- Alleghany 125
- Greensville 125
- Manassas Park city 125
- Tazewell 125
- Winchester city 125
- Wythe 125
- Henry 124
- King William 124
- Petersburg city 124
- Smyth 124
- Brunswick 123
- Buckingham 123
- Campbell 123
- Carroll 123
- Clarke 123
- Franklin city 123
- King and Queen 123
- Page 123
- Surry 123
- Waynesboro city 123
- Augusta 122
- Sussex 122
- Cumberland 121
- Salem city 121
- Buena Vista city 120
- Caroline 120
- Emporia city 120
- Lexington city 120
- Pulaski 120
- Richmond 120
- Westmoreland 120
- Wise 120
- Charlotte 119
- Staunton city 119
- Appomattox 117
- Giles 117
- Russell 117
- Buchanan 116
- Craig 116
- Dinwiddie 116
- Lunenburg 116
- Rappahannock 116
- Floyd 114
- Middlesex 114
- Colonial Heights city 113
- Fairfax city 113
- Scott 113
- Falls Church city 110
- Essex 107
- Norton city 102
- Patrick 102
- Highland 101
- Grayson 95
- Martinsville city 95
- Covington city 84
- Dickenson 46
- Bland 43
- Unknown 31
- Bath 24
state 1
- Virginia · 16,537 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
388833 | 388833 | 2020-07-31 | Accomack | Virginia | 51001 | 1074 | 15 |
388834 | 388834 | 2020-07-31 | Albemarle | Virginia | 51003 | 735 | 11 |
388835 | 388835 | 2020-07-31 | Alexandria city | Virginia | 51510 | 2798 | 58 |
388836 | 388836 | 2020-07-31 | Alleghany | Virginia | 51005 | 56 | 3 |
388837 | 388837 | 2020-07-31 | Amelia | Virginia | 51007 | 72 | 1 |
388838 | 388838 | 2020-07-31 | Amherst | Virginia | 51009 | 105 | 0 |
388839 | 388839 | 2020-07-31 | Appomattox | Virginia | 51011 | 68 | 0 |
388840 | 388840 | 2020-07-31 | Arlington | Virginia | 51013 | 2897 | 136 |
388841 | 388841 | 2020-07-31 | Augusta | Virginia | 51015 | 249 | 4 |
388842 | 388842 | 2020-07-31 | Bath | Virginia | 51017 | 4 | 0 |
388843 | 388843 | 2020-07-31 | Bedford | Virginia | 51019 | 286 | 6 |
388844 | 388844 | 2020-07-31 | Bland | Virginia | 51021 | 7 | 0 |
388845 | 388845 | 2020-07-31 | Botetourt | Virginia | 51023 | 185 | 5 |
388846 | 388846 | 2020-07-31 | Bristol city | Virginia | 51520 | 57 | 0 |
388847 | 388847 | 2020-07-31 | Brunswick | Virginia | 51025 | 197 | 1 |
388848 | 388848 | 2020-07-31 | Buchanan | Virginia | 51027 | 71 | 0 |
388849 | 388849 | 2020-07-31 | Buckingham | Virginia | 51029 | 593 | 6 |
388850 | 388850 | 2020-07-31 | Buena Vista city | Virginia | 51530 | 47 | 0 |
388851 | 388851 | 2020-07-31 | Campbell | Virginia | 51031 | 144 | 2 |
388852 | 388852 | 2020-07-31 | Caroline | Virginia | 51033 | 183 | 4 |
388853 | 388853 | 2020-07-31 | Carroll | Virginia | 51035 | 307 | 14 |
388854 | 388854 | 2020-07-31 | Charles City | Virginia | 51036 | 49 | 3 |
388855 | 388855 | 2020-07-31 | Charlotte | Virginia | 51037 | 50 | 0 |
388856 | 388856 | 2020-07-31 | Charlottesville city | Virginia | 51540 | 466 | 11 |
388857 | 388857 | 2020-07-31 | Chesapeake city | Virginia | 51550 | 2450 | 28 |
388858 | 388858 | 2020-07-31 | Chesterfield | Virginia | 51041 | 3937 | 72 |
388859 | 388859 | 2020-07-31 | Clarke | Virginia | 51043 | 69 | 0 |
388860 | 388860 | 2020-07-31 | Colonial Heights city | Virginia | 51570 | 178 | 21 |
388861 | 388861 | 2020-07-31 | Covington city | Virginia | 51580 | 12 | 0 |
388862 | 388862 | 2020-07-31 | Craig | Virginia | 51045 | 15 | 0 |
388863 | 388863 | 2020-07-31 | Culpeper | Virginia | 51047 | 942 | 12 |
388864 | 388864 | 2020-07-31 | Cumberland | Virginia | 51049 | 65 | 0 |
388865 | 388865 | 2020-07-31 | Danville city | Virginia | 51590 | 300 | 5 |
388866 | 388866 | 2020-07-31 | Dickenson | Virginia | 51051 | 22 | 0 |
388867 | 388867 | 2020-07-31 | Dinwiddie | Virginia | 51053 | 197 | 4 |
388868 | 388868 | 2020-07-31 | Emporia city | Virginia | 51595 | 163 | 15 |
388869 | 388869 | 2020-07-31 | Essex | Virginia | 51057 | 75 | 1 |
388870 | 388870 | 2020-07-31 | Fairfax | Virginia | 51059 | 15616 | 520 |
388871 | 388871 | 2020-07-31 | Fairfax city | Virginia | 51600 | 79 | 7 |
388872 | 388872 | 2020-07-31 | Falls Church city | Virginia | 51610 | 60 | 6 |
388873 | 388873 | 2020-07-31 | Fauquier | Virginia | 51061 | 571 | 8 |
388874 | 388874 | 2020-07-31 | Floyd | Virginia | 51063 | 32 | 1 |
388875 | 388875 | 2020-07-31 | Fluvanna | Virginia | 51065 | 173 | 8 |
388876 | 388876 | 2020-07-31 | Franklin | Virginia | 51067 | 151 | 1 |
388877 | 388877 | 2020-07-31 | Franklin city | Virginia | 51620 | 119 | 6 |
388878 | 388878 | 2020-07-31 | Frederick | Virginia | 51069 | 651 | 7 |
388879 | 388879 | 2020-07-31 | Fredericksburg city | Virginia | 51630 | 348 | 2 |
388880 | 388880 | 2020-07-31 | Galax city | Virginia | 51640 | 331 | 19 |
388881 | 388881 | 2020-07-31 | Giles | Virginia | 51071 | 23 | 0 |
388882 | 388882 | 2020-07-31 | Gloucester | Virginia | 51073 | 141 | 2 |
388883 | 388883 | 2020-07-31 | Goochland | Virginia | 51075 | 150 | 7 |
388884 | 388884 | 2020-07-31 | Grayson | Virginia | 51077 | 128 | 4 |
388885 | 388885 | 2020-07-31 | Greene | Virginia | 51079 | 134 | 2 |
388886 | 388886 | 2020-07-31 | Greensville | Virginia | 51081 | 417 | 9 |
388887 | 388887 | 2020-07-31 | Halifax | Virginia | 51083 | 130 | 1 |
388888 | 388888 | 2020-07-31 | Hampton city | Virginia | 51650 | 1007 | 5 |
388889 | 388889 | 2020-07-31 | Hanover | Virginia | 51085 | 584 | 31 |
388890 | 388890 | 2020-07-31 | Harrisonburg city | Virginia | 51660 | 1039 | 29 |
388891 | 388891 | 2020-07-31 | Henrico | Virginia | 51087 | 3541 | 180 |
388892 | 388892 | 2020-07-31 | Henry | Virginia | 51089 | 477 | 5 |
388893 | 388893 | 2020-07-31 | Highland | Virginia | 51091 | 3 | 0 |
388894 | 388894 | 2020-07-31 | Hopewell city | Virginia | 51670 | 254 | 5 |
388895 | 388895 | 2020-07-31 | Isle of Wight | Virginia | 51093 | 325 | 9 |
388896 | 388896 | 2020-07-31 | James City | Virginia | 51095 | 538 | 16 |
388897 | 388897 | 2020-07-31 | King George | Virginia | 51099 | 122 | 4 |
388898 | 388898 | 2020-07-31 | King William | Virginia | 51101 | 77 | 2 |
388899 | 388899 | 2020-07-31 | King and Queen | Virginia | 51097 | 35 | 1 |
388900 | 388900 | 2020-07-31 | Lancaster | Virginia | 51103 | 29 | 0 |
388901 | 388901 | 2020-07-31 | Lee | Virginia | 51105 | 91 | 1 |
388902 | 388902 | 2020-07-31 | Lexington city | Virginia | 51678 | 28 | 0 |
388903 | 388903 | 2020-07-31 | Loudoun | Virginia | 51107 | 4995 | 110 |
388904 | 388904 | 2020-07-31 | Louisa | Virginia | 51109 | 165 | 2 |
388905 | 388905 | 2020-07-31 | Lunenburg | Virginia | 51111 | 55 | 1 |
388906 | 388906 | 2020-07-31 | Lynchburg city | Virginia | 51680 | 429 | 2 |
388907 | 388907 | 2020-07-31 | Madison | Virginia | 51113 | 60 | 1 |
388908 | 388908 | 2020-07-31 | Manassas Park city | Virginia | 51685 | 497 | 7 |
388909 | 388909 | 2020-07-31 | Manassas city | Virginia | 51683 | 1604 | 20 |
388910 | 388910 | 2020-07-31 | Martinsville city | Virginia | 51690 | 159 | 3 |
388911 | 388911 | 2020-07-31 | Mathews | Virginia | 51115 | 12 | 0 |
388912 | 388912 | 2020-07-31 | Mecklenburg | Virginia | 51117 | 303 | 32 |
388913 | 388913 | 2020-07-31 | Middlesex | Virginia | 51119 | 26 | 1 |
388914 | 388914 | 2020-07-31 | Montgomery | Virginia | 51121 | 273 | 3 |
388915 | 388915 | 2020-07-31 | Nelson | Virginia | 51125 | 32 | 0 |
388916 | 388916 | 2020-07-31 | New Kent | Virginia | 51127 | 115 | 1 |
388917 | 388917 | 2020-07-31 | Newport News city | Virginia | 51700 | 1573 | 16 |
388918 | 388918 | 2020-07-31 | Norfolk city | Virginia | 51710 | 3180 | 24 |
388919 | 388919 | 2020-07-31 | Northampton | Virginia | 51131 | 292 | 28 |
388920 | 388920 | 2020-07-31 | Northumberland | Virginia | 51133 | 63 | 2 |
388921 | 388921 | 2020-07-31 | Norton city | Virginia | 51720 | 11 | 0 |
388922 | 388922 | 2020-07-31 | Nottoway | Virginia | 51135 | 172 | 9 |
388923 | 388923 | 2020-07-31 | Orange | Virginia | 51137 | 207 | 3 |
388924 | 388924 | 2020-07-31 | Page | Virginia | 51139 | 330 | 24 |
388925 | 388925 | 2020-07-31 | Patrick | Virginia | 51141 | 108 | 3 |
388926 | 388926 | 2020-07-31 | Petersburg city | Virginia | 51730 | 442 | 11 |
388927 | 388927 | 2020-07-31 | Pittsylvania | Virginia | 51143 | 316 | 2 |
388928 | 388928 | 2020-07-31 | Poquoson city | Virginia | 51735 | 36 | 0 |
388929 | 388929 | 2020-07-31 | Portsmouth city | Virginia | 51740 | 1462 | 22 |
388930 | 388930 | 2020-07-31 | Powhatan | Virginia | 51145 | 122 | 4 |
388931 | 388931 | 2020-07-31 | Prince Edward | Virginia | 51147 | 323 | 9 |
388932 | 388932 | 2020-07-31 | Prince George | Virginia | 51149 | 329 | 2 |
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);