ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
133 rows where date = "2020-09-05" and state = "Virginia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: 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
- 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 |
---|---|---|---|---|---|---|---|
504986 | 504986 | 2020-09-05 | Accomack | Virginia | 51001 | 1152 | 19 |
504987 | 504987 | 2020-09-05 | Albemarle | Virginia | 51003 | 1079 | 19 |
504988 | 504988 | 2020-09-05 | Alexandria city | Virginia | 51510 | 3476 | 62 |
504989 | 504989 | 2020-09-05 | Alleghany | Virginia | 51005 | 69 | 4 |
504990 | 504990 | 2020-09-05 | Amelia | Virginia | 51007 | 101 | 3 |
504991 | 504991 | 2020-09-05 | Amherst | Virginia | 51009 | 320 | 1 |
504992 | 504992 | 2020-09-05 | Appomattox | Virginia | 51011 | 180 | 1 |
504993 | 504993 | 2020-09-05 | Arlington | Virginia | 51013 | 3620 | 143 |
504994 | 504994 | 2020-09-05 | Augusta | Virginia | 51015 | 382 | 4 |
504995 | 504995 | 2020-09-05 | Bath | Virginia | 51017 | 4 | 0 |
504996 | 504996 | 2020-09-05 | Bedford | Virginia | 51019 | 602 | 9 |
504997 | 504997 | 2020-09-05 | Bland | Virginia | 51021 | 60 | 1 |
504998 | 504998 | 2020-09-05 | Botetourt | Virginia | 51023 | 256 | 10 |
504999 | 504999 | 2020-09-05 | Bristol city | Virginia | 51520 | 123 | 2 |
505000 | 505000 | 2020-09-05 | Brunswick | Virginia | 51025 | 308 | 2 |
505001 | 505001 | 2020-09-05 | Buchanan | Virginia | 51027 | 99 | 2 |
505002 | 505002 | 2020-09-05 | Buckingham | Virginia | 51029 | 655 | 8 |
505003 | 505003 | 2020-09-05 | Buena Vista city | Virginia | 51530 | 76 | 1 |
505004 | 505004 | 2020-09-05 | Campbell | Virginia | 51031 | 348 | 3 |
505005 | 505005 | 2020-09-05 | Caroline | Virginia | 51033 | 274 | 5 |
505006 | 505006 | 2020-09-05 | Carroll | Virginia | 51035 | 436 | 19 |
505007 | 505007 | 2020-09-05 | Charles City | Virginia | 51036 | 69 | 5 |
505008 | 505008 | 2020-09-05 | Charlotte | Virginia | 51037 | 79 | 0 |
505009 | 505009 | 2020-09-05 | Charlottesville city | Virginia | 51540 | 768 | 23 |
505010 | 505010 | 2020-09-05 | Chesapeake city | Virginia | 51550 | 3899 | 49 |
505011 | 505011 | 2020-09-05 | Chesterfield | Virginia | 51041 | 5251 | 83 |
505012 | 505012 | 2020-09-05 | Clarke | Virginia | 51043 | 83 | 0 |
505013 | 505013 | 2020-09-05 | Colonial Heights city | Virginia | 51570 | 232 | 23 |
505014 | 505014 | 2020-09-05 | Covington city | Virginia | 51580 | 26 | 0 |
505015 | 505015 | 2020-09-05 | Craig | Virginia | 51045 | 22 | 0 |
505016 | 505016 | 2020-09-05 | Culpeper | Virginia | 51047 | 1131 | 14 |
505017 | 505017 | 2020-09-05 | Cumberland | Virginia | 51049 | 101 | 0 |
505018 | 505018 | 2020-09-05 | Danville city | Virginia | 51590 | 652 | 16 |
505019 | 505019 | 2020-09-05 | Dickenson | Virginia | 51051 | 69 | 1 |
505020 | 505020 | 2020-09-05 | Dinwiddie | Virginia | 51053 | 314 | 8 |
505021 | 505021 | 2020-09-05 | Emporia city | Virginia | 51595 | 238 | 19 |
505022 | 505022 | 2020-09-05 | Essex | Virginia | 51057 | 143 | 2 |
505023 | 505023 | 2020-09-05 | Fairfax | Virginia | 51059 | 18876 | 562 |
505024 | 505024 | 2020-09-05 | Fairfax city | Virginia | 51600 | 126 | 7 |
505025 | 505025 | 2020-09-05 | Falls Church city | Virginia | 51610 | 66 | 7 |
505026 | 505026 | 2020-09-05 | Fauquier | Virginia | 51061 | 794 | 15 |
505027 | 505027 | 2020-09-05 | Floyd | Virginia | 51063 | 154 | 2 |
505028 | 505028 | 2020-09-05 | Fluvanna | Virginia | 51065 | 229 | 9 |
505029 | 505029 | 2020-09-05 | Franklin | Virginia | 51067 | 240 | 1 |
505030 | 505030 | 2020-09-05 | Franklin city | Virginia | 51620 | 329 | 7 |
505031 | 505031 | 2020-09-05 | Frederick | Virginia | 51069 | 777 | 11 |
505032 | 505032 | 2020-09-05 | Fredericksburg city | Virginia | 51630 | 491 | 4 |
505033 | 505033 | 2020-09-05 | Galax city | Virginia | 51640 | 401 | 28 |
505034 | 505034 | 2020-09-05 | Giles | Virginia | 51071 | 58 | 0 |
505035 | 505035 | 2020-09-05 | Gloucester | Virginia | 51073 | 207 | 2 |
505036 | 505036 | 2020-09-05 | Goochland | Virginia | 51075 | 224 | 7 |
505037 | 505037 | 2020-09-05 | Grayson | Virginia | 51077 | 241 | 8 |
505038 | 505038 | 2020-09-05 | Greene | Virginia | 51079 | 200 | 3 |
505039 | 505039 | 2020-09-05 | Greensville | Virginia | 51081 | 716 | 11 |
505040 | 505040 | 2020-09-05 | Halifax | Virginia | 51083 | 230 | 4 |
505041 | 505041 | 2020-09-05 | Hampton city | Virginia | 51650 | 1614 | 16 |
505042 | 505042 | 2020-09-05 | Hanover | Virginia | 51085 | 855 | 35 |
505043 | 505043 | 2020-09-05 | Harrisonburg city | Virginia | 51660 | 1665 | 33 |
505044 | 505044 | 2020-09-05 | Henrico | Virginia | 51087 | 4757 | 194 |
505045 | 505045 | 2020-09-05 | Henry | Virginia | 51089 | 907 | 16 |
505046 | 505046 | 2020-09-05 | Highland | Virginia | 51091 | 6 | 0 |
505047 | 505047 | 2020-09-05 | Hopewell city | Virginia | 51670 | 355 | 5 |
505048 | 505048 | 2020-09-05 | Isle of Wight | Virginia | 51093 | 603 | 11 |
505049 | 505049 | 2020-09-05 | James City | Virginia | 51095 | 760 | 18 |
505050 | 505050 | 2020-09-05 | King George | Virginia | 51099 | 210 | 4 |
505051 | 505051 | 2020-09-05 | King William | Virginia | 51101 | 119 | 2 |
505052 | 505052 | 2020-09-05 | King and Queen | Virginia | 51097 | 54 | 1 |
505053 | 505053 | 2020-09-05 | Lancaster | Virginia | 51103 | 81 | 0 |
505054 | 505054 | 2020-09-05 | Lee | Virginia | 51105 | 224 | 4 |
505055 | 505055 | 2020-09-05 | Lexington city | Virginia | 51678 | 43 | 1 |
505056 | 505056 | 2020-09-05 | Loudoun | Virginia | 51107 | 6166 | 118 |
505057 | 505057 | 2020-09-05 | Louisa | Virginia | 51109 | 260 | 3 |
505058 | 505058 | 2020-09-05 | Lunenburg | Virginia | 51111 | 100 | 2 |
505059 | 505059 | 2020-09-05 | Lynchburg city | Virginia | 51680 | 1063 | 5 |
505060 | 505060 | 2020-09-05 | Madison | Virginia | 51113 | 92 | 2 |
505061 | 505061 | 2020-09-05 | Manassas Park city | Virginia | 51685 | 575 | 7 |
505062 | 505062 | 2020-09-05 | Manassas city | Virginia | 51683 | 1830 | 24 |
505063 | 505063 | 2020-09-05 | Martinsville city | Virginia | 51690 | 339 | 6 |
505064 | 505064 | 2020-09-05 | Mathews | Virginia | 51115 | 23 | 0 |
505065 | 505065 | 2020-09-05 | Mecklenburg | Virginia | 51117 | 582 | 33 |
505066 | 505066 | 2020-09-05 | Middlesex | Virginia | 51119 | 61 | 1 |
505067 | 505067 | 2020-09-05 | Montgomery | Virginia | 51121 | 828 | 4 |
505068 | 505068 | 2020-09-05 | Nelson | Virginia | 51125 | 88 | 0 |
505069 | 505069 | 2020-09-05 | New Kent | Virginia | 51127 | 158 | 1 |
505070 | 505070 | 2020-09-05 | Newport News city | Virginia | 51700 | 2450 | 28 |
505071 | 505071 | 2020-09-05 | Norfolk city | Virginia | 51710 | 4481 | 60 |
505072 | 505072 | 2020-09-05 | Northampton | Virginia | 51131 | 304 | 29 |
505073 | 505073 | 2020-09-05 | Northumberland | Virginia | 51133 | 97 | 5 |
505074 | 505074 | 2020-09-05 | Norton city | Virginia | 51720 | 27 | 0 |
505075 | 505075 | 2020-09-05 | Nottoway | Virginia | 51135 | 206 | 15 |
505076 | 505076 | 2020-09-05 | Orange | Virginia | 51137 | 269 | 4 |
505077 | 505077 | 2020-09-05 | Page | Virginia | 51139 | 365 | 27 |
505078 | 505078 | 2020-09-05 | Patrick | Virginia | 51141 | 244 | 13 |
505079 | 505079 | 2020-09-05 | Petersburg city | Virginia | 51730 | 652 | 23 |
505080 | 505080 | 2020-09-05 | Pittsylvania | Virginia | 51143 | 833 | 5 |
505081 | 505081 | 2020-09-05 | Poquoson city | Virginia | 51735 | 71 | 0 |
505082 | 505082 | 2020-09-05 | Portsmouth city | Virginia | 51740 | 2277 | 43 |
505083 | 505083 | 2020-09-05 | Powhatan | Virginia | 51145 | 195 | 4 |
505084 | 505084 | 2020-09-05 | Prince Edward | Virginia | 51147 | 508 | 12 |
505085 | 505085 | 2020-09-05 | Prince George | Virginia | 51149 | 601 | 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);