ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
133 rows where date = "2022-01-01" 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 |
---|---|---|---|---|---|---|---|
2073040 | 2073040 | 2022-01-01 | Accomack | Virginia | 51001 | 4545 | 83 |
2073041 | 2073041 | 2022-01-01 | Albemarle | Virginia | 51003 | 9744 | 117 |
2073042 | 2073042 | 2022-01-01 | Alexandria city | Virginia | 51510 | 18480 | 161 |
2073043 | 2073043 | 2022-01-01 | Alleghany | Virginia | 51005 | 2512 | 87 |
2073044 | 2073044 | 2022-01-01 | Amelia | Virginia | 51007 | 1743 | 44 |
2073045 | 2073045 | 2022-01-01 | Amherst | Virginia | 51009 | 4894 | 63 |
2073046 | 2073046 | 2022-01-01 | Appomattox | Virginia | 51011 | 2727 | 38 |
2073047 | 2073047 | 2022-01-01 | Arlington | Virginia | 51013 | 26170 | 283 |
2073048 | 2073048 | 2022-01-01 | Augusta | Virginia | 51015 | 12068 | 141 |
2073049 | 2073049 | 2022-01-01 | Bath | Virginia | 51017 | 582 | 15 |
2073050 | 2073050 | 2022-01-01 | Bedford | Virginia | 51019 | 11447 | 176 |
2073051 | 2073051 | 2022-01-01 | Bland | Virginia | 51021 | 1185 | 18 |
2073052 | 2073052 | 2022-01-01 | Botetourt | Virginia | 51023 | 4825 | 66 |
2073053 | 2073053 | 2022-01-01 | Bristol city | Virginia | 51520 | 2718 | 58 |
2073054 | 2073054 | 2022-01-01 | Brunswick | Virginia | 51025 | 1930 | 36 |
2073055 | 2073055 | 2022-01-01 | Buchanan | Virginia | 51027 | 3110 | 87 |
2073056 | 2073056 | 2022-01-01 | Buckingham | Virginia | 51029 | 2882 | 41 |
2073057 | 2073057 | 2022-01-01 | Buena Vista city | Virginia | 51530 | 1511 | 34 |
2073058 | 2073058 | 2022-01-01 | Campbell | Virginia | 51031 | 8364 | 157 |
2073059 | 2073059 | 2022-01-01 | Caroline | Virginia | 51033 | 4847 | 58 |
2073060 | 2073060 | 2022-01-01 | Carroll | Virginia | 51035 | 4745 | 113 |
2073061 | 2073061 | 2022-01-01 | Charles City | Virginia | 51036 | 829 | 22 |
2073062 | 2073062 | 2022-01-01 | Charlotte | Virginia | 51037 | 1535 | 30 |
2073063 | 2073063 | 2022-01-01 | Charlottesville city | Virginia | 51540 | 6225 | 64 |
2073064 | 2073064 | 2022-01-01 | Chesapeake city | Virginia | 51550 | 33380 | 381 |
2073065 | 2073065 | 2022-01-01 | Chesterfield | Virginia | 51041 | 48029 | 607 |
2073066 | 2073066 | 2022-01-01 | Clarke | Virginia | 51043 | 1827 | 33 |
2073067 | 2073067 | 2022-01-01 | Colonial Heights city | Virginia | 51570 | 3095 | 71 |
2073068 | 2073068 | 2022-01-01 | Covington city | Virginia | 51580 | 818 | 19 |
2073069 | 2073069 | 2022-01-01 | Craig | Virginia | 51045 | 761 | 11 |
2073070 | 2073070 | 2022-01-01 | Culpeper | Virginia | 51047 | 8139 | 95 |
2073071 | 2073071 | 2022-01-01 | Cumberland | Virginia | 51049 | 850 | 19 |
2073072 | 2073072 | 2022-01-01 | Danville city | Virginia | 51590 | 7029 | 211 |
2073073 | 2073073 | 2022-01-01 | Dickenson | Virginia | 51051 | 2222 | 38 |
2073074 | 2073074 | 2022-01-01 | Dinwiddie | Virginia | 51053 | 3735 | 62 |
2073075 | 2073075 | 2022-01-01 | Emporia city | Virginia | 51595 | 887 | 46 |
2073076 | 2073076 | 2022-01-01 | Essex | Virginia | 51057 | 1498 | 21 |
2073077 | 2073077 | 2022-01-01 | Fairfax | Virginia | 51059 | 116752 | 1210 |
2073078 | 2073078 | 2022-01-01 | Fairfax city | Virginia | 51600 | 1329 | 36 |
2073079 | 2073079 | 2022-01-01 | Falls Church city | Virginia | 51610 | 984 | 14 |
2073080 | 2073080 | 2022-01-01 | Fauquier | Virginia | 51061 | 9137 | 95 |
2073081 | 2073081 | 2022-01-01 | Floyd | Virginia | 51063 | 1790 | 33 |
2073082 | 2073082 | 2022-01-01 | Fluvanna | Virginia | 51065 | 3328 | 32 |
2073083 | 2073083 | 2022-01-01 | Franklin | Virginia | 51067 | 7387 | 129 |
2073084 | 2073084 | 2022-01-01 | Franklin city | Virginia | 51620 | 1784 | 44 |
2073085 | 2073085 | 2022-01-01 | Frederick | Virginia | 51069 | 14580 | 184 |
2073086 | 2073086 | 2022-01-01 | Fredericksburg city | Virginia | 51630 | 3691 | 27 |
2073087 | 2073087 | 2022-01-01 | Galax city | Virginia | 51640 | 1758 | 69 |
2073088 | 2073088 | 2022-01-01 | Giles | Virginia | 51071 | 2612 | 38 |
2073089 | 2073089 | 2022-01-01 | Gloucester | Virginia | 51073 | 4493 | 83 |
2073090 | 2073090 | 2022-01-01 | Goochland | Virginia | 51075 | 2569 | 35 |
2073091 | 2073091 | 2022-01-01 | Grayson | Virginia | 51077 | 2612 | 62 |
2073092 | 2073092 | 2022-01-01 | Greene | Virginia | 51079 | 2647 | 47 |
2073093 | 2073093 | 2022-01-01 | Greensville | Virginia | 51081 | 2076 | 30 |
2073094 | 2073094 | 2022-01-01 | Halifax | Virginia | 51083 | 4569 | 127 |
2073095 | 2073095 | 2022-01-01 | Hampton city | Virginia | 51650 | 17525 | 256 |
2073096 | 2073096 | 2022-01-01 | Hanover | Virginia | 51085 | 14552 | 208 |
2073097 | 2073097 | 2022-01-01 | Harrisonburg city | Virginia | 51660 | 9119 | 116 |
2073098 | 2073098 | 2022-01-01 | Henrico | Virginia | 51087 | 42631 | 749 |
2073099 | 2073099 | 2022-01-01 | Henry | Virginia | 51089 | 7733 | 211 |
2073100 | 2073100 | 2022-01-01 | Highland | Virginia | 51091 | 234 | 4 |
2073101 | 2073101 | 2022-01-01 | Hopewell city | Virginia | 51670 | 4160 | 97 |
2073102 | 2073102 | 2022-01-01 | Isle of Wight | Virginia | 51093 | 5097 | 93 |
2073103 | 2073103 | 2022-01-01 | James City | Virginia | 51095 | 8583 | 100 |
2073104 | 2073104 | 2022-01-01 | King George | Virginia | 51099 | 3348 | 27 |
2073105 | 2073105 | 2022-01-01 | King William | Virginia | 51101 | 2491 | 27 |
2073106 | 2073106 | 2022-01-01 | King and Queen | Virginia | 51097 | 755 | 9 |
2073107 | 2073107 | 2022-01-01 | Lancaster | Virginia | 51103 | 1195 | 24 |
2073108 | 2073108 | 2022-01-01 | Lee | Virginia | 51105 | 4146 | 67 |
2073109 | 2073109 | 2022-01-01 | Lexington city | Virginia | 51678 | 1739 | 38 |
2073110 | 2073110 | 2022-01-01 | Loudoun | Virginia | 51107 | 44607 | 314 |
2073111 | 2073111 | 2022-01-01 | Louisa | Virginia | 51109 | 4209 | 54 |
2073112 | 2073112 | 2022-01-01 | Lunenburg | Virginia | 51111 | 1311 | 23 |
2073113 | 2073113 | 2022-01-01 | Lynchburg city | Virginia | 51680 | 13205 | 216 |
2073114 | 2073114 | 2022-01-01 | Madison | Virginia | 51113 | 1355 | 25 |
2073115 | 2073115 | 2022-01-01 | Manassas Park city | Virginia | 51685 | 1319 | 16 |
2073116 | 2073116 | 2022-01-01 | Manassas city | Virginia | 51683 | 6346 | 57 |
2073117 | 2073117 | 2022-01-01 | Martinsville city | Virginia | 51690 | 2391 | 100 |
2073118 | 2073118 | 2022-01-01 | Mathews | Virginia | 51115 | 1014 | 24 |
2073119 | 2073119 | 2022-01-01 | Mecklenburg | Virginia | 51117 | 3827 | 98 |
2073120 | 2073120 | 2022-01-01 | Middlesex | Virginia | 51119 | 1132 | 34 |
2073121 | 2073121 | 2022-01-01 | Montgomery | Virginia | 51121 | 13097 | 120 |
2073122 | 2073122 | 2022-01-01 | Nelson | Virginia | 51125 | 1726 | 24 |
2073123 | 2073123 | 2022-01-01 | New Kent | Virginia | 51127 | 2956 | 28 |
2073124 | 2073124 | 2022-01-01 | Newport News city | Virginia | 51700 | 23673 | 320 |
2073125 | 2073125 | 2022-01-01 | Norfolk city | Virginia | 51710 | 27953 | 370 |
2073126 | 2073126 | 2022-01-01 | Northampton | Virginia | 51131 | 1263 | 49 |
2073127 | 2073127 | 2022-01-01 | Northumberland | Virginia | 51133 | 1400 | 39 |
2073128 | 2073128 | 2022-01-01 | Norton city | Virginia | 51720 | 768 | 20 |
2073129 | 2073129 | 2022-01-01 | Nottoway | Virginia | 51135 | 2871 | 71 |
2073130 | 2073130 | 2022-01-01 | Orange | Virginia | 51137 | 4698 | 69 |
2073131 | 2073131 | 2022-01-01 | Page | Virginia | 51139 | 4149 | 92 |
2073132 | 2073132 | 2022-01-01 | Patrick | Virginia | 51141 | 2553 | 72 |
2073133 | 2073133 | 2022-01-01 | Petersburg city | Virginia | 51730 | 5737 | 109 |
2073134 | 2073134 | 2022-01-01 | Pittsylvania | Virginia | 51143 | 9155 | 141 |
2073135 | 2073135 | 2022-01-01 | Poquoson city | Virginia | 51735 | 1514 | 23 |
2073136 | 2073136 | 2022-01-01 | Portsmouth city | Virginia | 51740 | 14523 | 256 |
2073137 | 2073137 | 2022-01-01 | Powhatan | Virginia | 51145 | 3384 | 31 |
2073138 | 2073138 | 2022-01-01 | Prince Edward | Virginia | 51147 | 3223 | 54 |
2073139 | 2073139 | 2022-01-01 | Prince George | Virginia | 51149 | 5740 | 52 |
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);