Data Layout

Introduction

Property and Mortgage data for Insight and Analytics. Add Property and Mortgage Data to Your Records for Data-Driven Insight and Analytics. Our custom property data solutions give you fresh, accurate real estate and property data on more than 140 million U.S. properties including parcel and building information, calculated value, deed information and history, and more. Along with comprehensive information on the property, you also get detailed information on the homeowner and all other properties that owner has ever owned.

When you add more than 400 fields of detailed property data to your in-house records, you’ll gain the competitive edge and capitalize on market opportunities. The Property API is ideal for lenders, real estate professionals, investors and insurance agents.

Property Data

Sample File

Click here to download the sample file.

Layout and Definitions

Grouping	Column Name	Type	Definition
Address	PropertyMelissaAddressKey	bigint	10-digit unique key assigned to each address.
	PropertyBaseMelissaAddressKey	bigint	Displays the parent Melissa Address Key of an address if it is apart or within a building. Ex. Apartment
	PropertyAddressLine	varchar(100)	AddressLine
	PropertySuite	varchar(40)	Suite
	PropertyCity	varchar(70)	City
	PropertyState	varchar(2)	State
	PropertyZIPCode	varchar(5)	ZIP code
	PropertyPlus4	varchar(4)	Plus4
	PropertyDeliveryPoint	varchar(2)	A specific location where mail is delivered to an individual or entity. It is a precise point of delivery for a particular address.
	PropertyAddressKey	varchar(22)	Address key is a combination of a location’s ZIPCode + Plus4 + DeliveryPoint
	PropertyResultCodes	varchar(200)	Melissa result codes
	PropertyStreetNumber	varchar(10)	Address street number. Ex. ‘6450’
	PropertyDirectionPrefix	varchar(5)	Address directional prefix. Ex. ‘e’
	propertyStreetName	varchar(40)	Street name. Ex. ‘Side’
	PropertyStreetSuffix	varchar(10)	Suffix of address. Ex. ‘Dr’
	PropertyDirectionSuffix	varchar(5)	Address directional suffix. Ex. ‘Ne’
	PropertySuiteName	varchar(10)	Suite. Ex. ‘Apt’
	PropertySuiteNumber	varchar(10)	Suite number. Ex. ‘Q’
	PropertyCarrierRoute	varchar(4)	The carrier route for the location address assigned by the USPS.
	PropertyFIPSCode	varchar(5)	The FIPSCode indicates the location of the address at both the state and county level.
Geo	PropertyPlaceCode	varchar(7)	Place identifier represented as State FIPS (2) + PlaceFIPS (5)
	PropertyLatitude	decimal(18,6)	The latitude in decimal degrees using the WGS84 datum for the address
	PropertyLongitude	decimal(18,6)	The longitude in decimal degrees using the WGS84 datum for the address
	PropertyCensusKey	varchar(16)	Census key is a 15 or 16-character key combination of the state FIPS code + county FIPS code + tract number + block number + block suffix. The Census key was created by the US Government to correctly identify, classify, and pull statistical data from areas across the United States.
	PropertyCensusKeyDecennial	varchar(16)	Similar to the Census key, however, this key contains 15 characters and changes every 10 years. Fifteen-digit key that represents: State (2) + County (3) + Tract (6) + Block Group Number (4)
Address	CountyName	varchar(25)	County name
PropertyValuationModel	PropertyEstimatedValue	int	Highest hit rates.
	PropertyEstimatedMinValue	int	The lowest probable value for the subject property
	PropertyEstimatedMaxValue	int	The highest probable value for the subject property
	PropertyEstimatedConfidenceScore	int	Confidence Score is a metric to gauge accuracy of the value estimate based on property and MLS data available to the model. Confidence Scores range from 0 to 100, with higher score being better
	PropertyEstimatedValueFSD	int	Forecast Deviation (FSD) is statically recognized metric that measure standard deviation that single value estimates is within a +/- percentage of the true value
	ValuationDate	varchar(8)	Date AVM value was rendered
Parcel	APN	varchar(45)	Assessor’s Parcel Number or Parcel Identification Number
	APNUndecorated	varchar(45)	Undecorated Assessor’s Parcel Number or Parcel Identification Number

Code and Definitions

Column Name	Code	Definition
Mortgage1InterestRateType	1	Adjustable Rate
	0	Unknown
	2	Fixed Rate
PropertyRBDI	B	Business
	P	P.O. Box
	R	Residential
	U	Unknown
PropertyAddressType	A	Alias
	F	Firm or Company Address
	G	General Delivery Address
	H	High Rise or Business Complex
	P	P.O. Box Address
	R	Rural Route Address
	S	Street or Residential Address
	U	Unique
	Z	Unique
Mortgage1Type	126	Stand Alone First
	128	Stand Alone Second
	123	Arm (Adjustable Rate Mortgage)
	0	Unknown
	101	USDA - US Department of Agriculture Loan
	124	Closed End Mortgage
	133	Small Business Association
	121	Assumption
	3	Building or Construction
	134	Cash
	130	Second Mortgage To Cover Down Payment
	6	Line of Credit
	8	FHA
	122	Balloon
	102	Farmers Home Administration
	135	Negative Amortization
	131	Land Contract (Arrangement Of Sale)
	132	Loan Modification
	10	Conventional
	103	Commercial
	127	Stand Alone Refinance
	125	Seller Take-Back
	16	Veterans Administration Loan
	105	Reverse Mortgage
Mortgage2InterestRateType	1	Adjustable Rate
	0	Unknown
	2	Fixed Rate
Mortgage2Type	126	Stand Alone First
	128	Stand Alone Second
	123	Arm (Adjustable Rate Mortgage)
	0	Unknown
	101	USDA - US Department of Agriculture Loan
	124	Closed End Mortgage
	133	Small Business Association
	121	Assumption
	3	Building or Construction
	134	Cash
	130	Second Mortgage To Cover Down Payment
	6	Line of Credit
	8	FHA
	122	Balloon
	102	Farmers Home Administration
	135	Negative Amortization
	131	Land Contract (Arrangement Of Sale)
	132	Loan Modification
	10	Conventional
	103	Commercial
	127	Stand Alone Refinance
	125	Seller Take-Back
	16	Veterans Administration Loan
	105	Reverse Mortgage
VestingTypeCode	174	Also Known As (a/k/a)
	103	Company
	149	Community Property
	227	Contract Owner
	175	Doing Business As (dba)
	216	Domestic Partner
	218	Et Al (and Others) - Vendor Data Only
	150	Estate
	219	Et Ux (and Wife) - Vendor Data Only
	151	Executor
	178	Formerly Known As (f/k/a)
	220	Family Living Trust
	221	Family Trust
	222	Family Revocable Trust
	179	Government
	223	Her Husband
	109	Husband And Wife
	204	Irrevocable Living Trust
	203	Irrevocable Trust
	153	Joint Tenant/joint Tenant W/ Right Of Survivorship
	205	Joint Tenants
	154	Joint Venture
	156	Life Estate
	182	Life Tenant (holds A Life Estate Interest Only)
	159	Living Trust
	183	Minor, Ward Or Client (represented By Trustee)
	206	Married Man As His Sole And Separate Property
	207	Married Woman As Her Sole & Separate Property
	208	Partnership
	189	Revocable Living Trust
	164	Right Of Survivorship
	165	Revocable Trust
	125	Single Man
	167	Sole Owner
	127	Single Woman
	169	Tenants In Common
	209	Transfer Of Death
	171	Tenant By Entirety
	210	Tenant
	211	Trustee/conservator
	129	Trustee
	215	Tax Payer
	195	Widow Or Widower
TrustDescription		Not Available
	Name is a Trust	Name is a Trust
CompanyInd		Not Available
	N	N
	Y	Y
PropertyUseStandardized	315	Miscellaneous (General)
	246	Pipeline Or Right-of-way
	248	Rail (Right-Of-Way & Track)
	249	Road (Right-Of-Way)
	255	Utilities (Right-Of-Way Only)
	252	Sub-surface Rights (Mineral)
	253	Surface Rights (Grazing, Timber, Coal, Etc.)
	438	Leasehold Rights (Misc.)
	431	Possessory Interest (Misc.)
	456	Petroleum & Gas Wells (Misc.)
	435	Water Rights (Misc.)
	251	Right-of-way (Not Rail, Road Or Utility)
	465	Easement (Misc.)
	440	Homestead (Misc.)
	407	Common Area (Misc.)
	250	Royalty Interest
	257	Working Interest
	463	Parcels With Improvements, Use Not Specified
	411	Personal Property (General)
	441	Vehicles (General)
	420	Motor Vehicles (Cars, Trucks, Etc.)
	460	Recreational Vehicles / Travel Trailers
	432	Watercraft (Ships, Boats, Pwcs, Etc.)
	415	Aircraft
	434	Rolling Stock (Railroad)
	427	Spacecraft
	444	Misc Vehicles Not Otherwise Classed (Antiques, Etc.)
	445	Business Personal Property (General)
	455	Equipment / Supplies
	419	Inventory
	425	Goods In Transit
	466	Livestock (Animals, Fish, Birds, Etc.)
	413	Crops (In Ground)
	446	Crops (Harvested)
	439	Misc. Business Personal Property Not Otherwise Classed
	414	Structures (General)
	429	Structures On Leased Land
	408	Temporary Structures
	422	Misc Structures Not Otherwise Classed (Billboards, Etc.)
	437	Intangible Personal Property
	436	Misc Personal Property Not Otherwise Classed
	181	Single Family Residential
	385	Single Family Residential
	386	Townhouse
	364	Cluster Home
	366	Condominium
	367	Cooperative
	373	Mobile Home
	382	Row House
	118	Agricultural/rural (General)
	377	Planned Unit Development (PUD)
	365	Common Area (Residential)
	387	Timeshare
	384	Seasonal, Cabin, Vacation Residence
	363	Bungalow (Residential)
	390	Zero Lot Line (Residential)
	375	Miscellaneous (Residential)
	371	Manufactured, Modular, Pre-fabricated Homes
	376	Patio Home
	452	Garden Home
	416	Landominium
	423	Barndominium
	447	Tiny House
	381	Residential Income (General/Multi-Family)
369	Duplex (2 Units, Any Combination)
388	Triplex (3 Units, Any Combination)
378	Quadplex (4 Units, Any Combination)
361	Apartment House (5+ Units)
359	Apartment House (100+ Units)
357	Garden Apt, Court Apt (5+ Units)
358	High-rise Apartments
362	Boarding/rooming House, Apt Hotel
162	Mobile Home Park, Trailer Park
372	Multi-family Dwellings (Generic, Any Combination)
370	Fraternity House, Sorority House
360	Apartments (Generic)
368	Dormitory, Group Quarters (Residential)
379	Condominium Development (Association Assessment)
421	Condominium Building (Residential)
461	Cooperative Building (Residential)
418	Residential Parking Garage
448	Residential Storage Space
135	Commercial (General)
178	Retail Stores (Personal Services, Photography, Travel)
143	Department Store (Multi-Story)
140	Store/office (Mixed Use)
141	Department Store (Apparel, Household Goods, Furniture)
151	Grocery, Supermarket
179	Regional: Shopping Center, Mall (w/Anchor)
183	Community: Shopping Center, Mini-mall
167	Neighborhood: Shopping Center, Strip Center, Enterprise Zone
182	Shopping Center Common Area (Parking Etc)
192	Veterinary, Animal Hospital
148	Restaurant
146	Drive-thru Restaurant, Fast Food
189	Take-out Restaurant (Food Preparation)
128	Bakery
129	Bar, Tavern
158	Liquor Store
124	Convenience Store (7-11)
137	Convenience Store (w/Fuel Pump)
186	Service Station (Full Service)
185	Service Station w/Convenience Store (Food Mart)
190	Truck Stop (Fuel And Diner)
127	Vehicle Sales, Vehicle Rentals (Auto/Truck/RV/Boat/etc)
126	Auto Repair, Garage
193	Car Wash
147	Dry Cleaner
191	Service Shop (TV, Radio, Electric, Plumbing)
168	Nursery, Greenhouse, Florist (Retail, Wholesale)
194	Wholesale Outlet, Discount Store (Franchise)
173	Printer - Retail (Pip, Qwikcopy, etc.)
229	Mini-warehouse, Storage
175	Day Care, Pre-School (Commercial)
163	Motel
155	Hotel
172	Parking Garage, Parking Structure
174	Parking Lot
133	Cemetery, Funeral Home, Mortuary (Commercial)
132	Casino
154	Hotel-Resort
153	Hotel/motel
180	Gas Station
130	Commercial Building, Mail Order, Show Room (Non-Auto), Warehouse
171	Commercial Office/residential (Mixed Use)
125	Appliance Store (Bix Box Appliance)
156	Kennel
157	Laundromat (Self-Service)
166	Nightclub (Cocktail Lounge)
149	Farm Supply & Equipment (Commercial)
144	Garden Center, Home Improvement (Do-It-Yourself)
138	Commercial Condominium (Not Offices)
145	Drug Store, Pharmacy
131	Bed & Breakfast
464	Barber/Hair Salon
412	Pet Boarding & Grooming
449	Roadside Market
458	Car Wash - Automated
433	Car Wash - Self-Serve
459	Cannabis Dispensary
136	Commercial Office (General)
177	Professional Building (Legal, Insurance, Real Estate, Business)
176	Professional Building (Multi-Story)
169	Office Building
170	Office Building (Multi-Story)
142	Dental Building
160	Medical Building
150	Financial Building
139	Condominium Offices
184	Skyscraper/high-rise (Commercial Offices)
161	Mixed Use (Commercial/Industrial)
134	Common Area (Commercial, Not Shopping Center)
159	Mobile Commercial Units
334	Recreational/Entertainment (General)
332	Recreational Center
326	Public Swimming Pool
311	Marina, Boat Slips, Yacht Club, Boat Landing
264	Bowling Alley
259	Arcades (Amusement)
343	Skating Rink, Ice Skating, Roller Skating
270	Clubs, Lodges, Professional Associations
316	Museum, Library, Art Gallery (Recreational)
267	Country Club
346	Stadium
260	Arena, Convention Center
261	Auditorium
290	Driving Range (Golf)
350	Race Track (Auto, Dog, Horse)
296	Gym, Health Spa
279	Dance Hall
337	Riding Stable, Trails
273	Campground, RV Park
285	Fairgrounds
348	Theater (Movie)
281	Drive-in Theater
327	Amusement Park, Tourist Attraction
323	Piers, Wharf (Recreation)
287	Fish Camps, Game Club Target Shooting
262	Outdoor Recreation: Beach, Mountain, Desert
263	Pool Hall, Billiard Parlor
322	Park, Playground, Picnic Area
293	Golf Course
331	Racquet Court, Tennis Court
355	Zoo
292	Go-carts, Miniature Gold, Water Slides
410	Sports Complex
212	Industrial (General)
220	Manufacturing (Light)
215	Light Industrial (10% Improved Office Space; Machine Shop)
238	Warehouse, Storage
236	Storage Yard, Open Storage (Light Equipment, Material)
208	Food Packing, Packing Plant (Fruit, Vegetable, Meat, Dairy)
195	Assembly (Light Industrial)
206	Food Processing
232	Recycling (Metal, Paper, Glass)
272	Communications
201	Condominiums (Industrial)
231	R&d Facility, Laboratory, Research Facility, Cosmetics, Pharmaceutical
213	Industrial Park
224	Multi-tenant Industrial Building
219	Marine Facility/board Repairs (Small Craft, Sailboat)
218	Lumber & Wood Product Mfg (Including Furniture)
225	Paper Product Mfg & Related Products
227	Printing & Publishing (Light Industrial)
216	Industrial Loft Building, Loft Building
198	Construction/contracting Services (Industrial)
200	Common Area (Industrial)
210	Heavy Industrial (General)
291	Transportation (General)
280	Distribution Warehouse (Regional)
222	Mining, Mineral, Quarries
235	Storage Yard (Junk, Auto Wrecking, Salvage)
203	Distillery, Brewery, Bottling
226	Refinery, Petroleum Products
221	Mill (Feed, Grain, Paper, Lumber, Textile, Pulp)
205	Factory (Apparel, Textile, Leather, Medium Mfg)
228	Processing Plant (Minerals, Cement, Rock, Gravel, Glass, Clay)
217	Lumberyard, Building Materials
233	Shipyard - Built Or Repaired (Seagoing Vessels)
234	Slaughter House, Stockyard
240	Waste Disposal, Sewage (Processing, Disposal, Storage, Treatment)
230	Quarries (Sand, Gravel, Rock)
211	Heavy Manufacturing
214	Labor Camps (Industrial)
239	Winery
199	Chemical
207	Foundry, Industrial Plant (Metal, Rubber, Plastic)
197	Cannery
196	Bulk Storage, Tanks (Gasoline, Fuel, Etc)
209	Grain Elevator
204	Dump Site
202	Cold Storage
237	Sugar Refinery
258	Airport & Related
330	Railroad & Related
289	Freeways, State Hwys
338	Roads, Streets, Bridges
265	Bus Terminal
347	Telegraph, Telephone
340	Radio Or TV Station
351	Truck Terminal (Motor Freight)
276	Cable TV Station
300	Harbor & Marine Transportation
313	Microwave
266	Commercial Auto Transportation/Storage
324	Pollution Control
451	Cellular
105	Farm (Irrigated Or Dry)
114	Ranch
117	Range Land (Grazing)
103	Farm, Crops
110	Orchard (Fruit, Nut)
121	Vineyard
113	Poultry Farm (Chicken, Turkey, Fish, Bees, Rabbits)
101	Dairy Farm
120	Timberland, Forest, Trees
123	Wildlife (Refuge)
102	Desert Or Barren Land
112	Pasture
109	Miscellaneous Structures - Ranch, Farm Fixtures
111	Orchards, Groves
104	Feedlots
108	Livestock, Animals
106	Horticulture, Ornamental (Agricultural)
122	Well Site (Agricultural)
119	Truck Crops
115	Reservoir, Water Supply
107	Irrigation, Flood Control
317	Natural Resources
116	Rural Improved / Non-residential
450	Cannabis Grow Facility
389	Vacant Land
401	Residential - Vacant Land
393	Vacant Commercial
395	Industrial - Vacant Land
399	Private Preserve, Open Space - Vacant Land
396	Institutional - Vacant Land
394	Government - Vacant Land
398	Multi-family - Vacant Land
392	Agricultural (Unimproved) - Vacant Land
404	Waste Land, Marsh, Swamp, Submerged - Vacant Land
400	Recreational - Vacant Land
406	Water Area (Lakes, River, Shore) - Vacant Land
403	Unusable Land (Remnant, Steep, Etc.)
391	Abandoned Site, Contaminated Site
402	Under Construction
453	Vacant Land - Destroyed/Uninhabitable Improvement
462	Vacant Land - Unspecified Improvement
409	Vacant Land - Exempt
345	Special Purpose
333	Regulating Districts & Assessments; Tax Abatement
335	Redevelopment Agency Or Zone
268	Centrally Assessed
284	Exempt (Full Or Partial)
309	Indian Lands
310	Institutional (General)
336	Religious, Church, Worship (Synagogue, Temple, Parsonage)
328	Parochial School, Private School
274	College, University, Vocational School - Private
152	Hospital - Private
312	Medical Clinic
339	Homes (Retired, Handicap, Rest, Convalescent, Nursing)
320	Children’s Home, Orphanage
282	Cemetery (Exempt)
275	Crematorium, Mortuary (Exempt)
269	Charitable Organization, Fraternal
318	Recreational Non-taxable (Camps, Boy Scouts)
353	Private Utility (Electric, Water, Gas, Etc.)
294	Governmental / Public Use (General)
314	Military (Office, Base, Post, Port, Reserve, Weapon Range, Test Sites)
288	Forest (Park, Reserve, Recreation, Conservation)
342	Public School (Administration, Campus, Dorms, Instruction)
352	Colleges, University - Public
325	Post Office
298	Cultural, Historical (Monuments, Homes, Museums, Other)
295	Govt. Administrative Office (Federal, State, Local, Court House)
283	Emergency (Police, Fire, Rescue, Shelters, Animal Shelter)
356	Other Exempt Property
277	City, Municipal, Town, Village Owned (Exempt)
278	County Owned (Exempt)
344	State Owned (Exempt)
286	Federal Property (Exempt)
321	Public Health Care Facility (Exempt)
271	Community Center (Exempt)
329	Public Utility (Electric, Water, Gas, Etc.)
354	Welfare, Social Service, Low Income Housing (Exempt)
319	Correctional Facility, Jails, Prisons, Insane Asylum
302	Hospital - Public
304	Historical - Private (General)
306	Historical Residence
307	Historical Retail
308	Historical Warehouse
301	Historical Office
299	Historical Transient Lodging (Hotel, Motel)
305	Historical Recreation, Entertainment
303	Historical Park, Site, Misc.
297	Historical District
Pool	110	Above-ground Pool
	502	Pool w/Hot Tub/Spa
	101	Public/Municipal/Commercial
	610	Pool (Unspecified), Enclosed
	121	In-ground Vinyl Pool
	401	Pool (Unspecified), Heated
	130	Indoor Pool
	402	Pool, Solar Heated
	999	Type Unspecified
	904	Spa/Hot Tub (only)
Foundation	Null	Null
	501	Raised (Unspecified)
	999	Type Not Specified
	922	Masonry (Unspecified)
	921	Stone (Unspecified)
	924	Brick (Unspecified)
	923	Block (Unspecified)
	300	Pile
	400	Pier/Post & Beam
	930	Retaining Wall
	100	Mat/Raft Foundation (Slab)
	200	FOOTING
	920	Wood (Unspecified)
Construction	Null	Null
	31	Brick
	23	Concrete
	28	Concrete Blocks
	50	Arched/Dome
	2	Frame
	8	Heavy Frame
	7	Light Frame
	42	Log
	43	Manufactured
	1	Type Not Specified
	25	Masonry/Concrete Masonry Units (CMUs)
	19	Metal Frame
	20	Steel Frame
	38	Stone
	46	Tilt-Up Concrete
	10	Wood
	99	Mixed
RoofConstruction	Null	Null
	251	Gable
	313	Bowstring Truss
	329	Reinforced Concrete
	345	Geodesic/Dome
	312	Steel Frm/truss
	197	Flat
	253	Gable/Hip
	258	Hip
	283	Cathedral/Clerestory
	289	Gambrel
	265	Mansard
	320	Prestress Concrete
	311	Rigid Frm Bar Jt
	274	Shed
	282	Sawtooth
	318	Wood Truss
ViewDescription	Null	Null
	A	Freeway Proximity
	B	Waterfront-Beach (Ocean, River, or Lake)
	C	Contamination Site
	D	Cul-de-sac
	E	Corner
	VPR	Poor
	VAV	Average
	H	Historical
	I	School Proximity
	VGC	Golf Course
	0	None
	VLA	Lake
	VMN	Mountain
	VCA	Canal
	VOC	Ocean
	P	Proximity To Airport
	VGP	Greenbelt/Park
	R	Proximity To Railroad
	S	Major Street/Thoroughfare
	T	High Traffic Area
	VRR	River
		None
	Z	Flood Plain/Flood Zone
PorchCode	Null	Null
	PC0	Covered Porch
	PE0	Enclosed Porch
	P0Y	Glass Porch
	PO0	Open Porch
InteriorStructure	Null	Null
	410	Brick
	430	Concrete
	402	Block (Unspecified)
	750	Glass
	101	Finished/Painted
	201	Wallboard/Drywall
	102	Custom/Decorative
	401	Masonry (Unspecified)
	350	Log
	210	Cement Board
	104	Composition
	199	Other
	701	Plaster
	110	Paneling (Unspecified)
	420	Stone
	601	Metal
	190	Unfinished
	760	Vinyl Panel/Coating
	301	Wood (Unspecified)
	320	Plywood
HVACCoolingDetail	Null	Null
	136	Evaporative Cooler
	137	Other
	122	Refrigeration AC
	119	Fan Cooling AC
	139	Chilled Wate
HVACHeatingDetail	Null	Null
	103	Baseboard
	113	Electric
	108	Central
	102	Forced Air
	232	Oil
	109	Floor/Wall Furnace
	104	Gravity
	105	Heat Pump
	243	Geo-Thermal
	111	Hot Water
	231	Gas
	226	Partial
	112	Radiant
	219	None
	101	Other
	110	Steam
	229	Coal
	120	Space
	222	Convection
	106	Solar
	122	Wood Furnace
	244	Propane
	236	Yes
	238	Zone
ForeclosureRecordType	Null	Null
		Not Available
	ND	Notice of Default
	NL	Notice of Lis Pendens
	NS	Notice of Foreclosure Sale
	NT	Notice of Trustee Sale
MailingAddressType	Null	Null
		Not Available
	A	Alias
	F	Firm or Company Address
	G	General Delivery Address
	H	High Rise or Business Complex
	P	P.O. Box Address
	R	Rural Route Address
	S	Street or Residential Address
	U	Unique
	Z	Unique

Automated Valuation Models (AVM)

Sample File

Click here to download the sample file.

Layout and Definitions

Grouping	Column Name	Type	Definition
Address	PropertyMelissaAddressKey	bigint	10-digit unique key assigned to each address.
	PropertyBaseMelissaAddressKey	bigint	Displays the parent Melissa Address Key of an address if it is apart or within a building. Ex. Apartment
	PropertyAddressLine	varchar(100)	AddressLine
	PropertySuite	varchar(40)	Suite
	PropertyCity	varchar(70)	City
	PropertyState	varchar(2)	State
	PropertyZIPCode	varchar(5)	ZIP code
	PropertyPlus4	varchar(4)	Plus4
	PropertyDeliveryPoint	varchar(2)	A specific location where mail is delivered to an individual or entity. It is a precise point of delivery for a particular address.
	PropertyAddressKey	varchar(22)	Address key is a combination of a location’s ZIPCode + Plus4 + DeliveryPoint
	PropertyResultCodes	varchar(200)	Melissa result codes
	PropertyStreetNumber	varchar(10)	Address street number. Ex. ‘6450’
	PropertyDirectionPrefix	varchar(5)	Address directional prefix. Ex. ‘e’
	propertyStreetName	varchar(40)	Street name. Ex. ‘Side’
	PropertyStreetSuffix	varchar(10)	Suffix of address. Ex. ‘Dr’
	PropertyDirectionSuffix	varchar(5)	Address directional suffix. Ex. ‘Ne’
	PropertySuiteName	varchar(10)	Suite. Ex. ‘Apt’
	PropertySuiteNumber	varchar(10)	Suite number. Ex. ‘Q’
	PropertyPlaceCode	varchar(7)	Place identifier represented as State FIPS (2) + PlaceFIPS (5)
	PropertyCarrierRoute	varchar(4)	The carrier route for the location address assigned by the USPS.
	PropertyFIPSCode	varchar(5)	The FIPSCode indicates the location of the address at both the state and county level.
	PropertyDeliveryPointChecksum	varchar(1)	Barcode for the postal route, assigned to the mailing (primary) address. It shoul be 1 digits
Geo	PropertyLatitude	decimal	The latitude in decimal degrees using the WGS84 datum for the address
	PropertyLongitude	decimal	The longitude in decimal degrees using the WGS84 datum for the address
	PropertyCensusKey	varchar(16)	Census key is a 15 or 16-character key combination of the state FIPS code + county FIPS code + tract number + block number + block suffix. The Census key was created by the US Government to correctly identify, classify, and pull statistical data from areas across the United States.
	PropertyCensusKeyDecennial	varchar(16)	Similar to the Census key, however, this key contains 15 characters and changes every 10 years. Fifteen-digit key that represents: State (2) + County (3) + Tract (6) + Block Group Number (4)
Address	CountyName	varchar(25)	County name
PropertyValuationModel	PropertyEstimatedValue	int	Highest hit rates.
	PropertyEstimatedMinValue	int	The lowest probable value for the subject property
	PropertyEstimatedMaxValue	int	The highest probable value for the subject property
	PropertyEstimatedConfidenceScore	int	Confidence Score is a metric to gauge accuracy of the value estimate based on property and MLS data available to the model. Confidence Scores range from 0 to 100, with higher score being better
	PropertyEstimatedValueFSD	int	Forecast Deviation (FSD) is statically recognized metric that measure standard deviation that single value estimates is within a +/- percentage of the true value
	ValuationDate	varchar(8)	Date AVM value was rendered
Parcel	APN	varchar(45)	Assessor’s Parcel Number or Parcel Identification Number
	APNUndecorated	varchar(45)	Undecorated Assessor’s Parcel Number or Parcel Identification Number