johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
855 rows where active = 218 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
- US 756
- Japan 17
- Mexico 11
- India 6
- Italy 5
- Chile 4
- Colombia 4
- Kosovo 4
- Russia 4
- Togo 4
- Ukraine 4
- Canada 3
- China 3
- Pakistan 3
- West Bank and Gaza 3
- Bhutan 2
- Burkina Faso 2
- Germany 2
- Jordan 2
- Malaysia 2
- Albania 1
- Cote d'Ivoire 1
- Cyprus 1
- France 1
- Liechtenstein 1
- Lithuania 1
- Netherlands 1
- San Marino 1
- Serbia 1
- Spain 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3683295 | 3683295 | 2021-08-02 | Colombia | Choco | 16011 | 384 | 15409 | 218 | 5.2528 | -76.82600000000002 | 2021-08-03 04:21:39 | Choco, Colombia | ||
3903766 | 3903766 | 2021-07-31 | Chile | Nuble | 35312 | 618 | 34476 | 218 | -36.7226 | -71.7622 | 2021-08-01 04:21:50 | Nuble, Chile | ||
3137780 | 3137780 | 2021-07-23 | Russia | Nenets Autonomous Okrug | 1480 | 10 | 1252 | 218 | 68.27557185 | 57.1686375 | 2021-07-24 00:21:36 | Nenets Autonomous Okrug, Russia | ||
483434 | 483434 | 2021-07-19 | Colombia | Choco | 15475 | 378 | 14879 | 218 | 5.2528 | -76.82600000000002 | 2021-07-20 04:21:48 | Choco, Colombia | ||
3741102 | 3741102 | 2021-07-12 | Japan | Kyoto | 16831 | 247 | 16366 | 218 | 35.253815 | 135.443341 | 2021-07-13 04:21:18 | Kyoto, Japan | ||
829636 | 829636 | 2021-07-09 | Japan | Tochigi | 7209 | 82 | 6909 | 218 | 36.689912 | 139.819213 | 2021-07-10 04:21:25 | Tochigi, Japan | ||
1896783 | 1896783 | 2021-06-30 | Ukraine | Vinnytsia Oblast | 71086 | 1690 | 69178 | 218 | 49.2331 | 28.4682 | 2021-07-01 04:21:19 | Vinnytsia Oblast, Ukraine | ||
3030625 | 3030625 | 2021-06-16 | Togo | 13669 | 127 | 13324 | 218 | 8.6195 | 0.8248 | 2021-06-17 04:22:36 | Togo | |||
3030093 | 3030093 | 2021-06-16 | China | Guangdong | 2657 | 8 | 2431 | 218 | 23.3417 | 113.4244 | 2021-06-17 04:22:36 | Guangdong, China | ||
1448610 | 1448610 | 2021-06-03 | Japan | Miyagi | 8919 | 83 | 8618 | 218 | 38.446859 | 140.927086 | 2021-06-04 04:23:37 | Miyagi, Japan | ||
726543 | 726543 | 2021-05-22 | Japan | Wakayama | 2560 | 37 | 2305 | 218 | 33.911879 | 135.505446 | 2021-05-23 04:20:51 | Wakayama, Japan | ||
1913258 | 1913258 | 2021-05-20 | Japan | Yamagata | 1798 | 37 | 1543 | 218 | 38.448396 | 140.102154 | 2021-05-21 04:20:43 | Yamagata, Japan | ||
2255748 | 2255748 | 2021-05-19 | Japan | Iwate | 1275 | 42 | 1015 | 218 | 39.593287 | 141.361777 | 2021-05-20 04:21:05 | Iwate, Japan | ||
2939531 | 2939531 | 2021-05-16 | Russia | Karachay-Cherkess Republic | 20259 | 97 | 19944 | 218 | 43.7368326 | 41.7267991 | 2021-05-17 04:20:34 | Karachay-Cherkess Republic, Russia | ||
2549073 | 2549073 | 2021-04-15 | Russia | Ivanovo Oblast | 33501 | 1102 | 32181 | 218 | 56.9167446 | 41.43521370000001 | 2021-04-16 04:20:46 | Ivanovo Oblast, Russia | ||
3003314 | 3003314 | 2021-04-06 | Japan | Gunma | 5131 | 99 | 4814 | 218 | 36.504479 | 138.985605 | 2021-04-07 04:20:53 | Gunma, Japan | ||
3710348 | 3710348 | 2021-04-03 | Russia | Khakassia Republic | 21897 | 508 | 21171 | 218 | 53.72258845 | 91.44293627 | 2021-04-04 04:20:49 | Khakassia Republic, Russia | ||
1535953 | 1535953 | 2021-03-28 | Japan | Nagano | 2711 | 41 | 2452 | 218 | 36.132134 | 138.045528 | 2021-03-29 04:28:35 | Nagano, Japan | ||
1736162 | 1736162 | 2021-03-14 | US | Alaska | Copper River | 2066 | 218 | 0 | 0 | 218 | 60.3886 | -162.8905196 | 2021-04-02 15:13:53 | Copper River, Alaska, US |
1583819 | 1583819 | 2021-03-13 | US | Alaska | Copper River | 2066 | 218 | 0 | 0 | 218 | 60.3886 | -162.8905196 | 2021-04-02 15:13:53 | Copper River, Alaska, US |
1841598 | 1841598 | 2021-03-12 | US | Alaska | Copper River | 2066 | 218 | 0 | 0 | 218 | 60.3886 | -162.8905196 | 2021-04-02 15:13:53 | Copper River, Alaska, US |
3669719 | 3669719 | 2021-03-06 | US | Nebraska | Pawnee | 31133 | 219 | 1 | 0 | 218 | 40.13141096 | -96.23705437 | 2021-03-07 05:21:54 | Pawnee, Nebraska, US |
1091799 | 1091799 | 2021-03-03 | US | Minnesota | Lake of the Woods | 27077 | 219 | 1 | 0 | 218 | 48.77217001 | -94.90274472 | 2021-03-04 05:24:24 | Lake of the Woods, Minnesota, US |
3255871 | 3255871 | 2021-03-02 | US | Minnesota | Lake of the Woods | 27077 | 219 | 1 | 0 | 218 | 48.77217001 | -94.90274472 | 2021-03-03 05:23:28 | Lake of the Woods, Minnesota, US |
1000163 | 1000163 | 2021-03-01 | US | Minnesota | Lake of the Woods | 27077 | 219 | 1 | 0 | 218 | 48.77217001 | -94.90274472 | 2021-03-02 05:23:30 | Lake of the Woods, Minnesota, US |
2371175 | 2371175 | 2021-02-28 | Malaysia | Pahang | 3791 | 14 | 3559 | 218 | 3.8126 | 103.3256 | 2021-03-01 05:23:01 | Pahang, Malaysia | ||
2369221 | 2369221 | 2021-02-28 | US | Minnesota | Lake of the Woods | 27077 | 219 | 1 | 0 | 218 | 48.77217001 | -94.90274472 | 2021-03-01 05:23:01 | Lake of the Woods, Minnesota, US |
1936399 | 1936399 | 2021-02-23 | India | Himachal Pradesh | 58423 | 995 | 57210 | 218 | 31.927213 | 77.233081 | 2021-02-24 05:29:16 | Himachal Pradesh, India | ||
1936301 | 1936301 | 2021-02-23 | Colombia | La Guajira | 16085 | 632 | 15235 | 218 | 11.3548 | -72.5205 | 2021-02-24 05:29:16 | La Guajira, Colombia | ||
533465 | 533465 | 2021-02-22 | US | Puerto Rico | Patillas | 72109 | 218 | 0 | 0 | 218 | 18.03174 | -66.012242 | 2021-02-23 05:23:41 | Patillas, Puerto Rico, US |
184799 | 184799 | 2021-02-21 | US | Puerto Rico | Patillas | 72109 | 218 | 0 | 0 | 218 | 18.03174 | -66.012242 | 2021-02-22 05:24:21 | Patillas, Puerto Rico, US |
745073 | 745073 | 2021-02-20 | US | Puerto Rico | Patillas | 72109 | 218 | 0 | 0 | 218 | 18.03174 | -66.012242 | 2021-02-21 05:24:33 | Patillas, Puerto Rico, US |
474878 | 474878 | 2021-02-19 | US | West Virginia | Calhoun | 54013 | 218 | 0 | 0 | 218 | 38.84315422 | -81.11934872 | 2021-02-20 05:22:51 | Calhoun, West Virginia, US |
474619 | 474619 | 2021-02-19 | US | Texas | Schleicher | 48413 | 171 | 6 | 0 | 218 | 30.89740592 | -100.5384842 | 2021-02-20 05:22:51 | Schleicher, Texas, US |
1156587 | 1156587 | 2021-02-18 | US | West Virginia | Calhoun | 54013 | 218 | 0 | 0 | 218 | 38.84315422 | -81.11934872 | 2021-02-19 05:24:16 | Calhoun, West Virginia, US |
1156328 | 1156328 | 2021-02-18 | US | Texas | Schleicher | 48413 | 171 | 6 | 0 | 218 | 30.89740592 | -100.5384842 | 2021-02-19 05:24:16 | Schleicher, Texas, US |
3604507 | 3604507 | 2021-02-17 | US | West Virginia | Calhoun | 54013 | 218 | 0 | 0 | 218 | 38.84315422 | -81.11934872 | 2021-02-18 05:22:58 | Calhoun, West Virginia, US |
3053642 | 3053642 | 2021-02-16 | US | West Virginia | Calhoun | 54013 | 218 | 0 | 0 | 218 | 38.84315422 | -81.11934872 | 2021-02-17 05:23:10 | Calhoun, West Virginia, US |
1341741 | 1341741 | 2021-02-15 | US | West Virginia | Calhoun | 54013 | 218 | 0 | 0 | 218 | 38.84315422 | -81.11934872 | 2021-02-16 05:24:38 | Calhoun, West Virginia, US |
2286892 | 2286892 | 2021-02-14 | US | West Virginia | Calhoun | 54013 | 218 | 0 | 0 | 218 | 38.84315422 | -81.11934872 | 2021-02-15 05:24:49 | Calhoun, West Virginia, US |
2681292 | 2681292 | 2021-02-13 | US | West Virginia | Calhoun | 54013 | 218 | 0 | 0 | 218 | 38.84315422 | -81.11934872 | 2021-02-14 05:23:43 | Calhoun, West Virginia, US |
2680207 | 2680207 | 2021-02-13 | US | North Dakota | Burke | 38013 | 220 | 1 | 0 | 218 | 48.79094471 | -102.5182117 | 2021-02-14 05:23:43 | Burke, North Dakota, US |
3542666 | 3542666 | 2021-02-12 | US | Texas | Schleicher | 48413 | 171 | 6 | 0 | 218 | 30.89740592 | -100.5384842 | 2021-02-13 05:22:12 | Schleicher, Texas, US |
3541840 | 3541840 | 2021-02-12 | US | North Dakota | Burke | 38013 | 219 | 1 | 0 | 218 | 48.79094471 | -102.5182117 | 2021-02-13 05:22:12 | Burke, North Dakota, US |
2640929 | 2640929 | 2021-02-11 | US | Texas | Schleicher | 48413 | 171 | 6 | 0 | 218 | 30.89740592 | -100.5384842 | 2021-02-12 05:23:29 | Schleicher, Texas, US |
2640103 | 2640103 | 2021-02-11 | US | North Dakota | Burke | 38013 | 219 | 1 | 0 | 218 | 48.79094471 | -102.5182117 | 2021-02-12 05:23:29 | Burke, North Dakota, US |
3981186 | 3981186 | 2021-02-10 | US | Oregon | Grant | 41023 | 219 | 1 | 0 | 218 | 44.49024544 | -119.0068631 | 2021-02-11 05:23:55 | Grant, Oregon, US |
3980958 | 3980958 | 2021-02-10 | US | North Dakota | Burke | 38013 | 219 | 1 | 0 | 218 | 48.79094471 | -102.5182117 | 2021-02-11 05:23:55 | Burke, North Dakota, US |
1531077 | 1531077 | 2021-02-09 | US | Texas | Oldham | 48359 | 278 | 3 | 0 | 218 | 35.40425596 | -102.6027606 | 2021-02-10 05:22:41 | Oldham, Texas, US |
1530278 | 1530278 | 2021-02-09 | US | North Dakota | Burke | 38013 | 219 | 1 | 0 | 218 | 48.79094471 | -102.5182117 | 2021-02-10 05:22:41 | Burke, North Dakota, US |
616069 | 616069 | 2021-02-08 | US | North Dakota | Burke | 38013 | 218 | 1 | 0 | 218 | 48.79094471 | -102.5182117 | 2021-02-09 05:23:30 | Burke, North Dakota, US |
613698 | 613698 | 2021-02-08 | Japan | Hiroshima | 4901 | 96 | 4587 | 218 | 34.605309000000005 | 132.788719 | 2021-02-09 05:23:30 | Hiroshima, Japan | ||
613505 | 613505 | 2021-02-08 | China | Jilin | 573 | 3 | 352 | 218 | 43.6661 | 126.1923 | 2021-02-09 05:23:30 | Jilin, China | ||
1674838 | 1674838 | 2021-02-07 | US | North Dakota | Burke | 38013 | 218 | 1 | 0 | 218 | 48.79094471 | -102.5182117 | 2021-02-08 05:22:39 | Burke, North Dakota, US |
977299 | 977299 | 2021-02-06 | US | North Dakota | Burke | 38013 | 218 | 1 | 0 | 218 | 48.79094471 | -102.5182117 | 2021-02-07 05:23:00 | Burke, North Dakota, US |
975552 | 975552 | 2021-02-06 | US | Colorado | Ouray | 8091 | 235 | 3 | 0 | 218 | 38.14717457 | -107.7675136 | 2021-02-07 05:23:00 | Ouray, Colorado, US |
1590250 | 1590250 | 2021-02-05 | US | Nebraska | Hitchcock | 31087 | 221 | 3 | 0 | 218 | 40.17609175 | -101.0416477 | 2021-02-06 05:23:55 | Hitchcock, Nebraska, US |
793590 | 793590 | 2021-02-04 | US | Texas | Schleicher | 48413 | 171 | 6 | 0 | 218 | 30.89740592 | -100.5384842 | 2021-02-05 05:22:38 | Schleicher, Texas, US |
1677269 | 1677269 | 2021-02-01 | US | Georgia | Glascock | 13125 | 228 | 10 | 0 | 218 | 33.22879932 | -82.61297636 | 2021-02-02 05:22:49 | Glascock, Georgia, US |
1460557 | 1460557 | 2021-01-31 | US | Georgia | Glascock | 13125 | 228 | 10 | 0 | 218 | 33.22879932 | -82.61297636 | 2021-02-01 05:22:53 | Glascock, Georgia, US |
2212465 | 2212465 | 2021-01-30 | US | Georgia | Glascock | 13125 | 228 | 10 | 0 | 218 | 33.22879932 | -82.61297636 | 2021-01-31 05:22:42 | Glascock, Georgia, US |
2485108 | 2485108 | 2021-01-28 | US | Texas | Knox | 48275 | 226 | 12 | 0 | 218 | 33.60519951 | -99.7422906 | 2021-01-29 05:22:23 | Knox, Texas, US |
2483266 | 2483266 | 2021-01-28 | US | Kansas | Kiowa | 20097 | 222 | 4 | 0 | 218 | 37.55848695 | -99.2856537 | 2021-01-29 05:22:23 | Kiowa, Kansas, US |
3156370 | 3156370 | 2021-01-27 | US | Puerto Rico | Sabana Grande | 72121 | 218 | 0 | 0 | 218 | 18.08282 | -66.943758 | 2021-01-28 05:22:24 | Sabana Grande, Puerto Rico, US |
3154901 | 3154901 | 2021-01-27 | US | Kansas | Kiowa | 20097 | 222 | 4 | 0 | 218 | 37.55848695 | -99.2856537 | 2021-01-28 05:22:24 | Kiowa, Kansas, US |
15549 | 15549 | 2021-01-26 | US | Texas | Shackelford | 48417 | 210 | 1 | 0 | 218 | 32.73587756 | -99.35401337 | 2021-01-27 05:23:41 | Shackelford, Texas, US |
12357 | 12357 | 2021-01-26 | Japan | Kagoshima | 1556 | 18 | 1320 | 218 | 31.009484000000004 | 130.430665 | 2021-01-27 05:23:41 | Kagoshima, Japan | ||
1761357 | 1761357 | 2021-01-24 | US | Nebraska | Franklin | 31061 | 221 | 3 | 0 | 218 | 40.17636348 | -98.95299073 | 2021-01-25 05:22:16 | Franklin, Nebraska, US |
2429549 | 2429549 | 2021-01-23 | US | Pennsylvania | Cameron | 42023 | 225 | 7 | 0 | 218 | 41.43625568 | -78.20376845 | 2021-01-24 05:22:35 | Cameron, Pennsylvania, US |
2469866 | 2469866 | 2021-01-22 | US | Texas | Delta | 48119 | 859 | 6 | 0 | 218 | 33.38570922 | -95.66921122 | 2021-01-23 05:22:03 | Delta, Texas, US |
2469563 | 2469563 | 2021-01-22 | US | Puerto Rico | Out of PR | 72888 | 218 | 0 | 0 | 218 | 18.459681 | -67.336525 | 2021-01-23 05:22:03 | Out of PR, Puerto Rico, US |
2469451 | 2469451 | 2021-01-22 | US | Pennsylvania | Cameron | 42023 | 224 | 6 | 0 | 218 | 41.43625568 | -78.20376845 | 2021-01-23 05:22:03 | Cameron, Pennsylvania, US |
438114 | 438114 | 2021-01-21 | US | Puerto Rico | Out of PR | 72888 | 218 | 0 | 0 | 218 | 18.459681 | -67.336525 | 2021-01-22 05:22:10 | Out of PR, Puerto Rico, US |
437417 | 437417 | 2021-01-21 | US | Nebraska | Franklin | 31061 | 221 | 3 | 0 | 218 | 40.17636348 | -98.95299073 | 2021-01-22 05:22:10 | Franklin, Nebraska, US |
435081 | 435081 | 2021-01-21 | Bhutan | 850 | 1 | 631 | 218 | 27.5142 | 90.4336 | 2021-01-22 05:22:10 | Bhutan | |||
1096845 | 1096845 | 2021-01-20 | US | Puerto Rico | Out of PR | 72888 | 218 | 0 | 0 | 218 | 18.459681 | -67.336525 | 2021-01-21 05:22:01 | Out of PR, Puerto Rico, US |
1093874 | 1093874 | 2021-01-20 | Chile | Aysen | 2156 | 18 | 1920 | 218 | -45.9864 | -73.7669 | 2021-01-21 05:22:01 | Aysen, Chile | ||
1093813 | 1093813 | 2021-01-20 | Bhutan | 850 | 1 | 631 | 218 | 27.5142 | 90.4336 | 2021-01-21 05:22:01 | Bhutan | |||
911058 | 911058 | 2021-01-19 | US | South Dakota | McPherson | 46089 | 222 | 4 | 0 | 218 | 45.76626028 | -99.22118798 | 2021-01-20 05:21:54 | McPherson, South Dakota, US |
910935 | 910935 | 2021-01-19 | US | Puerto Rico | Out of PR | 72888 | 218 | 0 | 0 | 218 | 18.459681 | -67.336525 | 2021-01-20 05:21:54 | Out of PR, Puerto Rico, US |
909433 | 909433 | 2021-01-19 | US | Kansas | Chase | 20017 | 221 | 3 | 0 | 218 | 38.30292938 | -96.59563862 | 2021-01-20 05:21:54 | Chase, Kansas, US |
239961 | 239961 | 2021-01-18 | US | Puerto Rico | Ceiba | 72037 | 218 | 0 | 0 | 218 | 18.251818 | -65.666416 | 2021-01-19 05:22:15 | Ceiba, Puerto Rico, US |
238496 | 238496 | 2021-01-18 | US | Kansas | Chase | 20017 | 221 | 3 | 0 | 218 | 38.30292938 | -96.59563862 | 2021-01-19 05:22:15 | Chase, Kansas, US |
3104814 | 3104814 | 2021-01-16 | US | Virginia | Norton | 51720 | 221 | 3 | 0 | 218 | 36.93357076 | -82.62750411 | 2021-01-17 05:22:17 | Norton, Virginia, US |
3881949 | 3881949 | 2021-01-14 | US | North Dakota | Adams | 38001 | 222 | 2 | 0 | 218 | 46.09686891 | -102.5285397 | 2021-01-15 05:22:24 | Adams, North Dakota, US |
775271 | 775271 | 2021-01-12 | US | Idaho | Custer | 16037 | 220 | 2 | 0 | 218 | 44.24186819 | -114.2855494 | 2021-01-13 05:22:15 | Custer, Idaho, US |
2625876 | 2625876 | 2021-01-10 | Japan | Ehime | 662 | 13 | 431 | 218 | 33.624835 | 132.856842 | 2021-01-11 05:21:50 | Ehime, Japan | ||
3903275 | 3903275 | 2021-01-09 | US | Virginia | Cumberland | 51049 | 222 | 4 | 0 | 218 | 37.51328851 | -78.24398086 | 2021-01-10 05:22:12 | Cumberland, Virginia, US |
157298 | 157298 | 2021-01-08 | US | Virginia | Cumberland | 51049 | 222 | 4 | 0 | 218 | 37.51328851 | -78.24398086 | 2021-01-09 05:22:18 | Cumberland, Virginia, US |
2541814 | 2541814 | 2021-01-07 | US | Alaska | Aleutians West | 2016 | 218 | 0 | 0 | 218 | 52.3233 | -174.1596 | 2021-01-08 05:22:42 | Aleutians West, Alaska, US |
1064729 | 1064729 | 2021-01-04 | US | South Dakota | Mellette | 46095 | 220 | 2 | 0 | 218 | 43.58078848 | -100.7563186 | 2021-01-05 05:21:49 | Mellette, South Dakota, US |
1062832 | 1062832 | 2021-01-04 | US | Illinois | Hardin | 17069 | 225 | 7 | 0 | 218 | 37.51810645 | -88.26873022 | 2021-01-05 05:21:49 | Hardin, Illinois, US |
3233332 | 3233332 | 2021-01-03 | US | South Dakota | Mellette | 46095 | 220 | 2 | 0 | 218 | 43.58078848 | -100.7563186 | 2021-01-04 05:22:02 | Mellette, South Dakota, US |
3233212 | 3233212 | 2021-01-03 | US | Puerto Rico | Rincon | 72117 | 218 | 0 | 0 | 218 | 18.335443 | -67.23174 | 2021-01-04 05:22:02 | Rincon, Puerto Rico, US |
3232212 | 3232212 | 2021-01-03 | US | Minnesota | Traverse | 27155 | 220 | 2 | 0 | 218 | 45.77298854 | -96.47062949 | 2021-01-04 05:22:02 | Traverse, Minnesota, US |
2230281 | 2230281 | 2021-01-02 | US | Puerto Rico | Rincon | 72117 | 218 | 0 | 0 | 218 | 18.335443 | -67.23174 | 2021-01-03 05:22:52 | Rincon, Puerto Rico, US |
1140550 | 1140550 | 2021-01-01 | US | Alaska | Chugach | 2063 | 221 | 3 | 0 | 218 | 61.16666 | -149.9 | 2021-04-02 15:13:53 | Chugach, Alaska, US |
1138289 | 1138289 | 2021-01-01 | US | Kentucky | Hickman | 21105 | 223 | 5 | 0 | 218 | 36.67948079999999 | -88.97875928 | 2021-01-02 05:22:33 | Hickman, Kentucky, US |
1137314 | 1137314 | 2021-01-01 | US | Alaska | Unassigned | 90002 | 218 | 0 | 0 | 218 | 69.31479216 | 0.0 | 2021-01-02 05:22:33 | Unassigned, Alaska, US |
3699156 | 3699156 | 2020-12-31 | US | Alaska | Chugach | 2063 | 221 | 3 | 0 | 218 | 61.16666 | -149.9 | 2021-04-02 15:13:53 | Chugach, Alaska, 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]);