About this Dataset

License Applications

This dataset features all license applications submitted to the NYC Department of Consumer and Worker Protection (DCWP)—formerly the Department of Consumer Affairs (DCA). It includes applications where a license was issued or renewed, denied, withdrawn, or remains in pending status. If applicable, there is a corresponding license number, details of which can be found in the DCWP Licenses dataset.
Organization: City of New York
Last updated: 2020-11-10T17:04:38.015927
Tags: business, city-government, consumer, dca, dcwp, department-of-consumer-affairs, department-of-consumer-and-worker-protection, individual, industry, license

Tables

Table 1

@usgov.city_of_new_york_license_applications.table_1

4.79 MB
57,605 rows
35 columns

CREATE TABLE table_1 (
  "application_id" VARCHAR,
  "license_number" VARCHAR,
  "applicant" VARCHAR,
  "dba_trade_name" VARCHAR,
  "business_unique_id" VARCHAR,
  "business_category" VARCHAR,
  "application_type" VARCHAR,
  "license_type" VARCHAR,
  "intake_channel" VARCHAR,
  "submission_date" TIMESTAMP,
  "date_closed" TIMESTAMP,
  "application_status" VARCHAR,
  "temp_op_letter_issued" TIMESTAMP,
  "temp_op_letter_expiration" TIMESTAMP,
  "contact_phone" VARCHAR,
  "address_type" VARCHAR,
  "building_number" VARCHAR,
  "street1" VARCHAR,
  "street2" VARCHAR,
  "street3" VARCHAR,
  "unit_type" VARCHAR,
  "apt_suite" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" VARCHAR,
  "borough" VARCHAR,
  "community_board" DOUBLE,
  "council_district" DOUBLE,
  "bin" DOUBLE,
  "bbl" DOUBLE,
  "nta" VARCHAR,
  "census_block_2010" DOUBLE  -- Census Block (2010),
  "census_tract_2010" DOUBLE  -- Census Tract (2010),
  "latitude" DOUBLE,
  "longitude" DOUBLE
);