johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
205 rows where active = 1143 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1893069 | 1893069 | 2021-06-30 | Guinea | 23770 | 171 | 22456 | 1143 | 9.9456 | -9.6966 | 2021-07-01 04:21:19 | Guinea | |||
107700 | 107700 | 2021-06-19 | Russia | Stavropol Krai | 55987 | 1612 | 53232 | 1143 | 44.86325770000001 | 43.4406913 | 2021-06-20 04:21:48 | Stavropol Krai, Russia | ||
54432 | 54432 | 2021-05-29 | Ukraine | Zakarpattia Oblast | 61611 | 1586 | 58882 | 1143 | 48.6208 | 22.2879 | 2021-05-30 04:20:55 | Zakarpattia Oblast, Ukraine | ||
1912983 | 1912983 | 2021-05-20 | Canada | Nova Scotia | 5065 | 74 | 3848 | 1143 | 44.682 | -63.7443 | 2021-05-21 04:20:43 | Nova Scotia, Canada | ||
1873209 | 1873209 | 2021-05-15 | Russia | Tyumen Oblast | 35897 | 502 | 34252 | 1143 | 58.8206488 | 70.36588370000001 | 2021-05-16 04:20:49 | Tyumen Oblast, Russia | ||
3705793 | 3705793 | 2021-04-27 | Malaysia | Sabah | 57830 | 433 | 56254 | 1143 | 5.9788 | 116.0753 | 2021-04-28 04:20:32 | Sabah, Malaysia | ||
2552557 | 2552557 | 2021-04-15 | Malaysia | Sabah | 56368 | 410 | 54815 | 1143 | 5.9788 | 116.0753 | 2021-04-16 04:20:46 | Sabah, Malaysia | ||
2548898 | 2548898 | 2021-04-15 | Japan | Miyagi | 7421 | 44 | 6234 | 1143 | 38.446859 | 140.927086 | 2021-04-16 04:20:46 | Miyagi, Japan | ||
2645867 | 2645867 | 2021-04-08 | Namibia | 45054 | 557 | 43354 | 1143 | -22.9576 | 18.4904 | 2021-04-09 04:21:13 | Namibia | |||
241485 | 241485 | 2021-04-02 | Russia | Novosibirsk Oblast | 38929 | 1636 | 36150 | 1143 | 54.9720169 | 79.48139240000002 | 2021-04-03 04:20:44 | Novosibirsk Oblast, Russia | ||
3453108 | 3453108 | 2021-03-18 | Russia | Tula Oblast | 35012 | 1431 | 32438 | 1143 | 53.9570701 | 37.3690909 | 2021-03-19 05:26:09 | Tula Oblast, Russia | ||
1618944 | 1618944 | 2021-03-05 | US | Pennsylvania | Wyoming | 42131 | 1185 | 42 | 0 | 1143 | 41.51955538 | -76.01074915 | 2021-03-06 04:23:41 | Wyoming, Pennsylvania, US |
2210359 | 2210359 | 2021-03-04 | US | Puerto Rico | Aguadilla | 72005 | 1143 | 0 | 0 | 1143 | 18.459681 | -67.12081500000001 | 2021-03-05 05:26:29 | Aguadilla, Puerto Rico, US |
2207421 | 2207421 | 2021-03-04 | Canada | Manitoba | 32051 | 903 | 30005 | 1143 | 53.7609 | -98.8139 | 2021-03-05 05:26:29 | Manitoba, Canada | ||
1089993 | 1089993 | 2021-03-03 | Germany | Saarland | 29097 | 876 | 27204 | 1143 | 49.3964 | 7.023 | 2021-03-04 05:24:24 | Saarland, Germany | ||
3256667 | 3256667 | 2021-03-02 | US | Oklahoma | Alfalfa | 40003 | 1148 | 5 | 0 | 1143 | 36.73090616 | -98.32408495 | 2021-03-03 05:23:28 | Alfalfa, Oklahoma, US |
3255899 | 3255899 | 2021-03-02 | US | Minnesota | Rock | 27133 | 1157 | 14 | 0 | 1143 | 43.67482683 | -96.25296832 | 2021-03-03 05:23:28 | Rock, Minnesota, US |
1000959 | 1000959 | 2021-03-01 | US | Oklahoma | Alfalfa | 40003 | 1148 | 5 | 0 | 1143 | 36.73090616 | -98.32408495 | 2021-03-02 05:23:30 | Alfalfa, Oklahoma, US |
1000799 | 1000799 | 2021-03-01 | US | North Carolina | Swain | 37173 | 1159 | 16 | 0 | 1143 | 35.48665845 | -83.48748932 | 2021-03-02 05:23:30 | Swain, North Carolina, US |
1000191 | 1000191 | 2021-03-01 | US | Minnesota | Rock | 27133 | 1157 | 14 | 0 | 1143 | 43.67482683 | -96.25296832 | 2021-03-02 05:23:30 | Rock, Minnesota, US |
2370017 | 2370017 | 2021-02-28 | US | Oklahoma | Alfalfa | 40003 | 1148 | 5 | 0 | 1143 | 36.73090616 | -98.32408495 | 2021-03-01 05:23:01 | Alfalfa, Oklahoma, US |
2369857 | 2369857 | 2021-02-28 | US | North Carolina | Swain | 37173 | 1159 | 16 | 0 | 1143 | 35.48665845 | -83.48748932 | 2021-03-01 05:23:01 | Swain, North Carolina, US |
2369249 | 2369249 | 2021-02-28 | US | Minnesota | Rock | 27133 | 1157 | 14 | 0 | 1143 | 43.67482683 | -96.25296832 | 2021-03-01 05:23:01 | Rock, Minnesota, US |
3068359 | 3068359 | 2021-02-27 | US | North Carolina | Swain | 37173 | 1159 | 16 | 0 | 1143 | 35.48665845 | -83.48748932 | 2021-02-28 05:22:20 | Swain, North Carolina, US |
1859757 | 1859757 | 2021-02-25 | US | Minnesota | Rock | 27133 | 1156 | 13 | 0 | 1143 | 43.67482683 | -96.25296832 | 2021-02-26 05:22:40 | Rock, Minnesota, US |
1858935 | 1858935 | 2021-02-25 | US | Idaho | Idaho | 16049 | 1160 | 17 | 0 | 1143 | 45.84721541 | -115.4634436 | 2021-02-26 05:22:40 | Idaho, Idaho, US |
281952 | 281952 | 2021-02-24 | US | Minnesota | Watonwan | 27165 | 1151 | 8 | 0 | 1143 | 43.97823903 | -94.61413846 | 2021-02-25 05:24:57 | Watonwan, Minnesota, US |
281113 | 281113 | 2021-02-24 | US | Idaho | Idaho | 16049 | 1160 | 17 | 0 | 1143 | 45.84721541 | -115.4634436 | 2021-02-25 05:24:57 | Idaho, Idaho, US |
280707 | 280707 | 2021-02-24 | US | Arkansas | Van Buren | 5141 | 1161 | 18 | 0 | 1143 | 35.58095779 | -92.51295036 | 2021-02-25 05:24:57 | Van Buren, Arkansas, US |
1939680 | 1939680 | 2021-02-23 | US | Texas | Tyler | 48457 | 1258 | 32 | 0 | 1143 | 30.77031716 | -94.37690895 | 2021-02-24 05:29:16 | Tyler, Texas, US |
1938137 | 1938137 | 2021-02-23 | US | Minnesota | Aitkin | 27001 | 1176 | 33 | 0 | 1143 | 46.60962049 | -93.4116826 | 2021-02-24 05:29:16 | Aitkin, Minnesota, US |
1937381 | 1937381 | 2021-02-23 | US | Idaho | Idaho | 16049 | 1160 | 17 | 0 | 1143 | 45.84721541 | -115.4634436 | 2021-02-24 05:29:16 | Idaho, Idaho, US |
531934 | 531934 | 2021-02-22 | US | Iowa | Sac | 19161 | 1161 | 18 | 0 | 1143 | 42.38624071 | -95.10547892 | 2021-02-23 05:23:41 | Sac, Iowa, US |
531636 | 531636 | 2021-02-22 | US | Idaho | Idaho | 16049 | 1160 | 17 | 0 | 1143 | 45.84721541 | -115.4634436 | 2021-02-23 05:23:41 | Idaho, Idaho, US |
744143 | 744143 | 2021-02-20 | US | Mississippi | Perry | 28111 | 1176 | 33 | 0 | 1143 | 31.17161885 | -88.99281835 | 2021-02-21 05:24:33 | Perry, Mississippi, US |
743542 | 743542 | 2021-02-20 | US | Iowa | Sac | 19161 | 1160 | 17 | 0 | 1143 | 42.38624071 | -95.10547892 | 2021-02-21 05:24:33 | Sac, Iowa, US |
473669 | 473669 | 2021-02-19 | US | New York | Schoharie | 36095 | 1154 | 11 | 0 | 1143 | 42.58831742 | -74.44339029999998 | 2021-02-20 05:22:51 | Schoharie, New York, US |
472640 | 472640 | 2021-02-19 | US | Iowa | Sac | 19161 | 1160 | 17 | 0 | 1143 | 42.38624071 | -95.10547892 | 2021-02-20 05:22:51 | Sac, Iowa, US |
3602277 | 3602277 | 2021-02-17 | US | Iowa | Union | 19175 | 1174 | 31 | 0 | 1143 | 41.0277278 | -94.24234847 | 2021-02-18 05:22:58 | Union, Iowa, US |
2681162 | 2681162 | 2021-02-13 | US | Virginia | Goochland | 51075 | 1151 | 8 | 0 | 1143 | 37.71714806 | -77.90381514 | 2021-02-14 05:23:43 | Goochland, Virginia, US |
2681126 | 2681126 | 2021-02-13 | US | Virginia | Brunswick | 51025 | 1153 | 10 | 0 | 1143 | 36.76366949 | -77.8593436 | 2021-02-14 05:23:43 | Brunswick, Virginia, US |
2680030 | 2680030 | 2021-02-13 | US | New Mexico | Socorro | 35053 | 1193 | 50 | 0 | 1143 | 34.00715494 | -106.9298354 | 2021-02-14 05:23:43 | Socorro, New Mexico, US |
2679232 | 2679232 | 2021-02-13 | US | Kentucky | Henry | 21103 | 1149 | 6 | 0 | 1143 | 38.44942688 | -85.11587507 | 2021-02-14 05:23:43 | Henry, Kentucky, US |
2678977 | 2678977 | 2021-02-13 | US | Iowa | Appanoose | 19007 | 1189 | 46 | 0 | 1143 | 40.74324454 | -92.86865906 | 2021-02-14 05:23:43 | Appanoose, Iowa, US |
3542853 | 3542853 | 2021-02-12 | US | Virginia | Rockbridge | 51163 | 1172 | 29 | 0 | 1143 | 37.81204314 | -79.44605905 | 2021-02-13 05:22:12 | Rockbridge, Virginia, US |
3542469 | 3542469 | 2021-02-12 | US | Texas | Bandera | 48019 | 1274 | 22 | 0 | 1143 | 29.74619598 | -99.24598147 | 2021-02-13 05:22:12 | Bandera, Texas, US |
3541281 | 3541281 | 2021-02-12 | US | Mississippi | Montgomery | 28097 | 1180 | 37 | 0 | 1143 | 33.49419589 | -89.61729103 | 2021-02-13 05:22:12 | Montgomery, Mississippi, US |
3540868 | 3540868 | 2021-02-12 | US | Kentucky | Jackson | 21109 | 1171 | 28 | 0 | 1143 | 37.41866422 | -83.99825483 | 2021-02-13 05:22:12 | Jackson, Kentucky, US |
2640597 | 2640597 | 2021-02-11 | US | South Dakota | Lake | 46079 | 1160 | 17 | 0 | 1143 | 44.02193107 | -97.12926365 | 2021-02-12 05:23:29 | Lake, South Dakota, US |
2640324 | 2640324 | 2021-02-11 | US | Oregon | Columbia | 41009 | 1164 | 21 | 0 | 1143 | 45.94464254 | -123.0890898 | 2021-02-12 05:23:29 | Columbia, Oregon, US |
2639131 | 2639131 | 2021-02-11 | US | Kentucky | Jackson | 21109 | 1170 | 27 | 0 | 1143 | 37.41866422 | -83.99825483 | 2021-02-12 05:23:29 | Jackson, Kentucky, US |
1529315 | 1529315 | 2021-02-09 | US | Kentucky | Lawrence | 21127 | 1156 | 13 | 0 | 1143 | 38.07136018 | -82.72882223 | 2021-02-10 05:22:41 | Lawrence, Kentucky, US |
614901 | 614901 | 2021-02-08 | US | Iowa | Mitchell | 19131 | 1182 | 39 | 0 | 1143 | 43.35638371 | -92.78887719 | 2021-02-09 05:23:30 | Mitchell, Iowa, US |
1673670 | 1673670 | 2021-02-07 | US | Iowa | Mitchell | 19131 | 1182 | 39 | 0 | 1143 | 43.35638371 | -92.78887719 | 2021-02-08 05:22:39 | Mitchell, Iowa, US |
976131 | 976131 | 2021-02-06 | US | Iowa | Mitchell | 19131 | 1182 | 39 | 0 | 1143 | 43.35638371 | -92.78887719 | 2021-02-07 05:23:00 | Mitchell, Iowa, US |
975323 | 975323 | 2021-02-06 | US | Alabama | Wilcox | 1131 | 1165 | 22 | 0 | 1143 | 31.98773215 | -87.30891118 | 2021-02-07 05:23:00 | Wilcox, Alabama, US |
1589389 | 1589389 | 2021-02-05 | US | Iowa | Mitchell | 19131 | 1182 | 39 | 0 | 1143 | 43.35638371 | -92.78887719 | 2021-02-06 05:23:55 | Mitchell, Iowa, US |
1589342 | 1589342 | 2021-02-05 | US | Iowa | Chickasaw | 19037 | 1155 | 12 | 0 | 1143 | 43.06001295 | -92.31773347 | 2021-02-06 05:23:55 | Chickasaw, Iowa, US |
1589047 | 1589047 | 2021-02-05 | US | Georgia | Telfair | 13271 | 1189 | 46 | 0 | 1143 | 31.92829517 | -82.93491155 | 2021-02-06 05:23:55 | Telfair, Georgia, US |
791596 | 791596 | 2021-02-04 | US | Iowa | Mitchell | 19131 | 1182 | 39 | 0 | 1143 | 43.35638371 | -92.78887719 | 2021-02-05 05:22:38 | Mitchell, Iowa, US |
791333 | 791333 | 2021-02-04 | US | Idaho | Washington | 16087 | 1163 | 20 | 0 | 1143 | 44.45275475 | -116.7847688 | 2021-02-05 05:22:38 | Washington, Idaho, US |
341488 | 341488 | 2021-02-03 | US | Iowa | Mitchell | 19131 | 1182 | 39 | 0 | 1143 | 43.35638371 | -92.78887719 | 2021-02-04 05:22:26 | Mitchell, Iowa, US |
341225 | 341225 | 2021-02-03 | US | Idaho | Washington | 16087 | 1163 | 20 | 0 | 1143 | 44.45275475 | -116.7847688 | 2021-02-04 05:22:26 | Washington, Idaho, US |
1686903 | 1686903 | 2021-02-02 | US | North Dakota | McLean | 38055 | 1179 | 31 | 0 | 1143 | 47.60766714 | -101.3182418 | 2021-02-03 05:22:52 | McLean, North Dakota, US |
1679020 | 1679020 | 2021-02-01 | US | Oklahoma | Haskell | 40061 | 1151 | 8 | 0 | 1143 | 35.22257600000001 | -95.11513306 | 2021-02-02 05:22:49 | Haskell, Oklahoma, US |
1678873 | 1678873 | 2021-02-01 | US | North Dakota | McLean | 38055 | 1173 | 31 | 0 | 1143 | 47.60766714 | -101.3182418 | 2021-02-02 05:22:49 | McLean, North Dakota, US |
1678296 | 1678296 | 2021-02-01 | US | Mississippi | Noxubee | 28103 | 1170 | 27 | 0 | 1143 | 33.11009499 | -88.56949061 | 2021-02-02 05:22:49 | Noxubee, Mississippi, US |
1678265 | 1678265 | 2021-02-01 | US | Mississippi | Greene | 28041 | 1174 | 31 | 0 | 1143 | 31.21444233 | -88.63922281 | 2021-02-02 05:22:49 | Greene, Mississippi, US |
1677060 | 1677060 | 2021-02-01 | US | Colorado | Alamosa | 8003 | 1247 | 29 | 0 | 1143 | 37.57250606 | -105.7885451 | 2021-02-02 05:22:49 | Alamosa, Colorado, US |
1462161 | 1462161 | 2021-01-31 | US | North Dakota | McLean | 38055 | 1172 | 31 | 0 | 1143 | 47.60766714 | -101.3182418 | 2021-02-01 05:22:53 | McLean, North Dakota, US |
2214069 | 2214069 | 2021-01-30 | US | North Dakota | McLean | 38055 | 1172 | 31 | 0 | 1143 | 47.60766714 | -101.3182418 | 2021-01-31 05:22:42 | McLean, North Dakota, US |
2213137 | 2213137 | 2021-01-30 | US | Kentucky | Washington | 21229 | 1165 | 22 | 0 | 1143 | 37.75599461 | -85.17407732 | 2021-01-31 05:22:42 | Washington, Kentucky, US |
1900218 | 1900218 | 2021-01-29 | US | Texas | Dimmit | 48127 | 1258 | 18 | 0 | 1143 | 28.42270064 | -99.75645095 | 2021-01-30 05:22:49 | Dimmit, Texas, US |
1899556 | 1899556 | 2021-01-29 | US | North Dakota | McLean | 38055 | 1172 | 31 | 0 | 1143 | 47.60766714 | -101.3182418 | 2021-01-30 05:22:49 | McLean, North Dakota, US |
1899002 | 1899002 | 2021-01-29 | US | Mississippi | Walthall | 28147 | 1181 | 38 | 0 | 1143 | 31.14971548 | -90.10446654 | 2021-01-30 05:22:49 | Walthall, Mississippi, US |
1898806 | 1898806 | 2021-01-29 | US | Michigan | Mason | 26105 | 1169 | 26 | 0 | 1143 | 43.99509218 | -86.24988902 | 2021-01-30 05:22:49 | Mason, Michigan, US |
15932 | 15932 | 2021-01-26 | US | Wyoming | Carbon | 56007 | 1161 | 18 | 0 | 1143 | 41.69357844 | -106.9326084 | 2021-01-27 05:23:41 | Carbon, Wyoming, US |
436325 | 436325 | 2021-01-21 | US | Illinois | De Witt | 17039 | 1163 | 20 | 0 | 1143 | 40.17514519 | -88.90959682 | 2021-01-22 05:22:10 | De Witt, Illinois, US |
909193 | 909193 | 2021-01-19 | US | Illinois | Mercer | 17131 | 1172 | 29 | 0 | 1143 | 41.20596782 | -90.74290052 | 2021-01-20 05:21:54 | Mercer, Illinois, US |
240394 | 240394 | 2021-01-18 | US | Texas | Madison | 48313 | 1420 | 19 | 0 | 1143 | 30.96694679 | -95.93003775 | 2021-01-19 05:22:15 | Madison, Texas, US |
3503715 | 3503715 | 2021-01-17 | US | Alabama | Crenshaw | 1041 | 1187 | 44 | 0 | 1143 | 31.72941803 | -86.31593104 | 2021-01-18 05:22:34 | Crenshaw, Alabama, US |
3517036 | 3517036 | 2021-01-15 | US | Michigan | Iosco | 26069 | 1199 | 56 | 0 | 1143 | 44.35486835 | -83.63484895 | 2021-01-16 05:22:40 | Iosco, Michigan, US |
3880818 | 3880818 | 2021-01-14 | US | Iowa | Winnebago | 19189 | 1172 | 29 | 0 | 1143 | 43.37751174 | -93.73407298 | 2021-01-15 05:22:24 | Winnebago, Iowa, US |
775096 | 775096 | 2021-01-12 | US | Georgia | Brantley | 13025 | 1166 | 23 | 0 | 1143 | 31.19576557 | -81.97743999 | 2021-01-13 05:22:15 | Brantley, Georgia, US |
192628 | 192628 | 2021-01-11 | US | Oklahoma | Love | 40085 | 1151 | 8 | 0 | 1143 | 33.95273467 | -97.23906784 | 2021-01-12 05:22:15 | Love, Oklahoma, US |
2629202 | 2629202 | 2021-01-10 | US | Virginia | Fredericksburg | 51630 | 1154 | 11 | 0 | 1143 | 38.2977863 | -77.4922454 | 2021-01-11 05:21:50 | Fredericksburg, Virginia, US |
2628717 | 2628717 | 2021-01-10 | US | South Dakota | Charles Mix | 46023 | 1156 | 13 | 0 | 1143 | 43.20660134 | -98.58856175 | 2021-01-11 05:21:50 | Charles Mix, South Dakota, US |
157563 | 157563 | 2021-01-08 | US | Wisconsin | Washburn | 55129 | 1160 | 17 | 0 | 1143 | 45.89838588 | -91.79050449 | 2021-01-09 05:22:18 | Washburn, Wisconsin, US |
157466 | 157466 | 2021-01-08 | US | West Virginia | Mason | 54053 | 1164 | 21 | 0 | 1143 | 38.77071799 | -82.02524219 | 2021-01-09 05:22:18 | Mason, West Virginia, US |
155338 | 155338 | 2021-01-08 | US | Kentucky | Anderson | 21005 | 1146 | 3 | 0 | 1143 | 38.00671029 | -84.99171713 | 2021-01-09 05:22:18 | Anderson, Kentucky, US |
2543171 | 2543171 | 2021-01-07 | US | Minnesota | Wadena | 27159 | 1155 | 12 | 0 | 1143 | 46.58589171 | -94.96968506 | 2021-01-08 05:22:42 | Wadena, Minnesota, US |
2541417 | 2541417 | 2021-01-07 | Japan | Hiroshima | 3832 | 54 | 2635 | 1143 | 34.605309000000005 | 132.788719 | 2021-01-08 05:22:42 | Hiroshima, Japan | ||
3232559 | 3232559 | 2021-01-03 | US | Nebraska | Seward | 31159 | 1164 | 21 | 0 | 1143 | 40.87241834 | -97.139673 | 2021-01-04 05:22:02 | Seward, Nebraska, US |
3231132 | 3231132 | 2021-01-03 | US | Florida | Dixie | 12029 | 1154 | 11 | 0 | 1143 | 29.60631086 | -83.15724673 | 2021-01-04 05:22:02 | Dixie, Florida, US |
1140279 | 1140279 | 2021-01-01 | US | Virginia | Salem | 51775 | 1170 | 27 | 0 | 1143 | 37.2836193 | -80.06219455 | 2021-01-02 05:22:33 | Salem, Virginia, US |
1139778 | 1139778 | 2021-01-01 | US | South Dakota | Todd | 46121 | 1162 | 19 | 0 | 1143 | 43.19338568 | -100.7195503 | 2021-01-02 05:22:33 | Todd, South Dakota, US |
3698384 | 3698384 | 2020-12-31 | US | South Dakota | Todd | 46121 | 1162 | 19 | 0 | 1143 | 43.19338568 | -100.7195503 | 2021-01-01 05:23:07 | Todd, South Dakota, US |
3696022 | 3696022 | 2020-12-31 | US | California | Calaveras | 6009 | 1164 | 21 | 0 | 1143 | 38.20537103 | -120.552913 | 2021-01-01 05:23:07 | Calaveras, California, US |
3695692 | 3695692 | 2020-12-31 | Russia | Kaluga Oblast | 21049 | 172 | 19734 | 1143 | 54.4382773 | 35.5272854 | 2021-01-01 05:23:07 | Kaluga Oblast, Russia | ||
1012917 | 1012917 | 2020-12-30 | US | Oregon | Josephine | 41033 | 1165 | 22 | 0 | 1143 | 42.3665549 | -123.5561938 | 2020-12-31 05:22:49 | Josephine, Oregon, US |
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]);