johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where province_or_state = "Shiga" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: recovered, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2752924 | 2752924 | 2022-12-29 | Japan | Shiga | 319554 | 476 | 0 | 35.215827 | 136.138064 | 2022-12-30 04:21:04 | Shiga, Japan | |||
1073930 | 1073930 | 2022-12-28 | Japan | Shiga | 317348 | 473 | 0 | 35.215827 | 136.138064 | 2022-12-29 04:21:01 | Shiga, Japan | |||
327927 | 327927 | 2022-12-27 | Japan | Shiga | 315127 | 469 | 0 | 35.215827 | 136.138064 | 2022-12-28 04:21:04 | Shiga, Japan | |||
218000 | 218000 | 2022-12-26 | Japan | Shiga | 312408 | 466 | 0 | 35.215827 | 136.138064 | 2022-12-27 04:21:07 | Shiga, Japan | |||
3222457 | 3222457 | 2022-12-25 | Japan | Shiga | 311724 | 463 | 0 | 35.215827 | 136.138064 | 2022-12-26 04:21:06 | Shiga, Japan | |||
1018371 | 1018371 | 2022-12-24 | Japan | Shiga | 310247 | 458 | 0 | 35.215827 | 136.138064 | 2022-12-25 04:21:04 | Shiga, Japan | |||
690394 | 690394 | 2022-12-23 | Japan | Shiga | 308234 | 453 | 0 | 35.215827 | 136.138064 | 2022-12-24 04:21:02 | Shiga, Japan | |||
2179604 | 2179604 | 2022-12-22 | Japan | Shiga | 306289 | 448 | 0 | 35.215827 | 136.138064 | 2022-12-23 04:21:04 | Shiga, Japan | |||
451408 | 451408 | 2022-12-21 | Japan | Shiga | 304250 | 443 | 0 | 35.215827 | 136.138064 | 2022-12-22 04:20:56 | Shiga, Japan | |||
2951407 | 2951407 | 2022-12-20 | Japan | Shiga | 301747 | 438 | 0 | 35.215827 | 136.138064 | 2022-12-21 04:21:03 | Shiga, Japan | |||
3173809 | 3173809 | 2022-12-19 | Japan | Shiga | 299310 | 436 | 0 | 35.215827 | 136.138064 | 2022-12-20 04:21:04 | Shiga, Japan | |||
1628326 | 1628326 | 2022-12-18 | Japan | Shiga | 298723 | 433 | 0 | 35.215827 | 136.138064 | 2022-12-19 04:21:03 | Shiga, Japan | |||
503705 | 503705 | 2022-12-17 | Japan | Shiga | 297349 | 429 | 0 | 35.215827 | 136.138064 | 2022-12-18 04:21:03 | Shiga, Japan | |||
3324277 | 3324277 | 2022-12-16 | Japan | Shiga | 295403 | 426 | 0 | 35.215827 | 136.138064 | 2022-12-17 04:21:04 | Shiga, Japan | |||
542789 | 542789 | 2022-12-15 | Japan | Shiga | 293893 | 422 | 0 | 35.215827 | 136.138064 | 2022-12-16 04:21:01 | Shiga, Japan | |||
348317 | 348317 | 2022-12-14 | Japan | Shiga | 292105 | 418 | 0 | 35.215827 | 136.138064 | 2022-12-15 04:20:58 | Shiga, Japan | |||
307905 | 307905 | 2022-12-13 | Japan | Shiga | 289835 | 416 | 0 | 35.215827 | 136.138064 | 2022-12-14 04:21:04 | Shiga, Japan | |||
1148966 | 1148966 | 2022-12-12 | Japan | Shiga | 287444 | 416 | 0 | 35.215827 | 136.138064 | 2022-12-13 04:21: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 | |||
257350 | 257350 | 2022-12-10 | Japan | Shiga | 285690 | 415 | 0 | 35.215827 | 136.138064 | 2022-12-11 04:20:50 | Shiga, Japan | |||
3936064 | 3936064 | 2022-12-09 | Japan | Shiga | 283947 | 415 | 0 | 35.215827 | 136.138064 | 2022-12-10 04:21:02 | Shiga, Japan | |||
3377396 | 3377396 | 2022-12-08 | Japan | Shiga | 282581 | 410 | 0 | 35.215827 | 136.138064 | 2022-12-09 04:21:05 | Shiga, Japan | |||
1984667 | 1984667 | 2022-12-07 | Japan | Shiga | 281053 | 409 | 0 | 35.215827 | 136.138064 | 2022-12-08 04:21:07 | Shiga, Japan | |||
3714190 | 3714190 | 2022-12-06 | Japan | Shiga | 279208 | 406 | 0 | 35.215827 | 136.138064 | 2022-12-07 04:20:58 | Shiga, Japan | |||
2414895 | 2414895 | 2022-12-05 | Japan | Shiga | 277596 | 403 | 0 | 35.215827 | 136.138064 | 2022-12-06 04:21:03 | Shiga, Japan | |||
718503 | 718503 | 2022-12-04 | Japan | Shiga | 277281 | 398 | 0 | 35.215827 | 136.138064 | 2022-12-05 04:20:58 | Shiga, Japan | |||
2816792 | 2816792 | 2022-12-03 | Japan | Shiga | 276218 | 393 | 0 | 35.215827 | 136.138064 | 2022-12-04 04:20:56 | Shiga, Japan | |||
833648 | 833648 | 2022-12-02 | Japan | Shiga | 275151 | 389 | 0 | 35.215827 | 136.138064 | 2022-12-03 04:21:02 | Shiga, Japan | |||
2136178 | 2136178 | 2022-12-01 | Japan | Shiga | 274042 | 384 | 0 | 35.215827 | 136.138064 | 2022-12-02 04:21:07 | Shiga, Japan | |||
1964594 | 1964594 | 2022-11-30 | Japan | Shiga | 272757 | 380 | 0 | 35.215827 | 136.138064 | 2022-12-01 04:21:03 | Shiga, Japan | |||
2556608 | 2556608 | 2022-11-29 | Japan | Shiga | 271263 | 379 | 0 | 35.215827 | 136.138064 | 2022-11-30 04:21:07 | Shiga, Japan | |||
1239682 | 1239682 | 2022-11-28 | Japan | Shiga | 269598 | 378 | 0 | 35.215827 | 136.138064 | 2022-11-29 04:21:05 | Shiga, Japan | |||
3551670 | 3551670 | 2022-11-27 | Japan | Shiga | 269186 | 378 | 0 | 35.215827 | 136.138064 | 2022-11-28 04:21:02 | Shiga, Japan | |||
2100150 | 2100150 | 2022-11-26 | Japan | Shiga | 268160 | 378 | 0 | 35.215827 | 136.138064 | 2022-11-27 04:21:05 | Shiga, Japan | |||
487641 | 487641 | 2022-11-25 | Japan | Shiga | 266550 | 378 | 0 | 35.215827 | 136.138064 | 2022-11-26 04:21:11 | Shiga, Japan | |||
3523470 | 3523470 | 2022-11-24 | Japan | Shiga | 265035 | 377 | 0 | 35.215827 | 136.138064 | 2022-11-25 04:21:06 | Shiga, Japan | |||
3312253 | 3312253 | 2022-11-23 | Japan | Shiga | 264438 | 377 | 0 | 35.215827 | 136.138064 | 2022-11-24 04:21:09 | Shiga, Japan | |||
1620294 | 1620294 | 2022-11-22 | Japan | Shiga | 262948 | 376 | 0 | 35.215827 | 136.138064 | 2022-11-23 04:21:06 | Shiga, Japan | |||
3460182 | 3460182 | 2022-11-21 | Japan | Shiga | 261471 | 376 | 0 | 35.215827 | 136.138064 | 2022-11-22 04:20:47 | Shiga, Japan | |||
1640367 | 1640367 | 2022-11-20 | Japan | Shiga | 261123 | 375 | 0 | 35.215827 | 136.138064 | 2022-11-21 04:21:05 | Shiga, Japan | |||
2063924 | 2063924 | 2022-11-19 | Japan | Shiga | 260383 | 375 | 0 | 35.215827 | 136.138064 | 2022-11-20 04:21:08 | Shiga, Japan | |||
1755318 | 1755318 | 2022-11-18 | Japan | Shiga | 259421 | 373 | 0 | 35.215827 | 136.138064 | 2022-11-19 04:21:14 | Shiga, Japan | |||
3026311 | 3026311 | 2022-11-17 | Japan | Shiga | 258684 | 373 | 0 | 35.215827 | 136.138064 | 2022-11-18 04:21:15 | Shiga, Japan | |||
2486022 | 2486022 | 2022-11-16 | Japan | Shiga | 257793 | 372 | 0 | 35.215827 | 136.138064 | 2022-11-17 04:21:11 | Shiga, Japan | |||
292033 | 292033 | 2022-11-15 | Japan | Shiga | 256837 | 371 | 0 | 35.215827 | 136.138064 | 2022-11-16 04:21:09 | Shiga, Japan | |||
3597063 | 3597063 | 2022-11-14 | Japan | Shiga | 255755 | 372 | 0 | 35.215827 | 136.138064 | 2022-11-15 04:21:16 | Shiga, Japan | |||
311921 | 311921 | 2022-11-13 | Japan | Shiga | 255511 | 372 | 0 | 35.215827 | 136.138064 | 2022-11-14 04:21:09 | Shiga, Japan | |||
63082 | 63082 | 2022-11-12 | Japan | Shiga | 254861 | 372 | 0 | 35.215827 | 136.138064 | 2022-11-13 04:21:14 | Shiga, Japan | |||
2927244 | 2927244 | 2022-11-11 | Japan | Shiga | 253949 | 372 | 0 | 35.215827 | 136.138064 | 2022-11-12 04:20:41 | Shiga, Japan | |||
2506080 | 2506080 | 2022-11-10 | Japan | Shiga | 253252 | 371 | 0 | 35.215827 | 136.138064 | 2022-11-11 04:21:22 | Shiga, Japan | |||
2430955 | 2430955 | 2022-11-09 | Japan | Shiga | 252455 | 371 | 0 | 35.215827 | 136.138064 | 2022-11-10 04:21:16 | Shiga, Japan | |||
479611 | 479611 | 2022-11-08 | Japan | Shiga | 251565 | 370 | 0 | 35.215827 | 136.138064 | 2022-11-09 04:21:22 | Shiga, Japan | |||
2438761 | 2438761 | 2022-11-07 | Japan | Shiga | 250475 | 370 | 0 | 35.215827 | 136.138064 | 2022-11-08 04:21:21 | Shiga, Japan | |||
1049859 | 1049859 | 2022-11-06 | Japan | Shiga | 250241 | 370 | 0 | 35.215827 | 136.138064 | 2022-11-07 04:21:26 | Shiga, Japan | |||
617883 | 617883 | 2022-11-05 | Japan | Shiga | 249662 | 370 | 0 | 35.215827 | 136.138064 | 2022-11-06 04:21:24 | Shiga, Japan | |||
1022387 | 1022387 | 2022-11-04 | Japan | Shiga | 248691 | 370 | 0 | 35.215827 | 136.138064 | 2022-11-05 04:21:52 | Shiga, Japan | |||
431378 | 431378 | 2022-11-03 | Japan | Shiga | 248416 | 369 | 0 | 35.215827 | 136.138064 | 2022-11-04 04:22:11 | Shiga, Japan | |||
849620 | 849620 | 2022-11-02 | Japan | Shiga | 247638 | 367 | 0 | 35.215827 | 136.138064 | 2022-11-03 04:22:05 | Shiga, Japan | |||
710471 | 710471 | 2022-11-01 | Japan | Shiga | 246869 | 366 | 0 | 35.215827 | 136.138064 | 2022-11-02 04:22:09 | Shiga, Japan | |||
3284920 | 3284920 | 2022-10-31 | Japan | Shiga | 246038 | 366 | 0 | 35.215827 | 136.138064 | 2022-11-01 04:22:36 | Shiga, Japan | |||
319953 | 319953 | 2022-10-30 | Japan | Shiga | 245827 | 366 | 0 | 35.215827 | 136.138064 | 2022-10-31 04:21:36 | Shiga, Japan | |||
912229 | 912229 | 2022-10-29 | Japan | Shiga | 245421 | 366 | 0 | 35.215827 | 136.138064 | 2022-10-30 04:22:14 | Shiga, Japan | |||
1366498 | 1366498 | 2022-10-28 | Japan | Shiga | 244909 | 366 | 0 | 35.215827 | 136.138064 | 2022-10-29 04:21:13 | Shiga, Japan | |||
3038353 | 3038353 | 2022-10-27 | Japan | Shiga | 244528 | 365 | 0 | 35.215827 | 136.138064 | 2022-10-28 04:22:31 | Shiga, Japan | |||
538773 | 538773 | 2022-10-26 | Japan | Shiga | 243866 | 362 | 0 | 35.215827 | 136.138064 | 2022-10-27 04:22:01 | Shiga, Japan | |||
1830174 | 1830174 | 2022-10-25 | Japan | Shiga | 243322 | 359 | 0 | 35.215827 | 136.138064 | 2022-10-26 04:22:19 | Shiga, Japan | |||
794435 | 794435 | 2022-10-24 | Japan | Shiga | 242692 | 357 | 0 | 35.215827 | 136.138064 | 2022-10-25 04:21:53 | Shiga, Japan | |||
3276890 | 3276890 | 2022-10-23 | Japan | Shiga | 242530 | 353 | 0 | 35.215827 | 136.138064 | 2022-10-24 04:22:29 | Shiga, Japan | |||
2267928 | 2267928 | 2022-10-22 | Japan | Shiga | 242216 | 349 | 0 | 35.215827 | 136.138064 | 2022-10-23 04:22:46 | Shiga, Japan | |||
1592228 | 1592228 | 2022-10-21 | Japan | Shiga | 241871 | 349 | 0 | 35.215827 | 136.138064 | 2022-10-22 04:22:53 | Shiga, Japan | |||
2271944 | 2271944 | 2022-10-20 | Japan | Shiga | 241565 | 347 | 0 | 35.215827 | 136.138064 | 2022-10-21 04:22:23 | Shiga, Japan | |||
198279 | 198279 | 2022-10-19 | Japan | Shiga | 241137 | 346 | 0 | 35.215827 | 136.138064 | 2022-10-20 04:22:59 | Shiga, Japan | |||
2756940 | 2756940 | 2022-10-18 | Japan | Shiga | 240564 | 343 | 0 | 35.215827 | 136.138064 | 2022-10-19 04:22:26 | Shiga, Japan | |||
2024774 | 2024774 | 2022-10-17 | Japan | Shiga | 239990 | 343 | 0 | 35.215827 | 136.138064 | 2022-10-18 04:22:42 | Shiga, Japan | |||
2159552 | 2159552 | 2022-10-16 | Japan | Shiga | 239831 | 343 | 0 | 35.215827 | 136.138064 | 2022-10-17 04:20:31 | Shiga, Japan | |||
515749 | 515749 | 2022-10-15 | Japan | Shiga | 239495 | 342 | 0 | 35.215827 | 136.138064 | 2022-10-16 04:22:39 | Shiga, Japan | |||
2032806 | 2032806 | 2022-10-14 | Japan | Shiga | 239015 | 341 | 0 | 35.215827 | 136.138064 | 2022-10-15 04:22:00 | Shiga, Japan | |||
3753494 | 3753494 | 2022-10-13 | Japan | Shiga | 238557 | 338 | 0 | 35.215827 | 136.138064 | 2022-10-14 04:22:28 | Shiga, Japan | |||
3214319 | 3214319 | 2022-10-12 | Japan | Shiga | 238024 | 337 | 0 | 35.215827 | 136.138064 | 2022-10-13 04:22:39 | Shiga, Japan | |||
3250168 | 3250168 | 2022-10-11 | Japan | Shiga | 237325 | 334 | 0 | 35.215827 | 136.138064 | 2022-10-12 04:22:51 | Shiga, Japan | |||
2967427 | 2967427 | 2022-10-10 | Japan | Shiga | 237206 | 333 | 0 | 35.215827 | 136.138064 | 2022-10-11 04:23:05 | Shiga, Japan | |||
3097463 | 3097463 | 2022-10-09 | Japan | Shiga | 237072 | 333 | 0 | 35.215827 | 136.138064 | 2022-10-10 04:22:32 | Shiga, Japan | |||
4002688 | 4002688 | 2022-10-08 | Japan | Shiga | 236804 | 333 | 0 | 35.215827 | 136.138064 | 2022-10-09 04:21:16 | Shiga, Japan | |||
396285 | 396285 | 2022-10-07 | Japan | Shiga | 236489 | 333 | 0 | 35.215827 | 136.138064 | 2022-10-08 04:22:56 | Shiga, Japan | |||
2529402 | 2529402 | 2022-10-06 | Japan | Shiga | 236177 | 330 | 0 | 35.215827 | 136.138064 | 2022-10-07 04:23:08 | Shiga, Japan | |||
1810796 | 1810796 | 2022-10-05 | Japan | Shiga | 235687 | 327 | 0 | 35.215827 | 136.138064 | 2022-10-06 04:21:22 | Shiga, Japan | |||
130770 | 130770 | 2022-10-04 | Japan | Shiga | 235255 | 326 | 0 | 35.215827 | 136.138064 | 2022-10-05 04:23:06 | Shiga, Japan | |||
2685717 | 2685717 | 2022-10-03 | Japan | Shiga | 234613 | 326 | 0 | 35.215827 | 136.138064 | 2022-10-04 04:22:55 | Shiga, Japan | |||
2259784 | 2259784 | 2022-10-02 | Japan | Shiga | 234441 | 326 | 0 | 35.215827 | 136.138064 | 2022-10-03 04:23:11 | Shiga, Japan | |||
2995310 | 2995310 | 2022-10-01 | Japan | Shiga | 234160 | 326 | 0 | 35.215827 | 136.138064 | 2022-10-02 04:21:23 | Shiga, Japan | |||
853636 | 853636 | 2022-09-30 | Japan | Shiga | 233624 | 323 | 0 | 35.215827 | 136.138064 | 2022-10-01 04:23:01 | Shiga, Japan | |||
2375562 | 2375562 | 2022-09-29 | Japan | Shiga | 233205 | 321 | 0 | 35.215827 | 136.138064 | 2022-09-30 04:23:09 | Shiga, Japan | |||
1560113 | 1560113 | 2022-09-28 | Japan | Shiga | 232650 | 319 | 0 | 35.215827 | 136.138064 | 2022-09-29 04:22:34 | Shiga, Japan | |||
3994656 | 3994656 | 2022-09-27 | Japan | Shiga | 232024 | 317 | 0 | 35.215827 | 136.138064 | 2022-09-28 04:23:01 | Shiga, Japan | |||
2768984 | 2768984 | 2022-09-26 | Japan | Shiga | 231404 | 315 | 0 | 35.215827 | 136.138064 | 2022-09-27 04:23:01 | Shiga, Japan | |||
1976637 | 1976637 | 2022-09-25 | Japan | Shiga | 230964 | 314 | 0 | 35.215827 | 136.138064 | 2022-09-26 04:20:52 | Shiga, Japan | |||
2649804 | 2649804 | 2022-09-24 | Japan | Shiga | 230300 | 312 | 0 | 35.215827 | 136.138064 | 2022-09-25 04:23:31 | Shiga, Japan | |||
384244 | 384244 | 2022-09-23 | Japan | Shiga | 229743 | 311 | 0 | 35.215827 | 136.138064 | 2022-09-24 04:21:40 | Shiga, Japan | |||
1624310 | 1624310 | 2022-09-22 | Japan | Shiga | 228888 | 311 | 0 | 35.215827 | 136.138064 | 2022-09-23 04:23: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 |
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]);