Skip to content

Instantly share code, notes, and snippets.

@GeorgeSeif
Last active October 3, 2018 00:22
Show Gist options
  • Select an option

  • Save GeorgeSeif/1a85f7f26b4e12f5dd44958b44041e84 to your computer and use it in GitHub Desktop.

Select an option

Save GeorgeSeif/1a85f7f26b4e12f5dd44958b44041e84 to your computer and use it in GitHub Desktop.
'airconditioningtypeid' Type of cooling system present in the home (if any)
'architecturalstyletypeid' Architectural style of the home (ie 'ranch' 'colonial' 'split-level' etc)
'basementsqft' Finished living area below or partially below ground level
'bathroomcnt' Number of bathrooms in home including fractional bathrooms
'bedroomcnt' Number of bedrooms in home
'buildingqualitytypeid' Overall assessment of condition of the building from best (lowest) to worst (highest)
'buildingclasstypeid' The building framing type (steel frame wood frame concrete or brick)
'calculatedbathnbr' Number of bathrooms in home including fractional bathroom
'decktypeid' Type of deck (if any) present on parcel
'threequarterbathnbr' Number of 3/4 bathrooms in house (shower + sink + toilet)
'finishedfloor1squarefeet' Size of the finished living area on the first (entry) floor of the home
'calculatedfinishedsquarefeet' Calculated total finished living area of the home
'finishedsquarefeet6' Base unfinished and finished area
'finishedsquarefeet12' Finished living area
'finishedsquarefeet13' Perimeter living area
'finishedsquarefeet15' Total area
'finishedsquarefeet50' Size of the finished living area on the first (entry) floor of the home
'fips' Federal Information Processing Standard code
'fireplacecnt' Number of fireplaces in a home (if any)
'fireplaceflag' Is a fireplace present in this home
'fullbathcnt' Number of full bathrooms (sink shower + bathtub and toilet) present in home
'garagecarcnt' Total number of garages on the lot including an attached garage
'garagetotalsqft' Total number of square feet of all garages on lot including an attached garage
'hashottuborspa' Does the home have a hot tub or spa
'heatingorsystemtypeid' Type of home heating system
'latitude' Latitude of the middle of the parcel multiplied by 10e6
'longitude' Longitude of the middle of the parcel multiplied by 10e6
'lotsizesquarefeet' Area of the lot in square feet
'numberofstories' Number of stories or levels the home has
'parcelid' Unique identifier for parcels (lots)
'poolcnt' Number of pools on the lot (if any)
'poolsizesum' Total square footage of all pools on property
'pooltypeid10' Spa or Hot Tub
'pooltypeid2' Pool with Spa/Hot Tub
'pooltypeid7' Pool without hot tub
'propertycountylandusecode' County land use code ie it's zoning at the county level
'propertylandusetypeid' Type of land use the property is zoned for
'propertyzoningdesc' Description of the allowed land uses (zoning) for that property
'rawcensustractandblock' Census tract and block ID combined - also contains blockgroup assignment by extension
'censustractandblock' Census tract and block ID combined - also contains blockgroup assignment by extension
'regionidcounty' County in which the property is located
'regionidcity' City in which the property is located (if any)
'regionidzip' Zip code in which the property is located
'regionidneighborhood' Neighborhood in which the property is located
'roomcnt' Total number of rooms in the principal residence
'storytypeid' Type of floors in a multi-story house (ie basement and main level split-level attic etc)
'typeconstructiontypeid' What type of construction material was used to construct the home
'unitcnt' Number of units the structure is built into (ie 2 = duplex 3 = triplex etc)
'yardbuildingsqft17' Patio in yard
'yardbuildingsqft26' Storage shed/building in yard
'yearbuilt' The Year the principal residence was built
'taxvaluedollarcnt' The total tax assessed value of the parcel
'structuretaxvaluedollarcnt' The assessed value of the built structure on the parcel
'landtaxvaluedollarcnt' The assessed value of the land area of the parcel
'taxamount' The total property tax assessed for that assessment year
'assessmentyear' The year of the property tax assessment
'taxdelinquencyflag' Property taxes for this parcel are past due as of 2015
'taxdelinquencyyear' Year for which the unpaid propert taxes were due
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment