Film_Locations_in_San_Francisco

8 rows where Actor 3 = 439

Search:

descending

Link	rowid ▼	Title	Release Year	Locations	Production Company	Director	Writer	Actor 1	Actor 2	Actor 3
1	1	180 1	2011 1	Epic Roasthouse (399 Embarcadero)	SPI Cinemas 1	Jayendra 1	Umarji Anuradha, Jayendra, Aarthi Sriram, & Suba 1	Siddarth 237	Nithya Menon 1	Priya Anand 439
2	2	180 1	2011 1	Mason & California Streets (Nob Hill)	SPI Cinemas 1	Jayendra 1	Umarji Anuradha, Jayendra, Aarthi Sriram, & Suba 1	Siddarth 237	Nithya Menon 1	Priya Anand 439
3	3	180 1	2011 1	Justin Herman Plaza	SPI Cinemas 1	Jayendra 1	Umarji Anuradha, Jayendra, Aarthi Sriram, & Suba 1	Siddarth 237	Nithya Menon 1	Priya Anand 439
4	4	180 1	2011 1	200 block Market Street	SPI Cinemas 1	Jayendra 1	Umarji Anuradha, Jayendra, Aarthi Sriram, & Suba 1	Siddarth 237	Nithya Menon 1	Priya Anand 439
5	5	180 1	2011 1	City Hall	SPI Cinemas 1	Jayendra 1	Umarji Anuradha, Jayendra, Aarthi Sriram, & Suba 1	Siddarth 237	Nithya Menon 1	Priya Anand 439
6	6	180 1	2011 1	Polk & Larkin Streets	SPI Cinemas 1	Jayendra 1	Umarji Anuradha, Jayendra, Aarthi Sriram, & Suba 1	Siddarth 237	Nithya Menon 1	Priya Anand 439
7	7	180 1	2011 1	Randall Museum	SPI Cinemas 1	Jayendra 1	Umarji Anuradha, Jayendra, Aarthi Sriram, & Suba 1	Siddarth 237	Nithya Menon 1	Priya Anand 439
8	8	180 1	2011 1	555 Market St.	SPI Cinemas 1	Jayendra 1	Umarji Anuradha, Jayendra, Aarthi Sriram, & Suba 1	Siddarth 237	Nithya Menon 1	Priya Anand 439

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