Name: Listing Of All Los Angeles Businesses
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

Listing Of All Los Angeles Businesses

Source: https://data.lacity.org/Administration-Finance/Listing-of-All-Businesses/r4uk-afju

Listing of all (active and inactive) businesses registered with the Office of Finance in Los Angeles. An "active" business is defined as a registered business whose owner has not notified the Office of Finance of a cease of business operations.

NAICS Codes are from 2007 NAICS:
https://www.census.gov/cgi-bin/sssd/naics/naicsrch?chart=2007
Less

Tables

Listing Of All Businesses

@kaggle.peternooteboom_listing_of_all_los_angeles_businesses.listing_of_all_businesses

125.93 MB
1,440,750 rows
16 columns

CREATE TABLE listing_of_all_businesses (
  "location_account" VARCHAR  -- LOCATION ACCOUNT #,
  "business_name" VARCHAR,
  "dba_name" VARCHAR,
  "street_address" VARCHAR,
  "city" VARCHAR,
  "zip_code" VARCHAR,
  "location_description" VARCHAR,
  "mailing_address" VARCHAR,
  "mailing_city" VARCHAR,
  "mailing_zip_code" VARCHAR,
  "naics" DOUBLE,
  "primary_naics_description" VARCHAR,
  "council_district" BIGINT,
  "location_start_date" TIMESTAMP,
  "location_end_date" VARCHAR,
  "location" VARCHAR
);