Question: When was the last time there was an eclipse in the country that shares a border with the state they filmed Some Like It Hot?

full_context: Document 1: Solar eclipse of August 21, 2017: The solar eclipse of August 21, 2017, dubbed ``The Great American Eclipse ''by the media, was a total eclipse visible within a band across the entire contiguous United States, passing from the Pacific to the Atlantic coasts. As a partial solar eclipse, it was visible on land from Nunavut in northern Canada to as far south as northern South America. In northwestern Europe and Africa, it was partially visible in the late evening. In Asia it was visible only at the eastern extremity, the Chukchi Peninsula.
Document 2: Mexico–United States border: The total length of the continental border is 3,201 kilometers (1,989 mi). From the Gulf of Mexico, it follows the course of the Rio Grande (Río Bravo del Norte) to the border crossing at Ciudad Juárez, Chihuahua and El Paso, Texas. Westward from El Paso -- Juárez, it crosses vast tracts of the Chihuahuan and Sonoran deserts to the Colorado River Delta and San Diego -- Tijuana, before reaching the Pacific Ocean.
Document 3: American Horror Story: Hotel: According to creators Brad Falchuk and Ryan Murphy, thematically, Hotel is much darker than previous seasons. Inspiration came from old hotel horror films and actual hotels situated in downtown Los Angeles with a reputation for sinister events, including the Cecil. The cycle also marks a return to filming in Los Angeles, where the first two seasons were shot. Hotel features one of the most expansive sets in American Horror Story history, with production designer Mark Worthington building two stories on a soundstage, along with a working elevator and stairway. In July 2015, FX launched a marketing campaign for the series, with most trailers and teasers touting Gaga's involvement.
Document 4: Solar eclipse of July 22, 2009: The eclipse was part of Saros series 136, as was the solar eclipse of July 11, 1991, which was slightly longer, lasting up to 6 minutes 53 seconds (previous eclipses of the same saros series on June 30, 1973 and June 20, 1955, were longer, lasting 7 min 04 and 7 min 08, respectively). The next event from this series will be on August 2, 2027. The exceptional duration was a result of the Moon being near perigee, with the apparent diameter of the Moon 8% larger than the Sun (magnitude 1.080) and the Earth being near aphelion where the Sun appeared slightly smaller.
Document 5: Texas: Texas (/ ˈtɛksəs /, locally / ˈtɛksəz /; Spanish: Texas or Tejas, pronounced (ˈtexas)) is the second largest state in the United States by both area and population. Geographically located in the South Central region of the country, Texas shares borders with the U.S. states of Louisiana to the east, Arkansas to the northeast, Oklahoma to the north, New Mexico to the west, and the Mexican states of Chihuahua, Coahuila, Nuevo León, and Tamaulipas to the southwest, while the Gulf of Mexico is to the southeast.
Document 6: 500 Days of Summer: David Ng of the Los Angeles Times describes architecture as a star of the film. Tom is seen reading Alain de Botton's The Architecture of Happiness. The film was originally set in San Francisco but was later moved to Los Angeles and the script rewritten to make better use of the location. Buildings used include the Los Angeles Music Center (which includes the Dorothy Chandler Pavilion) and the towers of California Plaza. The older Fine Arts Building is featured in the film, in a scene where Tom shows it to Summer and mentions its designers, Walker and Eisen, two of his favorite architects, although he incorrectly gives the partners' names as ``Walker and Eisner. ''
Document 7: Solar eclipse of July 11, 1991: A total solar eclipse occurred on July 11, 1991. A solar eclipse occurs when the Moon passes between Earth and the Sun, thereby totally or partly obscuring the image of the Sun for a viewer on Earth. A total solar eclipse occurs when the Moon's apparent diameter is larger than the Sun's, blocking all direct sunlight, turning day into darkness. Totality occurs in a narrow path across Earth's surface, with the partial solar eclipse visible over a surrounding region thousands of kilometres wide. Totality began over the Pacific Ocean and Hawaii moving across Mexico, down through Central America and across South America ending over Brazil. It lasted for 6 minutes and 53 seconds at the point of maximum eclipse. There will not be a longer total eclipse until June 13, 2132.
Document 8: Solar eclipse of August 21, 2017: The solar eclipse of August 21, 2017, dubbed ``The Great American Eclipse ''by the media, was a total solar eclipse visible within a band across the entire contiguous United States, passing from the Pacific to the Atlantic coasts. As a partial solar eclipse, it was visible on land from Nunavut in northern Canada to as far south as northern South America. In northwestern Europe and Africa, it was partially visible in the late evening. In Asia, it was visible only at the eastern extremity, the Chukchi Peninsula.
Document 9: Mexico–United States border: Among the U.S. states, Texas has the longest stretch of the border with Mexico, while California has the shortest. Among the states in Mexico, Chihuahua has the longest border with the United States, while Nuevo León has the shortest.
Document 10: San Diego: The city shares a 15-mile (24 km) border with Mexico that includes two border crossings. San Diego hosts the busiest international border crossing in the world, in the San Ysidro neighborhood at the San Ysidro Port of Entry. A second, primarily commercial border crossing operates in the Otay Mesa area; it is the largest commercial crossing on the California-Baja California border and handles the third-highest volume of trucks and dollar value of trade among all United States-Mexico land crossings.
Document 11: Santa Monica, California: Hundreds of movies have been shot or set in part within the city of Santa Monica. One of the oldest exterior shots in Santa Monica is Buster Keaton's Spite Marriage (1929) which shows much of 2nd Street. The comedy It's a Mad, Mad, Mad, Mad World (1963) included several scenes shot in Santa Monica, including those along the California Incline, which led to the movie's treasure spot, "The Big W". The Sylvester Stallone film Rocky III (1982) shows Rocky Balboa and Apollo Creed training to fight Clubber Lang by running on the Santa Monica Beach, and Stallone's Demolition Man (1993) includes Santa Monica settings. Henry Jaglom's indie Someone to Love (1987), the last film in which Orson Welles appeared, takes place in Santa Monica's venerable Mayfair Theatre. Heathers (1989) used Santa Monica's John Adams Middle School for many exterior shots. The Truth About Cats & Dogs (1996) is set entirely in Santa Monica, particularly the Palisades Park area, and features a radio station that resembles KCRW at Santa Monica College. 17 Again (2009) was shot at Samohi. Other films that show significant exterior shots of Santa Monica include Fletch (1985), Species (1995), Get Shorty (1995), and Ocean's Eleven (2001). Richard Rossi's biopic Aimee Semple McPherson opens and closes at the beach in Santa Monica. Iron Man features the Santa Monica pier and surrounding communities as Tony Stark tests his experimental flight suit.
Document 12: Solar eclipse of April 8, 2024: A total solar eclipse will take place on Monday, April 8, 2024, visible across North America. A solar eclipse occurs when the Moon passes between Earth and the Sun, thereby totally or partly obscuring the image of the Sun for a viewer on Earth. A total solar eclipse occurs when the Moon's apparent diameter is larger than the Sun's, blocking all direct sunlight, turning day into darkness. Totality occurs in a narrow path across Earth's surface, with the partial solar eclipse visible over a surrounding region thousands of kilometres wide. With a magnitude of 1.0566, its longest duration of totality will be of four minutes and 28 seconds near the town of Nazas, Durango, Mexico, and the nearby city of Torreón, Coahuila.
Document 13: Alamo Square, San Francisco: A row of Victorian houses facing the park on Steiner Street, known as the ``Painted Ladies '', are often shown in the foreground of panoramic pictures of the city's downtown area. A number of movies, television shows and commercials have been filmed in or around Alamo Square. The park features heavily in the 1978 horror film The Invasion of the Body Snatchers, and the romantic comedy The Five - Year Engagement. The opening sequence of the American sitcom Full House (1987 - 1995) features a romp in Alamo Square Park with the famous row of Victorians in the background.
Document 14: Some Like It Hot: The film was made in California during the summer and autumn of 1958. Many scenes were shot at the Hotel del Coronado in San Diego which appeared as the ``Seminole Ritz Hotel ''in Miami in the film. The Hotel in San Diego fitted into the era of the 1920s and was near Hollywood, so Wilder chose it although it was not in Florida.
Document 15: Mexico–United States border: The total length of the continental border is 1,954 miles (3,145 km). From the Gulf of Mexico, it follows the course of the Rio Grande (Río Bravo del Norte) to the border crossing at Ciudad Juárez, Chihuahua, and El Paso, Texas. Westward from El Paso -- Juárez, it crosses vast tracts of the Chihuahuan and Sonoran deserts to the Colorado River Delta and San Diego -- Tijuana, before reaching the Pacific Ocean.
ground_truth: July 11, 1991
sub_queries: where did they film some like it hot Answer: in California
the country of shares a border with in California Answer: Mexico
when was the last time there was an eclipse in Mexico Answer: July 11, 1991