daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
134 rows where "last_update" is on date 2020-04-13 and province_or_state = "Virginia" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-04-13 | US | Virginia | Prince William | 51153 | 434 | 1 | 0 | 433 | 38.70916224 | -77.48713689 | 2020-04-13 23:07:54 | Prince William, Virginia, US |
2020-04-13 | US | Virginia | Pulaski | 51155 | 4 | 0 | 0 | 4 | 37.06474963 | -80.71229738 | 2020-04-13 23:07:54 | Pulaski, Virginia, US |
2020-04-13 | US | Virginia | Radford | 51750 | 1 | 0 | 0 | 1 | 37.12222899 | -80.56027320000003 | 2020-04-13 23:07:54 | Radford, Virginia, US |
2020-04-13 | US | Virginia | Rappahannock | 51157 | 1 | 0 | 0 | 1 | 38.68295619 | -78.15826963 | 2020-04-13 23:07:54 | Rappahannock, Virginia, US |
2020-04-13 | US | Virginia | Richmond | 51159 | 5 | 0 | 0 | 5 | 37.937575 | -76.72920628 | 2020-04-13 23:07:54 | Richmond, Virginia, US |
2020-04-13 | US | Virginia | Richmond City | 51760 | 167 | 0 | 0 | 167 | 37.53255773 | -77.47966921 | 2020-04-13 23:07:54 | Richmond City, Virginia, US |
2020-04-13 | US | Virginia | Roanoke | 51161 | 18 | 0 | 0 | 18 | 37.26865804 | -80.06396753 | 2020-04-13 23:07:54 | Roanoke, Virginia, US |
2020-04-13 | US | Virginia | Roanoke City | 51770 | 21 | 0 | 0 | 21 | 37.27791025 | -79.96189766 | 2020-04-13 23:07:54 | Roanoke City, Virginia, US |
2020-04-13 | US | Virginia | Rockbridge | 51163 | 3 | 0 | 0 | 3 | 37.81204314 | -79.44605905 | 2020-04-13 23:07:54 | Rockbridge, Virginia, US |
2020-04-13 | US | Virginia | Rockingham | 51165 | 49 | 0 | 0 | 49 | 38.51006137 | -78.87260325 | 2020-04-13 23:07:54 | Rockingham, Virginia, US |
2020-04-13 | US | Virginia | Russell | 51167 | 1 | 0 | 0 | 1 | 36.93028320000001 | -82.10095486 | 2020-04-13 23:07:54 | Russell, Virginia, US |
2020-04-13 | US | Virginia | Salem | 51775 | 1 | 0 | 0 | 1 | 37.2836193 | -80.06219455 | 2020-04-13 23:07:54 | Salem, Virginia, US |
2020-04-13 | US | Virginia | Scott | 51169 | 3 | 0 | 0 | 3 | 36.71466456 | -82.60171704 | 2020-04-13 23:07:54 | Scott, Virginia, US |
2020-04-13 | US | Virginia | Shenandoah | 51171 | 17 | 0 | 0 | 17 | 38.85905135 | -78.56813762 | 2020-04-13 23:07:54 | Shenandoah, Virginia, US |
2020-04-13 | US | Virginia | Smyth | 51173 | 11 | 0 | 0 | 11 | 36.84455636 | -81.53344948 | 2020-04-13 23:07:54 | Smyth, Virginia, US |
2020-04-13 | US | Virginia | Southampton | 51175 | 5 | 0 | 0 | 5 | 36.72231125 | -77.10642712 | 2020-04-13 23:07:54 | Southampton, Virginia, US |
2020-04-13 | US | Virginia | Spotsylvania | 51177 | 51 | 0 | 0 | 51 | 38.18574462 | -77.655399 | 2020-04-13 23:07:54 | Spotsylvania, Virginia, US |
2020-04-13 | US | Virginia | Stafford | 51179 | 87 | 0 | 0 | 87 | 38.41758738 | -77.45917053 | 2020-04-13 23:07:54 | Stafford, Virginia, US |
2020-04-13 | US | Virginia | Staunton | 51790 | 2 | 0 | 0 | 2 | 38.15965544 | -79.05979937 | 2020-04-13 23:07:54 | Staunton, Virginia, US |
2020-04-13 | US | Virginia | Suffolk | 51800 | 51 | 0 | 0 | 51 | 36.70155394 | -76.63603554 | 2020-04-13 23:07:54 | Suffolk, Virginia, US |
2020-04-13 | US | Virginia | Surry | 51181 | 3 | 0 | 0 | 3 | 37.11781893 | -76.88450012 | 2020-04-13 23:07:54 | Surry, Virginia, US |
2020-04-13 | US | Virginia | Sussex | 51183 | 8 | 0 | 0 | 8 | 36.92432914 | -77.25791182 | 2020-04-13 23:07:54 | Sussex, Virginia, US |
2020-04-13 | US | Virginia | Tazewell | 51185 | 4 | 0 | 0 | 4 | 37.12191123 | -81.56685568 | 2020-04-13 23:07:54 | Tazewell, Virginia, US |
2020-04-13 | US | Virginia | Unassigned | 90051 | 0 | 70 | 0 | 0 | 39.20172582 | 0.0 | 2020-04-13 23:07:54 | Unassigned, Virginia, US |
2020-04-13 | US | Virginia | Virginia Beach | 51810 | 251 | 1 | 0 | 250 | 36.73285734 | -76.04566934 | 2020-04-13 23:07:54 | Virginia Beach, Virginia, US |
2020-04-13 | US | Virginia | Warren | 51187 | 17 | 0 | 0 | 17 | 38.90847745 | -78.20280433 | 2020-04-13 23:07:54 | Warren, Virginia, US |
2020-04-13 | US | Virginia | Washington | 51191 | 28 | 0 | 0 | 28 | 36.72341572 | -81.95666289 | 2020-04-13 23:07:54 | Washington, Virginia, US |
2020-04-13 | US | Virginia | Waynesboro | 51820 | 6 | 0 | 0 | 6 | 38.06451466 | -78.90293905 | 2020-04-13 23:07:54 | Waynesboro, Virginia, US |
2020-04-13 | US | Virginia | Westmoreland | 51193 | 8 | 0 | 0 | 8 | 38.11021557 | -76.80213247 | 2020-04-13 23:07:54 | Westmoreland, Virginia, US |
2020-04-13 | US | Virginia | Williamsburg | 51830 | 20 | 1 | 0 | 19 | 37.28131268 | -76.70905141 | 2020-04-13 23:07:54 | Williamsburg, Virginia, US |
2020-04-13 | US | Virginia | Winchester | 51840 | 20 | 0 | 0 | 20 | 39.17054517 | -78.17325058 | 2020-04-13 23:07:54 | Winchester, Virginia, US |
2020-04-13 | US | Virginia | Wise | 51195 | 13 | 0 | 0 | 13 | 36.9746148 | -82.62410519 | 2020-04-13 23:07:54 | Wise, Virginia, US |
2020-04-13 | US | Virginia | Wythe | 51197 | 7 | 0 | 0 | 7 | 36.91582035 | -81.07834059 | 2020-04-13 23:07:54 | Wythe, Virginia, US |
2020-04-13 | US | Virginia | York | 51199 | 33 | 1 | 0 | 32 | 37.24374789 | -76.54412815 | 2020-04-13 23:07:54 | York, Virginia, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;