About this Dataset

Issued Licenses

This dataset features licenses issued by the NYC Department of Consumer and Worker Protection (DCWP)—formerly the Department of Consumer Affairs (DCA).
Organization: City of New York
Last updated: 2020-11-10T17:05:52.900377
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_legally_operating_businesses.table_1

5.47 MB
71,013 rows
31 columns

CREATE TABLE table_1 (
  "license_number" VARCHAR,
  "business_name" VARCHAR,
  "dba_trade_name" VARCHAR,
  "business_unique_id" VARCHAR,
  "business_category" VARCHAR,
  "license_type" VARCHAR,
  "license_status" VARCHAR,
  "initial_issuance_date" TIMESTAMP,
  "expiration_date" TIMESTAMP,
  "details" VARCHAR,
  "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
);