Film_Locations_in_San_Francisco

9 rows where Actor 1 = 220

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Fun Facts	Production Company	Distributor	Director	Writer	Actor 1	Actor 2
449	449	Edtv 86	1999 26	Palace of Fine Arts (3301 Lyon Street)	The original Palace was built for the 1915 Panama-Pacific Exposition, and completely destroyed in 1964. It was rebuilt in 1965.	Imagine Entertainment 64	MCA / Universal Pictures 49	Ron Howard 78	Lowell Ganz 79	Matthew McConaughey 220	Jenna Elfman 67
450	450	Edtv 86	1999 26	Moose's Restaurant (1652 Stockton)		Imagine Entertainment 64	MCA / Universal Pictures 49	Ron Howard 78	Lowell Ganz 79	Matthew McConaughey 220	Jenna Elfman 67
451	451	Edtv 86	1999 26	Mario's Bohemian Cigar Store (Washington Square)		Imagine Entertainment 64	MCA / Universal Pictures 49	Ron Howard 78	Lowell Ganz 79	Matthew McConaughey 220	Jenna Elfman 67
453	453	Edtv 86	1999 26	Center for the Arts, Yerba Buena Gardens (701 Mission Street)		Imagine Entertainment 64	MCA / Universal Pictures 49	Ron Howard 78	Lowell Ganz 79	Matthew McConaughey 220	Jenna Elfman 67
454	454	Edtv 86	1999 26	Castro Theatre (429 Castro Street, The Castro)	The original Castro Theatre was built in 1910, a few doors down from the current theatre. The original theatre was converted into retail space, and the current theatre was built in the 1920s.	Imagine Entertainment 64	MCA / Universal Pictures 49	Ron Howard 78	Lowell Ganz 79	Matthew McConaughey 220	Jenna Elfman 67
455	455	Edtv 86	1999 26	20th & Connecticut Streets (Potrero Hill)		Imagine Entertainment 64	MCA / Universal Pictures 49	Ron Howard 78	Lowell Ganz 79	Matthew McConaughey 220	Jenna Elfman 67
456	456	Edtv 86	1999 26	19 Green Street (North Beach)		Imagine Entertainment 64	MCA / Universal Pictures 49	Ron Howard 78	Lowell Ganz 79	Matthew McConaughey 220	Jenna Elfman 67
457	457	Edtv 86	1999 26	1138 Filbert Street		Imagine Entertainment 64	MCA / Universal Pictures 49	Ron Howard 78	Lowell Ganz 79	Matthew McConaughey 220	Jenna Elfman 67
458	458	Edtv 86	1999 26	North Beach Video (1398 Grant Avenue at Green)	The video store has since moved to an adjacent location.	Imagine Entertainment 64	MCA / Universal Pictures 49	Ron Howard 78	Lowell Ganz 79	Matthew McConaughey 220	Jenna Elfman 67

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