Name: Code Enforcement All Cases
Creator: US Government
License: http://creativecommons.org/publicdomain/zero/1.0/legalcode

About this Dataset

Code Enforcement All Cases

Code Enforcement All Cases.
Organization: City of New Orleans
Last updated: 2020-11-12T13:56:49.625102
Tags: blightstatus, case, violation

Tables

Table 1

@usgov.city_of_new_orleans_code_enforcement_all_cases.table_1

12.89 MB
173757 rows
26 columns


CREATE TABLE table_1 (
  "o_c" VARCHAR,
  "caseno" VARCHAR,
  "location" VARCHAR,
  "stage" VARCHAR,
  "keystatus" VARCHAR,
  "statdate" VARCHAR,
  "casefiled" VARCHAR,
  "initinspection" VARCHAR,
  "initinspresult" VARCHAR,
  "prevhearingdate" TIMESTAMP,
  "prevhearingresult" VARCHAR,
  "nexthearingdate" VARCHAR,
  "lastpermit" VARCHAR,
  "permitfiling" VARCHAR,
  "permittype" VARCHAR,
  "permitstatus" VARCHAR,
  "geoaddress" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zipcode" DOUBLE,
  "geopin" VARCHAR,
  "xpos" DOUBLE,
  "ypos" DOUBLE,
  "caseid" BIGINT,
  "titleresearch" VARCHAR,
  "recordationdate" VARCHAR
);