Film_Locations_in_San_Francisco

Data source: data.sfgov.org

7 rows where Actor 2 = 145

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
1015 Petulia 189 1968 31 Japanese Tea Garden, Hagiwara Tea Garden Drive, Golden Gate Park The Japanese Hagiwara family invented "Chinese" fortune cookies in the tea-garden Warner Brothers / Seven Arts 120 Warner Brothers / Seven Arts 75 Richard Lester 158 Lawrence B. Marcus 163 Julie Christie 358 George C. Scott 145 Richard Chamberlain 506
1016 Petulia 189 1968 31 Fairmont Hotel (950 Mason Street, Nob Hill) In 1945 the Fairmont hosted the United Nations Conference on International Organization as delegates arrived to draft a charter for the organization. The U.S. Secretary of State, Edward Stettinius drafted the charter in the hotel's Garden Room. Warner Brothers / Seven Arts 120 Warner Brothers / Seven Arts 75 Richard Lester 158 Lawrence B. Marcus 163 Julie Christie 358 George C. Scott 145 Richard Chamberlain 506
1017 Petulia 189 1968 31 Pier 43 1/2   Warner Brothers / Seven Arts 120 Warner Brothers / Seven Arts 75 Richard Lester 158 Lawrence B. Marcus 163 Julie Christie 358 George C. Scott 145 Richard Chamberlain 506
1018 Petulia 189 1968 31 Cala Foods (California Street and Hyde)   Warner Brothers / Seven Arts 120 Warner Brothers / Seven Arts 75 Richard Lester 158 Lawrence B. Marcus 163 Julie Christie 358 George C. Scott 145 Richard Chamberlain 506
1019 Petulia 189 1968 31 307 Filbert Street   Warner Brothers / Seven Arts 120 Warner Brothers / Seven Arts 75 Richard Lester 158 Lawrence B. Marcus 163 Julie Christie 358 George C. Scott 145 Richard Chamberlain 506
1020 Petulia 189 1968 31 2417 Franklin Street   Warner Brothers / Seven Arts 120 Warner Brothers / Seven Arts 75 Richard Lester 158 Lawrence B. Marcus 163 Julie Christie 358 George C. Scott 145 Richard Chamberlain 506
1021 Petulia 189 1968 31 Fort Point (Presidio, Golden Gate National Recreation Area) Built in 1853, Fort Point is the only West Coast fort built by the Union Army. Though the Confederate army planned to attack San Francisco, the commanding Confederate general learned that the war had ended while end route to SF. Warner Brothers / Seven Arts 120 Warner Brothers / Seven Arts 75 Richard Lester 158 Lawrence B. Marcus 163 Julie Christie 358 George C. Scott 145 Richard Chamberlain 506

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 34.576ms · Data source: data.sfgov.org