johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
156 rows where active = 1349 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1378212 | 1378212 | 2021-07-25 | Bahamas | 13781 | 274 | 12158 | 1349 | 25.025885 | -78.035889 | 2021-07-26 04:21:28 | Bahamas | |||
1329952 | 1329952 | 2021-07-24 | Bahamas | 13781 | 274 | 12158 | 1349 | 25.025885 | -78.035889 | 2021-07-25 04:22:12 | Bahamas | |||
3137256 | 3137256 | 2021-07-23 | Bahamas | 13781 | 274 | 12158 | 1349 | 25.025885 | -78.035889 | 2021-07-24 00:21:36 | Bahamas | |||
3476016 | 3476016 | 2021-07-22 | Bahamas | 13781 | 274 | 12158 | 1349 | 25.025885 | -78.035889 | 2021-07-23 04:21:29 | Bahamas | |||
3331235 | 3331235 | 2021-07-21 | Bahamas | 13781 | 274 | 12158 | 1349 | 25.025885 | -78.035889 | 2021-07-22 04:21:19 | Bahamas | |||
2765187 | 2765187 | 2021-07-01 | Russia | Tula Oblast | 42927 | 2220 | 39358 | 1349 | 53.9570701 | 37.3690909 | 2021-07-02 04:21:47 | Tula Oblast, Russia | ||
2502235 | 2502235 | 2021-05-07 | Russia | Karelia Republic | 46009 | 486 | 44174 | 1349 | 62.61940309999999 | 33.4920267 | 2021-05-08 04:21:04 | Karelia Republic, Russia | ||
645805 | 645805 | 2021-05-05 | Colombia | Narino | 54834 | 1791 | 51694 | 1349 | 1.2892 | -77.3579 | 2021-05-06 04:20:38 | Narino, Colombia | ||
3924015 | 3924015 | 2021-04-24 | Japan | Chiba | 32342 | 615 | 30378 | 1349 | 35.510141 | 140.198917 | 2021-04-25 04:20:32 | Chiba, Japan | ||
1289787 | 1289787 | 2021-03-29 | Chile | Antofagasta | 43021 | 866 | 40806 | 1349 | -23.6509 | -70.3975 | 2021-03-30 04:26:23 | Antofagasta, Chile | ||
1289751 | 1289751 | 2021-03-29 | Brazil | Piaui | 203458 | 4066 | 196853 | 1349 | -7.7183 | -42.7289 | 2021-03-30 04:26:23 | Piaui, Brazil | ||
1617431 | 1617431 | 2021-03-05 | US | Iowa | Hancock | 19081 | 1379 | 30 | 0 | 1349 | 43.08178477 | -93.73454884 | 2021-03-06 04:23:41 | Hancock, Iowa, US |
2208635 | 2208635 | 2021-03-04 | US | Illinois | Greene | 17061 | 1381 | 32 | 0 | 1349 | 39.35907414 | -90.388865 | 2021-03-05 05:26:29 | Greene, Illinois, US |
3256441 | 3256441 | 2021-03-02 | US | North Carolina | Chowan | 37041 | 1371 | 22 | 0 | 1349 | 36.12908077 | -76.60118385 | 2021-03-03 05:23:28 | Chowan, North Carolina, US |
2184428 | 2184428 | 2021-02-26 | US | Georgia | Oglethorpe | 13221 | 1376 | 27 | 0 | 1349 | 33.878629600000004 | -83.08278123 | 2021-02-27 05:22:28 | Oglethorpe, Georgia, US |
1860305 | 1860305 | 2021-02-25 | US | North Carolina | Currituck | 37053 | 1364 | 15 | 0 | 1349 | 36.36123664 | -75.95876401 | 2021-02-26 05:22:40 | Currituck, North Carolina, US |
1859155 | 1859155 | 2021-02-25 | US | Iowa | Allamakee | 19005 | 1394 | 45 | 0 | 1349 | 43.28383218 | -91.37860922 | 2021-02-26 05:22:40 | Allamakee, Iowa, US |
282150 | 282150 | 2021-02-24 | US | Missouri | Vernon | 29217 | 1388 | 39 | 0 | 1349 | 37.8457799 | -94.34127305 | 2021-02-25 05:24:57 | Vernon, Missouri, US |
281333 | 281333 | 2021-02-24 | US | Iowa | Allamakee | 19005 | 1393 | 44 | 0 | 1349 | 43.28383218 | -91.37860922 | 2021-02-25 05:24:57 | Allamakee, Iowa, US |
531856 | 531856 | 2021-02-22 | US | Iowa | Allamakee | 19005 | 1391 | 42 | 0 | 1349 | 43.28383218 | -91.37860922 | 2021-02-23 05:23:41 | Allamakee, Iowa, US |
742695 | 742695 | 2021-02-20 | US | Alabama | Macon | 1087 | 1392 | 43 | 0 | 1349 | 32.38759944 | -85.69267724 | 2021-02-21 05:24:33 | Macon, Alabama, US |
742539 | 742539 | 2021-02-20 | Russia | Murmansk Oblast | 46019 | 914 | 43756 | 1349 | 68.00004179999999 | 33.9999151 | 2021-02-21 05:24:33 | Murmansk Oblast, Russia | ||
742518 | 742518 | 2021-02-20 | Russia | Kamchatka Krai | 13223 | 118 | 11756 | 1349 | 57.1914882 | 160.03838190000005 | 2021-02-21 05:24:33 | Kamchatka Krai, Russia | ||
3604633 | 3604633 | 2021-02-17 | US | Wyoming | Carbon | 56007 | 1370 | 21 | 0 | 1349 | 41.69357844 | -106.9326084 | 2021-02-18 05:22:58 | Carbon, Wyoming, US |
3603793 | 3603793 | 2021-02-17 | US | Puerto Rico | Mayaguez | 72097 | 1349 | 0 | 0 | 1349 | 18.2013 | -67.1452 | 2021-02-18 05:22:58 | Mayaguez, Puerto Rico, US |
1338633 | 1338633 | 2021-02-15 | US | Alabama | Crenshaw | 1041 | 1400 | 51 | 0 | 1349 | 31.72941803 | -86.31593104 | 2021-02-16 05:24:38 | Crenshaw, Alabama, US |
3540055 | 3540055 | 2021-02-12 | US | Colorado | Chaffee | 8015 | 1440 | 23 | 0 | 1349 | 38.74745778 | -106.19265729999998 | 2021-02-13 05:22:12 | Chaffee, Colorado, US |
2641344 | 2641344 | 2021-02-11 | Ukraine | Kherson Oblast | 21171 | 603 | 19219 | 1349 | 46.6354 | 32.6169 | 2021-02-12 05:23:29 | Kherson Oblast, Ukraine | ||
2637560 | 2637560 | 2021-02-11 | Colombia | Caldas | 45668 | 935 | 43384 | 1349 | 5.2983 | -75.2479 | 2021-02-12 05:23:29 | Caldas, Colombia | ||
616062 | 616062 | 2021-02-08 | US | North Carolina | Yancey | 37199 | 1372 | 23 | 0 | 1349 | 35.90079156 | -82.31237181 | 2021-02-09 05:23:30 | Yancey, North Carolina, US |
793118 | 793118 | 2021-02-04 | US | Puerto Rico | Gurabo | 72063 | 1349 | 0 | 0 | 1349 | 18.266461 | -65.97970500000001 | 2021-02-05 05:22:38 | Gurabo, Puerto Rico, US |
791346 | 791346 | 2021-02-04 | US | Illinois | Clay | 17025 | 1387 | 38 | 0 | 1349 | 38.75388572 | -88.48914513 | 2021-02-05 05:22:38 | Clay, Illinois, US |
343358 | 343358 | 2021-02-03 | US | Texas | Gaines | 48165 | 608 | 37 | 0 | 1349 | 32.74055318 | -102.6353295 | 2021-02-04 05:22:26 | Gaines, Texas, US |
341238 | 341238 | 2021-02-03 | US | Illinois | Clay | 17025 | 1387 | 38 | 0 | 1349 | 38.75388572 | -88.48914513 | 2021-02-04 05:22:26 | Clay, Illinois, US |
1680151 | 1680151 | 2021-02-01 | Malaysia | Perak | 6298 | 29 | 4920 | 1349 | 4.5921 | 101.0901 | 2021-02-02 05:22:49 | Perak, Malaysia | ||
1462969 | 1462969 | 2021-01-31 | US | Texas | Shelby | 48419 | 1481 | 49 | 0 | 1349 | 31.79211404 | -94.14550696 | 2021-02-01 05:22:53 | Shelby, Texas, US |
1461692 | 1461692 | 2021-01-31 | US | Missouri | Osage | 29151 | 1359 | 10 | 0 | 1349 | 38.46036182 | -91.8613635 | 2021-02-01 05:22:53 | Osage, Missouri, US |
2212416 | 2212416 | 2021-01-30 | US | Georgia | Brantley | 13025 | 1374 | 25 | 0 | 1349 | 31.19576557 | -81.97743999 | 2021-01-31 05:22:42 | Brantley, Georgia, US |
13547 | 13547 | 2021-01-26 | US | Iowa | Lyon | 19119 | 1382 | 33 | 0 | 1349 | 43.38107862 | -96.20926845 | 2021-01-27 05:23:41 | Lyon, Iowa, US |
2571126 | 2571126 | 2021-01-25 | US | West Virginia | Boone | 54005 | 1377 | 28 | 0 | 1349 | 38.01974191 | -81.69888019 | 2021-01-26 05:22:02 | Boone, West Virginia, US |
2567873 | 2567873 | 2021-01-25 | Russia | Khakassia Republic | 20061 | 371 | 18341 | 1349 | 53.72258845 | 91.44293627 | 2021-01-26 05:22:02 | Khakassia Republic, Russia | ||
2469918 | 2469918 | 2021-01-22 | US | Texas | Houston | 48225 | 1412 | 32 | 0 | 1349 | 31.31925973 | -95.42226208 | 2021-01-23 05:22:03 | Houston, Texas, US |
240269 | 240269 | 2021-01-18 | US | Texas | Calhoun | 48057 | 1428 | 12 | 0 | 1349 | 28.47048236 | -96.61633945 | 2021-01-19 05:22:15 | Calhoun, Texas, US |
238096 | 238096 | 2021-01-18 | US | Georgia | Rabun | 13241 | 1377 | 28 | 0 | 1349 | 34.88389445 | -83.40304637 | 2021-01-19 05:22:15 | Rabun, Georgia, US |
3506386 | 3506386 | 2021-01-17 | US | Texas | Calhoun | 48057 | 1428 | 12 | 0 | 1349 | 28.47048236 | -96.61633945 | 2021-01-18 05:22:34 | Calhoun, Texas, US |
3104469 | 3104469 | 2021-01-16 | US | Texas | Calhoun | 48057 | 1428 | 12 | 0 | 1349 | 28.47048236 | -96.61633945 | 2021-01-17 05:22:17 | Calhoun, Texas, US |
3880888 | 3880888 | 2021-01-14 | US | Kansas | Nemaha | 20131 | 1398 | 49 | 0 | 1349 | 39.78345387 | -96.01392079 | 2021-01-15 05:22:24 | Nemaha, Kansas, US |
3880410 | 3880410 | 2021-01-14 | US | Georgia | Meriwether | 13199 | 1372 | 23 | 0 | 1349 | 33.04163534 | -84.68859732 | 2021-01-15 05:22:24 | Meriwether, Georgia, US |
3311175 | 3311175 | 2021-01-13 | US | Tennessee | Polk | 47139 | 1346 | 17 | 0 | 1349 | 35.12245443 | -84.52075859 | 2021-01-14 05:22:32 | Polk, Tennessee, US |
3309515 | 3309515 | 2021-01-13 | US | Kansas | Nemaha | 20131 | 1398 | 49 | 0 | 1349 | 39.78345387 | -96.01392079 | 2021-01-14 05:22:32 | Nemaha, Kansas, US |
776185 | 776185 | 2021-01-12 | US | Mississippi | Stone | 28131 | 1367 | 18 | 0 | 1349 | 30.79187949 | -89.11547539 | 2021-01-13 05:22:15 | Stone, Mississippi, US |
3900917 | 3900917 | 2021-01-09 | US | Illinois | Carroll | 17015 | 1380 | 31 | 0 | 1349 | 42.06823429 | -89.93395545 | 2021-01-10 05:22:12 | Carroll, Illinois, US |
1140127 | 1140127 | 2021-01-01 | US | Texas | Wilbarger | 48487 | 1434 | 31 | 0 | 1349 | 34.07945812 | -99.24178437 | 2021-01-02 05:22:33 | Wilbarger, Texas, US |
1012017 | 1012017 | 2020-12-30 | US | Minnesota | Hubbard | 27057 | 1386 | 37 | 0 | 1349 | 47.10778564 | -94.91693868 | 2020-12-31 05:22:49 | Hubbard, Minnesota, US |
767808 | 767808 | 2020-12-29 | US | Louisiana | Concordia | 22029 | 1386 | 37 | 0 | 1349 | 31.44817835 | -91.63814433 | 2020-12-30 05:22:34 | Concordia, Louisiana, US |
3762077 | 3762077 | 2020-12-28 | US | Arkansas | Logan | 5083 | 1360 | 11 | 0 | 1349 | 35.21413234 | -93.71951016 | 2020-12-29 05:22:37 | Logan, Arkansas, US |
3761930 | 3761930 | 2020-12-28 | US | Alabama | Cherokee | 1019 | 1372 | 23 | 0 | 1349 | 34.17805983 | -85.60638968 | 2020-12-29 05:22:37 | Cherokee, Alabama, US |
3780474 | 3780474 | 2020-12-27 | US | Oklahoma | Okfuskee | 40107 | 1364 | 15 | 0 | 1349 | 35.46485198 | -96.32639984 | 2020-12-28 05:22:06 | Okfuskee, Oklahoma, US |
3778635 | 3778635 | 2020-12-27 | US | Florida | Union | 12125 | 1414 | 65 | 0 | 1349 | 30.04412971 | -82.37497443 | 2020-12-28 05:22:06 | Union, Florida, US |
203929 | 203929 | 2020-12-25 | US | Michigan | Sanilac | 26151 | 1404 | 55 | 0 | 1349 | 43.42406072 | -82.82055898 | 2020-12-26 05:22:28 | Sanilac, Michigan, US |
3693152 | 3693152 | 2020-12-24 | US | Michigan | Sanilac | 26151 | 1404 | 55 | 0 | 1349 | 43.42406072 | -82.82055898 | 2020-12-25 05:22:48 | Sanilac, Michigan, US |
2408504 | 2408504 | 2020-12-23 | US | Michigan | Sanilac | 26151 | 1404 | 55 | 0 | 1349 | 43.42406072 | -82.82055898 | 2020-12-24 05:23:04 | Sanilac, Michigan, US |
848183 | 848183 | 2020-12-12 | US | Oregon | Klamath | 41035 | 1360 | 11 | 0 | 1349 | 42.68762984 | -121.64964609999998 | 2020-12-13 05:27:20 | Klamath, Oregon, US |
1600955 | 1600955 | 2020-12-10 | US | Georgia | Appling | 13001 | 1391 | 42 | 0 | 1349 | 31.74847232 | -82.28909114 | 2020-12-11 05:26:59 | Appling, Georgia, US |
1600414 | 1600414 | 2020-12-10 | Russia | Ingushetia Republic | 10304 | 120 | 8835 | 1349 | 43.11542075 | 45.01713552 | 2020-12-11 05:26:59 | Ingushetia Republic, Russia | ||
2976309 | 2976309 | 2020-12-09 | US | Indiana | Greene | 18055 | 1404 | 55 | 0 | 1349 | 39.03630547 | -86.96223202 | 2020-12-10 05:26:19 | Greene, Indiana, US |
1819047 | 1819047 | 2020-12-08 | Russia | Voronezh Oblast | 37331 | 730 | 35252 | 1349 | 50.9800393 | 40.15065070000001 | 2020-12-09 05:28:01 | Voronezh Oblast, Russia | ||
3863067 | 3863067 | 2020-12-04 | US | Texas | Waller | 48473 | 1281 | 19 | 0 | 1349 | 30.01058447 | -95.99011759 | 2020-12-05 05:27:36 | Waller, Texas, US |
75980 | 75980 | 2020-12-03 | US | Georgia | White | 13311 | 1377 | 28 | 0 | 1349 | 34.64624278 | -83.74905525 | 2020-12-04 05:27:27 | White, Georgia, US |
2538874 | 2538874 | 2020-12-01 | US | Louisiana | Beauregard | 22011 | 1399 | 50 | 0 | 1349 | 30.64836518 | -93.34173616 | 2020-12-02 05:27:41 | Beauregard, Louisiana, US |
1587002 | 1587002 | 2020-11-30 | US | South Dakota | Bon Homme | 46009 | 1363 | 14 | 0 | 1349 | 42.98914167 | -97.88592746 | 2020-12-01 05:26:18 | Bon Homme, South Dakota, US |
2936923 | 2936923 | 2020-11-28 | US | Minnesota | Brown | 27015 | 1364 | 15 | 0 | 1349 | 44.24205652 | -94.72562874 | 2020-11-29 05:25:55 | Brown, Minnesota, US |
393676 | 393676 | 2020-11-27 | US | Kentucky | Muhlenberg | 21177 | 1368 | 19 | 0 | 1349 | 37.21425819 | -87.14632053 | 2020-11-28 05:25:50 | Muhlenberg, Kentucky, US |
3189902 | 3189902 | 2020-11-22 | Germany | Mecklenburg-Vorpommern | 5154 | 53 | 3790 | 1349 | 53.6127 | 12.4296 | 2020-11-23 05:25:26 | Mecklenburg-Vorpommern, Germany | ||
2704280 | 2704280 | 2020-11-20 | US | Puerto Rico | Toa Alta | 72135 | 1349 | 0 | 0 | 1349 | 18.362406 | -66.246616 | 2020-11-21 05:25:51 | Toa Alta, Puerto Rico, US |
823717 | 823717 | 2020-11-19 | US | New Hampshire | Merrimack | 33013 | 1383 | 34 | 0 | 1349 | 43.29662971 | -71.6811573 | 2020-11-20 05:26:28 | Merrimack, New Hampshire, US |
123936 | 123936 | 2020-11-18 | US | Iowa | Tama | 19171 | 1388 | 39 | 0 | 1349 | 42.07991767 | -92.53266945 | 2020-11-19 05:25:23 | Tama, Iowa, US |
3170425 | 3170425 | 2020-11-16 | US | Georgia | Emanuel | 13107 | 1395 | 46 | 0 | 1349 | 32.59221302 | -82.30239915 | 2020-11-17 05:25:54 | Emanuel, Georgia, US |
3170093 | 3170093 | 2020-11-16 | US | Arkansas | Boone | 5009 | 1389 | 40 | 0 | 1349 | 36.3084504 | -93.09374925 | 2020-11-17 05:25:54 | Boone, Arkansas, US |
2917985 | 2917985 | 2020-11-14 | US | South Carolina | Colleton | 45029 | 1398 | 49 | 0 | 1349 | 32.87582989 | -80.67641292 | 2020-11-15 05:26:53 | Colleton, South Carolina, US |
2916173 | 2916173 | 2020-11-14 | US | Illinois | Jefferson | 17081 | 1405 | 56 | 0 | 1349 | 38.29980057 | -88.9240025 | 2020-11-15 05:26:53 | Jefferson, Illinois, US |
3444342 | 3444342 | 2020-11-11 | US | Wisconsin | Door | 55029 | 1359 | 10 | 0 | 1349 | 44.95856458 | -87.30002707 | 2020-11-12 05:25:55 | Door, Wisconsin, US |
3443483 | 3443483 | 2020-11-11 | US | Pennsylvania | Lawrence | 42073 | 1395 | 46 | 0 | 1349 | 40.99206278 | -80.33393706 | 2020-11-12 05:25:55 | Lawrence, Pennsylvania, US |
273131 | 273131 | 2020-11-10 | US | Illinois | Franklin | 17055 | 1363 | 14 | 0 | 1349 | 37.99189086 | -88.92567818 | 2020-11-11 05:25:30 | Franklin, Illinois, US |
1990471 | 1990471 | 2020-11-09 | US | Mississippi | Tate | 28137 | 1389 | 40 | 0 | 1349 | 34.65133709 | -89.94485778 | 2020-11-10 05:40:07 | Tate, Mississippi, US |
1990125 | 1990125 | 2020-11-09 | US | Louisiana | Franklin | 22041 | 1401 | 52 | 0 | 1349 | 32.13675181 | -91.67589857 | 2020-11-10 05:40:07 | Franklin, Louisiana, US |
1731287 | 1731287 | 2020-11-08 | US | South Carolina | Dillon | 45033 | 1397 | 48 | 0 | 1349 | 34.39007791 | -79.37741872 | 2020-11-09 05:25:45 | Dillon, South Carolina, US |
1729307 | 1729307 | 2020-11-08 | US | Georgia | Liberty | 13179 | 1375 | 26 | 0 | 1349 | 31.82588896 | -81.49251135 | 2020-11-09 05:25:45 | Liberty, Georgia, US |
379119 | 379119 | 2020-11-06 | US | Tennessee | Hawkins | 47073 | 1380 | 30 | 0 | 1349 | 36.44355426 | -82.94885298 | 2020-11-07 05:24:52 | Hawkins, Tennessee, US |
754693 | 754693 | 2020-10-28 | US | Alabama | Pike | 1109 | 1363 | 14 | 0 | 1349 | 31.80396383 | -85.9408295 | 2020-10-29 04:24:49 | Pike, Alabama, US |
1453754 | 1453754 | 2020-10-27 | US | Iowa | Crawford | 19047 | 1363 | 14 | 0 | 1349 | 42.03718237 | -95.3819718 | 2020-10-28 04:24:39 | Crawford, Iowa, US |
10642 | 10642 | 2020-10-25 | US | North Carolina | Halifax | 37083 | 1376 | 27 | 0 | 1349 | 36.25669272 | -77.6556109 | 2020-10-26 04:25:02 | Halifax, North Carolina, US |
8517 | 8517 | 2020-10-25 | Russia | Belgorod Oblast | 10947 | 61 | 9537 | 1349 | 50.7080119 | 37.5837615 | 2020-10-26 04:25:02 | Belgorod Oblast, Russia | ||
1055037 | 1055037 | 2020-10-23 | US | Iowa | Muscatine | 19139 | 1407 | 58 | 0 | 1349 | 41.48370744 | -91.1121697 | 2020-10-24 04:24:46 | Muscatine, Iowa, US |
1794724 | 1794724 | 2020-10-19 | Mexico | Queretaro | 11641 | 1109 | 9183 | 1349 | 20.5888 | -100.3899 | 2020-10-20 04:24:22 | Queretaro, Mexico | ||
764833 | 764833 | 2020-10-18 | US | Oklahoma | Bryan | 40013 | 1360 | 11 | 0 | 1349 | 33.96472458 | -96.25903472 | 2020-10-19 04:24:16 | Bryan, Oklahoma, US |
3785138 | 3785138 | 2020-10-13 | US | Texas | Wharton | 48481 | 1394 | 55 | 0 | 1349 | 29.27765923 | -96.22319248 | 2020-10-14 04:24:05 | Wharton, Texas, US |
3783433 | 3783433 | 2020-10-13 | US | Louisiana | Webster | 22119 | 1381 | 32 | 0 | 1349 | 32.70847669 | -93.33121835 | 2020-10-14 04:24:05 | Webster, Louisiana, US |
2294678 | 2294678 | 2020-10-12 | US | Texas | Wharton | 48481 | 1393 | 55 | 0 | 1349 | 29.27765923 | -96.22319248 | 2020-10-13 04:24:02 | Wharton, Texas, US |
2293441 | 2293441 | 2020-10-12 | US | Montana | Missoula | 30063 | 1354 | 5 | 0 | 1349 | 47.03728583 | -113.92135079999998 | 2020-10-13 04:24:02 | Missoula, 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]);