ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
134 rows where date = "2022-01-21" 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 · 134 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2138079 | 2138079 | 2022-01-21 | Accomack | Virginia | 51001 | 6230 | 86 |
2138080 | 2138080 | 2022-01-21 | Albemarle | Virginia | 51003 | 12616 | 121 |
2138081 | 2138081 | 2022-01-21 | Alexandria city | Virginia | 51510 | 26871 | 165 |
2138082 | 2138082 | 2022-01-21 | Alleghany | Virginia | 51005 | 3016 | 90 |
2138083 | 2138083 | 2022-01-21 | Amelia | Virginia | 51007 | 2226 | 44 |
2138084 | 2138084 | 2022-01-21 | Amherst | Virginia | 51009 | 5852 | 65 |
2138085 | 2138085 | 2022-01-21 | Appomattox | Virginia | 51011 | 3139 | 41 |
2138086 | 2138086 | 2022-01-21 | Arlington | Virginia | 51013 | 36214 | 286 |
2138087 | 2138087 | 2022-01-21 | Augusta | Virginia | 51015 | 15686 | 152 |
2138088 | 2138088 | 2022-01-21 | Bath | Virginia | 51017 | 713 | 15 |
2138089 | 2138089 | 2022-01-21 | Bedford | Virginia | 51019 | 13782 | 179 |
2138090 | 2138090 | 2022-01-21 | Bland | Virginia | 51021 | 1412 | 18 |
2138091 | 2138091 | 2022-01-21 | Botetourt | Virginia | 51023 | 6007 | 67 |
2138092 | 2138092 | 2022-01-21 | Bristol city | Virginia | 51520 | 3404 | 61 |
2138093 | 2138093 | 2022-01-21 | Brunswick | Virginia | 51025 | 2406 | 37 |
2138094 | 2138094 | 2022-01-21 | Buchanan | Virginia | 51027 | 3769 | 90 |
2138095 | 2138095 | 2022-01-21 | Buckingham | Virginia | 51029 | 3296 | 41 |
2138096 | 2138096 | 2022-01-21 | Buena Vista city | Virginia | 51530 | 1726 | 34 |
2138097 | 2138097 | 2022-01-21 | Campbell | Virginia | 51031 | 9666 | 165 |
2138098 | 2138098 | 2022-01-21 | Caroline | Virginia | 51033 | 6032 | 59 |
2138099 | 2138099 | 2022-01-21 | Carroll | Virginia | 51035 | 5504 | 114 |
2138100 | 2138100 | 2022-01-21 | Charles City | Virginia | 51036 | 1015 | 22 |
2138101 | 2138101 | 2022-01-21 | Charlotte | Virginia | 51037 | 1977 | 32 |
2138102 | 2138102 | 2022-01-21 | Charlottesville city | Virginia | 51540 | 8238 | 64 |
2138103 | 2138103 | 2022-01-21 | Chesapeake city | Virginia | 51550 | 44946 | 383 |
2138104 | 2138104 | 2022-01-21 | Chesterfield | Virginia | 51041 | 62461 | 611 |
2138105 | 2138105 | 2022-01-21 | Clarke | Virginia | 51043 | 2277 | 35 |
2138106 | 2138106 | 2022-01-21 | Colonial Heights city | Virginia | 51570 | 4100 | 72 |
2138107 | 2138107 | 2022-01-21 | Covington city | Virginia | 51580 | 879 | 20 |
2138108 | 2138108 | 2022-01-21 | Craig | Virginia | 51045 | 915 | 11 |
2138109 | 2138109 | 2022-01-21 | Culpeper | Virginia | 51047 | 10113 | 97 |
2138110 | 2138110 | 2022-01-21 | Cumberland | Virginia | 51049 | 1047 | 19 |
2138111 | 2138111 | 2022-01-21 | Danville city | Virginia | 51590 | 9270 | 213 |
2138112 | 2138112 | 2022-01-21 | Dickenson | Virginia | 51051 | 2635 | 40 |
2138113 | 2138113 | 2022-01-21 | Dinwiddie | Virginia | 51053 | 4585 | 63 |
2138114 | 2138114 | 2022-01-21 | Emporia city | Virginia | 51595 | 998 | 46 |
2138115 | 2138115 | 2022-01-21 | Essex | Virginia | 51057 | 1986 | 22 |
2138116 | 2138116 | 2022-01-21 | Fairfax | Virginia | 51059 | 158184 | 1218 |
2138117 | 2138117 | 2022-01-21 | Fairfax city | Virginia | 51600 | 1846 | 36 |
2138118 | 2138118 | 2022-01-21 | Falls Church city | Virginia | 51610 | 1638 | 14 |
2138119 | 2138119 | 2022-01-21 | Fauquier | Virginia | 51061 | 11487 | 100 |
2138120 | 2138120 | 2022-01-21 | Floyd | Virginia | 51063 | 2133 | 33 |
2138121 | 2138121 | 2022-01-21 | Fluvanna | Virginia | 51065 | 4045 | 33 |
2138122 | 2138122 | 2022-01-21 | Franklin | Virginia | 51067 | 9124 | 134 |
2138123 | 2138123 | 2022-01-21 | Franklin city | Virginia | 51620 | 2260 | 43 |
2138124 | 2138124 | 2022-01-21 | Frederick | Virginia | 51069 | 18268 | 188 |
2138125 | 2138125 | 2022-01-21 | Fredericksburg city | Virginia | 51630 | 4769 | 28 |
2138126 | 2138126 | 2022-01-21 | Galax city | Virginia | 51640 | 2136 | 71 |
2138127 | 2138127 | 2022-01-21 | Giles | Virginia | 51071 | 3114 | 38 |
2138128 | 2138128 | 2022-01-21 | Gloucester | Virginia | 51073 | 6356 | 84 |
2138129 | 2138129 | 2022-01-21 | Goochland | Virginia | 51075 | 3293 | 36 |
2138130 | 2138130 | 2022-01-21 | Grayson | Virginia | 51077 | 2949 | 67 |
2138131 | 2138131 | 2022-01-21 | Greene | Virginia | 51079 | 3362 | 47 |
2138132 | 2138132 | 2022-01-21 | Greensville | Virginia | 51081 | 2991 | 30 |
2138133 | 2138133 | 2022-01-21 | Halifax | Virginia | 51083 | 5879 | 127 |
2138134 | 2138134 | 2022-01-21 | Hampton city | Virginia | 51650 | 24737 | 258 |
2138135 | 2138135 | 2022-01-21 | Hanover | Virginia | 51085 | 18533 | 209 |
2138136 | 2138136 | 2022-01-21 | Harrisonburg city | Virginia | 51660 | 11412 | 118 |
2138137 | 2138137 | 2022-01-21 | Henrico | Virginia | 51087 | 55547 | 754 |
2138138 | 2138138 | 2022-01-21 | Henry | Virginia | 51089 | 9415 | 212 |
2138139 | 2138139 | 2022-01-21 | Highland | Virginia | 51091 | 290 | 4 |
2138140 | 2138140 | 2022-01-21 | Hopewell city | Virginia | 51670 | 5454 | 99 |
2138141 | 2138141 | 2022-01-21 | Isle of Wight | Virginia | 51093 | 6561 | 92 |
2138142 | 2138142 | 2022-01-21 | James City | Virginia | 51095 | 12699 | 100 |
2138143 | 2138143 | 2022-01-21 | King George | Virginia | 51099 | 4372 | 27 |
2138144 | 2138144 | 2022-01-21 | King William | Virginia | 51101 | 3220 | 27 |
2138145 | 2138145 | 2022-01-21 | King and Queen | Virginia | 51097 | 994 | 9 |
2138146 | 2138146 | 2022-01-21 | Lancaster | Virginia | 51103 | 1582 | 24 |
2138147 | 2138147 | 2022-01-21 | Lee | Virginia | 51105 | 4741 | 72 |
2138148 | 2138148 | 2022-01-21 | Lexington city | Virginia | 51678 | 2254 | 38 |
2138149 | 2138149 | 2022-01-21 | Loudoun | Virginia | 51107 | 59462 | 315 |
2138150 | 2138150 | 2022-01-21 | Louisa | Virginia | 51109 | 5380 | 53 |
2138151 | 2138151 | 2022-01-21 | Lunenburg | Virginia | 51111 | 1686 | 24 |
2138152 | 2138152 | 2022-01-21 | Lynchburg city | Virginia | 51680 | 16617 | 224 |
2138153 | 2138153 | 2022-01-21 | Madison | Virginia | 51113 | 1747 | 25 |
2138154 | 2138154 | 2022-01-21 | Manassas Park city | Virginia | 51685 | 2286 | 16 |
2138155 | 2138155 | 2022-01-21 | Manassas city | Virginia | 51683 | 8228 | 57 |
2138156 | 2138156 | 2022-01-21 | Martinsville city | Virginia | 51690 | 2796 | 100 |
2138157 | 2138157 | 2022-01-21 | Mathews | Virginia | 51115 | 1282 | 24 |
2138158 | 2138158 | 2022-01-21 | Mecklenburg | Virginia | 51117 | 4575 | 100 |
2138159 | 2138159 | 2022-01-21 | Middlesex | Virginia | 51119 | 1542 | 34 |
2138160 | 2138160 | 2022-01-21 | Montgomery | Virginia | 51121 | 15406 | 121 |
2138161 | 2138161 | 2022-01-21 | Nelson | Virginia | 51125 | 2264 | 25 |
2138162 | 2138162 | 2022-01-21 | New Kent | Virginia | 51127 | 3858 | 28 |
2138163 | 2138163 | 2022-01-21 | Newport News city | Virginia | 51700 | 32661 | 320 |
2138164 | 2138164 | 2022-01-21 | Norfolk city | Virginia | 51710 | 37818 | 371 |
2138165 | 2138165 | 2022-01-21 | Northampton | Virginia | 51131 | 1828 | 51 |
2138166 | 2138166 | 2022-01-21 | Northumberland | Virginia | 51133 | 1888 | 39 |
2138167 | 2138167 | 2022-01-21 | Norton city | Virginia | 51720 | 971 | 20 |
2138168 | 2138168 | 2022-01-21 | Nottoway | Virginia | 51135 | 3423 | 72 |
2138169 | 2138169 | 2022-01-21 | Orange | Virginia | 51137 | 5972 | 69 |
2138170 | 2138170 | 2022-01-21 | Page | Virginia | 51139 | 4956 | 93 |
2138171 | 2138171 | 2022-01-21 | Patrick | Virginia | 51141 | 2986 | 72 |
2138172 | 2138172 | 2022-01-21 | Petersburg city | Virginia | 51730 | 7527 | 112 |
2138173 | 2138173 | 2022-01-21 | Pittsylvania | Virginia | 51143 | 11004 | 147 |
2138174 | 2138174 | 2022-01-21 | Poquoson city | Virginia | 51735 | 2079 | 24 |
2138175 | 2138175 | 2022-01-21 | Portsmouth city | Virginia | 51740 | 19014 | 256 |
2138176 | 2138176 | 2022-01-21 | Powhatan | Virginia | 51145 | 4294 | 34 |
2138177 | 2138177 | 2022-01-21 | Prince Edward | Virginia | 51147 | 3924 | 54 |
2138178 | 2138178 | 2022-01-21 | Prince George | Virginia | 51149 | 7045 | 54 |
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);