Film_Locations_in_San_Francisco

Data source: data.sfgov.org

9 rows where Actor 2 = 74 and Distributor = 6

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
504 Fearless 94 1993 46 400 Montgomery Street   Spring Creek Productions 68 Warner Bros. Pictures 6 Peter Weir 85 Rafael Yglesias 86 Jeff Bridges 113 Isabella Rosellini 74 Rosie Perez 475
505 Fearless 94 1993 46 Folsom Street & Embarcadero   Spring Creek Productions 68 Warner Bros. Pictures 6 Peter Weir 85 Rafael Yglesias 86 Jeff Bridges 113 Isabella Rosellini 74 Rosie Perez 475
506 Fearless 94 1993 46 Varennes Alley between Filbert and Union   Spring Creek Productions 68 Warner Bros. Pictures 6 Peter Weir 85 Rafael Yglesias 86 Jeff Bridges 113 Isabella Rosellini 74 Rosie Perez 475
507 Fearless 94 1993 46 St. Peter & Paul's Church (666 Filbert Street, Washington Square) Though Marilyn Monroe and Joe DiMaggio were not allowed to be married at the Church (DiMaggio had married his first wife at the Church but was divorced), the couple returned to the steps of the Church for photos, following their City Hall nuptials. Spring Creek Productions 68 Warner Bros. Pictures 6 Peter Weir 85 Rafael Yglesias 86 Jeff Bridges 113 Isabella Rosellini 74 Rosie Perez 475
508 Fearless 94 1993 46 San Francisco General Hospital Medical Center (1001 Potrero Avenue, Potrero Hill) SF General Hospital is the only Level I Trauma Center serving San Francisco and northern San Mateo County. Spring Creek Productions 68 Warner Bros. Pictures 6 Peter Weir 85 Rafael Yglesias 86 Jeff Bridges 113 Isabella Rosellini 74 Rosie Perez 475
509 Fearless 94 1993 46 Kohl Building (400 Montgomery Street)   Spring Creek Productions 68 Warner Bros. Pictures 6 Peter Weir 85 Rafael Yglesias 86 Jeff Bridges 113 Isabella Rosellini 74 Rosie Perez 475
510 Fearless 94 1993 46 Bank of America Building (555 California Street) The Bank of America Building was the tallest building on the West Coast from 1969-1972, when it was surpassed by the TransAmerica Pyramid. Today, the Bank of America building is the 5th tallest building on the West Coast. Spring Creek Productions 68 Warner Bros. Pictures 6 Peter Weir 85 Rafael Yglesias 86 Jeff Bridges 113 Isabella Rosellini 74 Rosie Perez 475
511 Fearless 94 1993 46 90 Gold Street   Spring Creek Productions 68 Warner Bros. Pictures 6 Peter Weir 85 Rafael Yglesias 86 Jeff Bridges 113 Isabella Rosellini 74 Rosie Perez 475
512 Fearless 94 1993 46 5th and Beale Streets   Spring Creek Productions 68 Warner Bros. Pictures 6 Peter Weir 85 Rafael Yglesias 86 Jeff Bridges 113 Isabella Rosellini 74 Rosie Perez 475

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Film_Locations_in_San_Francisco" (
"Title" INTEGER,
  "Release Year" INTEGER,
  "Locations" TEXT,
  "Fun Facts" REAL,
  "Production Company" INTEGER,
  "Distributor" INTEGER,
  "Director" INTEGER,
  "Writer" INTEGER,
  "Actor 1" INTEGER,
  "Actor 2" INTEGER,
  "Actor 3" INTEGER
,
FOREIGN KEY ("Title") REFERENCES [Title](id),
    FOREIGN KEY ("Director") REFERENCES [Director](id),
    FOREIGN KEY ("Actor 2") REFERENCES [Actors](id),
    FOREIGN KEY ("Actor 1") REFERENCES [Actors](id),
    FOREIGN KEY ("Writer") REFERENCES [Writer](id),
    FOREIGN KEY ("Release Year") REFERENCES [Release Year](id),
    FOREIGN KEY ("Actor 3") REFERENCES [Actors](id),
    FOREIGN KEY ("Production Company") REFERENCES [Production Company](id),
    FOREIGN KEY ("Distributor") REFERENCES [Distributor](id));
CREATE INDEX ["Film_Locations_in_San_Francisco_Title"] ON [Film_Locations_in_San_Francisco]("Title");
CREATE INDEX ["Film_Locations_in_San_Francisco_Director"] ON [Film_Locations_in_San_Francisco]("Director");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 2"] ON [Film_Locations_in_San_Francisco]("Actor 2");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 1"] ON [Film_Locations_in_San_Francisco]("Actor 1");
CREATE INDEX ["Film_Locations_in_San_Francisco_Writer"] ON [Film_Locations_in_San_Francisco]("Writer");
CREATE INDEX ["Film_Locations_in_San_Francisco_Release Year"] ON [Film_Locations_in_San_Francisco]("Release Year");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 3"] ON [Film_Locations_in_San_Francisco]("Actor 3");
CREATE INDEX ["Film_Locations_in_San_Francisco_Production Company"] ON [Film_Locations_in_San_Francisco]("Production Company");
CREATE INDEX ["Film_Locations_in_San_Francisco_Distributor"] ON [Film_Locations_in_San_Francisco]("Distributor");
Powered by Datasette · Query took 37.538ms · Data source: data.sfgov.org