johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
67 rows where active = 89, country_or_region = "US" and province_or_state = "Virginia" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 1
- US · 67 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1861351 | 1861351 | 2021-02-25 | US | Virginia | Highland | 51091 | 89 | 0 | 0 | 89 | 38.35799465 | -79.56124594 | 2021-02-26 05:22:40 | Highland, Virginia, US |
283529 | 283529 | 2021-02-24 | US | Virginia | Highland | 51091 | 89 | 0 | 0 | 89 | 38.35799465 | -79.56124594 | 2021-02-25 05:24:57 | Highland, Virginia, US |
745660 | 745660 | 2021-02-20 | US | Virginia | Highland | 51091 | 89 | 0 | 0 | 89 | 38.35799465 | -79.56124594 | 2021-02-21 05:24:33 | Highland, Virginia, US |
474758 | 474758 | 2021-02-19 | US | Virginia | Highland | 51091 | 89 | 0 | 0 | 89 | 38.35799465 | -79.56124594 | 2021-02-20 05:22:51 | Highland, Virginia, US |
1603512 | 1603512 | 2020-12-10 | US | Virginia | Bath | 51017 | 89 | 0 | 0 | 89 | 38.05852573 | -79.73912095 | 2020-12-11 05:26:59 | Bath, Virginia, US |
78461 | 78461 | 2020-12-03 | US | Virginia | Norton | 51720 | 89 | 0 | 0 | 89 | 36.93357076 | -82.62750411 | 2020-12-04 05:27:27 | Norton, Virginia, US |
741614 | 741614 | 2020-12-02 | US | Virginia | Craig | 51045 | 90 | 1 | 0 | 89 | 37.48133648 | -80.21072274 | 2020-12-03 05:28:22 | Craig, Virginia, US |
2540708 | 2540708 | 2020-12-01 | US | Virginia | Craig | 51045 | 90 | 1 | 0 | 89 | 37.48133648 | -80.21072274 | 2020-12-02 05:27:41 | Craig, Virginia, US |
1587477 | 1587477 | 2020-11-30 | US | Virginia | Craig | 51045 | 90 | 1 | 0 | 89 | 37.48133648 | -80.21072274 | 2020-12-01 05:26:18 | Craig, Virginia, US |
3569880 | 3569880 | 2020-11-29 | US | Virginia | Craig | 51045 | 90 | 1 | 0 | 89 | 37.48133648 | -80.21072274 | 2020-11-30 05:26:13 | Craig, Virginia, US |
2938545 | 2938545 | 2020-11-28 | US | Virginia | Craig | 51045 | 90 | 1 | 0 | 89 | 37.48133648 | -80.21072274 | 2020-11-29 05:25:55 | Craig, Virginia, US |
2918495 | 2918495 | 2020-11-14 | US | Virginia | Covington | 51580 | 89 | 0 | 0 | 89 | 37.7824656 | -79.98631446 | 2020-11-15 05:26:53 | Covington, Virginia, US |
1180870 | 1180870 | 2020-10-22 | US | Virginia | Poquoson | 51735 | 91 | 2 | 0 | 89 | 37.14259351 | -76.35798148 | 2020-10-23 04:24:46 | Poquoson, Virginia, US |
2860148 | 2860148 | 2020-10-16 | US | Virginia | Charles City | 51036 | 94 | 5 | 0 | 89 | 37.35358063 | -77.05634116 | 2020-10-17 04:24:12 | Charles City, Virginia, US |
3805192 | 3805192 | 2020-10-05 | US | Virginia | Buena Vista | 51530 | 90 | 1 | 0 | 89 | 37.73484642 | -79.35296097 | 2020-10-06 04:23:33 | Buena Vista, Virginia, US |
1826082 | 1826082 | 2020-10-04 | US | Virginia | Buena Vista | 51530 | 90 | 1 | 0 | 89 | 37.73484642 | -79.35296097 | 2020-10-05 04:23:33 | Buena Vista, Virginia, US |
2585308 | 2585308 | 2020-09-27 | US | Virginia | Giles | 51071 | 89 | 0 | 0 | 89 | 37.31234791 | -80.70636931 | 2020-09-28 04:23:00 | Giles, Virginia, US |
2617360 | 2617360 | 2020-09-26 | US | Virginia | Giles | 51071 | 89 | 0 | 0 | 89 | 37.31234791 | -80.70636931 | 2020-09-27 04:23:00 | Giles, Virginia, US |
2174945 | 2174945 | 2020-09-09 | US | Virginia | Surry | 51181 | 92 | 3 | 0 | 89 | 37.11781893 | -76.88450012 | 2020-09-10 04:29:01 | Surry, Virginia, US |
3164980 | 3164980 | 2020-09-06 | US | Virginia | Nelson | 51125 | 89 | 0 | 0 | 89 | 37.78790447 | -78.88498513 | 2020-09-07 04:28:30 | Nelson, Virginia, US |
1357680 | 1357680 | 2020-09-03 | US | Virginia | Northumberland | 51133 | 94 | 5 | 0 | 89 | 37.89202088 | -76.41949732 | 2020-09-04 04:28:26 | Northumberland, Virginia, US |
1108904 | 1108904 | 2020-09-02 | US | Virginia | Madison | 51113 | 91 | 2 | 0 | 89 | 38.41531222 | -78.28220331 | 2020-09-03 04:28:22 | Madison, Virginia, US |
2063233 | 2063233 | 2020-09-01 | US | Virginia | Madison | 51113 | 91 | 2 | 0 | 89 | 38.41531222 | -78.28220331 | 2020-09-02 04:28:25 | Madison, Virginia, US |
197418 | 197418 | 2020-08-31 | US | Virginia | Madison | 51113 | 91 | 2 | 0 | 89 | 38.41531222 | -78.28220331 | 2020-09-01 04:28:31 | Madison, Virginia, US |
3935373 | 3935373 | 2020-08-30 | US | Virginia | Madison | 51113 | 91 | 2 | 0 | 89 | 38.41531222 | -78.28220331 | 2020-08-31 04:28:27 | Madison, Virginia, US |
1482832 | 1482832 | 2020-08-21 | US | Virginia | Amelia | 51007 | 91 | 2 | 0 | 89 | 37.34081025 | -77.98584649 | 2020-08-22 04:27:49 | Amelia, Virginia, US |
1482859 | 1482859 | 2020-08-21 | US | Virginia | Cumberland | 51049 | 89 | 0 | 0 | 89 | 37.51328851 | -78.24398086 | 2020-08-22 04:27:49 | Cumberland, Virginia, US |
3534722 | 3534722 | 2020-08-12 | US | Virginia | Appomattox | 51011 | 89 | 0 | 0 | 89 | 37.37569884 | -78.81340003 | 2020-08-13 04:29:15 | Appomattox, Virginia, US |
3534781 | 3534781 | 2020-08-12 | US | Virginia | King William | 51101 | 91 | 2 | 0 | 89 | 37.70965316 | -77.09384941 | 2020-08-13 04:29:15 | King William, Virginia, US |
3611279 | 3611279 | 2020-08-06 | US | Virginia | Russell | 51167 | 91 | 2 | 0 | 89 | 36.93028320000001 | -82.10095486 | 2020-08-07 04:35:11 | Russell, Virginia, US |
176407 | 176407 | 2020-07-27 | US | Virginia | Smyth | 51173 | 91 | 2 | 0 | 89 | 36.84455636 | -81.53344948 | 2020-07-28 04:58:43 | Smyth, Virginia, US |
324588 | 324588 | 2020-07-20 | US | Virginia | Franklin City | 51620 | 93 | 4 | 0 | 89 | 36.6831435 | -76.93859681 | 2020-07-21 04:38:46 | Franklin City, Virginia, US |
325649 | 325649 | 2020-07-20 | US | Virginia | New Kent | 51127 | 90 | 1 | 0 | 89 | 37.50694406 | -76.99828634 | 2020-07-21 04:38:46 | New Kent, Virginia, US |
2156425 | 2156425 | 2020-07-14 | US | Virginia | Grayson | 51077 | 93 | 4 | 0 | 89 | 36.65677234 | -81.23215889 | 2020-07-15 04:34:39 | Grayson, Virginia, US |
3434938 | 3434938 | 2020-07-11 | US | Virginia | Powhatan | 51145 | 91 | 2 | 0 | 89 | 37.55016038 | -77.91267882 | 2020-07-12 04:34:30 | Powhatan, Virginia, US |
2220430 | 2220430 | 2020-07-08 | US | Virginia | Grayson | 51077 | 91 | 2 | 0 | 89 | 36.65677234 | -81.23215889 | 2020-07-09 04:34:23 | Grayson, Virginia, US |
885041 | 885041 | 2020-07-07 | US | Virginia | Grayson | 51077 | 91 | 2 | 0 | 89 | 36.65677234 | -81.23215889 | 2020-07-08 05:33:48 | Grayson, Virginia, US |
2231920 | 2231920 | 2020-07-03 | US | Virginia | Danville | 51590 | 91 | 2 | 0 | 89 | 36.58022376 | -79.40395668 | 2020-07-04 04:33:51 | Danville, Virginia, US |
2234205 | 2234205 | 2020-07-03 | US | Virginia | Waynesboro | 51820 | 89 | 0 | 0 | 89 | 38.06451466 | -78.90293905 | 2020-07-04 04:33:51 | Waynesboro, Virginia, US |
2434904 | 2434904 | 2020-06-20 | US | Virginia | Brunswick | 51025 | 90 | 1 | 0 | 89 | 36.76366949 | -77.8593436 | 2020-06-21 04:33:19 | Brunswick, Virginia, US |
1688485 | 1688485 | 2020-06-19 | US | Virginia | Brunswick | 51025 | 90 | 1 | 0 | 89 | 36.76366949 | -77.8593436 | 2020-06-20 04:33:19 | Brunswick, Virginia, US |
1193997 | 1193997 | 2020-06-17 | US | Virginia | King George | 51099 | 93 | 4 | 0 | 89 | 38.26818502 | -77.15852768 | 2020-06-18 04:33:18 | King George, Virginia, US |
284047 | 284047 | 2020-06-15 | US | Virginia | Bedford | 51019 | 91 | 2 | 0 | 89 | 37.3080028 | -79.5281964 | 2020-06-16 04:33:09 | Bedford, Virginia, US |
1834003 | 1834003 | 2020-06-14 | US | Virginia | Bedford | 51019 | 91 | 2 | 0 | 89 | 37.3080028 | -79.5281964 | 2020-06-15 03:33:14 | Bedford, Virginia, US |
3058055 | 3058055 | 2020-06-13 | US | Virginia | Bedford | 51019 | 91 | 2 | 0 | 89 | 37.3080028 | -79.5281964 | 2020-06-14 03:33:15 | Bedford, Virginia, US |
3058731 | 3058731 | 2020-06-13 | US | Virginia | Emporia | 51595 | 95 | 6 | 0 | 89 | 36.69455571 | -77.53406129 | 2020-06-14 03:33:15 | Emporia, Virginia, US |
1270778 | 1270778 | 2020-06-11 | US | Virginia | Colonial Heights | 51570 | 106 | 17 | 0 | 89 | 37.26420587 | -77.39609676 | 2020-06-12 05:09:52 | Colonial Heights, Virginia, US |
2861223 | 2861223 | 2020-06-10 | US | Virginia | Colonial Heights | 51570 | 106 | 17 | 0 | 89 | 37.26420587 | -77.39609676 | 2020-06-11 03:33:41 | Colonial Heights, Virginia, US |
1208401 | 1208401 | 2020-06-09 | US | Virginia | Fluvanna | 51065 | 95 | 6 | 0 | 89 | 37.84157909 | -78.27715475 | 2020-06-10 04:07:00 | Fluvanna, Virginia, US |
214830 | 214830 | 2020-06-08 | US | Virginia | Fluvanna | 51065 | 95 | 6 | 0 | 89 | 37.84157909 | -78.27715475 | 2020-06-09 03:33:03 | Fluvanna, Virginia, US |
1787582 | 1787582 | 2020-05-29 | US | Virginia | Carroll | 51035 | 90 | 1 | 0 | 89 | 36.73066666 | -80.73455942 | 2020-05-30 02:32:48 | Carroll, Virginia, US |
1788199 | 1788199 | 2020-05-29 | US | Virginia | Goochland | 51075 | 95 | 6 | 0 | 89 | 37.71714806 | -77.90381514 | 2020-05-30 02:32:48 | Goochland, Virginia, US |
2546286 | 2546286 | 2020-05-27 | US | Virginia | Henry | 51089 | 92 | 3 | 0 | 89 | 36.68542395 | -79.87634026 | 2020-05-28 02:32:31 | Henry, Virginia, US |
2547408 | 2547408 | 2020-05-27 | US | Virginia | Roanoke | 51161 | 96 | 7 | 0 | 89 | 37.26865804 | -80.06396753 | 2020-05-28 02:32:31 | Roanoke, Virginia, US |
1040372 | 1040372 | 2020-05-26 | US | Virginia | Roanoke | 51161 | 96 | 7 | 0 | 89 | 37.26865804 | -80.06396753 | 2020-05-27 02:32:31 | Roanoke, Virginia, US |
872589 | 872589 | 2020-05-24 | US | Virginia | Augusta | 51015 | 90 | 1 | 0 | 89 | 38.16404586 | -79.12461614 | 2020-05-25 02:32:44 | Augusta, Virginia, US |
1827395 | 1827395 | 2020-05-16 | US | Virginia | Fredericksburg | 51630 | 89 | 0 | 0 | 89 | 38.2977863 | -77.4922454 | 2020-05-17 02:32:32 | Fredericksburg, Virginia, US |
270636 | 270636 | 2020-04-28 | US | Virginia | Page | 51139 | 89 | 0 | 0 | 89 | 38.61807452 | -78.48797204 | 2020-04-29 02:32:29 | Page, Virginia, US |
3588010 | 3588010 | 2020-04-27 | US | Virginia | Mecklenburg | 51117 | 98 | 9 | 0 | 89 | 36.67882005 | -78.36131056 | 2020-04-28 02:30:51 | Mecklenburg, Virginia, US |
3591697 | 3591697 | 2020-04-26 | US | Virginia | Richmond | 51159 | 89 | 0 | 0 | 89 | 37.937575 | -76.72920628 | 2020-04-27 02:30:52 | Richmond, Virginia, US |
3501075 | 3501075 | 2020-04-25 | US | Virginia | Isle of Wight | 51093 | 91 | 2 | 0 | 89 | 36.90579348 | -76.70842863 | 2020-04-26 02:30:51 | Isle of Wight, Virginia, US |
1456900 | 1456900 | 2020-04-24 | US | Virginia | Culpeper | 51047 | 90 | 1 | 0 | 89 | 38.48199985 | -77.95630870000002 | 2020-04-25 06:30:53 | Culpeper, Virginia, US |
1457481 | 1457481 | 2020-04-24 | US | Virginia | Isle of Wight | 51093 | 91 | 2 | 0 | 89 | 36.90579348 | -76.70842863 | 2020-04-25 06:30:53 | Isle of Wight, Virginia, US |
2523074 | 2523074 | 2020-04-23 | US | Virginia | Isle of Wight | 51093 | 91 | 2 | 0 | 89 | 36.90579348 | -76.70842863 | 2020-04-24 03:30:50 | Isle of Wight, Virginia, US |
1198400 | 1198400 | 2020-04-22 | US | Virginia | Portsmouth | 51740 | 93 | 4 | 0 | 89 | 36.85914825 | -76.35971629 | 2020-04-22 23:30:53 | Portsmouth, Virginia, US |
2471532 | 2471532 | 2020-04-20 | US | Virginia | Hampton | 51650 | 90 | 1 | 0 | 89 | 37.03513786 | -76.35879121 | 2020-04-20 23:36:47 | Hampton, Virginia, US |
3738478 | 3738478 | 2020-04-03 | US | Virginia | Chesterfield | 51041 | 89 | 0 | 0 | 89 | 37.37373208 | -77.58680140000001 | 2020-04-03 22:46:37 | Chesterfield, Virginia, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);