johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
458 rows where active = 445 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 394
- Russia 11
- Colombia 7
- Japan 5
- Ukraine 4
- Chile 3
- India 3
- Mexico 3
- Andorra 2
- Cuba 2
- Equatorial Guinea 2
- Italy 2
- Peru 2
- San Marino 2
- Belize 1
- Canada 1
- China 1
- Costa Rica 1
- Djibouti 1
- Latvia 1
- Mauritania 1
- North Macedonia 1
- Norway 1
- Pakistan 1
- Singapore 1
- Suriname 1
- Tajikistan 1
- Trinidad and Tobago 1
- Uruguay 1
- Yemen 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3683479 | 3683479 | 2021-08-02 | Japan | Niigata | 4096 | 54 | 3597 | 445 | 37.521819 | 138.918647 | 2021-08-03 04:21:39 | Niigata, Japan | ||
1330097 | 1330097 | 2021-07-24 | Colombia | La Guajira | 41162 | 1290 | 39427 | 445 | 11.3548 | -72.5205 | 2021-07-25 04:22:12 | La Guajira, Colombia | ||
3331380 | 3331380 | 2021-07-21 | Colombia | La Guajira | 40977 | 1287 | 39245 | 445 | 11.3548 | -72.5205 | 2021-07-22 04:21:19 | La Guajira, Colombia | ||
829821 | 829821 | 2021-07-09 | Russia | Mari El Republic | 14794 | 324 | 14025 | 445 | 56.5767504 | 47.8817512 | 2021-07-10 04:21:25 | Mari El Republic, Russia | ||
1440782 | 1440782 | 2021-07-07 | Russia | Ingushetia Republic | 16404 | 197 | 15762 | 445 | 43.11542075 | 45.01713552 | 2021-07-08 04:21:26 | Ingushetia Republic, Russia | ||
2593630 | 2593630 | 2021-06-27 | Ukraine | Kherson Oblast | 35734 | 1133 | 34156 | 445 | 46.6354 | 32.6169 | 2021-06-28 04:21:29 | Kherson Oblast, Ukraine | ||
2339252 | 2339252 | 2021-06-15 | Colombia | Quindio | 45650 | 1376 | 43829 | 445 | 4.461 | -75.6674 | 2021-06-16 04:22:32 | Quindio, Colombia | ||
1563948 | 1563948 | 2021-06-14 | Colombia | Quindio | 45650 | 1376 | 43829 | 445 | 4.461 | -75.6674 | 2021-06-15 04:22:22 | Quindio, Colombia | ||
1188792 | 1188792 | 2021-05-31 | Japan | Yamaguchi | 2924 | 62 | 2417 | 445 | 34.201190000000004 | 131.573293 | 2021-06-01 04:23:09 | Yamaguchi, Japan | ||
1309959 | 1309959 | 2021-05-26 | Chile | Magallanes | 27528 | 395 | 26688 | 445 | -52.368 | -70.9863 | 2021-05-27 04:20:59 | Magallanes, Chile | ||
954887 | 954887 | 2021-04-25 | Japan | Mie | 3526 | 77 | 3004 | 445 | 34.508018 | 136.376013 | 2021-04-26 04:21:04 | Mie, Japan | ||
954555 | 954555 | 2021-04-25 | Andorra | 13060 | 124 | 12491 | 445 | 42.5063 | 1.5218 | 2021-04-26 04:21:04 | Andorra | |||
2020927 | 2020927 | 2021-04-20 | Russia | Kamchatka Krai | 14362 | 213 | 13704 | 445 | 57.1914882 | 160.03838190000005 | 2021-04-21 04:21:14 | Kamchatka Krai, Russia | ||
982917 | 982917 | 2021-04-17 | India | Tripura | 34002 | 394 | 33163 | 445 | 23.746783 | 91.743565 | 2021-04-18 04:20:41 | Tripura, India | ||
2983562 | 2983562 | 2021-04-10 | Suriname | 9278 | 179 | 8654 | 445 | 3.9193 | -56.0278 | 2021-04-11 04:20:56 | Suriname | |||
3709991 | 3709991 | 2021-04-03 | Colombia | Meta | 43913 | 1002 | 42466 | 445 | 3.272 | -73.0877 | 2021-04-04 04:20:49 | Meta, Colombia | ||
2780956 | 2780956 | 2021-03-24 | India | Puducherry | 40645 | 679 | 39521 | 445 | 11.882658 | 78.86498 | 2021-03-25 05:27:00 | Puducherry, India | ||
3420804 | 3420804 | 2021-03-19 | Equatorial Guinea | 6666 | 100 | 6121 | 445 | 1.6508 | 10.2679 | 2021-03-20 05:25:46 | Equatorial Guinea | |||
3452742 | 3452742 | 2021-03-18 | Equatorial Guinea | 6666 | 100 | 6121 | 445 | 1.6508 | 10.2679 | 2021-03-19 05:26:09 | Equatorial Guinea | |||
2363131 | 2363131 | 2021-03-08 | Yemen | 2545 | 653 | 1447 | 445 | 15.552727 | 48.516388 | 2021-03-09 05:28:19 | Yemen | |||
3669667 | 3669667 | 2021-03-06 | US | Nebraska | Chase | 31029 | 448 | 3 | 0 | 445 | 40.5237198 | -101.6978026 | 2021-03-07 05:21:54 | Chase, Nebraska, US |
3669270 | 3669270 | 2021-03-06 | US | Michigan | Mackinac | 26097 | 448 | 3 | 0 | 445 | 46.07028979 | -85.04980537 | 2021-03-07 05:21:54 | Mackinac, Michigan, US |
281628 | 281628 | 2021-02-24 | US | Kentucky | Nicholas | 21181 | 451 | 6 | 0 | 445 | 38.33342292 | -84.01889177 | 2021-02-25 05:24:57 | Nicholas, Kentucky, US |
280613 | 280613 | 2021-02-24 | US | Alaska | Southeast Fairbanks | 2240 | 448 | 3 | 0 | 445 | 63.87692095 | -143.2127643 | 2021-02-25 05:24:57 | Southeast Fairbanks, Alaska, US |
183076 | 183076 | 2021-02-21 | US | Illinois | Scott | 17171 | 446 | 1 | 0 | 445 | 39.6429169 | -90.47814431 | 2021-02-22 05:24:21 | Scott, Illinois, US |
743350 | 743350 | 2021-02-20 | US | Illinois | Scott | 17171 | 446 | 1 | 0 | 445 | 39.6429169 | -90.47814431 | 2021-02-21 05:24:33 | Scott, Illinois, US |
472448 | 472448 | 2021-02-19 | US | Illinois | Scott | 17171 | 446 | 1 | 0 | 445 | 39.6429169 | -90.47814431 | 2021-02-20 05:22:51 | Scott, Illinois, US |
1156589 | 1156589 | 2021-02-18 | US | West Virginia | Doddridge | 54017 | 451 | 6 | 0 | 445 | 39.27057157 | -80.70671527 | 2021-02-19 05:24:16 | Doddridge, West Virginia, US |
1154157 | 1154157 | 2021-02-18 | US | Illinois | Scott | 17171 | 446 | 1 | 0 | 445 | 39.6429169 | -90.47814431 | 2021-02-19 05:24:16 | Scott, Illinois, US |
3602467 | 3602467 | 2021-02-17 | US | Kentucky | Lyon | 21143 | 458 | 13 | 0 | 445 | 37.02080035 | -88.07886257 | 2021-02-18 05:22:58 | Lyon, Kentucky, US |
3602077 | 3602077 | 2021-02-17 | US | Illinois | Scott | 17171 | 446 | 1 | 0 | 445 | 39.6429169 | -90.47814431 | 2021-02-18 05:22:58 | Scott, Illinois, US |
2284578 | 2284578 | 2021-02-14 | US | Iowa | Audubon | 19009 | 454 | 9 | 0 | 445 | 41.6844628 | -94.90581859 | 2021-02-15 05:24:49 | Audubon, Iowa, US |
2681044 | 2681044 | 2021-02-13 | US | Texas | Sutton | 48435 | 404 | 8 | 0 | 445 | 30.49856623 | -100.5382014 | 2021-02-14 05:23:43 | Sutton, Texas, US |
2640940 | 2640940 | 2021-02-11 | US | Texas | Sutton | 48435 | 404 | 8 | 0 | 445 | 30.49856623 | -100.5382014 | 2021-02-12 05:23:29 | Sutton, Texas, US |
3981855 | 3981855 | 2021-02-10 | US | Vermont | Orange | 50017 | 447 | 2 | 0 | 445 | 44.00470222 | -72.37640104 | 2021-02-11 05:23:55 | Orange, Vermont, US |
977010 | 977010 | 2021-02-06 | US | Nebraska | Morrill | 31123 | 460 | 15 | 0 | 445 | 41.71711774 | -103.0061405 | 2021-02-07 05:23:00 | Morrill, Nebraska, US |
1590268 | 1590268 | 2021-02-05 | US | Nebraska | Morrill | 31123 | 460 | 15 | 0 | 445 | 41.71711774 | -103.0061405 | 2021-02-06 05:23:55 | Morrill, Nebraska, US |
793626 | 793626 | 2021-02-04 | US | Texas | Wheeler | 48483 | 553 | 9 | 0 | 445 | 35.40114335 | -100.2699514 | 2021-02-05 05:22:38 | Wheeler, Texas, US |
792262 | 792262 | 2021-02-04 | US | Missouri | Clark | 29045 | 451 | 6 | 0 | 445 | 40.41040752 | -91.73661677 | 2021-02-05 05:22:38 | Clark, Missouri, US |
340347 | 340347 | 2021-02-03 | Mauritania | 16720 | 424 | 15851 | 445 | 21.0079 | -10.9408 | 2021-02-04 05:22:26 | Mauritania | |||
1686482 | 1686482 | 2021-02-02 | US | Montana | Chouteau | 30015 | 450 | 5 | 0 | 445 | 47.88084126 | -110.4353362 | 2021-02-03 05:22:52 | Chouteau, Montana, US |
1677837 | 1677837 | 2021-02-01 | US | Kentucky | Bracken | 21023 | 448 | 3 | 0 | 445 | 38.69158994 | -84.08532444 | 2021-02-02 05:22:49 | Bracken, Kentucky, US |
2215201 | 2215201 | 2021-01-30 | US | Wisconsin | Florence | 55037 | 457 | 12 | 0 | 445 | 45.84963535 | -88.39804137 | 2021-01-31 05:22:42 | Florence, Wisconsin, US |
2484516 | 2484516 | 2021-01-28 | US | Oklahoma | Greer | 40055 | 458 | 13 | 0 | 445 | 34.93535801 | -99.5605612 | 2021-01-29 05:22:23 | Greer, Oklahoma, US |
2483806 | 2483806 | 2021-01-28 | US | Mississippi | Sharkey | 28125 | 462 | 17 | 0 | 445 | 32.88149103 | -90.8159538 | 2021-01-29 05:22:23 | Sharkey, Mississippi, US |
3156151 | 3156151 | 2021-01-27 | US | Oklahoma | Greer | 40055 | 458 | 13 | 0 | 445 | 34.93535801 | -99.5605612 | 2021-01-28 05:22:24 | Greer, Oklahoma, US |
2570522 | 2570522 | 2021-01-25 | US | South Dakota | Edmunds | 46045 | 453 | 8 | 0 | 445 | 45.41846445 | -99.21545423 | 2021-01-26 05:22:02 | Edmunds, South Dakota, US |
1761195 | 1761195 | 2021-01-24 | US | Missouri | Hickory | 29085 | 455 | 10 | 0 | 445 | 37.94163617 | -93.3203037 | 2021-01-25 05:22:16 | Hickory, Missouri, US |
2429758 | 2429758 | 2021-01-23 | US | South Dakota | Deuel | 46039 | 452 | 7 | 0 | 445 | 44.75994309 | -96.66943645 | 2021-01-24 05:22:35 | Deuel, South Dakota, US |
2428802 | 2428802 | 2021-01-23 | US | Missouri | Hickory | 29085 | 455 | 10 | 0 | 445 | 37.94163617 | -93.3203037 | 2021-01-24 05:22:35 | Hickory, Missouri, US |
2468704 | 2468704 | 2021-01-22 | US | Missouri | Hickory | 29085 | 455 | 10 | 0 | 445 | 37.94163617 | -93.3203037 | 2021-01-23 05:22:03 | Hickory, Missouri, US |
437416 | 437416 | 2021-01-21 | US | Nebraska | Fillmore | 31059 | 454 | 9 | 0 | 445 | 40.52458567 | -97.59646937 | 2021-01-22 05:22:10 | Fillmore, Nebraska, US |
437255 | 437255 | 2021-01-21 | US | Missouri | Hickory | 29085 | 455 | 10 | 0 | 445 | 37.94163617 | -93.3203037 | 2021-01-22 05:22:10 | Hickory, Missouri, US |
436313 | 436313 | 2021-01-21 | US | Illinois | Calhoun | 17013 | 446 | 1 | 0 | 445 | 39.16840183 | -90.66330078 | 2021-01-22 05:22:10 | Calhoun, Illinois, US |
1093811 | 1093811 | 2021-01-20 | Belize | 11642 | 286 | 10911 | 445 | 17.1899 | -88.4976 | 2021-01-21 05:22:01 | Belize | |||
911028 | 911028 | 2021-01-19 | US | South Dakota | Corson | 46031 | 456 | 11 | 0 | 445 | 45.70889983 | -101.1970473 | 2021-01-20 05:21:54 | Corson, South Dakota, US |
910076 | 910076 | 2021-01-19 | US | Missouri | Hickory | 29085 | 454 | 9 | 0 | 445 | 37.94163617 | -93.3203037 | 2021-01-20 05:21:54 | Hickory, Missouri, US |
240296 | 240296 | 2021-01-18 | US | Texas | Dallam | 48111 | 853 | 20 | 0 | 445 | 36.27787176 | -102.6020725 | 2021-01-19 05:22:15 | Dallam, Texas, US |
239139 | 239139 | 2021-01-18 | US | Missouri | Hickory | 29085 | 454 | 9 | 0 | 445 | 37.94163617 | -93.3203037 | 2021-01-19 05:22:15 | Hickory, Missouri, US |
238226 | 238226 | 2021-01-18 | US | Illinois | Henderson | 17071 | 452 | 7 | 0 | 445 | 40.81908672 | -90.92491462 | 2021-01-19 05:22:15 | Henderson, Illinois, US |
3506413 | 3506413 | 2021-01-17 | US | Texas | Dallam | 48111 | 853 | 20 | 0 | 445 | 36.27787176 | -102.6020725 | 2021-01-18 05:22:34 | Dallam, Texas, US |
3505256 | 3505256 | 2021-01-17 | US | Missouri | Hickory | 29085 | 454 | 9 | 0 | 445 | 37.94163617 | -93.3203037 | 2021-01-18 05:22:34 | Hickory, Missouri, US |
3104496 | 3104496 | 2021-01-16 | US | Texas | Dallam | 48111 | 853 | 20 | 0 | 445 | 36.27787176 | -102.6020725 | 2021-01-17 05:22:17 | Dallam, Texas, US |
3103339 | 3103339 | 2021-01-16 | US | Missouri | Hickory | 29085 | 454 | 9 | 0 | 445 | 37.94163617 | -93.3203037 | 2021-01-17 05:22:17 | Hickory, Missouri, US |
3519035 | 3519035 | 2021-01-15 | Ukraine | Sevastopol* | 8130 | 308 | 7377 | 445 | 44.6054 | 33.522 | 2021-01-16 05:22:40 | Sevastopol*, Ukraine | ||
3518458 | 3518458 | 2021-01-15 | US | Texas | Dallam | 48111 | 853 | 20 | 0 | 445 | 36.27787176 | -102.6020725 | 2021-01-16 05:22:40 | Dallam, Texas, US |
3883207 | 3883207 | 2021-01-14 | Ukraine | Sevastopol* | 8034 | 302 | 7287 | 445 | 44.6054 | 33.522 | 2021-01-15 05:22:24 | Sevastopol*, Ukraine | ||
3882882 | 3882882 | 2021-01-14 | US | Virginia | Charlotte | 51037 | 454 | 9 | 0 | 445 | 37.01909701 | -78.66314092 | 2021-01-15 05:22:24 | Charlotte, Virginia, US |
3882734 | 3882734 | 2021-01-14 | US | Texas | McCulloch | 48307 | 434 | 12 | 0 | 445 | 31.1925468 | -99.34682807 | 2021-01-15 05:22:24 | McCulloch, Texas, US |
3882630 | 3882630 | 2021-01-14 | US | Texas | Dallam | 48111 | 853 | 20 | 0 | 445 | 36.27787176 | -102.6020725 | 2021-01-15 05:22:24 | Dallam, Texas, US |
3882425 | 3882425 | 2021-01-14 | US | South Dakota | Corson | 46031 | 456 | 11 | 0 | 445 | 45.70889983 | -101.1970473 | 2021-01-15 05:22:24 | Corson, South Dakota, US |
3881508 | 3881508 | 2021-01-14 | US | Missouri | Ozark | 29153 | 450 | 5 | 0 | 445 | 36.64916339 | -92.44459066 | 2021-01-15 05:22:24 | Ozark, Missouri, US |
3881477 | 3881477 | 2021-01-14 | US | Missouri | Iron | 29093 | 446 | 1 | 0 | 445 | 37.55487945 | -90.7735296 | 2021-01-15 05:22:24 | Iron, Missouri, US |
3311361 | 3311361 | 2021-01-13 | US | Texas | McCulloch | 48307 | 434 | 12 | 0 | 445 | 31.1925468 | -99.34682807 | 2021-01-14 05:22:32 | McCulloch, Texas, US |
3311257 | 3311257 | 2021-01-13 | US | Texas | Dallam | 48111 | 853 | 20 | 0 | 445 | 36.27787176 | -102.6020725 | 2021-01-14 05:22:32 | Dallam, Texas, US |
3309176 | 3309176 | 2021-01-13 | US | Illinois | Edwards | 17047 | 452 | 7 | 0 | 445 | 38.41353228 | -88.05720863 | 2021-01-14 05:22:32 | Edwards, Illinois, US |
777402 | 777402 | 2021-01-12 | US | Texas | Dallam | 48111 | 853 | 20 | 0 | 445 | 36.27787176 | -102.6020725 | 2021-01-13 05:22:15 | Dallam, Texas, US |
775633 | 775633 | 2021-01-12 | US | Kansas | Harper | 20077 | 463 | 18 | 0 | 445 | 37.19175361 | -98.07578384 | 2021-01-13 05:22:15 | Harper, Kansas, US |
191354 | 191354 | 2021-01-11 | US | Kansas | Harper | 20077 | 463 | 18 | 0 | 445 | 37.19175361 | -98.07578384 | 2021-01-12 05:22:15 | Harper, Kansas, US |
3903272 | 3903272 | 2021-01-09 | US | Virginia | Covington | 51580 | 449 | 4 | 0 | 445 | 37.7824656 | -79.98631446 | 2021-01-10 05:22:12 | Covington, Virginia, US |
154602 | 154602 | 2021-01-08 | US | Colorado | Kit Carson | 8063 | 488 | 10 | 0 | 445 | 39.30497777 | -102.6022199 | 2021-01-09 05:22:18 | Kit Carson, Colorado, US |
2544461 | 2544461 | 2021-01-07 | US | Texas | Dallam | 48111 | 852 | 19 | 0 | 445 | 36.27787176 | -102.6020725 | 2021-01-08 05:22:42 | Dallam, Texas, US |
2541626 | 2541626 | 2021-01-07 | Russia | Magadan Oblast | 7248 | 65 | 6738 | 445 | 62.48858785 | 153.9903764 | 2021-01-08 05:22:42 | Magadan Oblast, Russia | ||
2867829 | 2867829 | 2021-01-06 | US | Texas | Hudspeth | 48229 | 605 | 8 | 0 | 445 | 31.45628381 | -105.388178 | 2021-01-07 05:22:03 | Hudspeth, Texas, US |
2867770 | 2867770 | 2021-01-06 | US | Texas | Dallam | 48111 | 852 | 19 | 0 | 445 | 36.27787176 | -102.6020725 | 2021-01-07 05:22:03 | Dallam, Texas, US |
3037416 | 3037416 | 2021-01-05 | US | Texas | Hudspeth | 48229 | 605 | 8 | 0 | 445 | 31.45628381 | -105.388178 | 2021-01-06 05:22:16 | Hudspeth, Texas, US |
3035992 | 3035992 | 2021-01-05 | US | Minnesota | Big Stone | 27011 | 448 | 3 | 0 | 445 | 45.42712824 | -96.41403739 | 2021-01-06 05:22:16 | Big Stone, Minnesota, US |
3034323 | 3034323 | 2021-01-05 | Japan | Kumamoto | 2050 | 25 | 1580 | 445 | 32.608154 | 130.74523100000002 | 2021-01-06 05:22:16 | Kumamoto, Japan | ||
1065050 | 1065050 | 2021-01-04 | US | Texas | San Jacinto | 48407 | 1054 | 19 | 0 | 445 | 30.57933681 | -95.16260304 | 2021-01-05 05:21:49 | San Jacinto, Texas, US |
1065042 | 1065042 | 2021-01-04 | US | Texas | Refugio | 48391 | 504 | 17 | 0 | 445 | 28.3238976 | -97.15766311 | 2021-01-05 05:21:49 | Refugio, Texas, US |
1065040 | 1065040 | 2021-01-04 | US | Texas | Red River | 48387 | 514 | 27 | 0 | 445 | 33.61886692 | -95.04841765 | 2021-01-05 05:21:49 | Red River, Texas, US |
3233645 | 3233645 | 2021-01-03 | US | Texas | Refugio | 48391 | 504 | 17 | 0 | 445 | 28.3238976 | -97.15766311 | 2021-01-04 05:22:02 | Refugio, Texas, US |
3233215 | 3233215 | 2021-01-03 | US | Puerto Rico | Salinas | 72123 | 445 | 0 | 0 | 445 | 18.010386999999994 | -66.256592 | 2021-01-04 05:22:02 | Salinas, Puerto Rico, US |
3231489 | 3231489 | 2021-01-03 | US | Illinois | Stark | 17175 | 464 | 19 | 0 | 445 | 41.09309773 | -89.79745866 | 2021-01-04 05:22:02 | Stark, Illinois, US |
2229670 | 2229670 | 2021-01-02 | US | New Hampshire | Sullivan | 33019 | 451 | 6 | 0 | 445 | 43.36094111 | -72.22203125 | 2021-01-03 05:22:52 | Sullivan, New Hampshire, US |
1138120 | 1138120 | 2021-01-01 | US | Iowa | Van Buren | 19177 | 456 | 11 | 0 | 445 | 40.75326764 | -91.95017958 | 2021-01-02 05:22:33 | Van Buren, Iowa, US |
1013654 | 1013654 | 2020-12-30 | US | Virginia | King William | 51101 | 449 | 4 | 0 | 445 | 37.70965316 | -77.09384941 | 2020-12-31 05:22:49 | King William, Virginia, US |
1011259 | 1011259 | 2020-12-30 | US | Illinois | Brown | 17009 | 450 | 5 | 0 | 445 | 39.96209138 | -90.75068024 | 2020-12-31 05:22:49 | Brown, Illinois, US |
769615 | 769615 | 2020-12-29 | US | Virginia | Bland | 51021 | 451 | 6 | 0 | 445 | 37.13128068 | -81.13599391 | 2020-12-30 05:22:34 | Bland, Virginia, US |
769601 | 769601 | 2020-12-29 | US | Vermont | Windham | 50025 | 450 | 5 | 0 | 445 | 42.986982 | -72.71268875 | 2020-12-30 05:22:34 | Windham, Vermont, 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]);