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

Column Name

Code

Definition

CreditCardUsageBankCard

0

No/Unknown

Y

Yes