Name: Plan Review
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Plan Review

This dataset shows the steps taken in building plan review for permits in the City ofSeattle
Organization: City of Seattle
Last updated: 2025-10-11T22:20:14.701203
Tags: building-applications, building-permits, construction-permits, permit-applications, sdci, seattle-department-of-construction-and-inspections

Tables

Table 1

@usgov.city_of_seattle_plan_review_94209.table_1

15.48 MB
254,007 rows
46 columns

CREATE TABLE table_1 (
  "permitnum" VARCHAR,
  "reviewcycle" BIGINT,
  "reviewtype" VARCHAR,
  "reviewteam" VARCHAR,
  "reviewer" VARCHAR,
  "reviewteamassigndate" VARCHAR,
  "reviewerassigndate" VARCHAR,
  "reviewerfinishdate" VARCHAR,
  "reviewresultdesc" VARCHAR,
  "reviewcomplexity" VARCHAR,
  "reviewcomplexitydesc" VARCHAR,
  "reviewpriority" VARCHAR,
  "greenbuildingproject" VARCHAR,
  "permitclass" VARCHAR,
  "permitclassmapped" VARCHAR,
  "permittypemapped" VARCHAR,
  "permittypedesc" VARCHAR,
  "description" VARCHAR,
  "totaldaysplanreview" DOUBLE,
  "daysinitialplanreview" DOUBLE,
  "daysplanreviewcity" DOUBLE,
  "daysoutcorrections" BIGINT,
  "numberreviewcycles" BIGINT,
  "applieddate" VARCHAR,
  "initialreviewcompletedate" VARCHAR,
  "planreviewcompletedate" VARCHAR,
  "readyissuedate" VARCHAR,
  "issueddate" VARCHAR,
  "relatedmup" VARCHAR,
  "housingunitsremoved" DOUBLE,
  "housingunitsadded" DOUBLE,
  "housingunits" BIGINT,
  "zoning" VARCHAR,
  "dwellingunittype" VARCHAR,
  "standardplan" BOOLEAN,
  "dependentbuilding" BIGINT,
  "parentpermitnum" VARCHAR,
  "originaladdress1" VARCHAR,
  "originalcity" VARCHAR,
  "originalstate" VARCHAR,
  "originalzip" DOUBLE,
  "contractorcompanyname" VARCHAR,
  "link" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "housingcategory" VARCHAR
);