ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
133 rows where date = "2021-11-16" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Accomack 1
- Albemarle 1
- Alexandria city 1
- Alleghany 1
- Amelia 1
- Amherst 1
- Appomattox 1
- Arlington 1
- Augusta 1
- Bath 1
- Bedford 1
- Bland 1
- Botetourt 1
- Bristol city 1
- Brunswick 1
- Buchanan 1
- Buckingham 1
- Buena Vista city 1
- Campbell 1
- Caroline 1
- Carroll 1
- Charles City 1
- Charlotte 1
- Charlottesville city 1
- Chesapeake city 1
- Chesterfield 1
- Clarke 1
- Colonial Heights city 1
- Covington city 1
- Craig 1
- …
state 1
- Virginia · 133 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1923521 | 1923521 | 2021-11-16 | Accomack | Virginia | 51001 | 4145 | 80 |
1923522 | 1923522 | 2021-11-16 | Albemarle | Virginia | 51003 | 8279 | 108 |
1923523 | 1923523 | 2021-11-16 | Alexandria city | Virginia | 51510 | 14571 | 153 |
1923524 | 1923524 | 2021-11-16 | Alleghany | Virginia | 51005 | 2200 | 82 |
1923525 | 1923525 | 2021-11-16 | Amelia | Virginia | 51007 | 1506 | 42 |
1923526 | 1923526 | 2021-11-16 | Amherst | Virginia | 51009 | 4448 | 60 |
1923527 | 1923527 | 2021-11-16 | Appomattox | Virginia | 51011 | 2463 | 36 |
1923528 | 1923528 | 2021-11-16 | Arlington | Virginia | 51013 | 19089 | 274 |
1923529 | 1923529 | 2021-11-16 | Augusta | Virginia | 51015 | 10433 | 133 |
1923530 | 1923530 | 2021-11-16 | Bath | Virginia | 51017 | 498 | 15 |
1923531 | 1923531 | 2021-11-16 | Bedford | Virginia | 51019 | 10193 | 162 |
1923532 | 1923532 | 2021-11-16 | Bland | Virginia | 51021 | 1111 | 17 |
1923533 | 1923533 | 2021-11-16 | Botetourt | Virginia | 51023 | 4041 | 54 |
1923534 | 1923534 | 2021-11-16 | Bristol city | Virginia | 51520 | 2327 | 48 |
1923535 | 1923535 | 2021-11-16 | Brunswick | Virginia | 51025 | 1837 | 33 |
1923536 | 1923536 | 2021-11-16 | Buchanan | Virginia | 51027 | 2664 | 71 |
1923537 | 1923537 | 2021-11-16 | Buckingham | Virginia | 51029 | 2714 | 38 |
1923538 | 1923538 | 2021-11-16 | Buena Vista city | Virginia | 51530 | 1382 | 28 |
1923539 | 1923539 | 2021-11-16 | Campbell | Virginia | 51031 | 7408 | 144 |
1923540 | 1923540 | 2021-11-16 | Caroline | Virginia | 51033 | 4119 | 52 |
1923541 | 1923541 | 2021-11-16 | Carroll | Virginia | 51035 | 4158 | 101 |
1923542 | 1923542 | 2021-11-16 | Charles City | Virginia | 51036 | 706 | 21 |
1923543 | 1923543 | 2021-11-16 | Charlotte | Virginia | 51037 | 1335 | 28 |
1923544 | 1923544 | 2021-11-16 | Charlottesville city | Virginia | 51540 | 5423 | 60 |
1923545 | 1923545 | 2021-11-16 | Chesapeake city | Virginia | 51550 | 29279 | 367 |
1923546 | 1923546 | 2021-11-16 | Chesterfield | Virginia | 51041 | 40592 | 559 |
1923547 | 1923547 | 2021-11-16 | Clarke | Virginia | 51043 | 1463 | 26 |
1923548 | 1923548 | 2021-11-16 | Colonial Heights city | Virginia | 51570 | 2638 | 68 |
1923549 | 1923549 | 2021-11-16 | Covington city | Virginia | 51580 | 770 | 18 |
1923550 | 1923550 | 2021-11-16 | Craig | Virginia | 51045 | 583 | 9 |
1923551 | 1923551 | 2021-11-16 | Culpeper | Virginia | 51047 | 6725 | 88 |
1923552 | 1923552 | 2021-11-16 | Cumberland | Virginia | 51049 | 729 | 19 |
1923553 | 1923553 | 2021-11-16 | Danville city | Virginia | 51590 | 6364 | 195 |
1923554 | 1923554 | 2021-11-16 | Dickenson | Virginia | 51051 | 1777 | 28 |
1923555 | 1923555 | 2021-11-16 | Dinwiddie | Virginia | 51053 | 3402 | 58 |
1923556 | 1923556 | 2021-11-16 | Emporia city | Virginia | 51595 | 839 | 45 |
1923557 | 1923557 | 2021-11-16 | Essex | Virginia | 51057 | 1289 | 20 |
1923558 | 1923558 | 2021-11-16 | Fairfax | Virginia | 51059 | 93142 | 1172 |
1923559 | 1923559 | 2021-11-16 | Fairfax city | Virginia | 51600 | 1020 | 35 |
1923560 | 1923560 | 2021-11-16 | Falls Church city | Virginia | 51610 | 681 | 14 |
1923561 | 1923561 | 2021-11-16 | Fauquier | Virginia | 51061 | 7243 | 86 |
1923562 | 1923562 | 2021-11-16 | Floyd | Virginia | 51063 | 1488 | 31 |
1923563 | 1923563 | 2021-11-16 | Fluvanna | Virginia | 51065 | 2824 | 25 |
1923564 | 1923564 | 2021-11-16 | Franklin | Virginia | 51067 | 6223 | 108 |
1923565 | 1923565 | 2021-11-16 | Franklin city | Virginia | 51620 | 1661 | 44 |
1923566 | 1923566 | 2021-11-16 | Frederick | Virginia | 51069 | 11946 | 155 |
1923567 | 1923567 | 2021-11-16 | Fredericksburg city | Virginia | 51630 | 3120 | 26 |
1923568 | 1923568 | 2021-11-16 | Galax city | Virginia | 51640 | 1585 | 64 |
1923569 | 1923569 | 2021-11-16 | Giles | Virginia | 51071 | 2347 | 32 |
1923570 | 1923570 | 2021-11-16 | Gloucester | Virginia | 51073 | 3922 | 79 |
1923571 | 1923571 | 2021-11-16 | Goochland | Virginia | 51075 | 2082 | 31 |
1923572 | 1923572 | 2021-11-16 | Grayson | Virginia | 51077 | 2191 | 48 |
1923573 | 1923573 | 2021-11-16 | Greene | Virginia | 51079 | 2269 | 44 |
1923574 | 1923574 | 2021-11-16 | Greensville | Virginia | 51081 | 1946 | 26 |
1923575 | 1923575 | 2021-11-16 | Halifax | Virginia | 51083 | 4018 | 110 |
1923576 | 1923576 | 2021-11-16 | Hampton city | Virginia | 51650 | 15296 | 244 |
1923577 | 1923577 | 2021-11-16 | Hanover | Virginia | 51085 | 12159 | 199 |
1923578 | 1923578 | 2021-11-16 | Harrisonburg city | Virginia | 51660 | 8366 | 111 |
1923579 | 1923579 | 2021-11-16 | Henrico | Virginia | 51087 | 35075 | 728 |
1923580 | 1923580 | 2021-11-16 | Henry | Virginia | 51089 | 6791 | 169 |
1923581 | 1923581 | 2021-11-16 | Highland | Virginia | 51091 | 188 | 4 |
1923582 | 1923582 | 2021-11-16 | Hopewell city | Virginia | 51670 | 3676 | 88 |
1923583 | 1923583 | 2021-11-16 | Isle of Wight | Virginia | 51093 | 4564 | 91 |
1923584 | 1923584 | 2021-11-16 | James City | Virginia | 51095 | 7205 | 95 |
1923585 | 1923585 | 2021-11-16 | King George | Virginia | 51099 | 2738 | 24 |
1923586 | 1923586 | 2021-11-16 | King William | Virginia | 51101 | 2016 | 24 |
1923587 | 1923587 | 2021-11-16 | King and Queen | Virginia | 51097 | 653 | 8 |
1923588 | 1923588 | 2021-11-16 | Lancaster | Virginia | 51103 | 1074 | 23 |
1923589 | 1923589 | 2021-11-16 | Lee | Virginia | 51105 | 3796 | 61 |
1923590 | 1923590 | 2021-11-16 | Lexington city | Virginia | 51678 | 1609 | 36 |
1923591 | 1923591 | 2021-11-16 | Loudoun | Virginia | 51107 | 34980 | 302 |
1923592 | 1923592 | 2021-11-16 | Louisa | Virginia | 51109 | 3388 | 51 |
1923593 | 1923593 | 2021-11-16 | Lunenburg | Virginia | 51111 | 1187 | 22 |
1923594 | 1923594 | 2021-11-16 | Lynchburg city | Virginia | 51680 | 11863 | 193 |
1923595 | 1923595 | 2021-11-16 | Madison | Virginia | 51113 | 1045 | 23 |
1923596 | 1923596 | 2021-11-16 | Manassas Park city | Virginia | 51685 | 1285 | 14 |
1923597 | 1923597 | 2021-11-16 | Manassas city | Virginia | 51683 | 5177 | 53 |
1923598 | 1923598 | 2021-11-16 | Martinsville city | Virginia | 51690 | 2146 | 89 |
1923599 | 1923599 | 2021-11-16 | Mathews | Virginia | 51115 | 903 | 24 |
1923600 | 1923600 | 2021-11-16 | Mecklenburg | Virginia | 51117 | 3523 | 86 |
1923601 | 1923601 | 2021-11-16 | Middlesex | Virginia | 51119 | 960 | 33 |
1923602 | 1923602 | 2021-11-16 | Montgomery | Virginia | 51121 | 11979 | 110 |
1923603 | 1923603 | 2021-11-16 | Nelson | Virginia | 51125 | 1410 | 19 |
1923604 | 1923604 | 2021-11-16 | New Kent | Virginia | 51127 | 2520 | 26 |
1923605 | 1923605 | 2021-11-16 | Newport News city | Virginia | 51700 | 20913 | 304 |
1923606 | 1923606 | 2021-11-16 | Norfolk city | Virginia | 51710 | 24785 | 353 |
1923607 | 1923607 | 2021-11-16 | Northampton | Virginia | 51131 | 1166 | 46 |
1923608 | 1923608 | 2021-11-16 | Northumberland | Virginia | 51133 | 1234 | 34 |
1923609 | 1923609 | 2021-11-16 | Norton city | Virginia | 51720 | 631 | 15 |
1923610 | 1923610 | 2021-11-16 | Nottoway | Virginia | 51135 | 2642 | 70 |
1923611 | 1923611 | 2021-11-16 | Orange | Virginia | 51137 | 3864 | 60 |
1923612 | 1923612 | 2021-11-16 | Page | Virginia | 51139 | 3478 | 82 |
1923613 | 1923613 | 2021-11-16 | Patrick | Virginia | 51141 | 2193 | 58 |
1923614 | 1923614 | 2021-11-16 | Petersburg city | Virginia | 51730 | 5072 | 103 |
1923615 | 1923615 | 2021-11-16 | Pittsylvania | Virginia | 51143 | 8334 | 127 |
1923616 | 1923616 | 2021-11-16 | Poquoson city | Virginia | 51735 | 1360 | 22 |
1923617 | 1923617 | 2021-11-16 | Portsmouth city | Virginia | 51740 | 12852 | 246 |
1923618 | 1923618 | 2021-11-16 | Powhatan | Virginia | 51145 | 2895 | 28 |
1923619 | 1923619 | 2021-11-16 | Prince Edward | Virginia | 51147 | 2977 | 52 |
1923620 | 1923620 | 2021-11-16 | Prince George | Virginia | 51149 | 5215 | 49 |
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);