johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
153 rows where confirmed = 5367 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 8
- US 145
- Djibouti 2
- Canada 1
- Japan 1
- New Zealand 1
- Pakistan 1
- Russia 1
- United Kingdom 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2180089 | 2180089 | 2022-12-22 | US | Arkansas | Lincoln | 5079 | 5367 | 70 | 0 | 33.95317155 | -91.74002806 | 2022-12-23 04:21:04 | Lincoln, Arkansas, US | |
488108 | 488108 | 2022-11-25 | US | Arkansas | Drew | 5043 | 5367 | 79 | 0 | 33.59035001 | -91.71777921 | 2022-11-26 04:21:11 | Drew, Arkansas, US | |
3523937 | 3523937 | 2022-11-24 | US | Arkansas | Drew | 5043 | 5367 | 79 | 0 | 33.59035001 | -91.71777921 | 2022-11-25 04:21:06 | Drew, Arkansas, US | |
3312720 | 3312720 | 2022-11-23 | US | Arkansas | Drew | 5043 | 5367 | 79 | 0 | 33.59035001 | -91.71777921 | 2022-11-24 04:21:09 | Drew, Arkansas, US | |
1620761 | 1620761 | 2022-11-22 | US | Arkansas | Drew | 5043 | 5367 | 79 | 0 | 33.59035001 | -91.71777921 | 2022-11-23 04:21:06 | Drew, Arkansas, US | |
3041838 | 3041838 | 2022-10-27 | US | West Virginia | Monroe | 54063 | 5367 | 49 | 0 | 37.56274716 | -80.54577965 | 2022-10-28 04:22:31 | Monroe, West Virginia, US | |
1832276 | 1832276 | 2022-10-25 | US | Nebraska | Saunders | 31155 | 5367 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-10-26 04:22:19 | Saunders, Nebraska, US | |
796537 | 796537 | 2022-10-24 | US | Nebraska | Saunders | 31155 | 5367 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-10-25 04:21:53 | Saunders, Nebraska, US | |
3278992 | 3278992 | 2022-10-23 | US | Nebraska | Saunders | 31155 | 5367 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-10-24 04:22:29 | Saunders, Nebraska, US | |
2270030 | 2270030 | 2022-10-22 | US | Nebraska | Saunders | 31155 | 5367 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-10-23 04:22:46 | Saunders, Nebraska, US | |
1594330 | 1594330 | 2022-10-21 | US | Nebraska | Saunders | 31155 | 5367 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-10-22 04:22:53 | Saunders, Nebraska, US | |
2274046 | 2274046 | 2022-10-20 | US | Nebraska | Saunders | 31155 | 5367 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-10-21 04:22:23 | Saunders, Nebraska, US | |
200381 | 200381 | 2022-10-19 | US | Nebraska | Saunders | 31155 | 5367 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-10-20 04:22:59 | Saunders, Nebraska, US | |
2759659 | 2759659 | 2022-10-18 | US | Puerto Rico | Comerio | 72045 | 5367 | 0 | 0 | 18.224687 | -66.221622 | 2022-10-19 04:22:26 | Comerio, Puerto Rico, US | |
2759042 | 2759042 | 2022-10-18 | US | Nebraska | Saunders | 31155 | 5367 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-10-19 04:22:26 | Saunders, Nebraska, US | |
2027493 | 2027493 | 2022-10-17 | US | Puerto Rico | Comerio | 72045 | 5367 | 0 | 0 | 18.224687 | -66.221622 | 2022-10-18 04:22:42 | Comerio, Puerto Rico, US | |
2026876 | 2026876 | 2022-10-17 | US | Nebraska | Saunders | 31155 | 5367 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-10-18 04:22:42 | Saunders, Nebraska, US | |
2161654 | 2161654 | 2022-10-16 | US | Nebraska | Saunders | 31155 | 5367 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-10-17 04:20:31 | Saunders, Nebraska, US | |
517851 | 517851 | 2022-10-15 | US | Nebraska | Saunders | 31155 | 5367 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-10-16 04:22:39 | Saunders, Nebraska, US | |
2034908 | 2034908 | 2022-10-14 | US | Nebraska | Saunders | 31155 | 5367 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-10-15 04:22:00 | Saunders, Nebraska, US | |
3755596 | 3755596 | 2022-10-13 | US | Nebraska | Saunders | 31155 | 5367 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-10-14 04:22:28 | Saunders, Nebraska, US | |
3216421 | 3216421 | 2022-10-12 | US | Nebraska | Saunders | 31155 | 5367 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-10-13 04:22:39 | Saunders, Nebraska, US | |
3252270 | 3252270 | 2022-10-11 | US | Nebraska | Saunders | 31155 | 5367 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-10-12 04:22:51 | Saunders, Nebraska, US | |
2969529 | 2969529 | 2022-10-10 | US | Nebraska | Saunders | 31155 | 5367 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-10-11 04:23:05 | Saunders, Nebraska, US | |
2969055 | 2969055 | 2022-10-10 | US | Michigan | Iosco | 26069 | 5367 | 158 | 0 | 44.35486835 | -83.63484895 | 2022-10-11 04:23:05 | Iosco, Michigan, US | |
3099565 | 3099565 | 2022-10-09 | US | Nebraska | Saunders | 31155 | 5367 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-10-10 04:22:32 | Saunders, Nebraska, US | |
3099091 | 3099091 | 2022-10-09 | US | Michigan | Iosco | 26069 | 5367 | 158 | 0 | 44.35486835 | -83.63484895 | 2022-10-10 04:22:32 | Iosco, Michigan, US | |
4004790 | 4004790 | 2022-10-08 | US | Nebraska | Saunders | 31155 | 5367 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-10-09 04:21:16 | Saunders, Nebraska, US | |
4004316 | 4004316 | 2022-10-08 | US | Michigan | Iosco | 26069 | 5367 | 158 | 0 | 44.35486835 | -83.63484895 | 2022-10-09 04:21:16 | Iosco, Michigan, US | |
398387 | 398387 | 2022-10-07 | US | Nebraska | Saunders | 31155 | 5367 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-10-08 04:22:56 | Saunders, Nebraska, US | |
397913 | 397913 | 2022-10-07 | US | Michigan | Iosco | 26069 | 5367 | 158 | 0 | 44.35486835 | -83.63484895 | 2022-10-08 04:22:56 | Iosco, Michigan, US | |
2531504 | 2531504 | 2022-10-06 | US | Nebraska | Saunders | 31155 | 5367 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-10-07 04:23:08 | Saunders, Nebraska, US | |
2531030 | 2531030 | 2022-10-06 | US | Michigan | Iosco | 26069 | 5367 | 158 | 0 | 44.35486835 | -83.63484895 | 2022-10-07 04:23:08 | Iosco, Michigan, US | |
1812898 | 1812898 | 2022-10-05 | US | Nebraska | Saunders | 31155 | 5367 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-10-06 04:21:22 | Saunders, Nebraska, US | |
1812424 | 1812424 | 2022-10-05 | US | Michigan | Iosco | 26069 | 5367 | 158 | 0 | 44.35486835 | -83.63484895 | 2022-10-06 04:21:22 | Iosco, Michigan, US | |
132872 | 132872 | 2022-10-04 | US | Nebraska | Saunders | 31155 | 5367 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-10-05 04:23:06 | Saunders, Nebraska, US | |
132398 | 132398 | 2022-10-04 | US | Michigan | Iosco | 26069 | 5367 | 158 | 0 | 44.35486835 | -83.63484895 | 2022-10-05 04:23:06 | Iosco, Michigan, US | |
2687819 | 2687819 | 2022-10-03 | US | Nebraska | Saunders | 31155 | 5367 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-10-04 04:22:55 | Saunders, Nebraska, US | |
2261886 | 2261886 | 2022-10-02 | US | Nebraska | Saunders | 31155 | 5367 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-10-03 04:23:11 | Saunders, Nebraska, US | |
2997412 | 2997412 | 2022-10-01 | US | Nebraska | Saunders | 31155 | 5367 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-10-02 04:21:23 | Saunders, Nebraska, US | |
855738 | 855738 | 2022-09-30 | US | Nebraska | Saunders | 31155 | 5367 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-10-01 04:23:01 | Saunders, Nebraska, US | |
2377664 | 2377664 | 2022-09-29 | US | Nebraska | Saunders | 31155 | 5367 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-09-30 04:23:09 | Saunders, Nebraska, US | |
1562215 | 1562215 | 2022-09-28 | US | Nebraska | Saunders | 31155 | 5367 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-09-29 04:22:34 | Saunders, Nebraska, US | |
3996758 | 3996758 | 2022-09-27 | US | Nebraska | Saunders | 31155 | 5367 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-09-28 04:23:01 | Saunders, Nebraska, US | |
2771086 | 2771086 | 2022-09-26 | US | Nebraska | Saunders | 31155 | 5367 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-09-27 04:23:01 | Saunders, Nebraska, US | |
1978739 | 1978739 | 2022-09-25 | US | Nebraska | Saunders | 31155 | 5367 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-09-26 04:20:52 | Saunders, Nebraska, US | |
2651906 | 2651906 | 2022-09-24 | US | Nebraska | Saunders | 31155 | 5367 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-09-25 04:23:31 | Saunders, Nebraska, US | |
386346 | 386346 | 2022-09-23 | US | Nebraska | Saunders | 31155 | 5367 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-09-24 04:21:40 | Saunders, Nebraska, US | |
1626412 | 1626412 | 2022-09-22 | US | Nebraska | Saunders | 31155 | 5367 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-09-23 04:23:13 | Saunders, Nebraska, US | |
1372616 | 1372616 | 2022-09-21 | US | Nebraska | Saunders | 31155 | 5367 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-09-22 04:22:56 | Saunders, Nebraska, US | |
2018846 | 2018846 | 2022-09-20 | US | Nebraska | Saunders | 31155 | 5367 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-09-21 04:23:22 | Saunders, Nebraska, US | |
3572719 | 3572719 | 2022-09-19 | US | Nebraska | Saunders | 31155 | 5367 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-09-20 04:22:48 | Saunders, Nebraska, US | |
422866 | 422866 | 2022-09-18 | US | Wisconsin | Adams | 55001 | 5367 | 65 | 0 | 43.96974651 | -89.76782777 | 2022-09-19 04:21:49 | Adams, Wisconsin, US | |
421458 | 421458 | 2022-09-18 | US | Nebraska | Saunders | 31155 | 5367 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-09-19 04:21:49 | Saunders, Nebraska, US | |
3376890 | 3376890 | 2022-09-17 | US | Wisconsin | Adams | 55001 | 5367 | 65 | 0 | 43.96974651 | -89.76782777 | 2022-09-18 04:22:50 | Adams, Wisconsin, US | |
3375482 | 3375482 | 2022-09-17 | US | Nebraska | Saunders | 31155 | 5367 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-09-18 04:22:50 | Saunders, Nebraska, US | |
2358998 | 2358998 | 2022-09-16 | US | Wisconsin | Adams | 55001 | 5367 | 65 | 0 | 43.96974651 | -89.76782777 | 2022-09-17 04:20:19 | Adams, Wisconsin, US | |
2357590 | 2357590 | 2022-09-16 | US | Nebraska | Saunders | 31155 | 5367 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-09-17 04:20:19 | Saunders, Nebraska, US | |
3988747 | 3988747 | 2022-09-15 | US | Nebraska | Saunders | 31155 | 5367 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-09-16 04:21:19 | Saunders, Nebraska, US | |
1891264 | 1891264 | 2022-09-14 | US | Nebraska | Saunders | 31155 | 5367 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-09-15 04:21:02 | Saunders, Nebraska, US | |
374319 | 374319 | 2022-09-13 | US | Nebraska | Saunders | 31155 | 5367 | 30 | 0 | 41.2278103 | -96.63773905 | 2022-09-14 04:20:44 | Saunders, Nebraska, US | |
2636795 | 2636795 | 2022-09-05 | US | Texas | Deaf Smith | 48117 | 5367 | 115 | 0 | 34.96522957 | -102.6054267 | 2022-09-06 04:21:02 | Deaf Smith, Texas, US | |
2990359 | 2990359 | 2022-09-04 | US | Texas | Deaf Smith | 48117 | 5367 | 115 | 0 | 34.96522957 | -102.6054267 | 2022-09-05 04:21:01 | Deaf Smith, Texas, US | |
2716044 | 2716044 | 2022-09-03 | US | Texas | Deaf Smith | 48117 | 5367 | 115 | 0 | 34.96522957 | -102.6054267 | 2022-09-04 04:21:22 | Deaf Smith, Texas, US | |
1396749 | 1396749 | 2022-09-02 | US | Texas | Deaf Smith | 48117 | 5367 | 115 | 0 | 34.96522957 | -102.6054267 | 2022-09-03 04:21:04 | Deaf Smith, Texas, US | |
2831598 | 2831598 | 2022-08-25 | US | Puerto Rico | Santa Isabel | 72133 | 5367 | 0 | 0 | 17.994525 | -66.388913 | 2022-08-26 04:21:02 | Santa Isabel, Puerto Rico, US | |
2406214 | 2406214 | 2022-08-21 | US | Virginia | New Kent | 51127 | 5367 | 38 | 0 | 37.50694406 | -76.99828634 | 2022-08-22 04:20:38 | New Kent, Virginia, US | |
3801292 | 3801292 | 2022-08-20 | US | Virginia | New Kent | 51127 | 5367 | 38 | 0 | 37.50694406 | -76.99828634 | 2022-08-21 04:20:44 | New Kent, Virginia, US | |
2366878 | 2366878 | 2022-08-19 | US | Virginia | New Kent | 51127 | 5367 | 38 | 0 | 37.50694406 | -76.99828634 | 2022-08-20 04:21:01 | New Kent, Virginia, US | |
2597070 | 2597070 | 2022-07-25 | US | Texas | Burleson | 48051 | 5367 | 67 | 0 | 30.49273808 | -96.62158484 | 2022-07-26 04:20:58 | Burleson, Texas, US | |
1611421 | 1611421 | 2022-07-20 | US | Texas | Limestone | 48293 | 5367 | 124 | 0 | 31.5454767 | -96.58095444 | 2022-07-21 04:21:10 | Limestone, Texas, US | |
631410 | 631410 | 2022-07-12 | US | Louisiana | Concordia | 22029 | 5367 | 89 | 0 | 31.44817835 | -91.63814433 | 2022-07-13 04:20:58 | Concordia, Louisiana, US | |
630260 | 630260 | 2022-07-12 | US | Alabama | Butler | 1013 | 5367 | 129 | 0 | 31.75300095 | -86.68057478 | 2022-07-13 04:20:58 | Butler, Alabama, US | |
1420048 | 1420048 | 2022-07-08 | US | Tennessee | Johnson | 47091 | 5367 | 95 | 0 | 36.4552395 | -81.84886538 | 2022-07-09 04:20:59 | Johnson, Tennessee, US | |
2493020 | 2493020 | 2022-06-29 | US | Tennessee | Unicoi | 47171 | 5367 | 97 | 0 | 36.10890856 | -82.43709629 | 2022-06-30 04:21:01 | Unicoi, Tennessee, US | |
3729612 | 3729612 | 2022-06-07 | US | Virginia | Powhatan | 51145 | 5367 | 59 | 0 | 37.55016038 | -77.91267882 | 2022-06-08 04:20:55 | Powhatan, Virginia, US | |
3198641 | 3198641 | 2022-05-29 | US | Arkansas | Lawrence | 5075 | 5367 | 81 | 0 | 36.04188196 | -91.10867198 | 2022-05-30 04:20:50 | Lawrence, Arkansas, US | |
3444979 | 3444979 | 2022-05-11 | New Zealand | Cook Islands | 5367 | 1 | 0 | -21.2367 | -159.7777 | 2022-05-12 04:20:54 | Cook Islands, New Zealand | |||
1573701 | 1573701 | 2022-05-03 | US | Maine | Sagadahoc | 23023 | 5367 | 32 | 0 | 43.95415864 | -69.85074999 | 2022-05-04 04:20:59 | Sagadahoc, Maine, US | |
3855148 | 3855148 | 2022-04-27 | US | Virginia | Dinwiddie | 51053 | 5367 | 91 | 0 | 37.07544585 | -77.63451754 | 2022-04-28 04:20:47 | Dinwiddie, Virginia, US | |
2803873 | 2803873 | 2022-04-06 | US | Texas | Gillespie | 48171 | 5367 | 109 | 0 | 30.31824095 | -98.94676915 | 2022-04-07 04:20:53 | Gillespie, Texas, US | |
3732964 | 3732964 | 2022-04-03 | US | Puerto Rico | Cayey | 72035 | 5367 | 0 | 0 | 18.102851 | -66.14914 | 2022-04-04 04:20:51 | Cayey, Puerto Rico, US | |
1541012 | 1541012 | 2022-03-31 | US | Illinois | Union | 17181 | 5367 | 64 | 0 | 37.47119609 | -89.25548938 | 2022-04-01 04:20:28 | Union, Illinois, US | |
2479025 | 2479025 | 2022-03-30 | US | Illinois | Union | 17181 | 5367 | 64 | 0 | 37.47119609 | -89.25548938 | 2022-03-31 04:20:56 | Union, Illinois, US | |
3241087 | 3241087 | 2022-03-21 | US | Puerto Rico | Manati | 72091 | 5367 | 0 | 0 | 18.420473 | -66.490461 | 2022-03-22 04:20:54 | Manati, Puerto Rico, US | |
27160 | 27160 | 2022-03-20 | US | Puerto Rico | Manati | 72091 | 5367 | 0 | 0 | 18.420473 | -66.490461 | 2022-03-21 04:20:50 | Manati, Puerto Rico, US | |
2141261 | 2141261 | 2022-03-09 | US | Indiana | Fountain | 18045 | 5367 | 94 | 0 | 40.12361933 | -87.24217689 | 2022-03-10 04:20:48 | Fountain, Indiana, US | |
921579 | 921579 | 2022-03-08 | US | Missouri | Crawford | 29055 | 5367 | 97 | 0 | 37.97663738 | -91.30528104 | 2022-03-09 04:20:59 | Crawford, Missouri, US | |
920772 | 920772 | 2022-03-08 | US | Indiana | Fountain | 18045 | 5367 | 93 | 0 | 40.12361933 | -87.24217689 | 2022-03-09 04:20:59 | Fountain, Indiana, US | |
1513258 | 1513258 | 2022-02-24 | US | Mississippi | Stone | 28131 | 5367 | 70 | 0 | 30.79187949 | -89.11547539 | 2022-02-25 04:21:11 | Stone, Mississippi, US | |
2447590 | 2447590 | 2022-02-22 | US | Georgia | Haralson | 13143 | 5367 | 157 | 0 | 33.79602175 | -85.21005667 | 2022-02-23 04:21:09 | Haralson, Georgia, US | |
3878329 | 3878329 | 2022-02-19 | US | Puerto Rico | Juana Diaz | 72075 | 5367 | 0 | 0 | 18.050764 | -66.49458100000001 | 2022-02-20 04:21:00 | Juana Diaz, Puerto Rico, US | |
2475536 | 2475536 | 2022-02-03 | US | Maryland | Garrett | 24023 | 5367 | 109 | 0 | 39.52786077 | -79.27355126 | 2022-02-04 04:21:10 | Garrett, Maryland, US | |
3841008 | 3841008 | 2022-01-15 | US | Arkansas | Johnson | 5071 | 5367 | 65 | 0 | 35.56759135 | -93.46036368 | 2022-01-16 04:21:12 | Johnson, Arkansas, US | |
3688929 | 3688929 | 2022-01-13 | US | Kentucky | Mercer | 21167 | 5367 | 95 | 0 | 37.81474237 | -84.87488475 | 2022-01-14 04:21:54 | Mercer, Kentucky, US | |
2611331 | 2611331 | 2022-01-06 | US | Kansas | Ellis | 20051 | 5367 | 77 | 0 | 38.91458712 | -99.31751551 | 2022-01-07 04:22:09 | Ellis, Kansas, US | |
1283273 | 1283273 | 2022-01-05 | US | Kansas | Ellis | 20051 | 5367 | 77 | 0 | 38.91458712 | -99.31751551 | 2022-01-06 04:22:09 | Ellis, Kansas, US | |
406842 | 406842 | 2021-12-07 | US | Oklahoma | Custer | 40039 | 5367 | 129 | 0 | 35.63853802 | -99.00170785 | 2021-12-08 04:22:46 | Custer, Oklahoma, US | |
1032924 | 1032924 | 2021-12-06 | US | Oklahoma | Custer | 40039 | 5367 | 129 | 0 | 35.63853802 | -99.00170785 | 2021-12-07 04:22:34 | Custer, Oklahoma, US | |
1743087 | 1743087 | 2021-12-05 | US | Oklahoma | Custer | 40039 | 5367 | 129 | 0 | 35.63853802 | -99.00170785 | 2021-12-06 04:22:34 | Custer, Oklahoma, 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]);