Film_Locations_in_San_Francisco

Data source: data.sfgov.org

11 rows where Writer = 181

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
1133 Twisted 209 2004 5 Pier 24   Paramount Pictures 4 Paramount Pictures 3 Philip Kaufman 111 Sarah Thorp 181 Ashley Judd 324 Samuel L. Jackson 160  
1547 Twisted 209 2004 5 Red's Java House (Pier 30-32, The Embarcadero)   Paramount Pictures 4 Paramount Pictures 3 Philip Kaufman 111 Sarah Thorp 181 Ashley Judd 324 Samuel L. Jackson 160  
1548 Twisted 209 2004 5 Piers 30-32   Paramount Pictures 4 Paramount Pictures 3 Philip Kaufman 111 Sarah Thorp 181 Ashley Judd 324 Samuel L. Jackson 160  
1549 Twisted 209 2004 5 Pier 39   Paramount Pictures 4 Paramount Pictures 3 Philip Kaufman 111 Sarah Thorp 181 Ashley Judd 324 Samuel L. Jackson 160  
1550 Twisted 209 2004 5 Mojito (1337-1339 Grant Avenue)   Paramount Pictures 4 Paramount Pictures 3 Philip Kaufman 111 Sarah Thorp 181 Ashley Judd 324 Samuel L. Jackson 160  
1551 Twisted 209 2004 5 McCovey Point, China Basin Park (24 Willy Mays Plaza)   Paramount Pictures 4 Paramount Pictures 3 Philip Kaufman 111 Sarah Thorp 181 Ashley Judd 324 Samuel L. Jackson 160  
1552 Twisted 209 2004 5 Veterans' War Memorial Building (401 Van Ness Avenue)   Paramount Pictures 4 Paramount Pictures 3 Philip Kaufman 111 Sarah Thorp 181 Ashley Judd 324 Samuel L. Jackson 160  
1553 Twisted 209 2004 5     Paramount Pictures 4 Paramount Pictures 3 Philip Kaufman 111 Sarah Thorp 181 Ashley Judd 324 Samuel L. Jackson 160  
1554 Twisted 209 2004 5 La Bodega (1332 Grant Avenue at Vallejo)   Paramount Pictures 4 Paramount Pictures 3 Philip Kaufman 111 Sarah Thorp 181 Ashley Judd 324 Samuel L. Jackson 160  
1555 Twisted 209 2004 5 Vesuvio Café (255 Columbus Avenue) Jack Kerouac was a regular at the café. Paramount Pictures 4 Paramount Pictures 3 Philip Kaufman 111 Sarah Thorp 181 Ashley Judd 324 Samuel L. Jackson 160  
1556 Twisted 209 2004 5 The Saloon (1232 Grant Avenue)   Paramount Pictures 4 Paramount Pictures 3 Philip Kaufman 111 Sarah Thorp 181 Ashley Judd 324 Samuel L. Jackson 160  

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