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 2021-09-07 and state = "Virginia" sorted by date descending
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 |
---|---|---|---|---|---|---|---|
1696084 | 1696084 | 2021-09-07 | Accomack | Virginia | 51001 | 3442 | 57 |
1696085 | 1696085 | 2021-09-07 | Albemarle | Virginia | 51003 | 6732 | 85 |
1696086 | 1696086 | 2021-09-07 | Alexandria city | Virginia | 51510 | 12994 | 142 |
1696087 | 1696087 | 2021-09-07 | Alleghany | Virginia | 51005 | 1637 | 52 |
1696088 | 1696088 | 2021-09-07 | Amelia | Virginia | 51007 | 1123 | 38 |
1696089 | 1696089 | 2021-09-07 | Amherst | Virginia | 51009 | 3634 | 43 |
1696090 | 1696090 | 2021-09-07 | Appomattox | Virginia | 51011 | 1937 | 29 |
1696091 | 1696091 | 2021-09-07 | Arlington | Virginia | 51013 | 16872 | 261 |
1696092 | 1696092 | 2021-09-07 | Augusta | Virginia | 51015 | 7909 | 90 |
1696093 | 1696093 | 2021-09-07 | Bath | Virginia | 51017 | 324 | 11 |
1696094 | 1696094 | 2021-09-07 | Bedford | Virginia | 51019 | 7963 | 115 |
1696095 | 1696095 | 2021-09-07 | Bland | Virginia | 51021 | 849 | 10 |
1696096 | 1696096 | 2021-09-07 | Botetourt | Virginia | 51023 | 3054 | 39 |
1696097 | 1696097 | 2021-09-07 | Bristol city | Virginia | 51520 | 1912 | 41 |
1696098 | 1696098 | 2021-09-07 | Brunswick | Virginia | 51025 | 1570 | 27 |
1696099 | 1696099 | 2021-09-07 | Buchanan | Virginia | 51027 | 1892 | 47 |
1696100 | 1696100 | 2021-09-07 | Buckingham | Virginia | 51029 | 2362 | 34 |
1696101 | 1696101 | 2021-09-07 | Buena Vista city | Virginia | 51530 | 1015 | 22 |
1696102 | 1696102 | 2021-09-07 | Campbell | Virginia | 51031 | 5844 | 116 |
1696103 | 1696103 | 2021-09-07 | Caroline | Virginia | 51033 | 3272 | 43 |
1696104 | 1696104 | 2021-09-07 | Carroll | Virginia | 51035 | 3170 | 81 |
1696105 | 1696105 | 2021-09-07 | Charles City | Virginia | 51036 | 597 | 16 |
1696106 | 1696106 | 2021-09-07 | Charlotte | Virginia | 51037 | 1046 | 22 |
1696107 | 1696107 | 2021-09-07 | Charlottesville city | Virginia | 51540 | 4611 | 58 |
1696108 | 1696108 | 2021-09-07 | Chesapeake city | Virginia | 51550 | 25197 | 319 |
1696109 | 1696109 | 2021-09-07 | Chesterfield | Virginia | 51041 | 33725 | 472 |
1696110 | 1696110 | 2021-09-07 | Clarke | Virginia | 51043 | 1104 | 21 |
1696111 | 1696111 | 2021-09-07 | Colonial Heights city | Virginia | 51570 | 2137 | 62 |
1696112 | 1696112 | 2021-09-07 | Covington city | Virginia | 51580 | 666 | 14 |
1696113 | 1696113 | 2021-09-07 | Craig | Virginia | 51045 | 421 | 6 |
1696114 | 1696114 | 2021-09-07 | Culpeper | Virginia | 51047 | 5411 | 70 |
1696115 | 1696115 | 2021-09-07 | Cumberland | Virginia | 51049 | 605 | 10 |
1696116 | 1696116 | 2021-09-07 | Danville city | Virginia | 51590 | 5232 | 155 |
1696117 | 1696117 | 2021-09-07 | Dickenson | Virginia | 51051 | 1200 | 19 |
1696118 | 1696118 | 2021-09-07 | Dinwiddie | Virginia | 51053 | 2602 | 46 |
1696119 | 1696119 | 2021-09-07 | Emporia city | Virginia | 51595 | 780 | 42 |
1696120 | 1696120 | 2021-09-07 | Essex | Virginia | 51057 | 911 | 11 |
1696121 | 1696121 | 2021-09-07 | Fairfax | Virginia | 51059 | 84056 | 1140 |
1696122 | 1696122 | 2021-09-07 | Fairfax city | Virginia | 51600 | 607 | 19 |
1696123 | 1696123 | 2021-09-07 | Falls Church city | Virginia | 51610 | 488 | 8 |
1696124 | 1696124 | 2021-09-07 | Fauquier | Virginia | 51061 | 5807 | 72 |
1696125 | 1696125 | 2021-09-07 | Floyd | Virginia | 51063 | 1102 | 23 |
1696126 | 1696126 | 2021-09-07 | Fluvanna | Virginia | 51065 | 2196 | 22 |
1696127 | 1696127 | 2021-09-07 | Franklin | Virginia | 51067 | 4948 | 84 |
1696128 | 1696128 | 2021-09-07 | Franklin city | Virginia | 51620 | 1316 | 36 |
1696129 | 1696129 | 2021-09-07 | Frederick | Virginia | 51069 | 9445 | 107 |
1696130 | 1696130 | 2021-09-07 | Fredericksburg city | Virginia | 51630 | 2547 | 25 |
1696131 | 1696131 | 2021-09-07 | Galax city | Virginia | 51640 | 1329 | 53 |
1696132 | 1696132 | 2021-09-07 | Giles | Virginia | 51071 | 1615 | 24 |
1696133 | 1696133 | 2021-09-07 | Gloucester | Virginia | 51073 | 3106 | 53 |
1696134 | 1696134 | 2021-09-07 | Goochland | Virginia | 51075 | 1720 | 25 |
1696135 | 1696135 | 2021-09-07 | Grayson | Virginia | 51077 | 1732 | 40 |
1696136 | 1696136 | 2021-09-07 | Greene | Virginia | 51079 | 1635 | 23 |
1696137 | 1696137 | 2021-09-07 | Greensville | Virginia | 51081 | 1701 | 26 |
1696138 | 1696138 | 2021-09-07 | Halifax | Virginia | 51083 | 3242 | 89 |
1696139 | 1696139 | 2021-09-07 | Hampton city | Virginia | 51650 | 12948 | 193 |
1696140 | 1696140 | 2021-09-07 | Hanover | Virginia | 51085 | 9941 | 176 |
1696141 | 1696141 | 2021-09-07 | Harrisonburg city | Virginia | 51660 | 7237 | 96 |
1696142 | 1696142 | 2021-09-07 | Henrico | Virginia | 51087 | 30243 | 656 |
1696143 | 1696143 | 2021-09-07 | Henry | Virginia | 51089 | 5445 | 130 |
1696144 | 1696144 | 2021-09-07 | Highland | Virginia | 51091 | 129 | 1 |
1696145 | 1696145 | 2021-09-07 | Hopewell city | Virginia | 51670 | 3212 | 82 |
1696146 | 1696146 | 2021-09-07 | Isle of Wight | Virginia | 51093 | 3726 | 74 |
1696147 | 1696147 | 2021-09-07 | James City | Virginia | 51095 | 5802 | 78 |
1696148 | 1696148 | 2021-09-07 | King George | Virginia | 51099 | 2048 | 21 |
1696149 | 1696149 | 2021-09-07 | King William | Virginia | 51101 | 1542 | 16 |
1696150 | 1696150 | 2021-09-07 | King and Queen | Virginia | 51097 | 506 | 7 |
1696151 | 1696151 | 2021-09-07 | Lancaster | Virginia | 51103 | 917 | 19 |
1696152 | 1696152 | 2021-09-07 | Lee | Virginia | 51105 | 2845 | 48 |
1696153 | 1696153 | 2021-09-07 | Lexington city | Virginia | 51678 | 1346 | 33 |
1696154 | 1696154 | 2021-09-07 | Loudoun | Virginia | 51107 | 30903 | 285 |
1696155 | 1696155 | 2021-09-07 | Louisa | Virginia | 51109 | 2454 | 36 |
1696156 | 1696156 | 2021-09-07 | Lunenburg | Virginia | 51111 | 905 | 18 |
1696157 | 1696157 | 2021-09-07 | Lynchburg city | Virginia | 51680 | 8994 | 158 |
1696158 | 1696158 | 2021-09-07 | Madison | Virginia | 51113 | 752 | 17 |
1696159 | 1696159 | 2021-09-07 | Manassas Park city | Virginia | 51685 | 1248 | 11 |
1696160 | 1696160 | 2021-09-07 | Manassas city | Virginia | 51683 | 4580 | 49 |
1696161 | 1696161 | 2021-09-07 | Martinsville city | Virginia | 51690 | 1807 | 81 |
1696162 | 1696162 | 2021-09-07 | Mathews | Virginia | 51115 | 757 | 14 |
1696163 | 1696163 | 2021-09-07 | Mecklenburg | Virginia | 51117 | 2816 | 71 |
1696164 | 1696164 | 2021-09-07 | Middlesex | Virginia | 51119 | 715 | 23 |
1696165 | 1696165 | 2021-09-07 | Montgomery | Virginia | 51121 | 10375 | 83 |
1696166 | 1696166 | 2021-09-07 | Nelson | Virginia | 51125 | 1084 | 14 |
1696167 | 1696167 | 2021-09-07 | New Kent | Virginia | 51127 | 1858 | 19 |
1696168 | 1696168 | 2021-09-07 | Newport News city | Virginia | 51700 | 17661 | 252 |
1696169 | 1696169 | 2021-09-07 | Norfolk city | Virginia | 51710 | 21357 | 288 |
1696170 | 1696170 | 2021-09-07 | Northampton | Virginia | 51131 | 942 | 38 |
1696171 | 1696171 | 2021-09-07 | Northumberland | Virginia | 51133 | 968 | 21 |
1696172 | 1696172 | 2021-09-07 | Norton city | Virginia | 51720 | 384 | 8 |
1696173 | 1696173 | 2021-09-07 | Nottoway | Virginia | 51135 | 2245 | 56 |
1696174 | 1696174 | 2021-09-07 | Orange | Virginia | 51137 | 2793 | 42 |
1696175 | 1696175 | 2021-09-07 | Page | Virginia | 51139 | 2516 | 61 |
1696176 | 1696176 | 2021-09-07 | Patrick | Virginia | 51141 | 1704 | 47 |
1696177 | 1696177 | 2021-09-07 | Petersburg city | Virginia | 51730 | 4575 | 93 |
1696178 | 1696178 | 2021-09-07 | Pittsylvania | Virginia | 51143 | 6633 | 88 |
1696179 | 1696179 | 2021-09-07 | Poquoson city | Virginia | 51735 | 1054 | 18 |
1696180 | 1696180 | 2021-09-07 | Portsmouth city | Virginia | 51740 | 10819 | 211 |
1696181 | 1696181 | 2021-09-07 | Powhatan | Virginia | 51145 | 2331 | 18 |
1696182 | 1696182 | 2021-09-07 | Prince Edward | Virginia | 51147 | 2463 | 40 |
1696183 | 1696183 | 2021-09-07 | Prince George | Virginia | 51149 | 4274 | 33 |
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);