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 date descending
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 |
---|---|---|---|---|---|---|---|
318393 | 318393 | 2020-07-09 | Accomack | Virginia | 51001 | 1042 | 14 |
318394 | 318394 | 2020-07-09 | Albemarle | Virginia | 51003 | 512 | 10 |
318395 | 318395 | 2020-07-09 | Alexandria city | Virginia | 51510 | 2419 | 57 |
318396 | 318396 | 2020-07-09 | Alleghany | Virginia | 51005 | 39 | 2 |
318397 | 318397 | 2020-07-09 | Amelia | Virginia | 51007 | 49 | 1 |
318398 | 318398 | 2020-07-09 | Amherst | Virginia | 51009 | 38 | 0 |
318399 | 318399 | 2020-07-09 | Appomattox | Virginia | 51011 | 44 | 0 |
318400 | 318400 | 2020-07-09 | Arlington | Virginia | 51013 | 2567 | 132 |
318401 | 318401 | 2020-07-09 | Augusta | Virginia | 51015 | 200 | 2 |
318402 | 318402 | 2020-07-09 | Bath | Virginia | 51017 | 1 | 0 |
318403 | 318403 | 2020-07-09 | Bedford | Virginia | 51019 | 142 | 4 |
318404 | 318404 | 2020-07-09 | Bland | Virginia | 51021 | 2 | 0 |
318405 | 318405 | 2020-07-09 | Botetourt | Virginia | 51023 | 150 | 4 |
318406 | 318406 | 2020-07-09 | Bristol city | Virginia | 51520 | 8 | 0 |
318407 | 318407 | 2020-07-09 | Brunswick | Virginia | 51025 | 116 | 1 |
318408 | 318408 | 2020-07-09 | Buchanan | Virginia | 51027 | 38 | 0 |
318409 | 318409 | 2020-07-09 | Buckingham | Virginia | 51029 | 572 | 6 |
318410 | 318410 | 2020-07-09 | Buena Vista city | Virginia | 51530 | 15 | 0 |
318411 | 318411 | 2020-07-09 | Campbell | Virginia | 51031 | 54 | 1 |
318412 | 318412 | 2020-07-09 | Caroline | Virginia | 51033 | 132 | 4 |
318413 | 318413 | 2020-07-09 | Carroll | Virginia | 51035 | 241 | 9 |
318414 | 318414 | 2020-07-09 | Charles City | Virginia | 51036 | 41 | 3 |
318415 | 318415 | 2020-07-09 | Charlotte | Virginia | 51037 | 33 | 0 |
318416 | 318416 | 2020-07-09 | Charlottesville city | Virginia | 51540 | 251 | 7 |
318417 | 318417 | 2020-07-09 | Chesapeake city | Virginia | 51550 | 1117 | 22 |
318418 | 318418 | 2020-07-09 | Chesterfield | Virginia | 51041 | 3108 | 61 |
318419 | 318419 | 2020-07-09 | Clarke | Virginia | 51043 | 58 | 0 |
318420 | 318420 | 2020-07-09 | Colonial Heights city | Virginia | 51570 | 151 | 20 |
318421 | 318421 | 2020-07-09 | Covington city | Virginia | 51580 | 5 | 0 |
318422 | 318422 | 2020-07-09 | Craig | Virginia | 51045 | 9 | 0 |
318423 | 318423 | 2020-07-09 | Culpeper | Virginia | 51047 | 837 | 12 |
318424 | 318424 | 2020-07-09 | Cumberland | Virginia | 51049 | 59 | 0 |
318425 | 318425 | 2020-07-09 | Danville city | Virginia | 51590 | 102 | 2 |
318426 | 318426 | 2020-07-09 | Dickenson | Virginia | 51051 | 5 | 0 |
318427 | 318427 | 2020-07-09 | Dinwiddie | Virginia | 51053 | 154 | 2 |
318428 | 318428 | 2020-07-09 | Emporia city | Virginia | 51595 | 147 | 15 |
318429 | 318429 | 2020-07-09 | Essex | Virginia | 51057 | 64 | 0 |
318430 | 318430 | 2020-07-09 | Fairfax | Virginia | 51059 | 14284 | 497 |
318431 | 318431 | 2020-07-09 | Fairfax city | Virginia | 51600 | 72 | 7 |
318432 | 318432 | 2020-07-09 | Falls Church city | Virginia | 51610 | 53 | 7 |
318433 | 318433 | 2020-07-09 | Fauquier | Virginia | 51061 | 460 | 8 |
318434 | 318434 | 2020-07-09 | Floyd | Virginia | 51063 | 20 | 1 |
318435 | 318435 | 2020-07-09 | Fluvanna | Virginia | 51065 | 126 | 8 |
318436 | 318436 | 2020-07-09 | Franklin | Virginia | 51067 | 106 | 1 |
318437 | 318437 | 2020-07-09 | Franklin city | Virginia | 51620 | 66 | 3 |
318438 | 318438 | 2020-07-09 | Frederick | Virginia | 51069 | 534 | 6 |
318439 | 318439 | 2020-07-09 | Fredericksburg city | Virginia | 51630 | 264 | 0 |
318440 | 318440 | 2020-07-09 | Galax city | Virginia | 51640 | 282 | 16 |
318441 | 318441 | 2020-07-09 | Giles | Virginia | 51071 | 18 | 0 |
318442 | 318442 | 2020-07-09 | Gloucester | Virginia | 51073 | 64 | 1 |
318443 | 318443 | 2020-07-09 | Goochland | Virginia | 51075 | 129 | 6 |
318444 | 318444 | 2020-07-09 | Grayson | Virginia | 51077 | 91 | 4 |
318445 | 318445 | 2020-07-09 | Greene | Virginia | 51079 | 78 | 2 |
318446 | 318446 | 2020-07-09 | Greensville | Virginia | 51081 | 373 | 8 |
318447 | 318447 | 2020-07-09 | Halifax | Virginia | 51083 | 73 | 1 |
318448 | 318448 | 2020-07-09 | Hampton city | Virginia | 51650 | 424 | 4 |
318449 | 318449 | 2020-07-09 | Hanover | Virginia | 51085 | 459 | 31 |
318450 | 318450 | 2020-07-09 | Harrisonburg city | Virginia | 51660 | 975 | 28 |
318451 | 318451 | 2020-07-09 | Henrico | Virginia | 51087 | 2725 | 169 |
318452 | 318452 | 2020-07-09 | Henry | Virginia | 51089 | 330 | 5 |
318453 | 318453 | 2020-07-09 | Highland | Virginia | 51091 | 3 | 0 |
318454 | 318454 | 2020-07-09 | Hopewell city | Virginia | 51670 | 192 | 5 |
318455 | 318455 | 2020-07-09 | Isle of Wight | Virginia | 51093 | 209 | 9 |
318456 | 318456 | 2020-07-09 | James City | Virginia | 51095 | 323 | 16 |
318457 | 318457 | 2020-07-09 | King George | Virginia | 51099 | 102 | 4 |
318458 | 318458 | 2020-07-09 | King William | Virginia | 51101 | 54 | 1 |
318459 | 318459 | 2020-07-09 | King and Queen | Virginia | 51097 | 26 | 1 |
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 |
318463 | 318463 | 2020-07-09 | Loudoun | Virginia | 51107 | 4319 | 99 |
318464 | 318464 | 2020-07-09 | Louisa | Virginia | 51109 | 134 | 2 |
318465 | 318465 | 2020-07-09 | Lunenburg | Virginia | 51111 | 39 | 0 |
318466 | 318466 | 2020-07-09 | Lynchburg city | Virginia | 51680 | 169 | 1 |
318467 | 318467 | 2020-07-09 | Madison | Virginia | 51113 | 46 | 1 |
318468 | 318468 | 2020-07-09 | Manassas Park city | Virginia | 51685 | 451 | 6 |
318469 | 318469 | 2020-07-09 | Manassas city | Virginia | 51683 | 1464 | 18 |
318470 | 318470 | 2020-07-09 | Martinsville city | Virginia | 51690 | 104 | 1 |
318471 | 318471 | 2020-07-09 | Mathews | Virginia | 51115 | 7 | 0 |
318472 | 318472 | 2020-07-09 | Mecklenburg | Virginia | 51117 | 252 | 29 |
318473 | 318473 | 2020-07-09 | Middlesex | Virginia | 51119 | 15 | 0 |
318474 | 318474 | 2020-07-09 | Montgomery | Virginia | 51121 | 172 | 3 |
318475 | 318475 | 2020-07-09 | Nelson | Virginia | 51125 | 22 | 0 |
318476 | 318476 | 2020-07-09 | New Kent | Virginia | 51127 | 62 | 1 |
318477 | 318477 | 2020-07-09 | Newport News city | Virginia | 51700 | 659 | 10 |
318478 | 318478 | 2020-07-09 | Norfolk city | Virginia | 51710 | 1289 | 14 |
318479 | 318479 | 2020-07-09 | Northampton | Virginia | 51131 | 272 | 28 |
318480 | 318480 | 2020-07-09 | Northumberland | Virginia | 51133 | 37 | 1 |
318481 | 318481 | 2020-07-09 | Norton city | Virginia | 51720 | 4 | 0 |
318482 | 318482 | 2020-07-09 | Nottoway | Virginia | 51135 | 114 | 4 |
318483 | 318483 | 2020-07-09 | Orange | Virginia | 51137 | 155 | 3 |
318484 | 318484 | 2020-07-09 | Page | Virginia | 51139 | 295 | 23 |
318485 | 318485 | 2020-07-09 | Patrick | Virginia | 51141 | 48 | 1 |
318486 | 318486 | 2020-07-09 | Petersburg city | Virginia | 51730 | 314 | 8 |
318487 | 318487 | 2020-07-09 | Pittsylvania | Virginia | 51143 | 146 | 1 |
318488 | 318488 | 2020-07-09 | Poquoson city | Virginia | 51735 | 20 | 0 |
318489 | 318489 | 2020-07-09 | Portsmouth city | Virginia | 51740 | 605 | 18 |
318490 | 318490 | 2020-07-09 | Powhatan | Virginia | 51145 | 86 | 2 |
318491 | 318491 | 2020-07-09 | Prince Edward | Virginia | 51147 | 234 | 6 |
318492 | 318492 | 2020-07-09 | Prince George | Virginia | 51149 | 254 | 2 |
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);