Name: Occupational Business License Data For The Office Of Business And External Services
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Occupational Business License Data For The Office Of Business And External Services

A dataset of business license applications and their statuses from January 1st, 2018 to current day.
Organization: City of New Orleans
Last updated: 2022-12-02T18:13:12.281401
Tags: business, businesses, economic-development, license, licenses, occupational, permit, permits

Tables

Table 1

@usgov.city_of_new_orleans_occupational_business_license_for__150ab04c.table_1

2.69 MB
17,889 rows
44 columns

CREATE TABLE table_1 (
  "isclosed" BOOLEAN,
  "isdeleted" BOOLEAN,
  "licid" BIGINT,
  "numstring" VARCHAR,
  "address" VARCHAR,
  "descr" VARCHAR,
  "submittaltype" BIGINT,
  "class" VARCHAR,
  "type" VARCHAR,
  "exitcode" BIGINT,
  "reason" VARCHAR,
  "occnum" VARCHAR,
  "ishome" VARCHAR,
  "businesstype" VARCHAR,
  "status" VARCHAR,
  "category" VARCHAR,
  "naics" DOUBLE,
  "commentcount" DOUBLE,
  "currentstatus" VARCHAR,
  "sumfee" DOUBLE,
  "journalcount" BIGINT,
  "currentstatusdate" VARCHAR,
  "d_create" VARCHAR,
  "lastcomment" VARCHAR,
  "application_filed" VARCHAR,
  "application_review" VARCHAR,
  "approved" VARCHAR,
  "plan_review" VARCHAR,
  "zoning_application_review" VARCHAR,
  "firstcomment" VARCHAR,
  "issuedate" VARCHAR,
  "first_inspection" VARCHAR,
  "days_to_application_review" DOUBLE,
  "days_to_approved" DOUBLE,
  "days_to_plan_review" VARCHAR,
  "days_to_zoning_review" DOUBLE,
  "days_to_comment" DOUBLE,
  "days_to_issue_date" DOUBLE,
  "days_to_first_inspection" DOUBLE,
  "x" DOUBLE,
  "y" DOUBLE,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "location" VARCHAR
);