About this Dataset

Building And Safety Certificate Of Occupancy

The Department of Building and Safety is required by the Los Angeles Municipal Code to issue a Certificate of Occupancy for every building or structure in the City of Los Angeles. A Certificate of Occupancy is a document issued by the Department of Building and Safety certifying a building's compliance with applicable building codes and other laws, and indicating it to be in a condition suitable for occupancy.
Organization: City of Los Angeles
Last updated: 2020-11-10T17:52:04.865688
Tags: building, building-and-safety, building-permit, certificate, certificate-of-occupancy, cofo, cofo-number, construction, construction-services, department-of-building-and-safety, ladbs, occupancy, permit, permit-number, permit-type, safety

Tables

Table 1

@usgov.city_of_los_angeles_building_and_safety_certificate_of_cf2a68a3.table_1

6 MB
41,744 rows
56 columns

CREATE TABLE table_1 (
  "cofo_number" BIGINT,
  "cofo_issue_date" TIMESTAMP,
  "status" VARCHAR,
  "status_date" VARCHAR,
  "assessor_book" DOUBLE,
  "assessor_page" VARCHAR,
  "assessor_parcel" VARCHAR,
  "tract" VARCHAR,
  "block" VARCHAR,
  "lot" VARCHAR,
  "reference_old_permit" VARCHAR  -- Reference # (Old Permit #),
  "pcis_permit" VARCHAR  -- PCIS Permit #,
  "permit_type" VARCHAR,
  "permit_sub_type" VARCHAR,
  "permit_category" VARCHAR,
  "project_number" DOUBLE,
  "event_code" VARCHAR,
  "initiating_office" VARCHAR,
  "permit_issue_date" TIMESTAMP,
  "address_start" BIGINT,
  "address_fraction_start" VARCHAR,
  "address_end" BIGINT,
  "address_fraction_end" VARCHAR,
  "street_direction" VARCHAR,
  "street_name" VARCHAR,
  "street_suffix" VARCHAR,
  "suffix_direction" VARCHAR,
  "unit_range_start" VARCHAR,
  "unit_range_end" VARCHAR,
  "zip_code" DOUBLE,
  "work_description" VARCHAR,
  "valuation" DOUBLE,
  "floor_area_l_a_zoning_code_definition" DOUBLE  -- Floor Area-L.A. Zoning Code Definition,
  "n__of_residential_dwelling_units" DOUBLE  -- # Of Residential Dwelling Units,
  "n__of_stories" DOUBLE  -- # Of Stories,
  "contractor_s_business_name" VARCHAR,
  "contractor_address" VARCHAR,
  "contractor_city" VARCHAR,
  "contractor_state" VARCHAR,
  "license_type" VARCHAR,
  "license" DOUBLE  -- License #,
  "principal_first_name" VARCHAR,
  "principal_middle_name" VARCHAR,
  "principal_last_name" VARCHAR,
  "license_expiration_date" TIMESTAMP,
  "applicant_first_name" VARCHAR,
  "applicant_last_name" VARCHAR,
  "applicant_business_name" VARCHAR,
  "applicant_address_1" VARCHAR,
  "applicant_address_2" VARCHAR,
  "applicant_address_3" VARCHAR,
  "zone" VARCHAR,
  "occupancy" VARCHAR,
  "floor_area_l_a_building_code_definition" DOUBLE  -- Floor Area-L.A. Building Code Definition,
  "census_tract" DOUBLE,
  "latitude_longitude" VARCHAR
);