ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
181 rows where cases = 27 and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
fips >30
county >30
- Wise 26
- Amherst 20
- Charles City 15
- Gloucester 7
- Botetourt 5
- Floyd 5
- Halifax 5
- Madison 5
- Fairfax city 4
- New Kent 4
- Northumberland 4
- Norton city 4
- Petersburg city 4
- Washington 4
- Highland 3
- Prince George 3
- Bath 2
- Buckingham 2
- Franklin city 2
- Giles 2
- Harrisonburg city 2
- Hopewell city 2
- Louisa 2
- Middlesex 2
- Nelson 2
- Orange 2
- Williamsburg city 2
- Albemarle 1
- Alleghany 1
- Bedford 1
- …
state 1
- Virginia · 181 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
813075 | 813075 | 2020-12-09 | Highland | Virginia | 51091 | 27 | 0 |
809831 | 809831 | 2020-12-08 | Highland | Virginia | 51091 | 27 | 0 |
803341 | 803341 | 2020-12-06 | Highland | Virginia | 51091 | 27 | 0 |
696211 | 696211 | 2020-11-03 | Bath | Virginia | 51017 | 27 | 0 |
692969 | 692969 | 2020-11-02 | Bath | Virginia | 51017 | 27 | 0 |
543838 | 543838 | 2020-09-17 | Craig | Virginia | 51045 | 27 | 0 |
508246 | 508246 | 2020-09-06 | Covington city | Virginia | 51580 | 27 | 0 |
505074 | 505074 | 2020-09-05 | Norton city | Virginia | 51720 | 27 | 0 |
501840 | 501840 | 2020-09-04 | Norton city | Virginia | 51720 | 27 | 0 |
498606 | 498606 | 2020-09-03 | Norton city | Virginia | 51720 | 27 | 0 |
495373 | 495373 | 2020-09-02 | Norton city | Virginia | 51720 | 27 | 0 |
430701 | 430701 | 2020-08-13 | Bland | Virginia | 51021 | 27 | 0 |
430738 | 430738 | 2020-08-13 | Giles | Virginia | 51071 | 27 | 0 |
427510 | 427510 | 2020-08-12 | Giles | Virginia | 51071 | 27 | 0 |
395346 | 395346 | 2020-08-02 | Middlesex | Virginia | 51119 | 27 | 1 |
392130 | 392130 | 2020-08-01 | Middlesex | Virginia | 51119 | 27 | 1 |
388935 | 388935 | 2020-07-31 | Radford city | Virginia | 51750 | 27 | 0 |
372792 | 372792 | 2020-07-26 | Floyd | Virginia | 51063 | 27 | 1 |
369580 | 369580 | 2020-07-25 | Floyd | Virginia | 51063 | 27 | 1 |
359931 | 359931 | 2020-07-22 | Bristol city | Virginia | 51520 | 27 | 0 |
359959 | 359959 | 2020-07-22 | Floyd | Virginia | 51063 | 27 | 1 |
353605 | 353605 | 2020-07-20 | Poquoson city | Virginia | 51735 | 27 | 0 |
347148 | 347148 | 2020-07-18 | Floyd | Virginia | 51063 | 27 | 1 |
343948 | 343948 | 2020-07-17 | Floyd | Virginia | 51063 | 27 | 1 |
343975 | 343975 | 2020-07-17 | Lee | Virginia | 51105 | 27 | 0 |
340790 | 340790 | 2020-07-16 | Nelson | Virginia | 51125 | 27 | 0 |
340818 | 340818 | 2020-07-16 | Russell | Virginia | 51167 | 27 | 0 |
337594 | 337594 | 2020-07-15 | Nelson | Virginia | 51125 | 27 | 0 |
328004 | 328004 | 2020-07-12 | King and Queen | Virginia | 51097 | 27 | 1 |
286890 | 286890 | 2020-06-29 | Wise | Virginia | 51195 | 27 | 2 |
283744 | 283744 | 2020-06-28 | Wise | Virginia | 51195 | 27 | 2 |
280598 | 280598 | 2020-06-27 | Wise | Virginia | 51195 | 27 | 2 |
277450 | 277450 | 2020-06-26 | Wise | Virginia | 51195 | 27 | 2 |
274280 | 274280 | 2020-06-25 | Rockbridge | Virginia | 51163 | 27 | 0 |
274302 | 274302 | 2020-06-25 | Wise | Virginia | 51195 | 27 | 2 |
271162 | 271162 | 2020-06-24 | Wise | Virginia | 51195 | 27 | 2 |
268028 | 268028 | 2020-06-23 | Wise | Virginia | 51195 | 27 | 2 |
264899 | 264899 | 2020-06-22 | Wise | Virginia | 51195 | 27 | 2 |
261770 | 261770 | 2020-06-21 | Wise | Virginia | 51195 | 27 | 2 |
258643 | 258643 | 2020-06-20 | Wise | Virginia | 51195 | 27 | 2 |
255516 | 255516 | 2020-06-19 | Wise | Virginia | 51195 | 27 | 2 |
252354 | 252354 | 2020-06-18 | Northumberland | Virginia | 51133 | 27 | 1 |
252397 | 252397 | 2020-06-18 | Wise | Virginia | 51195 | 27 | 2 |
249239 | 249239 | 2020-06-17 | Northumberland | Virginia | 51133 | 27 | 1 |
249282 | 249282 | 2020-06-17 | Wise | Virginia | 51195 | 27 | 2 |
246127 | 246127 | 2020-06-16 | Northumberland | Virginia | 51133 | 27 | 1 |
246170 | 246170 | 2020-06-16 | Wise | Virginia | 51195 | 27 | 2 |
242935 | 242935 | 2020-06-15 | Amherst | Virginia | 51009 | 27 | 0 |
243014 | 243014 | 2020-06-15 | Northumberland | Virginia | 51133 | 27 | 1 |
243057 | 243057 | 2020-06-15 | Wise | Virginia | 51195 | 27 | 2 |
239824 | 239824 | 2020-06-14 | Amherst | Virginia | 51009 | 27 | 0 |
239946 | 239946 | 2020-06-14 | Wise | Virginia | 51195 | 27 | 2 |
236716 | 236716 | 2020-06-13 | Amherst | Virginia | 51009 | 27 | 0 |
236838 | 236838 | 2020-06-13 | Wise | Virginia | 51195 | 27 | 2 |
233607 | 233607 | 2020-06-12 | Alleghany | Virginia | 51005 | 27 | 2 |
233609 | 233609 | 2020-06-12 | Amherst | Virginia | 51009 | 27 | 0 |
233731 | 233731 | 2020-06-12 | Wise | Virginia | 51195 | 27 | 2 |
230504 | 230504 | 2020-06-11 | Amherst | Virginia | 51009 | 27 | 0 |
230626 | 230626 | 2020-06-11 | Wise | Virginia | 51195 | 27 | 2 |
227400 | 227400 | 2020-06-10 | Amherst | Virginia | 51009 | 27 | 0 |
227522 | 227522 | 2020-06-10 | Wise | Virginia | 51195 | 27 | 2 |
224300 | 224300 | 2020-06-09 | Amherst | Virginia | 51009 | 27 | 0 |
224422 | 224422 | 2020-06-09 | Wise | Virginia | 51195 | 27 | 2 |
221204 | 221204 | 2020-06-08 | Amherst | Virginia | 51009 | 27 | 0 |
221326 | 221326 | 2020-06-08 | Wise | Virginia | 51195 | 27 | 2 |
218112 | 218112 | 2020-06-07 | Amherst | Virginia | 51009 | 27 | 0 |
218205 | 218205 | 2020-06-07 | Pulaski | Virginia | 51155 | 27 | 1 |
218234 | 218234 | 2020-06-07 | Wise | Virginia | 51195 | 27 | 2 |
215022 | 215022 | 2020-06-06 | Amherst | Virginia | 51009 | 27 | 0 |
215036 | 215036 | 2020-06-06 | Charles City | Virginia | 51036 | 27 | 2 |
215106 | 215106 | 2020-06-06 | Patrick | Virginia | 51141 | 27 | 0 |
215144 | 215144 | 2020-06-06 | Wise | Virginia | 51195 | 27 | 2 |
211935 | 211935 | 2020-06-05 | Amherst | Virginia | 51009 | 27 | 0 |
211949 | 211949 | 2020-06-05 | Charles City | Virginia | 51036 | 27 | 2 |
212057 | 212057 | 2020-06-05 | Wise | Virginia | 51195 | 27 | 2 |
208850 | 208850 | 2020-06-04 | Amherst | Virginia | 51009 | 27 | 0 |
208864 | 208864 | 2020-06-04 | Charles City | Virginia | 51036 | 27 | 2 |
208972 | 208972 | 2020-06-04 | Wise | Virginia | 51195 | 27 | 2 |
205768 | 205768 | 2020-06-03 | Amherst | Virginia | 51009 | 27 | 0 |
205782 | 205782 | 2020-06-03 | Charles City | Virginia | 51036 | 27 | 2 |
205783 | 205783 | 2020-06-03 | Charlotte | Virginia | 51037 | 27 | 0 |
202689 | 202689 | 2020-06-02 | Amherst | Virginia | 51009 | 27 | 0 |
202703 | 202703 | 2020-06-02 | Charles City | Virginia | 51036 | 27 | 1 |
199613 | 199613 | 2020-06-01 | Amherst | Virginia | 51009 | 27 | 0 |
199620 | 199620 | 2020-06-01 | Brunswick | Virginia | 51025 | 27 | 1 |
199627 | 199627 | 2020-06-01 | Charles City | Virginia | 51036 | 27 | 1 |
196540 | 196540 | 2020-05-31 | Amherst | Virginia | 51009 | 27 | 0 |
196554 | 196554 | 2020-05-31 | Charles City | Virginia | 51036 | 27 | 1 |
196559 | 196559 | 2020-05-31 | Clarke | Virginia | 51043 | 27 | 0 |
193470 | 193470 | 2020-05-30 | Amherst | Virginia | 51009 | 27 | 0 |
193484 | 193484 | 2020-05-30 | Charles City | Virginia | 51036 | 27 | 1 |
190404 | 190404 | 2020-05-29 | Amherst | Virginia | 51009 | 27 | 0 |
190418 | 190418 | 2020-05-29 | Charles City | Virginia | 51036 | 27 | 1 |
187340 | 187340 | 2020-05-28 | Amherst | Virginia | 51009 | 27 | 0 |
187354 | 187354 | 2020-05-28 | Charles City | Virginia | 51036 | 27 | 1 |
184283 | 184283 | 2020-05-27 | Amherst | Virginia | 51009 | 27 | 0 |
184297 | 184297 | 2020-05-27 | Charles City | Virginia | 51036 | 27 | 1 |
184327 | 184327 | 2020-05-27 | Greene | Virginia | 51079 | 27 | 1 |
181246 | 181246 | 2020-05-26 | Charles City | Virginia | 51036 | 27 | 1 |
181301 | 181301 | 2020-05-26 | Martinsville city | Virginia | 51690 | 27 | 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);