ny_times_us_counties

Table actions
⚠️ 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

75,192 rows where state = "Virginia" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips

state

  • Virginia · 75,192 ✖
Link rowid date ▲ county state fips cases deaths
1819541 1819541 2021-10-15 Accomack Virginia 51001 3970 74
1819542 1819542 2021-10-15 Albemarle Virginia 51003 7834 95
1819543 1819543 2021-10-15 Alexandria city Virginia 51510 14019 148
1819544 1819544 2021-10-15 Alleghany Virginia 51005 2058 65
1819545 1819545 2021-10-15 Amelia Virginia 51007 1372 39
1819546 1819546 2021-10-15 Amherst Virginia 51009 4252 55
1819547 1819547 2021-10-15 Appomattox Virginia 51011 2335 36
1819548 1819548 2021-10-15 Arlington Virginia 51013 18265 269
1819549 1819549 2021-10-15 Augusta Virginia 51015 9884 114
1819550 1819550 2021-10-15 Bath Virginia 51017 452 14
1819551 1819551 2021-10-15 Bedford Virginia 51019 9670 144
1819552 1819552 2021-10-15 Bland Virginia 51021 1045 15
1819553 1819553 2021-10-15 Botetourt Virginia 51023 3703 45
1819554 1819554 2021-10-15 Bristol city Virginia 51520 2222 47
1819555 1819555 2021-10-15 Brunswick Virginia 51025 1765 32
1819556 1819556 2021-10-15 Buchanan Virginia 51027 2309 57
1819557 1819557 2021-10-15 Buckingham Virginia 51029 2604 37
1819558 1819558 2021-10-15 Buena Vista city Virginia 51530 1261 23
1819559 1819559 2021-10-15 Campbell Virginia 51031 6967 132
1819560 1819560 2021-10-15 Caroline Virginia 51033 3776 49
1819561 1819561 2021-10-15 Carroll Virginia 51035 3795 90
1819562 1819562 2021-10-15 Charles City Virginia 51036 670 19
1819563 1819563 2021-10-15 Charlotte Virginia 51037 1239 25
1819564 1819564 2021-10-15 Charlottesville city Virginia 51540 5248 59
1819565 1819565 2021-10-15 Chesapeake city Virginia 51550 28299 350
1819566 1819566 2021-10-15 Chesterfield Virginia 51041 38728 526
1819567 1819567 2021-10-15 Clarke Virginia 51043 1319 22
1819568 1819568 2021-10-15 Colonial Heights city Virginia 51570 2548 64
1819569 1819569 2021-10-15 Covington city Virginia 51580 741 15
1819570 1819570 2021-10-15 Craig Virginia 51045 527 6
1819571 1819571 2021-10-15 Culpeper Virginia 51047 6296 79
1819572 1819572 2021-10-15 Cumberland Virginia 51049 702 16
1819573 1819573 2021-10-15 Danville city Virginia 51590 6121 180
1819574 1819574 2021-10-15 Dickenson Virginia 51051 1568 26
1819575 1819575 2021-10-15 Dinwiddie Virginia 51053 3054 51
1819576 1819576 2021-10-15 Emporia city Virginia 51595 863 42
1819577 1819577 2021-10-15 Essex Virginia 51057 1211 17
1819578 1819578 2021-10-15 Fairfax Virginia 51059 90382 1170
1819579 1819579 2021-10-15 Fairfax city Virginia 51600 643 20
1819580 1819580 2021-10-15 Falls Church city Virginia 51610 540 8
1819581 1819581 2021-10-15 Fauquier Virginia 51061 6776 83
1819582 1819582 2021-10-15 Floyd Virginia 51063 1368 28
1819583 1819583 2021-10-15 Fluvanna Virginia 51065 2542 21
1819584 1819584 2021-10-15 Franklin Virginia 51067 5840 98
1819585 1819585 2021-10-15 Franklin city Virginia 51620 1593 41
1819586 1819586 2021-10-15 Frederick Virginia 51069 11285 138
1819587 1819587 2021-10-15 Fredericksburg city Virginia 51630 3007 25
1819588 1819588 2021-10-15 Galax city Virginia 51640 1487 61
1819589 1819589 2021-10-15 Giles Virginia 51071 2187 29
1819590 1819590 2021-10-15 Gloucester Virginia 51073 3781 72
1819591 1819591 2021-10-15 Goochland Virginia 51075 1955 29
1819592 1819592 2021-10-15 Grayson Virginia 51077 2014 45
1819593 1819593 2021-10-15 Greene Virginia 51079 2163 32
1819594 1819594 2021-10-15 Greensville Virginia 51081 1861 26
1819595 1819595 2021-10-15 Halifax Virginia 51083 3786 101
1819596 1819596 2021-10-15 Hampton city Virginia 51650 14750 236
1819597 1819597 2021-10-15 Hanover Virginia 51085 11479 191
1819598 1819598 2021-10-15 Harrisonburg city Virginia 51660 8128 103
1819599 1819599 2021-10-15 Henrico Virginia 51087 33701 703
1819600 1819600 2021-10-15 Henry Virginia 51089 6248 147
1819601 1819601 2021-10-15 Highland Virginia 51091 168 2
1819602 1819602 2021-10-15 Hopewell city Virginia 51670 3632 85
1819603 1819603 2021-10-15 Isle of Wight Virginia 51093 4350 83
1819604 1819604 2021-10-15 James City Virginia 51095 6859 92
1819605 1819605 2021-10-15 King George Virginia 51099 2533 22
1819606 1819606 2021-10-15 King William Virginia 51101 1857 24
1819607 1819607 2021-10-15 King and Queen Virginia 51097 607 8
1819608 1819608 2021-10-15 Lancaster Virginia 51103 1046 21
1819609 1819609 2021-10-15 Lee Virginia 51105 3605 57
1819610 1819610 2021-10-15 Lexington city Virginia 51678 1540 34
1819611 1819611 2021-10-15 Loudoun Virginia 51107 33536 294
1819612 1819612 2021-10-15 Louisa Virginia 51109 3098 44
1819613 1819613 2021-10-15 Lunenburg Virginia 51111 1051 19
1819614 1819614 2021-10-15 Lynchburg city Virginia 51680 11594 184
1819615 1819615 2021-10-15 Madison Virginia 51113 960 20
1819616 1819616 2021-10-15 Manassas Park city Virginia 51685 1264 12
1819617 1819617 2021-10-15 Manassas city Virginia 51683 5018 51
1819618 1819618 2021-10-15 Martinsville city Virginia 51690 1989 87
1819619 1819619 2021-10-15 Mathews Virginia 51115 874 20
1819620 1819620 2021-10-15 Mecklenburg Virginia 51117 3320 81
1819621 1819621 2021-10-15 Middlesex Virginia 51119 931 28
1819622 1819622 2021-10-15 Montgomery Virginia 51121 11577 100
1819623 1819623 2021-10-15 Nelson Virginia 51125 1304 16
1819624 1819624 2021-10-15 New Kent Virginia 51127 2310 22
1819625 1819625 2021-10-15 Newport News city Virginia 51700 20193 288
1819626 1819626 2021-10-15 Norfolk city Virginia 51710 23974 326
1819627 1819627 2021-10-15 Northampton Virginia 51131 1135 41
1819628 1819628 2021-10-15 Northumberland Virginia 51133 1182 30
1819629 1819629 2021-10-15 Norton city Virginia 51720 544 13
1819630 1819630 2021-10-15 Nottoway Virginia 51135 2544 64
1819631 1819631 2021-10-15 Orange Virginia 51137 3563 51
1819632 1819632 2021-10-15 Page Virginia 51139 3263 73
1819633 1819633 2021-10-15 Patrick Virginia 51141 1967 55
1819634 1819634 2021-10-15 Petersburg city Virginia 51730 5158 106
1819635 1819635 2021-10-15 Pittsylvania Virginia 51143 7884 105
1819636 1819636 2021-10-15 Poquoson city Virginia 51735 1308 19
1819637 1819637 2021-10-15 Portsmouth city Virginia 51740 12376 233
1819638 1819638 2021-10-15 Powhatan Virginia 51145 2734 27
1819639 1819639 2021-10-15 Prince Edward Virginia 51147 2886 50
1819640 1819640 2021-10-15 Prince George Virginia 51149 4858 38

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