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 193
- 51810 191
- 51107 190
- 51013 189
- 51085 188
- 51095 188
- 51147 188
- 51153 188
- 51510 188
- 51660 187
- 51041 186
- 51177 186
- 51179 184
- 51199 184
- 51075 183
- 51087 183
- 51540 183
- 51830 183
- 51036 182
- 51760 182
- 51001 180
- 51073 180
- 51700 180
- 51710 180
- 51740 180
- 51003 179
- 51023 179
- 51067 179
- 51093 179
- 51117 179
- …
county >30
- Fairfax 193
- Virginia Beach city 191
- Loudoun 190
- Arlington 189
- Alexandria city 188
- Hanover 188
- James City 188
- Prince Edward 188
- Prince William 188
- Harrisonburg city 187
- Chesterfield 186
- Spotsylvania 186
- Stafford 184
- York 184
- Charlottesville city 183
- Goochland 183
- Henrico 183
- Williamsburg city 183
- Charles City 182
- Richmond city 182
- Accomack 180
- Gloucester 180
- Newport News city 180
- Norfolk city 180
- Portsmouth city 180
- Albemarle 179
- Botetourt 179
- Franklin 179
- Isle of Wight 179
- Mecklenburg 179
- …
state 1
- Virginia · 22,655 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
537336 | 537336 | 2020-09-15 | Accomack | Virginia | 51001 | 1161 | 19 |
537337 | 537337 | 2020-09-15 | Albemarle | Virginia | 51003 | 1140 | 19 |
537338 | 537338 | 2020-09-15 | Alexandria city | Virginia | 51510 | 3615 | 65 |
537339 | 537339 | 2020-09-15 | Alleghany | Virginia | 51005 | 75 | 4 |
537340 | 537340 | 2020-09-15 | Amelia | Virginia | 51007 | 120 | 3 |
537341 | 537341 | 2020-09-15 | Amherst | Virginia | 51009 | 351 | 3 |
537342 | 537342 | 2020-09-15 | Appomattox | Virginia | 51011 | 197 | 2 |
537343 | 537343 | 2020-09-15 | Arlington | Virginia | 51013 | 3759 | 145 |
537344 | 537344 | 2020-09-15 | Augusta | Virginia | 51015 | 436 | 7 |
537345 | 537345 | 2020-09-15 | Bath | Virginia | 51017 | 4 | 0 |
537346 | 537346 | 2020-09-15 | Bedford | Virginia | 51019 | 663 | 9 |
537347 | 537347 | 2020-09-15 | Bland | Virginia | 51021 | 64 | 2 |
537348 | 537348 | 2020-09-15 | Botetourt | Virginia | 51023 | 278 | 10 |
537349 | 537349 | 2020-09-15 | Bristol city | Virginia | 51520 | 169 | 2 |
537350 | 537350 | 2020-09-15 | Brunswick | Virginia | 51025 | 333 | 3 |
537351 | 537351 | 2020-09-15 | Buchanan | Virginia | 51027 | 111 | 2 |
537352 | 537352 | 2020-09-15 | Buckingham | Virginia | 51029 | 670 | 8 |
537353 | 537353 | 2020-09-15 | Buena Vista city | Virginia | 51530 | 78 | 1 |
537354 | 537354 | 2020-09-15 | Campbell | Virginia | 51031 | 385 | 3 |
537355 | 537355 | 2020-09-15 | Caroline | Virginia | 51033 | 299 | 5 |
537356 | 537356 | 2020-09-15 | Carroll | Virginia | 51035 | 463 | 21 |
537357 | 537357 | 2020-09-15 | Charles City | Virginia | 51036 | 77 | 5 |
537358 | 537358 | 2020-09-15 | Charlotte | Virginia | 51037 | 97 | 0 |
537359 | 537359 | 2020-09-15 | Charlottesville city | Virginia | 51540 | 923 | 25 |
537360 | 537360 | 2020-09-15 | Chesapeake city | Virginia | 51550 | 4096 | 53 |
537361 | 537361 | 2020-09-15 | Chesterfield | Virginia | 51041 | 5593 | 87 |
537362 | 537362 | 2020-09-15 | Clarke | Virginia | 51043 | 88 | 0 |
537363 | 537363 | 2020-09-15 | Colonial Heights city | Virginia | 51570 | 240 | 23 |
537364 | 537364 | 2020-09-15 | Covington city | Virginia | 51580 | 29 | 0 |
537365 | 537365 | 2020-09-15 | Craig | Virginia | 51045 | 26 | 0 |
537366 | 537366 | 2020-09-15 | Culpeper | Virginia | 51047 | 1167 | 16 |
537367 | 537367 | 2020-09-15 | Cumberland | Virginia | 51049 | 102 | 1 |
537368 | 537368 | 2020-09-15 | Danville city | Virginia | 51590 | 767 | 20 |
537369 | 537369 | 2020-09-15 | Dickenson | Virginia | 51051 | 79 | 1 |
537370 | 537370 | 2020-09-15 | Dinwiddie | Virginia | 51053 | 341 | 9 |
537371 | 537371 | 2020-09-15 | Emporia city | Virginia | 51595 | 244 | 22 |
537372 | 537372 | 2020-09-15 | Essex | Virginia | 51057 | 163 | 2 |
537373 | 537373 | 2020-09-15 | Fairfax | Virginia | 51059 | 19732 | 569 |
537374 | 537374 | 2020-09-15 | Fairfax city | Virginia | 51600 | 131 | 7 |
537375 | 537375 | 2020-09-15 | Falls Church city | Virginia | 51610 | 67 | 7 |
537376 | 537376 | 2020-09-15 | Fauquier | Virginia | 51061 | 866 | 21 |
537377 | 537377 | 2020-09-15 | Floyd | Virginia | 51063 | 184 | 4 |
537378 | 537378 | 2020-09-15 | Fluvanna | Virginia | 51065 | 247 | 9 |
537379 | 537379 | 2020-09-15 | Franklin | Virginia | 51067 | 280 | 3 |
537380 | 537380 | 2020-09-15 | Franklin city | Virginia | 51620 | 377 | 9 |
537381 | 537381 | 2020-09-15 | Frederick | Virginia | 51069 | 821 | 11 |
537382 | 537382 | 2020-09-15 | Fredericksburg city | Virginia | 51630 | 518 | 5 |
537383 | 537383 | 2020-09-15 | Galax city | Virginia | 51640 | 406 | 30 |
537384 | 537384 | 2020-09-15 | Giles | Virginia | 51071 | 71 | 0 |
537385 | 537385 | 2020-09-15 | Gloucester | Virginia | 51073 | 227 | 2 |
537386 | 537386 | 2020-09-15 | Goochland | Virginia | 51075 | 252 | 7 |
537387 | 537387 | 2020-09-15 | Grayson | Virginia | 51077 | 290 | 8 |
537388 | 537388 | 2020-09-15 | Greene | Virginia | 51079 | 207 | 3 |
537389 | 537389 | 2020-09-15 | Greensville | Virginia | 51081 | 740 | 11 |
537390 | 537390 | 2020-09-15 | Halifax | Virginia | 51083 | 297 | 4 |
537391 | 537391 | 2020-09-15 | Hampton city | Virginia | 51650 | 1730 | 19 |
537392 | 537392 | 2020-09-15 | Hanover | Virginia | 51085 | 1187 | 35 |
537393 | 537393 | 2020-09-15 | Harrisonburg city | Virginia | 51660 | 2269 | 34 |
537394 | 537394 | 2020-09-15 | Henrico | Virginia | 51087 | 5079 | 203 |
537395 | 537395 | 2020-09-15 | Henry | Virginia | 51089 | 963 | 18 |
537396 | 537396 | 2020-09-15 | Highland | Virginia | 51091 | 6 | 0 |
537397 | 537397 | 2020-09-15 | Hopewell city | Virginia | 51670 | 373 | 5 |
537398 | 537398 | 2020-09-15 | Isle of Wight | Virginia | 51093 | 666 | 14 |
537399 | 537399 | 2020-09-15 | James City | Virginia | 51095 | 801 | 19 |
537400 | 537400 | 2020-09-15 | King George | Virginia | 51099 | 224 | 4 |
537401 | 537401 | 2020-09-15 | King William | Virginia | 51101 | 140 | 2 |
537402 | 537402 | 2020-09-15 | King and Queen | Virginia | 51097 | 65 | 1 |
537403 | 537403 | 2020-09-15 | Lancaster | Virginia | 51103 | 111 | 0 |
537404 | 537404 | 2020-09-15 | Lee | Virginia | 51105 | 248 | 6 |
537405 | 537405 | 2020-09-15 | Lexington city | Virginia | 51678 | 47 | 1 |
537406 | 537406 | 2020-09-15 | Loudoun | Virginia | 51107 | 6489 | 119 |
537407 | 537407 | 2020-09-15 | Louisa | Virginia | 51109 | 273 | 4 |
537408 | 537408 | 2020-09-15 | Lunenburg | Virginia | 51111 | 107 | 2 |
537409 | 537409 | 2020-09-15 | Lynchburg city | Virginia | 51680 | 1207 | 8 |
537410 | 537410 | 2020-09-15 | Madison | Virginia | 51113 | 99 | 3 |
537411 | 537411 | 2020-09-15 | Manassas Park city | Virginia | 51685 | 597 | 8 |
537412 | 537412 | 2020-09-15 | Manassas city | Virginia | 51683 | 1869 | 24 |
537413 | 537413 | 2020-09-15 | Martinsville city | Virginia | 51690 | 366 | 9 |
537414 | 537414 | 2020-09-15 | Mathews | Virginia | 51115 | 25 | 0 |
537415 | 537415 | 2020-09-15 | Mecklenburg | Virginia | 51117 | 634 | 33 |
537416 | 537416 | 2020-09-15 | Middlesex | Virginia | 51119 | 81 | 8 |
537417 | 537417 | 2020-09-15 | Montgomery | Virginia | 51121 | 1515 | 4 |
537418 | 537418 | 2020-09-15 | Nelson | Virginia | 51125 | 93 | 1 |
537419 | 537419 | 2020-09-15 | New Kent | Virginia | 51127 | 168 | 2 |
537420 | 537420 | 2020-09-15 | Newport News city | Virginia | 51700 | 2591 | 32 |
537421 | 537421 | 2020-09-15 | Norfolk city | Virginia | 51710 | 4676 | 66 |
537422 | 537422 | 2020-09-15 | Northampton | Virginia | 51131 | 304 | 29 |
537423 | 537423 | 2020-09-15 | Northumberland | Virginia | 51133 | 123 | 5 |
537424 | 537424 | 2020-09-15 | Norton city | Virginia | 51720 | 33 | 0 |
537425 | 537425 | 2020-09-15 | Nottoway | Virginia | 51135 | 233 | 15 |
537426 | 537426 | 2020-09-15 | Orange | Virginia | 51137 | 289 | 4 |
537427 | 537427 | 2020-09-15 | Page | Virginia | 51139 | 376 | 28 |
537428 | 537428 | 2020-09-15 | Patrick | Virginia | 51141 | 255 | 18 |
537429 | 537429 | 2020-09-15 | Petersburg city | Virginia | 51730 | 691 | 24 |
537430 | 537430 | 2020-09-15 | Pittsylvania | Virginia | 51143 | 914 | 7 |
537431 | 537431 | 2020-09-15 | Poquoson city | Virginia | 51735 | 76 | 1 |
537432 | 537432 | 2020-09-15 | Portsmouth city | Virginia | 51740 | 2424 | 46 |
537433 | 537433 | 2020-09-15 | Powhatan | Virginia | 51145 | 207 | 5 |
537434 | 537434 | 2020-09-15 | Prince Edward | Virginia | 51147 | 541 | 12 |
537435 | 537435 | 2020-09-15 | Prince George | Virginia | 51149 | 689 | 4 |
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);