ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
130 rows where date = "2020-06-13" 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
- 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
- Cumberland 1
- …
state 1
- Virginia · 130 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
236711 | 236711 | 2020-06-13 | Accomack | Virginia | 51001 | 989 | 14 |
236712 | 236712 | 2020-06-13 | Albemarle | Virginia | 51003 | 275 | 8 |
236713 | 236713 | 2020-06-13 | Alexandria city | Virginia | 51510 | 2134 | 48 |
236714 | 236714 | 2020-06-13 | Alleghany | Virginia | 51005 | 28 | 2 |
236715 | 236715 | 2020-06-13 | Amelia | Virginia | 51007 | 38 | 1 |
236716 | 236716 | 2020-06-13 | Amherst | Virginia | 51009 | 27 | 0 |
236717 | 236717 | 2020-06-13 | Appomattox | Virginia | 51011 | 34 | 0 |
236718 | 236718 | 2020-06-13 | Arlington | Virginia | 51013 | 2321 | 125 |
236719 | 236719 | 2020-06-13 | Augusta | Virginia | 51015 | 143 | 2 |
236720 | 236720 | 2020-06-13 | Bedford | Virginia | 51019 | 91 | 2 |
236721 | 236721 | 2020-06-13 | Botetourt | Virginia | 51023 | 47 | 4 |
236722 | 236722 | 2020-06-13 | Bristol city | Virginia | 51520 | 4 | 0 |
236723 | 236723 | 2020-06-13 | Brunswick | Virginia | 51025 | 46 | 1 |
236724 | 236724 | 2020-06-13 | Buchanan | Virginia | 51027 | 18 | 0 |
236725 | 236725 | 2020-06-13 | Buckingham | Virginia | 51029 | 519 | 3 |
236726 | 236726 | 2020-06-13 | Buena Vista city | Virginia | 51530 | 12 | 0 |
236727 | 236727 | 2020-06-13 | Campbell | Virginia | 51031 | 23 | 1 |
236728 | 236728 | 2020-06-13 | Caroline | Virginia | 51033 | 106 | 4 |
236729 | 236729 | 2020-06-13 | Carroll | Virginia | 51035 | 165 | 5 |
236730 | 236730 | 2020-06-13 | Charles City | Virginia | 51036 | 29 | 2 |
236731 | 236731 | 2020-06-13 | Charlotte | Virginia | 51037 | 30 | 0 |
236732 | 236732 | 2020-06-13 | Charlottesville city | Virginia | 51540 | 148 | 3 |
236733 | 236733 | 2020-06-13 | Chesapeake city | Virginia | 51550 | 650 | 16 |
236734 | 236734 | 2020-06-13 | Chesterfield | Virginia | 51041 | 2150 | 39 |
236735 | 236735 | 2020-06-13 | Clarke | Virginia | 51043 | 37 | 0 |
236736 | 236736 | 2020-06-13 | Colonial Heights city | Virginia | 51570 | 115 | 17 |
236737 | 236737 | 2020-06-13 | Covington city | Virginia | 51580 | 4 | 0 |
236738 | 236738 | 2020-06-13 | Craig | Virginia | 51045 | 6 | 0 |
236739 | 236739 | 2020-06-13 | Culpeper | Virginia | 51047 | 777 | 9 |
236740 | 236740 | 2020-06-13 | Cumberland | Virginia | 51049 | 47 | 0 |
236741 | 236741 | 2020-06-13 | Danville city | Virginia | 51590 | 63 | 2 |
236742 | 236742 | 2020-06-13 | Dinwiddie | Virginia | 51053 | 107 | 0 |
236743 | 236743 | 2020-06-13 | Emporia city | Virginia | 51595 | 95 | 6 |
236744 | 236744 | 2020-06-13 | Essex | Virginia | 51057 | 52 | 0 |
236745 | 236745 | 2020-06-13 | Fairfax | Virginia | 51059 | 12939 | 423 |
236746 | 236746 | 2020-06-13 | Fairfax city | Virginia | 51600 | 67 | 6 |
236747 | 236747 | 2020-06-13 | Falls Church city | Virginia | 51610 | 56 | 7 |
236748 | 236748 | 2020-06-13 | Fauquier | Virginia | 51061 | 380 | 6 |
236749 | 236749 | 2020-06-13 | Floyd | Virginia | 51063 | 9 | 1 |
236750 | 236750 | 2020-06-13 | Fluvanna | Virginia | 51065 | 101 | 6 |
236751 | 236751 | 2020-06-13 | Franklin | Virginia | 51067 | 43 | 1 |
236752 | 236752 | 2020-06-13 | Franklin city | Virginia | 51620 | 44 | 2 |
236753 | 236753 | 2020-06-13 | Frederick | Virginia | 51069 | 428 | 4 |
236754 | 236754 | 2020-06-13 | Fredericksburg city | Virginia | 51630 | 201 | 0 |
236755 | 236755 | 2020-06-13 | Galax city | Virginia | 51640 | 193 | 8 |
236756 | 236756 | 2020-06-13 | Giles | Virginia | 51071 | 5 | 0 |
236757 | 236757 | 2020-06-13 | Gloucester | Virginia | 51073 | 36 | 1 |
236758 | 236758 | 2020-06-13 | Goochland | Virginia | 51075 | 114 | 6 |
236759 | 236759 | 2020-06-13 | Grayson | Virginia | 51077 | 66 | 2 |
236760 | 236760 | 2020-06-13 | Greene | Virginia | 51079 | 45 | 1 |
236761 | 236761 | 2020-06-13 | Greensville | Virginia | 51081 | 336 | 7 |
236762 | 236762 | 2020-06-13 | Halifax | Virginia | 51083 | 35 | 1 |
236763 | 236763 | 2020-06-13 | Hampton city | Virginia | 51650 | 234 | 5 |
236764 | 236764 | 2020-06-13 | Hanover | Virginia | 51085 | 368 | 25 |
236765 | 236765 | 2020-06-13 | Harrisonburg city | Virginia | 51660 | 847 | 23 |
236766 | 236766 | 2020-06-13 | Henrico | Virginia | 51087 | 2234 | 136 |
236767 | 236767 | 2020-06-13 | Henry | Virginia | 51089 | 198 | 3 |
236768 | 236768 | 2020-06-13 | Highland | Virginia | 51091 | 2 | 0 |
236769 | 236769 | 2020-06-13 | Hopewell city | Virginia | 51670 | 138 | 2 |
236770 | 236770 | 2020-06-13 | Isle of Wight | Virginia | 51093 | 154 | 8 |
236771 | 236771 | 2020-06-13 | James City | Virginia | 51095 | 231 | 15 |
236772 | 236772 | 2020-06-13 | King George | Virginia | 51099 | 87 | 4 |
236773 | 236773 | 2020-06-13 | King William | Virginia | 51101 | 33 | 0 |
236774 | 236774 | 2020-06-13 | King and Queen | Virginia | 51097 | 24 | 1 |
236775 | 236775 | 2020-06-13 | Lancaster | Virginia | 51103 | 11 | 0 |
236776 | 236776 | 2020-06-13 | Lee | Virginia | 51105 | 9 | 0 |
236777 | 236777 | 2020-06-13 | Lexington city | Virginia | 51678 | 8 | 0 |
236778 | 236778 | 2020-06-13 | Loudoun | Virginia | 51107 | 3321 | 71 |
236779 | 236779 | 2020-06-13 | Louisa | Virginia | 51109 | 98 | 1 |
236780 | 236780 | 2020-06-13 | Lunenburg | Virginia | 51111 | 20 | 0 |
236781 | 236781 | 2020-06-13 | Lynchburg city | Virginia | 51680 | 92 | 1 |
236782 | 236782 | 2020-06-13 | Madison | Virginia | 51113 | 42 | 1 |
236783 | 236783 | 2020-06-13 | Manassas Park city | Virginia | 51685 | 372 | 6 |
236784 | 236784 | 2020-06-13 | Manassas city | Virginia | 51683 | 1299 | 12 |
236785 | 236785 | 2020-06-13 | Martinsville city | Virginia | 51690 | 54 | 1 |
236786 | 236786 | 2020-06-13 | Mathews | Virginia | 51115 | 5 | 0 |
236787 | 236787 | 2020-06-13 | Mecklenburg | Virginia | 51117 | 226 | 24 |
236788 | 236788 | 2020-06-13 | Middlesex | Virginia | 51119 | 14 | 0 |
236789 | 236789 | 2020-06-13 | Montgomery | Virginia | 51121 | 96 | 2 |
236790 | 236790 | 2020-06-13 | Nelson | Virginia | 51125 | 18 | 0 |
236791 | 236791 | 2020-06-13 | New Kent | Virginia | 51127 | 45 | 1 |
236792 | 236792 | 2020-06-13 | Newport News city | Virginia | 51700 | 357 | 10 |
236793 | 236793 | 2020-06-13 | Norfolk city | Virginia | 51710 | 643 | 7 |
236794 | 236794 | 2020-06-13 | Northampton | Virginia | 51131 | 261 | 27 |
236795 | 236795 | 2020-06-13 | Northumberland | Virginia | 51133 | 26 | 1 |
236796 | 236796 | 2020-06-13 | Norton city | Virginia | 51720 | 2 | 0 |
236797 | 236797 | 2020-06-13 | Nottoway | Virginia | 51135 | 65 | 0 |
236798 | 236798 | 2020-06-13 | Orange | Virginia | 51137 | 124 | 2 |
236799 | 236799 | 2020-06-13 | Page | Virginia | 51139 | 251 | 24 |
236800 | 236800 | 2020-06-13 | Patrick | Virginia | 51141 | 31 | 0 |
236801 | 236801 | 2020-06-13 | Petersburg city | Virginia | 51730 | 180 | 3 |
236802 | 236802 | 2020-06-13 | Pittsylvania | Virginia | 51143 | 60 | 1 |
236803 | 236803 | 2020-06-13 | Poquoson city | Virginia | 51735 | 11 | 0 |
236804 | 236804 | 2020-06-13 | Portsmouth city | Virginia | 51740 | 375 | 12 |
236805 | 236805 | 2020-06-13 | Powhatan | Virginia | 51145 | 51 | 0 |
236806 | 236806 | 2020-06-13 | Prince Edward | Virginia | 51147 | 161 | 3 |
236807 | 236807 | 2020-06-13 | Prince George | Virginia | 51149 | 162 | 0 |
236808 | 236808 | 2020-06-13 | Prince William | Virginia | 51153 | 6509 | 120 |
236809 | 236809 | 2020-06-13 | Pulaski | Virginia | 51155 | 30 | 1 |
236810 | 236810 | 2020-06-13 | Radford city | Virginia | 51750 | 8 | 0 |
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);