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 556
- 51810 555
- 51107 553
- 51013 552
- 51153 552
- 51085 551
- 51095 551
- 51147 551
- 51510 551
- 51177 550
- 51660 550
- 51041 549
- 51179 548
- 51199 548
- 51830 547
- 51075 546
- 51087 546
- 51540 546
- 51760 546
- 51036 545
- 51001 543
- 51073 543
- 51700 543
- 51710 543
- 51740 543
- 51800 543
- 51003 542
- 51023 542
- 51067 542
- 51093 542
- …
county >30
- Fairfax 556
- Virginia Beach city 555
- Loudoun 553
- Arlington 552
- Prince William 552
- Alexandria city 551
- Hanover 551
- James City 551
- Prince Edward 551
- Harrisonburg city 550
- Spotsylvania 550
- Chesterfield 549
- Stafford 548
- York 548
- Williamsburg city 547
- Charlottesville city 546
- Goochland 546
- Henrico 546
- Richmond city 546
- Charles City 545
- Accomack 543
- Gloucester 543
- Newport News city 543
- Norfolk city 543
- Portsmouth city 543
- Suffolk city 543
- Albemarle 542
- Botetourt 542
- Franklin 542
- Isle of Wight 542
- …
state 1
- Virginia · 70,968 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1718919 | 1718919 | 2021-09-14 | Prince William | Virginia | 51153 | 50605 | 527 |
1718920 | 1718920 | 2021-09-14 | Pulaski | Virginia | 51155 | 3428 | 75 |
1718921 | 1718921 | 2021-09-14 | Radford city | Virginia | 51750 | 2650 | 29 |
1718922 | 1718922 | 2021-09-14 | Rappahannock | Virginia | 51157 | 476 | 3 |
1718923 | 1718923 | 2021-09-14 | Richmond | Virginia | 51159 | 1489 | 12 |
1718924 | 1718924 | 2021-09-14 | Richmond city | Virginia | 51760 | 21356 | 291 |
1718925 | 1718925 | 2021-09-14 | Roanoke | Virginia | 51161 | 10060 | 152 |
1718926 | 1718926 | 2021-09-14 | Roanoke city | Virginia | 51770 | 10365 | 208 |
1718927 | 1718927 | 2021-09-14 | Rockbridge | Virginia | 51163 | 1815 | 50 |
1718928 | 1718928 | 2021-09-14 | Rockingham | Virginia | 51165 | 8121 | 119 |
1718929 | 1718929 | 2021-09-14 | Russell | Virginia | 51167 | 2975 | 43 |
1718930 | 1718930 | 2021-09-14 | Salem city | Virginia | 51775 | 2773 | 54 |
1718931 | 1718931 | 2021-09-14 | Scott | Virginia | 51169 | 2450 | 67 |
1718932 | 1718932 | 2021-09-14 | Shenandoah | Virginia | 51171 | 5178 | 138 |
1718933 | 1718933 | 2021-09-14 | Smyth | Virginia | 51173 | 3673 | 97 |
1718934 | 1718934 | 2021-09-14 | Southampton | Virginia | 51175 | 2165 | 58 |
1718935 | 1718935 | 2021-09-14 | Spotsylvania | Virginia | 51177 | 12760 | 132 |
1718936 | 1718936 | 2021-09-14 | Stafford | Virginia | 51179 | 14156 | 91 |
1718937 | 1718937 | 2021-09-14 | Staunton city | Virginia | 51790 | 2984 | 73 |
1718938 | 1718938 | 2021-09-14 | Suffolk city | Virginia | 51800 | 9696 | 204 |
1718939 | 1718939 | 2021-09-14 | Surry | Virginia | 51181 | 536 | 9 |
1718940 | 1718940 | 2021-09-14 | Sussex | Virginia | 51183 | 1371 | 23 |
1718941 | 1718941 | 2021-09-14 | Tazewell | Virginia | 51185 | 4758 | 83 |
1718942 | 1718942 | 2021-09-14 | Virginia Beach city | Virginia | 51810 | 44990 | 459 |
1718943 | 1718943 | 2021-09-14 | Warren | Virginia | 51187 | 4051 | 65 |
1718944 | 1718944 | 2021-09-14 | Washington | Virginia | 51191 | 6348 | 119 |
1718945 | 1718945 | 2021-09-14 | Waynesboro city | Virginia | 51820 | 2852 | 39 |
1718946 | 1718946 | 2021-09-14 | Westmoreland | Virginia | 51193 | 1557 | 29 |
1718947 | 1718947 | 2021-09-14 | Williamsburg city | Virginia | 51830 | 992 | 14 |
1718948 | 1718948 | 2021-09-14 | Winchester city | Virginia | 51840 | 3411 | 50 |
1718949 | 1718949 | 2021-09-14 | Wise | Virginia | 51195 | 4176 | 114 |
1718950 | 1718950 | 2021-09-14 | Wythe | Virginia | 51197 | 3664 | 87 |
1718951 | 1718951 | 2021-09-14 | York | Virginia | 51199 | 4752 | 62 |
1715571 | 1715571 | 2021-09-13 | Accomack | Virginia | 51001 | 3517 | 58 |
1715572 | 1715572 | 2021-09-13 | Albemarle | Virginia | 51003 | 6940 | 87 |
1715573 | 1715573 | 2021-09-13 | Alexandria city | Virginia | 51510 | 13209 | 142 |
1715574 | 1715574 | 2021-09-13 | Alleghany | Virginia | 51005 | 1720 | 59 |
1715575 | 1715575 | 2021-09-13 | Amelia | Virginia | 51007 | 1171 | 38 |
1715576 | 1715576 | 2021-09-13 | Amherst | Virginia | 51009 | 3825 | 45 |
1715577 | 1715577 | 2021-09-13 | Appomattox | Virginia | 51011 | 2041 | 29 |
1715578 | 1715578 | 2021-09-13 | Arlington | Virginia | 51013 | 17175 | 261 |
1715579 | 1715579 | 2021-09-13 | Augusta | Virginia | 51015 | 8529 | 93 |
1715580 | 1715580 | 2021-09-13 | Bath | Virginia | 51017 | 347 | 11 |
1715581 | 1715581 | 2021-09-13 | Bedford | Virginia | 51019 | 8417 | 116 |
1715582 | 1715582 | 2021-09-13 | Bland | Virginia | 51021 | 912 | 11 |
1715583 | 1715583 | 2021-09-13 | Botetourt | Virginia | 51023 | 3143 | 39 |
1715584 | 1715584 | 2021-09-13 | Bristol city | Virginia | 51520 | 1992 | 41 |
1715585 | 1715585 | 2021-09-13 | Brunswick | Virginia | 51025 | 1609 | 29 |
1715586 | 1715586 | 2021-09-13 | Buchanan | Virginia | 51027 | 1934 | 47 |
1715587 | 1715587 | 2021-09-13 | Buckingham | Virginia | 51029 | 2399 | 34 |
1715588 | 1715588 | 2021-09-13 | Buena Vista city | Virginia | 51530 | 1053 | 22 |
1715589 | 1715589 | 2021-09-13 | Campbell | Virginia | 51031 | 6135 | 118 |
1715590 | 1715590 | 2021-09-13 | Caroline | Virginia | 51033 | 3369 | 43 |
1715591 | 1715591 | 2021-09-13 | Carroll | Virginia | 51035 | 3251 | 81 |
1715592 | 1715592 | 2021-09-13 | Charles City | Virginia | 51036 | 610 | 17 |
1715593 | 1715593 | 2021-09-13 | Charlotte | Virginia | 51037 | 1076 | 22 |
1715594 | 1715594 | 2021-09-13 | Charlottesville city | Virginia | 51540 | 4768 | 57 |
1715595 | 1715595 | 2021-09-13 | Chesapeake city | Virginia | 51550 | 25805 | 322 |
1715596 | 1715596 | 2021-09-13 | Chesterfield | Virginia | 51041 | 34724 | 476 |
1715597 | 1715597 | 2021-09-13 | Clarke | Virginia | 51043 | 1144 | 22 |
1715598 | 1715598 | 2021-09-13 | Colonial Heights city | Virginia | 51570 | 2224 | 62 |
1715599 | 1715599 | 2021-09-13 | Covington city | Virginia | 51580 | 670 | 14 |
1715600 | 1715600 | 2021-09-13 | Craig | Virginia | 51045 | 435 | 6 |
1715601 | 1715601 | 2021-09-13 | Culpeper | Virginia | 51047 | 5576 | 70 |
1715602 | 1715602 | 2021-09-13 | Cumberland | Virginia | 51049 | 623 | 11 |
1715603 | 1715603 | 2021-09-13 | Danville city | Virginia | 51590 | 5461 | 156 |
1715604 | 1715604 | 2021-09-13 | Dickenson | Virginia | 51051 | 1283 | 20 |
1715605 | 1715605 | 2021-09-13 | Dinwiddie | Virginia | 51053 | 2677 | 47 |
1715606 | 1715606 | 2021-09-13 | Emporia city | Virginia | 51595 | 796 | 42 |
1715607 | 1715607 | 2021-09-13 | Essex | Virginia | 51057 | 967 | 12 |
1715608 | 1715608 | 2021-09-13 | Fairfax | Virginia | 51059 | 85236 | 1143 |
1715609 | 1715609 | 2021-09-13 | Fairfax city | Virginia | 51600 | 616 | 19 |
1715610 | 1715610 | 2021-09-13 | Falls Church city | Virginia | 51610 | 495 | 8 |
1715611 | 1715611 | 2021-09-13 | Fauquier | Virginia | 51061 | 5994 | 73 |
1715612 | 1715612 | 2021-09-13 | Floyd | Virginia | 51063 | 1137 | 23 |
1715613 | 1715613 | 2021-09-13 | Fluvanna | Virginia | 51065 | 2273 | 22 |
1715614 | 1715614 | 2021-09-13 | Franklin | Virginia | 51067 | 5094 | 86 |
1715615 | 1715615 | 2021-09-13 | Franklin city | Virginia | 51620 | 1354 | 36 |
1715616 | 1715616 | 2021-09-13 | Frederick | Virginia | 51069 | 9777 | 110 |
1715617 | 1715617 | 2021-09-13 | Fredericksburg city | Virginia | 51630 | 2644 | 25 |
1715618 | 1715618 | 2021-09-13 | Galax city | Virginia | 51640 | 1354 | 53 |
1715619 | 1715619 | 2021-09-13 | Giles | Virginia | 51071 | 1743 | 24 |
1715620 | 1715620 | 2021-09-13 | Gloucester | Virginia | 51073 | 3234 | 54 |
1715621 | 1715621 | 2021-09-13 | Goochland | Virginia | 51075 | 1749 | 27 |
1715622 | 1715622 | 2021-09-13 | Grayson | Virginia | 51077 | 1787 | 40 |
1715623 | 1715623 | 2021-09-13 | Greene | Virginia | 51079 | 1724 | 24 |
1715624 | 1715624 | 2021-09-13 | Greensville | Virginia | 51081 | 1717 | 26 |
1715625 | 1715625 | 2021-09-13 | Halifax | Virginia | 51083 | 3323 | 90 |
1715626 | 1715626 | 2021-09-13 | Hampton city | Virginia | 51650 | 13337 | 199 |
1715627 | 1715627 | 2021-09-13 | Hanover | Virginia | 51085 | 10195 | 179 |
1715628 | 1715628 | 2021-09-13 | Harrisonburg city | Virginia | 51660 | 7452 | 96 |
1715629 | 1715629 | 2021-09-13 | Henrico | Virginia | 51087 | 30928 | 660 |
1715630 | 1715630 | 2021-09-13 | Henry | Virginia | 51089 | 5575 | 134 |
1715631 | 1715631 | 2021-09-13 | Highland | Virginia | 51091 | 140 | 1 |
1715632 | 1715632 | 2021-09-13 | Hopewell city | Virginia | 51670 | 3298 | 83 |
1715633 | 1715633 | 2021-09-13 | Isle of Wight | Virginia | 51093 | 3812 | 74 |
1715634 | 1715634 | 2021-09-13 | James City | Virginia | 51095 | 5997 | 82 |
1715635 | 1715635 | 2021-09-13 | King George | Virginia | 51099 | 2131 | 21 |
1715636 | 1715636 | 2021-09-13 | King William | Virginia | 51101 | 1603 | 18 |
1715637 | 1715637 | 2021-09-13 | King and Queen | Virginia | 51097 | 530 | 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);