johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
160 rows where active = 1756 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2947615 | 2947615 | 2021-07-16 | Russia | Ulyanovsk Oblast | 61773 | 1827 | 58190 | 1756 | 54.1463177 | 47.2324921 | 2021-07-17 04:22:22 | Ulyanovsk Oblast, Russia | ||
3093056 | 3093056 | 2021-05-30 | Ukraine | Poltava Oblast | 76915 | 1784 | 73375 | 1756 | 49.5883 | 34.5514 | 2021-05-31 03:08:59 | Poltava Oblast, Ukraine | ||
2939169 | 2939169 | 2021-05-16 | Colombia | Cesar | 61073 | 1635 | 57682 | 1756 | 9.3373 | -73.6536 | 2021-05-17 04:20:34 | Cesar, Colombia | ||
2501872 | 2501872 | 2021-05-07 | Colombia | Cesar | 57027 | 1511 | 53760 | 1756 | 9.3373 | -73.6536 | 2021-05-08 04:21:04 | Cesar, Colombia | ||
2501867 | 2501867 | 2021-05-07 | Colombia | Caldas | 63598 | 1278 | 60564 | 1756 | 5.2983 | -75.2479 | 2021-05-08 04:21:04 | Caldas, Colombia | ||
1636327 | 1636327 | 2021-04-29 | Japan | Hokkaido | 23983 | 856 | 21371 | 1756 | 43.385711 | 142.552318 | 2021-04-30 04:21:03 | Hokkaido, Japan | ||
2571925 | 2571925 | 2021-04-13 | Russia | Stavropol Krai | 51575 | 1278 | 48541 | 1756 | 44.86325770000001 | 43.4406913 | 2021-04-14 04:20:41 | Stavropol Krai, Russia | ||
3670533 | 3670533 | 2021-03-06 | US | Tennessee | Cannon | 47015 | 1784 | 30 | 0 | 1756 | 35.80990797 | -86.05738983 | 2021-03-07 05:21:54 | Cannon, Tennessee, US |
1091509 | 1091509 | 2021-03-03 | US | Kentucky | McCreary | 21147 | 1778 | 22 | 0 | 1756 | 36.73874143 | -84.48102924 | 2021-03-04 05:24:24 | McCreary, Kentucky, US |
1091154 | 1091154 | 2021-03-03 | US | Indiana | Fulton | 18049 | 1793 | 37 | 0 | 1756 | 41.0469907 | -86.26252745 | 2021-03-04 05:24:24 | Fulton, Indiana, US |
3256815 | 3256815 | 2021-03-02 | US | Pennsylvania | Juniata | 42067 | 1836 | 80 | 0 | 1756 | 40.53358749 | -77.39975129999998 | 2021-03-03 05:23:28 | Juniata, Pennsylvania, US |
3255365 | 3255365 | 2021-03-02 | US | Iowa | O'Brien | 19141 | 1814 | 58 | 0 | 1756 | 43.08310673 | -95.62474482 | 2021-03-03 05:23:28 | O'Brien, Iowa, US |
2370488 | 2370488 | 2021-02-28 | US | Tennessee | Unicoi | 47171 | 1796 | 47 | 0 | 1756 | 36.10890856 | -82.43709629 | 2021-03-01 05:23:01 | Unicoi, Tennessee, US |
2368909 | 2368909 | 2021-02-28 | US | Kentucky | Johnson | 21115 | 1774 | 18 | 0 | 1756 | 37.85106355 | -82.8264322 | 2021-03-01 05:23:01 | Johnson, Kentucky, US |
2186958 | 2186958 | 2021-02-26 | US | Virginia | Nottoway | 51135 | 1791 | 35 | 0 | 1756 | 37.1435975 | -78.05065922 | 2021-02-27 05:22:28 | Nottoway, Virginia, US |
745574 | 745574 | 2021-02-20 | US | Utah | San Juan | 49037 | 1792 | 36 | 0 | 1756 | 37.62762978 | -109.80337140000002 | 2021-02-21 05:24:33 | San Juan, Utah, US |
1153492 | 1153492 | 2021-02-18 | US | Alabama | Henry | 1067 | 1796 | 40 | 0 | 1756 | 31.51148016 | -85.24267944 | 2021-02-19 05:24:16 | Henry, Alabama, US |
3601881 | 3601881 | 2021-02-17 | US | Georgia | Morgan | 13211 | 1771 | 15 | 0 | 1756 | 33.59232073 | -83.49129491 | 2021-02-18 05:22:58 | Morgan, Georgia, US |
3601674 | 3601674 | 2021-02-17 | US | Colorado | Otero | 8089 | 1856 | 59 | 0 | 1756 | 37.9014485 | -103.7173385 | 2021-02-18 05:22:58 | Otero, Colorado, US |
1340553 | 1340553 | 2021-02-15 | US | North Carolina | Ashe | 37009 | 1793 | 37 | 0 | 1756 | 36.43296207 | -81.49862729 | 2021-02-16 05:24:38 | Ashe, North Carolina, US |
1338756 | 1338756 | 2021-02-15 | US | Arkansas | Hempstead | 5057 | 1773 | 17 | 0 | 1756 | 33.73325583 | -93.66935133 | 2021-02-16 05:24:38 | Hempstead, Arkansas, US |
2284243 | 2284243 | 2021-02-14 | US | Georgia | Jefferson | 13163 | 1810 | 54 | 0 | 1756 | 33.05867328 | -82.41609057 | 2021-02-15 05:24:49 | Jefferson, Georgia, US |
2283907 | 2283907 | 2021-02-14 | US | Arkansas | Hempstead | 5057 | 1773 | 17 | 0 | 1756 | 33.73325583 | -93.66935133 | 2021-02-15 05:24:49 | Hempstead, Arkansas, US |
2680675 | 2680675 | 2021-02-13 | US | South Dakota | Clay | 46027 | 1771 | 15 | 0 | 1756 | 42.91296147 | -96.97656917 | 2021-02-14 05:23:43 | Clay, South Dakota, US |
2678307 | 2678307 | 2021-02-13 | US | Arkansas | Hempstead | 5057 | 1773 | 17 | 0 | 1756 | 33.73325583 | -93.66935133 | 2021-02-14 05:23:43 | Hempstead, Arkansas, US |
3542308 | 3542308 | 2021-02-12 | US | South Dakota | Clay | 46027 | 1771 | 15 | 0 | 1756 | 42.91296147 | -96.97656917 | 2021-02-13 05:22:12 | Clay, South Dakota, US |
3540149 | 3540149 | 2021-02-12 | US | Florida | Gulf | 12045 | 1791 | 35 | 0 | 1756 | 29.93543004 | -85.24270990000002 | 2021-02-13 05:22:12 | Gulf, Florida, US |
977485 | 977485 | 2021-02-06 | US | Oklahoma | McIntosh | 40091 | 1786 | 30 | 0 | 1756 | 35.37235506 | -95.66599306 | 2021-02-07 05:23:00 | McIntosh, Oklahoma, US |
1685630 | 1685630 | 2021-02-02 | US | Indiana | Starke | 18149 | 1806 | 50 | 0 | 1756 | 41.27890281 | -86.64686895 | 2021-02-03 05:22:52 | Starke, Indiana, US |
1677646 | 1677646 | 2021-02-01 | US | Iowa | Delaware | 19055 | 1793 | 37 | 0 | 1756 | 42.47104597 | -91.3664492 | 2021-02-02 05:22:49 | Delaware, Iowa, US |
1897011 | 1897011 | 2021-01-29 | Colombia | Risaralda | 43916 | 1016 | 41144 | 1756 | 5.3158 | -75.9928 | 2021-01-30 05:22:49 | Risaralda, Colombia | ||
3155550 | 3155550 | 2021-01-27 | US | Missouri | Randolph | 29175 | 1780 | 24 | 0 | 1756 | 39.44007257 | -92.4971374 | 2021-01-28 05:22:24 | Randolph, Missouri, US |
3154118 | 3154118 | 2021-01-27 | US | Arkansas | Randolph | 5121 | 1802 | 46 | 0 | 1756 | 36.3415714 | -91.02455531 | 2021-01-28 05:22:24 | Randolph, Arkansas, US |
15255 | 15255 | 2021-01-26 | US | Tennessee | Chester | 47023 | 1874 | 39 | 0 | 1756 | 35.42527478 | -88.6095842 | 2021-01-27 05:23:41 | Chester, Tennessee, US |
2570966 | 2570966 | 2021-01-25 | US | Virginia | Buckingham | 51029 | 1772 | 16 | 0 | 1756 | 37.57242268 | -78.52518834 | 2021-01-26 05:22:02 | Buckingham, Virginia, US |
2468799 | 2468799 | 2021-01-22 | US | Montana | Hill | 30041 | 1793 | 37 | 0 | 1756 | 48.62879827 | -110.1129252 | 2021-01-23 05:22:03 | Hill, Montana, US |
2467145 | 2467145 | 2021-01-22 | US | Alabama | Barbour | 1005 | 1793 | 37 | 0 | 1756 | 31.868263 | -85.3871286 | 2021-01-23 05:22:03 | Barbour, Alabama, US |
437604 | 437604 | 2021-01-21 | US | New York | Otsego | 36077 | 1779 | 23 | 0 | 1756 | 42.63492579 | -75.03151402 | 2021-01-22 05:22:10 | Otsego, New York, US |
1095516 | 1095516 | 2021-01-20 | US | Kentucky | Marion | 21155 | 1776 | 20 | 0 | 1756 | 37.55218078 | -85.26898542 | 2021-01-21 05:22:01 | Marion, Kentucky, US |
908643 | 908643 | 2021-01-19 | US | Arkansas | Columbia | 5027 | 1803 | 47 | 0 | 1756 | 33.21230701 | -93.22642793 | 2021-01-20 05:21:54 | Columbia, Arkansas, US |
3504102 | 3504102 | 2021-01-17 | US | Georgia | Ben Hill | 13017 | 1810 | 54 | 0 | 1756 | 31.76095874 | -83.22145359 | 2021-01-18 05:22:34 | Ben Hill, Georgia, US |
3517056 | 3517056 | 2021-01-15 | US | Michigan | Menominee | 26109 | 1792 | 36 | 0 | 1756 | 45.58038692 | -87.55370409 | 2021-01-16 05:22:40 | Menominee, Michigan, US |
3515896 | 3515896 | 2021-01-15 | US | Arkansas | Logan | 5083 | 1769 | 13 | 0 | 1756 | 35.21413234 | -93.71951016 | 2021-01-16 05:22:40 | Logan, Arkansas, US |
3881356 | 3881356 | 2021-01-14 | US | Mississippi | Chickasaw | 28017 | 1799 | 43 | 0 | 1756 | 33.91983202 | -88.9481545 | 2021-01-15 05:22:24 | Chickasaw, Mississippi, US |
155113 | 155113 | 2021-01-08 | US | Indiana | Sullivan | 18153 | 1790 | 34 | 0 | 1756 | 39.08952258 | -87.41414469 | 2021-01-09 05:22:18 | Sullivan, Indiana, US |
2867630 | 2867630 | 2021-01-06 | US | Tennessee | Claiborne | 47025 | 1832 | 20 | 0 | 1756 | 36.48319149 | -83.65947309 | 2021-01-07 05:22:03 | Claiborne, Tennessee, US |
3036185 | 3036185 | 2021-01-05 | US | Missouri | Crawford | 29055 | 1776 | 20 | 0 | 1756 | 37.97663738 | -91.30528104 | 2021-01-06 05:22:16 | Crawford, Missouri, US |
1061720 | 1061720 | 2021-01-04 | Cuba | 12740 | 147 | 10837 | 1756 | 21.521757 | -77.78116700000002 | 2021-01-05 05:21:49 | Cuba | |||
1139685 | 1139685 | 2021-01-01 | US | South Carolina | Clarendon | 45027 | 1830 | 74 | 0 | 1756 | 33.66610974 | -80.21647898 | 2021-01-02 05:22:33 | Clarendon, South Carolina, US |
1138079 | 1138079 | 2021-01-01 | US | Iowa | Jackson | 19097 | 1785 | 29 | 0 | 1756 | 42.17178824 | -90.57354837 | 2021-01-02 05:22:33 | Jackson, Iowa, US |
3698291 | 3698291 | 2020-12-31 | US | South Carolina | Clarendon | 45027 | 1830 | 74 | 0 | 1756 | 33.66610974 | -80.21647898 | 2021-01-01 05:23:07 | Clarendon, South Carolina, US |
1013786 | 1013786 | 2020-12-30 | US | West Virginia | Marion | 54049 | 1768 | 12 | 0 | 1756 | 39.50984542 | -80.24244659 | 2020-12-31 05:22:49 | Marion, West Virginia, US |
1012092 | 1012092 | 2020-12-30 | US | Mississippi | Covington | 28031 | 1823 | 67 | 0 | 1756 | 31.63225413 | -89.55389939 | 2020-12-31 05:22:49 | Covington, Mississippi, US |
3763063 | 3763063 | 2020-12-28 | US | Louisiana | Beauregard | 22011 | 1810 | 54 | 0 | 1756 | 30.64836518 | -93.34173616 | 2020-12-29 05:22:37 | Beauregard, Louisiana, US |
3762390 | 3762390 | 2020-12-28 | US | Georgia | Haralson | 13143 | 1794 | 38 | 0 | 1756 | 33.79602175 | -85.21005667 | 2020-12-29 05:22:37 | Haralson, Georgia, US |
2226329 | 2226329 | 2020-12-26 | US | South Carolina | Marion | 45067 | 1816 | 60 | 0 | 1756 | 34.07859748 | -79.36400756 | 2020-12-27 05:22:55 | Marion, South Carolina, US |
2122692 | 2122692 | 2020-12-20 | US | Tennessee | Scott | 47151 | 1963 | 16 | 0 | 1756 | 36.42325673 | -84.50360494 | 2020-12-21 05:27:58 | Scott, Tennessee, US |
2121648 | 2121648 | 2020-12-20 | US | Missouri | Perry | 29157 | 1771 | 15 | 0 | 1756 | 37.70660776 | -89.82741088 | 2020-12-21 05:27:58 | Perry, Missouri, US |
2933006 | 2933006 | 2020-12-19 | US | Mississippi | Coahoma | 28027 | 1804 | 48 | 0 | 1756 | 34.22772299 | -90.60415045 | 2020-12-20 05:27:32 | Coahoma, Mississippi, US |
2932112 | 2932112 | 2020-12-19 | US | Georgia | White | 13311 | 1789 | 33 | 0 | 1756 | 34.64624278 | -83.74905525 | 2020-12-20 05:27:32 | White, Georgia, US |
1903302 | 1903302 | 2020-12-18 | US | Nevada | Nye | 32023 | 1792 | 36 | 0 | 1756 | 38.04264256 | -116.4722702 | 2020-12-19 05:27:52 | Nye, Nevada, US |
3149985 | 3149985 | 2020-12-16 | US | Alabama | Pike | 1109 | 1773 | 17 | 0 | 1756 | 31.80396383 | -85.9408295 | 2020-12-17 05:28:12 | Pike, Alabama, US |
1037921 | 1037921 | 2020-12-15 | US | Wisconsin | Langlade | 55067 | 1795 | 39 | 0 | 1756 | 45.26271619 | -89.07483625 | 2020-12-16 05:28:04 | Langlade, Wisconsin, US |
3850229 | 3850229 | 2020-12-13 | US | Ohio | Clinton | 39027 | 1784 | 28 | 0 | 1756 | 39.41485808 | -83.80852286 | 2020-12-14 05:26:27 | Clinton, Ohio, US |
846444 | 846444 | 2020-12-12 | US | Georgia | Toombs | 13279 | 1826 | 70 | 0 | 1756 | 32.12059861 | -82.32957247 | 2020-12-13 05:27:20 | Toombs, Georgia, US |
862368 | 862368 | 2020-12-11 | US | Minnesota | Brown | 27015 | 1778 | 22 | 0 | 1756 | 44.24205652 | -94.72562874 | 2020-12-12 05:26:19 | Brown, Minnesota, US |
861410 | 861410 | 2020-12-11 | US | Florida | Wakulla | 12129 | 1774 | 18 | 0 | 1756 | 30.16548905 | -84.39895211 | 2020-12-12 05:26:19 | Wakulla, Florida, US |
1601616 | 1601616 | 2020-12-10 | US | Kentucky | Greenup | 21089 | 1773 | 17 | 0 | 1756 | 38.54332505 | -82.9215658 | 2020-12-11 05:26:59 | Greenup, Kentucky, US |
2976722 | 2976722 | 2020-12-09 | US | Louisiana | Franklin | 22041 | 1825 | 69 | 0 | 1756 | 32.13675181 | -91.67589857 | 2020-12-10 05:26:19 | Franklin, Louisiana, US |
1819730 | 1819730 | 2020-12-08 | US | Idaho | Payette | 16075 | 1773 | 17 | 0 | 1756 | 44.00545243 | -116.7647695 | 2020-12-09 05:28:01 | Payette, Idaho, US |
3863359 | 3863359 | 2020-12-04 | US | Wisconsin | Door | 55029 | 1767 | 11 | 0 | 1756 | 44.95856458 | -87.30002707 | 2020-12-05 05:27:36 | Door, Wisconsin, US |
78322 | 78322 | 2020-12-03 | US | Texas | Van Zandt | 48467 | 920 | 35 | 0 | 1756 | 32.56483801 | -95.83766469 | 2020-12-04 05:27:27 | Van Zandt, Texas, US |
75201 | 75201 | 2020-12-03 | Mozambique | 15918 | 132 | 14030 | 1756 | -18.665695 | 35.529562 | 2020-12-04 05:27:27 | Mozambique | |||
3566411 | 3566411 | 2020-11-29 | Colombia | Cesar | 29530 | 898 | 26876 | 1756 | 9.3373 | -73.6536 | 2020-11-30 05:26:13 | Cesar, Colombia | ||
2938169 | 2938169 | 2020-11-28 | US | Tennessee | Hardin | 47071 | 1764 | 25 | 0 | 1756 | 35.19732531 | -88.18593755 | 2020-11-29 05:25:55 | Hardin, Tennessee, US |
681382 | 681382 | 2020-11-23 | US | Texas | Erath | 48143 | 1408 | 19 | 0 | 1756 | 32.23602653 | -98.21773417 | 2020-11-24 05:27:31 | Erath, Texas, US |
3193058 | 3193058 | 2020-11-22 | US | Texas | Erath | 48143 | 1390 | 19 | 0 | 1756 | 32.23602653 | -98.21773417 | 2020-11-23 05:25:26 | Erath, Texas, US |
3191675 | 3191675 | 2020-11-22 | US | Minnesota | Beltrami | 27007 | 1771 | 15 | 0 | 1756 | 47.97373527 | -94.93732139 | 2020-11-23 05:25:26 | Beltrami, Minnesota, US |
3839552 | 3839552 | 2020-11-21 | US | Texas | Erath | 48143 | 1382 | 19 | 0 | 1756 | 32.23602653 | -98.21773417 | 2020-11-22 05:25:45 | Erath, Texas, US |
2704083 | 2704083 | 2020-11-20 | US | Oklahoma | Osage | 40113 | 1774 | 18 | 0 | 1756 | 36.62888819 | -96.39635704 | 2020-11-21 05:25:51 | Osage, Oklahoma, US |
122816 | 122816 | 2020-11-18 | Mozambique | 14629 | 119 | 12754 | 1756 | -18.665695 | 35.529562 | 2020-11-19 05:25:23 | Mozambique | |||
2785488 | 2785488 | 2020-11-13 | US | Arkansas | Independence | 5063 | 1824 | 68 | 0 | 1756 | 35.74242707 | -91.57001641 | 2020-11-14 05:25:37 | Independence, Arkansas, US |
2785016 | 2785016 | 2020-11-13 | Japan | Hokkaido | 5055 | 123 | 3176 | 1756 | 43.385711 | 142.552318 | 2020-11-14 05:25:37 | Hokkaido, Japan | ||
865082 | 865082 | 2020-11-12 | Sweden | Kalmar | 1820 | 64 | 0 | 1756 | 57.235 | 16.1849 | 2020-11-13 05:25:30 | Kalmar, Sweden | ||
3440803 | 3440803 | 2020-11-11 | Italy | Molise | 2653 | 57 | 840 | 1756 | 41.55774754 | 14.65916051 | 2020-11-12 05:25:55 | Molise, Italy | ||
273967 | 273967 | 2020-11-10 | US | Mississippi | Leflore | 28083 | 1844 | 88 | 0 | 1756 | 33.55545125 | -90.29900733 | 2020-11-11 05:25:30 | Leflore, Mississippi, US |
378687 | 378687 | 2020-11-06 | US | Ohio | Tuscarawas | 39157 | 1800 | 44 | 0 | 1756 | 40.44214695 | -81.47226262 | 2020-11-07 05:24:52 | Tuscarawas, Ohio, US |
3411496 | 3411496 | 2020-11-01 | US | Nebraska | Dodge | 31053 | 1776 | 20 | 0 | 1756 | 41.58071748 | -96.65598179 | 2020-11-02 05:25:04 | Dodge, Nebraska, US |
2082443 | 2082443 | 2020-10-31 | US | Ohio | Wayne | 39169 | 1823 | 67 | 0 | 1756 | 40.82925852 | -81.88844833 | 2020-11-01 04:36:19 | Wayne, Ohio, US |
3651919 | 3651919 | 2020-10-24 | US | Alabama | Coffee | 1031 | 1767 | 11 | 0 | 1756 | 31.39932826 | -85.98901039 | 2020-10-25 04:24:36 | Coffee, Alabama, US |
3993198 | 3993198 | 2020-10-20 | US | Oklahoma | Wagoner | 40145 | 1783 | 27 | 0 | 1756 | 35.96024096 | -95.51911308 | 2020-10-21 04:24:14 | Wagoner, Oklahoma, US |
1794833 | 1794833 | 2020-10-19 | Russia | Karelia Republic | 5250 | 38 | 3456 | 1756 | 62.61940309999999 | 33.4920267 | 2020-10-20 04:24:22 | Karelia Republic, Russia | ||
1027730 | 1027730 | 2020-10-17 | US | Kentucky | Daviess | 21059 | 1781 | 25 | 0 | 1756 | 37.73028906 | -87.09019479999998 | 2020-10-18 04:24:25 | Daviess, Kentucky, US |
787309 | 787309 | 2020-10-15 | US | Idaho | Madison | 16065 | 1758 | 2 | 0 | 1756 | 43.78141028 | -111.65384740000002 | 2020-10-16 04:24:01 | Madison, Idaho, US |
79551 | 79551 | 2020-10-14 | US | Arkansas | Crawford | 5033 | 1778 | 22 | 0 | 1756 | 35.58928601 | -94.2446814 | 2020-10-15 04:24:28 | Crawford, Arkansas, US |
3789439 | 3789439 | 2020-10-11 | US | Wisconsin | Manitowoc | 55071 | 1762 | 6 | 0 | 1756 | 44.11946801 | -87.80928853 | 2020-10-12 04:23:45 | Manitowoc, Wisconsin, US |
2690032 | 2690032 | 2020-10-08 | US | Alabama | Colbert | 1033 | 1783 | 27 | 0 | 1756 | 34.69847452 | -87.80168544 | 2020-10-09 04:23:59 | Colbert, Alabama, US |
1825107 | 1825107 | 2020-10-04 | US | North Carolina | Lincoln | 37109 | 1771 | 15 | 0 | 1756 | 35.48508185 | -81.21740317 | 2020-10-05 04:23:33 | Lincoln, North Carolina, US |
3390256 | 3390256 | 2020-10-02 | US | Georgia | Tift | 13277 | 1813 | 57 | 0 | 1756 | 31.45743864 | -83.5236119 | 2020-10-03 04:23:40 | Tift, Georgia, US |
1048470 | 1048470 | 2020-09-30 | US | Pennsylvania | Franklin | 42055 | 1806 | 50 | 0 | 1756 | 39.92956518 | -77.72157791 | 2020-10-01 04:23:42 | Franklin, Pennsylvania, 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]);