johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,006,353 rows sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3863631 | 3863631 | 2020-06-03 | US | Missouri | Audrain | 29007 | 97 | 0 | 0 | 97 | 39.215877 | -91.84242683 | 2020-06-04 02:33:14 | Audrain, Missouri, US |
3863632 | 3863632 | 2020-06-03 | US | Iowa | Audubon | 19009 | 13 | 1 | 0 | 12 | 41.6844628 | -94.90581859 | 2020-06-04 02:33:14 | Audubon, Iowa, US |
3863633 | 3863633 | 2020-06-03 | US | Ohio | Auglaize | 39011 | 76 | 1 | 0 | 75 | 40.55998859 | -84.22421429999999 | 2020-06-04 02:33:14 | Auglaize, Ohio, US |
3863634 | 3863634 | 2020-06-03 | US | Virginia | Augusta | 51015 | 115 | 2 | 0 | 113 | 38.16404586 | -79.12461614 | 2020-06-04 02:33:14 | Augusta, Virginia, US |
3863635 | 3863635 | 2020-06-03 | US | South Dakota | Aurora | 46003 | 27 | 0 | 0 | 27 | 43.71757685 | -98.56050467 | 2020-06-04 02:33:14 | Aurora, South Dakota, US |
3863636 | 3863636 | 2020-06-03 | US | Texas | Austin | 48015 | 20 | 0 | 0 | 27 | 29.88548725 | -96.27736949 | 2020-06-04 02:33:14 | Austin, Texas, US |
3863637 | 3863637 | 2020-06-03 | US | Alabama | Autauga | 1001 | 241 | 5 | 0 | 236 | 32.53952745 | -86.64408227 | 2020-06-04 02:33:14 | Autauga, Alabama, US |
3863638 | 3863638 | 2020-06-03 | US | North Carolina | Avery | 37011 | 2 | 0 | 0 | 2 | 36.07569796 | -81.92308483 | 2020-06-04 02:33:14 | Avery, North Carolina, US |
3863639 | 3863639 | 2020-06-03 | US | Louisiana | Avoyelles | 22009 | 141 | 9 | 0 | 132 | 31.07796211 | -92.00079449 | 2020-06-04 02:33:14 | Avoyelles, Louisiana, US |
3863640 | 3863640 | 2020-06-03 | US | Colorado | Baca | 8009 | 12 | 0 | 0 | 12 | 37.31940883 | -102.5603223 | 2020-06-04 02:33:14 | Baca, Colorado, US |
3863641 | 3863641 | 2020-06-03 | US | Georgia | Bacon | 13005 | 136 | 3 | 0 | 133 | 31.55456473 | -82.45936528 | 2020-06-04 02:33:14 | Bacon, Georgia, US |
3863642 | 3863642 | 2020-06-03 | US | Texas | Bailey | 48017 | 20 | 0 | 0 | 19 | 34.06854817 | -102.8299707 | 2020-06-04 02:33:14 | Bailey, Texas, US |
3863643 | 3863643 | 2020-06-03 | US | Florida | Baker | 12003 | 29 | 4 | 0 | 25 | 30.33060121 | -82.28467476 | 2020-06-04 02:33:14 | Baker, Florida, US |
3863644 | 3863644 | 2020-06-03 | US | Georgia | Baker | 13007 | 34 | 2 | 0 | 32 | 31.32669878 | -84.44218806 | 2020-06-04 02:33:14 | Baker, Georgia, US |
3863645 | 3863645 | 2020-06-03 | US | Oregon | Baker | 41001 | 1 | 0 | 0 | 1 | 44.70915557 | -117.6749883 | 2020-06-04 02:33:14 | Baker, Oregon, US |
3863646 | 3863646 | 2020-06-03 | US | Alabama | Baldwin | 1003 | 302 | 9 | 0 | 293 | 30.72774991 | -87.72207058 | 2020-06-04 02:33:14 | Baldwin, Alabama, US |
3863647 | 3863647 | 2020-06-03 | US | Georgia | Baldwin | 13009 | 352 | 27 | 0 | 325 | 33.06882326 | -83.24701748 | 2020-06-04 02:33:14 | Baldwin, Georgia, US |
3863648 | 3863648 | 2020-06-03 | US | Kentucky | Ballard | 21007 | 12 | 0 | 0 | 12 | 37.05842757 | -88.99427697 | 2020-06-04 02:33:14 | Ballard, Kentucky, US |
3863649 | 3863649 | 2020-06-03 | US | Maryland | Baltimore | 24005 | 6457 | 366 | 0 | 6091 | 39.45784712 | -76.62911955 | 2020-06-04 02:33:14 | Baltimore, Maryland, US |
3863650 | 3863650 | 2020-06-03 | US | Maryland | Baltimore City | 24510 | 5801 | 266 | 0 | 5535 | 39.30211911 | -76.61151012 | 2020-06-04 02:33:14 | Baltimore City, Maryland, US |
3863651 | 3863651 | 2020-06-03 | US | South Carolina | Bamberg | 45009 | 23 | 0 | 0 | 23 | 33.21927586 | -81.05659969 | 2020-06-04 02:33:14 | Bamberg, South Carolina, US |
3863652 | 3863652 | 2020-06-03 | US | Texas | Bandera | 48019 | 7 | 0 | 0 | 6 | 29.74619598 | -99.24598147 | 2020-06-04 02:33:14 | Bandera, Texas, US |
3863653 | 3863653 | 2020-06-03 | US | Georgia | Banks | 13011 | 86 | 1 | 0 | 85 | 34.35607081 | -83.49644388 | 2020-06-04 02:33:14 | Banks, Georgia, US |
3863654 | 3863654 | 2020-06-03 | US | Idaho | Bannock | 16005 | 34 | 1 | 0 | 33 | 42.67002716 | -112.2233311 | 2020-06-04 02:33:14 | Bannock, Idaho, US |
3863655 | 3863655 | 2020-06-03 | US | Michigan | Baraga | 26013 | 1 | 0 | 0 | 1 | 46.6720582 | -88.36363591 | 2020-06-04 02:33:14 | Baraga, Michigan, US |
3863656 | 3863656 | 2020-06-03 | US | Kansas | Barber | 20007 | 1 | 0 | 0 | 1 | 37.2288586 | -98.68460053 | 2020-06-04 02:33:14 | Barber, Kansas, US |
3863657 | 3863657 | 2020-06-03 | US | Alabama | Barbour | 1005 | 181 | 1 | 0 | 180 | 31.868263 | -85.3871286 | 2020-06-04 02:33:14 | Barbour, Alabama, US |
3863658 | 3863658 | 2020-06-03 | US | West Virginia | Barbour | 54001 | 8 | 1 | 0 | 7 | 39.1307219 | -80.00350858 | 2020-06-04 02:33:14 | Barbour, West Virginia, US |
3863659 | 3863659 | 2020-06-03 | US | North Dakota | Barnes | 38003 | 6 | 0 | 0 | 5 | 46.93579637 | -98.06605978 | 2020-06-04 02:33:14 | Barnes, North Dakota, US |
3863660 | 3863660 | 2020-06-03 | US | Massachusetts | Barnstable | 25001 | 1435 | 121 | 0 | 1314 | 41.72980578 | -70.28854339 | 2020-06-04 02:33:14 | Barnstable, Massachusetts, US |
3863661 | 3863661 | 2020-06-03 | US | South Carolina | Barnwell | 45011 | 48 | 1 | 0 | 47 | 33.26679302 | -81.43584352 | 2020-06-04 02:33:14 | Barnwell, South Carolina, US |
3863662 | 3863662 | 2020-06-03 | US | Kentucky | Barren | 21009 | 49 | 1 | 0 | 48 | 36.96469836 | -85.93338945 | 2020-06-04 02:33:14 | Barren, Kentucky, US |
3863663 | 3863663 | 2020-06-03 | US | Wisconsin | Barron | 55005 | 21 | 0 | 0 | 21 | 45.42372701 | -91.84833627 | 2020-06-04 02:33:14 | Barron, Wisconsin, US |
3863664 | 3863664 | 2020-06-03 | US | Georgia | Barrow | 13013 | 333 | 18 | 0 | 315 | 33.99148694 | -83.71436292 | 2020-06-04 02:33:14 | Barrow, Georgia, US |
3863665 | 3863665 | 2020-06-03 | US | Michigan | Barry | 26015 | 64 | 2 | 0 | 62 | 42.59513984 | -85.30834519 | 2020-06-04 02:33:14 | Barry, Michigan, US |
3863666 | 3863666 | 2020-06-03 | US | Missouri | Barry | 29009 | 9 | 0 | 0 | 9 | 36.70978521 | -93.82919888 | 2020-06-04 02:33:14 | Barry, Missouri, US |
3863667 | 3863667 | 2020-06-03 | US | Indiana | Bartholomew | 18005 | 522 | 42 | 0 | 480 | 39.20744865 | -85.89558181 | 2020-06-04 02:33:14 | Bartholomew, Indiana, US |
3863668 | 3863668 | 2020-06-03 | US | Kansas | Barton | 20009 | 44 | 1 | 0 | 43 | 38.47889676 | -98.75636726 | 2020-06-04 02:33:14 | Barton, Kansas, US |
3863669 | 3863669 | 2020-06-03 | US | Georgia | Bartow | 13015 | 496 | 39 | 0 | 457 | 34.23732119 | -84.83887523 | 2020-06-04 02:33:14 | Bartow, Georgia, US |
3863670 | 3863670 | 2020-06-03 | US | Texas | Bastrop | 48021 | 160 | 3 | 0 | 228 | 30.10370699 | -97.31206354 | 2020-06-04 02:33:14 | Bastrop, Texas, US |
3863671 | 3863671 | 2020-06-03 | US | Missouri | Bates | 29013 | 10 | 1 | 0 | 9 | 38.25271289 | -94.34113157 | 2020-06-04 02:33:14 | Bates, Missouri, US |
3863672 | 3863672 | 2020-06-03 | US | Kentucky | Bath | 21011 | 9 | 1 | 0 | 8 | 38.14735938 | -83.74588932 | 2020-06-04 02:33:14 | Bath, Kentucky, US |
3863673 | 3863673 | 2020-06-03 | US | Virginia | Bath | 51017 | 0 | 0 | 0 | 0 | 38.05852573 | -79.73912095 | 2020-06-04 02:33:14 | Bath, Virginia, US |
3863674 | 3863674 | 2020-06-03 | US | Arkansas | Baxter | 5005 | 12 | 0 | 0 | 12 | 36.28784385 | -92.33782872 | 2020-06-04 02:33:14 | Baxter, Arkansas, US |
3863675 | 3863675 | 2020-06-03 | US | Florida | Bay | 12005 | 105 | 3 | 0 | 102 | 30.26548745 | -85.62122584 | 2020-06-04 02:33:14 | Bay, Florida, US |
3863676 | 3863676 | 2020-06-03 | US | Michigan | Bay | 26017 | 322 | 24 | 0 | 298 | 43.70639106 | -83.98731479 | 2020-06-04 02:33:14 | Bay, Michigan, US |
3863677 | 3863677 | 2020-06-03 | US | Wisconsin | Bayfield | 55007 | 3 | 1 | 0 | 2 | 46.52868768 | -91.19716729 | 2020-06-04 02:33:14 | Bayfield, Wisconsin, US |
3863678 | 3863678 | 2020-06-03 | US | South Dakota | Beadle | 46005 | 308 | 5 | 0 | 303 | 44.41464384 | -98.27858469 | 2020-06-04 02:33:14 | Beadle, South Dakota, US |
3863679 | 3863679 | 2020-06-03 | US | Utah | Bear River | 305 | 2 | 0 | 303 | 41.52106798 | -113.0832816 | 2020-06-04 02:33:14 | Bear River, Utah, US | |
3863680 | 3863680 | 2020-06-03 | US | North Carolina | Beaufort | 37013 | 36 | 0 | 0 | 36 | 35.48531943 | -76.84325809 | 2020-06-04 02:33:14 | Beaufort, North Carolina, US |
3863681 | 3863681 | 2020-06-03 | US | South Carolina | Beaufort | 45013 | 398 | 14 | 0 | 384 | 32.39226291 | -80.72619758 | 2020-06-04 02:33:14 | Beaufort, South Carolina, US |
3863682 | 3863682 | 2020-06-03 | US | Louisiana | Beauregard | 22011 | 81 | 4 | 0 | 77 | 30.64836518 | -93.34173616 | 2020-06-04 02:33:14 | Beauregard, Louisiana, US |
3863683 | 3863683 | 2020-06-03 | US | Oklahoma | Beaver | 40007 | 24 | 0 | 0 | 24 | 36.7496847 | -100.4758872 | 2020-06-04 02:33:14 | Beaver, Oklahoma, US |
3863684 | 3863684 | 2020-06-03 | US | Pennsylvania | Beaver | 42007 | 590 | 74 | 0 | 516 | 40.6825484 | -80.34921611 | 2020-06-04 02:33:14 | Beaver, Pennsylvania, US |
3863685 | 3863685 | 2020-06-03 | US | Montana | Beaverhead | 30001 | 1 | 0 | 0 | 1 | 45.13434354 | -112.8984694 | 2020-06-04 02:33:14 | Beaverhead, Montana, US |
3863686 | 3863686 | 2020-06-03 | US | Minnesota | Becker | 27005 | 41 | 0 | 0 | 41 | 46.93479392 | -95.67158144 | 2020-06-04 02:33:14 | Becker, Minnesota, US |
3863687 | 3863687 | 2020-06-03 | US | Oklahoma | Beckham | 40009 | 7 | 0 | 0 | 7 | 35.26862449 | -99.68128023 | 2020-06-04 02:33:14 | Beckham, Oklahoma, US |
3863688 | 3863688 | 2020-06-03 | US | Pennsylvania | Bedford | 42009 | 42 | 2 | 0 | 40 | 40.00522157 | -78.48998442 | 2020-06-04 02:33:14 | Bedford, Pennsylvania, US |
3863689 | 3863689 | 2020-06-03 | US | Tennessee | Bedford | 47003 | 299 | 4 | 0 | 291 | 35.51123746 | -86.45549096 | 2020-06-04 02:33:14 | Bedford, Tennessee, US |
3863690 | 3863690 | 2020-06-03 | US | Virginia | Bedford | 51019 | 62 | 2 | 0 | 60 | 37.3080028 | -79.5281964 | 2020-06-04 02:33:14 | Bedford, Virginia, US |
3863691 | 3863691 | 2020-06-03 | US | Texas | Bee | 48025 | 8 | 0 | 0 | 11 | 28.41761668 | -97.74215593 | 2020-06-04 02:33:14 | Bee, Texas, US |
3863692 | 3863692 | 2020-06-03 | US | New Hampshire | Belknap | 33001 | 63 | 0 | 0 | 63 | 43.51637314 | -71.41684235 | 2020-06-04 02:33:14 | Belknap, New Hampshire, US |
3863693 | 3863693 | 2020-06-03 | US | Kentucky | Bell | 21013 | 1 | 0 | 0 | 1 | 36.73355174 | -83.67766671 | 2020-06-04 02:33:14 | Bell, Kentucky, US |
3863694 | 3863694 | 2020-06-03 | US | Texas | Bell | 48027 | 72 | 4 | 0 | 407 | 31.03736027 | -97.4785025 | 2020-06-04 02:33:14 | Bell, Texas, US |
3863695 | 3863695 | 2020-06-03 | US | Ohio | Belmont | 39013 | 439 | 19 | 0 | 420 | 40.01625942 | -80.9924051 | 2020-06-04 02:33:14 | Belmont, Ohio, US |
3863696 | 3863696 | 2020-06-03 | US | Minnesota | Beltrami | 27007 | 18 | 0 | 0 | 18 | 47.97373527 | -94.93732139 | 2020-06-04 02:33:14 | Beltrami, Minnesota, US |
3863697 | 3863697 | 2020-06-03 | US | Georgia | Ben Hill | 13017 | 81 | 1 | 0 | 80 | 31.76095874 | -83.22145359 | 2020-06-04 02:33:14 | Ben Hill, Georgia, US |
3863698 | 3863698 | 2020-06-03 | US | Idaho | Benewah | 16009 | 12 | 0 | 0 | 12 | 47.21754179 | -116.6586851 | 2020-06-04 02:33:14 | Benewah, Idaho, US |
3863699 | 3863699 | 2020-06-03 | US | Vermont | Bennington | 50003 | 64 | 1 | 0 | 63 | 43.03519828 | -73.09048868 | 2020-06-04 02:33:14 | Bennington, Vermont, US |
3863700 | 3863700 | 2020-06-03 | US | North Dakota | Benson | 38005 | 1 | 0 | 0 | 1 | 48.0683985 | -99.35916363 | 2020-06-04 02:33:14 | Benson, North Dakota, US |
3863701 | 3863701 | 2020-06-03 | US | Colorado | Bent | 8011 | 3 | 0 | 0 | 2 | 37.95474293 | -103.0720195 | 2020-06-04 02:33:14 | Bent, Colorado, US |
3863702 | 3863702 | 2020-06-03 | US | Arkansas | Benton | 5007 | 700 | 3 | 0 | 697 | 36.33644656 | -94.25680817 | 2020-06-04 02:33:14 | Benton, Arkansas, US |
3863703 | 3863703 | 2020-06-03 | US | Indiana | Benton | 18007 | 32 | 0 | 0 | 32 | 40.60626947 | -87.31093999 | 2020-06-04 02:33:14 | Benton, Indiana, US |
3863704 | 3863704 | 2020-06-03 | US | Iowa | Benton | 19011 | 44 | 1 | 0 | 43 | 42.08011739 | -92.06463573 | 2020-06-04 02:33:14 | Benton, Iowa, US |
3863705 | 3863705 | 2020-06-03 | US | Minnesota | Benton | 27009 | 181 | 3 | 0 | 178 | 45.69804958 | -93.99514135 | 2020-06-04 02:33:14 | Benton, Minnesota, US |
3863706 | 3863706 | 2020-06-03 | US | Mississippi | Benton | 28009 | 14 | 0 | 0 | 14 | 34.81681228 | -89.18945516 | 2020-06-04 02:33:14 | Benton, Mississippi, US |
3863707 | 3863707 | 2020-06-03 | US | Missouri | Benton | 29015 | 11 | 0 | 0 | 11 | 38.29503305 | -93.28756116 | 2020-06-04 02:33:14 | Benton, Missouri, US |
3863708 | 3863708 | 2020-06-03 | US | Oregon | Benton | 41003 | 57 | 5 | 0 | 52 | 44.49167306 | -123.4316987 | 2020-06-04 02:33:14 | Benton, Oregon, US |
3863709 | 3863709 | 2020-06-03 | US | Tennessee | Benton | 47005 | 7 | 1 | 0 | 6 | 36.07110411 | -88.06849355 | 2020-06-04 02:33:14 | Benton, Tennessee, US |
3863710 | 3863710 | 2020-06-03 | US | Washington | Benton | 53005 | 855 | 68 | 0 | 787 | 46.23946995 | -119.5120834 | 2020-06-04 02:33:14 | Benton, Washington, US |
3863711 | 3863711 | 2020-06-03 | US | Michigan | Benzie | 26019 | 4 | 0 | 0 | 4 | 44.63899297 | -86.01608482 | 2020-06-04 02:33:14 | Benzie, Michigan, US |
3863712 | 3863712 | 2020-06-03 | US | New Jersey | Bergen | 34003 | 18451 | 1595 | 0 | 16856 | 40.96010917 | -74.07164325 | 2020-06-04 02:33:14 | Bergen, New Jersey, US |
3863713 | 3863713 | 2020-06-03 | US | South Carolina | Berkeley | 45015 | 242 | 16 | 0 | 226 | 33.20222596 | -79.94654523 | 2020-06-04 02:33:14 | Berkeley, South Carolina, US |
3863714 | 3863714 | 2020-06-03 | US | West Virginia | Berkeley | 54003 | 326 | 7 | 0 | 319 | 39.46704621 | -78.02414609 | 2020-06-04 02:33:14 | Berkeley, West Virginia, US |
3863715 | 3863715 | 2020-06-03 | US | Pennsylvania | Berks | 42011 | 4120 | 322 | 0 | 3798 | 40.41570541 | -75.92457766 | 2020-06-04 02:33:14 | Berks, Pennsylvania, US |
3863716 | 3863716 | 2020-06-03 | US | Massachusetts | Berkshire | 25003 | 566 | 40 | 0 | 526 | 42.37428441 | -73.20524838 | 2020-06-04 02:33:14 | Berkshire, Massachusetts, US |
3863717 | 3863717 | 2020-06-03 | US | New Mexico | Bernalillo | 35001 | 1524 | 72 | 0 | 1452 | 35.05163625 | -106.6703554 | 2020-06-04 02:33:14 | Bernalillo, New Mexico, US |
3863718 | 3863718 | 2020-06-03 | US | Georgia | Berrien | 13019 | 48 | 0 | 0 | 48 | 31.27590016 | -83.22529920000002 | 2020-06-04 02:33:14 | Berrien, Georgia, US |
3863719 | 3863719 | 2020-06-03 | US | Michigan | Berrien | 26021 | 643 | 53 | 0 | 590 | 41.95447397 | -86.41313079999998 | 2020-06-04 02:33:14 | Berrien, Michigan, US |
3863720 | 3863720 | 2020-06-03 | US | North Carolina | Bertie | 37015 | 126 | 4 | 0 | 122 | 36.0688473 | -76.96545943 | 2020-06-04 02:33:14 | Bertie, North Carolina, US |
3863721 | 3863721 | 2020-06-03 | US | Alaska | Bethel | 2050 | 3 | 0 | 0 | 3 | 60.90980451 | -159.8561831 | 2020-06-04 02:33:14 | Bethel, Alaska, US |
3863722 | 3863722 | 2020-06-03 | US | Texas | Bexar | 48029 | 3000 | 75 | 0 | 2807 | 29.44928723 | -98.52019748 | 2020-06-04 02:33:14 | Bexar, Texas, US |
3863723 | 3863723 | 2020-06-03 | US | Alabama | Bibb | 1007 | 78 | 1 | 0 | 77 | 32.99642064 | -87.12511459999996 | 2020-06-04 02:33:14 | Bibb, Alabama, US |
3863724 | 3863724 | 2020-06-03 | US | Georgia | Bibb | 13021 | 481 | 29 | 0 | 452 | 32.80904227 | -83.70489165 | 2020-06-04 02:33:14 | Bibb, Georgia, US |
3863725 | 3863725 | 2020-06-03 | US | Louisiana | Bienville | 22013 | 149 | 23 | 0 | 126 | 32.34569994 | -93.05398492 | 2020-06-04 02:33:14 | Bienville, Louisiana, US |
3863726 | 3863726 | 2020-06-03 | US | Montana | Big Horn | 30003 | 31 | 0 | 0 | 31 | 45.42335905 | -107.492347 | 2020-06-04 02:33:14 | Big Horn, Montana, US |
3863727 | 3863727 | 2020-06-03 | US | Wyoming | Big Horn | 56003 | 6 | 0 | 0 | 6 | 44.52405055 | -107.9960365 | 2020-06-04 02:33:14 | Big Horn, Wyoming, US |
3863728 | 3863728 | 2020-06-03 | US | Minnesota | Big Stone | 27011 | 8 | 0 | 0 | 8 | 45.42712824 | -96.41403739 | 2020-06-04 02:33:14 | Big Stone, Minnesota, US |
3863729 | 3863729 | 2020-06-03 | US | Idaho | Bingham | 16011 | 8 | 0 | 0 | 8 | 43.21672879999999 | -112.3978437 | 2020-06-04 02:33:14 | Bingham, Idaho, US |
3863730 | 3863730 | 2020-06-03 | US | Iowa | Black Hawk | 19013 | 1759 | 46 | 0 | 1713 | 42.4704581 | -92.30524729 | 2020-06-04 02:33:14 | Black Hawk, Iowa, 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]);