Data Layout

Introduction

New Movers – whether they’re renters or homeowners - spend more on home-related goods and services in the first three months than non-movers spend in five years! We add 100,000+ records to our New Movers database every week, so you can confidently build your mailing list and take advantage of this window of opportunity with the freshest, most targeted data available.

Sample File

Click here to download the sample file.

Layout and Definitions

Grouping	Column Name	Type	Definition
Address	MelissaAddressKey	bigint	10-digit unique key assigned to each address.
	BaseMelissaAddressKey	bigint	Displays the parent Melissa Address Key of an address if it is a part of or within a building. Ex. Apartment
People	FullName	varchar(60)	Full Name
	FirstName	varchar(50)	First name
	MiddleName	varchar(15)	Middle Name
	LastName	varchar(50)	Last Name
Address	AddressLine	varchar(50)	Address line
	City	varchar(28)	City
	State	varchar(2)	State
	ZIPCode	varchar(5)	ZIP Code
	Plus4	varchar(4)	ZIP Code plus 4
	AddressKey	varchar(11)	Address key is a combination of a location’s ZIPCode + Plus4 + DeliveryPoint
	ResultCodes	varchar(100)	Melissa result codes
AddressPrevious	PreviousMelissaAddressKey	bigint	10-digit unique key assigned to each address.
	PreviousBaseMelissaAddressKey	bigint	Displays the parent Melissa Address Key of an address if it is a part of or within a building. Ex. Apartment
	PreviousAddressLine	varchar(50)	Previous address line
	PreviousSuite	varchar(50)	Previous suite
	PreviousCity	varchar(50)	Previous city
	PreviousState	varchar(2)	Previous state
	PreviousZIPCode	varchar(5)	Previous ZIP Code
	PreviousPlus4	varchar(4)	Previous Plus4
	PreviousAddressKey	varchar(11)	Previous addressKey
Demographic	MoveEffectiveDate	varchar(10)	Effective move date
	EstimatedHouseholdIncomeCode	varchar(2)	Estimated house income
	AgeOfHouseholdCode	varchar(1)	Age range of household
	EstimatedHousingValueCode	varchar(2)	Code for estimated house value code
	HomeOwnershipCode	varchar(1)	The probability of home ownership.
	PresenceOfChildrenCode	varchar(1)	The probability of children being present in the home.
	DwellingSpecificCode	varchar(1)	Dwelling type of a location. Refer to code definition for more insight.
	MoveDistanceCode	varchar(1)	The distance movers have moved from original locations.
Geo	Latitude	decimal(18,6)	The latitude in decimal degrees using the WGS84 datum for the address.
	Longitude	decimal(18,6)	The longitude in decimal degrees using the WGS84 datum for the address.
	CensusKey	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.
GeoPrevious	PreviousLatitude	decimal(18,6)	Previous latitude
	PreviousLongitude	decimal(18,6)	Previous longitude
	PreviousResultCodes	varchar(100)	Previous Melissa result codes
Phone	PhoneNumber	varchar(10)	Phone Number

Code and Definitions

Column Name	Code	Definition
AgeOfHouseholdCode	0	Unknown/No Data
	1	Under 35 Years of Age
	2	35-54 Years of Age
	3	55-64 Years of Age
	4	65 and Above Years of Age
DwellingSpecificCode	NULL	No Data/Default
	0	Unknown
	1	SFDU
	2	MFDU
	3	Rural Route/ General Delivery
	4	Post Office Box
EstimatedHouseholdIncomeCode	0	Unknown/NoData
	1	Under $15,000
	2	$15,000 - $19,999
	3	$20,000 - $24,999
	4	$25,000 - $29,999
	5	$30,000 - $34,999
	6	$35,000 - $39,999
	7	$40,000 - $44,999
	8	$45,000 - $49,999
	9	$50,000 - $54,999
	10	$55,000 - $59,999
	11	$60,000 - $64,999
	12	$65,000 - $69,999
	13	$70,000 - $74,999
	14	$75,000 - $79,999
	15	$80,000 - $84,999
	16	$85,000 - $89,999
	17	$90,000 - $94,999
	18	$95,000 - $99,999
	19	$100,000 – $104,999
	20	$105,000 – $109,999
	21	$110,000 – $114,999
	22	$115,000 – $119,999
	23	$120,000 – $124,999
	24	$125,000 – $129,999
	25	$130,000 – $134,999
	26	$135,000 +
EstimatedHousingValueCode	00	Unknown/NoData
	01	Under $50,000
	02	$50,000 - $99,999
	03	$100,000 - $124,999
	04	$125,000 - $149,999
	05	$150,000 - $174,999
	06	$175,000 - $199,999
	07	$200,000 - $249,999
	08	$250,000 - $299,999
	09	$300,000 - $349,999
	10	$350,000 - $399,999
	11	$400,000 - $449,999
	12	$450,000 - $499,999
	13	$500,000 - $599,999
	14	$600,000 - $699,999
	15	$700,000 - $799,999
	16	$800,000 - $899,999
	17	$900,000 - $999,999
	18	$1,000,000 - $1,499,999
	19	$1,500,000 - $1,999,999
	20	$2,000,000 - $2,499,999
	21	$2,500,000 +
HomeOwnershipCode	0	Unknown/No Data
	1	Probable Renter
	2	Low Probability of Home
	3	Ownership
	4	Good Probability of Home
	5	Ownership
MoveDistanceCode	0	Unknown/No Data
	1	Local Move (within the same zip code)
	2	1-25 Miles
	3	26-100 Miles
	4	101-500 Miles
	5	501-1,000 Miles
	6	1,001-2,000 Miles
	7	Over 2,001 Miles
	8	Outside the US
	9	Moved but retained old telephone number
PresenceOfChildrenCode	0	Unknown/No Data
	1	Not Likely
	2	Somewhat Likely
	3	Very Likely
	4	Strong Likelihood