Name: Permits - BLDS
Creator: US Government
License: http://creativecommons.org/publicdomain/zero/1.0/legalcode

About this Dataset

Permits - BLDS

City of New Orleans permit data starting from 1/01/2012. This dataset has been transformed to meet the standards outlined by the Building and Land Development Specification (BLDS).
Organization: City of New Orleans
Last updated: 2020-11-12T13:55:49.547961
Tags: blds, permits

Tables

Table 1

@usgov.city_of_new_orleans_permits_blds.table_1

63.8 MB
426012 rows
33 columns


CREATE TABLE table_1 (
  "permitnum" VARCHAR,
  "description" VARCHAR,
  "applieddate" VARCHAR,
  "issuedate" VARCHAR,
  "completedate" VARCHAR,
  "statuscurrent" VARCHAR,
  "originaladdress1" VARCHAR,
  "originalcity" VARCHAR,
  "originalstate" VARCHAR,
  "originalzip" DOUBLE,
  "permitclass" VARCHAR,
  "workclass" VARCHAR,
  "permittype" VARCHAR,
  "permittypedesc" VARCHAR,
  "statusdate" VARCHAR,
  "totalsqft" BIGINT,
  "link" VARCHAR,
  "location" VARCHAR,
  "estprojectcost" BIGINT,
  "pin" VARCHAR,
  "contractorcompanyname" VARCHAR,
  "contractortrade" VARCHAR,
  "contractortrademapped" VARCHAR,
  "contractorlicnum" VARCHAR,
  "contractorstatelic" VARCHAR,
  "expiresdate" VARCHAR,
  "coissueddate" VARCHAR,
  "publisher" VARCHAR,
  "fee" DOUBLE,
  "workclassmapped" VARCHAR,
  "permitclassmapped" VARCHAR,
  "permittypemapped" VARCHAR,
  "statuscurrentmapped" VARCHAR
);