About this Dataset

Historical Licenses

This dataset features businesses and individuals that were issued a DCWP license and the status of those licenses as of October 2013. A license is required to legally operate in New York City.
Organization: City of New York
Last updated: 2024-07-20T21:17:41.279235
Tags: archive, business, city-government, consumer, consumer-protection, dca, dcwp, department-of-consumer-affairs, department-of-consumer-and-worker-protection, historical, individual, industry, license

Tables

Table 1

@usgov.city_of_new_york_historical_licenses.table_1

12.96 MB
195,247 rows
27 columns

CREATE TABLE table_1 (
  "dca_license_number" BIGINT,
  "license_type" VARCHAR,
  "license_creation_date" TIMESTAMP,
  "license_expiration_date" TIMESTAMP,
  "license_status" VARCHAR,
  "license_status_date" TIMESTAMP,
  "business_code" BIGINT,
  "business_code_description" VARCHAR,
  "business_name" VARCHAR,
  "business_name2" VARCHAR,
  "address_building" VARCHAR,
  "address_street_name" VARCHAR,
  "secondary_address_street_name" VARCHAR,
  "address_city" VARCHAR,
  "address_state" VARCHAR,
  "address_postcode" VARCHAR,
  "contact_phone_number" VARCHAR,
  "borough_code" VARCHAR,
  "community_board" DOUBLE,
  "council_district" DOUBLE,
  "borough" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "bin" DOUBLE,
  "bbl" DOUBLE,
  "census_tract_2020" DOUBLE  -- Census Tract (2020),
  "neighborhood_tabulation_area_nta_2020" VARCHAR  -- Neighborhood Tabulation Area (NTA) (2020)
);