Film_Locations_in_San_Francisco

Data source: data.sfgov.org

58 rows where Production Company = 108

View and edit SQL

Suggested facets: Title, Release Year

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
912 Murder in the First, Season 1 171 2014 11 1821 Alabama Street   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
913 Murder in the First, Season 1 171 2014 11 Hall of Justice (850 Bryant Street)   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
914 Murder in the First, Season 1 171 2014 11 Cameron House (920 Sacramento Street)   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
915 Murder in the First, Season 1 171 2014 11 504 Broadway   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
916 Murder in the First, Season 1 171 2014 11 9 Calhoun Terrace   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
917 Murder in the First, Season 1 171 2014 11 AT&T Park   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
918 Murder in the First, Season 1 171 2014 11 Berry Street between 3rd and 4th Streets   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
919 Murder in the First, Season 1 171 2014 11 Kearny Street between Broadway and Pacific Avenue   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
920 Murder in the First, Season 1 171 2014 11 731 Grant Avenue   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
921 Murder in the First, Season 1 171 2014 11 Waverly Alley between Grant and Sacramento Streets   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
922 Murder in the First, Season 1 171 2014 11 Joice Street at Clay Street   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
923 Murder in the First, Season 1 171 2014 11 Palace of Fine Arts (3301 Lyon Street)   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
924 Murder in the First, Season 1 171 2014 11 800 Bay Street   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
925 Murder in the First, Season 1 171 2014 11 1201 Columbus Avenue   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
926 Murder in the First, Season 1 171 2014 11 Pier 45 The famous Musee Mecanique is located on Pier 45 Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
927 Murder in the First, Season 1 171 2014 11 369 Embarcadero   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
928 Murder in the First, Season 1 171 2014 11 Dolores Park   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
929 Murder in the First, Season 1 171 2014 11 24th Street between Folsom and Harrison Streets   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
930 Murder in the First, Season 1 171 2014 11 13 Lucky Street   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
931 Murder in the First, Season 1 171 2014 11 1541 Grove Street   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
932 Murder in the First, Season 1 171 2014 11 Ida B. Wells High School (1099 Hayes Street) Ida B. Wells High School is named after the African-American journalist, suffragist and early leader in the Civil Rights Movement Ida B. Wells Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
933 Murder in the First, Season 1 171 2014 11 Alamo Square Park   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
934 Murder in the First, Season 1 171 2014 11 50 California Street   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
935 Murder in the First, Season 1 171 2014 11 373 Columbus Avenue   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
936 Murder in the First, Season 1 171 2014 11 350 Union Street   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
937 Murder in the First, Season 2 172 2015 10 Potrero Hill Recreation Center (801 Arkansas Street)   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
938 Murder in the First, Season 2 172 2015 10 1243 19th Street   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
939 Murder in the First, Season 2 172 2015 10 372/374 Pennsylvania Avenue   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
940 Murder in the First, Season 2 172 2015 10 Stevenson Alley   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
941 Murder in the First, Season 2 172 2015 10 901 Missouri Street   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
942 Murder in the First, Season 2 172 2015 10 83 Watchman Way   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
943 Murder in the First, Season 2 172 2015 10 1059 Texas Street   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
944 Murder in the First, Season 2 172 2015 10 Sue Bierman Park   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
945 Murder in the First, Season 2 172 2015 10 Embarcadero Street at Washington Street   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
946 Murder in the First, Season 2 172 2015 10 Treasure Island   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
947 Murder in the First, Season 2 172 2015 10 Pier 50   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
948 Murder in the First, Season 2 172 2015 10 435 Broadway   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
949 Murder in the First, Season 2 172 2015 10 Columbus Avenue between Washington and Bay Streets   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
950 Murder in the First, Season 2 172 2015 10 Grant Avenue between Clay and Washington Streets   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
951 Murder in the First, Season 2 172 2015 10 1400 16th Street   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
952 Murder in the First, Season 2 172 2015 10 Pennsylvania Avenue at 19th Street   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
953 Murder in the First, Season 2 172 2015 10 Harriet Street between Bryant and Brannan Streets   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
954 Murder in the First, Season 2 172 2015 10 Boardman Place between Bryant and Brannan Streets   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
955 Murder in the First, Season 3 173 2016 30 Golden Gate Park   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
956 Murder in the First, Season 3 173 2016 30 Civic Center Plaza   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
957 Murder in the First, Season 3 173 2016 30 500 Grove Street   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
958 Murder in the First, Season 3 173 2016 30 600 Octavia Street   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
959 Murder in the First, Season 3 173 2016 30 535 Octavia Street   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
960 Murder in the First, Season 3 173 2016 30 Patricia's Green   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
961 Murder in the First, Season 3 173 2016 30 Ivy Street between Laguna and Gough Streets   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
962 Murder in the First, Season 3 173 2016 30 Linden Alley between Octavia and Gough Streets   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
963 Murder in the First, Season 3 173 2016 30 Hall of Justice (850 Bryant Street)   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
964 Murder in the First, Season 3 173 2016 30 Harriet Alley   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
965 Murder in the First, Season 3 173 2016 30 Howard Street at Steuart Street   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
966 Murder in the First, Season 3 173 2016 30 Red's Java House (Pier 30)   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
967 Murder in the First, Season 3 173 2016 30 887 De Haro Street   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
968 Murder in the First, Season 3 173 2016 30 Pier 96   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502
969 Murder in the First, Season 3 173 2016 30 2633 Vallejo Street   Turner North Center Productions 108 Turner Network Television (TNT) 69 Steven Bochcho 146 Eric Lodal 150 Taye Diggs 103 Kathleen Robertson 131 Ian Anthony Dale 502

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