Name: Fire Safety Complaints
Creator: US Government
License: http://opendatacommons.org/licenses/pddl/1.0/

About this Dataset

Fire Safety Complaints

Information on Complaints received by the Fire Department (from the public) for a particular location. Key fields include Complaint Number, Complaint Type, Address, Disposition
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:06.189246
Tags: 311, fire-inspections, public-complaints

Tables

Table 1

@usgov.city_of_san_francisco_fire_safety_complaints.table_1

4.31 MB
72,048 rows
33 columns

CREATE TABLE table_1 (
  "complaint_id" VARCHAR,
  "primary" VARCHAR,
  "complaint_number" VARCHAR,
  "complaint_item_type" VARCHAR,
  "complaint_item_type_description" VARCHAR,
  "n_311_case_number" DOUBLE  -- 311 Case Number,
  "inspection_number" DOUBLE,
  "address" VARCHAR,
  "zipcode" BIGINT,
  "battalion" VARCHAR,
  "station_area" VARCHAR,
  "fire_prevention_district" VARCHAR,
  "received_date" TIMESTAMP,
  "entry_date" TIMESTAMP,
  "disposition" VARCHAR,
  "disposition_date" TIMESTAMP,
  "supervisor_district" DOUBLE,
  "neighborhood_district" VARCHAR,
  "location" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR,
  "neighborhoods_from_fyvs_ahh9_2" DOUBLE,
  "supervisor_districts_2" DOUBLE,
  "fire_prevention_districts_2" DOUBLE,
  "current_police_districts_2" DOUBLE,
  "neighborhoods_analysis_boundaries_2" DOUBLE  -- Neighborhoods - Analysis Boundaries 2,
  "zip_codes_2" DOUBLE,
  "neighborhoods_old_2" DOUBLE  -- Neighborhoods (old) 2,
  "police_districts_2" DOUBLE,
  "neighborhoods" DOUBLE,
  "sf_find_neighborhoods" DOUBLE,
  "current_police_districts_3" DOUBLE,
  "current_supervisor_districts" DOUBLE
);