Dataset: San Francisco Film Locations

About this Dataset

San Francisco Film Locations

If you love movies, and you love San Francisco, you're bound to love this -- a listing of filming locations of movies shot in San Francisco starting from 1924. You'll find the titles, locations, fun facts, names of the director, writer, actors, and studio for most of these films.

This dataset is originally served by https://data.sfgov.org. However, there is a 1000-record per transaction with the API endpoint.

Serving a copy here on Kaggle allows a single transaction with the Kaggle API endpoint for the whole dataset. This provides data source integration into source code with greater ease.

Tables

Film Locations In San Francisco 20240504

@kaggle.martinjohnhborja_san_francisco_film_locations.film_locations_in_san_francisco_20240504

109.61 KB
2084 rows
14 columns


CREATE TABLE film_locations_in_san_francisco_20240504 (
  "title" VARCHAR,
  "release_year" BIGINT,
  "locations" VARCHAR,
  "fun_facts" VARCHAR,
  "production_company" VARCHAR,
  "distributor" VARCHAR,
  "director" VARCHAR,
  "writer" VARCHAR,
  "actor_1" VARCHAR,
  "actor_2" VARCHAR,
  "actor_3" VARCHAR,
  "sf_find_neighborhoods" DOUBLE,
  "analysis_neighborhoods" DOUBLE,
  "current_supervisor_districts" DOUBLE
);