Dataset: Listing Of All Businesses

About this Dataset

Listing Of All Businesses

Listing of all (active and inactive) businesses registered with the Office of Finance. An "active" business is defined as a registered business whose owner has not notified the Office of Finance of a cease of business operations. Update Interval: Monthly. NAICS Codes are from 2007 NAICS: https://www.census.gov/cgi-bin/sssd/naics/naicsrch?chart=2007
Organization: City of Los Angeles
Last updated: 2020-11-10T17:52:32.469352

Tables

Table 1

@usgov.city_of_los_angeles_listing_of_all_businesses.table_1

134.53 MB
1607924 rows
16 columns


CREATE TABLE table_1 (
  "location_account" VARCHAR,
  "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
);