Dataset: Historical Occupational Business Licenses 2015

About this Dataset

Historical Occupational Business Licenses 2015

Historical list of businesses operating in New Orleans with valid occupational licenses during calendar year 2015.
Organization: City of New Orleans
Last updated: 2020-11-12T13:57:01.189188
Tags: business, license

Tables

Table 1

@usgov.city_of_new_orleans_historical_occupational_business_l_c35f7f24.table_1

1.47 MB
13860 rows
23 columns


CREATE TABLE table_1 (
  "businessname" VARCHAR,
  "ownername" VARCHAR,
  "businesstype" VARCHAR,
  "businessstartdate" TIMESTAMP,
  "businessclosedate" TIMESTAMP,
  "address" VARCHAR,
  "streetnumber" VARCHAR,
  "streetdirection" VARCHAR,
  "streetname" VARCHAR,
  "streetsuffix" VARCHAR,
  "suite" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" VARCHAR,
  "phonenumber" VARCHAR,
  "mailaddress" VARCHAR,
  "mailsuite" VARCHAR,
  "mailcity" VARCHAR,
  "mailstate" VARCHAR,
  "mailzip" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location" VARCHAR
);