Film_Locations_in_San_Francisco

Data source: data.sfgov.org

10 rows where Actor 2 = 46

View and edit SQL

Suggested facets: Title, Release Year, Production Company, Distributor, Director, Writer, Actor 1

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
374 City of Angels 64 1998 18 San Francisco Public Library Main Branch (100 Larkin Street)   Atlas Entertainment 48 Warner Bros. Pictures 6 Brad Silberling 58 Dana Stevens 58 Nicolas Cage 216 Meg Ryan 46  
1392 The Doors 254 1991 37     Bill Graham Films 154 TriStar Pictures 20 Oliver Stone 209 J. Randal Johnson 221 Val Kilmer 401 Meg Ryan 46  
1590 When a Man Loves a Woman 302 1994 48 Buena Vista Café (2765 Hyde Street)   Touchstone Pictures 104 Buena Vista Pictures 25 Luis Mandoki 246 Ronald Bass 262 Andy Garcia 58 Meg Ryan 46  
1591 When a Man Loves a Woman 302 1994 48 Victor's Restaurant, The Westin St. Francis Hotel (335 Powell Street) The hotel was originally supposed to be named the Crocker Hotel, after Charles Founder the railroad magnate who founded it. However, the hotel took the name the St. Francis after one of the earliest Gold Rush hotels. Touchstone Pictures 104 Buena Vista Pictures 25 Luis Mandoki 246 Ronald Bass 262 Andy Garcia 58 Meg Ryan 46  
1592 When a Man Loves a Woman 302 1994 48 Spring Valley School (1451 Jackson Street)   Touchstone Pictures 104 Buena Vista Pictures 25 Luis Mandoki 246 Ronald Bass 262 Andy Garcia 58 Meg Ryan 46  
1593 When a Man Loves a Woman 302 1994 48 International Studies Academy (993 Vermont Street, Potrero Hill)   Touchstone Pictures 104 Buena Vista Pictures 25 Luis Mandoki 246 Ronald Bass 262 Andy Garcia 58 Meg Ryan 46  
1594 When a Man Loves a Woman 302 1994 48 Grant Street at Pacific Avenue   Touchstone Pictures 104 Buena Vista Pictures 25 Luis Mandoki 246 Ronald Bass 262 Andy Garcia 58 Meg Ryan 46  
1595 When a Man Loves a Woman 302 1994 48 Cybelle's Pizza (1000 Bush Street)   Touchstone Pictures 104 Buena Vista Pictures 25 Luis Mandoki 246 Ronald Bass 262 Andy Garcia 58 Meg Ryan 46  
1596 When a Man Loves a Woman 302 1994 48 766 Vallejo Street at Stockton Street (North Beach)   Touchstone Pictures 104 Buena Vista Pictures 25 Luis Mandoki 246 Ronald Bass 262 Andy Garcia 58 Meg Ryan 46  
1597 When a Man Loves a Woman 302 1994 48 1521 Masonic Avenue at Piedmont Street   Touchstone Pictures 104 Buena Vista Pictures 25 Luis Mandoki 246 Ronald Bass 262 Andy Garcia 58 Meg Ryan 46  

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