johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
125 rows where active = 1553 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3125451 | 3125451 | 2021-06-28 | India | Delhi | 1433993 | 24967 | 1407473 | 1553 | 28.646519 | 77.10898 | 2021-06-29 04:21:28 | Delhi, India | ||
2426559 | 2426559 | 2021-06-23 | Yemen | 6898 | 1355 | 3990 | 1553 | 15.552727 | 48.516388 | 2021-06-24 04:21:55 | Yemen | |||
1810365 | 1810365 | 2021-05-27 | Ukraine | Crimea Republic* | 43099 | 1336 | 40210 | 1553 | 45.2835 | 34.2008 | 2021-05-28 04:20:36 | Crimea Republic*, Ukraine | ||
1806666 | 1806666 | 2021-05-27 | Germany | Schleswig-Holstein | 62760 | 1586 | 59700 | 1553 | 54.2194 | 9.6961 | 2021-05-28 04:20:36 | Schleswig-Holstein, Germany | ||
3057865 | 3057865 | 2021-05-13 | Malaysia | Kedah | 12015 | 35 | 10427 | 1553 | 6.1184 | 100.3685 | 2021-05-14 04:20:41 | Kedah, Malaysia | ||
1842141 | 1842141 | 2021-04-14 | Russia | Ingushetia Republic | 15254 | 182 | 13519 | 1553 | 43.11542075 | 45.01713552 | 2021-04-15 04:20:54 | Ingushetia Republic, Russia | ||
605885 | 605885 | 2021-04-09 | Russia | Ingushetia Republic | 15206 | 181 | 13472 | 1553 | 43.11542075 | 45.01713552 | 2021-04-10 04:20:59 | Ingushetia Republic, Russia | ||
3003340 | 3003340 | 2021-04-06 | Japan | Saitama | 33605 | 709 | 31343 | 1553 | 35.997101 | 139.347635 | 2021-04-07 04:20:53 | Saitama, Japan | ||
3962309 | 3962309 | 2021-03-10 | Chile | Los Rios | 21793 | 247 | 19993 | 1553 | -40.231 | -72.3311 | 2021-03-11 05:25:48 | Los Rios, Chile | ||
1619641 | 1619641 | 2021-03-05 | US | Virginia | Scott | 51169 | 1602 | 49 | 0 | 1553 | 36.71466456 | -82.60171704 | 2021-03-06 04:23:41 | Scott, Virginia, US |
1617220 | 1617220 | 2021-03-05 | US | Illinois | Ford | 17053 | 1598 | 45 | 0 | 1553 | 40.59706922 | -88.22350769 | 2021-03-06 04:23:41 | Ford, Illinois, US |
2207907 | 2207907 | 2021-03-04 | Russia | Tyumen Oblast | 31641 | 298 | 29790 | 1553 | 58.8206488 | 70.36588370000001 | 2021-03-05 05:26:29 | Tyumen Oblast, Russia | ||
1861023 | 1861023 | 2021-02-25 | US | Texas | Bosque | 48035 | 1853 | 30 | 0 | 1553 | 31.89978581 | -97.63613524 | 2021-02-26 05:22:40 | Bosque, Texas, US |
1859718 | 1859718 | 2021-02-25 | US | Minnesota | Houston | 27055 | 1567 | 14 | 0 | 1553 | 43.67129565 | -91.49143057 | 2021-02-26 05:22:40 | Houston, Minnesota, US |
1859083 | 1859083 | 2021-02-25 | US | Indiana | Franklin | 18047 | 1588 | 35 | 0 | 1553 | 39.4142482 | -85.06062647 | 2021-02-26 05:22:40 | Franklin, Indiana, US |
744028 | 744028 | 2021-02-20 | US | Minnesota | Hubbard | 27057 | 1593 | 40 | 0 | 1553 | 47.10778564 | -94.91693868 | 2021-02-21 05:24:33 | Hubbard, Minnesota, US |
1153374 | 1153374 | 2021-02-18 | Russia | Tyumen Oblast | 30424 | 268 | 28603 | 1553 | 58.8206488 | 70.36588370000001 | 2021-02-19 05:24:16 | Tyumen Oblast, Russia | ||
3540384 | 3540384 | 2021-02-12 | US | Idaho | Elmore | 16039 | 1564 | 11 | 0 | 1553 | 43.3507101 | -115.4701578 | 2021-02-13 05:22:12 | Elmore, Idaho, US |
3980987 | 3980987 | 2021-02-10 | US | North Dakota | Ramsey | 38071 | 1579 | 30 | 0 | 1553 | 48.26886249 | -98.72223879 | 2021-02-11 05:23:55 | Ramsey, North Dakota, US |
3979570 | 3979570 | 2021-02-10 | US | Illinois | Jo Daviess | 17085 | 1575 | 22 | 0 | 1553 | 42.36542373 | -90.21094405 | 2021-02-11 05:23:55 | Jo Daviess, Illinois, US |
978395 | 978395 | 2021-02-06 | US | West Virginia | Jackson | 54035 | 1598 | 45 | 0 | 1553 | 38.84263974 | -81.68148753 | 2021-02-07 05:23:00 | Jackson, West Virginia, US |
1685691 | 1685691 | 2021-02-02 | US | Iowa | Harrison | 19085 | 1618 | 65 | 0 | 1553 | 41.68330137 | -95.81558439 | 2021-02-03 05:22:52 | Harrison, Iowa, US |
1462793 | 1462793 | 2021-01-31 | US | Texas | Cass | 48067 | 1597 | 68 | 0 | 1553 | 33.07499881 | -94.34646905 | 2021-02-01 05:22:53 | Cass, Texas, US |
2213595 | 2213595 | 2021-01-30 | US | Missouri | Morgan | 29141 | 1589 | 36 | 0 | 1553 | 38.4181765 | -92.88791859 | 2021-01-31 05:22:42 | Morgan, Missouri, US |
1897175 | 1897175 | 2021-01-29 | Japan | Kyoto | 8289 | 114 | 6622 | 1553 | 35.253815 | 135.443341 | 2021-01-30 05:22:49 | Kyoto, Japan | ||
2483133 | 2483133 | 2021-01-28 | US | Iowa | Cedar | 19031 | 1572 | 19 | 0 | 1553 | 41.77233777 | -91.13246684 | 2021-01-29 05:22:23 | Cedar, Iowa, US |
3155446 | 3155446 | 2021-01-27 | US | Mississippi | Tallahatchie | 28135 | 1588 | 35 | 0 | 1553 | 33.95339918 | -90.1729398 | 2021-01-28 05:22:24 | Tallahatchie, Mississippi, US |
2427533 | 2427533 | 2021-01-23 | US | Colorado | Montezuma | 8083 | 1656 | 20 | 0 | 1553 | 37.33859579 | -108.5958857 | 2021-01-24 05:22:35 | Montezuma, Colorado, US |
435048 | 435048 | 2021-01-21 | Angola | 19177 | 448 | 17176 | 1553 | -11.2027 | 17.8739 | 2021-01-22 05:22:10 | Angola | |||
1097484 | 1097484 | 2021-01-20 | US | Virginia | Salem | 51775 | 1585 | 32 | 0 | 1553 | 37.2836193 | -80.06219455 | 2021-01-21 05:22:01 | Salem, Virginia, US |
1094904 | 1094904 | 2021-01-20 | US | Georgia | Jefferson | 13163 | 1600 | 47 | 0 | 1553 | 33.05867328 | -82.41609057 | 2021-01-21 05:22:01 | Jefferson, Georgia, US |
238763 | 238763 | 2021-01-18 | US | Louisiana | St. James | 22093 | 1598 | 45 | 0 | 1553 | 30.02531716 | -90.80212061 | 2021-01-19 05:22:15 | St. James, Louisiana, US |
3518918 | 3518918 | 2021-01-15 | US | Wisconsin | Adams | 55001 | 1566 | 13 | 0 | 1553 | 43.96974651 | -89.76782777 | 2021-01-16 05:22:40 | Adams, Wisconsin, US |
3880412 | 3880412 | 2021-01-14 | US | Georgia | Mitchell | 13205 | 1612 | 59 | 0 | 1553 | 31.22483255 | -84.19381821 | 2021-01-15 05:22:24 | Mitchell, Georgia, US |
3879922 | 3879922 | 2021-01-14 | US | Alabama | Cherokee | 1019 | 1583 | 30 | 0 | 1553 | 34.17805983 | -85.60638968 | 2021-01-15 05:22:24 | Cherokee, Alabama, US |
775934 | 775934 | 2021-01-12 | US | Massachusetts | Dukes and Nantucket | 1555 | 2 | 0 | 1553 | 41.40674725 | -70.68763497 | 2021-01-13 05:22:15 | Dukes and Nantucket, Massachusetts, US | |
3900430 | 3900430 | 2021-01-09 | US | Arkansas | Cross | 5037 | 1590 | 37 | 0 | 1553 | 35.29631396 | -90.77185818 | 2021-01-10 05:22:12 | Cross, Arkansas, US |
2541419 | 2541419 | 2021-01-07 | Japan | Hyogo | 11193 | 254 | 9386 | 1553 | 35.039913 | 134.828057 | 2021-01-08 05:22:42 | Hyogo, Japan | ||
2866943 | 2866943 | 2021-01-06 | US | New York | Greene | 36039 | 1584 | 31 | 0 | 1553 | 42.275797 | -74.12384884 | 2021-01-07 05:22:03 | Greene, New York, US |
1061691 | 1061691 | 2021-01-04 | Colombia | Cesar | 33795 | 1000 | 31242 | 1553 | 9.3373 | -73.6536 | 2021-01-05 05:21:49 | Cesar, Colombia | ||
3233868 | 3233868 | 2021-01-03 | US | Virginia | York | 51199 | 1566 | 13 | 0 | 1553 | 37.24374789 | -76.54412815 | 2021-01-04 05:22:02 | York, Virginia, US |
2225367 | 2225367 | 2020-12-26 | US | Missouri | Audrain | 29007 | 1584 | 31 | 0 | 1553 | 39.215877 | -91.84242683 | 2020-12-27 05:22:55 | Audrain, Missouri, US |
3769947 | 3769947 | 2020-12-22 | Malta | 11910 | 196 | 10161 | 1553 | 35.9375 | 14.3754 | 2020-12-23 05:22:03 | Malta | |||
928455 | 928455 | 2020-12-21 | US | Georgia | Chattooga | 13055 | 1596 | 43 | 0 | 1553 | 34.47197698 | -85.34535662 | 2020-12-22 05:22:33 | Chattooga, Georgia, US |
2933805 | 2933805 | 2020-12-19 | US | Oklahoma | Seminole | 40133 | 1568 | 15 | 0 | 1553 | 35.16478725 | -96.61686741 | 2020-12-20 05:27:32 | Seminole, Oklahoma, US |
2932395 | 2932395 | 2020-12-19 | US | Iowa | Delaware | 19055 | 1581 | 28 | 0 | 1553 | 42.47104597 | -91.3664492 | 2020-12-20 05:27:32 | Delaware, Iowa, US |
2931291 | 2931291 | 2020-12-19 | Malta | 11621 | 187 | 9881 | 1553 | 35.9375 | 14.3754 | 2020-12-20 05:27:32 | Malta | |||
1901767 | 1901767 | 2020-12-18 | US | Colorado | Crowley | 8025 | 1597 | 13 | 0 | 1553 | 38.32608609 | -103.7844965 | 2020-12-19 05:27:52 | Crowley, Colorado, US |
1901549 | 1901549 | 2020-12-18 | US | Alabama | Marengo | 1091 | 1579 | 26 | 0 | 1553 | 32.24767634 | -87.78796182 | 2020-12-19 05:27:52 | Marengo, Alabama, US |
2129524 | 2129524 | 2020-12-17 | US | Louisiana | Union | 22111 | 1615 | 62 | 0 | 1553 | 32.83121059 | -92.3749373 | 2020-12-18 05:28:18 | Union, Louisiana, US |
3151380 | 3151380 | 2020-12-16 | US | Mississippi | Covington | 28031 | 1615 | 62 | 0 | 1553 | 31.63225413 | -89.55389939 | 2020-12-17 05:28:12 | Covington, Mississippi, US |
849234 | 849234 | 2020-12-12 | Zimbabwe | 11219 | 307 | 9359 | 1553 | -19.015438 | 29.154857 | 2020-12-13 05:27:20 | Zimbabwe | |||
848517 | 848517 | 2020-12-12 | US | Tennessee | Johnson | 47091 | 1580 | 25 | 0 | 1553 | 36.45523950000001 | -81.84886538 | 2020-12-13 05:27:20 | Johnson, Tennessee, US |
863624 | 863624 | 2020-12-11 | US | Tennessee | Johnson | 47091 | 1565 | 25 | 0 | 1553 | 36.45523950000001 | -81.84886538 | 2020-12-12 05:26:19 | Johnson, Tennessee, US |
1601732 | 1601732 | 2020-12-10 | US | Louisiana | Pointe Coupee | 22077 | 1604 | 51 | 0 | 1553 | 30.71409502 | -91.60209535 | 2020-12-11 05:26:59 | Pointe Coupee, Louisiana, US |
1007044 | 1007044 | 2020-12-06 | US | Georgia | Bryan | 13029 | 1571 | 18 | 0 | 1553 | 32.00979311 | -81.44002948 | 2020-12-07 05:26:14 | Bryan, Georgia, US |
1635728 | 1635728 | 2020-12-05 | US | Washington | Cowlitz | 53015 | 1567 | 14 | 0 | 1553 | 46.19074721 | -122.6782231 | 2020-12-06 05:26:18 | Cowlitz, Washington, US |
3861935 | 3861935 | 2020-12-04 | US | Nebraska | Saline | 31151 | 1556 | 3 | 0 | 1553 | 40.52418865 | -97.14085859 | 2020-12-05 05:27:36 | Saline, Nebraska, US |
3860381 | 3860381 | 2020-12-04 | US | California | Mendocino | 6045 | 1576 | 23 | 0 | 1553 | 39.4381191 | -123.3911313 | 2020-12-05 05:27:36 | Mendocino, California, US |
2937179 | 2937179 | 2020-11-28 | US | Missouri | Saline | 29195 | 1565 | 12 | 0 | 1553 | 39.13734288 | -93.20259964 | 2020-11-29 05:25:55 | Saline, Missouri, US |
2936684 | 2936684 | 2020-11-28 | US | Kentucky | Pulaski | 21199 | 1566 | 13 | 0 | 1553 | 37.10466131 | -84.57629079 | 2020-11-29 05:25:55 | Pulaski, Kentucky, US |
2935250 | 2935250 | 2020-11-28 | Japan | Kanagawa | 12321 | 194 | 10574 | 1553 | 35.415312 | 139.338983 | 2020-11-29 05:25:55 | Kanagawa, Japan | ||
926598 | 926598 | 2020-11-26 | US | Tennessee | Cocke | 47029 | 1576 | 30 | 0 | 1553 | 35.9278914 | -83.11828725 | 2020-11-27 05:26:53 | Cocke, Tennessee, US |
1975561 | 1975561 | 2020-11-25 | US | Tennessee | Rhea | 47143 | 1565 | 30 | 0 | 1553 | 35.60536161 | -84.93076643 | 2020-11-26 05:27:44 | Rhea, Tennessee, US |
1353151 | 1353151 | 2020-11-24 | US | South Carolina | Williamsburg | 45089 | 1603 | 50 | 0 | 1553 | 33.62190129 | -79.72767442 | 2020-11-25 05:27:20 | Williamsburg, South Carolina, US |
1351457 | 1351457 | 2020-11-24 | US | Indiana | Wabash | 18169 | 1580 | 27 | 0 | 1553 | 40.84704239 | -85.79328272 | 2020-11-25 05:27:20 | Wabash, Indiana, US |
3837536 | 3837536 | 2020-11-21 | US | Indiana | Adams | 18001 | 1574 | 21 | 0 | 1553 | 40.7457653 | -84.93671406 | 2020-11-22 05:25:45 | Adams, Indiana, US |
822665 | 822665 | 2020-11-19 | US | Indiana | Knox | 18083 | 1584 | 31 | 0 | 1553 | 38.68861576 | -87.4194665 | 2020-11-20 05:26:28 | Knox, Indiana, US |
123103 | 123103 | 2020-11-18 | US | Alabama | Tallapoosa | 1123 | 1642 | 89 | 0 | 1553 | 32.86698258 | -85.79833053 | 2020-11-19 05:25:23 | Tallapoosa, Alabama, US |
3341094 | 3341094 | 2020-11-17 | US | Ohio | Shelby | 39149 | 1570 | 17 | 0 | 1553 | 40.33163494 | -84.20258189 | 2020-11-18 05:40:31 | Shelby, Ohio, US |
2882115 | 2882115 | 2020-11-15 | US | Missouri | Lawrence | 29109 | 1585 | 32 | 0 | 1553 | 37.10626634 | -93.83293097 | 2020-11-16 05:25:57 | Lawrence, Missouri, US |
2917093 | 2917093 | 2020-11-14 | US | Missouri | Lawrence | 29109 | 1585 | 32 | 0 | 1553 | 37.10626634 | -93.83293097 | 2020-11-15 05:26:53 | Lawrence, Missouri, US |
2785879 | 2785879 | 2020-11-13 | US | Georgia | Toombs | 13279 | 1615 | 62 | 0 | 1553 | 32.12059861 | -82.32957247 | 2020-11-14 05:25:37 | Toombs, Georgia, US |
272083 | 272083 | 2020-11-10 | Guinea | 12484 | 74 | 10857 | 1553 | 9.9456 | -9.6966 | 2020-11-11 05:25:30 | Guinea | |||
3411174 | 3411174 | 2020-11-01 | US | Minnesota | Mower | 27099 | 1572 | 19 | 0 | 1553 | 43.67142874 | -92.75234549 | 2020-11-02 05:25:04 | Mower, Minnesota, US |
2245880 | 2245880 | 2020-10-30 | US | Ohio | Richland | 39139 | 1582 | 29 | 0 | 1553 | 40.77180308 | -82.53799609999999 | 2020-10-31 04:24:44 | Richland, Ohio, US |
1455579 | 1455579 | 2020-10-27 | US | Tennessee | Weakley | 47183 | 1588 | 26 | 0 | 1553 | 36.29896232 | -88.71990865 | 2020-10-28 04:24:39 | Weakley, Tennessee, US |
1455530 | 1455530 | 2020-10-27 | US | Tennessee | Jefferson | 47089 | 1565 | 22 | 0 | 1553 | 36.04818632 | -83.45148924 | 2020-10-28 04:24:39 | Jefferson, Tennessee, US |
10499 | 10499 | 2020-10-25 | US | New Jersey | Sussex | 34037 | 1750 | 197 | 0 | 1553 | 41.13891592 | -74.69118243 | 2020-10-26 04:25:02 | Sussex, New Jersey, US |
1797621 | 1797621 | 2020-10-19 | US | Tennessee | Wayne | 47181 | 1567 | 7 | 0 | 1553 | 35.23868267 | -87.78644456 | 2020-10-20 04:24:22 | Wayne, Tennessee, US |
765213 | 765213 | 2020-10-18 | US | Tennessee | Bedford | 47003 | 1570 | 20 | 0 | 1553 | 35.51123746 | -86.45549096 | 2020-10-19 04:24:16 | Bedford, Tennessee, US |
764059 | 764059 | 2020-10-18 | US | Minnesota | Rice | 27131 | 1562 | 9 | 0 | 1553 | 44.3543376 | -93.29658715 | 2020-10-19 04:24:16 | Rice, Minnesota, US |
786108 | 786108 | 2020-10-15 | Brazil | Acre | 29406 | 677 | 27176 | 1553 | -9.0238 | -70.812 | 2020-10-16 04:24:01 | Acre, Brazil | ||
2291653 | 2291653 | 2020-10-12 | Russia | Kostroma Oblast | 5501 | 90 | 3858 | 1553 | 58.424756 | 44.2533273 | 2020-10-13 04:24:02 | Kostroma Oblast, Russia | ||
1043639 | 1043639 | 2020-10-07 | US | Mississippi | Neshoba | 28099 | 1661 | 108 | 0 | 1553 | 32.75339664 | -89.11726492 | 2020-10-08 04:23:56 | Neshoba, Mississippi, US |
2514684 | 2514684 | 2020-10-03 | US | Arkansas | St. Francis | 5123 | 1559 | 6 | 0 | 1553 | 35.02201976 | -90.74828138 | 2020-10-04 04:23:44 | St. Francis, Arkansas, US |
3390097 | 3390097 | 2020-10-02 | US | Florida | Okeechobee | 12093 | 1581 | 28 | 0 | 1553 | 27.386336199999995 | -80.88944347 | 2020-10-03 04:23:40 | Okeechobee, Florida, US |
2382080 | 2382080 | 2020-10-01 | US | Ohio | Greene | 39057 | 1589 | 36 | 0 | 1553 | 39.69116283 | -83.89032084 | 2020-10-02 04:23:51 | Greene, Ohio, US |
2380507 | 2380507 | 2020-10-01 | US | Georgia | Walker | 13295 | 1591 | 38 | 0 | 1553 | 34.73376362 | -85.30165174 | 2020-10-02 04:23:51 | Walker, Georgia, US |
1048397 | 1048397 | 2020-09-30 | US | Oklahoma | Texas | 40139 | 1563 | 10 | 0 | 1553 | 36.74777635 | -101.4889765 | 2020-10-01 04:23:42 | Texas, Oklahoma, US |
2582326 | 2582326 | 2020-09-27 | US | Alabama | Chilton | 1021 | 1583 | 30 | 0 | 1553 | 32.85044126 | -86.7173256 | 2020-09-28 04:23:00 | Chilton, Alabama, US |
2839096 | 2839096 | 2020-09-21 | US | North Carolina | Caldwell | 37027 | 1571 | 18 | 0 | 1553 | 35.95204977 | -81.54799522 | 2020-09-22 04:23:00 | Caldwell, North Carolina, US |
3094413 | 3094413 | 2020-09-20 | US | Illinois | LaSalle | 17099 | 1608 | 55 | 0 | 1553 | 41.3442613 | -88.88633881 | 2020-09-21 04:23:00 | LaSalle, Illinois, US |
2850414 | 2850414 | 2020-09-18 | US | Maryland | Washington | 24043 | 1589 | 36 | 0 | 1553 | 39.60835778 | -77.82002295 | 2020-09-19 04:22:00 | Washington, Maryland, US |
666650 | 666650 | 2020-09-16 | US | Alabama | Lauderdale | 1077 | 1584 | 31 | 0 | 1553 | 34.90171875 | -87.65624729 | 2020-09-17 04:22:00 | Lauderdale, Alabama, US |
1445053 | 1445053 | 2020-09-11 | US | Arkansas | Garland | 5051 | 1589 | 36 | 0 | 1553 | 34.57692074 | -93.14921604 | 2020-09-12 04:25:05 | Garland, Arkansas, US |
429569 | 429569 | 2020-09-07 | US | New York | Niagara | 36063 | 1654 | 101 | 0 | 1553 | 43.19898042 | -78.74777412 | 2020-09-08 04:28:25 | Niagara, New York, US |
195102 | 195102 | 2020-08-31 | US | Illinois | Unassigned | 90017 | 1762 | 209 | 0 | 1553 | 42.36542373 | 0.0 | 2020-09-01 04:28:31 | Unassigned, Illinois, US |
3935024 | 3935024 | 2020-08-30 | US | Texas | Bastrop | 48021 | 1698 | 27 | 0 | 1553 | 30.10370699 | -97.31206354 | 2020-08-31 04:28:27 | Bastrop, Texas, US |
3562798 | 3562798 | 2020-08-25 | Russia | Orenburg Oblast | 9437 | 72 | 7812 | 1553 | 52.02692620000001 | 54.7276647 | 2020-08-26 04:28:11 | Orenburg 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]);