johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
322 rows where active = 781 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 26
- US 257
- Russia 20
- Mexico 5
- Chile 4
- Germany 4
- Sweden 4
- Italy 3
- Malaysia 3
- Colombia 2
- Guinea 2
- Japan 2
- Ukraine 2
- Armenia 1
- Azerbaijan 1
- Bahrain 1
- Brazil 1
- Canada 1
- Cote d'Ivoire 1
- Finland 1
- India 1
- Korea, South 1
- Netherlands 1
- North Macedonia 1
- Peru 1
- Sierra Leone 1
- Zimbabwe 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
645618 | 645618 | 2021-09-07 | Malaysia | Perlis | 2392 | 37 | 1574 | 781 | 6.4449 | 100.2048 | 2021-09-08 04:21:31 | Perlis, Malaysia | ||
3331236 | 3331236 | 2021-07-21 | Bahrain | 268092 | 1381 | 265930 | 781 | 26.0275 | 50.55 | 2021-07-22 04:21:19 | Bahrain | |||
778361 | 778361 | 2021-07-08 | Japan | Aichi | 51501 | 979 | 49741 | 781 | 35.035551 | 137.211621 | 2021-07-09 04:21:21 | Aichi, Japan | ||
3125211 | 3125211 | 2021-06-28 | Azerbaijan | 335874 | 4970 | 330123 | 781 | 40.1431 | 47.5769 | 2021-06-29 04:21:28 | Azerbaijan | |||
566605 | 566605 | 2021-06-22 | Ukraine | Sevastopol* | 15787 | 712 | 14294 | 781 | 44.6054 | 33.522 | 2021-06-23 04:21:46 | Sevastopol*, Ukraine | ||
3358866 | 3358866 | 2021-06-21 | Russia | Chuvashia Republic | 26789 | 1504 | 24504 | 781 | 55.4259922 | 47.0849429 | 2021-06-22 04:21:34 | Chuvashia Republic, Russia | ||
2911385 | 2911385 | 2021-06-17 | Russia | Khanty-Mansi Autonomous Okrug | 58593 | 803 | 57009 | 781 | 61.0259025 | 69.0982628 | 2021-06-18 04:22:16 | Khanty-Mansi Autonomous Okrug, Russia | ||
825778 | 825778 | 2021-06-06 | Russia | Chuvashia Republic | 26060 | 1447 | 23832 | 781 | 55.4259922 | 47.0849429 | 2021-06-07 04:22:51 | Chuvashia Republic, Russia | ||
1771604 | 1771604 | 2021-05-23 | Russia | Yamalo-Nenets Autonomous Okrug | 38943 | 417 | 37745 | 781 | 67.1471631 | 74.3415488 | 2021-05-24 04:20:53 | Yamalo-Nenets Autonomous Okrug, Russia | ||
3574507 | 3574507 | 2021-05-17 | Germany | Bremen | 26573 | 468 | 25340 | 781 | 53.0793 | 8.8017 | 2021-05-18 04:20:33 | Bremen, Germany | ||
1082188 | 1082188 | 2021-05-14 | Russia | Zabaykalsky Krai | 42672 | 649 | 41242 | 781 | 52.248521 | 115.956325 | 2021-05-15 04:20:58 | Zabaykalsky Krai, Russia | ||
1081720 | 1081720 | 2021-05-14 | Chile | Tarapaca | 35273 | 644 | 33848 | 781 | -19.9232 | -69.5132 | 2021-05-15 04:20:58 | Tarapaca, Chile | ||
2820965 | 2820965 | 2021-05-10 | Russia | Chuvashia Republic | 24730 | 1388 | 22561 | 781 | 55.4259922 | 47.0849429 | 2021-05-11 04:20:41 | Chuvashia Republic, Russia | ||
380390 | 380390 | 2021-04-30 | Russia | Irkutsk Oblast | 66204 | 2241 | 63182 | 781 | 56.6370122 | 104.719221 | 2021-05-01 04:20:47 | Irkutsk Oblast, Russia | ||
3924009 | 3924009 | 2021-04-24 | Italy | Valle d'Aosta | 10643 | 450 | 9412 | 781 | 45.73750286 | 7.320149366 | 2021-04-25 04:20:32 | Valle d'Aosta, Italy | ||
3129715 | 3129715 | 2021-04-18 | Russia | Chuvashia Republic | 23583 | 1314 | 21488 | 781 | 55.4259922 | 47.0849429 | 2021-04-19 04:20:57 | Chuvashia Republic, Russia | ||
2571930 | 2571930 | 2021-04-13 | Russia | Tula Oblast | 37390 | 1678 | 34931 | 781 | 53.9570701 | 37.3690909 | 2021-04-14 04:20:41 | Tula Oblast, Russia | ||
2571873 | 2571873 | 2021-04-13 | Russia | Chuvashia Republic | 23351 | 1292 | 21278 | 781 | 55.4259922 | 47.0849429 | 2021-04-14 04:20:41 | Chuvashia Republic, Russia | ||
609357 | 609357 | 2021-04-09 | Zimbabwe | 37147 | 1535 | 34831 | 781 | -19.015438 | 29.154857 | 2021-04-10 04:20:59 | Zimbabwe | |||
1536122 | 1536122 | 2021-03-28 | Russia | Chuvashia Republic | 22662 | 1199 | 20682 | 781 | 55.4259922 | 47.0849429 | 2021-03-29 04:28:35 | Chuvashia Republic, Russia | ||
352207 | 352207 | 2021-03-11 | Germany | Bremen | 18688 | 375 | 17599 | 781 | 53.0793 | 8.8017 | 2021-03-12 05:26:50 | Bremen, Germany | ||
3668605 | 3668605 | 2021-03-06 | US | Illinois | Hamilton | 17065 | 796 | 15 | 0 | 781 | 38.08163641 | -88.53883373 | 2021-03-07 05:21:54 | Hamilton, Illinois, US |
1619449 | 1619449 | 2021-03-05 | US | Texas | San Saba | 48411 | 790 | 21 | 0 | 781 | 31.1577796 | -98.81758731 | 2021-03-06 04:23:41 | San Saba, Texas, US |
1091732 | 1091732 | 2021-03-03 | US | Michigan | Missaukee | 26113 | 798 | 17 | 0 | 781 | 44.33772443 | -85.09256478 | 2021-03-04 05:24:24 | Missaukee, Michigan, US |
1939947 | 1939947 | 2021-02-23 | US | West Virginia | Pleasants | 54073 | 798 | 17 | 0 | 781 | 39.37091679 | -81.16771771 | 2021-02-24 05:29:16 | Pleasants, West Virginia, US |
534202 | 534202 | 2021-02-22 | US | West Virginia | Pleasants | 54073 | 798 | 17 | 0 | 781 | 39.37091679 | -81.16771771 | 2021-02-23 05:23:41 | Pleasants, West Virginia, US |
532452 | 532452 | 2021-02-22 | US | Minnesota | Pope | 27121 | 786 | 5 | 0 | 781 | 45.58606667 | -95.44451209 | 2021-02-23 05:23:41 | Pope, Minnesota, US |
183786 | 183786 | 2021-02-21 | US | Minnesota | Pope | 27121 | 786 | 5 | 0 | 781 | 45.58606667 | -95.44451209 | 2021-02-22 05:24:21 | Pope, Minnesota, US |
1154521 | 1154521 | 2021-02-18 | US | Kentucky | Hancock | 21091 | 795 | 14 | 0 | 781 | 37.83766422 | -86.78280584 | 2021-02-19 05:24:16 | Hancock, Kentucky, US |
1154506 | 1154506 | 2021-02-18 | US | Kentucky | Edmonson | 21061 | 799 | 18 | 0 | 781 | 37.21218923 | -86.23955613 | 2021-02-19 05:24:16 | Edmonson, Kentucky, US |
3601243 | 3601243 | 2021-02-17 | Russia | Kalmykia Republic | 18509 | 283 | 17445 | 781 | 46.2313018 | 45.3275745 | 2021-02-18 05:22:58 | Kalmykia Republic, Russia | ||
3051425 | 3051425 | 2021-02-16 | US | Kansas | Anderson | 20003 | 798 | 17 | 0 | 781 | 38.21413251 | -95.29272815 | 2021-02-17 05:23:10 | Anderson, Kansas, US |
1341481 | 1341481 | 2021-02-15 | US | Texas | San Saba | 48411 | 788 | 19 | 0 | 781 | 31.1577796 | -98.81758731 | 2021-02-16 05:24:38 | San Saba, Texas, US |
1339524 | 1339524 | 2021-02-15 | US | Kansas | Anderson | 20003 | 798 | 17 | 0 | 781 | 38.21413251 | -95.29272815 | 2021-02-16 05:24:38 | Anderson, Kansas, US |
2286632 | 2286632 | 2021-02-14 | US | Texas | San Saba | 48411 | 788 | 19 | 0 | 781 | 31.1577796 | -98.81758731 | 2021-02-15 05:24:49 | San Saba, Texas, US |
2283628 | 2283628 | 2021-02-14 | Russia | Kalmykia Republic | 18357 | 279 | 17297 | 781 | 46.2313018 | 45.3275745 | 2021-02-15 05:24:49 | Kalmykia Republic, Russia | ||
2283337 | 2283337 | 2021-02-14 | Germany | Bremen | 16909 | 310 | 15882 | 781 | 53.0793 | 8.8017 | 2021-02-15 05:24:49 | Bremen, Germany | ||
2681032 | 2681032 | 2021-02-13 | US | Texas | San Saba | 48411 | 788 | 19 | 0 | 781 | 31.1577796 | -98.81758731 | 2021-02-14 05:23:43 | San Saba, Texas, US |
2680562 | 2680562 | 2021-02-13 | US | Puerto Rico | Hatillo | 72065 | 781 | 0 | 0 | 781 | 18.410928 | -66.79632600000001 | 2021-02-14 05:23:43 | Hatillo, Puerto Rico, US |
3539420 | 3539420 | 2021-02-12 | India | Odisha | 336042 | 1910 | 333351 | 781 | 20.505428 | 84.418059 | 2021-02-13 05:22:12 | Odisha, India | ||
3982256 | 3982256 | 2021-02-10 | Malaysia | Pahang | 3455 | 12 | 2662 | 781 | 3.8126 | 103.3256 | 2021-02-11 05:23:55 | Pahang, Malaysia | ||
3981318 | 3981318 | 2021-02-10 | US | Puerto Rico | Juana Diaz | 72075 | 781 | 0 | 0 | 781 | 18.050764 | -66.49458100000001 | 2021-02-11 05:23:55 | Juana Diaz, Puerto Rico, US |
1530014 | 1530014 | 2021-02-09 | US | Nebraska | Thurston | 31173 | 790 | 9 | 0 | 781 | 42.15725356 | -96.54157099 | 2021-02-10 05:22:41 | Thurston, Nebraska, US |
1529948 | 1529948 | 2021-02-09 | US | Nebraska | Custer | 31041 | 799 | 18 | 0 | 781 | 41.39374521 | -99.72805369 | 2021-02-10 05:22:41 | Custer, Nebraska, US |
615574 | 615574 | 2021-02-08 | US | Missouri | Dallas | 29059 | 803 | 22 | 0 | 781 | 37.6811355 | -93.02127031 | 2021-02-09 05:23:30 | Dallas, Missouri, US |
1674435 | 1674435 | 2021-02-07 | US | Montana | Carbon | 30009 | 792 | 11 | 0 | 781 | 45.22850116 | -109.0274047 | 2021-02-08 05:22:39 | Carbon, Montana, US |
977263 | 977263 | 2021-02-06 | US | North Carolina | Perquimans | 37143 | 786 | 5 | 0 | 781 | 36.17847453 | -76.40603143 | 2021-02-07 05:23:00 | Perquimans, North Carolina, US |
977035 | 977035 | 2021-02-06 | US | Nebraska | Thurston | 31173 | 790 | 9 | 0 | 781 | 42.15725356 | -96.54157099 | 2021-02-07 05:23:00 | Thurston, Nebraska, US |
976896 | 976896 | 2021-02-06 | US | Montana | Carbon | 30009 | 792 | 11 | 0 | 781 | 45.22850116 | -109.0274047 | 2021-02-07 05:23:00 | Carbon, Montana, US |
976353 | 976353 | 2021-02-06 | US | Kentucky | McLean | 21149 | 806 | 25 | 0 | 781 | 37.5301951 | -87.26803443 | 2021-02-07 05:23:00 | McLean, Kentucky, US |
975927 | 975927 | 2021-02-06 | US | Illinois | Marshall | 17123 | 795 | 14 | 0 | 781 | 41.0327901 | -89.34510444 | 2021-02-07 05:23:00 | Marshall, Illinois, US |
1591731 | 1591731 | 2021-02-05 | US | Wisconsin | Menominee | 55078 | 792 | 11 | 0 | 781 | 45.00422544 | -88.70950714 | 2021-02-06 05:23:55 | Menominee, Wisconsin, US |
1590293 | 1590293 | 2021-02-05 | US | Nebraska | Thurston | 31173 | 790 | 9 | 0 | 781 | 42.15725356 | -96.54157099 | 2021-02-06 05:23:55 | Thurston, Nebraska, US |
1687776 | 1687776 | 2021-02-02 | US | Vermont | Franklin | 50011 | 816 | 35 | 0 | 781 | 44.85627605 | -72.91249563 | 2021-02-03 05:22:52 | Franklin, Vermont, US |
1678441 | 1678441 | 2021-02-01 | US | Missouri | Wayne | 29223 | 790 | 9 | 0 | 781 | 37.11303869 | -90.46001416 | 2021-02-02 05:22:49 | Wayne, Missouri, US |
2482809 | 2482809 | 2021-01-28 | US | Georgia | Montgomery | 13209 | 797 | 16 | 0 | 781 | 32.17201038 | -82.53527476 | 2021-01-29 05:22:23 | Montgomery, Georgia, US |
13715 | 13715 | 2021-01-26 | US | Kentucky | Carroll | 21041 | 791 | 10 | 0 | 781 | 38.66599534 | -85.12601074 | 2021-01-27 05:23:41 | Carroll, Kentucky, US |
1762580 | 1762580 | 2021-01-24 | US | Vermont | Windsor | 50027 | 786 | 5 | 0 | 781 | 43.58010937 | -72.58595157 | 2021-01-25 05:22:16 | Windsor, Vermont, US |
2430233 | 2430233 | 2021-01-23 | US | Virginia | Franklin City | 51620 | 801 | 20 | 0 | 781 | 36.6831435 | -76.93859681 | 2021-01-24 05:22:35 | Franklin City, Virginia, US |
2468698 | 2468698 | 2021-01-22 | US | Missouri | Gasconade | 29073 | 813 | 32 | 0 | 781 | 38.43947277 | -91.50847147 | 2021-01-23 05:22:03 | Gasconade, Missouri, US |
2468255 | 2468255 | 2021-01-22 | US | Kentucky | Pendleton | 21191 | 782 | 1 | 0 | 781 | 38.69607718 | -84.35599463 | 2021-01-23 05:22:03 | Pendleton, Kentucky, US |
436784 | 436784 | 2021-01-21 | US | Kentucky | Magoffin | 21153 | 782 | 1 | 0 | 781 | 37.70820545 | -83.0657714 | 2021-01-22 05:22:10 | Magoffin, Kentucky, US |
1095518 | 1095518 | 2021-01-20 | US | Kentucky | Martin | 21159 | 791 | 10 | 0 | 781 | 37.79990579 | -82.51247478 | 2021-01-21 05:22:01 | Martin, Kentucky, US |
1094900 | 1094900 | 2021-01-20 | US | Georgia | Irwin | 13155 | 803 | 22 | 0 | 781 | 31.60213036 | -83.27501387 | 2021-01-21 05:22:01 | Irwin, Georgia, US |
911448 | 911448 | 2021-01-19 | US | Vermont | Bennington | 50003 | 784 | 3 | 0 | 781 | 43.03519828 | -73.09048868 | 2021-01-20 05:21:54 | Bennington, Vermont, US |
238102 | 238102 | 2021-01-18 | US | Georgia | Seminole | 13253 | 794 | 13 | 0 | 781 | 30.93464824 | -84.86823924 | 2021-01-19 05:22:15 | Seminole, Georgia, US |
237997 | 237997 | 2021-01-18 | US | Georgia | Candler | 13043 | 818 | 37 | 0 | 781 | 32.40209349 | -82.07702563 | 2021-01-19 05:22:15 | Candler, Georgia, US |
3104847 | 3104847 | 2021-01-16 | US | Virginia | Sussex | 51183 | 795 | 14 | 0 | 781 | 36.92432914 | -77.25791182 | 2021-01-17 05:22:17 | Sussex, Virginia, US |
3102053 | 3102053 | 2021-01-16 | US | Colorado | Grand | 8049 | 838 | 5 | 0 | 781 | 40.10603347 | -106.1178042 | 2021-01-17 05:22:17 | Grand, Colorado, US |
3880790 | 3880790 | 2021-01-14 | US | Iowa | Monroe | 19135 | 799 | 18 | 0 | 781 | 41.02988815 | -92.8690667 | 2021-01-15 05:22:24 | Monroe, Iowa, US |
3311693 | 3311693 | 2021-01-13 | US | West Virginia | Morgan | 54065 | 790 | 9 | 0 | 781 | 39.55439028 | -78.26311676 | 2021-01-14 05:22:32 | Morgan, West Virginia, US |
777066 | 777066 | 2021-01-12 | US | Puerto Rico | Cayey | 72035 | 781 | 0 | 0 | 781 | 18.102851 | -66.14914 | 2021-01-13 05:22:15 | Cayey, Puerto Rico, US |
774622 | 774622 | 2021-01-12 | Sierra Leone | 2864 | 77 | 2006 | 781 | 8.460555000000001 | -11.779889 | 2021-01-13 05:22:15 | Sierra Leone | |||
191532 | 191532 | 2021-01-11 | US | Kentucky | Trigg | 21221 | 784 | 3 | 0 | 781 | 36.80767017 | -87.87333656 | 2021-01-12 05:22:15 | Trigg, Kentucky, US |
2628432 | 2628432 | 2021-01-10 | US | Oklahoma | Major | 40093 | 785 | 4 | 0 | 781 | 36.31149996 | -98.53467076 | 2021-01-11 05:21:50 | Major, Oklahoma, US |
2626485 | 2626485 | 2021-01-10 | US | Colorado | Gunnison | 8051 | 933 | 6 | 0 | 781 | 38.66611652 | -107.0320729 | 2021-01-11 05:21:50 | Gunnison, Colorado, US |
156127 | 156127 | 2021-01-08 | US | New Hampshire | Coos | 33007 | 797 | 16 | 0 | 781 | 44.69063265 | -71.30633239 | 2021-01-09 05:22:18 | Coos, New Hampshire, US |
155826 | 155826 | 2021-01-08 | US | Mississippi | Tunica | 28143 | 800 | 19 | 0 | 781 | 34.64967704 | -90.37481167 | 2021-01-09 05:22:18 | Tunica, Mississippi, US |
2544547 | 2544547 | 2021-01-07 | US | Texas | Lampasas | 48281 | 1148 | 15 | 0 | 781 | 31.19531316 | -98.24206613 | 2021-01-08 05:22:42 | Lampasas, Texas, US |
2543504 | 2543504 | 2021-01-07 | US | Nebraska | Phelps | 31137 | 789 | 8 | 0 | 781 | 40.51156033 | -99.41461667 | 2021-01-08 05:22:42 | Phelps, Nebraska, US |
2541927 | 2541927 | 2021-01-07 | US | Arkansas | Stone | 5137 | 808 | 27 | 0 | 781 | 35.86251946 | -92.15684085 | 2021-01-08 05:22:42 | Stone, Arkansas, US |
3037651 | 3037651 | 2021-01-05 | US | Virginia | King George | 51099 | 791 | 10 | 0 | 781 | 38.26818502 | -77.15852768 | 2021-01-06 05:22:16 | King George, Virginia, US |
3037336 | 3037336 | 2021-01-05 | US | Texas | Castro | 48069 | 1031 | 15 | 0 | 781 | 34.53016752 | -102.2617243 | 2021-01-06 05:22:16 | Castro, Texas, US |
3035773 | 3035773 | 2021-01-05 | US | Kentucky | Webster | 21233 | 793 | 12 | 0 | 781 | 37.52168356 | -87.67989953 | 2021-01-06 05:22:16 | Webster, Kentucky, US |
3035008 | 3035008 | 2021-01-05 | US | Florida | Liberty | 12077 | 795 | 14 | 0 | 781 | 30.23766008 | -84.8829258 | 2021-01-06 05:22:16 | Liberty, Florida, US |
1064876 | 1064876 | 2021-01-04 | US | Texas | Callahan | 48059 | 792 | 20 | 0 | 781 | 32.29760619 | -99.37326312 | 2021-01-05 05:21:49 | Callahan, Texas, US |
1063268 | 1063268 | 2021-01-04 | US | Kentucky | Lewis | 21135 | 806 | 25 | 0 | 781 | 38.53184419 | -83.37735618 | 2021-01-05 05:21:49 | Lewis, Kentucky, US |
3233479 | 3233479 | 2021-01-03 | US | Texas | Callahan | 48059 | 792 | 20 | 0 | 781 | 32.29760619 | -99.37326312 | 2021-01-04 05:22:02 | Callahan, Texas, US |
3232210 | 3232210 | 2021-01-03 | US | Minnesota | Swift | 27151 | 797 | 16 | 0 | 781 | 45.2829032 | -95.68264092 | 2021-01-04 05:22:02 | Swift, Minnesota, US |
3231871 | 3231871 | 2021-01-03 | US | Kentucky | Lewis | 21135 | 805 | 24 | 0 | 781 | 38.53184419 | -83.37735618 | 2021-01-04 05:22:02 | Lewis, Kentucky, US |
1139141 | 1139141 | 2021-01-01 | US | New York | Seneca | 36099 | 817 | 36 | 0 | 781 | 42.78081007 | -76.82497064 | 2021-01-02 05:22:33 | Seneca, New York, US |
1012315 | 1012315 | 2020-12-30 | US | Montana | Powell | 30077 | 786 | 5 | 0 | 781 | 46.85538891 | -112.9359164 | 2020-12-31 05:22:49 | Powell, Montana, US |
768330 | 768330 | 2020-12-29 | US | Montana | Powell | 30077 | 786 | 5 | 0 | 781 | 46.85538891 | -112.9359164 | 2020-12-30 05:22:34 | Powell, Montana, US |
3763594 | 3763594 | 2020-12-28 | US | Montana | Powell | 30077 | 786 | 5 | 0 | 781 | 46.85538891 | -112.9359164 | 2020-12-29 05:22:37 | Powell, Montana, US |
3780656 | 3780656 | 2020-12-27 | US | Puerto Rico | Morovis | 72101 | 781 | 0 | 0 | 781 | 18.316963 | -66.420383 | 2020-12-28 05:22:06 | Morovis, Puerto Rico, US |
3780196 | 3780196 | 2020-12-27 | US | North Carolina | Chowan | 37041 | 801 | 20 | 0 | 781 | 36.12908077 | -76.60118385 | 2020-12-28 05:22:06 | Chowan, North Carolina, US |
2224884 | 2224884 | 2020-12-26 | US | Kentucky | Casey | 21045 | 804 | 23 | 0 | 781 | 37.32533118 | -84.92726209 | 2020-12-27 05:22:55 | Casey, Kentucky, US |
204398 | 204398 | 2020-12-25 | US | New Hampshire | Carroll | 33003 | 784 | 3 | 0 | 781 | 43.87498583 | -71.20430216 | 2020-12-26 05:22:28 | Carroll, New Hampshire, US |
3693621 | 3693621 | 2020-12-24 | US | New Hampshire | Carroll | 33003 | 784 | 3 | 0 | 781 | 43.87498583 | -71.20430216 | 2020-12-25 05:22:48 | Carroll, New Hampshire, US |
2406630 | 2406630 | 2020-12-23 | Chile | Valparaiso | 34670 | 1214 | 32675 | 781 | -33.0472 | -71.6127 | 2020-12-24 05:23:04 | Valparaiso, Chile |
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]);