daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
56,193 rows where province_or_state = "West Virginia" sorted by latitude 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2022-10-19 | US | West Virginia | Hancock | 54029 | 7956 | 149 | 0 | 40.51943859 | -80.57461608 | 2022-10-20 04:22:59 | Hancock, West Virginia, US | |
2022-10-19 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2021-07-31 23:21:38 | Unassigned, West Virginia, US | |
2020-12-25 | US | West Virginia | Hancock | 54029 | 1686 | 33 | 0 | 1653 | 40.51943859 | -80.57461608 | 2020-12-26 05:22:28 | Hancock, West Virginia, US |
2020-12-25 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2020-12-26 05:22:28 | Unassigned, West Virginia, US |
2020-08-19 | US | West Virginia | Hancock | 54029 | 115 | 0 | 0 | 115 | 40.51943859 | -80.57461608 | 2020-08-20 04:27:43 | Hancock, West Virginia, US |
2020-08-19 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2020-08-20 04:27:43 | Unassigned, West Virginia, US |
2020-10-29 | US | West Virginia | Hancock | 54029 | 224 | 1 | 0 | 223 | 40.51943859 | -80.57461608 | 2020-10-30 04:24:49 | Hancock, West Virginia, US |
2020-10-29 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2020-10-30 04:24:49 | Unassigned, West Virginia, US |
2020-06-08 | US | West Virginia | Hancock | 54029 | 20 | 0 | 0 | 20 | 40.51943859 | -80.57461608 | 2020-06-09 03:33:03 | Hancock, West Virginia, US |
2020-06-08 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2020-06-09 03:33:03 | Unassigned, West Virginia, US |
2022-12-26 | US | West Virginia | Hancock | 54029 | 8177 | 149 | 0 | 40.51943859 | -80.57461608 | 2022-12-27 04:21:07 | Hancock, West Virginia, US | |
2022-12-26 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2021-07-31 23:21:38 | Unassigned, West Virginia, US | |
2022-05-09 | US | West Virginia | Hancock | 54029 | 6783 | 142 | 0 | 40.51943859 | -80.57461608 | 2022-05-10 04:20:50 | Hancock, West Virginia, US | |
2022-05-09 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2021-07-31 23:21:38 | Unassigned, West Virginia, US | |
2020-04-30 | US | West Virginia | Hancock | 54029 | 10 | 0 | 0 | 10 | 40.51943859 | -80.57461608 | 2020-05-01 02:32:28 | Hancock, West Virginia, US |
2020-04-30 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2020-05-01 02:32:28 | Unassigned, West Virginia, US |
2022-05-31 | US | West Virginia | Hancock | 54029 | 6947 | 142 | 0 | 40.51943859 | -80.57461608 | 2022-06-01 04:20:55 | Hancock, West Virginia, US | |
2022-05-31 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2021-07-31 23:21:38 | Unassigned, West Virginia, US | |
2022-02-11 | US | West Virginia | Hancock | 54029 | 6526 | 131 | 0 | 40.51943859 | -80.57461608 | 2022-02-12 04:21:06 | Hancock, West Virginia, US | |
2022-02-11 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2021-07-31 23:21:38 | Unassigned, West Virginia, US | |
2021-01-18 | US | West Virginia | Hancock | 54029 | 2318 | 75 | 0 | 2243 | 40.51943859 | -80.57461608 | 2021-01-19 05:22:15 | Hancock, West Virginia, US |
2021-01-18 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2021-01-19 05:22:15 | Unassigned, West Virginia, US |
2021-04-02 | US | West Virginia | Hancock | 54029 | 2634 | 97 | 0 | 40.51943859 | -80.57461608 | 2021-04-03 04:20:44 | Hancock, West Virginia, US | |
2021-04-02 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2021-04-03 04:20:44 | Unassigned, West Virginia, US | |
2021-08-17 | US | West Virginia | Hancock | 54029 | 2940 | 90 | 0 | 40.51943859 | -80.57461608 | 2021-08-18 04:21:35 | Hancock, West Virginia, US | |
2021-08-17 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2021-07-31 23:21:38 | Unassigned, West Virginia, US | |
2021-09-04 | US | West Virginia | Hancock | 54029 | 3119 | 91 | 0 | 40.51943859 | -80.57461608 | 2021-09-05 04:21:33 | Hancock, West Virginia, US | |
2021-09-04 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2021-07-31 23:21:38 | Unassigned, West Virginia, US | |
2022-09-08 | US | West Virginia | Hancock | 54029 | 7751 | 147 | 0 | 40.51943859 | -80.57461608 | 2022-09-09 04:21:11 | Hancock, West Virginia, US | |
2022-09-08 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2021-07-31 23:21:38 | Unassigned, West Virginia, US | |
2022-12-10 | US | West Virginia | Hancock | 54029 | 8142 | 149 | 0 | 40.51943859 | -80.57461608 | 2022-12-11 04:20:50 | Hancock, West Virginia, US | |
2022-12-10 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2021-07-31 23:21:38 | Unassigned, West Virginia, US | |
2022-03-15 | US | West Virginia | Hancock | 54029 | 6666 | 140 | 0 | 40.51943859 | -80.57461608 | 2022-03-16 04:20:50 | Hancock, West Virginia, US | |
2022-03-15 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2021-07-31 23:21:38 | Unassigned, West Virginia, US | |
2020-05-21 | US | West Virginia | Hancock | 54029 | 13 | 0 | 0 | 13 | 40.51943859 | -80.57461608 | 2020-05-22 02:36:51 | Hancock, West Virginia, US |
2020-05-21 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2020-05-22 02:36:51 | Unassigned, West Virginia, US |
2020-04-28 | US | West Virginia | Hancock | 54029 | 8 | 0 | 0 | 8 | 40.51943859 | -80.57461608 | 2020-04-29 02:32:29 | Hancock, West Virginia, US |
2020-04-28 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2020-04-29 02:32:29 | Unassigned, West Virginia, US |
2020-11-10 | US | West Virginia | Hancock | 54029 | 296 | 2 | 0 | 294 | 40.51943859 | -80.57461608 | 2020-11-11 05:25:30 | Hancock, West Virginia, US |
2020-11-10 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2020-11-11 05:25:30 | Unassigned, West Virginia, US |
2021-11-03 | US | West Virginia | Hancock | 54029 | 4292 | 116 | 0 | 40.51943859 | -80.57461608 | 2021-11-04 04:22:20 | Hancock, West Virginia, US | |
2021-11-03 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2021-07-31 23:21:38 | Unassigned, West Virginia, US | |
2021-02-24 | US | West Virginia | Hancock | 54029 | 2577 | 86 | 0 | 2491 | 40.51943859 | -80.57461608 | 2021-02-25 05:24:57 | Hancock, West Virginia, US |
2021-02-24 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2021-02-25 05:24:57 | Unassigned, West Virginia, US |
2020-06-15 | US | West Virginia | Hancock | 54029 | 20 | 0 | 0 | 20 | 40.51943859 | -80.57461608 | 2020-06-16 04:33:09 | Hancock, West Virginia, US |
2020-06-15 | US | West Virginia | Unassigned | 90054 | 1 | 0 | 0 | 1 | 40.51943859 | -82.42287994 | 2020-06-16 04:33:09 | Unassigned, West Virginia, US |
2021-10-31 | US | West Virginia | Hancock | 54029 | 4253 | 115 | 0 | 40.51943859 | -80.57461608 | 2021-11-01 04:22:01 | Hancock, West Virginia, US | |
2021-10-31 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2021-07-31 23:21:38 | Unassigned, West Virginia, US | |
2022-11-15 | US | West Virginia | Hancock | 54029 | 8041 | 149 | 0 | 40.51943859 | -80.57461608 | 2022-11-16 04:21:09 | Hancock, West Virginia, US | |
2022-11-15 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2021-07-31 23:21:38 | Unassigned, West Virginia, US | |
2021-07-15 | US | West Virginia | Hancock | 54029 | 2847 | 89 | 0 | 40.51943859 | -80.57461608 | 2021-07-16 04:21:22 | Hancock, West Virginia, US | |
2021-07-15 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2021-07-16 04:21:22 | Unassigned, West Virginia, US | |
2020-07-01 | US | West Virginia | Hancock | 54029 | 23 | 0 | 0 | 23 | 40.51943859 | -80.57461608 | 2020-07-02 04:33:46 | Hancock, West Virginia, US |
2020-07-01 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2020-07-02 04:33:46 | Unassigned, West Virginia, US |
2022-04-16 | US | West Virginia | Hancock | 54029 | 6704 | 142 | 0 | 40.51943859 | -80.57461608 | 2022-04-17 04:20:59 | Hancock, West Virginia, US | |
2022-04-16 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2021-07-31 23:21:38 | Unassigned, West Virginia, US | |
2022-12-13 | US | West Virginia | Hancock | 54029 | 8148 | 149 | 0 | 40.51943859 | -80.57461608 | 2022-12-14 04:21:04 | Hancock, West Virginia, US | |
2022-12-13 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2021-07-31 23:21:38 | Unassigned, West Virginia, US | |
2022-11-13 | US | West Virginia | Hancock | 54029 | 8027 | 149 | 0 | 40.51943859 | -80.57461608 | 2022-11-14 04:21:09 | Hancock, West Virginia, US | |
2022-11-13 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2021-07-31 23:21:38 | Unassigned, West Virginia, US | |
2022-02-12 | US | West Virginia | Hancock | 54029 | 6530 | 131 | 0 | 40.51943859 | -80.57461608 | 2022-02-13 04:21:00 | Hancock, West Virginia, US | |
2022-02-12 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2021-07-31 23:21:38 | Unassigned, West Virginia, US | |
2022-10-30 | US | West Virginia | Hancock | 54029 | 7964 | 149 | 0 | 40.51943859 | -80.57461608 | 2022-10-31 04:21:36 | Hancock, West Virginia, US | |
2022-10-30 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2021-07-31 23:21:38 | Unassigned, West Virginia, US | |
2020-07-20 | US | West Virginia | Hancock | 54029 | 62 | 0 | 0 | 62 | 40.51943859 | -80.57461608 | 2020-07-21 04:38:46 | Hancock, West Virginia, US |
2020-07-20 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2020-07-21 04:38:46 | Unassigned, West Virginia, US |
2022-12-27 | US | West Virginia | Hancock | 54029 | 8192 | 149 | 0 | 40.51943859 | -80.57461608 | 2022-12-28 04:21:04 | Hancock, West Virginia, US | |
2022-12-27 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2021-07-31 23:21:38 | Unassigned, West Virginia, US | |
2021-08-04 | US | West Virginia | Hancock | 54029 | 2886 | 90 | 0 | 40.51943859 | -80.57461608 | 2021-08-05 04:21:51 | Hancock, West Virginia, US | |
2021-08-04 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2021-07-31 23:21:38 | Unassigned, West Virginia, US | |
2022-03-18 | US | West Virginia | Hancock | 54029 | 6674 | 140 | 0 | 40.51943859 | -80.57461608 | 2022-03-19 04:20:47 | Hancock, West Virginia, US | |
2022-03-18 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2021-07-31 23:21:38 | Unassigned, West Virginia, US | |
2021-02-03 | US | West Virginia | Hancock | 54029 | 2501 | 82 | 0 | 2419 | 40.51943859 | -80.57461608 | 2021-02-04 05:22:26 | Hancock, West Virginia, US |
2021-02-03 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2021-02-04 05:22:26 | Unassigned, West Virginia, US |
2020-09-14 | US | West Virginia | Hancock | 54029 | 137 | 0 | 0 | 137 | 40.51943859 | -80.57461608 | 2020-09-15 03:22:50 | Hancock, West Virginia, US |
2020-09-14 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2020-09-15 03:22:50 | Unassigned, West Virginia, US |
2022-12-14 | US | West Virginia | Hancock | 54029 | 8151 | 149 | 0 | 40.51943859 | -80.57461608 | 2022-12-15 04:20:58 | Hancock, West Virginia, US | |
2022-12-14 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2021-07-31 23:21:38 | Unassigned, West Virginia, US | |
2021-03-11 | US | West Virginia | Hancock | 54029 | 2595 | 86 | 0 | 40.51943859 | -80.57461608 | 2021-03-12 05:26:50 | Hancock, West Virginia, US | |
2021-03-11 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2021-03-12 05:26:50 | Unassigned, West Virginia, US | |
2022-03-11 | US | West Virginia | Hancock | 54029 | 6660 | 140 | 0 | 40.51943859 | -80.57461608 | 2022-03-12 04:20:50 | Hancock, West Virginia, US | |
2022-03-11 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2021-07-31 23:21:38 | Unassigned, West Virginia, US | |
2022-05-07 | US | West Virginia | Hancock | 54029 | 6758 | 142 | 0 | 40.51943859 | -80.57461608 | 2022-05-08 04:20:49 | Hancock, West Virginia, US | |
2022-05-07 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2021-07-31 23:21:38 | Unassigned, West Virginia, US | |
2020-07-16 | US | West Virginia | Hancock | 54029 | 50 | 0 | 0 | 50 | 40.51943859 | -80.57461608 | 2020-07-17 04:34:50 | Hancock, West Virginia, US |
2020-07-16 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2020-07-17 04:34:50 | Unassigned, West Virginia, US |
2020-08-08 | US | West Virginia | Hancock | 54029 | 111 | 0 | 0 | 111 | 40.51943859 | -80.57461608 | 2020-08-09 04:34:54 | Hancock, West Virginia, US |
2020-08-08 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2020-08-09 04:34:54 | Unassigned, West Virginia, US |
2022-09-13 | US | West Virginia | Hancock | 54029 | 7814 | 147 | 0 | 40.51943859 | -80.57461608 | 2022-09-14 04:20:44 | Hancock, West Virginia, US | |
2022-09-13 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2021-07-31 23:21:38 | Unassigned, West Virginia, US | |
2020-11-06 | US | West Virginia | Hancock | 54029 | 261 | 1 | 0 | 260 | 40.51943859 | -80.57461608 | 2020-11-07 05:24:52 | Hancock, West Virginia, US |
2020-11-06 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2020-11-07 05:24:52 | Unassigned, West Virginia, US |
2021-04-30 | US | West Virginia | Hancock | 54029 | 2753 | 88 | 0 | 40.51943859 | -80.57461608 | 2021-05-01 04:20:47 | Hancock, West Virginia, US | |
2021-04-30 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2021-05-01 04:20:47 | Unassigned, West Virginia, US | |
2022-09-23 | US | West Virginia | Hancock | 54029 | 7870 | 148 | 0 | 40.51943859 | -80.57461608 | 2022-09-24 04:21:40 | Hancock, West Virginia, US | |
2022-09-23 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2021-07-31 23:21:38 | Unassigned, West Virginia, US | |
2021-04-04 | US | West Virginia | Hancock | 54029 | 2643 | 97 | 0 | 40.51943859 | -80.57461608 | 2021-04-05 04:20:35 | Hancock, West Virginia, US | |
2021-04-04 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2021-04-05 04:20:35 | Unassigned, West Virginia, US | |
2020-11-27 | US | West Virginia | Hancock | 54029 | 640 | 4 | 0 | 636 | 40.51943859 | -80.57461608 | 2020-11-28 05:25:50 | Hancock, West Virginia, US |
2020-11-27 | US | West Virginia | Unassigned | 90054 | 0 | 0 | 0 | 0 | 40.51943859 | -82.42287994 | 2020-11-28 05:25:50 | Unassigned, West Virginia, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;