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 214
- 51810 212
- 51107 211
- 51013 210
- 51085 209
- 51095 209
- 51147 209
- 51153 209
- 51510 209
- 51660 208
- 51041 207
- 51177 207
- 51179 205
- 51199 205
- 51075 204
- 51087 204
- 51540 204
- 51830 204
- 51036 203
- 51760 203
- 51001 201
- 51073 201
- 51700 201
- 51710 201
- 51740 201
- 51003 200
- 51023 200
- 51067 200
- 51093 200
- 51117 200
- …
county >30
- Fairfax 214
- Virginia Beach city 212
- Loudoun 211
- Arlington 210
- Alexandria city 209
- Hanover 209
- James City 209
- Prince Edward 209
- Prince William 209
- Harrisonburg city 208
- Chesterfield 207
- Spotsylvania 207
- Stafford 205
- York 205
- Charlottesville city 204
- Goochland 204
- Henrico 204
- Williamsburg city 204
- Charles City 203
- Richmond city 203
- Accomack 201
- Gloucester 201
- Newport News city 201
- Norfolk city 201
- Portsmouth city 201
- Albemarle 200
- Botetourt 200
- Franklin 200
- Isle of Wight 200
- Mecklenburg 200
- …
state 1
- Virginia · 25,448 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
605375 | 605375 | 2020-10-06 | Accomack | Virginia | 51001 | 1188 | 19 |
605376 | 605376 | 2020-10-06 | Albemarle | Virginia | 51003 | 1385 | 22 |
605377 | 605377 | 2020-10-06 | Alexandria city | Virginia | 51510 | 3932 | 71 |
605378 | 605378 | 2020-10-06 | Alleghany | Virginia | 51005 | 81 | 4 |
605379 | 605379 | 2020-10-06 | Amelia | Virginia | 51007 | 126 | 5 |
605380 | 605380 | 2020-10-06 | Amherst | Virginia | 51009 | 433 | 4 |
605381 | 605381 | 2020-10-06 | Appomattox | Virginia | 51011 | 227 | 3 |
605382 | 605382 | 2020-10-06 | Arlington | Virginia | 51013 | 4068 | 152 |
605383 | 605383 | 2020-10-06 | Augusta | Virginia | 51015 | 535 | 7 |
605384 | 605384 | 2020-10-06 | Bath | Virginia | 51017 | 16 | 0 |
605385 | 605385 | 2020-10-06 | Bedford | Virginia | 51019 | 862 | 15 |
605386 | 605386 | 2020-10-06 | Bland | Virginia | 51021 | 64 | 5 |
605387 | 605387 | 2020-10-06 | Botetourt | Virginia | 51023 | 315 | 10 |
605388 | 605388 | 2020-10-06 | Bristol city | Virginia | 51520 | 198 | 7 |
605389 | 605389 | 2020-10-06 | Brunswick | Virginia | 51025 | 374 | 5 |
605390 | 605390 | 2020-10-06 | Buchanan | Virginia | 51027 | 181 | 2 |
605391 | 605391 | 2020-10-06 | Buckingham | Virginia | 51029 | 702 | 9 |
605392 | 605392 | 2020-10-06 | Buena Vista city | Virginia | 51530 | 92 | 1 |
605393 | 605393 | 2020-10-06 | Campbell | Virginia | 51031 | 494 | 4 |
605394 | 605394 | 2020-10-06 | Caroline | Virginia | 51033 | 370 | 5 |
605395 | 605395 | 2020-10-06 | Carroll | Virginia | 51035 | 516 | 24 |
605396 | 605396 | 2020-10-06 | Charles City | Virginia | 51036 | 86 | 5 |
605397 | 605397 | 2020-10-06 | Charlotte | Virginia | 51037 | 146 | 0 |
605398 | 605398 | 2020-10-06 | Charlottesville city | Virginia | 51540 | 1383 | 30 |
605399 | 605399 | 2020-10-06 | Chesapeake city | Virginia | 51550 | 4448 | 73 |
605400 | 605400 | 2020-10-06 | Chesterfield | Virginia | 51041 | 6192 | 98 |
605401 | 605401 | 2020-10-06 | Clarke | Virginia | 51043 | 99 | 1 |
605402 | 605402 | 2020-10-06 | Colonial Heights city | Virginia | 51570 | 268 | 26 |
605403 | 605403 | 2020-10-06 | Covington city | Virginia | 51580 | 33 | 0 |
605404 | 605404 | 2020-10-06 | Craig | Virginia | 51045 | 31 | 0 |
605405 | 605405 | 2020-10-06 | Culpeper | Virginia | 51047 | 1228 | 17 |
605406 | 605406 | 2020-10-06 | Cumberland | Virginia | 51049 | 109 | 2 |
605407 | 605407 | 2020-10-06 | Danville city | Virginia | 51590 | 961 | 32 |
605408 | 605408 | 2020-10-06 | Dickenson | Virginia | 51051 | 104 | 1 |
605409 | 605409 | 2020-10-06 | Dinwiddie | Virginia | 51053 | 421 | 11 |
605410 | 605410 | 2020-10-06 | Emporia city | Virginia | 51595 | 261 | 26 |
605411 | 605411 | 2020-10-06 | Essex | Virginia | 51057 | 183 | 2 |
605412 | 605412 | 2020-10-06 | Fairfax | Virginia | 51059 | 21414 | 592 |
605413 | 605413 | 2020-10-06 | Fairfax city | Virginia | 51600 | 140 | 8 |
605414 | 605414 | 2020-10-06 | Falls Church city | Virginia | 51610 | 72 | 7 |
605415 | 605415 | 2020-10-06 | Fauquier | Virginia | 51061 | 976 | 25 |
605416 | 605416 | 2020-10-06 | Floyd | Virginia | 51063 | 214 | 13 |
605417 | 605417 | 2020-10-06 | Fluvanna | Virginia | 51065 | 385 | 9 |
605418 | 605418 | 2020-10-06 | Franklin | Virginia | 51067 | 431 | 4 |
605419 | 605419 | 2020-10-06 | Franklin city | Virginia | 51620 | 437 | 10 |
605420 | 605420 | 2020-10-06 | Frederick | Virginia | 51069 | 954 | 13 |
605421 | 605421 | 2020-10-06 | Fredericksburg city | Virginia | 51630 | 553 | 5 |
605422 | 605422 | 2020-10-06 | Galax city | Virginia | 51640 | 421 | 30 |
605423 | 605423 | 2020-10-06 | Giles | Virginia | 51071 | 94 | 0 |
605424 | 605424 | 2020-10-06 | Gloucester | Virginia | 51073 | 265 | 2 |
605425 | 605425 | 2020-10-06 | Goochland | Virginia | 51075 | 287 | 7 |
605426 | 605426 | 2020-10-06 | Grayson | Virginia | 51077 | 325 | 17 |
605427 | 605427 | 2020-10-06 | Greene | Virginia | 51079 | 241 | 3 |
605428 | 605428 | 2020-10-06 | Greensville | Virginia | 51081 | 806 | 11 |
605429 | 605429 | 2020-10-06 | Halifax | Virginia | 51083 | 384 | 7 |
605430 | 605430 | 2020-10-06 | Hampton city | Virginia | 51650 | 1896 | 27 |
605431 | 605431 | 2020-10-06 | Hanover | Virginia | 51085 | 1395 | 39 |
605432 | 605432 | 2020-10-06 | Harrisonburg city | Virginia | 51660 | 2739 | 34 |
605433 | 605433 | 2020-10-06 | Henrico | Virginia | 51087 | 5608 | 219 |
605434 | 605434 | 2020-10-06 | Henry | Virginia | 51089 | 1113 | 25 |
605435 | 605435 | 2020-10-06 | Highland | Virginia | 51091 | 8 | 0 |
605436 | 605436 | 2020-10-06 | Hopewell city | Virginia | 51670 | 421 | 7 |
605437 | 605437 | 2020-10-06 | Isle of Wight | Virginia | 51093 | 777 | 20 |
605438 | 605438 | 2020-10-06 | James City | Virginia | 51095 | 868 | 21 |
605439 | 605439 | 2020-10-06 | King George | Virginia | 51099 | 241 | 4 |
605440 | 605440 | 2020-10-06 | King William | Virginia | 51101 | 167 | 2 |
605441 | 605441 | 2020-10-06 | King and Queen | Virginia | 51097 | 78 | 1 |
605442 | 605442 | 2020-10-06 | Lancaster | Virginia | 51103 | 161 | 0 |
605443 | 605443 | 2020-10-06 | Lee | Virginia | 51105 | 306 | 7 |
605444 | 605444 | 2020-10-06 | Lexington city | Virginia | 51678 | 133 | 1 |
605445 | 605445 | 2020-10-06 | Loudoun | Virginia | 51107 | 7026 | 126 |
605446 | 605446 | 2020-10-06 | Louisa | Virginia | 51109 | 314 | 7 |
605447 | 605447 | 2020-10-06 | Lunenburg | Virginia | 51111 | 124 | 3 |
605448 | 605448 | 2020-10-06 | Lynchburg city | Virginia | 51680 | 1573 | 17 |
605449 | 605449 | 2020-10-06 | Madison | Virginia | 51113 | 114 | 3 |
605450 | 605450 | 2020-10-06 | Manassas Park city | Virginia | 51685 | 616 | 8 |
605451 | 605451 | 2020-10-06 | Manassas city | Virginia | 51683 | 1954 | 24 |
605452 | 605452 | 2020-10-06 | Martinsville city | Virginia | 51690 | 404 | 22 |
605453 | 605453 | 2020-10-06 | Mathews | Virginia | 51115 | 92 | 0 |
605454 | 605454 | 2020-10-06 | Mecklenburg | Virginia | 51117 | 807 | 34 |
605455 | 605455 | 2020-10-06 | Middlesex | Virginia | 51119 | 127 | 11 |
605456 | 605456 | 2020-10-06 | Montgomery | Virginia | 51121 | 2165 | 5 |
605457 | 605457 | 2020-10-06 | Nelson | Virginia | 51125 | 110 | 2 |
605458 | 605458 | 2020-10-06 | New Kent | Virginia | 51127 | 229 | 3 |
605459 | 605459 | 2020-10-06 | Newport News city | Virginia | 51700 | 2833 | 49 |
605460 | 605460 | 2020-10-06 | Norfolk city | Virginia | 51710 | 4955 | 79 |
605461 | 605461 | 2020-10-06 | Northampton | Virginia | 51131 | 310 | 31 |
605462 | 605462 | 2020-10-06 | Northumberland | Virginia | 51133 | 183 | 6 |
605463 | 605463 | 2020-10-06 | Norton city | Virginia | 51720 | 39 | 0 |
605464 | 605464 | 2020-10-06 | Nottoway | Virginia | 51135 | 276 | 20 |
605465 | 605465 | 2020-10-06 | Orange | Virginia | 51137 | 345 | 5 |
605466 | 605466 | 2020-10-06 | Page | Virginia | 51139 | 414 | 29 |
605467 | 605467 | 2020-10-06 | Patrick | Virginia | 51141 | 284 | 26 |
605468 | 605468 | 2020-10-06 | Petersburg city | Virginia | 51730 | 779 | 29 |
605469 | 605469 | 2020-10-06 | Pittsylvania | Virginia | 51143 | 1087 | 10 |
605470 | 605470 | 2020-10-06 | Poquoson city | Virginia | 51735 | 76 | 2 |
605471 | 605471 | 2020-10-06 | Portsmouth city | Virginia | 51740 | 2633 | 62 |
605472 | 605472 | 2020-10-06 | Powhatan | Virginia | 51145 | 240 | 5 |
605473 | 605473 | 2020-10-06 | Prince Edward | Virginia | 51147 | 622 | 12 |
605474 | 605474 | 2020-10-06 | Prince George | Virginia | 51149 | 871 | 5 |
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);