ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
133 rows where date = "2021-11-10" 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 |
---|---|---|---|---|---|---|---|
1904024 | 1904024 | 2021-11-10 | Accomack | Virginia | 51001 | 4124 | 80 |
1904025 | 1904025 | 2021-11-10 | Albemarle | Virginia | 51003 | 8222 | 106 |
1904026 | 1904026 | 2021-11-10 | Alexandria city | Virginia | 51510 | 14488 | 151 |
1904027 | 1904027 | 2021-11-10 | Alleghany | Virginia | 51005 | 2174 | 79 |
1904028 | 1904028 | 2021-11-10 | Amelia | Virginia | 51007 | 1477 | 40 |
1904029 | 1904029 | 2021-11-10 | Amherst | Virginia | 51009 | 4425 | 60 |
1904030 | 1904030 | 2021-11-10 | Appomattox | Virginia | 51011 | 2433 | 36 |
1904031 | 1904031 | 2021-11-10 | Arlington | Virginia | 51013 | 18915 | 273 |
1904032 | 1904032 | 2021-11-10 | Augusta | Virginia | 51015 | 10346 | 133 |
1904033 | 1904033 | 2021-11-10 | Bath | Virginia | 51017 | 496 | 15 |
1904034 | 1904034 | 2021-11-10 | Bedford | Virginia | 51019 | 10114 | 159 |
1904035 | 1904035 | 2021-11-10 | Bland | Virginia | 51021 | 1106 | 17 |
1904036 | 1904036 | 2021-11-10 | Botetourt | Virginia | 51023 | 3987 | 53 |
1904037 | 1904037 | 2021-11-10 | Bristol city | Virginia | 51520 | 2313 | 48 |
1904038 | 1904038 | 2021-11-10 | Brunswick | Virginia | 51025 | 1824 | 33 |
1904039 | 1904039 | 2021-11-10 | Buchanan | Virginia | 51027 | 2604 | 70 |
1904040 | 1904040 | 2021-11-10 | Buckingham | Virginia | 51029 | 2701 | 38 |
1904041 | 1904041 | 2021-11-10 | Buena Vista city | Virginia | 51530 | 1363 | 27 |
1904042 | 1904042 | 2021-11-10 | Campbell | Virginia | 51031 | 7336 | 141 |
1904043 | 1904043 | 2021-11-10 | Caroline | Virginia | 51033 | 4049 | 52 |
1904044 | 1904044 | 2021-11-10 | Carroll | Virginia | 51035 | 4091 | 100 |
1904045 | 1904045 | 2021-11-10 | Charles City | Virginia | 51036 | 695 | 21 |
1904046 | 1904046 | 2021-11-10 | Charlotte | Virginia | 51037 | 1315 | 27 |
1904047 | 1904047 | 2021-11-10 | Charlottesville city | Virginia | 51540 | 5392 | 59 |
1904048 | 1904048 | 2021-11-10 | Chesapeake city | Virginia | 51550 | 29128 | 365 |
1904049 | 1904049 | 2021-11-10 | Chesterfield | Virginia | 51041 | 40272 | 557 |
1904050 | 1904050 | 2021-11-10 | Clarke | Virginia | 51043 | 1417 | 25 |
1904051 | 1904051 | 2021-11-10 | Colonial Heights city | Virginia | 51570 | 2625 | 67 |
1904052 | 1904052 | 2021-11-10 | Covington city | Virginia | 51580 | 764 | 16 |
1904053 | 1904053 | 2021-11-10 | Craig | Virginia | 51045 | 567 | 9 |
1904054 | 1904054 | 2021-11-10 | Culpeper | Virginia | 51047 | 6665 | 86 |
1904055 | 1904055 | 2021-11-10 | Cumberland | Virginia | 51049 | 725 | 18 |
1904056 | 1904056 | 2021-11-10 | Danville city | Virginia | 51590 | 6330 | 195 |
1904057 | 1904057 | 2021-11-10 | Dickenson | Virginia | 51051 | 1726 | 28 |
1904058 | 1904058 | 2021-11-10 | Dinwiddie | Virginia | 51053 | 3318 | 54 |
1904059 | 1904059 | 2021-11-10 | Emporia city | Virginia | 51595 | 846 | 45 |
1904060 | 1904060 | 2021-11-10 | Essex | Virginia | 51057 | 1275 | 20 |
1904061 | 1904061 | 2021-11-10 | Fairfax | Virginia | 51059 | 92723 | 1171 |
1904062 | 1904062 | 2021-11-10 | Fairfax city | Virginia | 51600 | 854 | 30 |
1904063 | 1904063 | 2021-11-10 | Falls Church city | Virginia | 51610 | 616 | 13 |
1904064 | 1904064 | 2021-11-10 | Fauquier | Virginia | 51061 | 7162 | 86 |
1904065 | 1904065 | 2021-11-10 | Floyd | Virginia | 51063 | 1473 | 31 |
1904066 | 1904066 | 2021-11-10 | Fluvanna | Virginia | 51065 | 2773 | 25 |
1904067 | 1904067 | 2021-11-10 | Franklin | Virginia | 51067 | 6154 | 107 |
1904068 | 1904068 | 2021-11-10 | Franklin city | Virginia | 51620 | 1649 | 44 |
1904069 | 1904069 | 2021-11-10 | Frederick | Virginia | 51069 | 11824 | 152 |
1904070 | 1904070 | 2021-11-10 | Fredericksburg city | Virginia | 51630 | 3114 | 26 |
1904071 | 1904071 | 2021-11-10 | Galax city | Virginia | 51640 | 1566 | 63 |
1904072 | 1904072 | 2021-11-10 | Giles | Virginia | 51071 | 2326 | 32 |
1904073 | 1904073 | 2021-11-10 | Gloucester | Virginia | 51073 | 3900 | 78 |
1904074 | 1904074 | 2021-11-10 | Goochland | Virginia | 51075 | 2043 | 30 |
1904075 | 1904075 | 2021-11-10 | Grayson | Virginia | 51077 | 2144 | 47 |
1904076 | 1904076 | 2021-11-10 | Greene | Virginia | 51079 | 2244 | 43 |
1904077 | 1904077 | 2021-11-10 | Greensville | Virginia | 51081 | 1936 | 26 |
1904078 | 1904078 | 2021-11-10 | Halifax | Virginia | 51083 | 3987 | 109 |
1904079 | 1904079 | 2021-11-10 | Hampton city | Virginia | 51650 | 15225 | 240 |
1904080 | 1904080 | 2021-11-10 | Hanover | Virginia | 51085 | 12029 | 198 |
1904081 | 1904081 | 2021-11-10 | Harrisonburg city | Virginia | 51660 | 8318 | 108 |
1904082 | 1904082 | 2021-11-10 | Henrico | Virginia | 51087 | 34851 | 726 |
1904083 | 1904083 | 2021-11-10 | Henry | Virginia | 51089 | 6669 | 165 |
1904084 | 1904084 | 2021-11-10 | Highland | Virginia | 51091 | 187 | 4 |
1904085 | 1904085 | 2021-11-10 | Hopewell city | Virginia | 51670 | 3659 | 88 |
1904086 | 1904086 | 2021-11-10 | Isle of Wight | Virginia | 51093 | 4530 | 89 |
1904087 | 1904087 | 2021-11-10 | James City | Virginia | 51095 | 7149 | 94 |
1904088 | 1904088 | 2021-11-10 | King George | Virginia | 51099 | 2713 | 23 |
1904089 | 1904089 | 2021-11-10 | King William | Virginia | 51101 | 1985 | 24 |
1904090 | 1904090 | 2021-11-10 | King and Queen | Virginia | 51097 | 647 | 8 |
1904091 | 1904091 | 2021-11-10 | Lancaster | Virginia | 51103 | 1073 | 23 |
1904092 | 1904092 | 2021-11-10 | Lee | Virginia | 51105 | 3766 | 60 |
1904093 | 1904093 | 2021-11-10 | Lexington city | Virginia | 51678 | 1595 | 36 |
1904094 | 1904094 | 2021-11-10 | Loudoun | Virginia | 51107 | 34655 | 301 |
1904095 | 1904095 | 2021-11-10 | Louisa | Virginia | 51109 | 3348 | 49 |
1904096 | 1904096 | 2021-11-10 | Lunenburg | Virginia | 51111 | 1132 | 22 |
1904097 | 1904097 | 2021-11-10 | Lynchburg city | Virginia | 51680 | 11872 | 191 |
1904098 | 1904098 | 2021-11-10 | Madison | Virginia | 51113 | 1026 | 22 |
1904099 | 1904099 | 2021-11-10 | Manassas Park city | Virginia | 51685 | 1285 | 13 |
1904100 | 1904100 | 2021-11-10 | Manassas city | Virginia | 51683 | 5138 | 53 |
1904101 | 1904101 | 2021-11-10 | Martinsville city | Virginia | 51690 | 2114 | 89 |
1904102 | 1904102 | 2021-11-10 | Mathews | Virginia | 51115 | 898 | 24 |
1904103 | 1904103 | 2021-11-10 | Mecklenburg | Virginia | 51117 | 3470 | 86 |
1904104 | 1904104 | 2021-11-10 | Middlesex | Virginia | 51119 | 952 | 33 |
1904105 | 1904105 | 2021-11-10 | Montgomery | Virginia | 51121 | 11921 | 110 |
1904106 | 1904106 | 2021-11-10 | Nelson | Virginia | 51125 | 1400 | 18 |
1904107 | 1904107 | 2021-11-10 | New Kent | Virginia | 51127 | 2467 | 25 |
1904108 | 1904108 | 2021-11-10 | Newport News city | Virginia | 51700 | 20826 | 303 |
1904109 | 1904109 | 2021-11-10 | Norfolk city | Virginia | 51710 | 24682 | 345 |
1904110 | 1904110 | 2021-11-10 | Northampton | Virginia | 51131 | 1161 | 46 |
1904111 | 1904111 | 2021-11-10 | Northumberland | Virginia | 51133 | 1229 | 34 |
1904112 | 1904112 | 2021-11-10 | Norton city | Virginia | 51720 | 611 | 15 |
1904113 | 1904113 | 2021-11-10 | Nottoway | Virginia | 51135 | 2632 | 68 |
1904114 | 1904114 | 2021-11-10 | Orange | Virginia | 51137 | 3808 | 60 |
1904115 | 1904115 | 2021-11-10 | Page | Virginia | 51139 | 3449 | 80 |
1904116 | 1904116 | 2021-11-10 | Patrick | Virginia | 51141 | 2143 | 56 |
1904117 | 1904117 | 2021-11-10 | Petersburg city | Virginia | 51730 | 5132 | 106 |
1904118 | 1904118 | 2021-11-10 | Pittsylvania | Virginia | 51143 | 8293 | 122 |
1904119 | 1904119 | 2021-11-10 | Poquoson city | Virginia | 51735 | 1355 | 22 |
1904120 | 1904120 | 2021-11-10 | Portsmouth city | Virginia | 51740 | 12813 | 246 |
1904121 | 1904121 | 2021-11-10 | Powhatan | Virginia | 51145 | 2864 | 28 |
1904122 | 1904122 | 2021-11-10 | Prince Edward | Virginia | 51147 | 2967 | 52 |
1904123 | 1904123 | 2021-11-10 | Prince George | Virginia | 51149 | 5155 | 48 |
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);