johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
532 rows where deaths = 23 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
331391 | 331391 | 2022-12-27 | US | West Virginia | Gilmer | 54021 | 2519 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-12-28 04:21:04 | Gilmer, West Virginia, US | |
331416 | 331416 | 2022-12-27 | US | West Virginia | Pendleton | 54071 | 2295 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-12-28 04:21:04 | Pendleton, West Virginia, US | |
221464 | 221464 | 2022-12-26 | US | West Virginia | Gilmer | 54021 | 2519 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-12-27 04:21:07 | Gilmer, West Virginia, US | |
221489 | 221489 | 2022-12-26 | US | West Virginia | Pendleton | 54071 | 2293 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-12-27 04:21:07 | Pendleton, West Virginia, US | |
3225921 | 3225921 | 2022-12-25 | US | West Virginia | Gilmer | 54021 | 2519 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-12-26 04:21:06 | Gilmer, West Virginia, US | |
3225946 | 3225946 | 2022-12-25 | US | West Virginia | Pendleton | 54071 | 2293 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-12-26 04:21:06 | Pendleton, West Virginia, US | |
1021835 | 1021835 | 2022-12-24 | US | West Virginia | Gilmer | 54021 | 2519 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-12-25 04:21:04 | Gilmer, West Virginia, US | |
1021860 | 1021860 | 2022-12-24 | US | West Virginia | Pendleton | 54071 | 2293 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-12-25 04:21:04 | Pendleton, West Virginia, US | |
693858 | 693858 | 2022-12-23 | US | West Virginia | Gilmer | 54021 | 2519 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-12-24 04:21:02 | Gilmer, West Virginia, US | |
693883 | 693883 | 2022-12-23 | US | West Virginia | Pendleton | 54071 | 2293 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-12-24 04:21:02 | Pendleton, West Virginia, US | |
2183068 | 2183068 | 2022-12-22 | US | West Virginia | Gilmer | 54021 | 2519 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-12-23 04:21:04 | Gilmer, West Virginia, US | |
2183093 | 2183093 | 2022-12-22 | US | West Virginia | Pendleton | 54071 | 2293 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-12-23 04:21:04 | Pendleton, West Virginia, US | |
454872 | 454872 | 2022-12-21 | US | West Virginia | Gilmer | 54021 | 2519 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-12-22 04:20:56 | Gilmer, West Virginia, US | |
454897 | 454897 | 2022-12-21 | US | West Virginia | Pendleton | 54071 | 2292 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-12-22 04:20:56 | Pendleton, West Virginia, US | |
2954871 | 2954871 | 2022-12-20 | US | West Virginia | Gilmer | 54021 | 2518 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-12-21 04:21:03 | Gilmer, West Virginia, US | |
2954896 | 2954896 | 2022-12-20 | US | West Virginia | Pendleton | 54071 | 2290 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-12-21 04:21:03 | Pendleton, West Virginia, US | |
3177273 | 3177273 | 2022-12-19 | US | West Virginia | Gilmer | 54021 | 2518 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-12-20 04:21:04 | Gilmer, West Virginia, US | |
3177298 | 3177298 | 2022-12-19 | US | West Virginia | Pendleton | 54071 | 2289 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-12-20 04:21:04 | Pendleton, West Virginia, US | |
1631790 | 1631790 | 2022-12-18 | US | West Virginia | Gilmer | 54021 | 2517 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-12-19 04:21:03 | Gilmer, West Virginia, US | |
1631815 | 1631815 | 2022-12-18 | US | West Virginia | Pendleton | 54071 | 2287 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-12-19 04:21:03 | Pendleton, West Virginia, US | |
507169 | 507169 | 2022-12-17 | US | West Virginia | Gilmer | 54021 | 2517 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-12-18 04:21:03 | Gilmer, West Virginia, US | |
507194 | 507194 | 2022-12-17 | US | West Virginia | Pendleton | 54071 | 2287 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-12-18 04:21:03 | Pendleton, West Virginia, US | |
3327741 | 3327741 | 2022-12-16 | US | West Virginia | Gilmer | 54021 | 2517 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-12-17 04:21:04 | Gilmer, West Virginia, US | |
3327766 | 3327766 | 2022-12-16 | US | West Virginia | Pendleton | 54071 | 2287 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-12-17 04:21:04 | Pendleton, West Virginia, US | |
546253 | 546253 | 2022-12-15 | US | West Virginia | Gilmer | 54021 | 2517 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-12-16 04:21:01 | Gilmer, West Virginia, US | |
546278 | 546278 | 2022-12-15 | US | West Virginia | Pendleton | 54071 | 2284 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-12-16 04:21:01 | Pendleton, West Virginia, US | |
351781 | 351781 | 2022-12-14 | US | West Virginia | Gilmer | 54021 | 2517 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-12-15 04:20:58 | Gilmer, West Virginia, US | |
351806 | 351806 | 2022-12-14 | US | West Virginia | Pendleton | 54071 | 2283 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-12-15 04:20:58 | Pendleton, West Virginia, US | |
311369 | 311369 | 2022-12-13 | US | West Virginia | Gilmer | 54021 | 2517 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-12-14 04:21:04 | Gilmer, West Virginia, US | |
311394 | 311394 | 2022-12-13 | US | West Virginia | Pendleton | 54071 | 2280 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-12-14 04:21:04 | Pendleton, West Virginia, US | |
1152430 | 1152430 | 2022-12-12 | US | West Virginia | Gilmer | 54021 | 2517 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-12-13 04:21:01 | Gilmer, West Virginia, US | |
1152455 | 1152455 | 2022-12-12 | US | West Virginia | Pendleton | 54071 | 2279 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-12-13 04:21:01 | Pendleton, West Virginia, US | |
872284 | 872284 | 2022-12-11 | US | West Virginia | Gilmer | 54021 | 2516 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-12-12 04:21:01 | Gilmer, West Virginia, US | |
872309 | 872309 | 2022-12-11 | US | West Virginia | Pendleton | 54071 | 2276 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-12-12 04:21:01 | Pendleton, West Virginia, US | |
260814 | 260814 | 2022-12-10 | US | West Virginia | Gilmer | 54021 | 2516 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-12-11 04:20:50 | Gilmer, West Virginia, US | |
260839 | 260839 | 2022-12-10 | US | West Virginia | Pendleton | 54071 | 2276 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-12-11 04:20:50 | Pendleton, West Virginia, US | |
3939528 | 3939528 | 2022-12-09 | US | West Virginia | Gilmer | 54021 | 2516 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-12-10 04:21:02 | Gilmer, West Virginia, US | |
3939553 | 3939553 | 2022-12-09 | US | West Virginia | Pendleton | 54071 | 2276 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-12-10 04:21:02 | Pendleton, West Virginia, US | |
3380860 | 3380860 | 2022-12-08 | US | West Virginia | Gilmer | 54021 | 2514 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-12-09 04:21:05 | Gilmer, West Virginia, US | |
3380885 | 3380885 | 2022-12-08 | US | West Virginia | Pendleton | 54071 | 2273 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-12-09 04:21:05 | Pendleton, West Virginia, US | |
1988131 | 1988131 | 2022-12-07 | US | West Virginia | Gilmer | 54021 | 2514 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-12-08 04:21:07 | Gilmer, West Virginia, US | |
1988156 | 1988156 | 2022-12-07 | US | West Virginia | Pendleton | 54071 | 2272 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-12-08 04:21:07 | Pendleton, West Virginia, US | |
3717654 | 3717654 | 2022-12-06 | US | West Virginia | Gilmer | 54021 | 2514 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-12-07 04:20:58 | Gilmer, West Virginia, US | |
3717679 | 3717679 | 2022-12-06 | US | West Virginia | Pendleton | 54071 | 2271 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-12-07 04:20:58 | Pendleton, West Virginia, US | |
2418359 | 2418359 | 2022-12-05 | US | West Virginia | Gilmer | 54021 | 2514 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-12-06 04:21:03 | Gilmer, West Virginia, US | |
2418384 | 2418384 | 2022-12-05 | US | West Virginia | Pendleton | 54071 | 2268 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-12-06 04:21:03 | Pendleton, West Virginia, US | |
721967 | 721967 | 2022-12-04 | US | West Virginia | Gilmer | 54021 | 2511 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-12-05 04:20:58 | Gilmer, West Virginia, US | |
721992 | 721992 | 2022-12-04 | US | West Virginia | Pendleton | 54071 | 2267 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-12-05 04:20:58 | Pendleton, West Virginia, US | |
2820256 | 2820256 | 2022-12-03 | US | West Virginia | Gilmer | 54021 | 2511 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-12-04 04:20:56 | Gilmer, West Virginia, US | |
2820281 | 2820281 | 2022-12-03 | US | West Virginia | Pendleton | 54071 | 2267 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-12-04 04:20:56 | Pendleton, West Virginia, US | |
837112 | 837112 | 2022-12-02 | US | West Virginia | Gilmer | 54021 | 2511 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-12-03 04:21:02 | Gilmer, West Virginia, US | |
837137 | 837137 | 2022-12-02 | US | West Virginia | Pendleton | 54071 | 2267 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-12-03 04:21:02 | Pendleton, West Virginia, US | |
2139642 | 2139642 | 2022-12-01 | US | West Virginia | Gilmer | 54021 | 2511 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-12-02 04:21:07 | Gilmer, West Virginia, US | |
2139667 | 2139667 | 2022-12-01 | US | West Virginia | Pendleton | 54071 | 2266 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-12-02 04:21:07 | Pendleton, West Virginia, US | |
1968058 | 1968058 | 2022-11-30 | US | West Virginia | Gilmer | 54021 | 2511 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-12-01 04:21:03 | Gilmer, West Virginia, US | |
1968083 | 1968083 | 2022-11-30 | US | West Virginia | Pendleton | 54071 | 2263 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-12-01 04:21:03 | Pendleton, West Virginia, US | |
2560072 | 2560072 | 2022-11-29 | US | West Virginia | Gilmer | 54021 | 2509 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-11-30 04:21:07 | Gilmer, West Virginia, US | |
2560097 | 2560097 | 2022-11-29 | US | West Virginia | Pendleton | 54071 | 2263 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-11-30 04:21:07 | Pendleton, West Virginia, US | |
1243146 | 1243146 | 2022-11-28 | US | West Virginia | Gilmer | 54021 | 2507 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-11-29 04:21:05 | Gilmer, West Virginia, US | |
1243171 | 1243171 | 2022-11-28 | US | West Virginia | Pendleton | 54071 | 2262 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-11-29 04:21:05 | Pendleton, West Virginia, US | |
3555134 | 3555134 | 2022-11-27 | US | West Virginia | Gilmer | 54021 | 2506 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-11-28 04:21:02 | Gilmer, West Virginia, US | |
3555159 | 3555159 | 2022-11-27 | US | West Virginia | Pendleton | 54071 | 2259 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-11-28 04:21:02 | Pendleton, West Virginia, US | |
2103614 | 2103614 | 2022-11-26 | US | West Virginia | Gilmer | 54021 | 2506 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-11-27 04:21:05 | Gilmer, West Virginia, US | |
2103639 | 2103639 | 2022-11-26 | US | West Virginia | Pendleton | 54071 | 2259 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-11-27 04:21:05 | Pendleton, West Virginia, US | |
491105 | 491105 | 2022-11-25 | US | West Virginia | Gilmer | 54021 | 2506 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-11-26 04:21:11 | Gilmer, West Virginia, US | |
491130 | 491130 | 2022-11-25 | US | West Virginia | Pendleton | 54071 | 2259 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-11-26 04:21:11 | Pendleton, West Virginia, US | |
3526934 | 3526934 | 2022-11-24 | US | West Virginia | Gilmer | 54021 | 2506 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-11-25 04:21:06 | Gilmer, West Virginia, US | |
3526959 | 3526959 | 2022-11-24 | US | West Virginia | Pendleton | 54071 | 2259 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-11-25 04:21:06 | Pendleton, West Virginia, US | |
3315717 | 3315717 | 2022-11-23 | US | West Virginia | Gilmer | 54021 | 2506 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-11-24 04:21:09 | Gilmer, West Virginia, US | |
3315742 | 3315742 | 2022-11-23 | US | West Virginia | Pendleton | 54071 | 2259 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-11-24 04:21:09 | Pendleton, West Virginia, US | |
1623758 | 1623758 | 2022-11-22 | US | West Virginia | Gilmer | 54021 | 2505 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-11-23 04:21:06 | Gilmer, West Virginia, US | |
1623783 | 1623783 | 2022-11-22 | US | West Virginia | Pendleton | 54071 | 2259 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-11-23 04:21:06 | Pendleton, West Virginia, US | |
3463646 | 3463646 | 2022-11-21 | US | West Virginia | Gilmer | 54021 | 2503 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-11-22 04:20:47 | Gilmer, West Virginia, US | |
3463671 | 3463671 | 2022-11-21 | US | West Virginia | Pendleton | 54071 | 2258 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-11-22 04:20:47 | Pendleton, West Virginia, US | |
1643831 | 1643831 | 2022-11-20 | US | West Virginia | Gilmer | 54021 | 2501 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-11-21 04:21:05 | Gilmer, West Virginia, US | |
1643856 | 1643856 | 2022-11-20 | US | West Virginia | Pendleton | 54071 | 2256 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-11-21 04:21:05 | Pendleton, West Virginia, US | |
2067388 | 2067388 | 2022-11-19 | US | West Virginia | Gilmer | 54021 | 2501 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-11-20 04:21:08 | Gilmer, West Virginia, US | |
2067413 | 2067413 | 2022-11-19 | US | West Virginia | Pendleton | 54071 | 2256 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-11-20 04:21:08 | Pendleton, West Virginia, US | |
1758782 | 1758782 | 2022-11-18 | US | West Virginia | Gilmer | 54021 | 2501 | 23 | 0 | 38.9251277 | -80.85952723 | 2022-11-19 04:21:14 | Gilmer, West Virginia, US | |
1758807 | 1758807 | 2022-11-18 | US | West Virginia | Pendleton | 54071 | 2256 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-11-19 04:21:14 | Pendleton, West Virginia, US | |
3029800 | 3029800 | 2022-11-17 | US | West Virginia | Pendleton | 54071 | 2256 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-11-18 04:21:15 | Pendleton, West Virginia, US | |
2489511 | 2489511 | 2022-11-16 | US | West Virginia | Pendleton | 54071 | 2255 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-11-17 04:21:11 | Pendleton, West Virginia, US | |
295522 | 295522 | 2022-11-15 | US | West Virginia | Pendleton | 54071 | 2255 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-11-16 04:21:09 | Pendleton, West Virginia, US | |
3600552 | 3600552 | 2022-11-14 | US | West Virginia | Pendleton | 54071 | 2253 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-11-15 04:21:16 | Pendleton, West Virginia, US | |
315410 | 315410 | 2022-11-13 | US | West Virginia | Pendleton | 54071 | 2250 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-11-14 04:21:09 | Pendleton, West Virginia, US | |
66571 | 66571 | 2022-11-12 | US | West Virginia | Pendleton | 54071 | 2250 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-11-13 04:21:14 | Pendleton, West Virginia, US | |
2930733 | 2930733 | 2022-11-11 | US | West Virginia | Pendleton | 54071 | 2250 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-11-12 04:20:41 | Pendleton, West Virginia, US | |
2509569 | 2509569 | 2022-11-10 | US | West Virginia | Pendleton | 54071 | 2250 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-11-11 04:21:22 | Pendleton, West Virginia, US | |
2434444 | 2434444 | 2022-11-09 | US | West Virginia | Pendleton | 54071 | 2247 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-11-10 04:21:16 | Pendleton, West Virginia, US | |
483100 | 483100 | 2022-11-08 | US | West Virginia | Pendleton | 54071 | 2246 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-11-09 04:21:22 | Pendleton, West Virginia, US | |
2442250 | 2442250 | 2022-11-07 | US | West Virginia | Pendleton | 54071 | 2246 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-11-08 04:21:21 | Pendleton, West Virginia, US | |
1053348 | 1053348 | 2022-11-06 | US | West Virginia | Pendleton | 54071 | 2245 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-11-07 04:21:26 | Pendleton, West Virginia, US | |
621372 | 621372 | 2022-11-05 | US | West Virginia | Pendleton | 54071 | 2245 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-11-06 04:21:24 | Pendleton, West Virginia, US | |
1025876 | 1025876 | 2022-11-04 | US | West Virginia | Pendleton | 54071 | 2245 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-11-05 04:21:52 | Pendleton, West Virginia, US | |
434867 | 434867 | 2022-11-03 | US | West Virginia | Pendleton | 54071 | 2242 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-11-04 04:22:11 | Pendleton, West Virginia, US | |
853109 | 853109 | 2022-11-02 | US | West Virginia | Pendleton | 54071 | 2237 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-11-03 04:22:05 | Pendleton, West Virginia, US | |
713960 | 713960 | 2022-11-01 | US | West Virginia | Pendleton | 54071 | 2236 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-11-02 04:22:09 | Pendleton, West Virginia, US | |
3288409 | 3288409 | 2022-10-31 | US | West Virginia | Pendleton | 54071 | 2237 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-11-01 04:22:36 | Pendleton, West Virginia, US | |
323442 | 323442 | 2022-10-30 | US | West Virginia | Pendleton | 54071 | 2233 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-10-31 04:21:36 | Pendleton, West Virginia, US | |
915718 | 915718 | 2022-10-29 | US | West Virginia | Pendleton | 54071 | 2233 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-10-30 04:22:14 | Pendleton, 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]);