johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
568 rows where active = 414 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 466
- Russia 14
- Japan 10
- Chile 8
- Ukraine 7
- Colombia 6
- Malaysia 4
- Mexico 4
- Canada 3
- China 3
- Congo (Kinshasa) 3
- Equatorial Guinea 3
- Italy 3
- Sierra Leone 3
- Togo 3
- Zambia 3
- Brazil 2
- Germany 2
- Guinea-Bissau 2
- Malawi 2
- Pakistan 2
- Slovakia 2
- Belize 1
- Chad 1
- Cuba 1
- India 1
- Maldives 1
- Mali 1
- Saint Lucia 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
331816 | 331816 | 2021-08-04 | Germany | Brandenburg | 109381 | 3818 | 105200 | 414 | 52.4125 | 12.5316 | 2021-08-05 04:21:51 | Brandenburg, Germany | ||
331720 | 331720 | 2021-08-04 | China | Jiangsu | 1166 | 0 | 752 | 414 | 32.9711 | 119.455 | 2021-08-05 04:21:51 | Jiangsu, China | ||
3903993 | 3903993 | 2021-07-31 | Japan | Kumamoto | 6996 | 121 | 6461 | 414 | 32.608154 | 130.74523100000002 | 2021-08-01 04:21:50 | Kumamoto, Japan | ||
625655 | 625655 | 2021-07-10 | Canada | Saskatchewan | 49240 | 572 | 48254 | 414 | 52.9399 | -106.4509 | 2021-07-11 04:21:43 | Saskatchewan, Canada | ||
778154 | 778154 | 2021-07-08 | Chile | Nuble | 34470 | 585 | 33471 | 414 | -36.7226 | -71.7622 | 2021-07-09 04:21:21 | Nuble, Chile | ||
2693694 | 2693694 | 2021-07-06 | Japan | Fukuoka | 35697 | 523 | 34760 | 414 | 33.526032 | 130.666949 | 2021-07-07 04:21:20 | Fukuoka, Japan | ||
1932775 | 1932775 | 2021-07-05 | Togo | 14082 | 132 | 13536 | 414 | 8.6195 | 0.8248 | 2021-07-06 04:21:32 | Togo | |||
400173 | 400173 | 2021-06-29 | Germany | Berlin | 180132 | 3557 | 176200 | 414 | 52.52 | 13.405 | 2021-06-30 04:21:41 | Berlin, Germany | ||
400119 | 400119 | 2021-06-29 | Colombia | Putumayo | 13552 | 563 | 12575 | 414 | 0.436 | -75.5277 | 2021-06-30 04:21:41 | Putumayo, Colombia | ||
563109 | 563109 | 2021-06-22 | Pakistan | Azad Jammu and Kashmir | 20019 | 574 | 19031 | 414 | 34.027401 | 73.947253 | 2021-06-23 04:21:46 | Azad Jammu and Kashmir, Pakistan | ||
2888004 | 2888004 | 2021-06-20 | Ukraine | Poltava Oblast | 77671 | 1842 | 75415 | 414 | 49.5883 | 34.5514 | 2021-06-21 04:21:41 | Poltava Oblast, Ukraine | ||
1563877 | 1563877 | 2021-06-14 | Chile | Aysen | 6946 | 49 | 6483 | 414 | -45.9864 | -73.7669 | 2021-06-15 04:22:22 | Aysen, Chile | ||
1708516 | 1708516 | 2021-06-02 | Russia | Kamchatka Krai | 14709 | 231 | 14064 | 414 | 57.1914882 | 160.03838190000005 | 2021-06-03 04:23:32 | Kamchatka Krai, Russia | ||
1310381 | 1310381 | 2021-05-26 | Russia | Komi Republic | 43980 | 962 | 42604 | 414 | 63.9881421 | 54.3326073 | 2021-05-27 04:20:59 | Komi Republic, Russia | ||
1913056 | 1913056 | 2021-05-20 | Colombia | Choco | 9973 | 263 | 9296 | 414 | 5.2528 | -76.82600000000002 | 2021-05-21 04:20:43 | Choco, Colombia | ||
3578231 | 3578231 | 2021-05-17 | Ukraine | Sevastopol* | 14457 | 660 | 13383 | 414 | 44.6054 | 33.522 | 2021-05-18 04:20:33 | Sevastopol*, Ukraine | ||
3574800 | 3574800 | 2021-05-17 | Russia | Kamchatka Krai | 14585 | 231 | 13940 | 414 | 57.1914882 | 160.03838190000005 | 2021-05-18 04:20:33 | Kamchatka Krai, Russia | ||
3113675 | 3113675 | 2021-05-06 | Russia | Buryatia Republic | 37301 | 858 | 36029 | 414 | 52.7182426 | 109.492143 | 2021-05-07 04:20:40 | Buryatia Republic, Russia | ||
3705790 | 3705790 | 2021-04-27 | Malaysia | Perak | 14469 | 44 | 14011 | 414 | 4.5921 | 101.0901 | 2021-04-28 04:20:32 | Perak, Malaysia | ||
891798 | 891798 | 2021-04-26 | Malaysia | Pahang | 4985 | 18 | 4553 | 414 | 3.8126 | 103.3256 | 2021-04-27 04:20:52 | Pahang, Malaysia | ||
3883770 | 3883770 | 2021-04-11 | Russia | Adygea Republic | 14220 | 168 | 13638 | 414 | 44.6939006 | 40.1520421 | 2021-04-12 04:21:00 | Adygea Republic, Russia | ||
2645603 | 2645603 | 2021-04-08 | Colombia | La Guajira | 19821 | 690 | 18717 | 414 | 11.3548 | -72.5205 | 2021-04-09 04:21:13 | La Guajira, Colombia | ||
3085306 | 3085306 | 2021-04-05 | Japan | Fukuoka | 19160 | 333 | 18413 | 414 | 33.526032 | 130.666949 | 2021-04-06 04:20:32 | Fukuoka, Japan | ||
1880871 | 1880871 | 2021-03-26 | Equatorial Guinea | 6851 | 102 | 6335 | 414 | 1.6508 | 10.2679 | 2021-03-27 05:25:04 | Equatorial Guinea | |||
1980501 | 1980501 | 2021-03-25 | Equatorial Guinea | 6851 | 102 | 6335 | 414 | 1.6508 | 10.2679 | 2021-03-26 05:26:55 | Equatorial Guinea | |||
2780879 | 2780879 | 2021-03-24 | Equatorial Guinea | 6851 | 102 | 6335 | 414 | 1.6508 | 10.2679 | 2021-03-25 05:27:00 | Equatorial Guinea | |||
3453126 | 3453126 | 2021-03-18 | San Marino | 4249 | 77 | 3758 | 414 | 43.9424 | 12.4578 | 2021-03-19 05:26:09 | San Marino | |||
3667402 | 3667402 | 2021-03-06 | Chad | 4161 | 140 | 3607 | 414 | 15.4542 | 18.7322 | 2021-03-07 05:21:54 | Chad | |||
3255485 | 3255485 | 2021-03-02 | US | Kansas | Sheridan | 20179 | 426 | 12 | 0 | 414 | 39.35018161 | -100.4418259 | 2021-03-03 05:23:28 | Sheridan, Kansas, US |
999777 | 999777 | 2021-03-01 | US | Kansas | Sheridan | 20179 | 426 | 12 | 0 | 414 | 39.35018161 | -100.4418259 | 2021-03-02 05:23:30 | Sheridan, Kansas, US |
2368835 | 2368835 | 2021-02-28 | US | Kansas | Sheridan | 20179 | 426 | 12 | 0 | 414 | 39.35018161 | -100.4418259 | 2021-03-01 05:23:01 | Sheridan, Kansas, US |
3067337 | 3067337 | 2021-02-27 | US | Kansas | Sheridan | 20179 | 426 | 12 | 0 | 414 | 39.35018161 | -100.4418259 | 2021-02-28 05:22:20 | Sheridan, Kansas, US |
2184921 | 2184921 | 2021-02-26 | US | Kansas | Sheridan | 20179 | 426 | 12 | 0 | 414 | 39.35018161 | -100.4418259 | 2021-02-27 05:22:28 | Sheridan, Kansas, US |
1859343 | 1859343 | 2021-02-25 | US | Kansas | Sheridan | 20179 | 426 | 12 | 0 | 414 | 39.35018161 | -100.4418259 | 2021-02-26 05:22:40 | Sheridan, Kansas, US |
282057 | 282057 | 2021-02-24 | US | Missouri | Carter | 29035 | 422 | 8 | 0 | 414 | 36.94160441 | -90.96051322 | 2021-02-25 05:24:57 | Carter, Missouri, US |
281521 | 281521 | 2021-02-24 | US | Kansas | Sheridan | 20179 | 426 | 12 | 0 | 414 | 39.35018161 | -100.4418259 | 2021-02-25 05:24:57 | Sheridan, Kansas, US |
1937789 | 1937789 | 2021-02-23 | US | Kansas | Sheridan | 20179 | 426 | 12 | 0 | 414 | 39.35018161 | -100.4418259 | 2021-02-24 05:29:16 | Sheridan, Kansas, US |
532583 | 532583 | 2021-02-22 | US | Missouri | Chariton | 29041 | 420 | 6 | 0 | 414 | 39.51499357 | -92.9629191 | 2021-02-23 05:23:41 | Chariton, Missouri, US |
532044 | 532044 | 2021-02-22 | US | Kansas | Sheridan | 20179 | 426 | 12 | 0 | 414 | 39.35018161 | -100.4418259 | 2021-02-23 05:23:41 | Sheridan, Kansas, US |
183378 | 183378 | 2021-02-21 | US | Kansas | Sheridan | 20179 | 426 | 12 | 0 | 414 | 39.35018161 | -100.4418259 | 2021-02-22 05:24:21 | Sheridan, Kansas, US |
743652 | 743652 | 2021-02-20 | US | Kansas | Sheridan | 20179 | 426 | 12 | 0 | 414 | 39.35018161 | -100.4418259 | 2021-02-21 05:24:33 | Sheridan, Kansas, US |
472750 | 472750 | 2021-02-19 | US | Kansas | Sheridan | 20179 | 426 | 12 | 0 | 414 | 39.35018161 | -100.4418259 | 2021-02-20 05:22:51 | Sheridan, Kansas, US |
1154459 | 1154459 | 2021-02-18 | US | Kansas | Sheridan | 20179 | 426 | 12 | 0 | 414 | 39.35018161 | -100.4418259 | 2021-02-19 05:24:16 | Sheridan, Kansas, US |
3603468 | 3603468 | 2021-02-17 | US | North Dakota | Wells | 38103 | 421 | 8 | 0 | 414 | 47.58614526 | -99.65904998 | 2021-02-18 05:22:58 | Wells, North Dakota, US |
3602379 | 3602379 | 2021-02-17 | US | Kansas | Sheridan | 20179 | 426 | 12 | 0 | 414 | 39.35018161 | -100.4418259 | 2021-02-18 05:22:58 | Sheridan, Kansas, US |
3052603 | 3052603 | 2021-02-16 | US | North Dakota | Wells | 38103 | 420 | 8 | 0 | 414 | 47.58614526 | -99.65904998 | 2021-02-17 05:23:10 | Wells, North Dakota, US |
3051708 | 3051708 | 2021-02-16 | US | Louisiana | Unassigned | 90022 | 414 | 0 | 0 | 414 | 32.83121059 | 0.0 | 2021-02-17 05:23:10 | Unassigned, Louisiana, US |
3051514 | 3051514 | 2021-02-16 | US | Kansas | Sheridan | 20179 | 426 | 12 | 0 | 414 | 39.35018161 | -100.4418259 | 2021-02-17 05:23:10 | Sheridan, Kansas, US |
3050189 | 3050189 | 2021-02-16 | Japan | Ibaraki | 5410 | 99 | 4897 | 414 | 36.303588 | 140.319591 | 2021-02-17 05:23:10 | Ibaraki, Japan | ||
3049961 | 3049961 | 2021-02-16 | Chile | Atacama | 11260 | 142 | 10704 | 414 | -27.5661 | -70.0503 | 2021-02-17 05:23:10 | Atacama, Chile | ||
1339807 | 1339807 | 2021-02-15 | US | Louisiana | Unassigned | 90022 | 414 | 0 | 0 | 414 | 32.83121059 | 0.0 | 2021-02-16 05:24:38 | Unassigned, Louisiana, US |
1339613 | 1339613 | 2021-02-15 | US | Kansas | Sheridan | 20179 | 426 | 12 | 0 | 414 | 39.35018161 | -100.4418259 | 2021-02-16 05:24:38 | Sheridan, Kansas, US |
1338204 | 1338204 | 2021-02-15 | Guinea-Bissau | 2924 | 46 | 2464 | 414 | 11.8037 | -15.1804 | 2021-02-16 05:24:38 | Guinea-Bissau | |||
2285449 | 2285449 | 2021-02-14 | US | Montana | Teton | 30099 | 419 | 5 | 0 | 414 | 47.83741052 | -112.2410688 | 2021-02-15 05:24:49 | Teton, Montana, US |
2283355 | 2283355 | 2021-02-14 | Guinea-Bissau | 2924 | 46 | 2464 | 414 | 11.8037 | -15.1804 | 2021-02-15 05:24:49 | Guinea-Bissau | |||
2677637 | 2677637 | 2021-02-13 | China | Hong Kong | 10767 | 193 | 10160 | 414 | 22.3 | 114.2 | 2021-02-14 05:23:43 | Hong Kong, China | ||
2640137 | 2640137 | 2021-02-11 | US | North Dakota | Sargent | 38081 | 409 | 6 | 0 | 414 | 46.10830372 | -97.63217159 | 2021-02-12 05:23:29 | Sargent, North Dakota, US |
3979444 | 3979444 | 2021-02-10 | US | Georgia | Talbot | 13263 | 427 | 13 | 0 | 414 | 32.69642758 | -84.53351366 | 2021-02-11 05:23:55 | Talbot, Georgia, US |
1673989 | 1673989 | 2021-02-07 | US | Louisiana | Unassigned | 90022 | 414 | 0 | 0 | 414 | 32.83121059 | 0.0 | 2021-02-08 05:22:39 | Unassigned, Louisiana, US |
976344 | 976344 | 2021-02-06 | US | Kentucky | Lyon | 21143 | 426 | 12 | 0 | 414 | 37.02080035 | -88.07886257 | 2021-02-07 05:23:00 | Lyon, Kentucky, US |
976292 | 976292 | 2021-02-06 | US | Kentucky | Carlisle | 21039 | 415 | 1 | 0 | 414 | 36.85372876 | -88.96692220000001 | 2021-02-07 05:23:00 | Carlisle, Kentucky, US |
1589550 | 1589550 | 2021-02-05 | US | Kentucky | Carlisle | 21039 | 415 | 1 | 0 | 414 | 36.85372876 | -88.96692220000001 | 2021-02-06 05:23:55 | Carlisle, Kentucky, US |
791335 | 791335 | 2021-02-04 | US | Illinois | Alexander | 17003 | 422 | 8 | 0 | 414 | 37.18049267 | -89.32910838 | 2021-02-05 05:22:38 | Alexander, Illinois, US |
343329 | 343329 | 2021-02-03 | US | Texas | Crosby | 48107 | 737 | 25 | 0 | 414 | 33.61431553 | -101.3000364 | 2021-02-04 05:22:26 | Crosby, Texas, US |
1686916 | 1686916 | 2021-02-02 | US | North Dakota | Sargent | 38081 | 405 | 6 | 0 | 414 | 46.10830372 | -97.63217159 | 2021-02-03 05:22:52 | Sargent, North Dakota, US |
1459781 | 1459781 | 2021-01-31 | Japan | Mie | 2188 | 30 | 1744 | 414 | 34.508018 | 136.376013 | 2021-02-01 05:22:53 | Mie, Japan | ||
2213395 | 2213395 | 2021-01-30 | US | Minnesota | Mahnomen | 27087 | 421 | 7 | 0 | 414 | 47.32557075 | -95.80921485 | 2021-01-31 05:22:42 | Mahnomen, Minnesota, US |
1900478 | 1900478 | 2021-01-29 | US | Virginia | Fairfax City | 51600 | 426 | 12 | 0 | 414 | 38.85157547 | -77.29779640000002 | 2021-01-30 05:22:49 | Fairfax City, Virginia, US |
2483502 | 2483502 | 2021-01-28 | US | Louisiana | Unassigned | 90022 | 414 | 0 | 0 | 414 | 32.83121059 | 0.0 | 2021-01-29 05:22:23 | Unassigned, Louisiana, US |
3155716 | 3155716 | 2021-01-27 | US | Nebraska | Sheridan | 31161 | 427 | 13 | 0 | 414 | 42.50284406 | -102.4126613 | 2021-01-28 05:22:24 | Sheridan, Nebraska, US |
2567930 | 2567930 | 2021-01-25 | Saint Lucia | 886 | 11 | 461 | 414 | 13.9094 | -60.9789 | 2021-01-26 05:22:02 | Saint Lucia | |||
1762044 | 1762044 | 2021-01-24 | US | Puerto Rico | Luquillo | 72089 | 414 | 0 | 0 | 414 | 18.342114 | -65.72509699999999 | 2021-01-25 05:22:16 | Luquillo, Puerto Rico, US |
1760448 | 1760448 | 2021-01-24 | US | Iowa | Audubon | 19009 | 422 | 8 | 0 | 414 | 41.6844628 | -94.90581859 | 2021-01-25 05:22:16 | Audubon, Iowa, US |
1759318 | 1759318 | 2021-01-24 | Japan | Mie | 2000 | 28 | 1558 | 414 | 34.508018 | 136.376013 | 2021-01-25 05:22:16 | Mie, Japan | ||
2429651 | 2429651 | 2021-01-23 | US | Puerto Rico | Luquillo | 72089 | 414 | 0 | 0 | 414 | 18.342114 | -65.72509699999999 | 2021-01-24 05:22:35 | Luquillo, Puerto Rico, US |
2428269 | 2428269 | 2021-01-23 | US | Kentucky | Bracken | 21023 | 417 | 3 | 0 | 414 | 38.69158994 | -84.08532444 | 2021-01-24 05:22:35 | Bracken, Kentucky, US |
437401 | 437401 | 2021-01-21 | US | Nebraska | Chase | 31029 | 417 | 3 | 0 | 414 | 40.5237198 | -101.6978026 | 2021-01-22 05:22:10 | Chase, Nebraska, US |
436888 | 436888 | 2021-01-21 | US | Louisiana | Unassigned | 90022 | 414 | 0 | 0 | 414 | 32.83121059 | 0.0 | 2021-01-22 05:22:10 | Unassigned, Louisiana, US |
435381 | 435381 | 2021-01-21 | Japan | Nagano | 2102 | 26 | 1662 | 414 | 36.132134 | 138.045528 | 2021-01-22 05:22:10 | Nagano, Japan | ||
1094517 | 1094517 | 2021-01-20 | US | Alaska | Southeast Fairbanks | 2240 | 417 | 3 | 0 | 414 | 63.87692095 | -143.2127643 | 2021-01-21 05:22:01 | Southeast Fairbanks, Alaska, US |
910310 | 910310 | 2021-01-19 | US | Nevada | Lander | 32015 | 422 | 8 | 0 | 414 | 39.9332233 | -117.0397075 | 2021-01-20 05:21:54 | Lander, Nevada, US |
910013 | 910013 | 2021-01-19 | US | Mississippi | Sharkey | 28125 | 431 | 17 | 0 | 414 | 32.88149103 | -90.8159538 | 2021-01-20 05:21:54 | Sharkey, Mississippi, US |
3504889 | 3504889 | 2021-01-17 | US | Louisiana | Unassigned | 90022 | 414 | 0 | 0 | 414 | 32.83121059 | 0.0 | 2021-01-18 05:22:34 | Unassigned, Louisiana, US |
3104481 | 3104481 | 2021-01-16 | US | Texas | Coke | 48081 | 351 | 10 | 0 | 414 | 31.88911733 | -100.5297533 | 2021-01-17 05:22:17 | Coke, Texas, US |
3103179 | 3103179 | 2021-01-16 | US | Minnesota | Norman | 27107 | 422 | 8 | 0 | 414 | 47.32628443 | -96.45620947 | 2021-01-17 05:22:17 | Norman, Minnesota, US |
3882698 | 3882698 | 2021-01-14 | US | Texas | Jim Hogg | 48247 | 504 | 11 | 0 | 414 | 27.04453923 | -98.6968187 | 2021-01-15 05:22:24 | Jim Hogg, Texas, US |
3310747 | 3310747 | 2021-01-13 | US | Oklahoma | Greer | 40055 | 423 | 9 | 0 | 414 | 34.93535801 | -99.5605612 | 2021-01-14 05:22:32 | Greer, Oklahoma, US |
776752 | 776752 | 2021-01-12 | US | North Dakota | Nelson | 38063 | 423 | 12 | 0 | 414 | 47.9226426 | -98.19038437 | 2021-01-13 05:22:15 | Nelson, North Dakota, US |
3901892 | 3901892 | 2021-01-09 | US | Missouri | Ozark | 29153 | 418 | 4 | 0 | 414 | 36.64916339 | -92.44459066 | 2021-01-10 05:22:12 | Ozark, Missouri, US |
3901445 | 3901445 | 2021-01-09 | US | Louisiana | Cameron | 22023 | 418 | 4 | 0 | 414 | 29.87592238 | -93.19310676 | 2021-01-10 05:22:12 | Cameron, Louisiana, US |
155468 | 155468 | 2021-01-08 | US | Louisiana | Cameron | 22023 | 418 | 4 | 0 | 414 | 29.87592238 | -93.19310676 | 2021-01-09 05:22:18 | Cameron, Louisiana, US |
2543497 | 2543497 | 2021-01-07 | US | Nebraska | Morrill | 31123 | 426 | 12 | 0 | 414 | 41.71711774 | -103.0061405 | 2021-01-08 05:22:42 | Morrill, Nebraska, US |
2541430 | 2541430 | 2021-01-07 | Japan | Miyagi | 2427 | 16 | 1997 | 414 | 38.446859 | 140.927086 | 2021-01-08 05:22:42 | Miyagi, Japan | ||
2865242 | 2865242 | 2021-01-06 | US | Arkansas | Woodruff | 5147 | 416 | 2 | 0 | 414 | 35.18902527 | -91.2439489 | 2021-01-07 05:22:03 | Woodruff, Arkansas, US |
3034049 | 3034049 | 2021-01-05 | Brazil | Piaui | 144857 | 2873 | 140923 | 414 | -7.7183 | -42.7289 | 2021-01-06 05:22:16 | Piaui, Brazil | ||
1064965 | 1064965 | 2021-01-04 | US | Texas | Jack | 48237 | 416 | 9 | 0 | 414 | 33.23377248 | -98.17283469 | 2021-01-05 05:21:49 | Jack, Texas, US |
1064157 | 1064157 | 2021-01-04 | US | North Carolina | Graham | 37075 | 425 | 11 | 0 | 414 | 35.3506925 | -83.83369267 | 2021-01-05 05:21:49 | Graham, North Carolina, US |
1063400 | 1063400 | 2021-01-04 | US | Maine | Sagadahoc | 23023 | 415 | 1 | 0 | 414 | 43.95415864 | -69.85074999 | 2021-01-05 05:21:49 | Sagadahoc, Maine, US |
3233568 | 3233568 | 2021-01-03 | US | Texas | Jack | 48237 | 416 | 9 | 0 | 414 | 33.23377248 | -98.17283469 | 2021-01-04 05:22:02 | Jack, Texas, US |
3230448 | 3230448 | 2021-01-03 | Italy | Valle d'Aosta | 7332 | 386 | 6532 | 414 | 45.73750286 | 7.320149366 | 2021-01-04 05:22:02 | Valle d'Aosta, Italy |
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]);