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 361
- 51810 360
- 51107 358
- 51013 357
- 51147 357
- 51153 357
- 51085 356
- 51095 356
- 51510 356
- 51177 355
- 51660 355
- 51041 354
- 51179 353
- 51199 353
- 51830 352
- 51075 351
- 51087 351
- 51540 351
- 51760 351
- 51036 350
- 51700 349
- 51710 349
- 51740 349
- 51001 348
- 51073 348
- 51117 348
- 51800 348
- 51003 347
- 51023 347
- 51067 347
- …
county >30
- Fairfax 361
- Virginia Beach city 360
- Loudoun 358
- Arlington 357
- Prince Edward 357
- Prince William 357
- Alexandria city 356
- Hanover 356
- James City 356
- Harrisonburg city 355
- Spotsylvania 355
- Chesterfield 354
- Stafford 353
- York 353
- Williamsburg city 352
- Charlottesville city 351
- Goochland 351
- Henrico 351
- Richmond city 351
- Charles City 350
- Newport News city 349
- Norfolk city 349
- Portsmouth city 349
- Accomack 348
- Gloucester 348
- Mecklenburg 348
- Suffolk city 348
- Albemarle 347
- Botetourt 347
- Franklin 347
- …
state 1
- Virginia · 45,057 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1085715 | 1085715 | 2021-03-03 | Manassas Park city | Virginia | 51685 | 1127 | 11 |
1085716 | 1085716 | 2021-03-03 | Manassas city | Virginia | 51683 | 4012 | 41 |
1085717 | 1085717 | 2021-03-03 | Martinsville city | Virginia | 51690 | 1508 | 64 |
1085718 | 1085718 | 2021-03-03 | Mathews | Virginia | 51115 | 555 | 11 |
1085719 | 1085719 | 2021-03-03 | Mecklenburg | Virginia | 51117 | 1997 | 58 |
1085720 | 1085720 | 2021-03-03 | Middlesex | Virginia | 51119 | 524 | 18 |
1085721 | 1085721 | 2021-03-03 | Montgomery | Virginia | 51121 | 7806 | 86 |
1085722 | 1085722 | 2021-03-03 | Nelson | Virginia | 51125 | 774 | 9 |
1085723 | 1085723 | 2021-03-03 | New Kent | Virginia | 51127 | 1250 | 12 |
1085724 | 1085724 | 2021-03-03 | Newport News city | Virginia | 51700 | 11567 | 190 |
1085725 | 1085725 | 2021-03-03 | Norfolk city | Virginia | 51710 | 15019 | 205 |
1085726 | 1085726 | 2021-03-03 | Northampton | Virginia | 51131 | 721 | 34 |
1085727 | 1085727 | 2021-03-03 | Northumberland | Virginia | 51133 | 668 | 19 |
1085728 | 1085728 | 2021-03-03 | Norton city | Virginia | 51720 | 240 | 6 |
1085729 | 1085729 | 2021-03-03 | Nottoway | Virginia | 51135 | 1809 | 41 |
1085730 | 1085730 | 2021-03-03 | Orange | Virginia | 51137 | 1862 | 28 |
1085731 | 1085731 | 2021-03-03 | Page | Virginia | 51139 | 1832 | 53 |
1085732 | 1085732 | 2021-03-03 | Patrick | Virginia | 51141 | 1203 | 36 |
1085733 | 1085733 | 2021-03-03 | Petersburg city | Virginia | 51730 | 3192 | 62 |
1085734 | 1085734 | 2021-03-03 | Pittsylvania | Virginia | 51143 | 4775 | 69 |
1085735 | 1085735 | 2021-03-03 | Poquoson city | Virginia | 51735 | 724 | 15 |
1085736 | 1085736 | 2021-03-03 | Portsmouth city | Virginia | 51740 | 7754 | 148 |
1085737 | 1085737 | 2021-03-03 | Powhatan | Virginia | 51145 | 1650 | 9 |
1085738 | 1085738 | 2021-03-03 | Prince Edward | Virginia | 51147 | 1962 | 28 |
1085739 | 1085739 | 2021-03-03 | Prince George | Virginia | 51149 | 3005 | 16 |
1085740 | 1085740 | 2021-03-03 | Prince William | Virginia | 51153 | 39570 | 441 |
1085741 | 1085741 | 2021-03-03 | Pulaski | Virginia | 51155 | 2330 | 55 |
1085742 | 1085742 | 2021-03-03 | Radford city | Virginia | 51750 | 1895 | 17 |
1085743 | 1085743 | 2021-03-03 | Rappahannock | Virginia | 51157 | 300 | 2 |
1085744 | 1085744 | 2021-03-03 | Richmond | Virginia | 51159 | 1372 | 8 |
1085745 | 1085745 | 2021-03-03 | Richmond city | Virginia | 51760 | 14914 | 213 |
1085746 | 1085746 | 2021-03-03 | Roanoke | Virginia | 51161 | 7368 | 119 |
1085747 | 1085747 | 2021-03-03 | Roanoke city | Virginia | 51770 | 7569 | 157 |
1085748 | 1085748 | 2021-03-03 | Rockbridge | Virginia | 51163 | 1291 | 36 |
1085749 | 1085749 | 2021-03-03 | Rockingham | Virginia | 51165 | 6077 | 94 |
1085750 | 1085750 | 2021-03-03 | Russell | Virginia | 51167 | 2034 | 34 |
1085751 | 1085751 | 2021-03-03 | Salem city | Virginia | 51775 | 1860 | 42 |
1085752 | 1085752 | 2021-03-03 | Scott | Virginia | 51169 | 1591 | 49 |
1085753 | 1085753 | 2021-03-03 | Shenandoah | Virginia | 51171 | 3718 | 123 |
1085754 | 1085754 | 2021-03-03 | Smyth | Virginia | 51173 | 2521 | 87 |
1085755 | 1085755 | 2021-03-03 | Southampton | Virginia | 51175 | 1859 | 53 |
1085756 | 1085756 | 2021-03-03 | Spotsylvania | Virginia | 51177 | 8367 | 102 |
1085757 | 1085757 | 2021-03-03 | Stafford | Virginia | 51179 | 9644 | 68 |
1085758 | 1085758 | 2021-03-03 | Staunton city | Virginia | 51790 | 2449 | 66 |
1085759 | 1085759 | 2021-03-03 | Suffolk city | Virginia | 51800 | 6963 | 159 |
1085760 | 1085760 | 2021-03-03 | Surry | Virginia | 51181 | 367 | 8 |
1085761 | 1085761 | 2021-03-03 | Sussex | Virginia | 51183 | 1074 | 18 |
1085762 | 1085762 | 2021-03-03 | Tazewell | Virginia | 51185 | 3202 | 58 |
1085763 | 1085763 | 2021-03-03 | Virginia Beach city | Virginia | 51810 | 30838 | 328 |
1085764 | 1085764 | 2021-03-03 | Warren | Virginia | 51187 | 2304 | 47 |
1085765 | 1085765 | 2021-03-03 | Washington | Virginia | 51191 | 4287 | 98 |
1085766 | 1085766 | 2021-03-03 | Waynesboro city | Virginia | 51820 | 2153 | 32 |
1085767 | 1085767 | 2021-03-03 | Westmoreland | Virginia | 51193 | 1117 | 21 |
1085768 | 1085768 | 2021-03-03 | Williamsburg city | Virginia | 51830 | 535 | 11 |
1085769 | 1085769 | 2021-03-03 | Winchester city | Virginia | 51840 | 2471 | 40 |
1085770 | 1085770 | 2021-03-03 | Wise | Virginia | 51195 | 2882 | 92 |
1085771 | 1085771 | 2021-03-03 | Wythe | Virginia | 51197 | 2040 | 65 |
1085772 | 1085772 | 2021-03-03 | York | Virginia | 51199 | 3054 | 38 |
1082394 | 1082394 | 2021-03-02 | Accomack | Virginia | 51001 | 2604 | 35 |
1082395 | 1082395 | 2021-03-02 | Albemarle | Virginia | 51003 | 4867 | 62 |
1082396 | 1082396 | 2021-03-02 | Alexandria city | Virginia | 51510 | 10352 | 120 |
1082397 | 1082397 | 2021-03-02 | Alleghany | Virginia | 51005 | 1255 | 45 |
1082398 | 1082398 | 2021-03-02 | Amelia | Virginia | 51007 | 771 | 21 |
1082399 | 1082399 | 2021-03-02 | Amherst | Virginia | 51009 | 2681 | 24 |
1082400 | 1082400 | 2021-03-02 | Appomattox | Virginia | 51011 | 1415 | 17 |
1082401 | 1082401 | 2021-03-02 | Arlington | Virginia | 51013 | 13215 | 232 |
1082402 | 1082402 | 2021-03-02 | Augusta | Virginia | 51015 | 5206 | 61 |
1082403 | 1082403 | 2021-03-02 | Bath | Virginia | 51017 | 245 | 10 |
1082404 | 1082404 | 2021-03-02 | Bedford | Virginia | 51019 | 5804 | 69 |
1082405 | 1082405 | 2021-03-02 | Bland | Virginia | 51021 | 622 | 9 |
1082406 | 1082406 | 2021-03-02 | Botetourt | Virginia | 51023 | 2229 | 28 |
1082407 | 1082407 | 2021-03-02 | Bristol city | Virginia | 51520 | 1222 | 29 |
1082408 | 1082408 | 2021-03-02 | Brunswick | Virginia | 51025 | 1204 | 16 |
1082409 | 1082409 | 2021-03-02 | Buchanan | Virginia | 51027 | 1295 | 34 |
1082410 | 1082410 | 2021-03-02 | Buckingham | Virginia | 51029 | 2041 | 28 |
1082411 | 1082411 | 2021-03-02 | Buena Vista city | Virginia | 51530 | 842 | 18 |
1082412 | 1082412 | 2021-03-02 | Campbell | Virginia | 51031 | 4021 | 58 |
1082413 | 1082413 | 2021-03-02 | Caroline | Virginia | 51033 | 1847 | 24 |
1082414 | 1082414 | 2021-03-02 | Carroll | Virginia | 51035 | 2119 | 61 |
1082415 | 1082415 | 2021-03-02 | Charles City | Virginia | 51036 | 401 | 11 |
1082416 | 1082416 | 2021-03-02 | Charlotte | Virginia | 51037 | 749 | 14 |
1082417 | 1082417 | 2021-03-02 | Charlottesville city | Virginia | 51540 | 3636 | 47 |
1082418 | 1082418 | 2021-03-02 | Chesapeake city | Virginia | 51550 | 18318 | 199 |
1082419 | 1082419 | 2021-03-02 | Chesterfield | Virginia | 51041 | 23654 | 324 |
1082420 | 1082420 | 2021-03-02 | Clarke | Virginia | 51043 | 763 | 18 |
1082421 | 1082421 | 2021-03-02 | Colonial Heights city | Virginia | 51570 | 1372 | 41 |
1082422 | 1082422 | 2021-03-02 | Covington city | Virginia | 51580 | 546 | 11 |
1082423 | 1082423 | 2021-03-02 | Craig | Virginia | 51045 | 241 | 5 |
1082424 | 1082424 | 2021-03-02 | Culpeper | Virginia | 51047 | 4093 | 52 |
1082425 | 1082425 | 2021-03-02 | Cumberland | Virginia | 51049 | 386 | 6 |
1082426 | 1082426 | 2021-03-02 | Danville city | Virginia | 51590 | 4321 | 108 |
1082427 | 1082427 | 2021-03-02 | Dickenson | Virginia | 51051 | 875 | 14 |
1082428 | 1082428 | 2021-03-02 | Dinwiddie | Virginia | 51053 | 1801 | 29 |
1082429 | 1082429 | 2021-03-02 | Emporia city | Virginia | 51595 | 617 | 40 |
1082430 | 1082430 | 2021-03-02 | Essex | Virginia | 51057 | 639 | 6 |
1082431 | 1082431 | 2021-03-02 | Fairfax | Virginia | 51059 | 66825 | 956 |
1082432 | 1082432 | 2021-03-02 | Fairfax city | Virginia | 51600 | 492 | 13 |
1082433 | 1082433 | 2021-03-02 | Falls Church city | Virginia | 51610 | 353 | 8 |
1082434 | 1082434 | 2021-03-02 | Fauquier | Virginia | 51061 | 3968 | 53 |
1082435 | 1082435 | 2021-03-02 | Floyd | Virginia | 51063 | 738 | 18 |
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);