johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
480 rows where deaths = 586 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 331
- Russia 18
- Sweden 14
- Chile 13
- Netherlands 13
- Canada 12
- Haiti 8
- Japan 8
- Belize 7
- Spain 7
- India 5
- Ukraine 5
- Yemen 5
- Colombia 4
- Italy 3
- Pakistan 2
- Papua New Guinea 2
- Peru 2
- Azerbaijan 1
- Bahamas 1
- Brazil 1
- Bulgaria 1
- China 1
- Cote d'Ivoire 1
- Denmark 1
- Finland 1
- Germany 1
- Hungary 1
- Jamaica 1
- Kosovo 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1630530 | 1630530 | 2022-12-18 | US | New York | Albany | 36001 | 76334 | 586 | 0 | 42.60060306 | -73.97723916 | 2022-12-19 04:21:03 | Albany, New York, US | |
505909 | 505909 | 2022-12-17 | US | New York | Albany | 36001 | 76302 | 586 | 0 | 42.60060306 | -73.97723916 | 2022-12-18 04:21:03 | Albany, New York, US | |
3326481 | 3326481 | 2022-12-16 | US | New York | Albany | 36001 | 76273 | 586 | 0 | 42.60060306 | -73.97723916 | 2022-12-17 04:21:04 | Albany, New York, US | |
544993 | 544993 | 2022-12-15 | US | New York | Albany | 36001 | 76231 | 586 | 0 | 42.60060306 | -73.97723916 | 2022-12-16 04:21:01 | Albany, New York, US | |
350521 | 350521 | 2022-12-14 | US | New York | Albany | 36001 | 76182 | 586 | 0 | 42.60060306 | -73.97723916 | 2022-12-15 04:20:58 | Albany, New York, US | |
310109 | 310109 | 2022-12-13 | US | New York | Albany | 36001 | 76132 | 586 | 0 | 42.60060306 | -73.97723916 | 2022-12-14 04:21:04 | Albany, New York, US | |
2414881 | 2414881 | 2022-12-05 | Japan | Mie | 308040 | 586 | 0 | 34.508018 | 136.376013 | 2022-12-06 04:21:03 | Mie, Japan | |||
295555 | 295555 | 2022-11-15 | US | Wisconsin | Dane | 55025 | 170167 | 586 | 0 | 43.06601594 | -89.41733797 | 2022-11-16 04:21:09 | Dane, Wisconsin, US | |
3600585 | 3600585 | 2022-11-14 | US | Wisconsin | Dane | 55025 | 170117 | 586 | 0 | 43.06601594 | -89.41733797 | 2022-11-15 04:21:16 | Dane, Wisconsin, US | |
3597462 | 3597462 | 2022-11-14 | US | Alaska | Anchorage | 2020 | 121227 | 586 | 0 | 61.14998174 | -149.1426986 | 2022-11-15 04:21:16 | Anchorage, Alaska, US | |
315443 | 315443 | 2022-11-13 | US | Wisconsin | Dane | 55025 | 169914 | 586 | 0 | 43.06601594 | -89.41733797 | 2022-11-14 04:21:09 | Dane, Wisconsin, US | |
312320 | 312320 | 2022-11-13 | US | Alaska | Anchorage | 2020 | 121227 | 586 | 0 | 61.14998174 | -149.1426986 | 2022-11-14 04:21:09 | Anchorage, Alaska, US | |
66604 | 66604 | 2022-11-12 | US | Wisconsin | Dane | 55025 | 169914 | 586 | 0 | 43.06601594 | -89.41733797 | 2022-11-13 04:21:14 | Dane, Wisconsin, US | |
63481 | 63481 | 2022-11-12 | US | Alaska | Anchorage | 2020 | 121227 | 586 | 0 | 61.14998174 | -149.1426986 | 2022-11-13 04:21:14 | Anchorage, Alaska, US | |
2930766 | 2930766 | 2022-11-11 | US | Wisconsin | Dane | 55025 | 169914 | 586 | 0 | 43.06601594 | -89.41733797 | 2022-11-12 04:20:41 | Dane, Wisconsin, US | |
2927643 | 2927643 | 2022-11-11 | US | Alaska | Anchorage | 2020 | 121227 | 586 | 0 | 61.14998174 | -149.1426986 | 2022-11-12 04:20:41 | Anchorage, Alaska, US | |
2509602 | 2509602 | 2022-11-10 | US | Wisconsin | Dane | 55025 | 169827 | 586 | 0 | 43.06601594 | -89.41733797 | 2022-11-11 04:21:22 | Dane, Wisconsin, US | |
2506479 | 2506479 | 2022-11-10 | US | Alaska | Anchorage | 2020 | 121227 | 586 | 0 | 61.14998174 | -149.1426986 | 2022-11-11 04:21:22 | Anchorage, Alaska, US | |
2434477 | 2434477 | 2022-11-09 | US | Wisconsin | Dane | 55025 | 169730 | 586 | 0 | 43.06601594 | -89.41733797 | 2022-11-10 04:21:16 | Dane, Wisconsin, US | |
2431354 | 2431354 | 2022-11-09 | US | Alaska | Anchorage | 2020 | 121227 | 586 | 0 | 61.14998174 | -149.1426986 | 2022-11-10 04:21:16 | Anchorage, Alaska, US | |
483133 | 483133 | 2022-11-08 | US | Wisconsin | Dane | 55025 | 169614 | 586 | 0 | 43.06601594 | -89.41733797 | 2022-11-09 04:21:22 | Dane, Wisconsin, US | |
480010 | 480010 | 2022-11-08 | US | Alaska | Anchorage | 2020 | 121227 | 586 | 0 | 61.14998174 | -149.1426986 | 2022-11-09 04:21:22 | Anchorage, Alaska, US | |
2442283 | 2442283 | 2022-11-07 | US | Wisconsin | Dane | 55025 | 169555 | 586 | 0 | 43.06601594 | -89.41733797 | 2022-11-08 04:21:21 | Dane, Wisconsin, US | |
2439160 | 2439160 | 2022-11-07 | US | Alaska | Anchorage | 2020 | 121227 | 586 | 0 | 61.14998174 | -149.1426986 | 2022-11-08 04:21:21 | Anchorage, Alaska, US | |
1053381 | 1053381 | 2022-11-06 | US | Wisconsin | Dane | 55025 | 169349 | 586 | 0 | 43.06601594 | -89.41733797 | 2022-11-07 04:21:26 | Dane, Wisconsin, US | |
1050258 | 1050258 | 2022-11-06 | US | Alaska | Anchorage | 2020 | 121227 | 586 | 0 | 61.14998174 | -149.1426986 | 2022-11-07 04:21:26 | Anchorage, Alaska, US | |
621405 | 621405 | 2022-11-05 | US | Wisconsin | Dane | 55025 | 169349 | 586 | 0 | 43.06601594 | -89.41733797 | 2022-11-06 04:21:24 | Dane, Wisconsin, US | |
618282 | 618282 | 2022-11-05 | US | Alaska | Anchorage | 2020 | 121227 | 586 | 0 | 61.14998174 | -149.1426986 | 2022-11-06 04:21:24 | Anchorage, Alaska, US | |
1025909 | 1025909 | 2022-11-04 | US | Wisconsin | Dane | 55025 | 169349 | 586 | 0 | 43.06601594 | -89.41733797 | 2022-11-05 04:21:52 | Dane, Wisconsin, US | |
1022786 | 1022786 | 2022-11-04 | US | Alaska | Anchorage | 2020 | 121227 | 586 | 0 | 61.14998174 | -149.1426986 | 2022-11-05 04:21:52 | Anchorage, Alaska, US | |
431777 | 431777 | 2022-11-03 | US | Alaska | Anchorage | 2020 | 121227 | 586 | 0 | 61.14998174 | -149.1426986 | 2022-11-04 04:22:11 | Anchorage, Alaska, US | |
850019 | 850019 | 2022-11-02 | US | Alaska | Anchorage | 2020 | 121227 | 586 | 0 | 61.14998174 | -149.1426986 | 2022-11-03 04:22:05 | Anchorage, Alaska, US | |
710870 | 710870 | 2022-11-01 | US | Alaska | Anchorage | 2020 | 121136 | 586 | 0 | 61.14998174 | -149.1426986 | 2022-11-02 04:22:09 | Anchorage, Alaska, US | |
3285319 | 3285319 | 2022-10-31 | US | Alaska | Anchorage | 2020 | 121136 | 586 | 0 | 61.14998174 | -149.1426986 | 2022-11-01 04:22:36 | Anchorage, Alaska, US | |
320352 | 320352 | 2022-10-30 | US | Alaska | Anchorage | 2020 | 121136 | 586 | 0 | 61.14998174 | -149.1426986 | 2022-10-31 04:21:36 | Anchorage, Alaska, US | |
912628 | 912628 | 2022-10-29 | US | Alaska | Anchorage | 2020 | 121136 | 586 | 0 | 61.14998174 | -149.1426986 | 2022-10-30 04:22:14 | Anchorage, Alaska, US | |
1366897 | 1366897 | 2022-10-28 | US | Alaska | Anchorage | 2020 | 121136 | 586 | 0 | 61.14998174 | -149.1426986 | 2022-10-29 04:21:13 | Anchorage, Alaska, US | |
3038752 | 3038752 | 2022-10-27 | US | Alaska | Anchorage | 2020 | 121136 | 586 | 0 | 61.14998174 | -149.1426986 | 2022-10-28 04:22:31 | Anchorage, Alaska, US | |
539172 | 539172 | 2022-10-26 | US | Alaska | Anchorage | 2020 | 121136 | 586 | 0 | 61.14998174 | -149.1426986 | 2022-10-27 04:22:01 | Anchorage, Alaska, US | |
2771420 | 2771420 | 2022-09-26 | US | Ohio | Clermont | 39025 | 60465 | 586 | 0 | 39.04847534 | -84.15375786 | 2022-09-27 04:23:01 | Clermont, Ohio, US | |
1979073 | 1979073 | 2022-09-25 | US | Ohio | Clermont | 39025 | 60465 | 586 | 0 | 39.04847534 | -84.15375786 | 2022-09-26 04:20:52 | Clermont, Ohio, US | |
2652240 | 2652240 | 2022-09-24 | US | Ohio | Clermont | 39025 | 60465 | 586 | 0 | 39.04847534 | -84.15375786 | 2022-09-25 04:23:31 | Clermont, Ohio, US | |
386680 | 386680 | 2022-09-23 | US | Ohio | Clermont | 39025 | 60465 | 586 | 0 | 39.04847534 | -84.15375786 | 2022-09-24 04:21:40 | Clermont, Ohio, US | |
2020258 | 2020258 | 2022-09-20 | US | Wisconsin | Brown | 55009 | 96416 | 586 | 0 | 44.4526553 | -88.00411844 | 2022-09-21 04:23:22 | Brown, Wisconsin, US | |
3574131 | 3574131 | 2022-09-19 | US | Wisconsin | Brown | 55009 | 96331 | 586 | 0 | 44.4526553 | -88.00411844 | 2022-09-20 04:22:48 | Brown, Wisconsin, US | |
422870 | 422870 | 2022-09-18 | US | Wisconsin | Brown | 55009 | 96165 | 586 | 0 | 44.4526553 | -88.00411844 | 2022-09-19 04:21:49 | Brown, Wisconsin, US | |
3376894 | 3376894 | 2022-09-17 | US | Wisconsin | Brown | 55009 | 96165 | 586 | 0 | 44.4526553 | -88.00411844 | 2022-09-18 04:22:50 | Brown, Wisconsin, US | |
2359002 | 2359002 | 2022-09-16 | US | Wisconsin | Brown | 55009 | 96165 | 586 | 0 | 44.4526553 | -88.00411844 | 2022-09-17 04:20:19 | Brown, Wisconsin, US | |
3990159 | 3990159 | 2022-09-15 | US | Wisconsin | Brown | 55009 | 96099 | 586 | 0 | 44.4526553 | -88.00411844 | 2022-09-16 04:21:19 | Brown, Wisconsin, US | |
1891306 | 1891306 | 2022-09-14 | US | New Hampshire | Rockingham | 33015 | 77706 | 586 | 0 | 42.98499744 | -71.12883377 | 2022-09-15 04:21:02 | Rockingham, New Hampshire, US | |
2343424 | 2343424 | 2022-08-31 | Japan | Ibaraki | 317489 | 586 | 0 | 36.303588 | 140.319591 | 2022-09-01 04:21:03 | Ibaraki, Japan | |||
2828831 | 2828831 | 2022-08-25 | Japan | Okinawa | 459621 | 586 | 0 | 25.768923 | 126.668016 | 2022-08-26 04:21:02 | Okinawa, Japan | |||
1161163 | 1161163 | 2022-08-18 | Japan | Hiroshima | 291529 | 586 | 0 | 34.605309 | 132.788719 | 2022-08-19 04:20:54 | Hiroshima, Japan | |||
991442 | 991442 | 2022-08-16 | US | Arizona | Cochise | 4003 | 35115 | 586 | 0 | 31.87934684 | -109.7516088 | 2022-08-17 04:20:59 | Cochise, Arizona, US | |
2494481 | 2494481 | 2022-08-15 | US | Arizona | Cochise | 4003 | 35115 | 586 | 0 | 31.87934684 | -109.7516088 | 2022-08-16 04:20:58 | Cochise, Arizona, US | |
3648031 | 3648031 | 2022-08-14 | US | Arizona | Cochise | 4003 | 35115 | 586 | 0 | 31.87934684 | -109.7516088 | 2022-08-15 04:20:59 | Cochise, Arizona, US | |
1969037 | 1969037 | 2022-08-13 | US | Arizona | Cochise | 4003 | 35115 | 586 | 0 | 31.87934684 | -109.7516088 | 2022-08-14 04:20:55 | Cochise, Arizona, US | |
2888846 | 2888846 | 2022-08-12 | US | Arizona | Cochise | 4003 | 35115 | 586 | 0 | 31.87934684 | -109.7516088 | 2022-08-13 04:20:52 | Cochise, Arizona, US | |
3908451 | 3908451 | 2022-08-11 | US | Arizona | Cochise | 4003 | 35115 | 586 | 0 | 31.87934684 | -109.7516088 | 2022-08-12 04:20:54 | Cochise, Arizona, US | |
1346768 | 1346768 | 2022-08-10 | US | Arizona | Cochise | 4003 | 35115 | 586 | 0 | 31.87934684 | -109.7516088 | 2022-08-11 04:20:49 | Cochise, Arizona, US | |
1071421 | 1071421 | 2022-08-07 | US | Louisiana | Rapides | 22079 | 36425 | 586 | 0 | 31.19778499 | -92.52997303 | 2022-08-08 04:21:08 | Rapides, Louisiana, US | |
1942009 | 1942009 | 2022-08-06 | US | Louisiana | Rapides | 22079 | 36425 | 586 | 0 | 31.19778499 | -92.52997303 | 2022-08-07 04:20:54 | Rapides, Louisiana, US | |
881808 | 881808 | 2022-08-05 | US | Louisiana | Rapides | 22079 | 36425 | 586 | 0 | 31.19778499 | -92.52997303 | 2022-08-06 04:20:56 | Rapides, Louisiana, US | |
1068506 | 1068506 | 2022-07-28 | US | Oregon | Lane | 41039 | 69309 | 586 | 0 | 43.93727035 | -122.847753 | 2022-07-29 04:20:45 | Lane, Oregon, US | |
903246 | 903246 | 2022-07-22 | US | Texas | Ellis | 48139 | 51985 | 586 | 0 | 32.34894117 | -96.79371841 | 2022-07-23 04:20:53 | Ellis, Texas, US | |
673382 | 673382 | 2022-07-21 | US | Texas | Ellis | 48139 | 51881 | 586 | 0 | 32.34894117 | -96.79371841 | 2022-07-22 04:21:15 | Ellis, Texas, US | |
1611345 | 1611345 | 2022-07-20 | US | Texas | Ellis | 48139 | 51808 | 586 | 0 | 32.34894117 | -96.79371841 | 2022-07-21 04:21:10 | Ellis, Texas, US | |
961978 | 961978 | 2022-07-19 | US | Texas | Ellis | 48139 | 51746 | 586 | 0 | 32.34894117 | -96.79371841 | 2022-07-20 04:20:59 | Ellis, Texas, US | |
3213365 | 3213365 | 2022-07-18 | US | Texas | Ellis | 48139 | 51687 | 586 | 0 | 32.34894117 | -96.79371841 | 2022-07-19 04:20:58 | Ellis, Texas, US | |
3408540 | 3408540 | 2022-07-17 | US | Texas | Ellis | 48139 | 51618 | 586 | 0 | 32.34894117 | -96.79371841 | 2022-07-18 04:20:59 | Ellis, Texas, US | |
2154740 | 2154740 | 2022-07-16 | US | Texas | Ellis | 48139 | 51539 | 586 | 0 | 32.34894117 | -96.79371841 | 2022-07-17 04:21:15 | Ellis, Texas, US | |
3079684 | 3079684 | 2022-07-04 | US | Michigan | Calhoun | 26025 | 36367 | 586 | 0 | 42.24633834 | -85.00493569 | 2022-07-05 04:20:45 | Calhoun, Michigan, US | |
1768966 | 1768966 | 2022-07-03 | US | Michigan | Calhoun | 26025 | 36367 | 586 | 0 | 42.24633834 | -85.00493569 | 2022-07-04 04:20:54 | Calhoun, Michigan, US | |
3366952 | 3366952 | 2022-07-02 | US | Michigan | Calhoun | 26025 | 36367 | 586 | 0 | 42.24633834 | -85.00493569 | 2022-07-03 04:20:59 | Calhoun, Michigan, US | |
595281 | 595281 | 2022-07-01 | US | Michigan | Calhoun | 26025 | 36367 | 586 | 0 | 42.24633834 | -85.00493569 | 2022-07-02 04:21:16 | Calhoun, Michigan, US | |
3941682 | 3941682 | 2022-06-30 | US | Michigan | Calhoun | 26025 | 36367 | 586 | 0 | 42.24633834 | -85.00493569 | 2022-07-01 04:21:10 | Calhoun, Michigan, US | |
2491640 | 2491640 | 2022-06-29 | US | Michigan | Calhoun | 26025 | 36367 | 586 | 0 | 42.24633834 | -85.00493569 | 2022-06-30 04:21:01 | Calhoun, Michigan, US | |
2241022 | 2241022 | 2022-06-28 | US | Michigan | Calhoun | 26025 | 36367 | 586 | 0 | 42.24633834 | -85.00493569 | 2022-06-29 04:20:59 | Calhoun, Michigan, US | |
478420 | 478420 | 2022-06-26 | US | Tennessee | Montgomery | 47125 | 52411 | 586 | 0 | 36.49609412 | -87.38550661 | 2022-06-27 04:21:00 | Montgomery, Tennessee, US | |
941795 | 941795 | 2022-06-25 | US | Tennessee | Montgomery | 47125 | 52379 | 586 | 0 | 36.49609412 | -87.38550661 | 2022-06-26 04:21:02 | Montgomery, Tennessee, US | |
3349615 | 3349615 | 2022-06-24 | US | Tennessee | Montgomery | 47125 | 52357 | 586 | 0 | 36.49609412 | -87.38550661 | 2022-06-25 04:20:57 | Montgomery, Tennessee, US | |
1651356 | 1651356 | 2022-06-23 | US | Tennessee | Montgomery | 47125 | 52273 | 586 | 0 | 36.49609412 | -87.38550661 | 2022-06-24 04:20:58 | Montgomery, Tennessee, US | |
2190591 | 2190591 | 2022-06-22 | US | Tennessee | Montgomery | 47125 | 52213 | 586 | 0 | 36.49609412 | -87.38550661 | 2022-06-23 04:20:55 | Montgomery, Tennessee, US | |
169022 | 169022 | 2022-06-21 | US | Tennessee | Montgomery | 47125 | 52139 | 586 | 0 | 36.49609412 | -87.38550661 | 2022-06-22 04:20:54 | Montgomery, Tennessee, US | |
1766305 | 1766305 | 2022-06-20 | US | Tennessee | Montgomery | 47125 | 52067 | 586 | 0 | 36.49609412 | -87.38550661 | 2022-06-21 04:20:56 | Montgomery, Tennessee, US | |
3272491 | 3272491 | 2022-06-19 | US | Tennessee | Montgomery | 47125 | 52012 | 586 | 0 | 36.49609412 | -87.38550661 | 2022-06-20 04:21:01 | Montgomery, Tennessee, US | |
3400403 | 3400403 | 2022-06-18 | US | Tennessee | Montgomery | 47125 | 51967 | 586 | 0 | 36.49609412 | -87.38550661 | 2022-06-19 04:20:51 | Montgomery, Tennessee, US | |
2314280 | 2314280 | 2022-06-17 | US | Tennessee | Montgomery | 47125 | 51937 | 586 | 0 | 36.49609412 | -87.38550661 | 2022-06-18 04:21:10 | Montgomery, Tennessee, US | |
559445 | 559445 | 2022-06-16 | US | Colorado | Mesa | 8077 | 45013 | 586 | 0 | 39.01787888 | -108.469799 | 2022-06-17 04:20:56 | Mesa, Colorado, US | |
3889203 | 3889203 | 2022-06-06 | US | Maryland | Harford | 24025 | 40827 | 586 | 0 | 39.55010644 | -76.3077594 | 2022-06-07 04:21:08 | Harford, Maryland, US | |
3508972 | 3508972 | 2022-06-05 | US | Maryland | Harford | 24025 | 40765 | 586 | 0 | 39.55010644 | -76.3077594 | 2022-06-06 04:20:57 | Harford, Maryland, US | |
3529049 | 3529049 | 2022-06-04 | US | Maryland | Harford | 24025 | 40765 | 586 | 0 | 39.55010644 | -76.3077594 | 2022-06-05 04:20:55 | Harford, Maryland, US | |
3135135 | 3135135 | 2022-06-03 | US | Maryland | Harford | 24025 | 40765 | 586 | 0 | 39.55010644 | -76.3077594 | 2022-06-04 04:20:58 | Harford, Maryland, US | |
3580220 | 3580220 | 2022-06-02 | US | Maryland | Washington | 24043 | 35861 | 586 | 0 | 39.60835778 | -77.82002295 | 2022-06-03 04:20:58 | Washington, Maryland, US | |
3580210 | 3580210 | 2022-06-02 | US | Maryland | Harford | 24025 | 40693 | 586 | 0 | 39.55010644 | -76.3077594 | 2022-06-03 04:20:58 | Harford, Maryland, US | |
972513 | 972513 | 2022-06-01 | US | Maryland | Washington | 24043 | 35861 | 586 | 0 | 39.60835778 | -77.82002295 | 2022-06-02 05:20:39 | Washington, Maryland, US | |
972503 | 972503 | 2022-06-01 | US | Maryland | Harford | 24025 | 40713 | 586 | 0 | 39.55010644 | -76.3077594 | 2022-06-02 05:20:39 | Harford, Maryland, US | |
230820 | 230820 | 2022-05-31 | US | Maryland | Washington | 24043 | 35784 | 586 | 0 | 39.60835778 | -77.82002295 | 2022-06-01 04:20:55 | Washington, Maryland, US | |
3188444 | 3188444 | 2022-05-30 | US | Ohio | Clark | 39023 | 35537 | 586 | 0 | 39.91592258 | -83.78498252 | 2022-05-31 04:20:51 | Clark, Ohio, US | |
3187585 | 3187585 | 2022-05-30 | US | Maryland | Washington | 24043 | 35745 | 586 | 0 | 39.60835778 | -77.82002295 | 2022-05-31 04:20:51 | Washington, Maryland, 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]);