ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103,128 rows where state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 51059 421
- 51810 420
- 51107 418
- 51013 417
- 51153 417
- 51085 416
- 51095 416
- 51147 416
- 51510 416
- 51177 415
- 51660 415
- 51041 414
- 51179 413
- 51199 413
- 51830 412
- 51075 411
- 51087 411
- 51540 411
- 51760 411
- 51036 410
- 51001 408
- 51073 408
- 51700 408
- 51710 408
- 51740 408
- 51800 408
- 51003 407
- 51023 407
- 51067 407
- 51093 407
- …
county >30
- Fairfax 421
- Virginia Beach city 420
- Loudoun 418
- Arlington 417
- Prince William 417
- Alexandria city 416
- Hanover 416
- James City 416
- Prince Edward 416
- Harrisonburg city 415
- Spotsylvania 415
- Chesterfield 414
- Stafford 413
- York 413
- Williamsburg city 412
- Charlottesville city 411
- Goochland 411
- Henrico 411
- Richmond city 411
- Charles City 410
- Accomack 408
- Gloucester 408
- Newport News city 408
- Norfolk city 408
- Portsmouth city 408
- Suffolk city 408
- Albemarle 407
- Botetourt 407
- Franklin 407
- Isle of Wight 407
- …
state 1
- Virginia · 53,012 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280569 | 1280569 | 2021-05-02 | Prince William | Virginia | 51153 | 44663 | 482 |
1280570 | 1280570 | 2021-05-02 | Pulaski | Virginia | 51155 | 2612 | 61 |
1280571 | 1280571 | 2021-05-02 | Radford city | Virginia | 51750 | 2112 | 18 |
1280572 | 1280572 | 2021-05-02 | Rappahannock | Virginia | 51157 | 347 | 2 |
1280573 | 1280573 | 2021-05-02 | Richmond | Virginia | 51159 | 1492 | 15 |
1280574 | 1280574 | 2021-05-02 | Richmond city | Virginia | 51760 | 16823 | 257 |
1280575 | 1280575 | 2021-05-02 | Roanoke | Virginia | 51161 | 8139 | 138 |
1280576 | 1280576 | 2021-05-02 | Roanoke city | Virginia | 51770 | 8377 | 190 |
1280577 | 1280577 | 2021-05-02 | Rockbridge | Virginia | 51163 | 1513 | 46 |
1280578 | 1280578 | 2021-05-02 | Rockingham | Virginia | 51165 | 6689 | 105 |
1280579 | 1280579 | 2021-05-02 | Russell | Virginia | 51167 | 2244 | 38 |
1280580 | 1280580 | 2021-05-02 | Salem city | Virginia | 51775 | 2134 | 47 |
1280581 | 1280581 | 2021-05-02 | Scott | Virginia | 51169 | 1809 | 52 |
1280582 | 1280582 | 2021-05-02 | Shenandoah | Virginia | 51171 | 4260 | 130 |
1280583 | 1280583 | 2021-05-02 | Smyth | Virginia | 51173 | 2890 | 91 |
1280584 | 1280584 | 2021-05-02 | Southampton | Virginia | 51175 | 1970 | 56 |
1280585 | 1280585 | 2021-05-02 | Spotsylvania | Virginia | 51177 | 9733 | 115 |
1280586 | 1280586 | 2021-05-02 | Stafford | Virginia | 51179 | 11106 | 75 |
1280587 | 1280587 | 2021-05-02 | Staunton city | Virginia | 51790 | 2503 | 70 |
1280588 | 1280588 | 2021-05-02 | Suffolk city | Virginia | 51800 | 7834 | 186 |
1280589 | 1280589 | 2021-05-02 | Surry | Virginia | 51181 | 421 | 9 |
1280590 | 1280590 | 2021-05-02 | Sussex | Virginia | 51183 | 1182 | 21 |
1280591 | 1280591 | 2021-05-02 | Tazewell | Virginia | 51185 | 3592 | 67 |
1280592 | 1280592 | 2021-05-02 | Virginia Beach city | Virginia | 51810 | 35470 | 386 |
1280593 | 1280593 | 2021-05-02 | Warren | Virginia | 51187 | 2907 | 55 |
1280594 | 1280594 | 2021-05-02 | Washington | Virginia | 51191 | 4838 | 106 |
1280595 | 1280595 | 2021-05-02 | Waynesboro city | Virginia | 51820 | 2347 | 38 |
1280596 | 1280596 | 2021-05-02 | Westmoreland | Virginia | 51193 | 1265 | 24 |
1280597 | 1280597 | 2021-05-02 | Williamsburg city | Virginia | 51830 | 758 | 12 |
1280598 | 1280598 | 2021-05-02 | Winchester city | Virginia | 51840 | 2826 | 44 |
1280599 | 1280599 | 2021-05-02 | Wise | Virginia | 51195 | 3127 | 96 |
1280600 | 1280600 | 2021-05-02 | Wythe | Virginia | 51197 | 2604 | 78 |
1280601 | 1280601 | 2021-05-02 | York | Virginia | 51199 | 3697 | 52 |
1277222 | 1277222 | 2021-05-01 | Accomack | Virginia | 51001 | 2811 | 41 |
1277223 | 1277223 | 2021-05-01 | Albemarle | Virginia | 51003 | 5705 | 83 |
1277224 | 1277224 | 2021-05-01 | Alexandria city | Virginia | 51510 | 11657 | 133 |
1277225 | 1277225 | 2021-05-01 | Alleghany | Virginia | 51005 | 1326 | 48 |
1277226 | 1277226 | 2021-05-01 | Amelia | Virginia | 51007 | 879 | 31 |
1277227 | 1277227 | 2021-05-01 | Amherst | Virginia | 51009 | 2904 | 35 |
1277228 | 1277228 | 2021-05-01 | Appomattox | Virginia | 51011 | 1583 | 24 |
1277229 | 1277229 | 2021-05-01 | Arlington | Virginia | 51013 | 15111 | 252 |
1277230 | 1277230 | 2021-05-01 | Augusta | Virginia | 51015 | 5727 | 70 |
1277231 | 1277231 | 2021-05-01 | Bath | Virginia | 51017 | 270 | 10 |
1277232 | 1277232 | 2021-05-01 | Bedford | Virginia | 51019 | 6265 | 99 |
1277233 | 1277233 | 2021-05-01 | Bland | Virginia | 51021 | 669 | 10 |
1277234 | 1277234 | 2021-05-01 | Botetourt | Virginia | 51023 | 2501 | 36 |
1277235 | 1277235 | 2021-05-01 | Bristol city | Virginia | 51520 | 1464 | 33 |
1277236 | 1277236 | 2021-05-01 | Brunswick | Virginia | 51025 | 1296 | 21 |
1277237 | 1277237 | 2021-05-01 | Buchanan | Virginia | 51027 | 1409 | 38 |
1277238 | 1277238 | 2021-05-01 | Buckingham | Virginia | 51029 | 2118 | 30 |
1277239 | 1277239 | 2021-05-01 | Buena Vista city | Virginia | 51530 | 894 | 19 |
1277240 | 1277240 | 2021-05-01 | Campbell | Virginia | 51031 | 4407 | 84 |
1277241 | 1277241 | 2021-05-01 | Caroline | Virginia | 51033 | 2554 | 35 |
1277242 | 1277242 | 2021-05-01 | Carroll | Virginia | 51035 | 2597 | 69 |
1277243 | 1277243 | 2021-05-01 | Charles City | Virginia | 51036 | 498 | 15 |
1277244 | 1277244 | 2021-05-01 | Charlotte | Virginia | 51037 | 841 | 18 |
1277245 | 1277245 | 2021-05-01 | Charlottesville city | Virginia | 51540 | 4012 | 55 |
1277246 | 1277246 | 2021-05-01 | Chesapeake city | Virginia | 51550 | 20648 | 288 |
1277247 | 1277247 | 2021-05-01 | Chesterfield | Virginia | 51041 | 27248 | 421 |
1277248 | 1277248 | 2021-05-01 | Clarke | Virginia | 51043 | 967 | 19 |
1277249 | 1277249 | 2021-05-01 | Colonial Heights city | Virginia | 51570 | 1680 | 61 |
1277250 | 1277250 | 2021-05-01 | Covington city | Virginia | 51580 | 591 | 13 |
1277251 | 1277251 | 2021-05-01 | Craig | Virginia | 51045 | 309 | 5 |
1277252 | 1277252 | 2021-05-01 | Culpeper | Virginia | 51047 | 4545 | 61 |
1277253 | 1277253 | 2021-05-01 | Cumberland | Virginia | 51049 | 473 | 9 |
1277254 | 1277254 | 2021-05-01 | Danville city | Virginia | 51590 | 4348 | 134 |
1277255 | 1277255 | 2021-05-01 | Dickenson | Virginia | 51051 | 921 | 15 |
1277256 | 1277256 | 2021-05-01 | Dinwiddie | Virginia | 51053 | 2095 | 42 |
1277257 | 1277257 | 2021-05-01 | Emporia city | Virginia | 51595 | 669 | 42 |
1277258 | 1277258 | 2021-05-01 | Essex | Virginia | 51057 | 753 | 9 |
1277259 | 1277259 | 2021-05-01 | Fairfax | Virginia | 51059 | 75862 | 1073 |
1277260 | 1277260 | 2021-05-01 | Fairfax city | Virginia | 51600 | 550 | 19 |
1277261 | 1277261 | 2021-05-01 | Falls Church city | Virginia | 51610 | 423 | 9 |
1277262 | 1277262 | 2021-05-01 | Fauquier | Virginia | 51061 | 4628 | 63 |
1277263 | 1277263 | 2021-05-01 | Floyd | Virginia | 51063 | 842 | 21 |
1277264 | 1277264 | 2021-05-01 | Fluvanna | Virginia | 51065 | 1904 | 17 |
1277265 | 1277265 | 2021-05-01 | Franklin | Virginia | 51067 | 3994 | 74 |
1277266 | 1277266 | 2021-05-01 | Franklin city | Virginia | 51620 | 1131 | 32 |
1277267 | 1277267 | 2021-05-01 | Frederick | Virginia | 51069 | 7842 | 100 |
1277268 | 1277268 | 2021-05-01 | Fredericksburg city | Virginia | 51630 | 2087 | 23 |
1277269 | 1277269 | 2021-05-01 | Galax city | Virginia | 51640 | 1155 | 51 |
1277270 | 1277270 | 2021-05-01 | Giles | Virginia | 51071 | 1257 | 21 |
1277271 | 1277271 | 2021-05-01 | Gloucester | Virginia | 51073 | 2179 | 48 |
1277272 | 1277272 | 2021-05-01 | Goochland | Virginia | 51075 | 1431 | 23 |
1277273 | 1277273 | 2021-05-01 | Grayson | Virginia | 51077 | 1444 | 33 |
1277274 | 1277274 | 2021-05-01 | Greene | Virginia | 51079 | 1240 | 16 |
1277275 | 1277275 | 2021-05-01 | Greensville | Virginia | 51081 | 1568 | 24 |
1277276 | 1277276 | 2021-05-01 | Halifax | Virginia | 51083 | 2776 | 77 |
1277277 | 1277277 | 2021-05-01 | Hampton city | Virginia | 51650 | 10261 | 172 |
1277278 | 1277278 | 2021-05-01 | Hanover | Virginia | 51085 | 7993 | 154 |
1277279 | 1277279 | 2021-05-01 | Harrisonburg city | Virginia | 51660 | 6450 | 95 |
1277280 | 1277280 | 2021-05-01 | Henrico | Virginia | 51087 | 25004 | 602 |
1277281 | 1277281 | 2021-05-01 | Henry | Virginia | 51089 | 4498 | 121 |
1277282 | 1277282 | 2021-05-01 | Highland | Virginia | 51091 | 108 | 1 |
1277283 | 1277283 | 2021-05-01 | Hopewell city | Virginia | 51670 | 2556 | 70 |
1277284 | 1277284 | 2021-05-01 | Isle of Wight | Virginia | 51093 | 3111 | 66 |
1277285 | 1277285 | 2021-05-01 | James City | Virginia | 51095 | 4545 | 72 |
1277286 | 1277286 | 2021-05-01 | King George | Virginia | 51099 | 1655 | 19 |
1277287 | 1277287 | 2021-05-01 | King William | Virginia | 51101 | 1195 | 11 |
1277288 | 1277288 | 2021-05-01 | King and Queen | Virginia | 51097 | 388 | 8 |
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);