About this Dataset

Building And Safety Customer Service Request (Closed)

A Customer Service Request is a request received by the Department of Building and Safety from the City's constituents to investigate a site/property for a possible violation of the City's building, electrical, mechanical and zoning regulations, which are elements of the Los Angeles Municipal Code. Any investigative action taken by a Building and Safety inspector constitutes the opening of a case. Where no Code violation is found, the case is immediately closed. If a Code violation is found, the case remains open until the site/property satisfies the requirements for Code compliance.
Organization: City of Los Angeles
Last updated: 2020-11-10T17:52:10.473970
Tags: building, building-and-safety, case-number, construction, csr, csr-number, customer-service, customer-service-request, department-of-building-and-safety, ladbs, safety

Tables

Table 1

@usgov.city_of_los_angeles_building_and_safety_customer_servi_1fbc00e6.table_1

12.44 MB
282,346 rows
20 columns

CREATE TABLE table_1 (
  "csr_number" BIGINT,
  "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_street_zip" DOUBLE,
  "date_received" VARCHAR,
  "date_closed" VARCHAR,
  "due_date" VARCHAR,
  "case_flag" VARCHAR,
  "csr_priority" VARCHAR,
  "parcel_identification_number_pin" VARCHAR  -- Parcel Identification Number (PIN),
  "csr_problem_type" VARCHAR,
  "area_planning_commission_apc" VARCHAR  -- Area Planning Commission (APC),
  "case_number_related_to_csr" VARCHAR,
  "response_days" BIGINT,
  "latitude_longitude" VARCHAR
);