Data Layout#
Introduction#
Multisource dataset of over 17 million U.S. businesses and 70 million contacts providing comprehensive firmographic data on companies and organizations. This service helps you resolve business entities for standardization and record consolidation, plus it provides a wealth of fundamental characteristics about a business that can be utilized for decision making, lead scoring and optimized B2B marketing and sales efforts.
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 |
|
Firmographic |
Name |
varchar(256) |
The place’s common, recognized name |
Address |
AddressLine |
varchar(255) |
Address line |
Suite |
varchar(50) |
Suite |
|
City |
varchar(100) |
City |
|
State |
varchar(2) |
State |
|
ZIPCode |
varchar(5) |
ZIP code |
|
Plus4 |
varchar(4) |
ZIP plus 4 |
|
DeliveryPoint |
varchar(3) |
A specific location where mail is delivered to an individual or entity. It is a precise point of delivery for a particular address. |
|
AddressKey |
varchar(11) |
Address key is a combination of a location’s ZIPCode + Plus4 + DeliveryPoint |
|
ResultCodes |
varchar(200) |
Melissa result codes |
|
AddressStreetNumber |
varchar(50) |
Address street number. Ex. ‘6450’ |
|
AddressDirectionPrefix |
varchar(50) |
Address directional prefix. Ex. ‘e’ |
|
AddressStreetName |
varchar(50) |
Street name. Ex. ‘Side’ |
|
AddressStreetSuffix |
varchar(50) |
Suffix of address. Ex. ‘Dr’ |
|
AddressDirectionSuffix |
varchar(50) |
Address directional suffix. Ex. ‘Ne’ |
|
AddressSuiteName |
varchar(50) |
Suite. Ex. ‘Apt’ |
|
AddressSuiteNumber |
varchar(50) |
Suite number. Ex. ‘Q’ |
|
AddressTypeCode |
varchar(256) |
The type of address for the location. |
|
AdressType |
varchar(256) |
Address type. Ex. P.O.Box or residential address |
|
CarrierRouteCode |
varchar(4) |
The carrier route for the location address as assigned by the USPS. |
|
County |
varchar(256) |
County name, and state abbreivation |
|
FIPSCode |
varchar(5) |
The FIPSCode indicates the location of the address at both the state and county level. |
|
CMRAInd |
varchar(4) |
Indicates whether the location is a Commercial Mail Receiving Agency. |
|
AddressChangedDate |
varchar(256) |
The date when the business changed location. |
|
LandmarkAddress |
varchar(1000) |
The name of the complex, building, or mall where the place resides. |
|
MailingAddress |
MailingMelissaAddresskey |
bigint |
10-digit unique key assigned to each address. |
MailingBaseMelissaAddresskey |
bigint |
Displays the parent Melissa Address Key of an address if it is a part of or within a building. Ex. Apartment |
|
MailingAddressLine |
varchar(255) |
Address line |
|
MailingAddressSuite |
varchar(50) |
Suite |
|
MailingAddressCity |
varchar(100) |
City |
|
MailingAddressState |
varchar(2) |
State |
|
MailingAddressZIPCode |
varchar(5) |
ZIP code |
|
MailingAddressPlus4 |
varchar(4) |
Plus 4 |
|
MailingDeliveryPoint |
varchar(3) |
A specific location where mail is delivered to an individual or entity. It is a precise point of delivery for a particular address. |
|
MailingAddressKey |
varchar(11) |
Address key is a combination of a location’s ZIPCode + Plus4 + DeliveryPoint |
|
MailingResultCodes |
varchar(200) |
Melissa result codes |
|
MailingAddressStreetNumber |
varchar(50) |
Address street number. Ex. ‘6450’ |
|
MailingAddressDirectionPrefix |
varchar(50) |
Address directional prefix. Ex. ‘e’ |
|
MailingAddressStreetName |
varchar(50) |
Street name. Ex. ‘Side’ |
|
MailingAddressStreetSuffix |
varchar(50) |
Suffix of address. Ex. ‘Dr’ |
|
MailingAddressDirectionSuffix |
varchar(50) |
Address directional suffix. Ex. ‘Ne’ |
|
MailingAddressSuiteName |
varchar(50) |
Suite. Ex. ‘Apt’ |
|
MailingAddressSuiteNumber |
varchar(50) |
Suite number. Ex. ‘Q’ |
|
MailingAddressTypeCode |
varchar(256) |
Address type code |
|
MailingAddressType |
varchar(256) |
Address type. Ex. PO box or residential address |
|
MailingAddressCarrierRoute |
varchar(4) |
The carrier route for the location address as assigned by the USPS. |
|
MailingAddressFIPSCode |
varchar(5) |
The FIPSCode indicates the location of the address at both the state and county level. |
|
MailingAddressCMRAInd |
varchar(4) |
Information on whether the mailing address listed for the place is a Commercial Mail Receiving Agency. |
|
MailingScoreCode |
varchar(2) |
The deliverability score of the location address. |
|
Firmographic |
SicCodeId1 |
varchar(256) |
The primary line of business represented by a Standard Industrial Classification code. |
SicCodeIdLabels1 |
varchar(256) |
Primary Sic code Id labels |
|
SicCode2 |
varchar(500) |
The lines of business represented by Standard Industrial Classification codes. |
|
SicCodeIdLabels2 |
varchar(4000) |
Sic code Ids labels |
|
NaicsCode1 |
varchar(8) |
The primary line of business represented by a Standard Industrial Classification code. |
|
NaicsCodeIdLabels1 |
varchar(256) |
Primary Naics Code Id Labels |
|
NaicsCode2 |
varchar(1000) |
The lines of business represented by North American Industry Classification System codes |
|
NaicsCodeIdLabel2 |
varchar(4000) |
Naics code Ids labels |
|
EmployeeDemographic |
ContactFirstName |
varchar(256) |
The first name of the individual. |
ContactLastName |
varchar(256) |
The last name of the individual. |
|
Phone |
PhoneNumber |
varchar(14) |
The telephone number for the place. |
PhoneNumber1 |
varchar(14) |
The toll-free phone number for the place. |
|
PhoneNumber2 |
varchar(14) |
An additional phone number for the place. |
|
FaxNumber |
varchar(14) |
The fax number for the place. |
|
Firmographic |
CorporateEmployeeCount |
varchar(256) |
The actual, reported total number of employees at all locations in a corporate family. |
EstimatedCorporateEmployeeCount |
varchar(256) |
Estimates the total number of employees at all locations in a corporate family. |
|
LocationEmployeeCount |
varchar(256) |
The number of employees who work at this place. |
|
EstimatedLocationEmployeeCount |
varchar(256) |
Estimates the number of employees who work at this location. |
|
LocationSalesVolume |
varchar(256) |
An estimation of the place’s sales revenue. |
|
ContactEmail |
varchar(256) |
The email address of the contact. |
|
ContactEmailDeliverable |
varchar(256) |
The deliverability status of the email address. |
|
ContactEmailMarketable |
varchar(256) |
The marketable status of the email address. |
|
Geo |
Latitude |
decimal(18, 6) |
The latitude in decimal degree using the WGS84 datum for the address |
Longitude |
decimal(18, 6) |
The longitude in decimal degree 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. |
|
CensusBlock |
varchar(1) |
The census block group of the location as defined by the US Census Bureau. |
|
CensusTract |
varchar(16) |
The census tract of the location as defined by the US Census Bureau. |
|
SgcDivision |
varchar(256) |
The unique identifier for counties based on the Standard Geographical Classification (SGC). |
|
SgcDivisionLabels |
varchar(256) |
Standard Geographical Classification Labels |
|
CBSACode |
varchar(5) |
The core based statistical area where the place is located. |
|
CBSACodeLabels |
varchar(256) |
Core based statistical area labels |
|
CBSALevel |
varchar(1) |
Information on whether the CBSA is a micropolitan or metropolitan area. |
|
CBSALevelLabels |
varchar(256) |
CBSA level labels |
|
CSACode |
varchar(3) |
The combined statistical area code where the place is located. |
|
CSACodeLabels |
varchar(256) |
The combined statistical area code labels |
|
MailingGeo |
MailingLatitude |
decimal(18, 6) |
The latitude in decimal degree using the WGS84 datum for the address |
MailingLongitude |
decimal(18, 6) |
The longitude in decimal degree using the WGS84 datum for the address |
|
MailingCensusKey |
varchar(16) |
Census key is a 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. |
|
EmployeeDemographic |
ContactId |
varchar(256) |
The unique ID for the contact. |
ContactGender |
varchar(256) |
The gender of the individual. |
|
ContactGenderLabels |
varchar(256) |
Contact gender labels |
|
ContactJobFunctionId |
varchar(256) |
Describes the type of work an employee performs in their organization. |
|
ContactJobFunctionIdLabels |
varchar(256) |
Contact job function Id labels |
|
ContactJobTitles |
varchar(500) |
Descriptive label of the individual’s job |
|
ContactJobTitlesCount |
varchar(256) |
The total number of Job titles associated with the contact. |
|
ContactManagementLevel |
varchar(256) |
Describes the contact’s position relative to others in their organization. |
|
ContactManagementLevelLabels |
varchar(256) |
Primary contact management level labels |
|
ContactProfessionalTitle |
varchar(256) |
The professional degree or title of the individual. |
|
ContactProfessionalTitleLabels |
varchar(256) |
Primary contact professional title labels |
|
ContactIndicator |
varchar(256) |
Information on whether the individual is the primary contact for the location. |
|
ContactSuppressedFields |
varchar(256) |
The fields on the individual that are suppressed. |
|
ContactTitleCodes |
varchar(256) |
A list of the individual’s job titles. |
|
ContactTitleCodesLabels |
varchar(256) |
Primary contact title codes labels |
|
Website |
Website |
varchar(MAX) |
The primary homepage URL of the business. |
FacebookURL |
varchar(MAX) |
The link to the place on Facebook. |
|
TwitterUrl |
varchar(500) |
The link to the place on Twitter. |
|
LinkedInURL |
varchar(1000) |
The link to the place on LinkedIn. |
|
YelpUrl |
varchar(500) |
The link to the place on Yelp. |
|
PinterestUrl |
varchar(500) |
The link to the place on Pinterest. |
|
YoutubeUrl |
varchar(500) |
The link to the place’s YouTube channel or company video. |
|
TumblrUrl |
varchar(500) |
The link to the place on Tumblr. |
|
FoursquareUrl |
varchar(500) |
The link to the place on Foursquare. |
|
InstagramUrl |
varchar(500) |
The link to the place on Instagram. |
|
LogoUrl |
varchar(1000) |
The link to the place’s logo image. |
|
Firmographic |
WebsiteKeywords |
varchar(MAX) |
Keywords from company website HTML. |
LocationProfessionalSizeCode |
varchar(256) |
The number of professionals practicing at the place. |
|
LocationProfessionalSize |
varchar(256) |
Location professional size code labels |
|
PlaceType |
varchar(256) |
The type of place within a corporation. |
|
PlaceTypeLables |
varchar(256) |
Place type labels |
|
AlternativeName |
varchar(2000) |
An additional business name or DBA for the place. |
|
HistoricalNames |
varchar(2000) |
Previously used names for the business. |
|
LegalNames |
varchar(2000) |
The legal names of the place. |
|
InfogroupID |
varchar(9) |
The unique identifier for a Place. |
|
WorkAtHome |
varchar(256) |
The place is a work at home business. |
|
InBusiness |
varchar(256) |
The operational status of the business. |
|
InBusinessIndicator |
varchar(256) |
In business labels |
|
VerifiedOn |
varchar(256) |
The date the business was most recently verified. |
|
DuplicateOf |
varchar(256) |
The ID of the valid record that this place is a duplicate of. |
|
Suppressed |
varchar(256) |
The place is suppressed from customer feeds. |
|
SuppressedFields |
varchar(1000) |
The list of fields that are suppressed from display. |
|
CreatedAt |
varchar(256) |
The date and time when the place record was created. |
|
UpdatedAt |
varchar(256) |
The date and time when the place was last updated. |
|
OpenedForBusinessOn |
varchar(256) |
The date when the place opened for business. |
|
EstimatedOpenedForBusinessLower |
varchar(256) |
Estimated opened for business lower |
|
EstimatedOpenedForBusinessUpper |
varchar(256) |
Estimated opened for business upper |
|
LocationParentId |
varchar(9) |
The primary business at a location with multiple places. |
|
LocationParentRelationship |
varchar(256) |
Pinpointed latitude and longitude for the physical building. |
|
LocationParentRelationshipLabels |
varchar(256) |
Location parent relationship labels |
|
NumberOfTenants |
varchar(256) |
The number of places at a multi-tenant location. |
|
BusinessType |
varchar(1000) |
The specific types of business within a particular industry. |
|
BusinessTypeIdsLabels |
varchar(500) |
Business type Ids labels |
|
ContactsCount |
varchar(256) |
Contacts count |
|
OwnershipChangedOn |
varchar(256) |
The date when ownership of the place changed. |
|
HeadquartersId |
varchar(256) |
The direct headquarters of this place in its corporate family. |
|
AncestorHeadquartersIds |
varchar(256) |
The full list of all ancestors in the corporate family. |
|
AncestorHeadquartersIdsCount |
varchar(256) |
The total number of Ancestor Headquarters associated with the place. |
|
UltimateHeadquartersId |
varchar(256) |
The top-level headquarters of a corporate family. |
|
ChainId |
varchar(256) |
The corporate chain for branch locations. |
|
ChainIdLabels |
varchar(256) |
Chain Id labels |
|
CorporateFranchising |
varchar(256) |
Determine if the corporation includes franchised branches. |
|
CorporateSalesRevenue |
varchar(256) |
The actual, reported sales revenue for the corporate family. |
|
EstimatedCorporateSalesRevenue |
varchar(256) |
Estimates total sales revenue for the corporate family. |
|
BranchCount |
varchar(256) |
The number of branches reporting to a headquarter record. |
|
ForeignParentInd |
varchar(256) |
The place is owned by a corporation outside the US or Canada. |
|
FortuneRanking |
varchar(256) |
The place’s ranking on the Fortune Magazine Top 1000 list. |
|
StockExchangeCode |
varchar(256) |
The Stock Exchange where the corporation conducts trading activity. |
|
StockExchangeCodeLabels |
varchar(256) |
Stock exchange code labels |
|
CtockTickerSymbol |
varchar(256) |
The abbreviation used to identify the company on a stock market. |
|
TheCentralIndexKey |
varchar(256) |
The Central Index Key (CIK) assigned to the corporation for filing with the SEC. |
|
AffiliationIds |
varchar(256) |
A list of organizations the place is affiliated with. |
|
AffiliationIdsLabels |
varchar(256) |
Affiliation Ids Labels |
|
BrandIds |
varchar(500) |
A list of brands sold by the business. |
|
BrandIdsLabels |
varchar(256) |
Brand Ids labels |
|
CompanyDescription |
varchar(MAX) |
The description of the business. |
|
DressCode |
varchar(2000) |
Details about the place’s dress code. |
|
EquipmentRentals |
varchar(256) |
Information on whether equipment rentals are available. |
|
HasEcommerce |
varchar(256) |
The presence of a shopping cart on the business’s website. |
|
LanguagesSpoken |
varchar(256) |
The languages spoken at the place. |
|
LanguagesSpokenLabels |
varchar(256) |
Languages spoken labels |
|
PriceRange |
varchar(500) |
The price range for products and services sold at the place. |
|
ProfessionalSpecialtyIds |
varchar(1000) |
The specialty within professional lines of business. |
|
ProfessionalSpecialty |
varchar(500) |
Professional specialty Ids labels |
|
PublicAccess |
varchar(256) |
Indicates whether the place is publicly accessible. |
|
ShoppingCenterAtm |
varchar(256) |
The location has an ATM. |
|
OperatingHoursCount |
varchar(256) |
The number of operating hours at the place. |
|
PaymentTypes |
varchar(256) |
The types of payments accepted at the location. |
|
PaymentSubLabels |
varchar(256) |
Payment sub labels |
|
InsurancesAccepted |
varchar(500) |
The types of insurances accepted by the business. |
|
MedicareAccepted |
varchar(256) |
Information on whether the place accepts Medicare. |
|
MedicaidAccepted |
varchar(256) |
Information on whether the place accepts Medicaid. |
|
ServiceAreaPostalCodes |
varchar(256) |
The list of postal codes making up the service area of the place. |
|
NbrcCorporationFilingType |
varchar(256) |
The type of business registration filing. |
|
NbrcCorporateDate |
varchar(256) |
Date when place registered as a business. |
|
CarMakeIds |
varchar(1000) |
The make of car that a car dealer sells. |
|
CarMakeIdsLabels |
varchar(256) |
Car Make Ids labels |
|
ReligiousDenominationIds |
varchar(256) |
The religious denomination of the church or other house of worship. |
|
ReligiousDenominationIdsLabels |
varchar(256) |
Religious denomination ids labels |
|
RestaurantCuisines |
varchar(500) |
The type of cuisine served at the place. |
|
RestaurantCuisinesLabels |
varchar(500) |
Restaurant cuisines labels |
|
RestaurantLimitedService |
varchar(256) |
Indicates the restaurant service offering of the place. |
|
RestaurantReservations |
varchar(256) |
The restaurant has reservations. |
|
RestaurantTakeout |
varchar(256) |
The restaurant has takeout. |
|
HappyHoursCount |
varchar(256) |
The number of Happy Hour records on the place. |
|
HotelCableTV |
varchar(256) |
The hotel has Cable TV. |
|
HotelContinentalBreakfast |
varchar(256) |
The hotel offers continental breakfast. |
|
HotelElevator |
varchar(256) |
The hotel has an elevator. |
|
HotelExerciseFacility |
varchar(256) |
The hotel has an exercise facility. |
|
HotelGuestLaundry |
varchar(256) |
The hotel has guest laundry services. |
|
HotelHotTub |
varchar(256) |
The hotel has a hot tub. |
|
HotelIndoorPool |
varchar(256) |
The hotel has an indoor pool. |
|
HotelKitchens |
varchar(256) |
The hotel has guest kitchens. |
|
HotelOutdoorPool |
varchar(256) |
The hotel has an outdoor pool. |
|
HotelPetFriendly |
varchar(256) |
The hotel allows pets. |
|
HotelRoomService |
varchar(256) |
The hotel offers room service. |
|
HospitalHasEmergencyRoom |
varchar(256) |
The hospital has an emergency room. |
|
EstimatedFleetSizeLower |
varchar(256) |
Estimates the number of vehicles owned or used by the location. |
|
EstimatedFleetSizeUpper |
varchar(256) |
Estimated fleet size upper |
|
GrowingBusinessGode |
varchar(256) |
Information on whether the business is growing or shrinking a significant percentage. |
|
GrowingBusinessGodeLabels |
varchar(256) |
Growing business code labels |
|
SquareFootage |
varchar(256) |
An estimate of the space the place occupies. |
|
SquareFootageLabels |
varchar(256) |
Square footage labels |
|
WhiteCollarPercentage |
varchar(256) |
An estimation of white collar workers at the place. |
|
PopulationDensity |
varchar(256) |
The actual population density of the city. |
|
PopulationCodeForZIP |
varchar(256) |
The population size of the city by ZIP code. |
|
PopulationCodeForZIPLabels |
varchar(256) |
Population code for ZIP labels |
|
WealthyAreaInd |
varchar(256) |
An estimation on whether the place is located in a wealthy area. |
|
PhysicianDemographic |
PhysicianYearOfGraduation |
varchar(256) |
The year the physician graduated from medical school. |
MedicalSchoolCode |
varchar(256) |
The medical school the physician attended. |
|
sMedicalSchoolCodeLabels |
varchar(256) |
sami medical School code labels |
|
HospitalNumber |
varchar(256) |
The hospital the physician is associated with. |
|
HospitalNumberLabels |
varchar(256) |
Ami hospital number labels |
|
Upin |
varchar(256) |
The physician’s unique physician identification number (UPIN). |
|
LicenseNumber |
varchar(256) |
The physician’s medical license number. |
|
StateOfLicense |
varchar(256) |
The state where the physician’s medical license was issued. |
|
StateOfLicenseLabels |
varchar(256) |
Ami state of license labels |
|
PhysicianYearOfBirth |
varchar(256) |
The physician’s year of birth. |
|
ResidencyHospitalCode |
varchar(256) |
The hospital where the physician completed their residency. |
|
ResidencyHospitalCodeLabels |
varchar(256) |
Ami residency hospital code labels |
|
ResidencyGraduationYear |
varchar(256) |
The year the physician graduated from their residency program. |
|
NationalProviderInd |
varchar(256) |
Ami national provider indicator |
|
MedicalDeaNumber |
varchar(256) |
The physician’s DEA number. |
|
AcceptingNewPatientsIndicator |
varchar(256) |
The medical professional or office is accepting new patients. |
|
PhysicianPrimarySpecialtyCode |
varchar(256) |
The physician’s primary medical specialty. |
|
PhysicianPrimarySpecialty |
varchar(256) |
Physician primary specialty code labels |
|
PhysicianSecondarySpecialtyCode |
varchar(256) |
The physician’s secondary medical specialty. |
|
PhysicianSecondarySpecialty |
varchar(256) |
Physician secondary specialty code labels |
|
BoardCertifiedInd |
varchar(256) |
Information on whether the physician is board certified. |