Film_Locations_in_San_Francisco

8 rows where Director = 246

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2
1590	1590	When a Man Loves a Woman 302	1994 48	Buena Vista Café (2765 Hyde Street)		Touchstone Pictures 104	Buena Vista Pictures 25	Luis Mandoki 246	Ronald Bass 262	Andy Garcia 58	Meg Ryan 46
1591	1591	When a Man Loves a Woman 302	1994 48	Victor's Restaurant, The Westin St. Francis Hotel (335 Powell Street)	The hotel was originally supposed to be named the Crocker Hotel, after Charles Founder the railroad magnate who founded it. However, the hotel took the name the St. Francis after one of the earliest Gold Rush hotels.	Touchstone Pictures 104	Buena Vista Pictures 25	Luis Mandoki 246	Ronald Bass 262	Andy Garcia 58	Meg Ryan 46
1592	1592	When a Man Loves a Woman 302	1994 48	Spring Valley School (1451 Jackson Street)		Touchstone Pictures 104	Buena Vista Pictures 25	Luis Mandoki 246	Ronald Bass 262	Andy Garcia 58	Meg Ryan 46
1593	1593	When a Man Loves a Woman 302	1994 48	International Studies Academy (993 Vermont Street, Potrero Hill)		Touchstone Pictures 104	Buena Vista Pictures 25	Luis Mandoki 246	Ronald Bass 262	Andy Garcia 58	Meg Ryan 46
1594	1594	When a Man Loves a Woman 302	1994 48	Grant Street at Pacific Avenue		Touchstone Pictures 104	Buena Vista Pictures 25	Luis Mandoki 246	Ronald Bass 262	Andy Garcia 58	Meg Ryan 46
1595	1595	When a Man Loves a Woman 302	1994 48	Cybelle's Pizza (1000 Bush Street)		Touchstone Pictures 104	Buena Vista Pictures 25	Luis Mandoki 246	Ronald Bass 262	Andy Garcia 58	Meg Ryan 46
1596	1596	When a Man Loves a Woman 302	1994 48	766 Vallejo Street at Stockton Street (North Beach)		Touchstone Pictures 104	Buena Vista Pictures 25	Luis Mandoki 246	Ronald Bass 262	Andy Garcia 58	Meg Ryan 46
1597	1597	When a Man Loves a Woman 302	1994 48	1521 Masonic Avenue at Piedmont Street		Touchstone Pictures 104	Buena Vista Pictures 25	Luis Mandoki 246	Ronald Bass 262	Andy Garcia 58	Meg Ryan 46

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