Film_Locations_in_San_Francisco

Data source: data.sfgov.org

17 rows where Distributor = 8

View and edit SQL

Suggested facets: Title, Release Year, Fun Facts, Production Company, Director, Writer, Actor 1, Actor 2

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
26 Ant-Man 11 2015 10 420 Jones St. at Ellis St.   PYM Particles Productions, LLC 9 Walt Disney Studios Motion Pictures 8 Peyton Reed 10 Gabriel Ferrari  9 Michael Douglas 245 Paul Rudd 9  
51 Ant-Man 11 2015 10 Broadway between Powell and Davis Driving shots PYM Particles Productions, LLC 9 Walt Disney Studios Motion Pictures 8 Peyton Reed 10 Gabriel Ferrari  9 Michael Douglas 245 Paul Rudd 9  
77 Ant-Man 11 2015 10 Conzelman Rd at McCollough Rd and down Conzelman Rd. Aerial shots PYM Particles Productions, LLC 9 Walt Disney Studios Motion Pictures 8 Peyton Reed 10 Gabriel Ferrari  9 Michael Douglas 245 Paul Rudd 9  
78 Ant-Man 11 2015 10 Lombard at Hyde   PYM Particles Productions, LLC 9 Walt Disney Studios Motion Pictures 8 Peyton Reed 10 Gabriel Ferrari  9 Michael Douglas 245 Paul Rudd 9  
79 Ant-Man 11 2015 10 601 Buena Vista Ave West at Java St.   PYM Particles Productions, LLC 9 Walt Disney Studios Motion Pictures 8 Peyton Reed 10 Gabriel Ferrari  9 Michael Douglas 245 Paul Rudd 9  
80 Ant-Man 11 2015 10 Columbus between Bay and Washington Driving shots PYM Particles Productions, LLC 9 Walt Disney Studios Motion Pictures 8 Peyton Reed 10 Gabriel Ferrari  9 Michael Douglas 245 Paul Rudd 9  
81 Ant-Man 11 2015 10 California between Kearney and Davis Driving shots PYM Particles Productions, LLC 9 Walt Disney Studios Motion Pictures 8 Peyton Reed 10 Gabriel Ferrari  9 Michael Douglas 245 Paul Rudd 9  
82 Ant-Man 11 2015 10 Pine between Kearney and Davis Driving shots PYM Particles Productions, LLC 9 Walt Disney Studios Motion Pictures 8 Peyton Reed 10 Gabriel Ferrari  9 Michael Douglas 245 Paul Rudd 9  
83 Ant-Man 11 2015 10 Market between Stuart and Van Ness Driving shots PYM Particles Productions, LLC 9 Walt Disney Studios Motion Pictures 8 Peyton Reed 10 Gabriel Ferrari  9 Michael Douglas 245 Paul Rudd 9  
84 Ant-Man 11 2015 10 Grant between Bush and Broadway Driving shots PYM Particles Productions, LLC 9 Walt Disney Studios Motion Pictures 8 Peyton Reed 10 Gabriel Ferrari  9 Michael Douglas 245 Paul Rudd 9  
85 Ant-Man 11 2015 10 Intersection of Broadway at Kearney Driving shots PYM Particles Productions, LLC 9 Walt Disney Studios Motion Pictures 8 Peyton Reed 10 Gabriel Ferrari  9 Michael Douglas 245 Paul Rudd 9  
86 Ant-Man 11 2015 10 Intersection of California at Polk Driving shots PYM Particles Productions, LLC 9 Walt Disney Studios Motion Pictures 8 Peyton Reed 10 Gabriel Ferrari  9 Michael Douglas 245 Paul Rudd 9  
87 Ant-Man 11 2015 10 Treasure Island, Building #1, Ave of the Palms Aerial and exterior shots PYM Particles Productions, LLC 9 Walt Disney Studios Motion Pictures 8 Peyton Reed 10 Gabriel Ferrari  9 Michael Douglas 245 Paul Rudd 9  
970 Need For Speed 174 2014 11 Embarcadero from Broadway to Folsom   Need For Speed Productions, LLC 109 Walt Disney Studios Motion Pictures 8 Scott Waugh 147 George Gatins 151 Aaron Paul 344 Dominic Cooper 132 Imogen Poots 503
971 Need For Speed 174 2014 11 California St from Taylor to Powell   Need For Speed Productions, LLC 109 Walt Disney Studios Motion Pictures 8 Scott Waugh 147 George Gatins 151 Aaron Paul 344 Dominic Cooper 132 Imogen Poots 503
972 Need For Speed 174 2014 11 Mason St from Pine to Sacramento   Need For Speed Productions, LLC 109 Walt Disney Studios Motion Pictures 8 Scott Waugh 147 George Gatins 151 Aaron Paul 344 Dominic Cooper 132 Imogen Poots 503
973 Need For Speed 174 2014 11 Powell St. from Geary to Sacramento   Need For Speed Productions, LLC 109 Walt Disney Studios Motion Pictures 8 Scott Waugh 147 George Gatins 151 Aaron Paul 344 Dominic Cooper 132 Imogen Poots 503

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