johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
153 rows where active = 1489 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2693870 | 2693870 | 2021-07-06 | Qatar | 222760 | 594 | 220677 | 1489 | 25.3548 | 51.1839 | 2021-07-07 04:21:20 | Qatar | |||
2072132 | 2072132 | 2021-07-02 | Russia | Komi Republic | 47115 | 1021 | 44605 | 1489 | 63.9881421 | 54.3326073 | 2021-07-03 04:21:37 | Komi Republic, Russia | ||
3358619 | 3358619 | 2021-06-21 | India | Jharkhand | 344665 | 5100 | 338076 | 1489 | 23.654536 | 85.557631 | 2021-06-22 04:21:34 | Jharkhand, India | ||
1564426 | 1564426 | 2021-06-14 | Timor-Leste | 8341 | 19 | 6833 | 1489 | -8.874217 | 125.727539 | 2021-06-15 04:22:22 | Timor-Leste | |||
3381563 | 3381563 | 2021-06-13 | Russia | Bashkortostan Republic | 39378 | 540 | 37349 | 1489 | 54.8573563 | 57.1439682 | 2021-06-14 04:22:46 | Bashkortostan Republic, Russia | ||
726725 | 726725 | 2021-05-22 | Russia | Nizhny Novgorod Oblast | 116815 | 3496 | 111830 | 1489 | 55.47180329999999 | 44.0911594 | 2021-05-23 04:20:51 | Nizhny Novgorod Oblast, Russia | ||
1082183 | 1082183 | 2021-05-14 | Russia | Volgograd Oblast | 58236 | 1195 | 55552 | 1489 | 49.6048339 | 44.29035820000001 | 2021-05-15 04:20:58 | Volgograd Oblast, Russia | ||
1082121 | 1082121 | 2021-05-14 | Russia | Ingushetia Republic | 15587 | 188 | 13910 | 1489 | 43.11542075 | 45.01713552 | 2021-05-15 04:20:58 | Ingushetia Republic, Russia | ||
888321 | 888321 | 2021-04-26 | Russia | Kaliningrad Oblast | 31579 | 396 | 29694 | 1489 | 54.7293041 | 21.1489473 | 2021-04-27 04:20:52 | Kaliningrad Oblast, Russia | ||
2020560 | 2020560 | 2021-04-20 | Colombia | Boyaca | 50866 | 1199 | 48178 | 1489 | 5.4545 | -73.362 | 2021-04-21 04:21:14 | Boyaca, Colombia | ||
605877 | 605877 | 2021-04-09 | Russia | Belgorod Oblast | 35046 | 583 | 32974 | 1489 | 50.7080119 | 37.5837615 | 2021-04-10 04:20:59 | Belgorod Oblast, Russia | ||
1219479 | 1219479 | 2021-03-27 | Germany | Bremen | 20399 | 401 | 18652 | 1489 | 53.0793 | 8.8017 | 2021-03-28 05:28:10 | Bremen, Germany | ||
1090824 | 1090824 | 2021-03-03 | US | Georgia | Brantley | 13025 | 1519 | 30 | 0 | 1489 | 31.19576557 | -81.97743999 | 2021-03-04 05:24:24 | Brantley, Georgia, US |
1001893 | 1001893 | 2021-03-01 | US | Washington | Unassigned | 90053 | 1493 | 4 | 0 | 1489 | 48.82227976 | 0.0 | 2021-03-02 05:23:30 | Unassigned, Washington, US |
1001503 | 1001503 | 2021-03-01 | US | Texas | Dimmit | 48127 | 1608 | 22 | 0 | 1489 | 28.42270064 | -99.75645095 | 2021-03-02 05:23:30 | Dimmit, Texas, US |
2370561 | 2370561 | 2021-02-28 | US | Texas | Dimmit | 48127 | 1608 | 22 | 0 | 1489 | 28.42270064 | -99.75645095 | 2021-03-01 05:23:01 | Dimmit, Texas, US |
2369119 | 2369119 | 2021-02-28 | US | Michigan | Emmet | 26047 | 1528 | 39 | 0 | 1489 | 45.52625509 | -84.89083249 | 2021-03-01 05:23:01 | Emmet, Michigan, US |
2367727 | 2367727 | 2021-02-28 | Russia | Novosibirsk Oblast | 35749 | 1436 | 32824 | 1489 | 54.9720169 | 79.48139240000002 | 2021-03-01 05:23:01 | Novosibirsk Oblast, Russia | ||
3067621 | 3067621 | 2021-02-27 | US | Michigan | Emmet | 26047 | 1528 | 39 | 0 | 1489 | 45.52625509 | -84.89083249 | 2021-02-28 05:22:20 | Emmet, Michigan, US |
2186318 | 2186318 | 2021-02-26 | US | Puerto Rico | Gurabo | 72063 | 1489 | 0 | 0 | 1489 | 18.266461 | -65.97970500000001 | 2021-02-27 05:22:28 | Gurabo, Puerto Rico, US |
2185574 | 2185574 | 2021-02-26 | US | Montana | Glacier | 30035 | 1518 | 29 | 0 | 1489 | 48.70513576 | -112.9934235 | 2021-02-27 05:22:28 | Glacier, Montana, US |
1859996 | 1859996 | 2021-02-25 | US | Montana | Glacier | 30035 | 1518 | 29 | 0 | 1489 | 48.70513576 | -112.9934235 | 2021-02-26 05:22:40 | Glacier, Montana, US |
282174 | 282174 | 2021-02-24 | US | Montana | Glacier | 30035 | 1518 | 29 | 0 | 1489 | 48.70513576 | -112.9934235 | 2021-02-25 05:24:57 | Glacier, Montana, US |
1938442 | 1938442 | 2021-02-23 | US | Montana | Glacier | 30035 | 1518 | 29 | 0 | 1489 | 48.70513576 | -112.9934235 | 2021-02-24 05:29:16 | Glacier, Montana, US |
1154098 | 1154098 | 2021-02-18 | US | Illinois | Ford | 17053 | 1532 | 43 | 0 | 1489 | 40.59706922 | -88.22350769 | 2021-02-19 05:24:16 | Ford, Illinois, US |
1341003 | 1341003 | 2021-02-15 | US | Puerto Rico | Dorado | 72051 | 1489 | 0 | 0 | 1489 | 18.436115 | -66.278669 | 2021-02-16 05:24:38 | Dorado, Puerto Rico, US |
2678799 | 2678799 | 2021-02-13 | US | Illinois | Edgar | 17045 | 1525 | 36 | 0 | 1489 | 39.6809186 | -87.74759563 | 2021-02-14 05:23:43 | Edgar, Illinois, US |
3540432 | 3540432 | 2021-02-12 | US | Illinois | Edgar | 17045 | 1525 | 36 | 0 | 1489 | 39.6809186 | -87.74759563 | 2021-02-13 05:22:12 | Edgar, Illinois, US |
3981107 | 3981107 | 2021-02-10 | US | Oklahoma | Choctaw | 40023 | 1502 | 13 | 0 | 1489 | 34.02807439 | -95.54771129 | 2021-02-11 05:23:55 | Choctaw, Oklahoma, US |
1530264 | 1530264 | 2021-02-09 | US | North Carolina | Warren | 37185 | 1504 | 15 | 0 | 1489 | 36.39728256 | -78.10652228 | 2021-02-10 05:22:41 | Warren, North Carolina, US |
1675475 | 1675475 | 2021-02-07 | US | Texas | Bosque | 48035 | 1786 | 27 | 0 | 1489 | 31.89978581 | -97.63613524 | 2021-02-08 05:22:39 | Bosque, Texas, US |
1674237 | 1674237 | 2021-02-07 | US | Mississippi | Calhoun | 28013 | 1514 | 25 | 0 | 1489 | 33.93683395 | -89.33686647 | 2021-02-08 05:22:39 | Calhoun, Mississippi, US |
1674073 | 1674073 | 2021-02-07 | US | Michigan | Clare | 26035 | 1558 | 69 | 0 | 1489 | 43.98794227 | -84.84819859999998 | 2021-02-08 05:22:39 | Clare, Michigan, US |
976534 | 976534 | 2021-02-06 | US | Michigan | Clare | 26035 | 1558 | 69 | 0 | 1489 | 43.98794227 | -84.84819859999998 | 2021-02-07 05:23:00 | Clare, Michigan, US |
1590668 | 1590668 | 2021-02-05 | US | Ohio | Paulding | 39125 | 1525 | 36 | 0 | 1489 | 41.11676341 | -84.5801017 | 2021-02-06 05:23:55 | Paulding, Ohio, US |
792961 | 792961 | 2021-02-04 | US | Oklahoma | Pawnee | 40117 | 1514 | 25 | 0 | 1489 | 36.31743373 | -96.7033176 | 2021-02-05 05:22:38 | Pawnee, Oklahoma, US |
791740 | 791740 | 2021-02-04 | US | Kentucky | Anderson | 21005 | 1501 | 12 | 0 | 1489 | 38.00671029 | -84.99171713 | 2021-02-05 05:22:38 | Anderson, Kentucky, US |
343089 | 343089 | 2021-02-03 | US | South Carolina | Hampton | 45049 | 1530 | 41 | 0 | 1489 | 32.77419582 | -81.13845571 | 2021-02-04 05:22:26 | Hampton, South Carolina, US |
1687493 | 1687493 | 2021-02-02 | US | Tennessee | Union | 47173 | 1576 | 25 | 0 | 1489 | 36.28590426 | -83.83651902 | 2021-02-03 05:22:52 | Union, Tennessee, US |
1461082 | 1461082 | 2021-01-31 | US | Kansas | Pottawatomie | 20149 | 1502 | 13 | 0 | 1489 | 39.37925655 | -96.34564657 | 2021-02-01 05:22:53 | Pottawatomie, Kansas, US |
2213175 | 2213175 | 2021-01-30 | US | Louisiana | Madison | 22065 | 1517 | 28 | 0 | 1489 | 32.36918118 | -91.23973355 | 2021-01-31 05:22:42 | Madison, Louisiana, US |
2212990 | 2212990 | 2021-01-30 | US | Kansas | Pottawatomie | 20149 | 1502 | 13 | 0 | 1489 | 39.37925655 | -96.34564657 | 2021-01-31 05:22:42 | Pottawatomie, Kansas, US |
2212413 | 2212413 | 2021-01-30 | US | Georgia | Berrien | 13019 | 1524 | 35 | 0 | 1489 | 31.27590016 | -83.22529920000002 | 2021-01-31 05:22:42 | Berrien, Georgia, US |
1900486 | 1900486 | 2021-01-29 | US | Virginia | Fredericksburg | 51630 | 1503 | 14 | 0 | 1489 | 38.2977863 | -77.4922454 | 2021-01-30 05:22:49 | Fredericksburg, Virginia, US |
1898662 | 1898662 | 2021-01-29 | US | Louisiana | Madison | 22065 | 1517 | 28 | 0 | 1489 | 32.36918118 | -91.23973355 | 2021-01-30 05:22:49 | Madison, Louisiana, US |
1898477 | 1898477 | 2021-01-29 | US | Kansas | Pottawatomie | 20149 | 1502 | 13 | 0 | 1489 | 39.37925655 | -96.34564657 | 2021-01-30 05:22:49 | Pottawatomie, Kansas, US |
1897829 | 1897829 | 2021-01-29 | US | Florida | Calhoun | 12013 | 1525 | 36 | 0 | 1489 | 30.40666734 | -85.19394153 | 2021-01-30 05:22:49 | Calhoun, Florida, US |
15888 | 15888 | 2021-01-26 | US | Wisconsin | Lafayette | 55065 | 1497 | 8 | 0 | 1489 | 42.66005229 | -90.1317729 | 2021-01-27 05:23:41 | Lafayette, Wisconsin, US |
1760465 | 1760465 | 2021-01-24 | US | Iowa | Clayton | 19043 | 1538 | 49 | 0 | 1489 | 42.84443388 | -91.34133693 | 2021-01-25 05:22:16 | Clayton, Iowa, US |
1759759 | 1759759 | 2021-01-24 | US | Arkansas | Clay | 5021 | 1529 | 40 | 0 | 1489 | 36.36826212 | -90.4148172 | 2021-01-25 05:22:16 | Clay, Arkansas, US |
2428742 | 2428742 | 2021-01-23 | US | Mississippi | Stone | 28131 | 1514 | 25 | 0 | 1489 | 30.79187949 | -89.11547539 | 2021-01-24 05:22:35 | Stone, Mississippi, US |
2428072 | 2428072 | 2021-01-23 | US | Iowa | Clayton | 19043 | 1538 | 49 | 0 | 1489 | 42.84443388 | -91.34133693 | 2021-01-24 05:22:35 | Clayton, Iowa, US |
435743 | 435743 | 2021-01-21 | US | Alabama | Monroe | 1099 | 1507 | 18 | 0 | 1489 | 31.56729412 | -87.36995001 | 2021-01-22 05:22:10 | Monroe, Alabama, US |
911372 | 911372 | 2021-01-19 | US | Texas | Reeves | 48389 | 1209 | 33 | 0 | 1489 | 31.32323325 | -103.6903896 | 2021-01-20 05:21:54 | Reeves, Texas, US |
909367 | 909367 | 2021-01-19 | US | Iowa | Harrison | 19085 | 1551 | 62 | 0 | 1489 | 41.68330137 | -95.81558439 | 2021-01-20 05:21:54 | Harrison, Iowa, US |
3503866 | 3503866 | 2021-01-17 | US | Arkansas | Polk | 5113 | 1540 | 51 | 0 | 1489 | 34.48254879 | -94.22728802 | 2021-01-18 05:22:34 | Polk, Arkansas, US |
3880819 | 3880819 | 2021-01-14 | US | Iowa | Winneshiek | 19191 | 1508 | 19 | 0 | 1489 | 43.29094334 | -91.84422722 | 2021-01-15 05:22:24 | Winneshiek, Iowa, US |
776306 | 776306 | 2021-01-12 | US | Missouri | Ste. Genevieve | 29186 | 1500 | 11 | 0 | 1489 | 37.89090059 | -90.1949941 | 2021-01-13 05:22:15 | Ste. Genevieve, Missouri, US |
191257 | 191257 | 2021-01-11 | US | Iowa | Hardin | 19083 | 1518 | 29 | 0 | 1489 | 42.38353877 | -93.23654611 | 2021-01-12 05:22:15 | Hardin, Iowa, US |
2628189 | 2628189 | 2021-01-10 | US | North Carolina | Hertford | 37091 | 1541 | 52 | 0 | 1489 | 36.3607755 | -76.98104134 | 2021-01-11 05:21:50 | Hertford, North Carolina, US |
3900810 | 3900810 | 2021-01-09 | US | Georgia | Pike | 13231 | 1512 | 23 | 0 | 1489 | 33.09310242 | -84.38790389 | 2021-01-10 05:22:12 | Pike, Georgia, US |
156580 | 156580 | 2021-01-08 | US | Oregon | Benton | 41003 | 1500 | 11 | 0 | 1489 | 44.49167306 | -123.4316987 | 2021-01-09 05:22:18 | Benton, Oregon, US |
155909 | 155909 | 2021-01-08 | US | Missouri | Morgan | 29141 | 1513 | 24 | 0 | 1489 | 38.4181765 | -92.88791859 | 2021-01-09 05:22:18 | Morgan, Missouri, US |
2542781 | 2542781 | 2021-01-07 | US | Kentucky | Carter | 21043 | 1499 | 10 | 0 | 1489 | 38.31690743 | -83.05092385 | 2021-01-08 05:22:42 | Carter, Kentucky, US |
3232446 | 3232446 | 2021-01-03 | US | Montana | Lake | 30047 | 1505 | 16 | 0 | 1489 | 47.64514965 | -114.0898013 | 2021-01-04 05:22:02 | Lake, Montana, US |
767026 | 767026 | 2020-12-29 | US | Florida | Madison | 12079 | 1522 | 33 | 0 | 1489 | 30.44396917 | -83.47398594 | 2020-12-30 05:22:34 | Madison, Florida, US |
3764986 | 3764986 | 2020-12-28 | US | Virginia | Staunton | 51790 | 1511 | 22 | 0 | 1489 | 38.15965544 | -79.05979937 | 2020-12-29 05:22:37 | Staunton, Virginia, US |
204078 | 204078 | 2020-12-25 | US | Mississippi | Newton | 28101 | 1521 | 32 | 0 | 1489 | 32.40021118 | -89.11843336 | 2020-12-26 05:22:28 | Newton, Mississippi, US |
3693890 | 3693890 | 2020-12-24 | US | North Dakota | Richland | 38077 | 1514 | 15 | 0 | 1489 | 46.26440649 | -96.94852979 | 2020-12-25 05:22:48 | Richland, North Dakota, US |
3693741 | 3693741 | 2020-12-24 | US | New York | Tioga | 36107 | 1543 | 54 | 0 | 1489 | 42.16852837 | -76.30835812 | 2020-12-25 05:22:48 | Tioga, New York, US |
2121680 | 2121680 | 2020-12-20 | US | Missouri | Warren | 29219 | 1497 | 8 | 0 | 1489 | 38.76529479 | -91.16124662 | 2020-12-21 05:27:58 | Warren, Missouri, US |
2120252 | 2120252 | 2020-12-20 | US | California | Glenn | 6021 | 1491 | 9 | 0 | 1489 | 39.59875897 | -122.3938452 | 2020-12-21 05:27:58 | Glenn, California, US |
1903618 | 1903618 | 2020-12-18 | US | Ohio | Fayette | 39047 | 1516 | 27 | 0 | 1489 | 39.56021306 | -83.4562016 | 2020-12-19 05:27:52 | Fayette, Ohio, US |
2130034 | 2130034 | 2020-12-17 | US | Nebraska | Cass | 31025 | 1498 | 9 | 0 | 1489 | 40.90899107 | -96.13971217 | 2020-12-18 05:28:18 | Cass, Nebraska, US |
3150504 | 3150504 | 2020-12-16 | US | Idaho | Blaine | 16013 | 1499 | 10 | 0 | 1489 | 43.4085812 | -113.9752658 | 2020-12-17 05:28:12 | Blaine, Idaho, US |
1035391 | 1035391 | 2020-12-15 | US | Illinois | Montgomery | 17135 | 1507 | 18 | 0 | 1489 | 39.23198845 | -89.47809254 | 2020-12-16 05:28:04 | Montgomery, Illinois, US |
1754683 | 1754683 | 2020-12-14 | US | Virginia | Wise | 51195 | 1540 | 51 | 0 | 1489 | 36.9746148 | -82.62410519 | 2020-12-15 05:26:38 | Wise, Virginia, US |
3848004 | 3848004 | 2020-12-13 | Russia | Kursk Oblast | 17511 | 242 | 15780 | 1489 | 51.6568453 | 36.4852695 | 2020-12-14 05:26:27 | Kursk Oblast, Russia | ||
1600595 | 1600595 | 2020-12-10 | US | Alabama | Lawrence | 1079 | 1525 | 36 | 0 | 1489 | 34.52041498 | -87.31069453 | 2020-12-11 05:26:59 | Lawrence, Alabama, US |
1820560 | 1820560 | 2020-12-08 | US | Mississippi | Adams | 28001 | 1541 | 52 | 0 | 1489 | 31.47669768 | -91.35326037 | 2020-12-09 05:28:01 | Adams, Mississippi, US |
78071 | 78071 | 2020-12-03 | US | Tennessee | Smith | 47159 | 1500 | 20 | 0 | 1489 | 36.25359775 | -85.95411046 | 2020-12-04 05:27:27 | Smith, Tennessee, US |
739995 | 739995 | 2020-12-02 | US | Minnesota | Cass | 27021 | 1499 | 10 | 0 | 1489 | 46.95043611 | -94.32603968 | 2020-12-03 05:28:22 | Cass, Minnesota, US |
1584914 | 1584914 | 2020-11-30 | US | Georgia | Bryan | 13029 | 1507 | 18 | 0 | 1489 | 32.00979311 | -81.44002948 | 2020-12-01 05:26:18 | Bryan, Georgia, US |
1583871 | 1583871 | 2020-11-30 | Bahamas | 7541 | 163 | 5889 | 1489 | 25.025885 | -78.035889 | 2020-12-01 05:26:18 | Bahamas | |||
3566425 | 3566425 | 2020-11-29 | Colombia | Risaralda | 23071 | 552 | 21030 | 1489 | 5.3158 | -75.9928 | 2020-11-30 05:26:13 | Risaralda, Colombia | ||
2937477 | 2937477 | 2020-11-28 | US | New York | Oswego | 36075 | 1496 | 7 | 0 | 1489 | 43.42778894 | -76.14635194 | 2020-11-29 05:25:55 | Oswego, New York, US |
392149 | 392149 | 2020-11-27 | Germany | Mecklenburg-Vorpommern | 5695 | 58 | 4270 | 1489 | 53.6127 | 12.4296 | 2020-11-28 05:25:50 | Mecklenburg-Vorpommern, Germany | ||
925515 | 925515 | 2020-11-26 | US | Mississippi | Scott | 28123 | 1518 | 29 | 0 | 1489 | 32.406704100000006 | -89.53789439 | 2020-11-27 05:26:53 | Scott, Mississippi, US |
3190235 | 3190235 | 2020-11-22 | Russia | Tambov Oblast | 12229 | 75 | 10665 | 1489 | 52.9019574 | 41.3578918 | 2020-11-23 05:25:26 | Tambov Oblast, Russia | ||
823588 | 823588 | 2020-11-19 | US | Montana | Silver Bow | 30093 | 1506 | 17 | 0 | 1489 | 45.90018933 | -112.6620092 | 2020-11-20 05:26:28 | Silver Bow, Montana, US |
3340420 | 3340420 | 2020-11-17 | US | Mississippi | Pike | 28113 | 1547 | 58 | 0 | 1489 | 31.17507789 | -90.40392572 | 2020-11-18 05:40:31 | Pike, Mississippi, US |
2916741 | 2916741 | 2020-11-14 | US | Maryland | Allegany | 24001 | 1520 | 31 | 0 | 1489 | 39.62357628 | -78.69280486 | 2020-11-15 05:26:53 | Allegany, Maryland, US |
2787577 | 2787577 | 2020-11-13 | US | Oklahoma | Okmulgee | 40111 | 1503 | 14 | 0 | 1489 | 35.64661916 | -95.96432828 | 2020-11-14 05:25:37 | Okmulgee, Oklahoma, US |
866335 | 866335 | 2020-11-12 | US | Maryland | Cecil | 24015 | 1526 | 37 | 0 | 1489 | 39.56647682 | -75.94627411 | 2020-11-13 05:25:30 | Cecil, Maryland, US |
1992255 | 1992255 | 2020-11-09 | Ukraine | Kirovohrad Oblast | 3142 | 104 | 1549 | 1489 | 48.5079 | 32.2623 | 2020-11-10 05:40:07 | Kirovohrad Oblast, Ukraine | ||
1992057 | 1992057 | 2020-11-09 | US | Washington | Douglas | 53017 | 1499 | 10 | 0 | 1489 | 47.7361335 | -119.692937 | 2020-11-10 05:40:07 | Douglas, Washington, US |
1991363 | 1991363 | 2020-11-09 | US | Puerto Rico | Guaynabo | 72061 | 1489 | 0 | 0 | 1489 | 18.345114 | -66.11452299999999 | 2020-11-10 05:40:07 | Guaynabo, Puerto Rico, US |
1989148 | 1989148 | 2020-11-09 | US | Arkansas | Sevier | 5133 | 1505 | 16 | 0 | 1489 | 33.99780401 | -94.2424869 | 2020-11-10 05:40:07 | Sevier, Arkansas, US |
1544568 | 1544568 | 2020-11-07 | US | Colorado | Logan | 8075 | 1674 | 32 | 0 | 1489 | 40.7249637 | -103.110817 | 2020-11-08 05:24:56 | Logan, Colorado, US |
2922436 | 2922436 | 2020-11-04 | US | Utah | Central Utah | 1500 | 11 | 0 | 1489 | 39.37231946 | -111.5758676 | 2020-11-05 06:05:03 | Central Utah, Utah, 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]);