311 NYC Open Data HPD
311 complaints made to the housing preservation department
@kaggle.sousablde_311_nyc_open_data_hpd
About this Dataset
311 NYC Open Data HPD
Context
These datasets were added to empower people to explore what are the housing complaints that affect New York the most. I added PLUTO data to enrich the set with building features and characteristics.
Content
The data was acquired from opendata and filtered for only HPD, PLUTO adds information about building features and is divided by boroughs.
Acknowledgements
Al the pictures from the banner are by Photo by Colton Duke on Unsplash
Inspiration
I would love to see what you find to be the most abundant complaints and if you could predict which ones will keep increasing in the future.
Tables
Qn 18v1
@kaggle.sousablde_311_nyc_open_data_hpd.qn_18v1
- 19.36 MB
- 324583 rows
- 87 columns
Loading...
CREATE TABLE qn_18v1 (
"borough" VARCHAR,
"block" BIGINT,
"lot" BIGINT,
"cd" BIGINT,
"ct2010" DOUBLE,
"cb2010" DOUBLE,
"schooldist" DOUBLE,
"council" DOUBLE,
"zipcode" DOUBLE,
"firecomp" VARCHAR,
"policeprct" DOUBLE,
"healthcenterdistrict" DOUBLE,
"healtharea" DOUBLE,
"sanitboro" DOUBLE,
"sanitdistrict" DOUBLE,
"sanitsub" VARCHAR,
"address" VARCHAR,
"zonedist1" VARCHAR,
"zonedist2" VARCHAR,
"zonedist3" VARCHAR,
"zonedist4" VARCHAR,
"overlay1" VARCHAR,
"overlay2" VARCHAR,
"spdist1" VARCHAR,
"spdist2" VARCHAR,
"spdist3" VARCHAR,
"ltdheight" VARCHAR,
"splitzone" VARCHAR,
"bldgclass" VARCHAR,
"landuse" DOUBLE,
"easements" BIGINT,
"ownertype" VARCHAR,
"ownername" VARCHAR,
"lotarea" BIGINT,
"bldgarea" BIGINT,
"comarea" BIGINT,
"resarea" BIGINT,
"officearea" BIGINT,
"retailarea" BIGINT,
"garagearea" BIGINT,
"strgearea" BIGINT,
"factryarea" BIGINT,
"otherarea" BIGINT,
"areasource" BIGINT,
"numbldgs" BIGINT,
"numfloors" DOUBLE,
"unitsres" BIGINT,
"unitstotal" BIGINT,
"lotfront" DOUBLE,
"lotdepth" DOUBLE,
"bldgfront" DOUBLE,
"bldgdepth" DOUBLE,
"ext" VARCHAR,
"proxcode" DOUBLE,
"irrlotcode" VARCHAR,
"lottype" DOUBLE,
"bsmtcode" DOUBLE,
"assessland" BIGINT,
"assesstot" BIGINT,
"exemptland" BIGINT,
"exempttot" BIGINT,
"yearbuilt" BIGINT,
"yearalter1" BIGINT,
"yearalter2" BIGINT,
"histdist" VARCHAR,
"landmark" VARCHAR,
"builtfar" DOUBLE,
"residfar" DOUBLE,
"commfar" DOUBLE,
"facilfar" DOUBLE,
"borocode" BIGINT,
"bbl" BIGINT,
"condono" BIGINT,
"tract2010" BIGINT,
"xcoord" DOUBLE,
"ycoord" DOUBLE,
"zonemap" VARCHAR,
"zmcode" VARCHAR,
"sanborn" VARCHAR,
"taxmap" DOUBLE,
"edesignum" VARCHAR,
"appbbl" DOUBLE,
"appdate" TIMESTAMP,
"plutomapid" BIGINT,
"firm07_flag" DOUBLE,
"pfirm15_flag" DOUBLE,
"version" VARCHAR
);
Bk 18v1
@kaggle.sousablde_311_nyc_open_data_hpd.bk_18v1
- 16.78 MB
- 277316 rows
- 87 columns
Loading...
CREATE TABLE bk_18v1 (
"borough" VARCHAR,
"block" BIGINT,
"lot" BIGINT,
"cd" BIGINT,
"ct2010" DOUBLE,
"cb2010" DOUBLE,
"schooldist" DOUBLE,
"council" DOUBLE,
"zipcode" DOUBLE,
"firecomp" VARCHAR,
"policeprct" DOUBLE,
"healthcenterdistrict" DOUBLE,
"healtharea" DOUBLE,
"sanitboro" DOUBLE,
"sanitdistrict" DOUBLE,
"sanitsub" VARCHAR,
"address" VARCHAR,
"zonedist1" VARCHAR,
"zonedist2" VARCHAR,
"zonedist3" VARCHAR,
"zonedist4" VARCHAR,
"overlay1" VARCHAR,
"overlay2" VARCHAR,
"spdist1" VARCHAR,
"spdist2" VARCHAR,
"spdist3" VARCHAR,
"ltdheight" VARCHAR,
"splitzone" VARCHAR,
"bldgclass" VARCHAR,
"landuse" DOUBLE,
"easements" BIGINT,
"ownertype" VARCHAR,
"ownername" VARCHAR,
"lotarea" BIGINT,
"bldgarea" BIGINT,
"comarea" BIGINT,
"resarea" BIGINT,
"officearea" BIGINT,
"retailarea" BIGINT,
"garagearea" BIGINT,
"strgearea" BIGINT,
"factryarea" BIGINT,
"otherarea" BIGINT,
"areasource" BIGINT,
"numbldgs" BIGINT,
"numfloors" DOUBLE,
"unitsres" BIGINT,
"unitstotal" BIGINT,
"lotfront" DOUBLE,
"lotdepth" DOUBLE,
"bldgfront" DOUBLE,
"bldgdepth" DOUBLE,
"ext" VARCHAR,
"proxcode" DOUBLE,
"irrlotcode" VARCHAR,
"lottype" DOUBLE,
"bsmtcode" DOUBLE,
"assessland" BIGINT,
"assesstot" BIGINT,
"exemptland" BIGINT,
"exempttot" BIGINT,
"yearbuilt" BIGINT,
"yearalter1" BIGINT,
"yearalter2" BIGINT,
"histdist" VARCHAR,
"landmark" VARCHAR,
"builtfar" DOUBLE,
"residfar" DOUBLE,
"commfar" DOUBLE,
"facilfar" DOUBLE,
"borocode" BIGINT,
"bbl" BIGINT,
"condono" BIGINT,
"tract2010" BIGINT,
"xcoord" DOUBLE,
"ycoord" DOUBLE,
"zonemap" VARCHAR,
"zmcode" VARCHAR,
"sanborn" VARCHAR,
"taxmap" DOUBLE,
"edesignum" VARCHAR,
"appbbl" DOUBLE,
"appdate" TIMESTAMP,
"plutomapid" BIGINT,
"firm07_flag" DOUBLE,
"pfirm15_flag" DOUBLE,
"version" VARCHAR
);
Si 18v1
@kaggle.sousablde_311_nyc_open_data_hpd.si_18v1
- 7.51 MB
- 124493 rows
- 87 columns
Loading...
CREATE TABLE si_18v1 (
"borough" VARCHAR,
"block" BIGINT,
"lot" BIGINT,
"cd" BIGINT,
"ct2010" DOUBLE,
"cb2010" DOUBLE,
"schooldist" DOUBLE,
"council" DOUBLE,
"zipcode" DOUBLE,
"firecomp" VARCHAR,
"policeprct" DOUBLE,
"healthcenterdistrict" DOUBLE,
"healtharea" DOUBLE,
"sanitboro" DOUBLE,
"sanitdistrict" DOUBLE,
"sanitsub" VARCHAR,
"address" VARCHAR,
"zonedist1" VARCHAR,
"zonedist2" VARCHAR,
"zonedist3" VARCHAR,
"zonedist4" VARCHAR,
"overlay1" VARCHAR,
"overlay2" VARCHAR,
"spdist1" VARCHAR,
"spdist2" VARCHAR,
"spdist3" VARCHAR,
"ltdheight" VARCHAR,
"splitzone" VARCHAR,
"bldgclass" VARCHAR,
"landuse" DOUBLE,
"easements" BIGINT,
"ownertype" VARCHAR,
"ownername" VARCHAR,
"lotarea" BIGINT,
"bldgarea" BIGINT,
"comarea" BIGINT,
"resarea" BIGINT,
"officearea" BIGINT,
"retailarea" BIGINT,
"garagearea" BIGINT,
"strgearea" BIGINT,
"factryarea" BIGINT,
"otherarea" BIGINT,
"areasource" BIGINT,
"numbldgs" BIGINT,
"numfloors" DOUBLE,
"unitsres" BIGINT,
"unitstotal" BIGINT,
"lotfront" DOUBLE,
"lotdepth" DOUBLE,
"bldgfront" DOUBLE,
"bldgdepth" DOUBLE,
"ext" VARCHAR,
"proxcode" DOUBLE,
"irrlotcode" VARCHAR,
"lottype" DOUBLE,
"bsmtcode" DOUBLE,
"assessland" BIGINT,
"assesstot" BIGINT,
"exemptland" BIGINT,
"exempttot" BIGINT,
"yearbuilt" BIGINT,
"yearalter1" BIGINT,
"yearalter2" BIGINT,
"histdist" VARCHAR,
"landmark" VARCHAR,
"builtfar" DOUBLE,
"residfar" DOUBLE,
"commfar" DOUBLE,
"facilfar" DOUBLE,
"borocode" BIGINT,
"bbl" BIGINT,
"condono" BIGINT,
"tract2010" BIGINT,
"xcoord" DOUBLE,
"ycoord" DOUBLE,
"zonemap" VARCHAR,
"zmcode" VARCHAR,
"sanborn" VARCHAR,
"taxmap" DOUBLE,
"edesignum" VARCHAR,
"appbbl" DOUBLE,
"appdate" TIMESTAMP,
"plutomapid" BIGINT,
"firm07_flag" DOUBLE,
"pfirm15_flag" DOUBLE,
"version" VARCHAR
);
Mn 18v1
@kaggle.sousablde_311_nyc_open_data_hpd.mn_18v1
- 3.6 MB
- 42966 rows
- 87 columns
Loading...
CREATE TABLE mn_18v1 (
"borough" VARCHAR,
"block" BIGINT,
"lot" BIGINT,
"cd" BIGINT,
"ct2010" DOUBLE,
"cb2010" DOUBLE,
"schooldist" DOUBLE,
"council" DOUBLE,
"zipcode" DOUBLE,
"firecomp" VARCHAR,
"policeprct" DOUBLE,
"healthcenterdistrict" DOUBLE,
"healtharea" DOUBLE,
"sanitboro" DOUBLE,
"sanitdistrict" DOUBLE,
"sanitsub" VARCHAR,
"address" VARCHAR,
"zonedist1" VARCHAR,
"zonedist2" VARCHAR,
"zonedist3" VARCHAR,
"zonedist4" VARCHAR,
"overlay1" VARCHAR,
"overlay2" VARCHAR,
"spdist1" VARCHAR,
"spdist2" VARCHAR,
"spdist3" VARCHAR,
"ltdheight" VARCHAR,
"splitzone" VARCHAR,
"bldgclass" VARCHAR,
"landuse" DOUBLE,
"easements" BIGINT,
"ownertype" VARCHAR,
"ownername" VARCHAR,
"lotarea" BIGINT,
"bldgarea" BIGINT,
"comarea" BIGINT,
"resarea" BIGINT,
"officearea" BIGINT,
"retailarea" BIGINT,
"garagearea" BIGINT,
"strgearea" BIGINT,
"factryarea" BIGINT,
"otherarea" BIGINT,
"areasource" BIGINT,
"numbldgs" BIGINT,
"numfloors" DOUBLE,
"unitsres" BIGINT,
"unitstotal" BIGINT,
"lotfront" DOUBLE,
"lotdepth" DOUBLE,
"bldgfront" DOUBLE,
"bldgdepth" DOUBLE,
"ext" VARCHAR,
"proxcode" DOUBLE,
"irrlotcode" VARCHAR,
"lottype" DOUBLE,
"bsmtcode" DOUBLE,
"assessland" BIGINT,
"assesstot" BIGINT,
"exemptland" BIGINT,
"exempttot" BIGINT,
"yearbuilt" BIGINT,
"yearalter1" BIGINT,
"yearalter2" BIGINT,
"histdist" VARCHAR,
"landmark" VARCHAR,
"builtfar" DOUBLE,
"residfar" DOUBLE,
"commfar" DOUBLE,
"facilfar" DOUBLE,
"borocode" BIGINT,
"bbl" BIGINT,
"condono" BIGINT,
"tract2010" BIGINT,
"xcoord" DOUBLE,
"ycoord" DOUBLE,
"zonemap" VARCHAR,
"zmcode" VARCHAR,
"sanborn" VARCHAR,
"taxmap" DOUBLE,
"edesignum" VARCHAR,
"appbbl" DOUBLE,
"appdate" TIMESTAMP,
"plutomapid" BIGINT,
"firm07_flag" DOUBLE,
"pfirm15_flag" DOUBLE,
"version" VARCHAR
);
Bx 18v1
@kaggle.sousablde_311_nyc_open_data_hpd.bx_18v1
- 5.82 MB
- 89854 rows
- 87 columns
Loading...
CREATE TABLE bx_18v1 (
"borough" VARCHAR,
"block" BIGINT,
"lot" BIGINT,
"cd" BIGINT,
"ct2010" DOUBLE,
"cb2010" DOUBLE,
"schooldist" DOUBLE,
"council" DOUBLE,
"zipcode" DOUBLE,
"firecomp" VARCHAR,
"policeprct" DOUBLE,
"healthcenterdistrict" DOUBLE,
"healtharea" DOUBLE,
"sanitboro" DOUBLE,
"sanitdistrict" DOUBLE,
"sanitsub" VARCHAR,
"address" VARCHAR,
"zonedist1" VARCHAR,
"zonedist2" VARCHAR,
"zonedist3" VARCHAR,
"zonedist4" VARCHAR,
"overlay1" VARCHAR,
"overlay2" VARCHAR,
"spdist1" VARCHAR,
"spdist2" VARCHAR,
"spdist3" VARCHAR,
"ltdheight" VARCHAR,
"splitzone" VARCHAR,
"bldgclass" VARCHAR,
"landuse" DOUBLE,
"easements" BIGINT,
"ownertype" VARCHAR,
"ownername" VARCHAR,
"lotarea" BIGINT,
"bldgarea" BIGINT,
"comarea" BIGINT,
"resarea" BIGINT,
"officearea" BIGINT,
"retailarea" BIGINT,
"garagearea" BIGINT,
"strgearea" BIGINT,
"factryarea" BIGINT,
"otherarea" BIGINT,
"areasource" BIGINT,
"numbldgs" BIGINT,
"numfloors" DOUBLE,
"unitsres" BIGINT,
"unitstotal" BIGINT,
"lotfront" DOUBLE,
"lotdepth" DOUBLE,
"bldgfront" DOUBLE,
"bldgdepth" DOUBLE,
"ext" VARCHAR,
"proxcode" DOUBLE,
"irrlotcode" VARCHAR,
"lottype" DOUBLE,
"bsmtcode" DOUBLE,
"assessland" BIGINT,
"assesstot" BIGINT,
"exemptland" BIGINT,
"exempttot" BIGINT,
"yearbuilt" BIGINT,
"yearalter1" BIGINT,
"yearalter2" BIGINT,
"histdist" VARCHAR,
"landmark" VARCHAR,
"builtfar" DOUBLE,
"residfar" DOUBLE,
"commfar" DOUBLE,
"facilfar" DOUBLE,
"borocode" BIGINT,
"bbl" BIGINT,
"condono" BIGINT,
"tract2010" BIGINT,
"xcoord" DOUBLE,
"ycoord" DOUBLE,
"zonemap" VARCHAR,
"zmcode" VARCHAR,
"sanborn" VARCHAR,
"taxmap" DOUBLE,
"edesignum" VARCHAR,
"appbbl" DOUBLE,
"appdate" TIMESTAMP,
"plutomapid" BIGINT,
"firm07_flag" DOUBLE,
"pfirm15_flag" DOUBLE,
"version" VARCHAR
);