johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
170 rows where active = 1547 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3741146 | 3741146 | 2021-07-12 | Luxembourg | 72257 | 819 | 69891 | 1547 | 49.8153 | 6.1296 | 2021-07-13 04:21:18 | Luxembourg | |||
3663233 | 3663233 | 2021-07-11 | Ukraine | Sevastopol* | 17919 | 776 | 15596 | 1547 | 44.6054 | 33.522 | 2021-07-12 04:21:34 | Sevastopol*, Ukraine | ||
2884157 | 2884157 | 2021-06-20 | Chile | Los Rios | 43603 | 507 | 41549 | 1547 | -40.231 | -72.3311 | 2021-06-21 04:21:41 | Los Rios, Chile | ||
523118 | 523118 | 2021-06-09 | Russia | Voronezh Oblast | 86231 | 3059 | 81625 | 1547 | 50.9800393 | 40.15065070000001 | 2021-06-10 04:23:17 | Voronezh Oblast, Russia | ||
3054144 | 3054144 | 2021-05-13 | India | Ladakh | 15916 | 161 | 14208 | 1547 | 34.1526 | 77.5771 | 2021-05-14 04:20:41 | Ladakh, India | ||
2004614 | 2004614 | 2021-05-12 | India | Ladakh | 15807 | 158 | 14102 | 1547 | 34.1526 | 77.5771 | 2021-05-13 04:20:51 | Ladakh, India | ||
380457 | 380457 | 2021-04-30 | Rwanda | 25116 | 335 | 23234 | 1547 | -1.9403 | 29.8739 | 2021-05-01 04:20:47 | Rwanda | |||
888308 | 888308 | 2021-04-26 | Russia | Belgorod Oblast | 36462 | 623 | 34292 | 1547 | 50.7080119 | 37.5837615 | 2021-04-27 04:20:52 | Belgorod Oblast, Russia | ||
1409244 | 1409244 | 2021-04-23 | Russia | Kaliningrad Oblast | 31396 | 385 | 29464 | 1547 | 54.7293041 | 21.1489473 | 2021-04-24 04:20:38 | Kaliningrad Oblast, Russia | ||
1223232 | 1223232 | 2021-03-27 | Yemen | 3969 | 832 | 1590 | 1547 | 15.552727 | 48.516388 | 2021-03-28 05:28:10 | Yemen | |||
3421115 | 3421115 | 2021-03-19 | Russia | Ingushetia Republic | 14994 | 180 | 13267 | 1547 | 43.11542075 | 45.01713552 | 2021-03-20 05:25:46 | Ingushetia Republic, Russia | ||
3452703 | 3452703 | 2021-03-18 | Colombia | Cundinamarca | 108695 | 2997 | 104151 | 1547 | 5.026 | -74.03 | 2021-03-19 05:26:09 | Cundinamarca, Colombia | ||
3621277 | 3621277 | 2021-03-17 | Russia | Ingushetia Republic | 14968 | 179 | 13242 | 1547 | 43.11542075 | 45.01713552 | 2021-03-18 05:26:22 | Ingushetia Republic, Russia | ||
3670667 | 3670667 | 2021-03-06 | US | Texas | Colorado | 48089 | 1599 | 25 | 0 | 1547 | 29.622098 | -96.5273805 | 2021-03-07 05:21:54 | Colorado, Texas, US |
3667625 | 3667625 | 2021-03-06 | Japan | Chiba | 27188 | 475 | 25166 | 1547 | 35.510141 | 140.198917 | 2021-03-07 05:21:54 | Chiba, Japan | ||
2367958 | 2367958 | 2021-02-28 | US | Arkansas | Chicot | 5017 | 1585 | 38 | 0 | 1547 | 33.26458973 | -91.29539209 | 2021-03-01 05:23:01 | Chicot, Arkansas, US |
3067779 | 3067779 | 2021-02-27 | US | Mississippi | Calhoun | 28013 | 1575 | 28 | 0 | 1547 | 33.93683395 | -89.33686647 | 2021-02-28 05:22:20 | Calhoun, Mississippi, US |
3066460 | 3066460 | 2021-02-27 | US | Arkansas | Chicot | 5017 | 1587 | 40 | 0 | 1547 | 33.26458973 | -91.29539209 | 2021-02-28 05:22:20 | Chicot, Arkansas, US |
534158 | 534158 | 2021-02-22 | US | Washington | Stevens | 53065 | 1570 | 23 | 0 | 1547 | 48.40035475 | -117.8542701 | 2021-02-23 05:23:41 | Stevens, Washington, US |
531753 | 531753 | 2021-02-22 | US | Illinois | Washington | 17189 | 1570 | 23 | 0 | 1547 | 38.35309213 | -89.40982703 | 2021-02-23 05:23:41 | Washington, Illinois, US |
183087 | 183087 | 2021-02-21 | US | Illinois | Washington | 17189 | 1570 | 23 | 0 | 1547 | 38.35309213 | -89.40982703 | 2021-02-22 05:24:21 | Washington, Illinois, US |
743361 | 743361 | 2021-02-20 | US | Illinois | Washington | 17189 | 1570 | 23 | 0 | 1547 | 38.35309213 | -89.40982703 | 2021-02-21 05:24:33 | Washington, Illinois, US |
472490 | 472490 | 2021-02-19 | US | Indiana | Franklin | 18047 | 1582 | 35 | 0 | 1547 | 39.4142482 | -85.06062647 | 2021-02-20 05:22:51 | Franklin, Indiana, US |
1338950 | 1338950 | 2021-02-15 | US | Florida | Calhoun | 12013 | 1584 | 37 | 0 | 1547 | 30.40666734 | -85.19394153 | 2021-02-16 05:24:38 | Calhoun, Florida, US |
2678501 | 2678501 | 2021-02-13 | US | Florida | Calhoun | 12013 | 1583 | 36 | 0 | 1547 | 30.40666734 | -85.19394153 | 2021-02-14 05:23:43 | Calhoun, Florida, US |
2640300 | 2640300 | 2021-02-11 | US | Oklahoma | Pawnee | 40117 | 1575 | 28 | 0 | 1547 | 36.31743373 | -96.7033176 | 2021-02-12 05:23:29 | Pawnee, Oklahoma, US |
2638297 | 2638297 | 2021-02-11 | US | California | Siskiyou | 6093 | 1529 | 4 | 0 | 1547 | 41.59198861 | -122.5407434 | 2021-02-12 05:23:29 | Siskiyou, California, US |
1460949 | 1460949 | 2021-01-31 | US | Iowa | Harrison | 19085 | 1612 | 65 | 0 | 1547 | 41.68330137 | -95.81558439 | 2021-02-01 05:22:53 | Harrison, Iowa, US |
1460146 | 1460146 | 2021-01-31 | US | Alabama | Monroe | 1099 | 1569 | 22 | 0 | 1547 | 31.56729412 | -87.36995001 | 2021-02-01 05:22:53 | Monroe, Alabama, US |
2215144 | 2215144 | 2021-01-30 | US | West Virginia | Jackson | 54035 | 1592 | 45 | 0 | 1547 | 38.84263974 | -81.68148753 | 2021-01-31 05:22:42 | Jackson, West Virginia, US |
1897970 | 1897970 | 2021-01-29 | US | Georgia | Jeff Davis | 13161 | 1585 | 38 | 0 | 1547 | 31.80405727 | -82.63724870000001 | 2021-01-30 05:22:49 | Jeff Davis, Georgia, US |
1897927 | 1897927 | 2021-01-29 | US | Georgia | Cook | 13075 | 1581 | 34 | 0 | 1547 | 31.16068491 | -83.42947229 | 2021-01-30 05:22:49 | Cook, Georgia, US |
2483086 | 2483086 | 2021-01-28 | US | Indiana | Perry | 18123 | 1578 | 31 | 0 | 1547 | 38.07809328 | -86.63741946 | 2021-01-29 05:22:23 | Perry, Indiana, US |
2568853 | 2568853 | 2021-01-25 | US | Iowa | Hardin | 19083 | 1578 | 31 | 0 | 1547 | 42.38353877 | -93.23654611 | 2021-01-26 05:22:02 | Hardin, Iowa, US |
2467435 | 2467435 | 2021-01-22 | US | Colorado | Montezuma | 8083 | 1649 | 20 | 0 | 1547 | 37.33859579 | -108.5958857 | 2021-01-23 05:22:03 | Montezuma, Colorado, US |
1095133 | 1095133 | 2021-01-20 | US | Illinois | Warren | 17187 | 1588 | 41 | 0 | 1547 | 40.84925021 | -90.6147432 | 2021-01-21 05:22:01 | Warren, Illinois, US |
911542 | 911542 | 2021-01-19 | US | Virginia | Mecklenburg | 51117 | 1590 | 43 | 0 | 1547 | 36.67882005 | -78.36131056 | 2021-01-20 05:21:54 | Mecklenburg, Virginia, US |
910455 | 910455 | 2021-01-19 | US | North Carolina | Ashe | 37009 | 1575 | 28 | 0 | 1547 | 36.43296207 | -81.49862729 | 2021-01-20 05:21:54 | Ashe, North Carolina, US |
3104351 | 3104351 | 2021-01-16 | US | Tennessee | Cannon | 47015 | 1577 | 19 | 0 | 1547 | 35.80990797 | -86.05738983 | 2021-01-17 05:22:17 | Cannon, Tennessee, US |
3102915 | 3102915 | 2021-01-16 | US | Kentucky | Woodford | 21239 | 1551 | 4 | 0 | 1547 | 38.04178222 | -84.7417556 | 2021-01-17 05:22:17 | Woodford, Kentucky, US |
3517300 | 3517300 | 2021-01-15 | US | Missouri | Henry | 29083 | 1572 | 25 | 0 | 1547 | 38.38482826 | -93.79293734 | 2021-01-16 05:22:40 | Henry, Missouri, US |
3883090 | 3883090 | 2021-01-14 | US | Wisconsin | Adams | 55001 | 1560 | 13 | 0 | 1547 | 43.96974651 | -89.76782777 | 2021-01-15 05:22:24 | Adams, Wisconsin, US |
3881853 | 3881853 | 2021-01-14 | US | North Carolina | Avery | 37011 | 1563 | 16 | 0 | 1547 | 36.07569796 | -81.92308483 | 2021-01-15 05:22:24 | Avery, North Carolina, US |
3309766 | 3309766 | 2021-01-13 | US | Maryland | Caroline | 24011 | 1560 | 13 | 0 | 1547 | 38.87172293 | -75.82904158 | 2021-01-14 05:22:32 | Caroline, Maryland, US |
191655 | 191655 | 2021-01-11 | US | Massachusetts | Dukes and Nantucket | 1549 | 2 | 0 | 1547 | 41.40674725 | -70.68763497 | 2021-01-12 05:22:15 | Dukes and Nantucket, Massachusetts, US | |
3900463 | 3900463 | 2021-01-09 | US | Arkansas | Ouachita | 5103 | 1582 | 35 | 0 | 1547 | 33.58839816 | -92.87795984 | 2021-01-10 05:22:12 | Ouachita, Arkansas, US |
154221 | 154221 | 2021-01-08 | Russia | Ryazan Oblast | 19228 | 181 | 17500 | 1547 | 54.42267320000001 | 40.57052460000001 | 2021-01-09 05:22:18 | Ryazan Oblast, Russia | ||
2866093 | 2866093 | 2021-01-06 | US | Kentucky | Clark | 21049 | 1562 | 15 | 0 | 1547 | 37.9689263 | -84.14615986 | 2021-01-07 05:22:03 | Clark, Kentucky, US |
2865209 | 2865209 | 2021-01-06 | US | Arkansas | Logan | 5083 | 1560 | 13 | 0 | 1547 | 35.21413234 | -93.71951016 | 2021-01-07 05:22:03 | Logan, Arkansas, US |
3035379 | 3035379 | 2021-01-05 | US | Indiana | Fountain | 18045 | 1579 | 32 | 0 | 1547 | 40.12361933 | -87.24217689 | 2021-01-06 05:22:16 | Fountain, Indiana, US |
3233797 | 3233797 | 2021-01-03 | US | Virginia | Isle of Wight | 51093 | 1576 | 29 | 0 | 1547 | 36.90579348 | -76.70842863 | 2021-01-04 05:22:02 | Isle of Wight, Virginia, US |
2228737 | 2228737 | 2021-01-02 | US | Iowa | O'Brien | 19141 | 1600 | 53 | 0 | 1547 | 43.08310673 | -95.62474482 | 2021-01-03 05:22:52 | O'Brien, Iowa, US |
3696242 | 3696242 | 2020-12-31 | US | Georgia | Burke | 13033 | 1567 | 20 | 0 | 1547 | 33.05917989 | -81.99928721 | 2021-01-01 05:23:07 | Burke, Georgia, US |
1011263 | 1011263 | 2020-12-30 | US | Illinois | Cass | 17017 | 1566 | 19 | 0 | 1547 | 39.96991073 | -90.24734436 | 2020-12-31 05:22:49 | Cass, Illinois, US |
1010311 | 1010311 | 2020-12-30 | Japan | Fukuoka | 8773 | 119 | 7107 | 1547 | 33.526032 | 130.666949 | 2020-12-31 05:22:49 | Fukuoka, Japan | ||
3765020 | 3765020 | 2020-12-28 | US | Washington | Kittitas | 53037 | 1571 | 24 | 0 | 1547 | 47.12521214 | -120.679439 | 2020-12-29 05:22:37 | Kittitas, Washington, US |
3764723 | 3764723 | 2020-12-28 | US | Texas | Lamb | 48279 | 2043 | 63 | 0 | 1547 | 34.06859623 | -102.3516289 | 2020-12-29 05:22:37 | Lamb, Texas, US |
3763511 | 3763511 | 2020-12-28 | US | Missouri | New Madrid | 29143 | 1576 | 29 | 0 | 1547 | 36.59666326 | -89.66070007 | 2020-12-29 05:22:37 | New Madrid, Missouri, US |
3781043 | 3781043 | 2020-12-27 | US | Texas | Lamb | 48279 | 2035 | 63 | 0 | 1547 | 34.06859623 | -102.3516289 | 2020-12-28 05:22:06 | Lamb, Texas, US |
3780822 | 3780822 | 2020-12-27 | US | Tennessee | Crockett | 47033 | 1599 | 29 | 0 | 1547 | 35.81830662 | -89.14916269 | 2020-12-28 05:22:06 | Crockett, Tennessee, US |
3780166 | 3780166 | 2020-12-27 | US | New York | Tioga | 36107 | 1601 | 54 | 0 | 1547 | 42.16852837 | -76.30835812 | 2020-12-28 05:22:06 | Tioga, New York, US |
2226648 | 2226648 | 2020-12-26 | US | Texas | Lamb | 48279 | 2033 | 63 | 0 | 1547 | 34.06859623 | -102.3516289 | 2020-12-27 05:22:55 | Lamb, Texas, US |
205670 | 205670 | 2020-12-25 | US | Virginia | Winchester | 51840 | 1555 | 8 | 0 | 1547 | 39.17054517 | -78.17325058 | 2020-12-26 05:22:28 | Winchester, Virginia, US |
205395 | 205395 | 2020-12-25 | US | Texas | Lamb | 48279 | 2030 | 63 | 0 | 1547 | 34.06859623 | -102.3516289 | 2020-12-26 05:22:28 | Lamb, Texas, US |
3694618 | 3694618 | 2020-12-24 | US | Texas | Lamb | 48279 | 2015 | 63 | 0 | 1547 | 34.06859623 | -102.3516289 | 2020-12-25 05:22:48 | Lamb, Texas, US |
931218 | 931218 | 2020-12-21 | US | Wisconsin | Crawford | 55023 | 1558 | 11 | 0 | 1547 | 43.23870316 | -90.93073686 | 2020-12-22 05:22:33 | Crawford, Wisconsin, US |
931165 | 931165 | 2020-12-21 | US | West Virginia | Hancock | 54029 | 1567 | 20 | 0 | 1547 | 40.51943859 | -80.57461608 | 2020-12-22 05:22:33 | Hancock, West Virginia, US |
2122515 | 2122515 | 2020-12-20 | US | South Carolina | Clarendon | 45027 | 1621 | 74 | 0 | 1547 | 33.66610974 | -80.21647898 | 2020-12-21 05:27:58 | Clarendon, South Carolina, US |
2121264 | 2121264 | 2020-12-20 | US | Maine | Penobscot | 23019 | 1563 | 16 | 0 | 1547 | 45.40194593 | -68.65020455 | 2020-12-21 05:27:58 | Penobscot, Maine, US |
2934068 | 2934068 | 2020-12-19 | US | South Dakota | Clay | 46027 | 1558 | 11 | 0 | 1547 | 42.91296147 | -96.97656917 | 2020-12-20 05:27:32 | Clay, South Dakota, US |
2932972 | 2932972 | 2020-12-19 | US | Minnesota | Roseau | 27135 | 1560 | 13 | 0 | 1547 | 48.77501878 | -95.81079919 | 2020-12-20 05:27:32 | Roseau, Minnesota, US |
1904608 | 1904608 | 2020-12-18 | US | Washington | Okanogan | 53047 | 1573 | 26 | 0 | 1547 | 48.54855019 | -119.7387224 | 2020-12-19 05:27:52 | Okanogan, Washington, US |
2130510 | 2130510 | 2020-12-17 | US | Oklahoma | Adair | 40001 | 1560 | 13 | 0 | 1547 | 35.88494195 | -94.65859267 | 2020-12-18 05:28:18 | Adair, Oklahoma, US |
3151949 | 3151949 | 2020-12-16 | US | North Carolina | Stokes | 37169 | 1570 | 23 | 0 | 1547 | 36.4017975 | -80.23893369 | 2020-12-17 05:28:12 | Stokes, North Carolina, US |
1035853 | 1035853 | 2020-12-15 | US | Louisiana | Beauregard | 22011 | 1597 | 50 | 0 | 1547 | 30.64836518 | -93.34173616 | 2020-12-16 05:28:04 | Beauregard, Louisiana, US |
1035180 | 1035180 | 2020-12-15 | US | Georgia | Haralson | 13143 | 1580 | 33 | 0 | 1547 | 33.79602175 | -85.21005667 | 2020-12-16 05:28:04 | Haralson, Georgia, US |
1753374 | 1753374 | 2020-12-14 | US | Nebraska | Saunders | 31155 | 1556 | 9 | 0 | 1547 | 41.2278103 | -96.63773905 | 2020-12-15 05:26:38 | Saunders, Nebraska, US |
3848459 | 3848459 | 2020-12-13 | US | Florida | Bradford | 12007 | 1569 | 22 | 0 | 1547 | 29.95079741 | -82.16611613 | 2020-12-14 05:26:27 | Bradford, Florida, US |
3847632 | 3847632 | 2020-12-13 | Colombia | Cesar | 31048 | 941 | 28560 | 1547 | 9.3373 | -73.6536 | 2020-12-14 05:26:27 | Cesar, Colombia | ||
2978611 | 2978611 | 2020-12-09 | US | Virginia | Prince George | 51149 | 1554 | 7 | 0 | 1547 | 37.18497668 | -77.22922187 | 2020-12-10 05:26:19 | Prince George, Virginia, US |
1822452 | 1822452 | 2020-12-08 | Zimbabwe | 10912 | 303 | 9062 | 1547 | -19.015438 | 29.154857 | 2020-12-09 05:28:01 | Zimbabwe | |||
1009958 | 1009958 | 2020-12-06 | Zimbabwe | 10718 | 291 | 8880 | 1547 | -19.015438 | 29.154857 | 2020-12-07 05:26:14 | Zimbabwe | |||
1007526 | 1007526 | 2020-12-06 | US | Iowa | Tama | 19171 | 1589 | 42 | 0 | 1547 | 42.07991767 | -92.53266945 | 2020-12-07 05:26:14 | Tama, Iowa, US |
738823 | 738823 | 2020-12-02 | US | Arkansas | Union | 5139 | 1606 | 59 | 0 | 1547 | 33.16887091 | -92.59746952 | 2020-12-03 05:28:22 | Union, Arkansas, US |
395551 | 395551 | 2020-11-27 | US | Virginia | Danville | 51590 | 1597 | 50 | 0 | 1547 | 36.58022376 | -79.40395668 | 2020-11-28 05:25:50 | Danville, Virginia, US |
392232 | 392232 | 2020-11-27 | Italy | Valle d'Aosta | 6344 | 302 | 4495 | 1547 | 45.73750286 | 7.320149366 | 2020-11-28 05:25:50 | Valle d'Aosta, Italy | ||
3839421 | 3839421 | 2020-11-21 | US | Tennessee | Haywood | 47075 | 1570 | 29 | 0 | 1547 | 35.58332824 | -89.28536625 | 2020-11-22 05:25:45 | Haywood, Tennessee, US |
2703788 | 2703788 | 2020-11-20 | US | North Carolina | Beaufort | 37013 | 1600 | 53 | 0 | 1547 | 35.48531943 | -76.84325809 | 2020-11-21 05:25:51 | Beaufort, North Carolina, US |
2701772 | 2701772 | 2020-11-20 | Russia | Zabaykalsky Krai | 16558 | 252 | 14759 | 1547 | 52.248521 | 115.956325 | 2020-11-21 05:25:51 | Zabaykalsky Krai, Russia | ||
3338937 | 3338937 | 2020-11-17 | US | Alabama | Chambers | 1017 | 1595 | 48 | 0 | 1547 | 32.91360079 | -85.39072749 | 2020-11-18 05:40:31 | Chambers, Alabama, US |
2918526 | 2918526 | 2020-11-14 | US | Virginia | Henry | 51089 | 1584 | 37 | 0 | 1547 | 36.68542395 | -79.87634026 | 2020-11-15 05:26:53 | Henry, Virginia, US |
2918386 | 2918386 | 2020-11-14 | US | Texas | San Patricio | 48409 | 1898 | 83 | 0 | 1547 | 28.00880118 | -97.51763891 | 2020-11-15 05:26:53 | San Patricio, Texas, US |
2788208 | 2788208 | 2020-11-13 | US | Texas | San Patricio | 48409 | 1898 | 83 | 0 | 1547 | 28.00880118 | -97.51763891 | 2020-11-14 05:25:37 | San Patricio, Texas, US |
2786214 | 2786214 | 2020-11-13 | US | Iowa | Marion | 19125 | 1562 | 15 | 0 | 1547 | 41.33445101 | -93.09934783 | 2020-11-14 05:25:37 | Marion, Iowa, US |
867973 | 867973 | 2020-11-12 | US | Texas | San Patricio | 48409 | 1884 | 83 | 0 | 1547 | 28.00880118 | -97.51763891 | 2020-11-13 05:25:30 | San Patricio, Texas, US |
865701 | 865701 | 2020-11-12 | US | Idaho | Jerome | 16053 | 1556 | 9 | 0 | 1547 | 42.68891267 | -114.2655033 | 2020-11-13 05:25:30 | Jerome, Idaho, US |
865644 | 865644 | 2020-11-12 | US | Georgia | Toombs | 13279 | 1609 | 62 | 0 | 1547 | 32.12059861 | -82.32957247 | 2020-11-13 05:25:30 | Toombs, Georgia, US |
3444017 | 3444017 | 2020-11-11 | US | Texas | San Patricio | 48409 | 1880 | 83 | 0 | 1547 | 28.00880118 | -97.51763891 | 2020-11-12 05:25:55 | San Patricio, Texas, US |
275357 | 275357 | 2020-11-10 | US | Texas | San Patricio | 48409 | 1870 | 83 | 0 | 1547 | 28.00880118 | -97.51763891 | 2020-11-11 05:25:30 | San Patricio, Texas, US |
1991834 | 1991834 | 2020-11-09 | US | Texas | San Patricio | 48409 | 1866 | 83 | 0 | 1547 | 28.00880118 | -97.51763891 | 2020-11-10 05:40:07 | San Patricio, Texas, 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]);