johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,017 rows where active = 174 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
- US 901
- Japan 23
- Germany 9
- India 8
- Russia 8
- Chile 5
- France 5
- Ukraine 5
- Colombia 4
- Italy 4
- Canada 3
- China 3
- Malaysia 3
- Netherlands 3
- Cyprus 2
- Eritrea 2
- Iceland 2
- Latvia 2
- Liechtenstein 2
- Mexico 2
- Sao Tome and Principe 2
- Cote d'Ivoire 1
- Cuba 1
- Estonia 1
- Finland 1
- Moldova 1
- Monaco 1
- Niger 1
- Pakistan 1
- San Marino 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3683473 | 3683473 | 2021-08-02 | Japan | Mie | 5831 | 114 | 5543 | 174 | 34.508018 | 136.376013 | 2021-08-03 04:21:39 | Mie, Japan | ||
3018972 | 3018972 | 2021-08-01 | Ukraine | Chernivtsi Oblast | 80189 | 1798 | 78217 | 174 | 48.2917 | 25.9352 | 2021-08-02 04:21:36 | Chernivtsi Oblast, Ukraine | ||
3385697 | 3385697 | 2021-07-29 | Summer Olympics 2020 | 174 | 0 | 0 | 174 | 35.6491 | 139.7737 | 2021-07-30 04:21:34 | Summer Olympics 2020 | |||
1306197 | 1306197 | 2021-07-27 | Japan | Tottori | 672 | 2 | 496 | 174 | 35.359069 | 133.863619 | 2021-07-28 04:21:39 | Tottori, Japan | ||
1305938 | 1305938 | 2021-07-27 | Chile | Arica y Parinacota | 26269 | 500 | 25595 | 174 | -18.594 | -69.4785 | 2021-07-28 04:21:39 | Arica y Parinacota, Chile | ||
3218212 | 3218212 | 2021-07-26 | Germany | Mecklenburg-Vorpommern | 44325 | 1176 | 42980 | 174 | 53.6127 | 12.4296 | 2021-07-27 04:21:18 | Mecklenburg-Vorpommern, Germany | ||
3218081 | 3218081 | 2021-07-26 | Chile | Arica y Parinacota | 26256 | 500 | 25582 | 174 | -18.594 | -69.4785 | 2021-07-27 04:21:18 | Arica y Parinacota, Chile | ||
3331537 | 3331537 | 2021-07-21 | Japan | Fukushima | 5228 | 162 | 4892 | 174 | 37.378867 | 140.223295 | 2021-07-22 04:21:19 | Fukushima, Japan | ||
483579 | 483579 | 2021-07-19 | Italy | P.A. Bolzano | 73506 | 1182 | 72150 | 174 | 46.49933453 | 11.35662422 | 2021-07-20 04:21:48 | P.A. Bolzano, Italy | ||
1495522 | 1495522 | 2021-07-03 | Germany | Sachsen-Anhalt | 99243 | 3428 | 95680 | 174 | 51.9503 | 11.6923 | 2021-07-04 04:21:38 | Sachsen-Anhalt, Germany | ||
2764938 | 2764938 | 2021-07-01 | Japan | Fukui | 1300 | 35 | 1091 | 174 | 35.846614 | 136.22465400000002 | 2021-07-02 04:21:47 | Fukui, Japan | ||
2589987 | 2589987 | 2021-06-27 | Italy | Liguria | 103406 | 4350 | 98882 | 174 | 44.41149315 | 8.9326992 | 2021-06-28 04:21:29 | Liguria, Italy | ||
3970763 | 3970763 | 2021-06-11 | Russia | Komi Republic | 44539 | 968 | 43397 | 174 | 63.9881421 | 54.3326073 | 2021-06-12 04:22:22 | Komi Republic, Russia | ||
3472304 | 3472304 | 2021-06-08 | Japan | Fukushima | 4662 | 153 | 4335 | 174 | 37.378867 | 140.223295 | 2021-06-09 04:23:31 | Fukushima, Japan | ||
1188929 | 1188929 | 2021-05-31 | Russia | Altai Republic | 17064 | 247 | 16643 | 174 | 50.7114101 | 86.8572186 | 2021-06-01 04:23:09 | Altai Republic, Russia | ||
1310184 | 1310184 | 2021-05-26 | Japan | Iwate | 1380 | 43 | 1163 | 174 | 39.593287 | 141.361777 | 2021-05-27 04:20:59 | Iwate, Japan | ||
1872957 | 1872957 | 2021-05-15 | Japan | Akita | 684 | 9 | 501 | 174 | 39.748679 | 140.408228 | 2021-05-16 04:20:49 | Akita, Japan | ||
2820962 | 2820962 | 2021-05-10 | Russia | Chechen Republic | 12094 | 128 | 11792 | 174 | 43.39761470000001 | 45.6985005 | 2021-05-11 04:20:41 | Chechen Republic, Russia | ||
1424961 | 1424961 | 2021-05-09 | Colombia | San Andres y Providencia | 4078 | 59 | 3845 | 174 | 12.5567 | -81.7185 | 2021-05-10 04:20:38 | San Andres y Providencia, Colombia | ||
2760854 | 2760854 | 2021-05-03 | Iceland | 6483 | 29 | 6280 | 174 | 64.9631 | -19.0208 | 2021-05-04 04:20:34 | Iceland | |||
2450787 | 2450787 | 2021-05-02 | Japan | Iwate | 970 | 32 | 764 | 174 | 39.593287 | 141.361777 | 2021-05-03 04:20:39 | Iwate, Japan | ||
1636432 | 1636432 | 2021-04-29 | Netherlands | Aruba | 10608 | 98 | 10336 | 174 | 12.5211 | -69.9683 | 2021-04-30 04:21:03 | Aruba, Netherlands | ||
1636378 | 1636378 | 2021-04-29 | Liechtenstein | 3011 | 56 | 2781 | 174 | 47.14 | 9.55 | 2021-04-30 04:21:03 | Liechtenstein | |||
3393457 | 3393457 | 2021-04-28 | Liechtenstein | 3004 | 56 | 2774 | 174 | 47.14 | 9.55 | 2021-04-29 04:20:55 | Liechtenstein | |||
888402 | 888402 | 2021-04-26 | South Sudan | 10538 | 114 | 10250 | 174 | 6.877000000000002 | 31.307 | 2021-04-27 04:20:52 | South Sudan | |||
2020743 | 2020743 | 2021-04-20 | Japan | Kumamoto | 3700 | 76 | 3450 | 174 | 32.608154 | 130.74523100000002 | 2021-04-21 04:21:14 | Kumamoto, Japan | ||
3129712 | 3129712 | 2021-04-18 | Russia | Chechen Republic | 11864 | 118 | 11572 | 174 | 43.39761470000001 | 45.6985005 | 2021-04-19 04:20:57 | Chechen Republic, Russia | ||
1842136 | 1842136 | 2021-04-14 | Russia | Chechen Republic | 11822 | 118 | 11530 | 174 | 43.39761470000001 | 45.6985005 | 2021-04-15 04:20:54 | Chechen Republic, Russia | ||
2571639 | 2571639 | 2021-04-13 | India | Nagaland | 12427 | 93 | 12160 | 174 | 26.06702 | 94.470302 | 2021-04-14 04:20:41 | Nagaland, India | ||
3883611 | 3883611 | 2021-04-11 | Japan | Mie | 2993 | 73 | 2746 | 174 | 34.508018 | 136.376013 | 2021-04-12 04:21:00 | Mie, Japan | ||
605711 | 605711 | 2021-04-09 | Japan | Mie | 2941 | 72 | 2695 | 174 | 34.508018 | 136.376013 | 2021-04-10 04:20:59 | Mie, Japan | ||
3085110 | 3085110 | 2021-04-05 | China | Hong Kong | 11524 | 205 | 11145 | 174 | 22.3 | 114.2 | 2021-04-06 04:20:32 | Hong Kong, China | ||
1289816 | 1289816 | 2021-03-29 | China | Hong Kong | 11454 | 205 | 11075 | 174 | 22.3 | 114.2 | 2021-03-30 04:26:23 | Hong Kong, China | ||
2781033 | 2781033 | 2021-03-24 | Japan | Tochigi | 4467 | 70 | 4223 | 174 | 36.689912 | 139.819213 | 2021-03-25 05:27:00 | Tochigi, Japan | ||
1732630 | 1732630 | 2021-03-14 | Niger | 4860 | 182 | 4504 | 174 | 17.607789 | 8.081666 | 2021-03-15 05:25:51 | Niger | |||
1580261 | 1580261 | 2021-03-13 | Monaco | 2106 | 27 | 1905 | 174 | 43.7333 | 7.4167 | 2021-03-14 05:25:37 | Monaco | |||
1090191 | 1090191 | 2021-03-03 | Netherlands | Aruba | 7973 | 75 | 7724 | 174 | 12.5211 | -69.9683 | 2021-03-04 05:24:24 | Aruba, Netherlands | ||
3254109 | 3254109 | 2021-03-02 | India | Puducherry | 39763 | 669 | 38920 | 174 | 11.882658 | 78.86498 | 2021-03-03 05:23:28 | Puducherry, India | ||
1000498 | 1000498 | 2021-03-01 | US | Nebraska | Dundy | 31057 | 178 | 4 | 0 | 174 | 40.17638677 | -101.6876522 | 2021-03-02 05:23:30 | Dundy, Nebraska, US |
2369556 | 2369556 | 2021-02-28 | US | Nebraska | Dundy | 31057 | 178 | 4 | 0 | 174 | 40.17638677 | -101.6876522 | 2021-03-01 05:23:01 | Dundy, Nebraska, US |
2367494 | 2367494 | 2021-02-28 | Italy | Valle d'Aosta | 8054 | 415 | 7465 | 174 | 45.73750286 | 7.320149366 | 2021-03-01 05:23:01 | Valle d'Aosta, Italy | ||
3068530 | 3068530 | 2021-02-27 | US | Oklahoma | Cimarron | 40025 | 175 | 1 | 0 | 174 | 36.74817177 | -102.5173885 | 2021-02-28 05:22:20 | Cimarron, Oklahoma, US |
3068058 | 3068058 | 2021-02-27 | US | Nebraska | Dundy | 31057 | 178 | 4 | 0 | 174 | 40.17638677 | -101.6876522 | 2021-02-28 05:22:20 | Dundy, Nebraska, US |
2186114 | 2186114 | 2021-02-26 | US | Oklahoma | Cimarron | 40025 | 175 | 1 | 0 | 174 | 36.74817177 | -102.5173885 | 2021-02-27 05:22:28 | Cimarron, Oklahoma, US |
2185695 | 2185695 | 2021-02-26 | US | Nebraska | Sherman | 31163 | 178 | 4 | 0 | 174 | 41.22045983 | -98.97588642 | 2021-02-27 05:22:28 | Sherman, Nebraska, US |
2185642 | 2185642 | 2021-02-26 | US | Nebraska | Dundy | 31057 | 178 | 4 | 0 | 174 | 40.17638677 | -101.6876522 | 2021-02-27 05:22:28 | Dundy, Nebraska, US |
1860117 | 1860117 | 2021-02-25 | US | Nebraska | Sherman | 31163 | 178 | 4 | 0 | 174 | 41.22045983 | -98.97588642 | 2021-02-26 05:22:40 | Sherman, Nebraska, US |
1860072 | 1860072 | 2021-02-25 | US | Nebraska | Gosper | 31073 | 178 | 4 | 0 | 174 | 40.51481965 | -99.83020279 | 2021-02-26 05:22:40 | Gosper, Nebraska, US |
282250 | 282250 | 2021-02-24 | US | Nebraska | Gosper | 31073 | 178 | 4 | 0 | 174 | 40.51481965 | -99.83020279 | 2021-02-25 05:24:57 | Gosper, Nebraska, US |
1938518 | 1938518 | 2021-02-23 | US | Nebraska | Gosper | 31073 | 178 | 4 | 0 | 174 | 40.51481965 | -99.83020279 | 2021-02-24 05:29:16 | Gosper, Nebraska, US |
1938360 | 1938360 | 2021-02-23 | US | Missouri | Knox | 29103 | 176 | 2 | 0 | 174 | 40.12699751 | -92.14780832 | 2021-02-24 05:29:16 | Knox, Missouri, US |
1937906 | 1937906 | 2021-02-23 | US | Kentucky | Robertson | 21201 | 186 | 12 | 0 | 174 | 38.51923469 | -84.05055616 | 2021-02-24 05:29:16 | Robertson, Kentucky, US |
532615 | 532615 | 2021-02-22 | US | Missouri | Knox | 29103 | 176 | 2 | 0 | 174 | 40.12699751 | -92.14780832 | 2021-02-23 05:23:41 | Knox, Missouri, US |
530720 | 530720 | 2021-02-22 | Japan | Ishikawa | 1796 | 61 | 1561 | 174 | 36.769464 | 136.771027 | 2021-02-23 05:23:41 | Ishikawa, Japan | ||
530668 | 530668 | 2021-02-22 | India | Puducherry | 39600 | 663 | 38763 | 174 | 11.882658 | 78.86498 | 2021-02-23 05:23:41 | Puducherry, India | ||
183949 | 183949 | 2021-02-21 | US | Missouri | Knox | 29103 | 176 | 2 | 0 | 174 | 40.12699751 | -92.14780832 | 2021-02-22 05:24:21 | Knox, Missouri, US |
183382 | 183382 | 2021-02-21 | US | Kansas | Stanton | 20187 | 181 | 7 | 0 | 174 | 37.56304714 | -101.7843534 | 2021-02-22 05:24:21 | Stanton, Kansas, US |
744223 | 744223 | 2021-02-20 | US | Missouri | Knox | 29103 | 176 | 2 | 0 | 174 | 40.12699751 | -92.14780832 | 2021-02-21 05:24:33 | Knox, Missouri, US |
743656 | 743656 | 2021-02-20 | US | Kansas | Stanton | 20187 | 181 | 7 | 0 | 174 | 37.56304714 | -101.7843534 | 2021-02-21 05:24:33 | Stanton, Kansas, US |
472754 | 472754 | 2021-02-19 | US | Kansas | Stanton | 20187 | 181 | 7 | 0 | 174 | 37.56304714 | -101.7843534 | 2021-02-20 05:22:51 | Stanton, Kansas, US |
3603108 | 3603108 | 2021-02-17 | US | Nebraska | Gosper | 31073 | 178 | 4 | 0 | 174 | 40.51481965 | -99.83020279 | 2021-02-18 05:22:58 | Gosper, Nebraska, US |
3603043 | 3603043 | 2021-02-17 | US | Montana | McCone | 30055 | 174 | 0 | 0 | 174 | 47.64469406 | -105.7944994 | 2021-02-18 05:22:58 | McCone, Montana, US |
3602963 | 3602963 | 2021-02-17 | US | Missouri | Mercer | 29129 | 176 | 2 | 0 | 174 | 40.42212303 | -93.5682959 | 2021-02-18 05:22:58 | Mercer, Missouri, US |
3602496 | 3602496 | 2021-02-17 | US | Kentucky | Robertson | 21201 | 186 | 12 | 0 | 174 | 38.51923469 | -84.05055616 | 2021-02-18 05:22:58 | Robertson, Kentucky, US |
3053227 | 3053227 | 2021-02-16 | US | Texas | Cottle | 48101 | 178 | 7 | 0 | 174 | 34.07783319 | -100.2785062 | 2021-02-17 05:23:10 | Cottle, Texas, US |
3052243 | 3052243 | 2021-02-16 | US | Nebraska | Gosper | 31073 | 178 | 4 | 0 | 174 | 40.51481965 | -99.83020279 | 2021-02-17 05:23:10 | Gosper, Nebraska, US |
3052098 | 3052098 | 2021-02-16 | US | Missouri | Mercer | 29129 | 176 | 2 | 0 | 174 | 40.42212303 | -93.5682959 | 2021-02-17 05:23:10 | Mercer, Missouri, US |
3051631 | 3051631 | 2021-02-16 | US | Kentucky | Robertson | 21201 | 186 | 12 | 0 | 174 | 38.51923469 | -84.05055616 | 2021-02-17 05:23:10 | Robertson, Kentucky, US |
1341326 | 1341326 | 2021-02-15 | US | Texas | Cottle | 48101 | 178 | 7 | 0 | 174 | 34.07783319 | -100.2785062 | 2021-02-16 05:24:38 | Cottle, Texas, US |
1340342 | 1340342 | 2021-02-15 | US | Nebraska | Gosper | 31073 | 178 | 4 | 0 | 174 | 40.51481965 | -99.83020279 | 2021-02-16 05:24:38 | Gosper, Nebraska, US |
1339730 | 1339730 | 2021-02-15 | US | Kentucky | Robertson | 21201 | 186 | 12 | 0 | 174 | 38.51923469 | -84.05055616 | 2021-02-16 05:24:38 | Robertson, Kentucky, US |
2286477 | 2286477 | 2021-02-14 | US | Texas | Cottle | 48101 | 178 | 7 | 0 | 174 | 34.07783319 | -100.2785062 | 2021-02-15 05:24:49 | Cottle, Texas, US |
2285493 | 2285493 | 2021-02-14 | US | Nebraska | Gosper | 31073 | 178 | 4 | 0 | 174 | 40.51481965 | -99.83020279 | 2021-02-15 05:24:49 | Gosper, Nebraska, US |
2284881 | 2284881 | 2021-02-14 | US | Kentucky | Robertson | 21201 | 186 | 12 | 0 | 174 | 38.51923469 | -84.05055616 | 2021-02-15 05:24:49 | Robertson, Kentucky, US |
2284768 | 2284768 | 2021-02-14 | US | Kansas | Stanton | 20187 | 180 | 6 | 0 | 174 | 37.56304714 | -101.7843534 | 2021-02-15 05:24:49 | Stanton, Kansas, US |
2680877 | 2680877 | 2021-02-13 | US | Texas | Cottle | 48101 | 178 | 7 | 0 | 174 | 34.07783319 | -100.2785062 | 2021-02-14 05:23:43 | Cottle, Texas, US |
2679893 | 2679893 | 2021-02-13 | US | Nebraska | Gosper | 31073 | 178 | 4 | 0 | 174 | 40.51481965 | -99.83020279 | 2021-02-14 05:23:43 | Gosper, Nebraska, US |
2679281 | 2679281 | 2021-02-13 | US | Kentucky | Robertson | 21201 | 186 | 12 | 0 | 174 | 38.51923469 | -84.05055616 | 2021-02-14 05:23:43 | Robertson, Kentucky, US |
2679168 | 2679168 | 2021-02-13 | US | Kansas | Stanton | 20187 | 180 | 6 | 0 | 174 | 37.56304714 | -101.7843534 | 2021-02-14 05:23:43 | Stanton, Kansas, US |
3542510 | 3542510 | 2021-02-12 | US | Texas | Cottle | 48101 | 178 | 7 | 0 | 174 | 34.07783319 | -100.2785062 | 2021-02-13 05:22:12 | Cottle, Texas, US |
3541526 | 3541526 | 2021-02-12 | US | Nebraska | Gosper | 31073 | 178 | 4 | 0 | 174 | 40.51481965 | -99.83020279 | 2021-02-13 05:22:12 | Gosper, Nebraska, US |
3540801 | 3540801 | 2021-02-12 | US | Kansas | Stanton | 20187 | 180 | 6 | 0 | 174 | 37.56304714 | -101.7843534 | 2021-02-13 05:22:12 | Stanton, Kansas, US |
3540059 | 3540059 | 2021-02-12 | US | Colorado | Costilla | 8023 | 177 | 2 | 0 | 174 | 37.27732493 | -105.4276548 | 2021-02-13 05:22:12 | Costilla, Colorado, US |
2640773 | 2640773 | 2021-02-11 | US | Texas | Cottle | 48101 | 178 | 7 | 0 | 174 | 34.07783319 | -100.2785062 | 2021-02-12 05:23:29 | Cottle, Texas, US |
2638322 | 2638322 | 2021-02-11 | US | Colorado | Costilla | 8023 | 177 | 2 | 0 | 174 | 37.27732493 | -105.4276548 | 2021-02-12 05:23:29 | Costilla, Colorado, US |
2638134 | 2638134 | 2021-02-11 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 174 | 0 | 0 | 174 | 58.62403337 | -156.21405890000003 | 2021-02-12 05:23:29 | Bristol Bay plus Lake and Peninsula, Alaska, US |
3981628 | 3981628 | 2021-02-10 | US | Texas | Cottle | 48101 | 178 | 7 | 0 | 174 | 34.07783319 | -100.2785062 | 2021-02-11 05:23:55 | Cottle, Texas, US |
3980644 | 3980644 | 2021-02-10 | US | Nebraska | Gosper | 31073 | 178 | 4 | 0 | 174 | 40.51481965 | -99.83020279 | 2021-02-11 05:23:55 | Gosper, Nebraska, US |
3978989 | 3978989 | 2021-02-10 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 174 | 0 | 0 | 174 | 58.62403337 | -156.21405890000003 | 2021-02-11 05:23:55 | Bristol Bay plus Lake and Peninsula, Alaska, US |
1530948 | 1530948 | 2021-02-09 | US | Texas | Cottle | 48101 | 178 | 7 | 0 | 174 | 34.07783319 | -100.2785062 | 2021-02-10 05:22:41 | Cottle, Texas, US |
616739 | 616739 | 2021-02-08 | US | Texas | Cottle | 48101 | 178 | 7 | 0 | 174 | 34.07783319 | -100.2785062 | 2021-02-09 05:23:30 | Cottle, Texas, US |
1675508 | 1675508 | 2021-02-07 | US | Texas | Cottle | 48101 | 178 | 7 | 0 | 174 | 34.07783319 | -100.2785062 | 2021-02-08 05:22:39 | Cottle, Texas, US |
978567 | 978567 | 2021-02-06 | United Kingdom | Gibraltar | 4177 | 80 | 3923 | 174 | 36.1408 | -5.3536 | 2021-02-07 05:23:00 | Gibraltar, United Kingdom | ||
977969 | 977969 | 2021-02-06 | US | Texas | Cottle | 48101 | 178 | 7 | 0 | 174 | 34.07783319 | -100.2785062 | 2021-02-07 05:23:00 | Cottle, Texas, US |
1591227 | 1591227 | 2021-02-05 | US | Texas | Cottle | 48101 | 178 | 7 | 0 | 174 | 34.07783319 | -100.2785062 | 2021-02-06 05:23:55 | Cottle, Texas, US |
1590243 | 1590243 | 2021-02-05 | US | Nebraska | Gosper | 31073 | 178 | 4 | 0 | 174 | 40.51481965 | -99.83020279 | 2021-02-06 05:23:55 | Gosper, Nebraska, US |
793434 | 793434 | 2021-02-04 | US | Texas | Cottle | 48101 | 178 | 7 | 0 | 174 | 34.07783319 | -100.2785062 | 2021-02-05 05:22:38 | Cottle, Texas, US |
792450 | 792450 | 2021-02-04 | US | Nebraska | Gosper | 31073 | 178 | 4 | 0 | 174 | 40.51481965 | -99.83020279 | 2021-02-05 05:22:38 | Gosper, Nebraska, US |
343326 | 343326 | 2021-02-03 | US | Texas | Cottle | 48101 | 178 | 7 | 0 | 174 | 34.07783319 | -100.2785062 | 2021-02-04 05:22:26 | Cottle, Texas, US |
342342 | 342342 | 2021-02-03 | US | Nebraska | Gosper | 31073 | 178 | 4 | 0 | 174 | 40.51481965 | -99.83020279 | 2021-02-04 05:22:26 | Gosper, Nebraska, 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]);