Film_Locations_in_San_Francisco

13 rows where search matches "coit tower"

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
39	39	After the Thin Man 13	1936 12	Coit Tower	The Tower was funded by a gift bequeathed by Lillie Hitchcock Coit, a socialite who reportedly liked to chase fires. Though the tower resembles a firehose nozzle, it was not designed this way.	Metro-Goldwyn Mayer 8	Metro-Goldwyn Mayer 10	W.S. Van Dyke 12	Frances Goodrich 11	William Powell 247	Myrna Loy 11	James Stewart 432
189	189	Boys and Girls 39	2000 25	Coit Tower	The Tower was funded by a gift bequeathed by Lillie Hitchcock Coit, a socialite who reportedly liked to chase fires. Though the tower resembles a firehose nozzle, it was not designed this way.	Punch 21 Productions 34	Dimension Films 28	Robert Iscove 37	The Drews 36	Freddie Prinze, Jr. 271	Alyson Hannigan 34
367	367	Chance Season 2 61	2017 20	Coit Tower		TVM Productions Inc. 45	Hulu 36	Rozann Dawson 55	Alexandra Cunningham 55	Hugh Laurie 280	Greta Lee 43	Ethan Suplee 463
433	433	Doctor Dolittle 79	1998 18	Coit Tower	The Tower was funded by a gift bequeathed by Lillie Hitchcock Coit, a socialite who reportedly liked to chase fires. Though the tower resembles a firehose nozzle, it was not designed this way.	Twentieth Century Fox Film Cooperation 60	Twentieth Century Fox Film Cooperation 45	Betty Thomas 72	Nat Mauldin 72	Eddie Murphy 3	Ossie Davis 61
1003	1003	Pal Joey 184	1957 61	Coit Tower	The Tower was funded by a gift bequeathed by Lillie Hitchcock Coit, a socialite who reportedly liked to chase fires. Though the tower resembles a firehose nozzle, it was not designed this way.	Columbia Pictures Corporation 5	Columbia Pictures 4	George Sidney 153	Dorothy Kingsley 159	Rita Hayworth 354	Frank Sinatra 141	Kim Novak 231
1079	1079	Red Widow 201	2013 27	Pioneer Park at Coit Tower		Beyond Pix 126	American Broadcasting Company (ABC) 51	Alon Aranya 167	Melissa Rosenberg 174	Radha Mitchell 368	Sterling Beaumon 154	Clifton Collins Jr. 513
1098	1098	San Andreas 205	2015 10	Coit Tower		Upside Down Productions, Inc. 129	Warner Bros. 80	Brad Peyton 170	Allan Loeb 178	Dwayne Johnson 258
1109	1109	San Andreas 205	2015 10	Hyde St. at Greenwich and Hyde St. at Lombard	Characters walk to get a vantage point for Coit tower. 250 actors walking "fleeing" the city after earthquake	Upside Down Productions, Inc. 129	Warner Bros. 80	Brad Peyton 170	Allan Loeb 178	Dwayne Johnson 258
1168	1168	Sister Act 2: Back in the Habit 219	1993 46	Coit Tower	The Tower was funded by a gift bequeathed by Lillie Hitchcock Coit, a socialite who reportedly liked to chase fires. Though the tower resembles a firehose nozzle, it was not designed this way.	Touchstone Pictures 104	Buena Vista Pictures 25	Bill Duke 181	Joseph Howard 190	Whoopi Goldberg 274	Maggie Smith 167
1395	1395	The Enforcer 255	1976 45	Coit Tower	The Tower was funded by a gift bequeathed by Lillie Hitchcock Coit, a socialite who reportedly liked to chase fires. Though the tower resembles a firehose nozzle, it was not designed this way.	Warner Bros. Pictures 38	Warner Bros. Pictures 6	James Fargo 210	Stirling Silliphant 222	Clint Eastwood 295	Tyne Daly 195	Harry Guardino 60
1422	1422	The House on Telegraph Hill 260	1951 70	Coit Tower	The Tower was funded by a gift bequeathed by Lillie Hitchcock Coit, a socialite who reportedly liked to chase fires. Though the tower resembles a firehose nozzle, it was not designed this way.	Twentieth Century Fox Film Corp. 14	Twentieth Century Fox Film Corp. 13	Robert Wise 215	Elick Moll 226	Richard Basehart 405	Valentina Cortese 198	William Lundigan 534
1465	1465	The Presidio 275	1988 23	Coit Tower	The Tower was funded by a gift bequeathed by Lillie Hitchcock Coit, a socialite who reportedly liked to chase fires. Though the tower resembles a firehose nozzle, it was not designed this way.	Paramount Pictures 4	Paramount Pictures 3	Peter Hyams 226	Larry Ferguson 238	Sean Connery 107	Mark Harmon 211	Meg Ryan 46
1491	1491	The Rock 280	1996 43	Coit Tower	The Tower was funded by a gift bequeathed by Lillie Hitchcock Coit, a socialite who reportedly liked to chase fires. Though the tower resembles a firehose nozzle, it was not designed this way.	Hollywood Pictures 95	Buena Vista Pictures 25	Michael Bay 229	David Weisberg 241	Sean Connery 107	Nicolas Cage 216

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