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

About this Dataset

Permits

City of New Orleans permit data starting from 1/01/2012; Updated nightly.Note: For download of entire dataset, export as .csv
Organization: City of New Orleans
Last updated: 2020-11-12T13:56:38.234566
Tags: city-of-new-orleans, permits

Tables

Table 1

@usgov.city_of_new_orleans_permits.table_1

40.42 MB
324073 rows
42 columns


CREATE TABLE table_1 (
  "address" VARCHAR,
  "owner" VARCHAR,
  "description" VARCHAR,
  "numstring" VARCHAR,
  "isclosed" BOOLEAN,
  "type" VARCHAR,
  "code" VARCHAR,
  "division" VARCHAR,
  "m_s" VARCHAR,
  "filingdate" VARCHAR,
  "issuedate" VARCHAR,
  "currentstatus" VARCHAR,
  "nextstatus" VARCHAR,
  "currentstatusdate" VARCHAR,
  "nextstatusdate" VARCHAR,
  "landuse" VARCHAR,
  "landuseshort" VARCHAR,
  "projectname" VARCHAR,
  "unpaidfees" DOUBLE,
  "totalfees" DOUBLE,
  "bldgarea" BIGINT,
  "constrval" BIGINT,
  "bondamount" BIGINT,
  "opencomments" BIGINT,
  "applicant" VARCHAR,
  "totalinspections" BIGINT,
  "contractors" VARCHAR,
  "pin" VARCHAR,
  "beds" BIGINT,
  "baths" DOUBLE,
  "heattype" VARCHAR,
  "secondfloo" BIGINT,
  "basementar" BIGINT,
  "daysopen" BIGINT,
  "daysissued" BIGINT,
  "leadagency" VARCHAR,
  "exitreason" VARCHAR,
  "subdivision" VARCHAR,
  "councildist" VARCHAR,
  "zoning" VARCHAR,
  "historicdistrict" VARCHAR,
  "location_1" VARCHAR
);