johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
535 rows where active = 416 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 457
- Russia 9
- Colombia 8
- Chile 7
- India 7
- Japan 6
- Benin 3
- Malawi 3
- Malaysia 3
- Mexico 3
- Pakistan 3
- South Sudan 3
- Antigua and Barbuda 2
- Italy 2
- Kenya 2
- Suriname 2
- Ukraine 2
- Andorra 1
- Bangladesh 1
- China 1
- France 1
- Kyrgyzstan 1
- Luxembourg 1
- Maldives 1
- North Macedonia 1
- San Marino 1
- Sweden 1
- Togo 1
- Trinidad and Tobago 1
- Uganda 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
331746 | 331746 | 2021-08-04 | Colombia | Caqueta | 22196 | 885 | 20895 | 416 | 0.8699 | -73.8419 | 2021-08-05 04:21:51 | Caqueta, Colombia | ||
3471810 | 3471810 | 2021-08-03 | Ukraine | Luhansk Oblast | 27217 | 973 | 25828 | 416 | 48.574 | 39.3078 | 2021-08-04 04:21:25 | Luhansk Oblast, Ukraine | ||
3015635 | 3015635 | 2021-08-01 | South Sudan | 11049 | 119 | 10514 | 416 | 6.877000000000002 | 31.307 | 2021-08-02 04:21:36 | South Sudan | |||
3904258 | 3904258 | 2021-07-31 | South Sudan | 11049 | 119 | 10514 | 416 | 6.877000000000002 | 31.307 | 2021-08-01 04:21:50 | South Sudan | |||
3296463 | 3296463 | 2021-07-30 | South Sudan | 11049 | 119 | 10514 | 416 | 6.877000000000002 | 31.307 | 2021-07-31 04:21:35 | South Sudan | |||
3331551 | 3331551 | 2021-07-21 | Japan | Kyoto | 17216 | 249 | 16551 | 416 | 35.253815 | 135.443341 | 2021-07-22 04:21:19 | Kyoto, Japan | ||
778316 | 778316 | 2021-07-08 | India | Madhya Pradesh | 790096 | 9023 | 780657 | 416 | 23.541513 | 78.289633 | 2021-07-09 04:21:21 | Madhya Pradesh, India | ||
1125733 | 1125733 | 2021-06-18 | North Macedonia | 155612 | 5474 | 149722 | 416 | 41.6086 | 21.7453 | 2021-06-19 04:22:33 | North Macedonia | |||
2910957 | 2910957 | 2021-06-17 | Chile | Aysen | 7126 | 52 | 6658 | 416 | -45.9864 | -73.7669 | 2021-06-18 04:22:16 | Aysen, Chile | ||
86782 | 86782 | 2021-05-25 | Malaysia | W.P. Labuan | 2944 | 14 | 2514 | 416 | 5.2831 | 115.2308 | 2021-05-26 04:20:35 | W.P. Labuan, Malaysia | ||
1952541 | 1952541 | 2021-05-21 | Japan | Niigata | 2981 | 34 | 2531 | 416 | 37.521819 | 138.918647 | 2021-05-22 04:20:45 | Niigata, Japan | ||
380037 | 380037 | 2021-04-30 | Colombia | Choco | 8054 | 219 | 7419 | 416 | 5.2528 | -76.82600000000002 | 2021-05-01 04:20:47 | Choco, Colombia | ||
958480 | 958480 | 2021-04-25 | Uganda | 41655 | 341 | 40898 | 416 | 1.373333 | 32.290275 | 2021-04-26 04:21:04 | Uganda | |||
954869 | 954869 | 2021-04-25 | Japan | Ehime | 2192 | 32 | 1744 | 416 | 33.624835 | 132.856842 | 2021-04-26 04:21:04 | Ehime, Japan | ||
1409250 | 1409250 | 2021-04-23 | Russia | Kemerovo Oblast | 34628 | 654 | 33558 | 416 | 54.53357809999999 | 87.342861 | 2021-04-24 04:20:38 | Kemerovo Oblast, Russia | ||
36419 | 36419 | 2021-04-12 | Italy | P.A. Bolzano | 70027 | 1150 | 68461 | 416 | 46.49933453 | 11.35662422 | 2021-04-13 04:20:37 | P.A. Bolzano, Italy | ||
3003157 | 3003157 | 2021-04-06 | Colombia | Meta | 44162 | 1006 | 42740 | 416 | 3.272 | -73.0877 | 2021-04-07 04:20:53 | Meta, Colombia | ||
3710351 | 3710351 | 2021-04-03 | Russia | Komi Republic | 41821 | 811 | 40594 | 416 | 63.9881421 | 54.3326073 | 2021-04-04 04:20:49 | Komi Republic, Russia | ||
1744229 | 1744229 | 2021-03-20 | Andorra | 11481 | 113 | 10952 | 416 | 42.5063 | 1.5218 | 2021-03-21 05:25:44 | Andorra | |||
3669496 | 3669496 | 2021-03-06 | US | Missouri | Carter | 29035 | 425 | 9 | 0 | 416 | 36.94160441 | -90.96051322 | 2021-03-07 05:21:54 | Carter, Missouri, US |
3668960 | 3668960 | 2021-03-06 | US | Kansas | Sheridan | 20179 | 428 | 12 | 0 | 416 | 39.35018161 | -100.4418259 | 2021-03-07 05:21:54 | Sheridan, Kansas, US |
1617581 | 1617581 | 2021-03-05 | US | Kansas | Sheridan | 20179 | 428 | 12 | 0 | 416 | 39.35018161 | -100.4418259 | 2021-03-06 04:23:41 | Sheridan, Kansas, US |
2208992 | 2208992 | 2021-03-04 | US | Kansas | Sheridan | 20179 | 428 | 12 | 0 | 416 | 39.35018161 | -100.4418259 | 2021-03-05 05:26:29 | Sheridan, Kansas, US |
2208683 | 2208683 | 2021-03-04 | US | Illinois | Putnam | 17155 | 419 | 3 | 0 | 416 | 41.2013541 | -89.2869272 | 2021-03-05 05:26:29 | Putnam, Illinois, US |
1091413 | 1091413 | 2021-03-03 | US | Kansas | Sheridan | 20179 | 428 | 12 | 0 | 416 | 39.35018161 | -100.4418259 | 2021-03-04 05:24:24 | Sheridan, Kansas, US |
1091104 | 1091104 | 2021-03-03 | US | Illinois | Putnam | 17155 | 419 | 3 | 0 | 416 | 41.2013541 | -89.2869272 | 2021-03-04 05:24:24 | Putnam, Illinois, US |
3256021 | 3256021 | 2021-03-02 | US | Missouri | Carter | 29035 | 424 | 8 | 0 | 416 | 36.94160441 | -90.96051322 | 2021-03-03 05:23:28 | Carter, Missouri, US |
1000316 | 1000316 | 2021-03-01 | US | Missouri | Chariton | 29041 | 422 | 6 | 0 | 416 | 39.51499357 | -92.9629191 | 2021-03-02 05:23:30 | Chariton, Missouri, US |
1000313 | 1000313 | 2021-03-01 | US | Missouri | Carter | 29035 | 424 | 8 | 0 | 416 | 36.94160441 | -90.96051322 | 2021-03-02 05:23:30 | Carter, Missouri, US |
2369374 | 2369374 | 2021-02-28 | US | Missouri | Chariton | 29041 | 422 | 6 | 0 | 416 | 39.51499357 | -92.9629191 | 2021-03-01 05:23:01 | Chariton, Missouri, US |
2369371 | 2369371 | 2021-02-28 | US | Missouri | Carter | 29035 | 424 | 8 | 0 | 416 | 36.94160441 | -90.96051322 | 2021-03-01 05:23:01 | Carter, Missouri, US |
2369261 | 2369261 | 2021-02-28 | US | Minnesota | Unassigned | 90027 | 484 | 68 | 0 | 416 | 48.77754106 | 0.0 | 2021-03-01 05:23:01 | Unassigned, Minnesota, US |
3067876 | 3067876 | 2021-02-27 | US | Missouri | Chariton | 29041 | 422 | 6 | 0 | 416 | 39.51499357 | -92.9629191 | 2021-02-28 05:22:20 | Chariton, Missouri, US |
3067873 | 3067873 | 2021-02-27 | US | Missouri | Carter | 29035 | 424 | 8 | 0 | 416 | 36.94160441 | -90.96051322 | 2021-02-28 05:22:20 | Carter, Missouri, US |
2185457 | 2185457 | 2021-02-26 | US | Missouri | Carter | 29035 | 424 | 8 | 0 | 416 | 36.94160441 | -90.96051322 | 2021-02-27 05:22:28 | Carter, Missouri, US |
2183275 | 2183275 | 2021-02-26 | Antigua and Barbuda | 701 | 14 | 271 | 416 | 17.0608 | -61.7964 | 2021-02-27 05:22:28 | Antigua and Barbuda | |||
1859879 | 1859879 | 2021-02-25 | US | Missouri | Carter | 29035 | 424 | 8 | 0 | 416 | 36.94160441 | -90.96051322 | 2021-02-26 05:22:40 | Carter, Missouri, US |
1857697 | 1857697 | 2021-02-25 | Antigua and Barbuda | 701 | 14 | 271 | 416 | 17.0608 | -61.7964 | 2021-02-26 05:22:40 | Antigua and Barbuda | |||
281657 | 281657 | 2021-02-24 | US | Kentucky | Wolfe | 21237 | 420 | 4 | 0 | 416 | 37.73941626 | -83.49303612 | 2021-02-25 05:24:57 | Wolfe, Kentucky, US |
1937925 | 1937925 | 2021-02-23 | US | Kentucky | Wolfe | 21237 | 420 | 4 | 0 | 416 | 37.73941626 | -83.49303612 | 2021-02-24 05:29:16 | Wolfe, Kentucky, US |
183572 | 183572 | 2021-02-21 | US | Louisiana | Unassigned | 90022 | 416 | 0 | 0 | 416 | 32.83121059 | 0.0 | 2021-02-22 05:24:21 | Unassigned, Louisiana, US |
1154653 | 1154653 | 2021-02-18 | US | Louisiana | Unassigned | 90022 | 416 | 0 | 0 | 416 | 32.83121059 | 0.0 | 2021-02-19 05:24:16 | Unassigned, Louisiana, US |
3052591 | 3052591 | 2021-02-16 | US | North Dakota | Sargent | 38081 | 411 | 6 | 0 | 416 | 46.10830372 | -97.63217159 | 2021-02-17 05:23:10 | Sargent, North Dakota, US |
1340690 | 1340690 | 2021-02-15 | US | North Dakota | Sargent | 38081 | 410 | 6 | 0 | 416 | 46.10830372 | -97.63217159 | 2021-02-16 05:24:38 | Sargent, North Dakota, US |
1338135 | 1338135 | 2021-02-15 | Colombia | Sucre | 20098 | 750 | 18932 | 416 | 8.814 | -74.7233 | 2021-02-16 05:24:38 | Sucre, Colombia | ||
2285841 | 2285841 | 2021-02-14 | US | North Dakota | Sargent | 38081 | 410 | 6 | 0 | 416 | 46.10830372 | -97.63217159 | 2021-02-15 05:24:49 | Sargent, North Dakota, US |
2284293 | 2284293 | 2021-02-14 | US | Georgia | Talbot | 13263 | 431 | 15 | 0 | 416 | 32.69642758 | -84.53351366 | 2021-02-15 05:24:49 | Talbot, Georgia, US |
2679358 | 2679358 | 2021-02-13 | US | Louisiana | Unassigned | 90022 | 416 | 0 | 0 | 416 | 32.83121059 | 0.0 | 2021-02-14 05:23:43 | Unassigned, Louisiana, US |
2679067 | 2679067 | 2021-02-13 | US | Iowa | Wayne | 19185 | 437 | 21 | 0 | 416 | 40.73969028 | -93.32752197 | 2021-02-14 05:23:43 | Wayne, Iowa, US |
2678693 | 2678693 | 2021-02-13 | US | Georgia | Talbot | 13263 | 431 | 15 | 0 | 416 | 32.69642758 | -84.53351366 | 2021-02-14 05:23:43 | Talbot, Georgia, US |
2678425 | 2678425 | 2021-02-13 | US | Colorado | Conejos | 8021 | 439 | 9 | 0 | 416 | 37.201606 | -106.19174879999998 | 2021-02-14 05:23:43 | Conejos, Colorado, US |
3540991 | 3540991 | 2021-02-12 | US | Louisiana | Unassigned | 90022 | 416 | 0 | 0 | 416 | 32.83121059 | 0.0 | 2021-02-13 05:22:12 | Unassigned, Louisiana, US |
3540700 | 3540700 | 2021-02-12 | US | Iowa | Wayne | 19185 | 437 | 21 | 0 | 416 | 40.73969028 | -93.32752197 | 2021-02-13 05:22:12 | Wayne, Iowa, US |
3540058 | 3540058 | 2021-02-12 | US | Colorado | Conejos | 8021 | 437 | 9 | 0 | 416 | 37.201606 | -106.19174879999998 | 2021-02-13 05:22:12 | Conejos, Colorado, US |
2639254 | 2639254 | 2021-02-11 | US | Louisiana | Unassigned | 90022 | 416 | 0 | 0 | 416 | 32.83121059 | 0.0 | 2021-02-12 05:23:29 | Unassigned, Louisiana, US |
2638963 | 2638963 | 2021-02-11 | US | Iowa | Wayne | 19185 | 437 | 21 | 0 | 416 | 40.73969028 | -93.32752197 | 2021-02-12 05:23:29 | Wayne, Iowa, US |
3980109 | 3980109 | 2021-02-10 | US | Louisiana | Unassigned | 90022 | 416 | 0 | 0 | 416 | 32.83121059 | 0.0 | 2021-02-11 05:23:55 | Unassigned, Louisiana, US |
3979818 | 3979818 | 2021-02-10 | US | Iowa | Wayne | 19185 | 437 | 21 | 0 | 416 | 40.73969028 | -93.32752197 | 2021-02-11 05:23:55 | Wayne, Iowa, US |
615220 | 615220 | 2021-02-08 | US | Louisiana | Unassigned | 90022 | 416 | 0 | 0 | 416 | 32.83121059 | 0.0 | 2021-02-09 05:23:30 | Unassigned, Louisiana, US |
614668 | 614668 | 2021-02-08 | US | Illinois | Gallatin | 17059 | 419 | 3 | 0 | 416 | 37.76430935 | -88.22953869 | 2021-02-09 05:23:30 | Gallatin, Illinois, US |
1673437 | 1673437 | 2021-02-07 | US | Illinois | Gallatin | 17059 | 419 | 3 | 0 | 416 | 37.76430935 | -88.22953869 | 2021-02-08 05:22:39 | Gallatin, Illinois, US |
975058 | 975058 | 2021-02-06 | Pakistan | Azad Jammu and Kashmir | 9199 | 272 | 8511 | 416 | 34.027401 | 73.947253 | 2021-02-07 05:23:00 | Azad Jammu and Kashmir, Pakistan | ||
1591644 | 1591644 | 2021-02-05 | US | West Virginia | Doddridge | 54017 | 421 | 5 | 0 | 416 | 39.27057157 | -80.70671527 | 2021-02-06 05:23:55 | Doddridge, West Virginia, US |
1588817 | 1588817 | 2021-02-05 | US | Colorado | Rio Blanco | 8103 | 438 | 3 | 0 | 416 | 39.97913541 | -108.2179009 | 2021-02-06 05:23:55 | Rio Blanco, Colorado, US |
1588729 | 1588729 | 2021-02-05 | US | California | Modoc | 6049 | 416 | 3 | 0 | 416 | 41.58965602 | -120.7244817 | 2021-02-06 05:23:55 | Modoc, California, US |
1587985 | 1587985 | 2021-02-05 | China | Heilongjiang | 1609 | 13 | 1180 | 416 | 47.862 | 127.7615 | 2021-02-06 05:23:55 | Heilongjiang, China | ||
793851 | 793851 | 2021-02-04 | US | West Virginia | Doddridge | 54017 | 421 | 5 | 0 | 416 | 39.27057157 | -80.70671527 | 2021-02-05 05:22:38 | Doddridge, West Virginia, US |
792111 | 792111 | 2021-02-04 | US | Minnesota | Mahnomen | 27087 | 423 | 7 | 0 | 416 | 47.32557075 | -95.80921485 | 2021-02-05 05:22:38 | Mahnomen, Minnesota, US |
342003 | 342003 | 2021-02-03 | US | Minnesota | Mahnomen | 27087 | 423 | 7 | 0 | 416 | 47.32557075 | -95.80921485 | 2021-02-04 05:22:26 | Mahnomen, Minnesota, US |
1686229 | 1686229 | 2021-02-02 | US | Minnesota | Mahnomen | 27087 | 423 | 7 | 0 | 416 | 47.32557075 | -95.80921485 | 2021-02-03 05:22:52 | Mahnomen, Minnesota, US |
1686033 | 1686033 | 2021-02-02 | US | Louisiana | Unassigned | 90022 | 416 | 0 | 0 | 416 | 32.83121059 | 0.0 | 2021-02-03 05:22:52 | Unassigned, Louisiana, US |
1899265 | 1899265 | 2021-01-29 | US | Nebraska | Sheridan | 31161 | 429 | 13 | 0 | 416 | 42.50284406 | -102.4126613 | 2021-01-30 05:22:49 | Sheridan, Nebraska, US |
2484081 | 2484081 | 2021-01-28 | US | Nebraska | Sheridan | 31161 | 429 | 13 | 0 | 416 | 42.50284406 | -102.4126613 | 2021-01-29 05:22:23 | Sheridan, Nebraska, US |
15755 | 15755 | 2021-01-26 | US | Virginia | Williamsburg | 51830 | 425 | 9 | 0 | 416 | 37.28131268 | -76.70905141 | 2021-01-27 05:23:41 | Williamsburg, Virginia, US |
13126 | 13126 | 2021-01-26 | US | Georgia | Echols | 13101 | 422 | 6 | 0 | 416 | 30.71101099 | -82.89687287 | 2021-01-27 05:23:41 | Echols, Georgia, US |
1760828 | 1760828 | 2021-01-24 | US | Louisiana | Unassigned | 90022 | 416 | 0 | 0 | 416 | 32.83121059 | 0.0 | 2021-01-25 05:22:16 | Unassigned, Louisiana, US |
2430318 | 2430318 | 2021-01-23 | US | Virginia | Williamsburg | 51830 | 424 | 8 | 0 | 416 | 37.28131268 | -76.70905141 | 2021-01-24 05:22:35 | Williamsburg, Virginia, US |
2427735 | 2427735 | 2021-01-23 | US | Georgia | Marion | 13197 | 426 | 10 | 0 | 416 | 32.3483402 | -84.52733571 | 2021-01-24 05:22:35 | Marion, Georgia, US |
2468544 | 2468544 | 2021-01-22 | US | Minnesota | Norman | 27107 | 424 | 8 | 0 | 416 | 47.32628443 | -96.45620947 | 2021-01-23 05:22:03 | Norman, Minnesota, US |
437095 | 437095 | 2021-01-21 | US | Minnesota | Norman | 27107 | 424 | 8 | 0 | 416 | 47.32628443 | -96.45620947 | 2021-01-22 05:22:10 | Norman, Minnesota, US |
1095826 | 1095826 | 2021-01-20 | US | Minnesota | Norman | 27107 | 424 | 8 | 0 | 416 | 47.32628443 | -96.45620947 | 2021-01-21 05:22:01 | Norman, Minnesota, US |
910465 | 910465 | 2021-01-19 | US | North Carolina | Camden | 37029 | 421 | 5 | 0 | 416 | 36.33804939 | -76.15568396 | 2021-01-20 05:21:54 | Camden, North Carolina, US |
909916 | 909916 | 2021-01-19 | US | Minnesota | Norman | 27107 | 424 | 8 | 0 | 416 | 47.32628443 | -96.45620947 | 2021-01-20 05:21:54 | Norman, Minnesota, US |
240281 | 240281 | 2021-01-18 | US | Texas | Coke | 48081 | 353 | 10 | 0 | 416 | 31.88911733 | -100.5297533 | 2021-01-19 05:22:15 | Coke, Texas, US |
3506398 | 3506398 | 2021-01-17 | US | Texas | Coke | 48081 | 353 | 10 | 0 | 416 | 31.88911733 | -100.5297533 | 2021-01-18 05:22:34 | Coke, Texas, US |
3103828 | 3103828 | 2021-01-16 | US | North Dakota | Eddy | 38027 | 417 | 6 | 0 | 416 | 47.71701474 | -98.90432337 | 2021-01-17 05:22:17 | Eddy, North Dakota, US |
3517790 | 3517790 | 2021-01-15 | US | North Dakota | Eddy | 38027 | 417 | 6 | 0 | 416 | 47.71701474 | -98.90432337 | 2021-01-16 05:22:40 | Eddy, North Dakota, US |
3515736 | 3515736 | 2021-01-15 | Togo | 4220 | 73 | 3731 | 416 | 8.6195 | 0.8248 | 2021-01-16 05:22:40 | Togo | |||
3515400 | 3515400 | 2021-01-15 | Italy | Valle d'Aosta | 7601 | 392 | 6793 | 416 | 45.73750286 | 7.320149366 | 2021-01-16 05:22:40 | Valle d'Aosta, Italy | ||
3881962 | 3881962 | 2021-01-14 | US | North Dakota | Eddy | 38027 | 417 | 6 | 0 | 416 | 47.71701474 | -98.90432337 | 2021-01-15 05:22:24 | Eddy, North Dakota, US |
777843 | 777843 | 2021-01-12 | US | West Virginia | Pocahontas | 54075 | 425 | 9 | 0 | 416 | 38.32758728 | -80.00993811 | 2021-01-13 05:22:15 | Pocahontas, West Virginia, US |
776057 | 776057 | 2021-01-12 | US | Minnesota | Grant | 27051 | 423 | 7 | 0 | 416 | 45.93424769 | -96.01139609 | 2021-01-13 05:22:15 | Grant, Minnesota, US |
192377 | 192377 | 2021-01-11 | US | North Carolina | Gates | 37073 | 428 | 12 | 0 | 416 | 36.44667547 | -76.69749701 | 2021-01-12 05:22:15 | Gates, North Carolina, US |
192159 | 192159 | 2021-01-11 | US | Nebraska | Morrill | 31123 | 430 | 14 | 0 | 416 | 41.71711774 | -103.0061405 | 2021-01-12 05:22:15 | Morrill, Nebraska, US |
191778 | 191778 | 2021-01-11 | US | Minnesota | Grant | 27051 | 423 | 7 | 0 | 416 | 45.93424769 | -96.01139609 | 2021-01-12 05:22:15 | Grant, Minnesota, US |
2628707 | 2628707 | 2021-01-10 | US | South Dakota | Aurora | 46003 | 426 | 10 | 0 | 416 | 43.71757685 | -98.56050467 | 2021-01-11 05:21:50 | Aurora, South Dakota, US |
3903266 | 3903266 | 2021-01-09 | US | Virginia | Charlotte | 51037 | 425 | 9 | 0 | 416 | 37.01909701 | -78.66314092 | 2021-01-10 05:22:12 | Charlotte, Virginia, US |
157302 | 157302 | 2021-01-08 | US | Virginia | Emporia | 51595 | 446 | 30 | 0 | 416 | 36.69455571 | -77.53406129 | 2021-01-09 05:22:18 | Emporia, Virginia, US |
157289 | 157289 | 2021-01-08 | US | Virginia | Charlotte | 51037 | 423 | 7 | 0 | 416 | 37.01909701 | -78.66314092 | 2021-01-09 05:22:18 | Charlotte, Virginia, US |
2543465 | 2543465 | 2021-01-07 | US | Nebraska | Fillmore | 31059 | 423 | 7 | 0 | 416 | 40.52458567 | -97.59646937 | 2021-01-08 05:22:42 | Fillmore, 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]);