ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
133 rows where "date" is on date 2020-07-10 and state = "Virginia" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|
321572 | 321572 | 2020-07-10 | Accomack | Virginia | 51001 | 1042 | 14 |
321573 | 321573 | 2020-07-10 | Albemarle | Virginia | 51003 | 520 | 10 |
321574 | 321574 | 2020-07-10 | Alexandria city | Virginia | 51510 | 2439 | 57 |
321575 | 321575 | 2020-07-10 | Alleghany | Virginia | 51005 | 39 | 2 |
321576 | 321576 | 2020-07-10 | Amelia | Virginia | 51007 | 49 | 1 |
321577 | 321577 | 2020-07-10 | Amherst | Virginia | 51009 | 38 | 0 |
321578 | 321578 | 2020-07-10 | Appomattox | Virginia | 51011 | 46 | 0 |
321579 | 321579 | 2020-07-10 | Arlington | Virginia | 51013 | 2582 | 133 |
321580 | 321580 | 2020-07-10 | Augusta | Virginia | 51015 | 204 | 2 |
321581 | 321581 | 2020-07-10 | Bath | Virginia | 51017 | 1 | 0 |
321582 | 321582 | 2020-07-10 | Bedford | Virginia | 51019 | 144 | 4 |
321583 | 321583 | 2020-07-10 | Bland | Virginia | 51021 | 3 | 0 |
321584 | 321584 | 2020-07-10 | Botetourt | Virginia | 51023 | 151 | 4 |
321585 | 321585 | 2020-07-10 | Bristol city | Virginia | 51520 | 10 | 0 |
321586 | 321586 | 2020-07-10 | Brunswick | Virginia | 51025 | 123 | 1 |
321587 | 321587 | 2020-07-10 | Buchanan | Virginia | 51027 | 39 | 0 |
321588 | 321588 | 2020-07-10 | Buckingham | Virginia | 51029 | 574 | 6 |
321589 | 321589 | 2020-07-10 | Buena Vista city | Virginia | 51530 | 18 | 0 |
321590 | 321590 | 2020-07-10 | Campbell | Virginia | 51031 | 56 | 1 |
321591 | 321591 | 2020-07-10 | Caroline | Virginia | 51033 | 135 | 4 |
321592 | 321592 | 2020-07-10 | Carroll | Virginia | 51035 | 244 | 9 |
321593 | 321593 | 2020-07-10 | Charles City | Virginia | 51036 | 41 | 3 |
321594 | 321594 | 2020-07-10 | Charlotte | Virginia | 51037 | 35 | 0 |
321595 | 321595 | 2020-07-10 | Charlottesville city | Virginia | 51540 | 260 | 7 |
321596 | 321596 | 2020-07-10 | Chesapeake city | Virginia | 51550 | 1162 | 22 |
321597 | 321597 | 2020-07-10 | Chesterfield | Virginia | 51041 | 3135 | 62 |
321598 | 321598 | 2020-07-10 | Clarke | Virginia | 51043 | 58 | 0 |
321599 | 321599 | 2020-07-10 | Colonial Heights city | Virginia | 51570 | 152 | 20 |
321600 | 321600 | 2020-07-10 | Covington city | Virginia | 51580 | 5 | 0 |
321601 | 321601 | 2020-07-10 | Craig | Virginia | 51045 | 9 | 0 |
321602 | 321602 | 2020-07-10 | Culpeper | Virginia | 51047 | 841 | 12 |
321603 | 321603 | 2020-07-10 | Cumberland | Virginia | 51049 | 59 | 0 |
321604 | 321604 | 2020-07-10 | Danville city | Virginia | 51590 | 104 | 2 |
321605 | 321605 | 2020-07-10 | Dickenson | Virginia | 51051 | 5 | 0 |
321606 | 321606 | 2020-07-10 | Dinwiddie | Virginia | 51053 | 154 | 2 |
321607 | 321607 | 2020-07-10 | Emporia city | Virginia | 51595 | 147 | 15 |
321608 | 321608 | 2020-07-10 | Essex | Virginia | 51057 | 63 | 0 |
321609 | 321609 | 2020-07-10 | Fairfax | Virginia | 51059 | 14356 | 499 |
321610 | 321610 | 2020-07-10 | Fairfax city | Virginia | 51600 | 72 | 7 |
321611 | 321611 | 2020-07-10 | Falls Church city | Virginia | 51610 | 51 | 7 |
321612 | 321612 | 2020-07-10 | Fauquier | Virginia | 51061 | 471 | 8 |
321613 | 321613 | 2020-07-10 | Floyd | Virginia | 51063 | 20 | 1 |
321614 | 321614 | 2020-07-10 | Fluvanna | Virginia | 51065 | 128 | 8 |
321615 | 321615 | 2020-07-10 | Franklin | Virginia | 51067 | 105 | 1 |
321616 | 321616 | 2020-07-10 | Franklin city | Virginia | 51620 | 69 | 3 |
321617 | 321617 | 2020-07-10 | Frederick | Virginia | 51069 | 536 | 6 |
321618 | 321618 | 2020-07-10 | Fredericksburg city | Virginia | 51630 | 264 | 0 |
321619 | 321619 | 2020-07-10 | Galax city | Virginia | 51640 | 283 | 16 |
321620 | 321620 | 2020-07-10 | Giles | Virginia | 51071 | 18 | 0 |
321621 | 321621 | 2020-07-10 | Gloucester | Virginia | 51073 | 65 | 1 |
321622 | 321622 | 2020-07-10 | Goochland | Virginia | 51075 | 129 | 6 |
321623 | 321623 | 2020-07-10 | Grayson | Virginia | 51077 | 91 | 4 |
321624 | 321624 | 2020-07-10 | Greene | Virginia | 51079 | 80 | 2 |
321625 | 321625 | 2020-07-10 | Greensville | Virginia | 51081 | 374 | 9 |
321626 | 321626 | 2020-07-10 | Halifax | Virginia | 51083 | 76 | 1 |
321627 | 321627 | 2020-07-10 | Hampton city | Virginia | 51650 | 454 | 4 |
321628 | 321628 | 2020-07-10 | Hanover | Virginia | 51085 | 467 | 31 |
321629 | 321629 | 2020-07-10 | Harrisonburg city | Virginia | 51660 | 976 | 28 |
321630 | 321630 | 2020-07-10 | Henrico | Virginia | 51087 | 2784 | 172 |
321631 | 321631 | 2020-07-10 | Henry | Virginia | 51089 | 339 | 5 |
321632 | 321632 | 2020-07-10 | Highland | Virginia | 51091 | 3 | 0 |
321633 | 321633 | 2020-07-10 | Hopewell city | Virginia | 51670 | 193 | 5 |
321634 | 321634 | 2020-07-10 | Isle of Wight | Virginia | 51093 | 215 | 9 |
321635 | 321635 | 2020-07-10 | James City | Virginia | 51095 | 332 | 16 |
321636 | 321636 | 2020-07-10 | King George | Virginia | 51099 | 104 | 4 |
321637 | 321637 | 2020-07-10 | King William | Virginia | 51101 | 54 | 2 |
321638 | 321638 | 2020-07-10 | King and Queen | Virginia | 51097 | 26 | 1 |
321639 | 321639 | 2020-07-10 | Lancaster | Virginia | 51103 | 12 | 0 |
321640 | 321640 | 2020-07-10 | Lee | Virginia | 51105 | 17 | 0 |
321641 | 321641 | 2020-07-10 | Lexington city | Virginia | 51678 | 13 | 0 |
321642 | 321642 | 2020-07-10 | Loudoun | Virginia | 51107 | 4349 | 99 |
321643 | 321643 | 2020-07-10 | Louisa | Virginia | 51109 | 134 | 2 |
321644 | 321644 | 2020-07-10 | Lunenburg | Virginia | 51111 | 40 | 0 |
321645 | 321645 | 2020-07-10 | Lynchburg city | Virginia | 51680 | 177 | 1 |
321646 | 321646 | 2020-07-10 | Madison | Virginia | 51113 | 46 | 1 |
321647 | 321647 | 2020-07-10 | Manassas Park city | Virginia | 51685 | 455 | 6 |
321648 | 321648 | 2020-07-10 | Manassas city | Virginia | 51683 | 1472 | 18 |
321649 | 321649 | 2020-07-10 | Martinsville city | Virginia | 51690 | 107 | 1 |
321650 | 321650 | 2020-07-10 | Mathews | Virginia | 51115 | 7 | 0 |
321651 | 321651 | 2020-07-10 | Mecklenburg | Virginia | 51117 | 253 | 29 |
321652 | 321652 | 2020-07-10 | Middlesex | Virginia | 51119 | 16 | 0 |
321653 | 321653 | 2020-07-10 | Montgomery | Virginia | 51121 | 177 | 3 |
321654 | 321654 | 2020-07-10 | Nelson | Virginia | 51125 | 22 | 0 |
321655 | 321655 | 2020-07-10 | New Kent | Virginia | 51127 | 63 | 1 |
321656 | 321656 | 2020-07-10 | Newport News city | Virginia | 51700 | 679 | 10 |
321657 | 321657 | 2020-07-10 | Norfolk city | Virginia | 51710 | 1360 | 15 |
321658 | 321658 | 2020-07-10 | Northampton | Virginia | 51131 | 273 | 28 |
321659 | 321659 | 2020-07-10 | Northumberland | Virginia | 51133 | 38 | 1 |
321660 | 321660 | 2020-07-10 | Norton city | Virginia | 51720 | 4 | 0 |
321661 | 321661 | 2020-07-10 | Nottoway | Virginia | 51135 | 117 | 5 |
321662 | 321662 | 2020-07-10 | Orange | Virginia | 51137 | 158 | 3 |
321663 | 321663 | 2020-07-10 | Page | Virginia | 51139 | 296 | 23 |
321664 | 321664 | 2020-07-10 | Patrick | Virginia | 51141 | 48 | 1 |
321665 | 321665 | 2020-07-10 | Petersburg city | Virginia | 51730 | 320 | 8 |
321666 | 321666 | 2020-07-10 | Pittsylvania | Virginia | 51143 | 148 | 2 |
321667 | 321667 | 2020-07-10 | Poquoson city | Virginia | 51735 | 20 | 0 |
321668 | 321668 | 2020-07-10 | Portsmouth city | Virginia | 51740 | 627 | 18 |
321669 | 321669 | 2020-07-10 | Powhatan | Virginia | 51145 | 87 | 2 |
321670 | 321670 | 2020-07-10 | Prince Edward | Virginia | 51147 | 236 | 6 |
321671 | 321671 | 2020-07-10 | Prince George | Virginia | 51149 | 255 | 2 |
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);