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 2020-07-11 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 |
---|---|---|---|---|---|---|---|
324753 | 324753 | 2020-07-11 | Accomack | Virginia | 51001 | 1042 | 14 |
324754 | 324754 | 2020-07-11 | Albemarle | Virginia | 51003 | 533 | 10 |
324755 | 324755 | 2020-07-11 | Alexandria city | Virginia | 51510 | 2453 | 57 |
324756 | 324756 | 2020-07-11 | Alleghany | Virginia | 51005 | 40 | 2 |
324757 | 324757 | 2020-07-11 | Amelia | Virginia | 51007 | 49 | 1 |
324758 | 324758 | 2020-07-11 | Amherst | Virginia | 51009 | 40 | 0 |
324759 | 324759 | 2020-07-11 | Appomattox | Virginia | 51011 | 47 | 0 |
324760 | 324760 | 2020-07-11 | Arlington | Virginia | 51013 | 2597 | 134 |
324761 | 324761 | 2020-07-11 | Augusta | Virginia | 51015 | 205 | 2 |
324762 | 324762 | 2020-07-11 | Bath | Virginia | 51017 | 1 | 0 |
324763 | 324763 | 2020-07-11 | Bedford | Virginia | 51019 | 156 | 4 |
324764 | 324764 | 2020-07-11 | Bland | Virginia | 51021 | 3 | 0 |
324765 | 324765 | 2020-07-11 | Botetourt | Virginia | 51023 | 152 | 4 |
324766 | 324766 | 2020-07-11 | Bristol city | Virginia | 51520 | 12 | 0 |
324767 | 324767 | 2020-07-11 | Brunswick | Virginia | 51025 | 127 | 1 |
324768 | 324768 | 2020-07-11 | Buchanan | Virginia | 51027 | 39 | 0 |
324769 | 324769 | 2020-07-11 | Buckingham | Virginia | 51029 | 576 | 6 |
324770 | 324770 | 2020-07-11 | Buena Vista city | Virginia | 51530 | 18 | 0 |
324771 | 324771 | 2020-07-11 | Campbell | Virginia | 51031 | 63 | 1 |
324772 | 324772 | 2020-07-11 | Caroline | Virginia | 51033 | 137 | 4 |
324773 | 324773 | 2020-07-11 | Carroll | Virginia | 51035 | 245 | 9 |
324774 | 324774 | 2020-07-11 | Charles City | Virginia | 51036 | 41 | 3 |
324775 | 324775 | 2020-07-11 | Charlotte | Virginia | 51037 | 36 | 0 |
324776 | 324776 | 2020-07-11 | Charlottesville city | Virginia | 51540 | 270 | 7 |
324777 | 324777 | 2020-07-11 | Chesapeake city | Virginia | 51550 | 1204 | 22 |
324778 | 324778 | 2020-07-11 | Chesterfield | Virginia | 51041 | 3169 | 62 |
324779 | 324779 | 2020-07-11 | Clarke | Virginia | 51043 | 60 | 0 |
324780 | 324780 | 2020-07-11 | Colonial Heights city | Virginia | 51570 | 156 | 20 |
324781 | 324781 | 2020-07-11 | Covington city | Virginia | 51580 | 5 | 0 |
324782 | 324782 | 2020-07-11 | Craig | Virginia | 51045 | 9 | 0 |
324783 | 324783 | 2020-07-11 | Culpeper | Virginia | 51047 | 852 | 12 |
324784 | 324784 | 2020-07-11 | Cumberland | Virginia | 51049 | 59 | 0 |
324785 | 324785 | 2020-07-11 | Danville city | Virginia | 51590 | 113 | 2 |
324786 | 324786 | 2020-07-11 | Dickenson | Virginia | 51051 | 5 | 0 |
324787 | 324787 | 2020-07-11 | Dinwiddie | Virginia | 51053 | 154 | 2 |
324788 | 324788 | 2020-07-11 | Emporia city | Virginia | 51595 | 146 | 15 |
324789 | 324789 | 2020-07-11 | Essex | Virginia | 51057 | 63 | 0 |
324790 | 324790 | 2020-07-11 | Fairfax | Virginia | 51059 | 14403 | 498 |
324791 | 324791 | 2020-07-11 | Fairfax city | Virginia | 51600 | 72 | 7 |
324792 | 324792 | 2020-07-11 | Falls Church city | Virginia | 51610 | 53 | 7 |
324793 | 324793 | 2020-07-11 | Fauquier | Virginia | 51061 | 476 | 8 |
324794 | 324794 | 2020-07-11 | Floyd | Virginia | 51063 | 20 | 1 |
324795 | 324795 | 2020-07-11 | Fluvanna | Virginia | 51065 | 130 | 8 |
324796 | 324796 | 2020-07-11 | Franklin | Virginia | 51067 | 106 | 1 |
324797 | 324797 | 2020-07-11 | Franklin city | Virginia | 51620 | 70 | 3 |
324798 | 324798 | 2020-07-11 | Frederick | Virginia | 51069 | 543 | 6 |
324799 | 324799 | 2020-07-11 | Fredericksburg city | Virginia | 51630 | 277 | 0 |
324800 | 324800 | 2020-07-11 | Galax city | Virginia | 51640 | 287 | 16 |
324801 | 324801 | 2020-07-11 | Giles | Virginia | 51071 | 18 | 0 |
324802 | 324802 | 2020-07-11 | Gloucester | Virginia | 51073 | 67 | 1 |
324803 | 324803 | 2020-07-11 | Goochland | Virginia | 51075 | 129 | 6 |
324804 | 324804 | 2020-07-11 | Grayson | Virginia | 51077 | 91 | 4 |
324805 | 324805 | 2020-07-11 | Greene | Virginia | 51079 | 80 | 2 |
324806 | 324806 | 2020-07-11 | Greensville | Virginia | 51081 | 375 | 9 |
324807 | 324807 | 2020-07-11 | Halifax | Virginia | 51083 | 80 | 1 |
324808 | 324808 | 2020-07-11 | Hampton city | Virginia | 51650 | 469 | 4 |
324809 | 324809 | 2020-07-11 | Hanover | Virginia | 51085 | 469 | 31 |
324810 | 324810 | 2020-07-11 | Harrisonburg city | Virginia | 51660 | 978 | 28 |
324811 | 324811 | 2020-07-11 | Henrico | Virginia | 51087 | 2822 | 173 |
324812 | 324812 | 2020-07-11 | Henry | Virginia | 51089 | 350 | 5 |
324813 | 324813 | 2020-07-11 | Highland | Virginia | 51091 | 3 | 0 |
324814 | 324814 | 2020-07-11 | Hopewell city | Virginia | 51670 | 198 | 5 |
324815 | 324815 | 2020-07-11 | Isle of Wight | Virginia | 51093 | 222 | 9 |
324816 | 324816 | 2020-07-11 | James City | Virginia | 51095 | 336 | 16 |
324817 | 324817 | 2020-07-11 | King George | Virginia | 51099 | 105 | 4 |
324818 | 324818 | 2020-07-11 | King William | Virginia | 51101 | 54 | 2 |
324819 | 324819 | 2020-07-11 | King and Queen | Virginia | 51097 | 26 | 1 |
324820 | 324820 | 2020-07-11 | Lancaster | Virginia | 51103 | 13 | 0 |
324821 | 324821 | 2020-07-11 | Lee | Virginia | 51105 | 17 | 0 |
324822 | 324822 | 2020-07-11 | Lexington city | Virginia | 51678 | 16 | 0 |
324823 | 324823 | 2020-07-11 | Loudoun | Virginia | 51107 | 4373 | 99 |
324824 | 324824 | 2020-07-11 | Louisa | Virginia | 51109 | 135 | 2 |
324825 | 324825 | 2020-07-11 | Lunenburg | Virginia | 51111 | 40 | 0 |
324826 | 324826 | 2020-07-11 | Lynchburg city | Virginia | 51680 | 187 | 1 |
324827 | 324827 | 2020-07-11 | Madison | Virginia | 51113 | 47 | 1 |
324828 | 324828 | 2020-07-11 | Manassas Park city | Virginia | 51685 | 457 | 6 |
324829 | 324829 | 2020-07-11 | Manassas city | Virginia | 51683 | 1482 | 19 |
324830 | 324830 | 2020-07-11 | Martinsville city | Virginia | 51690 | 112 | 1 |
324831 | 324831 | 2020-07-11 | Mathews | Virginia | 51115 | 7 | 0 |
324832 | 324832 | 2020-07-11 | Mecklenburg | Virginia | 51117 | 257 | 29 |
324833 | 324833 | 2020-07-11 | Middlesex | Virginia | 51119 | 17 | 0 |
324834 | 324834 | 2020-07-11 | Montgomery | Virginia | 51121 | 182 | 3 |
324835 | 324835 | 2020-07-11 | Nelson | Virginia | 51125 | 25 | 0 |
324836 | 324836 | 2020-07-11 | New Kent | Virginia | 51127 | 68 | 1 |
324837 | 324837 | 2020-07-11 | Newport News city | Virginia | 51700 | 693 | 10 |
324838 | 324838 | 2020-07-11 | Norfolk city | Virginia | 51710 | 1448 | 15 |
324839 | 324839 | 2020-07-11 | Northampton | Virginia | 51131 | 274 | 28 |
324840 | 324840 | 2020-07-11 | Northumberland | Virginia | 51133 | 40 | 1 |
324841 | 324841 | 2020-07-11 | Norton city | Virginia | 51720 | 4 | 0 |
324842 | 324842 | 2020-07-11 | Nottoway | Virginia | 51135 | 120 | 5 |
324843 | 324843 | 2020-07-11 | Orange | Virginia | 51137 | 159 | 3 |
324844 | 324844 | 2020-07-11 | Page | Virginia | 51139 | 298 | 23 |
324845 | 324845 | 2020-07-11 | Patrick | Virginia | 51141 | 48 | 1 |
324846 | 324846 | 2020-07-11 | Petersburg city | Virginia | 51730 | 331 | 8 |
324847 | 324847 | 2020-07-11 | Pittsylvania | Virginia | 51143 | 159 | 2 |
324848 | 324848 | 2020-07-11 | Poquoson city | Virginia | 51735 | 20 | 0 |
324849 | 324849 | 2020-07-11 | Portsmouth city | Virginia | 51740 | 662 | 19 |
324850 | 324850 | 2020-07-11 | Powhatan | Virginia | 51145 | 91 | 2 |
324851 | 324851 | 2020-07-11 | Prince Edward | Virginia | 51147 | 237 | 6 |
324852 | 324852 | 2020-07-11 | Prince George | Virginia | 51149 | 258 | 2 |
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);