johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
236 rows where active = 1070 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
829874 | 829874 | 2021-07-09 | Seychelles | 16679 | 68 | 15541 | 1070 | -4.6796 | 55.492 | 2021-07-10 04:21:25 | Seychelles | |||
1440543 | 1440543 | 2021-07-07 | India | Nagaland | 25663 | 505 | 24088 | 1070 | 26.06702 | 94.470302 | 2021-07-08 04:21:26 | Nagaland, India | ||
1495803 | 1495803 | 2021-07-03 | Russia | Ivanovo Oblast | 38464 | 1301 | 36093 | 1070 | 56.9167446 | 41.43521370000001 | 2021-07-04 04:21:38 | Ivanovo Oblast, Russia | ||
2075541 | 2075541 | 2021-07-02 | Ukraine | Dnipropetrovsk Oblast | 135641 | 4439 | 130132 | 1070 | 48.4647 | 35.0462 | 2021-07-03 04:21:37 | Dnipropetrovsk Oblast, Ukraine | ||
3970807 | 3970807 | 2021-06-11 | Russia | Ulyanovsk Oblast | 56856 | 1472 | 54314 | 1070 | 54.1463177 | 47.2324921 | 2021-06-12 04:22:22 | Ulyanovsk Oblast, Russia | ||
1708449 | 1708449 | 2021-06-02 | North Macedonia | 155345 | 5429 | 148846 | 1070 | 41.6086 | 21.7453 | 2021-06-03 04:23:32 | North Macedonia | |||
1085603 | 1085603 | 2021-05-14 | Malaysia | Pahang | 6251 | 27 | 5154 | 1070 | 3.8126 | 103.3256 | 2021-05-15 04:20:58 | Pahang, Malaysia | ||
3054430 | 3054430 | 2021-05-13 | Russia | Ryazan Oblast | 28387 | 481 | 26836 | 1070 | 54.42267320000001 | 40.57052460000001 | 2021-05-14 04:20:41 | Ryazan Oblast, Russia | ||
2505703 | 2505703 | 2021-05-07 | Malaysia | Kedah | 10839 | 29 | 9740 | 1070 | 6.1184 | 100.3685 | 2021-05-08 04:21:04 | Kedah, Malaysia | ||
3393363 | 3393363 | 2021-04-28 | India | Tripura | 35028 | 396 | 33562 | 1070 | 23.746783 | 91.743565 | 2021-04-29 04:20:55 | Tripura, India | ||
954652 | 954652 | 2021-04-25 | Chile | Coquimbo | 31224 | 604 | 29550 | 1070 | -29.959 | -71.3389 | 2021-04-26 04:21:04 | Coquimbo, Chile | ||
1302277 | 1302277 | 2021-04-01 | Russia | Murmansk Oblast | 49139 | 1084 | 46985 | 1070 | 68.00004179999999 | 33.9999151 | 2021-04-02 04:20:36 | Murmansk Oblast, Russia | ||
641610 | 641610 | 2021-03-31 | Malaysia | W.P. Kuala Lumpur | 37819 | 118 | 36631 | 1070 | 3.139 | 101.6869 | 2021-04-01 04:27:05 | W.P. Kuala Lumpur, Malaysia | ||
2359385 | 2359385 | 2021-03-08 | Germany | Saarland | 29563 | 891 | 27621 | 1070 | 49.3964 | 7.023 | 2021-03-09 05:28:19 | Saarland, Germany | ||
3256300 | 3256300 | 2021-03-02 | US | New Hampshire | Unassigned | 90033 | 1075 | 5 | 0 | 1070 | 44.69063265 | 0.0 | 2021-03-03 05:23:28 | Unassigned, New Hampshire, US |
3255329 | 3255329 | 2021-03-02 | US | Iowa | Franklin | 19069 | 1089 | 19 | 0 | 1070 | 42.73270384 | -93.26256925 | 2021-03-03 05:23:28 | Franklin, Iowa, US |
1001944 | 1001944 | 2021-03-01 | US | West Virginia | Taylor | 54091 | 1091 | 21 | 0 | 1070 | 39.33602617 | -80.0421439 | 2021-03-02 05:23:30 | Taylor, West Virginia, US |
999979 | 999979 | 2021-03-01 | US | Louisiana | West Feliciana | 22125 | 1101 | 31 | 0 | 1070 | 30.87882871 | -91.4148538 | 2021-03-02 05:23:30 | West Feliciana, Louisiana, US |
999621 | 999621 | 2021-03-01 | US | Iowa | Franklin | 19069 | 1089 | 19 | 0 | 1070 | 42.73270384 | -93.26256925 | 2021-03-02 05:23:30 | Franklin, Iowa, US |
2368679 | 2368679 | 2021-02-28 | US | Iowa | Franklin | 19069 | 1089 | 19 | 0 | 1070 | 42.73270384 | -93.26256925 | 2021-03-01 05:23:01 | Franklin, Iowa, US |
2368443 | 2368443 | 2021-02-28 | US | Idaho | Teton | 16081 | 1074 | 4 | 0 | 1070 | 43.75303583 | -111.2056773 | 2021-03-01 05:23:01 | Teton, Idaho, US |
3067181 | 3067181 | 2021-02-27 | US | Iowa | Franklin | 19069 | 1089 | 19 | 0 | 1070 | 42.73270384 | -93.26256925 | 2021-02-28 05:22:20 | Franklin, Iowa, US |
3066945 | 3066945 | 2021-02-27 | US | Idaho | Teton | 16081 | 1074 | 4 | 0 | 1070 | 43.75303583 | -111.2056773 | 2021-02-28 05:22:20 | Teton, Idaho, US |
2185435 | 2185435 | 2021-02-26 | US | Mississippi | Webster | 28155 | 1100 | 30 | 0 | 1070 | 33.61300486 | -89.28392912 | 2021-02-27 05:22:28 | Webster, Mississippi, US |
2184765 | 2184765 | 2021-02-26 | US | Iowa | Franklin | 19069 | 1089 | 19 | 0 | 1070 | 42.73270384 | -93.26256925 | 2021-02-27 05:22:28 | Franklin, Iowa, US |
2184529 | 2184529 | 2021-02-26 | US | Idaho | Teton | 16081 | 1074 | 4 | 0 | 1070 | 43.75303583 | -111.2056773 | 2021-02-27 05:22:28 | Teton, Idaho, US |
1859857 | 1859857 | 2021-02-25 | US | Mississippi | Webster | 28155 | 1099 | 29 | 0 | 1070 | 33.61300486 | -89.28392912 | 2021-02-26 05:22:40 | Webster, Mississippi, US |
1858790 | 1858790 | 2021-02-25 | US | Georgia | Early | 13099 | 1114 | 44 | 0 | 1070 | 31.32155345 | -84.90255207 | 2021-02-26 05:22:40 | Early, Georgia, US |
1939022 | 1939022 | 2021-02-23 | US | Oklahoma | Nowata | 40105 | 1085 | 15 | 0 | 1070 | 36.79843529 | -95.61902331 | 2021-02-24 05:29:16 | Nowata, Oklahoma, US |
1936296 | 1936296 | 2021-02-23 | Colombia | Cordoba | 36690 | 1811 | 33809 | 1070 | 8.0493 | -75.574 | 2021-02-24 05:29:16 | Cordoba, Colombia | ||
530947 | 530947 | 2021-02-22 | Russia | Sakha (Yakutiya) Republic | 32285 | 513 | 30702 | 1070 | 66.941626 | 129.642371 | 2021-02-23 05:23:41 | Sakha (Yakutiya) Republic, Russia | ||
183816 | 183816 | 2021-02-21 | US | Mississippi | Amite | 28005 | 1102 | 32 | 0 | 1070 | 31.17467303 | -90.80501621 | 2021-02-22 05:24:21 | Amite, Mississippi, US |
3603787 | 3603787 | 2021-02-17 | US | Puerto Rico | Las Piedras | 72085 | 1070 | 0 | 0 | 1070 | 18.187527 | -65.86946800000001 | 2021-02-18 05:22:58 | Las Piedras, Puerto Rico, US |
3052922 | 3052922 | 2021-02-16 | US | Puerto Rico | Las Piedras | 72085 | 1070 | 0 | 0 | 1070 | 18.187527 | -65.86946800000001 | 2021-02-17 05:23:10 | Las Piedras, Puerto Rico, US |
1341689 | 1341689 | 2021-02-15 | US | Virginia | Westmoreland | 51193 | 1086 | 16 | 0 | 1070 | 38.11021557 | -76.80213247 | 2021-02-16 05:24:38 | Westmoreland, Virginia, US |
2286840 | 2286840 | 2021-02-14 | US | Virginia | Westmoreland | 51193 | 1086 | 16 | 0 | 1070 | 38.11021557 | -76.80213247 | 2021-02-15 05:24:49 | Westmoreland, Virginia, US |
2681240 | 2681240 | 2021-02-13 | US | Virginia | Westmoreland | 51193 | 1086 | 16 | 0 | 1070 | 38.11021557 | -76.80213247 | 2021-02-14 05:23:43 | Westmoreland, Virginia, US |
2678015 | 2678015 | 2021-02-13 | Russia | Bryansk Oblast | 31180 | 248 | 29862 | 1070 | 52.8873315 | 33.41585300000001 | 2021-02-14 05:23:43 | Bryansk Oblast, Russia | ||
1530154 | 1530154 | 2021-02-09 | US | New York | Schoharie | 36095 | 1079 | 9 | 0 | 1070 | 42.58831742 | -74.44339029999998 | 2021-02-10 05:22:41 | Schoharie, New York, US |
1529390 | 1529390 | 2021-02-09 | US | Louisiana | East Carroll | 22035 | 1092 | 22 | 0 | 1070 | 32.73926954 | -91.23425694 | 2021-02-10 05:22:41 | East Carroll, Louisiana, US |
1587934 | 1587934 | 2021-02-05 | Burkina Faso | 11143 | 132 | 9941 | 1070 | 12.2383 | -1.5616 | 2021-02-06 05:23:55 | Burkina Faso | |||
791876 | 791876 | 2021-02-04 | US | Louisiana | East Carroll | 22035 | 1091 | 21 | 0 | 1070 | 32.73926954 | -91.23425694 | 2021-02-05 05:22:38 | East Carroll, Louisiana, US |
790294 | 790294 | 2021-02-04 | Germany | Bremen | 16226 | 283 | 14999 | 1070 | 53.0793 | 8.8017 | 2021-02-05 05:22:38 | Bremen, Germany | ||
1686170 | 1686170 | 2021-02-02 | US | Michigan | Otsego | 26137 | 1095 | 25 | 0 | 1070 | 45.02085831 | -84.59898295 | 2021-02-03 05:22:52 | Otsego, Michigan, US |
1677664 | 1677664 | 2021-02-01 | US | Iowa | Humboldt | 19091 | 1090 | 20 | 0 | 1070 | 42.7764426 | -94.20722537 | 2021-02-02 05:22:49 | Humboldt, Iowa, US |
1462362 | 1462362 | 2021-01-31 | US | Oregon | Coos | 41011 | 1086 | 16 | 0 | 1070 | 43.17406868 | -124.0594514 | 2021-02-01 05:22:53 | Coos, Oregon, US |
1461177 | 1461177 | 2021-01-31 | US | Kentucky | Lawrence | 21127 | 1080 | 10 | 0 | 1070 | 38.07136018 | -82.72882223 | 2021-02-01 05:22:53 | Lawrence, Kentucky, US |
2215186 | 2215186 | 2021-01-30 | US | Wisconsin | Bayfield | 55007 | 1088 | 18 | 0 | 1070 | 46.52868768 | -91.19716729 | 2021-01-31 05:22:42 | Bayfield, Wisconsin, US |
2214270 | 2214270 | 2021-01-30 | US | Oregon | Coos | 41011 | 1086 | 16 | 0 | 1070 | 43.17406868 | -124.0594514 | 2021-01-31 05:22:42 | Coos, Oregon, US |
2213436 | 2213436 | 2021-01-30 | US | Minnesota | Watonwan | 27165 | 1078 | 8 | 0 | 1070 | 43.97823903 | -94.61413846 | 2021-01-31 05:22:42 | Watonwan, Minnesota, US |
2213073 | 2213073 | 2021-01-30 | US | Kentucky | Henry | 21103 | 1076 | 6 | 0 | 1070 | 38.44942688 | -85.11587507 | 2021-01-31 05:22:42 | Henry, Kentucky, US |
1899379 | 1899379 | 2021-01-29 | US | New York | Essex | 36031 | 1091 | 21 | 0 | 1070 | 44.11630765 | -73.77297842 | 2021-01-30 05:22:49 | Essex, New York, US |
2485259 | 2485259 | 2021-01-28 | US | Virginia | Alleghany | 51005 | 1101 | 31 | 0 | 1070 | 37.78636074 | -80.00222498 | 2021-01-29 05:22:23 | Alleghany, Virginia, US |
2482981 | 2482981 | 2021-01-28 | US | Illinois | Massac | 17127 | 1100 | 30 | 0 | 1070 | 37.22078441 | -88.71036614 | 2021-01-29 05:22:23 | Massac, Illinois, US |
13883 | 13883 | 2021-01-26 | US | Maine | Aroostook | 23003 | 1105 | 35 | 0 | 1070 | 46.65926321 | -68.59841248 | 2021-01-27 05:23:41 | Aroostook, Maine, US |
13879 | 13879 | 2021-01-26 | US | Louisiana | West Carroll | 22123 | 1106 | 36 | 0 | 1070 | 32.78550125 | -91.461201 | 2021-01-27 05:23:41 | West Carroll, Louisiana, US |
1762065 | 1762065 | 2021-01-24 | US | Puerto Rico | San Lorenzo | 72129 | 1070 | 0 | 0 | 1070 | 18.147987 | -65.976392 | 2021-01-25 05:22:16 | San Lorenzo, Puerto Rico, US |
2470286 | 2470286 | 2021-01-22 | US | West Virginia | Lincoln | 54043 | 1079 | 9 | 0 | 1070 | 38.172154 | -82.07017953 | 2021-01-23 05:22:03 | Lincoln, West Virginia, US |
438956 | 438956 | 2021-01-21 | US | Wyoming | Lincoln | 56023 | 1081 | 11 | 0 | 1070 | 42.26376367 | -110.6563997 | 2021-01-22 05:22:10 | Lincoln, Wyoming, US |
1095323 | 1095323 | 2021-01-20 | US | Iowa | Union | 19175 | 1092 | 22 | 0 | 1070 | 41.0277278 | -94.24234847 | 2021-01-21 05:22:01 | Union, Iowa, US |
909145 | 909145 | 2021-01-19 | US | Illinois | Cumberland | 17035 | 1085 | 15 | 0 | 1070 | 39.27432424 | -88.2401158 | 2021-01-20 05:21:54 | Cumberland, Illinois, US |
240266 | 240266 | 2021-01-18 | US | Texas | Burleson | 48051 | 1517 | 22 | 0 | 1070 | 30.49273808 | -96.62158484 | 2021-01-19 05:22:15 | Burleson, Texas, US |
3506383 | 3506383 | 2021-01-17 | US | Texas | Burleson | 48051 | 1517 | 22 | 0 | 1070 | 30.49273808 | -96.62158484 | 2021-01-18 05:22:34 | Burleson, Texas, US |
3504107 | 3504107 | 2021-01-17 | US | Georgia | Brooks | 13027 | 1103 | 33 | 0 | 1070 | 30.83922642 | -83.58303423 | 2021-01-18 05:22:34 | Brooks, Georgia, US |
3516870 | 3516870 | 2021-01-15 | US | Kentucky | Union | 21225 | 1079 | 9 | 0 | 1070 | 37.66166713 | -87.94300009 | 2021-01-16 05:22:40 | Union, Kentucky, US |
3310602 | 3310602 | 2021-01-13 | US | North Dakota | McKenzie | 38053 | 1074 | 11 | 0 | 1070 | 47.74133370000001 | -103.395905 | 2021-01-14 05:22:32 | McKenzie, North Dakota, US |
777490 | 777490 | 2021-01-12 | US | Texas | Lee | 48287 | 1155 | 33 | 0 | 1070 | 30.31120597 | -96.97045773 | 2021-01-13 05:22:15 | Lee, Texas, US |
775575 | 775575 | 2021-01-12 | US | Iowa | Sac | 19161 | 1085 | 15 | 0 | 1070 | 42.38624071 | -95.10547892 | 2021-01-13 05:22:15 | Sac, Iowa, US |
193252 | 193252 | 2021-01-11 | US | Texas | Parmer | 48369 | 1283 | 32 | 0 | 1070 | 34.52993409 | -102.7844668 | 2021-01-12 05:22:15 | Parmer, Texas, US |
190756 | 190756 | 2021-01-11 | US | Florida | Gilchrist | 12041 | 1097 | 27 | 0 | 1070 | 29.72856978 | -82.79880657 | 2021-01-12 05:22:15 | Gilchrist, Florida, US |
2629055 | 2629055 | 2021-01-10 | US | Texas | Parmer | 48369 | 1283 | 32 | 0 | 1070 | 34.52993409 | -102.7844668 | 2021-01-11 05:21:50 | Parmer, Texas, US |
3903143 | 3903143 | 2021-01-09 | US | Texas | Parmer | 48369 | 1283 | 32 | 0 | 1070 | 34.52993409 | -102.7844668 | 2021-01-10 05:22:12 | Parmer, Texas, US |
2543243 | 2543243 | 2021-01-07 | US | Mississippi | Smith | 28129 | 1090 | 20 | 0 | 1070 | 32.01744532 | -89.50644846 | 2021-01-08 05:22:42 | Smith, Mississippi, US |
2868090 | 2868090 | 2021-01-06 | US | Virginia | Orange | 51137 | 1083 | 13 | 0 | 1070 | 38.24530219 | -78.01560400000002 | 2021-01-07 05:22:03 | Orange, Virginia, US |
2867924 | 2867924 | 2021-01-06 | US | Texas | Shelby | 48419 | 1193 | 40 | 0 | 1070 | 31.79211404 | -94.14550696 | 2021-01-07 05:22:03 | Shelby, Texas, US |
2867759 | 2867759 | 2021-01-06 | US | Texas | Colorado | 48089 | 1113 | 16 | 0 | 1070 | 29.622098 | -96.5273805 | 2021-01-07 05:22:03 | Colorado, Texas, US |
2866552 | 2866552 | 2021-01-06 | US | Mississippi | Smith | 28129 | 1090 | 20 | 0 | 1070 | 32.01744532 | -89.50644846 | 2021-01-07 05:22:03 | Smith, Mississippi, US |
3035296 | 3035296 | 2021-01-05 | US | Illinois | Johnson | 17087 | 1079 | 9 | 0 | 1070 | 37.45939802 | -88.88165419 | 2021-01-06 05:22:16 | Johnson, Illinois, US |
1064036 | 1064036 | 2021-01-04 | US | New Mexico | Lincoln | 35027 | 1081 | 11 | 0 | 1070 | 33.74526079 | -105.4586166 | 2021-01-05 05:21:49 | Lincoln, New Mexico, US |
1139412 | 1139412 | 2021-01-01 | US | Oklahoma | Choctaw | 40023 | 1076 | 6 | 0 | 1070 | 34.02807439 | -95.54771129 | 2021-01-02 05:22:33 | Choctaw, Oklahoma, US |
3698018 | 3698018 | 2020-12-31 | US | Oklahoma | Choctaw | 40023 | 1076 | 6 | 0 | 1070 | 34.02807439 | -95.54771129 | 2021-01-01 05:23:07 | Choctaw, Oklahoma, US |
3696064 | 3696064 | 2020-12-31 | US | California | Siskiyou | 6093 | 1057 | 3 | 0 | 1070 | 41.59198861 | -122.5407434 | 2021-01-01 05:23:07 | Siskiyou, California, US |
1011547 | 1011547 | 2020-12-30 | US | Iowa | Winnebago | 19189 | 1098 | 28 | 0 | 1070 | 43.37751174 | -93.73407298 | 2020-12-31 05:22:49 | Winnebago, Iowa, US |
3762403 | 3762403 | 2020-12-28 | US | Georgia | Jones | 13169 | 1094 | 24 | 0 | 1070 | 33.02512137 | -83.56019163 | 2020-12-29 05:22:37 | Jones, Georgia, US |
2224863 | 2224863 | 2020-12-26 | US | Kentucky | Allen | 21003 | 1086 | 16 | 0 | 1070 | 36.75197631 | -86.19457544 | 2020-12-27 05:22:55 | Allen, Kentucky, US |
203856 | 203856 | 2020-12-25 | US | Michigan | Alpena | 26007 | 1094 | 24 | 0 | 1070 | 45.03477666 | -83.62212411 | 2020-12-26 05:22:28 | Alpena, Michigan, US |
203666 | 203666 | 2020-12-25 | US | Kentucky | Johnson | 21115 | 1084 | 14 | 0 | 1070 | 37.85106355 | -82.8264322 | 2020-12-26 05:22:28 | Johnson, Kentucky, US |
203379 | 203379 | 2020-12-25 | US | Indiana | Rush | 18139 | 1084 | 14 | 0 | 1070 | 39.62002287 | -85.4655599 | 2020-12-26 05:22:28 | Rush, Indiana, US |
203095 | 203095 | 2020-12-25 | US | Georgia | Morgan | 13211 | 1079 | 9 | 0 | 1070 | 33.59232073 | -83.49129491 | 2020-12-26 05:22:28 | Morgan, Georgia, US |
3694878 | 3694878 | 2020-12-24 | US | Virginia | Southampton | 51175 | 1112 | 42 | 0 | 1070 | 36.72231125 | -77.10642712 | 2020-12-25 05:22:48 | Southampton, Virginia, US |
3693079 | 3693079 | 2020-12-24 | US | Michigan | Alpena | 26007 | 1094 | 24 | 0 | 1070 | 45.03477666 | -83.62212411 | 2020-12-25 05:22:48 | Alpena, Michigan, US |
3692889 | 3692889 | 2020-12-24 | US | Kentucky | Johnson | 21115 | 1084 | 14 | 0 | 1070 | 37.85106355 | -82.8264322 | 2020-12-25 05:22:48 | Johnson, Kentucky, US |
2409649 | 2409649 | 2020-12-23 | US | South Carolina | Lee | 45061 | 1111 | 41 | 0 | 1070 | 34.16393091 | -80.25690731 | 2020-12-24 05:23:04 | Lee, South Carolina, US |
2408431 | 2408431 | 2020-12-23 | US | Michigan | Alpena | 26007 | 1094 | 24 | 0 | 1070 | 45.03477666 | -83.62212411 | 2020-12-24 05:23:04 | Alpena, Michigan, US |
2408241 | 2408241 | 2020-12-23 | US | Kentucky | Johnson | 21115 | 1084 | 14 | 0 | 1070 | 37.85106355 | -82.8264322 | 2020-12-24 05:23:04 | Johnson, Kentucky, US |
2406624 | 2406624 | 2020-12-23 | Chile | Maule | 23703 | 534 | 22099 | 1070 | -35.5183 | -71.6885 | 2020-12-24 05:23:04 | Maule, Chile | ||
3772821 | 3772821 | 2020-12-22 | US | Tennessee | Humphreys | 47085 | 1111 | 11 | 0 | 1070 | 36.03958805 | -87.77992872 | 2020-12-23 05:22:03 | Humphreys, Tennessee, US |
929404 | 929404 | 2020-12-21 | US | Minnesota | Houston | 27055 | 1080 | 10 | 0 | 1070 | 43.67129565 | -91.49143057 | 2020-12-22 05:22:33 | Houston, Minnesota, US |
928808 | 928808 | 2020-12-21 | US | Indiana | Perry | 18123 | 1092 | 22 | 0 | 1070 | 38.07809328 | -86.63741946 | 2020-12-22 05:22:33 | Perry, Indiana, US |
2121183 | 2121183 | 2020-12-20 | US | Kentucky | Wayne | 21231 | 1075 | 5 | 0 | 1070 | 36.80310688 | -84.8251971 | 2020-12-21 05:27:58 | Wayne, Kentucky, 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]);