About this Dataset

Corporate Registration

The Department of Licensing and Consumer Protection (DLCP) Business and Professional Licensing Administration Corporations Division serves as the Office of Corporate Registrar for the District of Columbia.

This data set contains data related to the following information of a business entity: file number, entity status, locale, model type, business name, suffix, business address, email, effective date, foreign date of organization, next report year, latest report year filed, and latest report date filed. More information can be found at https://dlcp.dc.gov/page/corporations
Organization: District of Columbia
Last updated: 2025-07-30T04:00:21.166609
Tags: business, consumer, consumer-licensing, dc, district-of-columbia, licensing, washington-dc

Tables

Table 1

@usgov.district_of_columbia_corporate_registration_6459e.table_1

42.29 MB
483958 rows
33 columns


CREATE TABLE table_1 (
  "file_number" VARCHAR,
  "entity_status" VARCHAR,
  "locale" VARCHAR,
  "modeltype" VARCHAR,
  "business_name" VARCHAR,
  "busniess_address_line1" VARCHAR,
  "busniess_address_line2" VARCHAR,
  "busniess_address_line3" VARCHAR,
  "busniess_address_line4" VARCHAR,
  "business_city" VARCHAR,
  "business_state" VARCHAR,
  "zipcode" VARCHAR,
  "business_country" VARCHAR,
  "suffix" VARCHAR,
  "ra_name" VARCHAR,
  "ra_address1" VARCHAR,
  "ra_address2" VARCHAR,
  "ra_address3" VARCHAR,
  "ra_address4" VARCHAR,
  "ra_city" VARCHAR,
  "ra_state" VARCHAR,
  "ra_zipcode" VARCHAR,
  "ra_email" VARCHAR,
  "effective_date" TIMESTAMP,
  "foreign_dateof_organization" VARCHAR,
  "next_reportyear_due" BIGINT,
  "dcs_last_mod_dttm" TIMESTAMP,
  "date_last_report_filed" VARCHAR,
  "next_reportyear" VARCHAR,
  "latestfiled_reportdate" VARCHAR,
  "latestreport_yearfiled" VARCHAR,
  "objectid" BIGINT,
  "globalid" VARCHAR
);