Film_Locations_in_San_Francisco

6 rows where Director = 112

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
642	642	Herbie Rides Again 120	1974 49	Castagnola's Restaurant (Fisherman's Wharf)		Walt Disney Productions 82	Buena Vista Distribution 58	Robert Stevenson 112	Bill Walsh 111	Helen Hayes 321	Ken Berry 96	Stefanie Powers 473
643	643	Herbie Rides Again 120	1974 49	Sheraton Palace Hotel (639 Market Street)	The hotel was destroyed in the 1906 earthquake and fire, had to be rebuilt, and was reopened in 1909.	Walt Disney Productions 82	Buena Vista Distribution 58	Robert Stevenson 112	Bill Walsh 111	Helen Hayes 321	Ken Berry 96	Stefanie Powers 473
644	644	Herbie Rides Again 120	1974 49	Golden Gate Bridge	With 23 miles of ladders and 300,000 rivets in each tower, the Golden Gate Bridge was the world's longest span when it opened in 1937.	Walt Disney Productions 82	Buena Vista Distribution 58	Robert Stevenson 112	Bill Walsh 111	Helen Hayes 321	Ken Berry 96	Stefanie Powers 473
1441	1441	The Love Bug 266	1968 31	Golden Gate Bridge	With 23 miles of ladders and 300,000 rivets in each tower, the Golden Gate Bridge was the world's longest span when it opened in 1937.	Walt Disney Productions 82	Buena Vista Distribution 58	Robert Stevenson 112	Bill Walsh 111	Dean Jones 410	Michele Lee 203	David Tomlinson 540
1442	1442	The Love Bug 266	1968 31	100 Block of Lombard Street	Lombard Street is not actually the most crooked in SF. That honor goes to Potrero Hill's Vermont Street between 22nd and 23rd.	Walt Disney Productions 82	Buena Vista Distribution 58	Robert Stevenson 112	Bill Walsh 111	Dean Jones 410	Michele Lee 203	David Tomlinson 540
1543	1543	To the Ends of the Earth 291	1948 56			Kennedy-Buckman Pictures 169	Columbia Pictures 4	Robert Stevenson 112	Jay Richard Kennedy 251	Dick Powell 427	Signe Hasso 226	Maylia 547

Advanced export

JSON shape: default, array, newline-delimited

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");