ny_times_us_counties

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

12,808 rows where state = "Virginia" sorted by date descending

View and edit SQL

fips

state

  • Virginia · 12,808
Link rowid date ▲ county state fips cases deaths
294523 2020-07-03 Accomack Virginia 51001 1042 14
294524 2020-07-03 Albemarle Virginia 51003 420 9
294525 2020-07-03 Alexandria city Virginia 51510 2338 57
294526 2020-07-03 Alleghany Virginia 51005 34 2
294527 2020-07-03 Amelia Virginia 51007 45 1
294528 2020-07-03 Amherst Virginia 51009 37 0
294529 2020-07-03 Appomattox Virginia 51011 43 0
294530 2020-07-03 Arlington Virginia 51013 2500 132
294531 2020-07-03 Augusta Virginia 51015 190 2
294532 2020-07-03 Bedford Virginia 51019 131 3
294533 2020-07-03 Bland Virginia 51021 2 0
294534 2020-07-03 Botetourt Virginia 51023 133 4
294535 2020-07-03 Bristol city Virginia 51520 5 0
294536 2020-07-03 Brunswick Virginia 51025 107 1
294537 2020-07-03 Buchanan Virginia 51027 31 0
294538 2020-07-03 Buckingham Virginia 51029 566 4
294539 2020-07-03 Buena Vista city Virginia 51530 16 0
294540 2020-07-03 Campbell Virginia 51031 48 1
294541 2020-07-03 Caroline Virginia 51033 128 4
294542 2020-07-03 Carroll Virginia 51035 225 9
294543 2020-07-03 Charles City Virginia 51036 41 3
294544 2020-07-03 Charlotte Virginia 51037 33 0
294545 2020-07-03 Charlottesville city Virginia 51540 220 6
294546 2020-07-03 Chesapeake city Virginia 51550 972 21
294547 2020-07-03 Chesterfield Virginia 51041 2974 53
294548 2020-07-03 Clarke Virginia 51043 54 0
294549 2020-07-03 Colonial Heights city Virginia 51570 145 18
294550 2020-07-03 Covington city Virginia 51580 5 0
294551 2020-07-03 Craig Virginia 51045 7 0
294552 2020-07-03 Culpeper Virginia 51047 814 11
294553 2020-07-03 Cumberland Virginia 51049 57 0
294554 2020-07-03 Danville city Virginia 51590 91 2
294555 2020-07-03 Dickenson Virginia 51051 5 0
294556 2020-07-03 Dinwiddie Virginia 51053 148 2
294557 2020-07-03 Emporia city Virginia 51595 141 15
294558 2020-07-03 Essex Virginia 51057 59 0
294559 2020-07-03 Fairfax Virginia 51059 13965 494
294560 2020-07-03 Fairfax city Virginia 51600 70 7
294561 2020-07-03 Falls Church city Virginia 51610 54 8
294562 2020-07-03 Fauquier Virginia 51061 427 7
294563 2020-07-03 Floyd Virginia 51063 19 1
294564 2020-07-03 Fluvanna Virginia 51065 116 8
294565 2020-07-03 Franklin Virginia 51067 92 1
294566 2020-07-03 Franklin city Virginia 51620 52 2
294567 2020-07-03 Frederick Virginia 51069 517 6
294568 2020-07-03 Fredericksburg city Virginia 51630 254 0
294569 2020-07-03 Galax city Virginia 51640 263 15
294570 2020-07-03 Giles Virginia 51071 17 0
294571 2020-07-03 Gloucester Virginia 51073 49 1
294572 2020-07-03 Goochland Virginia 51075 126 6
294573 2020-07-03 Grayson Virginia 51077 87 2
294574 2020-07-03 Greene Virginia 51079 67 1
294575 2020-07-03 Greensville Virginia 51081 366 7
294576 2020-07-03 Halifax Virginia 51083 59 1
294577 2020-07-03 Hampton city Virginia 51650 354 5
294578 2020-07-03 Hanover Virginia 51085 442 29
294579 2020-07-03 Harrisonburg city Virginia 51660 957 27
294580 2020-07-03 Henrico Virginia 51087 2629 157
294581 2020-07-03 Henry Virginia 51089 280 4
294582 2020-07-03 Highland Virginia 51091 3 0
294583 2020-07-03 Hopewell city Virginia 51670 184 2
294584 2020-07-03 Isle of Wight Virginia 51093 186 9
294585 2020-07-03 James City Virginia 51095 270 15
294586 2020-07-03 King George Virginia 51099 99 4
294587 2020-07-03 King William Virginia 51101 42 0
294588 2020-07-03 King and Queen Virginia 51097 24 1
294589 2020-07-03 Lancaster Virginia 51103 11 0
294590 2020-07-03 Lee Virginia 51105 12 0
294591 2020-07-03 Lexington city Virginia 51678 11 0
294592 2020-07-03 Loudoun Virginia 51107 4113 91
294593 2020-07-03 Louisa Virginia 51109 119 1
294594 2020-07-03 Lunenburg Virginia 51111 37 0
294595 2020-07-03 Lynchburg city Virginia 51680 159 1
294596 2020-07-03 Madison Virginia 51113 43 1
294597 2020-07-03 Manassas Park city Virginia 51685 434 6
294598 2020-07-03 Manassas city Virginia 51683 1430 18
294599 2020-07-03 Mathews Virginia 51115 6 0
294600 2020-07-03 Mecklenburg Virginia 51117 248 28
294601 2020-07-03 Middlesex Virginia 51119 15 0
294602 2020-07-03 Montgomery Virginia 51121 154 2
294603 2020-07-03 Nelson Virginia 51125 18 0
294604 2020-07-03 New Kent Virginia 51127 60 1
294605 2020-07-03 Newport News city Virginia 51700 549 10
294606 2020-07-03 Norfolk city Virginia 51710 1000 11
294607 2020-07-03 Northampton Virginia 51131 271 28
294608 2020-07-03 Northumberland Virginia 51133 36 1
294609 2020-07-03 Norton city Virginia 51720 4 0
294610 2020-07-03 Nottoway Virginia 51135 114 2
294611 2020-07-03 Orange Virginia 51137 152 3
294612 2020-07-03 Page Virginia 51139 281 23
294613 2020-07-03 Patrick Virginia 51141 48 1
294614 2020-07-03 Petersburg city Virginia 51730 256 5
294615 2020-07-03 Pittsylvania Virginia 51143 132 1
294616 2020-07-03 Poquoson city Virginia 51735 19 0
294617 2020-07-03 Portsmouth city Virginia 51740 526 18
294618 2020-07-03 Powhatan Virginia 51145 84 2
294619 2020-07-03 Prince Edward Virginia 51147 213 6
294620 2020-07-03 Prince George Virginia 51149 243 1
294621 2020-07-03 Prince William Virginia 51153 7442 146
294622 2020-07-03 Pulaski Virginia 51155 48 2

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
);
Powered by Datasette · Query took 1039.595ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette