Film_Locations_in_San_Francisco

Data source: data.sfgov.org

5 rows where Writer = 28

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
121 Bedazzled 31 2000 25 1155 Filbert Street at Hyde   Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Harold Ramis 29 Harold Ramis 28 Brendan Fraser 263 Elizabeth Hurley 27  
122 Bedazzled 31 2000 25 Washington Square Park (Filbert, between Stockton and Powell)   Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Harold Ramis 29 Harold Ramis 28 Brendan Fraser 263 Elizabeth Hurley 27  
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  
124 Bedazzled 31 2000 25 Montgomery & Market Streets   Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Harold Ramis 29 Harold Ramis 28 Brendan Fraser 263 Elizabeth Hurley 27  
125 Bedazzled 31 2000 25 City Hall The dome of SF's City Hall is almost a foot taller than that of the US Capitol Building. In 1954, Joe DiMaggio and Marilyn Monroe married at the Beaux Arts-style building. Twentieth Century Fox Film Corp. 14 Twentieth Century Fox Film Corp. 13 Harold Ramis 29 Harold Ramis 28 Brendan Fraser 263 Elizabeth Hurley 27  

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Query took 32.511ms · Data source: data.sfgov.org