ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
133 rows where date = "2020-11-30" 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 |
---|---|---|---|---|---|---|---|
783812 | 783812 | 2020-11-30 | Accomack | Virginia | 51001 | 1346 | 21 |
783813 | 783813 | 2020-11-30 | Albemarle | Virginia | 51003 | 1908 | 27 |
783814 | 783814 | 2020-11-30 | Alexandria city | Virginia | 51510 | 5366 | 77 |
783815 | 783815 | 2020-11-30 | Alleghany | Virginia | 51005 | 320 | 7 |
783816 | 783816 | 2020-11-30 | Amelia | Virginia | 51007 | 217 | 6 |
783817 | 783817 | 2020-11-30 | Amherst | Virginia | 51009 | 819 | 6 |
783818 | 783818 | 2020-11-30 | Appomattox | Virginia | 51011 | 405 | 6 |
783819 | 783819 | 2020-11-30 | Arlington | Virginia | 51013 | 6299 | 157 |
783820 | 783820 | 2020-11-30 | Augusta | Virginia | 51015 | 1177 | 11 |
783821 | 783821 | 2020-11-30 | Bath | Virginia | 51017 | 62 | 0 |
783822 | 783822 | 2020-11-30 | Bedford | Virginia | 51019 | 1839 | 19 |
783823 | 783823 | 2020-11-30 | Bland | Virginia | 51021 | 194 | 5 |
783824 | 783824 | 2020-11-30 | Botetourt | Virginia | 51023 | 778 | 13 |
783825 | 783825 | 2020-11-30 | Bristol city | Virginia | 51520 | 533 | 7 |
783826 | 783826 | 2020-11-30 | Brunswick | Virginia | 51025 | 471 | 7 |
783827 | 783827 | 2020-11-30 | Buchanan | Virginia | 51027 | 423 | 6 |
783828 | 783828 | 2020-11-30 | Buckingham | Virginia | 51029 | 893 | 10 |
783829 | 783829 | 2020-11-30 | Buena Vista city | Virginia | 51530 | 267 | 1 |
783830 | 783830 | 2020-11-30 | Campbell | Virginia | 51031 | 1201 | 12 |
783831 | 783831 | 2020-11-30 | Caroline | Virginia | 51033 | 606 | 6 |
783832 | 783832 | 2020-11-30 | Carroll | Virginia | 51035 | 973 | 30 |
783833 | 783833 | 2020-11-30 | Charles City | Virginia | 51036 | 142 | 7 |
783834 | 783834 | 2020-11-30 | Charlotte | Virginia | 51037 | 284 | 5 |
783835 | 783835 | 2020-11-30 | Charlottesville city | Virginia | 51540 | 1854 | 31 |
783836 | 783836 | 2020-11-30 | Chesapeake city | Virginia | 51550 | 6657 | 80 |
783837 | 783837 | 2020-11-30 | Chesterfield | Virginia | 51041 | 9323 | 131 |
783838 | 783838 | 2020-11-30 | Clarke | Virginia | 51043 | 208 | 3 |
783839 | 783839 | 2020-11-30 | Colonial Heights city | Virginia | 51570 | 420 | 26 |
783840 | 783840 | 2020-11-30 | Covington city | Virginia | 51580 | 157 | 1 |
783841 | 783841 | 2020-11-30 | Craig | Virginia | 51045 | 90 | 1 |
783842 | 783842 | 2020-11-30 | Culpeper | Virginia | 51047 | 2240 | 20 |
783843 | 783843 | 2020-11-30 | Cumberland | Virginia | 51049 | 160 | 4 |
783844 | 783844 | 2020-11-30 | Danville city | Virginia | 51590 | 1632 | 49 |
783845 | 783845 | 2020-11-30 | Dickenson | Virginia | 51051 | 268 | 1 |
783846 | 783846 | 2020-11-30 | Dinwiddie | Virginia | 51053 | 669 | 14 |
783847 | 783847 | 2020-11-30 | Emporia city | Virginia | 51595 | 335 | 28 |
783848 | 783848 | 2020-11-30 | Essex | Virginia | 51057 | 243 | 2 |
783849 | 783849 | 2020-11-30 | Fairfax | Virginia | 51059 | 31072 | 623 |
783850 | 783850 | 2020-11-30 | Fairfax city | Virginia | 51600 | 213 | 9 |
783851 | 783851 | 2020-11-30 | Falls Church city | Virginia | 51610 | 103 | 6 |
783852 | 783852 | 2020-11-30 | Fauquier | Virginia | 51061 | 1508 | 28 |
783853 | 783853 | 2020-11-30 | Floyd | Virginia | 51063 | 351 | 15 |
783854 | 783854 | 2020-11-30 | Fluvanna | Virginia | 51065 | 498 | 9 |
783855 | 783855 | 2020-11-30 | Franklin | Virginia | 51067 | 1634 | 17 |
783856 | 783856 | 2020-11-30 | Franklin city | Virginia | 51620 | 547 | 16 |
783857 | 783857 | 2020-11-30 | Frederick | Virginia | 51069 | 2228 | 18 |
783858 | 783858 | 2020-11-30 | Fredericksburg city | Virginia | 51630 | 703 | 6 |
783859 | 783859 | 2020-11-30 | Galax city | Virginia | 51640 | 572 | 30 |
783860 | 783860 | 2020-11-30 | Giles | Virginia | 51071 | 299 | 0 |
783861 | 783861 | 2020-11-30 | Gloucester | Virginia | 51073 | 475 | 3 |
783862 | 783862 | 2020-11-30 | Goochland | Virginia | 51075 | 450 | 7 |
783863 | 783863 | 2020-11-30 | Grayson | Virginia | 51077 | 524 | 22 |
783864 | 783864 | 2020-11-30 | Greene | Virginia | 51079 | 368 | 4 |
783865 | 783865 | 2020-11-30 | Greensville | Virginia | 51081 | 938 | 16 |
783866 | 783866 | 2020-11-30 | Halifax | Virginia | 51083 | 816 | 17 |
783867 | 783867 | 2020-11-30 | Hampton city | Virginia | 51650 | 2816 | 35 |
783868 | 783868 | 2020-11-30 | Hanover | Virginia | 51085 | 2442 | 54 |
783869 | 783869 | 2020-11-30 | Harrisonburg city | Virginia | 51660 | 3472 | 37 |
783870 | 783870 | 2020-11-30 | Henrico | Virginia | 51087 | 8409 | 251 |
783871 | 783871 | 2020-11-30 | Henry | Virginia | 51089 | 1916 | 41 |
783872 | 783872 | 2020-11-30 | Highland | Virginia | 51091 | 16 | 0 |
783873 | 783873 | 2020-11-30 | Hopewell city | Virginia | 51670 | 621 | 9 |
783874 | 783874 | 2020-11-30 | Isle of Wight | Virginia | 51093 | 1038 | 28 |
783875 | 783875 | 2020-11-30 | James City | Virginia | 51095 | 1209 | 22 |
783876 | 783876 | 2020-11-30 | King George | Virginia | 51099 | 420 | 5 |
783877 | 783877 | 2020-11-30 | King William | Virginia | 51101 | 285 | 5 |
783878 | 783878 | 2020-11-30 | King and Queen | Virginia | 51097 | 104 | 2 |
783879 | 783879 | 2020-11-30 | Lancaster | Virginia | 51103 | 242 | 1 |
783880 | 783880 | 2020-11-30 | Lee | Virginia | 51105 | 933 | 14 |
783881 | 783881 | 2020-11-30 | Lexington city | Virginia | 51678 | 356 | 2 |
783882 | 783882 | 2020-11-30 | Loudoun | Virginia | 51107 | 10049 | 143 |
783883 | 783883 | 2020-11-30 | Louisa | Virginia | 51109 | 532 | 8 |
783884 | 783884 | 2020-11-30 | Lunenburg | Virginia | 51111 | 171 | 4 |
783885 | 783885 | 2020-11-30 | Lynchburg city | Virginia | 51680 | 2758 | 30 |
783886 | 783886 | 2020-11-30 | Madison | Virginia | 51113 | 190 | 4 |
783887 | 783887 | 2020-11-30 | Manassas Park city | Virginia | 51685 | 726 | 8 |
783888 | 783888 | 2020-11-30 | Manassas city | Virginia | 51683 | 2311 | 28 |
783889 | 783889 | 2020-11-30 | Martinsville city | Virginia | 51690 | 709 | 24 |
783890 | 783890 | 2020-11-30 | Mathews | Virginia | 51115 | 160 | 1 |
783891 | 783891 | 2020-11-30 | Mecklenburg | Virginia | 51117 | 1008 | 36 |
783892 | 783892 | 2020-11-30 | Middlesex | Virginia | 51119 | 168 | 11 |
783893 | 783893 | 2020-11-30 | Montgomery | Virginia | 51121 | 3917 | 15 |
783894 | 783894 | 2020-11-30 | Nelson | Virginia | 51125 | 184 | 3 |
783895 | 783895 | 2020-11-30 | New Kent | Virginia | 51127 | 393 | 4 |
783896 | 783896 | 2020-11-30 | Newport News city | Virginia | 51700 | 4061 | 55 |
783897 | 783897 | 2020-11-30 | Norfolk city | Virginia | 51710 | 6528 | 91 |
783898 | 783898 | 2020-11-30 | Northampton | Virginia | 51131 | 352 | 31 |
783899 | 783899 | 2020-11-30 | Northumberland | Virginia | 51133 | 274 | 8 |
783900 | 783900 | 2020-11-30 | Norton city | Virginia | 51720 | 83 | 0 |
783901 | 783901 | 2020-11-30 | Nottoway | Virginia | 51135 | 511 | 22 |
783902 | 783902 | 2020-11-30 | Orange | Virginia | 51137 | 599 | 7 |
783903 | 783903 | 2020-11-30 | Page | Virginia | 51139 | 593 | 32 |
783904 | 783904 | 2020-11-30 | Patrick | Virginia | 51141 | 468 | 28 |
783905 | 783905 | 2020-11-30 | Petersburg city | Virginia | 51730 | 1123 | 31 |
783906 | 783906 | 2020-11-30 | Pittsylvania | Virginia | 51143 | 1762 | 22 |
783907 | 783907 | 2020-11-30 | Poquoson city | Virginia | 51735 | 146 | 2 |
783908 | 783908 | 2020-11-30 | Portsmouth city | Virginia | 51740 | 3202 | 71 |
783909 | 783909 | 2020-11-30 | Powhatan | Virginia | 51145 | 467 | 6 |
783910 | 783910 | 2020-11-30 | Prince Edward | Virginia | 51147 | 877 | 16 |
783911 | 783911 | 2020-11-30 | Prince George | Virginia | 51149 | 1430 | 7 |
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);