Fire Inspections
City of San Francisco
@usgov.city_of_san_francisco_fire_inspections
City of San Francisco
@usgov.city_of_san_francisco_fire_inspections
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
);
Anyone who has the link will be able to view this.