johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
412 rows where active = 503 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 340
- Japan 7
- Russia 7
- Chile 6
- Colombia 5
- Sierra Leone 5
- Ukraine 4
- India 3
- Mali 3
- Spain 3
- Germany 2
- Honduras 2
- Italy 2
- Netherlands 2
- Pakistan 2
- Sweden 2
- Timor-Leste 2
- Australia 1
- Equatorial Guinea 1
- Finland 1
- Guinea 1
- Laos 1
- Lebanon 1
- Malaysia 1
- Mauritius 1
- Mexico 1
- Mongolia 1
- Peru 1
- Senegal 1
- Seychelles 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3468187 | 3468187 | 2021-08-03 | Japan | Hiroshima | 12301 | 179 | 11619 | 503 | 34.605309000000005 | 132.788719 | 2021-08-04 04:21:25 | Hiroshima, Japan | ||
3683233 | 3683233 | 2021-08-02 | Chile | Araucania | 96872 | 1399 | 94970 | 503 | -38.9489 | -72.3311 | 2021-08-03 04:21:39 | Araucania, Chile | ||
2947320 | 2947320 | 2021-07-16 | India | Rajasthan | 953292 | 8947 | 943842 | 503 | 26.583423 | 73.847973 | 2021-07-17 04:22:22 | Rajasthan, India | ||
3958781 | 3958781 | 2021-06-26 | Senegal | 42851 | 1163 | 41185 | 503 | 14.4974 | -14.4524 | 2021-06-27 04:21:39 | Senegal | |||
1712399 | 1712399 | 2021-06-25 | Mauritius | 1852 | 18 | 1331 | 503 | -20.348404 | 57.552152 | 2021-06-26 04:21:43 | Mauritius | |||
2914804 | 2914804 | 2021-06-17 | Ukraine | Luhansk Oblast | 26458 | 930 | 25025 | 503 | 48.574 | 39.3078 | 2021-06-18 04:22:16 | Luhansk Oblast, Ukraine | ||
50848 | 50848 | 2021-05-29 | Laos | 1908 | 3 | 1402 | 503 | 19.85627 | 102.495496 | 2021-05-30 04:20:55 | Laos | |||
1309964 | 1309964 | 2021-05-26 | Chile | Tarapaca | 36330 | 660 | 35167 | 503 | -19.9232 | -69.5132 | 2021-05-27 04:20:59 | Tarapaca, Chile | ||
3054188 | 3054188 | 2021-05-13 | Italy | Valle d'Aosta | 11311 | 466 | 10342 | 503 | 45.73750286 | 7.320149366 | 2021-05-14 04:20:41 | Valle d'Aosta, Italy | ||
1425129 | 1425129 | 2021-05-09 | Japan | Nagasaki | 2479 | 44 | 1932 | 503 | 33.235712 | 129.608033 | 2021-05-10 04:20:38 | Nagasaki, Japan | ||
3883922 | 3883922 | 2021-04-11 | Timor-Leste | 947 | 1 | 443 | 503 | -8.874217 | 125.727539 | 2021-04-12 04:21:00 | Timor-Leste | |||
3883843 | 3883843 | 2021-04-11 | Russia | Tyva Republic | 15777 | 200 | 15074 | 503 | 51.4017149 | 93.8582593 | 2021-04-12 04:21:00 | Tyva Republic, Russia | ||
2986892 | 2986892 | 2021-04-10 | Ukraine | Sevastopol* | 13566 | 579 | 12484 | 503 | 44.6054 | 33.522 | 2021-04-11 04:20:56 | Sevastopol*, Ukraine | ||
2983590 | 2983590 | 2021-04-10 | Timor-Leste | 947 | 1 | 443 | 503 | -8.874217 | 125.727539 | 2021-04-11 04:20:56 | Timor-Leste | |||
1289790 | 1289790 | 2021-03-29 | Chile | Atacama | 14113 | 170 | 13440 | 503 | -27.5661 | -70.0503 | 2021-03-30 04:26:23 | Atacama, Chile | ||
1880828 | 1880828 | 2021-03-26 | Colombia | Cauca | 27981 | 774 | 26704 | 503 | 2.705 | -76.82600000000002 | 2021-03-27 05:25:04 | Cauca, Colombia | ||
1744536 | 1744536 | 2021-03-20 | Italy | Valle d'Aosta | 8575 | 419 | 7653 | 503 | 45.73750286 | 7.320149366 | 2021-03-21 05:25:44 | Valle d'Aosta, Italy | ||
702265 | 702265 | 2021-03-16 | Colombia | Sucre | 21476 | 805 | 20168 | 503 | 8.814 | -74.7233 | 2021-03-17 05:25:07 | Sucre, Colombia | ||
1837773 | 1837773 | 2021-03-12 | Colombia | Cauca | 27621 | 755 | 26363 | 503 | 2.705 | -76.82600000000002 | 2021-03-13 05:25:15 | Cauca, Colombia | ||
352079 | 352079 | 2021-03-11 | Chile | Arica y Parinacota | 15833 | 314 | 15016 | 503 | -18.594 | -69.4785 | 2021-03-12 05:26:50 | Arica y Parinacota, Chile | ||
3670031 | 3670031 | 2021-03-06 | US | North Dakota | Pierce | 38069 | 527 | 24 | 0 | 503 | 48.24977025 | -99.96407787 | 2021-03-07 05:21:54 | Pierce, North Dakota, US |
1092111 | 1092111 | 2021-03-03 | US | Nebraska | Boone | 31011 | 507 | 4 | 0 | 503 | 41.70759415 | -98.06737183 | 2021-03-04 05:24:24 | Boone, Nebraska, US |
1090016 | 1090016 | 2021-03-03 | India | Chandigarh | 21962 | 355 | 21104 | 503 | 30.733839 | 76.76827800000002 | 2021-03-04 05:24:24 | Chandigarh, India | ||
3069051 | 3069051 | 2021-02-27 | US | Texas | Crane | 48103 | 380 | 11 | 0 | 503 | 31.43052248 | -102.5143314 | 2021-02-28 05:22:20 | Crane, Texas, US |
3067725 | 3067725 | 2021-02-27 | US | Minnesota | Lincoln | 27081 | 505 | 2 | 0 | 503 | 44.41311883 | -96.26688165 | 2021-02-28 05:22:20 | Lincoln, Minnesota, US |
2186786 | 2186786 | 2021-02-26 | US | Texas | San Augustine | 48405 | 404 | 29 | 0 | 503 | 31.39457611 | -94.17000399 | 2021-02-27 05:22:28 | San Augustine, Texas, US |
1861208 | 1861208 | 2021-02-25 | US | Texas | San Augustine | 48405 | 404 | 29 | 0 | 503 | 31.39457611 | -94.17000399 | 2021-02-26 05:22:40 | San Augustine, Texas, US |
1858279 | 1858279 | 2021-02-25 | Seychelles | 2562 | 11 | 2048 | 503 | -4.6796 | 55.492 | 2021-02-26 05:22:40 | Seychelles | |||
283386 | 283386 | 2021-02-24 | US | Texas | San Augustine | 48405 | 404 | 29 | 0 | 503 | 31.39457611 | -94.17000399 | 2021-02-25 05:24:57 | San Augustine, Texas, US |
282260 | 282260 | 2021-02-24 | US | Nebraska | Howard | 31093 | 520 | 17 | 0 | 503 | 41.2200529 | -98.5166499 | 2021-02-25 05:24:57 | Howard, Nebraska, US |
1939654 | 1939654 | 2021-02-23 | US | Texas | San Augustine | 48405 | 404 | 29 | 0 | 503 | 31.39457611 | -94.17000399 | 2021-02-24 05:29:16 | San Augustine, Texas, US |
1938528 | 1938528 | 2021-02-23 | US | Nebraska | Howard | 31093 | 520 | 17 | 0 | 503 | 41.2200529 | -98.5166499 | 2021-02-24 05:29:16 | Howard, Nebraska, US |
532783 | 532783 | 2021-02-22 | US | Nebraska | Howard | 31093 | 520 | 17 | 0 | 503 | 41.2200529 | -98.5166499 | 2021-02-23 05:23:41 | Howard, Nebraska, US |
184117 | 184117 | 2021-02-21 | US | Nebraska | Howard | 31093 | 520 | 17 | 0 | 503 | 41.2200529 | -98.5166499 | 2021-02-22 05:24:21 | Howard, Nebraska, US |
744391 | 744391 | 2021-02-20 | US | Nebraska | Howard | 31093 | 520 | 17 | 0 | 503 | 41.2200529 | -98.5166499 | 2021-02-21 05:24:33 | Howard, Nebraska, US |
744005 | 744005 | 2021-02-20 | US | Minnesota | Big Stone | 27011 | 506 | 3 | 0 | 503 | 45.42712824 | -96.41403739 | 2021-02-21 05:24:33 | Big Stone, Minnesota, US |
1156485 | 1156485 | 2021-02-18 | US | Virginia | Mathews | 51115 | 510 | 7 | 0 | 503 | 37.44164146 | -76.34098896 | 2021-02-19 05:24:16 | Mathews, Virginia, US |
1155198 | 1155198 | 2021-02-18 | US | Nebraska | Howard | 31093 | 520 | 17 | 0 | 503 | 41.2200529 | -98.5166499 | 2021-02-19 05:24:16 | Howard, Nebraska, US |
2640882 | 2640882 | 2021-02-11 | US | Texas | McCulloch | 48307 | 495 | 15 | 0 | 503 | 31.1925468 | -99.34682807 | 2021-02-12 05:23:29 | McCulloch, Texas, US |
614800 | 614800 | 2021-02-08 | US | Indiana | Ohio | 18115 | 513 | 10 | 0 | 503 | 38.955305 | -84.96515993 | 2021-02-09 05:23:30 | Ohio, Indiana, US |
978278 | 978278 | 2021-02-06 | US | Virginia | Madison | 51113 | 509 | 6 | 0 | 503 | 38.41531222 | -78.28220331 | 2021-02-07 05:23:00 | Madison, Virginia, US |
1589725 | 1589725 | 2021-02-05 | US | Maine | Lincoln | 23015 | 505 | 2 | 0 | 503 | 44.05996956 | -69.54227124 | 2021-02-06 05:23:55 | Lincoln, Maine, US |
1589558 | 1589558 | 2021-02-05 | US | Kentucky | Crittenden | 21055 | 518 | 15 | 0 | 503 | 37.35839237 | -88.08826090000002 | 2021-02-06 05:23:55 | Crittenden, Kentucky, US |
1679185 | 1679185 | 2021-02-01 | US | Puerto Rico | Cabo Rojo | 72023 | 503 | 0 | 0 | 503 | 18.040993 | -67.154391 | 2021-02-02 05:22:49 | Cabo Rojo, Puerto Rico, US |
1462812 | 1462812 | 2021-01-31 | US | Texas | Crockett | 48105 | 374 | 15 | 0 | 503 | 30.72367027 | -101.4134238 | 2021-02-01 05:22:53 | Crockett, Texas, US |
1462484 | 1462484 | 2021-01-31 | US | Puerto Rico | Comerio | 72045 | 503 | 0 | 0 | 503 | 18.224687 | -66.221622 | 2021-02-01 05:22:53 | Comerio, Puerto Rico, US |
2214392 | 2214392 | 2021-01-30 | US | Puerto Rico | Comerio | 72045 | 503 | 0 | 0 | 503 | 18.224687 | -66.221622 | 2021-01-31 05:22:42 | Comerio, Puerto Rico, US |
1899879 | 1899879 | 2021-01-29 | US | Puerto Rico | Comerio | 72045 | 503 | 0 | 0 | 503 | 18.224687 | -66.221622 | 2021-01-30 05:22:49 | Comerio, Puerto Rico, US |
14274 | 14274 | 2021-01-26 | US | Missouri | Ozark | 29153 | 513 | 10 | 0 | 503 | 36.64916339 | -92.44459066 | 2021-01-27 05:23:41 | Ozark, Missouri, US |
2570770 | 2570770 | 2021-01-25 | US | Texas | Hemphill | 48211 | 614 | 2 | 0 | 503 | 35.83764858 | -100.2703577 | 2021-01-26 05:22:02 | Hemphill, Texas, US |
1762402 | 1762402 | 2021-01-24 | US | Texas | Hemphill | 48211 | 614 | 2 | 0 | 503 | 35.83764858 | -100.2703577 | 2021-01-25 05:22:16 | Hemphill, Texas, US |
2430009 | 2430009 | 2021-01-23 | US | Texas | Hemphill | 48211 | 614 | 2 | 0 | 503 | 35.83764858 | -100.2703577 | 2021-01-24 05:22:35 | Hemphill, Texas, US |
2470126 | 2470126 | 2021-01-22 | US | Virginia | Emporia | 51595 | 534 | 31 | 0 | 503 | 36.69455571 | -77.53406129 | 2021-01-23 05:22:03 | Emporia, Virginia, US |
2469571 | 2469571 | 2021-01-22 | US | Puerto Rico | Salinas | 72123 | 503 | 0 | 0 | 503 | 18.010386999999994 | -66.256592 | 2021-01-23 05:22:03 | Salinas, Puerto Rico, US |
911684 | 911684 | 2021-01-19 | US | West Virginia | Tyler | 54095 | 506 | 3 | 0 | 503 | 39.46811972 | -80.88772676 | 2021-01-20 05:21:54 | Tyler, West Virginia, US |
910502 | 910502 | 2021-01-19 | US | North Carolina | Jones | 37103 | 519 | 16 | 0 | 503 | 35.02254606 | -77.35870791 | 2021-01-20 05:21:54 | Jones, North Carolina, US |
909725 | 909725 | 2021-01-19 | US | Maine | Knox | 23013 | 507 | 4 | 0 | 503 | 44.11486325 | -69.10529169 | 2021-01-20 05:21:54 | Knox, Maine, US |
240002 | 240002 | 2021-01-18 | US | Puerto Rico | Quebradillas | 72115 | 503 | 0 | 0 | 503 | 18.439692 | -66.926113 | 2021-01-19 05:22:15 | Quebradillas, Puerto Rico, US |
3104202 | 3104202 | 2021-01-16 | US | Puerto Rico | Quebradillas | 72115 | 503 | 0 | 0 | 503 | 18.439692 | -66.926113 | 2021-01-17 05:22:17 | Quebradillas, Puerto Rico, US |
3518774 | 3518774 | 2021-01-15 | US | Virginia | Northampton | 51131 | 534 | 31 | 0 | 503 | 37.34062933 | -75.87751591 | 2021-01-16 05:22:40 | Northampton, Virginia, US |
3518716 | 3518716 | 2021-01-15 | US | Virginia | Covington | 51580 | 507 | 4 | 0 | 503 | 37.7824656 | -79.98631446 | 2021-01-16 05:22:40 | Covington, Virginia, US |
3881630 | 3881630 | 2021-01-14 | US | Nebraska | Dixon | 31051 | 511 | 8 | 0 | 503 | 42.49188363 | -96.86782408 | 2021-01-15 05:22:24 | Dixon, Nebraska, US |
3880917 | 3880917 | 2021-01-14 | US | Kansas | Stevens | 20189 | 510 | 7 | 0 | 503 | 37.1923008 | -101.3118967 | 2021-01-15 05:22:24 | Stevens, Kansas, US |
3309819 | 3309819 | 2021-01-13 | US | Michigan | Crawford | 26039 | 508 | 5 | 0 | 503 | 44.68255561 | -84.61006219 | 2021-01-14 05:22:32 | Crawford, Michigan, US |
3309544 | 3309544 | 2021-01-13 | US | Kansas | Stevens | 20189 | 510 | 7 | 0 | 503 | 37.1923008 | -101.3118967 | 2021-01-14 05:22:32 | Stevens, Kansas, US |
775985 | 775985 | 2021-01-12 | US | Michigan | Kalkaska | 26079 | 517 | 14 | 0 | 503 | 44.68512729 | -85.09085699 | 2021-01-13 05:22:15 | Kalkaska, Michigan, US |
3902550 | 3902550 | 2021-01-09 | US | Oklahoma | Unassigned | 90040 | 503 | 0 | 0 | 503 | 36.83532655 | 0.0 | 2021-01-10 05:22:12 | Unassigned, Oklahoma, US |
157149 | 157149 | 2021-01-08 | US | Texas | Mitchell | 48335 | 1072 | 17 | 0 | 503 | 32.30623474 | -100.9212058 | 2021-01-09 05:22:18 | Mitchell, Texas, US |
156689 | 156689 | 2021-01-08 | US | Puerto Rico | Anasco | 72011 | 503 | 0 | 0 | 503 | 18.287985 | -67.120611 | 2021-01-09 05:22:18 | Anasco, Puerto Rico, US |
156579 | 156579 | 2021-01-08 | US | Oregon | Baker | 41001 | 508 | 5 | 0 | 503 | 44.70915557 | -117.6749883 | 2021-01-09 05:22:18 | Baker, Oregon, US |
2544946 | 2544946 | 2021-01-07 | US | Wisconsin | Iron | 55051 | 538 | 35 | 0 | 503 | 46.26302338 | -90.24295041 | 2021-01-08 05:22:42 | Iron, Wisconsin, US |
2544844 | 2544844 | 2021-01-07 | US | Washington | Klickitat | 53039 | 506 | 3 | 0 | 503 | 45.87325839 | -120.7913598 | 2021-01-08 05:22:42 | Klickitat, Washington, US |
2543499 | 2543499 | 2021-01-07 | US | Nebraska | Nemaha | 31127 | 513 | 10 | 0 | 503 | 40.38514847 | -95.85433992 | 2021-01-08 05:22:42 | Nemaha, Nebraska, US |
2542739 | 2542739 | 2021-01-07 | US | Kansas | Scott | 20171 | 519 | 16 | 0 | 503 | 38.48222076 | -100.9066539 | 2021-01-08 05:22:42 | Scott, Kansas, US |
2542700 | 2542700 | 2021-01-07 | US | Kansas | Kearny | 20093 | 513 | 10 | 0 | 503 | 38.00017981 | -101.321681 | 2021-01-08 05:22:42 | Kearny, Kansas, US |
2868011 | 2868011 | 2021-01-06 | US | Virginia | Bland | 51021 | 509 | 6 | 0 | 503 | 37.13128068 | -81.13599391 | 2021-01-07 05:22:03 | Bland, Virginia, US |
2867867 | 2867867 | 2021-01-06 | US | Texas | Lynn | 48305 | 502 | 14 | 0 | 503 | 33.17657705 | -101.8162849 | 2021-01-07 05:22:03 | Lynn, Texas, US |
2866048 | 2866048 | 2021-01-06 | US | Kansas | Scott | 20171 | 519 | 16 | 0 | 503 | 38.48222076 | -100.9066539 | 2021-01-07 05:22:03 | Scott, Kansas, US |
2866009 | 2866009 | 2021-01-06 | US | Kansas | Kearny | 20093 | 513 | 10 | 0 | 503 | 38.00017981 | -101.321681 | 2021-01-07 05:22:03 | Kearny, Kansas, US |
1064601 | 1064601 | 2021-01-04 | US | Puerto Rico | Naguabo | 72103 | 503 | 0 | 0 | 503 | 18.230637 | -65.753897 | 2021-01-05 05:21:49 | Naguabo, Puerto Rico, US |
1063998 | 1063998 | 2021-01-04 | US | New Hampshire | Sullivan | 33019 | 509 | 6 | 0 | 503 | 43.36094111 | -72.22203125 | 2021-01-05 05:21:49 | Sullivan, New Hampshire, US |
3233204 | 3233204 | 2021-01-03 | US | Puerto Rico | Naguabo | 72103 | 503 | 0 | 0 | 503 | 18.230637 | -65.753897 | 2021-01-04 05:22:02 | Naguabo, Puerto Rico, US |
3230950 | 3230950 | 2021-01-03 | US | Arkansas | Monroe | 5095 | 510 | 7 | 0 | 503 | 34.6815935 | -91.20540287 | 2021-01-04 05:22:02 | Monroe, Arkansas, US |
2228396 | 2228396 | 2021-01-02 | US | Georgia | Treutlen | 13283 | 518 | 15 | 0 | 503 | 32.40422134 | -82.56904553 | 2021-01-03 05:22:52 | Treutlen, Georgia, US |
1139934 | 1139934 | 2021-01-01 | US | Texas | Crane | 48103 | 378 | 9 | 0 | 503 | 31.43052248 | -102.5143314 | 2021-01-02 05:22:33 | Crane, Texas, US |
1137717 | 1137717 | 2021-01-01 | US | Georgia | McIntosh | 13191 | 513 | 10 | 0 | 503 | 31.49683595 | -81.40163426 | 2021-01-02 05:22:33 | McIntosh, Georgia, US |
3698000 | 3698000 | 2020-12-31 | US | Ohio | Vinton | 39163 | 513 | 10 | 0 | 503 | 39.25208988 | -82.4831444 | 2021-01-01 05:23:07 | Vinton, Ohio, US |
3697592 | 3697592 | 2020-12-31 | US | Nebraska | Richardson | 31147 | 518 | 15 | 0 | 503 | 40.1247415 | -95.71755036 | 2021-01-01 05:23:07 | Richardson, Nebraska, US |
767864 | 767864 | 2020-12-29 | US | Maine | Hancock | 23009 | 514 | 11 | 0 | 503 | 44.59816444 | -68.38401854 | 2020-12-30 05:22:34 | Hancock, Maine, US |
766171 | 766171 | 2020-12-29 | Colombia | La Guajira | 14023 | 540 | 12980 | 503 | 11.3548 | -72.5205 | 2020-12-30 05:22:34 | La Guajira, Colombia | ||
3764460 | 3764460 | 2020-12-28 | US | South Dakota | Lyman | 46085 | 512 | 9 | 0 | 503 | 43.89522709 | -99.85201878 | 2020-12-29 05:22:37 | Lyman, South Dakota, US |
3764436 | 3764436 | 2020-12-28 | US | South Dakota | Day | 46037 | 523 | 20 | 0 | 503 | 45.367281 | -97.60737498 | 2020-12-29 05:22:37 | Day, South Dakota, US |
3780780 | 3780780 | 2020-12-27 | US | South Dakota | Lyman | 46085 | 512 | 9 | 0 | 503 | 43.89522709 | -99.85201878 | 2020-12-28 05:22:06 | Lyman, South Dakota, US |
3780756 | 3780756 | 2020-12-27 | US | South Dakota | Day | 46037 | 523 | 20 | 0 | 503 | 45.367281 | -97.60737498 | 2020-12-28 05:22:06 | Day, South Dakota, US |
3780159 | 3780159 | 2020-12-27 | US | New York | Schoharie | 36095 | 507 | 4 | 0 | 503 | 42.58831742 | -74.44339029999998 | 2020-12-28 05:22:06 | Schoharie, New York, US |
2226213 | 2226213 | 2020-12-26 | US | Puerto Rico | Aguas Buenas | 72007 | 503 | 0 | 0 | 503 | 18.251619 | -66.126806 | 2020-12-27 05:22:55 | Aguas Buenas, Puerto Rico, US |
205503 | 205503 | 2020-12-25 | US | Texas | Winkler | 48495 | 489 | 11 | 0 | 503 | 31.85008651 | -103.0485163 | 2020-12-26 05:22:28 | Winkler, Texas, US |
202884 | 202884 | 2020-12-25 | US | Colorado | Moffat | 8081 | 600 | 22 | 0 | 503 | 40.61810999 | -108.2070876 | 2020-12-26 05:22:28 | Moffat, Colorado, US |
3693518 | 3693518 | 2020-12-24 | US | Nebraska | Burt | 31021 | 511 | 8 | 0 | 503 | 41.85056773 | -96.32605633 | 2020-12-25 05:22:48 | Burt, Nebraska, US |
3692131 | 3692131 | 2020-12-24 | US | Colorado | Yuma | 8125 | 666 | 15 | 0 | 503 | 40.00346839 | -102.4258673 | 2020-12-25 05:22:48 | Yuma, Colorado, 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]);