Name: DOB License Info
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

DOB License Info

DOB licenses and registrations issued by the Department to individuals working with our Department and/or within the construction trades in New York City
Organization: City of New York
Last updated: 2020-11-10T17:05:19.774394

Tables

Table 1

@usgov.city_of_new_york_dob_license_info.table_1

6.36 MB
101526 rows
22 columns


CREATE TABLE table_1 (
  "license_sl_no" BIGINT,
  "license_type" VARCHAR,
  "license_number" BIGINT,
  "last_name" VARCHAR,
  "first_name" VARCHAR,
  "business_name" VARCHAR,
  "number" VARCHAR,
  "street" VARCHAR,
  "license_business_city" VARCHAR,
  "business_state" VARCHAR,
  "postcode" VARCHAR,
  "business_email" VARCHAR,
  "business_phone_number" VARCHAR,
  "license_status" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "community_board" DOUBLE,
  "council_district" DOUBLE,
  "census_tract" DOUBLE,
  "bin" DOUBLE,
  "bbl" DOUBLE,
  "nta" VARCHAR
);