About this Dataset

Fire Protection Systems Permits

"This dataset contains data for Fire Protection Systems permits including status and work performed. A fire protection is required for all work involving any fire protection system addition or modification. Permits are required any time that a fire protection system is affected by any sort of work including repair.
Update Frequency : Daily"
Organization: Montgomery County of Maryland
Last updated: 2020-11-10T16:58:06.839261
Tags: fire, permits, permitting, protection, system

Tables

Table 1

@usgov.montgomery_county_of_maryland_fire_protection_systems_permits.table_1

3.78 MB
49,774 rows
23 columns

CREATE TABLE table_1 (
  "application_type" VARCHAR,
  "permit_number" BIGINT,
  "work_type" VARCHAR,
  "use_code" VARCHAR,
  "added_date" TIMESTAMP,
  "issue_date" TIMESTAMP,
  "final_date" TIMESTAMP,
  "expired_date" TIMESTAMP,
  "status" VARCHAR,
  "building_area" DOUBLE,
  "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
);