ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
133 rows where date = "2022-02-01" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Accomack 1
- Albemarle 1
- Alexandria city 1
- Alleghany 1
- Amelia 1
- Amherst 1
- Appomattox 1
- Arlington 1
- Augusta 1
- Bath 1
- Bedford 1
- Bland 1
- Botetourt 1
- Bristol city 1
- Brunswick 1
- Buchanan 1
- Buckingham 1
- Buena Vista city 1
- Campbell 1
- Caroline 1
- Carroll 1
- Charles City 1
- Charlotte 1
- Charlottesville city 1
- Chesapeake city 1
- Chesterfield 1
- Clarke 1
- Colonial Heights city 1
- Covington city 1
- Craig 1
- …
state 1
- Virginia · 133 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2173872 | 2173872 | 2022-02-01 | Accomack | Virginia | 51001 | 6766 | 90 |
2173873 | 2173873 | 2022-02-01 | Albemarle | Virginia | 51003 | 13787 | 124 |
2173874 | 2173874 | 2022-02-01 | Alexandria city | Virginia | 51510 | 28416 | 166 |
2173875 | 2173875 | 2022-02-01 | Alleghany | Virginia | 51005 | 3310 | 90 |
2173876 | 2173876 | 2022-02-01 | Amelia | Virginia | 51007 | 2423 | 47 |
2173877 | 2173877 | 2022-02-01 | Amherst | Virginia | 51009 | 6258 | 69 |
2173878 | 2173878 | 2022-02-01 | Appomattox | Virginia | 51011 | 3350 | 43 |
2173879 | 2173879 | 2022-02-01 | Arlington | Virginia | 51013 | 38187 | 292 |
2173880 | 2173880 | 2022-02-01 | Augusta | Virginia | 51015 | 17298 | 158 |
2173881 | 2173881 | 2022-02-01 | Bath | Virginia | 51017 | 792 | 15 |
2173882 | 2173882 | 2022-02-01 | Bedford | Virginia | 51019 | 14737 | 184 |
2173883 | 2173883 | 2022-02-01 | Bland | Virginia | 51021 | 1579 | 19 |
2173884 | 2173884 | 2022-02-01 | Botetourt | Virginia | 51023 | 6457 | 74 |
2173885 | 2173885 | 2022-02-01 | Bristol city | Virginia | 51520 | 3884 | 63 |
2173886 | 2173886 | 2022-02-01 | Brunswick | Virginia | 51025 | 2741 | 37 |
2173887 | 2173887 | 2022-02-01 | Buchanan | Virginia | 51027 | 4113 | 91 |
2173888 | 2173888 | 2022-02-01 | Buckingham | Virginia | 51029 | 3530 | 42 |
2173889 | 2173889 | 2022-02-01 | Buena Vista city | Virginia | 51530 | 1835 | 36 |
2173890 | 2173890 | 2022-02-01 | Campbell | Virginia | 51031 | 10231 | 169 |
2173891 | 2173891 | 2022-02-01 | Caroline | Virginia | 51033 | 6413 | 63 |
2173892 | 2173892 | 2022-02-01 | Carroll | Virginia | 51035 | 5993 | 119 |
2173893 | 2173893 | 2022-02-01 | Charles City | Virginia | 51036 | 1108 | 23 |
2173894 | 2173894 | 2022-02-01 | Charlotte | Virginia | 51037 | 2173 | 32 |
2173895 | 2173895 | 2022-02-01 | Charlottesville city | Virginia | 51540 | 9090 | 63 |
2173896 | 2173896 | 2022-02-01 | Chesapeake city | Virginia | 51550 | 47540 | 391 |
2173897 | 2173897 | 2022-02-01 | Chesterfield | Virginia | 51041 | 67260 | 625 |
2173898 | 2173898 | 2022-02-01 | Clarke | Virginia | 51043 | 2452 | 37 |
2173899 | 2173899 | 2022-02-01 | Colonial Heights city | Virginia | 51570 | 4484 | 74 |
2173900 | 2173900 | 2022-02-01 | Covington city | Virginia | 51580 | 920 | 21 |
2173901 | 2173901 | 2022-02-01 | Craig | Virginia | 51045 | 990 | 12 |
2173902 | 2173902 | 2022-02-01 | Culpeper | Virginia | 51047 | 10832 | 104 |
2173903 | 2173903 | 2022-02-01 | Cumberland | Virginia | 51049 | 1140 | 19 |
2173904 | 2173904 | 2022-02-01 | Danville city | Virginia | 51590 | 10014 | 219 |
2173905 | 2173905 | 2022-02-01 | Dickenson | Virginia | 51051 | 2901 | 40 |
2173906 | 2173906 | 2022-02-01 | Dinwiddie | Virginia | 51053 | 4920 | 64 |
2173907 | 2173907 | 2022-02-01 | Emporia city | Virginia | 51595 | 1041 | 46 |
2173908 | 2173908 | 2022-02-01 | Essex | Virginia | 51057 | 2122 | 23 |
2173909 | 2173909 | 2022-02-01 | Fairfax | Virginia | 51059 | 166375 | 1234 |
2173910 | 2173910 | 2022-02-01 | Fairfax city | Virginia | 51600 | 1915 | 36 |
2173911 | 2173911 | 2022-02-01 | Falls Church city | Virginia | 51610 | 1783 | 14 |
2173912 | 2173912 | 2022-02-01 | Fauquier | Virginia | 51061 | 12157 | 111 |
2173913 | 2173913 | 2022-02-01 | Floyd | Virginia | 51063 | 2280 | 33 |
2173914 | 2173914 | 2022-02-01 | Fluvanna | Virginia | 51065 | 4361 | 33 |
2173915 | 2173915 | 2022-02-01 | Franklin | Virginia | 51067 | 9842 | 140 |
2173916 | 2173916 | 2022-02-01 | Franklin city | Virginia | 51620 | 2391 | 43 |
2173917 | 2173917 | 2022-02-01 | Frederick | Virginia | 51069 | 19293 | 194 |
2173918 | 2173918 | 2022-02-01 | Fredericksburg city | Virginia | 51630 | 5065 | 29 |
2173919 | 2173919 | 2022-02-01 | Galax city | Virginia | 51640 | 2300 | 71 |
2173920 | 2173920 | 2022-02-01 | Giles | Virginia | 51071 | 3515 | 40 |
2173921 | 2173921 | 2022-02-01 | Gloucester | Virginia | 51073 | 6869 | 86 |
2173922 | 2173922 | 2022-02-01 | Goochland | Virginia | 51075 | 3587 | 37 |
2173923 | 2173923 | 2022-02-01 | Grayson | Virginia | 51077 | 3315 | 67 |
2173924 | 2173924 | 2022-02-01 | Greene | Virginia | 51079 | 3622 | 49 |
2173925 | 2173925 | 2022-02-01 | Greensville | Virginia | 51081 | 3189 | 30 |
2173926 | 2173926 | 2022-02-01 | Halifax | Virginia | 51083 | 6377 | 129 |
2173927 | 2173927 | 2022-02-01 | Hampton city | Virginia | 51650 | 26165 | 263 |
2173928 | 2173928 | 2022-02-01 | Hanover | Virginia | 51085 | 20051 | 215 |
2173929 | 2173929 | 2022-02-01 | Harrisonburg city | Virginia | 51660 | 12347 | 122 |
2173930 | 2173930 | 2022-02-01 | Henrico | Virginia | 51087 | 60073 | 766 |
2173931 | 2173931 | 2022-02-01 | Henry | Virginia | 51089 | 10299 | 217 |
2173932 | 2173932 | 2022-02-01 | Highland | Virginia | 51091 | 330 | 5 |
2173933 | 2173933 | 2022-02-01 | Hopewell city | Virginia | 51670 | 5874 | 101 |
2173934 | 2173934 | 2022-02-01 | Isle of Wight | Virginia | 51093 | 6966 | 93 |
2173935 | 2173935 | 2022-02-01 | James City | Virginia | 51095 | 13771 | 100 |
2173936 | 2173936 | 2022-02-01 | King George | Virginia | 51099 | 4676 | 27 |
2173937 | 2173937 | 2022-02-01 | King William | Virginia | 51101 | 3466 | 27 |
2173938 | 2173938 | 2022-02-01 | King and Queen | Virginia | 51097 | 1072 | 10 |
2173939 | 2173939 | 2022-02-01 | Lancaster | Virginia | 51103 | 1677 | 24 |
2173940 | 2173940 | 2022-02-01 | Lee | Virginia | 51105 | 5345 | 74 |
2173941 | 2173941 | 2022-02-01 | Lexington city | Virginia | 51678 | 2581 | 38 |
2173942 | 2173942 | 2022-02-01 | Loudoun | Virginia | 51107 | 62390 | 318 |
2173943 | 2173943 | 2022-02-01 | Louisa | Virginia | 51109 | 5933 | 55 |
2173944 | 2173944 | 2022-02-01 | Lunenburg | Virginia | 51111 | 2051 | 24 |
2173945 | 2173945 | 2022-02-01 | Lynchburg city | Virginia | 51680 | 17912 | 230 |
2173946 | 2173946 | 2022-02-01 | Madison | Virginia | 51113 | 1904 | 28 |
2173947 | 2173947 | 2022-02-01 | Manassas Park city | Virginia | 51685 | 2542 | 16 |
2173948 | 2173948 | 2022-02-01 | Manassas city | Virginia | 51683 | 8492 | 58 |
2173949 | 2173949 | 2022-02-01 | Martinsville city | Virginia | 51690 | 2933 | 101 |
2173950 | 2173950 | 2022-02-01 | Mathews | Virginia | 51115 | 1342 | 24 |
2173951 | 2173951 | 2022-02-01 | Mecklenburg | Virginia | 51117 | 5354 | 102 |
2173952 | 2173952 | 2022-02-01 | Middlesex | Virginia | 51119 | 1694 | 36 |
2173953 | 2173953 | 2022-02-01 | Montgomery | Virginia | 51121 | 16763 | 124 |
2173954 | 2173954 | 2022-02-01 | Nelson | Virginia | 51125 | 2468 | 25 |
2173955 | 2173955 | 2022-02-01 | New Kent | Virginia | 51127 | 4331 | 28 |
2173956 | 2173956 | 2022-02-01 | Newport News city | Virginia | 51700 | 34599 | 326 |
2173957 | 2173957 | 2022-02-01 | Norfolk city | Virginia | 51710 | 39940 | 386 |
2173958 | 2173958 | 2022-02-01 | Northampton | Virginia | 51131 | 2037 | 52 |
2173959 | 2173959 | 2022-02-01 | Northumberland | Virginia | 51133 | 2020 | 39 |
2173960 | 2173960 | 2022-02-01 | Norton city | Virginia | 51720 | 1082 | 20 |
2173961 | 2173961 | 2022-02-01 | Nottoway | Virginia | 51135 | 3677 | 74 |
2173962 | 2173962 | 2022-02-01 | Orange | Virginia | 51137 | 6480 | 72 |
2173963 | 2173963 | 2022-02-01 | Page | Virginia | 51139 | 5269 | 97 |
2173964 | 2173964 | 2022-02-01 | Patrick | Virginia | 51141 | 3200 | 75 |
2173965 | 2173965 | 2022-02-01 | Petersburg city | Virginia | 51730 | 7994 | 115 |
2173966 | 2173966 | 2022-02-01 | Pittsylvania | Virginia | 51143 | 11936 | 157 |
2173967 | 2173967 | 2022-02-01 | Poquoson city | Virginia | 51735 | 2214 | 24 |
2173968 | 2173968 | 2022-02-01 | Portsmouth city | Virginia | 51740 | 19910 | 262 |
2173969 | 2173969 | 2022-02-01 | Powhatan | Virginia | 51145 | 4559 | 36 |
2173970 | 2173970 | 2022-02-01 | Prince Edward | Virginia | 51147 | 4238 | 54 |
2173971 | 2173971 | 2022-02-01 | Prince George | Virginia | 51149 | 7498 | 54 |
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);