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 557
- 51810 555
- 51107 554
- 51013 553
- 51085 552
- 51095 552
- 51147 552
- 51153 552
- 51510 552
- 51660 551
- 51041 550
- 51177 550
- 51179 548
- 51199 548
- 51075 547
- 51087 547
- 51540 547
- 51830 547
- 51036 546
- 51760 546
- 51001 544
- 51073 544
- 51700 544
- 51710 544
- 51740 544
- 51003 543
- 51023 543
- 51067 543
- 51093 543
- 51117 543
- …
county >30
- Fairfax 557
- Virginia Beach city 555
- Loudoun 554
- Arlington 553
- Alexandria city 552
- Hanover 552
- James City 552
- Prince Edward 552
- Prince William 552
- Harrisonburg city 551
- Chesterfield 550
- Spotsylvania 550
- Stafford 548
- York 548
- Charlottesville city 547
- Goochland 547
- Henrico 547
- Williamsburg city 547
- Charles City 546
- Richmond city 546
- Accomack 544
- Gloucester 544
- Newport News city 544
- Norfolk city 544
- Portsmouth city 544
- Albemarle 543
- Botetourt 543
- Franklin 543
- Isle of Wight 543
- Mecklenburg 543
- …
state 1
- Virginia · 71,068 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1718819 | 1718819 | 2021-09-14 | Accomack | Virginia | 51001 | 3529 | 58 |
1718820 | 1718820 | 2021-09-14 | Albemarle | Virginia | 51003 | 6991 | 89 |
1718821 | 1718821 | 2021-09-14 | Alexandria city | Virginia | 51510 | 13247 | 142 |
1718822 | 1718822 | 2021-09-14 | Alleghany | Virginia | 51005 | 1727 | 59 |
1718823 | 1718823 | 2021-09-14 | Amelia | Virginia | 51007 | 1178 | 38 |
1718824 | 1718824 | 2021-09-14 | Amherst | Virginia | 51009 | 3850 | 45 |
1718825 | 1718825 | 2021-09-14 | Appomattox | Virginia | 51011 | 2059 | 29 |
1718826 | 1718826 | 2021-09-14 | Arlington | Virginia | 51013 | 17207 | 261 |
1718827 | 1718827 | 2021-09-14 | Augusta | Virginia | 51015 | 8614 | 93 |
1718828 | 1718828 | 2021-09-14 | Bath | Virginia | 51017 | 353 | 11 |
1718829 | 1718829 | 2021-09-14 | Bedford | Virginia | 51019 | 8483 | 116 |
1718830 | 1718830 | 2021-09-14 | Bland | Virginia | 51021 | 914 | 12 |
1718831 | 1718831 | 2021-09-14 | Botetourt | Virginia | 51023 | 3163 | 39 |
1718832 | 1718832 | 2021-09-14 | Bristol city | Virginia | 51520 | 2000 | 41 |
1718833 | 1718833 | 2021-09-14 | Brunswick | Virginia | 51025 | 1614 | 29 |
1718834 | 1718834 | 2021-09-14 | Buchanan | Virginia | 51027 | 1945 | 47 |
1718835 | 1718835 | 2021-09-14 | Buckingham | Virginia | 51029 | 2402 | 34 |
1718836 | 1718836 | 2021-09-14 | Buena Vista city | Virginia | 51530 | 1056 | 22 |
1718837 | 1718837 | 2021-09-14 | Campbell | Virginia | 51031 | 6183 | 118 |
1718838 | 1718838 | 2021-09-14 | Caroline | Virginia | 51033 | 3385 | 43 |
1718839 | 1718839 | 2021-09-14 | Carroll | Virginia | 51035 | 3267 | 81 |
1718840 | 1718840 | 2021-09-14 | Charles City | Virginia | 51036 | 614 | 17 |
1718841 | 1718841 | 2021-09-14 | Charlotte | Virginia | 51037 | 1081 | 22 |
1718842 | 1718842 | 2021-09-14 | Charlottesville city | Virginia | 51540 | 4789 | 55 |
1718843 | 1718843 | 2021-09-14 | Chesapeake city | Virginia | 51550 | 25901 | 322 |
1718844 | 1718844 | 2021-09-14 | Chesterfield | Virginia | 51041 | 34910 | 476 |
1718845 | 1718845 | 2021-09-14 | Clarke | Virginia | 51043 | 1147 | 22 |
1718846 | 1718846 | 2021-09-14 | Colonial Heights city | Virginia | 51570 | 2245 | 62 |
1718847 | 1718847 | 2021-09-14 | Covington city | Virginia | 51580 | 673 | 14 |
1718848 | 1718848 | 2021-09-14 | Craig | Virginia | 51045 | 438 | 6 |
1718849 | 1718849 | 2021-09-14 | Culpeper | Virginia | 51047 | 5620 | 70 |
1718850 | 1718850 | 2021-09-14 | Cumberland | Virginia | 51049 | 624 | 11 |
1718851 | 1718851 | 2021-09-14 | Danville city | Virginia | 51590 | 5502 | 157 |
1718852 | 1718852 | 2021-09-14 | Dickenson | Virginia | 51051 | 1293 | 20 |
1718853 | 1718853 | 2021-09-14 | Dinwiddie | Virginia | 51053 | 2690 | 47 |
1718854 | 1718854 | 2021-09-14 | Emporia city | Virginia | 51595 | 797 | 42 |
1718855 | 1718855 | 2021-09-14 | Essex | Virginia | 51057 | 974 | 12 |
1718856 | 1718856 | 2021-09-14 | Fairfax | Virginia | 51059 | 85432 | 1143 |
1718857 | 1718857 | 2021-09-14 | Fairfax city | Virginia | 51600 | 619 | 19 |
1718858 | 1718858 | 2021-09-14 | Falls Church city | Virginia | 51610 | 496 | 8 |
1718859 | 1718859 | 2021-09-14 | Fauquier | Virginia | 51061 | 6022 | 75 |
1718860 | 1718860 | 2021-09-14 | Floyd | Virginia | 51063 | 1148 | 23 |
1718861 | 1718861 | 2021-09-14 | Fluvanna | Virginia | 51065 | 2283 | 22 |
1718862 | 1718862 | 2021-09-14 | Franklin | Virginia | 51067 | 5120 | 86 |
1718863 | 1718863 | 2021-09-14 | Franklin city | Virginia | 51620 | 1361 | 38 |
1718864 | 1718864 | 2021-09-14 | Frederick | Virginia | 51069 | 9829 | 111 |
1718865 | 1718865 | 2021-09-14 | Fredericksburg city | Virginia | 51630 | 2674 | 25 |
1718866 | 1718866 | 2021-09-14 | Galax city | Virginia | 51640 | 1359 | 53 |
1718867 | 1718867 | 2021-09-14 | Giles | Virginia | 51071 | 1762 | 24 |
1718868 | 1718868 | 2021-09-14 | Gloucester | Virginia | 51073 | 3275 | 54 |
1718869 | 1718869 | 2021-09-14 | Goochland | Virginia | 51075 | 1754 | 27 |
1718870 | 1718870 | 2021-09-14 | Grayson | Virginia | 51077 | 1795 | 40 |
1718871 | 1718871 | 2021-09-14 | Greene | Virginia | 51079 | 1744 | 24 |
1718872 | 1718872 | 2021-09-14 | Greensville | Virginia | 51081 | 1719 | 26 |
1718873 | 1718873 | 2021-09-14 | Halifax | Virginia | 51083 | 3334 | 90 |
1718874 | 1718874 | 2021-09-14 | Hampton city | Virginia | 51650 | 13401 | 199 |
1718875 | 1718875 | 2021-09-14 | Hanover | Virginia | 51085 | 10231 | 179 |
1718876 | 1718876 | 2021-09-14 | Harrisonburg city | Virginia | 51660 | 7480 | 96 |
1718877 | 1718877 | 2021-09-14 | Henrico | Virginia | 51087 | 31066 | 662 |
1718878 | 1718878 | 2021-09-14 | Henry | Virginia | 51089 | 5591 | 135 |
1718879 | 1718879 | 2021-09-14 | Highland | Virginia | 51091 | 146 | 1 |
1718880 | 1718880 | 2021-09-14 | Hopewell city | Virginia | 51670 | 3315 | 83 |
1718881 | 1718881 | 2021-09-14 | Isle of Wight | Virginia | 51093 | 3826 | 74 |
1718882 | 1718882 | 2021-09-14 | James City | Virginia | 51095 | 6016 | 82 |
1718883 | 1718883 | 2021-09-14 | King George | Virginia | 51099 | 2151 | 21 |
1718884 | 1718884 | 2021-09-14 | King William | Virginia | 51101 | 1619 | 18 |
1718885 | 1718885 | 2021-09-14 | King and Queen | Virginia | 51097 | 538 | 7 |
1718886 | 1718886 | 2021-09-14 | Lancaster | Virginia | 51103 | 949 | 19 |
1718887 | 1718887 | 2021-09-14 | Lee | Virginia | 51105 | 3014 | 50 |
1718888 | 1718888 | 2021-09-14 | Lexington city | Virginia | 51678 | 1394 | 33 |
1718889 | 1718889 | 2021-09-14 | Loudoun | Virginia | 51107 | 31407 | 287 |
1718890 | 1718890 | 2021-09-14 | Louisa | Virginia | 51109 | 2579 | 39 |
1718891 | 1718891 | 2021-09-14 | Lunenburg | Virginia | 51111 | 928 | 18 |
1718892 | 1718892 | 2021-09-14 | Lynchburg city | Virginia | 51680 | 9891 | 161 |
1718893 | 1718893 | 2021-09-14 | Madison | Virginia | 51113 | 799 | 17 |
1718894 | 1718894 | 2021-09-14 | Manassas Park city | Virginia | 51685 | 1250 | 11 |
1718895 | 1718895 | 2021-09-14 | Manassas city | Virginia | 51683 | 4650 | 49 |
1718896 | 1718896 | 2021-09-14 | Martinsville city | Virginia | 51690 | 1829 | 82 |
1718897 | 1718897 | 2021-09-14 | Mathews | Virginia | 51115 | 783 | 15 |
1718898 | 1718898 | 2021-09-14 | Mecklenburg | Virginia | 51117 | 2936 | 73 |
1718899 | 1718899 | 2021-09-14 | Middlesex | Virginia | 51119 | 774 | 24 |
1718900 | 1718900 | 2021-09-14 | Montgomery | Virginia | 51121 | 10708 | 84 |
1718901 | 1718901 | 2021-09-14 | Nelson | Virginia | 51125 | 1139 | 14 |
1718902 | 1718902 | 2021-09-14 | New Kent | Virginia | 51127 | 1933 | 20 |
1718903 | 1718903 | 2021-09-14 | Newport News city | Virginia | 51700 | 18236 | 254 |
1718904 | 1718904 | 2021-09-14 | Norfolk city | Virginia | 51710 | 21952 | 295 |
1718905 | 1718905 | 2021-09-14 | Northampton | Virginia | 51131 | 982 | 38 |
1718906 | 1718906 | 2021-09-14 | Northumberland | Virginia | 51133 | 1016 | 22 |
1718907 | 1718907 | 2021-09-14 | Norton city | Virginia | 51720 | 422 | 8 |
1718908 | 1718908 | 2021-09-14 | Nottoway | Virginia | 51135 | 2299 | 57 |
1718909 | 1718909 | 2021-09-14 | Orange | Virginia | 51137 | 2945 | 44 |
1718910 | 1718910 | 2021-09-14 | Page | Virginia | 51139 | 2666 | 62 |
1718911 | 1718911 | 2021-09-14 | Patrick | Virginia | 51141 | 1759 | 47 |
1718912 | 1718912 | 2021-09-14 | Petersburg city | Virginia | 51730 | 4719 | 95 |
1718913 | 1718913 | 2021-09-14 | Pittsylvania | Virginia | 51143 | 6911 | 93 |
1718914 | 1718914 | 2021-09-14 | Poquoson city | Virginia | 51735 | 1105 | 18 |
1718915 | 1718915 | 2021-09-14 | Portsmouth city | Virginia | 51740 | 11212 | 214 |
1718916 | 1718916 | 2021-09-14 | Powhatan | Virginia | 51145 | 2427 | 19 |
1718917 | 1718917 | 2021-09-14 | Prince Edward | Virginia | 51147 | 2537 | 40 |
1718918 | 1718918 | 2021-09-14 | Prince George | Virginia | 51149 | 4383 | 33 |
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);