Type Contact
Type category Entity
Description The Contacts table contains data for MMD contacts.
Timeseries key id, updateDateavailable from 2012-05-23
Fields
Name Type Filters Description
key id string(500)* = Unique identifier of the contact associated with a company. This is a concatenation of MMD contact id and company id, seperated by dash.
timeline updateDate dateTime* =< >= Contact record last updated on
address1 string(80) This is the contact's mailing address line 1.
address2 string(50) This is the contact's mailing address line 2.
link batch Batch = The batch that provided the data
link batchRun BatchRun = The batchRun that provided the data
biography string(10000) Biography of the contact
brokerName string(120) Broker Dealer firm name associated with contact. This field is only applicable to the InvestmentManager dataset.
city string(50) City - Text field for city location
link company Company MMD Company id, foreign key that links to the Company entity.
companyName string(120) Contact's company name
consultantSpecialty string(200)[100] Specialty of the consultant contact and only applies to the Consultant dataset.
contactId long MMD Contact Id.
country string(50) Country
countryCode string(2) Abbreviated Name of Country.
datasetName string(50) Name of the dataset for the entity.
email string(120) Email
firstName string(30) Contact's first name
isBank boolean Indicates if the contact is in charge of business development for a Bank (applies to job code 76). This field is only applicalbe to Investment Manager contacts.
isBroker boolean Indicates if the contact is in charge of business development for a Broker Dealer (applies to job code 76). This field is only applicable to the Investment Manager contacts.
isInsurer boolean Indicates if the contact is in charge of business development for an Insurance Company (applies to job code 76). This field is only applicable to the Investment Manager contacts.
isMutualFund boolean Indicates if the contact is in charge of business development for a Mutual Fund Company (applies to job code 76). This field is only applicable to the Investment Manager contacts.
isOther boolean Indicates if the contact is in charge of business development for "other" firm types (applies to job code 76).
isRegisteredInvestmentAdvisor boolean Indicates if the contact is in charge of business development for an Investment Advisor (applies to job code 76). This field is only applicable to the Investment Manager contacts.
isRegisteredRep boolean Indicates if the contact is a registered rep of a Broker/Dealer. This field is only applicalbe to Investment Manager contacts.
jobTitle string(140) Contact's job title
keyPersonId long This is the unique ID for the contact in CIQ Pro.
lastName string(30) Contact's last name
linkedIn string(300) LinkedIn url
middleName string(30) Contact's middle name
mktSpec1 string(4) If a client contact-marketing officer (applies to job code 30), their marketing focus1. This field is only applicable to the Investment Manager contacts.
mktSpec2 string(4) If a client contact-marketing officer (applies to job code 30), their marketing focus1. This field is only applicable to the Investment Manager contacts.
mktSpec3 string(4) If a client contact-marketing officer (applies to job code 30), their marketing focus1. This field is only applicable to the Investment Manager contacts.
mktSpec4 string(4) If a client contact-marketing officer (applies to job code 30), their marketing focus1. This field is only applicable to the Investment Manager contacts.
mktSpec5 string(4) If a client contact-marketing officer (applies to job code 30), their marketing focus1. This field is only applicable to the Investment Manager contacts.
otherDescription string(60) Other Firm type Description. This field is only applicable to the Investment Managers dataset.
personTitle string(10) Contact title
phone string(80) Telephone Number for contact
sex string(1) Contact's sex
specialties string(50)[100] Portfolio Manager/Research Analyst Specialty Codes. Applies only to InvestmentManager dataset.
stateProvince string(70) State or Province - Official Post Office abbreviation for state where the organization is located.
suffix string(15) Contact's suffix
yearHired string(4) Year hired
yearsConsult long Years contact has been in consulting business. This field only applies to the Consultant dataset.
zip string(12) Zip Code - Zip or mailing code
45 rows of 45 total
API Open API Specification