Download Specification

When you download foreclosure or auction data to your computer, each column has a heading. Below is a list of the columns, or fields, along with a short description, the date the column was added and a longer description of the field.

	Field		Short and Long Description		Date Added
	docketnum		Docket Number		Jun 1, 2003
			Each Notice of Default is assigned a Docket Number. The docket number is the legal reference number by which the Notice of Default is referenced in the court system.
	date_filed_formated		Date the Notice of Default was Filed		Jun 1, 2003
			The date the Notice of Default was filed. Until the Notice of Default is filed, an auction date cannot be set, and notices can not go into the newspaper or registry.
	defendant		Name of Defendant (Homeowner)		Jun 1, 2003
			The defendant is the Home Owner, the one being foreclosed on.
	def_first		Defendants First Name		Dec 17, 2004
			If the defendants name can be broken into first, middle and last, this is the First Name
	def_middle		Defendants Middle Name		Dec 17, 2004
			If the defendants name can be broken into first, middle and last, this is the Middle Name
	def_last		Defendants Last Name		Dec 17, 2004
			If the defendants name can be broken into first, middle and last, this is the Last Name
	def_street		Defendant's Street Address		Dec 21, 2005
			This is the street address of the defendant
	def_city		Defendant's City		Dec 21, 2005
			This is the city of the defendant
	def_state		Defendant's State		Dec 21, 2005
			This is the state of the defendant
	def_zip		Defendant's Zip		Dec 21, 2005
			This is the zip code of the defendant
	street		Legal Street Address		Jun 1, 2003
			This is the legal street address, as filed with the Notice of Default
	city		Legal Town or City		Jun 1, 2003
			The Legal Town or City is what was filed with the Notice of Default. If the foreclosure is in a specific part of the city (i.e. Roxbury, Centerville, etc…) that will be in Area and the Legal Town or City will be the actual Town or City (Boston, Barnstable, etc…)
	area		Area of Town or City		Dec 17, 2004
			When a foreclosure is located within an area of a City or Town, such as a village, neighborhood, etc… that has it's own legal name (Dorchester, Bradford, etc…) that area name will appear under Area
	street_num		Street Number		Dec 17, 2004
			The parsed street number from the legal address
	street_name		Street Name		Dec 17, 2004
			The parsed street name from the legal address
	unit		Unit Number		Dec 17, 2004
			If the foreclosure is in a condo complex or has a unit number, it will be under Unit
	street_usps		USPS Street address		Dec 17, 2004
			The street as provided by the USPS for this property. This is the address you want to use for mailing the foreclosure.
	city_usps		USPS City		Dec 17, 2004
			The city as provided by the USPS for this property. This is the city you want to use for mailing the foreclosure.
	zip_usps		USPS Zip+4 Zipcode		Dec 22, 2003
			The zip+4 zipcode as provided by the USPS for this property. This is the zipcode you want to use for mailing the foreclosure.
	plaintiff		Plaintiff (Bank)		Jun 1, 2003
			In order for the foreclosure process to be started, the Plaintiff, or Bank, needs to file a complaint. The Plaintiff is the legal name of the Bank on the mortgage.
	county		County		Jun 1, 2003
			The county this foreclosure is located in
	state		State		Dec 21, 2005
			This is the state where the foreclosure was filed
	telephone		Telephone number on file with town		Dec 22, 2003
			If the town has a telephone number on file, and it was not on the Do Not Call list at the time the tax record information was retrieved, it will be shown here
	total_rooms		Rooms in property		Dec 22, 2003
			The number of rooms in the property according to the towns tax record
	bedrooms		Bedrooms in property		Dec 22, 2003
			The number of bedrooms in the property according to the towns tax record
	full_baths		Full Bathrooms		Dec 22, 2003
			The number of full bathrooms in the property according to the towns tax record
	half_baths		Half Bathrooms		Dec 22, 2003
			The number of half bathrooms in the property according to the towns tax record
	gross_area		Gross Area in square feet		Dec 22, 2003
			Gross Area in square feet of the property according to the towns tax record
	lot_size_acres		Size of lot in Acres		Dec 22, 2003
			Lot size, in acres, according to the towns tax record
	style		Style of property		Dec 22, 2003
			Style of property (Colonial Ranch, Townhouse, etc…) according to the towns tax record
	last_sale_date_formated		Date of last sale		Dec 22, 2003
			Date the property was last sold
	last_sale_price		Price of last sale		Dec 22, 2003
			Price the property was last purchased for
	assessed_value		Towns valuation of property for tax purposes		Dec 22, 2003
			This is the TAX assessment of the property. This is NOT the saleable value of the property. This number is only for tax purposes
	assessment_year		Year property was assessed		Dec 22, 2003
			The year the property was last assessed by the town for tax purposes
	date_onsite_formated		Date foreclosure was listed on the site		Jun 1, 2003
			Date the foreclosure was listed on the site
	date_auction		Date of the auction		Dec 22, 2003
			Date of the auction, if an auction is scheduled and auction data is on file
	auction_status		Status of the auction		Dec 22, 2003
			Status of the auction, as provided by the auctioneer, if auction data is on file
	auction_notes		Notes about the auction		Dec 22, 2003
			Notes about the auction, as provided by the auctioneer, if auction data is on file
	auction_source		Source of the auction		Dec 22, 2003
			Source includes the name and phone number of the auctioneer, if auction data is on file
	date_auction_updated		Date the auction was last updated		Dec 22, 2003
			The date the auction data was last updated from the auctioneer, if auction data is on file
	apn		Assessors Parcel Number		Dec 20, 2005
			This is a unique ID assigned by the assessors office to identify this property
	date_mortgage_formatted		Mortgage Date		Dec 21, 2005
			This is the date that the foreclosing mortgage was originated
	mortgage_amount		Mortgage Amount		Dec 21, 2005
			When the mortgage was originated, this was the amount of the loan. This is NOT the current amount owed,
	mortgage_origlender		Original Mortgage Lender		Dec 21, 2005
			The original mortgage lender is the lender that first lent the money to the borrower. Often times mortgages are resold to other banks, and the original lender is no longer the current (foreclosing) lender.
	mortgage_balance		Mortgage Balance		Dec 21, 2005
			This is the current balance on the mortgage as of the balance date
	date_balance_formatted		Date of the Mortgage Balance		Dec 21, 2005
			The mortgage balance is current as of this date