johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
542 rows where deaths = 34 and province_or_state = "West Virginia" sorted by day descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756415 | 2756415 | 2022-12-29 | US | West Virginia | Pocahontas | 54075 | 2509 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-12-30 04:21:04 | Pocahontas, West Virginia, US | |
1077421 | 1077421 | 2022-12-28 | US | West Virginia | Pocahontas | 54075 | 2507 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-12-29 04:21:01 | Pocahontas, West Virginia, US | |
331418 | 331418 | 2022-12-27 | US | West Virginia | Pocahontas | 54075 | 2505 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-12-28 04:21:04 | Pocahontas, West Virginia, US | |
221491 | 221491 | 2022-12-26 | US | West Virginia | Pocahontas | 54075 | 2491 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-12-27 04:21:07 | Pocahontas, West Virginia, US | |
3225948 | 3225948 | 2022-12-25 | US | West Virginia | Pocahontas | 54075 | 2491 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-12-26 04:21:06 | Pocahontas, West Virginia, US | |
1021862 | 1021862 | 2022-12-24 | US | West Virginia | Pocahontas | 54075 | 2491 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-12-25 04:21:04 | Pocahontas, West Virginia, US | |
693885 | 693885 | 2022-12-23 | US | West Virginia | Pocahontas | 54075 | 2491 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-12-24 04:21:02 | Pocahontas, West Virginia, US | |
2183095 | 2183095 | 2022-12-22 | US | West Virginia | Pocahontas | 54075 | 2491 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-12-23 04:21:04 | Pocahontas, West Virginia, US | |
454899 | 454899 | 2022-12-21 | US | West Virginia | Pocahontas | 54075 | 2489 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-12-22 04:20:56 | Pocahontas, West Virginia, US | |
2954898 | 2954898 | 2022-12-20 | US | West Virginia | Pocahontas | 54075 | 2487 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-12-21 04:21:03 | Pocahontas, West Virginia, US | |
3177300 | 3177300 | 2022-12-19 | US | West Virginia | Pocahontas | 54075 | 2486 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-12-20 04:21:04 | Pocahontas, West Virginia, US | |
1631817 | 1631817 | 2022-12-18 | US | West Virginia | Pocahontas | 54075 | 2482 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-12-19 04:21:03 | Pocahontas, West Virginia, US | |
507196 | 507196 | 2022-12-17 | US | West Virginia | Pocahontas | 54075 | 2482 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-12-18 04:21:03 | Pocahontas, West Virginia, US | |
3327768 | 3327768 | 2022-12-16 | US | West Virginia | Pocahontas | 54075 | 2482 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-12-17 04:21:04 | Pocahontas, West Virginia, US | |
546280 | 546280 | 2022-12-15 | US | West Virginia | Pocahontas | 54075 | 2481 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-12-16 04:21:01 | Pocahontas, West Virginia, US | |
351808 | 351808 | 2022-12-14 | US | West Virginia | Pocahontas | 54075 | 2477 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-12-15 04:20:58 | Pocahontas, West Virginia, US | |
311396 | 311396 | 2022-12-13 | US | West Virginia | Pocahontas | 54075 | 2476 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-12-14 04:21:04 | Pocahontas, West Virginia, US | |
1152457 | 1152457 | 2022-12-12 | US | West Virginia | Pocahontas | 54075 | 2473 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-12-13 04:21:01 | Pocahontas, West Virginia, US | |
872311 | 872311 | 2022-12-11 | US | West Virginia | Pocahontas | 54075 | 2467 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-12-12 04:21:01 | Pocahontas, West Virginia, US | |
260841 | 260841 | 2022-12-10 | US | West Virginia | Pocahontas | 54075 | 2467 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-12-11 04:20:50 | Pocahontas, West Virginia, US | |
3939555 | 3939555 | 2022-12-09 | US | West Virginia | Pocahontas | 54075 | 2467 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-12-10 04:21:02 | Pocahontas, West Virginia, US | |
3380887 | 3380887 | 2022-12-08 | US | West Virginia | Pocahontas | 54075 | 2462 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-12-09 04:21:05 | Pocahontas, West Virginia, US | |
1988158 | 1988158 | 2022-12-07 | US | West Virginia | Pocahontas | 54075 | 2458 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-12-08 04:21:07 | Pocahontas, West Virginia, US | |
3717681 | 3717681 | 2022-12-06 | US | West Virginia | Pocahontas | 54075 | 2449 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-12-07 04:20:58 | Pocahontas, West Virginia, US | |
2418386 | 2418386 | 2022-12-05 | US | West Virginia | Pocahontas | 54075 | 2447 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-12-06 04:21:03 | Pocahontas, West Virginia, US | |
721994 | 721994 | 2022-12-04 | US | West Virginia | Pocahontas | 54075 | 2436 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-12-05 04:20:58 | Pocahontas, West Virginia, US | |
2820283 | 2820283 | 2022-12-03 | US | West Virginia | Pocahontas | 54075 | 2436 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-12-04 04:20:56 | Pocahontas, West Virginia, US | |
837139 | 837139 | 2022-12-02 | US | West Virginia | Pocahontas | 54075 | 2436 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-12-03 04:21:02 | Pocahontas, West Virginia, US | |
2139669 | 2139669 | 2022-12-01 | US | West Virginia | Pocahontas | 54075 | 2436 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-12-02 04:21:07 | Pocahontas, West Virginia, US | |
1968085 | 1968085 | 2022-11-30 | US | West Virginia | Pocahontas | 54075 | 2435 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-12-01 04:21:03 | Pocahontas, West Virginia, US | |
2560099 | 2560099 | 2022-11-29 | US | West Virginia | Pocahontas | 54075 | 2432 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-11-30 04:21:07 | Pocahontas, West Virginia, US | |
1243173 | 1243173 | 2022-11-28 | US | West Virginia | Pocahontas | 54075 | 2431 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-11-29 04:21:05 | Pocahontas, West Virginia, US | |
3555161 | 3555161 | 2022-11-27 | US | West Virginia | Pocahontas | 54075 | 2428 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-11-28 04:21:02 | Pocahontas, West Virginia, US | |
2103641 | 2103641 | 2022-11-26 | US | West Virginia | Pocahontas | 54075 | 2428 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-11-27 04:21:05 | Pocahontas, West Virginia, US | |
491132 | 491132 | 2022-11-25 | US | West Virginia | Pocahontas | 54075 | 2428 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-11-26 04:21:11 | Pocahontas, West Virginia, US | |
3526961 | 3526961 | 2022-11-24 | US | West Virginia | Pocahontas | 54075 | 2428 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-11-25 04:21:06 | Pocahontas, West Virginia, US | |
3315744 | 3315744 | 2022-11-23 | US | West Virginia | Pocahontas | 54075 | 2428 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-11-24 04:21:09 | Pocahontas, West Virginia, US | |
1623785 | 1623785 | 2022-11-22 | US | West Virginia | Pocahontas | 54075 | 2427 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-11-23 04:21:06 | Pocahontas, West Virginia, US | |
3463673 | 3463673 | 2022-11-21 | US | West Virginia | Pocahontas | 54075 | 2427 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-11-22 04:20:47 | Pocahontas, West Virginia, US | |
1643858 | 1643858 | 2022-11-20 | US | West Virginia | Pocahontas | 54075 | 2427 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-11-21 04:21:05 | Pocahontas, West Virginia, US | |
2067415 | 2067415 | 2022-11-19 | US | West Virginia | Pocahontas | 54075 | 2427 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-11-20 04:21:08 | Pocahontas, West Virginia, US | |
1758809 | 1758809 | 2022-11-18 | US | West Virginia | Pocahontas | 54075 | 2427 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-11-19 04:21:14 | Pocahontas, West Virginia, US | |
3029802 | 3029802 | 2022-11-17 | US | West Virginia | Pocahontas | 54075 | 2426 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-11-18 04:21:15 | Pocahontas, West Virginia, US | |
2489513 | 2489513 | 2022-11-16 | US | West Virginia | Pocahontas | 54075 | 2425 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-11-17 04:21:11 | Pocahontas, West Virginia, US | |
295524 | 295524 | 2022-11-15 | US | West Virginia | Pocahontas | 54075 | 2425 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-11-16 04:21:09 | Pocahontas, West Virginia, US | |
3600554 | 3600554 | 2022-11-14 | US | West Virginia | Pocahontas | 54075 | 2424 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-11-15 04:21:16 | Pocahontas, West Virginia, US | |
315412 | 315412 | 2022-11-13 | US | West Virginia | Pocahontas | 54075 | 2424 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-11-14 04:21:09 | Pocahontas, West Virginia, US | |
66573 | 66573 | 2022-11-12 | US | West Virginia | Pocahontas | 54075 | 2424 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-11-13 04:21:14 | Pocahontas, West Virginia, US | |
2930735 | 2930735 | 2022-11-11 | US | West Virginia | Pocahontas | 54075 | 2424 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-11-12 04:20:41 | Pocahontas, West Virginia, US | |
2509571 | 2509571 | 2022-11-10 | US | West Virginia | Pocahontas | 54075 | 2424 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-11-11 04:21:22 | Pocahontas, West Virginia, US | |
2434446 | 2434446 | 2022-11-09 | US | West Virginia | Pocahontas | 54075 | 2423 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-11-10 04:21:16 | Pocahontas, West Virginia, US | |
483102 | 483102 | 2022-11-08 | US | West Virginia | Pocahontas | 54075 | 2422 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-11-09 04:21:22 | Pocahontas, West Virginia, US | |
2442252 | 2442252 | 2022-11-07 | US | West Virginia | Pocahontas | 54075 | 2422 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-11-08 04:21:21 | Pocahontas, West Virginia, US | |
1053350 | 1053350 | 2022-11-06 | US | West Virginia | Pocahontas | 54075 | 2421 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-11-07 04:21:26 | Pocahontas, West Virginia, US | |
621374 | 621374 | 2022-11-05 | US | West Virginia | Pocahontas | 54075 | 2421 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-11-06 04:21:24 | Pocahontas, West Virginia, US | |
1025878 | 1025878 | 2022-11-04 | US | West Virginia | Pocahontas | 54075 | 2421 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-11-05 04:21:52 | Pocahontas, West Virginia, US | |
434869 | 434869 | 2022-11-03 | US | West Virginia | Pocahontas | 54075 | 2421 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-11-04 04:22:11 | Pocahontas, West Virginia, US | |
853111 | 853111 | 2022-11-02 | US | West Virginia | Pocahontas | 54075 | 2421 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-11-03 04:22:05 | Pocahontas, West Virginia, US | |
713962 | 713962 | 2022-11-01 | US | West Virginia | Pocahontas | 54075 | 2421 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-11-02 04:22:09 | Pocahontas, West Virginia, US | |
3288411 | 3288411 | 2022-10-31 | US | West Virginia | Pocahontas | 54075 | 2421 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-11-01 04:22:36 | Pocahontas, West Virginia, US | |
323444 | 323444 | 2022-10-30 | US | West Virginia | Pocahontas | 54075 | 2420 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-10-31 04:21:36 | Pocahontas, West Virginia, US | |
915720 | 915720 | 2022-10-29 | US | West Virginia | Pocahontas | 54075 | 2420 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-10-30 04:22:14 | Pocahontas, West Virginia, US | |
1369989 | 1369989 | 2022-10-28 | US | West Virginia | Pocahontas | 54075 | 2420 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-10-29 04:21:13 | Pocahontas, West Virginia, US | |
3041844 | 3041844 | 2022-10-27 | US | West Virginia | Pocahontas | 54075 | 2420 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-10-28 04:22:31 | Pocahontas, West Virginia, US | |
542264 | 542264 | 2022-10-26 | US | West Virginia | Pocahontas | 54075 | 2420 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-10-27 04:22:01 | Pocahontas, West Virginia, US | |
1833665 | 1833665 | 2022-10-25 | US | West Virginia | Pocahontas | 54075 | 2420 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-10-26 04:22:19 | Pocahontas, West Virginia, US | |
797926 | 797926 | 2022-10-24 | US | West Virginia | Pocahontas | 54075 | 2419 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-10-25 04:21:53 | Pocahontas, West Virginia, US | |
3280381 | 3280381 | 2022-10-23 | US | West Virginia | Pocahontas | 54075 | 2419 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-10-24 04:22:29 | Pocahontas, West Virginia, US | |
2271419 | 2271419 | 2022-10-22 | US | West Virginia | Pocahontas | 54075 | 2419 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-10-23 04:22:46 | Pocahontas, West Virginia, US | |
1595719 | 1595719 | 2022-10-21 | US | West Virginia | Pocahontas | 54075 | 2419 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-10-22 04:22:53 | Pocahontas, West Virginia, US | |
2275435 | 2275435 | 2022-10-20 | US | West Virginia | Pocahontas | 54075 | 2419 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-10-21 04:22:23 | Pocahontas, West Virginia, US | |
201770 | 201770 | 2022-10-19 | US | West Virginia | Pocahontas | 54075 | 2418 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-10-20 04:22:59 | Pocahontas, West Virginia, US | |
2760431 | 2760431 | 2022-10-18 | US | West Virginia | Pocahontas | 54075 | 2413 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-10-19 04:22:26 | Pocahontas, West Virginia, US | |
2028265 | 2028265 | 2022-10-17 | US | West Virginia | Pocahontas | 54075 | 2412 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-10-18 04:22:42 | Pocahontas, West Virginia, US | |
2163043 | 2163043 | 2022-10-16 | US | West Virginia | Pocahontas | 54075 | 2407 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-10-17 04:20:31 | Pocahontas, West Virginia, US | |
519240 | 519240 | 2022-10-15 | US | West Virginia | Pocahontas | 54075 | 2407 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-10-16 04:22:39 | Pocahontas, West Virginia, US | |
2036297 | 2036297 | 2022-10-14 | US | West Virginia | Pocahontas | 54075 | 2407 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-10-15 04:22:00 | Pocahontas, West Virginia, US | |
3756985 | 3756985 | 2022-10-13 | US | West Virginia | Pocahontas | 54075 | 2405 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-10-14 04:22:28 | Pocahontas, West Virginia, US | |
3217810 | 3217810 | 2022-10-12 | US | West Virginia | Pocahontas | 54075 | 2398 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-10-13 04:22:39 | Pocahontas, West Virginia, US | |
3253659 | 3253659 | 2022-10-11 | US | West Virginia | Pocahontas | 54075 | 2397 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-10-12 04:22:51 | Pocahontas, West Virginia, US | |
2970918 | 2970918 | 2022-10-10 | US | West Virginia | Pocahontas | 54075 | 2386 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-10-11 04:23:05 | Pocahontas, West Virginia, US | |
3100954 | 3100954 | 2022-10-09 | US | West Virginia | Pocahontas | 54075 | 2386 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-10-10 04:22:32 | Pocahontas, West Virginia, US | |
4006179 | 4006179 | 2022-10-08 | US | West Virginia | Pocahontas | 54075 | 2386 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-10-09 04:21:16 | Pocahontas, West Virginia, US | |
399776 | 399776 | 2022-10-07 | US | West Virginia | Pocahontas | 54075 | 2386 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-10-08 04:22:56 | Pocahontas, West Virginia, US | |
2532893 | 2532893 | 2022-10-06 | US | West Virginia | Pocahontas | 54075 | 2385 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-10-07 04:23:08 | Pocahontas, West Virginia, US | |
1814287 | 1814287 | 2022-10-05 | US | West Virginia | Pocahontas | 54075 | 2384 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-10-06 04:21:22 | Pocahontas, West Virginia, US | |
134261 | 134261 | 2022-10-04 | US | West Virginia | Pocahontas | 54075 | 2381 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-10-05 04:23:06 | Pocahontas, West Virginia, US | |
2689208 | 2689208 | 2022-10-03 | US | West Virginia | Pocahontas | 54075 | 2378 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-10-04 04:22:55 | Pocahontas, West Virginia, US | |
2263275 | 2263275 | 2022-10-02 | US | West Virginia | Pocahontas | 54075 | 2374 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-10-03 04:23:11 | Pocahontas, West Virginia, US | |
2998801 | 2998801 | 2022-10-01 | US | West Virginia | Pocahontas | 54075 | 2374 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-10-02 04:21:23 | Pocahontas, West Virginia, US | |
857127 | 857127 | 2022-09-30 | US | West Virginia | Pocahontas | 54075 | 2374 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-10-01 04:23:01 | Pocahontas, West Virginia, US | |
2379053 | 2379053 | 2022-09-29 | US | West Virginia | Pocahontas | 54075 | 2370 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-09-30 04:23:09 | Pocahontas, West Virginia, US | |
1563604 | 1563604 | 2022-09-28 | US | West Virginia | Pocahontas | 54075 | 2368 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-09-29 04:22:34 | Pocahontas, West Virginia, US | |
3998147 | 3998147 | 2022-09-27 | US | West Virginia | Pocahontas | 54075 | 2366 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-09-28 04:23:01 | Pocahontas, West Virginia, US | |
2772475 | 2772475 | 2022-09-26 | US | West Virginia | Pocahontas | 54075 | 2367 | 34 | 0 | 38.32758728 | -80.00993811 | 2022-09-27 04:23:01 | Pocahontas, West Virginia, US | |
1164691 | 1164691 | 2022-08-18 | US | West Virginia | Webster | 54101 | 2603 | 34 | 0 | 38.49370949 | -80.4202023 | 2022-08-19 04:20:54 | Webster, West Virginia, US | |
3954015 | 3954015 | 2022-08-17 | US | West Virginia | Webster | 54101 | 2595 | 34 | 0 | 38.49370949 | -80.4202023 | 2022-08-18 04:21:11 | Webster, West Virginia, US | |
994517 | 994517 | 2022-08-16 | US | West Virginia | Webster | 54101 | 2593 | 34 | 0 | 38.49370949 | -80.4202023 | 2022-08-17 04:20:59 | Webster, West Virginia, US | |
2497556 | 2497556 | 2022-08-15 | US | West Virginia | Webster | 54101 | 2590 | 34 | 0 | 38.49370949 | -80.4202023 | 2022-08-16 04:20:58 | Webster, West Virginia, US | |
3651106 | 3651106 | 2022-08-14 | US | West Virginia | Webster | 54101 | 2578 | 34 | 0 | 38.49370949 | -80.4202023 | 2022-08-15 04:20:59 | Webster, 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]);