Data Dictionary
All personal/company information mentioned within this context is entirely fictional and is solely intended for illustrative purposes.
Find all data points with explanations available in the Multi-source company data. Each category includes a table listing the available data points, their explanations, and data types.
The data points in the example snippets have been rearranged for better grouping. To see where a specific data point stands, check the full data sample here.
Data point | Description | Data type |
---|---|---|
company_id | Company record identification key in our database | Integer |
source_id | Identifier assigned by Professional Network | String |
expired_domain | Indicates if the domain is expired | Boolean/integer |
unique_domain | Indicates if the domain is unique | Boolean/integer |
unique_website | Indicates if the website is unique | Boolean/integer |
last_updated_at | Last update date of the record in the YYYY-MM-DD format | String (date) |
created_at | Record creation date in the YYYY-MM-DD format | String (date) |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
company_name | Company name | String |
company_name_alias | All name variations associated with the company | String |
company_legal_name | Legal company name | String |
company_logo | Base64-encoded image data of the company's logo | String |
is_b2b | Indicates if the company operates in a business-to-business model: 1 - b2b company 0 - b2c company | Boolean/Integer |
industry | Company's industry | String |
type | Company type | String |
founded_year | Founding year | String (date) |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
sic_codes | Company's SIC codes | Array of strings |
naics_codes | Company's NAICS codes | Array of strings |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
description | Company description | String |
description_enriched | Company description, enriched with LLM | String |
description_metadata_raw | Company description (parsed from external sources not included in our firmographic data) | String |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
size_range | Company size based on employee count range (as selected by the company profile administrator) | String |
employees_count | Number of employees on Professional Network who associated their experience with the company | Integer |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
categories_and_keywords | Categories and keywords assigned to the company profile and products across various platforms | Array of strings |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
status | Operational and ownership status | Array of objects (struct) |
value | Current operational status | String |
comment | Current ownership status | String |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
ownership_status | Ownership status | String |
parent_company_information | Parent company details | Object (struct) |
parent_company_name | Parent company name | String |
parent_company_website | Parent company website | String |
date | Date of the information provided in MM/YYYY format | String (date) |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
company_updates_collection | Information from posts published by the company | Array of objects |
followers | Profile follower count | Integer |
date | Publish date | String |
description | Published text Note: may contain control characters | String |
reactions_count | Number of reactions on the post | Integer |
comments_count | Number of comments on the post | Integer |
reshared_post_author | Reshared post author | String |
reshared_post_author_url | Profile URL of the reshared post author | String |
reshared_post_author_headline | Headline of the reshared post author | String |
reshared_post_description | Reshared post text | String |
reshared_post_followers | The number of followers of the reshared post author | Integer |
reshared_post_date | Date the reshared post was published | String |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
hq_region | Region of the company's HQ location | Array of strings |
hq_country | Country where the company's headquarters is located | String |
hq_country_iso2 | ISO 2-letter code of the headquarters country | String |
hq_country_iso3 | ISO 3-letter code of the headquarters country | String |
hq_location | Headquarters location | String |
hq_full_address | Full address of the headquarters | String |
hq_city | Headquarters city | String |
hq_state | Headquarters state | String |
hq_street | Headquarters street address | String |
hq_zipcode | Headquarters zip code | String |
company_locations_full | List of company locations | Array of objects (structs) |
location_address | Company location address | String |
is_primary | Indicates if this is the primary company location | Boolean |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
company_phone_numbers | Public phone numbers | Array of strings |
company_emails | Public email addresses | Array of strings |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
followers_count_professional_network | Profile follower count on professional network | Integer |
followers_count_twitter | Profile follower count on Twitter | Integer (long) |
followers_count_owler | Profile follower count on Owler | Integer (long) |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
professional_network_followers_count_change | Changes in the number of followers over different periods on professional network | Object (struct) |
current | Current number of followers on the professional network | Integer (long) |
change_monthly | Monthly change in follower count on the professional network | Integer (long) |
change_monthly_percentage | Monthly percentage change in follower count on the professional network | Float (double) |
change_quarterly | Quarterly change in follower count on the professional network | Integer (long) |
change_quarterly_percentage | Quarterly percentage change in follower count on the professional network | Float (double) |
change_yearly | Yearly change in follower count on the professional network | Integer (long) |
change_yearly_percentage | Yearly percentage change in follower count on the professional network | Float (double) |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
professional_network_followers_count_by_month | Professional network follower count changes by month. Counts available from 2019.01 | Array of objects (struct) |
follower_count | Number of employees | Integer (long) |
date | Record date | String (date) |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
competitors | Competitors and their similarity scores | Array of objects (struct) |
company_name | Competitor's name | String |
similarity_score | Score indicating the similarity to the record company | Integer (long) |
competitors_websites | Details on the competitors' websites | Array of objects (struct) |
website | Competitor's website URL | String |
total_website_visits_monthly | Total number of monthly competitor's website visits | Integer (long) |
category | Competitor's website category | String |
rank_category | Competitor's website rank within its category | Integer |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
pricing_available | Marks if service pricing information is available online | Boolean |
free_trial_available | Marks if the company offers a free trial of their services | Boolean |
demo_available | Marks if the company offers a demo | Boolean |
is_downloadable | Marks if the company offers a downloadable file/service | Boolean |
mobile_apps_exist | Marks if the company has mobile apps | Boolean |
online_reviews_exist | Marks if the company has any online reviews | Boolean |
api_docs_exist | Marks if the company has public API docs | Boolean |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
product_pricing_summary | Summary of product pricing plans | Array of objects (structs) |
type | Pricing plan type | String |
price | Plan price | String |
details | Pricing plan details | String |
See a snippet of the dataset for reference:
Data Point | Description | Data Type |
---|---|---|
product_reviews_count | Total number of product reviews | Integer (long) |
product_reviews_aggregate_score | Average score of product reviews | Float (double) |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
product_reviews_score_by_month | Product review scores by month. Counts available from 2021.04 | Array of objects (structs) |
product_reviews_score | Product review score | Float (double) |
date | Record date | String (date) |
See a snippet of the dataset for reference:
Data Point | Description | Data Type |
---|---|---|
product_reviews_score_distribution | Distribution of product review scores | Object (struct) |
1 | Number of 1-star reviews | Integer (long) |
2 | Number of 2-star reviews | Integer (long) |
3 | Number of 3-star reviews | Integer (long) |
4 | Number of 4-star reviews | Integer (long) |
5 | Number of 5-star reviews | Integer (long) |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
product_reviews_score_change | Changes in the product review score over different periods | Object (struct) |
current | Current product review score | Float (double) |
change_monthly | Monthly change in product review score | Float (double) |
change_quarterly | Quarterly change in product review score | Float (double) |
change_yearly | Yearly change in product review score | Float (double) |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
revenue_annual_range | Annual revenue range information from various sources | Object (struct) |
source_4_annual_revenue_range source_6_annual_revenue_range | Revenue information from a specific source | Object (struct) |
annual_revenue_range_from | Minimum annual revenue range | Float (double) |
annual_revenue_range_to | Maximum annual revenue range | Float (double) |
annual_revenue_range_currency | Revenue currency | String |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
revenue_annual | Annual revenue information from various sources | Object (struct) |
source_5_annual_revenue source_1_annual_revenue | Revenue information from a specific source | Object (struct) |
annual_revenue | Annual revenue amount | Integer (long) |
annual_revenue_currency | Revenue currency | String |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
revenue_quarterly | Quarterly revenue information | Object (struct) |
value | Quarterly revenue amount | Float (double) |
currency | Revenue currency | String |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
is_public | Indicates if the company is publicly traded | Boolean |
ipo_date | IPO date | String |
ipo_share_price | Initial share price at the time of IPO | Integer (long) |
ipo_share_price_currency | Initial share price currency | String |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
stock_ticker | Company's stock ticker information | Array of objects (structs) |
exchange | Stock exchange | String |
ticker | Stock ticker | String |
stock_information | Financial details of the company's stock | Array of objects (structs) |
closing_price | Stock's closing price | Float (double) |
currency | Stock currency | String |
date | Date of the stock information in YYYY-MM-DD format | String (date) |
marketcap | Market capitalization value | Float (double) |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
income_statements | Company's income statement details | Array of objects |
cost_of_goods_sold | Total cost of goods sold by the company | Float (double) |
cost_of_goods_sold_currency | Report currency | String |
ebit | Earnings before interest and taxes | Float (double) |
ebitda | Earnings before interest, taxes, depreciation, and amortization | Float (double) |
ebitda_margin | EBITDA divided by total revenue | Float (double) |
ebit_margin | EBIT divided by total revenue | Float (double) |
earnings_per_share | Earnings per share | Float (double) |
gross_profit | Profit after expenses related to manufacturing and selling its products or services | Float (double) |
gross_profit_margin | Gross profit divided by revenue | Float (double) |
income_tax_expense | Income tax expense | Float (double) |
interest_expense | Total interest expense | Float (double) |
interest_income | Interest income | Float (double) |
net_income | Net income | Float (double) |
period_display_end_date | Period end display date (e.g., fiscal year or quarter) based on how it's displayed in the source | String |
period_end_date | Period end date in YYYY-MM-DD format | String (date) |
period_type | Period type | String |
pre_tax_profit | Profit before tax | Float (double) |
revenue | Total revenue earned by the company | Float (double) |
total_operating_expense | Total expenses related to operations | Float (double) |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
last_funding_round_name | Last funding round name | String |
last_funding_round_announced_date | Date when the last funding round was announced in YYYY-MM-DD format | String (date) |
last_funding_round_lead_investors | Lead investors in the last funding round | Array of Strings |
last_funding_round_amount_raised | Amount raised in the last funding round | Integer (long) |
last_funding_round_amount_raised_currency | Funding round currency | String |
last_funding_round_num_investors | Number of investors in the last funding round | Integer (long) |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
funding_rounds | List of completed funding rounds | Array of objects (structs) |
name | Funding round name | String |
announced_date | Date when the funding round was announced in YYYY-MM-DD format | String (date) |
lead_investors | Lead investors in the funding round | Array of Strings |
amount_raised | Amount raised in the funding round | Integer (long) |
amount_raised_currency | Funding round currency | String |
num_investors | Number of investors in the funding round | Integer (long) |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
acquired_by_summary | Acquiring company details | Object (struct) |
acquirer_name | Acquiring company name | String |
announced_date | Acquisition date | String |
price | Acquisition price | Integer (long) |
currency | Acquisition currency | String |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
num_acquisitions_source_1 num_acquisitions_source_2 num_acquisitions_source_5 | Number of completed company acquisitions based on information from various sources | Integer |
acquisition_list_source_1 acquisition_list_source_2 acquisition_list_source_5 | Company's acquisition information from various sources | Array of objects (struct) |
acquiree_name | Acquired company name | String |
announced_date | Date when the acquisition was announced in YYYY-MM-DD format | String (date) |
price | Acquisition price | Integer |
currency | Acquisition price currency | String |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
num_news_articles | Number of news articles that mention the record company | Integer |
news_articles | Details about the news articles featuring significant company updates | Array of objects (structs) |
headline | News article headline | String |
published_date | Date the article was published in YYYY-MM-DD format | String (date) |
summary | News article summary | String |
article_url | Full news article URL | String |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
num_technologies_used | Number of technologies used by the company | Integer |
technologies_used | List of technologies used by the company | Array of strings |
technology | Technology name | String |
first_verified_at | Date this technology was first assigned to the company | String (date) |
last_verified_at | Date this technology was last assigned to the company | String (date) |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
website | Website URL | String |
website_alias | All possible company website variations (collected from our firmographic sources) | String |
professional_network_url | Professional network profile URL | String |
twitter_url | Twitter profile URL | Array of strings |
discord_url | Discord server URL | Array of strings |
facebook_url | Facebook page URL | Array of strings |
instagram_url | Instagram profile URL | Array of strings |
pinterest_url | Pinterest profile URL | Array of strings |
tiktok_url | TikTok profile URL | Array of strings |
youtube_url | YouTube channel URL | Array of strings |
github_url | GitHub profile URL | Array of strings |
reddit_url | Reddit profile URL | Array of strings |
financial_website_url | Financial network profile URL | String |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
total_website_visits_monthly | Monthly website visits | Integer (long) |
visits_change_monthly | Monthly change in website visits, shown in percentage | Float (double) |
rank_global | Global rank of the website | Integer |
rank_country | Country-specific rank of the website | Integer |
rank_category | Category-specific rank of the website | Integer |
bounce_rate | Percentage of visitors who leave the site after visiting one page | Float (double) |
pages_per_visit | Average number of pages viewed per visit | Float (double) |
average_visit_duration_seconds | Average duration of a visit in seconds | Float (double) |
similarly_ranked_websites | List of websites with similar rankings | Array of strings |
top_topics | List of top topics associated with the website | Array of strings |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
total_website_visits_change | Changes in the total number of website visits over different periods | Object (struct) |
current | Current number of total website visits | Integer (long) |
change_monthly | Monthly change in total website visits | Integer (long) |
change_monthly_percentage | Monthly percentage change in total website visits | Float (double) |
change_quarterly | Quarterly change in total website visits | Integer (long) |
change_quarterly_percentage | Quarterly percentage change in total website visits | Float (double) |
change_yearly | Yearly change in total website visits | Integer (long) |
change_yearly_percentage | Yearly percentage change in total website visits | Float (double) |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
total_website_visits_by_month | Website visits by month. Counts available from 202404 | Array of objects (structs) |
total_website_visits | Website visits | Float (double) |
date | Record date | String (date) |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
visits_breakdown_by_country | Breakdown of website visits by country | Array of objects (structs) |
country | Visitor's country | String |
percentage | Percentage of visits from one country | Float (double) |
percentage_monthly_change | Monthly change in percentage of visits from one country | Float (double) |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
visits_breakdown_by_gender | Breakdown of website visits by gender | Object (struct) |
male_percentage | Percentage of visits by males | Float (double) |
female_percentage | Percentage of visits by females | Float (double) |
See a snippet of the dataset for reference:
Data point | Description | Data type |
---|---|---|
visits_breakdown_by_age | Breakdown of website visits by age group | Object (struct) |
age_18_24_percentage | Percentage of visits by users aged 18-24 | Float |
age_25_34_percentage | Percentage of visits by users aged 25-34 | Float |
age_35_44_percentage | Percentage of visits by users aged 35-44 | Float |
age_45_54_percentage | Percentage of visits by users aged 45-54 | Float |