Film_Locations_in_San_Francisco

Data source: data.sfgov.org

9 rows where Title = 86

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
449 Edtv 86 1999 26 Palace of Fine Arts (3301 Lyon Street) The original Palace was built for the 1915 Panama-Pacific Exposition, and completely destroyed in 1964. It was rebuilt in 1965. Imagine Entertainment 64 MCA / Universal Pictures 49 Ron Howard 78 Lowell Ganz 79 Matthew McConaughey 220 Jenna Elfman 67  
450 Edtv 86 1999 26 Moose's Restaurant (1652 Stockton)   Imagine Entertainment 64 MCA / Universal Pictures 49 Ron Howard 78 Lowell Ganz 79 Matthew McConaughey 220 Jenna Elfman 67  
451 Edtv 86 1999 26 Mario's Bohemian Cigar Store (Washington Square)   Imagine Entertainment 64 MCA / Universal Pictures 49 Ron Howard 78 Lowell Ganz 79 Matthew McConaughey 220 Jenna Elfman 67  
453 Edtv 86 1999 26 Center for the Arts, Yerba Buena Gardens (701 Mission Street)   Imagine Entertainment 64 MCA / Universal Pictures 49 Ron Howard 78 Lowell Ganz 79 Matthew McConaughey 220 Jenna Elfman 67  
454 Edtv 86 1999 26 Castro Theatre (429 Castro Street, The Castro) The original Castro Theatre was built in 1910, a few doors down from the current theatre. The original theatre was converted into retail space, and the current theatre was built in the 1920s. Imagine Entertainment 64 MCA / Universal Pictures 49 Ron Howard 78 Lowell Ganz 79 Matthew McConaughey 220 Jenna Elfman 67  
455 Edtv 86 1999 26 20th & Connecticut Streets (Potrero Hill)   Imagine Entertainment 64 MCA / Universal Pictures 49 Ron Howard 78 Lowell Ganz 79 Matthew McConaughey 220 Jenna Elfman 67  
456 Edtv 86 1999 26 19 Green Street (North Beach)   Imagine Entertainment 64 MCA / Universal Pictures 49 Ron Howard 78 Lowell Ganz 79 Matthew McConaughey 220 Jenna Elfman 67  
457 Edtv 86 1999 26 1138 Filbert Street   Imagine Entertainment 64 MCA / Universal Pictures 49 Ron Howard 78 Lowell Ganz 79 Matthew McConaughey 220 Jenna Elfman 67  
458 Edtv 86 1999 26 North Beach Video (1398 Grant Avenue at Green) The video store has since moved to an adjacent location. Imagine Entertainment 64 MCA / Universal Pictures 49 Ron Howard 78 Lowell Ganz 79 Matthew McConaughey 220 Jenna Elfman 67  

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