About this Dataset

Adjudication Enforcement Detailed Hearings Data For The Office Of Business And External Services

A dataset of all enforcement hearings against parcels within six adjudication departments - Code Enforcement, Alcohol Beverage Outlets (ABO), Historic District and Landmarks Commission (HDLC), Vieux Carré Commission (VCC), Short Term Rentals (STR) and Zoning - from January 1st, 2018 to current day.
Organization: City of New Orleans
Last updated: 2022-12-02T18:13:54.953506
Tags: abo, adjudication, blight, code-enforcement, hdlc, hearings, historic-district, landmarks, mpm, obes, str, vcc, zoning

Tables

Table 1

@usgov.city_of_new_orleans_adjudication_enforcement_detailed__c6c48d61.table_1

2.84 MB
46652 rows
26 columns


CREATE TABLE table_1 (
  "hearing_id" BIGINT,
  "incident_number" VARCHAR,
  "codeincidid" BIGINT,
  "o_c" VARCHAR,
  "address" VARCHAR,
  "agency" VARCHAR,
  "case_type" VARCHAR,
  "updatedtype" VARCHAR,
  "hearing_date" VARCHAR,
  "prevhearingdate" VARCHAR,
  "nexthearingdate" VARCHAR,
  "judgment" VARCHAR,
  "case_established" VARCHAR,
  "violation_count" BIGINT,
  "open_violations" BIGINT,
  "event_at_case_closed" VARCHAR,
  "close_reason" VARCHAR,
  "case_history" VARCHAR,
  "feecount" BIGINT,
  "courtfee" BIGINT,
  "sumfee" DOUBLE,
  "x" DOUBLE,
  "y" DOUBLE,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "location" VARCHAR
);