About this Dataset

Use And Occupancy Certificates

This dataset contains data for Use and Occupancy Certificates including status and work performed. A Use & Occupancy Certificate (U&O) is required before a building or space may be occupied. It is issued after the building or space has passed final inspections for building, electrical and mechanical and fire disciplines. The purpose of this certificate is to document that the use is permitted, and that all applicable safety code and health code requirements have been met. Each different use in a building must have a separate Use and Occupancy certificate.
Update Frequency : Daily
Organization: Montgomery County of Maryland
Last updated: 2020-11-10T16:57:59.883564
Tags: certificates, construction, occupancy, safety, use

Tables

Table 1

@usgov.montgomery_county_of_maryland_use_and_occupancy_certificates.table_1

1.05 MB
14793 rows
22 columns


CREATE TABLE table_1 (
  "application_type" VARCHAR,
  "permit_number" BIGINT,
  "work_type" VARCHAR,
  "added_date" TIMESTAMP,
  "issue_date" TIMESTAMP,
  "final_date" TIMESTAMP,
  "expired_date" TIMESTAMP,
  "status" VARCHAR,
  "building_area" BIGINT,
  "description_of_work" VARCHAR,
  "street_number" VARCHAR,
  "pre_direction" VARCHAR,
  "street_name" VARCHAR,
  "street_suffix" VARCHAR,
  "post_direction" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "general_location" VARCHAR,
  "location" VARCHAR
);