Film_Locations_in_San_Francisco

5 rows where Title = 156

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Production Company	Distributor	Director	Writer	Actor 1	Actor 2	Actor 3
840	840	Looking Season 2 ep 208 156	2015 10	2450 Harrison Street	Mission Street Productions, LLC 101	HBO 18	Andrew Haigh 136	Michael Lannan 137	Jonathan Groff 339	Frankie Alvarez 123	Murray Bartlett 496
841	841	Looking Season 2 ep 208 156	2015 10	1246 Folsom Street	Mission Street Productions, LLC 101	HBO 18	Andrew Haigh 136	Michael Lannan 137	Jonathan Groff 339	Frankie Alvarez 123	Murray Bartlett 496
842	842	Looking Season 2 ep 208 156	2015 10	Citizens Band, 1198 Folsom Street	Mission Street Productions, LLC 101	HBO 18	Andrew Haigh 136	Michael Lannan 137	Jonathan Groff 339	Frankie Alvarez 123	Murray Bartlett 496
843	843	Looking Season 2 ep 208 156	2015 10	1111 California Street	Mission Street Productions, LLC 101	HBO 18	Andrew Haigh 136	Michael Lannan 137	Jonathan Groff 339	Frankie Alvarez 123	Murray Bartlett 496
844	844	Looking Season 2 ep 208 156	2015 10	950 Mason Street	Mission Street Productions, LLC 101	HBO 18	Andrew Haigh 136	Michael Lannan 137	Jonathan Groff 339	Frankie Alvarez 123	Murray Bartlett 496

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