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-09-08 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 133
- 51001 1
- 51003 1
- 51005 1
- 51007 1
- 51009 1
- 51011 1
- 51013 1
- 51015 1
- 51017 1
- 51019 1
- 51021 1
- 51023 1
- 51025 1
- 51027 1
- 51029 1
- 51031 1
- 51033 1
- 51035 1
- 51036 1
- 51037 1
- 51041 1
- 51043 1
- 51045 1
- 51047 1
- 51049 1
- 51051 1
- 51053 1
- 51057 1
- 51059 1
- 51061 1
- 51063 1
- 51065 1
- 51067 1
- 51069 1
- 51071 1
- 51073 1
- 51075 1
- 51077 1
- 51079 1
- 51081 1
- 51083 1
- 51085 1
- 51087 1
- 51089 1
- 51091 1
- 51093 1
- 51095 1
- 51097 1
- 51099 1
- 51101 1
- 51103 1
- 51105 1
- 51107 1
- 51109 1
- 51111 1
- 51113 1
- 51115 1
- 51117 1
- 51119 1
- 51121 1
- 51125 1
- 51127 1
- 51131 1
- 51133 1
- 51135 1
- 51137 1
- 51139 1
- 51141 1
- 51143 1
- 51145 1
- 51147 1
- 51149 1
- 51153 1
- 51155 1
- 51157 1
- 51159 1
- 51161 1
- 51163 1
- 51165 1
- 51167 1
- 51169 1
- 51171 1
- 51173 1
- 51175 1
- 51177 1
- 51179 1
- 51181 1
- 51183 1
- 51185 1
- 51187 1
- 51191 1
- 51193 1
- 51195 1
- 51197 1
- 51199 1
- 51510 1
- 51520 1
- 51530 1
- 51540 1
- 51550 1
- 51570 1
- 51580 1
- 51590 1
- 51595 1
- 51600 1
- 51610 1
- 51620 1
- 51630 1
- 51640 1
- 51650 1
- 51660 1
- 51670 1
- 51678 1
- 51680 1
- 51683 1
- 51685 1
- 51690 1
- 51700 1
- 51710 1
- 51720 1
- 51730 1
- 51735 1
- 51740 1
- 51750 1
- 51760 1
- 51770 1
- 51775 1
- 51790 1
- 51800 1
- 51810 1
- 51820 1
- 51830 1
- 51840 1
county 133
- 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
- Culpeper 1
- Cumberland 1
- Danville city 1
- Dickenson 1
- Dinwiddie 1
- Emporia city 1
- Essex 1
- Fairfax 1
- Fairfax city 1
- Falls Church city 1
- Fauquier 1
- Floyd 1
- Fluvanna 1
- Franklin 1
- Franklin city 1
- Frederick 1
- Fredericksburg city 1
- Galax city 1
- Giles 1
- Gloucester 1
- Goochland 1
- Grayson 1
- Greene 1
- Greensville 1
- Halifax 1
- Hampton city 1
- Hanover 1
- Harrisonburg city 1
- Henrico 1
- Henry 1
- Highland 1
- Hopewell city 1
- Isle of Wight 1
- James City 1
- King George 1
- King William 1
- King and Queen 1
- Lancaster 1
- Lee 1
- Lexington city 1
- Loudoun 1
- Louisa 1
- Lunenburg 1
- Lynchburg city 1
- Madison 1
- Manassas Park city 1
- Manassas city 1
- Martinsville city 1
- Mathews 1
- Mecklenburg 1
- Middlesex 1
- Montgomery 1
- Nelson 1
- New Kent 1
- Newport News city 1
- Norfolk city 1
- Northampton 1
- Northumberland 1
- Norton city 1
- Nottoway 1
- Orange 1
- Page 1
- Patrick 1
- Petersburg city 1
- Pittsylvania 1
- Poquoson city 1
- Portsmouth city 1
- Powhatan 1
- Prince Edward 1
- Prince George 1
- Prince William 1
- Pulaski 1
- Radford city 1
- Rappahannock 1
- Richmond 1
- Richmond city 1
- Roanoke 1
- Roanoke city 1
- Rockbridge 1
- Rockingham 1
- Russell 1
- Salem city 1
- Scott 1
- Shenandoah 1
- Smyth 1
- Southampton 1
- Spotsylvania 1
- Stafford 1
- Staunton city 1
- Suffolk city 1
- Surry 1
- Sussex 1
- Tazewell 1
- Virginia Beach city 1
- Warren 1
- Washington 1
- Waynesboro city 1
- Westmoreland 1
- Williamsburg city 1
- Winchester city 1
- Wise 1
- Wythe 1
- York 1
state 1
- Virginia · 133 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
514684 | 514684 | 2020-09-08 | Accomack | Virginia | 51001 | 1154 | 19 |
514685 | 514685 | 2020-09-08 | Albemarle | Virginia | 51003 | 1096 | 19 |
514686 | 514686 | 2020-09-08 | Alexandria city | Virginia | 51510 | 3527 | 62 |
514687 | 514687 | 2020-09-08 | Alleghany | Virginia | 51005 | 71 | 4 |
514688 | 514688 | 2020-09-08 | Amelia | Virginia | 51007 | 110 | 3 |
514689 | 514689 | 2020-09-08 | Amherst | Virginia | 51009 | 325 | 1 |
514690 | 514690 | 2020-09-08 | Appomattox | Virginia | 51011 | 183 | 1 |
514691 | 514691 | 2020-09-08 | Arlington | Virginia | 51013 | 3656 | 143 |
514692 | 514692 | 2020-09-08 | Augusta | Virginia | 51015 | 387 | 4 |
514693 | 514693 | 2020-09-08 | Bath | Virginia | 51017 | 4 | 0 |
514694 | 514694 | 2020-09-08 | Bedford | Virginia | 51019 | 616 | 9 |
514695 | 514695 | 2020-09-08 | Bland | Virginia | 51021 | 62 | 1 |
514696 | 514696 | 2020-09-08 | Botetourt | Virginia | 51023 | 266 | 10 |
514697 | 514697 | 2020-09-08 | Bristol city | Virginia | 51520 | 146 | 2 |
514698 | 514698 | 2020-09-08 | Brunswick | Virginia | 51025 | 317 | 2 |
514699 | 514699 | 2020-09-08 | Buchanan | Virginia | 51027 | 100 | 2 |
514700 | 514700 | 2020-09-08 | Buckingham | Virginia | 51029 | 656 | 8 |
514701 | 514701 | 2020-09-08 | Buena Vista city | Virginia | 51530 | 76 | 1 |
514702 | 514702 | 2020-09-08 | Campbell | Virginia | 51031 | 355 | 3 |
514703 | 514703 | 2020-09-08 | Caroline | Virginia | 51033 | 285 | 5 |
514704 | 514704 | 2020-09-08 | Carroll | Virginia | 51035 | 446 | 19 |
514705 | 514705 | 2020-09-08 | Charles City | Virginia | 51036 | 70 | 5 |
514706 | 514706 | 2020-09-08 | Charlotte | Virginia | 51037 | 86 | 0 |
514707 | 514707 | 2020-09-08 | Charlottesville city | Virginia | 51540 | 797 | 23 |
514708 | 514708 | 2020-09-08 | Chesapeake city | Virginia | 51550 | 3962 | 50 |
514709 | 514709 | 2020-09-08 | Chesterfield | Virginia | 51041 | 5307 | 83 |
514710 | 514710 | 2020-09-08 | Clarke | Virginia | 51043 | 86 | 0 |
514711 | 514711 | 2020-09-08 | Colonial Heights city | Virginia | 51570 | 232 | 23 |
514712 | 514712 | 2020-09-08 | Covington city | Virginia | 51580 | 29 | 0 |
514713 | 514713 | 2020-09-08 | Craig | Virginia | 51045 | 23 | 0 |
514714 | 514714 | 2020-09-08 | Culpeper | Virginia | 51047 | 1141 | 14 |
514715 | 514715 | 2020-09-08 | Cumberland | Virginia | 51049 | 102 | 0 |
514716 | 514716 | 2020-09-08 | Danville city | Virginia | 51590 | 688 | 17 |
514717 | 514717 | 2020-09-08 | Dickenson | Virginia | 51051 | 71 | 1 |
514718 | 514718 | 2020-09-08 | Dinwiddie | Virginia | 51053 | 322 | 8 |
514719 | 514719 | 2020-09-08 | Emporia city | Virginia | 51595 | 241 | 19 |
514720 | 514720 | 2020-09-08 | Essex | Virginia | 51057 | 147 | 2 |
514721 | 514721 | 2020-09-08 | Fairfax | Virginia | 51059 | 19135 | 563 |
514722 | 514722 | 2020-09-08 | Fairfax city | Virginia | 51600 | 125 | 7 |
514723 | 514723 | 2020-09-08 | Falls Church city | Virginia | 51610 | 66 | 7 |
514724 | 514724 | 2020-09-08 | Fauquier | Virginia | 51061 | 814 | 18 |
514725 | 514725 | 2020-09-08 | Floyd | Virginia | 51063 | 158 | 2 |
514726 | 514726 | 2020-09-08 | Fluvanna | Virginia | 51065 | 236 | 9 |
514727 | 514727 | 2020-09-08 | Franklin | Virginia | 51067 | 251 | 1 |
514728 | 514728 | 2020-09-08 | Franklin city | Virginia | 51620 | 340 | 7 |
514729 | 514729 | 2020-09-08 | Frederick | Virginia | 51069 | 793 | 11 |
514730 | 514730 | 2020-09-08 | Fredericksburg city | Virginia | 51630 | 497 | 4 |
514731 | 514731 | 2020-09-08 | Galax city | Virginia | 51640 | 403 | 28 |
514732 | 514732 | 2020-09-08 | Giles | Virginia | 51071 | 61 | 0 |
514733 | 514733 | 2020-09-08 | Gloucester | Virginia | 51073 | 210 | 2 |
514734 | 514734 | 2020-09-08 | Goochland | Virginia | 51075 | 229 | 7 |
514735 | 514735 | 2020-09-08 | Grayson | Virginia | 51077 | 265 | 8 |
514736 | 514736 | 2020-09-08 | Greene | Virginia | 51079 | 204 | 3 |
514737 | 514737 | 2020-09-08 | Greensville | Virginia | 51081 | 724 | 11 |
514738 | 514738 | 2020-09-08 | Halifax | Virginia | 51083 | 243 | 4 |
514739 | 514739 | 2020-09-08 | Hampton city | Virginia | 51650 | 1651 | 16 |
514740 | 514740 | 2020-09-08 | Hanover | Virginia | 51085 | 890 | 35 |
514741 | 514741 | 2020-09-08 | Harrisonburg city | Virginia | 51660 | 1936 | 33 |
514742 | 514742 | 2020-09-08 | Henrico | Virginia | 51087 | 4844 | 194 |
514743 | 514743 | 2020-09-08 | Henry | Virginia | 51089 | 915 | 16 |
514744 | 514744 | 2020-09-08 | Highland | Virginia | 51091 | 6 | 0 |
514745 | 514745 | 2020-09-08 | Hopewell city | Virginia | 51670 | 359 | 5 |
514746 | 514746 | 2020-09-08 | Isle of Wight | Virginia | 51093 | 617 | 11 |
514747 | 514747 | 2020-09-08 | James City | Virginia | 51095 | 774 | 18 |
514748 | 514748 | 2020-09-08 | King George | Virginia | 51099 | 212 | 4 |
514749 | 514749 | 2020-09-08 | King William | Virginia | 51101 | 125 | 2 |
514750 | 514750 | 2020-09-08 | King and Queen | Virginia | 51097 | 59 | 1 |
514751 | 514751 | 2020-09-08 | Lancaster | Virginia | 51103 | 83 | 0 |
514752 | 514752 | 2020-09-08 | Lee | Virginia | 51105 | 232 | 4 |
514753 | 514753 | 2020-09-08 | Lexington city | Virginia | 51678 | 44 | 1 |
514754 | 514754 | 2020-09-08 | Loudoun | Virginia | 51107 | 6263 | 118 |
514755 | 514755 | 2020-09-08 | Louisa | Virginia | 51109 | 265 | 3 |
514756 | 514756 | 2020-09-08 | Lunenburg | Virginia | 51111 | 100 | 2 |
514757 | 514757 | 2020-09-08 | Lynchburg city | Virginia | 51680 | 1092 | 5 |
514758 | 514758 | 2020-09-08 | Madison | Virginia | 51113 | 95 | 2 |
514759 | 514759 | 2020-09-08 | Manassas Park city | Virginia | 51685 | 582 | 7 |
514760 | 514760 | 2020-09-08 | Manassas city | Virginia | 51683 | 1836 | 24 |
514761 | 514761 | 2020-09-08 | Martinsville city | Virginia | 51690 | 346 | 6 |
514762 | 514762 | 2020-09-08 | Mathews | Virginia | 51115 | 23 | 0 |
514763 | 514763 | 2020-09-08 | Mecklenburg | Virginia | 51117 | 601 | 33 |
514764 | 514764 | 2020-09-08 | Middlesex | Virginia | 51119 | 62 | 1 |
514765 | 514765 | 2020-09-08 | Montgomery | Virginia | 51121 | 1015 | 4 |
514766 | 514766 | 2020-09-08 | Nelson | Virginia | 51125 | 90 | 0 |
514767 | 514767 | 2020-09-08 | New Kent | Virginia | 51127 | 160 | 1 |
514768 | 514768 | 2020-09-08 | Newport News city | Virginia | 51700 | 2499 | 28 |
514769 | 514769 | 2020-09-08 | Norfolk city | Virginia | 51710 | 4537 | 60 |
514770 | 514770 | 2020-09-08 | Northampton | Virginia | 51131 | 304 | 29 |
514771 | 514771 | 2020-09-08 | Northumberland | Virginia | 51133 | 101 | 5 |
514772 | 514772 | 2020-09-08 | Norton city | Virginia | 51720 | 31 | 0 |
514773 | 514773 | 2020-09-08 | Nottoway | Virginia | 51135 | 208 | 15 |
514774 | 514774 | 2020-09-08 | Orange | Virginia | 51137 | 273 | 4 |
514775 | 514775 | 2020-09-08 | Page | Virginia | 51139 | 366 | 27 |
514776 | 514776 | 2020-09-08 | Patrick | Virginia | 51141 | 245 | 13 |
514777 | 514777 | 2020-09-08 | Petersburg city | Virginia | 51730 | 665 | 23 |
514778 | 514778 | 2020-09-08 | Pittsylvania | Virginia | 51143 | 867 | 6 |
514779 | 514779 | 2020-09-08 | Poquoson city | Virginia | 51735 | 74 | 1 |
514780 | 514780 | 2020-09-08 | Portsmouth city | Virginia | 51740 | 2309 | 43 |
514781 | 514781 | 2020-09-08 | Powhatan | Virginia | 51145 | 196 | 4 |
514782 | 514782 | 2020-09-08 | Prince Edward | Virginia | 51147 | 516 | 12 |
514783 | 514783 | 2020-09-08 | Prince George | Virginia | 51149 | 626 | 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);