ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
133 rows where "date" is on date 2020-07-09 and state = "Virginia" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
county >30
- Accomack 1
- Albemarle 1
- Alexandria city 1
- Alleghany 1
- Amelia 1
- Amherst 1
- Appomattox 1
- Arlington 1
- Augusta 1
- Bath 1
- Bedford 1
- Bland 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
- …
state 1
- Virginia · 133 ✖
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
318398 | 318398 | 2020-07-09 | Amherst | Virginia | 51009 | 38 | 0 |
318399 | 318399 | 2020-07-09 | Appomattox | Virginia | 51011 | 44 | 0 |
318402 | 318402 | 2020-07-09 | Bath | Virginia | 51017 | 1 | 0 |
318404 | 318404 | 2020-07-09 | Bland | Virginia | 51021 | 2 | 0 |
318406 | 318406 | 2020-07-09 | Bristol city | Virginia | 51520 | 8 | 0 |
318408 | 318408 | 2020-07-09 | Buchanan | Virginia | 51027 | 38 | 0 |
318410 | 318410 | 2020-07-09 | Buena Vista city | Virginia | 51530 | 15 | 0 |
318415 | 318415 | 2020-07-09 | Charlotte | Virginia | 51037 | 33 | 0 |
318419 | 318419 | 2020-07-09 | Clarke | Virginia | 51043 | 58 | 0 |
318421 | 318421 | 2020-07-09 | Covington city | Virginia | 51580 | 5 | 0 |
318422 | 318422 | 2020-07-09 | Craig | Virginia | 51045 | 9 | 0 |
318424 | 318424 | 2020-07-09 | Cumberland | Virginia | 51049 | 59 | 0 |
318426 | 318426 | 2020-07-09 | Dickenson | Virginia | 51051 | 5 | 0 |
318429 | 318429 | 2020-07-09 | Essex | Virginia | 51057 | 64 | 0 |
318439 | 318439 | 2020-07-09 | Fredericksburg city | Virginia | 51630 | 264 | 0 |
318441 | 318441 | 2020-07-09 | Giles | Virginia | 51071 | 18 | 0 |
318453 | 318453 | 2020-07-09 | Highland | Virginia | 51091 | 3 | 0 |
318460 | 318460 | 2020-07-09 | Lancaster | Virginia | 51103 | 12 | 0 |
318461 | 318461 | 2020-07-09 | Lee | Virginia | 51105 | 15 | 0 |
318462 | 318462 | 2020-07-09 | Lexington city | Virginia | 51678 | 12 | 0 |
318465 | 318465 | 2020-07-09 | Lunenburg | Virginia | 51111 | 39 | 0 |
318471 | 318471 | 2020-07-09 | Mathews | Virginia | 51115 | 7 | 0 |
318473 | 318473 | 2020-07-09 | Middlesex | Virginia | 51119 | 15 | 0 |
318475 | 318475 | 2020-07-09 | Nelson | Virginia | 51125 | 22 | 0 |
318481 | 318481 | 2020-07-09 | Norton city | Virginia | 51720 | 4 | 0 |
318488 | 318488 | 2020-07-09 | Poquoson city | Virginia | 51735 | 20 | 0 |
318495 | 318495 | 2020-07-09 | Radford city | Virginia | 51750 | 16 | 0 |
318496 | 318496 | 2020-07-09 | Rappahannock | Virginia | 51157 | 31 | 0 |
318501 | 318501 | 2020-07-09 | Rockbridge | Virginia | 51163 | 33 | 0 |
318503 | 318503 | 2020-07-09 | Russell | Virginia | 51167 | 15 | 0 |
318511 | 318511 | 2020-07-09 | Staunton city | Virginia | 51790 | 85 | 0 |
318515 | 318515 | 2020-07-09 | Tazewell | Virginia | 51185 | 23 | 0 |
318519 | 318519 | 2020-07-09 | Waynesboro city | Virginia | 51820 | 114 | 0 |
318397 | 318397 | 2020-07-09 | Amelia | Virginia | 51007 | 49 | 1 |
318407 | 318407 | 2020-07-09 | Brunswick | Virginia | 51025 | 116 | 1 |
318411 | 318411 | 2020-07-09 | Campbell | Virginia | 51031 | 54 | 1 |
318434 | 318434 | 2020-07-09 | Floyd | Virginia | 51063 | 20 | 1 |
318436 | 318436 | 2020-07-09 | Franklin | Virginia | 51067 | 106 | 1 |
318442 | 318442 | 2020-07-09 | Gloucester | Virginia | 51073 | 64 | 1 |
318447 | 318447 | 2020-07-09 | Halifax | Virginia | 51083 | 73 | 1 |
318458 | 318458 | 2020-07-09 | King William | Virginia | 51101 | 54 | 1 |
318459 | 318459 | 2020-07-09 | King and Queen | Virginia | 51097 | 26 | 1 |
318466 | 318466 | 2020-07-09 | Lynchburg city | Virginia | 51680 | 169 | 1 |
318467 | 318467 | 2020-07-09 | Madison | Virginia | 51113 | 46 | 1 |
318470 | 318470 | 2020-07-09 | Martinsville city | Virginia | 51690 | 104 | 1 |
318476 | 318476 | 2020-07-09 | New Kent | Virginia | 51127 | 62 | 1 |
318480 | 318480 | 2020-07-09 | Northumberland | Virginia | 51133 | 37 | 1 |
318485 | 318485 | 2020-07-09 | Patrick | Virginia | 51141 | 48 | 1 |
318487 | 318487 | 2020-07-09 | Pittsylvania | Virginia | 51143 | 146 | 1 |
318507 | 318507 | 2020-07-09 | Smyth | Virginia | 51173 | 42 | 1 |
318513 | 318513 | 2020-07-09 | Surry | Virginia | 51181 | 17 | 1 |
318524 | 318524 | 2020-07-09 | Wythe | Virginia | 51197 | 57 | 1 |
318396 | 318396 | 2020-07-09 | Alleghany | Virginia | 51005 | 39 | 2 |
318401 | 318401 | 2020-07-09 | Augusta | Virginia | 51015 | 200 | 2 |
318425 | 318425 | 2020-07-09 | Danville city | Virginia | 51590 | 102 | 2 |
318427 | 318427 | 2020-07-09 | Dinwiddie | Virginia | 51053 | 154 | 2 |
318445 | 318445 | 2020-07-09 | Greene | Virginia | 51079 | 78 | 2 |
318464 | 318464 | 2020-07-09 | Louisa | Virginia | 51109 | 134 | 2 |
318490 | 318490 | 2020-07-09 | Powhatan | Virginia | 51145 | 86 | 2 |
318492 | 318492 | 2020-07-09 | Prince George | Virginia | 51149 | 254 | 2 |
318494 | 318494 | 2020-07-09 | Pulaski | Virginia | 51155 | 48 | 2 |
318505 | 318505 | 2020-07-09 | Scott | Virginia | 51169 | 11 | 2 |
318520 | 318520 | 2020-07-09 | Westmoreland | Virginia | 51193 | 124 | 2 |
318523 | 318523 | 2020-07-09 | Wise | Virginia | 51195 | 34 | 2 |
318414 | 318414 | 2020-07-09 | Charles City | Virginia | 51036 | 41 | 3 |
318437 | 318437 | 2020-07-09 | Franklin city | Virginia | 51620 | 66 | 3 |
318474 | 318474 | 2020-07-09 | Montgomery | Virginia | 51121 | 172 | 3 |
318483 | 318483 | 2020-07-09 | Orange | Virginia | 51137 | 155 | 3 |
318504 | 318504 | 2020-07-09 | Salem city | Virginia | 51775 | 84 | 3 |
318522 | 318522 | 2020-07-09 | Winchester city | Virginia | 51840 | 334 | 3 |
318525 | 318525 | 2020-07-09 | York | Virginia | 51199 | 140 | 3 |
318403 | 318403 | 2020-07-09 | Bedford | Virginia | 51019 | 142 | 4 |
318405 | 318405 | 2020-07-09 | Botetourt | Virginia | 51023 | 150 | 4 |
318412 | 318412 | 2020-07-09 | Caroline | Virginia | 51033 | 132 | 4 |
318444 | 318444 | 2020-07-09 | Grayson | Virginia | 51077 | 91 | 4 |
318448 | 318448 | 2020-07-09 | Hampton city | Virginia | 51650 | 424 | 4 |
318457 | 318457 | 2020-07-09 | King George | Virginia | 51099 | 102 | 4 |
318482 | 318482 | 2020-07-09 | Nottoway | Virginia | 51135 | 114 | 4 |
318497 | 318497 | 2020-07-09 | Richmond | Virginia | 51159 | 304 | 4 |
318518 | 318518 | 2020-07-09 | Washington | Virginia | 51191 | 74 | 4 |
318452 | 318452 | 2020-07-09 | Henry | Virginia | 51089 | 330 | 5 |
318454 | 318454 | 2020-07-09 | Hopewell city | Virginia | 51670 | 192 | 5 |
318409 | 318409 | 2020-07-09 | Buckingham | Virginia | 51029 | 572 | 6 |
318438 | 318438 | 2020-07-09 | Frederick | Virginia | 51069 | 534 | 6 |
318443 | 318443 | 2020-07-09 | Goochland | Virginia | 51075 | 129 | 6 |
318468 | 318468 | 2020-07-09 | Manassas Park city | Virginia | 51685 | 451 | 6 |
318491 | 318491 | 2020-07-09 | Prince Edward | Virginia | 51147 | 234 | 6 |
318499 | 318499 | 2020-07-09 | Roanoke | Virginia | 51161 | 301 | 6 |
318510 | 318510 | 2020-07-09 | Stafford | Virginia | 51179 | 1038 | 6 |
318521 | 318521 | 2020-07-09 | Williamsburg city | Virginia | 51830 | 78 | 6 |
318416 | 318416 | 2020-07-09 | Charlottesville city | Virginia | 51540 | 251 | 7 |
318431 | 318431 | 2020-07-09 | Fairfax city | Virginia | 51600 | 72 | 7 |
318432 | 318432 | 2020-07-09 | Falls Church city | Virginia | 51610 | 53 | 7 |
318514 | 318514 | 2020-07-09 | Sussex | Virginia | 51183 | 210 | 7 |
318517 | 318517 | 2020-07-09 | Warren | Virginia | 51187 | 303 | 7 |
318433 | 318433 | 2020-07-09 | Fauquier | Virginia | 51061 | 460 | 8 |
318435 | 318435 | 2020-07-09 | Fluvanna | Virginia | 51065 | 126 | 8 |
318446 | 318446 | 2020-07-09 | Greensville | Virginia | 51081 | 373 | 8 |
318486 | 318486 | 2020-07-09 | Petersburg city | Virginia | 51730 | 314 | 8 |
318413 | 318413 | 2020-07-09 | Carroll | Virginia | 51035 | 241 | 9 |
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);