ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
124 rows where "date" is on date 2020-04-15 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
- Bedford 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
- Craig 1
- Culpeper 1
- Cumberland 1
- Danville city 1
- …
state 1
- Virginia · 124 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
61587 | 61587 | 2020-04-15 | Accomack | Virginia | 51001 | 15 | 0 |
61588 | 61588 | 2020-04-15 | Albemarle | Virginia | 51003 | 53 | 0 |
61589 | 61589 | 2020-04-15 | Alexandria city | Virginia | 51510 | 254 | 6 |
61590 | 61590 | 2020-04-15 | Alleghany | Virginia | 51005 | 4 | 0 |
61591 | 61591 | 2020-04-15 | Amelia | Virginia | 51007 | 10 | 0 |
61592 | 61592 | 2020-04-15 | Amherst | Virginia | 51009 | 10 | 0 |
61593 | 61593 | 2020-04-15 | Appomattox | Virginia | 51011 | 7 | 0 |
61594 | 61594 | 2020-04-15 | Arlington | Virginia | 51013 | 420 | 12 |
61595 | 61595 | 2020-04-15 | Augusta | Virginia | 51015 | 18 | 0 |
61596 | 61596 | 2020-04-15 | Bedford | Virginia | 51019 | 16 | 0 |
61597 | 61597 | 2020-04-15 | Botetourt | Virginia | 51023 | 23 | 0 |
61598 | 61598 | 2020-04-15 | Bristol city | Virginia | 51520 | 1 | 0 |
61599 | 61599 | 2020-04-15 | Brunswick | Virginia | 51025 | 9 | 0 |
61600 | 61600 | 2020-04-15 | Buchanan | Virginia | 51027 | 12 | 0 |
61601 | 61601 | 2020-04-15 | Buckingham | Virginia | 51029 | 22 | 0 |
61602 | 61602 | 2020-04-15 | Buena Vista city | Virginia | 51530 | 4 | 0 |
61603 | 61603 | 2020-04-15 | Campbell | Virginia | 51031 | 11 | 0 |
61604 | 61604 | 2020-04-15 | Caroline | Virginia | 51033 | 9 | 0 |
61605 | 61605 | 2020-04-15 | Carroll | Virginia | 51035 | 3 | 0 |
61606 | 61606 | 2020-04-15 | Charles City | Virginia | 51036 | 9 | 0 |
61607 | 61607 | 2020-04-15 | Charlotte | Virginia | 51037 | 5 | 0 |
61608 | 61608 | 2020-04-15 | Charlottesville city | Virginia | 51540 | 38 | 1 |
61609 | 61609 | 2020-04-15 | Chesapeake city | Virginia | 51550 | 140 | 3 |
61610 | 61610 | 2020-04-15 | Chesterfield | Virginia | 51041 | 254 | 5 |
61611 | 61611 | 2020-04-15 | Clarke | Virginia | 51043 | 6 | 0 |
61612 | 61612 | 2020-04-15 | Colonial Heights city | Virginia | 51570 | 17 | 0 |
61613 | 61613 | 2020-04-15 | Craig | Virginia | 51045 | 2 | 0 |
61614 | 61614 | 2020-04-15 | Culpeper | Virginia | 51047 | 25 | 0 |
61615 | 61615 | 2020-04-15 | Cumberland | Virginia | 51049 | 8 | 0 |
61616 | 61616 | 2020-04-15 | Danville city | Virginia | 51590 | 22 | 0 |
61617 | 61617 | 2020-04-15 | Dinwiddie | Virginia | 51053 | 7 | 0 |
61618 | 61618 | 2020-04-15 | Emporia city | Virginia | 51595 | 7 | 0 |
61619 | 61619 | 2020-04-15 | Fairfax | Virginia | 51059 | 1298 | 29 |
61620 | 61620 | 2020-04-15 | Fairfax city | Virginia | 51600 | 1 | 0 |
61621 | 61621 | 2020-04-15 | Falls Church city | Virginia | 51610 | 2 | 0 |
61622 | 61622 | 2020-04-15 | Fauquier | Virginia | 51061 | 29 | 0 |
61623 | 61623 | 2020-04-15 | Floyd | Virginia | 51063 | 1 | 0 |
61624 | 61624 | 2020-04-15 | Fluvanna | Virginia | 51065 | 62 | 0 |
61625 | 61625 | 2020-04-15 | Franklin | Virginia | 51067 | 15 | 0 |
61626 | 61626 | 2020-04-15 | Franklin city | Virginia | 51620 | 7 | 0 |
61627 | 61627 | 2020-04-15 | Frederick | Virginia | 51069 | 73 | 0 |
61628 | 61628 | 2020-04-15 | Fredericksburg city | Virginia | 51630 | 15 | 0 |
61629 | 61629 | 2020-04-15 | Galax city | Virginia | 51640 | 1 | 0 |
61630 | 61630 | 2020-04-15 | Giles | Virginia | 51071 | 4 | 0 |
61631 | 61631 | 2020-04-15 | Gloucester | Virginia | 51073 | 20 | 0 |
61632 | 61632 | 2020-04-15 | Goochland | Virginia | 51075 | 40 | 1 |
61633 | 61633 | 2020-04-15 | Greene | Virginia | 51079 | 5 | 0 |
61634 | 61634 | 2020-04-15 | Greensville | Virginia | 51081 | 16 | 0 |
61635 | 61635 | 2020-04-15 | Halifax | Virginia | 51083 | 7 | 0 |
61636 | 61636 | 2020-04-15 | Hampton city | Virginia | 51650 | 75 | 1 |
61637 | 61637 | 2020-04-15 | Hanover | Virginia | 51085 | 53 | 0 |
61638 | 61638 | 2020-04-15 | Harrisonburg city | Virginia | 51660 | 101 | 0 |
61639 | 61639 | 2020-04-15 | Henrico | Virginia | 51087 | 453 | 45 |
61640 | 61640 | 2020-04-15 | Henry | Virginia | 51089 | 8 | 0 |
61641 | 61641 | 2020-04-15 | Hopewell city | Virginia | 51670 | 14 | 0 |
61642 | 61642 | 2020-04-15 | Isle of Wight | Virginia | 51093 | 60 | 0 |
61643 | 61643 | 2020-04-15 | James City | Virginia | 51095 | 132 | 3 |
61644 | 61644 | 2020-04-15 | King George | Virginia | 51099 | 17 | 0 |
61645 | 61645 | 2020-04-15 | King William | Virginia | 51101 | 2 | 0 |
61646 | 61646 | 2020-04-15 | King and Queen | Virginia | 51097 | 2 | 0 |
61647 | 61647 | 2020-04-15 | Lancaster | Virginia | 51103 | 1 | 0 |
61648 | 61648 | 2020-04-15 | Lee | Virginia | 51105 | 6 | 0 |
61649 | 61649 | 2020-04-15 | Lexington city | Virginia | 51678 | 3 | 0 |
61650 | 61650 | 2020-04-15 | Loudoun | Virginia | 51107 | 367 | 5 |
61651 | 61651 | 2020-04-15 | Louisa | Virginia | 51109 | 29 | 0 |
61652 | 61652 | 2020-04-15 | Lunenburg | Virginia | 51111 | 3 | 0 |
61653 | 61653 | 2020-04-15 | Lynchburg city | Virginia | 51680 | 34 | 0 |
61654 | 61654 | 2020-04-15 | Madison | Virginia | 51113 | 8 | 0 |
61655 | 61655 | 2020-04-15 | Manassas Park city | Virginia | 51685 | 14 | 0 |
61656 | 61656 | 2020-04-15 | Manassas city | Virginia | 51683 | 53 | 0 |
61657 | 61657 | 2020-04-15 | Mathews | Virginia | 51115 | 3 | 0 |
61658 | 61658 | 2020-04-15 | Mecklenburg | Virginia | 51117 | 57 | 0 |
61659 | 61659 | 2020-04-15 | Middlesex | Virginia | 51119 | 3 | 0 |
61660 | 61660 | 2020-04-15 | Montgomery | Virginia | 51121 | 34 | 0 |
61661 | 61661 | 2020-04-15 | Nelson | Virginia | 51125 | 5 | 0 |
61662 | 61662 | 2020-04-15 | New Kent | Virginia | 51127 | 16 | 0 |
61663 | 61663 | 2020-04-15 | Newport News city | Virginia | 51700 | 95 | 1 |
61664 | 61664 | 2020-04-15 | Norfolk city | Virginia | 51710 | 99 | 1 |
61665 | 61665 | 2020-04-15 | Northampton | Virginia | 51131 | 4 | 0 |
61666 | 61666 | 2020-04-15 | Northumberland | Virginia | 51133 | 4 | 0 |
61667 | 61667 | 2020-04-15 | Nottoway | Virginia | 51135 | 5 | 0 |
61668 | 61668 | 2020-04-15 | Orange | Virginia | 51137 | 17 | 0 |
61669 | 61669 | 2020-04-15 | Page | Virginia | 51139 | 6 | 0 |
61670 | 61670 | 2020-04-15 | Petersburg city | Virginia | 51730 | 19 | 0 |
61671 | 61671 | 2020-04-15 | Pittsylvania | Virginia | 51143 | 4 | 0 |
61672 | 61672 | 2020-04-15 | Poquoson city | Virginia | 51735 | 6 | 0 |
61673 | 61673 | 2020-04-15 | Portsmouth city | Virginia | 51740 | 59 | 4 |
61674 | 61674 | 2020-04-15 | Powhatan | Virginia | 51145 | 5 | 0 |
61675 | 61675 | 2020-04-15 | Prince Edward | Virginia | 51147 | 15 | 1 |
61676 | 61676 | 2020-04-15 | Prince George | Virginia | 51149 | 27 | 0 |
61677 | 61677 | 2020-04-15 | Prince William | Virginia | 51153 | 536 | 1 |
61678 | 61678 | 2020-04-15 | Pulaski | Virginia | 51155 | 4 | 0 |
61679 | 61679 | 2020-04-15 | Radford city | Virginia | 51750 | 1 | 0 |
61680 | 61680 | 2020-04-15 | Rappahannock | Virginia | 51157 | 1 | 0 |
61681 | 61681 | 2020-04-15 | Richmond | Virginia | 51159 | 7 | 0 |
61682 | 61682 | 2020-04-15 | Richmond city | Virginia | 51760 | 177 | 7 |
61683 | 61683 | 2020-04-15 | Roanoke | Virginia | 51161 | 17 | 0 |
61684 | 61684 | 2020-04-15 | Roanoke city | Virginia | 51770 | 22 | 0 |
61685 | 61685 | 2020-04-15 | Rockbridge | Virginia | 51163 | 3 | 0 |
61686 | 61686 | 2020-04-15 | Rockingham | Virginia | 51165 | 67 | 0 |
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);