Film_Locations_in_San_Francisco

Data source: data.sfgov.org

14 rows where Director = 184, Distributor = 20 and Release Year = 46

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
1198 So I Married an Axe Murderer 222 1993 46 Vesuvio Café (255 Columbus Avenue) Jack Kerouac was a regular at the café. TriStar Pictures 136 TriStar Pictures 20 Thomas Schlamme 184 Robbie Fox 193 Mike Myers 382 Nancy Travis 170  
1199 So I Married an Axe Murderer 222 1993 46 Swedenborgian Church (2107 Lyon Street)   TriStar Pictures 136 TriStar Pictures 20 Thomas Schlamme 184 Robbie Fox 193 Mike Myers 382 Nancy Travis 170  
1200 So I Married an Axe Murderer 222 1993 46 St. John's Presbyterian Church (25 Lake Street)   TriStar Pictures 136 TriStar Pictures 20 Thomas Schlamme 184 Robbie Fox 193 Mike Myers 382 Nancy Travis 170  
1201 So I Married an Axe Murderer 222 1993 46 San Francisco Chronicle (901 Mission Street at 15th Street) The paper is called the San Francisco Globe in the movie. TriStar Pictures 136 TriStar Pictures 20 Thomas Schlamme 184 Robbie Fox 193 Mike Myers 382 Nancy Travis 170  
1202 So I Married an Axe Murderer 222 1993 46 Rocco's Corner (Columbus Street)   TriStar Pictures 136 TriStar Pictures 20 Thomas Schlamme 184 Robbie Fox 193 Mike Myers 382 Nancy Travis 170  
1203 So I Married an Axe Murderer 222 1993 46 Prudente's Italian Deli (1462 Grant Ave at Union) Prudente's Italian Deli, which has since closed, is called "Meats of the World" in the film. TriStar Pictures 136 TriStar Pictures 20 Thomas Schlamme 184 Robbie Fox 193 Mike Myers 382 Nancy Travis 170  
1204 So I Married an Axe Murderer 222 1993 46 Fog City Diner (1300 Battery Street)   TriStar Pictures 136 TriStar Pictures 20 Thomas Schlamme 184 Robbie Fox 193 Mike Myers 382 Nancy Travis 170  
1205 So I Married an Axe Murderer 222 1993 46 Edinburgh Castle (950 Geary Street)   TriStar Pictures 136 TriStar Pictures 20 Thomas Schlamme 184 Robbie Fox 193 Mike Myers 382 Nancy Travis 170  
1206 So I Married an Axe Murderer 222 1993 46 City Light Bookstore (261 Columbus Avenue)   TriStar Pictures 136 TriStar Pictures 20 Thomas Schlamme 184 Robbie Fox 193 Mike Myers 382 Nancy Travis 170  
1207 So I Married an Axe Murderer 222 1993 46 Café Picaro 3120 16th Street   TriStar Pictures 136 TriStar Pictures 20 Thomas Schlamme 184 Robbie Fox 193 Mike Myers 382 Nancy Travis 170  
1208 So I Married an Axe Murderer 222 1993 46 Alcatraz Island Alcatraz Island was a military fort before it became a prison. TriStar Pictures 136 TriStar Pictures 20 Thomas Schlamme 184 Robbie Fox 193 Mike Myers 382 Nancy Travis 170  
1209 So I Married an Axe Murderer 222 1993 46 Aladdin Terrace (off of Taylor Street, Between Filbert and Union)   TriStar Pictures 136 TriStar Pictures 20 Thomas Schlamme 184 Robbie Fox 193 Mike Myers 382 Nancy Travis 170  
1210 So I Married an Axe Murderer 222 1993 46 305 Hugo Street   TriStar Pictures 136 TriStar Pictures 20 Thomas Schlamme 184 Robbie Fox 193 Mike Myers 382 Nancy Travis 170  
1211 So I Married an Axe Murderer 222 1993 46 1462 Grant Avenue, at Union Street   TriStar Pictures 136 TriStar Pictures 20 Thomas Schlamme 184 Robbie Fox 193 Mike Myers 382 Nancy Travis 170  

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 60.166ms · Data source: data.sfgov.org