Code Enforcement Active Pipeline by US Government | Demographics and Population Studies

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

4.84 MB
35097 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
);