About this Dataset

Building And Safety Code Enforcement Case (Closed)

This dataset has been retired and no longer updated. Please use the new dataset found in: https://data.lacity.org/City-Infrastructure-Service-Requests/Building-and-Safety-Code-Enforcement-Case-Closed-N/rken-a55j
Organization: City of Los Angeles
Last updated: 2020-11-10T17:52:30.999971
Tags: aim, billboard, building, building-and-safety, case, case-number, citation, cnap, code-enforcement, construction, construction-services, department-of-building-and-safety, ladbs, pace, safety, sign, veip, violation

Tables

Table 1

@usgov.city_of_los_angeles_building_and_safety_code_enforceme_927f065c.table_1

15.65 MB
411,758 rows
16 columns

CREATE TABLE table_1 (
  "case_number" VARCHAR,
  "ladbs_inspection_district" VARCHAR,
  "address_house_number" DOUBLE,
  "address_house_fraction_number" VARCHAR,
  "address_street_direction" VARCHAR,
  "address_street_name" VARCHAR,
  "address_street_suffix" VARCHAR,
  "address_street_suffix_direction" VARCHAR,
  "address_zip" DOUBLE,
  "date_case_generated" VARCHAR,
  "date_case_closed" VARCHAR,
  "parcel_identification_number_pin" VARCHAR  -- Parcel Identification Number (PIN),
  "case_type" VARCHAR,
  "area_planning_commission_apc" VARCHAR  -- Area Planning Commission (APC),
  "status_of_case" VARCHAR,
  "latitude_longitude" VARCHAR
);