johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
386 rows where active = 592 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 23
- US 328
- Russia 13
- Japan 6
- India 5
- Colombia 4
- Chile 3
- Gabon 3
- Mexico 3
- Canada 2
- Guinea-Bissau 2
- Italy 2
- Malaysia 2
- Netherlands 2
- Ukraine 2
- Bahamas 1
- China 1
- Croatia 1
- Guinea 1
- Kyrgyzstan 1
- Peru 1
- Spain 1
- Tajikistan 1
- Trinidad and Tobago 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2673757 | 2673757 | 2021-07-18 | India | Delhi | 1435529 | 25027 | 1409910 | 592 | 28.646519 | 77.10898 | 2021-07-19 04:21:24 | Delhi, India | ||
3659465 | 3659465 | 2021-07-11 | Croatia | 360826 | 8227 | 352007 | 592 | 45.1 | 15.2 | 2021-07-12 04:21:34 | Croatia | |||
1425100 | 1425100 | 2021-05-09 | Italy | Valle d'Aosta | 11217 | 462 | 10163 | 592 | 45.73750286 | 7.320149366 | 2021-05-10 04:20:38 | Valle d'Aosta, Italy | ||
2502037 | 2502037 | 2021-05-07 | Japan | Gifu | 6288 | 138 | 5558 | 592 | 35.778671 | 137.055925 | 2021-05-08 04:21:04 | Gifu, Japan | ||
888133 | 888133 | 2021-04-26 | Japan | Ibaraki | 7922 | 133 | 7197 | 592 | 36.303588 | 140.319591 | 2021-04-27 04:20:52 | Ibaraki, Japan | ||
954570 | 954570 | 2021-04-25 | Bahamas | 10050 | 196 | 9262 | 592 | 25.025885 | -78.035889 | 2021-04-26 04:21:04 | Bahamas | |||
1409288 | 1409288 | 2021-04-23 | Russia | Smolensk Oblast | 29096 | 843 | 27661 | 592 | 55.03434960000001 | 33.0192065 | 2021-04-24 04:20:38 | Smolensk Oblast, Russia | ||
1980857 | 1980857 | 2021-03-25 | Russia | Sakha (Yakutiya) Republic | 33411 | 542 | 32277 | 592 | 66.941626 | 129.642371 | 2021-03-26 05:26:55 | Sakha (Yakutiya) Republic, Russia | ||
702405 | 702405 | 2021-03-16 | Japan | Aichi | 26523 | 562 | 25369 | 592 | 35.035551 | 137.211621 | 2021-03-17 05:25:07 | Aichi, Japan | ||
2359396 | 2359396 | 2021-03-08 | Guinea-Bissau | 3312 | 49 | 2671 | 592 | 11.8037 | -15.1804 | 2021-03-09 05:28:19 | Guinea-Bissau | |||
54734 | 54734 | 2021-03-07 | Guinea-Bissau | 3312 | 49 | 2671 | 592 | 11.8037 | -15.1804 | 2021-03-08 05:24:48 | Guinea-Bissau | |||
3668513 | 3668513 | 2021-03-06 | US | Georgia | Wheeler | 13309 | 615 | 23 | 0 | 592 | 32.12009104 | -82.72574721 | 2021-03-07 05:21:54 | Wheeler, Georgia, US |
1619121 | 1619121 | 2021-03-05 | US | South Dakota | Lyman | 46085 | 602 | 10 | 0 | 592 | 43.89522709 | -99.85201878 | 2021-03-06 04:23:41 | Lyman, South Dakota, US |
2210532 | 2210532 | 2021-03-04 | US | South Dakota | Lyman | 46085 | 602 | 10 | 0 | 592 | 43.89522709 | -99.85201878 | 2021-03-05 05:26:29 | Lyman, South Dakota, US |
3255765 | 3255765 | 2021-03-02 | US | Michigan | Crawford | 26039 | 597 | 5 | 0 | 592 | 44.68255561 | -84.61006219 | 2021-03-03 05:23:28 | Crawford, Michigan, US |
3065841 | 3065841 | 2021-02-27 | Colombia | Cauca | 27343 | 748 | 26003 | 592 | 2.705 | -76.82600000000002 | 2021-02-28 05:22:20 | Cauca, Colombia | ||
2185388 | 2185388 | 2021-02-26 | US | Mississippi | Jefferson | 28063 | 619 | 27 | 0 | 592 | 31.73397872 | -91.03764977 | 2021-02-27 05:22:28 | Jefferson, Mississippi, US |
1858896 | 1858896 | 2021-02-25 | US | Georgia | Wheeler | 13309 | 615 | 23 | 0 | 592 | 32.12009104 | -82.72574721 | 2021-02-26 05:22:40 | Wheeler, Georgia, US |
183379 | 183379 | 2021-02-21 | US | Kansas | Sherman | 20181 | 603 | 11 | 0 | 592 | 39.35147699 | -101.7197624 | 2021-02-22 05:24:21 | Sherman, Kansas, US |
743653 | 743653 | 2021-02-20 | US | Kansas | Sherman | 20181 | 603 | 11 | 0 | 592 | 39.35147699 | -101.7197624 | 2021-02-21 05:24:33 | Sherman, Kansas, US |
473823 | 473823 | 2021-02-19 | US | North Dakota | Ransom | 38073 | 609 | 16 | 0 | 592 | 46.45621782 | -97.65742504 | 2021-02-20 05:22:51 | Ransom, North Dakota, US |
473453 | 473453 | 2021-02-19 | US | Nebraska | Burt | 31021 | 603 | 11 | 0 | 592 | 41.85056773 | -96.32605633 | 2021-02-20 05:22:51 | Burt, Nebraska, US |
472751 | 472751 | 2021-02-19 | US | Kansas | Sherman | 20181 | 603 | 11 | 0 | 592 | 39.35147699 | -101.7197624 | 2021-02-20 05:22:51 | Sherman, Kansas, US |
3602894 | 3602894 | 2021-02-17 | US | Mississippi | Wilkinson | 28157 | 618 | 26 | 0 | 592 | 31.16078225 | -91.31018819 | 2021-02-18 05:22:58 | Wilkinson, Mississippi, US |
3053062 | 3053062 | 2021-02-16 | US | South Dakota | Moody | 46101 | 608 | 16 | 0 | 592 | 44.02266214 | -96.67081159 | 2021-02-17 05:23:10 | Moody, South Dakota, US |
3052029 | 3052029 | 2021-02-16 | US | Mississippi | Wilkinson | 28157 | 618 | 26 | 0 | 592 | 31.16078225 | -91.31018819 | 2021-02-17 05:23:10 | Wilkinson, Mississippi, US |
3050703 | 3050703 | 2021-02-16 | US | Arkansas | Woodruff | 5147 | 600 | 8 | 0 | 592 | 35.18902527 | -91.2439489 | 2021-02-17 05:23:10 | Woodruff, Arkansas, US |
1341161 | 1341161 | 2021-02-15 | US | South Dakota | Moody | 46101 | 608 | 16 | 0 | 592 | 44.02266214 | -96.67081159 | 2021-02-16 05:24:38 | Moody, South Dakota, US |
1338802 | 1338802 | 2021-02-15 | US | Arkansas | Woodruff | 5147 | 600 | 8 | 0 | 592 | 35.18902527 | -91.2439489 | 2021-02-16 05:24:38 | Woodruff, Arkansas, US |
2286312 | 2286312 | 2021-02-14 | US | South Dakota | Moody | 46101 | 608 | 16 | 0 | 592 | 44.02266214 | -96.67081159 | 2021-02-15 05:24:49 | Moody, South Dakota, US |
2283953 | 2283953 | 2021-02-14 | US | Arkansas | Woodruff | 5147 | 600 | 8 | 0 | 592 | 35.18902527 | -91.2439489 | 2021-02-15 05:24:49 | Woodruff, Arkansas, US |
2679274 | 2679274 | 2021-02-13 | US | Kentucky | Owen | 21187 | 599 | 7 | 0 | 592 | 38.51679143 | -84.82404619 | 2021-02-14 05:23:43 | Owen, Kentucky, US |
2678353 | 2678353 | 2021-02-13 | US | Arkansas | Woodruff | 5147 | 600 | 8 | 0 | 592 | 35.18902527 | -91.2439489 | 2021-02-14 05:23:43 | Woodruff, Arkansas, US |
3543000 | 3543000 | 2021-02-12 | US | Wisconsin | Iron | 55051 | 630 | 38 | 0 | 592 | 46.26302338 | -90.24295041 | 2021-02-13 05:22:12 | Iron, Wisconsin, US |
3540907 | 3540907 | 2021-02-12 | US | Kentucky | Owen | 21187 | 599 | 7 | 0 | 592 | 38.51679143 | -84.82404619 | 2021-02-13 05:22:12 | Owen, Kentucky, US |
3539986 | 3539986 | 2021-02-12 | US | Arkansas | Woodruff | 5147 | 600 | 8 | 0 | 592 | 35.18902527 | -91.2439489 | 2021-02-13 05:22:12 | Woodruff, Arkansas, US |
2640477 | 2640477 | 2021-02-11 | US | Puerto Rico | Naguabo | 72103 | 592 | 0 | 0 | 592 | 18.230637 | -65.753897 | 2021-02-12 05:23:29 | Naguabo, Puerto Rico, US |
2637506 | 2637506 | 2021-02-11 | Chile | Arica y Parinacota | 13831 | 272 | 12967 | 592 | -18.594 | -69.4785 | 2021-02-12 05:23:29 | Arica y Parinacota, Chile | ||
3981332 | 3981332 | 2021-02-10 | US | Puerto Rico | Naguabo | 72103 | 592 | 0 | 0 | 592 | 18.230637 | -65.753897 | 2021-02-11 05:23:55 | Naguabo, Puerto Rico, US |
3980125 | 3980125 | 2021-02-10 | US | Maine | Knox | 23013 | 597 | 5 | 0 | 592 | 44.11486325 | -69.10529169 | 2021-02-11 05:23:55 | Knox, Maine, US |
1531404 | 1531404 | 2021-02-09 | US | West Virginia | Tyler | 54095 | 596 | 4 | 0 | 592 | 39.46811972 | -80.88772676 | 2021-02-10 05:22:41 | Tyler, West Virginia, US |
1529445 | 1529445 | 2021-02-09 | US | Maine | Knox | 23013 | 597 | 5 | 0 | 592 | 44.11486325 | -69.10529169 | 2021-02-10 05:22:41 | Knox, Maine, US |
792981 | 792981 | 2021-02-04 | US | Oregon | Baker | 41001 | 599 | 7 | 0 | 592 | 44.70915557 | -117.6749883 | 2021-02-05 05:22:38 | Baker, Oregon, US |
342481 | 342481 | 2021-02-03 | US | New Mexico | Torrance | 35057 | 603 | 11 | 0 | 592 | 34.64048375 | -105.8508949 | 2021-02-04 05:22:26 | Torrance, New Mexico, US |
1687771 | 1687771 | 2021-02-02 | US | Vermont | Addison | 50001 | 600 | 8 | 0 | 592 | 44.03217337 | -73.14130877 | 2021-02-03 05:22:52 | Addison, Vermont, US |
1678766 | 1678766 | 2021-02-01 | US | North Carolina | Clay | 37043 | 597 | 5 | 0 | 592 | 35.05704275 | -83.74353633 | 2021-02-02 05:22:49 | Clay, North Carolina, US |
2214541 | 2214541 | 2021-01-30 | US | South Dakota | Kingsbury | 46077 | 605 | 13 | 0 | 592 | 44.36956169 | -97.4913945 | 2021-01-31 05:22:42 | Kingsbury, South Dakota, US |
1900028 | 1900028 | 2021-01-29 | US | South Dakota | Kingsbury | 46077 | 605 | 13 | 0 | 592 | 44.36956169 | -97.4913945 | 2021-01-30 05:22:49 | Kingsbury, South Dakota, US |
2485267 | 2485267 | 2021-01-28 | US | Virginia | Bland | 51021 | 600 | 8 | 0 | 592 | 37.13128068 | -81.13599391 | 2021-01-29 05:22:23 | Bland, Virginia, US |
2483642 | 2483642 | 2021-01-28 | US | Michigan | Presque Isle | 26141 | 614 | 22 | 0 | 592 | 45.34018577 | -83.91498656 | 2021-01-29 05:22:23 | Presque Isle, Michigan, US |
15779 | 15779 | 2021-01-26 | US | Washington | Klickitat | 53039 | 596 | 4 | 0 | 592 | 45.87325839 | -120.7913598 | 2021-01-27 05:23:41 | Klickitat, Washington, US |
15708 | 15708 | 2021-01-26 | US | Virginia | Nelson | 51125 | 598 | 6 | 0 | 592 | 37.78790447 | -78.88498513 | 2021-01-27 05:23:41 | Nelson, Virginia, US |
12969 | 12969 | 2021-01-26 | US | Colorado | Moffat | 8081 | 676 | 22 | 0 | 592 | 40.61810999 | -108.2070876 | 2021-01-27 05:23:41 | Moffat, Colorado, US |
1761349 | 1761349 | 2021-01-24 | US | Nebraska | Dawes | 31045 | 610 | 18 | 0 | 592 | 42.71985036 | -103.1313774 | 2021-01-25 05:22:16 | Dawes, Nebraska, US |
1760216 | 1760216 | 2021-01-24 | US | Idaho | Caribou | 16029 | 603 | 11 | 0 | 592 | 42.77149116 | -111.5597683 | 2021-01-25 05:22:16 | Caribou, Idaho, US |
2428956 | 2428956 | 2021-01-23 | US | Nebraska | Dawes | 31045 | 610 | 18 | 0 | 592 | 42.71985036 | -103.1313774 | 2021-01-24 05:22:35 | Dawes, Nebraska, US |
2427823 | 2427823 | 2021-01-23 | US | Idaho | Caribou | 16029 | 603 | 11 | 0 | 592 | 42.77149116 | -111.5597683 | 2021-01-24 05:22:35 | Caribou, Idaho, US |
2469529 | 2469529 | 2021-01-22 | US | Puerto Rico | Coamo | 72043 | 592 | 0 | 0 | 592 | 18.097597 | -66.36014 | 2021-01-23 05:22:03 | Coamo, Puerto Rico, US |
2468526 | 2468526 | 2021-01-22 | US | Minnesota | Koochiching | 27071 | 602 | 10 | 0 | 592 | 48.24539665 | -93.78352843 | 2021-01-23 05:22:03 | Koochiching, Minnesota, US |
1096135 | 1096135 | 2021-01-20 | US | Nebraska | Clay | 31035 | 603 | 11 | 0 | 592 | 40.52439441 | -98.05126296 | 2021-01-21 05:22:01 | Clay, Nebraska, US |
1094921 | 1094921 | 2021-01-20 | US | Georgia | McIntosh | 13191 | 602 | 10 | 0 | 592 | 31.49683595 | -81.40163426 | 2021-01-21 05:22:01 | McIntosh, Georgia, US |
1094590 | 1094590 | 2021-01-20 | US | Arkansas | Newton | 5101 | 618 | 26 | 0 | 592 | 35.91947491 | -93.21612969 | 2021-01-21 05:22:01 | Newton, Arkansas, US |
909007 | 909007 | 2021-01-19 | US | Georgia | Macon | 13193 | 608 | 16 | 0 | 592 | 32.35207048 | -84.04234127 | 2021-01-20 05:21:54 | Macon, Georgia, US |
239261 | 239261 | 2021-01-18 | US | Montana | Stillwater | 30095 | 602 | 10 | 0 | 592 | 45.67071407 | -109.3950061 | 2021-01-19 05:22:15 | Stillwater, Montana, US |
239023 | 239023 | 2021-01-18 | US | Mississippi | Choctaw | 28019 | 605 | 13 | 0 | 592 | 33.34598242 | -89.24809382 | 2021-01-19 05:22:15 | Choctaw, Mississippi, US |
3518906 | 3518906 | 2021-01-15 | US | West Virginia | Summers | 54089 | 610 | 18 | 0 | 592 | 37.65390597 | -80.86009693 | 2021-01-16 05:22:40 | Summers, West Virginia, US |
3882764 | 3882764 | 2021-01-14 | US | Texas | Rains | 48379 | 350 | 19 | 0 | 592 | 32.87109387 | -95.79232691 | 2021-01-15 05:22:24 | Rains, Texas, US |
3881942 | 3881942 | 2021-01-14 | US | North Carolina | Washington | 37187 | 611 | 19 | 0 | 592 | 35.83810081 | -76.57299037 | 2021-01-15 05:22:24 | Washington, North Carolina, US |
3880603 | 3880603 | 2021-01-14 | US | Illinois | Pulaski | 17153 | 595 | 3 | 0 | 592 | 37.22631423 | -89.13085001 | 2021-01-15 05:22:24 | Pulaski, Illinois, US |
3311391 | 3311391 | 2021-01-13 | US | Texas | Rains | 48379 | 350 | 19 | 0 | 592 | 32.87109387 | -95.79232691 | 2021-01-14 05:22:32 | Rains, Texas, US |
777595 | 777595 | 2021-01-12 | US | Texas | Winkler | 48495 | 599 | 15 | 0 | 592 | 31.85008651 | -103.0485163 | 2021-01-13 05:22:15 | Winkler, Texas, US |
155913 | 155913 | 2021-01-08 | US | Missouri | Oregon | 29149 | 595 | 3 | 0 | 592 | 36.68710164 | -91.4033755 | 2021-01-09 05:22:18 | Oregon, Missouri, US |
2542951 | 2542951 | 2021-01-07 | US | Maine | Hancock | 23009 | 608 | 16 | 0 | 592 | 44.59816444 | -68.38401854 | 2021-01-08 05:22:42 | Hancock, Maine, US |
3037325 | 3037325 | 2021-01-05 | US | Texas | Brooks | 48047 | 648 | 27 | 0 | 592 | 27.03103197 | -98.21808402 | 2021-01-06 05:22:16 | Brooks, Texas, US |
3035311 | 3035311 | 2021-01-05 | US | Illinois | Marshall | 17123 | 602 | 10 | 0 | 592 | 41.0327901 | -89.34510444 | 2021-01-06 05:22:16 | Marshall, Illinois, US |
3034804 | 3034804 | 2021-01-05 | US | Arkansas | Nevada | 5099 | 612 | 20 | 0 | 592 | 33.66340119 | -93.30632432 | 2021-01-06 05:22:16 | Nevada, Arkansas, US |
3231699 | 3231699 | 2021-01-03 | US | Kansas | Anderson | 20003 | 594 | 2 | 0 | 592 | 38.21413251 | -95.29272815 | 2021-01-04 05:22:02 | Anderson, Kansas, US |
2231124 | 2231124 | 2021-01-02 | US | Wyoming | Sublette | 56035 | 598 | 6 | 0 | 592 | 42.76558279 | -109.9130922 | 2021-01-03 05:22:52 | Sublette, Wyoming, US |
2229310 | 2229310 | 2021-01-02 | US | Mississippi | Franklin | 28037 | 601 | 9 | 0 | 592 | 31.47786634 | -90.89672989 | 2021-01-03 05:22:52 | Franklin, Mississippi, US |
2229240 | 2229240 | 2021-01-02 | US | Minnesota | Lac qui Parle | 27073 | 607 | 15 | 0 | 592 | 44.9973857 | -96.17488219 | 2021-01-03 05:22:52 | Lac qui Parle, Minnesota, US |
2228768 | 2228768 | 2021-01-02 | US | Kansas | Anderson | 20003 | 594 | 2 | 0 | 592 | 38.21413251 | -95.29272815 | 2021-01-03 05:22:52 | Anderson, Kansas, US |
1140564 | 1140564 | 2021-01-01 | Malaysia | Pulau Pinang | 3712 | 9 | 3111 | 592 | 5.4141 | 100.3288 | 2021-01-02 05:22:33 | Pulau Pinang, Malaysia | ||
1139107 | 1139107 | 2021-01-01 | US | New York | Essex | 36031 | 608 | 16 | 0 | 592 | 44.11630765 | -73.77297842 | 2021-01-02 05:22:33 | Essex, New York, US |
1138132 | 1138132 | 2021-01-01 | US | Kansas | Anderson | 20003 | 594 | 2 | 0 | 592 | 38.21413251 | -95.29272815 | 2021-01-02 05:22:33 | Anderson, Kansas, US |
3698843 | 3698843 | 2020-12-31 | US | Virginia | Lexington | 51678 | 596 | 4 | 0 | 592 | 37.78258621 | -79.44262866 | 2021-01-01 05:23:07 | Lexington, Virginia, US |
3695281 | 3695281 | 2020-12-31 | Chile | Los Rios | 8852 | 89 | 8171 | 592 | -40.231 | -72.3311 | 2021-01-01 05:23:07 | Los Rios, Chile | ||
3764882 | 3764882 | 2020-12-28 | US | Virginia | Brunswick | 51025 | 599 | 7 | 0 | 592 | 36.76366949 | -77.8593436 | 2020-12-29 05:22:37 | Brunswick, Virginia, US |
3764165 | 3764165 | 2020-12-28 | US | Oklahoma | Pushmataha | 40127 | 598 | 6 | 0 | 592 | 34.41635232 | -95.37603505 | 2020-12-29 05:22:37 | Pushmataha, Oklahoma, US |
3763032 | 3763032 | 2020-12-28 | US | Kentucky | Pendleton | 21191 | 593 | 1 | 0 | 592 | 38.69607718 | -84.35599463 | 2020-12-29 05:22:37 | Pendleton, Kentucky, US |
3779254 | 3779254 | 2020-12-27 | US | Kansas | Wilson | 20205 | 597 | 5 | 0 | 592 | 37.55937174 | -95.74323255 | 2020-12-28 05:22:06 | Wilson, Kansas, US |
2225807 | 2225807 | 2020-12-26 | US | North Carolina | Currituck | 37053 | 603 | 11 | 0 | 592 | 36.36123664 | -75.95876401 | 2020-12-27 05:22:55 | Currituck, North Carolina, US |
2224859 | 2224859 | 2020-12-26 | US | Kansas | Wilson | 20205 | 597 | 5 | 0 | 592 | 37.55937174 | -95.74323255 | 2020-12-27 05:22:55 | Wilson, Kansas, US |
2224276 | 2224276 | 2020-12-26 | US | Georgia | Clinch | 13065 | 606 | 14 | 0 | 592 | 30.91395822 | -82.70432472 | 2020-12-27 05:22:55 | Clinch, Georgia, US |
205747 | 205747 | 2020-12-25 | US | West Virginia | Nicholas | 54067 | 599 | 7 | 0 | 592 | 38.29617706 | -80.79759588 | 2020-12-26 05:22:28 | Nicholas, West Virginia, US |
203606 | 203606 | 2020-12-25 | US | Kansas | Wilson | 20205 | 597 | 5 | 0 | 592 | 37.55937174 | -95.74323255 | 2020-12-26 05:22:28 | Wilson, Kansas, US |
203023 | 203023 | 2020-12-25 | US | Georgia | Clinch | 13065 | 606 | 14 | 0 | 592 | 30.91395822 | -82.70432472 | 2020-12-26 05:22:28 | Clinch, Georgia, US |
3692829 | 3692829 | 2020-12-24 | US | Kansas | Wilson | 20205 | 597 | 5 | 0 | 592 | 37.55937174 | -95.74323255 | 2020-12-25 05:22:48 | Wilson, Kansas, US |
2409730 | 2409730 | 2020-12-23 | US | South Dakota | Walworth | 46129 | 606 | 14 | 0 | 592 | 45.43019636 | -100.0307514 | 2020-12-24 05:23:04 | Walworth, South Dakota, US |
2408181 | 2408181 | 2020-12-23 | US | Kansas | Wilson | 20205 | 597 | 5 | 0 | 592 | 37.55937174 | -95.74323255 | 2020-12-24 05:23:04 | Wilson, Kansas, US |
3773164 | 3773164 | 2020-12-22 | US | Virginia | Alleghany | 51005 | 612 | 20 | 0 | 592 | 37.78636074 | -80.00222498 | 2020-12-23 05:22:03 | Alleghany, Virginia, 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]);