About this Dataset

Certificate Of Occupancy

All applicants for a Basic Business License operating from a commercial location in the District of Columbia must provide a Certificate of Occupancy (C of O) for the premise address from which the business activity is conducted in order to demonstrate the activity does not conflict with building and zoning codes. A certificate of occupancy is needed to occupy any structure other than a single family dwelling. To include the following uses: two family flat, apartment house, and all commercial uses.
Organization: District of Columbia
Last updated: 2024-04-30T18:07:33.279048
Tags: certificate-of-occupancy, district-of-columbia, dob, dwelling, home, permit, washington-dc

Tables

Table 1

@usgov.district_of_columbia_certificate_of_occupancy.table_1

10.14 MB
74,953 rows
35 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "permit_number" VARCHAR,
  "issue_date" TIMESTAMP,
  "address" VARCHAR,
  "ward" VARCHAR,
  "description_of_occupancy" VARCHAR,
  "permission_granted_to" VARCHAR,
  "trading_as" VARCHAR,
  "occupancy_load" VARCHAR,
  "property_owner" VARCHAR,
  "owner_address" VARCHAR,
  "b_z_a_number" VARCHAR,
  "approved_building_code_use" VARCHAR,
  "approved_zoning_use" VARCHAR,
  "application_comments" VARCHAR,
  "expiration_date" TIMESTAMP,
  "mar_id" BIGINT,
  "x_coordinate" DOUBLE,
  "y_coordinate" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "dcs_last_mod_dttm" TIMESTAMP,
  "floors_occupied" VARCHAR,
  "zone" VARCHAR,
  "ssl" VARCHAR,
  "approved_zoning_general_use" VARCHAR,
  "occupied_sq_footage" DOUBLE,
  "approved_cofo" VARCHAR,
  "occpnt_tot_num_of_dwell_units" VARCHAR,
  "total_fee" BIGINT,
  "permitnumbers" VARCHAR,
  "conditional_restriction" VARCHAR,
  "approved_build_code_use_other" VARCHAR,
  "objectid" BIGINT
);