Cambridge Property Database FY2020

data.cambridgema.gov | Last Updated 30 Oct 2019

Extract of Cambridge Assessing Department on-line property database file for FY16, FY17, FY18, FY19, and FY2020. Contains residential, condo, commercial and exempt data. Please see attached Cambridge Property Data Metadata for field descriptions. Please refer to Cambridge's property database website for official assessment data: https://www.cambridgema.gov/propertydatabase

Tags: assessing, cambridge, residential, commercial, condo

This dataset has the following 62 columns:

Column NameAPI Column NameData TypeDescription
PIDpidnumber
GISIDgisidtextUnique ID to link property on map
BldgNumbldgnumnumber
Addresslocation_1location
Unitunittext
StateClassCodestateclasscodenumberUse as defined by the MA Dept of Revenue
PropertyClasspropertyclasstext
ZoningzoningtextUnofficial zoning per City of Cambridge
Map/Lotmap_lottextUnique assessor's ID
LandArealandareanumbersquare feet
YearOfAssessmentyearofassessmentnumber
TaxDistricttaxdistricttext
ResidentialExemptionresidentialexemptiontextOwner occupied tax exemption
BuildingValuebuildingvaluenumber
LandValuelandvaluenumber
AssessedValueassessedvaluenumber
SalePricesalepricenumber
Book/Pagebook_pagetextBook and page of last deed recorded at registry of deeds
SaleDatesaledatecalendar_dateDate of last deed transaction
PreviousAssessedValuepreviousassessedvaluenumber
Owner_Nameowner_nametext
Owner_CoOwnerNameowner_coownernametext
Owner_Locationowner_locationlocation
Owner_Addressowner_addresstext
Owner_Address2owner_address2text
Owner_Cityowner_citytext
Owner_Stateowner_statetext
Owner_Zipowner_ziptext
Exterior_Styleexterior_styletext
Exterior_occupancyexterior_occupancytext
Exterior_NumStoriesexterior_numstoriesnumber
Exterior_WallTypeexterior_walltypetext
Exterior_WallHeightexterior_wallheightnumber
Exterior_RoofTypeexterior_rooftypetext
Exterior_RoofMaterialexterior_roofmaterialtext
Exterior_FloorLocationexterior_floorlocationnumber
Exterior_Viewexterior_viewtext
Interior_LivingAreainterior_livingareanumber
Interior_NumUnitsinterior_numunitsnumber
Interior_TotalRoomsinterior_totalroomsnumber
Interior_Bedroomsinterior_bedroomsnumber
Interior_Kitchensinterior_kitchenstext
Interior_FullBathsinterior_fullbathsnumber
Interior_HalfBathsinterior_halfbathsnumber
Interior_Fireplacesinterior_fireplacesnumber
Interior_Flooringinterior_flooringtext
Interior_Layoutinterior_layouttext
Interior_LaundryInUnitinterior_laundryinunittext
Systems_HeatTypesystems_heattypetext
Systems_HeatFuelsystems_heatfueltext
Systems_CentralAirsystems_centralairtext
Systems_Plumbingsystems_plumbingtext
Condition_YearBuiltcondition_yearbuiltnumber
Condition_InteriorConditioncondition_interiorconditiontext
Condition_OverallConditioncondition_overallconditiontext
Condition_OverallGradecondition_overallgradetext
Parking_Openparking_opennumber
Parking_Coveredparking_coverednumber
Parking_Garageparking_garagenumber
UnfinishedBasementGrossunfinishedbasementgrossnumber
FinishedBasementGrossfinishedbasementgrossnumber
PropertyTaxAmountpropertytaxamountnumberProperty task for the fiscal year