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 364
- 51810 363
- 51107 361
- 51013 360
- 51153 360
- 51085 359
- 51095 359
- 51147 359
- 51510 359
- 51177 358
- 51660 358
- 51041 357
- 51179 356
- 51199 356
- 51830 355
- 51075 354
- 51087 354
- 51540 354
- 51760 354
- 51036 353
- 51001 351
- 51073 351
- 51700 351
- 51710 351
- 51740 351
- 51800 351
- 51003 350
- 51023 350
- 51067 350
- 51093 350
- …
county >30
- Fairfax 364
- Virginia Beach city 363
- Loudoun 361
- Arlington 360
- Prince William 360
- Alexandria city 359
- Hanover 359
- James City 359
- Prince Edward 359
- Harrisonburg city 358
- Spotsylvania 358
- Chesterfield 357
- Stafford 356
- York 356
- Williamsburg city 355
- Charlottesville city 354
- Goochland 354
- Henrico 354
- Richmond city 354
- Charles City 353
- Accomack 351
- Gloucester 351
- Newport News city 351
- Norfolk city 351
- Portsmouth city 351
- Suffolk city 351
- Albemarle 350
- Botetourt 350
- Franklin 350
- Isle of Wight 350
- …
state 1
- Virginia · 45,431 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1095477 | 1095477 | 2021-03-06 | Prince William | Virginia | 51153 | 39868 | 450 |
1095478 | 1095478 | 2021-03-06 | Pulaski | Virginia | 51155 | 2331 | 55 |
1095479 | 1095479 | 2021-03-06 | Radford city | Virginia | 51750 | 1903 | 17 |
1095480 | 1095480 | 2021-03-06 | Rappahannock | Virginia | 51157 | 306 | 2 |
1095481 | 1095481 | 2021-03-06 | Richmond | Virginia | 51159 | 1380 | 10 |
1095482 | 1095482 | 2021-03-06 | Richmond city | Virginia | 51760 | 14990 | 215 |
1095483 | 1095483 | 2021-03-06 | Roanoke | Virginia | 51161 | 7435 | 131 |
1095484 | 1095484 | 2021-03-06 | Roanoke city | Virginia | 51770 | 7622 | 162 |
1095485 | 1095485 | 2021-03-06 | Rockbridge | Virginia | 51163 | 1309 | 40 |
1095486 | 1095486 | 2021-03-06 | Rockingham | Virginia | 51165 | 6117 | 96 |
1095487 | 1095487 | 2021-03-06 | Russell | Virginia | 51167 | 2042 | 35 |
1095488 | 1095488 | 2021-03-06 | Salem city | Virginia | 51775 | 1872 | 42 |
1095489 | 1095489 | 2021-03-06 | Scott | Virginia | 51169 | 1603 | 49 |
1095490 | 1095490 | 2021-03-06 | Shenandoah | Virginia | 51171 | 3743 | 124 |
1095491 | 1095491 | 2021-03-06 | Smyth | Virginia | 51173 | 2526 | 87 |
1095492 | 1095492 | 2021-03-06 | Southampton | Virginia | 51175 | 1860 | 52 |
1095493 | 1095493 | 2021-03-06 | Spotsylvania | Virginia | 51177 | 8418 | 102 |
1095494 | 1095494 | 2021-03-06 | Stafford | Virginia | 51179 | 9659 | 68 |
1095495 | 1095495 | 2021-03-06 | Staunton city | Virginia | 51790 | 2472 | 67 |
1095496 | 1095496 | 2021-03-06 | Suffolk city | Virginia | 51800 | 7006 | 165 |
1095497 | 1095497 | 2021-03-06 | Surry | Virginia | 51181 | 373 | 8 |
1095498 | 1095498 | 2021-03-06 | Sussex | Virginia | 51183 | 1081 | 20 |
1095499 | 1095499 | 2021-03-06 | Tazewell | Virginia | 51185 | 3233 | 60 |
1095500 | 1095500 | 2021-03-06 | Virginia Beach city | Virginia | 51810 | 31077 | 333 |
1095501 | 1095501 | 2021-03-06 | Warren | Virginia | 51187 | 2326 | 48 |
1095502 | 1095502 | 2021-03-06 | Washington | Virginia | 51191 | 4307 | 99 |
1095503 | 1095503 | 2021-03-06 | Waynesboro city | Virginia | 51820 | 2162 | 34 |
1095504 | 1095504 | 2021-03-06 | Westmoreland | Virginia | 51193 | 1124 | 21 |
1095505 | 1095505 | 2021-03-06 | Williamsburg city | Virginia | 51830 | 544 | 12 |
1095506 | 1095506 | 2021-03-06 | Winchester city | Virginia | 51840 | 2481 | 41 |
1095507 | 1095507 | 2021-03-06 | Wise | Virginia | 51195 | 2900 | 93 |
1095508 | 1095508 | 2021-03-06 | Wythe | Virginia | 51197 | 2051 | 66 |
1095509 | 1095509 | 2021-03-06 | York | Virginia | 51199 | 3104 | 39 |
1092131 | 1092131 | 2021-03-05 | Accomack | Virginia | 51001 | 2619 | 35 |
1092132 | 1092132 | 2021-03-05 | Albemarle | Virginia | 51003 | 4946 | 71 |
1092133 | 1092133 | 2021-03-05 | Alexandria city | Virginia | 51510 | 10404 | 123 |
1092134 | 1092134 | 2021-03-05 | Alleghany | Virginia | 51005 | 1251 | 47 |
1092135 | 1092135 | 2021-03-05 | Amelia | Virginia | 51007 | 774 | 21 |
1092136 | 1092136 | 2021-03-05 | Amherst | Virginia | 51009 | 2696 | 33 |
1092137 | 1092137 | 2021-03-05 | Appomattox | Virginia | 51011 | 1424 | 19 |
1092138 | 1092138 | 2021-03-05 | Arlington | Virginia | 51013 | 13342 | 236 |
1092139 | 1092139 | 2021-03-05 | Augusta | Virginia | 51015 | 5232 | 66 |
1092140 | 1092140 | 2021-03-05 | Bath | Virginia | 51017 | 245 | 10 |
1092141 | 1092141 | 2021-03-05 | Bedford | Virginia | 51019 | 5833 | 75 |
1092142 | 1092142 | 2021-03-05 | Bland | Virginia | 51021 | 621 | 9 |
1092143 | 1092143 | 2021-03-05 | Botetourt | Virginia | 51023 | 2252 | 29 |
1092144 | 1092144 | 2021-03-05 | Bristol city | Virginia | 51520 | 1227 | 30 |
1092145 | 1092145 | 2021-03-05 | Brunswick | Virginia | 51025 | 1212 | 17 |
1092146 | 1092146 | 2021-03-05 | Buchanan | Virginia | 51027 | 1307 | 35 |
1092147 | 1092147 | 2021-03-05 | Buckingham | Virginia | 51029 | 2047 | 28 |
1092148 | 1092148 | 2021-03-05 | Buena Vista city | Virginia | 51530 | 846 | 19 |
1092149 | 1092149 | 2021-03-05 | Campbell | Virginia | 51031 | 4038 | 63 |
1092150 | 1092150 | 2021-03-05 | Caroline | Virginia | 51033 | 1852 | 27 |
1092151 | 1092151 | 2021-03-05 | Carroll | Virginia | 51035 | 2129 | 64 |
1092152 | 1092152 | 2021-03-05 | Charles City | Virginia | 51036 | 410 | 12 |
1092153 | 1092153 | 2021-03-05 | Charlotte | Virginia | 51037 | 752 | 14 |
1092154 | 1092154 | 2021-03-05 | Charlottesville city | Virginia | 51540 | 3663 | 46 |
1092155 | 1092155 | 2021-03-05 | Chesapeake city | Virginia | 51550 | 18446 | 226 |
1092156 | 1092156 | 2021-03-05 | Chesterfield | Virginia | 51041 | 23812 | 356 |
1092157 | 1092157 | 2021-03-05 | Clarke | Virginia | 51043 | 780 | 19 |
1092158 | 1092158 | 2021-03-05 | Colonial Heights city | Virginia | 51570 | 1386 | 46 |
1092159 | 1092159 | 2021-03-05 | Covington city | Virginia | 51580 | 551 | 11 |
1092160 | 1092160 | 2021-03-05 | Craig | Virginia | 51045 | 243 | 5 |
1092161 | 1092161 | 2021-03-05 | Culpeper | Virginia | 51047 | 4118 | 55 |
1092162 | 1092162 | 2021-03-05 | Cumberland | Virginia | 51049 | 394 | 6 |
1092163 | 1092163 | 2021-03-05 | Danville city | Virginia | 51590 | 4341 | 112 |
1092164 | 1092164 | 2021-03-05 | Dickenson | Virginia | 51051 | 876 | 14 |
1092165 | 1092165 | 2021-03-05 | Dinwiddie | Virginia | 51053 | 1825 | 33 |
1092166 | 1092166 | 2021-03-05 | Emporia city | Virginia | 51595 | 619 | 40 |
1092167 | 1092167 | 2021-03-05 | Essex | Virginia | 51057 | 644 | 7 |
1092168 | 1092168 | 2021-03-05 | Fairfax | Virginia | 51059 | 67399 | 990 |
1092169 | 1092169 | 2021-03-05 | Fairfax city | Virginia | 51600 | 497 | 13 |
1092170 | 1092170 | 2021-03-05 | Falls Church city | Virginia | 51610 | 354 | 8 |
1092171 | 1092171 | 2021-03-05 | Fauquier | Virginia | 51061 | 3994 | 55 |
1092172 | 1092172 | 2021-03-05 | Floyd | Virginia | 51063 | 745 | 18 |
1092173 | 1092173 | 2021-03-05 | Fluvanna | Virginia | 51065 | 1303 | 16 |
1092174 | 1092174 | 2021-03-05 | Franklin | Virginia | 51067 | 3733 | 58 |
1092175 | 1092175 | 2021-03-05 | Franklin city | Virginia | 51620 | 1007 | 27 |
1092176 | 1092176 | 2021-03-05 | Frederick | Virginia | 51069 | 6820 | 87 |
1092177 | 1092177 | 2021-03-05 | Fredericksburg city | Virginia | 51630 | 1788 | 22 |
1092178 | 1092178 | 2021-03-05 | Galax city | Virginia | 51640 | 998 | 49 |
1092179 | 1092179 | 2021-03-05 | Giles | Virginia | 51071 | 1088 | 15 |
1092180 | 1092180 | 2021-03-05 | Gloucester | Virginia | 51073 | 1903 | 43 |
1092181 | 1092181 | 2021-03-05 | Goochland | Virginia | 51075 | 1225 | 17 |
1092182 | 1092182 | 2021-03-05 | Grayson | Virginia | 51077 | 1135 | 34 |
1092183 | 1092183 | 2021-03-05 | Greene | Virginia | 51079 | 1014 | 9 |
1092184 | 1092184 | 2021-03-05 | Greensville | Virginia | 51081 | 1464 | 25 |
1092185 | 1092185 | 2021-03-05 | Halifax | Virginia | 51083 | 2479 | 64 |
1092186 | 1092186 | 2021-03-05 | Hampton city | Virginia | 51650 | 8768 | 127 |
1092187 | 1092187 | 2021-03-05 | Hanover | Virginia | 51085 | 6782 | 138 |
1092188 | 1092188 | 2021-03-05 | Harrisonburg city | Virginia | 51660 | 5777 | 87 |
1092189 | 1092189 | 2021-03-05 | Henrico | Virginia | 51087 | 21639 | 537 |
1092190 | 1092190 | 2021-03-05 | Henry | Virginia | 51089 | 4230 | 115 |
1092191 | 1092191 | 2021-03-05 | Highland | Virginia | 51091 | 97 | 1 |
1092192 | 1092192 | 2021-03-05 | Hopewell city | Virginia | 51670 | 2145 | 54 |
1092193 | 1092193 | 2021-03-05 | Isle of Wight | Virginia | 51093 | 2677 | 57 |
1092194 | 1092194 | 2021-03-05 | James City | Virginia | 51095 | 3906 | 64 |
1092195 | 1092195 | 2021-03-05 | King George | Virginia | 51099 | 1425 | 16 |
1092196 | 1092196 | 2021-03-05 | King William | Virginia | 51101 | 936 | 10 |
1092197 | 1092197 | 2021-03-05 | King and Queen | Virginia | 51097 | 318 | 6 |
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);