ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
133 rows where date = "2021-12-11" 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 |
---|---|---|---|---|---|---|---|
2004784 | 2004784 | 2021-12-11 | Accomack | Virginia | 51001 | 4285 | 81 |
2004785 | 2004785 | 2021-12-11 | Albemarle | Virginia | 51003 | 8705 | 113 |
2004786 | 2004786 | 2021-12-11 | Alexandria city | Virginia | 51510 | 15185 | 155 |
2004787 | 2004787 | 2021-12-11 | Alleghany | Virginia | 51005 | 2342 | 84 |
2004788 | 2004788 | 2021-12-11 | Amelia | Virginia | 51007 | 1607 | 42 |
2004789 | 2004789 | 2021-12-11 | Amherst | Virginia | 51009 | 4623 | 62 |
2004790 | 2004790 | 2021-12-11 | Appomattox | Virginia | 51011 | 2597 | 36 |
2004791 | 2004791 | 2021-12-11 | Arlington | Virginia | 51013 | 20112 | 276 |
2004792 | 2004792 | 2021-12-11 | Augusta | Virginia | 51015 | 11010 | 140 |
2004793 | 2004793 | 2021-12-11 | Bath | Virginia | 51017 | 530 | 15 |
2004794 | 2004794 | 2021-12-11 | Bedford | Virginia | 51019 | 10705 | 168 |
2004795 | 2004795 | 2021-12-11 | Bland | Virginia | 51021 | 1148 | 18 |
2004796 | 2004796 | 2021-12-11 | Botetourt | Virginia | 51023 | 4325 | 58 |
2004797 | 2004797 | 2021-12-11 | Bristol city | Virginia | 51520 | 2535 | 50 |
2004798 | 2004798 | 2021-12-11 | Brunswick | Virginia | 51025 | 1871 | 35 |
2004799 | 2004799 | 2021-12-11 | Buchanan | Virginia | 51027 | 2920 | 82 |
2004800 | 2004800 | 2021-12-11 | Buckingham | Virginia | 51029 | 2777 | 40 |
2004801 | 2004801 | 2021-12-11 | Buena Vista city | Virginia | 51530 | 1455 | 31 |
2004802 | 2004802 | 2021-12-11 | Campbell | Virginia | 51031 | 7837 | 152 |
2004803 | 2004803 | 2021-12-11 | Caroline | Virginia | 51033 | 4429 | 56 |
2004804 | 2004804 | 2021-12-11 | Carroll | Virginia | 51035 | 4487 | 105 |
2004805 | 2004805 | 2021-12-11 | Charles City | Virginia | 51036 | 764 | 21 |
2004806 | 2004806 | 2021-12-11 | Charlotte | Virginia | 51037 | 1421 | 28 |
2004807 | 2004807 | 2021-12-11 | Charlottesville city | Virginia | 51540 | 5645 | 62 |
2004808 | 2004808 | 2021-12-11 | Chesapeake city | Virginia | 51550 | 30326 | 374 |
2004809 | 2004809 | 2021-12-11 | Chesterfield | Virginia | 51041 | 42491 | 583 |
2004810 | 2004810 | 2021-12-11 | Clarke | Virginia | 51043 | 1599 | 32 |
2004811 | 2004811 | 2021-12-11 | Colonial Heights city | Virginia | 51570 | 2740 | 70 |
2004812 | 2004812 | 2021-12-11 | Covington city | Virginia | 51580 | 790 | 18 |
2004813 | 2004813 | 2021-12-11 | Craig | Virginia | 51045 | 684 | 10 |
2004814 | 2004814 | 2021-12-11 | Culpeper | Virginia | 51047 | 7177 | 92 |
2004815 | 2004815 | 2021-12-11 | Cumberland | Virginia | 51049 | 773 | 19 |
2004816 | 2004816 | 2021-12-11 | Danville city | Virginia | 51590 | 6582 | 201 |
2004817 | 2004817 | 2021-12-11 | Dickenson | Virginia | 51051 | 2063 | 30 |
2004818 | 2004818 | 2021-12-11 | Dinwiddie | Virginia | 51053 | 3513 | 60 |
2004819 | 2004819 | 2021-12-11 | Emporia city | Virginia | 51595 | 846 | 46 |
2004820 | 2004820 | 2021-12-11 | Essex | Virginia | 51057 | 1356 | 20 |
2004821 | 2004821 | 2021-12-11 | Fairfax | Virginia | 51059 | 97108 | 1178 |
2004822 | 2004822 | 2021-12-11 | Fairfax city | Virginia | 51600 | 1120 | 35 |
2004823 | 2004823 | 2021-12-11 | Falls Church city | Virginia | 51610 | 736 | 14 |
2004824 | 2004824 | 2021-12-11 | Fauquier | Virginia | 51061 | 7807 | 91 |
2004825 | 2004825 | 2021-12-11 | Floyd | Virginia | 51063 | 1629 | 32 |
2004826 | 2004826 | 2021-12-11 | Fluvanna | Virginia | 51065 | 3042 | 29 |
2004827 | 2004827 | 2021-12-11 | Franklin | Virginia | 51067 | 6751 | 115 |
2004828 | 2004828 | 2021-12-11 | Franklin city | Virginia | 51620 | 1699 | 43 |
2004829 | 2004829 | 2021-12-11 | Frederick | Virginia | 51069 | 13035 | 165 |
2004830 | 2004830 | 2021-12-11 | Fredericksburg city | Virginia | 51630 | 3260 | 26 |
2004831 | 2004831 | 2021-12-11 | Galax city | Virginia | 51640 | 1670 | 64 |
2004832 | 2004832 | 2021-12-11 | Giles | Virginia | 51071 | 2454 | 35 |
2004833 | 2004833 | 2021-12-11 | Gloucester | Virginia | 51073 | 4088 | 80 |
2004834 | 2004834 | 2021-12-11 | Goochland | Virginia | 51075 | 2268 | 32 |
2004835 | 2004835 | 2021-12-11 | Grayson | Virginia | 51077 | 2376 | 54 |
2004836 | 2004836 | 2021-12-11 | Greene | Virginia | 51079 | 2413 | 45 |
2004837 | 2004837 | 2021-12-11 | Greensville | Virginia | 51081 | 1978 | 26 |
2004838 | 2004838 | 2021-12-11 | Halifax | Virginia | 51083 | 4235 | 117 |
2004839 | 2004839 | 2021-12-11 | Hampton city | Virginia | 51650 | 15750 | 249 |
2004840 | 2004840 | 2021-12-11 | Hanover | Virginia | 51085 | 12893 | 202 |
2004841 | 2004841 | 2021-12-11 | Harrisonburg city | Virginia | 51660 | 8633 | 114 |
2004842 | 2004842 | 2021-12-11 | Henrico | Virginia | 51087 | 36966 | 737 |
2004843 | 2004843 | 2021-12-11 | Henry | Virginia | 51089 | 7239 | 185 |
2004844 | 2004844 | 2021-12-11 | Highland | Virginia | 51091 | 204 | 4 |
2004845 | 2004845 | 2021-12-11 | Hopewell city | Virginia | 51670 | 3793 | 94 |
2004846 | 2004846 | 2021-12-11 | Isle of Wight | Virginia | 51093 | 4708 | 92 |
2004847 | 2004847 | 2021-12-11 | James City | Virginia | 51095 | 7630 | 99 |
2004848 | 2004848 | 2021-12-11 | King George | Virginia | 51099 | 2972 | 24 |
2004849 | 2004849 | 2021-12-11 | King William | Virginia | 51101 | 2207 | 26 |
2004850 | 2004850 | 2021-12-11 | King and Queen | Virginia | 51097 | 690 | 9 |
2004851 | 2004851 | 2021-12-11 | Lancaster | Virginia | 51103 | 1102 | 24 |
2004852 | 2004852 | 2021-12-11 | Lee | Virginia | 51105 | 3981 | 62 |
2004853 | 2004853 | 2021-12-11 | Lexington city | Virginia | 51678 | 1650 | 37 |
2004854 | 2004854 | 2021-12-11 | Loudoun | Virginia | 51107 | 37054 | 304 |
2004855 | 2004855 | 2021-12-11 | Louisa | Virginia | 51109 | 3693 | 54 |
2004856 | 2004856 | 2021-12-11 | Lunenburg | Virginia | 51111 | 1219 | 23 |
2004857 | 2004857 | 2021-12-11 | Lynchburg city | Virginia | 51680 | 12312 | 199 |
2004858 | 2004858 | 2021-12-11 | Madison | Virginia | 51113 | 1153 | 23 |
2004859 | 2004859 | 2021-12-11 | Manassas Park city | Virginia | 51685 | 1295 | 15 |
2004860 | 2004860 | 2021-12-11 | Manassas city | Virginia | 51683 | 5399 | 54 |
2004861 | 2004861 | 2021-12-11 | Martinsville city | Virginia | 51690 | 2269 | 94 |
2004862 | 2004862 | 2021-12-11 | Mathews | Virginia | 51115 | 936 | 24 |
2004863 | 2004863 | 2021-12-11 | Mecklenburg | Virginia | 51117 | 3656 | 91 |
2004864 | 2004864 | 2021-12-11 | Middlesex | Virginia | 51119 | 1008 | 33 |
2004865 | 2004865 | 2021-12-11 | Montgomery | Virginia | 51121 | 12379 | 116 |
2004866 | 2004866 | 2021-12-11 | Nelson | Virginia | 51125 | 1525 | 23 |
2004867 | 2004867 | 2021-12-11 | New Kent | Virginia | 51127 | 2658 | 27 |
2004868 | 2004868 | 2021-12-11 | Newport News city | Virginia | 51700 | 21531 | 306 |
2004869 | 2004869 | 2021-12-11 | Norfolk city | Virginia | 51710 | 25541 | 361 |
2004870 | 2004870 | 2021-12-11 | Northampton | Virginia | 51131 | 1201 | 47 |
2004871 | 2004871 | 2021-12-11 | Northumberland | Virginia | 51133 | 1279 | 37 |
2004872 | 2004872 | 2021-12-11 | Norton city | Virginia | 51720 | 687 | 17 |
2004873 | 2004873 | 2021-12-11 | Nottoway | Virginia | 51135 | 2683 | 70 |
2004874 | 2004874 | 2021-12-11 | Orange | Virginia | 51137 | 4152 | 63 |
2004875 | 2004875 | 2021-12-11 | Page | Virginia | 51139 | 3744 | 89 |
2004876 | 2004876 | 2021-12-11 | Patrick | Virginia | 51141 | 2373 | 60 |
2004877 | 2004877 | 2021-12-11 | Petersburg city | Virginia | 51730 | 5202 | 105 |
2004878 | 2004878 | 2021-12-11 | Pittsylvania | Virginia | 51143 | 8647 | 133 |
2004879 | 2004879 | 2021-12-11 | Poquoson city | Virginia | 51735 | 1411 | 23 |
2004880 | 2004880 | 2021-12-11 | Portsmouth city | Virginia | 51740 | 13188 | 252 |
2004881 | 2004881 | 2021-12-11 | Powhatan | Virginia | 51145 | 3061 | 31 |
2004882 | 2004882 | 2021-12-11 | Prince Edward | Virginia | 51147 | 3046 | 52 |
2004883 | 2004883 | 2021-12-11 | Prince George | Virginia | 51149 | 5362 | 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);