johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where province_or_state = "Shiga" sorted by latitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, recovered, latitude, longitude, last_update, day (date), last_update (date)
active 249 ✖
- 2 16
- 22 10
- 1 8
- 5 8
- 3 7
- 17 6
- 19 6
- 97 6
- 16 5
- 8 5
- 106 4
- 4 4
- 90 4
- 95 4
- 96 4
- 104 3
- 114 3
- 116 3
- 146 3
- 157 3
- 163 3
- 18 3
- 20 3
- 23 3
- 29 3
- 398 3
- 407 3
- 45 3
- 58 3
- 6 3
- 68 3
- 71 3
- 72 3
- 75 3
- 80 3
- 83 3
- 85 3
- 87 3
- 88 3
- 92 3
- 99 3
- 101 2
- 103 2
- 112 2
- 117 2
- 119 2
- 123 2
- 128 2
- 131 2
- 133 2
- 138 2
- 140 2
- 143 2
- 147 2
- 148 2
- 151 2
- 152 2
- 156 2
- 160 2
- 167 2
- 172 2
- 179 2
- 186 2
- 190 2
- 197 2
- 213 2
- 247 2
- 25 2
- 27 2
- 28 2
- 284 2
- 297 2
- 298 2
- 37 2
- 40 2
- 418 2
- 439 2
- 450 2
- 473 2
- 54 2
- 55 2
- 585 2
- 603 2
- 69 2
- 7 2
- 74 2
- 76 2
- 78 2
- 79 2
- 81 2
- 84 2
- 94 2
- 10 1
- 100 1
- 102 1
- 107 1
- 108 1
- 109 1
- 110 1
- 111 1
- 113 1
- 121 1
- 124 1
- 127 1
- 129 1
- 13 1
- 134 1
- 135 1
- 137 1
- 139 1
- 142 1
- 149 1
- 15 1
- 155 1
- 162 1
- 164 1
- 165 1
- 166 1
- 168 1
- 176 1
- 178 1
- 181 1
- 185 1
- 187 1
- 188 1
- 189 1
- 191 1
- 195 1
- 203 1
- 205 1
- 206 1
- 21 1
- 211 1
- 215 1
- 221 1
- 223 1
- 227 1
- 229 1
- 231 1
- 232 1
- 233 1
- 236 1
- 24 1
- 244 1
- 250 1
- 253 1
- 255 1
- 26 1
- 261 1
- 265 1
- 266 1
- 270 1
- 271 1
- 274 1
- 277 1
- 30 1
- 302 1
- 305 1
- 308 1
- 316 1
- 320 1
- 332 1
- 339 1
- 340 1
- 341 1
- 35 1
- 356 1
- 360 1
- 366 1
- 373 1
- 378 1
- 38 1
- 381 1
- 382 1
- 39 1
- 403 1
- 405 1
- 410 1
- 412 1
- 413 1
- 415 1
- 42 1
- 424 1
- 426 1
- 427 1
- 430 1
- 435 1
- 437 1
- 443 1
- 446 1
- 449 1
- 455 1
- 459 1
- 46 1
- 461 1
- 467 1
- 47 1
- 470 1
- 474 1
- 478 1
- 48 1
- 482 1
- 483 1
- 484 1
- 487 1
- 489 1
- 491 1
- 495 1
- 50 1
- 501 1
- 506 1
- 51 1
- 515 1
- 52 1
- 520 1
- 526 1
- 531 1
- 534 1
- 544 1
- 546 1
- 569 1
- 576 1
- 577 1
- 580 1
- 586 1
- 587 1
- 59 1
- 594 1
- 596 1
- 602 1
- 605 1
- 613 1
- 614 1
- 617 1
- 628 1
- 638 1
- 64 1
- 644 1
- 65 1
- 659 1
- 66 1
- 699 1
- 70 1
- 73 1
- 77 1
- 82 1
- 89 1
- 91 1
- 98 1
province_or_state 1
- Shiga · 946 ✖
country_or_region 1
- Japan 946
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude ▼ | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
63082 | 63082 | 2022-11-12 | Japan | Shiga | 254861 | 372 | 0 | 35.215827 | 136.138064 | 2022-11-13 04:21:14 | Shiga, Japan | |||
91162 | 91162 | 2022-07-23 | Japan | Shiga | 112068 | 225 | 0 | 35.215827 | 136.138064 | 2022-07-24 04:20:47 | Shiga, Japan | |||
114772 | 114772 | 2022-09-06 | Japan | Shiga | 211198 | 294 | 0 | 35.215827 | 136.138064 | 2022-09-07 04:20:59 | Shiga, Japan | |||
130770 | 130770 | 2022-10-04 | Japan | Shiga | 235255 | 326 | 0 | 35.215827 | 136.138064 | 2022-10-05 04:23:06 | Shiga, Japan | |||
142008 | 142008 | 2022-07-09 | Japan | Shiga | 98000 | 222 | 0 | 35.215827 | 136.138064 | 2022-07-10 04:20:54 | Shiga, Japan | |||
166065 | 166065 | 2022-06-21 | Japan | Shiga | 93972 | 221 | 0 | 35.215827 | 136.138064 | 2022-06-22 04:20:54 | Shiga, Japan | |||
198279 | 198279 | 2022-10-19 | Japan | Shiga | 241137 | 346 | 0 | 35.215827 | 136.138064 | 2022-10-20 04:22:59 | Shiga, Japan | |||
218000 | 218000 | 2022-12-26 | Japan | Shiga | 312408 | 466 | 0 | 35.215827 | 136.138064 | 2022-12-27 04:21:07 | Shiga, Japan | |||
222016 | 222016 | 2022-05-09 | Japan | Shiga | 83230 | 214 | 0 | 35.215827 | 136.138064 | 2022-05-10 04:20:50 | Shiga, Japan | |||
229247 | 229247 | 2022-05-31 | Japan | Shiga | 90742 | 219 | 0 | 35.215827 | 136.138064 | 2022-06-01 04:20:55 | Shiga, Japan | |||
253334 | 253334 | 2022-09-08 | Japan | Shiga | 214430 | 297 | 0 | 35.215827 | 136.138064 | 2022-09-09 04:21:11 | Shiga, Japan | |||
257350 | 257350 | 2022-12-10 | Japan | Shiga | 285690 | 415 | 0 | 35.215827 | 136.138064 | 2022-12-11 04:20:50 | Shiga, Japan | |||
292033 | 292033 | 2022-11-15 | Japan | Shiga | 256837 | 371 | 0 | 35.215827 | 136.138064 | 2022-11-16 04:21:09 | Shiga, Japan | |||
307905 | 307905 | 2022-12-13 | Japan | Shiga | 289835 | 416 | 0 | 35.215827 | 136.138064 | 2022-12-14 04:21:04 | Shiga, Japan | |||
311921 | 311921 | 2022-11-13 | Japan | Shiga | 255511 | 372 | 0 | 35.215827 | 136.138064 | 2022-11-14 04:21:09 | Shiga, Japan | |||
319953 | 319953 | 2022-10-30 | Japan | Shiga | 245827 | 366 | 0 | 35.215827 | 136.138064 | 2022-10-31 04:21:36 | Shiga, Japan | |||
327927 | 327927 | 2022-12-27 | Japan | Shiga | 315127 | 469 | 0 | 35.215827 | 136.138064 | 2022-12-28 04:21:04 | Shiga, Japan | |||
348317 | 348317 | 2022-12-14 | Japan | Shiga | 292105 | 418 | 0 | 35.215827 | 136.138064 | 2022-12-15 04:20:58 | Shiga, Japan | |||
360363 | 360363 | 2022-05-07 | Japan | Shiga | 82478 | 213 | 0 | 35.215827 | 136.138064 | 2022-05-08 04:20:49 | Shiga, Japan | |||
372217 | 372217 | 2022-09-13 | Japan | Shiga | 220348 | 302 | 0 | 35.215827 | 136.138064 | 2022-09-14 04:20:44 | Shiga, Japan | |||
384244 | 384244 | 2022-09-23 | Japan | Shiga | 229743 | 311 | 0 | 35.215827 | 136.138064 | 2022-09-24 04:21:40 | Shiga, Japan | |||
396285 | 396285 | 2022-10-07 | Japan | Shiga | 236489 | 333 | 0 | 35.215827 | 136.138064 | 2022-10-08 04:22:56 | Shiga, Japan | |||
419356 | 419356 | 2022-09-18 | Japan | Shiga | 225646 | 307 | 0 | 35.215827 | 136.138064 | 2022-09-19 04:21:49 | Shiga, Japan | |||
431378 | 431378 | 2022-11-03 | Japan | Shiga | 248416 | 369 | 0 | 35.215827 | 136.138064 | 2022-11-04 04:22:11 | Shiga, Japan | |||
451408 | 451408 | 2022-12-21 | Japan | Shiga | 304250 | 443 | 0 | 35.215827 | 136.138064 | 2022-12-22 04:20:56 | Shiga, Japan | |||
463417 | 463417 | 2022-05-02 | Japan | Shiga | 81380 | 213 | 0 | 35.215827 | 136.138064 | 2022-05-03 04:21:00 | Shiga, Japan | |||
475463 | 475463 | 2022-06-26 | Japan | Shiga | 94794 | 221 | 0 | 35.215827 | 136.138064 | 2022-06-27 04:21:00 | Shiga, Japan | |||
479611 | 479611 | 2022-11-08 | Japan | Shiga | 251565 | 370 | 0 | 35.215827 | 136.138064 | 2022-11-09 04:21:22 | Shiga, Japan | |||
487641 | 487641 | 2022-11-25 | Japan | Shiga | 266550 | 378 | 0 | 35.215827 | 136.138064 | 2022-11-26 04:21:11 | Shiga, Japan | |||
503705 | 503705 | 2022-12-17 | Japan | Shiga | 297349 | 429 | 0 | 35.215827 | 136.138064 | 2022-12-18 04:21:03 | Shiga, Japan | |||
515749 | 515749 | 2022-10-15 | Japan | Shiga | 239495 | 342 | 0 | 35.215827 | 136.138064 | 2022-10-16 04:22:39 | Shiga, Japan | |||
538773 | 538773 | 2022-10-26 | Japan | Shiga | 243866 | 362 | 0 | 35.215827 | 136.138064 | 2022-10-27 04:22:01 | Shiga, Japan | |||
542789 | 542789 | 2022-12-15 | Japan | Shiga | 293893 | 422 | 0 | 35.215827 | 136.138064 | 2022-12-16 04:21:01 | Shiga, Japan | |||
558827 | 558827 | 2022-06-16 | Japan | Shiga | 93261 | 221 | 0 | 35.215827 | 136.138064 | 2022-06-17 04:20:56 | Shiga, Japan | |||
593679 | 593679 | 2022-07-01 | Japan | Shiga | 95581 | 221 | 0 | 35.215827 | 136.138064 | 2022-07-02 04:21:16 | Shiga, Japan | |||
617883 | 617883 | 2022-11-05 | Japan | Shiga | 249662 | 370 | 0 | 35.215827 | 136.138064 | 2022-11-06 04:21:24 | Shiga, Japan | |||
621899 | 621899 | 2022-05-22 | Japan | Shiga | 89052 | 219 | 0 | 35.215827 | 136.138064 | 2022-05-26 04:20:50 | Shiga, Japan | |||
629929 | 629929 | 2022-07-12 | Japan | Shiga | 99949 | 222 | 0 | 35.215827 | 136.138064 | 2022-07-13 04:20:58 | Shiga, Japan | |||
658335 | 658335 | 2022-05-13 | Japan | Shiga | 84969 | 217 | 0 | 35.215827 | 136.138064 | 2022-05-14 04:20:48 | Shiga, Japan | |||
666314 | 666314 | 2020-09-16 | Japan | Shiga | 474 | 7 | 432 | 35 | 35.215827 | 136.138064 | 2020-09-17 04:22:00 | Shiga, Japan | ||
670320 | 670320 | 2022-07-21 | Japan | Shiga | 109065 | 224 | 0 | 35.215827 | 136.138064 | 2022-07-22 04:21:15 | Shiga, Japan | |||
674336 | 674336 | 2022-07-30 | Japan | Shiga | 125409 | 232 | 0 | 35.215827 | 136.138064 | 2022-07-31 04:21:02 | Shiga, Japan | |||
690394 | 690394 | 2022-12-23 | Japan | Shiga | 308234 | 453 | 0 | 35.215827 | 136.138064 | 2022-12-24 04:21:02 | Shiga, Japan | |||
710471 | 710471 | 2022-11-01 | Japan | Shiga | 246869 | 366 | 0 | 35.215827 | 136.138064 | 2022-11-02 04:22:09 | Shiga, Japan | |||
718503 | 718503 | 2022-12-04 | Japan | Shiga | 277281 | 398 | 0 | 35.215827 | 136.138064 | 2022-12-05 04:20:58 | Shiga, Japan | |||
794435 | 794435 | 2022-10-24 | Japan | Shiga | 242692 | 357 | 0 | 35.215827 | 136.138064 | 2022-10-25 04:21:53 | Shiga, Japan | |||
833648 | 833648 | 2022-12-02 | Japan | Shiga | 275151 | 389 | 0 | 35.215827 | 136.138064 | 2022-12-03 04:21:02 | Shiga, Japan | |||
849620 | 849620 | 2022-11-02 | Japan | Shiga | 247638 | 367 | 0 | 35.215827 | 136.138064 | 2022-11-03 04:22:05 | Shiga, Japan | |||
853636 | 853636 | 2022-09-30 | Japan | Shiga | 233624 | 323 | 0 | 35.215827 | 136.138064 | 2022-10-01 04:23:01 | Shiga, Japan | |||
868820 | 868820 | 2022-12-11 | Japan | Shiga | 286870 | 415 | 0 | 35.215827 | 136.138064 | 2022-12-12 04:21:01 | Shiga, Japan | |||
880301 | 880301 | 2022-08-05 | Japan | Shiga | 141034 | 235 | 0 | 35.215827 | 136.138064 | 2022-08-06 04:20:56 | Shiga, Japan | |||
896168 | 896168 | 2022-07-24 | Japan | Shiga | 113574 | 225 | 0 | 35.215827 | 136.138064 | 2022-07-25 04:20:51 | Shiga, Japan | |||
900184 | 900184 | 2022-07-22 | Japan | Shiga | 110825 | 225 | 0 | 35.215827 | 136.138064 | 2022-07-23 04:20:53 | Shiga, Japan | |||
912229 | 912229 | 2022-10-29 | Japan | Shiga | 245421 | 366 | 0 | 35.215827 | 136.138064 | 2022-10-30 04:22:14 | Shiga, Japan | |||
938838 | 938838 | 2022-06-25 | Japan | Shiga | 94679 | 221 | 0 | 35.215827 | 136.138064 | 2022-06-26 04:21:02 | Shiga, Japan | |||
946870 | 946870 | 2022-06-14 | Japan | Shiga | 92941 | 220 | 0 | 35.215827 | 136.138064 | 2022-06-15 04:20:54 | Shiga, Japan | |||
958916 | 958916 | 2022-07-19 | Japan | Shiga | 106388 | 223 | 0 | 35.215827 | 136.138064 | 2022-07-20 04:20:59 | Shiga, Japan | |||
962932 | 962932 | 2022-09-09 | Japan | Shiga | 215833 | 297 | 0 | 35.215827 | 136.138064 | 2022-09-10 04:21:10 | Shiga, Japan | |||
970940 | 970940 | 2022-06-01 | Japan | Shiga | 90937 | 219 | 0 | 35.215827 | 136.138064 | 2022-06-02 05:20:39 | Shiga, Japan | |||
991015 | 991015 | 2022-08-16 | Japan | Shiga | 166097 | 259 | 0 | 35.215827 | 136.138064 | 2022-08-17 04:20:59 | Shiga, Japan | |||
1018371 | 1018371 | 2022-12-24 | Japan | Shiga | 310247 | 458 | 0 | 35.215827 | 136.138064 | 2022-12-25 04:21:04 | Shiga, Japan | |||
1022387 | 1022387 | 2022-11-04 | Japan | Shiga | 248691 | 370 | 0 | 35.215827 | 136.138064 | 2022-11-05 04:21:52 | Shiga, Japan | |||
1049859 | 1049859 | 2022-11-06 | Japan | Shiga | 250241 | 370 | 0 | 35.215827 | 136.138064 | 2022-11-07 04:21:26 | Shiga, Japan | |||
1065898 | 1065898 | 2022-07-28 | Japan | Shiga | 120926 | 228 | 0 | 35.215827 | 136.138064 | 2022-07-29 04:20:45 | Shiga, Japan | |||
1069914 | 1069914 | 2022-08-07 | Japan | Shiga | 145960 | 237 | 0 | 35.215827 | 136.138064 | 2022-08-08 04:21:08 | Shiga, Japan | |||
1073930 | 1073930 | 2022-12-28 | Japan | Shiga | 317348 | 473 | 0 | 35.215827 | 136.138064 | 2022-12-29 04:21:01 | Shiga, Japan | |||
1086096 | 1086096 | 2022-08-09 | Japan | Shiga | 150170 | 244 | 0 | 35.215827 | 136.138064 | 2022-08-10 04:20:57 | Shiga, Japan | |||
1098139 | 1098139 | 2022-08-03 | Japan | Shiga | 135412 | 234 | 0 | 35.215827 | 136.138064 | 2022-08-04 04:20:58 | Shiga, Japan | |||
1109595 | 1109595 | 2022-05-21 | Japan | Shiga | 87880 | 219 | 0 | 35.215827 | 136.138064 | 2022-05-22 04:20:52 | Shiga, Japan | |||
1121625 | 1121625 | 2020-09-17 | Japan | Shiga | 475 | 7 | 439 | 29 | 35.215827 | 136.138064 | 2020-09-18 05:05:00 | Shiga, Japan | ||
1148966 | 1148966 | 2022-12-12 | Japan | Shiga | 287444 | 416 | 0 | 35.215827 | 136.138064 | 2022-12-13 04:21:01 | Shiga, Japan | |||
1157173 | 1157173 | 2022-04-29 | Japan | Shiga | 80789 | 213 | 0 | 35.215827 | 136.138064 | 2022-04-30 04:21:05 | Shiga, Japan | |||
1161189 | 1161189 | 2022-08-18 | Japan | Shiga | 170588 | 263 | 0 | 35.215827 | 136.138064 | 2022-08-19 04:20:54 | Shiga, Japan | |||
1169219 | 1169219 | 2022-05-20 | Japan | Shiga | 87398 | 219 | 0 | 35.215827 | 136.138064 | 2022-05-21 04:20:58 | Shiga, Japan | |||
1184766 | 1184766 | 2022-05-18 | Japan | Shiga | 86594 | 217 | 0 | 35.215827 | 136.138064 | 2022-05-19 04:20:54 | Shiga, Japan | |||
1199828 | 1199828 | 2022-07-06 | Japan | Shiga | 96911 | 221 | 0 | 35.215827 | 136.138064 | 2022-07-07 04:20:55 | Shiga, Japan | |||
1211573 | 1211573 | 2022-07-11 | Japan | Shiga | 99209 | 222 | 0 | 35.215827 | 136.138064 | 2022-07-12 04:20:51 | Shiga, Japan | |||
1239682 | 1239682 | 2022-11-28 | Japan | Shiga | 269598 | 378 | 0 | 35.215827 | 136.138064 | 2022-11-29 04:21:05 | Shiga, Japan | |||
1250778 | 1250778 | 2022-08-23 | Japan | Shiga | 184009 | 275 | 0 | 35.215827 | 136.138064 | 2022-08-24 04:20:46 | Shiga, Japan | |||
1314220 | 1314220 | 2022-05-27 | Japan | Shiga | 89778 | 219 | 0 | 35.215827 | 136.138064 | 2022-05-28 04:21:07 | Shiga, Japan | |||
1346341 | 1346341 | 2022-08-10 | Japan | Shiga | 152748 | 248 | 0 | 35.215827 | 136.138064 | 2022-08-11 04:20:49 | Shiga, Japan | |||
1366498 | 1366498 | 2022-10-28 | Japan | Shiga | 244909 | 366 | 0 | 35.215827 | 136.138064 | 2022-10-29 04:21:13 | Shiga, Japan | |||
1370514 | 1370514 | 2022-09-21 | Japan | Shiga | 227843 | 309 | 0 | 35.215827 | 136.138064 | 2022-09-22 04:22:56 | Shiga, Japan | |||
1393698 | 1393698 | 2022-09-02 | Japan | Shiga | 205865 | 289 | 0 | 35.215827 | 136.138064 | 2022-09-03 04:21:04 | Shiga, Japan | |||
1397714 | 1397714 | 2022-05-06 | Japan | Shiga | 82133 | 213 | 0 | 35.215827 | 136.138064 | 2022-05-07 04:21:09 | Shiga, Japan | |||
1405064 | 1405064 | 2022-08-02 | Japan | Shiga | 133174 | 234 | 0 | 35.215827 | 136.138064 | 2022-08-03 04:20:59 | Shiga, Japan | |||
1417108 | 1417108 | 2022-07-08 | Japan | Shiga | 97648 | 222 | 0 | 35.215827 | 136.138064 | 2022-07-09 04:20:59 | Shiga, Japan | |||
1421124 | 1421124 | 2022-06-08 | Japan | Shiga | 92069 | 219 | 0 | 35.215827 | 136.138064 | 2022-06-09 04:20:54 | Shiga, Japan | |||
1487607 | 1487607 | 2022-07-26 | Japan | Shiga | 116527 | 225 | 0 | 35.215827 | 136.138064 | 2022-07-27 04:21:04 | Shiga, Japan | |||
1503620 | 1503620 | 2022-05-16 | Japan | Shiga | 85867 | 217 | 0 | 35.215827 | 136.138064 | 2022-05-17 04:20:59 | Shiga, Japan | |||
1531949 | 1531949 | 2022-08-26 | Japan | Shiga | 192299 | 284 | 0 | 35.215827 | 136.138064 | 2022-08-27 04:20:57 | Shiga, Japan | |||
1560113 | 1560113 | 2022-09-28 | Japan | Shiga | 232650 | 319 | 0 | 35.215827 | 136.138064 | 2022-09-29 04:22:34 | Shiga, Japan | |||
1572157 | 1572157 | 2022-05-03 | Japan | Shiga | 81625 | 213 | 0 | 35.215827 | 136.138064 | 2022-05-04 04:20:59 | Shiga, Japan | |||
1592228 | 1592228 | 2022-10-21 | Japan | Shiga | 241871 | 349 | 0 | 35.215827 | 136.138064 | 2022-10-22 04:22:53 | Shiga, Japan | |||
1608283 | 1608283 | 2022-07-20 | Japan | Shiga | 107754 | 224 | 0 | 35.215827 | 136.138064 | 2022-07-21 04:21:10 | Shiga, Japan | |||
1620294 | 1620294 | 2022-11-22 | Japan | Shiga | 262948 | 376 | 0 | 35.215827 | 136.138064 | 2022-11-23 04:21:06 | Shiga, Japan | |||
1624310 | 1624310 | 2022-09-22 | Japan | Shiga | 228888 | 311 | 0 | 35.215827 | 136.138064 | 2022-09-23 04:23:13 | Shiga, Japan | |||
1628326 | 1628326 | 2022-12-18 | Japan | Shiga | 298723 | 433 | 0 | 35.215827 | 136.138064 | 2022-12-19 04:21:03 | Shiga, Japan | |||
1640367 | 1640367 | 2022-11-20 | Japan | Shiga | 261123 | 375 | 0 | 35.215827 | 136.138064 | 2022-11-21 04:21:05 | Shiga, Japan | |||
1648399 | 1648399 | 2022-06-23 | Japan | Shiga | 94330 | 221 | 0 | 35.215827 | 136.138064 | 2022-06-24 04:20:58 | Shiga, Japan |
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]);