ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
73 rows where cases = 87 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Highland 7
- Westmoreland 6
- Charles City 4
- Clarke 3
- Fluvanna 2
- Frederick 2
- Goochland 2
- Grayson 2
- Greene 2
- King George 2
- King William 2
- King and Queen 2
- Nelson 2
- Rockbridge 2
- Salem city 2
- Appomattox 1
- Augusta 1
- Buchanan 1
- Craig 1
- Danville city 1
- Dickenson 1
- Fauquier 1
- Franklin city 1
- Galax city 1
- Halifax 1
- Harrisonburg city 1
- Henrico 1
- Hopewell city 1
- Lancaster 1
- Loudoun 1
- …
state 1
- Virginia · 73 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1043505 | 1043505 | 2021-02-18 | Highland | Virginia | 51091 | 87 | 0 |
1040260 | 1040260 | 2021-02-17 | Highland | Virginia | 51091 | 87 | 0 |
1037015 | 1037015 | 2021-02-16 | Highland | Virginia | 51091 | 87 | 0 |
1033770 | 1033770 | 2021-02-15 | Highland | Virginia | 51091 | 87 | 0 |
1030524 | 1030524 | 2021-02-14 | Highland | Virginia | 51091 | 87 | 0 |
1027277 | 1027277 | 2021-02-13 | Highland | Virginia | 51091 | 87 | 0 |
1017542 | 1017542 | 2021-02-10 | Highland | Virginia | 51091 | 87 | 0 |
780670 | 780670 | 2020-11-29 | Rappahannock | Virginia | 51157 | 87 | 2 |
767614 | 767614 | 2020-11-25 | Craig | Virginia | 51045 | 87 | 1 |
689782 | 689782 | 2020-11-01 | King and Queen | Virginia | 51097 | 87 | 2 |
686537 | 686537 | 2020-10-31 | King and Queen | Virginia | 51097 | 87 | 2 |
637901 | 637901 | 2020-10-16 | Poquoson city | Virginia | 51735 | 87 | 2 |
621607 | 621607 | 2020-10-11 | Charles City | Virginia | 51036 | 87 | 5 |
618364 | 618364 | 2020-10-10 | Charles City | Virginia | 51036 | 87 | 5 |
615122 | 615122 | 2020-10-09 | Charles City | Virginia | 51036 | 87 | 5 |
611881 | 611881 | 2020-10-08 | Charles City | Virginia | 51036 | 87 | 5 |
550318 | 550318 | 2020-09-19 | Dickenson | Virginia | 51051 | 87 | 1 |
534126 | 534126 | 2020-09-14 | Clarke | Virginia | 51043 | 87 | 0 |
530891 | 530891 | 2020-09-13 | Clarke | Virginia | 51043 | 87 | 0 |
527654 | 527654 | 2020-09-12 | Clarke | Virginia | 51043 | 87 | 0 |
521223 | 521223 | 2020-09-10 | Lancaster | Virginia | 51103 | 87 | 0 |
518027 | 518027 | 2020-09-09 | Rockbridge | Virginia | 51163 | 87 | 1 |
514792 | 514792 | 2020-09-08 | Rockbridge | Virginia | 51163 | 87 | 1 |
508338 | 508338 | 2020-09-06 | Surry | Virginia | 51181 | 87 | 3 |
501834 | 501834 | 2020-09-04 | Nelson | Virginia | 51125 | 87 | 0 |
498600 | 498600 | 2020-09-03 | Nelson | Virginia | 51125 | 87 | 0 |
482437 | 482437 | 2020-08-29 | Northumberland | Virginia | 51133 | 87 | 4 |
479190 | 479190 | 2020-08-28 | Madison | Virginia | 51113 | 87 | 2 |
450063 | 450063 | 2020-08-19 | Buchanan | Virginia | 51027 | 87 | 1 |
421023 | 421023 | 2020-08-10 | Appomattox | Virginia | 51011 | 87 | 0 |
417861 | 417861 | 2020-08-09 | King William | Virginia | 51101 | 87 | 2 |
414640 | 414640 | 2020-08-08 | King William | Virginia | 51101 | 87 | 2 |
388955 | 388955 | 2020-07-31 | Tazewell | Virginia | 51185 | 87 | 0 |
347151 | 347151 | 2020-07-18 | Franklin city | Virginia | 51620 | 87 | 4 |
337640 | 337640 | 2020-07-15 | Williamsburg city | Virginia | 51830 | 87 | 6 |
334369 | 334369 | 2020-07-14 | Greene | Virginia | 51079 | 87 | 2 |
331176 | 331176 | 2020-07-13 | Greene | Virginia | 51079 | 87 | 2 |
331178 | 331178 | 2020-07-13 | Halifax | Virginia | 51083 | 87 | 1 |
328063 | 328063 | 2020-07-12 | Washington | Virginia | 51191 | 87 | 4 |
324864 | 324864 | 2020-07-11 | Salem city | Virginia | 51775 | 87 | 3 |
321669 | 321669 | 2020-07-10 | Powhatan | Virginia | 51145 | 87 | 2 |
321683 | 321683 | 2020-07-10 | Salem city | Virginia | 51775 | 87 | 3 |
308953 | 308953 | 2020-07-06 | Martinsville city | Virginia | 51690 | 87 | 1 |
299431 | 299431 | 2020-07-03 | Grayson | Virginia | 51077 | 87 | 2 |
296269 | 296269 | 2020-07-02 | Grayson | Virginia | 51077 | 87 | 2 |
293095 | 293095 | 2020-07-01 | Danville city | Virginia | 51590 | 87 | 2 |
264863 | 264863 | 2020-06-22 | Pittsylvania | Virginia | 51143 | 87 | 1 |
255513 | 255513 | 2020-06-19 | Westmoreland | Virginia | 51193 | 87 | 1 |
252394 | 252394 | 2020-06-18 | Westmoreland | Virginia | 51193 | 87 | 1 |
249279 | 249279 | 2020-06-17 | Westmoreland | Virginia | 51193 | 87 | 1 |
246167 | 246167 | 2020-06-16 | Westmoreland | Virginia | 51193 | 87 | 1 |
243054 | 243054 | 2020-06-15 | Westmoreland | Virginia | 51193 | 87 | 1 |
239943 | 239943 | 2020-06-14 | Westmoreland | Virginia | 51193 | 87 | 1 |
236772 | 236772 | 2020-06-13 | King George | Virginia | 51099 | 87 | 4 |
233665 | 233665 | 2020-06-12 | King George | Virginia | 51099 | 87 | 4 |
212000 | 212000 | 2020-06-05 | Lynchburg city | Virginia | 51680 | 87 | 1 |
193523 | 193523 | 2020-05-30 | Hopewell city | Virginia | 51670 | 87 | 0 |
184317 | 184317 | 2020-05-27 | Fluvanna | Virginia | 51065 | 87 | 6 |
181266 | 181266 | 2020-05-26 | Fluvanna | Virginia | 51065 | 87 | 6 |
172139 | 172139 | 2020-05-23 | Galax city | Virginia | 51640 | 87 | 0 |
172185 | 172185 | 2020-05-23 | Petersburg city | Virginia | 51730 | 87 | 2 |
159969 | 159969 | 2020-05-19 | Augusta | Virginia | 51015 | 87 | 1 |
153967 | 153967 | 2020-05-17 | Goochland | Virginia | 51075 | 87 | 5 |
150956 | 150956 | 2020-05-16 | Goochland | Virginia | 51075 | 87 | 5 |
139025 | 139025 | 2020-05-12 | Warren | Virginia | 51187 | 87 | 1 |
95103 | 95103 | 2020-04-27 | Page | Virginia | 51139 | 87 | 0 |
92225 | 92225 | 2020-04-26 | Fauquier | Virginia | 51061 | 87 | 2 |
86598 | 86598 | 2020-04-24 | Frederick | Virginia | 51069 | 87 | 0 |
83791 | 83791 | 2020-04-23 | Frederick | Virginia | 51069 | 87 | 0 |
56213 | 56213 | 2020-04-13 | Harrisonburg city | Virginia | 51660 | 87 | 0 |
56269 | 56269 | 2020-04-13 | Stafford | Virginia | 51179 | 87 | 1 |
28202 | 28202 | 2020-04-02 | Henrico | Virginia | 51087 | 87 | 3 |
23706 | 23706 | 2020-03-31 | Loudoun | Virginia | 51107 | 87 | 0 |
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);