ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
130 rows where date = "2020-06-10" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
fips >30
county >30
- Accomack 1
- Albemarle 1
- Alexandria city 1
- Alleghany 1
- Amelia 1
- Amherst 1
- Appomattox 1
- Arlington 1
- Augusta 1
- Bedford 1
- Botetourt 1
- Bristol city 1
- Brunswick 1
- Buchanan 1
- Buckingham 1
- Buena Vista city 1
- Campbell 1
- Caroline 1
- Carroll 1
- Charles City 1
- Charlotte 1
- Charlottesville city 1
- Chesapeake city 1
- Chesterfield 1
- Clarke 1
- Colonial Heights city 1
- Covington city 1
- Craig 1
- Culpeper 1
- Cumberland 1
- …
state 1
- Virginia · 130 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
227395 | 227395 | 2020-06-10 | Accomack | Virginia | 51001 | 984 | 13 |
227396 | 227396 | 2020-06-10 | Albemarle | Virginia | 51003 | 260 | 8 |
227397 | 227397 | 2020-06-10 | Alexandria city | Virginia | 51510 | 2125 | 47 |
227398 | 227398 | 2020-06-10 | Alleghany | Virginia | 51005 | 26 | 2 |
227399 | 227399 | 2020-06-10 | Amelia | Virginia | 51007 | 34 | 1 |
227400 | 227400 | 2020-06-10 | Amherst | Virginia | 51009 | 27 | 0 |
227401 | 227401 | 2020-06-10 | Appomattox | Virginia | 51011 | 33 | 0 |
227402 | 227402 | 2020-06-10 | Arlington | Virginia | 51013 | 2280 | 121 |
227403 | 227403 | 2020-06-10 | Augusta | Virginia | 51015 | 139 | 2 |
227404 | 227404 | 2020-06-10 | Bedford | Virginia | 51019 | 83 | 2 |
227405 | 227405 | 2020-06-10 | Botetourt | Virginia | 51023 | 40 | 4 |
227406 | 227406 | 2020-06-10 | Bristol city | Virginia | 51520 | 4 | 0 |
227407 | 227407 | 2020-06-10 | Brunswick | Virginia | 51025 | 43 | 1 |
227408 | 227408 | 2020-06-10 | Buchanan | Virginia | 51027 | 18 | 0 |
227409 | 227409 | 2020-06-10 | Buckingham | Virginia | 51029 | 497 | 3 |
227410 | 227410 | 2020-06-10 | Buena Vista city | Virginia | 51530 | 13 | 0 |
227411 | 227411 | 2020-06-10 | Campbell | Virginia | 51031 | 22 | 1 |
227412 | 227412 | 2020-06-10 | Caroline | Virginia | 51033 | 99 | 3 |
227413 | 227413 | 2020-06-10 | Carroll | Virginia | 51035 | 153 | 5 |
227414 | 227414 | 2020-06-10 | Charles City | Virginia | 51036 | 28 | 2 |
227415 | 227415 | 2020-06-10 | Charlotte | Virginia | 51037 | 29 | 0 |
227416 | 227416 | 2020-06-10 | Charlottesville city | Virginia | 51540 | 142 | 3 |
227417 | 227417 | 2020-06-10 | Chesapeake city | Virginia | 51550 | 617 | 15 |
227418 | 227418 | 2020-06-10 | Chesterfield | Virginia | 51041 | 1995 | 38 |
227419 | 227419 | 2020-06-10 | Clarke | Virginia | 51043 | 35 | 0 |
227420 | 227420 | 2020-06-10 | Colonial Heights city | Virginia | 51570 | 106 | 17 |
227421 | 227421 | 2020-06-10 | Covington city | Virginia | 51580 | 4 | 0 |
227422 | 227422 | 2020-06-10 | Craig | Virginia | 51045 | 6 | 0 |
227423 | 227423 | 2020-06-10 | Culpeper | Virginia | 51047 | 773 | 9 |
227424 | 227424 | 2020-06-10 | Cumberland | Virginia | 51049 | 45 | 0 |
227425 | 227425 | 2020-06-10 | Danville city | Virginia | 51590 | 61 | 2 |
227426 | 227426 | 2020-06-10 | Dinwiddie | Virginia | 51053 | 101 | 0 |
227427 | 227427 | 2020-06-10 | Emporia city | Virginia | 51595 | 93 | 6 |
227428 | 227428 | 2020-06-10 | Essex | Virginia | 51057 | 53 | 0 |
227429 | 227429 | 2020-06-10 | Fairfax | Virginia | 51059 | 12746 | 422 |
227430 | 227430 | 2020-06-10 | Fairfax city | Virginia | 51600 | 69 | 6 |
227431 | 227431 | 2020-06-10 | Falls Church city | Virginia | 51610 | 56 | 8 |
227432 | 227432 | 2020-06-10 | Fauquier | Virginia | 51061 | 370 | 6 |
227433 | 227433 | 2020-06-10 | Floyd | Virginia | 51063 | 8 | 1 |
227434 | 227434 | 2020-06-10 | Fluvanna | Virginia | 51065 | 98 | 6 |
227435 | 227435 | 2020-06-10 | Franklin | Virginia | 51067 | 41 | 1 |
227436 | 227436 | 2020-06-10 | Franklin city | Virginia | 51620 | 42 | 2 |
227437 | 227437 | 2020-06-10 | Frederick | Virginia | 51069 | 415 | 4 |
227438 | 227438 | 2020-06-10 | Fredericksburg city | Virginia | 51630 | 194 | 0 |
227439 | 227439 | 2020-06-10 | Galax city | Virginia | 51640 | 154 | 6 |
227440 | 227440 | 2020-06-10 | Giles | Virginia | 51071 | 5 | 0 |
227441 | 227441 | 2020-06-10 | Gloucester | Virginia | 51073 | 33 | 1 |
227442 | 227442 | 2020-06-10 | Goochland | Virginia | 51075 | 106 | 6 |
227443 | 227443 | 2020-06-10 | Grayson | Virginia | 51077 | 60 | 2 |
227444 | 227444 | 2020-06-10 | Greene | Virginia | 51079 | 44 | 1 |
227445 | 227445 | 2020-06-10 | Greensville | Virginia | 51081 | 300 | 7 |
227446 | 227446 | 2020-06-10 | Halifax | Virginia | 51083 | 32 | 1 |
227447 | 227447 | 2020-06-10 | Hampton city | Virginia | 51650 | 231 | 5 |
227448 | 227448 | 2020-06-10 | Hanover | Virginia | 51085 | 354 | 25 |
227449 | 227449 | 2020-06-10 | Harrisonburg city | Virginia | 51660 | 842 | 23 |
227450 | 227450 | 2020-06-10 | Henrico | Virginia | 51087 | 2162 | 135 |
227451 | 227451 | 2020-06-10 | Henry | Virginia | 51089 | 182 | 3 |
227452 | 227452 | 2020-06-10 | Highland | Virginia | 51091 | 2 | 0 |
227453 | 227453 | 2020-06-10 | Hopewell city | Virginia | 51670 | 120 | 2 |
227454 | 227454 | 2020-06-10 | Isle of Wight | Virginia | 51093 | 150 | 8 |
227455 | 227455 | 2020-06-10 | James City | Virginia | 51095 | 224 | 15 |
227456 | 227456 | 2020-06-10 | King George | Virginia | 51099 | 83 | 4 |
227457 | 227457 | 2020-06-10 | King William | Virginia | 51101 | 32 | 0 |
227458 | 227458 | 2020-06-10 | King and Queen | Virginia | 51097 | 24 | 1 |
227459 | 227459 | 2020-06-10 | Lancaster | Virginia | 51103 | 10 | 0 |
227460 | 227460 | 2020-06-10 | Lee | Virginia | 51105 | 9 | 0 |
227461 | 227461 | 2020-06-10 | Lexington city | Virginia | 51678 | 8 | 0 |
227462 | 227462 | 2020-06-10 | Loudoun | Virginia | 51107 | 3180 | 67 |
227463 | 227463 | 2020-06-10 | Louisa | Virginia | 51109 | 94 | 1 |
227464 | 227464 | 2020-06-10 | Lunenburg | Virginia | 51111 | 18 | 0 |
227465 | 227465 | 2020-06-10 | Lynchburg city | Virginia | 51680 | 89 | 1 |
227466 | 227466 | 2020-06-10 | Madison | Virginia | 51113 | 41 | 1 |
227467 | 227467 | 2020-06-10 | Manassas Park city | Virginia | 51685 | 360 | 6 |
227468 | 227468 | 2020-06-10 | Manassas city | Virginia | 51683 | 1262 | 12 |
227469 | 227469 | 2020-06-10 | Martinsville city | Virginia | 51690 | 52 | 1 |
227470 | 227470 | 2020-06-10 | Mathews | Virginia | 51115 | 5 | 0 |
227471 | 227471 | 2020-06-10 | Mecklenburg | Virginia | 51117 | 224 | 24 |
227472 | 227472 | 2020-06-10 | Middlesex | Virginia | 51119 | 14 | 0 |
227473 | 227473 | 2020-06-10 | Montgomery | Virginia | 51121 | 96 | 1 |
227474 | 227474 | 2020-06-10 | Nelson | Virginia | 51125 | 17 | 0 |
227475 | 227475 | 2020-06-10 | New Kent | Virginia | 51127 | 45 | 1 |
227476 | 227476 | 2020-06-10 | Newport News city | Virginia | 51700 | 328 | 10 |
227477 | 227477 | 2020-06-10 | Norfolk city | Virginia | 51710 | 605 | 7 |
227478 | 227478 | 2020-06-10 | Northampton | Virginia | 51131 | 257 | 27 |
227479 | 227479 | 2020-06-10 | Northumberland | Virginia | 51133 | 25 | 1 |
227480 | 227480 | 2020-06-10 | Norton city | Virginia | 51720 | 2 | 0 |
227481 | 227481 | 2020-06-10 | Nottoway | Virginia | 51135 | 51 | 0 |
227482 | 227482 | 2020-06-10 | Orange | Virginia | 51137 | 119 | 2 |
227483 | 227483 | 2020-06-10 | Page | Virginia | 51139 | 247 | 24 |
227484 | 227484 | 2020-06-10 | Patrick | Virginia | 51141 | 28 | 0 |
227485 | 227485 | 2020-06-10 | Petersburg city | Virginia | 51730 | 174 | 3 |
227486 | 227486 | 2020-06-10 | Pittsylvania | Virginia | 51143 | 54 | 1 |
227487 | 227487 | 2020-06-10 | Poquoson city | Virginia | 51735 | 9 | 0 |
227488 | 227488 | 2020-06-10 | Portsmouth city | Virginia | 51740 | 354 | 11 |
227489 | 227489 | 2020-06-10 | Powhatan | Virginia | 51145 | 48 | 0 |
227490 | 227490 | 2020-06-10 | Prince Edward | Virginia | 51147 | 153 | 3 |
227491 | 227491 | 2020-06-10 | Prince George | Virginia | 51149 | 153 | 0 |
227492 | 227492 | 2020-06-10 | Prince William | Virginia | 51153 | 6376 | 118 |
227493 | 227493 | 2020-06-10 | Pulaski | Virginia | 51155 | 30 | 1 |
227494 | 227494 | 2020-06-10 | Radford city | Virginia | 51750 | 7 | 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);