johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
455 rows where confirmed = 1198 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1622697 | 1622697 | 2022-11-22 | US | North Dakota | Pierce | 38069 | 1198 | 32 | 0 | 48.24977025 | -99.96407787 | 2022-11-23 04:21:06 | Pierce, North Dakota, US | |
3462585 | 3462585 | 2022-11-21 | US | North Dakota | Pierce | 38069 | 1198 | 32 | 0 | 48.24977025 | -99.96407787 | 2022-11-22 04:20:47 | Pierce, North Dakota, US | |
1642770 | 1642770 | 2022-11-20 | US | North Dakota | Pierce | 38069 | 1198 | 32 | 0 | 48.24977025 | -99.96407787 | 2022-11-21 04:21:05 | Pierce, North Dakota, US | |
2066327 | 2066327 | 2022-11-19 | US | North Dakota | Pierce | 38069 | 1198 | 32 | 0 | 48.24977025 | -99.96407787 | 2022-11-20 04:21:08 | Pierce, North Dakota, US | |
1757721 | 1757721 | 2022-11-18 | US | North Dakota | Pierce | 38069 | 1198 | 32 | 0 | 48.24977025 | -99.96407787 | 2022-11-19 04:21:14 | Pierce, North Dakota, US | |
3028714 | 3028714 | 2022-11-17 | US | North Dakota | Pierce | 38069 | 1198 | 32 | 0 | 48.24977025 | -99.96407787 | 2022-11-18 04:21:15 | Pierce, North Dakota, US | |
131172 | 131172 | 2022-10-04 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 1198 | 1 | 0 | 58.62403337 | -156.2140589 | 2022-10-05 04:23:06 | Bristol Bay plus Lake and Peninsula, Alaska, US | |
2686119 | 2686119 | 2022-10-03 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 1198 | 1 | 0 | 58.62403337 | -156.2140589 | 2022-10-04 04:22:55 | Bristol Bay plus Lake and Peninsula, Alaska, US | |
2262193 | 2262193 | 2022-10-02 | US | North Dakota | Sargent | 38081 | 1198 | 9 | 0 | 46.10830372 | -97.63217159 | 2022-10-03 04:23:11 | Sargent, North Dakota, US | |
2260186 | 2260186 | 2022-10-02 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 1198 | 1 | 0 | 58.62403337 | -156.2140589 | 2022-10-03 04:23:11 | Bristol Bay plus Lake and Peninsula, Alaska, US | |
2997719 | 2997719 | 2022-10-01 | US | North Dakota | Sargent | 38081 | 1198 | 9 | 0 | 46.10830372 | -97.63217159 | 2022-10-02 04:21:23 | Sargent, North Dakota, US | |
2995712 | 2995712 | 2022-10-01 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 1198 | 1 | 0 | 58.62403337 | -156.2140589 | 2022-10-02 04:21:23 | Bristol Bay plus Lake and Peninsula, Alaska, US | |
856045 | 856045 | 2022-09-30 | US | North Dakota | Sargent | 38081 | 1198 | 9 | 0 | 46.10830372 | -97.63217159 | 2022-10-01 04:23:01 | Sargent, North Dakota, US | |
854038 | 854038 | 2022-09-30 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 1198 | 1 | 0 | 58.62403337 | -156.2140589 | 2022-10-01 04:23:01 | Bristol Bay plus Lake and Peninsula, Alaska, US | |
2375964 | 2375964 | 2022-09-29 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 1198 | 1 | 0 | 58.62403337 | -156.2140589 | 2022-09-30 04:23:09 | Bristol Bay plus Lake and Peninsula, Alaska, US | |
1560515 | 1560515 | 2022-09-28 | US | Alaska | Bristol Bay plus Lake and Peninsula | 2164 | 1198 | 1 | 0 | 58.62403337 | -156.2140589 | 2022-09-29 04:22:34 | Bristol Bay plus Lake and Peninsula, Alaska, US | |
373148 | 373148 | 2022-09-13 | US | Idaho | Lincoln | 16063 | 1198 | 15 | 0 | 43.0012336 | -114.1358773 | 2022-09-14 04:20:44 | Lincoln, Idaho, US | |
2395750 | 2395750 | 2022-09-12 | US | Idaho | Lincoln | 16063 | 1198 | 15 | 0 | 43.0012336 | -114.1358773 | 2022-09-13 04:20:57 | Lincoln, Idaho, US | |
2832216 | 2832216 | 2022-08-25 | US | Virginia | Rappahannock | 51157 | 1198 | 10 | 0 | 38.68295619 | -78.15826963 | 2022-08-26 04:21:02 | Rappahannock, Virginia, US | |
2404219 | 2404219 | 2022-08-21 | US | Kentucky | Carlisle | 21039 | 1198 | 20 | 0 | 36.85372876 | -88.9669222 | 2022-08-22 04:20:38 | Carlisle, Kentucky, US | |
3799297 | 3799297 | 2022-08-20 | US | Kentucky | Carlisle | 21039 | 1198 | 20 | 0 | 36.85372876 | -88.9669222 | 2022-08-21 04:20:44 | Carlisle, Kentucky, US | |
2364883 | 2364883 | 2022-08-19 | US | Kentucky | Carlisle | 21039 | 1198 | 20 | 0 | 36.85372876 | -88.9669222 | 2022-08-20 04:21:01 | Carlisle, Kentucky, US | |
1162554 | 1162554 | 2022-08-18 | US | Kentucky | Carlisle | 21039 | 1198 | 20 | 0 | 36.85372876 | -88.9669222 | 2022-08-19 04:20:54 | Carlisle, Kentucky, US | |
3954038 | 3954038 | 2022-08-17 | US | Wisconsin | Florence | 55037 | 1198 | 17 | 0 | 45.84963535 | -88.39804137 | 2022-08-18 04:21:11 | Florence, Wisconsin, US | |
3951878 | 3951878 | 2022-08-17 | US | Kentucky | Carlisle | 21039 | 1198 | 20 | 0 | 36.85372876 | -88.9669222 | 2022-08-18 04:21:11 | Carlisle, Kentucky, US | |
992380 | 992380 | 2022-08-16 | US | Kentucky | Carlisle | 21039 | 1198 | 20 | 0 | 36.85372876 | -88.9669222 | 2022-08-17 04:20:59 | Carlisle, Kentucky, US | |
991409 | 991409 | 2022-08-16 | US | Alaska | Aleutians East | 2013 | 1198 | 3 | 0 | 55.32222414 | -161.9722021 | 2022-08-17 04:20:59 | Aleutians East, Alaska, US | |
2497067 | 2497067 | 2022-08-15 | US | Texas | Brewster | 48043 | 1198 | 32 | 0 | 29.81008251 | -103.2520326 | 2022-08-16 04:20:58 | Brewster, Texas, US | |
2495419 | 2495419 | 2022-08-15 | US | Kentucky | Carlisle | 21039 | 1198 | 20 | 0 | 36.85372876 | -88.9669222 | 2022-08-16 04:20:58 | Carlisle, Kentucky, US | |
2494448 | 2494448 | 2022-08-15 | US | Alaska | Aleutians East | 2013 | 1198 | 3 | 0 | 55.32222414 | -161.9722021 | 2022-08-16 04:20:58 | Aleutians East, Alaska, US | |
3647998 | 3647998 | 2022-08-14 | US | Alaska | Aleutians East | 2013 | 1198 | 3 | 0 | 55.32222414 | -161.9722021 | 2022-08-15 04:20:59 | Aleutians East, Alaska, US | |
1971351 | 1971351 | 2022-08-13 | US | Puerto Rico | Maricao | 72093 | 1198 | 0 | 0 | 18.171795 | -66.942126 | 2022-08-14 04:20:55 | Maricao, Puerto Rico, US | |
1969004 | 1969004 | 2022-08-13 | US | Alaska | Aleutians East | 2013 | 1198 | 3 | 0 | 55.32222414 | -161.9722021 | 2022-08-14 04:20:55 | Aleutians East, Alaska, US | |
2888813 | 2888813 | 2022-08-12 | US | Alaska | Aleutians East | 2013 | 1198 | 3 | 0 | 55.32222414 | -161.9722021 | 2022-08-13 04:20:52 | Aleutians East, Alaska, US | |
3908418 | 3908418 | 2022-08-11 | US | Alaska | Aleutians East | 2013 | 1198 | 3 | 0 | 55.32222414 | -161.9722021 | 2022-08-12 04:20:54 | Aleutians East, Alaska, US | |
1346735 | 1346735 | 2022-08-10 | US | Alaska | Aleutians East | 2013 | 1198 | 3 | 0 | 55.32222414 | -161.9722021 | 2022-08-11 04:20:49 | Aleutians East, Alaska, US | |
1088273 | 1088273 | 2022-08-09 | US | New Mexico | Guadalupe | 35019 | 1198 | 17 | 0 | 34.86319296 | -104.790669 | 2022-08-10 04:20:57 | Guadalupe, New Mexico, US | |
1088179 | 1088179 | 2022-08-09 | US | Nebraska | Morrill | 31123 | 1198 | 20 | 0 | 41.71711774 | -103.0061405 | 2022-08-10 04:20:57 | Morrill, Nebraska, US | |
3545594 | 3545594 | 2022-08-08 | US | Nebraska | Morrill | 31123 | 1198 | 20 | 0 | 41.71711774 | -103.0061405 | 2022-08-09 04:20:34 | Morrill, Nebraska, US | |
3620158 | 3620158 | 2022-08-01 | US | Texas | Donley | 48129 | 1198 | 26 | 0 | 34.96517499 | -100.8140093 | 2022-08-02 04:20:53 | Donley, Texas, US | |
3874638 | 3874638 | 2022-07-31 | US | Texas | Donley | 48129 | 1198 | 26 | 0 | 34.96517499 | -100.8140093 | 2022-08-01 04:21:03 | Donley, Texas, US | |
677392 | 677392 | 2022-07-30 | US | Texas | Donley | 48129 | 1198 | 26 | 0 | 34.96517499 | -100.8140093 | 2022-07-31 04:21:02 | Donley, Texas, US | |
1786591 | 1786591 | 2022-07-29 | US | Texas | Donley | 48129 | 1198 | 26 | 0 | 34.96517499 | -100.8140093 | 2022-07-30 04:20:42 | Donley, Texas, US | |
1068954 | 1068954 | 2022-07-28 | US | Texas | Donley | 48129 | 1198 | 26 | 0 | 34.96517499 | -100.8140093 | 2022-07-29 04:20:45 | Donley, Texas, US | |
3968695 | 3968695 | 2022-07-05 | US | Nevada | Lander | 32015 | 1198 | 21 | 0 | 39.9332233 | -117.0397075 | 2022-07-06 04:20:58 | Lander, Nevada, US | |
3080206 | 3080206 | 2022-07-04 | US | Nevada | Lander | 32015 | 1198 | 21 | 0 | 39.9332233 | -117.0397075 | 2022-07-05 04:20:45 | Lander, Nevada, US | |
1769488 | 1769488 | 2022-07-03 | US | Nevada | Lander | 32015 | 1198 | 21 | 0 | 39.9332233 | -117.0397075 | 2022-07-04 04:20:54 | Lander, Nevada, US | |
3367474 | 3367474 | 2022-07-02 | US | Nevada | Lander | 32015 | 1198 | 21 | 0 | 39.9332233 | -117.0397075 | 2022-07-03 04:20:59 | Lander, Nevada, US | |
595803 | 595803 | 2022-07-01 | US | Nevada | Lander | 32015 | 1198 | 21 | 0 | 39.9332233 | -117.0397075 | 2022-07-02 04:21:16 | Lander, Nevada, US | |
3943423 | 3943423 | 2022-06-30 | US | Virginia | King and Queen | 51097 | 1198 | 12 | 0 | 37.71044922 | -76.88689628 | 2022-07-01 04:21:10 | King and Queen, Virginia, US | |
3942204 | 3942204 | 2022-06-30 | US | Nevada | Lander | 32015 | 1198 | 21 | 0 | 39.9332233 | -117.0397075 | 2022-07-01 04:21:10 | Lander, Nevada, US | |
2492162 | 2492162 | 2022-06-29 | US | Nevada | Lander | 32015 | 1198 | 21 | 0 | 39.9332233 | -117.0397075 | 2022-06-30 04:21:01 | Lander, Nevada, US | |
1853310 | 1853310 | 2022-05-26 | US | Virginia | Charles City | 51036 | 1198 | 27 | 0 | 37.35358063 | -77.05634116 | 2022-05-27 04:20:56 | Charles City, Virginia, US | |
3002624 | 3002624 | 2022-05-24 | US | Virginia | Charles City | 51036 | 1198 | 27 | 0 | 37.35358063 | -77.05634116 | 2022-05-25 04:20:56 | Charles City, Virginia, US | |
2599546 | 2599546 | 2022-05-05 | US | Louisiana | Cameron | 22023 | 1198 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-05-06 04:21:00 | Cameron, Louisiana, US | |
3266995 | 3266995 | 2022-05-04 | US | Louisiana | Cameron | 22023 | 1198 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-05-05 04:20:55 | Cameron, Louisiana, US | |
1573634 | 1573634 | 2022-05-03 | US | Louisiana | Cameron | 22023 | 1198 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-05-04 04:20:59 | Cameron, Louisiana, US | |
464894 | 464894 | 2022-05-02 | US | Louisiana | Cameron | 22023 | 1198 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-05-03 04:21:00 | Cameron, Louisiana, US | |
3917533 | 3917533 | 2022-05-01 | US | Louisiana | Cameron | 22023 | 1198 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-05-02 04:21:10 | Cameron, Louisiana, US | |
2842337 | 2842337 | 2022-04-30 | US | Louisiana | Cameron | 22023 | 1198 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-05-01 04:20:57 | Cameron, Louisiana, US | |
1158650 | 1158650 | 2022-04-29 | US | Louisiana | Cameron | 22023 | 1198 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-04-30 04:21:05 | Cameron, Louisiana, US | |
1697832 | 1697832 | 2022-04-28 | US | Louisiana | Cameron | 22023 | 1198 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-04-29 04:20:59 | Cameron, Louisiana, US | |
3853315 | 3853315 | 2022-04-27 | US | Louisiana | Cameron | 22023 | 1198 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-04-28 04:20:47 | Cameron, Louisiana, US | |
1327745 | 1327745 | 2022-04-26 | US | Louisiana | Cameron | 22023 | 1198 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-04-27 04:20:52 | Cameron, Louisiana, US | |
3723699 | 3723699 | 2022-04-25 | US | Louisiana | Cameron | 22023 | 1198 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-04-26 04:20:51 | Cameron, Louisiana, US | |
2030267 | 2030267 | 2022-04-24 | US | Louisiana | Cameron | 22023 | 1198 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-04-25 04:20:56 | Cameron, Louisiana, US | |
2028569 | 2028569 | 2022-04-24 | China | Jiangxi | 1198 | 1 | 0 | 27.614 | 115.7221 | 2022-04-25 04:20:56 | Jiangxi, China | |||
747842 | 747842 | 2022-04-23 | US | Louisiana | Cameron | 22023 | 1198 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-04-24 04:20:56 | Cameron, Louisiana, US | |
3438327 | 3438327 | 2022-04-22 | US | Louisiana | Cameron | 22023 | 1198 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-04-23 04:20:50 | Cameron, Louisiana, US | |
2893912 | 2893912 | 2022-04-21 | US | Louisiana | Cameron | 22023 | 1198 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-04-22 04:20:45 | Cameron, Louisiana, US | |
2308784 | 2308784 | 2022-04-20 | US | Louisiana | Cameron | 22023 | 1198 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-04-21 04:20:46 | Cameron, Louisiana, US | |
2252923 | 2252923 | 2022-04-19 | US | Louisiana | Cameron | 22023 | 1198 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-04-20 04:20:45 | Cameron, Louisiana, US | |
1847473 | 1847473 | 2022-04-18 | US | Louisiana | Cameron | 22023 | 1198 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-04-19 04:21:00 | Cameron, Louisiana, US | |
3418417 | 3418417 | 2022-04-17 | US | Louisiana | Cameron | 22023 | 1198 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-04-18 04:21:12 | Cameron, Louisiana, US | |
305366 | 305366 | 2022-04-16 | US | Louisiana | Cameron | 22023 | 1198 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-04-17 04:20:59 | Cameron, Louisiana, US | |
2671311 | 2671311 | 2022-04-15 | US | Louisiana | Cameron | 22023 | 1198 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-04-16 04:20:48 | Cameron, Louisiana, US | |
1225096 | 1225096 | 2022-04-14 | US | Louisiana | Cameron | 22023 | 1198 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-04-15 04:20:57 | Cameron, Louisiana, US | |
2444254 | 2444254 | 2022-04-13 | US | Louisiana | Cameron | 22023 | 1198 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-04-13 23:21:06 | Cameron, Louisiana, US | |
1950011 | 1950011 | 2022-04-12 | US | Louisiana | Cameron | 22023 | 1198 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-04-13 04:21:03 | Cameron, Louisiana, US | |
3207764 | 3207764 | 2022-04-11 | US | Louisiana | Cameron | 22023 | 1198 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-04-12 04:20:49 | Cameron, Louisiana, US | |
1577650 | 1577650 | 2022-04-10 | US | Louisiana | Cameron | 22023 | 1198 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-04-11 04:21:02 | Cameron, Louisiana, US | |
1653892 | 1653892 | 2022-04-09 | US | Louisiana | Cameron | 22023 | 1198 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-04-10 04:20:52 | Cameron, Louisiana, US | |
2117214 | 2117214 | 2022-04-08 | US | Louisiana | Cameron | 22023 | 1198 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-04-09 04:20:42 | Cameron, Louisiana, US | |
3321738 | 3321738 | 2022-04-07 | US | Louisiana | Cameron | 22023 | 1198 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-04-08 04:20:48 | Cameron, Louisiana, US | |
2802274 | 2802274 | 2022-04-06 | US | Louisiana | Cameron | 22023 | 1198 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-04-07 04:20:53 | Cameron, Louisiana, US | |
3870644 | 3870644 | 2022-04-05 | US | Texas | Goliad | 48175 | 1198 | 32 | 0 | 28.65696592 | -97.42760647 | 2022-04-06 04:20:49 | Goliad, Texas, US | |
3869043 | 3869043 | 2022-04-05 | US | Louisiana | Cameron | 22023 | 1198 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-04-06 04:20:49 | Cameron, Louisiana, US | |
2750385 | 2750385 | 2022-04-04 | US | Louisiana | Cameron | 22023 | 1198 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-04-05 04:20:48 | Cameron, Louisiana, US | |
3731731 | 3731731 | 2022-04-03 | US | Louisiana | Cameron | 22023 | 1198 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-04-04 04:20:51 | Cameron, Louisiana, US | |
501166 | 501166 | 2022-04-02 | US | Louisiana | Cameron | 22023 | 1198 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-04-03 04:20:48 | Cameron, Louisiana, US | |
3352151 | 3352151 | 2022-04-01 | US | Louisiana | Cameron | 22023 | 1198 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-04-02 04:20:47 | Cameron, Louisiana, US | |
1541456 | 1541456 | 2022-03-31 | US | Louisiana | Cameron | 22023 | 1198 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-04-01 04:20:28 | Cameron, Louisiana, US | |
2479469 | 2479469 | 2022-03-30 | US | Louisiana | Cameron | 22023 | 1198 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-03-31 04:20:56 | Cameron, Louisiana, US | |
159510 | 159510 | 2022-03-29 | US | Louisiana | Cameron | 22023 | 1198 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-03-30 04:20:45 | Cameron, Louisiana, US | |
1438081 | 1438081 | 2022-03-28 | US | Louisiana | Cameron | 22023 | 1198 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-03-29 04:20:46 | Cameron, Louisiana, US | |
877762 | 877762 | 2022-03-27 | US | Louisiana | Cameron | 22023 | 1198 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-03-28 04:20:33 | Cameron, Louisiana, US | |
2165045 | 2165045 | 2022-03-26 | US | Louisiana | Cameron | 22023 | 1198 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-03-27 04:20:47 | Cameron, Louisiana, US | |
1721981 | 1721981 | 2022-03-25 | US | Louisiana | Cameron | 22023 | 1198 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-03-26 04:20:23 | Cameron, Louisiana, US | |
1469598 | 1469598 | 2022-03-24 | US | Louisiana | Cameron | 22023 | 1198 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-03-25 04:20:46 | Cameron, Louisiana, US | |
3023772 | 3023772 | 2022-03-23 | US | Louisiana | Cameron | 22023 | 1198 | 8 | 0 | 29.87592238 | -93.19310676 | 2022-03-24 04:20:43 | Cameron, Louisiana, 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]);