johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
341 rows where active = 625 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 24
- US 283
- Russia 13
- Ukraine 6
- Chile 5
- India 5
- Colombia 4
- Mexico 4
- Japan 3
- Cuba 2
- Germany 2
- Azerbaijan 1
- Brazil 1
- Burkina Faso 1
- China 1
- Italy 1
- Lithuania 1
- Maldives 1
- Malta 1
- Netherlands 1
- Peru 1
- Seychelles 1
- Singapore 1
- Sri Lanka 1
- Tajikistan 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3741077 | 3741077 | 2021-07-12 | Italy | Umbria | 56943 | 1424 | 54894 | 625 | 43.10675841 | 12.38824698 | 2021-07-13 04:21:18 | Umbria, Italy | ||
3125419 | 3125419 | 2021-06-28 | Germany | Hamburg | 77299 | 1590 | 75100 | 625 | 53.5511 | 9.9937 | 2021-06-29 04:21:28 | Hamburg, Germany | ||
2720608 | 2720608 | 2021-06-10 | Ukraine | Sevastopol* | 15188 | 698 | 13865 | 625 | 44.6054 | 33.522 | 2021-06-11 04:23:20 | Sevastopol*, Ukraine | ||
522707 | 522707 | 2021-06-09 | Colombia | La Guajira | 37271 | 1175 | 35471 | 625 | 11.3548 | -72.5205 | 2021-06-10 04:23:17 | La Guajira, Colombia | ||
1708541 | 1708541 | 2021-06-02 | Russia | Novgorod Oblast | 31055 | 164 | 30266 | 625 | 58.2843833 | 32.5169757 | 2021-06-03 04:23:32 | Novgorod Oblast, Russia | ||
51042 | 51042 | 2021-05-29 | Russia | Tomsk Oblast | 32808 | 431 | 31752 | 625 | 58.6124279 | 82.04753149999998 | 2021-05-30 04:20:55 | Tomsk Oblast, Russia | ||
3393185 | 3393185 | 2021-04-28 | Chile | Magallanes | 25044 | 367 | 24052 | 625 | -52.368 | -70.9863 | 2021-04-29 04:20:55 | Magallanes, Chile | ||
2780848 | 2780848 | 2021-03-24 | Colombia | Norte de Santander | 51653 | 2756 | 48272 | 625 | 7.9463 | -72.8988 | 2021-03-25 05:27:00 | Norte de Santander, Colombia | ||
1798913 | 1798913 | 2021-03-23 | Seychelles | 3798 | 16 | 3157 | 625 | -4.6796 | 55.492 | 2021-03-24 05:25:40 | Seychelles | |||
3668502 | 3668502 | 2021-03-06 | US | Georgia | Twiggs | 13289 | 663 | 38 | 0 | 625 | 32.67435595 | -83.43078662 | 2021-03-07 05:21:54 | Twiggs, Georgia, US |
1092949 | 1092949 | 2021-03-03 | US | South Dakota | Kingsbury | 46077 | 639 | 14 | 0 | 625 | 44.36956169 | -97.4913945 | 2021-03-04 05:24:24 | Kingsbury, South Dakota, US |
3257021 | 3257021 | 2021-03-02 | US | South Dakota | Kingsbury | 46077 | 639 | 14 | 0 | 625 | 44.36956169 | -97.4913945 | 2021-03-03 05:23:28 | Kingsbury, South Dakota, US |
1001313 | 1001313 | 2021-03-01 | US | South Dakota | Kingsbury | 46077 | 639 | 14 | 0 | 625 | 44.36956169 | -97.4913945 | 2021-03-02 05:23:30 | Kingsbury, South Dakota, US |
2370371 | 2370371 | 2021-02-28 | US | South Dakota | Kingsbury | 46077 | 639 | 14 | 0 | 625 | 44.36956169 | -97.4913945 | 2021-03-01 05:23:01 | Kingsbury, South Dakota, US |
3069321 | 3069321 | 2021-02-27 | US | Virginia | Essex | 51057 | 631 | 6 | 0 | 625 | 37.93357639 | -76.94230311 | 2021-02-28 05:22:20 | Essex, Virginia, US |
3068205 | 3068205 | 2021-02-27 | US | New Mexico | Torrance | 35057 | 637 | 12 | 0 | 625 | 34.64048375 | -105.8508949 | 2021-02-28 05:22:20 | Torrance, New Mexico, US |
2186363 | 2186363 | 2021-02-26 | US | Puerto Rico | Villalba | 72149 | 625 | 0 | 0 | 625 | 18.127951 | -66.473115 | 2021-02-27 05:22:28 | Villalba, Puerto Rico, US |
1861363 | 1861363 | 2021-02-25 | US | Virginia | Lunenburg | 51111 | 629 | 4 | 0 | 625 | 36.94618528 | -78.24133319 | 2021-02-26 05:22:40 | Lunenburg, Virginia, US |
1859553 | 1859553 | 2021-02-25 | US | Maine | Knox | 23013 | 630 | 5 | 0 | 625 | 44.11486325 | -69.10529169 | 2021-02-26 05:22:40 | Knox, Maine, US |
1857750 | 1857750 | 2021-02-25 | Brazil | Piaui | 172525 | 3305 | 167754 | 625 | -7.7183 | -42.7289 | 2021-02-26 05:22:40 | Piaui, Brazil | ||
281855 | 281855 | 2021-02-24 | US | Michigan | Presque Isle | 26141 | 653 | 28 | 0 | 625 | 45.34018577 | -83.91498656 | 2021-02-25 05:24:57 | Presque Isle, Michigan, US |
1938123 | 1938123 | 2021-02-23 | US | Michigan | Presque Isle | 26141 | 653 | 28 | 0 | 625 | 45.34018577 | -83.91498656 | 2021-02-24 05:29:16 | Presque Isle, Michigan, US |
1937685 | 1937685 | 2021-02-23 | US | Iowa | Taylor | 19173 | 637 | 12 | 0 | 625 | 40.73710579 | -94.69778563 | 2021-02-24 05:29:16 | Taylor, Iowa, US |
532784 | 532784 | 2021-02-22 | US | Nebraska | Jefferson | 31095 | 626 | 1 | 0 | 625 | 40.17584531 | -97.142601 | 2021-02-23 05:23:41 | Jefferson, Nebraska, US |
532099 | 532099 | 2021-02-22 | US | Kentucky | Gallatin | 21077 | 644 | 19 | 0 | 625 | 38.75398691 | -84.8558382 | 2021-02-23 05:23:41 | Gallatin, Kentucky, US |
531940 | 531940 | 2021-02-22 | US | Iowa | Taylor | 19173 | 636 | 11 | 0 | 625 | 40.73710579 | -94.69778563 | 2021-02-23 05:23:41 | Taylor, Iowa, US |
530667 | 530667 | 2021-02-22 | India | Odisha | 336705 | 1914 | 334166 | 625 | 20.505428 | 84.418059 | 2021-02-23 05:23:41 | Odisha, India | ||
185354 | 185354 | 2021-02-21 | US | Virginia | Covington | 51580 | 630 | 5 | 0 | 625 | 37.7824656 | -79.98631446 | 2021-02-22 05:24:21 | Covington, Virginia, US |
183274 | 183274 | 2021-02-21 | US | Iowa | Taylor | 19173 | 636 | 11 | 0 | 625 | 40.73710579 | -94.69778563 | 2021-02-22 05:24:21 | Taylor, Iowa, US |
745168 | 745168 | 2021-02-20 | US | South Dakota | Day | 46037 | 653 | 28 | 0 | 625 | 45.367281 | -97.60737498 | 2021-02-21 05:24:33 | Day, South Dakota, US |
744849 | 744849 | 2021-02-20 | US | Oklahoma | Cotton | 40033 | 638 | 13 | 0 | 625 | 34.28845626 | -98.37053567 | 2021-02-21 05:24:33 | Cotton, Oklahoma, US |
471928 | 471928 | 2021-02-19 | US | Arkansas | Searcy | 5129 | 640 | 15 | 0 | 625 | 35.9109364 | -92.69936482 | 2021-02-20 05:22:51 | Searcy, Arkansas, US |
1156435 | 1156435 | 2021-02-18 | US | Virginia | Covington | 51580 | 630 | 5 | 0 | 625 | 37.7824656 | -79.98631446 | 2021-02-19 05:24:16 | Covington, Virginia, US |
1339658 | 1339658 | 2021-02-15 | US | Kentucky | Cumberland | 21057 | 632 | 7 | 0 | 625 | 36.78926125 | -85.39050034 | 2021-02-16 05:24:38 | Cumberland, Kentucky, US |
1338866 | 1338866 | 2021-02-15 | US | Colorado | Archuleta | 8007 | 641 | 1 | 0 | 625 | 37.19474156 | -107.0476867 | 2021-02-16 05:24:38 | Archuleta, Colorado, US |
2284809 | 2284809 | 2021-02-14 | US | Kentucky | Cumberland | 21057 | 632 | 7 | 0 | 625 | 36.78926125 | -85.39050034 | 2021-02-15 05:24:49 | Cumberland, Kentucky, US |
2283366 | 2283366 | 2021-02-14 | India | Bihar | 261741 | 1525 | 259591 | 625 | 25.679658 | 85.60484 | 2021-02-15 05:24:49 | Bihar, India | ||
613472 | 613472 | 2021-02-08 | Chile | Arica y Parinacota | 13638 | 265 | 12748 | 625 | -18.594 | -69.4785 | 2021-02-09 05:23:30 | Arica y Parinacota, Chile | ||
1672488 | 1672488 | 2021-02-07 | Japan | Okinawa | 7842 | 92 | 7125 | 625 | 25.768923 | 126.668016 | 2021-02-08 05:22:39 | Okinawa, Japan | ||
1672241 | 1672241 | 2021-02-07 | Chile | Arica y Parinacota | 13548 | 264 | 12659 | 625 | -18.594 | -69.4785 | 2021-02-08 05:22:39 | Arica y Parinacota, Chile | ||
341521 | 341521 | 2021-02-03 | US | Iowa | Worth | 19195 | 629 | 4 | 0 | 625 | 43.37750768 | -93.26087602 | 2021-02-04 05:22:26 | Worth, Iowa, US |
1687809 | 1687809 | 2021-02-02 | US | Virginia | Charlotte | 51037 | 636 | 11 | 0 | 625 | 37.01909701 | -78.66314092 | 2021-02-03 05:22:52 | Charlotte, Virginia, US |
1687034 | 1687034 | 2021-02-02 | US | Oklahoma | Coal | 40029 | 635 | 10 | 0 | 625 | 34.58840127 | -96.29798747 | 2021-02-03 05:22:52 | Coal, Oklahoma, US |
1686681 | 1686681 | 2021-02-02 | US | New Mexico | Colfax | 35007 | 664 | 39 | 0 | 625 | 36.60569702 | -104.64726740000002 | 2021-02-03 05:22:52 | Colfax, New Mexico, US |
1685747 | 1685747 | 2021-02-02 | US | Iowa | Worth | 19195 | 629 | 4 | 0 | 625 | 43.37750768 | -93.26087602 | 2021-02-03 05:22:52 | Worth, Iowa, US |
1679004 | 1679004 | 2021-02-01 | US | Oklahoma | Coal | 40029 | 635 | 10 | 0 | 625 | 34.58840127 | -96.29798747 | 2021-02-02 05:22:49 | Coal, Oklahoma, US |
1678651 | 1678651 | 2021-02-01 | US | New Mexico | Colfax | 35007 | 664 | 39 | 0 | 625 | 36.60569702 | -104.64726740000002 | 2021-02-02 05:22:49 | Colfax, New Mexico, US |
1461939 | 1461939 | 2021-01-31 | US | New Mexico | Colfax | 35007 | 662 | 37 | 0 | 625 | 36.60569702 | -104.64726740000002 | 2021-02-01 05:22:53 | Colfax, New Mexico, US |
2214219 | 2214219 | 2021-01-30 | US | Oklahoma | Jefferson | 40067 | 632 | 7 | 0 | 625 | 34.11130184 | -97.83182974 | 2021-01-31 05:22:42 | Jefferson, Oklahoma, US |
2213847 | 2213847 | 2021-01-30 | US | New Mexico | Colfax | 35007 | 662 | 37 | 0 | 625 | 36.60569702 | -104.64726740000002 | 2021-01-31 05:22:42 | Colfax, New Mexico, US |
2213091 | 2213091 | 2021-01-30 | US | Kentucky | Livingston | 21139 | 641 | 16 | 0 | 625 | 37.21137452 | -88.34797529 | 2021-01-31 05:22:42 | Livingston, Kentucky, US |
1900522 | 1900522 | 2021-01-29 | US | Virginia | Nelson | 51125 | 631 | 6 | 0 | 625 | 37.78790447 | -78.88498513 | 2021-01-30 05:22:49 | Nelson, Virginia, US |
2481754 | 2481754 | 2021-01-28 | Chile | Arica y Parinacota | 12654 | 253 | 11776 | 625 | -18.594 | -69.4785 | 2021-01-29 05:22:23 | Arica y Parinacota, Chile | ||
3155375 | 3155375 | 2021-01-27 | US | Minnesota | Wilkin | 27167 | 635 | 10 | 0 | 625 | 46.35721532 | -96.4684375 | 2021-01-28 05:22:24 | Wilkin, Minnesota, US |
14420 | 14420 | 2021-01-26 | US | Nebraska | Kearney | 31099 | 629 | 4 | 0 | 625 | 40.50663314 | -98.94877182 | 2021-01-27 05:23:41 | Kearney, Nebraska, US |
14341 | 14341 | 2021-01-26 | US | Montana | Madison | 30057 | 631 | 6 | 0 | 625 | 45.30080065 | -111.9173017 | 2021-01-27 05:23:41 | Madison, Montana, US |
14110 | 14110 | 2021-01-26 | US | Minnesota | Wilkin | 27167 | 635 | 10 | 0 | 625 | 46.35721532 | -96.4684375 | 2021-01-27 05:23:41 | Wilkin, Minnesota, US |
13662 | 13662 | 2021-01-26 | US | Kansas | Phillips | 20147 | 642 | 17 | 0 | 625 | 39.78465501 | -99.34668865 | 2021-01-27 05:23:41 | Phillips, Kansas, US |
2569447 | 2569447 | 2021-01-25 | US | Mississippi | Choctaw | 28019 | 638 | 13 | 0 | 625 | 33.34598242 | -89.24809382 | 2021-01-26 05:22:02 | Choctaw, Mississippi, US |
2569434 | 2569434 | 2021-01-25 | US | Minnesota | Wilkin | 27167 | 635 | 10 | 0 | 625 | 46.35721532 | -96.4684375 | 2021-01-26 05:22:02 | Wilkin, Minnesota, US |
2568986 | 2568986 | 2021-01-25 | US | Kansas | Phillips | 20147 | 642 | 17 | 0 | 625 | 39.78465501 | -99.34668865 | 2021-01-26 05:22:02 | Phillips, Kansas, US |
1762800 | 1762800 | 2021-01-24 | US | West Virginia | Summers | 54089 | 646 | 21 | 0 | 625 | 37.65390597 | -80.86009693 | 2021-01-25 05:22:16 | Summers, West Virginia, US |
2428673 | 2428673 | 2021-01-23 | US | Minnesota | Wilkin | 27167 | 634 | 9 | 0 | 625 | 46.35721532 | -96.4684375 | 2021-01-24 05:22:35 | Wilkin, Minnesota, US |
438571 | 438571 | 2021-01-21 | US | Texas | Stephens | 48429 | 715 | 19 | 0 | 625 | 32.73553157 | -98.83631615 | 2021-01-22 05:22:10 | Stephens, Texas, US |
435861 | 435861 | 2021-01-21 | US | Arkansas | Perry | 5105 | 631 | 6 | 0 | 625 | 34.9459153 | -92.94372564 | 2021-01-22 05:22:10 | Perry, Arkansas, US |
1096504 | 1096504 | 2021-01-20 | US | North Dakota | Sioux | 38085 | 626 | 11 | 0 | 625 | 46.11323337 | -101.0440149 | 2021-01-21 05:22:01 | Sioux, North Dakota, US |
909731 | 909731 | 2021-01-19 | US | Maine | Sagadahoc | 23023 | 626 | 1 | 0 | 625 | 43.95415864 | -69.85074999 | 2021-01-20 05:21:54 | Sagadahoc, Maine, US |
3504576 | 3504576 | 2021-01-17 | US | Iowa | Osceola | 19143 | 634 | 9 | 0 | 625 | 43.37824276 | -95.62422844 | 2021-01-18 05:22:34 | Osceola, Iowa, US |
3102659 | 3102659 | 2021-01-16 | US | Iowa | Osceola | 19143 | 634 | 9 | 0 | 625 | 43.37824276 | -95.62422844 | 2021-01-17 05:22:17 | Osceola, Iowa, US |
3516621 | 3516621 | 2021-01-15 | US | Iowa | Osceola | 19143 | 634 | 9 | 0 | 625 | 43.37824276 | -95.62422844 | 2021-01-16 05:22:40 | Osceola, Iowa, US |
3883180 | 3883180 | 2021-01-14 | US | Wyoming | Sublette | 56035 | 632 | 7 | 0 | 625 | 42.76558279 | -109.9130922 | 2021-01-15 05:22:24 | Sublette, Wyoming, US |
3880794 | 3880794 | 2021-01-14 | US | Iowa | Osceola | 19143 | 634 | 9 | 0 | 625 | 43.37824276 | -95.62422844 | 2021-01-15 05:22:24 | Osceola, Iowa, US |
3309211 | 3309211 | 2021-01-13 | US | Illinois | Marshall | 17123 | 637 | 12 | 0 | 625 | 41.0327901 | -89.34510444 | 2021-01-14 05:22:32 | Marshall, Illinois, US |
775241 | 775241 | 2021-01-12 | US | Georgia | Wilcox | 13315 | 664 | 39 | 0 | 625 | 31.97496928 | -83.43438555 | 2021-01-13 05:22:15 | Wilcox, Georgia, US |
3902216 | 3902216 | 2021-01-09 | US | New York | Schuyler | 36097 | 635 | 10 | 0 | 625 | 42.39184015 | -76.8773299 | 2021-01-10 05:22:12 | Schuyler, New York, US |
156878 | 156878 | 2021-01-08 | US | South Dakota | Tripp | 46123 | 638 | 13 | 0 | 625 | 43.34459388 | -99.8854891 | 2021-01-09 05:22:18 | Tripp, South Dakota, US |
2865782 | 2865782 | 2021-01-06 | US | Indiana | Crawford | 18025 | 638 | 13 | 0 | 625 | 38.28814402 | -86.44518825 | 2021-01-07 05:22:03 | Crawford, Indiana, US |
3037520 | 3037520 | 2021-01-05 | US | Texas | Swisher | 48437 | 784 | 13 | 0 | 625 | 34.53028891 | -101.7349174 | 2021-01-06 05:22:16 | Swisher, Texas, US |
3037202 | 3037202 | 2021-01-05 | US | South Dakota | Walworth | 46129 | 639 | 14 | 0 | 625 | 45.43019636 | -100.0307514 | 2021-01-06 05:22:16 | Walworth, South Dakota, US |
3232350 | 3232350 | 2021-01-03 | US | Missouri | Howard | 29089 | 628 | 3 | 0 | 625 | 39.1435761 | -92.69756691 | 2021-01-04 05:22:02 | Howard, Missouri, US |
2228415 | 2228415 | 2021-01-02 | US | Georgia | Wilkinson | 13319 | 643 | 18 | 0 | 625 | 32.80291082 | -83.17140684 | 2021-01-03 05:22:52 | Wilkinson, Georgia, US |
2228358 | 2228358 | 2021-01-02 | US | Georgia | Montgomery | 13209 | 635 | 10 | 0 | 625 | 32.17201038 | -82.53527476 | 2021-01-03 05:22:52 | Montgomery, Georgia, US |
1138933 | 1138933 | 2021-01-01 | US | Nebraska | Custer | 31041 | 639 | 14 | 0 | 625 | 41.39374521 | -99.72805369 | 2021-01-02 05:22:33 | Custer, Nebraska, US |
3696384 | 3696384 | 2020-12-31 | US | Georgia | Wilkes | 13317 | 635 | 10 | 0 | 625 | 33.78290391 | -82.74286107 | 2021-01-01 05:23:07 | Wilkes, Georgia, US |
1012449 | 1012449 | 2020-12-30 | US | New Hampshire | Coos | 33007 | 640 | 15 | 0 | 625 | 44.69063265 | -71.30633239 | 2020-12-31 05:22:49 | Coos, New Hampshire, US |
1011117 | 1011117 | 2020-12-30 | US | Georgia | Irwin | 13155 | 642 | 17 | 0 | 625 | 31.60213036 | -83.27501387 | 2020-12-31 05:22:49 | Irwin, Georgia, US |
767686 | 767686 | 2020-12-29 | US | Kentucky | Breckinridge | 21027 | 630 | 5 | 0 | 625 | 37.77377239 | -86.42885017 | 2020-12-30 05:22:34 | Breckinridge, Kentucky, US |
3780262 | 3780262 | 2020-12-27 | US | North Carolina | Swain | 37173 | 632 | 7 | 0 | 625 | 35.48665845 | -83.48748932 | 2020-12-28 05:22:06 | Swain, North Carolina, US |
3778693 | 3778693 | 2020-12-27 | US | Georgia | Evans | 13109 | 638 | 13 | 0 | 625 | 32.15328841 | -81.8870105 | 2020-12-28 05:22:06 | Evans, Georgia, US |
2225451 | 2225451 | 2020-12-26 | US | Missouri | Ralls | 29173 | 631 | 6 | 0 | 625 | 39.52817427 | -91.51838643 | 2020-12-27 05:22:55 | Ralls, Missouri, US |
2225400 | 2225400 | 2020-12-26 | US | Missouri | Gasconade | 29073 | 654 | 29 | 0 | 625 | 38.43947277 | -91.50847147 | 2020-12-27 05:22:55 | Gasconade, Missouri, US |
204198 | 204198 | 2020-12-25 | US | Missouri | Ralls | 29173 | 631 | 6 | 0 | 625 | 39.52817427 | -91.51838643 | 2020-12-26 05:22:28 | Ralls, Missouri, US |
203439 | 203439 | 2020-12-25 | US | Iowa | Greene | 19073 | 632 | 7 | 0 | 625 | 42.03614551 | -94.39658081 | 2020-12-26 05:22:28 | Greene, Iowa, US |
3692662 | 3692662 | 2020-12-24 | US | Iowa | Greene | 19073 | 632 | 7 | 0 | 625 | 42.03614551 | -94.39658081 | 2020-12-25 05:22:48 | Greene, Iowa, US |
2409796 | 2409796 | 2020-12-23 | US | Tennessee | Moore | 47127 | 679 | 5 | 0 | 625 | 35.27724699 | -86.36230578 | 2020-12-24 05:23:04 | Moore, Tennessee, US |
3773437 | 3773437 | 2020-12-22 | US | Wisconsin | Pepin | 55091 | 630 | 5 | 0 | 625 | 44.58307413 | -91.99949611 | 2020-12-23 05:22:03 | Pepin, Wisconsin, US |
3771293 | 3771293 | 2020-12-22 | US | Kentucky | Lawrence | 21127 | 629 | 4 | 0 | 625 | 38.07136018 | -82.72882223 | 2020-12-23 05:22:03 | Lawrence, Kentucky, US |
929718 | 929718 | 2020-12-21 | US | Montana | Valley | 30105 | 632 | 7 | 0 | 625 | 48.36435097 | -106.6669635 | 2020-12-22 05:22:33 | Valley, Montana, US |
927484 | 927484 | 2020-12-21 | Chile | Los Rios | 7949 | 77 | 7247 | 625 | -40.231 | -72.3311 | 2020-12-22 05:22:33 | Los Rios, Chile | ||
2121739 | 2121739 | 2020-12-20 | US | Montana | Valley | 30105 | 632 | 7 | 0 | 625 | 48.36435097 | -106.6669635 | 2020-12-21 05:27:58 | Valley, Montana, 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]);