ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
133 rows where "date" is on date 2021-12-15 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|
2017787 | 2017787 | 2021-12-15 | Accomack | Virginia | 51001 | 4312 | 83 |
2017788 | 2017788 | 2021-12-15 | Albemarle | Virginia | 51003 | 8826 | 113 |
2017789 | 2017789 | 2021-12-15 | Alexandria city | Virginia | 51510 | 15407 | 156 |
2017790 | 2017790 | 2021-12-15 | Alleghany | Virginia | 51005 | 2383 | 85 |
2017791 | 2017791 | 2021-12-15 | Amelia | Virginia | 51007 | 1627 | 42 |
2017792 | 2017792 | 2021-12-15 | Amherst | Virginia | 51009 | 4671 | 62 |
2017793 | 2017793 | 2021-12-15 | Appomattox | Virginia | 51011 | 2612 | 37 |
2017794 | 2017794 | 2021-12-15 | Arlington | Virginia | 51013 | 20448 | 276 |
2017795 | 2017795 | 2021-12-15 | Augusta | Virginia | 51015 | 11152 | 140 |
2017796 | 2017796 | 2021-12-15 | Bath | Virginia | 51017 | 534 | 15 |
2017797 | 2017797 | 2021-12-15 | Bedford | Virginia | 51019 | 10852 | 169 |
2017798 | 2017798 | 2021-12-15 | Bland | Virginia | 51021 | 1147 | 18 |
2017799 | 2017799 | 2021-12-15 | Botetourt | Virginia | 51023 | 4439 | 58 |
2017800 | 2017800 | 2021-12-15 | Bristol city | Virginia | 51520 | 2574 | 51 |
2017801 | 2017801 | 2021-12-15 | Brunswick | Virginia | 51025 | 1880 | 35 |
2017802 | 2017802 | 2021-12-15 | Buchanan | Virginia | 51027 | 2951 | 83 |
2017803 | 2017803 | 2021-12-15 | Buckingham | Virginia | 51029 | 2794 | 40 |
2017804 | 2017804 | 2021-12-15 | Buena Vista city | Virginia | 51530 | 1465 | 31 |
2017805 | 2017805 | 2021-12-15 | Campbell | Virginia | 51031 | 7933 | 152 |
2017806 | 2017806 | 2021-12-15 | Caroline | Virginia | 51033 | 4486 | 56 |
2017807 | 2017807 | 2021-12-15 | Carroll | Virginia | 51035 | 4530 | 106 |
2017808 | 2017808 | 2021-12-15 | Charles City | Virginia | 51036 | 770 | 21 |
2017809 | 2017809 | 2021-12-15 | Charlotte | Virginia | 51037 | 1443 | 28 |
2017810 | 2017810 | 2021-12-15 | Charlottesville city | Virginia | 51540 | 5711 | 62 |
2017811 | 2017811 | 2021-12-15 | Chesapeake city | Virginia | 51550 | 30612 | 375 |
2017812 | 2017812 | 2021-12-15 | Chesterfield | Virginia | 51041 | 43085 | 587 |
2017813 | 2017813 | 2021-12-15 | Clarke | Virginia | 51043 | 1634 | 33 |
2017814 | 2017814 | 2021-12-15 | Colonial Heights city | Virginia | 51570 | 2772 | 70 |
2017815 | 2017815 | 2021-12-15 | Covington city | Virginia | 51580 | 795 | 19 |
2017816 | 2017816 | 2021-12-15 | Craig | Virginia | 51045 | 702 | 11 |
2017817 | 2017817 | 2021-12-15 | Culpeper | Virginia | 51047 | 7280 | 93 |
2017818 | 2017818 | 2021-12-15 | Cumberland | Virginia | 51049 | 791 | 19 |
2017819 | 2017819 | 2021-12-15 | Danville city | Virginia | 51590 | 6621 | 204 |
2017820 | 2017820 | 2021-12-15 | Dickenson | Virginia | 51051 | 2100 | 32 |
2017821 | 2017821 | 2021-12-15 | Dinwiddie | Virginia | 51053 | 3538 | 61 |
2017822 | 2017822 | 2021-12-15 | Emporia city | Virginia | 51595 | 848 | 46 |
2017823 | 2017823 | 2021-12-15 | Essex | Virginia | 51057 | 1371 | 20 |
2017824 | 2017824 | 2021-12-15 | Fairfax | Virginia | 51059 | 98198 | 1184 |
2017825 | 2017825 | 2021-12-15 | Fairfax city | Virginia | 51600 | 1131 | 35 |
2017826 | 2017826 | 2021-12-15 | Falls Church city | Virginia | 51610 | 746 | 14 |
2017827 | 2017827 | 2021-12-15 | Fauquier | Virginia | 51061 | 7949 | 92 |
2017828 | 2017828 | 2021-12-15 | Floyd | Virginia | 51063 | 1664 | 32 |
2017829 | 2017829 | 2021-12-15 | Fluvanna | Virginia | 51065 | 3076 | 29 |
2017830 | 2017830 | 2021-12-15 | Franklin | Virginia | 51067 | 6902 | 116 |
2017831 | 2017831 | 2021-12-15 | Franklin city | Virginia | 51620 | 1707 | 43 |
2017832 | 2017832 | 2021-12-15 | Frederick | Virginia | 51069 | 13314 | 166 |
2017833 | 2017833 | 2021-12-15 | Fredericksburg city | Virginia | 51630 | 3290 | 26 |
2017834 | 2017834 | 2021-12-15 | Galax city | Virginia | 51640 | 1689 | 65 |
2017835 | 2017835 | 2021-12-15 | Giles | Virginia | 51071 | 2488 | 35 |
2017836 | 2017836 | 2021-12-15 | Gloucester | Virginia | 51073 | 4147 | 82 |
2017837 | 2017837 | 2021-12-15 | Goochland | Virginia | 51075 | 2293 | 32 |
2017838 | 2017838 | 2021-12-15 | Grayson | Virginia | 51077 | 2416 | 56 |
2017839 | 2017839 | 2021-12-15 | Greene | Virginia | 51079 | 2438 | 45 |
2017840 | 2017840 | 2021-12-15 | Greensville | Virginia | 51081 | 1991 | 27 |
2017841 | 2017841 | 2021-12-15 | Halifax | Virginia | 51083 | 4282 | 117 |
2017842 | 2017842 | 2021-12-15 | Hampton city | Virginia | 51650 | 15867 | 249 |
2017843 | 2017843 | 2021-12-15 | Hanover | Virginia | 51085 | 13111 | 202 |
2017844 | 2017844 | 2021-12-15 | Harrisonburg city | Virginia | 51660 | 8714 | 114 |
2017845 | 2017845 | 2021-12-15 | Henrico | Virginia | 51087 | 37457 | 740 |
2017846 | 2017846 | 2021-12-15 | Henry | Virginia | 51089 | 7333 | 190 |
2017847 | 2017847 | 2021-12-15 | Highland | Virginia | 51091 | 215 | 4 |
2017848 | 2017848 | 2021-12-15 | Hopewell city | Virginia | 51670 | 3832 | 95 |
2017849 | 2017849 | 2021-12-15 | Isle of Wight | Virginia | 51093 | 4740 | 93 |
2017850 | 2017850 | 2021-12-15 | James City | Virginia | 51095 | 7682 | 100 |
2017851 | 2017851 | 2021-12-15 | King George | Virginia | 51099 | 3017 | 24 |
2017852 | 2017852 | 2021-12-15 | King William | Virginia | 51101 | 2252 | 26 |
2017853 | 2017853 | 2021-12-15 | King and Queen | Virginia | 51097 | 699 | 9 |
2017854 | 2017854 | 2021-12-15 | Lancaster | Virginia | 51103 | 1119 | 24 |
2017855 | 2017855 | 2021-12-15 | Lee | Virginia | 51105 | 4014 | 62 |
2017856 | 2017856 | 2021-12-15 | Lexington city | Virginia | 51678 | 1659 | 37 |
2017857 | 2017857 | 2021-12-15 | Loudoun | Virginia | 51107 | 37708 | 307 |
2017858 | 2017858 | 2021-12-15 | Louisa | Virginia | 51109 | 3761 | 54 |
2017859 | 2017859 | 2021-12-15 | Lunenburg | Virginia | 51111 | 1233 | 23 |
2017860 | 2017860 | 2021-12-15 | Lynchburg city | Virginia | 51680 | 12390 | 205 |
2017861 | 2017861 | 2021-12-15 | Madison | Virginia | 51113 | 1194 | 23 |
2017862 | 2017862 | 2021-12-15 | Manassas Park city | Virginia | 51685 | 1296 | 15 |
2017863 | 2017863 | 2021-12-15 | Manassas city | Virginia | 51683 | 5482 | 54 |
2017864 | 2017864 | 2021-12-15 | Martinsville city | Virginia | 51690 | 2290 | 94 |
2017865 | 2017865 | 2021-12-15 | Mathews | Virginia | 51115 | 938 | 24 |
2017866 | 2017866 | 2021-12-15 | Mecklenburg | Virginia | 51117 | 3671 | 93 |
2017867 | 2017867 | 2021-12-15 | Middlesex | Virginia | 51119 | 1040 | 33 |
2017868 | 2017868 | 2021-12-15 | Montgomery | Virginia | 51121 | 12497 | 117 |
2017869 | 2017869 | 2021-12-15 | Nelson | Virginia | 51125 | 1571 | 23 |
2017870 | 2017870 | 2021-12-15 | New Kent | Virginia | 51127 | 2710 | 27 |
2017871 | 2017871 | 2021-12-15 | Newport News city | Virginia | 51700 | 21708 | 308 |
2017872 | 2017872 | 2021-12-15 | Norfolk city | Virginia | 51710 | 25770 | 362 |
2017873 | 2017873 | 2021-12-15 | Northampton | Virginia | 51131 | 1204 | 48 |
2017874 | 2017874 | 2021-12-15 | Northumberland | Virginia | 51133 | 1288 | 37 |
2017875 | 2017875 | 2021-12-15 | Norton city | Virginia | 51720 | 703 | 17 |
2017876 | 2017876 | 2021-12-15 | Nottoway | Virginia | 51135 | 2699 | 70 |
2017877 | 2017877 | 2021-12-15 | Orange | Virginia | 51137 | 4209 | 65 |
2017878 | 2017878 | 2021-12-15 | Page | Virginia | 51139 | 3831 | 90 |
2017879 | 2017879 | 2021-12-15 | Patrick | Virginia | 51141 | 2410 | 61 |
2017880 | 2017880 | 2021-12-15 | Petersburg city | Virginia | 51730 | 5236 | 107 |
2017881 | 2017881 | 2021-12-15 | Pittsylvania | Virginia | 51143 | 8713 | 134 |
2017882 | 2017882 | 2021-12-15 | Poquoson city | Virginia | 51735 | 1424 | 23 |
2017883 | 2017883 | 2021-12-15 | Portsmouth city | Virginia | 51740 | 13287 | 254 |
2017884 | 2017884 | 2021-12-15 | Powhatan | Virginia | 51145 | 3099 | 31 |
2017885 | 2017885 | 2021-12-15 | Prince Edward | Virginia | 51147 | 3075 | 53 |
2017886 | 2017886 | 2021-12-15 | Prince George | Virginia | 51149 | 5405 | 52 |
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);