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 2022-03-19 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 |
---|---|---|---|---|---|---|---|
2323469 | 2323469 | 2022-03-19 | Accomack | Virginia | 51001 | 6928 | 105 |
2323470 | 2323470 | 2022-03-19 | Albemarle | Virginia | 51003 | 15840 | 149 |
2323471 | 2323471 | 2022-03-19 | Alexandria city | Virginia | 51510 | 29907 | 185 |
2323472 | 2323472 | 2022-03-19 | Alleghany | Virginia | 51005 | 3478 | 93 |
2323473 | 2323473 | 2022-03-19 | Amelia | Virginia | 51007 | 2595 | 60 |
2323474 | 2323474 | 2022-03-19 | Amherst | Virginia | 51009 | 7166 | 84 |
2323475 | 2323475 | 2022-03-19 | Appomattox | Virginia | 51011 | 3729 | 51 |
2323476 | 2323476 | 2022-03-19 | Arlington | Virginia | 51013 | 40734 | 321 |
2323477 | 2323477 | 2022-03-19 | Augusta | Virginia | 51015 | 18896 | 206 |
2323478 | 2323478 | 2022-03-19 | Bath | Virginia | 51017 | 887 | 20 |
2323479 | 2323479 | 2022-03-19 | Bedford | Virginia | 51019 | 16840 | 225 |
2323480 | 2323480 | 2022-03-19 | Bland | Virginia | 51021 | 1754 | 21 |
2323481 | 2323481 | 2022-03-19 | Botetourt | Virginia | 51023 | 7410 | 94 |
2323482 | 2323482 | 2022-03-19 | Bristol city | Virginia | 51520 | 4372 | 76 |
2323483 | 2323483 | 2022-03-19 | Brunswick | Virginia | 51025 | 3179 | 45 |
2323484 | 2323484 | 2022-03-19 | Buchanan | Virginia | 51027 | 4857 | 105 |
2323485 | 2323485 | 2022-03-19 | Buckingham | Virginia | 51029 | 3811 | 55 |
2323486 | 2323486 | 2022-03-19 | Buena Vista city | Virginia | 51530 | 1998 | 40 |
2323487 | 2323487 | 2022-03-19 | Campbell | Virginia | 51031 | 11662 | 197 |
2323488 | 2323488 | 2022-03-19 | Caroline | Virginia | 51033 | 6795 | 79 |
2323489 | 2323489 | 2022-03-19 | Carroll | Virginia | 51035 | 6608 | 141 |
2323490 | 2323490 | 2022-03-19 | Charles City | Virginia | 51036 | 1147 | 27 |
2323491 | 2323491 | 2022-03-19 | Charlotte | Virginia | 51037 | 2411 | 46 |
2323492 | 2323492 | 2022-03-19 | Charlottesville city | Virginia | 51540 | 10072 | 77 |
2323493 | 2323493 | 2022-03-19 | Chesapeake city | Virginia | 51550 | 49594 | 476 |
2323494 | 2323494 | 2022-03-19 | Chesterfield | Virginia | 51041 | 71782 | 746 |
2323495 | 2323495 | 2022-03-19 | Clarke | Virginia | 51043 | 2590 | 40 |
2323496 | 2323496 | 2022-03-19 | Colonial Heights city | Virginia | 51570 | 4803 | 95 |
2323497 | 2323497 | 2022-03-19 | Covington city | Virginia | 51580 | 1117 | 25 |
2323498 | 2323498 | 2022-03-19 | Craig | Virginia | 51045 | 1111 | 17 |
2323499 | 2323499 | 2022-03-19 | Culpeper | Virginia | 51047 | 11474 | 144 |
2323500 | 2323500 | 2022-03-19 | Cumberland | Virginia | 51049 | 1255 | 24 |
2323501 | 2323501 | 2022-03-19 | Danville city | Virginia | 51590 | 11114 | 275 |
2323502 | 2323502 | 2022-03-19 | Dickenson | Virginia | 51051 | 3325 | 47 |
2323503 | 2323503 | 2022-03-19 | Dinwiddie | Virginia | 51053 | 5273 | 84 |
2323504 | 2323504 | 2022-03-19 | Emporia city | Virginia | 51595 | 1151 | 53 |
2323505 | 2323505 | 2022-03-19 | Essex | Virginia | 51057 | 2250 | 31 |
2323506 | 2323506 | 2022-03-19 | Fairfax | Virginia | 51059 | 174638 | 1417 |
2323507 | 2323507 | 2022-03-19 | Fairfax city | Virginia | 51600 | 1949 | 43 |
2323508 | 2323508 | 2022-03-19 | Falls Church city | Virginia | 51610 | 1944 | 16 |
2323509 | 2323509 | 2022-03-19 | Fauquier | Virginia | 51061 | 12924 | 140 |
2323510 | 2323510 | 2022-03-19 | Floyd | Virginia | 51063 | 2544 | 46 |
2323511 | 2323511 | 2022-03-19 | Fluvanna | Virginia | 51065 | 4927 | 42 |
2323512 | 2323512 | 2022-03-19 | Franklin | Virginia | 51067 | 10721 | 189 |
2323513 | 2323513 | 2022-03-19 | Franklin city | Virginia | 51620 | 2455 | 51 |
2323514 | 2323514 | 2022-03-19 | Frederick | Virginia | 51069 | 20460 | 241 |
2323515 | 2323515 | 2022-03-19 | Fredericksburg city | Virginia | 51630 | 5277 | 38 |
2323516 | 2323516 | 2022-03-19 | Galax city | Virginia | 51640 | 2545 | 76 |
2323517 | 2323517 | 2022-03-19 | Giles | Virginia | 51071 | 4036 | 46 |
2323518 | 2323518 | 2022-03-19 | Gloucester | Virginia | 51073 | 7277 | 102 |
2323519 | 2323519 | 2022-03-19 | Goochland | Virginia | 51075 | 3885 | 46 |
2323520 | 2323520 | 2022-03-19 | Grayson | Virginia | 51077 | 4030 | 79 |
2323521 | 2323521 | 2022-03-19 | Greene | Virginia | 51079 | 4002 | 61 |
2323522 | 2323522 | 2022-03-19 | Greensville | Virginia | 51081 | 3312 | 37 |
2323523 | 2323523 | 2022-03-19 | Halifax | Virginia | 51083 | 6998 | 151 |
2323524 | 2323524 | 2022-03-19 | Hampton city | Virginia | 51650 | 27471 | 317 |
2323525 | 2323525 | 2022-03-19 | Hanover | Virginia | 51085 | 21581 | 274 |
2323526 | 2323526 | 2022-03-19 | Harrisonburg city | Virginia | 51660 | 13209 | 154 |
2323527 | 2323527 | 2022-03-19 | Henrico | Virginia | 51087 | 63828 | 894 |
2323528 | 2323528 | 2022-03-19 | Henry | Virginia | 51089 | 11483 | 254 |
2323529 | 2323529 | 2022-03-19 | Highland | Virginia | 51091 | 362 | 7 |
2323530 | 2323530 | 2022-03-19 | Hopewell city | Virginia | 51670 | 6093 | 118 |
2323531 | 2323531 | 2022-03-19 | Isle of Wight | Virginia | 51093 | 7247 | 109 |
2323532 | 2323532 | 2022-03-19 | James City | Virginia | 51095 | 14735 | 117 |
2323533 | 2323533 | 2022-03-19 | King George | Virginia | 51099 | 4983 | 38 |
2323534 | 2323534 | 2022-03-19 | King William | Virginia | 51101 | 3669 | 36 |
2323535 | 2323535 | 2022-03-19 | King and Queen | Virginia | 51097 | 1116 | 11 |
2323536 | 2323536 | 2022-03-19 | Lancaster | Virginia | 51103 | 1784 | 31 |
2323537 | 2323537 | 2022-03-19 | Lee | Virginia | 51105 | 6201 | 91 |
2323538 | 2323538 | 2022-03-19 | Lexington city | Virginia | 51678 | 2824 | 39 |
2323539 | 2323539 | 2022-03-19 | Loudoun | Virginia | 51107 | 66930 | 373 |
2323540 | 2323540 | 2022-03-19 | Louisa | Virginia | 51109 | 6520 | 80 |
2323541 | 2323541 | 2022-03-19 | Lunenburg | Virginia | 51111 | 2330 | 33 |
2323542 | 2323542 | 2022-03-19 | Lynchburg city | Virginia | 51680 | 20371 | 269 |
2323543 | 2323543 | 2022-03-19 | Madison | Virginia | 51113 | 2228 | 37 |
2323544 | 2323544 | 2022-03-19 | Manassas Park city | Virginia | 51685 | 3695 | 25 |
2323545 | 2323545 | 2022-03-19 | Manassas city | Virginia | 51683 | 9032 | 70 |
2323546 | 2323546 | 2022-03-19 | Martinsville city | Virginia | 51690 | 3251 | 114 |
2323547 | 2323547 | 2022-03-19 | Mathews | Virginia | 51115 | 1425 | 28 |
2323548 | 2323548 | 2022-03-19 | Mecklenburg | Virginia | 51117 | 6012 | 111 |
2323549 | 2323549 | 2022-03-19 | Middlesex | Virginia | 51119 | 1803 | 45 |
2323550 | 2323550 | 2022-03-19 | Montgomery | Virginia | 51121 | 18499 | 146 |
2323551 | 2323551 | 2022-03-19 | Nelson | Virginia | 51125 | 2687 | 32 |
2323552 | 2323552 | 2022-03-19 | New Kent | Virginia | 51127 | 4573 | 32 |
2323553 | 2323553 | 2022-03-19 | Newport News city | Virginia | 51700 | 36032 | 384 |
2323554 | 2323554 | 2022-03-19 | Norfolk city | Virginia | 51710 | 41819 | 461 |
2323555 | 2323555 | 2022-03-19 | Northampton | Virginia | 51131 | 2143 | 61 |
2323556 | 2323556 | 2022-03-19 | Northumberland | Virginia | 51133 | 2153 | 44 |
2323557 | 2323557 | 2022-03-19 | Norton city | Virginia | 51720 | 1302 | 22 |
2323558 | 2323558 | 2022-03-19 | Nottoway | Virginia | 51135 | 4010 | 87 |
2323559 | 2323559 | 2022-03-19 | Orange | Virginia | 51137 | 6853 | 85 |
2323560 | 2323560 | 2022-03-19 | Page | Virginia | 51139 | 5572 | 119 |
2323561 | 2323561 | 2022-03-19 | Patrick | Virginia | 51141 | 3578 | 91 |
2323562 | 2323562 | 2022-03-19 | Petersburg city | Virginia | 51730 | 8275 | 138 |
2323563 | 2323563 | 2022-03-19 | Pittsylvania | Virginia | 51143 | 13829 | 187 |
2323564 | 2323564 | 2022-03-19 | Poquoson city | Virginia | 51735 | 2329 | 29 |
2323565 | 2323565 | 2022-03-19 | Portsmouth city | Virginia | 51740 | 20664 | 316 |
2323566 | 2323566 | 2022-03-19 | Powhatan | Virginia | 51145 | 4971 | 55 |
2323567 | 2323567 | 2022-03-19 | Prince Edward | Virginia | 51147 | 4713 | 65 |
2323568 | 2323568 | 2022-03-19 | Prince George | Virginia | 51149 | 8237 | 69 |
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);