About this Dataset

Department Of Inspections And Standards Permits 2009-2018

Includes Building, Electrical, Mechanical, and Plumbing permits issued by the Department of Inspections and Standards through September 18, 2018. The data spans the use of several different systems and has been converted from its original forms to comply with the Building and Land Development Specification (more info available at http://permitdata.org/).
Organization: City of Providence
Last updated: 2020-11-12T12:32:06.191021
Tags: construction, neighborhood

Tables

Table 1

@usgov.city_of_providence_department_of_inspections_and_stand_f047c98a.table_1

8.12 MB
80,874 rows
27 columns

CREATE TABLE table_1 (
  "permitnum" VARCHAR,
  "permittype" VARCHAR,
  "permittypemapped" VARCHAR,
  "mbl" VARCHAR,
  "originaladdress1" VARCHAR,
  "originalcity" VARCHAR,
  "originalstate" VARCHAR,
  "originalzip" BIGINT,
  "description" VARCHAR,
  "estprojectcost" DOUBLE,
  "applieddate" VARCHAR,
  "issueddate" VARCHAR,
  "completeddate" TIMESTAMP,
  "statuscurrent" VARCHAR,
  "statuscurrentmapped" VARCHAR,
  "statusdate" VARCHAR,
  "permitclass" VARCHAR,
  "permitclassmapped" VARCHAR,
  "workclass" VARCHAR,
  "workclassmapped" VARCHAR,
  "totalsqft" DOUBLE,
  "contractorfullname" VARCHAR,
  "contractorcompanyname" VARCHAR,
  "contractorlicnum" VARCHAR,
  "contractorstatelic" VARCHAR,
  "proposeduse" VARCHAR,
  "georeference" VARCHAR
);