johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
147 rows where deaths = 1193 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2954083 | 2954083 | 2022-12-20 | US | Pennsylvania | Northampton | 42095 | 96114 | 1193 | 0 | 40.75182733 | -75.30471829 | 2022-12-21 04:21:03 | Northampton, Pennsylvania, US | |
3176485 | 3176485 | 2022-12-19 | US | Pennsylvania | Northampton | 42095 | 96114 | 1193 | 0 | 40.75182733 | -75.30471829 | 2022-12-20 04:21:04 | Northampton, Pennsylvania, US | |
1631002 | 1631002 | 2022-12-18 | US | Pennsylvania | Northampton | 42095 | 96114 | 1193 | 0 | 40.75182733 | -75.30471829 | 2022-12-19 04:21:03 | Northampton, Pennsylvania, US | |
506381 | 506381 | 2022-12-17 | US | Pennsylvania | Northampton | 42095 | 96114 | 1193 | 0 | 40.75182733 | -75.30471829 | 2022-12-18 04:21:03 | Northampton, Pennsylvania, US | |
3326953 | 3326953 | 2022-12-16 | US | Pennsylvania | Northampton | 42095 | 96114 | 1193 | 0 | 40.75182733 | -75.30471829 | 2022-12-17 04:21:04 | Northampton, Pennsylvania, US | |
545465 | 545465 | 2022-12-15 | US | Pennsylvania | Northampton | 42095 | 96114 | 1193 | 0 | 40.75182733 | -75.30471829 | 2022-12-16 04:21:01 | Northampton, Pennsylvania, US | |
350993 | 350993 | 2022-12-14 | US | Pennsylvania | Northampton | 42095 | 96114 | 1193 | 0 | 40.75182733 | -75.30471829 | 2022-12-15 04:20:58 | Northampton, Pennsylvania, US | |
1964631 | 1964631 | 2022-11-30 | Malaysia | Melaka | 141909 | 1193 | 0 | 2.1896 | 102.2501 | 2022-12-01 04:21:03 | Melaka, Malaysia | |||
2011639 | 2011639 | 2022-08-04 | US | Tennessee | Hamilton | 47065 | 109505 | 1193 | 0 | 35.17670231 | -85.16652245 | 2022-08-05 04:20:52 | Hamilton, Tennessee, US | |
1101066 | 1101066 | 2022-08-03 | US | Tennessee | Hamilton | 47065 | 109362 | 1193 | 0 | 35.17670231 | -85.16652245 | 2022-08-04 04:20:58 | Hamilton, Tennessee, US | |
1407991 | 1407991 | 2022-08-02 | US | Tennessee | Hamilton | 47065 | 109214 | 1193 | 0 | 35.17670231 | -85.16652245 | 2022-08-03 04:20:59 | Hamilton, Tennessee, US | |
1608785 | 1608785 | 2022-07-20 | US | Arkansas | Pulaski | 5119 | 113130 | 1193 | 0 | 34.77054088 | -92.31355101 | 2022-07-21 04:21:10 | Pulaski, Arkansas, US | |
959418 | 959418 | 2022-07-19 | US | Arkansas | Pulaski | 5119 | 112838 | 1193 | 0 | 34.77054088 | -92.31355101 | 2022-07-20 04:20:59 | Pulaski, Arkansas, US | |
3210805 | 3210805 | 2022-07-18 | US | Arkansas | Pulaski | 5119 | 112605 | 1193 | 0 | 34.77054088 | -92.31355101 | 2022-07-19 04:20:58 | Pulaski, Arkansas, US | |
3405980 | 3405980 | 2022-07-17 | US | Arkansas | Pulaski | 5119 | 112528 | 1193 | 0 | 34.77054088 | -92.31355101 | 2022-07-18 04:20:59 | Pulaski, Arkansas, US | |
2152180 | 2152180 | 2022-07-16 | US | Arkansas | Pulaski | 5119 | 112367 | 1193 | 0 | 34.77054088 | -92.31355101 | 2022-07-17 04:21:15 | Pulaski, Arkansas, US | |
2419413 | 2419413 | 2022-07-15 | US | Arkansas | Pulaski | 5119 | 112209 | 1193 | 0 | 34.77054088 | -92.31355101 | 2022-07-16 04:21:05 | Pulaski, Arkansas, US | |
3429488 | 3429488 | 2022-07-14 | US | Arkansas | Pulaski | 5119 | 112022 | 1193 | 0 | 34.77054088 | -92.31355101 | 2022-07-15 04:20:53 | Pulaski, Arkansas, US | |
3110008 | 3110008 | 2022-07-13 | US | Arkansas | Pulaski | 5119 | 111697 | 1193 | 0 | 34.77054088 | -92.31355101 | 2022-07-14 04:20:57 | Pulaski, Arkansas, US | |
3270581 | 3270581 | 2022-06-19 | US | Indiana | Allen | 18003 | 106758 | 1193 | 0 | 41.09194313 | -85.06800636 | 2022-06-20 04:21:01 | Allen, Indiana, US | |
3398493 | 3398493 | 2022-06-18 | US | Indiana | Allen | 18003 | 106758 | 1193 | 0 | 41.09194313 | -85.06800636 | 2022-06-19 04:20:51 | Allen, Indiana, US | |
2312370 | 2312370 | 2022-06-17 | US | Indiana | Allen | 18003 | 106758 | 1193 | 0 | 41.09194313 | -85.06800636 | 2022-06-18 04:21:10 | Allen, Indiana, US | |
559874 | 559874 | 2022-06-16 | US | Indiana | Allen | 18003 | 106657 | 1193 | 0 | 41.09194313 | -85.06800636 | 2022-06-17 04:20:56 | Allen, Indiana, US | |
3983676 | 3983676 | 2022-06-15 | US | Indiana | Allen | 18003 | 106657 | 1193 | 0 | 41.09194313 | -85.06800636 | 2022-06-16 04:20:55 | Allen, Indiana, US | |
947917 | 947917 | 2022-06-14 | US | Indiana | Allen | 18003 | 106572 | 1193 | 0 | 41.09194313 | -85.06800636 | 2022-06-15 04:20:54 | Allen, Indiana, US | |
2980325 | 2980325 | 2022-06-13 | US | Indiana | Allen | 18003 | 106572 | 1193 | 0 | 41.09194313 | -85.06800636 | 2022-06-14 04:20:52 | Allen, Indiana, US | |
2236451 | 2236451 | 2022-06-12 | US | Indiana | Allen | 18003 | 106392 | 1193 | 0 | 41.09194313 | -85.06800636 | 2022-06-13 04:21:14 | Allen, Indiana, US | |
3142649 | 3142649 | 2022-06-11 | US | Indiana | Allen | 18003 | 106392 | 1193 | 0 | 41.09194313 | -85.06800636 | 2022-06-12 04:20:53 | Allen, Indiana, US | |
1945565 | 1945565 | 2022-06-10 | US | Indiana | Allen | 18003 | 106392 | 1193 | 0 | 41.09194313 | -85.06800636 | 2022-06-11 04:21:01 | Allen, Indiana, US | |
1328399 | 1328399 | 2022-04-26 | US | Nevada | Washoe | 32031 | 104836 | 1193 | 0 | 40.66562265 | -119.6631594 | 2022-04-27 04:20:52 | Washoe, Nevada, US | |
3724353 | 3724353 | 2022-04-25 | US | Nevada | Washoe | 32031 | 104836 | 1193 | 0 | 40.66562265 | -119.6631594 | 2022-04-26 04:20:51 | Washoe, Nevada, US | |
2031403 | 2031403 | 2022-04-24 | US | Oregon | Multnomah | 41051 | 116609 | 1193 | 0 | 45.54747959 | -122.4169351 | 2022-04-25 04:20:56 | Multnomah, Oregon, US | |
2030921 | 2030921 | 2022-04-24 | US | Nevada | Washoe | 32031 | 104836 | 1193 | 0 | 40.66562265 | -119.6631594 | 2022-04-25 04:20:56 | Washoe, Nevada, US | |
748978 | 748978 | 2022-04-23 | US | Oregon | Multnomah | 41051 | 116609 | 1193 | 0 | 45.54747959 | -122.4169351 | 2022-04-24 04:20:56 | Multnomah, Oregon, US | |
748496 | 748496 | 2022-04-23 | US | Nevada | Washoe | 32031 | 104836 | 1193 | 0 | 40.66562265 | -119.6631594 | 2022-04-24 04:20:56 | Washoe, Nevada, US | |
3439463 | 3439463 | 2022-04-22 | US | Oregon | Multnomah | 41051 | 116609 | 1193 | 0 | 45.54747959 | -122.4169351 | 2022-04-23 04:20:50 | Multnomah, Oregon, US | |
3438981 | 3438981 | 2022-04-22 | US | Nevada | Washoe | 32031 | 104836 | 1193 | 0 | 40.66562265 | -119.6631594 | 2022-04-23 04:20:50 | Washoe, Nevada, US | |
2895048 | 2895048 | 2022-04-21 | US | Oregon | Multnomah | 41051 | 116347 | 1193 | 0 | 45.54747959 | -122.4169351 | 2022-04-22 04:20:45 | Multnomah, Oregon, US | |
2894566 | 2894566 | 2022-04-21 | US | Nevada | Washoe | 32031 | 104836 | 1193 | 0 | 40.66562265 | -119.6631594 | 2022-04-22 04:20:45 | Washoe, Nevada, US | |
2309438 | 2309438 | 2022-04-20 | US | Nevada | Washoe | 32031 | 104836 | 1193 | 0 | 40.66562265 | -119.6631594 | 2022-04-21 04:20:46 | Washoe, Nevada, US | |
3730834 | 3730834 | 2022-04-03 | US | Colorado | Arapahoe | 8005 | 158490 | 1193 | 0 | 39.64977461 | -104.3353617 | 2022-04-04 04:20:51 | Arapahoe, Colorado, US | |
500269 | 500269 | 2022-04-02 | US | Colorado | Arapahoe | 8005 | 158463 | 1193 | 0 | 39.64977461 | -104.3353617 | 2022-04-03 04:20:48 | Arapahoe, Colorado, US | |
3351254 | 3351254 | 2022-04-01 | US | Colorado | Arapahoe | 8005 | 158437 | 1193 | 0 | 39.64977461 | -104.3353617 | 2022-04-02 04:20:47 | Arapahoe, Colorado, US | |
1542125 | 1542125 | 2022-03-31 | US | New Jersey | Burlington | 34005 | 101903 | 1193 | 0 | 39.87681124 | -74.66927768 | 2022-04-01 04:20:28 | Burlington, New Jersey, US | |
1540559 | 1540559 | 2022-03-31 | US | Colorado | Arapahoe | 8005 | 158395 | 1193 | 0 | 39.64977461 | -104.3353617 | 2022-04-01 04:20:28 | Arapahoe, Colorado, US | |
2480138 | 2480138 | 2022-03-30 | US | New Jersey | Burlington | 34005 | 101853 | 1193 | 0 | 39.87681124 | -74.66927768 | 2022-03-31 04:20:56 | Burlington, New Jersey, US | |
160179 | 160179 | 2022-03-29 | US | New Jersey | Burlington | 34005 | 101808 | 1193 | 0 | 39.87681124 | -74.66927768 | 2022-03-30 04:20:45 | Burlington, New Jersey, US | |
1438750 | 1438750 | 2022-03-28 | US | New Jersey | Burlington | 34005 | 101756 | 1193 | 0 | 39.87681124 | -74.66927768 | 2022-03-29 04:20:46 | Burlington, New Jersey, US | |
878431 | 878431 | 2022-03-27 | US | New Jersey | Burlington | 34005 | 101732 | 1193 | 0 | 39.87681124 | -74.66927768 | 2022-03-28 04:20:33 | Burlington, New Jersey, US | |
2165714 | 2165714 | 2022-03-26 | US | New Jersey | Burlington | 34005 | 101700 | 1193 | 0 | 39.87681124 | -74.66927768 | 2022-03-27 04:20:47 | Burlington, New Jersey, US | |
1469404 | 1469404 | 2022-03-24 | US | Kansas | Johnson | 20091 | 144965 | 1193 | 0 | 38.88548175 | -94.82250877 | 2022-03-25 04:20:46 | Johnson, Kansas, US | |
3023578 | 3023578 | 2022-03-23 | US | Kansas | Johnson | 20091 | 144965 | 1193 | 0 | 38.88548175 | -94.82250877 | 2022-03-24 04:20:43 | Johnson, Kansas, US | |
233460 | 233460 | 2022-02-11 | Russia | Kostroma Oblast | 60842 | 1193 | 0 | 58.424756 | 44.253327299999995 | 2022-02-12 04:21:06 | Kostroma Oblast, Russia | |||
1466768 | 1466768 | 2022-02-10 | US | Pennsylvania | Lehigh | 42077 | 88000 | 1193 | 0 | 40.6154815 | -75.59435245 | 2022-02-11 04:21:09 | Lehigh, Pennsylvania, US | |
1464311 | 1464311 | 2022-02-10 | Russia | Mordovia Republic | 48701 | 1193 | 0 | 54.4419829 | 44.466114399999995 | 2022-02-11 04:21:09 | Mordovia Republic, Russia | |||
462452 | 462452 | 2022-02-02 | US | Texas | Denton | 48121 | 165595 | 1193 | 0 | 33.20521901 | -97.11691153 | 2022-02-03 04:21:21 | Denton, Texas, US | |
2660971 | 2660971 | 2022-01-31 | US | Texas | Montgomery | 48339 | 129046 | 1193 | 0 | 30.30079133 | -95.50572772 | 2022-02-01 04:21:11 | Montgomery, Texas, US | |
3303388 | 3303388 | 2022-01-30 | US | Texas | Montgomery | 48339 | 128567 | 1193 | 0 | 30.30079133 | -95.50572772 | 2022-01-31 04:21:09 | Montgomery, Texas, US | |
3065179 | 3065179 | 2022-01-29 | US | Texas | Montgomery | 48339 | 128049 | 1193 | 0 | 30.30079133 | -95.50572772 | 2022-01-30 04:21:26 | Montgomery, Texas, US | |
1230216 | 1230216 | 2022-01-24 | US | Oklahoma | Unassigned | 90040 | 77407 | 1193 | 0 | 36.83532655 | 0.0 | 2022-01-25 04:21:05 | Unassigned, Oklahoma, US | |
1962314 | 1962314 | 2022-01-20 | US | Minnesota | Ramsey | 27123 | 103109 | 1193 | 0 | 45.01625271 | -93.09872295 | 2022-01-21 04:21:09 | Ramsey, Minnesota, US | |
1961231 | 1961231 | 2022-01-20 | US | Delaware | New Castle | 10003 | 133641 | 1193 | 0 | 39.57992638 | -75.64054974 | 2022-01-21 04:21:09 | New Castle, Delaware, US | |
1114446 | 1114446 | 2022-01-11 | US | Georgia | Out of GA | 80013 | 58479 | 1193 | 0 | 34.91369188 | 0.0 | 2022-01-12 04:21:44 | Out of GA, Georgia, US | |
1282300 | 1282300 | 2022-01-05 | Suriname | 55376 | 1193 | 0 | 3.9193 | -56.0278 | 2022-01-06 04:22:09 | Suriname | ||||
1701861 | 1701861 | 2022-01-03 | US | Louisiana | Jefferson | 22051 | 82443 | 1193 | 0 | 29.74075478 | -90.11115756 | 2022-01-04 04:22:17 | Jefferson, Louisiana, US | |
3520944 | 3520944 | 2022-01-02 | US | Louisiana | Jefferson | 22051 | 77982 | 1193 | 0 | 29.74075478 | -90.11115756 | 2022-01-03 02:22:25 | Jefferson, Louisiana, US | |
2169074 | 2169074 | 2022-01-01 | US | Louisiana | Jefferson | 22051 | 77982 | 1193 | 0 | 29.74075478 | -90.11115756 | 2022-01-02 04:20:52 | Jefferson, Louisiana, US | |
2778505 | 2778505 | 2021-12-31 | US | Louisiana | Jefferson | 22051 | 77982 | 1193 | 0 | 29.74075478 | -90.11115756 | 2022-01-01 04:22:14 | Jefferson, Louisiana, US | |
4000162 | 4000162 | 2021-12-30 | US | Louisiana | Jefferson | 22051 | 77982 | 1193 | 0 | 29.74075478 | -90.11115756 | 2021-12-31 04:21:50 | Jefferson, Louisiana, US | |
3998861 | 3998861 | 2021-12-30 | Russia | Karelia Republic | 89903 | 1193 | 0 | 62.61940309999999 | 33.4920267 | 2021-12-31 04:21:50 | Karelia Republic, Russia | |||
2115033 | 2115033 | 2021-12-26 | US | Virginia | Fairfax | 51059 | 105063 | 1193 | 0 | 38.83677558 | -77.27565836 | 2021-12-27 04:21:58 | Fairfax, Virginia, US | |
3608405 | 3608405 | 2021-12-25 | US | Virginia | Fairfax | 51059 | 105063 | 1193 | 0 | 38.83677558 | -77.27565836 | 2021-12-26 04:21:50 | Fairfax, Virginia, US | |
2966723 | 2966723 | 2021-12-24 | US | Virginia | Fairfax | 51059 | 105063 | 1193 | 0 | 38.83677558 | -77.27565836 | 2021-12-25 04:21:37 | Fairfax, Virginia, US | |
1719408 | 1719408 | 2021-12-16 | US | Texas | Collin | 48085 | 132712 | 1193 | 0 | 33.18820114 | -96.57264368 | 2021-12-17 04:22:14 | Collin, Texas, US | |
3499242 | 3499242 | 2021-12-15 | US | Texas | Collin | 48085 | 132551 | 1193 | 0 | 33.18820114 | -96.57264368 | 2021-12-16 04:22:11 | Collin, Texas, US | |
29094 | 29094 | 2021-11-11 | US | District of Columbia | District of Columbia | 11001 | 65159 | 1193 | 0 | 38.90417773 | -77.01655992 | 2021-11-12 04:22:01 | District of Columbia, District of Columbia ,US | |
2845533 | 2845533 | 2021-11-10 | US | District of Columbia | District of Columbia | 11001 | 65159 | 1193 | 0 | 38.90417773 | -77.01655992 | 2021-11-11 04:21:45 | District of Columbia, District of Columbia ,US | |
87803 | 87803 | 2021-11-09 | US | District of Columbia | District of Columbia | 11001 | 65094 | 1193 | 0 | 38.90417773 | -77.01655992 | 2021-11-10 04:21:38 | District of Columbia, District of Columbia ,US | |
3640231 | 3640231 | 2021-11-08 | US | District of Columbia | District of Columbia | 11001 | 65050 | 1193 | 0 | 38.90417773 | -77.01655992 | 2021-11-09 04:21:36 | District of Columbia, District of Columbia ,US | |
2001339 | 2001339 | 2021-11-07 | US | District of Columbia | District of Columbia | 11001 | 64799 | 1193 | 0 | 38.90417773 | -77.01655992 | 2021-11-08 04:21:43 | District of Columbia, District of Columbia ,US | |
496330 | 496330 | 2021-11-06 | US | District of Columbia | District of Columbia | 11001 | 64799 | 1193 | 0 | 38.90417773 | -77.01655992 | 2021-11-07 04:21:53 | District of Columbia, District of Columbia ,US | |
3122185 | 3122185 | 2021-11-05 | US | District of Columbia | District of Columbia | 11001 | 64799 | 1193 | 0 | 38.90417773 | -77.01655992 | 2021-11-06 04:21:51 | District of Columbia, District of Columbia ,US | |
699083 | 699083 | 2021-11-04 | US | District of Columbia | District of Columbia | 11001 | 64708 | 1193 | 0 | 38.90417773 | -77.01655992 | 2021-11-05 04:21:54 | District of Columbia, District of Columbia ,US | |
276861 | 276861 | 2021-11-03 | US | District of Columbia | District of Columbia | 11001 | 64602 | 1193 | 0 | 38.90417773 | -77.01655992 | 2021-11-04 04:22:20 | District of Columbia, District of Columbia ,US | |
44386 | 44386 | 2021-11-02 | US | District of Columbia | District of Columbia | 11001 | 64541 | 1193 | 0 | 38.90417773 | -77.01655992 | 2021-11-03 06:22:09 | District of Columbia, District of Columbia ,US | |
426987 | 426987 | 2021-10-10 | Ukraine | Luhansk Oblast | 37768 | 1193 | 0 | 48.574 | 39.3078 | 2021-10-11 04:21:31 | Luhansk Oblast, Ukraine | |||
988582 | 988582 | 2021-10-04 | US | Massachusetts | Plymouth | 25023 | 56907 | 1193 | 0 | 41.94070556 | -70.80802823 | 2021-10-05 04:21:27 | Plymouth, Massachusetts, US | |
2131995 | 2131995 | 2021-10-01 | Italy | P.A. Bolzano | 76980 | 1193 | 0 | 46.49933453 | 11.35662422 | 2021-10-02 04:21:25 | P.A. Bolzano, Italy | |||
706492 | 706492 | 2021-09-29 | Malaysia | Negeri Sembilan | 97113 | 1193 | 0 | 2.7258 | 101.9424 | 2021-09-30 04:21:20 | Negeri Sembilan, Malaysia | |||
1334334 | 1334334 | 2021-09-28 | Malaysia | Negeri Sembilan | 96944 | 1193 | 0 | 2.7258 | 101.9424 | 2021-09-29 04:21:45 | Negeri Sembilan, Malaysia | |||
1235703 | 1235703 | 2021-09-27 | Malaysia | Negeri Sembilan | 96855 | 1193 | 0 | 2.7258 | 101.9424 | 2021-09-28 04:21:28 | Negeri Sembilan, Malaysia | |||
2809015 | 2809015 | 2021-09-16 | Rwanda | 94478 | 1193 | 0 | -1.9403 | 29.8739 | 2021-09-17 04:21:46 | Rwanda | ||||
3193915 | 3193915 | 2021-09-06 | Germany | Mecklenburg-Vorpommern | 46726 | 1193 | 0 | 53.6127 | 12.4296 | 2021-09-07 04:21:35 | Mecklenburg-Vorpommern, Germany | |||
178801 | 178801 | 2021-09-02 | US | Georgia | Cobb | 13067 | 96190 | 1193 | 0 | 33.94243204 | -84.5761255 | 2021-09-03 04:21:20 | Cobb, Georgia, US | |
332209 | 332209 | 2021-08-04 | Spain | Navarra | 77238 | 1193 | 3905 | 72140 | 42.6954 | -1.6761 | 2021-08-05 04:21:51 | Navarra, Spain | ||
3295959 | 3295959 | 2021-07-30 | Chile | Antofagasta | 59624 | 1193 | 58121 | 310 | -23.6509 | -70.3975 | 2021-07-31 04:21:35 | Antofagasta, Chile | ||
296165 | 296165 | 2021-07-15 | Peru | Amazonas | 30408 | 1193 | 0 | 29215 | -5.077253 | -78.050172 | 2021-07-16 04:21:22 | Amazonas, Peru | ||
3632110 | 3632110 | 2021-07-14 | Peru | Amazonas | 30408 | 1193 | 0 | 29215 | -5.077253 | -78.050172 | 2021-07-15 04:21:48 | Amazonas, Peru | ||
3659842 | 3659842 | 2021-07-11 | Russia | Smolensk Oblast | 37395 | 1193 | 32533 | 3669 | 55.03434960000001 | 33.0192065 | 2021-07-12 04:21:34 | Smolensk Oblast, Russia | ||
1440845 | 1440845 | 2021-07-07 | Russia | Vologda Oblast | 49347 | 1193 | 44664 | 3490 | 60.0391461 | 43.1215213 | 2021-07-08 04:21:26 | Vologda Oblast, Russia |
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]);