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, or “doing business as” 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. |
|
CarrierRoute |
varchar(4) |
The carrier route for the location address as assigned by the USPS. |
|
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 |
|
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. |
|
Firmographic |
PrimarySICCodeId |
varchar(256) |
The primary line of business represented by a Standard Industrial Classification code. |
SecondarySicCodeIds |
varchar(500) |
The lines of business represented by Standard Industrial Classification codes. |
|
NAICSCode1 |
varchar(8) |
The primary line of business represented by a Standard Industrial Classification code. |
|
NAICSCode2 |
varchar(1000) |
The lines of business represented by North American Industry Classification System codes |
|
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. |
TollFreeNumber |
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. |
|
ContactEmailDeliverableInd |
varchar(256) |
The deliverability status of the email address. |
|
ContactEmailMarketableInd |
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). |
|
CBSACode |
varchar(5) |
The core based statistical area where the place is located. |
|
CBSALevel |
varchar(1) |
Information on whether the CBSA is a micropolitan or metropolitan area. |
|
CSACode |
varchar(3) |
The combined statistical area code where the place is located. |
|
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 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. |
|
EmployeeDemographic |
ContactId |
varchar(256) |
The unique ID for the contact. |
ContactGender |
varchar(256) |
The gender of the individual. |
|
ContactJobFunctionId |
varchar(256) |
Describes the type of work an employee performs in their organization. |
|
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. |
|
ContactProfessionalTitle |
varchar(256) |
The professional degree or title of the individual. |
|
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. |
|
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. |
|
PlaceType |
varchar(256) |
The type of place within a corporation. |
|
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. |
|
BusinessID |
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. |
|
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) |
The relationship to the primary business at a location |
|
NumberOfTenants |
varchar(256) |
The number of places at a multi-tenant location. |
|
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. |
|
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. |
|
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. |
|
AffiliationIdsLabels |
varchar(256) |
Affiliation Ids Labels |
|
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. |
|
PriceRange |
varchar(500) |
The price range for products and services sold at the place. |
|
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. |
|
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. |
|
CarMakeIdsLabels |
varchar(256) |
Car Make Ids labels |
|
ReligiousDenominationIdsLabels |
varchar(256) |
Religious denomination ids labels |
|
RestaurantCuisines |
varchar(500) |
The type of cuisine served at the place. |
|
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. |
|
SquareFootage |
varchar(256) |
An estimate of the space the place occupies. |
|
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. |
|
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. |
|
HospitalNumber |
varchar(256) |
The hospital the physician is associated with. |
|
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. |
|
PhysicianYearOfBirth |
varchar(256) |
The physician’s year of birth. |
|
ResidencyHospitalCode |
varchar(256) |
The hospital where the physician completed their residency. |
|
ResidencyGraduationYear |
varchar(256) |
The year the physician graduated from their residency program. |
|
NationalProviderID |
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. |
|
PhysicianSecondarySpecialtyCode |
varchar(256) |
The physician’s secondary medical specialty. |
|
BoardCertifiedInd |
varchar(256) |
Information on whether the physician is board certified. |
Code and Definitions#
Column Name |
Code |
Definition |
|---|---|---|
AddressTypeCode |
Not Available |
|
S |
Street |
|
H |
High Rise |
|
F |
Firm |
|
R |
Rural Route |
|
U |
<Unknown> (U) |
|
P |
Post Office Box |
|
N |
Unknown |
|
G |
General Delivery |
|
M |
Military |
|
MailingAddressTypeCode |
Not Available |
|
P |
Post Office Box |
|
S |
Street |
|
H |
High Rise |
|
R |
Rural Route |
|
F |
Firm |
|
G |
General Delivery |
|
N |
Unknown |
|
U |
<Unknown> (U) |
|
M |
Military |
|
CBSALevel |
2 |
Metropolitan |
1 |
Micropolitan |
|
3 |
Consolidated CMA/CA (Non-Tracted CA) |
|
4 |
Strongly Influenced (Zone) |
|
5 |
Moderately Influenced (Zone) |
|
6 |
Weakly Influenced (Zone) |
|
7 |
Not Influenced (Zone) |
|
8 |
Territories |
|
ContactGender |
M |
Male |
F |
Female |
|
ContactJobFunctionId |
270 |
Leadership > Ownership & Partnerships |
300 |
Operations > Services > Business |
|
268 |
Leadership > Executive |
|
301 |
Operations > Services > Personal |
|
291 |
Operations > Administration |
|
302 |
Operations > Services > Public |
|
315 |
Sales |
|
267 |
Leadership > Board of Directors |
|
250 |
Finance |
|
287 |
Marketing > Promotion |
|
243 |
Product > Engineering > Information Technology |
|
297 |
Operations > Manufacturing |
|
259 |
Human Resources |
|
290 |
Operations |
|
309 |
Product > Engineering > Software |
|
257 |
Finance > Financial Planning > Treasury |
|
251 |
Finance > Accounting |
|
271 |
Legal |
|
311 |
Product > Research & Development > Business Development |
|
294 |
Operations > Facilities |
|
239 |
Audit > Internal Control |
|
306 |
Product > Design > Creative |
|
316 |
Sales > Account |
|
272 |
Legal > General Counsel |
|
265 |
Human Resources > Training & Development |
|
317 |
Sales > Customer Service |
|
279 |
Legal > Legal Administration Support |
|
285 |
Marketing > Communications > Publishing |
|
310 |
Product > Research & Development |
|
298 |
Operations > Purchasing & Procurement |
|
252 |
Finance > Accounting > Accounts Payable & Receivable |
|
242 |
Product > Engineering |
|
296 |
Operations > Hospitality |
|
292 |
Operations > Distribution & Fulfillment |
|
244 |
Audit > Internal Control > Inventory |
|
248 |
Audit > Risk > Claims |
|
282 |
Marketing > Communications |
|
261 |
Human Resources > Benefits |
|
249 |
Audit > Risk > Loss Prevention & Disaster Recovery |
|
245 |
Audit > Internal Control > Quality Assurance |
|
256 |
Finance > Financial Planning > Budget & Funding |
|
304 |
Product > Design > Art |
|
289 |
Marketing > Promotion > Digital Marketing |
|
314 |
Product > Research & Development > Science |
|
293 |
Operations > Exhibition |
|
240 |
Audit > Internal Control > Compliance |
|
283 |
Marketing > Communications > Broadcast |
|
276 |
Legal > Governance > Internal Review Board |
|
264 |
Human Resources > Recruitment |
|
284 |
Marketing > Communications > Public Relations |
|
255 |
Finance > Financial Planning |
|
312 |
Product > Research & Development > Data |
|
253 |
Finance > Accounting > Bookkeeping |
|
262 |
Human Resources > Employment |
|
305 |
Product > Design > Audio Visual |
|
258 |
Finance > Financial Planning > Valuation |
|
277 |
Legal > Governance > Policy & Regulatory Affairs |
|
286 |
Marketing > Communications > Telecommunications |
|
254 |
Finance > Accounting > Tax |
|
307 |
Product > Design > Photography |
|
288 |
Marketing > Promotion > Advertising |
|
238 |
Audit |
|
246 |
Audit > Risk |
|
278 |
Legal > Intellectual Property |
|
275 |
Legal > Governance |
|
263 |
Human Resources > Payroll |
|
269 |
Leadership > Investor Relations |
|
247 |
Audit > Risk > Actuarial & Underwriting |
|
313 |
Product > Research & Development > Land |
|
260 |
Human Resources > Advocacy & Diversity |
|
308 |
Product > Engineering > Hardware |
|
274 |
Legal > General Counsel > Litigation |
|
280 |
Legal > Mergers & Acquisitions |
|
273 |
Legal > General Counsel > Arbitration |
|
266 |
Leadership |
|
303 |
Product > Design |
|
281 |
Marketing |
|
299 |
Operations > Services |
|
241 |
Product |
|
ContactManagementLevel |
owner |
Owner |
manager |
Manager |
|
executive |
Executive |
|
individual_contributor |
Individual Contributor |
|
chief_officer |
Chief Officer |
|
board_of_directors |
Board of Directors |
|
ContactTitleCodes |
1 |
Owner |
3 |
Manager |
|
2 |
President |
|
( |
Director |
|
] |
Other |
|
C |
Chief Executive Officer |
|
K |
Vice President |
|
8 |
Religious Leader |
|
_ |
Site Manager |
|
W |
Executive Officer |
|
4 |
Executive Director |
|
[ |
Operations |
|
7 |
Administrator |
|
5 |
Principal |
|
> |
General Manager |
|
? |
Office Manager |
|
9 |
Partner |
|
- |
Sales |
|
D |
Board Member |
|
{ |
Regional Manager |
|
J |
Senior Vice President |
|
O |
Finance Executive |
|
T |
Sales Executive |
|
# |
Finance |
|
Marketing |
||
I |
Executive Vice President |
|
! |
Information Technology |
|
6 |
Publisher/Editor |
|
G |
Treasurer |
|
V |
Legal |
|
= |
Engineering/Technical |
|
: |
Educator |
|
A |
Chairman |
|
F |
Chief Financial Officer |
|
) |
Executive |
|
P |
Human Resources Executive |
|
X |
Manufacturing Executive |
|
^ |
Human Resources |
|
S |
Operations Executive |
|
E |
Chief Operating Officer |
|
H |
Controller |
|
@ |
Chief Information Officer/Chief Technology Officer |
|
L |
Administration Executive |
|
R |
Marketing Executive |
|
Y |
Purchasing Executive |
|
N |
It Executive |
|
% |
Chief Marketing Officer |
|
& |
Business Development |
|
+ |
Facilities |
|
$ |
Chief Administrative Officer |
|
Q |
Telecommunications Executive |
|
. |
International |
|
M |
Corporate Communications Executive |
|
/ |
Manufacturing |
|
LocationProfessionalSizeCode |
A |
1 Professional |
F |
10+ Professional |
|
B |
2 Professional |
|
E |
5 9 Professional |
|
C |
3 Professional |
|
D |
4 Professional |
|
PlaceType |
independent |
Independent |
individual |
Individual |
|
branch |
Branch |
|
kiosk |
Kiosk |
|
headquarters |
Headquarters |
|
InBusiness |
yes |
Yes |
junk |
Junk |
|
maybe |
Maybe |
|
no |
No |
|
LocationParentRelationship |
primary |
Primary Business |
professional_individual |
Professional Individual |
|
affiliated |
Affiliated Business |
|
kiosk |
Kiosk |
|
separate |
Separate Business |
|
department |
Department |
|
StockExchangeCode |
3 |
NASDAQ |
9 |
Other (US) |
|
1 |
NYSE |
|
2 |
NYSE Market |
|
4 |
TSX |
|
6 |
TSX Venture |
|
8 |
Other (Canada) |
|
PaymentTypes |
isa |
Visa |
MasterCard |
Mastercard |
|
Discover |
Discover |
|
American Express |
American Express |
|
Cash |
Cash |
|
Check |
Check |
|
ATM/Debit |
Atm/Debit |
|
PayPal |
PayPal |
|
Other Card |
Other card |
|
Store Card |
Store card |
|
Apple Pay |
Apple Pay |
|
Diners Club |
Diners Club |
|
Invoicing |
Invoicing |
|
Financing |
Financing |
|
Google Checkout |
Google Checkout |
|
Traveler’s Check |
Traveler’s Check |
|
Samsung Pay |
Samsung Pay |
|
Android Pay |
Android Pay |
|
RestaurantCuisines |
american |
American (Traditional) |
pizza |
Pizza |
|
burgers |
Burgers |
|
deli |
Deli |
|
mexican |
Mexican |
|
chinese |
Chinese |
|
italian |
Italian |
|
seafood |
Seafood |
|
sandwiches |
Sandwiches |
|
new_american |
American (New) |
|
chicken |
Chicken |
|
bbq |
Barbeque |
|
breakfast_brunch |
Breakfast/Brunch |
|
steak |
Steakhouse |
|
asian |
Asian |
|
bakery |
Bakery |
|
japanese |
Japanese |
|
diner |
Diner |
|
vegetarian |
Vegetarian |
|
sushi |
Sushi |
|
thai |
Thai |
|
mediterranean |
Mediterranean |
|
asian_fusion |
Asian Fusion |
|
tex_mex |
Tex-Mex |
|
vegan |
Vegan |
|
southern |
Southern |
|
greek |
Greek |
|
hot_dogs |
Hot Dogs |
|
indian |
Indian |
|
buffet |
Buffet |
|
vietnamese |
Vietnamese |
|
french |
French |
|
latin |
Latin American |
|
salad |
Salad |
|
cajun_creole |
Cajun/Creole |
|
middle_eastern |
Middle Eastern |
|
brew_pub |
Brew Pub |
|
soul_food |
Soul Food |
|
korean |
Korean |
|
caribbean |
Caribbean |
|
southwestern |
Southwestern |
|
german |
German |
|
hawaiian |
Hawaiian |
|
irish |
Irish |
|
wings |
Wings |
|
organic |
Organic |
|
spanish |
Spanish |
|
cantonese |
Cantonese |
|
gastropub |
Gastropub |
|
soup |
Soup |
|
cuban |
Cuban |
|
gluten_free |
Gluten-Free |
|
english |
English |
|
international |
International |
|
brazilian |
Brazilian |
|
tapas |
<Unknown> (tapas) |
|
pho |
Pho |
|
continental |
Continental |
|
moroccan |
Moroccan |
|
peruvian |
Peruvian |
|
crepes |
Crepes |
|
turkish |
Turkish |
|
jamaican |
Jamaican |
|
ramen |
Ramen |
|
african |
African |
|
kosher |
Kosher |
|
lebanese |
Lebanese |
|
halal |
Halal |
|
taiwanese |
Taiwanese |
|
filipino |
Filipino |
|
dim_sum |
Dim Sum |
|
fish_chips |
Fish & Chips |
|
european |
Modern European |
|
pakistani |
Pakistani |
|
russian |
Russian |
|
ethiopian |
Ethiopian |
|
himalayan |
Himalayan |
|
teriyaki |
Teriyaki |
|
portuguese |
Portuguese |
|
afghani |
Afghani |
|
polish |
Polish |
|
persian |
Persian |
|
raw_food |
Raw Bar |
|
fondue |
Fondue |
|
singaporean |
Singaporean |
|
Desserts |
Desserts |
|
mongolian |
Mongolian |
|
argentine |
Argentine |
|
polynesian |
Polynesian |
|
nepalese |
Nepalese |
|
swiss |
Swiss |
|
malaysian |
Malaysian |
|
basque |
Basque |
|
belgian |
Belgian |
|
burmese |
Burmese |
|
cambodian |
Cambodian |
|
hungarian |
Hungarian |
|
indonesian |
Indonesian |
|
canadian |
Canadian |
|
scandinavian |
Scandinavian |
|
tapas_small plates |
<Unknown> (tapas_small plates) |
|
australian |
Australian |
|
czech |
Czechoslovakian |
|
jewish |
jewish |
|
tapas_small_plates |
Tapas/Small Plates |
|
GrowingBusinessGode |
C |
Constant |
I |
Individuals |
|
+ |
Growing |
|
- |
Shrinking |
|
G |
Slightly Growing |
|
S |
Slightly Shrinking |
|
SquareFootage |
2 |
1,500 - 2,499 |
1 |
1 - 1,499 |
|
3 |
2,500 - 4,999 |
|
4 |
5,000 - 9,999 |
|
5 |
10,000 - 19,999 |
|
6 |
20,000 - 39,999 |
|
7 |
40,000 - 99,999 |
|
8 |
100,000+ |
|
PopulationCodeForZIP |
7 |
20,000 - 49,999 |
6 |
10,000 - 19,999 |
|
8 |
50,000+ |
|
5 |
5,000 - 9,999 |
|
4 |
2,500 - 4,999 |
|
3 |
1,000 - 2,499 |
|
1 |
0 - 249 |
|
2 |
250 - 999 |
|
CMRAInd |
Not Available |
|
True |
True |
|
MailingAddressCMRAInd |
Not Available |
|
True |
True |
|
ContactEmailDeliverableInd |
Not Available |
|
FALSE |
FALSE |
|
True |
True |
|
ContactEmailMarketableInd |
Not Available |
|
FALSE |
FALSE |
|
True |
True |
|
WorkAtHome |
Not Available |
|
True |
True |
|
CorporateFranchising |
Not Available |
|
True |
True |
|
ForeignParentFlag |
Not Available |
|
FALSE |
FALSE |
|
True |
True |
|
EquipmentRentals |
Not Available |
|
FALSE |
FALSE |
|
True |
True |
|
PublicAccess |
Not Available |
|
FALSE |
FALSE |
|
True |
True |
|
ShoppingCenterAtm |
Not Available |
|
FALSE |
FALSE |
|
True |
True |
|
RestaurantLimitedService |
Not Available |
|
False |
False |
|
True |
True |
|
RestaurantReservations |
Not Available |
|
False |
False |
|
True |
True |
|
RestaurantTakeout |
Not Available |
|
False |
False |
|
True |
True |
|
HappyHoursCount |
Not Available |
|
False |
False |
|
True |
True |
|
HotelExerciseFacility |
Not Available |
|
False |
False |
|
True |
True |
|
HotelGuestLaundry |
Not Available |
|
False |
False |
|
True |
True |
|
HotelHotTub |
Not Available |
|
False |
False |
|
True |
True |
|
HotelIndoorPool |
Not Available |
|
False |
False |
|
True |
True |
|
HotelKitchens |
Not Available |
|
False |
False |
|
True |
True |
|
HotelOutdoorPool |
Not Available |
|
False |
False |
|
True |
True |
|
HotelPetFriendly |
Not Available |
|
False |
False |
|
True |
True |
|
HotelRoomService |
Not Available |
|
False |
False |
|
True |
True |
|
HospitalHasEmergencyRoom |
Not Available |
|
False |
False |
|
True |
True |
|
AcceptingNewPatientsIndicator |
Not Available |
|
False |
False |
|
True |
True |
|
BoardCertifiedInd |
Not Available |
|
False |
False |
|
True |
True |
|
MedicaidAccepted |
Not Available |
|
False |
False |
|
True |
True |