NYC DOB Job Applications Dataset 2023

New York City Department of Buildings Job Applications Dataset 2000 - 2023

@kaggle.utkarshx27_dob_job_application_filings

Table List

1 table(448.39 MB)

Dob Job Application Filings

@kaggle.utkarshx27_dob_job_application_filings.dob_job_application_filings

448.39 MB
2698822 rows
96 columns

job Job #	doc Doc #	borough Borough	house House #	street_name Street Name	block Block	lot Lot	bin Bin #	job_type Job Type	job_status Job Status	job_status_descrp Job Status Descrp	latest_action_date Latest Action Date	building_type Building Type	community_board Community - Board	cluster Cluster	landmarked Landmarked	adult_estab Adult Estab	loft_board Loft Board	city_owned City Owned	little_e Little E	pc_filed PC Filed	efiling_filed EFiling Filed	plumbing Plumbing	mechanical Mechanical	boiler Boiler	fuel_burning Fuel Burning	fuel_storage Fuel Storage	standpipe Standpipe	sprinkler Sprinkler	fire_alarm Fire Alarm	equipment Equipment	fire_suppression Fire Suppression	curb_cut Curb Cut	other Other	other_description Other Description	applicant_s_first_name Applicant\u0027s First Name	applicant_s_last_name Applicant\u0027s Last Name	applicant_professional_title Applicant Professional Title	applicant_license Applicant License #	professional_cert Professional Cert	pre_filing_date Pre- Filing Date	paid Paid	fully_paid Fully Paid	assigned Assigned	approved Approved	fully_permitted Fully Permitted	initial_cost Initial Cost	total_est_fee Total Est. Fee	fee_status Fee Status	existing_zoning_sqft Existing Zoning Sqft	proposed_zoning_sqft Proposed Zoning Sqft	horizontal_enlrgmt Horizontal Enlrgmt	vertical_enlrgmt Vertical Enlrgmt	enlargement_sq_footage Enlargement SQ Footage	street_frontage Street Frontage	existingno_of_stories ExistingNo. Of Stories	proposed_no_of_stories Proposed No. Of Stories	existing_height Existing Height	proposed_height Proposed Height	existing_dwelling_units Existing Dwelling Units	proposed_dwelling_units Proposed Dwelling Units	existing_occupancy Existing Occupancy	proposed_occupancy Proposed Occupancy	site_fill Site Fill	zoning_dist1 Zoning Dist1	zoning_dist2 Zoning Dist2	zoning_dist3 Zoning Dist3	special_district_1 Special District 1	special_district_2 Special District 2	owner_type Owner Type	non_profit Non-Profit	owner_s_first_name Owner\u0027s First Name	owner_s_last_name Owner\u0027s Last Name	owner_s_business_name Owner\u0027s Business Name	owner_s_house_number Owner\u0027s House Number	owner_shouse_street_name Owner\u0027sHouse Street Name	city City	state State	owner_sphone Owner\u0027sPhone #	job_description Job Description	dobrundate DOBRunDate	job_s1_no JOB S1 NO	total_construction_floor_area TOTAL CONSTRUCTION FLOOR AREA	signoff_date SIGNOFF DATE	special_action_status SPECIAL ACTION STATUS	special_action_date SPECIAL ACTION DATE	building_class BUILDING CLASS	gis_latitude GIS LATITUDE	gis_longitude GIS LONGITUDE	gis_council_district GIS COUNCIL DISTRICT	gis_census_tract GIS CENSUS TRACT	gis_nta_name GIS NTA NAME	gis_bin GIS BIN
301793156	1	BROOKLYN	30	SCHAEFER STREET	03426	00021	3079404	A3	R	PERMIT ISSUED - ENTIRE JOB/WORK	07/28/2004	1-2-3 FAMILY	304	nan	N	N	nan	nan	nan	Y	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	X	BPP	HARI	SONI	PE	075456	Y	Mon Jul 26 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jul 26 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Jul 26 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jul 28 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	07/28/2004	07/28/2004	$0.00	$200.00	STANDARD			nan	nan		25		3		30	nan	3	J-0	nan	NONE	R6	nan	nan	nan	nan	CORPORATION	N	BEHROOZ	RAOFIM	MARCY CORP.	nan	nan	nan	nan	5166217500	BUILDERS PAVEMENT PLAN STREET FRONTAGE OF THE PROJECT= 25	12/17/2022 00:00:00	1003072		nan	N	nan	C0	40.685185	-73.91222	37	401	Bushwick South	3079404
301776077	1	BROOKLYN	208	NORTH 8 STREET	02321	00008	3061967	A2	X	SIGNED OFF	11/28/2005	OTHERS	301	nan	N	N	nan	nan	nan	Y	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	X	GC	David	Turner	RA	016162	Y	Fri Apr 16 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Apr 20 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Apr 20 2004 00:00:00 GMT+0000 (Coordinated Universal Time)		04/20/2004	05/12/2004	$6000.00	$150.30	STANDARD			nan	nan				5		50	nan	nan	COM	nan	NONE	R6	M1-2	nan	nan	nan	INDIVIDUAL	N	Fred	Moehring	Electronic Hardware Consulting	nan	nan	nan	nan	7189632220	general construction to include partitions, joist replacment, and legalization of violation # 34412553M. No change in use egress or occupancy	06/26/2022 00:00:00	1000363		11/28/2005	N	nan	S2	40.717318	-73.955431	33	519	North Side-South Side	3061967
301776291	1	BROOKLYN	933	51 STREET	05645	00066	3137917	A1	X	SIGNED OFF	10/26/2006	1-2-3 FAMILY	312	nan	N	N	nan	nan	nan	Y	nan	X	nan	nan	nan	nan	nan	nan	nan	X	nan	nan	X	GC	Ernest	Keller	RA	007362	Y	Fri Apr 16 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Apr 16 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Apr 16 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Apr 19 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	04/19/2004	07/15/2004	$80000.00	$682.30	STANDARD			nan	Y	568			3		40	nan	3	J-0	J-0	NONE	R6	nan	nan	nan	nan	INDIVIDUAL	N	Ernesto	Stern	nan	nan	nan	nan	nan	7188512135	NEW 3rd FLOOR ADDTITON TO AN EXISTING THREE FAMILY, PARTITION AND PLUMBING WORK AT CELLAR, 2nd & 3rd FLOOR.	06/26/2022 00:00:00	1000387	5488	10/26/2006	N	nan	C0	40.638728	-74.00125	38	114	Borough Park	3137917
302163557	1	BROOKLYN	96	ROCKWELL PLACE	02106	07501	3059160	A1	R	PERMIT ISSUED - ENTIRE JOB/WORK	05/10/2010	OTHERS	302	nan	N	N	N	nan	N	N	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	X	GC	NORMAN	COX	RA	016362	nan	Tue May 23 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed May 24 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed May 24 2006 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon May 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	01/04/2007	01/05/2007	$600000.00	$9866.44	STANDARD	24319	39029	nan	Y	14093		6	12	70	162	0	36	COM	J-2	NONE	C6-4	nan	nan	DB	nan	PARTNERSHIP	N	JOSHUA	LANDAU	96 ROCKWELL LLC	nan	nan	nan	nan	2124730940	nan	06/26/2022 00:00:00	1052740	37955	nan	N	nan	R0	40.687317	-73.979159	35	33	Fort Greene	3059160
301773613	1	BROOKLYN	412	7 STREET	01000	00017	3021944	A2	P	PLAN EXAM - APPROVED	03/19/2004	OTHERS	306	nan	N	N	nan	nan	nan	Y	nan	X	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	VINCENT	LIOTTA	PE	048918	Y	Fri Mar 19 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Mar 19 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Mar 19 2004 00:00:00 GMT+0000 (Coordinated Universal Time)		03/19/2004	nan	$30000.00	$397.50	STANDARD			nan	nan				4		42	nan	nan	E	nan	NONE	R6B	nan	nan	nan	nan	CORPORATION	N	FONG	KIT	412 7TH AVE	nan	nan	nan	nan	7187881458	REPLACEMENT GAS PIPING, RELOCATE GAS METERS AND INSTALLATIO OF NEW GAS METER, NEW PLUMBING RISERS (VENT,WASTE,HOT AND COLD DOMESTIC WATER), REPLACEMENT HOT WATER HEATER AND REPLACEMENT STEAM HEAT RISERS. THERE WILL BE NO CHANGE IN USE EGRESS OR OCCUPANCY.	05/07/2023 00:00:00	1000011		nan	N	nan	C3	40.668861	-73.982156	39	153	Park Slope-Gowanus	3021944
440673852	1	QUEENS	246-08	135 ROAD	13228	00009	4284335	A2	X	SIGNED OFF	02/23/2022	1-2-3 FAMILY	413	N	N	N	N	nan	N	nan	Y	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	X	SOLAR TAX	WALID	ABDULLA	PE	094110	Y	Mon May 03 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon May 03 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon May 03 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon May 03 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	05/03/2021	05/07/2021	$37300.00	$215.80	STANDARD			nan	nan			2	2	22	22	1	1	R-3	R-3	NOT APPLICABLE	R2	nan	nan	nan	MS4	INDIVIDUAL	N	LEONIE	TAYLOR	nan	nan	nan	nan	nan	7185279550	FILING HEREWITH TAX ABATEMENT APPLICATION FOR INSTALLATION OF ROOF MOUNTED SOLAR PANELS. NO CHANGE IN USE, EGRESS OR OCCUPANCY.	02/24/2022 00:00:00	3294719		02/23/2022	N	nan	A2	40.669797	-73.729699	31	638	Rosedale	4284335
421789559	1	QUEENS	98-87	QUEENS BLVD	02105	00001	4050525	DM	R	PERMIT ISSUED - ENTIRE JOB/WORK	03/24/2022	OTHERS	406	N	N	N	N	nan	N	nan	Y	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	PETER	STROH	PE	072184	N	Mon May 03 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon May 03 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon May 03 2021 00:00:00 GMT+0000 (Coordinated Universal Time)		05/03/2021	03/24/2022	$0.00	$369.20	STANDARD			nan	nan		142	1		18		7	nan	J-3	nan	OFF-SITE	R7-1	nan	nan	nan	nan	INDIVIDUAL	N	RUDOLPH	ABRAMOV	TRYLON LLC	nan	nan	nan	nan	7186310800	DEMO OF ONE STORY COMMERCIAL STRUCTURE	03/25/2022 00:00:00	3294726		nan	N	nan	K1	40.727573	-73.855368	29	71304	Forest Hills	4050525
240304167	1	BRONX	101	LINCOLN AVE	02316	00001	2130735	A3	R	PERMIT ISSUED - ENTIRE JOB/WORK	05/13/2021	OTHERS	201	N	N	N	N	nan	Y	nan	Y	nan	nan	nan	nan	nan	nan	nan	nan	X	nan	nan	nan	nan	KEVIN	KETCHO	PE	101795	Y	Mon May 03 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon May 03 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon May 03 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon May 03 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	05/10/2021	05/13/2021	$0.00	$160.00	STANDARD			nan	nan			25	25	262	262	921	921	R-2	R-2	nan	M1-3/R8	nan	nan	MX-1	nan	PARTNERSHIP	N	GERRY	CORMICAN	STRUCTURETECH NEW YORK, INC	nan	nan	nan	nan	9146639622	INSTALLATION OF TEMPORARY SUSPENDED SCAFFOLD AS PER DRAWINGS. TEMPORARY SUSPENDED SCAFFOLD SHALL COMPLY WITH CHAPTER #33 OF THE NYC BUILDING CODE. NO CHANGE IN USE, OCCUPANCY OR EGRESS UNDER THIS APPLICATION	04/07/2022 00:00:00	3294701		nan	N	nan	D6	40.807149	-73.929969	8	19	Mott Haven-Port Morris	2000759
440707709	1	QUEENS	131-24	223 STREET	12932	00108	4278532	A2	R	PERMIT ISSUED - ENTIRE JOB/WORK	03/11/2022	1-2-3 FAMILY	413	N	N	N	N	nan	N	nan	Y	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	X	SOLAR TAX	VYACHESLAV	NECHAYEV	PE	095221	Y	Tue Mar 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Mar 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Mar 10 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Mar 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	03/10/2022	03/11/2022	$50400.00	$249.60	STANDARD			nan	nan			2	2	24	24	1	1	R-3	R-3	NOT APPLICABLE	R2	nan	nan	nan	nan	INDIVIDUAL	N	VINOLA	BECKFORD	nan	nan	nan	nan	nan	6319542844	ROOFTOP SOLAR PANEL INSTALLATION	03/12/2022 00:00:00	3334383		nan	N	nan	A1	40.680871	-73.744992	31	626	Laurelton	4278532
340819350	1	BROOKLYN	1548	72ND STREET	06191	00027	3429108	A3	J	PLAN EXAM - DISAPPROVED	11/08/2021	OTHERS	311	N	N	N	N	nan	N	nan	Y	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	X	BPP	SHIMING	TAM	RA	018525	N	Mon Aug 09 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Aug 09 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Nov 01 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Nov 04 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	nan	$0.00	$640.00	STANDARD			nan	nan		80					nan	nan	nan	nan	nan	R5	nan	nan	nan	nan	CORPORATION	N	BENTLY	ZHAO	1554 LLC	nan	nan	nan	nan	7184394688	SUBMIT BUILDER'S PAVEMENT PLAN IN CONJUNCTION WITH NEW BUILDING #321191704, TOTAL: 80'-0' FRONTAGE.	05/03/2022 00:00:00	3308694		nan	N	nan	V0	40.618773	-74.000274	43	190	Bensonhurst West	3158356


