About this Dataset

Code Enforcement Active Pipeline

Please note that this data set contains Code Enforcement cases from May 12th, 2009 to present. For the purpose of analyzing active cases, please filter for "Open" on the first column, "O/C". Cases are closed in when the in rem judgement is paid and violations are abated. Please see https://www.nola.gov/code-enforcement/ for more information.
Organization: City of New Orleans
Last updated: 2020-11-12T13:55:52.139092
Tags: active, blightstatus, case, violation

Tables

Table 1

@usgov.city_of_new_orleans_code_enforcement_active_pipeline.table_1

5.07 MB
35,097 rows
28 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" TIMESTAMP,
  "lastpermit" VARCHAR,
  "permitfiling" VARCHAR,
  "permittype" VARCHAR,
  "permitstatus" VARCHAR,
  "unpaidfees" BIGINT,
  "geoaddress" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zipcode" DOUBLE,
  "geopin" VARCHAR,
  "xpos" DOUBLE,
  "ypos" DOUBLE,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "caseid" BIGINT,
  "pointlocation" VARCHAR
);