johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
118 rows where active = 1949 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1306009 | 1306009 | 2021-07-27 | Colombia | Norte de Santander | 85497 | 3955 | 79593 | 1949 | 7.9463 | -72.8988 | 2021-07-28 04:21:39 | Norte de Santander, Colombia | ||
2673720 | 2673720 | 2021-07-18 | Germany | Baden-Wurttemberg | 502346 | 10333 | 490600 | 1949 | 48.6616 | 9.3501 | 2021-07-19 04:21:24 | Baden-Wurttemberg, Germany | ||
2765142 | 2765142 | 2021-07-01 | Russia | Karelia Republic | 50164 | 632 | 47583 | 1949 | 62.61940309999999 | 33.4920267 | 2021-07-02 04:21:47 | Karelia Republic, Russia | ||
1125446 | 1125446 | 2021-06-18 | Colombia | Meta | 63115 | 1470 | 59696 | 1949 | 3.272 | -73.0877 | 2021-06-19 04:22:33 | Meta, Colombia | ||
1310357 | 1310357 | 2021-05-26 | Russia | Belgorod Oblast | 38482 | 683 | 35850 | 1949 | 50.7080119 | 37.5837615 | 2021-05-27 04:20:59 | Belgorod Oblast, Russia | ||
726428 | 726428 | 2021-05-22 | Guyana | 16014 | 355 | 13710 | 1949 | 4.860416000000002 | -58.93018000000001 | 2021-05-23 04:20:51 | Guyana | |||
3574447 | 3574447 | 2021-05-17 | Colombia | Magdalena | 65728 | 2502 | 61277 | 1949 | 10.4113 | -74.4057 | 2021-05-18 04:20:33 | Magdalena, Colombia | ||
2020959 | 2020959 | 2021-04-20 | Russia | Primorsky Krai | 43241 | 705 | 40587 | 1949 | 45.0819456 | 134.726645 | 2021-04-21 04:21:14 | Primorsky Krai, Russia | ||
2549131 | 2549131 | 2021-04-15 | Russia | Ulyanovsk Oblast | 52157 | 1066 | 49142 | 1949 | 54.1463177 | 47.2324921 | 2021-04-16 04:20:46 | Ulyanovsk Oblast, Russia | ||
2549107 | 2549107 | 2021-04-15 | Russia | Orel Oblast | 33321 | 527 | 30845 | 1949 | 52.96854329999999 | 36.0692477 | 2021-04-16 04:20:46 | Orel Oblast, Russia | ||
1301829 | 1301829 | 2021-04-01 | Canada | Saskatchewan | 33789 | 436 | 31404 | 1949 | 52.9399 | -106.4509 | 2021-04-02 04:20:36 | Saskatchewan, Canada | ||
1290263 | 1290263 | 2021-03-29 | Russia | Vladimir Oblast | 29847 | 996 | 26902 | 1949 | 56.0503336 | 40.6561633 | 2021-03-30 04:26:23 | Vladimir Oblast, Russia | ||
2781197 | 2781197 | 2021-03-24 | Russia | Kaluga Oblast | 31905 | 281 | 29675 | 1949 | 54.4382773 | 35.5272854 | 2021-03-25 05:27:00 | Kaluga Oblast, Russia | ||
3372946 | 3372946 | 2021-03-21 | Ukraine | Crimea Republic* | 37000 | 1026 | 34025 | 1949 | 45.2835 | 34.2008 | 2021-03-22 05:25:43 | Crimea Republic*, Ukraine | ||
3670791 | 3670791 | 2021-03-06 | US | Texas | Montague | 48337 | 2073 | 67 | 0 | 1949 | 33.67521893 | -97.72500958 | 2021-03-07 05:21:54 | Montague, Texas, US |
3667810 | 3667810 | 2021-03-06 | Russia | Belgorod Oblast | 32018 | 501 | 29568 | 1949 | 50.7080119 | 37.5837615 | 2021-03-07 05:21:54 | Belgorod Oblast, Russia | ||
1619608 | 1619608 | 2021-03-05 | US | Virginia | Mecklenburg | 51117 | 2007 | 58 | 0 | 1949 | 36.67882005 | -78.36131056 | 2021-03-06 04:23:41 | Mecklenburg, Virginia, US |
3256437 | 3256437 | 2021-03-02 | US | North Carolina | Caswell | 37033 | 1972 | 23 | 0 | 1949 | 36.39312665 | -79.33353281 | 2021-03-03 05:23:28 | Caswell, North Carolina, US |
999672 | 999672 | 2021-03-01 | US | Iowa | Tama | 19171 | 2014 | 65 | 0 | 1949 | 42.07991767 | -92.53266945 | 2021-03-02 05:23:30 | Tama, Iowa, US |
2368298 | 2368298 | 2021-02-28 | US | Georgia | Grady | 13131 | 2004 | 55 | 0 | 1949 | 30.87454847 | -84.23418364 | 2021-03-01 05:23:01 | Grady, Georgia, US |
1860560 | 1860560 | 2021-02-25 | US | Oklahoma | Kingfisher | 40073 | 1972 | 23 | 0 | 1949 | 35.94530008 | -97.94193268 | 2021-02-26 05:22:40 | Kingfisher, Oklahoma, US |
280784 | 280784 | 2021-02-24 | US | Colorado | Crowley | 8025 | 2050 | 14 | 0 | 1949 | 38.32608609 | -103.7844965 | 2021-02-25 05:24:57 | Crowley, Colorado, US |
532181 | 532181 | 2021-02-22 | US | Kentucky | Woodford | 21239 | 1953 | 4 | 0 | 1949 | 38.04178222 | -84.7417556 | 2021-02-23 05:23:41 | Woodford, Kentucky, US |
471634 | 471634 | 2021-02-19 | Russia | Mordovia Republic | 17331 | 153 | 15229 | 1949 | 54.4419829 | 44.4661144 | 2021-02-20 05:22:51 | Mordovia Republic, Russia | ||
1154903 | 1154903 | 2021-02-18 | US | Mississippi | Chickasaw | 28017 | 1999 | 50 | 0 | 1949 | 33.91983202 | -88.9481545 | 2021-02-19 05:24:16 | Chickasaw, Mississippi, US |
3053810 | 3053810 | 2021-02-16 | Ukraine | Sumy Oblast | 47062 | 643 | 44470 | 1949 | 50.9077 | 34.7981 | 2021-02-17 05:23:10 | Sumy Oblast, Ukraine | ||
2680733 | 2680733 | 2021-02-13 | US | Tennessee | Bledsoe | 47007 | 1977 | 10 | 0 | 1949 | 35.59942968 | -85.20611967 | 2021-02-14 05:23:43 | Bledsoe, Tennessee, US |
3540426 | 3540426 | 2021-02-12 | US | Illinois | Crawford | 17033 | 1970 | 21 | 0 | 1949 | 39.0032229 | -87.75954624 | 2021-02-13 05:22:12 | Crawford, Illinois, US |
617101 | 617101 | 2021-02-08 | US | Virginia | Waynesboro | 51820 | 1976 | 27 | 0 | 1949 | 38.06451466 | -78.90293905 | 2021-02-09 05:23:30 | Waynesboro, Virginia, US |
1674261 | 1674261 | 2021-02-07 | US | Mississippi | Jasper | 28061 | 1989 | 40 | 0 | 1949 | 32.01922104 | -89.11786866 | 2021-02-08 05:22:39 | Jasper, Mississippi, US |
342874 | 342874 | 2021-02-03 | US | Oregon | Benton | 41003 | 1963 | 14 | 0 | 1949 | 44.49167306 | -123.4316987 | 2021-02-04 05:22:26 | Benton, Oregon, US |
342705 | 342705 | 2021-02-03 | US | Ohio | Adams | 39001 | 1990 | 41 | 0 | 1949 | 38.84541072 | -83.4718964 | 2021-02-04 05:22:26 | Adams, Ohio, US |
2212536 | 2212536 | 2021-01-30 | US | Georgia | Tattnall | 13267 | 1993 | 44 | 0 | 1949 | 32.04785085 | -82.05539188 | 2021-01-31 05:22:42 | Tattnall, Georgia, US |
1899672 | 1899672 | 2021-01-29 | US | Ohio | Wyandot | 39175 | 2000 | 51 | 0 | 1949 | 40.84339621 | -83.30734173 | 2021-01-30 05:22:49 | Wyandot, Ohio, US |
2483421 | 2483421 | 2021-01-28 | US | Kentucky | Perry | 21193 | 1974 | 25 | 0 | 1949 | 37.25023553 | -83.22922731 | 2021-01-29 05:22:23 | Perry, Kentucky, US |
3155573 | 3155573 | 2021-01-27 | US | Missouri | Warren | 29219 | 1961 | 12 | 0 | 1949 | 38.76529479 | -91.16124662 | 2021-01-28 05:22:24 | Warren, Missouri, US |
2568873 | 2568873 | 2021-01-25 | US | Iowa | Mahaska | 19123 | 1986 | 37 | 0 | 1949 | 41.33521503 | -92.64083907 | 2021-01-26 05:22:02 | Mahaska, Iowa, US |
2427997 | 2427997 | 2021-01-23 | US | Indiana | Jennings | 18079 | 1989 | 40 | 0 | 1949 | 38.99588883 | -85.62710784 | 2021-01-24 05:22:35 | Jennings, Indiana, US |
2468741 | 2468741 | 2021-01-22 | US | Missouri | Perry | 29157 | 1971 | 22 | 0 | 1949 | 37.70660776 | -89.82741088 | 2021-01-23 05:22:03 | Perry, Missouri, US |
2467056 | 2467056 | 2021-01-22 | Russia | Tula Oblast | 27294 | 940 | 24405 | 1949 | 53.9570701 | 37.3690909 | 2021-01-23 05:22:03 | Tula Oblast, Russia | ||
3103769 | 3103769 | 2021-01-16 | US | North Carolina | Macon | 37113 | 1961 | 12 | 0 | 1949 | 35.14867843 | -83.41696617 | 2021-01-17 05:22:17 | Macon, North Carolina, US |
3101823 | 3101823 | 2021-01-16 | US | Alabama | Marengo | 1091 | 1978 | 29 | 0 | 1949 | 32.24767634 | -87.78796182 | 2021-01-17 05:22:17 | Marengo, Alabama, US |
3517134 | 3517134 | 2021-01-15 | US | Minnesota | Meeker | 27093 | 1982 | 33 | 0 | 1949 | 45.12328869 | -94.52839455 | 2021-01-16 05:22:40 | Meeker, Minnesota, US |
193577 | 193577 | 2021-01-11 | US | West Virginia | Wayne | 54099 | 1972 | 23 | 0 | 1949 | 38.14901357 | -82.42287994 | 2021-01-12 05:22:15 | Wayne, West Virginia, US |
2542766 | 2542766 | 2021-01-07 | US | Kentucky | Bell | 21013 | 1977 | 28 | 0 | 1949 | 36.73355174 | -83.67766671 | 2021-01-08 05:22:42 | Bell, Kentucky, US |
2866229 | 2866229 | 2021-01-06 | US | Louisiana | Pointe Coupee | 22077 | 2006 | 57 | 0 | 1949 | 30.71409502 | -91.60209535 | 2021-01-07 05:22:03 | Pointe Coupee, Louisiana, US |
1063002 | 1063002 | 2021-01-04 | US | Iowa | Boone | 19015 | 1964 | 15 | 0 | 1949 | 42.03657094 | -93.9313999 | 2021-01-05 05:21:49 | Boone, Iowa, US |
2227519 | 2227519 | 2021-01-02 | Jamaica | 12931 | 303 | 10679 | 1949 | 18.1096 | -77.2975 | 2021-01-03 05:22:52 | Jamaica | |||
3779411 | 3779411 | 2020-12-27 | US | Louisiana | Morehouse | 22067 | 1992 | 43 | 0 | 1949 | 32.81686191 | -91.80421614 | 2020-12-28 05:22:06 | Morehouse, Louisiana, US |
2121276 | 2121276 | 2020-12-20 | US | Maryland | Calvert | 24009 | 1994 | 45 | 0 | 1949 | 38.53961642 | -76.56820632 | 2020-12-21 05:27:58 | Calvert, Maryland, US |
2120644 | 2120644 | 2020-12-20 | US | Idaho | Jefferson | 16051 | 1963 | 14 | 0 | 1949 | 43.82078483 | -112.3131749 | 2020-12-21 05:27:58 | Jefferson, Idaho, US |
2933194 | 2933194 | 2020-12-19 | US | Montana | Big Horn | 30003 | 2006 | 57 | 0 | 1949 | 45.42335905 | -107.492347 | 2020-12-20 05:27:32 | Big Horn, Montana, US |
1902564 | 1902564 | 2020-12-18 | US | Kentucky | Greenup | 21089 | 1967 | 18 | 0 | 1949 | 38.54332505 | -82.9215658 | 2020-12-19 05:27:52 | Greenup, Kentucky, US |
2129882 | 2129882 | 2020-12-17 | US | Missouri | Dunklin | 29069 | 1963 | 14 | 0 | 1949 | 36.27167174 | -90.09122243 | 2020-12-18 05:28:18 | Dunklin, Missouri, US |
1037918 | 1037918 | 2020-12-15 | US | Wisconsin | Kewaunee | 55061 | 1972 | 23 | 0 | 1949 | 44.51727459 | -87.61468386 | 2020-12-16 05:28:04 | Kewaunee, Wisconsin, US |
1752335 | 1752335 | 2020-12-14 | US | Indiana | Daviess | 18027 | 2012 | 63 | 0 | 1949 | 38.70186039 | -87.07185406 | 2020-12-15 05:26:38 | Daviess, Indiana, US |
2975415 | 2975415 | 2020-12-09 | Russia | Belgorod Oblast | 17791 | 116 | 15726 | 1949 | 50.7080119 | 37.5837615 | 2020-12-10 05:26:19 | Belgorod Oblast, Russia | ||
3862771 | 3862771 | 2020-12-04 | US | Tennessee | Henderson | 47077 | 1982 | 34 | 0 | 1949 | 35.65581134 | -88.38600175 | 2020-12-05 05:27:36 | Henderson, Tennessee, US |
3862173 | 3862173 | 2020-12-04 | US | North Carolina | Pender | 37141 | 1966 | 17 | 0 | 1949 | 34.52265624 | -77.90352133 | 2020-12-05 05:27:36 | Pender, North Carolina, US |
739794 | 739794 | 2020-12-02 | US | Louisiana | Evangeline | 22039 | 1994 | 45 | 0 | 1949 | 30.72985248 | -92.39915924 | 2020-12-03 05:28:22 | Evangeline, Louisiana, US |
2539585 | 2539585 | 2020-12-01 | US | New Mexico | Luna | 35029 | 1976 | 27 | 0 | 1949 | 32.18179341 | -107.75088259999998 | 2020-12-02 05:27:41 | Luna, New Mexico, US |
926355 | 926355 | 2020-11-26 | US | Pennsylvania | Lycoming | 42081 | 1987 | 38 | 0 | 1949 | 41.34310539 | -77.06629984 | 2020-11-27 05:26:53 | Lycoming, Pennsylvania, US |
1351076 | 1351076 | 2020-11-24 | US | Georgia | Catoosa | 13047 | 1978 | 29 | 0 | 1949 | 34.89872298 | -85.13757014 | 2020-11-25 05:27:20 | Catoosa, Georgia, US |
681110 | 681110 | 2020-11-23 | US | South Carolina | Cherokee | 45021 | 2011 | 62 | 0 | 1949 | 35.05122251 | -81.61828622 | 2020-11-24 05:27:31 | Cherokee, South Carolina, US |
2702430 | 2702430 | 2020-11-20 | US | Idaho | Cassia | 16031 | 1966 | 17 | 0 | 1949 | 42.28347888 | -113.6012409 | 2020-11-21 05:25:51 | Cassia, Idaho, US |
824793 | 824793 | 2020-11-19 | US | Texas | Titus | 48449 | 1568 | 40 | 0 | 1949 | 33.21339719 | -94.96797273 | 2020-11-20 05:26:28 | Titus, Texas, US |
3173030 | 3173030 | 2020-11-16 | US | Virginia | Rockingham | 51165 | 1978 | 29 | 0 | 1949 | 38.51006137 | -78.87260325 | 2020-11-17 05:25:54 | Rockingham, Virginia, US |
2883130 | 2883130 | 2020-11-15 | US | Tennessee | Fayette | 47047 | 2008 | 36 | 0 | 1949 | 35.19615831 | -89.41399032 | 2020-11-16 05:25:57 | Fayette, Tennessee, US |
2788260 | 2788260 | 2020-11-13 | US | Utah | Central Utah | 1963 | 14 | 0 | 1949 | 39.37231946 | -111.5758676 | 2020-11-14 05:25:37 | Central Utah, Utah, US | |
1992147 | 1992147 | 2020-11-09 | US | Wisconsin | Barron | 55005 | 1960 | 11 | 0 | 1949 | 45.42372701 | -91.84833627 | 2020-11-10 05:40:07 | Barron, Wisconsin, US |
1546846 | 1546846 | 2020-11-07 | US | Tennessee | Bedford | 47003 | 1966 | 23 | 0 | 1949 | 35.51123746 | -86.45549096 | 2020-11-08 05:24:56 | Bedford, Tennessee, US |
2921694 | 2921694 | 2020-11-04 | US | Ohio | Wayne | 39169 | 2023 | 74 | 0 | 1949 | 40.82925852 | -81.88844833 | 2020-11-05 06:05:03 | Wayne, Ohio, US |
2920064 | 2920064 | 2020-11-04 | US | Georgia | Walker | 13295 | 1996 | 47 | 0 | 1949 | 34.73376362 | -85.30165174 | 2020-11-05 06:05:03 | Walker, Georgia, US |
2498901 | 2498901 | 2020-11-03 | US | Georgia | Walker | 13295 | 1996 | 47 | 0 | 1949 | 34.73376362 | -85.30165174 | 2020-11-04 05:25:09 | Walker, Georgia, US |
3410263 | 3410263 | 2020-11-01 | US | Georgia | Laurens | 13175 | 2038 | 89 | 0 | 1949 | 32.46325233 | -82.92221316 | 2020-11-02 05:25:04 | Laurens, Georgia, US |
2082356 | 2082356 | 2020-10-31 | US | North Dakota | Williams | 38105 | 2094 | 18 | 0 | 1949 | 48.34522353 | -103.4793387 | 2020-11-01 04:36:19 | Williams, North Dakota, US |
754096 | 754096 | 2020-10-28 | Chile | Metropolitana | 295796 | 9794 | 284053 | 1949 | -33.4376 | -70.6505 | 2020-10-29 04:24:49 | Metropolitana, Chile | ||
3482547 | 3482547 | 2020-10-26 | US | New York | Niagara | 36063 | 2050 | 101 | 0 | 1949 | 43.19898042 | -78.74777412 | 2020-10-27 04:24:45 | Niagara, New York, US |
3480703 | 3480703 | 2020-10-26 | US | Alabama | Russell | 1113 | 1952 | 3 | 0 | 1949 | 32.28725256 | -85.18415324 | 2020-10-27 04:24:45 | Russell, Alabama, US |
3654614 | 3654614 | 2020-10-24 | US | Texas | Coryell | 48099 | 2295 | 13 | 0 | 1949 | 31.39078397 | -97.79936155 | 2020-10-25 04:24:36 | Coryell, Texas, US |
3993009 | 3993009 | 2020-10-20 | US | North Dakota | Morton | 38059 | 2006 | 48 | 0 | 1949 | 46.71681782 | -101.2822377 | 2020-10-21 04:24:14 | Morton, North Dakota, US |
82011 | 82011 | 2020-10-14 | US | Tennessee | Gibson | 47053 | 1979 | 33 | 0 | 1949 | 35.99438059 | -88.93358327 | 2020-10-15 04:24:28 | Gibson, Tennessee, US |
3784430 | 3784430 | 2020-10-13 | US | Oklahoma | Comanche | 40031 | 1964 | 15 | 0 | 1949 | 34.65973764 | -98.47195055 | 2020-10-14 04:24:05 | Comanche, Oklahoma, US |
2292208 | 2292208 | 2020-10-12 | US | Georgia | Colquitt | 13071 | 1986 | 37 | 0 | 1949 | 31.18810588 | -83.7677946 | 2020-10-13 04:24:02 | Colquitt, Georgia, US |
2602827 | 2602827 | 2020-10-10 | US | Georgia | Gordon | 13129 | 1988 | 39 | 0 | 1949 | 34.50487351 | -84.87296253 | 2020-10-11 04:23:46 | Gordon, Georgia, US |
820066 | 820066 | 2020-10-09 | US | Ohio | Trumbull | 39155 | 2063 | 114 | 0 | 1949 | 41.31735028 | -80.76109643 | 2020-10-10 04:23:57 | Trumbull, Ohio, US |
2692216 | 2692216 | 2020-10-08 | US | Oklahoma | Garfield | 40047 | 1971 | 22 | 0 | 1949 | 36.3791334 | -97.78265517 | 2020-10-09 04:23:59 | Garfield, Oklahoma, US |
3389860 | 3389860 | 2020-10-02 | US | Arkansas | Garland | 5051 | 2002 | 53 | 0 | 1949 | 34.57692074 | -93.14921604 | 2020-10-03 04:23:40 | Garland, Arkansas, US |
1046872 | 1046872 | 2020-09-30 | US | Indiana | Cass | 18017 | 1961 | 12 | 0 | 1949 | 40.76135835 | -86.34830753 | 2020-10-01 04:23:42 | Cass, Indiana, US |
967962 | 967962 | 2020-09-29 | US | Indiana | Delaware | 18035 | 2011 | 62 | 0 | 1949 | 40.22787247 | -85.39732772 | 2020-09-30 04:23:33 | Delaware, Indiana, US |
2614841 | 2614841 | 2020-09-26 | US | Georgia | Jackson | 13157 | 1981 | 32 | 0 | 1949 | 34.13794553 | -83.56814788 | 2020-09-27 04:23:00 | Jackson, Georgia, US |
2654022 | 2654022 | 2020-09-23 | Russia | Ulyanovsk Oblast | 14651 | 147 | 12555 | 1949 | 54.1463177 | 47.2324921 | 2020-09-24 04:23:00 | Ulyanovsk Oblast, Russia | ||
3319613 | 3319613 | 2020-09-22 | US | Virginia | Stafford | 51179 | 1963 | 14 | 0 | 1949 | 38.41758738 | -77.45917053 | 2020-09-23 04:23:00 | Stafford, Virginia, US |
3096300 | 3096300 | 2020-09-20 | US | South Dakota | Pennington | 46103 | 1984 | 35 | 0 | 1949 | 44.0025835 | -102.8240777 | 2020-09-21 04:23:00 | Pennington, South Dakota, US |
669255 | 669255 | 2020-09-16 | US | Tennessee | Sullivan | 47163 | 1984 | 31 | 0 | 1949 | 36.51240691 | -82.30412917 | 2020-09-17 04:22:00 | Sullivan, Tennessee, US |
668641 | 668641 | 2020-09-16 | US | North Carolina | Wilson | 37195 | 1993 | 44 | 0 | 1949 | 35.70625477 | -77.917978 | 2020-09-17 04:22:00 | Wilson, North Carolina, US |
345332 | 345332 | 2020-09-14 | US | Indiana | Clark | 18019 | 2003 | 54 | 0 | 1949 | 38.48015445 | -85.70510334 | 2020-09-15 03:22:50 | Clark, Indiana, US |
2869814 | 2869814 | 2020-09-13 | US | Indiana | Monroe | 18105 | 1986 | 37 | 0 | 1949 | 39.16130004 | -86.52414358 | 2020-09-14 04:26:00 | Monroe, Indiana, US |
2663406 | 2663406 | 2020-09-04 | US | Michigan | Kalamazoo | 26077 | 2037 | 88 | 0 | 1949 | 42.24542231 | -85.53038622 | 2020-09-05 04:28:19 | Kalamazoo, Michigan, US |
3932329 | 3932329 | 2020-08-30 | Sweden | Dalarna | 2123 | 174 | 0 | 1949 | 61.0917 | 14.6664 | 2020-08-31 04:28:27 | Dalarna, 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]);