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 363
- 51810 362
- 51107 361
- 51013 359
- 51147 359
- 51153 359
- 51085 358
- 51095 358
- 51510 358
- 51177 357
- 51660 357
- 51041 356
- 51179 355
- 51199 355
- 51830 354
- 51075 353
- 51087 353
- 51540 353
- 51760 353
- 51036 352
- 51700 351
- 51710 351
- 51740 351
- 51001 350
- 51073 350
- 51117 350
- 51800 350
- 51003 349
- 51023 349
- 51067 349
- …
county >30
- Fairfax 363
- Virginia Beach city 362
- Loudoun 361
- Arlington 359
- Prince Edward 359
- Prince William 359
- Alexandria city 358
- Hanover 358
- James City 358
- Harrisonburg city 357
- Spotsylvania 357
- Chesterfield 356
- Stafford 355
- York 355
- Williamsburg city 354
- Charlottesville city 353
- Goochland 353
- Henrico 353
- Richmond city 353
- Charles City 352
- Newport News city 351
- Norfolk city 351
- Portsmouth city 351
- Accomack 350
- Gloucester 350
- Mecklenburg 350
- Suffolk city 350
- Albemarle 349
- Botetourt 349
- Franklin 349
- …
state 1
- Virginia · 45,331 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1092198 | 1092198 | 2021-03-05 | Lancaster | Virginia | 51103 | 670 | 13 |
1092199 | 1092199 | 2021-03-05 | Lee | Virginia | 51105 | 2306 | 42 |
1092200 | 1092200 | 2021-03-05 | Lexington city | Virginia | 51678 | 1123 | 26 |
1092201 | 1092201 | 2021-03-05 | Loudoun | Virginia | 51107 | 23352 | 252 |
1092202 | 1092202 | 2021-03-05 | Louisa | Virginia | 51109 | 1690 | 25 |
1092203 | 1092203 | 2021-03-05 | Lunenburg | Virginia | 51111 | 661 | 6 |
1092204 | 1092204 | 2021-03-05 | Lynchburg city | Virginia | 51680 | 6931 | 133 |
1092205 | 1092205 | 2021-03-05 | Madison | Virginia | 51113 | 536 | 14 |
1092206 | 1092206 | 2021-03-05 | Manassas Park city | Virginia | 51685 | 1129 | 12 |
1092207 | 1092207 | 2021-03-05 | Manassas city | Virginia | 51683 | 4029 | 41 |
1092208 | 1092208 | 2021-03-05 | Martinsville city | Virginia | 51690 | 1511 | 65 |
1092209 | 1092209 | 2021-03-05 | Mathews | Virginia | 51115 | 556 | 11 |
1092210 | 1092210 | 2021-03-05 | Mecklenburg | Virginia | 51117 | 2007 | 58 |
1092211 | 1092211 | 2021-03-05 | Middlesex | Virginia | 51119 | 528 | 18 |
1092212 | 1092212 | 2021-03-05 | Montgomery | Virginia | 51121 | 8003 | 86 |
1092213 | 1092213 | 2021-03-05 | Nelson | Virginia | 51125 | 786 | 9 |
1092214 | 1092214 | 2021-03-05 | New Kent | Virginia | 51127 | 1258 | 12 |
1092215 | 1092215 | 2021-03-05 | Newport News city | Virginia | 51700 | 11688 | 190 |
1092216 | 1092216 | 2021-03-05 | Norfolk city | Virginia | 51710 | 15079 | 209 |
1092217 | 1092217 | 2021-03-05 | Northampton | Virginia | 51131 | 726 | 34 |
1092218 | 1092218 | 2021-03-05 | Northumberland | Virginia | 51133 | 671 | 20 |
1092219 | 1092219 | 2021-03-05 | Norton city | Virginia | 51720 | 241 | 6 |
1092220 | 1092220 | 2021-03-05 | Nottoway | Virginia | 51135 | 1817 | 41 |
1092221 | 1092221 | 2021-03-05 | Orange | Virginia | 51137 | 1869 | 32 |
1092222 | 1092222 | 2021-03-05 | Page | Virginia | 51139 | 1840 | 53 |
1092223 | 1092223 | 2021-03-05 | Patrick | Virginia | 51141 | 1213 | 36 |
1092224 | 1092224 | 2021-03-05 | Petersburg city | Virginia | 51730 | 3220 | 64 |
1092225 | 1092225 | 2021-03-05 | Pittsylvania | Virginia | 51143 | 4795 | 69 |
1092226 | 1092226 | 2021-03-05 | Poquoson city | Virginia | 51735 | 728 | 15 |
1092227 | 1092227 | 2021-03-05 | Portsmouth city | Virginia | 51740 | 7789 | 149 |
1092228 | 1092228 | 2021-03-05 | Powhatan | Virginia | 51145 | 1661 | 10 |
1092229 | 1092229 | 2021-03-05 | Prince Edward | Virginia | 51147 | 1971 | 29 |
1092230 | 1092230 | 2021-03-05 | Prince George | Virginia | 51149 | 3023 | 16 |
1092231 | 1092231 | 2021-03-05 | Prince William | Virginia | 51153 | 39767 | 446 |
1092232 | 1092232 | 2021-03-05 | Pulaski | Virginia | 51155 | 2330 | 55 |
1092233 | 1092233 | 2021-03-05 | Radford city | Virginia | 51750 | 1899 | 17 |
1092234 | 1092234 | 2021-03-05 | Rappahannock | Virginia | 51157 | 305 | 2 |
1092235 | 1092235 | 2021-03-05 | Richmond | Virginia | 51159 | 1379 | 9 |
1092236 | 1092236 | 2021-03-05 | Richmond city | Virginia | 51760 | 14971 | 214 |
1092237 | 1092237 | 2021-03-05 | Roanoke | Virginia | 51161 | 7405 | 122 |
1092238 | 1092238 | 2021-03-05 | Roanoke city | Virginia | 51770 | 7603 | 160 |
1092239 | 1092239 | 2021-03-05 | Rockbridge | Virginia | 51163 | 1307 | 39 |
1092240 | 1092240 | 2021-03-05 | Rockingham | Virginia | 51165 | 6109 | 95 |
1092241 | 1092241 | 2021-03-05 | Russell | Virginia | 51167 | 2039 | 34 |
1092242 | 1092242 | 2021-03-05 | Salem city | Virginia | 51775 | 1870 | 42 |
1092243 | 1092243 | 2021-03-05 | Scott | Virginia | 51169 | 1602 | 49 |
1092244 | 1092244 | 2021-03-05 | Shenandoah | Virginia | 51171 | 3737 | 123 |
1092245 | 1092245 | 2021-03-05 | Smyth | Virginia | 51173 | 2523 | 87 |
1092246 | 1092246 | 2021-03-05 | Southampton | Virginia | 51175 | 1860 | 52 |
1092247 | 1092247 | 2021-03-05 | Spotsylvania | Virginia | 51177 | 8402 | 102 |
1092248 | 1092248 | 2021-03-05 | Stafford | Virginia | 51179 | 9649 | 68 |
1092249 | 1092249 | 2021-03-05 | Staunton city | Virginia | 51790 | 2466 | 66 |
1092250 | 1092250 | 2021-03-05 | Suffolk city | Virginia | 51800 | 6995 | 163 |
1092251 | 1092251 | 2021-03-05 | Surry | Virginia | 51181 | 372 | 8 |
1092252 | 1092252 | 2021-03-05 | Sussex | Virginia | 51183 | 1082 | 20 |
1092253 | 1092253 | 2021-03-05 | Tazewell | Virginia | 51185 | 3222 | 60 |
1092254 | 1092254 | 2021-03-05 | Virginia Beach city | Virginia | 51810 | 31010 | 330 |
1092255 | 1092255 | 2021-03-05 | Warren | Virginia | 51187 | 2320 | 48 |
1092256 | 1092256 | 2021-03-05 | Washington | Virginia | 51191 | 4301 | 99 |
1092257 | 1092257 | 2021-03-05 | Waynesboro city | Virginia | 51820 | 2159 | 33 |
1092258 | 1092258 | 2021-03-05 | Westmoreland | Virginia | 51193 | 1122 | 21 |
1092259 | 1092259 | 2021-03-05 | Williamsburg city | Virginia | 51830 | 540 | 11 |
1092260 | 1092260 | 2021-03-05 | Winchester city | Virginia | 51840 | 2479 | 40 |
1092261 | 1092261 | 2021-03-05 | Wise | Virginia | 51195 | 2892 | 92 |
1092262 | 1092262 | 2021-03-05 | Wythe | Virginia | 51197 | 2051 | 66 |
1092263 | 1092263 | 2021-03-05 | York | Virginia | 51199 | 3082 | 38 |
1088885 | 1088885 | 2021-03-04 | Accomack | Virginia | 51001 | 2609 | 35 |
1088886 | 1088886 | 2021-03-04 | Albemarle | Virginia | 51003 | 4925 | 70 |
1088887 | 1088887 | 2021-03-04 | Alexandria city | Virginia | 51510 | 10389 | 123 |
1088888 | 1088888 | 2021-03-04 | Alleghany | Virginia | 51005 | 1252 | 47 |
1088889 | 1088889 | 2021-03-04 | Amelia | Virginia | 51007 | 774 | 21 |
1088890 | 1088890 | 2021-03-04 | Amherst | Virginia | 51009 | 2685 | 31 |
1088891 | 1088891 | 2021-03-04 | Appomattox | Virginia | 51011 | 1423 | 19 |
1088892 | 1088892 | 2021-03-04 | Arlington | Virginia | 51013 | 13294 | 235 |
1088893 | 1088893 | 2021-03-04 | Augusta | Virginia | 51015 | 5216 | 66 |
1088894 | 1088894 | 2021-03-04 | Bath | Virginia | 51017 | 245 | 10 |
1088895 | 1088895 | 2021-03-04 | Bedford | Virginia | 51019 | 5816 | 73 |
1088896 | 1088896 | 2021-03-04 | Bland | Virginia | 51021 | 620 | 9 |
1088897 | 1088897 | 2021-03-04 | Botetourt | Virginia | 51023 | 2246 | 29 |
1088898 | 1088898 | 2021-03-04 | Bristol city | Virginia | 51520 | 1229 | 30 |
1088899 | 1088899 | 2021-03-04 | Brunswick | Virginia | 51025 | 1210 | 17 |
1088900 | 1088900 | 2021-03-04 | Buchanan | Virginia | 51027 | 1299 | 35 |
1088901 | 1088901 | 2021-03-04 | Buckingham | Virginia | 51029 | 2047 | 28 |
1088902 | 1088902 | 2021-03-04 | Buena Vista city | Virginia | 51530 | 843 | 18 |
1088903 | 1088903 | 2021-03-04 | Campbell | Virginia | 51031 | 4030 | 63 |
1088904 | 1088904 | 2021-03-04 | Caroline | Virginia | 51033 | 1853 | 27 |
1088905 | 1088905 | 2021-03-04 | Carroll | Virginia | 51035 | 2127 | 64 |
1088906 | 1088906 | 2021-03-04 | Charles City | Virginia | 51036 | 408 | 12 |
1088907 | 1088907 | 2021-03-04 | Charlotte | Virginia | 51037 | 751 | 14 |
1088908 | 1088908 | 2021-03-04 | Charlottesville city | Virginia | 51540 | 3660 | 46 |
1088909 | 1088909 | 2021-03-04 | Chesapeake city | Virginia | 51550 | 18395 | 222 |
1088910 | 1088910 | 2021-03-04 | Chesterfield | Virginia | 51041 | 23757 | 353 |
1088911 | 1088911 | 2021-03-04 | Clarke | Virginia | 51043 | 772 | 19 |
1088912 | 1088912 | 2021-03-04 | Colonial Heights city | Virginia | 51570 | 1381 | 45 |
1088913 | 1088913 | 2021-03-04 | Covington city | Virginia | 51580 | 551 | 11 |
1088914 | 1088914 | 2021-03-04 | Craig | Virginia | 51045 | 241 | 5 |
1088915 | 1088915 | 2021-03-04 | Culpeper | Virginia | 51047 | 4109 | 55 |
1088916 | 1088916 | 2021-03-04 | Cumberland | Virginia | 51049 | 391 | 6 |
1088917 | 1088917 | 2021-03-04 | Danville city | Virginia | 51590 | 4340 | 112 |
1088918 | 1088918 | 2021-03-04 | Dickenson | Virginia | 51051 | 876 | 14 |
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);