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-11-29 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 |
---|---|---|---|---|---|---|---|
1965781 | 1965781 | 2021-11-29 | Accomack | Virginia | 51001 | 4210 | 80 |
1965782 | 1965782 | 2021-11-29 | Albemarle | Virginia | 51003 | 8486 | 110 |
1965783 | 1965783 | 2021-11-29 | Alexandria city | Virginia | 51510 | 14789 | 154 |
1965784 | 1965784 | 2021-11-29 | Alleghany | Virginia | 51005 | 2258 | 83 |
1965785 | 1965785 | 2021-11-29 | Amelia | Virginia | 51007 | 1560 | 42 |
1965786 | 1965786 | 2021-11-29 | Amherst | Virginia | 51009 | 4509 | 61 |
1965787 | 1965787 | 2021-11-29 | Appomattox | Virginia | 51011 | 2513 | 36 |
1965788 | 1965788 | 2021-11-29 | Arlington | Virginia | 51013 | 19470 | 275 |
1965789 | 1965789 | 2021-11-29 | Augusta | Virginia | 51015 | 10680 | 139 |
1965790 | 1965790 | 2021-11-29 | Bath | Virginia | 51017 | 510 | 15 |
1965791 | 1965791 | 2021-11-29 | Bedford | Virginia | 51019 | 10401 | 164 |
1965792 | 1965792 | 2021-11-29 | Bland | Virginia | 51021 | 1126 | 17 |
1965793 | 1965793 | 2021-11-29 | Botetourt | Virginia | 51023 | 4148 | 57 |
1965794 | 1965794 | 2021-11-29 | Bristol city | Virginia | 51520 | 2394 | 50 |
1965795 | 1965795 | 2021-11-29 | Brunswick | Virginia | 51025 | 1850 | 35 |
1965796 | 1965796 | 2021-11-29 | Buchanan | Virginia | 51027 | 2807 | 77 |
1965797 | 1965797 | 2021-11-29 | Buckingham | Virginia | 51029 | 2734 | 39 |
1965798 | 1965798 | 2021-11-29 | Buena Vista city | Virginia | 51530 | 1419 | 28 |
1965799 | 1965799 | 2021-11-29 | Campbell | Virginia | 51031 | 7577 | 147 |
1965800 | 1965800 | 2021-11-29 | Caroline | Virginia | 51033 | 4277 | 55 |
1965801 | 1965801 | 2021-11-29 | Carroll | Virginia | 51035 | 4312 | 105 |
1965802 | 1965802 | 2021-11-29 | Charles City | Virginia | 51036 | 741 | 21 |
1965803 | 1965803 | 2021-11-29 | Charlotte | Virginia | 51037 | 1369 | 28 |
1965804 | 1965804 | 2021-11-29 | Charlottesville city | Virginia | 51540 | 5525 | 62 |
1965805 | 1965805 | 2021-11-29 | Chesapeake city | Virginia | 51550 | 29730 | 371 |
1965806 | 1965806 | 2021-11-29 | Chesterfield | Virginia | 51041 | 41420 | 572 |
1965807 | 1965807 | 2021-11-29 | Clarke | Virginia | 51043 | 1512 | 29 |
1965808 | 1965808 | 2021-11-29 | Colonial Heights city | Virginia | 51570 | 2684 | 69 |
1965809 | 1965809 | 2021-11-29 | Covington city | Virginia | 51580 | 781 | 18 |
1965810 | 1965810 | 2021-11-29 | Craig | Virginia | 51045 | 648 | 10 |
1965811 | 1965811 | 2021-11-29 | Culpeper | Virginia | 51047 | 6911 | 92 |
1965812 | 1965812 | 2021-11-29 | Cumberland | Virginia | 51049 | 740 | 19 |
1965813 | 1965813 | 2021-11-29 | Danville city | Virginia | 51590 | 6469 | 198 |
1965814 | 1965814 | 2021-11-29 | Dickenson | Virginia | 51051 | 1941 | 29 |
1965815 | 1965815 | 2021-11-29 | Dinwiddie | Virginia | 51053 | 3469 | 59 |
1965816 | 1965816 | 2021-11-29 | Emporia city | Virginia | 51595 | 842 | 46 |
1965817 | 1965817 | 2021-11-29 | Essex | Virginia | 51057 | 1320 | 20 |
1965818 | 1965818 | 2021-11-29 | Fairfax | Virginia | 51059 | 94835 | 1177 |
1965819 | 1965819 | 2021-11-29 | Fairfax city | Virginia | 51600 | 1101 | 35 |
1965820 | 1965820 | 2021-11-29 | Falls Church city | Virginia | 51610 | 715 | 14 |
1965821 | 1965821 | 2021-11-29 | Fauquier | Virginia | 51061 | 7490 | 88 |
1965822 | 1965822 | 2021-11-29 | Floyd | Virginia | 51063 | 1551 | 32 |
1965823 | 1965823 | 2021-11-29 | Fluvanna | Virginia | 51065 | 2941 | 28 |
1965824 | 1965824 | 2021-11-29 | Franklin | Virginia | 51067 | 6457 | 112 |
1965825 | 1965825 | 2021-11-29 | Franklin city | Virginia | 51620 | 1676 | 44 |
1965826 | 1965826 | 2021-11-29 | Frederick | Virginia | 51069 | 12422 | 161 |
1965827 | 1965827 | 2021-11-29 | Fredericksburg city | Virginia | 51630 | 3184 | 26 |
1965828 | 1965828 | 2021-11-29 | Galax city | Virginia | 51640 | 1617 | 64 |
1965829 | 1965829 | 2021-11-29 | Giles | Virginia | 51071 | 2400 | 33 |
1965830 | 1965830 | 2021-11-29 | Gloucester | Virginia | 51073 | 4014 | 80 |
1965831 | 1965831 | 2021-11-29 | Goochland | Virginia | 51075 | 2172 | 31 |
1965832 | 1965832 | 2021-11-29 | Grayson | Virginia | 51077 | 2286 | 52 |
1965833 | 1965833 | 2021-11-29 | Greene | Virginia | 51079 | 2334 | 45 |
1965834 | 1965834 | 2021-11-29 | Greensville | Virginia | 51081 | 1963 | 26 |
1965835 | 1965835 | 2021-11-29 | Halifax | Virginia | 51083 | 4117 | 113 |
1965836 | 1965836 | 2021-11-29 | Hampton city | Virginia | 51650 | 15485 | 248 |
1965837 | 1965837 | 2021-11-29 | Hanover | Virginia | 51085 | 12427 | 201 |
1965838 | 1965838 | 2021-11-29 | Harrisonburg city | Virginia | 51660 | 8469 | 114 |
1965839 | 1965839 | 2021-11-29 | Henrico | Virginia | 51087 | 35843 | 734 |
1965840 | 1965840 | 2021-11-29 | Henry | Virginia | 51089 | 7025 | 173 |
1965841 | 1965841 | 2021-11-29 | Highland | Virginia | 51091 | 192 | 4 |
1965842 | 1965842 | 2021-11-29 | Hopewell city | Virginia | 51670 | 3729 | 89 |
1965843 | 1965843 | 2021-11-29 | Isle of Wight | Virginia | 51093 | 4613 | 92 |
1965844 | 1965844 | 2021-11-29 | James City | Virginia | 51095 | 7409 | 97 |
1965845 | 1965845 | 2021-11-29 | King George | Virginia | 51099 | 2847 | 24 |
1965846 | 1965846 | 2021-11-29 | King William | Virginia | 51101 | 2103 | 25 |
1965847 | 1965847 | 2021-11-29 | King and Queen | Virginia | 51097 | 668 | 9 |
1965848 | 1965848 | 2021-11-29 | Lancaster | Virginia | 51103 | 1085 | 23 |
1965849 | 1965849 | 2021-11-29 | Lee | Virginia | 51105 | 3901 | 62 |
1965850 | 1965850 | 2021-11-29 | Lexington city | Virginia | 51678 | 1627 | 37 |
1965851 | 1965851 | 2021-11-29 | Loudoun | Virginia | 51107 | 35847 | 303 |
1965852 | 1965852 | 2021-11-29 | Louisa | Virginia | 51109 | 3524 | 53 |
1965853 | 1965853 | 2021-11-29 | Lunenburg | Virginia | 51111 | 1201 | 22 |
1965854 | 1965854 | 2021-11-29 | Lynchburg city | Virginia | 51680 | 12001 | 195 |
1965855 | 1965855 | 2021-11-29 | Madison | Virginia | 51113 | 1096 | 23 |
1965856 | 1965856 | 2021-11-29 | Manassas Park city | Virginia | 51685 | 1285 | 14 |
1965857 | 1965857 | 2021-11-29 | Manassas city | Virginia | 51683 | 5271 | 54 |
1965858 | 1965858 | 2021-11-29 | Martinsville city | Virginia | 51690 | 2216 | 91 |
1965859 | 1965859 | 2021-11-29 | Mathews | Virginia | 51115 | 915 | 24 |
1965860 | 1965860 | 2021-11-29 | Mecklenburg | Virginia | 51117 | 3575 | 89 |
1965861 | 1965861 | 2021-11-29 | Middlesex | Virginia | 51119 | 986 | 33 |
1965862 | 1965862 | 2021-11-29 | Montgomery | Virginia | 51121 | 12139 | 114 |
1965863 | 1965863 | 2021-11-29 | Nelson | Virginia | 51125 | 1449 | 20 |
1965864 | 1965864 | 2021-11-29 | New Kent | Virginia | 51127 | 2591 | 26 |
1965865 | 1965865 | 2021-11-29 | Newport News city | Virginia | 51700 | 21180 | 305 |
1965866 | 1965866 | 2021-11-29 | Norfolk city | Virginia | 51710 | 25109 | 358 |
1965867 | 1965867 | 2021-11-29 | Northampton | Virginia | 51131 | 1180 | 46 |
1965868 | 1965868 | 2021-11-29 | Northumberland | Virginia | 51133 | 1248 | 37 |
1965869 | 1965869 | 2021-11-29 | Norton city | Virginia | 51720 | 653 | 17 |
1965870 | 1965870 | 2021-11-29 | Nottoway | Virginia | 51135 | 2662 | 70 |
1965871 | 1965871 | 2021-11-29 | Orange | Virginia | 51137 | 4009 | 62 |
1965872 | 1965872 | 2021-11-29 | Page | Virginia | 51139 | 3596 | 88 |
1965873 | 1965873 | 2021-11-29 | Patrick | Virginia | 51141 | 2277 | 59 |
1965874 | 1965874 | 2021-11-29 | Petersburg city | Virginia | 51730 | 5122 | 104 |
1965875 | 1965875 | 2021-11-29 | Pittsylvania | Virginia | 51143 | 8465 | 130 |
1965876 | 1965876 | 2021-11-29 | Poquoson city | Virginia | 51735 | 1370 | 22 |
1965877 | 1965877 | 2021-11-29 | Portsmouth city | Virginia | 51740 | 13020 | 250 |
1965878 | 1965878 | 2021-11-29 | Powhatan | Virginia | 51145 | 2947 | 28 |
1965879 | 1965879 | 2021-11-29 | Prince Edward | Virginia | 51147 | 3003 | 52 |
1965880 | 1965880 | 2021-11-29 | Prince George | Virginia | 51149 | 5281 | 51 |
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);