johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
56,193 rows where province_or_state = "West Virginia" sorted by latitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude ▼ | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3826 | 3826 | 2021-12-02 | US | West Virginia | McDowell | 54047 | 3189 | 54 | 0 | 37.38002939 | -81.65083669 | 2021-12-03 04:23:05 | McDowell, West Virginia, US | |
7841 | 7841 | 2021-10-28 | US | West Virginia | McDowell | 54047 | 2923 | 50 | 0 | 37.38002939 | -81.65083669 | 2021-10-29 04:22:03 | McDowell, West Virginia, US | |
11813 | 11813 | 2020-10-25 | US | West Virginia | McDowell | 54047 | 114 | 1 | 0 | 113 | 37.38002939 | -81.65083669 | 2020-10-26 04:25:02 | McDowell, West Virginia, US |
15826 | 15826 | 2021-01-26 | US | West Virginia | McDowell | 54047 | 1198 | 11 | 0 | 1187 | 37.38002939 | -81.65083669 | 2021-01-27 05:23:41 | McDowell, West Virginia, US |
19848 | 19848 | 2021-09-18 | US | West Virginia | McDowell | 54047 | 2277 | 28 | 0 | 37.38002939 | -81.65083669 | 2021-09-19 04:21:34 | McDowell, West Virginia, US | |
23859 | 23859 | 2021-05-28 | US | West Virginia | McDowell | 54047 | 1588 | 25 | 0 | 37.38002939 | -81.65083669 | 2021-05-29 04:20:41 | McDowell, West Virginia, US | |
27897 | 27897 | 2022-03-20 | US | West Virginia | McDowell | 54047 | 5568 | 67 | 0 | 37.38002939 | -81.65083669 | 2022-03-21 04:20:50 | McDowell, West Virginia, US | |
31912 | 31912 | 2021-11-11 | US | West Virginia | McDowell | 54047 | 3016 | 50 | 0 | 37.38002939 | -81.65083669 | 2021-11-12 04:22:01 | McDowell, West Virginia, US | |
35908 | 35908 | 2021-08-25 | US | West Virginia | McDowell | 54047 | 1847 | 27 | 0 | 37.38002939 | -81.65083669 | 2021-08-26 04:21:28 | McDowell, West Virginia, US | |
39918 | 39918 | 2021-04-12 | US | West Virginia | McDowell | 54047 | 1455 | 22 | 0 | 37.38002939 | -81.65083669 | 2021-04-13 04:20:37 | McDowell, West Virginia, US | |
41921 | 41921 | 2020-04-13 | US | West Virginia | McDowell | 54047 | 5 | 0 | 0 | 5 | 37.38002939 | -81.65083669 | 2020-04-13 23:07:54 | McDowell, West Virginia, US |
47204 | 47204 | 2021-11-02 | US | West Virginia | McDowell | 54047 | 2945 | 50 | 0 | 37.38002939 | -81.65083669 | 2021-11-03 06:22:09 | McDowell, West Virginia, US | |
48995 | 48995 | 2020-04-17 | US | West Virginia | McDowell | 54047 | 6 | 0 | 0 | 6 | 37.38002939 | -81.65083669 | 2020-04-17 23:30:52 | McDowell, West Virginia, US |
54280 | 54280 | 2021-05-29 | US | West Virginia | McDowell | 54047 | 1588 | 25 | 0 | 37.38002939 | -81.65083669 | 2021-05-30 04:20:55 | McDowell, West Virginia, US | |
58291 | 58291 | 2021-03-07 | US | West Virginia | McDowell | 54047 | 1379 | 20 | 0 | 37.38002939 | -81.65083669 | 2021-03-08 05:24:48 | McDowell, West Virginia, US | |
60384 | 60384 | 2020-07-23 | US | West Virginia | McDowell | 54047 | 12 | 0 | 0 | 12 | 37.38002939 | -81.65083669 | 2020-07-24 05:30:40 | McDowell, West Virginia, US |
66562 | 66562 | 2022-11-12 | US | West Virginia | McDowell | 54047 | 7108 | 83 | 0 | 37.38002939 | -81.65083669 | 2022-11-13 04:21:14 | McDowell, West Virginia, US | |
70553 | 70553 | 2021-09-01 | US | West Virginia | McDowell | 54047 | 1951 | 28 | 0 | 37.38002939 | -81.65083669 | 2021-09-02 04:21:15 | McDowell, West Virginia, US | |
74587 | 74587 | 2022-02-07 | US | West Virginia | McDowell | 54047 | 4842 | 60 | 0 | 37.38002939 | -81.65083669 | 2022-02-08 04:21:15 | McDowell, West Virginia, US | |
78573 | 78573 | 2020-12-03 | US | West Virginia | McDowell | 54047 | 641 | 2 | 0 | 639 | 37.38002939 | -81.65083669 | 2020-12-04 05:27:27 | McDowell, West Virginia, US |
82567 | 82567 | 2020-10-14 | US | West Virginia | McDowell | 54047 | 99 | 1 | 0 | 98 | 37.38002939 | -81.65083669 | 2020-10-15 04:24:28 | McDowell, West Virginia, US |
86583 | 86583 | 2021-05-25 | US | West Virginia | McDowell | 54047 | 1586 | 25 | 0 | 37.38002939 | -81.65083669 | 2021-05-26 04:20:35 | McDowell, West Virginia, US | |
90621 | 90621 | 2021-11-09 | US | West Virginia | McDowell | 54047 | 2996 | 50 | 0 | 37.38002939 | -81.65083669 | 2021-11-10 04:21:38 | McDowell, West Virginia, US | |
94639 | 94639 | 2022-07-23 | US | West Virginia | McDowell | 54047 | 6233 | 77 | 0 | 37.38002939 | -81.65083669 | 2022-07-24 04:20:47 | McDowell, West Virginia, US | |
96710 | 96710 | 2020-08-04 | US | West Virginia | McDowell | 54047 | 46 | 0 | 0 | 46 | 37.38002939 | -81.65083669 | 2020-08-05 04:34:43 | McDowell, West Virginia, US |
102822 | 102822 | 2022-01-14 | US | West Virginia | McDowell | 54047 | 3818 | 56 | 0 | 37.38002939 | -81.65083669 | 2022-01-15 04:21:07 | McDowell, West Virginia, US | |
106818 | 106818 | 2021-08-15 | US | West Virginia | McDowell | 54047 | 1732 | 27 | 0 | 37.38002939 | -81.65083669 | 2021-08-16 04:21:31 | McDowell, West Virginia, US | |
110942 | 110942 | 2021-06-19 | US | West Virginia | McDowell | 54047 | 1612 | 26 | 0 | 37.38002939 | -81.65083669 | 2021-06-20 04:21:48 | McDowell, West Virginia, US | |
112858 | 112858 | 2020-05-08 | US | West Virginia | McDowell | 54047 | 6 | 0 | 0 | 6 | 37.38002939 | -81.65083669 | 2020-05-09 02:32:35 | McDowell, West Virginia, US |
118249 | 118249 | 2022-09-06 | US | West Virginia | McDowell | 54047 | 6774 | 79 | 0 | 37.38002939 | -81.65083669 | 2022-09-07 04:20:59 | McDowell, West Virginia, US | |
120311 | 120311 | 2020-07-19 | US | West Virginia | McDowell | 54047 | 12 | 0 | 0 | 12 | 37.38002939 | -81.65083669 | 2020-07-20 05:34:40 | McDowell, West Virginia, US |
126188 | 126188 | 2020-11-18 | US | West Virginia | McDowell | 54047 | 515 | 1 | 0 | 514 | 37.38002939 | -81.65083669 | 2020-11-19 05:25:23 | McDowell, West Virginia, US |
130229 | 130229 | 2022-01-09 | US | West Virginia | McDowell | 54047 | 3688 | 56 | 0 | 37.38002939 | -81.65083669 | 2022-01-10 04:22:07 | McDowell, West Virginia, US | |
134250 | 134250 | 2022-10-04 | US | West Virginia | McDowell | 54047 | 7004 | 82 | 0 | 37.38002939 | -81.65083669 | 2022-10-05 04:23:06 | McDowell, West Virginia, US | |
136102 | 136102 | 2020-04-29 | US | West Virginia | McDowell | 54047 | 6 | 0 | 0 | 6 | 37.38002939 | -81.65083669 | 2020-04-30 02:32:27 | McDowell, West Virginia, US |
141467 | 141467 | 2021-12-04 | US | West Virginia | McDowell | 54047 | 3234 | 54 | 0 | 37.38002939 | -81.65083669 | 2021-12-05 04:22:25 | McDowell, West Virginia, US | |
145485 | 145485 | 2022-07-09 | US | West Virginia | McDowell | 54047 | 6019 | 77 | 0 | 37.38002939 | -81.65083669 | 2022-07-10 04:20:54 | McDowell, West Virginia, US | |
149440 | 149440 | 2020-08-15 | US | West Virginia | McDowell | 54047 | 66 | 0 | 0 | 66 | 37.38002939 | -81.65083669 | 2020-08-16 04:27:42 | McDowell, West Virginia, US |
153480 | 153480 | 2021-11-29 | US | West Virginia | McDowell | 54047 | 3158 | 53 | 0 | 37.38002939 | -81.65083669 | 2021-11-30 04:22:53 | McDowell, West Virginia, US | |
157467 | 157467 | 2021-01-08 | US | West Virginia | McDowell | 54047 | 1067 | 6 | 0 | 1061 | 37.38002939 | -81.65083669 | 2021-01-09 05:22:18 | McDowell, West Virginia, US |
161509 | 161509 | 2022-03-29 | US | West Virginia | McDowell | 54047 | 5592 | 71 | 0 | 37.38002939 | -81.65083669 | 2022-03-30 04:20:45 | McDowell, West Virginia, US | |
165524 | 165524 | 2021-11-19 | US | West Virginia | McDowell | 54047 | 3077 | 52 | 0 | 37.38002939 | -81.65083669 | 2021-11-20 04:22:17 | McDowell, West Virginia, US | |
169542 | 169542 | 2022-06-21 | US | West Virginia | McDowell | 54047 | 5846 | 76 | 0 | 37.38002939 | -81.65083669 | 2022-06-22 04:20:54 | McDowell, West Virginia, US | |
173532 | 173532 | 2021-04-16 | US | West Virginia | McDowell | 54047 | 1467 | 22 | 0 | 37.38002939 | -81.65083669 | 2021-04-17 04:20:40 | McDowell, West Virginia, US | |
175624 | 175624 | 2020-07-27 | US | West Virginia | McDowell | 54047 | 15 | 0 | 0 | 15 | 37.38002939 | -81.65083669 | 2020-07-28 04:58:43 | McDowell, West Virginia, US |
181518 | 181518 | 2021-09-02 | US | West Virginia | McDowell | 54047 | 1975 | 28 | 0 | 37.38002939 | -81.65083669 | 2021-09-03 04:21:20 | McDowell, West Virginia, US | |
185526 | 185526 | 2021-02-21 | US | West Virginia | McDowell | 54047 | 1337 | 19 | 0 | 1318 | 37.38002939 | -81.65083669 | 2021-02-22 05:24:21 | McDowell, West Virginia, US |
189567 | 189567 | 2022-02-13 | US | West Virginia | McDowell | 54047 | 5075 | 60 | 0 | 37.38002939 | -81.65083669 | 2022-02-14 04:20:51 | McDowell, West Virginia, US | |
193553 | 193553 | 2021-01-11 | US | West Virginia | McDowell | 54047 | 1091 | 7 | 0 | 1084 | 37.38002939 | -81.65083669 | 2021-01-12 05:22:15 | McDowell, West Virginia, US |
197544 | 197544 | 2020-08-31 | US | West Virginia | McDowell | 54047 | 70 | 1 | 0 | 69 | 37.38002939 | -81.65083669 | 2020-09-01 04:28:31 | McDowell, West Virginia, US |
201759 | 201759 | 2022-10-19 | US | West Virginia | McDowell | 54047 | 7049 | 83 | 0 | 37.38002939 | -81.65083669 | 2022-10-20 04:22:59 | McDowell, West Virginia, US | |
205740 | 205740 | 2020-12-25 | US | West Virginia | McDowell | 54047 | 888 | 4 | 0 | 884 | 37.38002939 | -81.65083669 | 2020-12-26 05:22:28 | McDowell, West Virginia, US |
209726 | 209726 | 2020-08-19 | US | West Virginia | McDowell | 54047 | 67 | 0 | 0 | 67 | 37.38002939 | -81.65083669 | 2020-08-20 04:27:43 | McDowell, West Virginia, US |
213722 | 213722 | 2020-10-29 | US | West Virginia | McDowell | 54047 | 126 | 1 | 0 | 125 | 37.38002939 | -81.65083669 | 2020-10-30 04:24:49 | McDowell, West Virginia, US |
215697 | 215697 | 2020-06-08 | US | West Virginia | McDowell | 54047 | 6 | 0 | 0 | 6 | 37.38002939 | -81.65083669 | 2020-06-09 03:33:03 | McDowell, West Virginia, US |
221480 | 221480 | 2022-12-26 | US | West Virginia | McDowell | 54047 | 7160 | 85 | 0 | 37.38002939 | -81.65083669 | 2022-12-27 04:21:07 | McDowell, West Virginia, US | |
225492 | 225492 | 2022-05-09 | US | West Virginia | McDowell | 54047 | 5652 | 75 | 0 | 37.38002939 | -81.65083669 | 2022-05-10 04:20:50 | McDowell, West Virginia, US | |
227354 | 227354 | 2020-04-30 | US | West Virginia | McDowell | 54047 | 6 | 0 | 0 | 6 | 37.38002939 | -81.65083669 | 2020-05-01 02:32:28 | McDowell, West Virginia, US |
232724 | 232724 | 2022-05-31 | US | West Virginia | McDowell | 54047 | 5744 | 75 | 0 | 37.38002939 | -81.65083669 | 2022-06-01 04:20:55 | McDowell, West Virginia, US | |
236739 | 236739 | 2022-02-11 | US | West Virginia | McDowell | 54047 | 5000 | 60 | 0 | 37.38002939 | -81.65083669 | 2022-02-12 04:21:06 | McDowell, West Virginia, US | |
240726 | 240726 | 2021-01-18 | US | West Virginia | McDowell | 54047 | 1135 | 8 | 0 | 1127 | 37.38002939 | -81.65083669 | 2021-01-19 05:22:15 | McDowell, West Virginia, US |
244743 | 244743 | 2021-04-02 | US | West Virginia | McDowell | 54047 | 1420 | 22 | 0 | 37.38002939 | -81.65083669 | 2021-04-03 04:20:44 | McDowell, West Virginia, US | |
248761 | 248761 | 2021-08-17 | US | West Virginia | McDowell | 54047 | 1746 | 27 | 0 | 37.38002939 | -81.65083669 | 2021-08-18 04:21:35 | McDowell, West Virginia, US | |
252775 | 252775 | 2021-09-04 | US | West Virginia | McDowell | 54047 | 1992 | 28 | 0 | 37.38002939 | -81.65083669 | 2021-09-05 04:21:33 | McDowell, West Virginia, US | |
256811 | 256811 | 2022-09-08 | US | West Virginia | McDowell | 54047 | 6805 | 79 | 0 | 37.38002939 | -81.65083669 | 2022-09-09 04:21:11 | McDowell, West Virginia, US | |
260830 | 260830 | 2022-12-10 | US | West Virginia | McDowell | 54047 | 7146 | 84 | 0 | 37.38002939 | -81.65083669 | 2022-12-11 04:20:50 | McDowell, West Virginia, US | |
265029 | 265029 | 2022-03-15 | US | West Virginia | McDowell | 54047 | 5553 | 65 | 0 | 37.38002939 | -81.65083669 | 2022-03-16 04:20:50 | McDowell, West Virginia, US | |
266948 | 266948 | 2020-05-21 | US | West Virginia | McDowell | 54047 | 6 | 0 | 0 | 6 | 37.38002939 | -81.65083669 | 2020-05-22 02:36:51 | McDowell, West Virginia, US |
270318 | 270318 | 2020-04-28 | US | West Virginia | McDowell | 54047 | 6 | 0 | 0 | 6 | 37.38002939 | -81.65083669 | 2020-04-29 02:32:29 | McDowell, West Virginia, US |
275638 | 275638 | 2020-11-10 | US | West Virginia | McDowell | 54047 | 175 | 0 | 0 | 175 | 37.38002939 | -81.65083669 | 2020-11-11 05:25:30 | McDowell, West Virginia, US |
279679 | 279679 | 2021-11-03 | US | West Virginia | McDowell | 54047 | 2952 | 50 | 0 | 37.38002939 | -81.65083669 | 2021-11-04 04:22:20 | McDowell, West Virginia, US | |
283669 | 283669 | 2021-02-24 | US | West Virginia | McDowell | 54047 | 1340 | 20 | 0 | 1320 | 37.38002939 | -81.65083669 | 2021-02-25 05:24:57 | McDowell, West Virginia, US |
285660 | 285660 | 2020-06-15 | US | West Virginia | McDowell | 54047 | 6 | 0 | 0 | 6 | 37.38002939 | -81.65083669 | 2020-06-16 04:33:09 | McDowell, West Virginia, US |
291491 | 291491 | 2021-10-31 | US | West Virginia | McDowell | 54047 | 2944 | 50 | 0 | 37.38002939 | -81.65083669 | 2021-11-01 04:22:01 | McDowell, West Virginia, US | |
295513 | 295513 | 2022-11-15 | US | West Virginia | McDowell | 54047 | 7111 | 83 | 0 | 37.38002939 | -81.65083669 | 2022-11-16 04:21:09 | McDowell, West Virginia, US | |
299504 | 299504 | 2021-07-15 | US | West Virginia | McDowell | 54047 | 1639 | 26 | 0 | 37.38002939 | -81.65083669 | 2021-07-16 04:21:22 | McDowell, West Virginia, US | |
301515 | 301515 | 2020-07-01 | US | West Virginia | McDowell | 54047 | 6 | 0 | 0 | 6 | 37.38002939 | -81.65083669 | 2020-07-02 04:33:46 | McDowell, West Virginia, US |
307365 | 307365 | 2022-04-16 | US | West Virginia | McDowell | 54047 | 5610 | 73 | 0 | 37.38002939 | -81.65083669 | 2022-04-17 04:20:59 | McDowell, West Virginia, US | |
311385 | 311385 | 2022-12-13 | US | West Virginia | McDowell | 54047 | 7147 | 85 | 0 | 37.38002939 | -81.65083669 | 2022-12-14 04:21:04 | McDowell, West Virginia, US | |
315401 | 315401 | 2022-11-13 | US | West Virginia | McDowell | 54047 | 7108 | 83 | 0 | 37.38002939 | -81.65083669 | 2022-11-14 04:21:09 | McDowell, West Virginia, US | |
319413 | 319413 | 2022-02-12 | US | West Virginia | McDowell | 54047 | 5043 | 60 | 0 | 37.38002939 | -81.65083669 | 2022-02-13 04:21:00 | McDowell, West Virginia, US | |
323433 | 323433 | 2022-10-30 | US | West Virginia | McDowell | 54047 | 7083 | 83 | 0 | 37.38002939 | -81.65083669 | 2022-10-31 04:21:36 | McDowell, West Virginia, US | |
325448 | 325448 | 2020-07-20 | US | West Virginia | McDowell | 54047 | 12 | 0 | 0 | 12 | 37.38002939 | -81.65083669 | 2020-07-21 04:38:46 | McDowell, West Virginia, US |
331407 | 331407 | 2022-12-27 | US | West Virginia | McDowell | 54047 | 7186 | 85 | 0 | 37.38002939 | -81.65083669 | 2022-12-28 04:21:04 | McDowell, West Virginia, US | |
335398 | 335398 | 2021-08-04 | US | West Virginia | McDowell | 54047 | 1676 | 27 | 0 | 37.38002939 | -81.65083669 | 2021-08-05 04:21:51 | McDowell, West Virginia, US | |
339433 | 339433 | 2022-03-18 | US | West Virginia | McDowell | 54047 | 5568 | 67 | 0 | 37.38002939 | -81.65083669 | 2022-03-19 04:20:47 | McDowell, West Virginia, US | |
343761 | 343761 | 2021-02-03 | US | West Virginia | McDowell | 54047 | 1268 | 14 | 0 | 1254 | 37.38002939 | -81.65083669 | 2021-02-04 05:22:26 | McDowell, West Virginia, US |
347752 | 347752 | 2020-09-14 | US | West Virginia | McDowell | 54047 | 80 | 1 | 0 | 79 | 37.38002939 | -81.65083669 | 2020-09-15 03:22:50 | McDowell, West Virginia, US |
351797 | 351797 | 2022-12-14 | US | West Virginia | McDowell | 54047 | 7148 | 85 | 0 | 37.38002939 | -81.65083669 | 2022-12-15 04:20:58 | McDowell, West Virginia, US | |
355782 | 355782 | 2021-03-11 | US | West Virginia | McDowell | 54047 | 1384 | 20 | 0 | 37.38002939 | -81.65083669 | 2021-03-12 05:26:50 | McDowell, West Virginia, US | |
359823 | 359823 | 2022-03-11 | US | West Virginia | McDowell | 54047 | 5533 | 64 | 0 | 37.38002939 | -81.65083669 | 2022-03-12 04:20:50 | McDowell, West Virginia, US | |
363839 | 363839 | 2022-05-07 | US | West Virginia | McDowell | 54047 | 5645 | 75 | 0 | 37.38002939 | -81.65083669 | 2022-05-08 04:20:49 | McDowell, West Virginia, US | |
365851 | 365851 | 2020-07-16 | US | West Virginia | McDowell | 54047 | 12 | 0 | 0 | 12 | 37.38002939 | -81.65083669 | 2020-07-17 04:34:50 | McDowell, West Virginia, US |
369775 | 369775 | 2020-08-08 | US | West Virginia | McDowell | 54047 | 58 | 0 | 0 | 58 | 37.38002939 | -81.65083669 | 2020-08-09 04:34:54 | McDowell, West Virginia, US |
375697 | 375697 | 2022-09-13 | US | West Virginia | McDowell | 54047 | 6861 | 80 | 0 | 37.38002939 | -81.65083669 | 2022-09-14 04:20:44 | McDowell, West Virginia, US | |
379665 | 379665 | 2020-11-06 | US | West Virginia | McDowell | 54047 | 159 | 1 | 0 | 158 | 37.38002939 | -81.65083669 | 2020-11-07 05:24:52 | McDowell, West Virginia, US |
383681 | 383681 | 2021-04-30 | US | West Virginia | McDowell | 54047 | 1535 | 21 | 0 | 37.38002939 | -81.65083669 | 2021-05-01 04:20:47 | McDowell, West Virginia, US | |
387724 | 387724 | 2022-09-23 | US | West Virginia | McDowell | 54047 | 6965 | 80 | 0 | 37.38002939 | -81.65083669 | 2022-09-24 04:21:40 | McDowell, West Virginia, US | |
391711 | 391711 | 2021-04-04 | US | West Virginia | McDowell | 54047 | 1427 | 22 | 0 | 37.38002939 | -81.65083669 | 2021-04-05 04:20:35 | McDowell, West Virginia, US | |
395719 | 395719 | 2020-11-27 | US | West Virginia | McDowell | 54047 | 613 | 1 | 0 | 612 | 37.38002939 | -81.65083669 | 2020-11-28 05:25:50 | McDowell, West 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]);