NYC DOB Job Applications Dataset 2023
New York City Department of Buildings Job Applications Dataset 2000 - 2023
@kaggle.utkarshx27_dob_job_application_filings
Loading...
Loading...
Loading...
Loading...
About this Dataset
NYC DOB Job Applications Dataset 2023
Description
This dataset contains all job applications submitted through the Borough Offices, through eFiling, or through the HUB, which have a "Latest Action Date" since January 1, 2000. This dataset does not include jobs submitted through DOB NOW. See the DOB NOW: Build – Job Application Filings dataset for DOB NOW jobs.
DOB -> Department of Buildings (DOB)
| Field Name | Description | Data Type |
|---|---|---|
| Job # | Number assigned by DOB to Job Filing | Plain Text |
| Doc # | Document Number | Plain Text |
| Borough | Borough code (1= Manhattan, 2= Bronx, 3= Brooklyn, 4= Queens, 5= Staten Island) | Plain Text |
| House # | House Number of Residence or Commercial Property | Plain Text |
| Street Name | Street Name where Property is located | Plain Text |
| Block | Tax block assigned by Department of Finance | Plain Text |
| Lot | Tax lot assigned by Department of Finance | Plain Text |
| Bin # | Number assigned by City Planning to a specific building | Plain Text |
| Job Type | Job Type, based on DOB Job Code | Plain Text |
| Job Status | DOB Status code of job | Plain Text |
| Job Status Descrp | Status code description | Plain Text |
| Latest Action Date | Latest status date | Plain Text |
| Building Type | 1-2-3 Family or Other | Plain Text |
| Community - Board | 3-digit identifier: Borough code = first position, last 2 = community board | Plain Text |
| Cluster | Cluster | Plain Text |
| Landmarked | L code indicates that the building has been assigned landmark status | Plain Text |
| Adult Estab | Adult Establishment | Plain Text |
| Loft Board | Loft Board | Plain Text |
| City Owned | City Owned | Plain Text |
| Little e | Hazardous | Plain Text |
| PC Filed | Application Filed electronically, rather than manually | Plain Text |
| eFiling Filed | Application Filed electronically, rather than manually | Plain Text |
| Plumbing | Plumbing Work Type? (X=Yes, Blank=No) | Plain Text |
| Mechanical | Mechanical Work Type? (X=Yes, Blank=No) | Plain Text |
| Boiler | Boiler Work Type? (X=Yes, Blank=No) | Plain Text |
| Fuel Burning | Fuel Burning Work Type? (X=Yes, Blank=No) | Plain Text |
| Fuel Storage | Fuel Storage Work Type? (X=Yes, Blank=No) | Plain Text |
| Standpipe | Standpipe Work Type? (X=Yes, Blank=No) | Plain Text |
| Sprinkler | Sprinkler Work Type? (X=Yes, Blank=No) | Plain Text |
| Fire Alarm | Fire Alarm Work Type? (X=Yes, Blank=No) | Plain Text |
| Equipment | Equipment Work Type? (X=Yes, Blank=No) | Plain Text |
| Fire Suppression | Fire Suppression Work Type? (X=Yes, Blank=No) | Plain Text |
| Curb Cut | Curb Cut Work Type? (X=Yes, Blank=No) | Plain Text |
| Other | Other? (X=Yes, Blank=No) | Plain Text |
| Other Description | Other Description | Plain Text |
| Applicant's First Name | First Name of Applicant | Plain Text |
| Applicant's Last Name | Last Name of Applicant | Plain Text |
| Applicant Professional Title | Applicant's Professional Title | Plain Text |
| Applicant License # | Number assigned to the skilled trade person/contractor or licensed professional | Plain Text |
| Professional Cert | Job is Professionally Certified by Licensed Professional instead of having it reviewed by Department of Building's Plan Examiners | Plain Text |
| Pre-Filing Date | Date when job is prefiled | Plain Text |
| Paid | Date when job is paid | Plain Text |
| Fully Paid | Date when job is paid and entered | Plain Text |
| Assigned | Date when job is assigned to plan examiner | Plain Text |
| Approved | Date when job is approved | Plain Text |
| Fully Permitted | Date when job is fully permitted | Plain Text |
| Initial Cost | Estimated cost of job | Plain Text |
| Total Est. Fee | Estimated fee of job | Plain Text |
| Fee Status | Type of Fee | Plain Text |
| Existing Zoning Sqft | Existing Zoning Sqft | Number |
| Proposed Zoning Sqft | Proposed Zoning Sqft | Number |
| Horizontal Enlrgmt | Horizontal Enlargement | Plain Text |
| Vertical Enlrgmt | Vertical Enlargement | Plain Text |
| Enlargement SQ Footage | Enlargement Square Footage | Number |
| Street Frontage | Street Frontage | Number |
| Existing No. of Stories | Existing Number of Stories | Number |
| Proposed No. of Stories | Proposed Number of Stories | Number |
| Existing Height | Existing Height | Number |
| Proposed Height | Proposed Height | Number |
| Existing Dwelling Units | Existing Dwelling Units | Plain Text |
| Proposed Dwelling Units | Proposed Dwelling Units | Plain Text |
| Existing Occupancy | Existing Occupancy | Plain Text |
| Proposed Occupancy | Proposed Occupancy | Plain Text |
| Site Fill | Site Fill | Plain Text |
| Zoning Dist1 | Zoning District 1 | Plain Text |
| Zoning Dist2 | Zoning District 2 | Plain Text |
| Zoning Dist3 | Zoning District 3 | Plain Text |
| Special District 1 | Special District 1 | Plain Text |
| Special District 2 | Special District 2 | Plain Text |
| Owner Type | Owner Type | Plain Text |
| Non-Profit | Non-Profit | Plain Text |
| Owner's First Name | First Name of property owner | Plain Text |
| Owner's Last Name | Last Name of property owner | Plain Text |
| Owner's Business Name | Business Name of Property Owner | Plain Text |
| Owner's House Number | House Number of Property Owner | Plain Text |
| Owner's House Street Name | House Street Name of Property Owner | Plain Text |
| City | City | Plain Text |
| State | State | Plain Text |
| Zip | Zip | Plain Text |
| Owner's Phone # | Owner's Phone Number | Plain Text |
| Job Description | Job Description | Plain Text |
| DOBRunDate | Date when query is run and pushed to Open Data | Plain Text |
| JOB_S1_NO | JOB_S1_NO | Plain Text |
| TOTAL_CONSTRUCTION_FLOOR_AREA | Total Construction Floor Area | Plain Text |
| WITHDRAWAL_FLAG | Withdrawal Indicator | Plain Text |
| SIGNOFF_DATE | Sign-off Date | Plain Text |
| SPECIAL_ACTION_STATUS | Special Action Status | Plain Text |
| SPECIAL_ACTION_DATE | Special Action Date | Plain Text |
| BUILDING_CLASS | Building Class | Plain Text |
| JOB_NO_GOOD_COUNT | Job No Good Count | Plain Text |
| GIS_LATITUDE | Latitude | Plain Text |
| GIS_LONGITUDE | Longitude | Plain Text |
| GIS_COUNCIL_DISTRICT | Council District | Plain Text |
| GIS_CENSUS_TRACT | Census Tract | Plain Text |
| GIS_NTA_NAME | NTA Name | Plain Text |
| GIS_BIN | BIN | Plain Text |
Tables
Dob Job Application Filings
@kaggle.utkarshx27_dob_job_application_filings.dob_job_application_filings
- 470.17 MB
- 2,698,822 rows
- 96 columns
Loading...
Loading...
CREATE TABLE dob_job_application_filings (
"job" BIGINT -- Job #,
"doc" BIGINT -- Doc #,
"borough" VARCHAR,
"house" VARCHAR -- House #,
"street_name" VARCHAR,
"block" VARCHAR,
"lot" VARCHAR,
"bin" BIGINT -- Bin #,
"job_type" VARCHAR,
"job_status" VARCHAR,
"job_status_descrp" VARCHAR,
"latest_action_date" VARCHAR,
"building_type" VARCHAR,
"community_board" VARCHAR -- Community - Board,
"cluster" VARCHAR,
"landmarked" VARCHAR,
"adult_estab" VARCHAR,
"loft_board" VARCHAR,
"city_owned" VARCHAR,
"little_e" VARCHAR,
"pc_filed" VARCHAR,
"efiling_filed" VARCHAR,
"plumbing" VARCHAR,
"mechanical" VARCHAR,
"boiler" VARCHAR,
"fuel_burning" VARCHAR,
"fuel_storage" VARCHAR,
"standpipe" VARCHAR,
"sprinkler" VARCHAR,
"fire_alarm" VARCHAR,
"equipment" VARCHAR,
"fire_suppression" VARCHAR,
"curb_cut" VARCHAR,
"other" VARCHAR,
"other_description" VARCHAR,
"applicant_s_first_name" VARCHAR -- Applicant\u0027s First Name,
"applicant_s_last_name" VARCHAR -- Applicant\u0027s Last Name,
"applicant_professional_title" VARCHAR,
"applicant_license" VARCHAR -- Applicant License #,
"professional_cert" VARCHAR,
"pre_filing_date" TIMESTAMP -- Pre- Filing Date,
"paid" TIMESTAMP,
"fully_paid" TIMESTAMP,
"assigned" TIMESTAMP,
"approved" VARCHAR,
"fully_permitted" VARCHAR,
"initial_cost" VARCHAR,
"total_est_fee" VARCHAR -- Total Est. Fee,
"fee_status" VARCHAR,
"existing_zoning_sqft" BIGINT,
"proposed_zoning_sqft" BIGINT,
"horizontal_enlrgmt" VARCHAR,
"vertical_enlrgmt" VARCHAR,
"enlargement_sq_footage" BIGINT,
"street_frontage" BIGINT,
"existingno_of_stories" BIGINT -- ExistingNo. Of Stories,
"proposed_no_of_stories" BIGINT -- Proposed No. Of Stories,
"existing_height" BIGINT,
"proposed_height" BIGINT,
"existing_dwelling_units" VARCHAR,
"proposed_dwelling_units" VARCHAR,
"existing_occupancy" VARCHAR,
"proposed_occupancy" VARCHAR,
"site_fill" VARCHAR,
"zoning_dist1" VARCHAR,
"zoning_dist2" VARCHAR,
"zoning_dist3" VARCHAR,
"special_district_1" VARCHAR,
"special_district_2" VARCHAR,
"owner_type" VARCHAR,
"non_profit" VARCHAR,
"owner_s_first_name" VARCHAR -- Owner\u0027s First Name,
"owner_s_last_name" VARCHAR -- Owner\u0027s Last Name,
"owner_s_business_name" VARCHAR -- Owner\u0027s Business Name,
"owner_s_house_number" VARCHAR -- Owner\u0027s House Number,
"owner_shouse_street_name" VARCHAR -- Owner\u0027sHouse Street Name,
"city" VARCHAR,
"state" VARCHAR,
"zip" DOUBLE,
"owner_sphone" VARCHAR -- Owner\u0027sPhone #,
"job_description" VARCHAR,
"dobrundate" VARCHAR,
"job_s1_no" BIGINT,
"total_construction_floor_area" BIGINT,
"withdrawal_flag" BIGINT,
"signoff_date" VARCHAR,
"special_action_status" VARCHAR,
"special_action_date" VARCHAR,
"building_class" VARCHAR,
"job_no_good_count" BIGINT,
"gis_latitude" DOUBLE,
"gis_longitude" DOUBLE,
"gis_council_district" DOUBLE,
"gis_census_tract" DOUBLE,
"gis_nta_name" VARCHAR,
"gis_bin" DOUBLE
);