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

103,128 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 >30

state 1

  • Virginia · 103,128 ✖
Link rowid date ▲ county state fips cases deaths
2502510 2502510 2022-05-13 Accomack Virginia 51001 7054 106
2502511 2502511 2022-05-13 Albemarle Virginia 51003 18671 163
2502512 2502512 2022-05-13 Alexandria city Virginia 51510 32647 188
2502513 2502513 2022-05-13 Alleghany Virginia 51005 3364 98
2502514 2502514 2022-05-13 Amelia Virginia 51007 2683 61
2502515 2502515 2022-05-13 Amherst Virginia 51009 7316 89
2502516 2502516 2022-05-13 Appomattox Virginia 51011 3817 53
2502517 2502517 2022-05-13 Arlington Virginia 51013 46198 322
2502518 2502518 2022-05-13 Augusta Virginia 51015 18922 206
2502519 2502519 2022-05-13 Bath Virginia 51017 906 20
2502520 2502520 2022-05-13 Bedford Virginia 51019 17276 240
2502521 2502521 2022-05-13 Bland Virginia 51021 1800 24
2502522 2502522 2022-05-13 Botetourt Virginia 51023 7607 101
2502523 2502523 2022-05-13 Bristol city Virginia 51520 4454 80
2502524 2502524 2022-05-13 Brunswick Virginia 51025 3284 47
2502525 2502525 2022-05-13 Buchanan Virginia 51027 4895 122
2502526 2502526 2022-05-13 Buckingham Virginia 51029 3993 56
2502527 2502527 2022-05-13 Buena Vista city Virginia 51530 2017 44
2502528 2502528 2022-05-13 Campbell Virginia 51031 12814 215
2502529 2502529 2022-05-13 Caroline Virginia 51033 6976 85
2502530 2502530 2022-05-13 Carroll Virginia 51035 6747 148
2502531 2502531 2022-05-13 Charles City Virginia 51036 1191 27
2502532 2502532 2022-05-13 Charlotte Virginia 51037 2540 45
2502533 2502533 2022-05-13 Charlottesville city Virginia 51540 9466 74
2502534 2502534 2022-05-13 Chesapeake city Virginia 51550 51025 497
2502535 2502535 2022-05-13 Chesterfield Virginia 51041 75487 760
2502536 2502536 2022-05-13 Clarke Virginia 51043 2679 42
2502537 2502537 2022-05-13 Colonial Heights city Virginia 51570 4958 97
2502538 2502538 2022-05-13 Covington city Virginia 51580 1299 26
2502539 2502539 2022-05-13 Craig Virginia 51045 1128 18
2502540 2502540 2022-05-13 Culpeper Virginia 51047 11497 149
2502541 2502541 2022-05-13 Cumberland Virginia 51049 1366 27
2502542 2502542 2022-05-13 Danville city Virginia 51590 11226 282
2502543 2502543 2022-05-13 Dickenson Virginia 51051 3321 49
2502544 2502544 2022-05-13 Dinwiddie Virginia 51053 5442 93
2502545 2502545 2022-05-13 Emporia city Virginia 51595 1187 55
2502546 2502546 2022-05-13 Essex Virginia 51057 2285 33
2502547 2502547 2022-05-13 Fairfax Virginia 51059 188156 1453
2502548 2502548 2022-05-13 Fairfax city Virginia 51600 2056 43
2502549 2502549 2022-05-13 Falls Church city Virginia 51610 2226 17
2502550 2502550 2022-05-13 Fauquier Virginia 51061 13267 144
2502551 2502551 2022-05-13 Floyd Virginia 51063 2587 49
2502552 2502552 2022-05-13 Fluvanna Virginia 51065 5260 46
2502553 2502553 2022-05-13 Franklin Virginia 51067 10984 198
2502554 2502554 2022-05-13 Franklin city Virginia 51620 2395 52
2502555 2502555 2022-05-13 Frederick Virginia 51069 20904 249
2502556 2502556 2022-05-13 Fredericksburg city Virginia 51630 5498 42
2502557 2502557 2022-05-13 Galax city Virginia 51640 2561 78
2502558 2502558 2022-05-13 Giles Virginia 51071 4115 50
2502559 2502559 2022-05-13 Gloucester Virginia 51073 7453 104
2502560 2502560 2022-05-13 Goochland Virginia 51075 4153 53
2502561 2502561 2022-05-13 Grayson Virginia 51077 4059 83
2502562 2502562 2022-05-13 Greene Virginia 51079 4074 62
2502563 2502563 2022-05-13 Greensville Virginia 51081 3341 40
2502564 2502564 2022-05-13 Halifax Virginia 51083 7217 159
2502565 2502565 2022-05-13 Hampton city Virginia 51650 28527 330
2502566 2502566 2022-05-13 Hanover Virginia 51085 22386 286
2502567 2502567 2022-05-13 Harrisonburg city Virginia 51660 13492 160
2502568 2502568 2022-05-13 Henrico Virginia 51087 67513 934
2502569 2502569 2022-05-13 Henry Virginia 51089 12205 266
2502570 2502570 2022-05-13 Highland Virginia 51091 387 7
2502571 2502571 2022-05-13 Hopewell city Virginia 51670 6141 118
2502572 2502572 2022-05-13 Isle of Wight Virginia 51093 7395 119
2502573 2502573 2022-05-13 James City Virginia 51095 15461 121
2502574 2502574 2022-05-13 King George Virginia 51099 5119 39
2502575 2502575 2022-05-13 King William Virginia 51101 3767 43
2502576 2502576 2022-05-13 King and Queen Virginia 51097 1146 12
2502577 2502577 2022-05-13 Lancaster Virginia 51103 1846 31
2502578 2502578 2022-05-13 Lee Virginia 51105 6185 93
2502579 2502579 2022-05-13 Lexington city Virginia 51678 2857 40
2502580 2502580 2022-05-13 Loudoun Virginia 51107 71890 383
2502581 2502581 2022-05-13 Louisa Virginia 51109 6842 85
2502582 2502582 2022-05-13 Lunenburg Virginia 51111 2460 39
2502583 2502583 2022-05-13 Lynchburg city Virginia 51680 19760 267
2502584 2502584 2022-05-13 Madison Virginia 51113 2451 41
2502585 2502585 2022-05-13 Manassas Park city Virginia 51685 3828 27
2502586 2502586 2022-05-13 Manassas city Virginia 51683 9281 71
2502587 2502587 2022-05-13 Martinsville city Virginia 51690 3478 124
2502588 2502588 2022-05-13 Mathews Virginia 51115 1524 27
2502589 2502589 2022-05-13 Mecklenburg Virginia 51117 6217 123
2502590 2502590 2022-05-13 Middlesex Virginia 51119 1874 48
2502591 2502591 2022-05-13 Montgomery Virginia 51121 19403 154
2502592 2502592 2022-05-13 Nelson Virginia 51125 2589 36
2502593 2502593 2022-05-13 New Kent Virginia 51127 4742 32
2502594 2502594 2022-05-13 Newport News city Virginia 51700 37189 404
2502595 2502595 2022-05-13 Norfolk city Virginia 51710 43091 476
2502596 2502596 2022-05-13 Northampton Virginia 51131 2183 65
2502597 2502597 2022-05-13 Northumberland Virginia 51133 2216 46
2502598 2502598 2022-05-13 Norton city Virginia 51720 1310 22
2502599 2502599 2022-05-13 Nottoway Virginia 51135 4300 92
2502600 2502600 2022-05-13 Orange Virginia 51137 6928 86
2502601 2502601 2022-05-13 Page Virginia 51139 5660 122
2502602 2502602 2022-05-13 Patrick Virginia 51141 3706 98
2502603 2502603 2022-05-13 Petersburg city Virginia 51730 8297 140
2502604 2502604 2022-05-13 Pittsylvania Virginia 51143 14301 199
2502605 2502605 2022-05-13 Poquoson city Virginia 51735 2388 30
2502606 2502606 2022-05-13 Portsmouth city Virginia 51740 21144 338
2502607 2502607 2022-05-13 Powhatan Virginia 51145 5257 59
2502608 2502608 2022-05-13 Prince Edward Virginia 51147 5107 71
2502609 2502609 2022-05-13 Prince George Virginia 51149 8917 79

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