johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
951 rows where active = 187 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 846
- Japan 29
- Canada 6
- Russia 6
- Ukraine 5
- Benin 3
- Burkina Faso 3
- Chile 3
- Colombia 3
- India 3
- Malaysia 3
- Mexico 3
- Albania 2
- China 2
- Germany 2
- Iceland 2
- Jamaica 2
- Netherlands 2
- Niger 2
- Thailand 2
- Bhutan 1
- Comoros 1
- Congo (Kinshasa) 1
- Croatia 1
- Estonia 1
- Finland 1
- France 1
- Georgia 1
- Guinea-Bissau 1
- Haiti 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
408108 | 408108 | 2021-07-28 | China | Jiangsu | 931 | 0 | 744 | 187 | 32.9711 | 119.455 | 2021-07-29 04:21:33 | Jiangsu, China | ||
2950998 | 2950998 | 2021-07-16 | Ukraine | Vinnytsia Oblast | 71248 | 1696 | 69365 | 187 | 49.2331 | 28.4682 | 2021-07-17 04:22:22 | Vinnytsia Oblast, Ukraine | ||
296051 | 296051 | 2021-07-15 | Japan | Tochigi | 7311 | 82 | 7042 | 187 | 36.689912 | 139.819213 | 2021-07-16 04:21:22 | Tochigi, Japan | ||
3631964 | 3631964 | 2021-07-14 | Japan | Fukushima | 5124 | 161 | 4776 | 187 | 37.378867 | 140.223295 | 2021-07-15 04:21:48 | Fukushima, Japan | ||
625663 | 625663 | 2021-07-10 | Chile | Aysen | 7911 | 65 | 7659 | 187 | -45.9864 | -73.7669 | 2021-07-11 04:21:43 | Aysen, Chile | ||
829604 | 829604 | 2021-07-09 | Japan | Fukushima | 5049 | 161 | 4701 | 187 | 37.378867 | 140.223295 | 2021-07-10 04:21:25 | Fukushima, Japan | ||
782003 | 782003 | 2021-07-08 | Ukraine | Vinnytsia Oblast | 71186 | 1693 | 69306 | 187 | 49.2331 | 28.4682 | 2021-07-09 04:21:21 | Vinnytsia Oblast, Ukraine | ||
2697321 | 2697321 | 2021-07-06 | Ukraine | Luhansk Oblast | 26667 | 950 | 25530 | 187 | 48.574 | 39.3078 | 2021-07-07 04:21:20 | Luhansk Oblast, Ukraine | ||
2071974 | 2071974 | 2021-07-02 | Laos | 2176 | 3 | 1986 | 187 | 19.85627 | 102.495496 | 2021-07-03 04:21:37 | Laos | |||
3381392 | 3381392 | 2021-06-13 | Japan | Kagoshima | 3584 | 33 | 3364 | 187 | 31.009484000000004 | 130.430665 | 2021-06-14 04:22:46 | Kagoshima, Japan | ||
1736715 | 1736715 | 2021-06-12 | Russia | Karachay-Cherkess Republic | 20593 | 158 | 20248 | 187 | 43.7368326 | 41.7267991 | 2021-06-13 04:22:44 | Karachay-Cherkess Republic, Russia | ||
522771 | 522771 | 2021-06-09 | Germany | Mecklenburg-Vorpommern | 44015 | 1133 | 42700 | 187 | 53.6127 | 12.4296 | 2021-06-10 04:23:17 | Mecklenburg-Vorpommern, Germany | ||
3472226 | 3472226 | 2021-06-08 | Guinea-Bissau | 3790 | 68 | 3535 | 187 | 11.8037 | -15.1804 | 2021-06-09 04:23:31 | Guinea-Bissau | |||
2585995 | 2585995 | 2021-06-05 | Japan | Fukushima | 4632 | 152 | 4293 | 187 | 37.378867 | 140.223295 | 2021-06-06 04:24:03 | Fukushima, Japan | ||
2585990 | 2585990 | 2021-06-05 | Japan | Aomori | 2415 | 30 | 2198 | 187 | 40.781541 | 140.828896 | 2021-06-06 04:24:03 | Aomori, Japan | ||
1188791 | 1188791 | 2021-05-31 | Japan | Yamagata | 1961 | 41 | 1733 | 187 | 38.448396 | 140.102154 | 2021-06-01 04:23:09 | Yamagata, Japan | ||
3089358 | 3089358 | 2021-05-30 | India | Andaman and Nicobar Islands | 6984 | 114 | 6683 | 187 | 11.225999 | 92.968178 | 2021-05-31 03:08:59 | Andaman and Nicobar Islands, India | ||
20404 | 20404 | 2021-05-28 | Japan | Saga | 2478 | 19 | 2272 | 187 | 33.286977 | 130.115738 | 2021-05-29 04:20:41 | Saga, Japan | ||
83140 | 83140 | 2021-05-25 | Japan | Wakayama | 2574 | 40 | 2347 | 187 | 33.911879 | 135.505446 | 2021-05-26 04:20:35 | Wakayama, Japan | ||
1952237 | 1952237 | 2021-05-21 | Bhutan | 1374 | 1 | 1186 | 187 | 27.5142 | 90.4336 | 2021-05-22 04:20:45 | Bhutan | |||
2761110 | 2761110 | 2021-05-03 | Russia | Chechen Republic | 12023 | 125 | 11711 | 187 | 43.39761470000001 | 45.6985005 | 2021-05-04 04:20:34 | Chechen Republic, Russia | ||
3393400 | 3393400 | 2021-04-28 | Japan | Fukui | 869 | 33 | 649 | 187 | 35.846614 | 136.22465400000002 | 2021-04-29 04:20:55 | Fukui, Japan | ||
3702302 | 3702302 | 2021-04-27 | Russia | Chechen Republic | 11966 | 122 | 11657 | 187 | 43.39761470000001 | 45.6985005 | 2021-04-28 04:20:32 | Chechen Republic, Russia | ||
888125 | 888125 | 2021-04-26 | Japan | Fukui | 858 | 33 | 638 | 187 | 35.846614 | 136.22465400000002 | 2021-04-27 04:20:52 | Fukui, Japan | ||
169801 | 169801 | 2021-04-16 | Burkina Faso | 13083 | 154 | 12742 | 187 | 12.2383 | -1.5616 | 2021-04-17 04:20:40 | Burkina Faso | |||
36432 | 36432 | 2021-04-12 | Japan | Aomori | 1177 | 20 | 970 | 187 | 40.781541 | 140.828896 | 2021-04-13 04:20:37 | Aomori, Japan | ||
2986933 | 2986933 | 2021-04-10 | Malaysia | Melaka | 6699 | 22 | 6490 | 187 | 2.1896 | 102.2501 | 2021-04-11 04:20:56 | Melaka, Malaysia | ||
605691 | 605691 | 2021-04-09 | Japan | Aomori | 1144 | 20 | 937 | 187 | 40.781541 | 140.828896 | 2021-04-10 04:20:59 | Aomori, Japan | ||
1290015 | 1290015 | 2021-03-29 | Japan | Gunma | 4963 | 99 | 4677 | 187 | 36.504479 | 138.985605 | 2021-03-30 04:26:23 | Gunma, Japan | ||
2781329 | 2781329 | 2021-03-24 | Trinidad and Tobago | 7903 | 141 | 7575 | 187 | 10.6918 | -61.2225 | 2021-03-25 05:27:00 | Trinidad and Tobago | |||
1798396 | 1798396 | 2021-03-23 | Burkina Faso | 12572 | 145 | 12240 | 187 | 12.2383 | -1.5616 | 2021-03-24 05:25:40 | Burkina Faso | |||
1203845 | 1203845 | 2021-03-22 | Japan | Shizuoka | 5500 | 114 | 5199 | 187 | 34.916975 | 138.40778400000002 | 2021-03-23 05:26:18 | Shizuoka, Japan | ||
1838066 | 1838066 | 2021-03-12 | Niger | 4853 | 180 | 4486 | 187 | 17.607789 | 8.081666 | 2021-03-13 05:25:15 | Niger | |||
352431 | 352431 | 2021-03-11 | Niger | 4853 | 180 | 4486 | 187 | 17.607789 | 8.081666 | 2021-03-12 05:26:50 | Niger | |||
3962556 | 3962556 | 2021-03-10 | Japan | Shiga | 2612 | 48 | 2377 | 187 | 35.21582700000001 | 136.138064 | 2021-03-11 05:25:48 | Shiga, Japan | ||
3670833 | 3670833 | 2021-03-06 | US | Texas | Sherman | 48421 | 307 | 12 | 0 | 187 | 36.27751473 | -101.8933156 | 2021-03-07 05:21:54 | Sherman, Texas, US |
1619454 | 1619454 | 2021-03-05 | US | Texas | Sherman | 48421 | 307 | 12 | 0 | 187 | 36.27751473 | -101.8933156 | 2021-03-06 04:23:41 | Sherman, Texas, US |
2210865 | 2210865 | 2021-03-04 | US | Texas | Sherman | 48421 | 307 | 12 | 0 | 187 | 36.27751473 | -101.8933156 | 2021-03-05 05:26:29 | Sherman, Texas, US |
1093286 | 1093286 | 2021-03-03 | US | Texas | Sherman | 48421 | 307 | 12 | 0 | 187 | 36.27751473 | -101.8933156 | 2021-03-04 05:24:24 | Sherman, Texas, US |
3254747 | 3254747 | 2021-03-02 | US | Colorado | Costilla | 8023 | 193 | 2 | 0 | 187 | 37.27732493 | -105.4276548 | 2021-03-03 05:23:28 | Costilla, Colorado, US |
282245 | 282245 | 2021-02-24 | US | Nebraska | Frontier | 31063 | 188 | 1 | 0 | 187 | 40.52993007 | -100.3924658 | 2021-02-25 05:24:57 | Frontier, Nebraska, US |
1938513 | 1938513 | 2021-02-23 | US | Nebraska | Frontier | 31063 | 188 | 1 | 0 | 187 | 40.52993007 | -100.3924658 | 2021-02-24 05:29:16 | Frontier, Nebraska, US |
1938434 | 1938434 | 2021-02-23 | US | Montana | Daniels | 30019 | 194 | 7 | 0 | 187 | 48.78420029 | -105.54763429999998 | 2021-02-24 05:29:16 | Daniels, Montana, US |
1937740 | 1937740 | 2021-02-23 | US | Kansas | Hodgeman | 20083 | 194 | 7 | 0 | 187 | 38.08780079 | -99.89829881 | 2021-02-24 05:29:16 | Hodgeman, Kansas, US |
532689 | 532689 | 2021-02-22 | US | Montana | Daniels | 30019 | 194 | 7 | 0 | 187 | 48.78420029 | -105.54763429999998 | 2021-02-23 05:23:41 | Daniels, Montana, US |
531995 | 531995 | 2021-02-22 | US | Kansas | Hodgeman | 20083 | 194 | 7 | 0 | 187 | 38.08780079 | -99.89829881 | 2021-02-23 05:23:41 | Hodgeman, Kansas, US |
182054 | 182054 | 2021-02-21 | Japan | Ishikawa | 1790 | 61 | 1542 | 187 | 36.769464 | 136.771027 | 2021-02-22 05:24:21 | Ishikawa, Japan | ||
3050823 | 3050823 | 2021-02-16 | US | Colorado | Sedgwick | 8115 | 191 | 2 | 0 | 187 | 40.87595412 | -102.3519227 | 2021-02-17 05:23:10 | Sedgwick, Colorado, US |
1338922 | 1338922 | 2021-02-15 | US | Colorado | Sedgwick | 8115 | 191 | 2 | 0 | 187 | 40.87595412 | -102.3519227 | 2021-02-16 05:24:38 | Sedgwick, Colorado, US |
2284073 | 2284073 | 2021-02-14 | US | Colorado | Sedgwick | 8115 | 190 | 2 | 0 | 187 | 40.87595412 | -102.3519227 | 2021-02-15 05:24:49 | Sedgwick, Colorado, US |
2678492 | 2678492 | 2021-02-13 | US | Delaware | Unassigned | 90010 | 187 | 0 | 0 | 187 | 39.57992638 | 0.0 | 2021-02-14 05:23:43 | Unassigned, Delaware, US |
2678473 | 2678473 | 2021-02-13 | US | Colorado | Sedgwick | 8115 | 190 | 2 | 0 | 187 | 40.87595412 | -102.3519227 | 2021-02-14 05:23:43 | Sedgwick, Colorado, US |
3540106 | 3540106 | 2021-02-12 | US | Colorado | Sedgwick | 8115 | 190 | 2 | 0 | 187 | 40.87595412 | -102.3519227 | 2021-02-13 05:22:12 | Sedgwick, Colorado, US |
2638369 | 2638369 | 2021-02-11 | US | Colorado | Sedgwick | 8115 | 189 | 2 | 0 | 187 | 40.87595412 | -102.3519227 | 2021-02-12 05:23:29 | Sedgwick, Colorado, US |
1529250 | 1529250 | 2021-02-09 | US | Kansas | Woodson | 20207 | 190 | 3 | 0 | 187 | 37.8865336 | -95.74006277 | 2021-02-10 05:22:41 | Woodson, Kansas, US |
615681 | 615681 | 2021-02-08 | US | Montana | Granite | 30039 | 189 | 2 | 0 | 187 | 46.40605220000001 | -113.4414186 | 2021-02-09 05:23:30 | Granite, Montana, US |
615041 | 615041 | 2021-02-08 | US | Kansas | Woodson | 20207 | 190 | 3 | 0 | 187 | 37.8865336 | -95.74006277 | 2021-02-09 05:23:30 | Woodson, Kansas, US |
614102 | 614102 | 2021-02-08 | US | Alaska | Dillingham | 2070 | 188 | 1 | 0 | 187 | 59.79603738 | -158.23819419999995 | 2021-02-09 05:23:30 | Dillingham, Alaska, US |
1675167 | 1675167 | 2021-02-07 | US | Puerto Rico | Arroyo | 72015 | 187 | 0 | 0 | 187 | 17.998457000000005 | -66.056546 | 2021-02-08 05:22:39 | Arroyo, Puerto Rico, US |
1674450 | 1674450 | 2021-02-07 | US | Montana | Granite | 30039 | 189 | 2 | 0 | 187 | 46.40605220000001 | -113.4414186 | 2021-02-08 05:22:39 | Granite, Montana, US |
1673810 | 1673810 | 2021-02-07 | US | Kansas | Woodson | 20207 | 190 | 3 | 0 | 187 | 37.8865336 | -95.74006277 | 2021-02-08 05:22:39 | Woodson, Kansas, US |
977628 | 977628 | 2021-02-06 | US | Puerto Rico | Arroyo | 72015 | 187 | 0 | 0 | 187 | 17.998457000000005 | -66.056546 | 2021-02-07 05:23:00 | Arroyo, Puerto Rico, US |
976911 | 976911 | 2021-02-06 | US | Montana | Granite | 30039 | 189 | 2 | 0 | 187 | 46.40605220000001 | -113.4414186 | 2021-02-07 05:23:00 | Granite, Montana, US |
976271 | 976271 | 2021-02-06 | US | Kansas | Woodson | 20207 | 190 | 3 | 0 | 187 | 37.8865336 | -95.74006277 | 2021-02-07 05:23:00 | Woodson, Kansas, US |
1590886 | 1590886 | 2021-02-05 | US | Puerto Rico | Arroyo | 72015 | 187 | 0 | 0 | 187 | 17.998457000000005 | -66.056546 | 2021-02-06 05:23:55 | Arroyo, Puerto Rico, US |
1590169 | 1590169 | 2021-02-05 | US | Montana | Granite | 30039 | 189 | 2 | 0 | 187 | 46.40605220000001 | -113.4414186 | 2021-02-06 05:23:55 | Granite, Montana, US |
1589529 | 1589529 | 2021-02-05 | US | Kansas | Woodson | 20207 | 190 | 3 | 0 | 187 | 37.8865336 | -95.74006277 | 2021-02-06 05:23:55 | Woodson, Kansas, US |
1588117 | 1588117 | 2021-02-05 | India | Chandigarh | 21060 | 338 | 20535 | 187 | 30.733839 | 76.76827800000002 | 2021-02-06 05:23:55 | Chandigarh, India | ||
793093 | 793093 | 2021-02-04 | US | Puerto Rico | Arroyo | 72015 | 187 | 0 | 0 | 187 | 17.998457000000005 | -66.056546 | 2021-02-05 05:22:38 | Arroyo, Puerto Rico, US |
791736 | 791736 | 2021-02-04 | US | Kansas | Woodson | 20207 | 190 | 3 | 0 | 187 | 37.8865336 | -95.74006277 | 2021-02-05 05:22:38 | Woodson, Kansas, US |
791030 | 791030 | 2021-02-04 | US | Colorado | Sedgwick | 8115 | 188 | 2 | 0 | 187 | 40.87595412 | -102.3519227 | 2021-02-05 05:22:38 | Sedgwick, Colorado, US |
790324 | 790324 | 2021-02-04 | India | Chandigarh | 21036 | 337 | 20512 | 187 | 30.733839 | 76.76827800000002 | 2021-02-05 05:22:38 | Chandigarh, India | ||
342985 | 342985 | 2021-02-03 | US | Puerto Rico | Arroyo | 72015 | 187 | 0 | 0 | 187 | 17.998457000000005 | -66.056546 | 2021-02-04 05:22:26 | Arroyo, Puerto Rico, US |
341628 | 341628 | 2021-02-03 | US | Kansas | Woodson | 20207 | 190 | 3 | 0 | 187 | 37.8865336 | -95.74006277 | 2021-02-04 05:22:26 | Woodson, Kansas, US |
340922 | 340922 | 2021-02-03 | US | Colorado | Sedgwick | 8115 | 188 | 2 | 0 | 187 | 40.87595412 | -102.3519227 | 2021-02-04 05:22:26 | Sedgwick, Colorado, US |
1687211 | 1687211 | 2021-02-02 | US | Puerto Rico | Arroyo | 72015 | 187 | 0 | 0 | 187 | 17.998457000000005 | -66.056546 | 2021-02-03 05:22:52 | Arroyo, Puerto Rico, US |
1686598 | 1686598 | 2021-02-02 | US | Nebraska | Pawnee | 31133 | 188 | 1 | 0 | 187 | 40.13141096 | -96.23705437 | 2021-02-03 05:22:52 | Pawnee, Nebraska, US |
1685148 | 1685148 | 2021-02-02 | US | Colorado | Sedgwick | 8115 | 187 | 2 | 0 | 187 | 40.87595412 | -102.3519227 | 2021-02-03 05:22:52 | Sedgwick, Colorado, US |
1680138 | 1680138 | 2021-02-01 | US | Alaska | Copper River | 2066 | 187 | 0 | 0 | 187 | 60.3886 | -162.8905196 | 2021-04-02 15:13:53 | Copper River, Alaska, US |
1677118 | 1677118 | 2021-02-01 | US | Colorado | Sedgwick | 8115 | 187 | 2 | 0 | 187 | 40.87595412 | -102.3519227 | 2021-02-02 05:22:49 | Sedgwick, Colorado, US |
1463426 | 1463426 | 2021-01-31 | US | Alaska | Copper River | 2066 | 187 | 0 | 0 | 187 | 60.3886 | -162.8905196 | 2021-04-02 15:13:53 | Copper River, Alaska, US |
1460406 | 1460406 | 2021-01-31 | US | Colorado | Sedgwick | 8115 | 187 | 2 | 0 | 187 | 40.87595412 | -102.3519227 | 2021-02-01 05:22:53 | Sedgwick, Colorado, US |
2214377 | 2214377 | 2021-01-30 | US | Puerto Rico | Arroyo | 72015 | 187 | 0 | 0 | 187 | 17.998457000000005 | -66.056546 | 2021-01-31 05:22:42 | Arroyo, Puerto Rico, US |
2212314 | 2212314 | 2021-01-30 | US | Colorado | Sedgwick | 8115 | 187 | 2 | 0 | 187 | 40.87595412 | -102.3519227 | 2021-01-31 05:22:42 | Sedgwick, Colorado, US |
1897801 | 1897801 | 2021-01-29 | US | Colorado | Sedgwick | 8115 | 187 | 2 | 0 | 187 | 40.87595412 | -102.3519227 | 2021-01-30 05:22:49 | Sedgwick, Colorado, US |
2484580 | 2484580 | 2021-01-28 | US | Oregon | Harney | 41025 | 193 | 6 | 0 | 187 | 43.06422669 | -118.9666306 | 2021-01-29 05:22:23 | Harney, Oregon, US |
3153634 | 3153634 | 2021-01-27 | Japan | Oita | 1093 | 16 | 890 | 187 | 33.200697 | 131.43323999999998 | 2021-01-28 05:22:24 | Oita, Japan | ||
3153609 | 3153609 | 2021-01-27 | Japan | Ehime | 969 | 17 | 765 | 187 | 33.624835 | 132.856842 | 2021-01-28 05:22:24 | Ehime, Japan | ||
2429646 | 2429646 | 2021-01-23 | US | Puerto Rico | Lajas | 72079 | 187 | 0 | 0 | 187 | 18.011661 | -67.040585 | 2021-01-24 05:22:35 | Lajas, Puerto Rico, US |
2426932 | 2426932 | 2021-01-23 | Japan | Oita | 1032 | 14 | 831 | 187 | 33.200697 | 131.43323999999998 | 2021-01-24 05:22:35 | Oita, Japan | ||
2470012 | 2470012 | 2021-01-22 | US | Texas | Schleicher | 48413 | 140 | 6 | 0 | 187 | 30.89740592 | -100.5384842 | 2021-01-23 05:22:03 | Schleicher, Texas, US |
1097742 | 1097742 | 2021-01-20 | United Kingdom | Turks and Caicos Islands | 1125 | 7 | 931 | 187 | 21.694000000000006 | -71.7979 | 2021-01-21 05:22:01 | Turks and Caicos Islands, United Kingdom | ||
911492 | 911492 | 2021-01-19 | US | Virginia | Craig | 51045 | 189 | 2 | 0 | 187 | 37.48133648 | -80.21072274 | 2021-01-20 05:21:54 | Craig, Virginia, US |
3503372 | 3503372 | 2021-01-17 | Japan | Ishikawa | 1325 | 54 | 1084 | 187 | 36.769464 | 136.771027 | 2021-01-18 05:22:34 | Ishikawa, Japan | ||
3104906 | 3104906 | 2021-01-16 | US | West Virginia | Calhoun | 54013 | 187 | 0 | 0 | 187 | 38.84315422 | -81.11934872 | 2021-01-17 05:22:17 | Calhoun, West Virginia, US |
3101484 | 3101484 | 2021-01-16 | Japan | Toyama | 796 | 26 | 583 | 187 | 36.637464 | 137.26934599999998 | 2021-01-17 05:22:17 | Toyama, Japan | ||
3308069 | 3308069 | 2021-01-13 | Comoros | 1169 | 33 | 949 | 187 | -11.6455 | 43.3333 | 2021-01-14 05:22:32 | Comoros | |||
192713 | 192713 | 2021-01-11 | US | Pennsylvania | Cameron | 42023 | 191 | 4 | 0 | 187 | 41.43625568 | -78.20376845 | 2021-01-12 05:22:15 | Cameron, Pennsylvania, US |
2867595 | 2867595 | 2021-01-06 | US | South Dakota | McPherson | 46089 | 189 | 2 | 0 | 187 | 45.76626028 | -99.22118798 | 2021-01-07 05:22:03 | McPherson, South Dakota, US |
3035068 | 3035068 | 2021-01-05 | US | Georgia | Clay | 13061 | 190 | 3 | 0 | 187 | 31.62221166 | -84.97713865 | 2021-01-06 05:22:16 | Clay, Georgia, 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]);