Film_Locations_in_San_Francisco
Data source:
data.sfgov.org
11 rows
where search matches "justin"
✎ View and edit SQL
This data as json, CSV (advanced)
Suggested facets: Title, Release Year, Locations, Production Company, Director, Writer, Actor 1, Actor 2, Actor 3
Link
|
rowid ▼
|
Title
|
Release Year
|
Locations
|
Fun Facts
|
Production Company
|
Distributor
|
Director
|
Writer
|
Actor 1
|
Actor 2
|
Actor 3
|
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 |
123 |
123 |
Bedazzled 31 |
2000 25 |
Vaillancourt Fountain (Justin Herman Plaza) |
Installed in 1975, the Vaillancourt Fountain is officially titled, "Québec Libre!". The night before the sculpture's inauguration, artist Armand Vaillancourt inscribed "Québec libre!" in red letters on the sculpture. The next day when he noticed that the note had been erased, Vaillancourt jumped on the statue to re-inscribe his message. |
Twentieth Century Fox Film Corp. 14 |
Twentieth Century Fox Film Corp. 13 |
Harold Ramis 29 |
Harold Ramis 28 |
Brendan Fraser 263 |
Elizabeth Hurley 27 |
|
666 |
666 |
I Am Michael 129 |
2015 10 |
Flint & 16th (Castro) |
|
That’s Hollywood 85 |
|
Justin Kelly 120 |
Justin Kelly 119 |
James Franco 327 |
Emma Roberts 105 |
Zachary Quinto 488 |
667 |
667 |
I Am Michael 129 |
2015 10 |
Grove & Polk, thru Fulton & 6th, Masonic, 28th & 47th |
|
That’s Hollywood 85 |
|
Justin Kelly 120 |
Justin Kelly 119 |
James Franco 327 |
Emma Roberts 105 |
Zachary Quinto 488 |
668 |
668 |
I Am Michael 129 |
2015 10 |
Ocean Beach @ Balboa |
|
That’s Hollywood 85 |
|
Justin Kelly 120 |
Justin Kelly 119 |
James Franco 327 |
Emma Roberts 105 |
Zachary Quinto 488 |
669 |
669 |
I Am Michael 129 |
2015 10 |
4100 20th St |
|
That’s Hollywood 85 |
|
Justin Kelly 120 |
Justin Kelly 119 |
James Franco 327 |
Emma Roberts 105 |
Zachary Quinto 488 |
670 |
670 |
I Am Michael 129 |
2015 10 |
Harvey Milk Plaza |
|
That’s Hollywood 85 |
|
Justin Kelly 120 |
Justin Kelly 119 |
James Franco 327 |
Emma Roberts 105 |
Zachary Quinto 488 |
671 |
671 |
I Am Michael 129 |
2015 10 |
F Train |
|
That’s Hollywood 85 |
|
Justin Kelly 120 |
Justin Kelly 119 |
James Franco 327 |
Emma Roberts 105 |
Zachary Quinto 488 |
672 |
672 |
I Am Michael 129 |
2015 10 |
Sanchez/Cumberland steps and sidewalks |
|
That’s Hollywood 85 |
|
Justin Kelly 120 |
Justin Kelly 119 |
James Franco 327 |
Emma Roberts 105 |
Zachary Quinto 488 |
1515 |
1515 |
The Zodiac 286 |
2005 2 |
|
|
Blackwater Films 167 |
THINKFilm 104 |
Alexander Bulkley 234 |
Alexander Bulkley & Kelley Bulkeley 247 |
Justin Chambers 423 |
Robin Tunney 44 |
|
1522 |
1522 |
Time After Time 289 |
1979 44 |
Justin Herman Plaza |
|
Orion Pictures Corp. 166 |
Columbia Broadcasting System (CBS) 38 |
Nicholas Meyer 186 |
Karl Alexander 249 |
Malcolm McDowell 425 |
Mary Steenburgen 224 |
David Warner 546 |
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");