ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
39,812 rows where state = "Virginia" sorted by date descending
This data as json, yaml, copyable, CSV (advanced)
Suggested facets: date (date)
fips
- 51059 322
- 51810 320
- 51107 319
- 51013 318
- 51085 317
- 51095 317
- 51147 317
- 51153 317
- 51510 317
- 51660 316
- 51041 315
- 51177 315
- 51179 313
- 51199 313
- 51075 312
- 51087 312
- 51540 312
- 51830 312
- 51036 311
- 51760 311
- 51001 309
- 51073 309
- 51700 309
- 51710 309
- 51740 309
- 51003 308
- 51023 308
- 51067 308
- 51093 308
- 51117 308
- ...
county
- Fairfax 322
- Virginia Beach city 320
- Loudoun 319
- Arlington 318
- Alexandria city 317
- Hanover 317
- James City 317
- Prince Edward 317
- Prince William 317
- Harrisonburg city 316
- Chesterfield 315
- Spotsylvania 315
- Stafford 313
- York 313
- Charlottesville city 312
- Goochland 312
- Henrico 312
- Williamsburg city 312
- Charles City 311
- Richmond city 311
- Accomack 309
- Gloucester 309
- Newport News city 309
- Norfolk city 309
- Portsmouth city 309
- Albemarle 308
- Botetourt 308
- Franklin 308
- Isle of Wight 308
- Mecklenburg 308
- ...
state
- Virginia · 39,812 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955895 | 955895 | 2021-01-22 | Accomack | Virginia | 51001 | 2206 | 31 |
955896 | 955896 | 2021-01-22 | Albemarle | Virginia | 51003 | 3666 | 35 |
955897 | 955897 | 2021-01-22 | Alexandria city | Virginia | 51510 | 8975 | 99 |
955898 | 955898 | 2021-01-22 | Alleghany | Virginia | 51005 | 1047 | 29 |
955899 | 955899 | 2021-01-22 | Amelia | Virginia | 51007 | 575 | 8 |
955900 | 955900 | 2021-01-22 | Amherst | Virginia | 51009 | 2156 | 10 |
955901 | 955901 | 2021-01-22 | Appomattox | Virginia | 51011 | 1129 | 8 |
955902 | 955902 | 2021-01-22 | Arlington | Virginia | 51013 | 11006 | 196 |
955903 | 955903 | 2021-01-22 | Augusta | Virginia | 51015 | 4527 | 43 |
955904 | 955904 | 2021-01-22 | Bath | Virginia | 51017 | 236 | 0 |
955905 | 955905 | 2021-01-22 | Bedford | Virginia | 51019 | 4679 | 36 |
955906 | 955906 | 2021-01-22 | Bland | Virginia | 51021 | 589 | 7 |
955907 | 955907 | 2021-01-22 | Botetourt | Virginia | 51023 | 1734 | 20 |
955908 | 955908 | 2021-01-22 | Bristol city | Virginia | 51520 | 1142 | 22 |
955909 | 955909 | 2021-01-22 | Brunswick | Virginia | 51025 | 1042 | 8 |
955910 | 955910 | 2021-01-22 | Buchanan | Virginia | 51027 | 1012 | 26 |
955911 | 955911 | 2021-01-22 | Buckingham | Virginia | 51029 | 1717 | 15 |
955912 | 955912 | 2021-01-22 | Buena Vista city | Virginia | 51530 | 672 | 9 |
955913 | 955913 | 2021-01-22 | Campbell | Virginia | 51031 | 3258 | 29 |
955914 | 955914 | 2021-01-22 | Caroline | Virginia | 51033 | 1415 | 12 |
955915 | 955915 | 2021-01-22 | Carroll | Virginia | 51035 | 1894 | 55 |
955916 | 955916 | 2021-01-22 | Charles City | Virginia | 51036 | 316 | 9 |
955917 | 955917 | 2021-01-22 | Charlotte | Virginia | 51037 | 555 | 10 |
955918 | 955918 | 2021-01-22 | Charlottesville city | Virginia | 51540 | 2628 | 37 |
955919 | 955919 | 2021-01-22 | Chesapeake city | Virginia | 51550 | 14015 | 120 |
955920 | 955920 | 2021-01-22 | Chesterfield | Virginia | 51041 | 17408 | 195 |
955921 | 955921 | 2021-01-22 | Clarke | Virginia | 51043 | 569 | 8 |
955922 | 955922 | 2021-01-22 | Colonial Heights city | Virginia | 51570 | 924 | 30 |
955923 | 955923 | 2021-01-22 | Covington city | Virginia | 51580 | 540 | 4 |
955924 | 955924 | 2021-01-22 | Craig | Virginia | 51045 | 199 | 3 |
955925 | 955925 | 2021-01-22 | Culpeper | Virginia | 51047 | 3558 | 32 |
955926 | 955926 | 2021-01-22 | Cumberland | Virginia | 51049 | 293 | 4 |
955927 | 955927 | 2021-01-22 | Danville city | Virginia | 51590 | 3224 | 64 |
955928 | 955928 | 2021-01-22 | Dickenson | Virginia | 51051 | 797 | 13 |
955929 | 955929 | 2021-01-22 | Dinwiddie | Virginia | 51053 | 1312 | 18 |
955930 | 955930 | 2021-01-22 | Emporia city | Virginia | 51595 | 534 | 31 |
955931 | 955931 | 2021-01-22 | Essex | Virginia | 51057 | 496 | 3 |
955932 | 955932 | 2021-01-22 | Fairfax | Virginia | 51059 | 55846 | 749 |
955933 | 955933 | 2021-01-22 | Fairfax city | Virginia | 51600 | 382 | 10 |
955934 | 955934 | 2021-01-22 | Falls Church city | Virginia | 51610 | 256 | 6 |
955935 | 955935 | 2021-01-22 | Fauquier | Virginia | 51061 | 3208 | 31 |
955936 | 955936 | 2021-01-22 | Floyd | Virginia | 51063 | 651 | 18 |
955937 | 955937 | 2021-01-22 | Fluvanna | Virginia | 51065 | 1040 | 11 |
955938 | 955938 | 2021-01-22 | Franklin | Virginia | 51067 | 3102 | 31 |
955939 | 955939 | 2021-01-22 | Franklin city | Virginia | 51620 | 795 | 20 |
955940 | 955940 | 2021-01-22 | Frederick | Virginia | 51069 | 5195 | 40 |
955941 | 955941 | 2021-01-22 | Fredericksburg city | Virginia | 51630 | 1364 | 14 |
955942 | 955942 | 2021-01-22 | Galax city | Virginia | 51640 | 943 | 38 |
955943 | 955943 | 2021-01-22 | Giles | Virginia | 51071 | 877 | 6 |
955944 | 955944 | 2021-01-22 | Gloucester | Virginia | 51073 | 1318 | 19 |
955945 | 955945 | 2021-01-22 | Goochland | Virginia | 51075 | 930 | 7 |
955946 | 955946 | 2021-01-22 | Grayson | Virginia | 51077 | 998 | 26 |
955947 | 955947 | 2021-01-22 | Greene | Virginia | 51079 | 758 | 4 |
955948 | 955948 | 2021-01-22 | Greensville | Virginia | 51081 | 1164 | 17 |
955949 | 955949 | 2021-01-22 | Halifax | Virginia | 51083 | 1817 | 48 |
955950 | 955950 | 2021-01-22 | Hampton city | Virginia | 51650 | 6420 | 59 |
955951 | 955951 | 2021-01-22 | Hanover | Virginia | 51085 | 5332 | 93 |
955952 | 955952 | 2021-01-22 | Harrisonburg city | Virginia | 51660 | 5112 | 57 |
955953 | 955953 | 2021-01-22 | Henrico | Virginia | 51087 | 16846 | 329 |
955954 | 955954 | 2021-01-22 | Henry | Virginia | 51089 | 3484 | 65 |
955955 | 955955 | 2021-01-22 | Highland | Virginia | 51091 | 72 | 0 |
955956 | 955956 | 2021-01-22 | Hopewell city | Virginia | 51670 | 1436 | 12 |
955957 | 955957 | 2021-01-22 | Isle of Wight | Virginia | 51093 | 1973 | 35 |
955958 | 955958 | 2021-01-22 | James City | Virginia | 51095 | 3012 | 37 |
955959 | 955959 | 2021-01-22 | King George | Virginia | 51099 | 1052 | 11 |
955960 | 955960 | 2021-01-22 | King William | Virginia | 51101 | 645 | 5 |
955961 | 955961 | 2021-01-22 | King and Queen | Virginia | 51097 | 234 | 3 |
955962 | 955962 | 2021-01-22 | Lancaster | Virginia | 51103 | 496 | 3 |
955963 | 955963 | 2021-01-22 | Lee | Virginia | 51105 | 2023 | 33 |
955964 | 955964 | 2021-01-22 | Lexington city | Virginia | 51678 | 766 | 15 |
955965 | 955965 | 2021-01-22 | Loudoun | Virginia | 51107 | 17809 | 171 |
955966 | 955966 | 2021-01-22 | Louisa | Virginia | 51109 | 1341 | 11 |
955967 | 955967 | 2021-01-22 | Lunenburg | Virginia | 51111 | 529 | 3 |
955968 | 955968 | 2021-01-22 | Lynchburg city | Virginia | 51680 | 5669 | 66 |
955969 | 955969 | 2021-01-22 | Madison | Virginia | 51113 | 416 | 5 |
955970 | 955970 | 2021-01-22 | Manassas Park city | Virginia | 51685 | 1050 | 8 |
955971 | 955971 | 2021-01-22 | Manassas city | Virginia | 51683 | 3500 | 32 |
955972 | 955972 | 2021-01-22 | Martinsville city | Virginia | 51690 | 1277 | 30 |
955973 | 955973 | 2021-01-22 | Mathews | Virginia | 51115 | 400 | 6 |
955974 | 955974 | 2021-01-22 | Mecklenburg | Virginia | 51117 | 1632 | 43 |
955975 | 955975 | 2021-01-22 | Middlesex | Virginia | 51119 | 370 | 15 |
955976 | 955976 | 2021-01-22 | Montgomery | Virginia | 51121 | 5988 | 56 |
955977 | 955977 | 2021-01-22 | Nelson | Virginia | 51125 | 560 | 5 |
955978 | 955978 | 2021-01-22 | New Kent | Virginia | 51127 | 953 | 7 |
955979 | 955979 | 2021-01-22 | Newport News city | Virginia | 51700 | 8517 | 79 |
955980 | 955980 | 2021-01-22 | Norfolk city | Virginia | 51710 | 11715 | 132 |
955981 | 955981 | 2021-01-22 | Northampton | Virginia | 51131 | 582 | 32 |
955982 | 955982 | 2021-01-22 | Northumberland | Virginia | 51133 | 536 | 12 |
955983 | 955983 | 2021-01-22 | Norton city | Virginia | 51720 | 223 | 2 |
955984 | 955984 | 2021-01-22 | Nottoway | Virginia | 51135 | 1570 | 25 |
955985 | 955985 | 2021-01-22 | Orange | Virginia | 51137 | 1390 | 16 |
955986 | 955986 | 2021-01-22 | Page | Virginia | 51139 | 1445 | 38 |
955987 | 955987 | 2021-01-22 | Patrick | Virginia | 51141 | 976 | 28 |
955988 | 955988 | 2021-01-22 | Petersburg city | Virginia | 51730 | 2253 | 36 |
955989 | 955989 | 2021-01-22 | Pittsylvania | Virginia | 51143 | 3754 | 43 |
955990 | 955990 | 2021-01-22 | Poquoson city | Virginia | 51735 | 513 | 7 |
955991 | 955991 | 2021-01-22 | Portsmouth city | Virginia | 51740 | 6028 | 96 |
955992 | 955992 | 2021-01-22 | Powhatan | Virginia | 51145 | 1184 | 7 |
955993 | 955993 | 2021-01-22 | Prince Edward | Virginia | 51147 | 1505 | 19 |
955994 | 955994 | 2021-01-22 | Prince George | Virginia | 51149 | 2291 | 10 |
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]);