⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

45,531 rows where state = "Virginia" sorted by date descending

View and edit SQL

Suggested facets: date (date)

fips

state

  • Virginia · 45,531
Link rowid date ▲ county state fips cases deaths
1095377 2021-03-06 Accomack Virginia 51001 2621 35
1095378 2021-03-06 Albemarle Virginia 51003 4964 72
1095379 2021-03-06 Alexandria city Virginia 51510 10429 123
1095380 2021-03-06 Alleghany Virginia 51005 1252 47
1095381 2021-03-06 Amelia Virginia 51007 776 22
1095382 2021-03-06 Amherst Virginia 51009 2712 34
1095383 2021-03-06 Appomattox Virginia 51011 1425 19
1095384 2021-03-06 Arlington Virginia 51013 13391 237
1095385 2021-03-06 Augusta Virginia 51015 5242 67
1095386 2021-03-06 Bath Virginia 51017 246 11
1095387 2021-03-06 Bedford Virginia 51019 5835 76
1095388 2021-03-06 Bland Virginia 51021 622 10
1095389 2021-03-06 Botetourt Virginia 51023 2262 29
1095390 2021-03-06 Bristol city Virginia 51520 1229 30
1095391 2021-03-06 Brunswick Virginia 51025 1213 17
1095392 2021-03-06 Buchanan Virginia 51027 1309 35
1095393 2021-03-06 Buckingham Virginia 51029 2047 28
1095394 2021-03-06 Buena Vista city Virginia 51530 846 19
1095395 2021-03-06 Campbell Virginia 51031 4053 64
1095396 2021-03-06 Caroline Virginia 51033 1853 28
1095397 2021-03-06 Carroll Virginia 51035 2139 65
1095398 2021-03-06 Charles City Virginia 51036 412 12
1095399 2021-03-06 Charlotte Virginia 51037 754 14
1095400 2021-03-06 Charlottesville city Virginia 51540 3669 45
1095401 2021-03-06 Chesapeake city Virginia 51550 18491 230
1095402 2021-03-06 Chesterfield Virginia 51041 23881 359
1095403 2021-03-06 Clarke Virginia 51043 781 19
1095404 2021-03-06 Colonial Heights city Virginia 51570 1407 48
1095405 2021-03-06 Covington city Virginia 51580 551 11
1095406 2021-03-06 Craig Virginia 51045 246 6
1095407 2021-03-06 Culpeper Virginia 51047 4121 55
1095408 2021-03-06 Cumberland Virginia 51049 396 7
1095409 2021-03-06 Danville city Virginia 51590 4381 112
1095410 2021-03-06 Dickenson Virginia 51051 878 15
1095411 2021-03-06 Dinwiddie Virginia 51053 1839 34
1095412 2021-03-06 Emporia city Virginia 51595 622 41
1095413 2021-03-06 Essex Virginia 51057 645 7
1095414 2021-03-06 Fairfax Virginia 51059 67533 995
1095415 2021-03-06 Fairfax city Virginia 51600 498 14
1095416 2021-03-06 Falls Church city Virginia 51610 358 8
1095417 2021-03-06 Fauquier Virginia 51061 4007 56
1095418 2021-03-06 Floyd Virginia 51063 750 19
1095419 2021-03-06 Fluvanna Virginia 51065 1307 16
1095420 2021-03-06 Franklin Virginia 51067 3736 60
1095421 2021-03-06 Franklin city Virginia 51620 1019 27
1095422 2021-03-06 Frederick Virginia 51069 6834 87
1095423 2021-03-06 Fredericksburg city Virginia 51630 1790 22
1095424 2021-03-06 Galax city Virginia 51640 1000 50
1095425 2021-03-06 Giles Virginia 51071 1091 16
1095426 2021-03-06 Gloucester Virginia 51073 1907 43
1095427 2021-03-06 Goochland Virginia 51075 1230 17
1095428 2021-03-06 Grayson Virginia 51077 1135 34
1095429 2021-03-06 Greene Virginia 51079 1017 9
1095430 2021-03-06 Greensville Virginia 51081 1466 25
1095431 2021-03-06 Halifax Virginia 51083 2485 65
1095432 2021-03-06 Hampton city Virginia 51650 8794 129
1095433 2021-03-06 Hanover Virginia 51085 6797 138
1095434 2021-03-06 Harrisonburg city Virginia 51660 5794 89
1095435 2021-03-06 Henrico Virginia 51087 21712 538
1095436 2021-03-06 Henry Virginia 51089 4237 117
1095437 2021-03-06 Highland Virginia 51091 97 1
1095438 2021-03-06 Hopewell city Virginia 51670 2156 56
1095439 2021-03-06 Isle of Wight Virginia 51093 2686 58
1095440 2021-03-06 James City Virginia 51095 3916 64
1095441 2021-03-06 King George Virginia 51099 1424 16
1095442 2021-03-06 King William Virginia 51101 945 10
1095443 2021-03-06 King and Queen Virginia 51097 319 6
1095444 2021-03-06 Lancaster Virginia 51103 671 13
1095445 2021-03-06 Lee Virginia 51105 2309 42
1095446 2021-03-06 Lexington city Virginia 51678 1125 26
1095447 2021-03-06 Loudoun Virginia 51107 23418 252
1095448 2021-03-06 Louisa Virginia 51109 1693 25
1095449 2021-03-06 Lunenburg Virginia 51111 669 6
1095450 2021-03-06 Lynchburg city Virginia 51680 6945 133
1095451 2021-03-06 Madison Virginia 51113 536 14
1095452 2021-03-06 Manassas Park city Virginia 51685 1129 12
1095453 2021-03-06 Manassas city Virginia 51683 4046 41
1095454 2021-03-06 Martinsville city Virginia 51690 1512 66
1095455 2021-03-06 Mathews Virginia 51115 556 11
1095456 2021-03-06 Mecklenburg Virginia 51117 2021 58
1095457 2021-03-06 Middlesex Virginia 51119 528 18
1095458 2021-03-06 Montgomery Virginia 51121 8046 86
1095459 2021-03-06 Nelson Virginia 51125 810 9
1095460 2021-03-06 New Kent Virginia 51127 1262 13
1095461 2021-03-06 Newport News city Virginia 51700 11708 190
1095462 2021-03-06 Norfolk city Virginia 51710 15125 214
1095463 2021-03-06 Northampton Virginia 51131 726 34
1095464 2021-03-06 Northumberland Virginia 51133 674 20
1095465 2021-03-06 Norton city Virginia 51720 241 6
1095466 2021-03-06 Nottoway Virginia 51135 1821 41
1095467 2021-03-06 Orange Virginia 51137 1871 33
1095468 2021-03-06 Page Virginia 51139 1841 53
1095469 2021-03-06 Patrick Virginia 51141 1225 37
1095470 2021-03-06 Petersburg city Virginia 51730 3236 65
1095471 2021-03-06 Pittsylvania Virginia 51143 4769 69
1095472 2021-03-06 Poquoson city Virginia 51735 731 15
1095473 2021-03-06 Portsmouth city Virginia 51740 7814 149
1095474 2021-03-06 Powhatan Virginia 51145 1665 10
1095475 2021-03-06 Prince Edward Virginia 51147 1972 29
1095476 2021-03-06 Prince George Virginia 51149 3037 18

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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]);