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-08-01 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 |
---|---|---|---|---|---|---|---|
392050 | 392050 | 2020-08-01 | Accomack | Virginia | 51001 | 1077 | 15 |
392051 | 392051 | 2020-08-01 | Albemarle | Virginia | 51003 | 741 | 12 |
392052 | 392052 | 2020-08-01 | Alexandria city | Virginia | 51510 | 2811 | 59 |
392053 | 392053 | 2020-08-01 | Alleghany | Virginia | 51005 | 56 | 3 |
392054 | 392054 | 2020-08-01 | Amelia | Virginia | 51007 | 73 | 1 |
392055 | 392055 | 2020-08-01 | Amherst | Virginia | 51009 | 108 | 0 |
392056 | 392056 | 2020-08-01 | Appomattox | Virginia | 51011 | 68 | 0 |
392057 | 392057 | 2020-08-01 | Arlington | Virginia | 51013 | 2906 | 136 |
392058 | 392058 | 2020-08-01 | Augusta | Virginia | 51015 | 251 | 4 |
392059 | 392059 | 2020-08-01 | Bath | Virginia | 51017 | 4 | 0 |
392060 | 392060 | 2020-08-01 | Bedford | Virginia | 51019 | 293 | 6 |
392061 | 392061 | 2020-08-01 | Bland | Virginia | 51021 | 7 | 0 |
392062 | 392062 | 2020-08-01 | Botetourt | Virginia | 51023 | 185 | 7 |
392063 | 392063 | 2020-08-01 | Bristol city | Virginia | 51520 | 59 | 0 |
392064 | 392064 | 2020-08-01 | Brunswick | Virginia | 51025 | 204 | 1 |
392065 | 392065 | 2020-08-01 | Buchanan | Virginia | 51027 | 71 | 0 |
392066 | 392066 | 2020-08-01 | Buckingham | Virginia | 51029 | 594 | 6 |
392067 | 392067 | 2020-08-01 | Buena Vista city | Virginia | 51530 | 47 | 0 |
392068 | 392068 | 2020-08-01 | Campbell | Virginia | 51031 | 149 | 2 |
392069 | 392069 | 2020-08-01 | Caroline | Virginia | 51033 | 190 | 4 |
392070 | 392070 | 2020-08-01 | Carroll | Virginia | 51035 | 308 | 14 |
392071 | 392071 | 2020-08-01 | Charles City | Virginia | 51036 | 50 | 5 |
392072 | 392072 | 2020-08-01 | Charlotte | Virginia | 51037 | 49 | 0 |
392073 | 392073 | 2020-08-01 | Charlottesville city | Virginia | 51540 | 471 | 13 |
392074 | 392074 | 2020-08-01 | Chesapeake city | Virginia | 51550 | 2462 | 29 |
392075 | 392075 | 2020-08-01 | Chesterfield | Virginia | 51041 | 3968 | 75 |
392076 | 392076 | 2020-08-01 | Clarke | Virginia | 51043 | 69 | 0 |
392077 | 392077 | 2020-08-01 | Colonial Heights city | Virginia | 51570 | 181 | 21 |
392078 | 392078 | 2020-08-01 | Covington city | Virginia | 51580 | 12 | 0 |
392079 | 392079 | 2020-08-01 | Craig | Virginia | 51045 | 16 | 0 |
392080 | 392080 | 2020-08-01 | Culpeper | Virginia | 51047 | 946 | 12 |
392081 | 392081 | 2020-08-01 | Cumberland | Virginia | 51049 | 65 | 0 |
392082 | 392082 | 2020-08-01 | Danville city | Virginia | 51590 | 314 | 7 |
392083 | 392083 | 2020-08-01 | Dickenson | Virginia | 51051 | 23 | 0 |
392084 | 392084 | 2020-08-01 | Dinwiddie | Virginia | 51053 | 198 | 6 |
392085 | 392085 | 2020-08-01 | Emporia city | Virginia | 51595 | 165 | 15 |
392086 | 392086 | 2020-08-01 | Essex | Virginia | 51057 | 76 | 1 |
392087 | 392087 | 2020-08-01 | Fairfax | Virginia | 51059 | 15689 | 522 |
392088 | 392088 | 2020-08-01 | Fairfax city | Virginia | 51600 | 80 | 7 |
392089 | 392089 | 2020-08-01 | Falls Church city | Virginia | 51610 | 59 | 6 |
392090 | 392090 | 2020-08-01 | Fauquier | Virginia | 51061 | 572 | 8 |
392091 | 392091 | 2020-08-01 | Floyd | Virginia | 51063 | 33 | 1 |
392092 | 392092 | 2020-08-01 | Fluvanna | Virginia | 51065 | 173 | 8 |
392093 | 392093 | 2020-08-01 | Franklin | Virginia | 51067 | 156 | 1 |
392094 | 392094 | 2020-08-01 | Franklin city | Virginia | 51620 | 120 | 6 |
392095 | 392095 | 2020-08-01 | Frederick | Virginia | 51069 | 661 | 9 |
392096 | 392096 | 2020-08-01 | Fredericksburg city | Virginia | 51630 | 356 | 2 |
392097 | 392097 | 2020-08-01 | Galax city | Virginia | 51640 | 331 | 21 |
392098 | 392098 | 2020-08-01 | Giles | Virginia | 51071 | 23 | 0 |
392099 | 392099 | 2020-08-01 | Gloucester | Virginia | 51073 | 143 | 2 |
392100 | 392100 | 2020-08-01 | Goochland | Virginia | 51075 | 151 | 7 |
392101 | 392101 | 2020-08-01 | Grayson | Virginia | 51077 | 129 | 4 |
392102 | 392102 | 2020-08-01 | Greene | Virginia | 51079 | 137 | 2 |
392103 | 392103 | 2020-08-01 | Greensville | Virginia | 51081 | 420 | 9 |
392104 | 392104 | 2020-08-01 | Halifax | Virginia | 51083 | 135 | 1 |
392105 | 392105 | 2020-08-01 | Hampton city | Virginia | 51650 | 1009 | 5 |
392106 | 392106 | 2020-08-01 | Hanover | Virginia | 51085 | 588 | 31 |
392107 | 392107 | 2020-08-01 | Harrisonburg city | Virginia | 51660 | 1045 | 29 |
392108 | 392108 | 2020-08-01 | Henrico | Virginia | 51087 | 3601 | 182 |
392109 | 392109 | 2020-08-01 | Henry | Virginia | 51089 | 502 | 6 |
392110 | 392110 | 2020-08-01 | Highland | Virginia | 51091 | 3 | 0 |
392111 | 392111 | 2020-08-01 | Hopewell city | Virginia | 51670 | 253 | 5 |
392112 | 392112 | 2020-08-01 | Isle of Wight | Virginia | 51093 | 331 | 9 |
392113 | 392113 | 2020-08-01 | James City | Virginia | 51095 | 541 | 16 |
392114 | 392114 | 2020-08-01 | King George | Virginia | 51099 | 124 | 4 |
392115 | 392115 | 2020-08-01 | King William | Virginia | 51101 | 77 | 2 |
392116 | 392116 | 2020-08-01 | King and Queen | Virginia | 51097 | 35 | 1 |
392117 | 392117 | 2020-08-01 | Lancaster | Virginia | 51103 | 31 | 0 |
392118 | 392118 | 2020-08-01 | Lee | Virginia | 51105 | 95 | 1 |
392119 | 392119 | 2020-08-01 | Lexington city | Virginia | 51678 | 29 | 0 |
392120 | 392120 | 2020-08-01 | Loudoun | Virginia | 51107 | 5014 | 112 |
392121 | 392121 | 2020-08-01 | Louisa | Virginia | 51109 | 166 | 2 |
392122 | 392122 | 2020-08-01 | Lunenburg | Virginia | 51111 | 55 | 1 |
392123 | 392123 | 2020-08-01 | Lynchburg city | Virginia | 51680 | 440 | 2 |
392124 | 392124 | 2020-08-01 | Madison | Virginia | 51113 | 61 | 1 |
392125 | 392125 | 2020-08-01 | Manassas Park city | Virginia | 51685 | 498 | 7 |
392126 | 392126 | 2020-08-01 | Manassas city | Virginia | 51683 | 1607 | 20 |
392127 | 392127 | 2020-08-01 | Martinsville city | Virginia | 51690 | 168 | 3 |
392128 | 392128 | 2020-08-01 | Mathews | Virginia | 51115 | 13 | 0 |
392129 | 392129 | 2020-08-01 | Mecklenburg | Virginia | 51117 | 305 | 32 |
392130 | 392130 | 2020-08-01 | Middlesex | Virginia | 51119 | 27 | 1 |
392131 | 392131 | 2020-08-01 | Montgomery | Virginia | 51121 | 275 | 3 |
392132 | 392132 | 2020-08-01 | Nelson | Virginia | 51125 | 32 | 0 |
392133 | 392133 | 2020-08-01 | New Kent | Virginia | 51127 | 116 | 1 |
392134 | 392134 | 2020-08-01 | Newport News city | Virginia | 51700 | 1589 | 16 |
392135 | 392135 | 2020-08-01 | Norfolk city | Virginia | 51710 | 3185 | 26 |
392136 | 392136 | 2020-08-01 | Northampton | Virginia | 51131 | 292 | 28 |
392137 | 392137 | 2020-08-01 | Northumberland | Virginia | 51133 | 65 | 2 |
392138 | 392138 | 2020-08-01 | Norton city | Virginia | 51720 | 13 | 0 |
392139 | 392139 | 2020-08-01 | Nottoway | Virginia | 51135 | 174 | 9 |
392140 | 392140 | 2020-08-01 | Orange | Virginia | 51137 | 210 | 3 |
392141 | 392141 | 2020-08-01 | Page | Virginia | 51139 | 331 | 24 |
392142 | 392142 | 2020-08-01 | Patrick | Virginia | 51141 | 111 | 3 |
392143 | 392143 | 2020-08-01 | Petersburg city | Virginia | 51730 | 454 | 13 |
392144 | 392144 | 2020-08-01 | Pittsylvania | Virginia | 51143 | 329 | 2 |
392145 | 392145 | 2020-08-01 | Poquoson city | Virginia | 51735 | 36 | 0 |
392146 | 392146 | 2020-08-01 | Portsmouth city | Virginia | 51740 | 1492 | 24 |
392147 | 392147 | 2020-08-01 | Powhatan | Virginia | 51145 | 122 | 4 |
392148 | 392148 | 2020-08-01 | Prince Edward | Virginia | 51147 | 341 | 10 |
392149 | 392149 | 2020-08-01 | Prince George | Virginia | 51149 | 332 | 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);