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 133
- 51059 113
- 51810 112
- 51107 110
- 51013 109
- 51085 108
- 51095 108
- 51147 108
- 51153 108
- 51510 108
- 51177 107
- 51660 107
- 51041 106
- 51179 105
- 51199 105
- 51830 104
- 51075 103
- 51087 103
- 51540 103
- 51760 103
- 51036 102
- 51001 100
- 51073 100
- 51700 100
- 51710 100
- 51740 100
- 51800 100
- 51003 99
- 51023 99
- 51067 99
- 51093 99
- 51117 99
- 51165 99
- 51009 98
- 51019 98
- 51047 98
- 51065 98
- 51105 98
- 51109 98
- 51163 98
- 51590 97
- 51083 96
- 51161 96
- 51171 96
- 51550 96
- 51069 95
- 51113 95
- 51115 95
- 51125 95
- 51135 95
- 51137 95
- 51175 95
- 51187 95
- 51191 95
- 51630 95
- 51683 95
- 51750 95
- 51007 94
- 51061 94
- 51079 94
- 51099 94
- 51131 94
- 51143 94
- 51149 94
- 51650 94
- 51680 94
- 51735 94
- 51770 94
- 51520 93
- 51640 93
- 51103 92
- 51121 92
- 51127 92
- 51133 92
- 51145 92
- 51185 92
- 51197 92
- 51670 92
- 51840 92
- 51005 91
- 51081 91
- 51173 91
- 51685 91
- 51089 90
- 51101 90
- 51181 90
- 51730 90
- 51820 90
- 51025 89
- 51029 89
- 51031 89
- 51035 89
- 51043 89
- 51097 89
- 51139 89
- 51183 89
- 51620 89
- 51015 88
- 51775 88
- 51049 87
- 51155 87
- 51159 87
- 51193 87
- 51195 87
- 51033 86
- 51530 86
- 51595 86
- 51678 86
- 51790 86
- 51037 85
- 51167 84
- 51011 83
- 51071 83
- 51157 83
- 51027 82
- 51045 82
- 51053 82
- 51111 82
- 51063 80
- 51119 80
- 51169 80
- 51570 79
- 51600 79
- 51610 76
- 51057 73
- 51141 68
- 51720 68
- 51091 67
- 51077 61
- 51690 61
- 51580 50
- - 31
- 51051 12
- 51021 9
county 133
- Fairfax 113
- Virginia Beach city 112
- Loudoun 110
- Arlington 109
- Alexandria city 108
- Hanover 108
- James City 108
- Prince Edward 108
- Prince William 108
- Harrisonburg city 107
- Spotsylvania 107
- Chesterfield 106
- Stafford 105
- York 105
- Williamsburg city 104
- Charlottesville city 103
- Goochland 103
- Henrico 103
- Richmond city 103
- Charles City 102
- Accomack 100
- Gloucester 100
- Newport News city 100
- Norfolk city 100
- Portsmouth city 100
- Suffolk city 100
- Albemarle 99
- Botetourt 99
- Franklin 99
- Isle of Wight 99
- Mecklenburg 99
- Rockingham 99
- Amherst 98
- Bedford 98
- Culpeper 98
- Fluvanna 98
- Lee 98
- Louisa 98
- Rockbridge 98
- Danville city 97
- Chesapeake city 96
- Halifax 96
- Roanoke 96
- Shenandoah 96
- Frederick 95
- Fredericksburg city 95
- Madison 95
- Manassas city 95
- Mathews 95
- Nelson 95
- Nottoway 95
- Orange 95
- Radford city 95
- Southampton 95
- Warren 95
- Washington 95
- Amelia 94
- Fauquier 94
- Greene 94
- Hampton city 94
- King George 94
- Lynchburg city 94
- Northampton 94
- Pittsylvania 94
- Poquoson city 94
- Prince George 94
- Roanoke city 94
- Bristol city 93
- Galax city 93
- Hopewell city 92
- Lancaster 92
- Montgomery 92
- New Kent 92
- Northumberland 92
- Powhatan 92
- Tazewell 92
- Winchester city 92
- Wythe 92
- Alleghany 91
- Greensville 91
- Manassas Park city 91
- Smyth 91
- Henry 90
- King William 90
- Petersburg city 90
- Surry 90
- Waynesboro city 90
- Brunswick 89
- Buckingham 89
- Campbell 89
- Carroll 89
- Clarke 89
- Franklin city 89
- King and Queen 89
- Page 89
- Sussex 89
- Augusta 88
- Salem city 88
- Cumberland 87
- Pulaski 87
- Richmond 87
- Westmoreland 87
- Wise 87
- Buena Vista city 86
- Caroline 86
- Emporia city 86
- Lexington city 86
- Staunton city 86
- Charlotte 85
- Russell 84
- Appomattox 83
- Giles 83
- Rappahannock 83
- Buchanan 82
- Craig 82
- Dinwiddie 82
- Lunenburg 82
- Floyd 80
- Middlesex 80
- Scott 80
- Colonial Heights city 79
- Fairfax city 79
- Falls Church city 76
- Essex 73
- Norton city 68
- Patrick 68
- Highland 67
- Grayson 61
- Martinsville city 61
- Covington city 50
- Unknown 31
- Dickenson 12
- Bland 9
state 1
- Virginia · 12,057 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
283715 | 283715 | 2020-06-28 | Pulaski | Virginia | 51155 | 39 | 2 |
283716 | 283716 | 2020-06-28 | Radford city | Virginia | 51750 | 11 | 0 |
283717 | 283717 | 2020-06-28 | Rappahannock | Virginia | 51157 | 20 | 0 |
283718 | 283718 | 2020-06-28 | Richmond | Virginia | 51159 | 296 | 4 |
283719 | 283719 | 2020-06-28 | Richmond city | Virginia | 51760 | 2184 | 30 |
283720 | 283720 | 2020-06-28 | Roanoke | Virginia | 51161 | 206 | 5 |
283721 | 283721 | 2020-06-28 | Roanoke city | Virginia | 51770 | 368 | 10 |
283722 | 283722 | 2020-06-28 | Rockbridge | Virginia | 51163 | 30 | 0 |
283723 | 283723 | 2020-06-28 | Rockingham | Virginia | 51165 | 707 | 10 |
283724 | 283724 | 2020-06-28 | Russell | Virginia | 51167 | 9 | 0 |
283725 | 283725 | 2020-06-28 | Salem city | Virginia | 51775 | 51 | 3 |
283726 | 283726 | 2020-06-28 | Scott | Virginia | 51169 | 10 | 2 |
283727 | 283727 | 2020-06-28 | Shenandoah | Virginia | 51171 | 558 | 29 |
283728 | 283728 | 2020-06-28 | Smyth | Virginia | 51173 | 35 | 1 |
283729 | 283729 | 2020-06-28 | Southampton | Virginia | 51175 | 155 | 2 |
283730 | 283730 | 2020-06-28 | Spotsylvania | Virginia | 51177 | 981 | 29 |
283731 | 283731 | 2020-06-28 | Stafford | Virginia | 51179 | 983 | 5 |
283732 | 283732 | 2020-06-28 | Staunton city | Virginia | 51790 | 68 | 0 |
283733 | 283733 | 2020-06-28 | Suffolk city | Virginia | 51800 | 398 | 34 |
283734 | 283734 | 2020-06-28 | Surry | Virginia | 51181 | 14 | 1 |
283735 | 283735 | 2020-06-28 | Sussex | Virginia | 51183 | 195 | 2 |
283736 | 283736 | 2020-06-28 | Tazewell | Virginia | 51185 | 15 | 0 |
283737 | 283737 | 2020-06-28 | Virginia Beach city | Virginia | 51810 | 1123 | 29 |
283738 | 283738 | 2020-06-28 | Warren | Virginia | 51187 | 285 | 5 |
283739 | 283739 | 2020-06-28 | Washington | Virginia | 51191 | 63 | 4 |
283740 | 283740 | 2020-06-28 | Waynesboro city | Virginia | 51820 | 77 | 0 |
283741 | 283741 | 2020-06-28 | Westmoreland | Virginia | 51193 | 104 | 2 |
283742 | 283742 | 2020-06-28 | Williamsburg city | Virginia | 51830 | 55 | 6 |
283743 | 283743 | 2020-06-28 | Winchester city | Virginia | 51840 | 311 | 3 |
283744 | 283744 | 2020-06-28 | Wise | Virginia | 51195 | 27 | 2 |
283745 | 283745 | 2020-06-28 | Wythe | Virginia | 51197 | 49 | 1 |
283746 | 283746 | 2020-06-28 | York | Virginia | 51199 | 114 | 3 |
280469 | 280469 | 2020-06-27 | Accomack | Virginia | 51001 | 1039 | 14 |
280470 | 280470 | 2020-06-27 | Albemarle | Virginia | 51003 | 382 | 8 |
280471 | 280471 | 2020-06-27 | Alexandria city | Virginia | 51510 | 2303 | 57 |
280472 | 280472 | 2020-06-27 | Alleghany | Virginia | 51005 | 31 | 2 |
280473 | 280473 | 2020-06-27 | Amelia | Virginia | 51007 | 42 | 1 |
280474 | 280474 | 2020-06-27 | Amherst | Virginia | 51009 | 35 | 0 |
280475 | 280475 | 2020-06-27 | Appomattox | Virginia | 51011 | 38 | 0 |
280476 | 280476 | 2020-06-27 | Arlington | Virginia | 51013 | 2454 | 132 |
280477 | 280477 | 2020-06-27 | Augusta | Virginia | 51015 | 179 | 2 |
280478 | 280478 | 2020-06-27 | Bedford | Virginia | 51019 | 107 | 3 |
280479 | 280479 | 2020-06-27 | Bland | Virginia | 51021 | 2 | 0 |
280480 | 280480 | 2020-06-27 | Botetourt | Virginia | 51023 | 69 | 4 |
280481 | 280481 | 2020-06-27 | Bristol city | Virginia | 51520 | 4 | 0 |
280482 | 280482 | 2020-06-27 | Brunswick | Virginia | 51025 | 99 | 1 |
280483 | 280483 | 2020-06-27 | Buchanan | Virginia | 51027 | 31 | 0 |
280484 | 280484 | 2020-06-27 | Buckingham | Virginia | 51029 | 556 | 4 |
280485 | 280485 | 2020-06-27 | Buena Vista city | Virginia | 51530 | 14 | 0 |
280486 | 280486 | 2020-06-27 | Campbell | Virginia | 51031 | 41 | 1 |
280487 | 280487 | 2020-06-27 | Caroline | Virginia | 51033 | 128 | 4 |
280488 | 280488 | 2020-06-27 | Carroll | Virginia | 51035 | 203 | 8 |
280489 | 280489 | 2020-06-27 | Charles City | Virginia | 51036 | 39 | 3 |
280490 | 280490 | 2020-06-27 | Charlotte | Virginia | 51037 | 30 | 0 |
280491 | 280491 | 2020-06-27 | Charlottesville city | Virginia | 51540 | 200 | 3 |
280492 | 280492 | 2020-06-27 | Chesapeake city | Virginia | 51550 | 854 | 20 |
280493 | 280493 | 2020-06-27 | Chesterfield | Virginia | 51041 | 2842 | 49 |
280494 | 280494 | 2020-06-27 | Clarke | Virginia | 51043 | 49 | 0 |
280495 | 280495 | 2020-06-27 | Colonial Heights city | Virginia | 51570 | 143 | 17 |
280496 | 280496 | 2020-06-27 | Covington city | Virginia | 51580 | 3 | 0 |
280497 | 280497 | 2020-06-27 | Craig | Virginia | 51045 | 6 | 0 |
280498 | 280498 | 2020-06-27 | Culpeper | Virginia | 51047 | 807 | 10 |
280499 | 280499 | 2020-06-27 | Cumberland | Virginia | 51049 | 50 | 0 |
280500 | 280500 | 2020-06-27 | Danville city | Virginia | 51590 | 79 | 2 |
280501 | 280501 | 2020-06-27 | Dickenson | Virginia | 51051 | 3 | 0 |
280502 | 280502 | 2020-06-27 | Dinwiddie | Virginia | 51053 | 141 | 0 |
280503 | 280503 | 2020-06-27 | Emporia city | Virginia | 51595 | 133 | 10 |
280504 | 280504 | 2020-06-27 | Essex | Virginia | 51057 | 56 | 0 |
280505 | 280505 | 2020-06-27 | Fairfax | Virginia | 51059 | 13728 | 468 |
280506 | 280506 | 2020-06-27 | Fairfax city | Virginia | 51600 | 70 | 7 |
280507 | 280507 | 2020-06-27 | Falls Church city | Virginia | 51610 | 56 | 7 |
280508 | 280508 | 2020-06-27 | Fauquier | Virginia | 51061 | 417 | 6 |
280509 | 280509 | 2020-06-27 | Floyd | Virginia | 51063 | 15 | 1 |
280510 | 280510 | 2020-06-27 | Fluvanna | Virginia | 51065 | 109 | 6 |
280511 | 280511 | 2020-06-27 | Franklin | Virginia | 51067 | 60 | 1 |
280512 | 280512 | 2020-06-27 | Franklin city | Virginia | 51620 | 47 | 2 |
280513 | 280513 | 2020-06-27 | Frederick | Virginia | 51069 | 479 | 5 |
280514 | 280514 | 2020-06-27 | Fredericksburg city | Virginia | 51630 | 239 | 0 |
280515 | 280515 | 2020-06-27 | Galax city | Virginia | 51640 | 244 | 13 |
280516 | 280516 | 2020-06-27 | Giles | Virginia | 51071 | 8 | 0 |
280517 | 280517 | 2020-06-27 | Gloucester | Virginia | 51073 | 44 | 1 |
280518 | 280518 | 2020-06-27 | Goochland | Virginia | 51075 | 118 | 6 |
280519 | 280519 | 2020-06-27 | Grayson | Virginia | 51077 | 84 | 2 |
280520 | 280520 | 2020-06-27 | Greene | Virginia | 51079 | 60 | 1 |
280521 | 280521 | 2020-06-27 | Greensville | Virginia | 51081 | 355 | 7 |
280522 | 280522 | 2020-06-27 | Halifax | Virginia | 51083 | 49 | 1 |
280523 | 280523 | 2020-06-27 | Hampton city | Virginia | 51650 | 305 | 5 |
280524 | 280524 | 2020-06-27 | Hanover | Virginia | 51085 | 416 | 26 |
280525 | 280525 | 2020-06-27 | Harrisonburg city | Virginia | 51660 | 925 | 23 |
280526 | 280526 | 2020-06-27 | Henrico | Virginia | 51087 | 2560 | 141 |
280527 | 280527 | 2020-06-27 | Henry | Virginia | 51089 | 243 | 4 |
280528 | 280528 | 2020-06-27 | Highland | Virginia | 51091 | 3 | 0 |
280529 | 280529 | 2020-06-27 | Hopewell city | Virginia | 51670 | 169 | 2 |
280530 | 280530 | 2020-06-27 | Isle of Wight | Virginia | 51093 | 177 | 8 |
280531 | 280531 | 2020-06-27 | James City | Virginia | 51095 | 252 | 15 |
280532 | 280532 | 2020-06-27 | King George | Virginia | 51099 | 97 | 4 |
280533 | 280533 | 2020-06-27 | King William | Virginia | 51101 | 40 | 0 |
280534 | 280534 | 2020-06-27 | King and Queen | Virginia | 51097 | 23 | 1 |
280535 | 280535 | 2020-06-27 | Lancaster | Virginia | 51103 | 10 | 0 |
280536 | 280536 | 2020-06-27 | Lee | Virginia | 51105 | 9 | 0 |
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);