ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
132 rows where date = "2020-06-29" 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
- 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
- Culpeper 1
- …
state 1
- Virginia · 132 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
286761 | 286761 | 2020-06-29 | Accomack | Virginia | 51001 | 1039 | 14 |
286762 | 286762 | 2020-06-29 | Albemarle | Virginia | 51003 | 394 | 8 |
286763 | 286763 | 2020-06-29 | Alexandria city | Virginia | 51510 | 2317 | 57 |
286764 | 286764 | 2020-06-29 | Alleghany | Virginia | 51005 | 31 | 2 |
286765 | 286765 | 2020-06-29 | Amelia | Virginia | 51007 | 44 | 1 |
286766 | 286766 | 2020-06-29 | Amherst | Virginia | 51009 | 35 | 0 |
286767 | 286767 | 2020-06-29 | Appomattox | Virginia | 51011 | 39 | 0 |
286768 | 286768 | 2020-06-29 | Arlington | Virginia | 51013 | 2466 | 132 |
286769 | 286769 | 2020-06-29 | Augusta | Virginia | 51015 | 183 | 2 |
286770 | 286770 | 2020-06-29 | Bedford | Virginia | 51019 | 114 | 3 |
286771 | 286771 | 2020-06-29 | Bland | Virginia | 51021 | 2 | 0 |
286772 | 286772 | 2020-06-29 | Botetourt | Virginia | 51023 | 86 | 4 |
286773 | 286773 | 2020-06-29 | Bristol city | Virginia | 51520 | 4 | 0 |
286774 | 286774 | 2020-06-29 | Brunswick | Virginia | 51025 | 102 | 1 |
286775 | 286775 | 2020-06-29 | Buchanan | Virginia | 51027 | 31 | 0 |
286776 | 286776 | 2020-06-29 | Buckingham | Virginia | 51029 | 556 | 4 |
286777 | 286777 | 2020-06-29 | Buena Vista city | Virginia | 51530 | 14 | 0 |
286778 | 286778 | 2020-06-29 | Campbell | Virginia | 51031 | 44 | 1 |
286779 | 286779 | 2020-06-29 | Caroline | Virginia | 51033 | 128 | 4 |
286780 | 286780 | 2020-06-29 | Carroll | Virginia | 51035 | 209 | 8 |
286781 | 286781 | 2020-06-29 | Charles City | Virginia | 51036 | 40 | 3 |
286782 | 286782 | 2020-06-29 | Charlotte | Virginia | 51037 | 31 | 0 |
286783 | 286783 | 2020-06-29 | Charlottesville city | Virginia | 51540 | 211 | 3 |
286784 | 286784 | 2020-06-29 | Chesapeake city | Virginia | 51550 | 887 | 20 |
286785 | 286785 | 2020-06-29 | Chesterfield | Virginia | 51041 | 2869 | 49 |
286786 | 286786 | 2020-06-29 | Clarke | Virginia | 51043 | 49 | 0 |
286787 | 286787 | 2020-06-29 | Colonial Heights city | Virginia | 51570 | 143 | 17 |
286788 | 286788 | 2020-06-29 | Covington city | Virginia | 51580 | 3 | 0 |
286789 | 286789 | 2020-06-29 | Craig | Virginia | 51045 | 7 | 0 |
286790 | 286790 | 2020-06-29 | Culpeper | Virginia | 51047 | 808 | 10 |
286791 | 286791 | 2020-06-29 | Cumberland | Virginia | 51049 | 50 | 0 |
286792 | 286792 | 2020-06-29 | Danville city | Virginia | 51590 | 82 | 2 |
286793 | 286793 | 2020-06-29 | Dickenson | Virginia | 51051 | 4 | 0 |
286794 | 286794 | 2020-06-29 | Dinwiddie | Virginia | 51053 | 140 | 0 |
286795 | 286795 | 2020-06-29 | Emporia city | Virginia | 51595 | 133 | 12 |
286796 | 286796 | 2020-06-29 | Essex | Virginia | 51057 | 57 | 0 |
286797 | 286797 | 2020-06-29 | Fairfax | Virginia | 51059 | 13840 | 478 |
286798 | 286798 | 2020-06-29 | Fairfax city | Virginia | 51600 | 70 | 7 |
286799 | 286799 | 2020-06-29 | Falls Church city | Virginia | 51610 | 56 | 8 |
286800 | 286800 | 2020-06-29 | Fauquier | Virginia | 51061 | 417 | 6 |
286801 | 286801 | 2020-06-29 | Floyd | Virginia | 51063 | 17 | 1 |
286802 | 286802 | 2020-06-29 | Fluvanna | Virginia | 51065 | 110 | 6 |
286803 | 286803 | 2020-06-29 | Franklin | Virginia | 51067 | 72 | 1 |
286804 | 286804 | 2020-06-29 | Franklin city | Virginia | 51620 | 50 | 2 |
286805 | 286805 | 2020-06-29 | Frederick | Virginia | 51069 | 491 | 5 |
286806 | 286806 | 2020-06-29 | Fredericksburg city | Virginia | 51630 | 247 | 0 |
286807 | 286807 | 2020-06-29 | Galax city | Virginia | 51640 | 253 | 13 |
286808 | 286808 | 2020-06-29 | Giles | Virginia | 51071 | 14 | 0 |
286809 | 286809 | 2020-06-29 | Gloucester | Virginia | 51073 | 48 | 1 |
286810 | 286810 | 2020-06-29 | Goochland | Virginia | 51075 | 119 | 6 |
286811 | 286811 | 2020-06-29 | Grayson | Virginia | 51077 | 84 | 2 |
286812 | 286812 | 2020-06-29 | Greene | Virginia | 51079 | 65 | 1 |
286813 | 286813 | 2020-06-29 | Greensville | Virginia | 51081 | 354 | 7 |
286814 | 286814 | 2020-06-29 | Halifax | Virginia | 51083 | 50 | 1 |
286815 | 286815 | 2020-06-29 | Hampton city | Virginia | 51650 | 316 | 5 |
286816 | 286816 | 2020-06-29 | Hanover | Virginia | 51085 | 423 | 26 |
286817 | 286817 | 2020-06-29 | Harrisonburg city | Virginia | 51660 | 936 | 24 |
286818 | 286818 | 2020-06-29 | Henrico | Virginia | 51087 | 2584 | 141 |
286819 | 286819 | 2020-06-29 | Henry | Virginia | 51089 | 250 | 4 |
286820 | 286820 | 2020-06-29 | Highland | Virginia | 51091 | 3 | 0 |
286821 | 286821 | 2020-06-29 | Hopewell city | Virginia | 51670 | 169 | 2 |
286822 | 286822 | 2020-06-29 | Isle of Wight | Virginia | 51093 | 178 | 8 |
286823 | 286823 | 2020-06-29 | James City | Virginia | 51095 | 258 | 15 |
286824 | 286824 | 2020-06-29 | King George | Virginia | 51099 | 97 | 4 |
286825 | 286825 | 2020-06-29 | King William | Virginia | 51101 | 42 | 0 |
286826 | 286826 | 2020-06-29 | King and Queen | Virginia | 51097 | 23 | 1 |
286827 | 286827 | 2020-06-29 | Lancaster | Virginia | 51103 | 11 | 0 |
286828 | 286828 | 2020-06-29 | Lee | Virginia | 51105 | 9 | 0 |
286829 | 286829 | 2020-06-29 | Lexington city | Virginia | 51678 | 10 | 0 |
286830 | 286830 | 2020-06-29 | Loudoun | Virginia | 51107 | 3968 | 87 |
286831 | 286831 | 2020-06-29 | Louisa | Virginia | 51109 | 118 | 1 |
286832 | 286832 | 2020-06-29 | Lunenburg | Virginia | 51111 | 31 | 0 |
286833 | 286833 | 2020-06-29 | Lynchburg city | Virginia | 51680 | 139 | 1 |
286834 | 286834 | 2020-06-29 | Madison | Virginia | 51113 | 43 | 1 |
286835 | 286835 | 2020-06-29 | Manassas Park city | Virginia | 51685 | 427 | 5 |
286836 | 286836 | 2020-06-29 | Manassas city | Virginia | 51683 | 1385 | 16 |
286837 | 286837 | 2020-06-29 | Martinsville city | Virginia | 51690 | 74 | 1 |
286838 | 286838 | 2020-06-29 | Mathews | Virginia | 51115 | 5 | 0 |
286839 | 286839 | 2020-06-29 | Mecklenburg | Virginia | 51117 | 240 | 26 |
286840 | 286840 | 2020-06-29 | Middlesex | Virginia | 51119 | 15 | 0 |
286841 | 286841 | 2020-06-29 | Montgomery | Virginia | 51121 | 143 | 2 |
286842 | 286842 | 2020-06-29 | Nelson | Virginia | 51125 | 18 | 0 |
286843 | 286843 | 2020-06-29 | New Kent | Virginia | 51127 | 57 | 1 |
286844 | 286844 | 2020-06-29 | Newport News city | Virginia | 51700 | 513 | 10 |
286845 | 286845 | 2020-06-29 | Norfolk city | Virginia | 51710 | 889 | 9 |
286846 | 286846 | 2020-06-29 | Northampton | Virginia | 51131 | 269 | 28 |
286847 | 286847 | 2020-06-29 | Northumberland | Virginia | 51133 | 39 | 1 |
286848 | 286848 | 2020-06-29 | Norton city | Virginia | 51720 | 4 | 0 |
286849 | 286849 | 2020-06-29 | Nottoway | Virginia | 51135 | 110 | 2 |
286850 | 286850 | 2020-06-29 | Orange | Virginia | 51137 | 146 | 3 |
286851 | 286851 | 2020-06-29 | Page | Virginia | 51139 | 267 | 24 |
286852 | 286852 | 2020-06-29 | Patrick | Virginia | 51141 | 42 | 1 |
286853 | 286853 | 2020-06-29 | Petersburg city | Virginia | 51730 | 226 | 3 |
286854 | 286854 | 2020-06-29 | Pittsylvania | Virginia | 51143 | 117 | 1 |
286855 | 286855 | 2020-06-29 | Poquoson city | Virginia | 51735 | 19 | 0 |
286856 | 286856 | 2020-06-29 | Portsmouth city | Virginia | 51740 | 471 | 16 |
286857 | 286857 | 2020-06-29 | Powhatan | Virginia | 51145 | 79 | 2 |
286858 | 286858 | 2020-06-29 | Prince Edward | Virginia | 51147 | 186 | 3 |
286859 | 286859 | 2020-06-29 | Prince George | Virginia | 51149 | 235 | 1 |
286860 | 286860 | 2020-06-29 | Prince William | Virginia | 51153 | 7210 | 139 |
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);