ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
133 rows where date = "2020-10-23" 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 |
---|---|---|---|---|---|---|---|
660525 | 660525 | 2020-10-23 | Accomack | Virginia | 51001 | 1206 | 19 |
660526 | 660526 | 2020-10-23 | Albemarle | Virginia | 51003 | 1530 | 24 |
660527 | 660527 | 2020-10-23 | Alexandria city | Virginia | 51510 | 4179 | 75 |
660528 | 660528 | 2020-10-23 | Alleghany | Virginia | 51005 | 105 | 4 |
660529 | 660529 | 2020-10-23 | Amelia | Virginia | 51007 | 143 | 6 |
660530 | 660530 | 2020-10-23 | Amherst | Virginia | 51009 | 563 | 4 |
660531 | 660531 | 2020-10-23 | Appomattox | Virginia | 51011 | 281 | 5 |
660532 | 660532 | 2020-10-23 | Arlington | Virginia | 51013 | 4488 | 153 |
660533 | 660533 | 2020-10-23 | Augusta | Virginia | 51015 | 647 | 8 |
660534 | 660534 | 2020-10-23 | Bath | Virginia | 51017 | 24 | 0 |
660535 | 660535 | 2020-10-23 | Bedford | Virginia | 51019 | 1151 | 17 |
660536 | 660536 | 2020-10-23 | Bland | Virginia | 51021 | 64 | 5 |
660537 | 660537 | 2020-10-23 | Botetourt | Virginia | 51023 | 378 | 12 |
660538 | 660538 | 2020-10-23 | Bristol city | Virginia | 51520 | 253 | 7 |
660539 | 660539 | 2020-10-23 | Brunswick | Virginia | 51025 | 419 | 5 |
660540 | 660540 | 2020-10-23 | Buchanan | Virginia | 51027 | 246 | 2 |
660541 | 660541 | 2020-10-23 | Buckingham | Virginia | 51029 | 731 | 9 |
660542 | 660542 | 2020-10-23 | Buena Vista city | Virginia | 51530 | 121 | 1 |
660543 | 660543 | 2020-10-23 | Campbell | Virginia | 51031 | 672 | 8 |
660544 | 660544 | 2020-10-23 | Caroline | Virginia | 51033 | 406 | 6 |
660545 | 660545 | 2020-10-23 | Carroll | Virginia | 51035 | 584 | 27 |
660546 | 660546 | 2020-10-23 | Charles City | Virginia | 51036 | 98 | 5 |
660547 | 660547 | 2020-10-23 | Charlotte | Virginia | 51037 | 203 | 1 |
660548 | 660548 | 2020-10-23 | Charlottesville city | Virginia | 51540 | 1556 | 31 |
660549 | 660549 | 2020-10-23 | Chesapeake city | Virginia | 51550 | 4823 | 78 |
660550 | 660550 | 2020-10-23 | Chesterfield | Virginia | 51041 | 6869 | 101 |
660551 | 660551 | 2020-10-23 | Clarke | Virginia | 51043 | 116 | 1 |
660552 | 660552 | 2020-10-23 | Colonial Heights city | Virginia | 51570 | 298 | 26 |
660553 | 660553 | 2020-10-23 | Covington city | Virginia | 51580 | 35 | 0 |
660554 | 660554 | 2020-10-23 | Craig | Virginia | 51045 | 50 | 0 |
660555 | 660555 | 2020-10-23 | Culpeper | Virginia | 51047 | 1338 | 18 |
660556 | 660556 | 2020-10-23 | Cumberland | Virginia | 51049 | 115 | 2 |
660557 | 660557 | 2020-10-23 | Danville city | Virginia | 51590 | 1161 | 42 |
660558 | 660558 | 2020-10-23 | Dickenson | Virginia | 51051 | 128 | 1 |
660559 | 660559 | 2020-10-23 | Dinwiddie | Virginia | 51053 | 501 | 12 |
660560 | 660560 | 2020-10-23 | Emporia city | Virginia | 51595 | 286 | 28 |
660561 | 660561 | 2020-10-23 | Essex | Virginia | 51057 | 191 | 2 |
660562 | 660562 | 2020-10-23 | Fairfax | Virginia | 51059 | 23137 | 606 |
660563 | 660563 | 2020-10-23 | Fairfax city | Virginia | 51600 | 156 | 8 |
660564 | 660564 | 2020-10-23 | Falls Church city | Virginia | 51610 | 74 | 7 |
660565 | 660565 | 2020-10-23 | Fauquier | Virginia | 51061 | 1073 | 27 |
660566 | 660566 | 2020-10-23 | Floyd | Virginia | 51063 | 241 | 15 |
660567 | 660567 | 2020-10-23 | Fluvanna | Virginia | 51065 | 416 | 9 |
660568 | 660568 | 2020-10-23 | Franklin | Virginia | 51067 | 748 | 5 |
660569 | 660569 | 2020-10-23 | Franklin city | Virginia | 51620 | 489 | 12 |
660570 | 660570 | 2020-10-23 | Frederick | Virginia | 51069 | 1137 | 13 |
660571 | 660571 | 2020-10-23 | Fredericksburg city | Virginia | 51630 | 582 | 6 |
660572 | 660572 | 2020-10-23 | Galax city | Virginia | 51640 | 436 | 30 |
660573 | 660573 | 2020-10-23 | Giles | Virginia | 51071 | 122 | 0 |
660574 | 660574 | 2020-10-23 | Gloucester | Virginia | 51073 | 342 | 3 |
660575 | 660575 | 2020-10-23 | Goochland | Virginia | 51075 | 321 | 7 |
660576 | 660576 | 2020-10-23 | Grayson | Virginia | 51077 | 374 | 19 |
660577 | 660577 | 2020-10-23 | Greene | Virginia | 51079 | 280 | 3 |
660578 | 660578 | 2020-10-23 | Greensville | Virginia | 51081 | 890 | 14 |
660579 | 660579 | 2020-10-23 | Halifax | Virginia | 51083 | 472 | 8 |
660580 | 660580 | 2020-10-23 | Hampton city | Virginia | 51650 | 2079 | 32 |
660581 | 660581 | 2020-10-23 | Hanover | Virginia | 51085 | 1580 | 42 |
660582 | 660582 | 2020-10-23 | Harrisonburg city | Virginia | 51660 | 2962 | 35 |
660583 | 660583 | 2020-10-23 | Henrico | Virginia | 51087 | 6136 | 229 |
660584 | 660584 | 2020-10-23 | Henry | Virginia | 51089 | 1276 | 31 |
660585 | 660585 | 2020-10-23 | Highland | Virginia | 51091 | 9 | 0 |
660586 | 660586 | 2020-10-23 | Hopewell city | Virginia | 51670 | 497 | 7 |
660587 | 660587 | 2020-10-23 | Isle of Wight | Virginia | 51093 | 849 | 25 |
660588 | 660588 | 2020-10-23 | James City | Virginia | 51095 | 936 | 22 |
660589 | 660589 | 2020-10-23 | King George | Virginia | 51099 | 266 | 4 |
660590 | 660590 | 2020-10-23 | King William | Virginia | 51101 | 199 | 2 |
660591 | 660591 | 2020-10-23 | King and Queen | Virginia | 51097 | 86 | 2 |
660592 | 660592 | 2020-10-23 | Lancaster | Virginia | 51103 | 196 | 1 |
660593 | 660593 | 2020-10-23 | Lee | Virginia | 51105 | 423 | 9 |
660594 | 660594 | 2020-10-23 | Lexington city | Virginia | 51678 | 217 | 1 |
660595 | 660595 | 2020-10-23 | Loudoun | Virginia | 51107 | 7704 | 130 |
660596 | 660596 | 2020-10-23 | Louisa | Virginia | 51109 | 378 | 8 |
660597 | 660597 | 2020-10-23 | Lunenburg | Virginia | 51111 | 146 | 3 |
660598 | 660598 | 2020-10-23 | Lynchburg city | Virginia | 51680 | 1893 | 25 |
660599 | 660599 | 2020-10-23 | Madison | Virginia | 51113 | 128 | 3 |
660600 | 660600 | 2020-10-23 | Manassas Park city | Virginia | 51685 | 641 | 8 |
660601 | 660601 | 2020-10-23 | Manassas city | Virginia | 51683 | 2029 | 27 |
660602 | 660602 | 2020-10-23 | Martinsville city | Virginia | 51690 | 472 | 23 |
660603 | 660603 | 2020-10-23 | Mathews | Virginia | 51115 | 130 | 0 |
660604 | 660604 | 2020-10-23 | Mecklenburg | Virginia | 51117 | 858 | 35 |
660605 | 660605 | 2020-10-23 | Middlesex | Virginia | 51119 | 143 | 11 |
660606 | 660606 | 2020-10-23 | Montgomery | Virginia | 51121 | 2632 | 5 |
660607 | 660607 | 2020-10-23 | Nelson | Virginia | 51125 | 136 | 2 |
660608 | 660608 | 2020-10-23 | New Kent | Virginia | 51127 | 276 | 3 |
660609 | 660609 | 2020-10-23 | Newport News city | Virginia | 51700 | 3119 | 50 |
660610 | 660610 | 2020-10-23 | Norfolk city | Virginia | 51710 | 5282 | 85 |
660611 | 660611 | 2020-10-23 | Northampton | Virginia | 51131 | 316 | 31 |
660612 | 660612 | 2020-10-23 | Northumberland | Virginia | 51133 | 213 | 7 |
660613 | 660613 | 2020-10-23 | Norton city | Virginia | 51720 | 47 | 0 |
660614 | 660614 | 2020-10-23 | Nottoway | Virginia | 51135 | 336 | 21 |
660615 | 660615 | 2020-10-23 | Orange | Virginia | 51137 | 385 | 5 |
660616 | 660616 | 2020-10-23 | Page | Virginia | 51139 | 464 | 30 |
660617 | 660617 | 2020-10-23 | Patrick | Virginia | 51141 | 314 | 27 |
660618 | 660618 | 2020-10-23 | Petersburg city | Virginia | 51730 | 905 | 29 |
660619 | 660619 | 2020-10-23 | Pittsylvania | Virginia | 51143 | 1248 | 17 |
660620 | 660620 | 2020-10-23 | Poquoson city | Virginia | 51735 | 93 | 2 |
660621 | 660621 | 2020-10-23 | Portsmouth city | Virginia | 51740 | 2793 | 69 |
660622 | 660622 | 2020-10-23 | Powhatan | Virginia | 51145 | 294 | 5 |
660623 | 660623 | 2020-10-23 | Prince Edward | Virginia | 51147 | 739 | 13 |
660624 | 660624 | 2020-10-23 | Prince George | Virginia | 51149 | 1065 | 6 |
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);