About this Dataset

Historical Inspection Requests

This dataset includes requests for inspections not associated with issuance of a permit, beginning in November 1997 and ending in March 2005, from the Safety and Permits Information Network (SPIN). Inspection requests include complaints about violations of City code reported to Safety and Permits (e.g. building, zoning, and health codes) as well as non-complaint-related inspection requests for new business applications, alcoholic beverage outlets (ABO), zoning verifications, subdivisions, and address changes.
Organization: City of New Orleans
Last updated: 2020-11-12T13:56:12.506276
Tags: abo, code-enforcement, inspection, legacy, permit, violation, zoning

Tables

Table 1

@usgov.city_of_new_orleans_historical_inspection_requests.table_1

1.88 MB
19020 rows
26 columns


CREATE TABLE table_1 (
  "complaintnumber" VARCHAR,
  "recieveddate" VARCHAR,
  "housenum" DOUBLE,
  "streetdir" VARCHAR,
  "streetname" VARCHAR,
  "streetsuffix" VARCHAR,
  "unitnumber" VARCHAR,
  "violationaddress" VARCHAR,
  "category" VARCHAR,
  "violatorname" VARCHAR,
  "parcelowner" VARCHAR,
  "zoning" VARCHAR,
  "complaintmeth" VARCHAR,
  "complainttype" VARCHAR,
  "complaintclass" VARCHAR,
  "stopworkissued" VARCHAR,
  "description" VARCHAR,
  "inspector" DOUBLE,
  "resolutiontype" VARCHAR,
  "createdatetime" VARCHAR,
  "createopid" VARCHAR,
  "updatedatetime" VARCHAR,
  "updateopid" VARCHAR,
  "propertykey" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE
);