V4 Documentation

Bulk Property Data Schema

Simple, reliable property data

Build your business faster with access to over 105 million properties.

Note: APN & FIPS are always included in each component and are meant to be used for cross referencing properties across each table.

metadata.csv:

Metadata related to the request.

Field:	Description:
`fips` string	Unique County identifier, first 2 digits are state FIPS. Eg. 12086
`apn` string	The formatted assessor's parcel number. Eg. 001-090-04-02
`publishing_date` string [YYYY-MM-DD] (100% coverage)	The date the data was made available at the source. Eg. 2018-02-14

addresses.csv:

Address details as provided by the assessor.

Field:	Description:
`fips` string	Unique County identifier, first 2 digits are state FIPS. Eg. 12086
`apn` string	The formatted assessor's parcel number. Eg. 001-090-04-02
`street_number` string (96% coverage)	Parsed street number. Eg. 3450
`street_pre_direction` string (20% coverage)	Directional appearing before the street name. Eg. N
`street_name` string (97% coverage)	Parsed street name. Numeric street names will include ordinal suffixes (st, nd, rd, th) Eg. Main
`street_suffix` string (92% coverage)	Standardized and parsed street suffix abbreviation. Eg. St
`street_post_direction` string (6% coverage)	Directional appearing after street suffix denoting quadrant. Eg. SW
`unit_type` string (7% coverage)	Unit type abbreviation. Eg. Apt
`unit_number` string (7% coverage)	Unit number (may be alphanumeric). Eg. 101A
`formatted_street_address` string (97% coverage)	Combined street address (including unit). Eg. 1650 N 16th St SW Apt 101
`city` string (96% coverage)	City name. Eg. Chicago
`state` string (97% coverage)	State abbreviation. Eg. IL
`zip_code` string (99% coverage)	Zip code. Eg. 60614
`zip_plus_four_code` string (92% coverage)	Four digit postal zip extension. Eg. 5505
`carrier_code` string	USPS code for mail delivery services. Eg. R001
`latitude` float (98% coverage)	Measured latitude for the property. Eg. 41.912406
`longitude` float (98% coverage)	Measured longitude for the property. Eg. -87.649191
`geocoding_accuracy` string	Describes the level of geocoding match. Eg. Parcel Centroid
`census_tract` string	The census tract as designated by the Census Bureau. Eg. 10570200.002009

parcels.csv:

Parcel details as provided by the assessor.

Field:	Description:
`fips` string	Unique County identifier, first 2 digits are state FIPS. Eg. 12086
`apn` string	The formatted assessor's parcel number. Eg. 001-090-04-02
`apn_unformatted` string	The unformatted assessor's parcel number. Eg. 0010900402
`apn_previous` string	A previous assessor's parcel number, formatted. Eg. 001-090-04-00
`depth_ft` float (21% coverage)	Depth measurement of the parcel in feet. Eg. 120.0
`frontage_ft` float	Frontage measurement of the parcel in feet. Eg. 260.0
`area_sq_ft` integer	Total area of the parcel in square feet. Eg. 31200
`area_acres` float (81% coverage)	Total area of the parcel in acres. Eg. 0.716
`county_name` string	The name of the county. Eg. Cook
`county_land_use_code` string	The land use code as provided directly from the county, without interpretation. Eg. SFR01
`county_land_use_description` string	The land use description as provided by directly from the county, without interpretation. Eg. RESIDENTIAL SINGLE DWELLING
`standardized_land_use_category` string	The general land use category for the property, converted to a common set of values across all counties. Eg. Multi-Family Residential
`standardized_land_use_type` string	Describes further granularity into the land use type, converted to a common set of values across all counties. Eg. Townhouse
`location_descriptions` [string] (5% coverage)	Pipe delimited list describing the location and surrounding area. Eg. In Cul-de-sac\|Has Mountain view
`zoning` string	City zoning designation, unique to each incorporated area. Eg. T/G
`building_count` integer (13% coverage)	Count of all buildings on the property. Eg. 1
`tax_account_number` string	Parcel identifier used by the tax assessor. Eg. 0134601209K
`legal_description` string	Legal description as provided by the assessor. Eg. Legal subdivision 4, Section 10, Township 82, West of the 6th Meridian, New York District
`lot_code` string	Indicates properties with multiple or partial lots. Eg. More than one lot
`lot_number` string	Number(s) identifying individual lots making up a property, separated by a comma (,), or ampersand (&). Ranges are denoted by a hyphen (-). Eg. 1-13,15
`subdivision` string	The name of the subdivision, plat, or tract in which the property is located Eg. CRYSTAL LAKE FOREST
`municipality` string	The jurisdiction in which the property is located. Eg. FELL TOWNSHIP
`section_township_range` string	Section township range meridian identifier. Eg. SEC 14 TWN 1N RNG 11E

structures.csv:

Information about the building(s) on the parcel.

Field:	Description:
`fips` string	Unique County identifier, first 2 digits are state FIPS. Eg. 12086
`apn` string	The formatted assessor's parcel number. Eg. 001-090-04-02
`year_built` integer (87% coverage)	The year the structure was built. Eg. 1923
`effective_year_built` integer (16% coverage)	The year a structure was substantially updated or improved. Eg. 1996
`stories` string (74% coverage)	The number of stories comprising the structure (may include fractional stories and alphabetic codes). Eg. 2+A
`rooms_count` integer (39% coverage)	The total number of rooms in the building (not just bedrooms). Eg. 4
`beds_count` integer (63% coverage)	The number of bedrooms in the building. Eg. 3
`baths` float (75% coverage)	The total number of bathrooms in the building, including half baths. Eg. 2.5
`partial_baths_count` integer (19% coverage)	The number of partial bathrooms in the building, when available. Eg. 2
`units_count` integer (25% coverage)	Total number of units reported to the county. Eg. 1
`parking_type` string (54% coverage)	The type of parking available. Eg. Detached Garage
`parking_spaces_count` integer	The total number of available parking spaces; including garage, carport, driveway. Eg. 2
`pool_type` string (6% coverage)	Type of pool located on the property - shared or private. Eg. Heated Pool
`architecture_type` string (24% coverage)	Style or historical period of the primary structure. Eg. Spanish
`construction_type` string (33% coverage)	Type of material used in construction of the building. Eg. Wood
`exterior_wall_type` string (57% coverage)	Material used for the exterior walls of the building. Eg. Stucco
`foundation_type` string (32% coverage)	The type of material used in the foundation. Eg. Concrete
`roof_material_type` string	The material used for the roof of the building. Eg. Asphalt
`roof_style_type` string (29% coverage)	The architectural style for the roof of the building. Eg. Gable
`heating_type` string (66% coverage)	Primary heating type for the building. Eg. Baseboard
`heating_fuel_type` string	Type of fuel used to heat the building. Eg. Gas
`air_conditioning_type` string (51% coverage)	Air conditioning type for the building. Eg. Central
`fireplaces` string (31% coverage)	Total number of fireplaces in the building (can also be "YES") Eg. 2
`basement_type` string (35% coverage)	Basement type for the building. Eg. Full Basement
`quality` string (43% coverage)	The quality of the structure rated from A+ to E+. This grade is determined by the county and is based on numerous, non-standard factors. For example, a mobile home would likely have a lower score than a mansion as the mobile home uses cheaper, lower quality materials and has less features. Eg. A+
`condition` string (44% coverage)	Current condition of the structure provided by the county. This relates to things like whether or not there is visible wear on the structure (e.g. chipped paint, siding falling off). The method for determining this varies across counties. Eg. Fair
`flooring_types` [string] (20% coverage)	Pipe delimited list of flooring used in improvements in the building. Eg. Carpet\|Marble
`plumbing_fixtures_count` integer	Total number of all plumbing fixtures in the building. Eg. 1
`interior_wall_type` string	The type of material used for the interior walls. Eg. Plaster
`water_type` string (23% coverage)	The water system for the property. Eg. Municipal
`sewer_type` string (23% coverage)	The waste disposal/sewage system for the property. Eg. Septic
`total_area_sq_ft` integer	Total livable square footage of the structure. Eg. 1692
`other_rooms` [string]	Pipe delimited list of other rooms within the building. Eg. Laundry Room\|Home Office
`amenities` [string]	Pipe delimited list of amenities included in the property. Eg. Wine Cellar\|Tennis Court

other_areas.csv:

Other areas within the building, and their corresponding size in sq ft.

Field:	Description:
`fips` string	Unique County identifier, first 2 digits are state FIPS. Eg. 12086
`apn` string	The formatted assessor's parcel number. Eg. 001-090-04-02
`area_type` string	A description of the area. Eg. 1st Floor
`area_sq_ft` integer	The integer area size in square feet. Eg. 346

other_features.csv:

Other features in or around the building, and their corresponding size in sq ft.

Field:	Description:
`fips` string	Unique County identifier, first 2 digits are state FIPS. Eg. 12086
`apn` string	The formatted assessor's parcel number. Eg. 001-090-04-02
`feature_type` string	A description of the area. Eg. Driveway
`feature_sq_ft` string	The area size in square feet. May hold an integer, float, or rectangle (e.g. "24X16"). Eg. 240

other_improvements.csv:

Other improvements to the property or building, and their corresponding size in sq ft.

Field:	Description:
`fips` string	Unique County identifier, first 2 digits are state FIPS. Eg. 12086
`apn` string	The formatted assessor's parcel number. Eg. 001-090-04-02
`impr_type` string	A description of the area. Eg. Greenhouse
`impr_sq_ft` string	The area size in square feet. May hold an integer, float, or rectangle (e.g. "24X16"). Eg. 435

taxes.csv:

Tax records as provided by the assessor.

Field:	Description:
`fips` string	Unique County identifier, first 2 digits are state FIPS. Eg. 12086
`apn` string	The formatted assessor's parcel number. Eg. 001-090-04-02
`year` int [YYYY]	The year the tax was levied. Eg. 2017
`amount` integer	The amount of tax on the property in dollars. Eg. 2247
`exemptions` [string]	Pipe delimited list of exemptions. Eg. Agricultural\|Low Income
`rate_code_area` string	Represents separate tax jurisdictions within the county as provided on the county tax/assessment roll. Eg. 01H

assessments.csv:

Tax assessment information as provided by the assessor.

Field:	Description:
`fips` string	Unique County identifier, first 2 digits are state FIPS. Eg. 12086
`apn` string	The formatted assessor's parcel number. Eg. 001-090-04-02
`year` int [YYYY] (90% coverage)	The year the assessment was performed. Eg. 2018
`land_value` integer (76% coverage)	The current assessed land value before any exemptions in dollars. Eg. 2580
`improvement_value` integer (78% coverage)	The current assessed improvement value before any exemptions in dollars. Eg. 13300
`total_value` integer (97% coverage)	The total current assessed value of both land and improvements before any exemptions in dollars. Eg. 15880

market_assessments.csv:

Market assessment data as determined by the assessor.

Field:	Description:
`fips` string	Unique County identifier, first 2 digits are state FIPS. Eg. 12086
`apn` string	The formatted assessor's parcel number. Eg. 001-090-04-02
`year` int [YYYY]	The year the market assessment was performed. Eg. 2017
`land_value` integer	The market land value as determined by the assessor. Eg. 3000
`improvement_value` integer	The market improvement value as determined by the assessor. Eg. 12000
`total_value` integer	The total market value as determined by the assessor. Eg. 15000

valuations.csv:

Valuation details as provided by a proprietary valuation algorithm.

Field:	Description:
`fips` string	Unique County identifier, first 2 digits are state FIPS. Eg. 12086
`apn` string	The formatted assessor's parcel number. Eg. 001-090-04-02
`value` integer (89% coverage)	The current property value. Eg. 16430
`high` integer (89% coverage)	The highest probable value. Eg. 17220
`low` integer (89% coverage)	The lowest probable value. Eg. 15780
`forecast_standard_deviation` integer [percentage 0-100]	Forecast standard deviation. Eg. 55
`date` string [YYYY-MM-DD]	The date the valuation was performed. Eg. 2019-10-24

owners.csv:

Current owner details taken from either the assessment or the latest deed, whichever is more recent.

Field:	Description:
`fips` string	Unique County identifier, first 2 digits are state FIPS. Eg. 12086
`apn` string	The formatted assessor's parcel number. Eg. 001-090-04-02
`name` string (100% coverage)	Assessed owner name. Eg. John Smith
`second_name` string (16% coverage)	Second assessed owner name when provided by county. Eg. Jane Smith
`formatted_street_address` string	The address where the current tax bill is mailed (not including unit). Eg. 123 Main St
`unit_type` string	The unit type. Eg. Apt
`unit_number` string	The unit number. Eg. 104
`city` string (99% coverage)	The city where the current tax bill is mailed. In the case it is out of USA, the county will also be located here. Eg. Atlanta
`state` string (99% coverage)	The state abbreviation where the current tax bill is mailed; XX for out of country addresses. Eg. GA
`zip_code` string (99% coverage)	The zip code where the current tax bill is mailed. Eg. 30342
`zip_plus_four_code` string	92244980 Eg. 3019
`owner_occupied` string	Description of the owner occupancy. Can be "YES" or "PROBABLE". Data not available if null. Eg. Yes

deeds.csv:

Up to 20 years of sale and mortgage data which constitute a deed record.

Field:	Description:
`fips` string	Unique County identifier, first 2 digits are state FIPS. Eg. 12086
`apn` string	The formatted assessor's parcel number. Eg. 001-090-04-02
`document_type` string	Type of deed document. Eg. Warranty Deed
`recording_date` string [YYYY-MM-DD] (68% coverage)	The official date the document was recorded. Eg. 2011-12-28
`original_contract_date` string [YYYY-MM-DD]	The date the original contract was signed. Eg. 2011-12-26
`deed_book` string (34% coverage)	The physical book where the deed was recorded. Eg. 9056
`deed_page` string (34% coverage)	The physical page where the deed was recorded. Eg. 595
`document_id` string (56% coverage)	Identifier assigned to document at the recording date. Eg. 93154L
`sale_price` integer (39% coverage)	The total sale price in dollars. Eg. 170000
`sale_price_description` string	A description of the sale. Eg. Estimated
`transfer_tax` float	The tax amount levied by the city, county, or a combination thereof. Eg. 142.03
`distressed_sale` boolean	An indicator to determine if the sale was deemed to be distressed. Eg. false
`real_estate_owned` string	An indicator used to determine the status of the transfer. Eg. NO
`seller_first_name` string	Seller first name, or null if corporate owner. Eg. John
`seller_last_name` string	Seller last name, or corporate name. Eg. Smith
`seller2_first_name` string	The second seller first name, or null if corporate owner. Eg. Jane
`seller2_last_name` string	The second seller last name, or corporate name. Eg. Smith
`seller_address` string	The seller mailing address. Eg. 123 Main St
`seller_unit_number` string	The seller unit number. Eg. 1
`seller_city` string	The seller city. Eg. Phoenix
`seller_state` string	The seller mailing state. Eg. AZ
`seller_zip_code` string	Seller zip code. Eg. 85024
`seller_zip_plus_four_code` string	Seller four digit postal zip extension. Eg. 3019
`buyer_first_name` string	Buyer first name, or null if corporate owner. Eg. John
`buyer_last_name` string	Buyer last name, or corporate name. Eg. Smith
`buyer2_first_name` string	Second buyer first name, or null if corporate owner. Eg. Jane
`buyer2_last_name` string	Second buyer last name, or corporate name. Eg. Smith
`buyer_address` string	Buyer mailing address. Eg. 123 Main St
`buyer_unit_type` string	Buyer unit type. Eg. Apt
`buyer_unit_number` string	Buyer unit number. Eg. 1A
`buyer_city` string	Buyer mailing city. Eg. Denver
`buyer_state` string	Buyer mailing state. Eg. CO
`buyer_zip_code` string	Buyer mailing zip code. Eg. 80222
`buyer_zip_plus_four_code` string	Buyer four digit postal zip extension. Eg. 3019
`lender_name` string	Mortgage lender. Eg. CITIMORTGAGE INC
`lender_type` string	The type of lender. Eg. Bank
`loan_amount` integer (26% coverage)	Mortgage recorded in dollars. Eg. 74900
`loan_type` string (23% coverage)	Type of loan security. Eg. Closed Mortgage
`loan_due_date` string [YYYY-MM-DD]	The date the mortgage will be paid in full. Eg. 2029-10-22
`loan_finance_type` string	The interest rate type on the loan. Eg. Fixed Rate
`loan_interest_rate` float	The interest rate of the loan. Eg. 2.97

Ready to get started?

Choose specific areas and fields that you want and get flexible licensing and pricing suited to your needs. Whether you need information about entire states for market expansion or individual neighborhoods to assist in your marketing efforts, Estated has the data.

Contact Sales →

Or call 1 (236) 420-2976