johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
215 rows where active = 1097 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3468028 | 3468028 | 2021-08-03 | Colombia | Magdalena | 88889 | 3195 | 84597 | 1097 | 10.4113 | -74.4057 | 2021-08-04 04:21:25 | Magdalena, Colombia | ||
1378424 | 1378424 | 2021-07-25 | Germany | Rheinland-Pfalz | 156603 | 3897 | 151800 | 1097 | 50.1183 | 7.309 | 2021-07-26 04:21:28 | Rheinland-Pfalz, Germany | ||
3744768 | 3744768 | 2021-07-12 | Malaysia | W.P. Labuan | 9206 | 135 | 7974 | 1097 | 5.2831 | 115.2308 | 2021-07-13 04:21:18 | W.P. Labuan, Malaysia | ||
1712253 | 1712253 | 2021-06-25 | Guinea | 23653 | 168 | 22388 | 1097 | 9.9456 | -9.6966 | 2021-06-26 04:21:43 | Guinea | |||
2411060 | 2411060 | 2021-04-19 | Russia | Kurgan Oblast | 19963 | 368 | 18498 | 1097 | 55.7655302 | 64.5632681 | 2021-04-20 04:20:41 | Kurgan Oblast, Russia | ||
1980867 | 1980867 | 2021-03-25 | Russia | Tula Oblast | 35699 | 1488 | 33114 | 1097 | 53.9570701 | 37.3690909 | 2021-03-26 05:26:55 | Tula Oblast, Russia | ||
2781255 | 2781255 | 2021-03-24 | Russia | Yamalo-Nenets Autonomous Okrug | 37826 | 406 | 36323 | 1097 | 67.1471631 | 74.3415488 | 2021-03-25 05:27:00 | Yamalo-Nenets Autonomous Okrug, Russia | ||
1619598 | 1619598 | 2021-03-05 | US | Virginia | Lexington | 51678 | 1123 | 26 | 0 | 1097 | 37.78258621 | -79.44262866 | 2021-03-06 04:23:41 | Lexington, Virginia, US |
1618969 | 1618969 | 2021-03-05 | US | Puerto Rico | Corozal | 72047 | 1097 | 0 | 0 | 1097 | 18.304264 | -66.327738 | 2021-03-06 04:23:41 | Corozal, Puerto Rico, US |
1091443 | 1091443 | 2021-03-03 | US | Kentucky | Breckinridge | 21027 | 1106 | 9 | 0 | 1097 | 37.77377239 | -86.42885017 | 2021-03-04 05:24:24 | Breckinridge, Kentucky, US |
2186920 | 2186920 | 2021-02-26 | US | Virginia | Grayson | 51077 | 1126 | 29 | 0 | 1097 | 36.65677234 | -81.23215889 | 2021-02-27 05:22:28 | Grayson, Virginia, US |
1859198 | 1859198 | 2021-02-25 | US | Iowa | Humboldt | 19091 | 1122 | 25 | 0 | 1097 | 42.7764426 | -94.20722537 | 2021-02-26 05:22:40 | Humboldt, Iowa, US |
531885 | 531885 | 2021-02-22 | US | Iowa | Emmet | 19063 | 1136 | 39 | 0 | 1097 | 43.37782951 | -94.67858943 | 2021-02-23 05:23:41 | Emmet, Iowa, US |
183219 | 183219 | 2021-02-21 | US | Iowa | Emmet | 19063 | 1136 | 39 | 0 | 1097 | 43.37782951 | -94.67858943 | 2021-02-22 05:24:21 | Emmet, Iowa, US |
743493 | 743493 | 2021-02-20 | US | Iowa | Emmet | 19063 | 1136 | 39 | 0 | 1097 | 43.37782951 | -94.67858943 | 2021-02-21 05:24:33 | Emmet, Iowa, US |
472591 | 472591 | 2021-02-19 | US | Iowa | Emmet | 19063 | 1136 | 39 | 0 | 1097 | 43.37782951 | -94.67858943 | 2021-02-20 05:22:51 | Emmet, Iowa, US |
3602220 | 3602220 | 2021-02-17 | US | Iowa | Emmet | 19063 | 1136 | 39 | 0 | 1097 | 43.37782951 | -94.67858943 | 2021-02-18 05:22:58 | Emmet, Iowa, US |
2286131 | 2286131 | 2021-02-14 | US | Puerto Rico | Aguadilla | 72005 | 1097 | 0 | 0 | 1097 | 18.459681 | -67.12081500000001 | 2021-02-15 05:24:49 | Aguadilla, Puerto Rico, US |
2680444 | 2680444 | 2021-02-13 | US | Oregon | Lincoln | 41041 | 1115 | 18 | 0 | 1097 | 44.64252874 | -123.869912 | 2021-02-14 05:23:43 | Lincoln, Oregon, US |
2679655 | 2679655 | 2021-02-13 | US | Mississippi | Perry | 28111 | 1130 | 33 | 0 | 1097 | 31.17161885 | -88.99281835 | 2021-02-14 05:23:43 | Perry, Mississippi, US |
616917 | 616917 | 2021-02-08 | US | Texas | Tyler | 48457 | 1210 | 30 | 0 | 1097 | 30.77031716 | -94.37690895 | 2021-02-09 05:23:30 | Tyler, Texas, US |
614230 | 614230 | 2021-02-08 | US | California | Inyo | 6027 | 1134 | 30 | 0 | 1097 | 36.51112084 | -117.41119779999998 | 2021-02-09 05:23:30 | Inyo, California, US |
1675686 | 1675686 | 2021-02-07 | US | Texas | Tyler | 48457 | 1210 | 30 | 0 | 1097 | 30.77031716 | -94.37690895 | 2021-02-08 05:22:39 | Tyler, Texas, US |
978147 | 978147 | 2021-02-06 | US | Texas | Tyler | 48457 | 1210 | 30 | 0 | 1097 | 30.77031716 | -94.37690895 | 2021-02-07 05:23:00 | Tyler, Texas, US |
976390 | 976390 | 2021-02-06 | US | Kentucky | Webster | 21233 | 1114 | 17 | 0 | 1097 | 37.52168356 | -87.67989953 | 2021-02-07 05:23:00 | Webster, Kentucky, US |
793683 | 793683 | 2021-02-04 | US | Virginia | Brunswick | 51025 | 1107 | 10 | 0 | 1097 | 36.76366949 | -77.8593436 | 2021-02-05 05:22:38 | Brunswick, Virginia, US |
343044 | 343044 | 2021-02-03 | US | Puerto Rico | San Lorenzo | 72129 | 1097 | 0 | 0 | 1097 | 18.147987 | -65.976392 | 2021-02-04 05:22:26 | San Lorenzo, Puerto Rico, US |
341961 | 341961 | 2021-02-03 | US | Minnesota | Aitkin | 27001 | 1130 | 33 | 0 | 1097 | 46.60962049 | -93.4116826 | 2021-02-04 05:22:26 | Aitkin, Minnesota, US |
341681 | 341681 | 2021-02-03 | US | Kentucky | Henry | 21103 | 1103 | 6 | 0 | 1097 | 38.44942688 | -85.11587507 | 2021-02-04 05:22:26 | Henry, Kentucky, US |
1686187 | 1686187 | 2021-02-02 | US | Minnesota | Aitkin | 27001 | 1130 | 33 | 0 | 1097 | 46.60962049 | -93.4116826 | 2021-02-03 05:22:52 | Aitkin, Minnesota, US |
1679073 | 1679073 | 2021-02-01 | US | Oregon | Columbia | 41009 | 1116 | 19 | 0 | 1097 | 45.94464254 | -123.0890898 | 2021-02-02 05:22:49 | Columbia, Oregon, US |
1678991 | 1678991 | 2021-02-01 | US | Oklahoma | Alfalfa | 40003 | 1102 | 5 | 0 | 1097 | 36.73090616 | -98.32408495 | 2021-02-02 05:22:49 | Alfalfa, Oklahoma, US |
1678157 | 1678157 | 2021-02-01 | US | Minnesota | Aitkin | 27001 | 1130 | 33 | 0 | 1097 | 46.60962049 | -93.4116826 | 2021-02-02 05:22:49 | Aitkin, Minnesota, US |
1462361 | 1462361 | 2021-01-31 | US | Oregon | Columbia | 41009 | 1116 | 19 | 0 | 1097 | 45.94464254 | -123.0890898 | 2021-02-01 05:22:53 | Columbia, Oregon, US |
1462059 | 1462059 | 2021-01-31 | US | North Carolina | Currituck | 37053 | 1111 | 14 | 0 | 1097 | 36.36123664 | -75.95876401 | 2021-02-01 05:22:53 | Currituck, North Carolina, US |
2214405 | 2214405 | 2021-01-30 | US | Puerto Rico | Humacao | 72069 | 1097 | 0 | 0 | 1097 | 18.145211 | -65.810174 | 2021-01-31 05:22:42 | Humacao, Puerto Rico, US |
2214269 | 2214269 | 2021-01-30 | US | Oregon | Columbia | 41009 | 1116 | 19 | 0 | 1097 | 45.94464254 | -123.0890898 | 2021-01-31 05:22:42 | Columbia, Oregon, US |
2483291 | 2483291 | 2021-01-28 | US | Kansas | Pawnee | 20145 | 1107 | 10 | 0 | 1097 | 38.18108732 | -99.23692334 | 2021-01-29 05:22:23 | Pawnee, Kansas, US |
3155587 | 3155587 | 2021-01-27 | US | Montana | Custer | 30017 | 1111 | 14 | 0 | 1097 | 46.25319932 | -105.57375259999998 | 2021-01-28 05:22:24 | Custer, Montana, US |
3154926 | 3154926 | 2021-01-27 | US | Kansas | Pawnee | 20145 | 1107 | 10 | 0 | 1097 | 38.18108732 | -99.23692334 | 2021-01-28 05:22:24 | Pawnee, Kansas, US |
3153516 | 3153516 | 2021-01-27 | Germany | Bremen | 15549 | 257 | 14255 | 1097 | 53.0793 | 8.8017 | 2021-01-28 05:22:24 | Bremen, Germany | ||
2568479 | 2568479 | 2021-01-25 | US | Georgia | Jasper | 13159 | 1120 | 23 | 0 | 1097 | 33.31535543 | -83.68844964 | 2021-01-26 05:22:02 | Jasper, Georgia, US |
2429006 | 2429006 | 2021-01-23 | US | Nebraska | Red Willow | 31145 | 1106 | 9 | 0 | 1097 | 40.17556879999999 | -100.476998 | 2021-01-24 05:22:35 | Red Willow, Nebraska, US |
2468630 | 2468630 | 2021-01-22 | US | Mississippi | Noxubee | 28103 | 1122 | 25 | 0 | 1097 | 33.11009499 | -88.56949061 | 2021-01-23 05:22:03 | Noxubee, Mississippi, US |
437204 | 437204 | 2021-01-21 | US | Mississippi | Walthall | 28147 | 1134 | 37 | 0 | 1097 | 31.14971548 | -90.10446654 | 2021-01-22 05:22:10 | Walthall, Mississippi, US |
436584 | 436584 | 2021-01-21 | US | Iowa | Sac | 19161 | 1112 | 15 | 0 | 1097 | 42.38624071 | -95.10547892 | 2021-01-22 05:22:10 | Sac, Iowa, US |
1095249 | 1095249 | 2021-01-20 | US | Iowa | Cass | 19029 | 1139 | 42 | 0 | 1097 | 41.33149454 | -94.92792482 | 2021-01-21 05:22:01 | Cass, Iowa, US |
909829 | 909829 | 2021-01-19 | US | Michigan | Mason | 26105 | 1120 | 23 | 0 | 1097 | 43.99509218 | -86.24988902 | 2021-01-20 05:21:54 | Mason, Michigan, US |
909633 | 909633 | 2021-01-19 | US | Kentucky | Rockcastle | 21203 | 1109 | 12 | 0 | 1097 | 37.36642393 | -84.31176452 | 2021-01-20 05:21:54 | Rockcastle, Kentucky, US |
909405 | 909405 | 2021-01-19 | US | Iowa | Sac | 19161 | 1112 | 15 | 0 | 1097 | 42.38624071 | -95.10547892 | 2021-01-20 05:21:54 | Sac, Iowa, US |
238892 | 238892 | 2021-01-18 | US | Michigan | Mason | 26105 | 1120 | 23 | 0 | 1097 | 43.99509218 | -86.24988902 | 2021-01-19 05:22:15 | Mason, Michigan, US |
238406 | 238406 | 2021-01-18 | US | Iowa | Chickasaw | 19037 | 1109 | 12 | 0 | 1097 | 43.06001295 | -92.31773347 | 2021-01-19 05:22:15 | Chickasaw, Iowa, US |
3503911 | 3503911 | 2021-01-17 | US | California | Mono | 6051 | 1103 | 3 | 0 | 1097 | 37.93899289 | -118.8872409 | 2021-01-18 05:22:34 | Mono, California, US |
3503774 | 3503774 | 2021-01-17 | US | Alaska | Juneau | 2110 | 1102 | 5 | 0 | 1097 | 58.45031811 | -134.200436 | 2021-01-18 05:22:34 | Juneau, Alaska, US |
3102128 | 3102128 | 2021-01-16 | US | Florida | Gilchrist | 12041 | 1124 | 27 | 0 | 1097 | 29.72856978 | -82.79880657 | 2021-01-17 05:22:17 | Gilchrist, Florida, US |
3518701 | 3518701 | 2021-01-15 | US | Virginia | Bristol | 51520 | 1108 | 11 | 0 | 1097 | 36.6163024 | -82.16359122 | 2021-01-16 05:22:40 | Bristol, Virginia, US |
3880420 | 3880420 | 2021-01-14 | US | Georgia | Oglethorpe | 13221 | 1113 | 16 | 0 | 1097 | 33.878629600000004 | -83.08278123 | 2021-01-15 05:22:24 | Oglethorpe, Georgia, US |
775357 | 775357 | 2021-01-12 | US | Illinois | Mason | 17125 | 1136 | 39 | 0 | 1097 | 40.23917274 | -89.91824452 | 2021-01-13 05:22:15 | Mason, Illinois, US |
193250 | 193250 | 2021-01-11 | US | Texas | Panola | 48365 | 1394 | 46 | 0 | 1097 | 32.163959600000005 | -94.30552481 | 2021-01-12 05:22:15 | Panola, Texas, US |
189920 | 189920 | 2021-01-11 | Colombia | Magdalena | 26291 | 1113 | 24081 | 1097 | 10.4113 | -74.4057 | 2021-01-12 05:22:15 | Magdalena, Colombia | ||
2629387 | 2629387 | 2021-01-10 | US | Wisconsin | Ashland | 55003 | 1113 | 16 | 0 | 1097 | 46.31956891 | -90.67837132 | 2021-01-11 05:21:50 | Ashland, Wisconsin, US |
157454 | 157454 | 2021-01-08 | US | West Virginia | Hampshire | 54027 | 1119 | 22 | 0 | 1097 | 39.32103553 | -78.60826476 | 2021-01-09 05:22:18 | Hampshire, West Virginia, US |
156250 | 156250 | 2021-01-08 | US | New York | Washington | 36115 | 1115 | 18 | 0 | 1097 | 43.31153794 | -73.43043448 | 2021-01-09 05:22:18 | Washington, New York, US |
2543595 | 2543595 | 2021-01-07 | US | New Mexico | Lincoln | 35027 | 1109 | 12 | 0 | 1097 | 33.74526079 | -105.4586166 | 2021-01-08 05:22:42 | Lincoln, New Mexico, US |
1063819 | 1063819 | 2021-01-04 | US | Missouri | Wright | 29229 | 1121 | 24 | 0 | 1097 | 37.27029221 | -92.46914488 | 2021-01-05 05:21:49 | Wright, Missouri, US |
2227998 | 2227998 | 2021-01-02 | US | Arkansas | Grant | 5053 | 1109 | 12 | 0 | 1097 | 34.29017991 | -92.42320562 | 2021-01-03 05:22:52 | Grant, Arkansas, US |
1137087 | 1137087 | 2021-01-01 | Russia | Kamchatka Krai | 10176 | 82 | 8997 | 1097 | 57.1914882 | 160.03838190000005 | 2021-01-02 05:22:33 | Kamchatka Krai, Russia | ||
1012011 | 1012011 | 2020-12-30 | US | Minnesota | Fillmore | 27045 | 1098 | 1 | 0 | 1097 | 43.67394126 | -92.08980382 | 2020-12-31 05:22:49 | Fillmore, Minnesota, US |
1010655 | 1010655 | 2020-12-30 | US | Alabama | Clay | 1027 | 1131 | 34 | 0 | 1097 | 33.26984193 | -85.85836077 | 2020-12-31 05:22:49 | Clay, Alabama, US |
769060 | 769060 | 2020-12-29 | US | Puerto Rico | Juncos | 72077 | 1097 | 0 | 0 | 1097 | 18.223793 | -65.909109 | 2020-12-30 05:22:34 | Juncos, Puerto Rico, US |
768471 | 768471 | 2020-12-29 | US | New Hampshire | Unassigned | 90033 | 1097 | 0 | 0 | 1097 | 44.69063265 | 0.0 | 2020-12-30 05:22:34 | Unassigned, New Hampshire, US |
766513 | 766513 | 2020-12-29 | Russia | Chuvashia Republic | 16155 | 507 | 14551 | 1097 | 55.4259922 | 47.0849429 | 2020-12-30 05:22:34 | Chuvashia Republic, Russia | ||
3763018 | 3763018 | 2020-12-28 | US | Kentucky | Meade | 21163 | 1101 | 4 | 0 | 1097 | 37.96163597 | -86.21028219 | 2020-12-29 05:22:37 | Meade, Kentucky, US |
3779687 | 3779687 | 2020-12-27 | US | Mississippi | Clarke | 28023 | 1155 | 58 | 0 | 1097 | 32.04158545 | -88.68896219999998 | 2020-12-28 05:22:06 | Clarke, Mississippi, US |
3779482 | 3779482 | 2020-12-27 | US | Maryland | Talbot | 24041 | 1104 | 7 | 0 | 1097 | 38.76618159 | -76.10882561 | 2020-12-28 05:22:06 | Talbot, Maryland, US |
3778367 | 3778367 | 2020-12-27 | US | Arkansas | Cleburne | 5023 | 1132 | 35 | 0 | 1097 | 35.53864922 | -92.02640019 | 2020-12-28 05:22:06 | Cleburne, Arkansas, US |
2225617 | 2225617 | 2020-12-26 | US | Nebraska | Seward | 31159 | 1116 | 19 | 0 | 1097 | 40.87241834 | -97.139673 | 2020-12-27 05:22:55 | Seward, Nebraska, US |
204483 | 204483 | 2020-12-25 | US | New York | Greene | 36039 | 1115 | 18 | 0 | 1097 | 42.275797 | -74.12384884 | 2020-12-26 05:22:28 | Greene, New York, US |
2410227 | 2410227 | 2020-12-23 | US | Virginia | Scott | 51169 | 1126 | 29 | 0 | 1097 | 36.71466456 | -82.60171704 | 2020-12-24 05:23:04 | Scott, Virginia, US |
929279 | 929279 | 2020-12-21 | US | Massachusetts | Dukes and Nantucket | 1099 | 2 | 0 | 1097 | 41.40674725 | -70.68763497 | 2020-12-22 05:22:33 | Dukes and Nantucket, Massachusetts, US | |
928621 | 928621 | 2020-12-21 | US | Idaho | Gooding | 16047 | 1114 | 17 | 0 | 1097 | 42.96927962 | -114.8108306 | 2020-12-22 05:22:33 | Gooding, Idaho, US |
928465 | 928465 | 2020-12-21 | US | Georgia | Cook | 13075 | 1119 | 22 | 0 | 1097 | 31.16068491 | -83.42947229 | 2020-12-22 05:22:33 | Cook, Georgia, US |
2122440 | 2122440 | 2020-12-20 | US | Puerto Rico | Dorado | 72051 | 1097 | 0 | 0 | 1097 | 18.436115 | -66.278669 | 2020-12-21 05:27:58 | Dorado, Puerto Rico, US |
3151066 | 3151066 | 2020-12-16 | US | Kentucky | Woodford | 21239 | 1098 | 1 | 0 | 1097 | 38.04178222 | -84.7417556 | 2020-12-17 05:28:12 | Woodford, Kentucky, US |
1037447 | 1037447 | 2020-12-15 | US | Texas | Fayette | 48149 | 1044 | 30 | 0 | 1097 | 29.87788372 | -96.92076062 | 2020-12-16 05:28:04 | Fayette, Texas, US |
1752789 | 1752789 | 2020-12-14 | US | Louisiana | St. James | 22093 | 1137 | 40 | 0 | 1097 | 30.02531716 | -90.80212061 | 2020-12-15 05:26:38 | St. James, Louisiana, US |
3850952 | 3850952 | 2020-12-13 | US | Texas | Milam | 48331 | 625 | 10 | 0 | 1097 | 30.785818300000006 | -96.97718698 | 2020-12-14 05:26:27 | Milam, Texas, US |
848734 | 848734 | 2020-12-12 | US | Texas | Milam | 48331 | 618 | 10 | 0 | 1097 | 30.785818300000006 | -96.97718698 | 2020-12-13 05:27:20 | Milam, Texas, US |
1600712 | 1600712 | 2020-12-10 | US | Arkansas | Logan | 5083 | 1105 | 8 | 0 | 1097 | 35.21413234 | -93.71951016 | 2020-12-11 05:26:59 | Logan, Arkansas, US |
2349768 | 2349768 | 2020-12-07 | US | North Carolina | Person | 37145 | 1110 | 13 | 0 | 1097 | 36.38989032 | -78.97217358 | 2020-12-08 05:27:42 | Person, North Carolina, US |
1007453 | 1007453 | 2020-12-06 | US | Iowa | Calhoun | 19025 | 1104 | 7 | 0 | 1097 | 42.38521079 | -94.64046046 | 2020-12-07 05:26:14 | Calhoun, Iowa, US |
1635335 | 1635335 | 2020-12-05 | US | Texas | Cass | 48067 | 964 | 36 | 0 | 1097 | 33.07499881 | -94.34646905 | 2020-12-06 05:26:18 | Cass, Texas, US |
1633462 | 1633462 | 2020-12-05 | US | Iowa | Calhoun | 19025 | 1104 | 7 | 0 | 1097 | 42.38521079 | -94.64046046 | 2020-12-06 05:26:18 | Calhoun, Iowa, US |
3863339 | 3863339 | 2020-12-04 | US | West Virginia | Wayne | 54099 | 1113 | 16 | 0 | 1097 | 38.14901357 | -82.42287994 | 2020-12-05 05:27:36 | Wayne, West Virginia, US |
740143 | 740143 | 2020-12-02 | US | Mississippi | Tishomingo | 28141 | 1140 | 43 | 0 | 1097 | 34.74023475 | -88.23917219 | 2020-12-03 05:28:22 | Tishomingo, Mississippi, US |
2538671 | 2538671 | 2020-12-01 | US | Kansas | Franklin | 20059 | 1113 | 16 | 0 | 1097 | 38.56443815 | -95.28644341 | 2020-12-02 05:27:41 | Franklin, Kansas, US |
1585440 | 1585440 | 2020-11-30 | US | Kansas | Franklin | 20059 | 1113 | 16 | 0 | 1097 | 38.56443815 | -95.28644341 | 2020-12-01 05:26:18 | Franklin, Kansas, US |
3566824 | 3566824 | 2020-11-29 | Russia | Volgograd Oblast | 26924 | 305 | 25522 | 1097 | 49.6048339 | 44.29035820000001 | 2020-11-30 05:26:13 | Volgograd Oblast, Russia | ||
2938699 | 2938699 | 2020-11-28 | US | West Virginia | Fayette | 54019 | 1131 | 34 | 0 | 1097 | 38.02974928 | -81.08286634 | 2020-11-29 05:25:55 | Fayette, West Virginia, US |
924699 | 924699 | 2020-11-26 | US | Illinois | Montgomery | 17135 | 1115 | 18 | 0 | 1097 | 39.23198845 | -89.47809254 | 2020-11-27 05:26:53 | Montgomery, Illinois, 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]);