johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
365 rows where country_or_region = "US", deaths = 21 and province_or_state = "West Virginia" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
375681 | 375681 | 2022-09-13 | US | West Virginia | Gilmer | 54021 | 2418 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-09-14 04:20:44 | Gilmer, West Virginia, US | |
2398283 | 2398283 | 2022-09-12 | US | West Virginia | Gilmer | 54021 | 2411 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-09-13 04:20:57 | Gilmer, West Virginia, US | |
3769361 | 3769361 | 2022-09-11 | US | West Virginia | Gilmer | 54021 | 2405 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-09-12 04:20:58 | Gilmer, West Virginia, US | |
3827936 | 3827936 | 2022-09-10 | US | West Virginia | Gilmer | 54021 | 2405 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-09-11 04:20:50 | Gilmer, West Virginia, US | |
966393 | 966393 | 2022-09-09 | US | West Virginia | Gilmer | 54021 | 2405 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-09-10 04:21:10 | Gilmer, West Virginia, US | |
256795 | 256795 | 2022-09-08 | US | West Virginia | Gilmer | 54021 | 2403 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-09-09 04:21:11 | Gilmer, West Virginia, US | |
3748593 | 3748593 | 2022-09-07 | US | West Virginia | Gilmer | 54021 | 2394 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-09-08 04:21:02 | Gilmer, West Virginia, US | |
118233 | 118233 | 2022-09-06 | US | West Virginia | Gilmer | 54021 | 2390 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-09-07 04:20:59 | Gilmer, West Virginia, US | |
2637205 | 2637205 | 2022-09-05 | US | West Virginia | Gilmer | 54021 | 2385 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-09-06 04:21:02 | Gilmer, West Virginia, US | |
2990769 | 2990769 | 2022-09-04 | US | West Virginia | Gilmer | 54021 | 2385 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-09-05 04:21:01 | Gilmer, West Virginia, US | |
2716454 | 2716454 | 2022-09-03 | US | West Virginia | Gilmer | 54021 | 2385 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-09-04 04:21:22 | Gilmer, West Virginia, US | |
1397159 | 1397159 | 2022-09-02 | US | West Virginia | Gilmer | 54021 | 2385 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-09-03 04:21:04 | Gilmer, West Virginia, US | |
3550988 | 3550988 | 2022-09-01 | US | West Virginia | Gilmer | 54021 | 2376 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-09-02 04:21:07 | Gilmer, West Virginia, US | |
2346908 | 2346908 | 2022-08-31 | US | West Virginia | Gilmer | 54021 | 2371 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-09-01 04:21:03 | Gilmer, West Virginia, US | |
3777388 | 3777388 | 2022-08-30 | US | West Virginia | Gilmer | 54021 | 2368 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-08-31 04:20:57 | Gilmer, West Virginia, US | |
1683984 | 1683984 | 2022-08-29 | US | West Virginia | Gilmer | 54021 | 2364 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-08-30 04:21:03 | Gilmer, West Virginia, US | |
1880468 | 1880468 | 2022-08-28 | US | West Virginia | Gilmer | 54021 | 2359 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-08-29 04:21:06 | Gilmer, West Virginia, US | |
2099595 | 2099595 | 2022-08-27 | US | West Virginia | Gilmer | 54021 | 2359 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-08-28 04:21:02 | Gilmer, West Virginia, US | |
1535410 | 1535410 | 2022-08-26 | US | West Virginia | Gilmer | 54021 | 2359 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-08-27 04:20:57 | Gilmer, West Virginia, US | |
2832297 | 2832297 | 2022-08-25 | US | West Virginia | Gilmer | 54021 | 2357 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-08-26 04:21:02 | Gilmer, West Virginia, US | |
2326830 | 2326830 | 2022-08-24 | US | West Virginia | Gilmer | 54021 | 2354 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-08-25 04:21:13 | Gilmer, West Virginia, US | |
1254239 | 1254239 | 2022-08-23 | US | West Virginia | Gilmer | 54021 | 2346 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-08-24 04:20:46 | Gilmer, West Virginia, US | |
2856343 | 2856343 | 2022-08-22 | US | West Virginia | Gilmer | 54021 | 2341 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-08-23 04:20:56 | Gilmer, West Virginia, US | |
2406315 | 2406315 | 2022-08-21 | US | West Virginia | Gilmer | 54021 | 2332 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-08-22 04:20:38 | Gilmer, West Virginia, US | |
3801393 | 3801393 | 2022-08-20 | US | West Virginia | Gilmer | 54021 | 2332 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-08-21 04:20:44 | Gilmer, West Virginia, US | |
2366979 | 2366979 | 2022-08-19 | US | West Virginia | Gilmer | 54021 | 2332 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-08-20 04:21:01 | Gilmer, West Virginia, US | |
1164650 | 1164650 | 2022-08-18 | US | West Virginia | Gilmer | 54021 | 2331 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-08-19 04:20:54 | Gilmer, West Virginia, US | |
3953974 | 3953974 | 2022-08-17 | US | West Virginia | Gilmer | 54021 | 2326 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-08-18 04:21:11 | Gilmer, West Virginia, US | |
994476 | 994476 | 2022-08-16 | US | West Virginia | Gilmer | 54021 | 2321 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-08-17 04:20:59 | Gilmer, West Virginia, US | |
2497515 | 2497515 | 2022-08-15 | US | West Virginia | Gilmer | 54021 | 2320 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-08-16 04:20:58 | Gilmer, West Virginia, US | |
3651065 | 3651065 | 2022-08-14 | US | West Virginia | Gilmer | 54021 | 2317 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-08-15 04:20:59 | Gilmer, West Virginia, US | |
1972071 | 1972071 | 2022-08-13 | US | West Virginia | Gilmer | 54021 | 2317 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-08-14 04:20:55 | Gilmer, West Virginia, US | |
2891880 | 2891880 | 2022-08-12 | US | West Virginia | Gilmer | 54021 | 2317 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-08-13 04:20:52 | Gilmer, West Virginia, US | |
3911485 | 3911485 | 2022-08-11 | US | West Virginia | Gilmer | 54021 | 2314 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-08-12 04:20:54 | Gilmer, West Virginia, US | |
1349802 | 1349802 | 2022-08-10 | US | West Virginia | Gilmer | 54021 | 2313 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-08-11 04:20:49 | Gilmer, West Virginia, US | |
1089557 | 1089557 | 2022-08-09 | US | West Virginia | Gilmer | 54021 | 2309 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-08-10 04:20:57 | Gilmer, West Virginia, US | |
3546972 | 3546972 | 2022-08-08 | US | West Virginia | Gilmer | 54021 | 2307 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-08-09 04:20:34 | Gilmer, West Virginia, US | |
1073375 | 1073375 | 2022-08-07 | US | West Virginia | Gilmer | 54021 | 2299 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-08-08 04:21:08 | Gilmer, West Virginia, US | |
1943963 | 1943963 | 2022-08-06 | US | West Virginia | Gilmer | 54021 | 2299 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-08-07 04:20:54 | Gilmer, West Virginia, US | |
883762 | 883762 | 2022-08-05 | US | West Virginia | Gilmer | 54021 | 2299 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-08-06 04:20:56 | Gilmer, West Virginia, US | |
2012173 | 2012173 | 2022-08-04 | US | West Virginia | Gilmer | 54021 | 2296 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-08-05 04:20:52 | Gilmer, West Virginia, US | |
1101600 | 1101600 | 2022-08-03 | US | West Virginia | Gilmer | 54021 | 2295 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-08-04 04:20:58 | Gilmer, West Virginia, US | |
1408525 | 1408525 | 2022-08-02 | US | West Virginia | Gilmer | 54021 | 2292 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-08-03 04:20:59 | Gilmer, West Virginia, US | |
3620563 | 3620563 | 2022-08-01 | US | West Virginia | Gilmer | 54021 | 2287 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-08-02 04:20:53 | Gilmer, West Virginia, US | |
3875043 | 3875043 | 2022-07-31 | US | West Virginia | Gilmer | 54021 | 2280 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-08-01 04:21:03 | Gilmer, West Virginia, US | |
677797 | 677797 | 2022-07-30 | US | West Virginia | Gilmer | 54021 | 2280 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-07-31 04:21:02 | Gilmer, West Virginia, US | |
1786996 | 1786996 | 2022-07-29 | US | West Virginia | Gilmer | 54021 | 2280 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-07-30 04:20:42 | Gilmer, West Virginia, US | |
2310792 | 2310792 | 2022-04-20 | US | West Virginia | Pendleton | 54071 | 1962 | 21 | 0 | 38.68314479 | -79.35084086 | 2022-04-21 04:20:46 | Pendleton, West Virginia, US | |
2254931 | 2254931 | 2022-04-19 | US | West Virginia | Pendleton | 54071 | 1961 | 21 | 0 | 38.68314479 | -79.35084086 | 2022-04-20 04:20:45 | Pendleton, West Virginia, US | |
1849481 | 1849481 | 2022-04-18 | US | West Virginia | Pendleton | 54071 | 1959 | 21 | 0 | 38.68314479 | -79.35084086 | 2022-04-19 04:21:00 | Pendleton, West Virginia, US | |
3420425 | 3420425 | 2022-04-17 | US | West Virginia | Pendleton | 54071 | 1959 | 21 | 0 | 38.68314479 | -79.35084086 | 2022-04-18 04:21:12 | Pendleton, West Virginia, US | |
307374 | 307374 | 2022-04-16 | US | West Virginia | Pendleton | 54071 | 1959 | 21 | 0 | 38.68314479 | -79.35084086 | 2022-04-17 04:20:59 | Pendleton, West Virginia, US | |
2673319 | 2673319 | 2022-04-15 | US | West Virginia | Pendleton | 54071 | 1959 | 21 | 0 | 38.68314479 | -79.35084086 | 2022-04-16 04:20:48 | Pendleton, West Virginia, US | |
1227104 | 1227104 | 2022-04-14 | US | West Virginia | Pendleton | 54071 | 1959 | 21 | 0 | 38.68314479 | -79.35084086 | 2022-04-15 04:20:57 | Pendleton, West Virginia, US | |
2446262 | 2446262 | 2022-04-13 | US | West Virginia | Pendleton | 54071 | 1959 | 21 | 0 | 38.68314479 | -79.35084086 | 2022-04-13 23:21:06 | Pendleton, West Virginia, US | |
1952019 | 1952019 | 2022-04-12 | US | West Virginia | Pendleton | 54071 | 1961 | 21 | 0 | 38.68314479 | -79.35084086 | 2022-04-13 04:21:03 | Pendleton, West Virginia, US | |
3209772 | 3209772 | 2022-04-11 | US | West Virginia | Pendleton | 54071 | 1956 | 21 | 0 | 38.68314479 | -79.35084086 | 2022-04-12 04:20:49 | Pendleton, West Virginia, US | |
1579658 | 1579658 | 2022-04-10 | US | West Virginia | Pendleton | 54071 | 1953 | 21 | 0 | 38.68314479 | -79.35084086 | 2022-04-11 04:21:02 | Pendleton, West Virginia, US | |
1655900 | 1655900 | 2022-04-09 | US | West Virginia | Pendleton | 54071 | 1953 | 21 | 0 | 38.68314479 | -79.35084086 | 2022-04-10 04:20:52 | Pendleton, West Virginia, US | |
2119222 | 2119222 | 2022-04-08 | US | West Virginia | Pendleton | 54071 | 1953 | 21 | 0 | 38.68314479 | -79.35084086 | 2022-04-09 04:20:42 | Pendleton, West Virginia, US | |
3323746 | 3323746 | 2022-04-07 | US | West Virginia | Pendleton | 54071 | 1948 | 21 | 0 | 38.68314479 | -79.35084086 | 2022-04-08 04:20:48 | Pendleton, West Virginia, US | |
2804282 | 2804282 | 2022-04-06 | US | West Virginia | Pendleton | 54071 | 1948 | 21 | 0 | 38.68314479 | -79.35084086 | 2022-04-07 04:20:53 | Pendleton, West Virginia, US | |
3675176 | 3675176 | 2022-02-15 | US | West Virginia | Wirt | 54105 | 1403 | 21 | 0 | 39.02775007 | -81.37473928 | 2022-02-16 04:21:10 | Wirt, West Virginia, US | |
1258280 | 1258280 | 2021-12-20 | US | West Virginia | Pocahontas | 54075 | 1321 | 21 | 0 | 38.32758728 | -80.00993811 | 2021-12-21 03:21:27 | Pocahontas, West Virginia, US | |
2907223 | 2907223 | 2021-12-19 | US | West Virginia | Pocahontas | 54075 | 1321 | 21 | 0 | 38.32758728 | -80.00993811 | 2021-12-20 04:21:43 | Pocahontas, West Virginia, US | |
1262296 | 1262296 | 2021-12-18 | US | West Virginia | Pocahontas | 54075 | 1319 | 21 | 0 | 38.32758728 | -80.00993811 | 2021-12-19 04:21:11 | Pocahontas, West Virginia, US | |
2402324 | 2402324 | 2021-12-17 | US | West Virginia | Pocahontas | 54075 | 1314 | 21 | 0 | 38.32758728 | -80.00993811 | 2021-12-18 02:22:20 | Pocahontas, West Virginia, US | |
1719862 | 1719862 | 2021-12-16 | US | West Virginia | Pocahontas | 54075 | 1308 | 21 | 0 | 38.32758728 | -80.00993811 | 2021-12-17 04:22:14 | Pocahontas, West Virginia, US | |
3499696 | 3499696 | 2021-12-15 | US | West Virginia | Pocahontas | 54075 | 1305 | 21 | 0 | 38.32758728 | -80.00993811 | 2021-12-16 04:22:11 | Pocahontas, West Virginia, US | |
2091481 | 2091481 | 2021-12-14 | US | West Virginia | Pocahontas | 54075 | 1299 | 21 | 0 | 38.32758728 | -80.00993811 | 2021-12-15 03:22:16 | Pocahontas, West Virginia, US | |
785898 | 785898 | 2021-12-13 | US | West Virginia | Pocahontas | 54075 | 1292 | 21 | 0 | 38.32758728 | -80.00993811 | 2021-12-14 04:22:38 | Pocahontas, West Virginia, US | |
1663933 | 1663933 | 2021-12-12 | US | West Virginia | Pocahontas | 54075 | 1291 | 21 | 0 | 38.32758728 | -80.00993811 | 2021-12-13 04:22:02 | Pocahontas, West Virginia, US | |
1667949 | 1667949 | 2021-12-11 | US | West Virginia | Pocahontas | 54075 | 1289 | 21 | 0 | 38.32758728 | -80.00993811 | 2021-12-12 04:22:12 | Pocahontas, West Virginia, US | |
3659101 | 3659101 | 2021-12-10 | US | West Virginia | Pocahontas | 54075 | 1288 | 21 | 0 | 38.32758728 | -80.00993811 | 2021-12-11 04:22:45 | Pocahontas, West Virginia, US | |
1081432 | 1081432 | 2021-12-09 | US | West Virginia | Pocahontas | 54075 | 1285 | 21 | 0 | 38.32758728 | -80.00993811 | 2021-12-10 04:22:28 | Pocahontas, West Virginia, US | |
554281 | 554281 | 2021-12-08 | US | West Virginia | Pocahontas | 54075 | 1284 | 21 | 0 | 38.32758728 | -80.00993811 | 2021-12-09 04:22:49 | Pocahontas, West Virginia, US | |
407801 | 407801 | 2021-12-07 | US | West Virginia | Pocahontas | 54075 | 1283 | 21 | 0 | 38.32758728 | -80.00993811 | 2021-12-08 04:22:46 | Pocahontas, West Virginia, US | |
1033883 | 1033883 | 2021-12-06 | US | West Virginia | Pocahontas | 54075 | 1282 | 21 | 0 | 38.32758728 | -80.00993811 | 2021-12-07 04:22:34 | Pocahontas, West Virginia, US | |
1744046 | 1744046 | 2021-12-05 | US | West Virginia | Pocahontas | 54075 | 1281 | 21 | 0 | 38.32758728 | -80.00993811 | 2021-12-06 04:22:34 | Pocahontas, West Virginia, US | |
141478 | 141478 | 2021-12-04 | US | West Virginia | Pocahontas | 54075 | 1279 | 21 | 0 | 38.32758728 | -80.00993811 | 2021-12-05 04:22:25 | Pocahontas, West Virginia, US | |
2199131 | 2199131 | 2021-12-03 | US | West Virginia | Pocahontas | 54075 | 1276 | 21 | 0 | 38.32758728 | -80.00993811 | 2021-12-04 04:22:18 | Pocahontas, West Virginia, US | |
3837 | 3837 | 2021-12-02 | US | West Virginia | Pocahontas | 54075 | 1274 | 21 | 0 | 38.32758728 | -80.00993811 | 2021-12-03 04:23:05 | Pocahontas, West Virginia, US | |
1148436 | 1148436 | 2021-12-01 | US | West Virginia | Pocahontas | 54075 | 1270 | 21 | 0 | 38.32758728 | -80.00993811 | 2021-12-02 04:22:37 | Pocahontas, West Virginia, US | |
1148441 | 1148441 | 2021-12-01 | US | West Virginia | Ritchie | 54085 | 1554 | 21 | 0 | 39.18094587 | -81.06356878 | 2021-12-02 04:22:37 | Ritchie, West Virginia, US | |
3404948 | 3404948 | 2021-11-30 | US | West Virginia | Pocahontas | 54075 | 1262 | 21 | 0 | 38.32758728 | -80.00993811 | 2021-12-01 04:22:29 | Pocahontas, West Virginia, US | |
3404953 | 3404953 | 2021-11-30 | US | West Virginia | Ritchie | 54085 | 1545 | 21 | 0 | 39.18094587 | -81.06356878 | 2021-12-01 04:22:29 | Ritchie, West Virginia, US | |
153461 | 153461 | 2021-11-29 | US | West Virginia | Clay | 54015 | 1386 | 21 | 0 | 38.46231092 | -81.07652217 | 2021-11-30 04:22:53 | Clay, West Virginia, US | |
153496 | 153496 | 2021-11-29 | US | West Virginia | Ritchie | 54085 | 1545 | 21 | 0 | 39.18094587 | -81.06356878 | 2021-11-30 04:22:53 | Ritchie, West Virginia, US | |
3073506 | 3073506 | 2021-11-23 | US | West Virginia | Clay | 54015 | 1368 | 21 | 0 | 38.46231092 | -81.07652217 | 2021-11-24 04:22:14 | Clay, West Virginia, US | |
3073541 | 3073541 | 2021-11-23 | US | West Virginia | Ritchie | 54085 | 1532 | 21 | 0 | 39.18094587 | -81.06356878 | 2021-11-24 04:22:14 | Ritchie, West Virginia, US | |
3752604 | 3752604 | 2021-11-22 | US | West Virginia | Clay | 54015 | 1363 | 21 | 0 | 38.46231092 | -81.07652217 | 2021-11-23 04:22:39 | Clay, West Virginia, US | |
3752639 | 3752639 | 2021-11-22 | US | West Virginia | Ritchie | 54085 | 1526 | 21 | 0 | 39.18094587 | -81.06356878 | 2021-11-23 04:22:39 | Ritchie, West Virginia, US | |
1017811 | 1017811 | 2021-11-21 | US | West Virginia | Clay | 54015 | 1359 | 21 | 0 | 38.46231092 | -81.07652217 | 2021-11-22 04:22:20 | Clay, West Virginia, US | |
1017846 | 1017846 | 2021-11-21 | US | West Virginia | Ritchie | 54085 | 1527 | 21 | 0 | 39.18094587 | -81.06356878 | 2021-11-22 04:22:20 | Ritchie, West Virginia, US | |
725975 | 725975 | 2021-11-20 | US | West Virginia | Clay | 54015 | 1358 | 21 | 0 | 38.46231092 | -81.07652217 | 2021-11-21 04:22:13 | Clay, West Virginia, US | |
726010 | 726010 | 2021-11-20 | US | West Virginia | Ritchie | 54085 | 1525 | 21 | 0 | 39.18094587 | -81.06356878 | 2021-11-21 04:22:13 | Ritchie, West Virginia, US | |
165505 | 165505 | 2021-11-19 | US | West Virginia | Clay | 54015 | 1353 | 21 | 0 | 38.46231092 | -81.07652217 | 2021-11-20 04:22:17 | Clay, West Virginia, US | |
165540 | 165540 | 2021-11-19 | US | West Virginia | Ritchie | 54085 | 1517 | 21 | 0 | 39.18094587 | -81.06356878 | 2021-11-20 04:22:17 | Ritchie, West Virginia, US | |
3292392 | 3292392 | 2021-11-18 | US | West Virginia | Clay | 54015 | 1345 | 21 | 0 | 38.46231092 | -81.07652217 | 2021-11-19 04:21:40 | Clay, West Virginia, US | |
3292427 | 3292427 | 2021-11-18 | US | West Virginia | Ritchie | 54085 | 1518 | 21 | 0 | 39.18094587 | -81.06356878 | 2021-11-19 04:21:40 | Ritchie, 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]);