johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
148 rows where active = 1634 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 15
- US 111
- Russia 10
- Colombia 6
- India 4
- Ukraine 4
- Chile 3
- Japan 2
- Guinea 1
- Italy 1
- Libya 1
- Malaysia 1
- Mozambique 1
- Netherlands 1
- Qatar 1
- Uzbekistan 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3476493 | 3476493 | 2021-07-22 | Qatar | 224834 | 600 | 222600 | 1634 | 25.3548 | 51.1839 | 2021-07-23 04:21:29 | Qatar | |||
3331737 | 3331737 | 2021-07-21 | Russia | Kamchatka Krai | 16250 | 238 | 14378 | 1634 | 57.1914882 | 160.03838190000005 | 2021-07-22 04:21:19 | Kamchatka Krai, Russia | ||
2371460 | 2371460 | 2021-07-20 | India | Jammu and Kashmir | 320112 | 4371 | 314107 | 1634 | 33.75943 | 76.612638 | 2021-07-21 04:21:40 | Jammu and Kashmir, India | ||
296222 | 296222 | 2021-07-15 | Russia | Kemerovo Oblast | 42647 | 892 | 40121 | 1634 | 54.53357809999999 | 87.342861 | 2021-07-16 04:21:22 | Kemerovo Oblast, Russia | ||
295848 | 295848 | 2021-07-15 | Colombia | Bolivar | 143876 | 2727 | 139515 | 1634 | 8.6704 | -74.03 | 2021-07-16 04:21:22 | Bolivar, Colombia | ||
563081 | 563081 | 2021-06-22 | Mozambique | 72775 | 852 | 70289 | 1634 | -18.665695 | 35.529562 | 2021-06-23 04:21:46 | Mozambique | |||
1125383 | 1125383 | 2021-06-18 | Chile | Los Rios | 43164 | 500 | 41030 | 1634 | -40.231 | -72.3311 | 2021-06-19 04:22:33 | Los Rios, Chile | ||
3030476 | 3030476 | 2021-06-16 | Russia | Arkhangelsk Oblast | 64955 | 1008 | 62313 | 1634 | 63.5589686 | 43.1221646 | 2021-06-17 04:22:36 | Arkhangelsk Oblast, Russia | ||
1188954 | 1188954 | 2021-05-31 | Russia | Khabarovsk Krai | 52562 | 414 | 50514 | 1634 | 51.6312684 | 136.121524 | 2021-06-01 04:23:09 | Khabarovsk Krai, Russia | ||
1310377 | 1310377 | 2021-05-26 | Russia | Khabarovsk Krai | 52371 | 406 | 50331 | 1634 | 51.6312684 | 136.121524 | 2021-05-27 04:20:59 | Khabarovsk Krai, Russia | ||
1952364 | 1952364 | 2021-05-21 | Colombia | Magdalena | 66843 | 2549 | 62660 | 1634 | 10.4113 | -74.4057 | 2021-05-22 04:20:45 | Magdalena, Colombia | ||
3675497 | 3675497 | 2021-05-04 | Colombia | Cordoba | 53223 | 2244 | 49345 | 1634 | 8.0493 | -75.574 | 2021-05-05 04:20:43 | Cordoba, Colombia | ||
2024342 | 2024342 | 2021-04-20 | Ukraine | Crimea Republic* | 39463 | 1167 | 36662 | 1634 | 45.2835 | 34.2008 | 2021-04-21 04:21:14 | Crimea Republic*, Ukraine | ||
2552536 | 2552536 | 2021-04-15 | Uzbekistan | 85730 | 634 | 83462 | 1634 | 41.377491 | 64.585262 | 2021-04-16 04:20:46 | Uzbekistan | |||
388246 | 388246 | 2021-04-04 | Japan | Miyagi | 6498 | 33 | 4831 | 1634 | 38.446859 | 140.927086 | 2021-04-05 04:20:35 | Miyagi, Japan | ||
3647226 | 3647226 | 2021-03-30 | Malaysia | Johor | 41172 | 103 | 39435 | 1634 | 1.4854 | 103.7618 | 2021-03-31 04:26:25 | Johor, Malaysia | ||
1744757 | 1744757 | 2021-03-20 | Russia | Leningrad Oblast | 38659 | 845 | 36180 | 1634 | 60.1853296 | 32.3925325 | 2021-03-21 05:25:44 | Leningrad Oblast, Russia | ||
2359437 | 2359437 | 2021-03-08 | India | Uttar Pradesh | 604380 | 8738 | 594008 | 1634 | 26.925425 | 80.560982 | 2021-03-09 05:28:19 | Uttar Pradesh, India | ||
3669407 | 3669407 | 2021-03-06 | US | Mississippi | Clarke | 28023 | 1707 | 73 | 0 | 1634 | 32.04158545 | -88.68896219999998 | 2021-03-07 05:21:54 | Clarke, Mississippi, US |
3668746 | 3668746 | 2021-03-06 | US | Indiana | Rush | 18139 | 1656 | 22 | 0 | 1634 | 39.62002287 | -85.4655599 | 2021-03-07 05:21:54 | Rush, Indiana, US |
1091123 | 1091123 | 2021-03-03 | US | Illinois | Wayne | 17191 | 1683 | 49 | 0 | 1634 | 38.42955355 | -88.42586459 | 2021-03-04 05:24:24 | Wayne, Illinois, US |
3066462 | 3066462 | 2021-02-27 | US | Arkansas | Clay | 5021 | 1680 | 46 | 0 | 1634 | 36.36826212 | -90.4148172 | 2021-02-28 05:22:20 | Clay, Arkansas, US |
2183522 | 2183522 | 2021-02-26 | India | Assam | 217518 | 1092 | 214792 | 1634 | 26.357149 | 92.830441 | 2021-02-27 05:22:28 | Assam, India | ||
1858580 | 1858580 | 2021-02-25 | US | California | Siskiyou | 6093 | 1616 | 4 | 0 | 1634 | 41.59198861 | -122.5407434 | 2021-02-26 05:22:40 | Siskiyou, California, US |
281209 | 281209 | 2021-02-24 | US | Illinois | Pike | 17149 | 1683 | 49 | 0 | 1634 | 39.62265059 | -90.8877017 | 2021-02-25 05:24:57 | Pike, Illinois, US |
1937193 | 1937193 | 2021-02-23 | US | Georgia | Banks | 13011 | 1665 | 31 | 0 | 1634 | 34.35607081 | -83.49644388 | 2021-02-24 05:29:16 | Banks, Georgia, US |
185042 | 185042 | 2021-02-21 | US | Texas | Andrews | 48003 | 1381 | 45 | 0 | 1634 | 32.30468633 | -102.6376548 | 2021-02-22 05:24:21 | Andrews, Texas, US |
184379 | 184379 | 2021-02-21 | US | North Carolina | Northampton | 37131 | 1662 | 28 | 0 | 1634 | 36.41736238 | -77.39769443 | 2021-02-22 05:24:21 | Northampton, North Carolina, US |
745316 | 745316 | 2021-02-20 | US | Texas | Andrews | 48003 | 1381 | 45 | 0 | 1634 | 32.30468633 | -102.6376548 | 2021-02-21 05:24:33 | Andrews, Texas, US |
742443 | 742443 | 2021-02-20 | Netherlands | Unknown | 2146 | 25 | 0 | 1634 | 2021-02-21 05:24:33 | Unknown, Netherlands | ||||
474414 | 474414 | 2021-02-19 | US | Texas | Andrews | 48003 | 1381 | 45 | 0 | 1634 | 32.30468633 | -102.6376548 | 2021-02-20 05:22:51 | Andrews, Texas, US |
472374 | 472374 | 2021-02-19 | US | Illinois | Clark | 17023 | 1663 | 29 | 0 | 1634 | 39.33425789 | -87.78705622 | 2021-02-20 05:22:51 | Clark, Illinois, US |
1156249 | 1156249 | 2021-02-18 | US | Texas | Karnes | 48255 | 1700 | 31 | 0 | 1634 | 28.90705334 | -97.85960149 | 2021-02-19 05:24:16 | Karnes, Texas, US |
1156123 | 1156123 | 2021-02-18 | US | Texas | Andrews | 48003 | 1381 | 45 | 0 | 1634 | 32.30468633 | -102.6376548 | 2021-02-19 05:24:16 | Andrews, Texas, US |
3604169 | 3604169 | 2021-02-17 | US | Texas | Karnes | 48255 | 1700 | 31 | 0 | 1634 | 28.90705334 | -97.85960149 | 2021-02-18 05:22:58 | Karnes, Texas, US |
3604043 | 3604043 | 2021-02-17 | US | Texas | Andrews | 48003 | 1381 | 45 | 0 | 1634 | 32.30468633 | -102.6376548 | 2021-02-18 05:22:58 | Andrews, Texas, US |
3053304 | 3053304 | 2021-02-16 | US | Texas | Karnes | 48255 | 1700 | 31 | 0 | 1634 | 28.90705334 | -97.85960149 | 2021-02-17 05:23:10 | Karnes, Texas, US |
3053178 | 3053178 | 2021-02-16 | US | Texas | Andrews | 48003 | 1381 | 45 | 0 | 1634 | 32.30468633 | -102.6376548 | 2021-02-17 05:23:10 | Andrews, Texas, US |
3051444 | 3051444 | 2021-02-16 | US | Kansas | Dickinson | 20041 | 1670 | 36 | 0 | 1634 | 38.86600962 | -97.15532383 | 2021-02-17 05:23:10 | Dickinson, Kansas, US |
1341403 | 1341403 | 2021-02-15 | US | Texas | Karnes | 48255 | 1700 | 31 | 0 | 1634 | 28.90705334 | -97.85960149 | 2021-02-16 05:24:38 | Karnes, Texas, US |
1341277 | 1341277 | 2021-02-15 | US | Texas | Andrews | 48003 | 1381 | 45 | 0 | 1634 | 32.30468633 | -102.6376548 | 2021-02-16 05:24:38 | Andrews, Texas, US |
1339543 | 1339543 | 2021-02-15 | US | Kansas | Dickinson | 20041 | 1670 | 36 | 0 | 1634 | 38.86600962 | -97.15532383 | 2021-02-16 05:24:38 | Dickinson, Kansas, US |
2286554 | 2286554 | 2021-02-14 | US | Texas | Karnes | 48255 | 1700 | 31 | 0 | 1634 | 28.90705334 | -97.85960149 | 2021-02-15 05:24:49 | Karnes, Texas, US |
2286428 | 2286428 | 2021-02-14 | US | Texas | Andrews | 48003 | 1381 | 45 | 0 | 1634 | 32.30468633 | -102.6376548 | 2021-02-15 05:24:49 | Andrews, Texas, US |
2680954 | 2680954 | 2021-02-13 | US | Texas | Karnes | 48255 | 1700 | 31 | 0 | 1634 | 28.90705334 | -97.85960149 | 2021-02-14 05:23:43 | Karnes, Texas, US |
2680828 | 2680828 | 2021-02-13 | US | Texas | Andrews | 48003 | 1381 | 45 | 0 | 1634 | 32.30468633 | -102.6376548 | 2021-02-14 05:23:43 | Andrews, Texas, US |
3542461 | 3542461 | 2021-02-12 | US | Texas | Andrews | 48003 | 1381 | 45 | 0 | 1634 | 32.30468633 | -102.6376548 | 2021-02-13 05:22:12 | Andrews, Texas, US |
3541298 | 3541298 | 2021-02-12 | US | Mississippi | Stone | 28131 | 1662 | 28 | 0 | 1634 | 30.79187949 | -89.11547539 | 2021-02-13 05:22:12 | Stone, Mississippi, US |
3540191 | 3540191 | 2021-02-12 | US | Florida | Union | 12125 | 1704 | 70 | 0 | 1634 | 30.04412971 | -82.37497443 | 2021-02-13 05:22:12 | Union, Florida, US |
3981611 | 3981611 | 2021-02-10 | US | Texas | Cass | 48067 | 1683 | 73 | 0 | 1634 | 33.07499881 | -94.34646905 | 2021-02-11 05:23:55 | Cass, Texas, US |
1528713 | 1528713 | 2021-02-09 | US | Georgia | Jeff Davis | 13161 | 1673 | 39 | 0 | 1634 | 31.80405727 | -82.63724870000001 | 2021-02-10 05:22:41 | Jeff Davis, Georgia, US |
616639 | 616639 | 2021-02-08 | US | Tennessee | Lake | 47095 | 1662 | 24 | 0 | 1634 | 36.34180170000001 | -89.48921915 | 2021-02-09 05:23:30 | Lake, Tennessee, US |
1675652 | 1675652 | 2021-02-07 | US | Texas | Reeves | 48389 | 1359 | 38 | 0 | 1634 | 31.32323325 | -103.6903896 | 2021-02-08 05:22:39 | Reeves, Texas, US |
1675408 | 1675408 | 2021-02-07 | US | Tennessee | Lake | 47095 | 1662 | 24 | 0 | 1634 | 36.34180170000001 | -89.48921915 | 2021-02-08 05:22:39 | Lake, Tennessee, US |
976105 | 976105 | 2021-02-06 | US | Iowa | Hamilton | 19079 | 1672 | 38 | 0 | 1634 | 42.38382428 | -93.70197703 | 2021-02-07 05:23:00 | Hamilton, Iowa, US |
343650 | 343650 | 2021-02-03 | US | Virginia | Nottoway | 51135 | 1661 | 27 | 0 | 1634 | 37.1435975 | -78.05065922 | 2021-02-04 05:22:26 | Nottoway, Virginia, US |
1679382 | 1679382 | 2021-02-01 | US | Tennessee | Cannon | 47015 | 1673 | 24 | 0 | 1634 | 35.80990797 | -86.05738983 | 2021-02-02 05:22:49 | Cannon, Tennessee, US |
1677715 | 1677715 | 2021-02-01 | US | Iowa | Winneshiek | 19191 | 1658 | 24 | 0 | 1634 | 43.29094334 | -91.84422722 | 2021-02-02 05:22:49 | Winneshiek, Iowa, US |
1460579 | 1460579 | 2021-01-31 | US | Georgia | Jones | 13169 | 1665 | 31 | 0 | 1634 | 33.02512137 | -83.56019163 | 2021-02-01 05:22:53 | Jones, Georgia, US |
1759094 | 1759094 | 2021-01-24 | Chile | Valparaiso | 41669 | 1354 | 38681 | 1634 | -33.0472 | -71.6127 | 2021-01-25 05:22:16 | Valparaiso, Chile | ||
1096234 | 1096234 | 2021-01-20 | US | New Hampshire | Grafton | 33009 | 1645 | 11 | 0 | 1634 | 43.93779815 | -71.82057197 | 2021-01-21 05:22:01 | Grafton, New Hampshire, US |
911479 | 911479 | 2021-01-19 | US | Virginia | Buckingham | 51029 | 1648 | 14 | 0 | 1634 | 37.57242268 | -78.52518834 | 2021-01-20 05:21:54 | Buckingham, Virginia, US |
3505964 | 3505964 | 2021-01-17 | US | Oregon | Douglas | 41019 | 1677 | 43 | 0 | 1634 | 43.27941273 | -123.167291 | 2021-01-18 05:22:34 | Douglas, Oregon, US |
3515768 | 3515768 | 2021-01-15 | US | Alabama | Fayette | 1057 | 1660 | 26 | 0 | 1634 | 33.72076938 | -87.73886638 | 2021-01-16 05:22:40 | Fayette, Alabama, US |
3515186 | 3515186 | 2021-01-15 | Chile | Araucania | 26935 | 355 | 24946 | 1634 | -38.9489 | -72.3311 | 2021-01-16 05:22:40 | Araucania, Chile | ||
3880743 | 3880743 | 2021-01-14 | US | Iowa | Clay | 19041 | 1653 | 19 | 0 | 1634 | 43.08247182 | -95.15096481 | 2021-01-15 05:22:24 | Clay, Iowa, US |
3309770 | 3309770 | 2021-01-13 | US | Maryland | Dorchester | 24019 | 1658 | 24 | 0 | 1634 | 38.45413522 | -76.02752426 | 2021-01-14 05:22:32 | Dorchester, Maryland, US |
190535 | 190535 | 2021-01-11 | US | Arkansas | Conway | 5029 | 1653 | 19 | 0 | 1634 | 35.26205537 | -92.70506566 | 2021-01-12 05:22:15 | Conway, Arkansas, US |
2625883 | 2625883 | 2021-01-10 | Japan | Hokkaido | 14713 | 506 | 12573 | 1634 | 43.385711 | 142.552318 | 2021-01-11 05:21:50 | Hokkaido, Japan | ||
2543830 | 2543830 | 2021-01-07 | US | North Dakota | Walsh | 38099 | 1644 | 22 | 0 | 1634 | 48.36876964 | -97.72574783 | 2021-01-08 05:22:42 | Walsh, North Dakota, US |
2542533 | 2542533 | 2021-01-07 | US | Indiana | Spencer | 18147 | 1648 | 14 | 0 | 1634 | 38.01519732 | -87.0079644 | 2021-01-08 05:22:42 | Spencer, Indiana, US |
1063840 | 1063840 | 2021-01-04 | US | Montana | Hill | 30041 | 1668 | 34 | 0 | 1634 | 48.62879827 | -110.1129252 | 2021-01-05 05:21:49 | Hill, Montana, US |
3232569 | 3232569 | 2021-01-03 | US | Nebraska | Washington | 31177 | 1651 | 17 | 0 | 1634 | 41.52815707 | -96.22019892 | 2021-01-04 05:22:02 | Washington, Nebraska, US |
3231851 | 3231851 | 2021-01-03 | US | Kentucky | Harlan | 21095 | 1657 | 23 | 0 | 1634 | 36.85699301 | -83.21899516 | 2021-01-04 05:22:02 | Harlan, Kentucky, US |
1140364 | 1140364 | 2021-01-01 | US | West Virginia | Logan | 54045 | 1693 | 59 | 0 | 1634 | 37.8299889 | -81.93528571 | 2021-01-02 05:22:33 | Logan, West Virginia, US |
3697409 | 3697409 | 2020-12-31 | US | Missouri | McDonald | 29119 | 1652 | 18 | 0 | 1634 | 36.62869595 | -94.34867205 | 2021-01-01 05:23:07 | McDonald, Missouri, US |
1013440 | 1013440 | 2020-12-30 | US | Texas | Kleberg | 48273 | 1763 | 59 | 0 | 1634 | 27.42435506 | -97.69894948 | 2020-12-31 05:22:49 | Kleberg, Texas, US |
1011347 | 1011347 | 2020-12-30 | US | Illinois | Union | 17181 | 1663 | 29 | 0 | 1634 | 37.47119609 | -89.25548938 | 2020-12-31 05:22:49 | Union, Illinois, US |
3781133 | 3781133 | 2020-12-27 | US | Texas | Upshur | 48459 | 1752 | 31 | 0 | 1634 | 32.73706798 | -94.93999853 | 2020-12-28 05:22:06 | Upshur, Texas, US |
3691336 | 3691336 | 2020-12-24 | Colombia | Quindio | 22224 | 606 | 19984 | 1634 | 4.461 | -75.6674 | 2020-12-25 05:22:48 | Quindio, Colombia | ||
3770894 | 3770894 | 2020-12-22 | US | Illinois | Montgomery | 17135 | 1655 | 21 | 0 | 1634 | 39.23198845 | -89.47809254 | 2020-12-23 05:22:03 | Montgomery, Illinois, US |
2932339 | 2932339 | 2020-12-19 | US | Indiana | Posey | 18129 | 1661 | 27 | 0 | 1634 | 38.02097333 | -87.86480429 | 2020-12-20 05:27:32 | Posey, Indiana, US |
3151532 | 3151532 | 2020-12-16 | US | Missouri | Polk | 29167 | 1650 | 16 | 0 | 1634 | 37.6162296 | -93.39828174 | 2020-12-17 05:28:12 | Polk, Missouri, US |
3850609 | 3850609 | 2020-12-13 | US | South Carolina | Marlboro | 45069 | 1656 | 22 | 0 | 1634 | 34.59905577 | -79.67561152 | 2020-12-14 05:26:27 | Marlboro, South Carolina, US |
3848538 | 3848538 | 2020-12-13 | US | Georgia | Bryan | 13029 | 1652 | 18 | 0 | 1634 | 32.00979311 | -81.44002948 | 2020-12-14 05:26:27 | Bryan, Georgia, US |
2976052 | 2976052 | 2020-12-09 | US | Georgia | Liberty | 13179 | 1664 | 30 | 0 | 1634 | 31.82588896 | -81.49251135 | 2020-12-10 05:26:19 | Liberty, Georgia, US |
1821592 | 1821592 | 2020-12-08 | US | South Carolina | Dillon | 45033 | 1687 | 53 | 0 | 1634 | 34.39007791 | -79.37741872 | 2020-12-09 05:28:01 | Dillon, South Carolina, US |
2348941 | 2348941 | 2020-12-07 | US | Louisiana | Sabine | 22085 | 1662 | 28 | 0 | 1634 | 31.56388699 | -93.55433981 | 2020-12-08 05:27:42 | Sabine, Louisiana, US |
1007305 | 1007305 | 2020-12-06 | US | Illinois | McDonough | 17109 | 1667 | 33 | 0 | 1634 | 40.45674722 | -90.67775541 | 2020-12-07 05:26:14 | McDonough, Illinois, US |
3862664 | 3862664 | 2020-12-04 | US | South Carolina | Williamsburg | 45089 | 1686 | 52 | 0 | 1634 | 33.62190129 | -79.72767442 | 2020-12-05 05:27:36 | Williamsburg, South Carolina, US |
3860240 | 3860240 | 2020-12-04 | US | Alaska | Bethel | 2050 | 1641 | 7 | 0 | 1634 | 60.90980451 | -159.8561831 | 2020-12-05 05:27:36 | Bethel, Alaska, US |
739391 | 739391 | 2020-12-02 | US | Indiana | Jasper | 18073 | 1650 | 16 | 0 | 1634 | 41.02078733 | -87.11553319 | 2020-12-03 05:28:22 | Jasper, Indiana, US |
2539544 | 2539544 | 2020-12-01 | US | New Hampshire | Strafford | 33017 | 1649 | 15 | 0 | 1634 | 43.291833 | -71.02336013 | 2020-12-02 05:27:41 | Strafford, New Hampshire, US |
2937482 | 2937482 | 2020-11-28 | US | New York | Rensselaer | 36083 | 1686 | 52 | 0 | 1634 | 42.71348136 | -73.51089874 | 2020-11-29 05:25:55 | Rensselaer, New York, US |
927218 | 927218 | 2020-11-26 | US | Wisconsin | Green | 55045 | 1640 | 6 | 0 | 1634 | 42.6794956 | -89.60243287 | 2020-11-27 05:26:53 | Green, Wisconsin, US |
926592 | 926592 | 2020-11-26 | US | Tennessee | Carroll | 47017 | 1660 | 34 | 0 | 1634 | 35.97366108 | -88.45189331 | 2020-11-27 05:26:53 | Carroll, Tennessee, US |
1351604 | 1351604 | 2020-11-24 | US | Kansas | Harvey | 20079 | 1643 | 9 | 0 | 1634 | 38.04293782 | -97.42747573 | 2020-11-25 05:27:20 | Harvey, Kansas, US |
679598 | 679598 | 2020-11-23 | US | Kansas | Harvey | 20079 | 1643 | 9 | 0 | 1634 | 38.04293782 | -97.42747573 | 2020-11-24 05:27:31 | Harvey, Kansas, US |
3839282 | 3839282 | 2020-11-21 | US | South Carolina | Chesterfield | 45025 | 1686 | 52 | 0 | 1634 | 34.64137396 | -80.15640140000002 | 2020-11-22 05:25:45 | Chesterfield, South Carolina, US |
3839061 | 3839061 | 2020-11-21 | US | Oklahoma | Pontotoc | 40123 | 1644 | 10 | 0 | 1634 | 34.72959848 | -96.68337199 | 2020-11-22 05:25:45 | Pontotoc, Oklahoma, 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]);