johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
173 rows where active = 1334 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
408057 | 408057 | 2021-07-28 | Canada | Alberta | 233875 | 2325 | 230216 | 1334 | 53.9333 | -116.5765 | 2021-07-29 04:21:33 | Alberta, Canada | ||
579039 | 579039 | 2021-07-13 | Russia | Kamchatka Krai | 15856 | 238 | 14284 | 1334 | 57.1914882 | 160.03838190000005 | 2021-07-14 04:21:35 | Kamchatka Krai, Russia | ||
3659581 | 3659581 | 2021-07-11 | Italy | Marche | 104017 | 3038 | 99645 | 1334 | 43.61675973 | 13.5188753 | 2021-07-12 04:21:34 | Marche, Italy | ||
523076 | 523076 | 2021-06-09 | Russia | Leningrad Oblast | 46046 | 1541 | 43171 | 1334 | 60.1853296 | 32.3925325 | 2021-06-10 04:23:17 | Leningrad Oblast, Russia | ||
3149215 | 3149215 | 2021-06-07 | Ukraine | Poltava Oblast | 77195 | 1810 | 74051 | 1334 | 49.5883 | 34.5514 | 2021-06-08 04:22:35 | Poltava Oblast, Ukraine | ||
2020647 | 2020647 | 2021-04-20 | Ghana | 91709 | 771 | 89604 | 1334 | 7.9465 | -1.0232 | 2021-04-21 04:21:14 | Ghana | |||
2410768 | 2410768 | 2021-04-19 | Ghana | 91709 | 771 | 89604 | 1334 | 7.9465 | -1.0232 | 2021-04-20 04:20:41 | Ghana | |||
3129445 | 3129445 | 2021-04-18 | Ghana | 91709 | 771 | 89604 | 1334 | 7.9465 | -1.0232 | 2021-04-19 04:20:57 | Ghana | |||
2571424 | 2571424 | 2021-04-13 | Brazil | Piaui | 221617 | 4633 | 214416 | 1334 | -7.7183 | -42.7289 | 2021-04-14 04:20:41 | Piaui, Brazil | ||
1219708 | 1219708 | 2021-03-27 | Pakistan | Azad Jammu and Kashmir | 12367 | 344 | 10689 | 1334 | 34.027401 | 73.947253 | 2021-03-28 05:28:10 | Azad Jammu and Kashmir, Pakistan | ||
3669952 | 3669952 | 2021-03-06 | US | North Carolina | Madison | 37115 | 1373 | 39 | 0 | 1334 | 35.85402722 | -82.71346418 | 2021-03-07 05:21:54 | Madison, North Carolina, US |
3669319 | 3669319 | 2021-03-06 | US | Minnesota | Chippewa | 27023 | 1369 | 35 | 0 | 1334 | 45.02343421 | -95.56403693 | 2021-03-07 05:21:54 | Chippewa, Minnesota, US |
1618591 | 1618591 | 2021-03-05 | US | North Carolina | Polk | 37149 | 1361 | 27 | 0 | 1334 | 35.27820615 | -82.16812354 | 2021-03-06 04:23:41 | Polk, North Carolina, US |
1618468 | 1618468 | 2021-03-05 | US | New York | Essex | 36031 | 1360 | 26 | 0 | 1334 | 44.11630765 | -73.77297842 | 2021-03-06 04:23:41 | Essex, New York, US |
2211140 | 2211140 | 2021-03-04 | US | West Virginia | McDowell | 54047 | 1354 | 20 | 0 | 1334 | 37.38002939 | -81.65083669 | 2021-03-05 05:26:29 | McDowell, West Virginia, US |
2209356 | 2209356 | 2021-03-04 | US | Minnesota | Cottonwood | 27033 | 1354 | 20 | 0 | 1334 | 44.00715262 | -95.18138802 | 2021-03-05 05:26:29 | Cottonwood, Minnesota, US |
3256717 | 3256717 | 2021-03-02 | US | Oklahoma | Noble | 40103 | 1347 | 13 | 0 | 1334 | 36.38953329 | -97.22928674 | 2021-03-03 05:23:28 | Noble, Oklahoma, US |
1001009 | 1001009 | 2021-03-01 | US | Oklahoma | Noble | 40103 | 1347 | 13 | 0 | 1334 | 36.38953329 | -97.22928674 | 2021-03-02 05:23:30 | Noble, Oklahoma, US |
3066351 | 3066351 | 2021-02-27 | US | Alabama | Cleburne | 1029 | 1373 | 39 | 0 | 1334 | 33.67679204 | -85.52005899 | 2021-02-28 05:22:20 | Cleburne, Alabama, US |
1939972 | 1939972 | 2021-02-23 | US | Wisconsin | Buffalo | 55011 | 1341 | 7 | 0 | 1334 | 44.37835084 | -91.75332578 | 2021-02-24 05:29:16 | Buffalo, Wisconsin, US |
1938751 | 1938751 | 2021-02-23 | US | North Carolina | Currituck | 37053 | 1349 | 15 | 0 | 1334 | 36.36123664 | -75.95876401 | 2021-02-24 05:29:16 | Currituck, North Carolina, US |
534227 | 534227 | 2021-02-22 | US | Wisconsin | Buffalo | 55011 | 1341 | 7 | 0 | 1334 | 44.37835084 | -91.75332578 | 2021-02-23 05:23:41 | Buffalo, Wisconsin, US |
530968 | 530968 | 2021-02-22 | Russia | Yaroslavl Oblast | 31914 | 381 | 30199 | 1334 | 57.77819760000001 | 39.0021095 | 2021-02-23 05:23:41 | Yaroslavl Oblast, Russia | ||
185561 | 185561 | 2021-02-21 | US | Wisconsin | Buffalo | 55011 | 1341 | 7 | 0 | 1334 | 44.37835084 | -91.75332578 | 2021-02-22 05:24:21 | Buffalo, Wisconsin, US |
182058 | 182058 | 2021-02-21 | Japan | Kanagawa | 44084 | 649 | 42101 | 1334 | 35.415312 | 139.338983 | 2021-02-22 05:24:21 | Kanagawa, Japan | ||
743502 | 743502 | 2021-02-20 | US | Iowa | Hancock | 19081 | 1362 | 28 | 0 | 1334 | 43.08178477 | -93.73454884 | 2021-02-21 05:24:33 | Hancock, Iowa, US |
472600 | 472600 | 2021-02-19 | US | Iowa | Hancock | 19081 | 1362 | 28 | 0 | 1334 | 43.08178477 | -93.73454884 | 2021-02-20 05:22:51 | Hancock, Iowa, US |
1154309 | 1154309 | 2021-02-18 | US | Iowa | Hancock | 19081 | 1362 | 28 | 0 | 1334 | 43.08178477 | -93.73454884 | 2021-02-19 05:24:16 | Hancock, Iowa, US |
3600823 | 3600823 | 2021-02-17 | Chile | Antofagasta | 35413 | 711 | 33368 | 1334 | -23.6509 | -70.3975 | 2021-02-18 05:22:58 | Antofagasta, Chile | ||
3051665 | 3051665 | 2021-02-16 | US | Louisiana | Claiborne | 22027 | 1383 | 49 | 0 | 1334 | 32.82308512 | -92.99526883 | 2021-02-17 05:23:10 | Claiborne, Louisiana, US |
3051364 | 3051364 | 2021-02-16 | US | Iowa | Hancock | 19081 | 1361 | 27 | 0 | 1334 | 43.08178477 | -93.73454884 | 2021-02-17 05:23:10 | Hancock, Iowa, US |
1339764 | 1339764 | 2021-02-15 | US | Louisiana | Claiborne | 22027 | 1383 | 49 | 0 | 1334 | 32.82308512 | -92.99526883 | 2021-02-16 05:24:38 | Claiborne, Louisiana, US |
2285648 | 2285648 | 2021-02-14 | US | New York | Delaware | 36025 | 1365 | 31 | 0 | 1334 | 42.19837623 | -74.96709306 | 2021-02-15 05:24:49 | Delaware, New York, US |
2285393 | 2285393 | 2021-02-14 | US | Missouri | Vernon | 29217 | 1368 | 34 | 0 | 1334 | 37.8457799 | -94.34127305 | 2021-02-15 05:24:49 | Vernon, Missouri, US |
2284858 | 2284858 | 2021-02-14 | US | Kentucky | Mason | 21161 | 1360 | 26 | 0 | 1334 | 38.59471935 | -83.82151043 | 2021-02-15 05:24:49 | Mason, Kentucky, US |
2284576 | 2284576 | 2021-02-14 | US | Iowa | Allamakee | 19005 | 1375 | 41 | 0 | 1334 | 43.28383218 | -91.37860922 | 2021-02-15 05:24:49 | Allamakee, Iowa, US |
2679793 | 2679793 | 2021-02-13 | US | Missouri | Vernon | 29217 | 1368 | 34 | 0 | 1334 | 37.8457799 | -94.34127305 | 2021-02-14 05:23:43 | Vernon, Missouri, US |
2679220 | 2679220 | 2021-02-13 | US | Kentucky | Garrard | 21079 | 1342 | 8 | 0 | 1334 | 37.6388668 | -84.53289319 | 2021-02-14 05:23:43 | Garrard, Kentucky, US |
3542120 | 3542120 | 2021-02-12 | US | Pennsylvania | Forest | 42053 | 1353 | 19 | 0 | 1334 | 41.51095103 | -79.23229292 | 2021-02-13 05:22:12 | Forest, Pennsylvania, US |
2639695 | 2639695 | 2021-02-11 | US | Missouri | Wright | 29229 | 1360 | 26 | 0 | 1334 | 37.27029221 | -92.46914488 | 2021-02-12 05:23:29 | Wright, Missouri, US |
2639211 | 2639211 | 2021-02-11 | US | Louisiana | Claiborne | 22027 | 1383 | 49 | 0 | 1334 | 32.82308512 | -92.99526883 | 2021-02-12 05:23:29 | Claiborne, Louisiana, US |
978101 | 978101 | 2021-02-06 | US | Texas | Panola | 48365 | 1640 | 55 | 0 | 1334 | 32.163959600000005 | -94.30552481 | 2021-02-07 05:23:00 | Panola, Texas, US |
1589291 | 1589291 | 2021-02-05 | US | Indiana | Parke | 18121 | 1347 | 13 | 0 | 1334 | 39.77202286 | -87.20375833 | 2021-02-06 05:23:55 | Parke, Indiana, US |
791498 | 791498 | 2021-02-04 | US | Indiana | Parke | 18121 | 1347 | 13 | 0 | 1334 | 39.77202286 | -87.20375833 | 2021-02-05 05:22:38 | Parke, Indiana, US |
1687243 | 1687243 | 2021-02-02 | US | Puerto Rico | Juncos | 72077 | 1334 | 0 | 0 | 1334 | 18.223793 | -65.909109 | 2021-02-03 05:22:52 | Juncos, Puerto Rico, US |
1459549 | 1459549 | 2021-01-31 | Chile | Los Rios | 14729 | 161 | 13234 | 1334 | -40.231 | -72.3311 | 2021-02-01 05:22:53 | Los Rios, Chile | ||
2214228 | 2214228 | 2021-01-30 | US | Oklahoma | Love | 40085 | 1342 | 8 | 0 | 1334 | 33.95273467 | -97.23906784 | 2021-01-31 05:22:42 | Love, Oklahoma, US |
2212630 | 2212630 | 2021-01-30 | US | Illinois | Clay | 17025 | 1372 | 38 | 0 | 1334 | 38.75388572 | -88.48914513 | 2021-01-31 05:22:42 | Clay, Illinois, US |
1898117 | 1898117 | 2021-01-29 | US | Illinois | Clay | 17025 | 1370 | 36 | 0 | 1334 | 38.75388572 | -88.48914513 | 2021-01-30 05:22:49 | Clay, Illinois, US |
2485443 | 2485443 | 2021-01-28 | US | West Virginia | Hampshire | 54027 | 1362 | 28 | 0 | 1334 | 39.32103553 | -78.60826476 | 2021-01-29 05:22:23 | Hampshire, West Virginia, US |
13962 | 13962 | 2021-01-26 | US | Michigan | Emmet | 26047 | 1369 | 35 | 0 | 1334 | 45.52625509 | -84.89083249 | 2021-01-27 05:23:41 | Emmet, Michigan, US |
13703 | 13703 | 2021-01-26 | US | Kentucky | Bourbon | 21017 | 1337 | 3 | 0 | 1334 | 38.2054607 | -84.21827874 | 2021-01-27 05:23:41 | Bourbon, Kentucky, US |
3505887 | 3505887 | 2021-01-17 | US | Oklahoma | Choctaw | 40023 | 1342 | 8 | 0 | 1334 | 34.02807439 | -95.54771129 | 2021-01-18 05:22:34 | Choctaw, Oklahoma, US |
3505062 | 3505062 | 2021-01-17 | US | Minnesota | Dodge | 27039 | 1338 | 4 | 0 | 1334 | 44.02238415 | -92.86244324 | 2021-01-18 05:22:34 | Dodge, Minnesota, US |
777900 | 777900 | 2021-01-12 | US | Wisconsin | Marquette | 55077 | 1359 | 25 | 0 | 1334 | 43.81911946 | -89.40073763 | 2021-01-13 05:22:15 | Marquette, Wisconsin, US |
776627 | 776627 | 2021-01-12 | US | North Carolina | Bertie | 37015 | 1361 | 27 | 0 | 1334 | 36.0688473 | -76.96545943 | 2021-01-13 05:22:15 | Bertie, North Carolina, US |
775187 | 775187 | 2021-01-12 | US | Georgia | Morgan | 13211 | 1344 | 10 | 0 | 1334 | 33.59232073 | -83.49129491 | 2021-01-13 05:22:15 | Morgan, Georgia, US |
193195 | 193195 | 2021-01-11 | US | Texas | Karnes | 48255 | 1393 | 24 | 0 | 1334 | 28.90705334 | -97.85960149 | 2021-01-12 05:22:15 | Karnes, Texas, US |
2628998 | 2628998 | 2021-01-10 | US | Texas | Karnes | 48255 | 1393 | 24 | 0 | 1334 | 28.90705334 | -97.85960149 | 2021-01-11 05:21:50 | Karnes, Texas, US |
2626099 | 2626099 | 2021-01-10 | Russia | North Ossetia - Alania Republic | 12849 | 101 | 11414 | 1334 | 42.79336110000001 | 44.6324493 | 2021-01-11 05:21:50 | North Ossetia - Alania Republic, Russia | ||
3903086 | 3903086 | 2021-01-09 | US | Texas | Karnes | 48255 | 1393 | 24 | 0 | 1334 | 28.90705334 | -97.85960149 | 2021-01-10 05:22:12 | Karnes, Texas, US |
3902748 | 3902748 | 2021-01-09 | US | South Carolina | Abbeville | 45001 | 1360 | 26 | 0 | 1334 | 34.22333378 | -82.46170658 | 2021-01-10 05:22:12 | Abbeville, South Carolina, US |
2541860 | 2541860 | 2021-01-07 | US | Arkansas | Ashley | 5003 | 1355 | 21 | 0 | 1334 | 33.19153461 | -91.7698471 | 2021-01-08 05:22:42 | Ashley, Arkansas, US |
2541541 | 2541541 | 2021-01-07 | Niger | 3706 | 119 | 2253 | 1334 | 17.607789 | 8.081666 | 2021-01-08 05:22:42 | Niger | |||
1063321 | 1063321 | 2021-01-04 | US | Kentucky | Woodford | 21239 | 1335 | 1 | 0 | 1334 | 38.04178222 | -84.7417556 | 2021-01-05 05:21:49 | Woodford, Kentucky, US |
1139550 | 1139550 | 2021-01-01 | US | Pennsylvania | Juniata | 42067 | 1382 | 48 | 0 | 1334 | 40.53358749 | -77.39975129999998 | 2021-01-02 05:22:33 | Juniata, Pennsylvania, US |
1139128 | 1139128 | 2021-01-01 | US | New York | Orleans | 36073 | 1397 | 63 | 0 | 1334 | 43.2516977 | -78.2320066 | 2021-01-02 05:22:33 | Orleans, New York, US |
1013548 | 1013548 | 2020-12-30 | US | Texas | Wilbarger | 48487 | 1407 | 31 | 0 | 1334 | 34.07945812 | -99.24178437 | 2020-12-31 05:22:49 | Wilbarger, Texas, US |
769484 | 769484 | 2020-12-29 | US | Texas | Milam | 48331 | 864 | 11 | 0 | 1334 | 30.785818300000006 | -96.97718698 | 2020-12-30 05:22:34 | Milam, Texas, US |
3762096 | 3762096 | 2020-12-28 | US | Arkansas | Randolph | 5121 | 1373 | 39 | 0 | 1334 | 36.3415714 | -91.02455531 | 2020-12-29 05:22:37 | Randolph, Arkansas, US |
2226079 | 2226079 | 2020-12-26 | US | Oklahoma | Okfuskee | 40107 | 1349 | 15 | 0 | 1334 | 35.46485198 | -96.32639984 | 2020-12-27 05:22:55 | Okfuskee, Oklahoma, US |
204270 | 204270 | 2020-12-25 | US | Montana | Roosevelt | 30085 | 1376 | 42 | 0 | 1334 | 48.29607488 | -105.0079268 | 2020-12-26 05:22:28 | Roosevelt, Montana, US |
203968 | 203968 | 2020-12-25 | US | Minnesota | Hubbard | 27057 | 1370 | 36 | 0 | 1334 | 47.10778564 | -94.91693868 | 2020-12-26 05:22:28 | Hubbard, Minnesota, US |
3694831 | 3694831 | 2020-12-24 | US | Virginia | Lee | 51105 | 1362 | 28 | 0 | 1334 | 36.70586667 | -83.12606515 | 2020-12-25 05:22:48 | Lee, Virginia, US |
3693493 | 3693493 | 2020-12-24 | US | Montana | Roosevelt | 30085 | 1376 | 42 | 0 | 1334 | 48.29607488 | -105.0079268 | 2020-12-25 05:22:48 | Roosevelt, Montana, US |
3693191 | 3693191 | 2020-12-24 | US | Minnesota | Hubbard | 27057 | 1370 | 36 | 0 | 1334 | 47.10778564 | -94.91693868 | 2020-12-25 05:22:48 | Hubbard, Minnesota, US |
3692668 | 3692668 | 2020-12-24 | US | Iowa | Harrison | 19085 | 1386 | 52 | 0 | 1334 | 41.68330137 | -95.81558439 | 2020-12-25 05:22:48 | Harrison, Iowa, US |
930367 | 930367 | 2020-12-21 | US | Pennsylvania | McKean | 42083 | 1346 | 12 | 0 | 1334 | 41.80938602 | -78.56478358 | 2020-12-22 05:22:33 | McKean, Pennsylvania, US |
929651 | 929651 | 2020-12-21 | US | Missouri | Ste. Genevieve | 29186 | 1336 | 2 | 0 | 1334 | 37.89090059 | -90.1949941 | 2020-12-22 05:22:33 | Ste. Genevieve, Missouri, US |
2121910 | 2121910 | 2020-12-20 | US | New Mexico | Roosevelt | 35041 | 1355 | 21 | 0 | 1334 | 34.02097406 | -103.4799493 | 2020-12-21 05:27:58 | Roosevelt, New Mexico, US |
2932621 | 2932621 | 2020-12-19 | US | Kentucky | Harlan | 21095 | 1350 | 16 | 0 | 1334 | 36.85699301 | -83.21899516 | 2020-12-20 05:27:32 | Harlan, Kentucky, US |
1903093 | 1903093 | 2020-12-18 | US | Missouri | Morgan | 29141 | 1350 | 16 | 0 | 1334 | 38.4181765 | -92.88791859 | 2020-12-19 05:27:52 | Morgan, Missouri, US |
2129149 | 2129149 | 2020-12-17 | US | Iowa | Buchanan | 19019 | 1349 | 15 | 0 | 1334 | 42.4709188 | -91.83510825 | 2020-12-18 05:28:18 | Buchanan, Iowa, US |
846602 | 846602 | 2020-12-12 | US | Illinois | Saline | 17165 | 1360 | 26 | 0 | 1334 | 37.75332999 | -88.54119706 | 2020-12-13 05:27:20 | Saline, Illinois, US |
862559 | 862559 | 2020-12-11 | US | Missouri | Crawford | 29055 | 1348 | 14 | 0 | 1334 | 37.97663738 | -91.30528104 | 2020-12-12 05:26:19 | Crawford, Missouri, US |
1602101 | 1602101 | 2020-12-10 | US | Missouri | Crawford | 29055 | 1348 | 14 | 0 | 1334 | 37.97663738 | -91.30528104 | 2020-12-11 05:26:59 | Crawford, Missouri, US |
1601084 | 1601084 | 2020-12-10 | US | Georgia | Sumter | 13261 | 1406 | 72 | 0 | 1334 | 32.03650571 | -84.19821492 | 2020-12-11 05:26:59 | Sumter, Georgia, US |
1819524 | 1819524 | 2020-12-08 | US | Georgia | Appling | 13001 | 1376 | 42 | 0 | 1334 | 31.74847232 | -82.28909114 | 2020-12-09 05:28:01 | Appling, Georgia, US |
2349086 | 2349086 | 2020-12-07 | US | Michigan | Oceana | 26127 | 1362 | 28 | 0 | 1334 | 43.64124435 | -86.26726673 | 2020-12-08 05:27:42 | Oceana, Michigan, US |
1007540 | 1007540 | 2020-12-06 | US | Iowa | Wright | 19197 | 1342 | 8 | 0 | 1334 | 42.73305373 | -93.73515113 | 2020-12-07 05:26:14 | Wright, Iowa, US |
3861618 | 3861618 | 2020-12-04 | US | Mississippi | Covington | 28031 | 1376 | 42 | 0 | 1334 | 31.63225413 | -89.55389939 | 2020-12-05 05:27:36 | Covington, Mississippi, US |
77890 | 77890 | 2020-12-03 | US | South Carolina | Clarendon | 45027 | 1404 | 70 | 0 | 1334 | 33.66610974 | -80.21647898 | 2020-12-04 05:27:27 | Clarendon, South Carolina, US |
76207 | 76207 | 2020-12-03 | US | Indiana | Posey | 18129 | 1357 | 23 | 0 | 1334 | 38.02097333 | -87.86480429 | 2020-12-04 05:27:27 | Posey, Indiana, US |
741875 | 741875 | 2020-12-02 | US | Wisconsin | Taylor | 55119 | 1348 | 14 | 0 | 1334 | 45.21179252 | -90.5004405 | 2020-12-03 05:28:22 | Taylor, Wisconsin, US |
2539675 | 2539675 | 2020-12-01 | US | North Carolina | Bladen | 37017 | 1353 | 19 | 0 | 1334 | 34.61296243 | -78.56180059 | 2020-12-02 05:27:41 | Bladen, North Carolina, US |
2539047 | 2539047 | 2020-12-01 | US | Michigan | Menominee | 26109 | 1352 | 18 | 0 | 1334 | 45.58038692 | -87.55370409 | 2020-12-02 05:27:41 | Menominee, Michigan, US |
3567187 | 3567187 | 2020-11-29 | US | Colorado | La Plata | 8067 | 1633 | 17 | 0 | 1334 | 37.28632032 | -107.8429014 | 2020-11-30 05:26:13 | La Plata, Colorado, US |
2936202 | 2936202 | 2020-11-28 | US | Illinois | Douglas | 17041 | 1347 | 13 | 0 | 1334 | 39.76768052 | -88.21854195 | 2020-11-29 05:25:55 | Douglas, Illinois, US |
681133 | 681133 | 2020-11-23 | US | South Carolina | Marlboro | 45069 | 1350 | 16 | 0 | 1334 | 34.59905577 | -79.67561152 | 2020-11-24 05:27:31 | Marlboro, South Carolina, US |
679829 | 679829 | 2020-11-23 | US | Louisiana | Sabine | 22085 | 1353 | 19 | 0 | 1334 | 31.56388699 | -93.55433981 | 2020-11-24 05:27:31 | Sabine, Louisiana, 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]);