Baselight

Fire Inspections

City of San Francisco

@usgov.city_of_san_francisco_fire_inspections

Loading...
Loading...

About this Dataset

Fire Inspections

Information on Fire Inspections performed at a given location by the Fire Department. Key fields include Inspection Number, Address, Inspection Type, Start DtTm, End Dttm, Disposition
Organization: City of San Francisco
Last updated: 2020-11-10T16:57:03.166423
Tags: building-safety, fire-inspections, fire-safety

Tables

Table 1

@usgov.city_of_san_francisco_fire_inspections.table_1
  • 19.13 MB
  • 408073 rows
  • 49 columns
Loading...

CREATE TABLE table_1 (
  "inspection_number" BIGINT,
  "inspection_type" VARCHAR,
  "inspection_type_description" VARCHAR,
  "address" VARCHAR,
  "zipcode" VARCHAR,
  "battalion" VARCHAR,
  "station_area" VARCHAR,
  "fire_prevention_district" VARCHAR,
  "billable_inspection" BOOLEAN,
  "inspection_start_date" TIMESTAMP,
  "inspection_end_date" TIMESTAMP,
  "inspection_status" VARCHAR,
  "return_date" TIMESTAMP,
  "corrective_action_date" TIMESTAMP,
  "referral_agency" VARCHAR,
  "complaint_number" DOUBLE,
  "permit_number" DOUBLE,
  "referral_number" DOUBLE,
  "violation_number" DOUBLE,
  "dbi_application_number" VARCHAR,
  "invoice_date" TIMESTAMP,
  "second_notice_date" TIMESTAMP,
  "final_notice_date" TIMESTAMP,
  "lien_date" TIMESTAMP,
  "sent_to_bureau_of_delinquent_revenue" BOOLEAN,
  "invoice_amount" DOUBLE,
  "fee" DOUBLE,
  "penalty_amount" DOUBLE,
  "posting_fee" DOUBLE,
  "interest_amount" DOUBLE,
  "paid_amount" DOUBLE,
  "paid_date" TIMESTAMP,
  "supervisor_district" DOUBLE,
  "neighborhood_district" VARCHAR,
  "location" VARCHAR,
  "data_as_of" VARCHAR,
  "data_loaded_at" VARCHAR,
  "neighborhoods_old_2" DOUBLE,
  "zip_codes_2" DOUBLE,
  "fire_prevention_districts_2" DOUBLE,
  "police_districts_2" DOUBLE,
  "supervisor_districts_2" DOUBLE,
  "central_market_tenderloin_boundary_2" DOUBLE,
  "central_market_tenderloin_boundary_polygon_updated_2" DOUBLE,
  "neighborhoods_2" DOUBLE,
  "sf_find_neighborhoods_2" DOUBLE,
  "current_police_districts_2" DOUBLE,
  "current_supervisor_districts_2" DOUBLE,
  "analysis_neighborhoods_2" DOUBLE
);

Share link

Anyone who has the link will be able to view this.