johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
131 rows where active = 1885 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3296360 | 3296360 | 2021-07-30 | Qatar | 226077 | 601 | 223591 | 1885 | 25.3548 | 51.1839 | 2021-07-31 04:21:35 | Qatar | |||
3958454 | 3958454 | 2021-06-26 | India | Himachal Pradesh | 201547 | 3471 | 196191 | 1885 | 31.927213 | 77.233081 | 2021-06-27 04:21:39 | Himachal Pradesh, India | ||
1712591 | 1712591 | 2021-06-25 | Russia | Zabaykalsky Krai | 45473 | 714 | 42874 | 1885 | 52.248521 | 115.956325 | 2021-06-26 04:21:43 | Zabaykalsky Krai, Russia | ||
1129227 | 1129227 | 2021-06-18 | Ukraine | Lviv Oblast | 137099 | 3631 | 131583 | 1885 | 49.8397 | 24.0297 | 2021-06-19 04:22:33 | Lviv Oblast, Ukraine | ||
3475982 | 3475982 | 2021-06-08 | Malaysia | Terengganu | 10096 | 60 | 8151 | 1885 | 5.3117 | 103.1324 | 2021-06-09 04:23:31 | Terengganu, Malaysia | ||
726732 | 726732 | 2021-05-22 | Russia | Penza Oblast | 46617 | 759 | 43973 | 1885 | 53.1655415 | 44.78791810000001 | 2021-05-23 04:20:51 | Penza Oblast, Russia | ||
3574870 | 3574870 | 2021-05-17 | Seychelles | 9741 | 30 | 7826 | 1885 | -4.6796 | 55.492 | 2021-05-18 04:20:33 | Seychelles | |||
380429 | 380429 | 2021-04-30 | Russia | Primorsky Krai | 43538 | 713 | 40940 | 1885 | 45.0819456 | 134.726645 | 2021-05-01 04:20:47 | Primorsky Krai, Russia | ||
1408927 | 1408927 | 2021-04-23 | El Salvador | 68318 | 2093 | 64340 | 1885 | 13.7942 | -88.8965 | 2021-04-24 04:20:38 | El Salvador | |||
3710342 | 3710342 | 2021-04-03 | Russia | Kaluga Oblast | 32524 | 284 | 30355 | 1885 | 54.4382773 | 35.5272854 | 2021-04-04 04:20:49 | Kaluga Oblast, Russia | ||
3369123 | 3369123 | 2021-03-21 | Chile | OHiggins | 35390 | 850 | 32655 | 1885 | -34.5755 | -71.0022 | 2021-03-22 05:25:43 | OHiggins, Chile | ||
2359682 | 2359682 | 2021-03-08 | Russia | Krasnoyarsk Krai | 63784 | 2899 | 59000 | 1885 | 63.3233807 | 97.0979974 | 2021-03-09 05:28:19 | Krasnoyarsk Krai, Russia | ||
1617131 | 1617131 | 2021-03-05 | US | Georgia | Washington | 13303 | 1956 | 71 | 0 | 1885 | 32.96711864 | -82.79357039 | 2021-03-06 04:23:41 | Washington, Georgia, US |
2210190 | 2210190 | 2021-03-04 | US | Oklahoma | Craig | 40035 | 1896 | 11 | 0 | 1885 | 36.76268118 | -95.20916602 | 2021-03-05 05:26:29 | Craig, Oklahoma, US |
2209648 | 2209648 | 2021-03-04 | US | Montana | Hill | 30041 | 1924 | 39 | 0 | 1885 | 48.62879827 | -110.1129252 | 2021-03-05 05:26:29 | Hill, Montana, US |
3256613 | 3256613 | 2021-03-02 | US | Ohio | Hocking | 39073 | 1942 | 57 | 0 | 1885 | 39.49537927 | -82.47991446 | 2021-03-03 05:23:28 | Hocking, Ohio, US |
2369816 | 2369816 | 2021-02-28 | US | North Carolina | Hertford | 37091 | 1945 | 60 | 0 | 1885 | 36.3607755 | -76.98104134 | 2021-03-01 05:23:01 | Hertford, North Carolina, US |
2368450 | 2368450 | 2021-02-28 | US | Illinois | Bond | 17005 | 1909 | 24 | 0 | 1885 | 38.88829622 | -89.43534887 | 2021-03-01 05:23:01 | Bond, Illinois, US |
3068318 | 3068318 | 2021-02-27 | US | North Carolina | Hertford | 37091 | 1945 | 60 | 0 | 1885 | 36.3607755 | -76.98104134 | 2021-02-28 05:22:20 | Hertford, North Carolina, US |
3066887 | 3066887 | 2021-02-27 | US | Georgia | Washington | 13303 | 1954 | 69 | 0 | 1885 | 32.96711864 | -82.79357039 | 2021-02-28 05:22:20 | Washington, Georgia, US |
1858518 | 1858518 | 2021-02-25 | US | Arkansas | Randolph | 5121 | 1934 | 49 | 0 | 1885 | 36.3415714 | -91.02455531 | 2021-02-26 05:22:40 | Randolph, Arkansas, US |
283603 | 283603 | 2021-02-24 | US | Washington | Adams | 53001 | 1906 | 21 | 0 | 1885 | 46.98299757 | -118.5601734 | 2021-02-25 05:24:57 | Adams, Washington, US |
1940070 | 1940070 | 2021-02-23 | Ukraine | Donetsk Oblast | 46513 | 1050 | 43578 | 1885 | 48.0159 | 37.8028 | 2021-02-24 05:29:16 | Donetsk Oblast, Ukraine | ||
1155734 | 1155734 | 2021-02-18 | US | Oregon | Jefferson | 41031 | 1912 | 27 | 0 | 1885 | 44.62806839 | -121.17832 | 2021-02-19 05:24:16 | Jefferson, Oregon, US |
2679297 | 2679297 | 2021-02-13 | US | Kentucky | Wayne | 21231 | 1920 | 35 | 0 | 1885 | 36.80310688 | -84.8251971 | 2021-02-14 05:23:43 | Wayne, Kentucky, US |
3540930 | 3540930 | 2021-02-12 | US | Kentucky | Wayne | 21231 | 1919 | 34 | 0 | 1885 | 36.80310688 | -84.8251971 | 2021-02-13 05:22:12 | Wayne, Kentucky, US |
2640891 | 2640891 | 2021-02-11 | US | Texas | Montague | 48337 | 1999 | 57 | 0 | 1885 | 33.67521893 | -97.72500958 | 2021-02-12 05:23:29 | Montague, Texas, US |
2639193 | 2639193 | 2021-02-11 | US | Kentucky | Wayne | 21231 | 1919 | 34 | 0 | 1885 | 36.80310688 | -84.8251971 | 2021-02-12 05:23:29 | Wayne, Kentucky, US |
1672318 | 1672318 | 2021-02-07 | Colombia | Tolima | 63623 | 1967 | 59771 | 1885 | 4.0925 | -75.1545 | 2021-02-08 05:22:39 | Tolima, Colombia | ||
1589829 | 1589829 | 2021-02-05 | US | Michigan | Mecosta | 26107 | 1904 | 19 | 0 | 1885 | 43.64064262 | -85.32463223 | 2021-02-06 05:23:55 | Mecosta, Michigan, US |
343814 | 343814 | 2021-02-03 | US | Wisconsin | Green Lake | 55047 | 1905 | 20 | 0 | 1885 | 43.80025981 | -89.04679553 | 2021-02-04 05:22:26 | Green Lake, Wisconsin, US |
1677894 | 1677894 | 2021-02-01 | US | Kentucky | Lincoln | 21137 | 1915 | 30 | 0 | 1885 | 37.45475628 | -84.6565327 | 2021-02-02 05:22:49 | Lincoln, Kentucky, US |
1462358 | 1462358 | 2021-01-31 | US | Oregon | Benton | 41003 | 1899 | 14 | 0 | 1885 | 44.49167306 | -123.4316987 | 2021-02-01 05:22:53 | Benton, Oregon, US |
2214266 | 2214266 | 2021-01-30 | US | Oregon | Benton | 41003 | 1899 | 14 | 0 | 1885 | 44.49167306 | -123.4316987 | 2021-01-31 05:22:42 | Benton, Oregon, US |
1900643 | 1900643 | 2021-01-29 | US | West Virginia | Mingo | 54059 | 1906 | 21 | 0 | 1885 | 37.73048351 | -82.13338365 | 2021-01-30 05:22:49 | Mingo, West Virginia, US |
13781 | 13781 | 2021-01-26 | US | Kentucky | Montgomery | 21173 | 1906 | 21 | 0 | 1885 | 38.03253032 | -83.9145241 | 2021-01-27 05:23:41 | Montgomery, Kentucky, US |
1095854 | 1095854 | 2021-01-20 | US | Minnesota | Waseca | 27161 | 1901 | 16 | 0 | 1885 | 44.02211116 | -93.58720034 | 2021-01-21 05:22:01 | Waseca, Minnesota, US |
240361 | 240361 | 2021-01-18 | US | Texas | Jasper | 48241 | 2267 | 48 | 0 | 1885 | 30.74685667 | -94.02667579 | 2021-01-19 05:22:15 | Jasper, Texas, US |
238028 | 238028 | 2021-01-18 | US | Georgia | Elbert | 13105 | 1921 | 36 | 0 | 1885 | 34.11302332 | -82.83936148 | 2021-01-19 05:22:15 | Elbert, Georgia, US |
3506478 | 3506478 | 2021-01-17 | US | Texas | Jasper | 48241 | 2267 | 48 | 0 | 1885 | 30.74685667 | -94.02667579 | 2021-01-18 05:22:34 | Jasper, Texas, US |
3103324 | 3103324 | 2021-01-16 | US | Missouri | Crawford | 29055 | 1906 | 21 | 0 | 1885 | 37.97663738 | -91.30528104 | 2021-01-17 05:22:17 | Crawford, Missouri, US |
3518818 | 3518818 | 2021-01-15 | US | Virginia | Winchester | 51840 | 1903 | 18 | 0 | 1885 | 39.17054517 | -78.17325058 | 2021-01-16 05:22:40 | Winchester, Virginia, US |
3517629 | 3517629 | 2021-01-15 | US | New York | Fulton | 36035 | 1932 | 47 | 0 | 1885 | 43.11363907 | -74.41798804 | 2021-01-16 05:22:40 | Fulton, New York, US |
3881434 | 3881434 | 2021-01-14 | US | Missouri | Audrain | 29007 | 1928 | 43 | 0 | 1885 | 39.215877 | -91.84242683 | 2021-01-15 05:22:24 | Audrain, Missouri, US |
2628819 | 2628819 | 2021-01-10 | US | Tennessee | Johnson | 47091 | 1898 | 30 | 0 | 1885 | 36.45523950000001 | -81.84886538 | 2021-01-11 05:21:50 | Johnson, Tennessee, US |
3900713 | 3900713 | 2021-01-09 | US | Georgia | Butts | 13035 | 1935 | 50 | 0 | 1885 | 33.283094500000004 | -83.95435040000002 | 2021-01-10 05:22:12 | Butts, Georgia, US |
2543513 | 2543513 | 2021-01-07 | US | Nebraska | Saunders | 31155 | 1895 | 10 | 0 | 1885 | 41.2278103 | -96.63773905 | 2021-01-08 05:22:42 | Saunders, Nebraska, US |
1064339 | 1064339 | 2021-01-04 | US | Ohio | Perry | 39127 | 1924 | 39 | 0 | 1885 | 39.73508655 | -82.23804971 | 2021-01-05 05:21:49 | Perry, Ohio, US |
1064334 | 1064334 | 2021-01-04 | US | Ohio | Morrow | 39117 | 1912 | 27 | 0 | 1885 | 40.52363560000001 | -82.7892599 | 2021-01-05 05:21:49 | Morrow, Ohio, US |
1062654 | 1062654 | 2021-01-04 | US | Georgia | Haralson | 13143 | 1923 | 38 | 0 | 1885 | 33.79602175 | -85.21005667 | 2021-01-05 05:21:49 | Haralson, Georgia, US |
1010516 | 1010516 | 2020-12-30 | Russia | Komi Republic | 30088 | 568 | 27635 | 1885 | 63.9881421 | 54.3326073 | 2020-12-31 05:22:49 | Komi Republic, Russia | ||
3763278 | 3763278 | 2020-12-28 | US | Minnesota | Cass | 27021 | 1904 | 19 | 0 | 1885 | 46.95043611 | -94.32603968 | 2020-12-29 05:22:37 | Cass, Minnesota, US |
3778633 | 3778633 | 2020-12-27 | US | Florida | Taylor | 12123 | 1910 | 25 | 0 | 1885 | 30.04848048 | -83.60445406 | 2020-12-28 05:22:06 | Taylor, Florida, US |
2225003 | 2225003 | 2020-12-26 | US | Louisiana | Franklin | 22041 | 1961 | 76 | 0 | 1885 | 32.13675181 | -91.67589857 | 2020-12-27 05:22:55 | Franklin, Louisiana, US |
2224288 | 2224288 | 2020-12-26 | US | Georgia | Decatur | 13087 | 1934 | 49 | 0 | 1885 | 30.87967778 | -84.57619536 | 2020-12-27 05:22:55 | Decatur, Georgia, US |
203750 | 203750 | 2020-12-25 | US | Louisiana | Franklin | 22041 | 1961 | 76 | 0 | 1885 | 32.13675181 | -91.67589857 | 2020-12-26 05:22:28 | Franklin, Louisiana, US |
3692973 | 3692973 | 2020-12-24 | US | Louisiana | Franklin | 22041 | 1961 | 76 | 0 | 1885 | 32.13675181 | -91.67589857 | 2020-12-25 05:22:48 | Franklin, Louisiana, US |
3770765 | 3770765 | 2020-12-22 | US | Georgia | Wayne | 13305 | 1934 | 49 | 0 | 1885 | 31.5521809 | -81.91894878 | 2020-12-23 05:22:03 | Wayne, Georgia, US |
2130314 | 2130314 | 2020-12-17 | US | North Carolina | Jackson | 37099 | 1897 | 12 | 0 | 1885 | 35.28814273 | -83.14093385 | 2020-12-18 05:28:18 | Jackson, North Carolina, US |
3150667 | 3150667 | 2020-12-16 | US | Indiana | Fayette | 18041 | 1929 | 44 | 0 | 1885 | 39.63684962 | -85.17797541 | 2020-12-17 05:28:12 | Fayette, Indiana, US |
1602497 | 1602497 | 2020-12-10 | US | North Carolina | Beaufort | 37013 | 1941 | 56 | 0 | 1885 | 35.48531943 | -76.84325809 | 2020-12-11 05:26:59 | Beaufort, North Carolina, US |
2976854 | 2976854 | 2020-12-09 | US | Michigan | Gratiot | 26057 | 1927 | 42 | 0 | 1885 | 43.29265605 | -84.60505416 | 2020-12-10 05:26:19 | Gratiot, Michigan, US |
1822028 | 1822028 | 2020-12-08 | US | Texas | Wharton | 48481 | 1870 | 71 | 0 | 1885 | 29.27765923 | -96.22319248 | 2020-12-09 05:28:01 | Wharton, Texas, US |
77724 | 77724 | 2020-12-03 | US | Pennsylvania | Armstrong | 42005 | 1931 | 46 | 0 | 1885 | 40.81665618 | -79.46290811 | 2020-12-04 05:27:27 | Armstrong, Pennsylvania, US |
77565 | 77565 | 2020-12-03 | US | Ohio | Madison | 39097 | 1910 | 25 | 0 | 1885 | 39.89381073 | -83.40178317 | 2020-12-04 05:27:27 | Madison, Ohio, US |
926556 | 926556 | 2020-11-26 | US | South Dakota | Lawrence | 46081 | 1907 | 22 | 0 | 1885 | 44.35919441 | -103.7929428 | 2020-11-27 05:26:53 | Lawrence, South Dakota, US |
924683 | 924683 | 2020-11-26 | US | Illinois | Lee | 17103 | 1894 | 9 | 0 | 1885 | 41.74583951 | -89.29977132 | 2020-11-27 05:26:53 | Lee, Illinois, US |
1975461 | 1975461 | 2020-11-25 | US | South Dakota | Lawrence | 46081 | 1907 | 22 | 0 | 1885 | 44.35919441 | -103.7929428 | 2020-11-26 05:27:44 | Lawrence, South Dakota, US |
1353305 | 1353305 | 2020-11-24 | US | Tennessee | Trousdale | 47169 | 1885 | 12 | 0 | 1885 | 36.39026213 | -86.16087954 | 2020-11-25 05:27:20 | Trousdale, Tennessee, US |
3192241 | 3192241 | 2020-11-22 | US | New York | Saratoga | 36091 | 1904 | 19 | 0 | 1885 | 43.10904162 | -73.86653895 | 2020-11-23 05:25:26 | Saratoga, New York, US |
3838807 | 3838807 | 2020-11-21 | US | North Carolina | Lenoir | 37107 | 1935 | 50 | 0 | 1885 | 35.24032589999999 | -77.64245615 | 2020-11-22 05:25:45 | Lenoir, North Carolina, US |
124182 | 124182 | 2020-11-18 | US | Louisiana | Avoyelles | 22009 | 1952 | 67 | 0 | 1885 | 31.07796211 | -92.00079449 | 2020-11-19 05:25:23 | Avoyelles, Louisiana, US |
3170134 | 3170134 | 2020-11-16 | US | Arkansas | Miller | 5091 | 1907 | 22 | 0 | 1885 | 33.31403423 | -93.89285258 | 2020-11-17 05:25:54 | Miller, Arkansas, US |
2916266 | 2916266 | 2020-11-14 | US | Indiana | Hancock | 18059 | 1932 | 47 | 0 | 1885 | 39.82304555 | -85.77566351 | 2020-11-15 05:26:53 | Hancock, Indiana, US |
2787569 | 2787569 | 2020-11-13 | US | Oklahoma | McCurtain | 40089 | 1926 | 41 | 0 | 1885 | 34.11664328 | -94.77222373 | 2020-11-14 05:25:37 | McCurtain, Oklahoma, US |
2786830 | 2786830 | 2020-11-13 | US | Mississippi | Panola | 28107 | 1928 | 43 | 0 | 1885 | 34.36398677 | -89.95064249 | 2020-11-14 05:25:37 | Panola, Mississippi, US |
1546854 | 1546854 | 2020-11-07 | US | Tennessee | Carter | 47019 | 1967 | 38 | 0 | 1885 | 36.28969086 | -82.12588974 | 2020-11-08 05:24:56 | Carter, Tennessee, US |
377996 | 377996 | 2020-11-06 | US | Mississippi | Lowndes | 28087 | 1947 | 62 | 0 | 1885 | 33.47386518 | -88.44191529999998 | 2020-11-07 05:24:52 | Lowndes, Mississippi, US |
894174 | 894174 | 2020-11-05 | US | Nebraska | Dodge | 31053 | 1906 | 21 | 0 | 1885 | 41.58071748 | -96.65598179 | 2020-11-06 05:24:55 | Dodge, Nebraska, US |
2500787 | 2500787 | 2020-11-03 | US | Puerto Rico | Toa Alta | 72135 | 1885 | 0 | 0 | 1885 | 18.362406 | -66.246616 | 2020-11-04 05:25:09 | Toa Alta, Puerto Rico, US |
2500530 | 2500530 | 2020-11-03 | US | Ohio | Wayne | 39169 | 1956 | 71 | 0 | 1885 | 40.82925852 | -81.88844833 | 2020-11-04 05:25:09 | Wayne, Ohio, US |
3304770 | 3304770 | 2020-11-02 | US | California | Sutter | 6101 | 1897 | 12 | 0 | 1885 | 39.03417539 | -121.6945899 | 2020-11-03 06:00:16 | Sutter, California, US |
3411641 | 3411641 | 2020-11-01 | US | New Mexico | Santa Fe | 35049 | 1899 | 14 | 0 | 1885 | 35.50708973 | -105.9774716 | 2020-11-02 05:25:04 | Santa Fe, New Mexico, US |
1054962 | 1054962 | 2020-10-23 | US | Indiana | Warrick | 18173 | 1952 | 67 | 0 | 1885 | 38.08922676 | -87.2716085 | 2020-10-24 04:24:46 | Warrick, Indiana, US |
2193835 | 2193835 | 2020-10-21 | US | New York | Niagara | 36063 | 1986 | 101 | 0 | 1885 | 43.19898042 | -78.74777412 | 2020-10-22 04:24:27 | Niagara, New York, US |
1795182 | 1795182 | 2020-10-19 | US | California | Napa | 6055 | 1900 | 12 | 0 | 1885 | 38.50735751 | -122.332839 | 2020-10-20 04:24:22 | Napa, California, US |
1026606 | 1026606 | 2020-10-17 | Russia | Vladimir Oblast | 8346 | 243 | 6218 | 1885 | 56.0503336 | 40.6561633 | 2020-10-18 04:24:25 | Vladimir Oblast, Russia | ||
786460 | 786460 | 2020-10-15 | Mexico | Guanajuato | 44230 | 3180 | 39165 | 1885 | 21.019 | -101.2574 | 2020-10-16 04:24:01 | Guanajuato, Mexico | ||
81364 | 81364 | 2020-10-14 | US | North Carolina | Brunswick | 37019 | 1915 | 30 | 0 | 1885 | 34.070565 | -78.22814204 | 2020-10-15 04:24:28 | Brunswick, North Carolina, US |
3787415 | 3787415 | 2020-10-11 | US | Louisiana | St. Mary | 22101 | 1966 | 81 | 0 | 1885 | 29.69262097 | -91.44702164 | 2020-10-12 04:23:45 | St. Mary, Louisiana, US |
2691256 | 2691256 | 2020-10-08 | US | Maryland | Washington | 24043 | 1926 | 41 | 0 | 1885 | 39.60835778 | -77.82002295 | 2020-10-09 04:23:59 | Washington, Maryland, US |
1043343 | 1043343 | 2020-10-07 | US | Louisiana | St. Mary | 22101 | 1963 | 78 | 0 | 1885 | 29.69262097 | -91.44702164 | 2020-10-08 04:23:56 | St. Mary, Louisiana, US |
1042609 | 1042609 | 2020-10-07 | US | Georgia | Fayette | 13113 | 1937 | 52 | 0 | 1885 | 33.41357794 | -84.49089434 | 2020-10-08 04:23:56 | Fayette, Georgia, US |
1042079 | 1042079 | 2020-10-07 | Russia | Volgograd Oblast | 16021 | 156 | 13980 | 1885 | 49.6048339 | 44.29035820000001 | 2020-10-08 04:23:56 | Volgograd Oblast, Russia | ||
3805282 | 3805282 | 2020-10-05 | US | Virginia | Roanoke City | 51770 | 1914 | 29 | 0 | 1885 | 37.27791025 | -79.96189766 | 2020-10-06 04:23:33 | Roanoke City, Virginia, US |
3802152 | 3802152 | 2020-10-05 | Russia | Volgograd Oblast | 15735 | 152 | 13698 | 1885 | 49.6048339 | 44.29035820000001 | 2020-10-06 04:23:33 | Volgograd Oblast, Russia | ||
1046171 | 1046171 | 2020-09-30 | US | Alabama | Cullman | 1043 | 1905 | 20 | 0 | 1885 | 34.13020303 | -86.86888037 | 2020-10-01 04:23:42 | Cullman, Alabama, US |
2609379 | 2609379 | 2020-09-24 | US | Virginia | Manassas | 51683 | 1910 | 25 | 0 | 1885 | 38.7464321 | -77.48509905 | 2020-09-25 04:23:00 | Manassas, Virginia, US |
3096084 | 3096084 | 2020-09-20 | US | Pennsylvania | Lebanon | 42075 | 1944 | 59 | 0 | 1885 | 40.36680311 | -76.45651841 | 2020-09-21 04:23:00 | Lebanon, Pennsylvania, US |
2731065 | 2731065 | 2020-09-15 | US | Nebraska | Hall | 31079 | 1932 | 47 | 0 | 1885 | 40.87257079 | -98.50218293 | 2020-09-16 04:22:53 | Hall, Nebraska, 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]);