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 2022-03-02 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 |
---|---|---|---|---|---|---|---|
2268176 | 2268176 | 2022-03-02 | Accomack | Virginia | 51001 | 6900 | 103 |
2268177 | 2268177 | 2022-03-02 | Albemarle | Virginia | 51003 | 15604 | 144 |
2268178 | 2268178 | 2022-03-02 | Alexandria city | Virginia | 51510 | 29603 | 183 |
2268179 | 2268179 | 2022-03-02 | Alleghany | Virginia | 51005 | 3550 | 93 |
2268180 | 2268180 | 2022-03-02 | Amelia | Virginia | 51007 | 2572 | 57 |
2268181 | 2268181 | 2022-03-02 | Amherst | Virginia | 51009 | 6952 | 83 |
2268182 | 2268182 | 2022-03-02 | Appomattox | Virginia | 51011 | 3659 | 50 |
2268183 | 2268183 | 2022-03-02 | Arlington | Virginia | 51013 | 40215 | 318 |
2268184 | 2268184 | 2022-03-02 | Augusta | Virginia | 51015 | 18741 | 199 |
2268185 | 2268185 | 2022-03-02 | Bath | Virginia | 51017 | 876 | 19 |
2268186 | 2268186 | 2022-03-02 | Bedford | Virginia | 51019 | 16457 | 217 |
2268187 | 2268187 | 2022-03-02 | Bland | Virginia | 51021 | 1744 | 20 |
2268188 | 2268188 | 2022-03-02 | Botetourt | Virginia | 51023 | 7242 | 93 |
2268189 | 2268189 | 2022-03-02 | Bristol city | Virginia | 51520 | 4350 | 71 |
2268190 | 2268190 | 2022-03-02 | Brunswick | Virginia | 51025 | 3033 | 42 |
2268191 | 2268191 | 2022-03-02 | Buchanan | Virginia | 51027 | 4719 | 102 |
2268192 | 2268192 | 2022-03-02 | Buckingham | Virginia | 51029 | 3778 | 52 |
2268193 | 2268193 | 2022-03-02 | Buena Vista city | Virginia | 51530 | 1982 | 39 |
2268194 | 2268194 | 2022-03-02 | Campbell | Virginia | 51031 | 11303 | 192 |
2268195 | 2268195 | 2022-03-02 | Caroline | Virginia | 51033 | 6818 | 77 |
2268196 | 2268196 | 2022-03-02 | Carroll | Virginia | 51035 | 6546 | 135 |
2268197 | 2268197 | 2022-03-02 | Charles City | Virginia | 51036 | 1141 | 27 |
2268198 | 2268198 | 2022-03-02 | Charlotte | Virginia | 51037 | 2359 | 43 |
2268199 | 2268199 | 2022-03-02 | Charlottesville city | Virginia | 51540 | 9981 | 70 |
2268200 | 2268200 | 2022-03-02 | Chesapeake city | Virginia | 51550 | 49348 | 462 |
2268201 | 2268201 | 2022-03-02 | Chesterfield | Virginia | 51041 | 70674 | 724 |
2268202 | 2268202 | 2022-03-02 | Clarke | Virginia | 51043 | 2592 | 40 |
2268203 | 2268203 | 2022-03-02 | Colonial Heights city | Virginia | 51570 | 4770 | 90 |
2268204 | 2268204 | 2022-03-02 | Covington city | Virginia | 51580 | 994 | 23 |
2268205 | 2268205 | 2022-03-02 | Craig | Virginia | 51045 | 1107 | 15 |
2268206 | 2268206 | 2022-03-02 | Culpeper | Virginia | 51047 | 11561 | 141 |
2268207 | 2268207 | 2022-03-02 | Cumberland | Virginia | 51049 | 1212 | 23 |
2268208 | 2268208 | 2022-03-02 | Danville city | Virginia | 51590 | 10834 | 255 |
2268209 | 2268209 | 2022-03-02 | Dickenson | Virginia | 51051 | 3278 | 45 |
2268210 | 2268210 | 2022-03-02 | Dinwiddie | Virginia | 51053 | 5188 | 81 |
2268211 | 2268211 | 2022-03-02 | Emporia city | Virginia | 51595 | 1126 | 53 |
2268212 | 2268212 | 2022-03-02 | Essex | Virginia | 51057 | 2238 | 31 |
2268213 | 2268213 | 2022-03-02 | Fairfax | Virginia | 51059 | 172919 | 1378 |
2268214 | 2268214 | 2022-03-02 | Fairfax city | Virginia | 51600 | 1951 | 43 |
2268215 | 2268215 | 2022-03-02 | Falls Church city | Virginia | 51610 | 1919 | 16 |
2268216 | 2268216 | 2022-03-02 | Fauquier | Virginia | 51061 | 12778 | 138 |
2268217 | 2268217 | 2022-03-02 | Floyd | Virginia | 51063 | 2509 | 44 |
2268218 | 2268218 | 2022-03-02 | Fluvanna | Virginia | 51065 | 4896 | 41 |
2268219 | 2268219 | 2022-03-02 | Franklin | Virginia | 51067 | 10618 | 181 |
2268220 | 2268220 | 2022-03-02 | Franklin city | Virginia | 51620 | 2457 | 48 |
2268221 | 2268221 | 2022-03-02 | Frederick | Virginia | 51069 | 20319 | 229 |
2268222 | 2268222 | 2022-03-02 | Fredericksburg city | Virginia | 51630 | 5344 | 34 |
2268223 | 2268223 | 2022-03-02 | Galax city | Virginia | 51640 | 2537 | 75 |
2268224 | 2268224 | 2022-03-02 | Giles | Virginia | 51071 | 3995 | 44 |
2268225 | 2268225 | 2022-03-02 | Gloucester | Virginia | 51073 | 7227 | 100 |
2268226 | 2268226 | 2022-03-02 | Goochland | Virginia | 51075 | 3859 | 43 |
2268227 | 2268227 | 2022-03-02 | Grayson | Virginia | 51077 | 3964 | 77 |
2268228 | 2268228 | 2022-03-02 | Greene | Virginia | 51079 | 3950 | 59 |
2268229 | 2268229 | 2022-03-02 | Greensville | Virginia | 51081 | 3292 | 37 |
2268230 | 2268230 | 2022-03-02 | Halifax | Virginia | 51083 | 6901 | 148 |
2268231 | 2268231 | 2022-03-02 | Hampton city | Virginia | 51650 | 27331 | 307 |
2268232 | 2268232 | 2022-03-02 | Hanover | Virginia | 51085 | 21366 | 259 |
2268233 | 2268233 | 2022-03-02 | Harrisonburg city | Virginia | 51660 | 13160 | 150 |
2268234 | 2268234 | 2022-03-02 | Henrico | Virginia | 51087 | 63308 | 863 |
2268235 | 2268235 | 2022-03-02 | Henry | Virginia | 51089 | 11244 | 241 |
2268236 | 2268236 | 2022-03-02 | Highland | Virginia | 51091 | 357 | 7 |
2268237 | 2268237 | 2022-03-02 | Hopewell city | Virginia | 51670 | 6103 | 118 |
2268238 | 2268238 | 2022-03-02 | Isle of Wight | Virginia | 51093 | 7230 | 106 |
2268239 | 2268239 | 2022-03-02 | James City | Virginia | 51095 | 14666 | 111 |
2268240 | 2268240 | 2022-03-02 | King George | Virginia | 51099 | 4960 | 36 |
2268241 | 2268241 | 2022-03-02 | King William | Virginia | 51101 | 3657 | 34 |
2268242 | 2268242 | 2022-03-02 | King and Queen | Virginia | 51097 | 1111 | 11 |
2268243 | 2268243 | 2022-03-02 | Lancaster | Virginia | 51103 | 1770 | 29 |
2268244 | 2268244 | 2022-03-02 | Lee | Virginia | 51105 | 6168 | 86 |
2268245 | 2268245 | 2022-03-02 | Lexington city | Virginia | 51678 | 2809 | 39 |
2268246 | 2268246 | 2022-03-02 | Loudoun | Virginia | 51107 | 65650 | 363 |
2268247 | 2268247 | 2022-03-02 | Louisa | Virginia | 51109 | 6422 | 73 |
2268248 | 2268248 | 2022-03-02 | Lunenburg | Virginia | 51111 | 2286 | 30 |
2268249 | 2268249 | 2022-03-02 | Lynchburg city | Virginia | 51680 | 19741 | 261 |
2268250 | 2268250 | 2022-03-02 | Madison | Virginia | 51113 | 2055 | 36 |
2268251 | 2268251 | 2022-03-02 | Manassas Park city | Virginia | 51685 | 3676 | 25 |
2268252 | 2268252 | 2022-03-02 | Manassas city | Virginia | 51683 | 9014 | 69 |
2268253 | 2268253 | 2022-03-02 | Martinsville city | Virginia | 51690 | 3172 | 111 |
2268254 | 2268254 | 2022-03-02 | Mathews | Virginia | 51115 | 1409 | 28 |
2268255 | 2268255 | 2022-03-02 | Mecklenburg | Virginia | 51117 | 5939 | 107 |
2268256 | 2268256 | 2022-03-02 | Middlesex | Virginia | 51119 | 1790 | 46 |
2268257 | 2268257 | 2022-03-02 | Montgomery | Virginia | 51121 | 18281 | 140 |
2268258 | 2268258 | 2022-03-02 | Nelson | Virginia | 51125 | 2674 | 32 |
2268259 | 2268259 | 2022-03-02 | New Kent | Virginia | 51127 | 4560 | 32 |
2268260 | 2268260 | 2022-03-02 | Newport News city | Virginia | 51700 | 35861 | 378 |
2268261 | 2268261 | 2022-03-02 | Norfolk city | Virginia | 51710 | 41213 | 455 |
2268262 | 2268262 | 2022-03-02 | Northampton | Virginia | 51131 | 2128 | 61 |
2268263 | 2268263 | 2022-03-02 | Northumberland | Virginia | 51133 | 2144 | 43 |
2268264 | 2268264 | 2022-03-02 | Norton city | Virginia | 51720 | 1288 | 22 |
2268265 | 2268265 | 2022-03-02 | Nottoway | Virginia | 51135 | 3956 | 83 |
2268266 | 2268266 | 2022-03-02 | Orange | Virginia | 51137 | 6852 | 85 |
2268267 | 2268267 | 2022-03-02 | Page | Virginia | 51139 | 5517 | 116 |
2268268 | 2268268 | 2022-03-02 | Patrick | Virginia | 51141 | 3528 | 86 |
2268269 | 2268269 | 2022-03-02 | Petersburg city | Virginia | 51730 | 8278 | 134 |
2268270 | 2268270 | 2022-03-02 | Pittsylvania | Virginia | 51143 | 13369 | 177 |
2268271 | 2268271 | 2022-03-02 | Poquoson city | Virginia | 51735 | 2313 | 28 |
2268272 | 2268272 | 2022-03-02 | Portsmouth city | Virginia | 51740 | 20608 | 307 |
2268273 | 2268273 | 2022-03-02 | Powhatan | Virginia | 51145 | 4818 | 52 |
2268274 | 2268274 | 2022-03-02 | Prince Edward | Virginia | 51147 | 4634 | 63 |
2268275 | 2268275 | 2022-03-02 | Prince George | Virginia | 51149 | 8083 | 62 |
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);