ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
85 rows where date = "2020-03-30" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths
fips >30
county >30
- Accomack 1
- Albemarle 1
- Alexandria city 1
- Alleghany 1
- Amelia 1
- Amherst 1
- Arlington 1
- Bedford 1
- Botetourt 1
- Bristol city 1
- Charles City 1
- Charlottesville city 1
- Chesapeake city 1
- Chesterfield 1
- Culpeper 1
- Danville city 1
- Fairfax 1
- Fauquier 1
- Fluvanna 1
- Franklin 1
- Frederick 1
- Fredericksburg city 1
- Galax city 1
- Gloucester 1
- Goochland 1
- Greene 1
- Greensville 1
- Halifax 1
- Hampton city 1
- Hanover 1
- …
state 1
- Virginia · 85 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
21520 | 21520 | 2020-03-30 | Accomack | Virginia | 51001 | 6 | 0 |
21521 | 21521 | 2020-03-30 | Albemarle | Virginia | 51003 | 19 | 0 |
21522 | 21522 | 2020-03-30 | Alexandria city | Virginia | 51510 | 26 | 0 |
21523 | 21523 | 2020-03-30 | Alleghany | Virginia | 51005 | 1 | 0 |
21524 | 21524 | 2020-03-30 | Amelia | Virginia | 51007 | 1 | 0 |
21525 | 21525 | 2020-03-30 | Amherst | Virginia | 51009 | 3 | 0 |
21526 | 21526 | 2020-03-30 | Arlington | Virginia | 51013 | 86 | 2 |
21527 | 21527 | 2020-03-30 | Bedford | Virginia | 51019 | 2 | 0 |
21528 | 21528 | 2020-03-30 | Botetourt | Virginia | 51023 | 5 | 0 |
21529 | 21529 | 2020-03-30 | Bristol city | Virginia | 51520 | 1 | 0 |
21530 | 21530 | 2020-03-30 | Charles City | Virginia | 51036 | 1 | 0 |
21531 | 21531 | 2020-03-30 | Charlottesville city | Virginia | 51540 | 13 | 0 |
21532 | 21532 | 2020-03-30 | Chesapeake city | Virginia | 51550 | 18 | 0 |
21533 | 21533 | 2020-03-30 | Chesterfield | Virginia | 51041 | 21 | 0 |
21534 | 21534 | 2020-03-30 | Culpeper | Virginia | 51047 | 3 | 0 |
21535 | 21535 | 2020-03-30 | Danville city | Virginia | 51590 | 4 | 0 |
21536 | 21536 | 2020-03-30 | Fairfax | Virginia | 51059 | 225 | 2 |
21537 | 21537 | 2020-03-30 | Fauquier | Virginia | 51061 | 6 | 0 |
21538 | 21538 | 2020-03-30 | Fluvanna | Virginia | 51065 | 3 | 0 |
21539 | 21539 | 2020-03-30 | Franklin | Virginia | 51067 | 5 | 0 |
21540 | 21540 | 2020-03-30 | Frederick | Virginia | 51069 | 10 | 0 |
21541 | 21541 | 2020-03-30 | Fredericksburg city | Virginia | 51630 | 1 | 0 |
21542 | 21542 | 2020-03-30 | Galax city | Virginia | 51640 | 1 | 0 |
21543 | 21543 | 2020-03-30 | Gloucester | Virginia | 51073 | 7 | 0 |
21544 | 21544 | 2020-03-30 | Goochland | Virginia | 51075 | 6 | 0 |
21545 | 21545 | 2020-03-30 | Greene | Virginia | 51079 | 1 | 0 |
21546 | 21546 | 2020-03-30 | Greensville | Virginia | 51081 | 3 | 0 |
21547 | 21547 | 2020-03-30 | Halifax | Virginia | 51083 | 1 | 0 |
21548 | 21548 | 2020-03-30 | Hampton city | Virginia | 51650 | 9 | 0 |
21549 | 21549 | 2020-03-30 | Hanover | Virginia | 51085 | 5 | 0 |
21550 | 21550 | 2020-03-30 | Harrisonburg city | Virginia | 51660 | 6 | 0 |
21551 | 21551 | 2020-03-30 | Henrico | Virginia | 51087 | 44 | 3 |
21552 | 21552 | 2020-03-30 | Henry | Virginia | 51089 | 1 | 0 |
21553 | 21553 | 2020-03-30 | Hopewell city | Virginia | 51670 | 3 | 0 |
21554 | 21554 | 2020-03-30 | Isle of Wight | Virginia | 51093 | 3 | 0 |
21555 | 21555 | 2020-03-30 | James City | Virginia | 51095 | 73 | 3 |
21556 | 21556 | 2020-03-30 | King George | Virginia | 51099 | 3 | 0 |
21557 | 21557 | 2020-03-30 | King William | Virginia | 51101 | 1 | 0 |
21558 | 21558 | 2020-03-30 | Lancaster | Virginia | 51103 | 1 | 0 |
21559 | 21559 | 2020-03-30 | Lee | Virginia | 51105 | 2 | 0 |
21560 | 21560 | 2020-03-30 | Loudoun | Virginia | 51107 | 61 | 0 |
21561 | 21561 | 2020-03-30 | Louisa | Virginia | 51109 | 8 | 0 |
21562 | 21562 | 2020-03-30 | Lynchburg city | Virginia | 51680 | 4 | 0 |
21563 | 21563 | 2020-03-30 | Madison | Virginia | 51113 | 3 | 0 |
21564 | 21564 | 2020-03-30 | Manassas Park city | Virginia | 51685 | 1 | 0 |
21565 | 21565 | 2020-03-30 | Manassas city | Virginia | 51683 | 7 | 0 |
21566 | 21566 | 2020-03-30 | Mathews | Virginia | 51115 | 2 | 0 |
21567 | 21567 | 2020-03-30 | Mecklenburg | Virginia | 51117 | 4 | 0 |
21568 | 21568 | 2020-03-30 | Montgomery | Virginia | 51121 | 1 | 0 |
21569 | 21569 | 2020-03-30 | Nelson | Virginia | 51125 | 2 | 0 |
21570 | 21570 | 2020-03-30 | New Kent | Virginia | 51127 | 1 | 0 |
21571 | 21571 | 2020-03-30 | Newport News city | Virginia | 51700 | 18 | 1 |
21572 | 21572 | 2020-03-30 | Norfolk city | Virginia | 51710 | 17 | 0 |
21573 | 21573 | 2020-03-30 | Northampton | Virginia | 51131 | 1 | 0 |
21574 | 21574 | 2020-03-30 | Northumberland | Virginia | 51133 | 2 | 0 |
21575 | 21575 | 2020-03-30 | Nottoway | Virginia | 51135 | 1 | 0 |
21576 | 21576 | 2020-03-30 | Orange | Virginia | 51137 | 1 | 0 |
21577 | 21577 | 2020-03-30 | Petersburg city | Virginia | 51730 | 2 | 0 |
21578 | 21578 | 2020-03-30 | Pittsylvania | Virginia | 51143 | 1 | 0 |
21579 | 21579 | 2020-03-30 | Poquoson city | Virginia | 51735 | 2 | 0 |
21580 | 21580 | 2020-03-30 | Portsmouth city | Virginia | 51740 | 4 | 0 |
21581 | 21581 | 2020-03-30 | Powhatan | Virginia | 51145 | 3 | 0 |
21582 | 21582 | 2020-03-30 | Prince Edward | Virginia | 51147 | 2 | 0 |
21583 | 21583 | 2020-03-30 | Prince George | Virginia | 51149 | 5 | 0 |
21584 | 21584 | 2020-03-30 | Prince William | Virginia | 51153 | 79 | 0 |
21585 | 21585 | 2020-03-30 | Radford city | Virginia | 51750 | 1 | 0 |
21586 | 21586 | 2020-03-30 | Richmond city | Virginia | 51760 | 25 | 0 |
21587 | 21587 | 2020-03-30 | Roanoke | Virginia | 51161 | 2 | 0 |
21588 | 21588 | 2020-03-30 | Roanoke city | Virginia | 51770 | 6 | 0 |
21589 | 21589 | 2020-03-30 | Rockbridge | Virginia | 51163 | 2 | 0 |
21590 | 21590 | 2020-03-30 | Rockingham | Virginia | 51165 | 5 | 0 |
21591 | 21591 | 2020-03-30 | Shenandoah | Virginia | 51171 | 6 | 0 |
21592 | 21592 | 2020-03-30 | Smyth | Virginia | 51173 | 1 | 0 |
21593 | 21593 | 2020-03-30 | Southampton | Virginia | 51175 | 1 | 0 |
21594 | 21594 | 2020-03-30 | Spotsylvania | Virginia | 51177 | 6 | 0 |
21595 | 21595 | 2020-03-30 | Stafford | Virginia | 51179 | 20 | 0 |
21596 | 21596 | 2020-03-30 | Suffolk city | Virginia | 51800 | 3 | 0 |
21597 | 21597 | 2020-03-30 | Tazewell | Virginia | 51185 | 2 | 0 |
21598 | 21598 | 2020-03-30 | Virginia Beach city | Virginia | 51810 | 52 | 0 |
21599 | 21599 | 2020-03-30 | Warren | Virginia | 51187 | 2 | 0 |
21600 | 21600 | 2020-03-30 | Washington | Virginia | 51191 | 2 | 0 |
21601 | 21601 | 2020-03-30 | Williamsburg city | Virginia | 51830 | 7 | 1 |
21602 | 21602 | 2020-03-30 | Winchester city | Virginia | 51840 | 3 | 0 |
21603 | 21603 | 2020-03-30 | Wythe | Virginia | 51197 | 1 | 0 |
21604 | 21604 | 2020-03-30 | York | Virginia | 51199 | 11 | 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);