About this Dataset

DOB NOW: Build – Job Application Filings

List of most job filings filed in DOB NOW. This dataset does not include certain types of job. For Electrical jobs, use https://data.cityofnewyork.us/browse?Data-Collection_Data-Collection=DOB+NOW+Electrical+Permits+Data. Elevator and LAA jobs will also be published separately.
Organization: City of New York
Last updated: 2021-08-07T17:49:44.044767
Tags: buildings, dob, filings, job

Tables

Table 1

@usgov.city_of_new_york_dob_now_build_job_application_filings.table_1

91.22 MB
749,844 rows
83 columns

CREATE TABLE table_1 (
  "job_filing_number" VARCHAR,
  "filing_status" VARCHAR,
  "house_no" VARCHAR,
  "street_name" VARCHAR,
  "borough" VARCHAR,
  "block" BIGINT,
  "lot" BIGINT,
  "bin" BIGINT,
  "commmunity_board" DOUBLE  -- Commmunity - Board,
  "work_on_floor" VARCHAR,
  "apt_condo_no_s" VARCHAR  -- Apt./Condo No(s),
  "applicant_professional_title" VARCHAR,
  "applicant_license" VARCHAR  -- Applicant License #,
  "applicant_first_name" VARCHAR,
  "applicants_middle_initial" VARCHAR,
  "applicant_last_name" VARCHAR,
  "owner_s_business_name" VARCHAR,
  "owner_s_street_name" VARCHAR,
  "owner_s_city" VARCHAR,
  "owner_s_state" VARCHAR,
  "owner_s_zip" VARCHAR,
  "filing_representative_first_name" VARCHAR,
  "filing_representative_middle_initial" VARCHAR,
  "filing_representative_last_name" VARCHAR,
  "filing_representative_business_name" VARCHAR,
  "filing_representative_street_name" VARCHAR,
  "filing_representative_city" VARCHAR,
  "filing_representative_state" VARCHAR,
  "filing_representative_zip" VARCHAR,
  "sprinkler_work_type" VARCHAR  -- Sprinkler (Work Type),
  "plumbing_work_type" VARCHAR  -- Plumbing (Work Type),
  "initial_cost" DOUBLE,
  "total_construction_floor_area" DOUBLE,
  "review_building_code" VARCHAR,
  "little_e" VARCHAR,
  "unmapped_cco_street" VARCHAR,
  "request_legalization" VARCHAR,
  "includes_permanent_removal" VARCHAR,
  "in_compliance_with_nycecc" VARCHAR,
  "exempt_from_nycecc" VARCHAR,
  "building_type" VARCHAR,
  "existing_stories" DOUBLE,
  "existing_height" DOUBLE,
  "existing_dwelling_units" DOUBLE,
  "proposed_no_of_stories" DOUBLE,
  "proposed_height" DOUBLE,
  "proposed_dwelling_units" DOUBLE,
  "specialinspectionrequirement" VARCHAR,
  "special_inspection_agency_number" VARCHAR,
  "progressinspectionrequirement" VARCHAR,
  "built_1_information_value" VARCHAR,
  "built_2_information_value" VARCHAR,
  "built_2_a_information_value" VARCHAR,
  "built_2_b_information_value" VARCHAR,
  "standpipe" VARCHAR,
  "antenna" VARCHAR,
  "curb_cut" VARCHAR,
  "sign" VARCHAR,
  "fence" VARCHAR,
  "scaffold" VARCHAR,
  "shed" VARCHAR,
  "postcode" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "council_district" DOUBLE,
  "census_tract" DOUBLE,
  "bbl" DOUBLE,
  "nta" VARCHAR,
  "filing_date" VARCHAR,
  "current_status_date" VARCHAR,
  "first_permit_date" VARCHAR,
  "boiler_equipment_work_type" VARCHAR  -- Boiler Equipment (Work Type),
  "earth_work_work_type" VARCHAR  -- Earth Work (Work Type),
  "foundation_work_type" VARCHAR  -- Foundation (Work Type),
  "general_construction_work_type" VARCHAR  -- General Construction (Work Type),
  "mechanical_systems_work_type" VARCHAR  -- Mechanical Systems (Work Type),
  "place_of_assembly_work_type" VARCHAR  -- Place Of Assembly (Work Type),
  "protection_mechanical_methods_work_type" VARCHAR  -- Protection Mechanical Methods (Work Type),
  "sidewalk_shed_work_type" VARCHAR  -- Sidewalk Shed (Work Type),
  "structural_work_type" VARCHAR  -- Structural (Work Type),
  "support_of_excavation_work_type" VARCHAR  -- Support Of Excavation (Work Type),
  "temporary_place_of_assembly_work_type" VARCHAR  -- Temporary Place Of Assembly (Work Type),
  "job_type" VARCHAR
);