johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
523 rows where active = 444 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 29
- US 459
- Russia 13
- Chile 7
- Colombia 6
- India 3
- Malaysia 3
- Australia 2
- Cote d'Ivoire 2
- Germany 2
- Italy 2
- Japan 2
- Mongolia 2
- Pakistan 2
- Papua New Guinea 2
- San Marino 2
- Andorra 1
- Eritrea 1
- Liberia 1
- Malta 1
- Rwanda 1
- Sao Tome and Principe 1
- Seychelles 1
- Somalia 1
- Spain 1
- Suriname 1
- Switzerland 1
- Uganda 1
- Ukraine 1
- Uruguay 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3197689 | 3197689 | 2021-09-06 | Malaysia | W.P. Putrajaya | 5575 | 22 | 5109 | 444 | 2.9264 | 101.6964 | 2021-09-07 04:21:35 | W.P. Putrajaya, Malaysia | ||
3015190 | 3015190 | 2021-08-01 | Colombia | Caqueta | 22125 | 878 | 20803 | 444 | 0.8699 | -73.8419 | 2021-08-02 04:21:36 | Caqueta, Colombia | ||
3296018 | 3296018 | 2021-07-30 | Colombia | Caqueta | 22066 | 875 | 20747 | 444 | 0.8699 | -73.8419 | 2021-07-31 04:21:35 | Caqueta, Colombia | ||
3385177 | 3385177 | 2021-07-29 | Chile | Los Lagos | 87371 | 1327 | 85600 | 444 | -41.9198 | -72.1416 | 2021-07-30 04:21:34 | Los Lagos, Chile | ||
3479935 | 3479935 | 2021-07-22 | Ukraine | Dnipropetrovsk Oblast | 136157 | 4483 | 131230 | 444 | 48.4647 | 35.0462 | 2021-07-23 04:21:29 | Dnipropetrovsk Oblast, Ukraine | ||
3706348 | 3706348 | 2021-07-17 | Russia | Magadan Oblast | 9094 | 132 | 8518 | 444 | 62.48858785 | 153.9903764 | 2021-07-18 04:22:07 | Magadan Oblast, Russia | ||
2764855 | 2764855 | 2021-07-01 | Germany | Thuringen | 128776 | 4335 | 124000 | 444 | 51.011 | 10.8453 | 2021-07-02 04:21:47 | Thuringen, Germany | ||
2764819 | 2764819 | 2021-07-01 | Eritrea | 6028 | 25 | 5559 | 444 | 15.1794 | 39.7823 | 2021-07-02 04:21:47 | Eritrea | |||
563118 | 563118 | 2021-06-22 | Papua New Guinea | 17013 | 173 | 16396 | 444 | -6.314993 | 143.95555 | 2021-06-23 04:21:46 | Papua New Guinea | |||
3358820 | 3358820 | 2021-06-21 | Papua New Guinea | 17013 | 173 | 16396 | 444 | -6.314993 | 143.95555 | 2021-06-22 04:21:34 | Papua New Guinea | |||
3381160 | 3381160 | 2021-06-13 | Chile | Aysen | 6888 | 47 | 6397 | 444 | -45.9864 | -73.7669 | 2021-06-14 04:22:46 | Aysen, Chile | ||
1736427 | 1736427 | 2021-06-12 | Germany | Saarland | 41229 | 1016 | 39800 | 444 | 49.3964 | 7.023 | 2021-06-13 04:22:44 | Saarland, Germany | ||
3970539 | 3970539 | 2021-06-11 | Italy | P.A. Bolzano | 73151 | 1180 | 71527 | 444 | 46.49933453 | 11.35662422 | 2021-06-12 04:22:22 | P.A. Bolzano, Italy | ||
1413247 | 1413247 | 2021-05-24 | Russia | Buryatia Republic | 37975 | 886 | 36645 | 444 | 52.7182426 | 109.492143 | 2021-05-25 04:21:08 | Buryatia Republic, Russia | ||
1413085 | 1413085 | 2021-05-24 | Japan | Niigata | 3067 | 34 | 2589 | 444 | 37.521819 | 138.918647 | 2021-05-25 04:21:08 | Niigata, Japan | ||
1916827 | 1916827 | 2021-05-20 | Uganda | 43223 | 350 | 42429 | 444 | 1.373333 | 32.290275 | 2021-05-21 04:20:43 | Uganda | |||
2939510 | 2939510 | 2021-05-16 | Russia | Amur Oblast | 22517 | 288 | 21785 | 444 | 52.8032368 | 128.437295 | 2021-05-17 04:20:34 | Amur Oblast, Russia | ||
3924240 | 3924240 | 2021-04-24 | Russia | North Ossetia - Alania Republic | 16667 | 195 | 16028 | 444 | 42.79336110000001 | 44.6324493 | 2021-04-25 04:20:32 | North Ossetia - Alania Republic, Russia | ||
1567796 | 1567796 | 2021-04-22 | Andorra | 12942 | 123 | 12375 | 444 | 42.5063 | 1.5218 | 2021-04-23 04:20:52 | Andorra | |||
982962 | 982962 | 2021-04-17 | Japan | Ibaraki | 7385 | 129 | 6812 | 444 | 36.303588 | 140.319591 | 2021-04-18 04:20:41 | Ibaraki, Japan | ||
1744808 | 1744808 | 2021-03-20 | San Marino | 4328 | 79 | 3805 | 444 | 43.9424 | 12.4578 | 2021-03-21 05:25:44 | San Marino | |||
3668574 | 3668574 | 2021-03-06 | US | Illinois | Alexander | 17003 | 453 | 9 | 0 | 444 | 37.18049267 | -89.32910838 | 2021-03-07 05:21:54 | Alexander, Illinois, US |
1618288 | 1618288 | 2021-03-05 | US | Nebraska | Chase | 31029 | 447 | 3 | 0 | 444 | 40.5237198 | -101.6978026 | 2021-03-06 04:23:41 | Chase, Nebraska, US |
1617891 | 1617891 | 2021-03-05 | US | Michigan | Mackinac | 26097 | 447 | 3 | 0 | 444 | 46.07028979 | -85.04980537 | 2021-03-06 04:23:41 | Mackinac, Michigan, US |
1617195 | 1617195 | 2021-03-05 | US | Illinois | Alexander | 17003 | 453 | 9 | 0 | 444 | 37.18049267 | -89.32910838 | 2021-03-06 04:23:41 | Alexander, Illinois, US |
2209699 | 2209699 | 2021-03-04 | US | Nebraska | Chase | 31029 | 447 | 3 | 0 | 444 | 40.5237198 | -101.6978026 | 2021-03-05 05:26:29 | Chase, Nebraska, US |
998992 | 998992 | 2021-03-01 | US | California | Modoc | 6049 | 444 | 3 | 0 | 444 | 41.58965602 | -120.7244817 | 2021-03-02 05:23:30 | Modoc, California, US |
2368050 | 2368050 | 2021-02-28 | US | California | Modoc | 6049 | 444 | 3 | 0 | 444 | 41.58965602 | -120.7244817 | 2021-03-01 05:23:01 | Modoc, California, US |
3066785 | 3066785 | 2021-02-27 | US | Georgia | Echols | 13101 | 450 | 6 | 0 | 444 | 30.71101099 | -82.89687287 | 2021-02-28 05:22:20 | Echols, Georgia, US |
280969 | 280969 | 2021-02-24 | US | Georgia | Echols | 13101 | 450 | 6 | 0 | 444 | 30.71101099 | -82.89687287 | 2021-02-25 05:24:57 | Echols, Georgia, US |
279967 | 279967 | 2021-02-24 | Chile | Atacama | 11758 | 147 | 11167 | 444 | -27.5661 | -70.0503 | 2021-02-25 05:24:57 | Atacama, Chile | ||
1936881 | 1936881 | 2021-02-23 | US | Alaska | Southeast Fairbanks | 2240 | 447 | 3 | 0 | 444 | 63.87692095 | -143.2127643 | 2021-02-24 05:29:16 | Southeast Fairbanks, Alaska, US |
531136 | 531136 | 2021-02-22 | US | Alaska | Southeast Fairbanks | 2240 | 447 | 3 | 0 | 444 | 63.87692095 | -143.2127643 | 2021-02-23 05:23:41 | Southeast Fairbanks, Alaska, US |
182470 | 182470 | 2021-02-21 | US | Alaska | Southeast Fairbanks | 2240 | 447 | 3 | 0 | 444 | 63.87692095 | -143.2127643 | 2021-02-22 05:24:21 | Southeast Fairbanks, Alaska, US |
182314 | 182314 | 2021-02-21 | Seychelles | 2328 | 10 | 1874 | 444 | -4.6796 | 55.492 | 2021-02-22 05:24:21 | Seychelles | |||
744053 | 744053 | 2021-02-20 | US | Minnesota | Norman | 27107 | 452 | 8 | 0 | 444 | 47.32628443 | -96.45620947 | 2021-02-21 05:24:33 | Norman, Minnesota, US |
742744 | 742744 | 2021-02-20 | US | Alaska | Southeast Fairbanks | 2240 | 447 | 3 | 0 | 444 | 63.87692095 | -143.2127643 | 2021-02-21 05:24:33 | Southeast Fairbanks, Alaska, US |
471842 | 471842 | 2021-02-19 | US | Alaska | Southeast Fairbanks | 2240 | 447 | 3 | 0 | 444 | 63.87692095 | -143.2127643 | 2021-02-20 05:22:51 | Southeast Fairbanks, Alaska, US |
1154547 | 1154547 | 2021-02-18 | US | Kentucky | Lyon | 21143 | 457 | 13 | 0 | 444 | 37.02080035 | -88.07886257 | 2021-02-19 05:24:16 | Lyon, Kentucky, US |
1153551 | 1153551 | 2021-02-18 | US | Alaska | Southeast Fairbanks | 2240 | 447 | 3 | 0 | 444 | 63.87692095 | -143.2127643 | 2021-02-19 05:24:16 | Southeast Fairbanks, Alaska, US |
3604509 | 3604509 | 2021-02-17 | US | West Virginia | Doddridge | 54017 | 450 | 6 | 0 | 444 | 39.27057157 | -80.70671527 | 2021-02-18 05:22:58 | Doddridge, West Virginia, US |
3053644 | 3053644 | 2021-02-16 | US | West Virginia | Doddridge | 54017 | 450 | 6 | 0 | 444 | 39.27057157 | -80.70671527 | 2021-02-17 05:23:10 | Doddridge, West Virginia, US |
3051602 | 3051602 | 2021-02-16 | US | Kentucky | Lyon | 21143 | 457 | 13 | 0 | 444 | 37.02080035 | -88.07886257 | 2021-02-17 05:23:10 | Lyon, Kentucky, US |
3051212 | 3051212 | 2021-02-16 | US | Illinois | Scott | 17171 | 445 | 1 | 0 | 444 | 39.6429169 | -90.47814431 | 2021-02-17 05:23:10 | Scott, Illinois, US |
1341743 | 1341743 | 2021-02-15 | US | West Virginia | Doddridge | 54017 | 450 | 6 | 0 | 444 | 39.27057157 | -80.70671527 | 2021-02-16 05:24:38 | Doddridge, West Virginia, US |
2681150 | 2681150 | 2021-02-13 | US | Virginia | Fairfax City | 51600 | 456 | 12 | 0 | 444 | 38.85157547 | -77.29779640000002 | 2021-02-14 05:23:43 | Fairfax City, Virginia, US |
2678978 | 2678978 | 2021-02-13 | US | Iowa | Audubon | 19009 | 453 | 9 | 0 | 444 | 41.6844628 | -94.90581859 | 2021-02-14 05:23:43 | Audubon, Iowa, US |
3542677 | 3542677 | 2021-02-12 | US | Texas | Sutton | 48435 | 403 | 8 | 0 | 444 | 30.49856623 | -100.5382014 | 2021-02-13 05:22:12 | Sutton, Texas, US |
3540611 | 3540611 | 2021-02-12 | US | Iowa | Audubon | 19009 | 453 | 9 | 0 | 444 | 41.6844628 | -94.90581859 | 2021-02-13 05:22:12 | Audubon, Iowa, US |
2638027 | 2638027 | 2021-02-11 | Suriname | 8765 | 166 | 8155 | 444 | 3.9193 | -56.0278 | 2021-02-12 05:23:29 | Suriname | |||
3978717 | 3978717 | 2021-02-10 | Pakistan | Azad Jammu and Kashmir | 9334 | 276 | 8614 | 444 | 34.027401 | 73.947253 | 2021-02-11 05:23:55 | Azad Jammu and Kashmir, Pakistan | ||
1527738 | 1527738 | 2021-02-09 | Colombia | Casanare | 11859 | 242 | 11173 | 444 | 5.7589 | -71.5724 | 2021-02-10 05:22:41 | Casanare, Colombia | ||
1591331 | 1591331 | 2021-02-05 | US | Texas | Marion | 48315 | 550 | 24 | 0 | 444 | 32.79868409 | -94.3566123 | 2021-02-06 05:23:55 | Marion, Texas, US |
341986 | 341986 | 2021-02-03 | US | Minnesota | Grant | 27051 | 452 | 8 | 0 | 444 | 45.93424769 | -96.01139609 | 2021-02-04 05:22:26 | Grant, Minnesota, US |
1686212 | 1686212 | 2021-02-02 | US | Minnesota | Grant | 27051 | 452 | 8 | 0 | 444 | 45.93424769 | -96.01139609 | 2021-02-03 05:22:52 | Grant, Minnesota, US |
2211777 | 2211777 | 2021-01-30 | Mongolia | 1742 | 2 | 1333 | 444 | 46.8625 | 103.8467 | 2021-01-31 05:22:42 | Mongolia | |||
1900688 | 1900688 | 2021-01-29 | US | Wisconsin | Florence | 55037 | 456 | 12 | 0 | 444 | 45.84963535 | -88.39804137 | 2021-01-30 05:22:49 | Florence, Wisconsin, US |
1900660 | 1900660 | 2021-01-29 | US | West Virginia | Tucker | 54093 | 451 | 7 | 0 | 444 | 39.11240885 | -79.57053576 | 2021-01-30 05:22:49 | Tucker, West Virginia, US |
2484258 | 2484258 | 2021-01-28 | US | North Carolina | Camden | 37029 | 449 | 5 | 0 | 444 | 36.33804939 | -76.15568396 | 2021-01-29 05:22:23 | Camden, North Carolina, US |
3155558 | 3155558 | 2021-01-27 | US | Missouri | Shannon | 29203 | 454 | 10 | 0 | 444 | 37.15772072 | -91.40190382 | 2021-01-28 05:22:24 | Shannon, Missouri, US |
2568891 | 2568891 | 2021-01-25 | US | Iowa | Ringgold | 19159 | 455 | 11 | 0 | 444 | 40.73518949 | -94.24368535 | 2021-01-26 05:22:02 | Ringgold, Iowa, US |
1762154 | 1762154 | 2021-01-24 | US | South Dakota | Edmunds | 46045 | 452 | 8 | 0 | 444 | 45.41846445 | -99.21545423 | 2021-01-25 05:22:16 | Edmunds, South Dakota, US |
2429761 | 2429761 | 2021-01-23 | US | South Dakota | Edmunds | 46045 | 452 | 8 | 0 | 444 | 45.41846445 | -99.21545423 | 2021-01-24 05:22:35 | Edmunds, South Dakota, US |
2469660 | 2469660 | 2021-01-22 | US | South Dakota | Deuel | 46039 | 451 | 7 | 0 | 444 | 44.75994309 | -96.66943645 | 2021-01-23 05:22:03 | Deuel, South Dakota, US |
1095986 | 1095986 | 2021-01-20 | US | Missouri | Hickory | 29085 | 454 | 10 | 0 | 444 | 37.94163617 | -93.3203037 | 2021-01-21 05:22:01 | Hickory, Missouri, US |
240346 | 240346 | 2021-01-18 | US | Texas | Hemphill | 48211 | 555 | 2 | 0 | 444 | 35.83764858 | -100.2703577 | 2021-01-19 05:22:15 | Hemphill, Texas, US |
3506463 | 3506463 | 2021-01-17 | US | Texas | Hemphill | 48211 | 555 | 2 | 0 | 444 | 35.83764858 | -100.2703577 | 2021-01-18 05:22:34 | Hemphill, Texas, US |
3505389 | 3505389 | 2021-01-17 | US | Nebraska | Antelope | 31003 | 449 | 5 | 0 | 444 | 42.17695516 | -98.0666283 | 2021-01-18 05:22:34 | Antelope, Nebraska, US |
3504343 | 3504343 | 2021-01-17 | US | Illinois | Henderson | 17071 | 451 | 7 | 0 | 444 | 40.81908672 | -90.92491462 | 2021-01-18 05:22:34 | Henderson, Illinois, US |
3104546 | 3104546 | 2021-01-16 | US | Texas | Hemphill | 48211 | 555 | 2 | 0 | 444 | 35.83764858 | -100.2703577 | 2021-01-17 05:22:17 | Hemphill, Texas, US |
3518755 | 3518755 | 2021-01-15 | US | Virginia | Lancaster | 51103 | 447 | 3 | 0 | 444 | 37.71889653 | -76.46400482 | 2021-01-16 05:22:40 | Lancaster, Virginia, US |
3880687 | 3880687 | 2021-01-14 | US | Indiana | Ohio | 18115 | 454 | 10 | 0 | 444 | 38.955305 | -84.96515993 | 2021-01-15 05:22:24 | Ohio, Indiana, US |
3310237 | 3310237 | 2021-01-13 | US | Nebraska | Boone | 31011 | 448 | 4 | 0 | 444 | 41.70759415 | -98.06737183 | 2021-01-14 05:22:32 | Boone, Nebraska, US |
777853 | 777853 | 2021-01-12 | US | West Virginia | Tyler | 54095 | 447 | 3 | 0 | 444 | 39.46811972 | -80.88772676 | 2021-01-13 05:22:15 | Tyler, West Virginia, US |
777668 | 777668 | 2021-01-12 | US | Virginia | Essex | 51057 | 447 | 3 | 0 | 444 | 37.93357639 | -76.94230311 | 2021-01-13 05:22:15 | Essex, Virginia, US |
777506 | 777506 | 2021-01-12 | US | Texas | McCulloch | 48307 | 433 | 12 | 0 | 444 | 31.1925468 | -99.34682807 | 2021-01-13 05:22:15 | McCulloch, Texas, US |
191005 | 191005 | 2021-01-11 | US | Idaho | Lincoln | 16063 | 453 | 9 | 0 | 444 | 43.0012336 | -114.1358773 | 2021-01-12 05:22:15 | Lincoln, Idaho, US |
3902498 | 3902498 | 2021-01-09 | US | Oklahoma | Dewey | 40043 | 447 | 3 | 0 | 444 | 35.98772922 | -99.00730714 | 2021-01-10 05:22:12 | Dewey, Oklahoma, US |
154624 | 154624 | 2021-01-08 | US | Colorado | Rio Grande | 8105 | 575 | 11 | 0 | 444 | 37.5836865 | -106.3847838 | 2021-01-09 05:22:18 | Rio Grande, Colorado, US |
2867908 | 2867908 | 2021-01-06 | US | Texas | Red River | 48387 | 513 | 27 | 0 | 444 | 33.61886692 | -95.04841765 | 2021-01-07 05:22:03 | Red River, Texas, US |
2867756 | 2867756 | 2021-01-06 | US | Texas | Coleman | 48083 | 532 | 16 | 0 | 444 | 31.76736834 | -99.45240766 | 2021-01-07 05:22:03 | Coleman, Texas, US |
3037357 | 3037357 | 2021-01-05 | US | Texas | Dallam | 48111 | 851 | 19 | 0 | 444 | 36.27787176 | -102.6020725 | 2021-01-06 05:22:16 | Dallam, Texas, US |
3035212 | 3035212 | 2021-01-05 | US | Idaho | Benewah | 16009 | 449 | 5 | 0 | 444 | 47.21754179 | -116.6586851 | 2021-01-06 05:22:16 | Benewah, Idaho, US |
1062469 | 1062469 | 2021-01-04 | US | Colorado | Lake | 8065 | 462 | 0 | 0 | 444 | 39.20278823 | -106.3555697 | 2021-01-05 05:21:49 | Lake, Colorado, US |
3233643 | 3233643 | 2021-01-03 | US | Texas | Red River | 48387 | 512 | 26 | 0 | 444 | 33.61886692 | -95.04841765 | 2021-01-04 05:22:02 | Red River, Texas, US |
3233529 | 3233529 | 2021-01-03 | US | Texas | Franklin | 48159 | 574 | 12 | 0 | 444 | 33.17653242 | -95.21917243 | 2021-01-04 05:22:02 | Franklin, Texas, US |
3231797 | 3231797 | 2021-01-03 | US | Kansas | Wabaunsee | 20197 | 452 | 8 | 0 | 444 | 38.95471985 | -96.20350509 | 2021-01-04 05:22:02 | Wabaunsee, Kansas, US |
2228866 | 2228866 | 2021-01-02 | US | Kansas | Wabaunsee | 20197 | 452 | 8 | 0 | 444 | 38.95471985 | -96.20350509 | 2021-01-03 05:22:52 | Wabaunsee, Kansas, US |
2227391 | 2227391 | 2021-01-02 | Cote d'Ivoire | 22563 | 138 | 21981 | 444 | 7.54 | -5.5471 | 2021-01-03 05:22:52 | Cote d'Ivoire | |||
1139604 | 1139604 | 2021-01-01 | US | Puerto Rico | Ciales | 72039 | 444 | 0 | 0 | 444 | 18.28885 | -66.516475 | 2021-01-02 05:22:33 | Ciales, Puerto Rico, US |
1138230 | 1138230 | 2021-01-01 | US | Kansas | Wabaunsee | 20197 | 452 | 8 | 0 | 444 | 38.95471985 | -96.20350509 | 2021-01-02 05:22:33 | Wabaunsee, Kansas, US |
1136755 | 1136755 | 2021-01-01 | Cote d'Ivoire | 22563 | 138 | 21981 | 444 | 7.54 | -5.5471 | 2021-01-02 05:22:33 | Cote d'Ivoire | |||
3696726 | 3696726 | 2020-12-31 | US | Iowa | Van Buren | 19177 | 455 | 11 | 0 | 444 | 40.75326764 | -91.95017958 | 2021-01-01 05:23:07 | Van Buren, Iowa, US |
1011848 | 1011848 | 2020-12-30 | US | Maine | Franklin | 23007 | 449 | 5 | 0 | 444 | 44.97330019 | -70.44381045 | 2020-12-31 05:22:49 | Franklin, Maine, US |
766459 | 766459 | 2020-12-29 | Pakistan | Azad Jammu and Kashmir | 8241 | 220 | 7577 | 444 | 34.027401 | 73.947253 | 2020-12-30 05:22:34 | Azad Jammu and Kashmir, Pakistan | ||
3763308 | 3763308 | 2020-12-28 | US | Minnesota | Lincoln | 27081 | 445 | 1 | 0 | 444 | 44.41311883 | -96.26688165 | 2020-12-29 05:22:37 | Lincoln, Minnesota, US |
3761803 | 3761803 | 2020-12-28 | Russia | Magadan Oblast | 6886 | 62 | 6380 | 444 | 62.48858785 | 153.9903764 | 2020-12-29 05:22:37 | Magadan Oblast, Russia | ||
3780682 | 3780682 | 2020-12-27 | US | Puerto Rico | Villalba | 72149 | 444 | 0 | 0 | 444 | 18.127951 | -66.473115 | 2020-12-28 05:22:06 | Villalba, Puerto Rico, US |
3779628 | 3779628 | 2020-12-27 | US | Minnesota | Lincoln | 27081 | 445 | 1 | 0 | 444 | 44.41311883 | -96.26688165 | 2020-12-28 05:22:06 | Lincoln, Minnesota, US |
2225312 | 2225312 | 2020-12-26 | US | Mississippi | Jefferson | 28063 | 458 | 14 | 0 | 444 | 31.73397872 | -91.03764977 | 2020-12-27 05:22:55 | Jefferson, Mississippi, 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]);