johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
863 rows where active = 212 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 780
- Japan 13
- Malaysia 6
- Togo 5
- Germany 4
- Iceland 4
- Italy 4
- France 3
- Russia 3
- Ukraine 3
- Uruguay 3
- Chile 2
- China 2
- Colombia 2
- Gambia 2
- India 2
- Jordan 2
- Papua New Guinea 2
- Albania 1
- Bahrain 1
- Bulgaria 1
- Chad 1
- Congo (Kinshasa) 1
- Cote d'Ivoire 1
- Cyprus 1
- Guinea-Bissau 1
- Kosovo 1
- Latvia 1
- Lithuania 1
- Mauritania 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3218209 | 3218209 | 2021-07-26 | Germany | Bremen | 27745 | 493 | 27050 | 212 | 53.0793 | 8.8017 | 2021-07-27 04:21:18 | Bremen, Germany | ||
3137702 | 3137702 | 2021-07-23 | Papua New Guinea | 17581 | 192 | 17177 | 212 | -6.314993 | 143.95555 | 2021-07-24 00:21:36 | Papua New Guinea | |||
3476462 | 3476462 | 2021-07-22 | Papua New Guinea | 17581 | 192 | 17177 | 212 | -6.314993 | 143.95555 | 2021-07-23 04:21:29 | Papua New Guinea | |||
483525 | 483525 | 2021-07-19 | Iceland | 6718 | 30 | 6476 | 212 | 64.9631 | -19.0208 | 2021-07-20 04:21:48 | Iceland | |||
2673748 | 2673748 | 2021-07-18 | Iceland | 6718 | 30 | 6476 | 212 | 64.9631 | -19.0208 | 2021-07-19 04:21:24 | Iceland | |||
3706060 | 3706060 | 2021-07-17 | Iceland | 6718 | 30 | 6476 | 212 | 64.9631 | -19.0208 | 2021-07-18 04:22:07 | Iceland | |||
299645 | 299645 | 2021-07-15 | Ukraine | Luhansk Oblast | 26803 | 960 | 25631 | 212 | 48.574 | 39.3078 | 2021-07-16 04:21:22 | Luhansk Oblast, Ukraine | ||
1168801 | 1168801 | 2021-07-04 | Ukraine | Luhansk Oblast | 26640 | 949 | 25479 | 212 | 48.574 | 39.3078 | 2021-07-05 04:21:28 | Luhansk Oblast, Ukraine | ||
2764862 | 2764862 | 2021-07-01 | Guinea-Bissau | 3869 | 69 | 3588 | 212 | 11.8037 | -15.1804 | 2021-07-02 04:21:47 | Guinea-Bissau | |||
1448594 | 1448594 | 2021-06-03 | Japan | Fukushima | 4612 | 147 | 4253 | 212 | 37.378867 | 140.223295 | 2021-06-04 04:23:37 | Fukushima, Japan | ||
2104126 | 2104126 | 2021-06-01 | Italy | Valle d'Aosta | 11601 | 472 | 10917 | 212 | 45.73750286 | 7.320149366 | 2021-06-02 04:24:34 | Valle d'Aosta, Italy | ||
1952528 | 1952528 | 2021-05-21 | Japan | Iwate | 1313 | 42 | 1059 | 212 | 39.593287 | 141.361777 | 2021-05-22 04:20:45 | Iwate, Japan | ||
2390786 | 2390786 | 2021-05-18 | Japan | Iwate | 1257 | 41 | 1004 | 212 | 39.593287 | 141.361777 | 2021-05-19 04:20:42 | Iwate, Japan | ||
887905 | 887905 | 2021-04-26 | Chile | Aysen | 4169 | 30 | 3927 | 212 | -45.9864 | -73.7669 | 2021-04-27 04:20:52 | Aysen, Chile | ||
954645 | 954645 | 2021-04-25 | Chad | 4770 | 169 | 4389 | 212 | 15.4542 | 18.7322 | 2021-04-26 04:21:04 | Chad | |||
2020737 | 2020737 | 2021-04-20 | Japan | Ishikawa | 2215 | 68 | 1935 | 212 | 36.769464 | 136.771027 | 2021-04-21 04:21:14 | Ishikawa, Japan | ||
2410654 | 2410654 | 2021-04-19 | China | Hong Kong | 11695 | 209 | 11274 | 212 | 22.3 | 114.2 | 2021-04-20 04:20:41 | Hong Kong, China | ||
3133206 | 3133206 | 2021-04-18 | Malaysia | Terengganu | 3897 | 14 | 3671 | 212 | 5.3117 | 103.1324 | 2021-04-19 04:20:57 | Terengganu, Malaysia | ||
2548709 | 2548709 | 2021-04-15 | Colombia | Arauca | 5996 | 180 | 5604 | 212 | 7.0762 | -70.7105 | 2021-04-16 04:20:46 | Arauca, Colombia | ||
36502 | 36502 | 2021-04-12 | Mauritania | 18035 | 450 | 17373 | 212 | 21.0079 | -10.9408 | 2021-04-13 04:20:37 | Mauritania | |||
3085243 | 3085243 | 2021-04-05 | India | Dadra and Nagar Haveli and Daman and Diu | 3770 | 2 | 3556 | 212 | 20.194742 | 73.080901 | 2021-04-06 04:20:32 | Dadra and Nagar Haveli and Daman and Diu, India | ||
1302080 | 1302080 | 2021-04-01 | Japan | Niigata | 1486 | 18 | 1256 | 212 | 37.521819 | 138.918647 | 2021-04-02 04:20:36 | Niigata, Japan | ||
1219473 | 1219473 | 2021-03-27 | Gambia | 5365 | 163 | 4990 | 212 | 13.4432 | -15.3101 | 2021-03-28 05:28:10 | Gambia | |||
1880891 | 1880891 | 2021-03-26 | Gambia | 5365 | 163 | 4990 | 212 | 13.4432 | -15.3101 | 2021-03-27 05:25:04 | Gambia | |||
706079 | 706079 | 2021-03-16 | Malaysia | Kedah | 7925 | 23 | 7690 | 212 | 6.1184 | 100.3685 | 2021-03-17 05:25:07 | Kedah, Malaysia | ||
2209693 | 2209693 | 2021-03-04 | US | Nebraska | Brown | 31017 | 214 | 2 | 0 | 212 | 42.43018907 | -99.92904055 | 2021-03-05 05:26:29 | Brown, Nebraska, US |
1092114 | 1092114 | 2021-03-03 | US | Nebraska | Brown | 31017 | 214 | 2 | 0 | 212 | 42.43018907 | -99.92904055 | 2021-03-04 05:24:24 | Brown, Nebraska, US |
3256186 | 3256186 | 2021-03-02 | US | Nebraska | Brown | 31017 | 214 | 2 | 0 | 212 | 42.43018907 | -99.92904055 | 2021-03-03 05:23:28 | Brown, Nebraska, US |
1000478 | 1000478 | 2021-03-01 | US | Nebraska | Brown | 31017 | 214 | 2 | 0 | 212 | 42.43018907 | -99.92904055 | 2021-03-02 05:23:30 | Brown, Nebraska, US |
2369536 | 2369536 | 2021-02-28 | US | Nebraska | Brown | 31017 | 214 | 2 | 0 | 212 | 42.43018907 | -99.92904055 | 2021-03-01 05:23:01 | Brown, Nebraska, US |
3068096 | 3068096 | 2021-02-27 | US | Nebraska | Pawnee | 31133 | 213 | 1 | 0 | 212 | 40.13141096 | -96.23705437 | 2021-02-28 05:22:20 | Pawnee, Nebraska, US |
3068038 | 3068038 | 2021-02-27 | US | Nebraska | Brown | 31017 | 214 | 2 | 0 | 212 | 42.43018907 | -99.92904055 | 2021-02-28 05:22:20 | Brown, Nebraska, US |
2185680 | 2185680 | 2021-02-26 | US | Nebraska | Pawnee | 31133 | 213 | 1 | 0 | 212 | 40.13141096 | -96.23705437 | 2021-02-27 05:22:28 | Pawnee, Nebraska, US |
2185622 | 2185622 | 2021-02-26 | US | Nebraska | Brown | 31017 | 214 | 2 | 0 | 212 | 42.43018907 | -99.92904055 | 2021-02-27 05:22:28 | Brown, Nebraska, US |
1860102 | 1860102 | 2021-02-25 | US | Nebraska | Pawnee | 31133 | 213 | 1 | 0 | 212 | 40.13141096 | -96.23705437 | 2021-02-26 05:22:40 | Pawnee, Nebraska, US |
1859729 | 1859729 | 2021-02-25 | US | Minnesota | Lake of the Woods | 27077 | 213 | 1 | 0 | 212 | 48.77217001 | -94.90274472 | 2021-02-26 05:22:40 | Lake of the Woods, Minnesota, US |
281907 | 281907 | 2021-02-24 | US | Minnesota | Lake of the Woods | 27077 | 213 | 1 | 0 | 212 | 48.77217001 | -94.90274472 | 2021-02-25 05:24:57 | Lake of the Woods, Minnesota, US |
1938490 | 1938490 | 2021-02-23 | US | Nebraska | Brown | 31017 | 214 | 2 | 0 | 212 | 42.43018907 | -99.92904055 | 2021-02-24 05:29:16 | Brown, Nebraska, US |
1938175 | 1938175 | 2021-02-23 | US | Minnesota | Lake of the Woods | 27077 | 213 | 1 | 0 | 212 | 48.77217001 | -94.90274472 | 2021-02-24 05:29:16 | Lake of the Woods, Minnesota, US |
1936560 | 1936560 | 2021-02-23 | Monaco | 1904 | 23 | 1669 | 212 | 43.7333 | 7.4167 | 2021-02-24 05:29:16 | Monaco | |||
532745 | 532745 | 2021-02-22 | US | Nebraska | Brown | 31017 | 214 | 2 | 0 | 212 | 42.43018907 | -99.92904055 | 2021-02-23 05:23:41 | Brown, Nebraska, US |
532430 | 532430 | 2021-02-22 | US | Minnesota | Lake of the Woods | 27077 | 213 | 1 | 0 | 212 | 48.77217001 | -94.90274472 | 2021-02-23 05:23:41 | Lake of the Woods, Minnesota, US |
184079 | 184079 | 2021-02-21 | US | Nebraska | Brown | 31017 | 214 | 2 | 0 | 212 | 42.43018907 | -99.92904055 | 2021-02-22 05:24:21 | Brown, Nebraska, US |
744353 | 744353 | 2021-02-20 | US | Nebraska | Brown | 31017 | 214 | 2 | 0 | 212 | 42.43018907 | -99.92904055 | 2021-02-21 05:24:33 | Brown, Nebraska, US |
473451 | 473451 | 2021-02-19 | US | Nebraska | Brown | 31017 | 214 | 2 | 0 | 212 | 42.43018907 | -99.92904055 | 2021-02-20 05:22:51 | Brown, Nebraska, US |
1155160 | 1155160 | 2021-02-18 | US | Nebraska | Brown | 31017 | 214 | 2 | 0 | 212 | 42.43018907 | -99.92904055 | 2021-02-19 05:24:16 | Brown, Nebraska, US |
2283434 | 2283434 | 2021-02-14 | Japan | Gifu | 4476 | 91 | 4173 | 212 | 35.778671 | 137.055925 | 2021-02-15 05:24:49 | Gifu, Japan | ||
2680585 | 2680585 | 2021-02-13 | US | Puerto Rico | Patillas | 72109 | 212 | 0 | 0 | 212 | 18.03174 | -66.012242 | 2021-02-14 05:23:43 | Patillas, Puerto Rico, US |
2679830 | 2679830 | 2021-02-13 | US | Montana | Mineral | 30061 | 212 | 0 | 0 | 212 | 47.15283992 | -115.0015239 | 2021-02-14 05:23:43 | Mineral, Montana, US |
3541463 | 3541463 | 2021-02-12 | US | Montana | Mineral | 30061 | 212 | 0 | 0 | 212 | 47.15283992 | -115.0015239 | 2021-02-13 05:22:12 | Mineral, Montana, US |
2639726 | 2639726 | 2021-02-11 | US | Montana | Mineral | 30061 | 212 | 0 | 0 | 212 | 47.15283992 | -115.0015239 | 2021-02-12 05:23:29 | Mineral, Montana, US |
3980581 | 3980581 | 2021-02-10 | US | Montana | Mineral | 30061 | 212 | 0 | 0 | 212 | 47.15283992 | -115.0015239 | 2021-02-11 05:23:55 | Mineral, Montana, US |
1529901 | 1529901 | 2021-02-09 | US | Montana | Mineral | 30061 | 212 | 0 | 0 | 212 | 47.15283992 | -115.0015239 | 2021-02-10 05:22:41 | Mineral, Montana, US |
615692 | 615692 | 2021-02-08 | US | Montana | Mineral | 30061 | 212 | 0 | 0 | 212 | 47.15283992 | -115.0015239 | 2021-02-09 05:23:30 | Mineral, Montana, US |
976922 | 976922 | 2021-02-06 | US | Montana | Mineral | 30061 | 212 | 0 | 0 | 212 | 47.15283992 | -115.0015239 | 2021-02-07 05:23:00 | Mineral, Montana, US |
1590180 | 1590180 | 2021-02-05 | US | Montana | Mineral | 30061 | 212 | 0 | 0 | 212 | 47.15283992 | -115.0015239 | 2021-02-06 05:23:55 | Mineral, Montana, US |
791017 | 791017 | 2021-02-04 | US | Colorado | Ouray | 8091 | 233 | 3 | 0 | 212 | 38.14717457 | -107.7675136 | 2021-02-05 05:22:38 | Ouray, Colorado, US |
1679678 | 1679678 | 2021-02-01 | US | Texas | Schleicher | 48413 | 165 | 6 | 0 | 212 | 30.89740592 | -100.5384842 | 2021-02-02 05:22:49 | Schleicher, Texas, US |
1463074 | 1463074 | 2021-01-31 | US | Virginia | Craig | 51045 | 215 | 3 | 0 | 212 | 37.48133648 | -80.21072274 | 2021-02-01 05:22:53 | Craig, Virginia, US |
2214982 | 2214982 | 2021-01-30 | US | Virginia | Craig | 51045 | 215 | 3 | 0 | 212 | 37.48133648 | -80.21072274 | 2021-01-31 05:22:42 | Craig, Virginia, US |
1899535 | 1899535 | 2021-01-29 | US | North Dakota | Burke | 38013 | 212 | 1 | 0 | 212 | 48.79094471 | -102.5182117 | 2021-01-30 05:22:49 | Burke, North Dakota, US |
2484351 | 2484351 | 2021-01-28 | US | North Dakota | Burke | 38013 | 211 | 1 | 0 | 212 | 48.79094471 | -102.5182117 | 2021-01-29 05:22:23 | Burke, North Dakota, US |
2482736 | 2482736 | 2021-01-28 | US | Georgia | Clay | 13061 | 215 | 3 | 0 | 212 | 31.62221166 | -84.97713865 | 2021-01-29 05:22:23 | Clay, Georgia, US |
3155986 | 3155986 | 2021-01-27 | US | North Dakota | Burke | 38013 | 211 | 1 | 0 | 212 | 48.79094471 | -102.5182117 | 2021-01-28 05:22:24 | Burke, North Dakota, US |
3155679 | 3155679 | 2021-01-27 | US | Nebraska | Hitchcock | 31087 | 215 | 3 | 0 | 212 | 40.17609175 | -101.0416477 | 2021-01-28 05:22:24 | Hitchcock, Nebraska, US |
3154371 | 3154371 | 2021-01-27 | US | Georgia | Clay | 13061 | 215 | 3 | 0 | 212 | 31.62221166 | -84.97713865 | 2021-01-28 05:22:24 | Clay, Georgia, US |
2429668 | 2429668 | 2021-01-23 | US | Puerto Rico | Sabana Grande | 72121 | 212 | 0 | 0 | 212 | 18.08282 | -66.943758 | 2021-01-24 05:22:35 | Sabana Grande, Puerto Rico, US |
2428846 | 2428846 | 2021-01-23 | US | Missouri | Putnam | 29171 | 214 | 2 | 0 | 212 | 40.47942497 | -93.02042674 | 2021-01-24 05:22:35 | Putnam, Missouri, US |
2468748 | 2468748 | 2021-01-22 | US | Missouri | Putnam | 29171 | 214 | 2 | 0 | 212 | 40.47942497 | -93.02042674 | 2021-01-23 05:22:03 | Putnam, Missouri, US |
437965 | 437965 | 2021-01-21 | US | Oregon | Grant | 41023 | 213 | 1 | 0 | 212 | 44.49024544 | -119.0068631 | 2021-01-22 05:22:10 | Grant, Oregon, US |
436668 | 436668 | 2021-01-21 | US | Kansas | Morton | 20129 | 220 | 8 | 0 | 212 | 37.19141121 | -101.79925190000002 | 2021-01-22 05:22:10 | Morton, Kansas, US |
436652 | 436652 | 2021-01-21 | US | Kansas | Kiowa | 20097 | 216 | 4 | 0 | 212 | 37.55848695 | -99.2856537 | 2021-01-22 05:22:10 | Kiowa, Kansas, US |
1096696 | 1096696 | 2021-01-20 | US | Oregon | Grant | 41023 | 213 | 1 | 0 | 212 | 44.49024544 | -119.0068631 | 2021-01-21 05:22:01 | Grant, Oregon, US |
1095399 | 1095399 | 2021-01-20 | US | Kansas | Morton | 20129 | 220 | 8 | 0 | 212 | 37.19141121 | -101.79925190000002 | 2021-01-21 05:22:01 | Morton, Kansas, US |
1095383 | 1095383 | 2021-01-20 | US | Kansas | Kiowa | 20097 | 216 | 4 | 0 | 212 | 37.55848695 | -99.2856537 | 2021-01-21 05:22:01 | Kiowa, Kansas, US |
910786 | 910786 | 2021-01-19 | US | Oregon | Grant | 41023 | 213 | 1 | 0 | 212 | 44.49024544 | -119.0068631 | 2021-01-20 05:21:54 | Grant, Oregon, US |
910238 | 910238 | 2021-01-19 | US | Nebraska | Franklin | 31061 | 215 | 3 | 0 | 212 | 40.17636348 | -98.95299073 | 2021-01-20 05:21:54 | Franklin, Nebraska, US |
239849 | 239849 | 2021-01-18 | US | Oregon | Grant | 41023 | 213 | 1 | 0 | 212 | 44.49024544 | -119.0068631 | 2021-01-19 05:22:15 | Grant, Oregon, US |
239602 | 239602 | 2021-01-18 | US | North Carolina | Tyrrell | 37177 | 216 | 4 | 0 | 212 | 35.87147226 | -76.17055253 | 2021-01-19 05:22:15 | Tyrrell, North Carolina, US |
239301 | 239301 | 2021-01-18 | US | Nebraska | Franklin | 31061 | 215 | 3 | 0 | 212 | 40.17636348 | -98.95299073 | 2021-01-19 05:22:15 | Franklin, Nebraska, US |
3506709 | 3506709 | 2021-01-17 | US | Virginia | King and Queen | 51097 | 214 | 2 | 0 | 212 | 37.71044922 | -76.88689628 | 2021-01-18 05:22:34 | King and Queen, Virginia, US |
3505966 | 3505966 | 2021-01-17 | US | Oregon | Grant | 41023 | 213 | 1 | 0 | 212 | 44.49024544 | -119.0068631 | 2021-01-18 05:22:34 | Grant, Oregon, US |
3505719 | 3505719 | 2021-01-17 | US | North Carolina | Tyrrell | 37177 | 216 | 4 | 0 | 212 | 35.87147226 | -76.17055253 | 2021-01-18 05:22:34 | Tyrrell, North Carolina, US |
3104574 | 3104574 | 2021-01-16 | US | Texas | Kimble | 48267 | 201 | 6 | 0 | 212 | 30.48678918 | -99.74856473 | 2021-01-17 05:22:17 | Kimble, Texas, US |
3104049 | 3104049 | 2021-01-16 | US | Oregon | Grant | 41023 | 213 | 1 | 0 | 212 | 44.49024544 | -119.0068631 | 2021-01-17 05:22:17 | Grant, Oregon, US |
3518776 | 3518776 | 2021-01-15 | US | Virginia | Norton | 51720 | 215 | 3 | 0 | 212 | 36.93357076 | -82.62750411 | 2021-01-16 05:22:40 | Norton, Virginia, US |
3518011 | 3518011 | 2021-01-15 | US | Oregon | Grant | 41023 | 213 | 1 | 0 | 212 | 44.49024544 | -119.0068631 | 2021-01-16 05:22:40 | Grant, Oregon, US |
3882455 | 3882455 | 2021-01-14 | US | South Dakota | McPherson | 46089 | 215 | 3 | 0 | 212 | 45.76626028 | -99.22118798 | 2021-01-15 05:22:24 | McPherson, South Dakota, US |
3308633 | 3308633 | 2021-01-13 | US | Alaska | Unassigned | 90002 | 212 | 0 | 0 | 212 | 69.31479216 | 0.0 | 2021-01-14 05:22:32 | Unassigned, Alaska, US |
777641 | 777641 | 2021-01-12 | US | Virginia | Bath | 51017 | 212 | 0 | 0 | 212 | 38.05852573 | -79.73912095 | 2021-01-13 05:22:15 | Bath, Virginia, US |
777067 | 777067 | 2021-01-12 | US | Puerto Rico | Ceiba | 72037 | 212 | 0 | 0 | 212 | 18.251818 | -65.666416 | 2021-01-13 05:22:15 | Ceiba, Puerto Rico, US |
192465 | 192465 | 2021-01-11 | US | North Dakota | Logan | 38047 | 216 | 8 | 0 | 212 | 46.45729487 | -99.47719806 | 2021-01-12 05:22:15 | Logan, North Dakota, US |
2629319 | 2629319 | 2021-01-10 | US | Washington | Skamania | 53059 | 213 | 1 | 0 | 212 | 46.02408726 | -121.9164403 | 2021-01-11 05:21:50 | Skamania, Washington, US |
2628268 | 2628268 | 2021-01-10 | US | North Dakota | Logan | 38047 | 216 | 8 | 0 | 212 | 46.45729487 | -99.47719806 | 2021-01-11 05:21:50 | Logan, North Dakota, US |
3903407 | 3903407 | 2021-01-09 | US | Washington | Skamania | 53059 | 213 | 1 | 0 | 212 | 46.02408726 | -121.9164403 | 2021-01-10 05:22:12 | Skamania, Washington, US |
3902356 | 3902356 | 2021-01-09 | US | North Dakota | Logan | 38047 | 216 | 8 | 0 | 212 | 46.45729487 | -99.47719806 | 2021-01-10 05:22:12 | Logan, North Dakota, US |
3902349 | 3902349 | 2021-01-09 | US | North Dakota | Golden Valley | 38033 | 217 | 0 | 0 | 212 | 46.94022281 | -103.8465421 | 2021-01-10 05:22:12 | Golden Valley, North Dakota, US |
2542662 | 2542662 | 2021-01-07 | US | Kansas | Chase | 20017 | 215 | 3 | 0 | 212 | 38.30292938 | -96.59563862 | 2021-01-08 05:22:42 | Chase, Kansas, US |
2541424 | 2541424 | 2021-01-07 | Japan | Kagoshima | 1157 | 14 | 931 | 212 | 31.009484000000004 | 130.430665 | 2021-01-08 05:22:42 | Kagoshima, Japan | ||
2868021 | 2868021 | 2021-01-06 | US | Virginia | Charles City | 51036 | 220 | 8 | 0 | 212 | 37.35358063 | -77.05634116 | 2021-01-07 05:22:03 | Charles City, Virginia, 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]);