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 797
- 51810 796
- 51107 794
- 51013 793
- 51153 793
- 51085 792
- 51095 792
- 51147 792
- 51510 792
- 51177 791
- 51660 791
- 51041 790
- 51179 789
- 51199 789
- 51830 788
- 51075 787
- 51087 787
- 51540 787
- 51760 787
- 51036 786
- 51001 784
- 51073 784
- 51700 784
- 51710 784
- 51740 784
- 51800 784
- 51003 783
- 51023 783
- 51067 783
- 51093 783
- …
county >30
- Fairfax 797
- Virginia Beach city 796
- Loudoun 794
- Arlington 793
- Prince William 793
- Alexandria city 792
- Hanover 792
- James City 792
- Prince Edward 792
- Harrisonburg city 791
- Spotsylvania 791
- Chesterfield 790
- Stafford 789
- York 789
- Williamsburg city 788
- Charlottesville city 787
- Goochland 787
- Henrico 787
- Richmond city 787
- Charles City 786
- Accomack 784
- Gloucester 784
- Newport News city 784
- Norfolk city 784
- Portsmouth city 784
- Suffolk city 784
- Albemarle 783
- Botetourt 783
- Franklin 783
- Isle of Wight 783
- …
state 1
- Virginia · 103,028 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502610 | 2502610 | 2022-05-13 | Prince William | Virginia | 51153 | 97967 | 748 |
2502611 | 2502611 | 2022-05-13 | Pulaski | Virginia | 51155 | 7343 | 138 |
2502612 | 2502612 | 2022-05-13 | Radford city | Virginia | 51750 | 5018 | 53 |
2502613 | 2502613 | 2022-05-13 | Rappahannock | Virginia | 51157 | 1051 | 10 |
2502614 | 2502614 | 2022-05-13 | Richmond | Virginia | 51159 | 2601 | 25 |
2502615 | 2502615 | 2022-05-13 | Richmond city | Virginia | 51760 | 46245 | 515 |
2502616 | 2502616 | 2022-05-13 | Roanoke | Virginia | 51161 | 21633 | 282 |
2502617 | 2502617 | 2022-05-13 | Roanoke city | Virginia | 51770 | 21671 | 376 |
2502618 | 2502618 | 2022-05-13 | Rockbridge | Virginia | 51163 | 3300 | 79 |
2502619 | 2502619 | 2022-05-13 | Rockingham | Virginia | 51165 | 14648 | 228 |
2502620 | 2502620 | 2022-05-13 | Russell | Virginia | 51167 | 6877 | 114 |
2502621 | 2502621 | 2022-05-13 | Salem city | Virginia | 51775 | 5745 | 97 |
2502622 | 2502622 | 2022-05-13 | Scott | Virginia | 51169 | 5845 | 111 |
2502623 | 2502623 | 2022-05-13 | Shenandoah | Virginia | 51171 | 10936 | 222 |
2502624 | 2502624 | 2022-05-13 | Smyth | Virginia | 51173 | 8896 | 171 |
2502625 | 2502625 | 2022-05-13 | Southampton | Virginia | 51175 | 3446 | 93 |
2502626 | 2502626 | 2022-05-13 | Spotsylvania | Virginia | 51177 | 27655 | 301 |
2502627 | 2502627 | 2022-05-13 | Stafford | Virginia | 51179 | 31265 | 177 |
2502628 | 2502628 | 2022-05-13 | Staunton city | Virginia | 51790 | 5737 | 115 |
2502629 | 2502629 | 2022-05-13 | Suffolk city | Virginia | 51800 | 19133 | 302 |
2502630 | 2502630 | 2022-05-13 | Surry | Virginia | 51181 | 1110 | 20 |
2502631 | 2502631 | 2022-05-13 | Sussex | Virginia | 51183 | 2419 | 42 |
2502632 | 2502632 | 2022-05-13 | Tazewell | Virginia | 51185 | 10329 | 175 |
2502633 | 2502633 | 2022-05-13 | Virginia Beach city | Virginia | 51810 | 91483 | 824 |
2502634 | 2502634 | 2022-05-13 | Warren | Virginia | 51187 | 8675 | 157 |
2502635 | 2502635 | 2022-05-13 | Washington | Virginia | 51191 | 13910 | 215 |
2502636 | 2502636 | 2022-05-13 | Waynesboro city | Virginia | 51820 | 6033 | 69 |
2502637 | 2502637 | 2022-05-13 | Westmoreland | Virginia | 51193 | 3284 | 52 |
2502638 | 2502638 | 2022-05-13 | Williamsburg city | Virginia | 51830 | 1837 | 22 |
2502639 | 2502639 | 2022-05-13 | Winchester city | Virginia | 51840 | 6440 | 80 |
2502640 | 2502640 | 2022-05-13 | Wise | Virginia | 51195 | 10306 | 199 |
2502641 | 2502641 | 2022-05-13 | Wythe | Virginia | 51197 | 7557 | 149 |
2502642 | 2502642 | 2022-05-13 | York | Virginia | 51199 | 10189 | 109 |
2499252 | 2499252 | 2022-05-12 | Accomack | Virginia | 51001 | 7046 | 106 |
2499253 | 2499253 | 2022-05-12 | Albemarle | Virginia | 51003 | 18592 | 163 |
2499254 | 2499254 | 2022-05-12 | Alexandria city | Virginia | 51510 | 32528 | 188 |
2499255 | 2499255 | 2022-05-12 | Alleghany | Virginia | 51005 | 3367 | 98 |
2499256 | 2499256 | 2022-05-12 | Amelia | Virginia | 51007 | 2680 | 60 |
2499257 | 2499257 | 2022-05-12 | Amherst | Virginia | 51009 | 7309 | 89 |
2499258 | 2499258 | 2022-05-12 | Appomattox | Virginia | 51011 | 3815 | 53 |
2499259 | 2499259 | 2022-05-12 | Arlington | Virginia | 51013 | 45960 | 322 |
2499260 | 2499260 | 2022-05-12 | Augusta | Virginia | 51015 | 18893 | 206 |
2499261 | 2499261 | 2022-05-12 | Bath | Virginia | 51017 | 905 | 20 |
2499262 | 2499262 | 2022-05-12 | Bedford | Virginia | 51019 | 17256 | 240 |
2499263 | 2499263 | 2022-05-12 | Bland | Virginia | 51021 | 1798 | 24 |
2499264 | 2499264 | 2022-05-12 | Botetourt | Virginia | 51023 | 7598 | 101 |
2499265 | 2499265 | 2022-05-12 | Bristol city | Virginia | 51520 | 4453 | 80 |
2499266 | 2499266 | 2022-05-12 | Brunswick | Virginia | 51025 | 3283 | 47 |
2499267 | 2499267 | 2022-05-12 | Buchanan | Virginia | 51027 | 4902 | 122 |
2499268 | 2499268 | 2022-05-12 | Buckingham | Virginia | 51029 | 3991 | 56 |
2499269 | 2499269 | 2022-05-12 | Buena Vista city | Virginia | 51530 | 2015 | 44 |
2499270 | 2499270 | 2022-05-12 | Campbell | Virginia | 51031 | 12806 | 215 |
2499271 | 2499271 | 2022-05-12 | Caroline | Virginia | 51033 | 6970 | 85 |
2499272 | 2499272 | 2022-05-12 | Carroll | Virginia | 51035 | 6745 | 148 |
2499273 | 2499273 | 2022-05-12 | Charles City | Virginia | 51036 | 1189 | 27 |
2499274 | 2499274 | 2022-05-12 | Charlotte | Virginia | 51037 | 2533 | 45 |
2499275 | 2499275 | 2022-05-12 | Charlottesville city | Virginia | 51540 | 9428 | 74 |
2499276 | 2499276 | 2022-05-12 | Chesapeake city | Virginia | 51550 | 50960 | 497 |
2499277 | 2499277 | 2022-05-12 | Chesterfield | Virginia | 51041 | 75368 | 760 |
2499278 | 2499278 | 2022-05-12 | Clarke | Virginia | 51043 | 2676 | 42 |
2499279 | 2499279 | 2022-05-12 | Colonial Heights city | Virginia | 51570 | 4956 | 97 |
2499280 | 2499280 | 2022-05-12 | Covington city | Virginia | 51580 | 1300 | 26 |
2499281 | 2499281 | 2022-05-12 | Craig | Virginia | 51045 | 1128 | 18 |
2499282 | 2499282 | 2022-05-12 | Culpeper | Virginia | 51047 | 11486 | 149 |
2499283 | 2499283 | 2022-05-12 | Cumberland | Virginia | 51049 | 1364 | 27 |
2499284 | 2499284 | 2022-05-12 | Danville city | Virginia | 51590 | 11207 | 282 |
2499285 | 2499285 | 2022-05-12 | Dickenson | Virginia | 51051 | 3321 | 49 |
2499286 | 2499286 | 2022-05-12 | Dinwiddie | Virginia | 51053 | 5431 | 93 |
2499287 | 2499287 | 2022-05-12 | Emporia city | Virginia | 51595 | 1187 | 55 |
2499288 | 2499288 | 2022-05-12 | Essex | Virginia | 51057 | 2279 | 33 |
2499289 | 2499289 | 2022-05-12 | Fairfax | Virginia | 51059 | 187548 | 1452 |
2499290 | 2499290 | 2022-05-12 | Fairfax city | Virginia | 51600 | 2055 | 43 |
2499291 | 2499291 | 2022-05-12 | Falls Church city | Virginia | 51610 | 2205 | 17 |
2499292 | 2499292 | 2022-05-12 | Fauquier | Virginia | 51061 | 13247 | 144 |
2499293 | 2499293 | 2022-05-12 | Floyd | Virginia | 51063 | 2583 | 49 |
2499294 | 2499294 | 2022-05-12 | Fluvanna | Virginia | 51065 | 5243 | 46 |
2499295 | 2499295 | 2022-05-12 | Franklin | Virginia | 51067 | 10945 | 198 |
2499296 | 2499296 | 2022-05-12 | Franklin city | Virginia | 51620 | 2396 | 52 |
2499297 | 2499297 | 2022-05-12 | Frederick | Virginia | 51069 | 20874 | 248 |
2499298 | 2499298 | 2022-05-12 | Fredericksburg city | Virginia | 51630 | 5482 | 42 |
2499299 | 2499299 | 2022-05-12 | Galax city | Virginia | 51640 | 2559 | 78 |
2499300 | 2499300 | 2022-05-12 | Giles | Virginia | 51071 | 4104 | 50 |
2499301 | 2499301 | 2022-05-12 | Gloucester | Virginia | 51073 | 7446 | 104 |
2499302 | 2499302 | 2022-05-12 | Goochland | Virginia | 51075 | 4140 | 53 |
2499303 | 2499303 | 2022-05-12 | Grayson | Virginia | 51077 | 4057 | 83 |
2499304 | 2499304 | 2022-05-12 | Greene | Virginia | 51079 | 4063 | 62 |
2499305 | 2499305 | 2022-05-12 | Greensville | Virginia | 51081 | 3341 | 40 |
2499306 | 2499306 | 2022-05-12 | Halifax | Virginia | 51083 | 7193 | 159 |
2499307 | 2499307 | 2022-05-12 | Hampton city | Virginia | 51650 | 28488 | 330 |
2499308 | 2499308 | 2022-05-12 | Hanover | Virginia | 51085 | 22343 | 286 |
2499309 | 2499309 | 2022-05-12 | Harrisonburg city | Virginia | 51660 | 13470 | 160 |
2499310 | 2499310 | 2022-05-12 | Henrico | Virginia | 51087 | 67333 | 934 |
2499311 | 2499311 | 2022-05-12 | Henry | Virginia | 51089 | 12189 | 266 |
2499312 | 2499312 | 2022-05-12 | Highland | Virginia | 51091 | 387 | 7 |
2499313 | 2499313 | 2022-05-12 | Hopewell city | Virginia | 51670 | 6140 | 118 |
2499314 | 2499314 | 2022-05-12 | Isle of Wight | Virginia | 51093 | 7388 | 119 |
2499315 | 2499315 | 2022-05-12 | James City | Virginia | 51095 | 15414 | 120 |
2499316 | 2499316 | 2022-05-12 | King George | Virginia | 51099 | 5105 | 39 |
2499317 | 2499317 | 2022-05-12 | King William | Virginia | 51101 | 3765 | 44 |
2499318 | 2499318 | 2022-05-12 | King and Queen | Virginia | 51097 | 1144 | 12 |
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);