ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
119 rows where cases = 66 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Falls Church city 19
- Montgomery 10
- Rappahannock 8
- Craig 7
- Rockbridge 6
- Charles City 5
- Grayson 4
- King and Queen 4
- Charlottesville city 3
- Danville city 3
- Hopewell city 3
- Lunenburg 3
- Prince Edward 3
- Amelia 2
- Carroll 2
- Clarke 2
- Colonial Heights city 2
- Essex 2
- Fluvanna 2
- Northumberland 2
- Richmond 2
- Winchester city 2
- Albemarle 1
- Amherst 1
- Augusta 1
- Bath 1
- Bristol city 1
- Campbell 1
- Franklin 1
- Franklin city 1
- …
state 1
- Virginia · 119 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
790310 | 790310 | 2020-12-02 | Bath | Virginia | 51017 | 66 | 0 |
728665 | 728665 | 2020-11-13 | Craig | Virginia | 51045 | 66 | 0 |
725422 | 725422 | 2020-11-12 | Craig | Virginia | 51045 | 66 | 0 |
722179 | 722179 | 2020-11-11 | Craig | Virginia | 51045 | 66 | 0 |
718936 | 718936 | 2020-11-10 | Craig | Virginia | 51045 | 66 | 0 |
715693 | 715693 | 2020-11-09 | Craig | Virginia | 51045 | 66 | 0 |
712449 | 712449 | 2020-11-08 | Craig | Virginia | 51045 | 66 | 0 |
709205 | 709205 | 2020-11-07 | Craig | Virginia | 51045 | 66 | 0 |
647650 | 647650 | 2020-10-19 | Rappahannock | Virginia | 51157 | 66 | 2 |
634664 | 634664 | 2020-10-15 | Rappahannock | Virginia | 51157 | 66 | 2 |
628175 | 628175 | 2020-10-13 | Rappahannock | Virginia | 51157 | 66 | 2 |
624932 | 624932 | 2020-10-12 | Rappahannock | Virginia | 51157 | 66 | 2 |
621689 | 621689 | 2020-10-11 | Rappahannock | Virginia | 51157 | 66 | 2 |
618446 | 618446 | 2020-10-10 | Rappahannock | Virginia | 51157 | 66 | 2 |
615204 | 615204 | 2020-10-09 | Rappahannock | Virginia | 51157 | 66 | 2 |
608721 | 608721 | 2020-10-07 | Rappahannock | Virginia | 51157 | 66 | 2 |
550351 | 550351 | 2020-09-19 | King and Queen | Virginia | 51097 | 66 | 1 |
547112 | 547112 | 2020-09-18 | King and Queen | Virginia | 51097 | 66 | 1 |
543875 | 543875 | 2020-09-17 | King and Queen | Virginia | 51097 | 66 | 1 |
540612 | 540612 | 2020-09-16 | Falls Church city | Virginia | 51610 | 66 | 6 |
540639 | 540639 | 2020-09-16 | King and Queen | Virginia | 51097 | 66 | 1 |
527667 | 527667 | 2020-09-12 | Falls Church city | Virginia | 51610 | 66 | 7 |
524472 | 524472 | 2020-09-11 | Middlesex | Virginia | 51119 | 66 | 1 |
521195 | 521195 | 2020-09-10 | Falls Church city | Virginia | 51610 | 66 | 7 |
517958 | 517958 | 2020-09-09 | Falls Church city | Virginia | 51610 | 66 | 7 |
514723 | 514723 | 2020-09-08 | Falls Church city | Virginia | 51610 | 66 | 7 |
511490 | 511490 | 2020-09-07 | Falls Church city | Virginia | 51610 | 66 | 7 |
508257 | 508257 | 2020-09-06 | Falls Church city | Virginia | 51610 | 66 | 7 |
505025 | 505025 | 2020-09-05 | Falls Church city | Virginia | 51610 | 66 | 7 |
501791 | 501791 | 2020-09-04 | Falls Church city | Virginia | 51610 | 66 | 7 |
498557 | 498557 | 2020-09-03 | Falls Church city | Virginia | 51610 | 66 | 7 |
495324 | 495324 | 2020-09-02 | Falls Church city | Virginia | 51610 | 66 | 7 |
492090 | 492090 | 2020-09-01 | Falls Church city | Virginia | 51610 | 66 | 7 |
488857 | 488857 | 2020-08-31 | Falls Church city | Virginia | 51610 | 66 | 7 |
485624 | 485624 | 2020-08-30 | Falls Church city | Virginia | 51610 | 66 | 7 |
485705 | 485705 | 2020-08-30 | Surry | Virginia | 51181 | 66 | 3 |
482389 | 482389 | 2020-08-29 | Falls Church city | Virginia | 51610 | 66 | 7 |
479137 | 479137 | 2020-08-28 | Charles City | Virginia | 51036 | 66 | 5 |
479155 | 479155 | 2020-08-28 | Falls Church city | Virginia | 51610 | 66 | 7 |
479183 | 479183 | 2020-08-28 | Lancaster | Virginia | 51103 | 66 | 0 |
475904 | 475904 | 2020-08-27 | Charles City | Virginia | 51036 | 66 | 5 |
475922 | 475922 | 2020-08-27 | Falls Church city | Virginia | 51610 | 66 | 7 |
472671 | 472671 | 2020-08-26 | Charles City | Virginia | 51036 | 66 | 5 |
472689 | 472689 | 2020-08-26 | Falls Church city | Virginia | 51610 | 66 | 7 |
469439 | 469439 | 2020-08-25 | Charles City | Virginia | 51036 | 66 | 5 |
469457 | 469457 | 2020-08-25 | Falls Church city | Virginia | 51610 | 66 | 7 |
466210 | 466210 | 2020-08-24 | Charles City | Virginia | 51036 | 66 | 5 |
433987 | 433987 | 2020-08-14 | Lunenburg | Virginia | 51111 | 66 | 1 |
430762 | 430762 | 2020-08-13 | Lunenburg | Virginia | 51111 | 66 | 1 |
427534 | 427534 | 2020-08-12 | Lunenburg | Virginia | 51111 | 66 | 1 |
411429 | 411429 | 2020-08-07 | Madison | Virginia | 51113 | 66 | 1 |
411463 | 411463 | 2020-08-07 | Rockbridge | Virginia | 51163 | 66 | 1 |
408244 | 408244 | 2020-08-06 | Rockbridge | Virginia | 51163 | 66 | 1 |
408248 | 408248 | 2020-08-06 | Scott | Virginia | 51169 | 66 | 3 |
405024 | 405024 | 2020-08-05 | Rockbridge | Virginia | 51163 | 66 | 0 |
401711 | 401711 | 2020-08-04 | Bristol city | Virginia | 51520 | 66 | 0 |
401806 | 401806 | 2020-08-04 | Rockbridge | Virginia | 51163 | 66 | 0 |
398569 | 398569 | 2020-08-03 | Northumberland | Virginia | 51133 | 66 | 2 |
395353 | 395353 | 2020-08-02 | Northumberland | Virginia | 51133 | 66 | 2 |
392158 | 392158 | 2020-08-01 | Rockbridge | Virginia | 51163 | 66 | 0 |
388941 | 388941 | 2020-07-31 | Rockbridge | Virginia | 51163 | 66 | 0 |
385642 | 385642 | 2020-07-30 | Clarke | Virginia | 51043 | 66 | 0 |
382424 | 382424 | 2020-07-29 | Clarke | Virginia | 51043 | 66 | 0 |
375969 | 375969 | 2020-07-27 | Amelia | Virginia | 51007 | 66 | 1 |
372755 | 372755 | 2020-07-26 | Amelia | Virginia | 51007 | 66 | 1 |
369607 | 369607 | 2020-07-25 | Lee | Virginia | 51105 | 66 | 0 |
359923 | 359923 | 2020-07-22 | Amherst | Virginia | 51009 | 66 | 0 |
356778 | 356778 | 2020-07-21 | King William | Virginia | 51101 | 66 | 2 |
337548 | 337548 | 2020-07-15 | Essex | Virginia | 51057 | 66 | 0 |
334353 | 334353 | 2020-07-14 | Essex | Virginia | 51057 | 66 | 0 |
331142 | 331142 | 2020-07-13 | Campbell | Virginia | 51031 | 66 | 1 |
318437 | 318437 | 2020-07-09 | Franklin city | Virginia | 51620 | 66 | 3 |
302669 | 302669 | 2020-07-04 | Washington | Virginia | 51191 | 66 | 4 |
293115 | 293115 | 2020-07-01 | Greene | Virginia | 51079 | 66 | 1 |
283657 | 283657 | 2020-06-28 | Franklin | Virginia | 51067 | 66 | 1 |
267995 | 267995 | 2020-06-23 | Powhatan | Virginia | 51145 | 66 | 2 |
268024 | 268024 | 2020-06-23 | Waynesboro city | Virginia | 51820 | 66 | 0 |
261758 | 261758 | 2020-06-21 | Staunton city | Virginia | 51790 | 66 | 0 |
249184 | 249184 | 2020-06-17 | Danville city | Virginia | 51590 | 66 | 2 |
246072 | 246072 | 2020-06-16 | Danville city | Virginia | 51590 | 66 | 2 |
246091 | 246091 | 2020-06-16 | Grayson | Virginia | 51077 | 66 | 2 |
242960 | 242960 | 2020-06-15 | Danville city | Virginia | 51590 | 66 | 2 |
242978 | 242978 | 2020-06-15 | Grayson | Virginia | 51077 | 66 | 2 |
239867 | 239867 | 2020-06-14 | Grayson | Virginia | 51077 | 66 | 2 |
236759 | 236759 | 2020-06-13 | Grayson | Virginia | 51077 | 66 | 2 |
178241 | 178241 | 2020-05-25 | Hopewell city | Virginia | 51670 | 66 | 0 |
175196 | 175196 | 2020-05-24 | Hopewell city | Virginia | 51670 | 66 | 0 |
172113 | 172113 | 2020-05-23 | Carroll | Virginia | 51035 | 66 | 1 |
169072 | 169072 | 2020-05-22 | Carroll | Virginia | 51035 | 66 | 1 |
169112 | 169112 | 2020-05-22 | Hopewell city | Virginia | 51670 | 66 | 0 |
163067 | 163067 | 2020-05-20 | Montgomery | Virginia | 51121 | 66 | 1 |
160039 | 160039 | 2020-05-19 | Montgomery | Virginia | 51121 | 66 | 1 |
157015 | 157015 | 2020-05-18 | Montgomery | Virginia | 51121 | 66 | 1 |
153998 | 153998 | 2020-05-17 | Montgomery | Virginia | 51121 | 66 | 1 |
150987 | 150987 | 2020-05-16 | Montgomery | Virginia | 51121 | 66 | 1 |
147944 | 147944 | 2020-05-15 | Galax city | Virginia | 51640 | 66 | 0 |
147978 | 147978 | 2020-05-15 | Montgomery | Virginia | 51121 | 66 | 1 |
144975 | 144975 | 2020-05-14 | Montgomery | Virginia | 51121 | 66 | 1 |
141908 | 141908 | 2020-05-13 | Augusta | Virginia | 51015 | 66 | 1 |
141978 | 141978 | 2020-05-13 | Montgomery | Virginia | 51121 | 66 | 1 |
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);