ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
133 rows where date = "2021-01-06" 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 |
---|---|---|---|---|---|---|---|
903890 | 903890 | 2021-01-06 | Accomack | Virginia | 51001 | 1824 | 29 |
903891 | 903891 | 2021-01-06 | Albemarle | Virginia | 51003 | 3009 | 33 |
903892 | 903892 | 2021-01-06 | Alexandria city | Virginia | 51510 | 7676 | 89 |
903893 | 903893 | 2021-01-06 | Alleghany | Virginia | 51005 | 848 | 23 |
903894 | 903894 | 2021-01-06 | Amelia | Virginia | 51007 | 403 | 7 |
903895 | 903895 | 2021-01-06 | Amherst | Virginia | 51009 | 1566 | 10 |
903896 | 903896 | 2021-01-06 | Appomattox | Virginia | 51011 | 809 | 7 |
903897 | 903897 | 2021-01-06 | Arlington | Virginia | 51013 | 9420 | 184 |
903898 | 903898 | 2021-01-06 | Augusta | Virginia | 51015 | 3759 | 29 |
903899 | 903899 | 2021-01-06 | Bath | Virginia | 51017 | 199 | 0 |
903900 | 903900 | 2021-01-06 | Bedford | Virginia | 51019 | 3382 | 32 |
903901 | 903901 | 2021-01-06 | Bland | Virginia | 51021 | 509 | 6 |
903902 | 903902 | 2021-01-06 | Botetourt | Virginia | 51023 | 1397 | 18 |
903903 | 903903 | 2021-01-06 | Bristol city | Virginia | 51520 | 997 | 8 |
903904 | 903904 | 2021-01-06 | Brunswick | Virginia | 51025 | 690 | 7 |
903905 | 903905 | 2021-01-06 | Buchanan | Virginia | 51027 | 928 | 23 |
903906 | 903906 | 2021-01-06 | Buckingham | Virginia | 51029 | 1459 | 12 |
903907 | 903907 | 2021-01-06 | Buena Vista city | Virginia | 51530 | 558 | 4 |
903908 | 903908 | 2021-01-06 | Campbell | Virginia | 51031 | 2275 | 21 |
903909 | 903909 | 2021-01-06 | Caroline | Virginia | 51033 | 1126 | 10 |
903910 | 903910 | 2021-01-06 | Carroll | Virginia | 51035 | 1633 | 37 |
903911 | 903911 | 2021-01-06 | Charles City | Virginia | 51036 | 220 | 8 |
903912 | 903912 | 2021-01-06 | Charlotte | Virginia | 51037 | 412 | 7 |
903913 | 903913 | 2021-01-06 | Charlottesville city | Virginia | 51540 | 2303 | 34 |
903914 | 903914 | 2021-01-06 | Chesapeake city | Virginia | 51550 | 9933 | 104 |
903915 | 903915 | 2021-01-06 | Chesterfield | Virginia | 51041 | 13953 | 175 |
903916 | 903916 | 2021-01-06 | Clarke | Virginia | 51043 | 423 | 5 |
903917 | 903917 | 2021-01-06 | Colonial Heights city | Virginia | 51570 | 666 | 28 |
903918 | 903918 | 2021-01-06 | Covington city | Virginia | 51580 | 424 | 4 |
903919 | 903919 | 2021-01-06 | Craig | Virginia | 51045 | 152 | 1 |
903920 | 903920 | 2021-01-06 | Culpeper | Virginia | 51047 | 3160 | 23 |
903921 | 903921 | 2021-01-06 | Cumberland | Virginia | 51049 | 215 | 4 |
903922 | 903922 | 2021-01-06 | Danville city | Virginia | 51590 | 2609 | 63 |
903923 | 903923 | 2021-01-06 | Dickenson | Virginia | 51051 | 702 | 6 |
903924 | 903924 | 2021-01-06 | Dinwiddie | Virginia | 51053 | 990 | 16 |
903925 | 903925 | 2021-01-06 | Emporia city | Virginia | 51595 | 439 | 30 |
903926 | 903926 | 2021-01-06 | Essex | Virginia | 51057 | 385 | 2 |
903927 | 903927 | 2021-01-06 | Fairfax | Virginia | 51059 | 46776 | 691 |
903928 | 903928 | 2021-01-06 | Fairfax city | Virginia | 51600 | 311 | 10 |
903929 | 903929 | 2021-01-06 | Falls Church city | Virginia | 51610 | 194 | 6 |
903930 | 903930 | 2021-01-06 | Fauquier | Virginia | 51061 | 2649 | 29 |
903931 | 903931 | 2021-01-06 | Floyd | Virginia | 51063 | 546 | 17 |
903932 | 903932 | 2021-01-06 | Fluvanna | Virginia | 51065 | 842 | 11 |
903933 | 903933 | 2021-01-06 | Franklin | Virginia | 51067 | 2494 | 24 |
903934 | 903934 | 2021-01-06 | Franklin city | Virginia | 51620 | 688 | 18 |
903935 | 903935 | 2021-01-06 | Frederick | Virginia | 51069 | 4103 | 33 |
903936 | 903936 | 2021-01-06 | Fredericksburg city | Virginia | 51630 | 1106 | 11 |
903937 | 903937 | 2021-01-06 | Galax city | Virginia | 51640 | 853 | 36 |
903938 | 903938 | 2021-01-06 | Giles | Virginia | 51071 | 691 | 2 |
903939 | 903939 | 2021-01-06 | Gloucester | Virginia | 51073 | 953 | 7 |
903940 | 903940 | 2021-01-06 | Goochland | Virginia | 51075 | 671 | 7 |
903941 | 903941 | 2021-01-06 | Grayson | Virginia | 51077 | 838 | 25 |
903942 | 903942 | 2021-01-06 | Greene | Virginia | 51079 | 606 | 4 |
903943 | 903943 | 2021-01-06 | Greensville | Virginia | 51081 | 1029 | 17 |
903944 | 903944 | 2021-01-06 | Halifax | Virginia | 51083 | 1284 | 40 |
903945 | 903945 | 2021-01-06 | Hampton city | Virginia | 51650 | 4865 | 50 |
903946 | 903946 | 2021-01-06 | Hanover | Virginia | 51085 | 4321 | 78 |
903947 | 903947 | 2021-01-06 | Harrisonburg city | Virginia | 51660 | 4593 | 46 |
903948 | 903948 | 2021-01-06 | Henrico | Virginia | 51087 | 13561 | 299 |
903949 | 903949 | 2021-01-06 | Henry | Virginia | 51089 | 2883 | 57 |
903950 | 903950 | 2021-01-06 | Highland | Virginia | 51091 | 57 | 0 |
903951 | 903951 | 2021-01-06 | Hopewell city | Virginia | 51670 | 984 | 11 |
903952 | 903952 | 2021-01-06 | Isle of Wight | Virginia | 51093 | 1625 | 29 |
903953 | 903953 | 2021-01-06 | James City | Virginia | 51095 | 2143 | 31 |
903954 | 903954 | 2021-01-06 | King George | Virginia | 51099 | 795 | 10 |
903955 | 903955 | 2021-01-06 | King William | Virginia | 51101 | 492 | 4 |
903956 | 903956 | 2021-01-06 | King and Queen | Virginia | 51097 | 183 | 2 |
903957 | 903957 | 2021-01-06 | Lancaster | Virginia | 51103 | 389 | 3 |
903958 | 903958 | 2021-01-06 | Lee | Virginia | 51105 | 1613 | 31 |
903959 | 903959 | 2021-01-06 | Lexington city | Virginia | 51678 | 660 | 5 |
903960 | 903960 | 2021-01-06 | Loudoun | Virginia | 51107 | 14973 | 161 |
903961 | 903961 | 2021-01-06 | Louisa | Virginia | 51109 | 1018 | 11 |
903962 | 903962 | 2021-01-06 | Lunenburg | Virginia | 51111 | 368 | 3 |
903963 | 903963 | 2021-01-06 | Lynchburg city | Virginia | 51680 | 4543 | 55 |
903964 | 903964 | 2021-01-06 | Madison | Virginia | 51113 | 328 | 4 |
903965 | 903965 | 2021-01-06 | Manassas Park city | Virginia | 51685 | 972 | 8 |
903966 | 903966 | 2021-01-06 | Manassas city | Virginia | 51683 | 3025 | 29 |
903967 | 903967 | 2021-01-06 | Martinsville city | Virginia | 51690 | 1062 | 27 |
903968 | 903968 | 2021-01-06 | Mathews | Virginia | 51115 | 338 | 4 |
903969 | 903969 | 2021-01-06 | Mecklenburg | Virginia | 51117 | 1395 | 39 |
903970 | 903970 | 2021-01-06 | Middlesex | Virginia | 51119 | 293 | 12 |
903971 | 903971 | 2021-01-06 | Montgomery | Virginia | 51121 | 5398 | 43 |
903972 | 903972 | 2021-01-06 | Nelson | Virginia | 51125 | 382 | 4 |
903973 | 903973 | 2021-01-06 | New Kent | Virginia | 51127 | 738 | 5 |
903974 | 903974 | 2021-01-06 | Newport News city | Virginia | 51700 | 6541 | 72 |
903975 | 903975 | 2021-01-06 | Norfolk city | Virginia | 51710 | 9551 | 112 |
903976 | 903976 | 2021-01-06 | Northampton | Virginia | 51131 | 466 | 31 |
903977 | 903977 | 2021-01-06 | Northumberland | Virginia | 51133 | 462 | 10 |
903978 | 903978 | 2021-01-06 | Norton city | Virginia | 51720 | 181 | 1 |
903979 | 903979 | 2021-01-06 | Nottoway | Virginia | 51135 | 1234 | 24 |
903980 | 903980 | 2021-01-06 | Orange | Virginia | 51137 | 1083 | 13 |
903981 | 903981 | 2021-01-06 | Page | Virginia | 51139 | 1154 | 34 |
903982 | 903982 | 2021-01-06 | Patrick | Virginia | 51141 | 833 | 28 |
903983 | 903983 | 2021-01-06 | Petersburg city | Virginia | 51730 | 1583 | 33 |
903984 | 903984 | 2021-01-06 | Pittsylvania | Virginia | 51143 | 2897 | 41 |
903985 | 903985 | 2021-01-06 | Poquoson city | Virginia | 51735 | 373 | 6 |
903986 | 903986 | 2021-01-06 | Portsmouth city | Virginia | 51740 | 4895 | 86 |
903987 | 903987 | 2021-01-06 | Powhatan | Virginia | 51145 | 910 | 6 |
903988 | 903988 | 2021-01-06 | Prince Edward | Virginia | 51147 | 1191 | 17 |
903989 | 903989 | 2021-01-06 | Prince George | Virginia | 51149 | 1898 | 9 |
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);