johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
740 rows where active = 234 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 636
- Japan 16
- Ukraine 9
- Colombia 8
- India 8
- Chile 7
- France 6
- Russia 6
- Mexico 5
- Andorra 4
- Mauritius 4
- Papua New Guinea 4
- Cote d'Ivoire 3
- Togo 3
- Germany 2
- Netherlands 2
- North Macedonia 2
- Pakistan 2
- Cabo Verde 1
- China 1
- Italy 1
- Kyrgyzstan 1
- Malawi 1
- Malaysia 1
- Monaco 1
- Saint Vincent and the Grenadines 1
- Singapore 1
- Slovenia 1
- Taiwan* 1
- United Kingdom 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3468203 | 3468203 | 2021-08-03 | Japan | Nagasaki | 3550 | 69 | 3247 | 234 | 33.235712 | 129.608033 | 2021-08-04 04:21:25 | Nagasaki, Japan | ||
3468127 | 3468127 | 2021-08-03 | India | Jharkhand | 347246 | 5129 | 341883 | 234 | 23.654536 | 85.557631 | 2021-08-04 04:21:25 | Jharkhand, India | ||
3018996 | 3018996 | 2021-08-01 | Ukraine | Zhytomyr Oblast | 88854 | 1805 | 86815 | 234 | 50.2547 | 28.6587 | 2021-08-02 04:21:36 | Zhytomyr Oblast, Ukraine | ||
3907602 | 3907602 | 2021-07-31 | Ukraine | Khmelnytskyi Oblast | 89263 | 1893 | 87136 | 234 | 49.423 | 26.9871 | 2021-08-01 04:21:50 | Khmelnytskyi Oblast, Ukraine | ||
3295971 | 3295971 | 2021-07-30 | Chile | Nuble | 35280 | 618 | 34428 | 234 | -36.7226 | -71.7622 | 2021-07-31 04:21:35 | Nuble, Chile | ||
1306178 | 1306178 | 2021-07-27 | Japan | Miyagi | 9711 | 91 | 9386 | 234 | 38.446859 | 140.927086 | 2021-07-28 04:21:39 | Miyagi, Japan | ||
1305999 | 1305999 | 2021-07-27 | Colombia | Choco | 15859 | 381 | 15244 | 234 | 5.2528 | -76.82600000000002 | 2021-07-28 04:21:39 | Choco, Colombia | ||
3331726 | 3331726 | 2021-07-21 | Russia | Chukotka Autonomous Okrug | 1022 | 8 | 780 | 234 | 66.0006475 | 169.4900869 | 2021-07-22 04:21:19 | Chukotka Autonomous Okrug, Russia | ||
3331669 | 3331669 | 2021-07-21 | North Macedonia | 155965 | 5488 | 150243 | 234 | 41.6086 | 21.7453 | 2021-07-22 04:21:19 | North Macedonia | |||
2371550 | 2371550 | 2021-07-20 | Japan | Tochigi | 7440 | 84 | 7122 | 234 | 36.689912 | 139.819213 | 2021-07-21 04:21:40 | Tochigi, Japan | ||
2673852 | 2673852 | 2021-07-18 | Japan | Tochigi | 7397 | 83 | 7080 | 234 | 36.689912 | 139.819213 | 2021-07-19 04:21:24 | Tochigi, Japan | ||
3744726 | 3744726 | 2021-07-12 | Ukraine | Zaporizhia Oblast | 104784 | 2447 | 102103 | 234 | 47.8388 | 35.1396 | 2021-07-13 04:21:18 | Zaporizhia Oblast, Ukraine | ||
3663239 | 3663239 | 2021-07-11 | Ukraine | Zaporizhia Oblast | 104781 | 2447 | 102100 | 234 | 47.8388 | 35.1396 | 2021-07-12 04:21:34 | Zaporizhia Oblast, Ukraine | ||
2764853 | 2764853 | 2021-07-01 | Germany | Sachsen-Anhalt | 99238 | 3428 | 95620 | 234 | 51.9503 | 11.6923 | 2021-07-02 04:21:47 | Sachsen-Anhalt, Germany | ||
1896779 | 1896779 | 2021-06-30 | Ukraine | Rivne Oblast | 79489 | 1205 | 78050 | 234 | 50.6199 | 26.2516 | 2021-07-01 04:21:19 | Rivne Oblast, Ukraine | ||
2339240 | 2339240 | 2021-06-15 | Colombia | Choco | 12791 | 317 | 12240 | 234 | 5.2528 | -76.82600000000002 | 2021-06-16 04:22:32 | Choco, Colombia | ||
1563936 | 1563936 | 2021-06-14 | Colombia | Choco | 12791 | 317 | 12240 | 234 | 5.2528 | -76.82600000000002 | 2021-06-15 04:22:22 | Choco, Colombia | ||
3472371 | 3472371 | 2021-06-08 | Mauritius | 1519 | 18 | 1206 | 234 | -20.348404 | 57.552152 | 2021-06-09 04:23:31 | Mauritius | |||
3145655 | 3145655 | 2021-06-07 | Mauritius | 1509 | 18 | 1206 | 234 | -20.348404 | 57.552152 | 2021-06-08 04:22:35 | Mauritius | |||
825657 | 825657 | 2021-06-06 | Mauritius | 1458 | 18 | 1206 | 234 | -20.348404 | 57.552152 | 2021-06-07 04:22:51 | Mauritius | |||
2586011 | 2586011 | 2021-06-05 | Japan | Miyagi | 8964 | 83 | 8647 | 234 | 38.446859 | 140.927086 | 2021-06-06 04:24:03 | Miyagi, Japan | ||
1188946 | 1188946 | 2021-05-31 | Russia | Kabardino-Balkarian Republic | 24327 | 467 | 23626 | 234 | 43.4806048 | 43.5978976 | 2021-06-01 04:23:09 | Kabardino-Balkarian Republic, Russia | ||
1952371 | 1952371 | 2021-05-21 | Colombia | San Andres y Providencia | 4865 | 74 | 4557 | 234 | 12.5567 | -81.7185 | 2021-05-22 04:20:45 | San Andres y Providencia, Colombia | ||
1913417 | 1913417 | 2021-05-20 | Russia | Karachay-Cherkess Republic | 20306 | 108 | 19964 | 234 | 43.7368326 | 41.7267991 | 2021-05-21 04:20:43 | Karachay-Cherkess Republic, Russia | ||
2390976 | 2390976 | 2021-05-18 | Russia | Karachay-Cherkess Republic | 20285 | 102 | 19949 | 234 | 43.7368326 | 41.7267991 | 2021-05-19 04:20:42 | Karachay-Cherkess Republic, Russia | ||
2390641 | 2390641 | 2021-05-18 | Cote d'Ivoire | 46708 | 298 | 46176 | 234 | 7.54 | -5.5471 | 2021-05-19 04:20:42 | Cote d'Ivoire | |||
1872826 | 1872826 | 2021-05-15 | Cote d'Ivoire | 46535 | 295 | 46006 | 234 | 7.54 | -5.5471 | 2021-05-16 04:20:49 | Cote d'Ivoire | |||
1081795 | 1081795 | 2021-05-14 | Cote d'Ivoire | 46535 | 295 | 46006 | 234 | 7.54 | -5.5471 | 2021-05-15 04:20:58 | Cote d'Ivoire | |||
1551756 | 1551756 | 2021-05-08 | Chile | Aysen | 4556 | 30 | 4292 | 234 | -45.9864 | -73.7669 | 2021-05-09 04:20:35 | Aysen, Chile | ||
2760943 | 2760943 | 2021-05-03 | Japan | Miyazaki | 2299 | 22 | 2043 | 234 | 32.193203999999994 | 131.299374 | 2021-05-04 04:20:34 | Miyazaki, Japan | ||
3924059 | 3924059 | 2021-04-24 | Japan | Yamaguchi | 1696 | 43 | 1419 | 234 | 34.201190000000004 | 131.573293 | 2021-04-25 04:20:32 | Yamaguchi, Japan | ||
1408877 | 1408877 | 2021-04-23 | Colombia | Arauca | 6275 | 183 | 5858 | 234 | 7.0762 | -70.7105 | 2021-04-24 04:20:38 | Arauca, Colombia | ||
2575343 | 2575343 | 2021-04-13 | Vietnam | 2714 | 35 | 2445 | 234 | 14.058324 | 108.277199 | 2021-04-14 04:20:41 | Vietnam | |||
3883627 | 3883627 | 2021-04-11 | Japan | Shizuoka | 5967 | 121 | 5612 | 234 | 34.916975 | 138.40778400000002 | 2021-04-12 04:21:00 | Shizuoka, Japan | ||
1290027 | 1290027 | 2021-03-29 | Japan | Kyoto | 9430 | 169 | 9027 | 234 | 35.253815 | 135.443341 | 2021-03-30 04:26:23 | Kyoto, Japan | ||
1980825 | 1980825 | 2021-03-25 | Russia | Khakassia Republic | 21751 | 499 | 21018 | 234 | 53.72258845 | 91.44293627 | 2021-03-26 05:26:55 | Khakassia Republic, Russia | ||
1838047 | 1838047 | 2021-03-12 | Netherlands | Aruba | 8320 | 77 | 8009 | 234 | 12.5211 | -69.9683 | 2021-03-13 05:25:15 | Aruba, Netherlands | ||
3671272 | 3671272 | 2021-03-06 | United Kingdom | Isle of Man | 676 | 25 | 417 | 234 | 54.2361 | -4.5481 | 2021-03-07 05:21:54 | Isle of Man, United Kingdom | ||
2211028 | 2211028 | 2021-03-04 | US | Virginia | Norton | 51720 | 240 | 6 | 0 | 234 | 36.93357076 | -82.62750411 | 2021-03-05 05:26:29 | Norton, Virginia, US |
2207509 | 2207509 | 2021-03-04 | Colombia | Putumayo | 7922 | 314 | 7374 | 234 | 0.436 | -75.5277 | 2021-03-05 05:26:29 | Putumayo, Colombia | ||
1093449 | 1093449 | 2021-03-03 | US | Virginia | Norton | 51720 | 240 | 6 | 0 | 234 | 36.93357076 | -82.62750411 | 2021-03-04 05:24:24 | Norton, Virginia, US |
3257187 | 3257187 | 2021-03-02 | US | Texas | Cochran | 48079 | 335 | 14 | 0 | 234 | 33.60425307 | -102.8284499 | 2021-03-03 05:23:28 | Cochran, Texas, US |
2186464 | 2186464 | 2021-02-26 | US | South Dakota | McPherson | 46089 | 238 | 4 | 0 | 234 | 45.76626028 | -99.22118798 | 2021-02-27 05:22:28 | McPherson, South Dakota, US |
1861300 | 1861300 | 2021-02-25 | US | Virginia | Bath | 51017 | 243 | 9 | 0 | 234 | 38.05852573 | -79.73912095 | 2021-02-26 05:22:40 | Bath, Virginia, US |
1860886 | 1860886 | 2021-02-25 | US | South Dakota | McPherson | 46089 | 238 | 4 | 0 | 234 | 45.76626028 | -99.22118798 | 2021-02-26 05:22:40 | McPherson, South Dakota, US |
283498 | 283498 | 2021-02-24 | US | Virginia | Craig | 51045 | 238 | 4 | 0 | 234 | 37.48133648 | -80.21072274 | 2021-02-25 05:24:57 | Craig, Virginia, US |
283064 | 283064 | 2021-02-24 | US | South Dakota | McPherson | 46089 | 238 | 4 | 0 | 234 | 45.76626028 | -99.22118798 | 2021-02-25 05:24:57 | McPherson, South Dakota, US |
282941 | 282941 | 2021-02-24 | US | Puerto Rico | Out of PR | 72888 | 234 | 0 | 0 | 234 | 18.459681 | -67.336525 | 2021-02-25 05:24:57 | Out of PR, Puerto Rico, US |
1939766 | 1939766 | 2021-02-23 | US | Virginia | Craig | 51045 | 238 | 4 | 0 | 234 | 37.48133648 | -80.21072274 | 2021-02-24 05:29:16 | Craig, Virginia, US |
1939209 | 1939209 | 2021-02-23 | US | Puerto Rico | Out of PR | 72888 | 234 | 0 | 0 | 234 | 18.459681 | -67.336525 | 2021-02-24 05:29:16 | Out of PR, Puerto Rico, US |
1937249 | 1937249 | 2021-02-23 | US | Georgia | Glascock | 13125 | 250 | 16 | 0 | 234 | 33.22879932 | -82.61297636 | 2021-02-24 05:29:16 | Glascock, Georgia, US |
533464 | 533464 | 2021-02-22 | US | Puerto Rico | Out of PR | 72888 | 234 | 0 | 0 | 234 | 18.459681 | -67.336525 | 2021-02-23 05:23:41 | Out of PR, Puerto Rico, US |
184798 | 184798 | 2021-02-21 | US | Puerto Rico | Out of PR | 72888 | 234 | 0 | 0 | 234 | 18.459681 | -67.336525 | 2021-02-22 05:24:21 | Out of PR, Puerto Rico, US |
181988 | 181988 | 2021-02-21 | India | Himachal Pradesh | 58385 | 995 | 57156 | 234 | 31.927213 | 77.233081 | 2021-02-22 05:24:21 | Himachal Pradesh, India | ||
745072 | 745072 | 2021-02-20 | US | Puerto Rico | Out of PR | 72888 | 234 | 0 | 0 | 234 | 18.459681 | -67.336525 | 2021-02-21 05:24:33 | Out of PR, Puerto Rico, US |
474550 | 474550 | 2021-02-19 | US | Texas | Knox | 48275 | 244 | 14 | 0 | 234 | 33.60519951 | -99.7422906 | 2021-02-20 05:22:51 | Knox, Texas, US |
1156259 | 1156259 | 2021-02-18 | US | Texas | Knox | 48275 | 244 | 14 | 0 | 234 | 33.60519951 | -99.7422906 | 2021-02-19 05:24:16 | Knox, Texas, US |
3604179 | 3604179 | 2021-02-17 | US | Texas | Knox | 48275 | 244 | 14 | 0 | 234 | 33.60519951 | -99.7422906 | 2021-02-18 05:22:58 | Knox, Texas, US |
3050810 | 3050810 | 2021-02-16 | US | Colorado | Ouray | 8091 | 254 | 3 | 0 | 234 | 38.14717457 | -107.7675136 | 2021-02-17 05:23:10 | Ouray, Colorado, US |
3050031 | 3050031 | 2021-02-16 | Colombia | Putumayo | 7721 | 306 | 7181 | 234 | 0.436 | -75.5277 | 2021-02-17 05:23:10 | Putumayo, Colombia | ||
1338909 | 1338909 | 2021-02-15 | US | Colorado | Ouray | 8091 | 254 | 3 | 0 | 234 | 38.14717457 | -107.7675136 | 2021-02-16 05:24:38 | Ouray, Colorado, US |
2284060 | 2284060 | 2021-02-14 | US | Colorado | Ouray | 8091 | 249 | 3 | 0 | 234 | 38.14717457 | -107.7675136 | 2021-02-15 05:24:49 | Ouray, Colorado, US |
2640332 | 2640332 | 2021-02-11 | US | Oregon | Harney | 41025 | 240 | 6 | 0 | 234 | 43.06422669 | -118.9666306 | 2021-02-12 05:23:29 | Harney, Oregon, US |
1672274 | 1672274 | 2021-02-07 | China | Jilin | 573 | 3 | 336 | 234 | 43.6661 | 126.1923 | 2021-02-08 05:22:39 | Jilin, China | ||
793678 | 793678 | 2021-02-04 | US | Virginia | Bath | 51017 | 242 | 8 | 0 | 234 | 38.05852573 | -79.73912095 | 2021-02-05 05:22:38 | Bath, Virginia, US |
343484 | 343484 | 2021-02-03 | US | Texas | Shackelford | 48417 | 226 | 1 | 0 | 234 | 32.73587756 | -99.35401337 | 2021-02-04 05:22:26 | Shackelford, Texas, US |
340384 | 340384 | 2021-02-03 | Monaco | 1572 | 18 | 1320 | 234 | 43.7333 | 7.4167 | 2021-02-04 05:22:26 | Monaco | |||
1684508 | 1684508 | 2021-02-02 | Japan | Fukushima | 1737 | 46 | 1457 | 234 | 37.378867 | 140.223295 | 2021-02-03 05:22:52 | Fukushima, Japan | ||
1899105 | 1899105 | 2021-01-29 | US | Missouri | Scotland | 29199 | 237 | 3 | 0 | 234 | 40.45214695 | -92.14709064 | 2021-01-30 05:22:49 | Scotland, Missouri, US |
2570798 | 2570798 | 2021-01-25 | US | Texas | Kimble | 48267 | 223 | 6 | 0 | 234 | 30.48678918 | -99.74856473 | 2021-01-26 05:22:02 | Kimble, Texas, US |
1760576 | 1760576 | 2021-01-24 | US | Kansas | Graham | 20065 | 238 | 4 | 0 | 234 | 39.34987223 | -99.88332493 | 2021-01-25 05:22:16 | Graham, Kansas, US |
2430255 | 2430255 | 2021-01-23 | US | Virginia | King and Queen | 51097 | 237 | 3 | 0 | 234 | 37.71044922 | -76.88689628 | 2021-01-24 05:22:35 | King and Queen, Virginia, US |
2428183 | 2428183 | 2021-01-23 | US | Kansas | Graham | 20065 | 238 | 4 | 0 | 234 | 39.34987223 | -99.88332493 | 2021-01-24 05:22:35 | Graham, Kansas, US |
2468085 | 2468085 | 2021-01-22 | US | Kansas | Graham | 20065 | 238 | 4 | 0 | 234 | 39.34987223 | -99.88332493 | 2021-01-23 05:22:03 | Graham, Kansas, US |
436636 | 436636 | 2021-01-21 | US | Kansas | Graham | 20065 | 238 | 4 | 0 | 234 | 39.34987223 | -99.88332493 | 2021-01-22 05:22:10 | Graham, Kansas, US |
435360 | 435360 | 2021-01-21 | Japan | Ehime | 891 | 17 | 640 | 234 | 33.624835 | 132.856842 | 2021-01-22 05:22:10 | Ehime, Japan | ||
1095367 | 1095367 | 2021-01-20 | US | Kansas | Graham | 20065 | 238 | 4 | 0 | 234 | 39.34987223 | -99.88332493 | 2021-01-21 05:22:01 | Graham, Kansas, US |
908453 | 908453 | 2021-01-19 | Singapore | 59157 | 29 | 58894 | 234 | 1.2833 | 103.8333 | 2021-01-20 05:21:54 | Singapore | |||
3515994 | 3515994 | 2021-01-15 | US | Colorado | Baca | 8009 | 260 | 3 | 0 | 234 | 37.31940883 | -102.5603223 | 2021-01-16 05:22:40 | Baca, Colorado, US |
3882622 | 3882622 | 2021-01-14 | US | Texas | Concho | 48095 | 293 | 4 | 0 | 234 | 31.32635934 | -99.86473038 | 2021-01-15 05:22:24 | Concho, Texas, US |
3881965 | 3881965 | 2021-01-14 | US | North Dakota | Golden Valley | 38033 | 235 | 0 | 0 | 234 | 46.94022281 | -103.8465421 | 2021-01-15 05:22:24 | Golden Valley, North Dakota, US |
3879842 | 3879842 | 2021-01-14 | Saint Vincent and the Grenadines | 340 | 0 | 106 | 234 | 12.9843 | -61.2872 | 2021-01-15 05:22:24 | Saint Vincent and the Grenadines | |||
777394 | 777394 | 2021-01-12 | US | Texas | Concho | 48095 | 293 | 4 | 0 | 234 | 31.32635934 | -99.86473038 | 2021-01-13 05:22:15 | Concho, Texas, US |
191830 | 191830 | 2021-01-11 | US | Minnesota | Traverse | 27155 | 237 | 3 | 0 | 234 | 45.77298854 | -96.47062949 | 2021-01-12 05:22:15 | Traverse, Minnesota, US |
190503 | 190503 | 2021-01-11 | US | Alaska | Yukon-Koyukuk | 2290 | 238 | 4 | 0 | 234 | 65.50815459 | -151.3907387 | 2021-01-12 05:22:15 | Yukon-Koyukuk, Alaska, US |
157174 | 157174 | 2021-01-08 | US | Texas | Real | 48385 | 264 | 12 | 0 | 234 | 29.83321503 | -99.82018052 | 2021-01-09 05:22:18 | Real, Texas, US |
155928 | 155928 | 2021-01-08 | US | Missouri | Reynolds | 29179 | 236 | 2 | 0 | 234 | 37.36085952 | -90.97009925 | 2021-01-09 05:22:18 | Reynolds, Missouri, US |
2865700 | 2865700 | 2021-01-06 | US | Illinois | Hardin | 17069 | 241 | 7 | 0 | 234 | 37.51810645 | -88.26873022 | 2021-01-07 05:22:03 | Hardin, Illinois, US |
3037064 | 3037064 | 2021-01-05 | US | Puerto Rico | Rincon | 72117 | 234 | 0 | 0 | 234 | 18.335443 | -67.23174 | 2021-01-06 05:22:16 | Rincon, Puerto Rico, US |
1065123 | 1065123 | 2021-01-04 | US | Vermont | Lamoille | 50015 | 235 | 1 | 0 | 234 | 44.60353043 | -72.64356694 | 2021-01-05 05:21:49 | Lamoille, Vermont, US |
3233726 | 3233726 | 2021-01-03 | US | Vermont | Lamoille | 50015 | 235 | 1 | 0 | 234 | 44.60353043 | -72.64356694 | 2021-01-04 05:22:02 | Lamoille, Vermont, US |
3231886 | 3231886 | 2021-01-03 | US | Kentucky | Menifee | 21165 | 236 | 2 | 0 | 234 | 37.94090733 | -83.59985712 | 2021-01-04 05:22:02 | Menifee, Kentucky, US |
2230795 | 2230795 | 2021-01-02 | US | Vermont | Lamoille | 50015 | 235 | 1 | 0 | 234 | 44.60353043 | -72.64356694 | 2021-01-03 05:22:52 | Lamoille, Vermont, US |
1139070 | 1139070 | 2021-01-01 | US | New Mexico | Hidalgo | 35023 | 242 | 8 | 0 | 234 | 31.91383467 | -108.7151824 | 2021-01-02 05:22:33 | Hidalgo, New Mexico, US |
3698225 | 3698225 | 2020-12-31 | US | Puerto Rico | Hormigueros | 72067 | 234 | 0 | 0 | 234 | 18.134532 | -67.113972 | 2021-01-01 05:23:07 | Hormigueros, Puerto Rico, US |
3764737 | 3764737 | 2020-12-28 | US | Texas | Marion | 48315 | 315 | 17 | 0 | 234 | 32.79868409 | -94.3566123 | 2020-12-29 05:22:37 | Marion, Texas, US |
3762220 | 3762220 | 2020-12-28 | US | Colorado | Phillips | 8095 | 308 | 12 | 0 | 234 | 40.59414277 | -102.3577703 | 2020-12-29 05:22:37 | Phillips, Colorado, US |
3781308 | 3781308 | 2020-12-27 | US | Virginia | Surry | 51181 | 239 | 5 | 0 | 234 | 37.11781893 | -76.88450012 | 2020-12-28 05:22:06 | Surry, Virginia, US |
3781057 | 3781057 | 2020-12-27 | US | Texas | Marion | 48315 | 313 | 17 | 0 | 234 | 32.79868409 | -94.3566123 | 2020-12-28 05:22:06 | Marion, Texas, US |
2227189 | 2227189 | 2020-12-26 | Malaysia | Pulau Pinang | 3162 | 9 | 2919 | 234 | 5.4141 | 100.3288 | 2020-12-27 05:22:55 | Pulau Pinang, Malaysia |
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]);