johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
938 rows where province_or_state = "Halland" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: confirmed, last_update, day (date), last_update (date)
active 245 ✖
- 39890 7
- 40418 7
- 10296 6
- 12240 6
- 31892 5
- 40518 5
- 1092 4
- 14710 4
- 16305 4
- 17499 4
- 18567 4
- 19678 4
- 20798 4
- 21949 4
- 2208 4
- 2273 4
- 23366 4
- 2396 4
- 24782 4
- 2549 4
- 26281 4
- 2696 4
- 27977 4
- 2825 4
- 2995 4
- 30193 4
- 3346 4
- 33906 4
- 35495 4
- 36712 4
- 37610 4
- 38438 4
- 39054 4
- 39573 4
- 3963 4
- 40202 4
- 40396 4
- 40592 4
- 40667 4
- 40737 4
- 40846 4
- 41001 4
- 4752 4
- 5428 4
- 6190 4
- 7261 4
- 8131 4
- 9441 4
- 1260 3
- 1502 3
- 1564 3
- 1593 3
- 1628 3
- 1678 3
- 1764 3
- 1870 3
- 1939 3
- 2048 3
- 2135 3
- 13793 2
- 1520 2
- 38867 2
- 1000 1
- 10054 1
- 1006 1
- 1024 1
- 1069 1
- 1127 1
- 1138 1
- 11720 1
- 1205 1
- 1237 1
- 1371 1
- 1412 1
- 14249 1
- 1464 1
- 1466 1
- 15430 1
- 1545 1
- 1552 1
- 1573 1
- 1576 1
- 1580 1
- 15815 1
- 1588 1
- 1605 1
- 16081 1
- 1614 1
- 1620 1
- 1624 1
- 1635 1
- 1642 1
- 1648 1
- 16767 1
- 1680 1
- 1695 1
- 17066 1
- 1710 1
- 1715 1
- 17287 1
- 1748 1
- 1793 1
- 17966 1
- 1814 1
- 18174 1
- 18446 1
- 1846 1
- 1858 1
- 1884 1
- 1896 1
- 19009 1
- 19308 1
- 1935 1
- 1937 1
- 19513 1
- 1980 1
- 2000 1
- 20078 1
- 2022 1
- 2025 1
- 20384 1
- 2056 1
- 20586 1
- 2071 1
- 2103 1
- 2110 1
- 21225 1
- 21503 1
- 2151 1
- 2166 1
- 2170 1
- 21763 1
- 2199 1
- 2240 1
- 2248 1
- 22483 1
- 2263 1
- 22800 1
- 23129 1
- 2344 1
- 2346 1
- 2365 1
- 23844 1
- 24222 1
- 24503 1
- 2464 1
- 2489 1
- 2519 1
- 25302 1
- 25729 1
- 2601 1
- 26043 1
- 2640 1
- 2670 1
- 26916 1
- 27297 1
- 2760 1
- 27675 1
- 2776 1
- 2819 1
- 28897 1
- 2891 1
- 2927 1
- 29443 1
- 2953 1
- 29856 1
- 31155 1
- 3129 1
- 31533 1
- 3228 1
- 3262 1
- 32746 1
- 33280 1
- 33608 1
- 34664 1
- 34997 1
- 35262 1
- 36119 1
- 36348 1
- 3638 1
- 36523 1
- 37163 1
- 37349 1
- 37491 1
- 3788 1
- 38027 1
- 38190 1
- 38256 1
- 3845 1
- 38754 1
- 39289 1
- 39397 1
- 39479 1
- 39750 1
- 39828 1
- 40160 1
- 40304 1
- 40345 1
- 40375 1
- 40501 1
- 40507 1
- 40547 1
- 40560 1
- 40573 1
- 40628 1
- 40649 1
- 40660 1
- 40694 1
- 40710 1
- 40725 1
- 40782 1
- 40810 1
- 40829 1
- 40917 1
- 40948 1
- 40976 1
- 41069 1
- 41107 1
- 4427 1
- 4469 1
- 4502 1
- 5078 1
- 5133 1
- 5249 1
- 5765 1
- 5898 1
- 6121 1
- 6832 1
- 7047 1
- 7089 1
- 7659 1
- 7770 1
- 7998 1
- 814 1
- 830 1
- 856 1
- 863 1
- 8652 1
- 880 1
- 8934 1
- 903 1
- 9225 1
- 934 1
- 960 1
- 989 1
province_or_state 1
- Halland · 938 ✖
country_or_region 1
- Sweden 938
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2753222 | 2753222 | 2022-12-29 | Sweden | Halland | 111719 | 561 | 0 | 56.8967 | 12.8034 | 2022-12-30 04:21:04 | Halland, Sweden | |||
1074228 | 1074228 | 2022-12-28 | Sweden | Halland | 111205 | 549 | 0 | 56.8967 | 12.8034 | 2022-12-29 04:21:01 | Halland, Sweden | |||
328225 | 328225 | 2022-12-27 | Sweden | Halland | 111205 | 549 | 0 | 56.8967 | 12.8034 | 2022-12-28 04:21:04 | Halland, Sweden | |||
218298 | 218298 | 2022-12-26 | Sweden | Halland | 111205 | 549 | 0 | 56.8967 | 12.8034 | 2022-12-27 04:21:07 | Halland, Sweden | |||
3222755 | 3222755 | 2022-12-25 | Sweden | Halland | 111205 | 549 | 0 | 56.8967 | 12.8034 | 2022-12-26 04:21:06 | Halland, Sweden | |||
1018669 | 1018669 | 2022-12-24 | Sweden | Halland | 111205 | 549 | 0 | 56.8967 | 12.8034 | 2022-12-25 04:21:04 | Halland, Sweden | |||
690692 | 690692 | 2022-12-23 | Sweden | Halland | 111205 | 549 | 0 | 56.8967 | 12.8034 | 2022-12-24 04:21:02 | Halland, Sweden | |||
2179902 | 2179902 | 2022-12-22 | Sweden | Halland | 111205 | 549 | 0 | 56.8967 | 12.8034 | 2022-12-23 04:21:04 | Halland, Sweden | |||
451706 | 451706 | 2022-12-21 | Sweden | Halland | 110553 | 538 | 0 | 56.8967 | 12.8034 | 2022-12-22 04:20:56 | Halland, Sweden | |||
2951705 | 2951705 | 2022-12-20 | Sweden | Halland | 110553 | 538 | 0 | 56.8967 | 12.8034 | 2022-12-21 04:21:03 | Halland, Sweden | |||
3174107 | 3174107 | 2022-12-19 | Sweden | Halland | 110553 | 538 | 0 | 56.8967 | 12.8034 | 2022-12-20 04:21:04 | Halland, Sweden | |||
1628624 | 1628624 | 2022-12-18 | Sweden | Halland | 110553 | 538 | 0 | 56.8967 | 12.8034 | 2022-12-19 04:21:03 | Halland, Sweden | |||
504003 | 504003 | 2022-12-17 | Sweden | Halland | 110553 | 538 | 0 | 56.8967 | 12.8034 | 2022-12-18 04:21:03 | Halland, Sweden | |||
3324575 | 3324575 | 2022-12-16 | Sweden | Halland | 110553 | 538 | 0 | 56.8967 | 12.8034 | 2022-12-17 04:21:04 | Halland, Sweden | |||
543087 | 543087 | 2022-12-15 | Sweden | Halland | 110553 | 538 | 0 | 56.8967 | 12.8034 | 2022-12-16 04:21:01 | Halland, Sweden | |||
348615 | 348615 | 2022-12-14 | Sweden | Halland | 110001 | 535 | 0 | 56.8967 | 12.8034 | 2022-12-15 04:20:58 | Halland, Sweden | |||
308203 | 308203 | 2022-12-13 | Sweden | Halland | 110001 | 535 | 0 | 56.8967 | 12.8034 | 2022-12-14 04:21:04 | Halland, Sweden | |||
1149264 | 1149264 | 2022-12-12 | Sweden | Halland | 110001 | 535 | 0 | 56.8967 | 12.8034 | 2022-12-13 04:21:01 | Halland, Sweden | |||
869118 | 869118 | 2022-12-11 | Sweden | Halland | 110001 | 535 | 0 | 56.8967 | 12.8034 | 2022-12-12 04:21:01 | Halland, Sweden | |||
257648 | 257648 | 2022-12-10 | Sweden | Halland | 110001 | 535 | 0 | 56.8967 | 12.8034 | 2022-12-11 04:20:50 | Halland, Sweden | |||
3936362 | 3936362 | 2022-12-09 | Sweden | Halland | 110001 | 535 | 0 | 56.8967 | 12.8034 | 2022-12-10 04:21:02 | Halland, Sweden | |||
3377694 | 3377694 | 2022-12-08 | Sweden | Halland | 110001 | 535 | 0 | 56.8967 | 12.8034 | 2022-12-09 04:21:05 | Halland, Sweden | |||
1984965 | 1984965 | 2022-12-07 | Sweden | Halland | 109673 | 535 | 0 | 56.8967 | 12.8034 | 2022-12-08 04:21:07 | Halland, Sweden | |||
3714488 | 3714488 | 2022-12-06 | Sweden | Halland | 109673 | 535 | 0 | 56.8967 | 12.8034 | 2022-12-07 04:20:58 | Halland, Sweden | |||
2415193 | 2415193 | 2022-12-05 | Sweden | Halland | 109673 | 535 | 0 | 56.8967 | 12.8034 | 2022-12-06 04:21:03 | Halland, Sweden | |||
718801 | 718801 | 2022-12-04 | Sweden | Halland | 109673 | 535 | 0 | 56.8967 | 12.8034 | 2022-12-05 04:20:58 | Halland, Sweden | |||
2817090 | 2817090 | 2022-12-03 | Sweden | Halland | 109673 | 535 | 0 | 56.8967 | 12.8034 | 2022-12-04 04:20:56 | Halland, Sweden | |||
833946 | 833946 | 2022-12-02 | Sweden | Halland | 109673 | 535 | 0 | 56.8967 | 12.8034 | 2022-12-03 04:21:02 | Halland, Sweden | |||
2136476 | 2136476 | 2022-12-01 | Sweden | Halland | 109673 | 535 | 0 | 56.8967 | 12.8034 | 2022-12-02 04:21:07 | Halland, Sweden | |||
1964892 | 1964892 | 2022-11-30 | Sweden | Halland | 109457 | 533 | 0 | 56.8967 | 12.8034 | 2022-12-01 04:21:03 | Halland, Sweden | |||
2556906 | 2556906 | 2022-11-29 | Sweden | Halland | 109457 | 533 | 0 | 56.8967 | 12.8034 | 2022-11-30 04:21:07 | Halland, Sweden | |||
1239980 | 1239980 | 2022-11-28 | Sweden | Halland | 109457 | 533 | 0 | 56.8967 | 12.8034 | 2022-11-29 04:21:05 | Halland, Sweden | |||
3551968 | 3551968 | 2022-11-27 | Sweden | Halland | 109457 | 533 | 0 | 56.8967 | 12.8034 | 2022-11-28 04:21:02 | Halland, Sweden | |||
2100448 | 2100448 | 2022-11-26 | Sweden | Halland | 109457 | 533 | 0 | 56.8967 | 12.8034 | 2022-11-27 04:21:05 | Halland, Sweden | |||
487939 | 487939 | 2022-11-25 | Sweden | Halland | 109457 | 533 | 0 | 56.8967 | 12.8034 | 2022-11-26 04:21:11 | Halland, Sweden | |||
3523768 | 3523768 | 2022-11-24 | Sweden | Halland | 109457 | 533 | 0 | 56.8967 | 12.8034 | 2022-11-25 04:21:06 | Halland, Sweden | |||
3312551 | 3312551 | 2022-11-23 | Sweden | Halland | 109355 | 527 | 0 | 56.8967 | 12.8034 | 2022-11-24 04:21:09 | Halland, Sweden | |||
1620592 | 1620592 | 2022-11-22 | Sweden | Halland | 109355 | 527 | 0 | 56.8967 | 12.8034 | 2022-11-23 04:21:06 | Halland, Sweden | |||
3460480 | 3460480 | 2022-11-21 | Sweden | Halland | 109355 | 527 | 0 | 56.8967 | 12.8034 | 2022-11-22 04:20:47 | Halland, Sweden | |||
1640665 | 1640665 | 2022-11-20 | Sweden | Halland | 109355 | 527 | 0 | 56.8967 | 12.8034 | 2022-11-21 04:21:05 | Halland, Sweden | |||
2064222 | 2064222 | 2022-11-19 | Sweden | Halland | 109355 | 527 | 0 | 56.8967 | 12.8034 | 2022-11-20 04:21:08 | Halland, Sweden | |||
1755616 | 1755616 | 2022-11-18 | Sweden | Halland | 109355 | 527 | 0 | 56.8967 | 12.8034 | 2022-11-19 04:21:14 | Halland, Sweden | |||
3026609 | 3026609 | 2022-11-17 | Sweden | Halland | 109355 | 527 | 0 | 56.8967 | 12.8034 | 2022-11-18 04:21:15 | Halland, Sweden | |||
2486320 | 2486320 | 2022-11-16 | Sweden | Halland | 109187 | 524 | 0 | 56.8967 | 12.8034 | 2022-11-17 04:21:11 | Halland, Sweden | |||
292331 | 292331 | 2022-11-15 | Sweden | Halland | 109187 | 524 | 0 | 56.8967 | 12.8034 | 2022-11-16 04:21:09 | Halland, Sweden | |||
3597361 | 3597361 | 2022-11-14 | Sweden | Halland | 109187 | 524 | 0 | 56.8967 | 12.8034 | 2022-11-15 04:21:16 | Halland, Sweden | |||
312219 | 312219 | 2022-11-13 | Sweden | Halland | 109187 | 524 | 0 | 56.8967 | 12.8034 | 2022-11-14 04:21:09 | Halland, Sweden | |||
63380 | 63380 | 2022-11-12 | Sweden | Halland | 109187 | 524 | 0 | 56.8967 | 12.8034 | 2022-11-13 04:21:14 | Halland, Sweden | |||
2927542 | 2927542 | 2022-11-11 | Sweden | Halland | 109187 | 524 | 0 | 56.8967 | 12.8034 | 2022-11-12 04:20:41 | Halland, Sweden | |||
2506378 | 2506378 | 2022-11-10 | Sweden | Halland | 109187 | 524 | 0 | 56.8967 | 12.8034 | 2022-11-11 04:21:22 | Halland, Sweden | |||
2431253 | 2431253 | 2022-11-09 | Sweden | Halland | 108997 | 522 | 0 | 56.8967 | 12.8034 | 2022-11-10 04:21:16 | Halland, Sweden | |||
479909 | 479909 | 2022-11-08 | Sweden | Halland | 108997 | 522 | 0 | 56.8967 | 12.8034 | 2022-11-09 04:21:22 | Halland, Sweden | |||
2439059 | 2439059 | 2022-11-07 | Sweden | Halland | 108997 | 522 | 0 | 56.8967 | 12.8034 | 2022-11-08 04:21:21 | Halland, Sweden | |||
1050157 | 1050157 | 2022-11-06 | Sweden | Halland | 108997 | 522 | 0 | 56.8967 | 12.8034 | 2022-11-07 04:21:26 | Halland, Sweden | |||
618181 | 618181 | 2022-11-05 | Sweden | Halland | 108997 | 522 | 0 | 56.8967 | 12.8034 | 2022-11-06 04:21:24 | Halland, Sweden | |||
1022685 | 1022685 | 2022-11-04 | Sweden | Halland | 108997 | 522 | 0 | 56.8967 | 12.8034 | 2022-11-05 04:21:52 | Halland, Sweden | |||
431676 | 431676 | 2022-11-03 | Sweden | Halland | 108997 | 522 | 0 | 56.8967 | 12.8034 | 2022-11-04 04:22:11 | Halland, Sweden | |||
849918 | 849918 | 2022-11-02 | Sweden | Halland | 108822 | 518 | 0 | 56.8967 | 12.8034 | 2022-11-03 04:22:05 | Halland, Sweden | |||
710769 | 710769 | 2022-11-01 | Sweden | Halland | 108822 | 518 | 0 | 56.8967 | 12.8034 | 2022-11-02 04:22:09 | Halland, Sweden | |||
3285218 | 3285218 | 2022-10-31 | Sweden | Halland | 108822 | 518 | 0 | 56.8967 | 12.8034 | 2022-11-01 04:22:36 | Halland, Sweden | |||
320251 | 320251 | 2022-10-30 | Sweden | Halland | 108822 | 518 | 0 | 56.8967 | 12.8034 | 2022-10-31 04:21:36 | Halland, Sweden | |||
912527 | 912527 | 2022-10-29 | Sweden | Halland | 108822 | 518 | 0 | 56.8967 | 12.8034 | 2022-10-30 04:22:14 | Halland, Sweden | |||
1366796 | 1366796 | 2022-10-28 | Sweden | Halland | 108822 | 518 | 0 | 56.8967 | 12.8034 | 2022-10-29 04:21:13 | Halland, Sweden | |||
3038651 | 3038651 | 2022-10-27 | Sweden | Halland | 108822 | 518 | 0 | 56.8967 | 12.8034 | 2022-10-28 04:22:31 | Halland, Sweden | |||
539071 | 539071 | 2022-10-26 | Sweden | Halland | 108651 | 513 | 0 | 56.8967 | 12.8034 | 2022-10-27 04:22:01 | Halland, Sweden | |||
1830472 | 1830472 | 2022-10-25 | Sweden | Halland | 108651 | 513 | 0 | 56.8967 | 12.8034 | 2022-10-26 04:22:19 | Halland, Sweden | |||
794733 | 794733 | 2022-10-24 | Sweden | Halland | 108651 | 513 | 0 | 56.8967 | 12.8034 | 2022-10-25 04:21:53 | Halland, Sweden | |||
3277188 | 3277188 | 2022-10-23 | Sweden | Halland | 108651 | 513 | 0 | 56.8967 | 12.8034 | 2022-10-24 04:22:29 | Halland, Sweden | |||
2268226 | 2268226 | 2022-10-22 | Sweden | Halland | 108651 | 513 | 0 | 56.8967 | 12.8034 | 2022-10-23 04:22:46 | Halland, Sweden | |||
1592526 | 1592526 | 2022-10-21 | Sweden | Halland | 108651 | 513 | 0 | 56.8967 | 12.8034 | 2022-10-22 04:22:53 | Halland, Sweden | |||
2272242 | 2272242 | 2022-10-20 | Sweden | Halland | 108651 | 513 | 0 | 56.8967 | 12.8034 | 2022-10-21 04:22:23 | Halland, Sweden | |||
198577 | 198577 | 2022-10-19 | Sweden | Halland | 108485 | 503 | 0 | 56.8967 | 12.8034 | 2022-10-20 04:22:59 | Halland, Sweden | |||
2757238 | 2757238 | 2022-10-18 | Sweden | Halland | 108485 | 503 | 0 | 56.8967 | 12.8034 | 2022-10-19 04:22:26 | Halland, Sweden | |||
2025072 | 2025072 | 2022-10-17 | Sweden | Halland | 108485 | 503 | 0 | 56.8967 | 12.8034 | 2022-10-18 04:22:42 | Halland, Sweden | |||
2159850 | 2159850 | 2022-10-16 | Sweden | Halland | 108485 | 503 | 0 | 56.8967 | 12.8034 | 2022-10-17 04:20:31 | Halland, Sweden | |||
516047 | 516047 | 2022-10-15 | Sweden | Halland | 108485 | 503 | 0 | 56.8967 | 12.8034 | 2022-10-16 04:22:39 | Halland, Sweden | |||
2033104 | 2033104 | 2022-10-14 | Sweden | Halland | 108485 | 503 | 0 | 56.8967 | 12.8034 | 2022-10-15 04:22:00 | Halland, Sweden | |||
3753792 | 3753792 | 2022-10-13 | Sweden | Halland | 108485 | 503 | 0 | 56.8967 | 12.8034 | 2022-10-14 04:22:28 | Halland, Sweden | |||
3214617 | 3214617 | 2022-10-12 | Sweden | Halland | 108326 | 496 | 0 | 56.8967 | 12.8034 | 2022-10-13 04:22:39 | Halland, Sweden | |||
3250466 | 3250466 | 2022-10-11 | Sweden | Halland | 108326 | 496 | 0 | 56.8967 | 12.8034 | 2022-10-12 04:22:51 | Halland, Sweden | |||
2967725 | 2967725 | 2022-10-10 | Sweden | Halland | 108326 | 496 | 0 | 56.8967 | 12.8034 | 2022-10-11 04:23:05 | Halland, Sweden | |||
3097761 | 3097761 | 2022-10-09 | Sweden | Halland | 108326 | 496 | 0 | 56.8967 | 12.8034 | 2022-10-10 04:22:32 | Halland, Sweden | |||
4002986 | 4002986 | 2022-10-08 | Sweden | Halland | 108326 | 496 | 0 | 56.8967 | 12.8034 | 2022-10-09 04:21:16 | Halland, Sweden | |||
396583 | 396583 | 2022-10-07 | Sweden | Halland | 108326 | 496 | 0 | 56.8967 | 12.8034 | 2022-10-08 04:22:56 | Halland, Sweden | |||
2529700 | 2529700 | 2022-10-06 | Sweden | Halland | 108326 | 496 | 0 | 56.8967 | 12.8034 | 2022-10-07 04:23:08 | Halland, Sweden | |||
1811094 | 1811094 | 2022-10-05 | Sweden | Halland | 108185 | 496 | 0 | 56.8967 | 12.8034 | 2022-10-06 04:21:22 | Halland, Sweden | |||
131068 | 131068 | 2022-10-04 | Sweden | Halland | 108185 | 496 | 0 | 56.8967 | 12.8034 | 2022-10-05 04:23:06 | Halland, Sweden | |||
2686015 | 2686015 | 2022-10-03 | Sweden | Halland | 108185 | 496 | 0 | 56.8967 | 12.8034 | 2022-10-04 04:22:55 | Halland, Sweden | |||
2260082 | 2260082 | 2022-10-02 | Sweden | Halland | 108185 | 496 | 0 | 56.8967 | 12.8034 | 2022-10-03 04:23:11 | Halland, Sweden | |||
2995608 | 2995608 | 2022-10-01 | Sweden | Halland | 108185 | 496 | 0 | 56.8967 | 12.8034 | 2022-10-02 04:21:23 | Halland, Sweden | |||
853934 | 853934 | 2022-09-30 | Sweden | Halland | 108185 | 496 | 0 | 56.8967 | 12.8034 | 2022-10-01 04:23:01 | Halland, Sweden | |||
2375860 | 2375860 | 2022-09-29 | Sweden | Halland | 108185 | 496 | 0 | 56.8967 | 12.8034 | 2022-09-30 04:23:09 | Halland, Sweden | |||
1560411 | 1560411 | 2022-09-28 | Sweden | Halland | 108032 | 495 | 0 | 56.8967 | 12.8034 | 2022-09-29 04:22:34 | Halland, Sweden | |||
3994954 | 3994954 | 2022-09-27 | Sweden | Halland | 108032 | 495 | 0 | 56.8967 | 12.8034 | 2022-09-28 04:23:01 | Halland, Sweden | |||
2769282 | 2769282 | 2022-09-26 | Sweden | Halland | 108032 | 495 | 0 | 56.8967 | 12.8034 | 2022-09-27 04:23:01 | Halland, Sweden | |||
1976935 | 1976935 | 2022-09-25 | Sweden | Halland | 108032 | 495 | 0 | 56.8967 | 12.8034 | 2022-09-26 04:20:52 | Halland, Sweden | |||
2650102 | 2650102 | 2022-09-24 | Sweden | Halland | 108032 | 495 | 0 | 56.8967 | 12.8034 | 2022-09-25 04:23:31 | Halland, Sweden | |||
384542 | 384542 | 2022-09-23 | Sweden | Halland | 108032 | 495 | 0 | 56.8967 | 12.8034 | 2022-09-24 04:21:40 | Halland, Sweden | |||
1624608 | 1624608 | 2022-09-22 | Sweden | Halland | 108032 | 495 | 0 | 56.8967 | 12.8034 | 2022-09-23 04:23:13 | Halland, Sweden | |||
1370812 | 1370812 | 2022-09-21 | Sweden | Halland | 107880 | 492 | 0 | 56.8967 | 12.8034 | 2022-09-22 04:22:56 | Halland, Sweden |
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]);