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, latitude, longitude, day (date), last_update (date)
deaths 245 ✖
- 1 73
- 104 73
- 9 43
- 11 29
- 8 28
- 90 27
- 219 26
- 221 22
- 7 19
- 102 17
- 61 16
- 95 16
- 103 15
- 4 13
- 213 13
- 97 11
- 93 9
- 94 9
- 99 9
- 33 8
- 47 8
- 51 8
- 59 8
- 105 8
- 217 8
- 222 8
- 106 7
- 54 6
- 79 6
- 98 6
- 188 6
- 204 6
- 16 5
- 48 5
- 67 5
- 96 5
- 100 5
- 223 5
- 225 5
- 366 5
- 370 5
- 372 5
- 3 4
- 39 4
- 44 4
- 56 4
- 58 4
- 74 4
- 82 4
- 83 4
- 88 4
- 200 4
- 307 4
- 326 4
- 333 4
- 378 4
- 2 3
- 5 3
- 13 3
- 19 3
- 26 3
- 40 3
- 69 3
- 75 3
- 81 3
- 91 3
- 92 3
- 117 3
- 120 3
- 134 3
- 192 3
- 210 3
- 234 3
- 284 3
- 289 3
- 300 3
- 343 3
- 371 3
- 415 3
- 6 2
- 12 2
- 14 2
- 18 2
- 20 2
- 27 2
- 30 2
- 35 2
- 43 2
- 46 2
- 52 2
- 60 2
- 68 2
- 89 2
- 110 2
- 111 2
- 112 2
- 115 2
- 118 2
- 131 2
- 165 2
- 183 2
- 185 2
- 190 2
- 191 2
- 196 2
- 199 2
- 224 2
- 228 2
- 233 2
- 252 2
- 256 2
- 259 2
- 271 2
- 287 2
- 297 2
- 306 2
- 311 2
- 349 2
- 373 2
- 375 2
- 376 2
- 377 2
- 416 2
- 10 1
- 15 1
- 17 1
- 25 1
- 28 1
- 29 1
- 31 1
- 42 1
- 45 1
- 49 1
- 55 1
- 63 1
- 64 1
- 72 1
- 76 1
- 80 1
- 84 1
- 85 1
- 86 1
- 87 1
- 101 1
- 108 1
- 122 1
- 124 1
- 125 1
- 129 1
- 133 1
- 135 1
- 137 1
- 141 1
- 146 1
- 150 1
- 152 1
- 154 1
- 158 1
- 159 1
- 161 1
- 166 1
- 168 1
- 172 1
- 176 1
- 179 1
- 182 1
- 194 1
- 197 1
- 205 1
- 211 1
- 214 1
- 216 1
- 220 1
- 231 1
- 232 1
- 235 1
- 236 1
- 237 1
- 241 1
- 244 1
- 248 1
- 257 1
- 263 1
- 267 1
- 269 1
- 275 1
- 277 1
- 283 1
- 285 1
- 286 1
- 292 1
- 294 1
- 295 1
- 302 1
- 303 1
- 309 1
- 312 1
- 314 1
- 315 1
- 317 1
- 319 1
- 321 1
- 323 1
- 327 1
- 330 1
- 334 1
- 337 1
- 338 1
- 341 1
- 342 1
- 346 1
- 347 1
- 353 1
- 357 1
- 359 1
- 362 1
- 365 1
- 367 1
- 369 1
- 379 1
- 380 1
- 384 1
- 389 1
- 393 1
- 398 1
- 403 1
- 406 1
- 409 1
- 410 1
- 418 1
- 422 1
- 426 1
- 429 1
- 433 1
- 436 1
- 438 1
- 443 1
- 448 1
- 453 1
- 458 1
- 463 1
- 466 1
- 469 1
- 473 1
- 476 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]);