johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
946 rows where province_or_state = "Aomori" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, active, last_update, day (date), last_update (date)
recovered 264 ✖
- 0 512
- 26 56
- 32 33
- 29 14
- 34 14
- 36 9
- 31 7
- 35 5
- 25 4
- 30 4
- 255 3
- 265 3
- 273 3
- 733 3
- 769 3
- 771 3
- 776 3
- 845 3
- 2412 3
- 196 2
- 267 2
- 345 2
- 377 2
- 382 2
- 599 2
- 643 2
- 669 2
- 752 2
- 796 2
- 806 2
- 937 2
- 1100 2
- 1236 2
- 2423 2
- 2462 2
- 24 1
- 39 1
- 42 1
- 49 1
- 58 1
- 60 1
- 67 1
- 77 1
- 83 1
- 103 1
- 120 1
- 133 1
- 143 1
- 151 1
- 162 1
- 172 1
- 186 1
- 195 1
- 206 1
- 210 1
- 215 1
- 222 1
- 231 1
- 235 1
- 237 1
- 241 1
- 243 1
- 247 1
- 248 1
- 256 1
- 260 1
- 262 1
- 263 1
- 268 1
- 269 1
- 274 1
- 286 1
- 287 1
- 291 1
- 293 1
- 298 1
- 308 1
- 314 1
- 325 1
- 329 1
- 337 1
- 344 1
- 360 1
- 365 1
- 367 1
- 368 1
- 376 1
- 380 1
- 385 1
- 391 1
- 394 1
- 395 1
- 410 1
- 423 1
- 432 1
- 436 1
- 451 1
- 464 1
- 473 1
- 481 1
- 491 1
- 505 1
- 517 1
- 525 1
- 529 1
- 533 1
- 542 1
- 554 1
- 570 1
- 573 1
- 583 1
- 614 1
- 624 1
- 631 1
- 639 1
- 646 1
- 652 1
- 656 1
- 659 1
- 663 1
- 672 1
- 687 1
- 694 1
- 696 1
- 698 1
- 706 1
- 707 1
- 709 1
- 713 1
- 721 1
- 725 1
- 730 1
- 755 1
- 763 1
- 775 1
- 781 1
- 783 1
- 784 1
- 786 1
- 795 1
- 797 1
- 800 1
- 801 1
- 803 1
- 809 1
- 821 1
- 834 1
- 837 1
- 860 1
- 867 1
- 870 1
- 875 1
- 884 1
- 887 1
- 892 1
- 896 1
- 904 1
- 909 1
- 915 1
- 963 1
- 970 1
- 1035 1
- 1044 1
- 1063 1
- 1076 1
- 1087 1
- 1124 1
- 1148 1
- 1161 1
- 1172 1
- 1178 1
- 1191 1
- 1202 1
- 1264 1
- 1268 1
- 1289 1
- 1300 1
- 1318 1
- 1326 1
- 1333 1
- 1386 1
- 1396 1
- 1423 1
- 1454 1
- 1471 1
- 1483 1
- 1515 1
- 1544 1
- 1563 1
- 1574 1
- 1609 1
- 1622 1
- 1644 1
- 1702 1
- 1740 1
- 1762 1
- 1793 1
- 1804 1
- 1830 1
- 1852 1
- 1908 1
- 1921 1
- 1966 1
- 1992 1
- 2013 1
- 2029 1
- 2073 1
- 2132 1
- 2157 1
- 2183 1
- 2198 1
- 2208 1
- 2213 1
- 2250 1
- 2275 1
- 2287 1
- 2301 1
- 2316 1
- 2328 1
- 2334 1
- 2356 1
- 2366 1
- 2372 1
- 2384 1
- 2387 1
- 2390 1
- 2392 1
- 2397 1
- 2401 1
- 2403 1
- 2410 1
- 2411 1
- 2418 1
- 2419 1
- 2420 1
- 2426 1
- 2431 1
- 2434 1
- 2448 1
- 2455 1
- 2470 1
- 2485 1
- 2490 1
- 2495 1
- 2499 1
- 2503 1
- 2504 1
- 2506 1
- 2508 1
- 2509 1
- 2511 1
- 2514 1
- 2517 1
- 2521 1
- 2526 1
- 2533 1
- 2538 1
- 2543 1
- 2550 1
- 2559 1
- 2563 1
- 2567 1
- 2571 1
- 2575 1
province_or_state 1
- Aomori · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2752890 | 2752890 | 2022-12-29 | Japan | Aomori | 249739 | 526 | 0 | 40.781541 | 140.828896 | 2022-12-30 04:21:04 | Aomori, Japan | |||
1073896 | 1073896 | 2022-12-28 | Japan | Aomori | 248443 | 521 | 0 | 40.781541 | 140.828896 | 2022-12-29 04:21:01 | Aomori, Japan | |||
327893 | 327893 | 2022-12-27 | Japan | Aomori | 246897 | 512 | 0 | 40.781541 | 140.828896 | 2022-12-28 04:21:04 | Aomori, Japan | |||
217966 | 217966 | 2022-12-26 | Japan | Aomori | 244940 | 510 | 0 | 40.781541 | 140.828896 | 2022-12-27 04:21:07 | Aomori, Japan | |||
3222423 | 3222423 | 2022-12-25 | Japan | Aomori | 244348 | 508 | 0 | 40.781541 | 140.828896 | 2022-12-26 04:21:06 | Aomori, Japan | |||
1018337 | 1018337 | 2022-12-24 | Japan | Aomori | 243287 | 506 | 0 | 40.781541 | 140.828896 | 2022-12-25 04:21:04 | Aomori, Japan | |||
690360 | 690360 | 2022-12-23 | Japan | Aomori | 241683 | 500 | 0 | 40.781541 | 140.828896 | 2022-12-24 04:21:02 | Aomori, Japan | |||
2179570 | 2179570 | 2022-12-22 | Japan | Aomori | 240056 | 494 | 0 | 40.781541 | 140.828896 | 2022-12-23 04:21:04 | Aomori, Japan | |||
451374 | 451374 | 2022-12-21 | Japan | Aomori | 238386 | 488 | 0 | 40.781541 | 140.828896 | 2022-12-22 04:20:56 | Aomori, Japan | |||
2951373 | 2951373 | 2022-12-20 | Japan | Aomori | 236548 | 484 | 0 | 40.781541 | 140.828896 | 2022-12-21 04:21:03 | Aomori, Japan | |||
3173775 | 3173775 | 2022-12-19 | Japan | Aomori | 234384 | 479 | 0 | 40.781541 | 140.828896 | 2022-12-20 04:21:04 | Aomori, Japan | |||
1628292 | 1628292 | 2022-12-18 | Japan | Aomori | 233709 | 477 | 0 | 40.781541 | 140.828896 | 2022-12-19 04:21:03 | Aomori, Japan | |||
503671 | 503671 | 2022-12-17 | Japan | Aomori | 232672 | 473 | 0 | 40.781541 | 140.828896 | 2022-12-18 04:21:03 | Aomori, Japan | |||
3324243 | 3324243 | 2022-12-16 | Japan | Aomori | 231065 | 470 | 0 | 40.781541 | 140.828896 | 2022-12-17 04:21:04 | Aomori, Japan | |||
542755 | 542755 | 2022-12-15 | Japan | Aomori | 229445 | 464 | 0 | 40.781541 | 140.828896 | 2022-12-16 04:21:01 | Aomori, Japan | |||
348283 | 348283 | 2022-12-14 | Japan | Aomori | 227632 | 455 | 0 | 40.781541 | 140.828896 | 2022-12-15 04:20:58 | Aomori, Japan | |||
307871 | 307871 | 2022-12-13 | Japan | Aomori | 225598 | 452 | 0 | 40.781541 | 140.828896 | 2022-12-14 04:21:04 | Aomori, Japan | |||
1148932 | 1148932 | 2022-12-12 | Japan | Aomori | 222715 | 446 | 0 | 40.781541 | 140.828896 | 2022-12-13 04:21:01 | Aomori, Japan | |||
868786 | 868786 | 2022-12-11 | Japan | Aomori | 221963 | 441 | 0 | 40.781541 | 140.828896 | 2022-12-12 04:21:01 | Aomori, Japan | |||
257316 | 257316 | 2022-12-10 | Japan | Aomori | 220865 | 438 | 0 | 40.781541 | 140.828896 | 2022-12-11 04:20:50 | Aomori, Japan | |||
3936030 | 3936030 | 2022-12-09 | Japan | Aomori | 219062 | 434 | 0 | 40.781541 | 140.828896 | 2022-12-10 04:21:02 | Aomori, Japan | |||
3377362 | 3377362 | 2022-12-08 | Japan | Aomori | 218065 | 427 | 0 | 40.781541 | 140.828896 | 2022-12-09 04:21:05 | Aomori, Japan | |||
1984633 | 1984633 | 2022-12-07 | Japan | Aomori | 216456 | 423 | 0 | 40.781541 | 140.828896 | 2022-12-08 04:21:07 | Aomori, Japan | |||
3714156 | 3714156 | 2022-12-06 | Japan | Aomori | 214780 | 417 | 0 | 40.781541 | 140.828896 | 2022-12-07 04:20:58 | Aomori, Japan | |||
2414861 | 2414861 | 2022-12-05 | Japan | Aomori | 212885 | 412 | 0 | 40.781541 | 140.828896 | 2022-12-06 04:21:03 | Aomori, Japan | |||
718469 | 718469 | 2022-12-04 | Japan | Aomori | 212359 | 408 | 0 | 40.781541 | 140.828896 | 2022-12-05 04:20:58 | Aomori, Japan | |||
2816758 | 2816758 | 2022-12-03 | Japan | Aomori | 211483 | 403 | 0 | 40.781541 | 140.828896 | 2022-12-04 04:20:56 | Aomori, Japan | |||
833614 | 833614 | 2022-12-02 | Japan | Aomori | 210163 | 401 | 0 | 40.781541 | 140.828896 | 2022-12-03 04:21:02 | Aomori, Japan | |||
2136144 | 2136144 | 2022-12-01 | Japan | Aomori | 208778 | 398 | 0 | 40.781541 | 140.828896 | 2022-12-02 04:21:07 | Aomori, Japan | |||
1964560 | 1964560 | 2022-11-30 | Japan | Aomori | 207410 | 394 | 0 | 40.781541 | 140.828896 | 2022-12-01 04:21:03 | Aomori, Japan | |||
2556574 | 2556574 | 2022-11-29 | Japan | Aomori | 205672 | 387 | 0 | 40.781541 | 140.828896 | 2022-11-30 04:21:07 | Aomori, Japan | |||
1239648 | 1239648 | 2022-11-28 | Japan | Aomori | 195503 | 387 | 0 | 40.781541 | 140.828896 | 2022-11-29 04:21:05 | Aomori, Japan | |||
3551636 | 3551636 | 2022-11-27 | Japan | Aomori | 194892 | 386 | 0 | 40.781541 | 140.828896 | 2022-11-28 04:21:02 | Aomori, Japan | |||
2100116 | 2100116 | 2022-11-26 | Japan | Aomori | 193907 | 382 | 0 | 40.781541 | 140.828896 | 2022-11-27 04:21:05 | Aomori, Japan | |||
487607 | 487607 | 2022-11-25 | Japan | Aomori | 192356 | 378 | 0 | 40.781541 | 140.828896 | 2022-11-26 04:21:11 | Aomori, Japan | |||
3523436 | 3523436 | 2022-11-24 | Japan | Aomori | 190468 | 375 | 0 | 40.781541 | 140.828896 | 2022-11-25 04:21:06 | Aomori, Japan | |||
3312219 | 3312219 | 2022-11-23 | Japan | Aomori | 189795 | 372 | 0 | 40.781541 | 140.828896 | 2022-11-24 04:21:09 | Aomori, Japan | |||
1620260 | 1620260 | 2022-11-22 | Japan | Aomori | 188189 | 366 | 0 | 40.781541 | 140.828896 | 2022-11-23 04:21:06 | Aomori, Japan | |||
3460148 | 3460148 | 2022-11-21 | Japan | Aomori | 186180 | 365 | 0 | 40.781541 | 140.828896 | 2022-11-22 04:20:47 | Aomori, Japan | |||
1640333 | 1640333 | 2022-11-20 | Japan | Aomori | 185657 | 362 | 0 | 40.781541 | 140.828896 | 2022-11-21 04:21:05 | Aomori, Japan | |||
2063890 | 2063890 | 2022-11-19 | Japan | Aomori | 184783 | 361 | 0 | 40.781541 | 140.828896 | 2022-11-20 04:21:08 | Aomori, Japan | |||
1755284 | 1755284 | 2022-11-18 | Japan | Aomori | 183575 | 357 | 0 | 40.781541 | 140.828896 | 2022-11-19 04:21:14 | Aomori, Japan | |||
3026277 | 3026277 | 2022-11-17 | Japan | Aomori | 184830 | 351 | 0 | 40.781541 | 140.828896 | 2022-11-18 04:21:15 | Aomori, Japan | |||
2485988 | 2485988 | 2022-11-16 | Japan | Aomori | 181310 | 351 | 0 | 40.781541 | 140.828896 | 2022-11-17 04:21:11 | Aomori, Japan | |||
291999 | 291999 | 2022-11-15 | Japan | Aomori | 179879 | 346 | 0 | 40.781541 | 140.828896 | 2022-11-16 04:21:09 | Aomori, Japan | |||
3597029 | 3597029 | 2022-11-14 | Japan | Aomori | 184830 | 351 | 0 | 40.781541 | 140.828896 | 2022-11-15 04:21:16 | Aomori, Japan | |||
311887 | 311887 | 2022-11-13 | Japan | Aomori | 184453 | 349 | 0 | 40.781541 | 140.828896 | 2022-11-14 04:21:09 | Aomori, Japan | |||
63048 | 63048 | 2022-11-12 | Japan | Aomori | 183718 | 348 | 0 | 40.781541 | 140.828896 | 2022-11-13 04:21:14 | Aomori, Japan | |||
2927210 | 2927210 | 2022-11-11 | Japan | Aomori | 182752 | 347 | 0 | 40.781541 | 140.828896 | 2022-11-12 04:20:41 | Aomori, Japan | |||
2506046 | 2506046 | 2022-11-10 | Japan | Aomori | 181908 | 346 | 0 | 40.781541 | 140.828896 | 2022-11-11 04:21:22 | Aomori, Japan | |||
2430921 | 2430921 | 2022-11-09 | Japan | Aomori | 181004 | 345 | 0 | 40.781541 | 140.828896 | 2022-11-10 04:21:16 | Aomori, Japan | |||
479577 | 479577 | 2022-11-08 | Japan | Aomori | 179989 | 343 | 0 | 40.781541 | 140.828896 | 2022-11-09 04:21:22 | Aomori, Japan | |||
2438727 | 2438727 | 2022-11-07 | Japan | Aomori | 178913 | 342 | 0 | 40.781541 | 140.828896 | 2022-11-08 04:21:21 | Aomori, Japan | |||
1049825 | 1049825 | 2022-11-06 | Japan | Aomori | 178577 | 341 | 0 | 40.781541 | 140.828896 | 2022-11-07 04:21:26 | Aomori, Japan | |||
617849 | 617849 | 2022-11-05 | Japan | Aomori | 178014 | 340 | 0 | 40.781541 | 140.828896 | 2022-11-06 04:21:24 | Aomori, Japan | |||
1022353 | 1022353 | 2022-11-04 | Japan | Aomori | 176977 | 338 | 0 | 40.781541 | 140.828896 | 2022-11-05 04:21:52 | Aomori, Japan | |||
431344 | 431344 | 2022-11-03 | Japan | Aomori | 176672 | 337 | 0 | 40.781541 | 140.828896 | 2022-11-04 04:22:11 | Aomori, Japan | |||
849586 | 849586 | 2022-11-02 | Japan | Aomori | 175904 | 336 | 0 | 40.781541 | 140.828896 | 2022-11-03 04:22:05 | Aomori, Japan | |||
710437 | 710437 | 2022-11-01 | Japan | Aomori | 175096 | 335 | 0 | 40.781541 | 140.828896 | 2022-11-02 04:22:09 | Aomori, Japan | |||
3284886 | 3284886 | 2022-10-31 | Japan | Aomori | 174216 | 334 | 0 | 40.781541 | 140.828896 | 2022-11-01 04:22:36 | Aomori, Japan | |||
319919 | 319919 | 2022-10-30 | Japan | Aomori | 173929 | 334 | 0 | 40.781541 | 140.828896 | 2022-10-31 04:21:36 | Aomori, Japan | |||
912195 | 912195 | 2022-10-29 | Japan | Aomori | 173470 | 334 | 0 | 40.781541 | 140.828896 | 2022-10-30 04:22:14 | Aomori, Japan | |||
1366464 | 1366464 | 2022-10-28 | Japan | Aomori | 172849 | 331 | 0 | 40.781541 | 140.828896 | 2022-10-29 04:21:13 | Aomori, Japan | |||
3038319 | 3038319 | 2022-10-27 | Japan | Aomori | 172341 | 330 | 0 | 40.781541 | 140.828896 | 2022-10-28 04:22:31 | Aomori, Japan | |||
538739 | 538739 | 2022-10-26 | Japan | Aomori | 171810 | 326 | 0 | 40.781541 | 140.828896 | 2022-10-27 04:22:01 | Aomori, Japan | |||
1830140 | 1830140 | 2022-10-25 | Japan | Aomori | 171227 | 323 | 0 | 40.781541 | 140.828896 | 2022-10-26 04:22:19 | Aomori, Japan | |||
794401 | 794401 | 2022-10-24 | Japan | Aomori | 170615 | 321 | 0 | 40.781541 | 140.828896 | 2022-10-25 04:21:53 | Aomori, Japan | |||
3276856 | 3276856 | 2022-10-23 | Japan | Aomori | 170441 | 321 | 0 | 40.781541 | 140.828896 | 2022-10-24 04:22:29 | Aomori, Japan | |||
2267894 | 2267894 | 2022-10-22 | Japan | Aomori | 170162 | 320 | 0 | 40.781541 | 140.828896 | 2022-10-23 04:22:46 | Aomori, Japan | |||
1592194 | 1592194 | 2022-10-21 | Japan | Aomori | 169752 | 318 | 0 | 40.781541 | 140.828896 | 2022-10-22 04:22:53 | Aomori, Japan | |||
2271910 | 2271910 | 2022-10-20 | Japan | Aomori | 169389 | 317 | 0 | 40.781541 | 140.828896 | 2022-10-21 04:22:23 | Aomori, Japan | |||
198245 | 198245 | 2022-10-19 | Japan | Aomori | 168986 | 317 | 0 | 40.781541 | 140.828896 | 2022-10-20 04:22:59 | Aomori, Japan | |||
2756906 | 2756906 | 2022-10-18 | Japan | Aomori | 168606 | 316 | 0 | 40.781541 | 140.828896 | 2022-10-19 04:22:26 | Aomori, Japan | |||
2024740 | 2024740 | 2022-10-17 | Japan | Aomori | 168080 | 316 | 0 | 40.781541 | 140.828896 | 2022-10-18 04:22:42 | Aomori, Japan | |||
2159518 | 2159518 | 2022-10-16 | Japan | Aomori | 167957 | 316 | 0 | 40.781541 | 140.828896 | 2022-10-17 04:20:31 | Aomori, Japan | |||
515715 | 515715 | 2022-10-15 | Japan | Aomori | 167695 | 316 | 0 | 40.781541 | 140.828896 | 2022-10-16 04:22:39 | Aomori, Japan | |||
2032772 | 2032772 | 2022-10-14 | Japan | Aomori | 167348 | 314 | 0 | 40.781541 | 140.828896 | 2022-10-15 04:22:00 | Aomori, Japan | |||
3753460 | 3753460 | 2022-10-13 | Japan | Aomori | 166996 | 314 | 0 | 40.781541 | 140.828896 | 2022-10-14 04:22:28 | Aomori, Japan | |||
3214285 | 3214285 | 2022-10-12 | Japan | Aomori | 166534 | 314 | 0 | 40.781541 | 140.828896 | 2022-10-13 04:22:39 | Aomori, Japan | |||
3250134 | 3250134 | 2022-10-11 | Japan | Aomori | 165980 | 314 | 0 | 40.781541 | 140.828896 | 2022-10-12 04:22:51 | Aomori, Japan | |||
2967393 | 2967393 | 2022-10-10 | Japan | Aomori | 165819 | 314 | 0 | 40.781541 | 140.828896 | 2022-10-11 04:23:05 | Aomori, Japan | |||
3097429 | 3097429 | 2022-10-09 | Japan | Aomori | 165706 | 314 | 0 | 40.781541 | 140.828896 | 2022-10-10 04:22:32 | Aomori, Japan | |||
4002654 | 4002654 | 2022-10-08 | Japan | Aomori | 165529 | 313 | 0 | 40.781541 | 140.828896 | 2022-10-09 04:21:16 | Aomori, Japan | |||
396251 | 396251 | 2022-10-07 | Japan | Aomori | 165271 | 311 | 0 | 40.781541 | 140.828896 | 2022-10-08 04:22:56 | Aomori, Japan | |||
2529368 | 2529368 | 2022-10-06 | Japan | Aomori | 164997 | 310 | 0 | 40.781541 | 140.828896 | 2022-10-07 04:23:08 | Aomori, Japan | |||
1810762 | 1810762 | 2022-10-05 | Japan | Aomori | 164737 | 309 | 0 | 40.781541 | 140.828896 | 2022-10-06 04:21:22 | Aomori, Japan | |||
130736 | 130736 | 2022-10-04 | Japan | Aomori | 164422 | 308 | 0 | 40.781541 | 140.828896 | 2022-10-05 04:23:06 | Aomori, Japan | |||
2685683 | 2685683 | 2022-10-03 | Japan | Aomori | 163975 | 307 | 0 | 40.781541 | 140.828896 | 2022-10-04 04:22:55 | Aomori, Japan | |||
2259750 | 2259750 | 2022-10-02 | Japan | Aomori | 163866 | 305 | 0 | 40.781541 | 140.828896 | 2022-10-03 04:23:11 | Aomori, Japan | |||
2995276 | 2995276 | 2022-10-01 | Japan | Aomori | 163633 | 304 | 0 | 40.781541 | 140.828896 | 2022-10-02 04:21:23 | Aomori, Japan | |||
853602 | 853602 | 2022-09-30 | Japan | Aomori | 163349 | 304 | 0 | 40.781541 | 140.828896 | 2022-10-01 04:23:01 | Aomori, Japan | |||
2375528 | 2375528 | 2022-09-29 | Japan | Aomori | 163107 | 299 | 0 | 40.781541 | 140.828896 | 2022-09-30 04:23:09 | Aomori, Japan | |||
1560079 | 1560079 | 2022-09-28 | Japan | Aomori | 162804 | 299 | 0 | 40.781541 | 140.828896 | 2022-09-29 04:22:34 | Aomori, Japan | |||
3994622 | 3994622 | 2022-09-27 | Japan | Aomori | 162460 | 293 | 0 | 40.781541 | 140.828896 | 2022-09-28 04:23:01 | Aomori, Japan | |||
2768950 | 2768950 | 2022-09-26 | Japan | Aomori | 161912 | 293 | 0 | 40.781541 | 140.828896 | 2022-09-27 04:23:01 | Aomori, Japan | |||
1976603 | 1976603 | 2022-09-25 | Japan | Aomori | 161572 | 293 | 0 | 40.781541 | 140.828896 | 2022-09-26 04:20:52 | Aomori, Japan | |||
2649770 | 2649770 | 2022-09-24 | Japan | Aomori | 161336 | 293 | 0 | 40.781541 | 140.828896 | 2022-09-25 04:23:31 | Aomori, Japan | |||
384210 | 384210 | 2022-09-23 | Japan | Aomori | 160962 | 291 | 0 | 40.781541 | 140.828896 | 2022-09-24 04:21:40 | Aomori, Japan | |||
1624276 | 1624276 | 2022-09-22 | Japan | Aomori | 160542 | 291 | 0 | 40.781541 | 140.828896 | 2022-09-23 04:23:13 | Aomori, Japan | |||
1370480 | 1370480 | 2022-09-21 | Japan | Aomori | 159962 | 288 | 0 | 40.781541 | 140.828896 | 2022-09-22 04:22:56 | Aomori, 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]);