Film_Locations_in_San_Francisco

Data source: data.sfgov.org

12 rows where Writer = 36

View and edit SQL

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
184 Boys and Girls 39 2000 25 1122 Folsom Street   Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  
185 Boys and Girls 39 2000 25 St. Peter & Paul's Church (666 Filbert Street, Washington Square) Though Marilyn Monroe and Joe DiMaggio were not allowed to be married at the Church (DiMaggio had married his first wife at the Church but was divorced), the couple returned to the steps of the Church for photos, following their City Hall nuptials. Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  
186 Boys and Girls 39 2000 25 Golden Gate Bridge With 23 miles of ladders and 300,000 rivets in each tower, the Golden Gate Bridge was the world's longest span when it opened in 1937. Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  
187 Boys and Girls 39 2000 25 Fisherman's Wharf Supposedly, Mikhail S. Gorbachev has said that his favorite part of visiting America was touring Fisherman's Wharf. Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  
188 Boys and Girls 39 2000 25 Ferry Building Every hour and half-hour, the clock bell atop the Ferry Building chimes portions of the Westminster Quarters. Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  
189 Boys and Girls 39 2000 25 Coit Tower The Tower was funded by a gift bequeathed by Lillie Hitchcock Coit, a socialite who reportedly liked to chase fires. Though the tower resembles a firehose nozzle, it was not designed this way. Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  
190 Boys and Girls 39 2000 25 City Hall The dome of SF's City Hall is almost a foot taller than that of the US Capitol Building. In 1954, Joe DiMaggio and Marilyn Monroe married at the Beaux Arts-style building. Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  
191 Boys and Girls 39 2000 25 Lombard Street Lombard Street is not actually the most crooked in SF. That honor goes to Potrero Hill's Vermont Street between 22nd and 23rd. Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  
192 Boys and Girls 39 2000 25 Chinatown First established in the mid-19th Century, SF's Chinatown is the oldest and largest Chinatown in the US. Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  
193 Boys and Girls 39 2000 25 Aquatic Park (Jefferson Street) Located at one end of Fisherman's Wharf, Aquatic Park was built as part of FDR's Works Progress Administration Project. Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  
194 Boys and Girls 39 2000 25 Alcatraz Island Alcatraz Island was a military fort before it became a prison. Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  
195 Boys and Girls 39 2000 25 628 Cole Street   Punch 21 Productions 34 Dimension Films 28 Robert Iscove 37 The Drews 36 Freddie Prinze, Jr. 271 Alyson Hannigan 34  

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