johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
489 rows where confirmed = 1194 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2954263 | 2954263 | 2022-12-20 | US | South Dakota | Gregory | 46053 | 1194 | 34 | 0 | 43.19419064 | -99.18883902 | 2022-12-21 04:21:03 | Gregory, South Dakota, US | |
3176665 | 3176665 | 2022-12-19 | US | South Dakota | Gregory | 46053 | 1194 | 34 | 0 | 43.19419064 | -99.18883902 | 2022-12-20 04:21:04 | Gregory, South Dakota, US | |
1631182 | 1631182 | 2022-12-18 | US | South Dakota | Gregory | 46053 | 1194 | 34 | 0 | 43.19419064 | -99.18883902 | 2022-12-19 04:21:03 | Gregory, South Dakota, US | |
506561 | 506561 | 2022-12-17 | US | South Dakota | Gregory | 46053 | 1194 | 34 | 0 | 43.19419064 | -99.18883902 | 2022-12-18 04:21:03 | Gregory, South Dakota, US | |
3327133 | 3327133 | 2022-12-16 | US | South Dakota | Gregory | 46053 | 1194 | 34 | 0 | 43.19419064 | -99.18883902 | 2022-12-17 04:21:04 | Gregory, South Dakota, US | |
545645 | 545645 | 2022-12-15 | US | South Dakota | Gregory | 46053 | 1194 | 34 | 0 | 43.19419064 | -99.18883902 | 2022-12-16 04:21:01 | Gregory, South Dakota, US | |
351173 | 351173 | 2022-12-14 | US | South Dakota | Gregory | 46053 | 1194 | 34 | 0 | 43.19419064 | -99.18883902 | 2022-12-15 04:20:58 | Gregory, South Dakota, US | |
3249932 | 3249932 | 2022-10-11 | China | Chongqing | 1194 | 6 | 0 | 30.0572 | 107.874 | 2022-10-12 04:22:51 | Chongqing, China | |||
2531377 | 2531377 | 2022-10-06 | US | Montana | Chouteau | 30015 | 1194 | 15 | 0 | 47.88084126 | -110.4353362 | 2022-10-07 04:23:08 | Chouteau, Montana, US | |
1812771 | 1812771 | 2022-10-05 | US | Montana | Chouteau | 30015 | 1194 | 15 | 0 | 47.88084126 | -110.4353362 | 2022-10-06 04:21:22 | Chouteau, Montana, US | |
132745 | 132745 | 2022-10-04 | US | Montana | Chouteau | 30015 | 1194 | 15 | 0 | 47.88084126 | -110.4353362 | 2022-10-05 04:23:06 | Chouteau, Montana, US | |
2687692 | 2687692 | 2022-10-03 | US | Montana | Chouteau | 30015 | 1194 | 15 | 0 | 47.88084126 | -110.4353362 | 2022-10-04 04:22:55 | Chouteau, Montana, US | |
2261759 | 2261759 | 2022-10-02 | US | Montana | Chouteau | 30015 | 1194 | 15 | 0 | 47.88084126 | -110.4353362 | 2022-10-03 04:23:11 | Chouteau, Montana, US | |
2997285 | 2997285 | 2022-10-01 | US | Montana | Chouteau | 30015 | 1194 | 15 | 0 | 47.88084126 | -110.4353362 | 2022-10-02 04:21:23 | Chouteau, Montana, US | |
855611 | 855611 | 2022-09-30 | US | Montana | Chouteau | 30015 | 1194 | 15 | 0 | 47.88084126 | -110.4353362 | 2022-10-01 04:23:01 | Chouteau, Montana, US | |
1562522 | 1562522 | 2022-09-28 | US | North Dakota | Sargent | 38081 | 1194 | 9 | 0 | 46.10830372 | -97.63217159 | 2022-09-29 04:22:34 | Sargent, North Dakota, US | |
2650350 | 2650350 | 2022-09-24 | US | California | Modoc | 6049 | 1194 | 11 | 0 | 41.58965602 | -120.7244817 | 2022-09-25 04:23:31 | Modoc, California, US | |
384790 | 384790 | 2022-09-23 | US | California | Modoc | 6049 | 1194 | 11 | 0 | 41.58965602 | -120.7244817 | 2022-09-24 04:21:40 | Modoc, California, US | |
1624856 | 1624856 | 2022-09-22 | US | California | Modoc | 6049 | 1194 | 11 | 0 | 41.58965602 | -120.7244817 | 2022-09-23 04:23:13 | Modoc, California, US | |
1371060 | 1371060 | 2022-09-21 | US | California | Modoc | 6049 | 1194 | 11 | 0 | 41.58965602 | -120.7244817 | 2022-09-22 04:22:56 | Modoc, California, US | |
2017290 | 2017290 | 2022-09-20 | US | California | Modoc | 6049 | 1194 | 11 | 0 | 41.58965602 | -120.7244817 | 2022-09-21 04:23:22 | Modoc, California, US | |
2017146 | 2017146 | 2022-09-20 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 1194 | 1 | 0 | 58.62403337 | -156.2140589 | 2022-09-21 04:23:22 | Bristol Bay plus Lake and Peninsula, Alaska, US | |
3571163 | 3571163 | 2022-09-19 | US | California | Modoc | 6049 | 1194 | 11 | 0 | 41.58965602 | -120.7244817 | 2022-09-20 04:22:48 | Modoc, California, US | |
3571019 | 3571019 | 2022-09-19 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 1194 | 1 | 0 | 58.62403337 | -156.2140589 | 2022-09-20 04:22:48 | Bristol Bay plus Lake and Peninsula, Alaska, US | |
419902 | 419902 | 2022-09-18 | US | California | Modoc | 6049 | 1194 | 11 | 0 | 41.58965602 | -120.7244817 | 2022-09-19 04:21:49 | Modoc, California, US | |
419758 | 419758 | 2022-09-18 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 1194 | 1 | 0 | 58.62403337 | -156.2140589 | 2022-09-19 04:21:49 | Bristol Bay plus Lake and Peninsula, Alaska, US | |
3373926 | 3373926 | 2022-09-17 | US | California | Modoc | 6049 | 1194 | 11 | 0 | 41.58965602 | -120.7244817 | 2022-09-18 04:22:50 | Modoc, California, US | |
3373782 | 3373782 | 2022-09-17 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 1194 | 1 | 0 | 58.62403337 | -156.2140589 | 2022-09-18 04:22:50 | Bristol Bay plus Lake and Peninsula, Alaska, US | |
2356034 | 2356034 | 2022-09-16 | US | California | Modoc | 6049 | 1194 | 11 | 0 | 41.58965602 | -120.7244817 | 2022-09-17 04:20:19 | Modoc, California, US | |
2355890 | 2355890 | 2022-09-16 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 1194 | 1 | 0 | 58.62403337 | -156.2140589 | 2022-09-17 04:20:19 | Bristol Bay plus Lake and Peninsula, Alaska, US | |
3987047 | 3987047 | 2022-09-15 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 1194 | 1 | 0 | 58.62403337 | -156.2140589 | 2022-09-16 04:21:19 | Bristol Bay plus Lake and Peninsula, Alaska, US | |
1889564 | 1889564 | 2022-09-14 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 1194 | 1 | 0 | 58.62403337 | -156.2140589 | 2022-09-15 04:21:02 | Bristol Bay plus Lake and Peninsula, Alaska, US | |
2396479 | 2396479 | 2022-09-12 | US | Michigan | Ontonagon | 26131 | 1194 | 41 | 0 | 46.6652262 | -89.31390481 | 2022-09-13 04:20:57 | Ontonagon, Michigan, US | |
3767557 | 3767557 | 2022-09-11 | US | Michigan | Ontonagon | 26131 | 1194 | 41 | 0 | 46.6652262 | -89.31390481 | 2022-09-12 04:20:58 | Ontonagon, Michigan, US | |
3826132 | 3826132 | 2022-09-10 | US | Michigan | Ontonagon | 26131 | 1194 | 41 | 0 | 46.6652262 | -89.31390481 | 2022-09-11 04:20:50 | Ontonagon, Michigan, US | |
964589 | 964589 | 2022-09-09 | US | Michigan | Ontonagon | 26131 | 1194 | 41 | 0 | 46.6652262 | -89.31390481 | 2022-09-10 04:21:10 | Ontonagon, Michigan, US | |
254991 | 254991 | 2022-09-08 | US | Michigan | Ontonagon | 26131 | 1194 | 41 | 0 | 46.6652262 | -89.31390481 | 2022-09-09 04:21:11 | Ontonagon, Michigan, US | |
3746789 | 3746789 | 2022-09-07 | US | Michigan | Ontonagon | 26131 | 1194 | 41 | 0 | 46.6652262 | -89.31390481 | 2022-09-08 04:21:02 | Ontonagon, Michigan, US | |
116429 | 116429 | 2022-09-06 | US | Michigan | Ontonagon | 26131 | 1194 | 41 | 0 | 46.6652262 | -89.31390481 | 2022-09-07 04:20:59 | Ontonagon, Michigan, US | |
2326749 | 2326749 | 2022-08-24 | US | Virginia | Rappahannock | 51157 | 1194 | 10 | 0 | 38.68295619 | -78.15826963 | 2022-08-25 04:21:13 | Rappahannock, Virginia, US | |
994540 | 994540 | 2022-08-16 | US | Wisconsin | Florence | 55037 | 1194 | 17 | 0 | 45.84963535 | -88.39804137 | 2022-08-17 04:20:59 | Florence, Wisconsin, US | |
3872486 | 3872486 | 2022-07-31 | US | Idaho | Boise | 16015 | 1194 | 14 | 0 | 43.98829931 | -115.7309284 | 2022-08-01 04:21:03 | Boise, Idaho, US | |
675240 | 675240 | 2022-07-30 | US | Idaho | Boise | 16015 | 1194 | 14 | 0 | 43.98829931 | -115.7309284 | 2022-07-31 04:21:02 | Boise, Idaho, US | |
1784439 | 1784439 | 2022-07-29 | US | Idaho | Boise | 16015 | 1194 | 14 | 0 | 43.98829931 | -115.7309284 | 2022-07-30 04:20:42 | Boise, Idaho, US | |
630856 | 630856 | 2022-07-12 | US | Idaho | Lewis | 16061 | 1194 | 29 | 0 | 46.23315327 | -116.434146 | 2022-07-13 04:20:58 | Lewis, Idaho, US | |
1212500 | 1212500 | 2022-07-11 | US | Idaho | Lewis | 16061 | 1194 | 29 | 0 | 46.23315327 | -116.434146 | 2022-07-12 04:20:51 | Lewis, Idaho, US | |
2493381 | 2493381 | 2022-06-29 | US | Virginia | King and Queen | 51097 | 1194 | 12 | 0 | 37.71044922 | -76.88689628 | 2022-06-30 04:21:01 | King and Queen, Virginia, US | |
559847 | 559847 | 2022-06-16 | US | Illinois | Putnam | 17155 | 1194 | 9 | 0 | 41.2013541 | -89.2869272 | 2022-06-17 04:20:56 | Putnam, Illinois, US | |
3983649 | 3983649 | 2022-06-15 | US | Illinois | Putnam | 17155 | 1194 | 9 | 0 | 41.2013541 | -89.2869272 | 2022-06-16 04:20:55 | Putnam, Illinois, US | |
947890 | 947890 | 2022-06-14 | US | Illinois | Putnam | 17155 | 1194 | 9 | 0 | 41.2013541 | -89.2869272 | 2022-06-15 04:20:54 | Putnam, Illinois, US | |
2980298 | 2980298 | 2022-06-13 | US | Illinois | Putnam | 17155 | 1194 | 9 | 0 | 41.2013541 | -89.2869272 | 2022-06-14 04:20:52 | Putnam, Illinois, US | |
974174 | 974174 | 2022-06-01 | US | Texas | Wheeler | 48483 | 1194 | 23 | 0 | 35.40114335 | -100.2699514 | 2022-06-02 05:20:39 | Wheeler, Texas, US | |
232481 | 232481 | 2022-05-31 | US | Texas | Wheeler | 48483 | 1194 | 23 | 0 | 35.40114335 | -100.2699514 | 2022-06-01 04:20:55 | Wheeler, Texas, US | |
3189246 | 3189246 | 2022-05-30 | US | Texas | Wheeler | 48483 | 1194 | 23 | 0 | 35.40114335 | -100.2699514 | 2022-05-31 04:20:51 | Wheeler, Texas, US | |
3201395 | 3201395 | 2022-05-29 | US | Texas | Wheeler | 48483 | 1194 | 23 | 0 | 35.40114335 | -100.2699514 | 2022-05-30 04:20:50 | Wheeler, Texas, US | |
2728273 | 2728273 | 2022-05-28 | US | Texas | Wheeler | 48483 | 1194 | 23 | 0 | 35.40114335 | -100.2699514 | 2022-05-29 04:20:53 | Wheeler, Texas, US | |
1317454 | 1317454 | 2022-05-27 | US | Texas | Wheeler | 48483 | 1194 | 23 | 0 | 35.40114335 | -100.2699514 | 2022-05-28 04:21:07 | Wheeler, Texas, US | |
1112893 | 1112893 | 2022-05-21 | US | Virginia | Charles City | 51036 | 1194 | 27 | 0 | 37.35358063 | -77.05634116 | 2022-05-22 04:20:52 | Charles City, Virginia, US | |
1172517 | 1172517 | 2022-05-20 | US | Virginia | Charles City | 51036 | 1194 | 27 | 0 | 37.35358063 | -77.05634116 | 2022-05-21 04:20:58 | Charles City, Virginia, US | |
3899280 | 3899280 | 2022-05-19 | US | Virginia | Charles City | 51036 | 1194 | 27 | 0 | 37.35358063 | -77.05634116 | 2022-05-20 04:20:57 | Charles City, Virginia, US | |
1188078 | 1188078 | 2022-05-18 | US | Virginia | Emporia | 51595 | 1194 | 55 | 0 | 36.69455571 | -77.53406129 | 2022-05-19 04:20:54 | Emporia, Virginia, US | |
1188064 | 1188064 | 2022-05-18 | US | Virginia | Charles City | 51036 | 1194 | 27 | 0 | 37.35358063 | -77.05634116 | 2022-05-19 04:20:54 | Charles City, Virginia, US | |
465999 | 465999 | 2022-05-02 | US | Oklahoma | Unassigned | 90040 | 1194 | 1630 | 0 | 36.83532655 | 0.0 | 2022-05-03 04:21:00 | Unassigned, Oklahoma, US | |
3918638 | 3918638 | 2022-05-01 | US | Oklahoma | Unassigned | 90040 | 1194 | 1630 | 0 | 36.83532655 | 0.0 | 2022-05-02 04:21:10 | Unassigned, Oklahoma, US | |
2843442 | 2843442 | 2022-04-30 | US | Oklahoma | Unassigned | 90040 | 1194 | 1630 | 0 | 36.83532655 | 0.0 | 2022-05-01 04:20:57 | Unassigned, Oklahoma, US | |
1645692 | 1645692 | 2022-03-03 | US | Kansas | Ottawa | 20143 | 1194 | 16 | 0 | 39.13237408 | -97.65020313 | 2022-03-04 04:21:09 | Ottawa, Kansas, US | |
2526695 | 2526695 | 2022-03-02 | US | Kansas | Ottawa | 20143 | 1194 | 16 | 0 | 39.13237408 | -97.65020313 | 2022-03-03 04:21:01 | Ottawa, Kansas, US | |
1994157 | 1994157 | 2022-03-01 | US | Louisiana | Cameron | 22023 | 1194 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-03-02 04:21:07 | Cameron, Louisiana, US | |
944331 | 944331 | 2022-02-28 | US | Louisiana | Cameron | 22023 | 1194 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-03-01 04:21:09 | Cameron, Louisiana, US | |
2734522 | 2734522 | 2022-02-27 | US | Louisiana | Cameron | 22023 | 1194 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-02-28 04:21:05 | Cameron, Louisiana, US | |
3047675 | 3047675 | 2022-02-26 | US | Louisiana | Cameron | 22023 | 1194 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-02-27 04:21:04 | Cameron, Louisiana, US | |
576330 | 576330 | 2022-02-25 | US | Louisiana | Cameron | 22023 | 1194 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-02-26 04:21:12 | Cameron, Louisiana, US | |
3915347 | 3915347 | 2022-02-20 | US | Virginia | Cumberland | 51049 | 1194 | 22 | 0 | 37.51328851 | -78.24398086 | 2022-02-21 04:21:05 | Cumberland, Virginia, US | |
3878905 | 3878905 | 2022-02-19 | US | Virginia | Cumberland | 51049 | 1194 | 22 | 0 | 37.51328851 | -78.24398086 | 2022-02-20 04:21:00 | Cumberland, Virginia, US | |
3859161 | 3859161 | 2022-02-18 | US | Virginia | Cumberland | 51049 | 1194 | 22 | 0 | 37.51328851 | -78.24398086 | 2022-02-19 04:21:11 | Cumberland, Virginia, US | |
1301380 | 1301380 | 2022-02-17 | US | Virginia | Cumberland | 51049 | 1194 | 22 | 0 | 37.51328851 | -78.24398086 | 2022-02-18 04:21:04 | Cumberland, Virginia, US | |
1299789 | 1299789 | 2022-02-17 | US | Minnesota | Lincoln | 27081 | 1194 | 6 | 0 | 44.41311883 | -96.26688165 | 2022-02-18 04:21:04 | Lincoln, Minnesota, US | |
1464520 | 1464520 | 2022-02-10 | US | Alaska | Prince of Wales-Hyder | 2198 | 1194 | 6 | 0 | 55.76261984 | -133.0511621 | 2022-02-11 04:21:09 | Prince of Wales-Hyder, Alaska, US | |
3074481 | 3074481 | 2022-02-09 | US | Alaska | Prince of Wales-Hyder | 2198 | 1194 | 6 | 0 | 55.76261984 | -133.0511621 | 2022-02-10 04:21:14 | Prince of Wales-Hyder, Alaska, US | |
2477017 | 2477017 | 2022-02-03 | US | Texas | Crane | 48103 | 1194 | 21 | 0 | 31.43052248 | -102.5143314 | 2022-02-04 04:21:10 | Crane, Texas, US | |
1782573 | 1782573 | 2022-01-27 | US | Texas | Newton | 48351 | 1194 | 56 | 0 | 30.78548982 | -93.74408813 | 2022-01-28 04:21:09 | Newton, Texas, US | |
2052929 | 2052929 | 2022-01-25 | US | Illinois | Scott | 17171 | 1194 | 10 | 0 | 39.642916899999996 | -90.47814431 | 2022-01-26 04:21:07 | Scott, Illinois, US | |
3689296 | 3689296 | 2022-01-13 | US | Mississippi | Jefferson | 28063 | 1194 | 35 | 0 | 31.73397872 | -91.03764977 | 2022-01-14 04:21:54 | Jefferson, Mississippi, US | |
1217532 | 1217532 | 2022-01-08 | US | Missouri | Shelby | 29205 | 1194 | 13 | 0 | 39.79742518 | -92.07634971 | 2022-01-09 04:21:46 | Shelby, Missouri, US | |
1287849 | 1287849 | 2022-01-04 | US | Mississippi | Quitman | 28119 | 1194 | 28 | 0 | 34.25157572 | -90.28908 | 2022-01-05 04:21:59 | Quitman, Mississippi, US | |
2168099 | 2168099 | 2022-01-01 | US | Arkansas | Woodruff | 5147 | 1194 | 24 | 0 | 35.18902527 | -91.2439489 | 2022-01-02 04:20:52 | Woodruff, Arkansas, US | |
2777530 | 2777530 | 2021-12-31 | US | Arkansas | Woodruff | 5147 | 1194 | 24 | 0 | 35.18902527 | -91.2439489 | 2022-01-01 04:22:14 | Woodruff, Arkansas, US | |
2777504 | 2777504 | 2021-12-31 | US | Arkansas | Montgomery | 5097 | 1194 | 53 | 0 | 34.53704874 | -93.65824478 | 2022-01-01 04:22:14 | Montgomery, Arkansas, US | |
1670421 | 1670421 | 2021-12-29 | US | Missouri | Shannon | 29203 | 1194 | 29 | 0 | 37.15772072 | -91.40190382 | 2021-12-30 04:21:25 | Shannon, Missouri, US | |
1669496 | 1669496 | 2021-12-29 | US | Illinois | Pulaski | 17153 | 1194 | 15 | 0 | 37.22631423 | -89.13085001 | 2021-12-30 04:21:25 | Pulaski, Illinois, US | |
2113058 | 2113058 | 2021-12-26 | US | Kansas | Wabaunsee | 20197 | 1194 | 19 | 0 | 38.95471985 | -96.20350509 | 2021-12-27 04:21:58 | Wabaunsee, Kansas, US | |
3606430 | 3606430 | 2021-12-25 | US | Kansas | Wabaunsee | 20197 | 1194 | 19 | 0 | 38.95471985 | -96.20350509 | 2021-12-26 04:21:50 | Wabaunsee, Kansas, US | |
2964748 | 2964748 | 2021-12-24 | US | Kansas | Wabaunsee | 20197 | 1194 | 19 | 0 | 38.95471985 | -96.20350509 | 2021-12-25 04:21:37 | Wabaunsee, Kansas, US | |
3817780 | 3817780 | 2021-12-23 | US | Kansas | Wabaunsee | 20197 | 1194 | 19 | 0 | 38.95471985 | -96.20350509 | 2021-12-24 04:21:34 | Wabaunsee, Kansas, US | |
799788 | 799788 | 2021-12-22 | US | Kansas | Wabaunsee | 20197 | 1194 | 19 | 0 | 38.95471985 | -96.20350509 | 2021-12-23 04:21:21 | Wabaunsee, Kansas, US | |
799395 | 799395 | 2021-12-22 | US | Illinois | Brown | 17009 | 1194 | 13 | 0 | 39.96209138 | -90.75068024 | 2021-12-23 04:21:21 | Brown, Illinois, US | |
3499559 | 3499559 | 2021-12-15 | US | Virginia | Madison | 51113 | 1194 | 23 | 0 | 38.41531222 | -78.28220331 | 2021-12-16 04:22:11 | Madison, Virginia, US | |
784539 | 784539 | 2021-12-13 | US | Nevada | Pershing | 32027 | 1194 | 27 | 0 | 40.44003782 | -118.40056409999998 | 2021-12-14 04:22:38 | Pershing, Nevada, US | |
1662574 | 1662574 | 2021-12-12 | US | Nevada | Pershing | 32027 | 1194 | 27 | 0 | 40.44003782 | -118.40056409999998 | 2021-12-13 04:22:02 | Pershing, Nevada, US | |
1666590 | 1666590 | 2021-12-11 | US | Nevada | Pershing | 32027 | 1194 | 27 | 0 | 40.44003782 | -118.40056409999998 | 2021-12-12 04:22:12 | Pershing, Nevada, 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]);