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-11-19 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 |
---|---|---|---|---|---|---|---|
748111 | 748111 | 2020-11-19 | Accomack | Virginia | 51001 | 1279 | 21 |
748112 | 748112 | 2020-11-19 | Albemarle | Virginia | 51003 | 1755 | 26 |
748113 | 748113 | 2020-11-19 | Alexandria city | Virginia | 51510 | 4797 | 77 |
748114 | 748114 | 2020-11-19 | Alleghany | Virginia | 51005 | 259 | 6 |
748115 | 748115 | 2020-11-19 | Amelia | Virginia | 51007 | 165 | 6 |
748116 | 748116 | 2020-11-19 | Amherst | Virginia | 51009 | 699 | 6 |
748117 | 748117 | 2020-11-19 | Appomattox | Virginia | 51011 | 362 | 6 |
748118 | 748118 | 2020-11-19 | Arlington | Virginia | 51013 | 5544 | 156 |
748119 | 748119 | 2020-11-19 | Augusta | Virginia | 51015 | 954 | 11 |
748120 | 748120 | 2020-11-19 | Bath | Virginia | 51017 | 46 | 0 |
748121 | 748121 | 2020-11-19 | Bedford | Virginia | 51019 | 1606 | 18 |
748122 | 748122 | 2020-11-19 | Bland | Virginia | 51021 | 111 | 5 |
748123 | 748123 | 2020-11-19 | Botetourt | Virginia | 51023 | 654 | 13 |
748124 | 748124 | 2020-11-19 | Bristol city | Virginia | 51520 | 459 | 7 |
748125 | 748125 | 2020-11-19 | Brunswick | Virginia | 51025 | 453 | 6 |
748126 | 748126 | 2020-11-19 | Buchanan | Virginia | 51027 | 351 | 5 |
748127 | 748127 | 2020-11-19 | Buckingham | Virginia | 51029 | 837 | 9 |
748128 | 748128 | 2020-11-19 | Buena Vista city | Virginia | 51530 | 204 | 1 |
748129 | 748129 | 2020-11-19 | Campbell | Virginia | 51031 | 970 | 12 |
748130 | 748130 | 2020-11-19 | Caroline | Virginia | 51033 | 527 | 6 |
748131 | 748131 | 2020-11-19 | Carroll | Virginia | 51035 | 806 | 29 |
748132 | 748132 | 2020-11-19 | Charles City | Virginia | 51036 | 125 | 5 |
748133 | 748133 | 2020-11-19 | Charlotte | Virginia | 51037 | 264 | 4 |
748134 | 748134 | 2020-11-19 | Charlottesville city | Virginia | 51540 | 1769 | 31 |
748135 | 748135 | 2020-11-19 | Chesapeake city | Virginia | 51550 | 5729 | 80 |
748136 | 748136 | 2020-11-19 | Chesterfield | Virginia | 51041 | 8363 | 124 |
748137 | 748137 | 2020-11-19 | Clarke | Virginia | 51043 | 172 | 2 |
748138 | 748138 | 2020-11-19 | Colonial Heights city | Virginia | 51570 | 366 | 26 |
748139 | 748139 | 2020-11-19 | Covington city | Virginia | 51580 | 110 | 0 |
748140 | 748140 | 2020-11-19 | Craig | Virginia | 51045 | 75 | 0 |
748141 | 748141 | 2020-11-19 | Culpeper | Virginia | 51047 | 1854 | 19 |
748142 | 748142 | 2020-11-19 | Cumberland | Virginia | 51049 | 139 | 4 |
748143 | 748143 | 2020-11-19 | Danville city | Virginia | 51590 | 1469 | 47 |
748144 | 748144 | 2020-11-19 | Dickenson | Virginia | 51051 | 229 | 1 |
748145 | 748145 | 2020-11-19 | Dinwiddie | Virginia | 51053 | 612 | 13 |
748146 | 748146 | 2020-11-19 | Emporia city | Virginia | 51595 | 307 | 28 |
748147 | 748147 | 2020-11-19 | Essex | Virginia | 51057 | 221 | 2 |
748148 | 748148 | 2020-11-19 | Fairfax | Virginia | 51059 | 27475 | 612 |
748149 | 748149 | 2020-11-19 | Fairfax city | Virginia | 51600 | 191 | 8 |
748150 | 748150 | 2020-11-19 | Falls Church city | Virginia | 51610 | 86 | 7 |
748151 | 748151 | 2020-11-19 | Fauquier | Virginia | 51061 | 1309 | 27 |
748152 | 748152 | 2020-11-19 | Floyd | Virginia | 51063 | 298 | 15 |
748153 | 748153 | 2020-11-19 | Fluvanna | Virginia | 51065 | 468 | 9 |
748154 | 748154 | 2020-11-19 | Franklin | Virginia | 51067 | 1343 | 11 |
748155 | 748155 | 2020-11-19 | Franklin city | Virginia | 51620 | 530 | 16 |
748156 | 748156 | 2020-11-19 | Frederick | Virginia | 51069 | 1704 | 17 |
748157 | 748157 | 2020-11-19 | Fredericksburg city | Virginia | 51630 | 641 | 6 |
748158 | 748158 | 2020-11-19 | Galax city | Virginia | 51640 | 513 | 30 |
748159 | 748159 | 2020-11-19 | Giles | Virginia | 51071 | 217 | 0 |
748160 | 748160 | 2020-11-19 | Gloucester | Virginia | 51073 | 391 | 3 |
748161 | 748161 | 2020-11-19 | Goochland | Virginia | 51075 | 382 | 7 |
748162 | 748162 | 2020-11-19 | Grayson | Virginia | 51077 | 473 | 21 |
748163 | 748163 | 2020-11-19 | Greene | Virginia | 51079 | 338 | 4 |
748164 | 748164 | 2020-11-19 | Greensville | Virginia | 51081 | 925 | 16 |
748165 | 748165 | 2020-11-19 | Halifax | Virginia | 51083 | 752 | 12 |
748166 | 748166 | 2020-11-19 | Hampton city | Virginia | 51650 | 2481 | 34 |
748167 | 748167 | 2020-11-19 | Hanover | Virginia | 51085 | 2090 | 48 |
748168 | 748168 | 2020-11-19 | Harrisonburg city | Virginia | 51660 | 3296 | 36 |
748169 | 748169 | 2020-11-19 | Henrico | Virginia | 51087 | 7509 | 242 |
748170 | 748170 | 2020-11-19 | Henry | Virginia | 51089 | 1652 | 39 |
748171 | 748171 | 2020-11-19 | Highland | Virginia | 51091 | 14 | 0 |
748172 | 748172 | 2020-11-19 | Hopewell city | Virginia | 51670 | 567 | 9 |
748173 | 748173 | 2020-11-19 | Isle of Wight | Virginia | 51093 | 950 | 27 |
748174 | 748174 | 2020-11-19 | James City | Virginia | 51095 | 1082 | 22 |
748175 | 748175 | 2020-11-19 | King George | Virginia | 51099 | 350 | 5 |
748176 | 748176 | 2020-11-19 | King William | Virginia | 51101 | 263 | 5 |
748177 | 748177 | 2020-11-19 | King and Queen | Virginia | 51097 | 99 | 2 |
748178 | 748178 | 2020-11-19 | Lancaster | Virginia | 51103 | 223 | 1 |
748179 | 748179 | 2020-11-19 | Lee | Virginia | 51105 | 777 | 11 |
748180 | 748180 | 2020-11-19 | Lexington city | Virginia | 51678 | 312 | 2 |
748181 | 748181 | 2020-11-19 | Loudoun | Virginia | 51107 | 9046 | 138 |
748182 | 748182 | 2020-11-19 | Louisa | Virginia | 51109 | 457 | 8 |
748183 | 748183 | 2020-11-19 | Lunenburg | Virginia | 51111 | 161 | 5 |
748184 | 748184 | 2020-11-19 | Lynchburg city | Virginia | 51680 | 2395 | 27 |
748185 | 748185 | 2020-11-19 | Madison | Virginia | 51113 | 171 | 4 |
748186 | 748186 | 2020-11-19 | Manassas Park city | Virginia | 51685 | 688 | 8 |
748187 | 748187 | 2020-11-19 | Manassas city | Virginia | 51683 | 2180 | 28 |
748188 | 748188 | 2020-11-19 | Martinsville city | Virginia | 51690 | 595 | 24 |
748189 | 748189 | 2020-11-19 | Mathews | Virginia | 51115 | 151 | 1 |
748190 | 748190 | 2020-11-19 | Mecklenburg | Virginia | 51117 | 958 | 35 |
748191 | 748191 | 2020-11-19 | Middlesex | Virginia | 51119 | 152 | 11 |
748192 | 748192 | 2020-11-19 | Montgomery | Virginia | 51121 | 3547 | 12 |
748193 | 748193 | 2020-11-19 | Nelson | Virginia | 51125 | 155 | 2 |
748194 | 748194 | 2020-11-19 | New Kent | Virginia | 51127 | 343 | 4 |
748195 | 748195 | 2020-11-19 | Newport News city | Virginia | 51700 | 3654 | 53 |
748196 | 748196 | 2020-11-19 | Norfolk city | Virginia | 51710 | 6116 | 88 |
748197 | 748197 | 2020-11-19 | Northampton | Virginia | 51131 | 334 | 31 |
748198 | 748198 | 2020-11-19 | Northumberland | Virginia | 51133 | 245 | 8 |
748199 | 748199 | 2020-11-19 | Norton city | Virginia | 51720 | 65 | 0 |
748200 | 748200 | 2020-11-19 | Nottoway | Virginia | 51135 | 474 | 21 |
748201 | 748201 | 2020-11-19 | Orange | Virginia | 51137 | 502 | 7 |
748202 | 748202 | 2020-11-19 | Page | Virginia | 51139 | 544 | 31 |
748203 | 748203 | 2020-11-19 | Patrick | Virginia | 51141 | 412 | 27 |
748204 | 748204 | 2020-11-19 | Petersburg city | Virginia | 51730 | 1029 | 31 |
748205 | 748205 | 2020-11-19 | Pittsylvania | Virginia | 51143 | 1554 | 21 |
748206 | 748206 | 2020-11-19 | Poquoson city | Virginia | 51735 | 121 | 2 |
748207 | 748207 | 2020-11-19 | Portsmouth city | Virginia | 51740 | 3039 | 70 |
748208 | 748208 | 2020-11-19 | Powhatan | Virginia | 51145 | 385 | 6 |
748209 | 748209 | 2020-11-19 | Prince Edward | Virginia | 51147 | 836 | 14 |
748210 | 748210 | 2020-11-19 | Prince George | Virginia | 51149 | 1328 | 7 |
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);