ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
74 rows where cases = 79 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Fluvanna 6
- Alleghany 5
- Dickenson 5
- Buena Vista city 4
- Amelia 3
- Falls Church city 3
- Northumberland 3
- Bedford 2
- Bland 2
- Fairfax city 2
- King William 2
- Louisa 2
- Roanoke 2
- Bath 1
- Caroline 1
- Charles City 1
- Charlotte 1
- Clarke 1
- Craig 1
- Cumberland 1
- Danville city 1
- Emporia city 1
- Gloucester 1
- Goochland 1
- Grayson 1
- Hampton city 1
- Hanover 1
- Harrisonburg city 1
- King George 1
- King and Queen 1
- …
state 1
- Virginia · 74 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
809780 | 809780 | 2020-12-08 | Bath | Virginia | 51017 | 79 | 0 |
764443 | 764443 | 2020-11-24 | Rappahannock | Virginia | 51157 | 79 | 2 |
751386 | 751386 | 2020-11-20 | Craig | Virginia | 51045 | 79 | 0 |
715703 | 715703 | 2020-11-09 | Falls Church city | Virginia | 51610 | 79 | 7 |
712459 | 712459 | 2020-11-08 | Falls Church city | Virginia | 51610 | 79 | 7 |
709215 | 709215 | 2020-11-07 | Falls Church city | Virginia | 51610 | 79 | 7 |
692971 | 692971 | 2020-11-02 | Bland | Virginia | 51021 | 79 | 5 |
689727 | 689727 | 2020-11-01 | Bland | Virginia | 51021 | 79 | 5 |
615167 | 615167 | 2020-10-09 | King and Queen | Virginia | 51097 | 79 | 1 |
589168 | 589168 | 2020-10-01 | Alleghany | Virginia | 51005 | 79 | 4 |
585927 | 585927 | 2020-09-30 | Alleghany | Virginia | 51005 | 79 | 4 |
582687 | 582687 | 2020-09-29 | Alleghany | Virginia | 51005 | 79 | 4 |
579448 | 579448 | 2020-09-28 | Alleghany | Virginia | 51005 | 79 | 4 |
576207 | 576207 | 2020-09-27 | Alleghany | Virginia | 51005 | 79 | 4 |
556778 | 556778 | 2020-09-21 | Buena Vista city | Virginia | 51530 | 79 | 1 |
553541 | 553541 | 2020-09-20 | Buena Vista city | Virginia | 51530 | 79 | 1 |
550302 | 550302 | 2020-09-19 | Buena Vista city | Virginia | 51530 | 79 | 1 |
547063 | 547063 | 2020-09-18 | Buena Vista city | Virginia | 51530 | 79 | 1 |
540594 | 540594 | 2020-09-16 | Charles City | Virginia | 51036 | 79 | 5 |
540606 | 540606 | 2020-09-16 | Dickenson | Virginia | 51051 | 79 | 1 |
537369 | 537369 | 2020-09-15 | Dickenson | Virginia | 51051 | 79 | 1 |
534133 | 534133 | 2020-09-14 | Dickenson | Virginia | 51051 | 79 | 1 |
530898 | 530898 | 2020-09-13 | Dickenson | Virginia | 51051 | 79 | 1 |
527661 | 527661 | 2020-09-12 | Dickenson | Virginia | 51051 | 79 | 1 |
505008 | 505008 | 2020-09-05 | Charlotte | Virginia | 51037 | 79 | 0 |
482376 | 482376 | 2020-08-29 | Clarke | Virginia | 51043 | 79 | 0 |
459839 | 459839 | 2020-08-22 | Rockbridge | Virginia | 51163 | 79 | 1 |
456586 | 456586 | 2020-08-21 | Nelson | Virginia | 51125 | 79 | 0 |
440454 | 440454 | 2020-08-16 | Northumberland | Virginia | 51133 | 79 | 3 |
437228 | 437228 | 2020-08-15 | Northumberland | Virginia | 51133 | 79 | 3 |
433946 | 433946 | 2020-08-14 | Cumberland | Virginia | 51049 | 79 | 0 |
434002 | 434002 | 2020-08-14 | Northumberland | Virginia | 51133 | 79 | 3 |
421021 | 421021 | 2020-08-10 | Amelia | Virginia | 51007 | 79 | 2 |
417800 | 417800 | 2020-08-09 | Amelia | Virginia | 51007 | 79 | 2 |
414579 | 414579 | 2020-08-08 | Amelia | Virginia | 51007 | 79 | 2 |
408201 | 408201 | 2020-08-06 | King William | Virginia | 51101 | 79 | 2 |
404981 | 404981 | 2020-08-05 | King William | Virginia | 51101 | 79 | 2 |
405017 | 405017 | 2020-08-05 | Pulaski | Virginia | 51155 | 79 | 3 |
388871 | 388871 | 2020-07-31 | Fairfax city | Virginia | 51600 | 79 | 7 |
388963 | 388963 | 2020-07-31 | Wise | Virginia | 51195 | 79 | 3 |
382436 | 382436 | 2020-07-29 | Fairfax city | Virginia | 51600 | 79 | 7 |
337561 | 337561 | 2020-07-15 | Gloucester | Virginia | 51073 | 79 | 1 |
305826 | 305826 | 2020-07-05 | Staunton city | Virginia | 51790 | 79 | 0 |
286857 | 286857 | 2020-06-29 | Powhatan | Virginia | 51145 | 79 | 2 |
280500 | 280500 | 2020-06-27 | Danville city | Virginia | 51590 | 79 | 2 |
261691 | 261691 | 2020-06-21 | Grayson | Virginia | 51077 | 79 | 2 |
261729 | 261729 | 2020-06-21 | Nottoway | Virginia | 51135 | 79 | 0 |
224356 | 224356 | 2020-06-09 | King George | Virginia | 51099 | 79 | 4 |
221208 | 221208 | 2020-06-08 | Bedford | Virginia | 51019 | 79 | 2 |
218116 | 218116 | 2020-06-07 | Bedford | Virginia | 51019 | 79 | 2 |
211947 | 211947 | 2020-06-05 | Caroline | Virginia | 51033 | 79 | 3 |
212059 | 212059 | 2020-06-05 | York | Virginia | 51199 | 79 | 3 |
199676 | 199676 | 2020-06-01 | Louisa | Virginia | 51109 | 79 | 1 |
196567 | 196567 | 2020-05-31 | Emporia city | Virginia | 51595 | 79 | 5 |
196603 | 196603 | 2020-05-31 | Louisa | Virginia | 51109 | 79 | 1 |
184374 | 184374 | 2020-05-27 | Prince George | Virginia | 51149 | 79 | 0 |
181297 | 181297 | 2020-05-26 | Lynchburg city | Virginia | 51680 | 79 | 1 |
147939 | 147939 | 2020-05-15 | Fluvanna | Virginia | 51065 | 79 | 6 |
148026 | 148026 | 2020-05-15 | Winchester city | Virginia | 51840 | 79 | 1 |
144936 | 144936 | 2020-05-14 | Fluvanna | Virginia | 51065 | 79 | 6 |
141939 | 141939 | 2020-05-13 | Fluvanna | Virginia | 51065 | 79 | 6 |
139007 | 139007 | 2020-05-12 | Roanoke | Virginia | 51161 | 79 | 0 |
135952 | 135952 | 2020-05-11 | Fluvanna | Virginia | 51065 | 79 | 6 |
136016 | 136016 | 2020-05-11 | Roanoke | Virginia | 51161 | 79 | 0 |
132962 | 132962 | 2020-05-10 | Fluvanna | Virginia | 51065 | 79 | 6 |
129972 | 129972 | 2020-05-09 | Fluvanna | Virginia | 51065 | 79 | 6 |
112218 | 112218 | 2020-05-03 | Goochland | Virginia | 51075 | 79 | 5 |
97969 | 97969 | 2020-04-28 | Shenandoah | Virginia | 51171 | 79 | 2 |
89470 | 89470 | 2020-04-25 | Richmond | Virginia | 51159 | 79 | 0 |
78266 | 78266 | 2020-04-21 | Spotsylvania | Virginia | 51177 | 79 | 2 |
69879 | 69879 | 2020-04-18 | Hampton city | Virginia | 51650 | 79 | 1 |
69880 | 69880 | 2020-04-18 | Hanover | Virginia | 51085 | 79 | 0 |
50848 | 50848 | 2020-04-11 | Harrisonburg city | Virginia | 51660 | 79 | 0 |
21584 | 21584 | 2020-03-30 | Prince William | Virginia | 51153 | 79 | 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);