ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
133 rows where date = "2021-01-22" 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 |
---|---|---|---|---|---|---|---|
955815 | 955815 | 2021-01-22 | Accomack | Virginia | 51001 | 2206 | 31 |
955816 | 955816 | 2021-01-22 | Albemarle | Virginia | 51003 | 3666 | 35 |
955817 | 955817 | 2021-01-22 | Alexandria city | Virginia | 51510 | 8975 | 99 |
955818 | 955818 | 2021-01-22 | Alleghany | Virginia | 51005 | 1047 | 29 |
955819 | 955819 | 2021-01-22 | Amelia | Virginia | 51007 | 575 | 8 |
955820 | 955820 | 2021-01-22 | Amherst | Virginia | 51009 | 2156 | 10 |
955821 | 955821 | 2021-01-22 | Appomattox | Virginia | 51011 | 1129 | 8 |
955822 | 955822 | 2021-01-22 | Arlington | Virginia | 51013 | 11006 | 196 |
955823 | 955823 | 2021-01-22 | Augusta | Virginia | 51015 | 4527 | 43 |
955824 | 955824 | 2021-01-22 | Bath | Virginia | 51017 | 236 | 0 |
955825 | 955825 | 2021-01-22 | Bedford | Virginia | 51019 | 4679 | 36 |
955826 | 955826 | 2021-01-22 | Bland | Virginia | 51021 | 589 | 7 |
955827 | 955827 | 2021-01-22 | Botetourt | Virginia | 51023 | 1734 | 20 |
955828 | 955828 | 2021-01-22 | Bristol city | Virginia | 51520 | 1142 | 22 |
955829 | 955829 | 2021-01-22 | Brunswick | Virginia | 51025 | 1042 | 8 |
955830 | 955830 | 2021-01-22 | Buchanan | Virginia | 51027 | 1012 | 26 |
955831 | 955831 | 2021-01-22 | Buckingham | Virginia | 51029 | 1717 | 15 |
955832 | 955832 | 2021-01-22 | Buena Vista city | Virginia | 51530 | 672 | 9 |
955833 | 955833 | 2021-01-22 | Campbell | Virginia | 51031 | 3258 | 29 |
955834 | 955834 | 2021-01-22 | Caroline | Virginia | 51033 | 1415 | 12 |
955835 | 955835 | 2021-01-22 | Carroll | Virginia | 51035 | 1894 | 55 |
955836 | 955836 | 2021-01-22 | Charles City | Virginia | 51036 | 316 | 9 |
955837 | 955837 | 2021-01-22 | Charlotte | Virginia | 51037 | 555 | 10 |
955838 | 955838 | 2021-01-22 | Charlottesville city | Virginia | 51540 | 2628 | 37 |
955839 | 955839 | 2021-01-22 | Chesapeake city | Virginia | 51550 | 14015 | 120 |
955840 | 955840 | 2021-01-22 | Chesterfield | Virginia | 51041 | 17408 | 195 |
955841 | 955841 | 2021-01-22 | Clarke | Virginia | 51043 | 569 | 8 |
955842 | 955842 | 2021-01-22 | Colonial Heights city | Virginia | 51570 | 924 | 30 |
955843 | 955843 | 2021-01-22 | Covington city | Virginia | 51580 | 540 | 4 |
955844 | 955844 | 2021-01-22 | Craig | Virginia | 51045 | 199 | 3 |
955845 | 955845 | 2021-01-22 | Culpeper | Virginia | 51047 | 3558 | 32 |
955846 | 955846 | 2021-01-22 | Cumberland | Virginia | 51049 | 293 | 4 |
955847 | 955847 | 2021-01-22 | Danville city | Virginia | 51590 | 3224 | 64 |
955848 | 955848 | 2021-01-22 | Dickenson | Virginia | 51051 | 797 | 13 |
955849 | 955849 | 2021-01-22 | Dinwiddie | Virginia | 51053 | 1312 | 18 |
955850 | 955850 | 2021-01-22 | Emporia city | Virginia | 51595 | 534 | 31 |
955851 | 955851 | 2021-01-22 | Essex | Virginia | 51057 | 496 | 3 |
955852 | 955852 | 2021-01-22 | Fairfax | Virginia | 51059 | 55846 | 749 |
955853 | 955853 | 2021-01-22 | Fairfax city | Virginia | 51600 | 382 | 10 |
955854 | 955854 | 2021-01-22 | Falls Church city | Virginia | 51610 | 256 | 6 |
955855 | 955855 | 2021-01-22 | Fauquier | Virginia | 51061 | 3208 | 31 |
955856 | 955856 | 2021-01-22 | Floyd | Virginia | 51063 | 651 | 18 |
955857 | 955857 | 2021-01-22 | Fluvanna | Virginia | 51065 | 1040 | 11 |
955858 | 955858 | 2021-01-22 | Franklin | Virginia | 51067 | 3102 | 31 |
955859 | 955859 | 2021-01-22 | Franklin city | Virginia | 51620 | 795 | 20 |
955860 | 955860 | 2021-01-22 | Frederick | Virginia | 51069 | 5195 | 40 |
955861 | 955861 | 2021-01-22 | Fredericksburg city | Virginia | 51630 | 1364 | 14 |
955862 | 955862 | 2021-01-22 | Galax city | Virginia | 51640 | 943 | 38 |
955863 | 955863 | 2021-01-22 | Giles | Virginia | 51071 | 877 | 6 |
955864 | 955864 | 2021-01-22 | Gloucester | Virginia | 51073 | 1318 | 19 |
955865 | 955865 | 2021-01-22 | Goochland | Virginia | 51075 | 930 | 7 |
955866 | 955866 | 2021-01-22 | Grayson | Virginia | 51077 | 998 | 26 |
955867 | 955867 | 2021-01-22 | Greene | Virginia | 51079 | 758 | 4 |
955868 | 955868 | 2021-01-22 | Greensville | Virginia | 51081 | 1164 | 17 |
955869 | 955869 | 2021-01-22 | Halifax | Virginia | 51083 | 1817 | 48 |
955870 | 955870 | 2021-01-22 | Hampton city | Virginia | 51650 | 6420 | 59 |
955871 | 955871 | 2021-01-22 | Hanover | Virginia | 51085 | 5332 | 93 |
955872 | 955872 | 2021-01-22 | Harrisonburg city | Virginia | 51660 | 5112 | 57 |
955873 | 955873 | 2021-01-22 | Henrico | Virginia | 51087 | 16846 | 329 |
955874 | 955874 | 2021-01-22 | Henry | Virginia | 51089 | 3484 | 65 |
955875 | 955875 | 2021-01-22 | Highland | Virginia | 51091 | 72 | 0 |
955876 | 955876 | 2021-01-22 | Hopewell city | Virginia | 51670 | 1436 | 12 |
955877 | 955877 | 2021-01-22 | Isle of Wight | Virginia | 51093 | 1973 | 35 |
955878 | 955878 | 2021-01-22 | James City | Virginia | 51095 | 3012 | 37 |
955879 | 955879 | 2021-01-22 | King George | Virginia | 51099 | 1052 | 11 |
955880 | 955880 | 2021-01-22 | King William | Virginia | 51101 | 645 | 5 |
955881 | 955881 | 2021-01-22 | King and Queen | Virginia | 51097 | 234 | 3 |
955882 | 955882 | 2021-01-22 | Lancaster | Virginia | 51103 | 496 | 3 |
955883 | 955883 | 2021-01-22 | Lee | Virginia | 51105 | 2023 | 33 |
955884 | 955884 | 2021-01-22 | Lexington city | Virginia | 51678 | 766 | 15 |
955885 | 955885 | 2021-01-22 | Loudoun | Virginia | 51107 | 17809 | 171 |
955886 | 955886 | 2021-01-22 | Louisa | Virginia | 51109 | 1341 | 11 |
955887 | 955887 | 2021-01-22 | Lunenburg | Virginia | 51111 | 529 | 3 |
955888 | 955888 | 2021-01-22 | Lynchburg city | Virginia | 51680 | 5669 | 66 |
955889 | 955889 | 2021-01-22 | Madison | Virginia | 51113 | 416 | 5 |
955890 | 955890 | 2021-01-22 | Manassas Park city | Virginia | 51685 | 1050 | 8 |
955891 | 955891 | 2021-01-22 | Manassas city | Virginia | 51683 | 3500 | 32 |
955892 | 955892 | 2021-01-22 | Martinsville city | Virginia | 51690 | 1277 | 30 |
955893 | 955893 | 2021-01-22 | Mathews | Virginia | 51115 | 400 | 6 |
955894 | 955894 | 2021-01-22 | Mecklenburg | Virginia | 51117 | 1632 | 43 |
955895 | 955895 | 2021-01-22 | Middlesex | Virginia | 51119 | 370 | 15 |
955896 | 955896 | 2021-01-22 | Montgomery | Virginia | 51121 | 5988 | 56 |
955897 | 955897 | 2021-01-22 | Nelson | Virginia | 51125 | 560 | 5 |
955898 | 955898 | 2021-01-22 | New Kent | Virginia | 51127 | 953 | 7 |
955899 | 955899 | 2021-01-22 | Newport News city | Virginia | 51700 | 8517 | 79 |
955900 | 955900 | 2021-01-22 | Norfolk city | Virginia | 51710 | 11715 | 132 |
955901 | 955901 | 2021-01-22 | Northampton | Virginia | 51131 | 582 | 32 |
955902 | 955902 | 2021-01-22 | Northumberland | Virginia | 51133 | 536 | 12 |
955903 | 955903 | 2021-01-22 | Norton city | Virginia | 51720 | 223 | 2 |
955904 | 955904 | 2021-01-22 | Nottoway | Virginia | 51135 | 1570 | 25 |
955905 | 955905 | 2021-01-22 | Orange | Virginia | 51137 | 1390 | 16 |
955906 | 955906 | 2021-01-22 | Page | Virginia | 51139 | 1445 | 38 |
955907 | 955907 | 2021-01-22 | Patrick | Virginia | 51141 | 976 | 28 |
955908 | 955908 | 2021-01-22 | Petersburg city | Virginia | 51730 | 2253 | 36 |
955909 | 955909 | 2021-01-22 | Pittsylvania | Virginia | 51143 | 3754 | 43 |
955910 | 955910 | 2021-01-22 | Poquoson city | Virginia | 51735 | 513 | 7 |
955911 | 955911 | 2021-01-22 | Portsmouth city | Virginia | 51740 | 6028 | 96 |
955912 | 955912 | 2021-01-22 | Powhatan | Virginia | 51145 | 1184 | 7 |
955913 | 955913 | 2021-01-22 | Prince Edward | Virginia | 51147 | 1505 | 19 |
955914 | 955914 | 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]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);