Name: Building Permits
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Building Permits

All building permits issued or in progress within the city of Seattle.
Organization: City of Seattle
Last updated: 2024-12-16T22:21:47.930468
Tags: building-applications, building-permits, construction-permits, permit-applications, sdci, seattle-department-of-construction-and-inspections

Tables

Table 1

@usgov.city_of_seattle_building_permits_0f57c.table_1

22.97 MB
184,771 rows
40 columns

CREATE TABLE table_1 (
  "permitnum" VARCHAR,
  "permitclass" VARCHAR,
  "permitclassmapped" VARCHAR,
  "permittypemapped" VARCHAR,
  "permittypedesc" VARCHAR,
  "description" VARCHAR,
  "housingunits" BIGINT,
  "housingunitsremoved" DOUBLE,
  "housingunitsadded" DOUBLE,
  "estprojectcost" DOUBLE,
  "applieddate" TIMESTAMP,
  "issueddate" TIMESTAMP,
  "expiresdate" TIMESTAMP,
  "completeddate" TIMESTAMP,
  "statuscurrent" VARCHAR,
  "relatedmup" VARCHAR,
  "originaladdress1" VARCHAR,
  "originalcity" VARCHAR,
  "originalstate" VARCHAR,
  "originalzip" DOUBLE,
  "contractorcompanyname" VARCHAR,
  "link" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location1" VARCHAR,
  "totaldaysplanreview" DOUBLE,
  "daysinitialplanreview" DOUBLE,
  "daysplanreviewcity" DOUBLE,
  "daysoutcorrections" DOUBLE,
  "numberreviewcycles" DOUBLE,
  "initialreviewcompletedate" VARCHAR,
  "planreviewcompletedate" VARCHAR,
  "daysissuepermitcity" DOUBLE,
  "readytoissuedate" VARCHAR,
  "zoning" VARCHAR,
  "dwellingunittype" VARCHAR,
  "standardplan" DOUBLE,
  "dependentbuilding" BIGINT,
  "parentpermitnum" VARCHAR,
  "housingcategory" VARCHAR
);