CREATE TABLE dob_job_application_filings (
  "job" BIGINT,
  "doc" BIGINT,
  "borough" VARCHAR,
  "house" VARCHAR,
  "street_name" VARCHAR,
  "block" VARCHAR,
  "lot" VARCHAR,
  "bin" BIGINT,
  "job_type" VARCHAR,
  "job_status" VARCHAR,
  "job_status_descrp" VARCHAR,
  "latest_action_date" VARCHAR,
  "building_type" VARCHAR,
  "community_board" VARCHAR,
  "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_s_last_name" VARCHAR,
  "applicant_professional_title" VARCHAR,
  "applicant_license" VARCHAR,
  "professional_cert" VARCHAR,
  "pre_filing_date" TIMESTAMP,
  "paid" TIMESTAMP,
  "fully_paid" TIMESTAMP,
  "assigned" TIMESTAMP,
  "approved" VARCHAR,
  "fully_permitted" VARCHAR,
  "initial_cost" VARCHAR,
  "total_est_fee" VARCHAR,
  "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,
  "proposed_no_of_stories" BIGINT,
  "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_s_last_name" VARCHAR,
  "owner_s_business_name" VARCHAR,
  "owner_s_house_number" VARCHAR,
  "owner_shouse_street_name" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" DOUBLE,
  "owner_sphone" VARCHAR,
  "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
);