About this Dataset

Basic Business Licenses

In order to operate legally in District of Columbia, most businesses must get a Basic Business License (BBL) from the Department of Licensing and Consumer Protection (DLCP). The Basic Business License (BBL) Program streamlines District of Columbia business licensing procedures. The BBL groups licenses by the type of business activity and regulatory approvals required.
Organization: District of Columbia
Last updated: 2024-04-30T17:34:32.124822
Tags: basic-business-license, bbl, commercial-regulatory, district-of-columbia, dlcp, economic, feeds, livedataset, washington-dc

Tables

Table 1

@usgov.district_of_columbia_basic_business_licenses.table_1

30.01 MB
248,966 rows
44 columns

CREATE TABLE table_1 (
  "billing_address" VARCHAR,
  "billing_address_city_state_zip" VARCHAR,
  "agent_entity" VARCHAR,
  "agent_first_name" VARCHAR,
  "agent_last_name" VARCHAR,
  "agent_middle_name" VARCHAR,
  "agent_phone" VARCHAR,
  "site_address" VARCHAR,
  "bbl_city_state_zip" VARCHAR,
  "billing_name" VARCHAR,
  "customer_number" BIGINT,
  "dc_addr_flag" VARCHAR,
  "licensecategory" VARCHAR,
  "entity_name" VARCHAR,
  "first_name" VARCHAR,
  "last_name" VARCHAR,
  "dcs_add_date" VARCHAR,
  "license_end_date" VARCHAR,
  "license_issue_date" TIMESTAMP,
  "license_start_date" VARCHAR,
  "license_category_text" VARCHAR,
  "license_category_code" DOUBLE,
  "licensestatus" VARCHAR,
  "phone_number" VARCHAR,
  "objectid" BIGINT,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" VARCHAR,
  "bbl_license_fact_id" BIGINT,
  "dcs_last_mod_dttm" TIMESTAMP,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "xcoord" DOUBLE,
  "ycoord" DOUBLE,
  "zipcode" VARCHAR,
  "maraddressrepositoryid" DOUBLE,
  "ward" DOUBLE,
  "anc" VARCHAR,
  "smd" VARCHAR,
  "district" VARCHAR,
  "psa" DOUBLE,
  "neighborhoodcluster" VARCHAR,
  "businessimprovementdistrict" VARCHAR,
  "mainstreet" VARCHAR
);