Basic Business Licenses by US Government | Finance and Economics

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

28.62 MB
248966 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
);