About this Dataset

Basic Business License In Last 30 Days

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:36:40.285516
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_license_in_last_30_days.table_1

373.46 KB
2694 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" TIMESTAMP,
  "license_issue_date" TIMESTAMP,
  "license_start_date" TIMESTAMP,
  "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
);