Firmographic Data
This data dictionary shows all available data points, explains their values, and provides samples of raw company data and the data you can get via Company API.
All tables have snippets of the Professional Network Companies dataset.
Raw company data in the Company dataset has the same data points as the data you get using the Database API.
All company information mentioned in this data dictionary is fictional and is solely intended for illustrative purposes.
A null value means that the information was not listed in the profile.
Data point | Description | Data type |
url | Company profile URL | string |
hash | Profile URL, processed by the MD5 algorithm | string |
name | Company name | string |
website | Company website URL | string |
size | Company size category (determined by the number of employees) | string |
industry | Industry the company operates in | string |
description | Company description | string |
followers | Follower count | number (integer) |
founded | Founding year | number (integer) |
headquarters_city | Headquarters location (city) Note: legacy field that is rarely filled | string |
headquarters_country | Headquarters location (country) Note: legacy field that is rarely filled | string |
headquarters_state | Headquarters location (state) Note: legacy field that is rarely filled | string |
headquarters_street1 | Headquarters location (street) Note: legacy field that is rarely filled | string |
headquarters_street2 | Headquarters location (street) Note: legacy field that is rarely filled | string |
headquarters_zip | Headquarters location (zip code) Note: legacy field that is rarely filled | string |
logo_url | Company logo | string |
last_response_code | The response code of the last scraping request | number (integer) |
type | Company type | string |
headquarters_new_address | Newly exposed headquarters address | string |
employees_count | Number of employees on the professional network who associated their experience with the company | number (integer) |
headquarters_country_restored | Country the company is based in (from our restored database) Note: legacy field that is rarely filled | string |
headquarters_country_parsed | Country the company is based in (as parsed by our in-house country parser) | string |
company_shorthand_name | The dynamic part of the URL used to update the profile and identify companies | string |
company_shorthand_name_hash | Shorthand name of the company processed by the MD5 algorithm | string |
canonical_url | The most recent version of the company profile URL | string |
canonical_hash | Canonical_url processed by the MD5 algorithm | string |
canonical_shorthand_name | The dynamic part of a canonical_url, used to identify companies (the part of the URL that has the company name) | string |
canonical_shorthand_name_hash | Canonical shorthand name processed by the MD5 algorithm | string |
last_updated_ux | The date and time when the record was last updated (Unix time) | number (integer) |
source_id | In-house company ID (static) on the Professional network | number (integer) |
The main company table data sample:
Data point | Description | Data type |
company_affiliated_collection | Profiles of affiliated companies | array of objects |
affiliated_company_url | Affiliate company profile URL | string |
affiliated_company_id | Identification key relating to the company table for the affiliate company Note: legacy field | number (integer) |
Affiliated table data sample:
A legacy table that is no longer filled.
Data point | Description | Data type |
company_also_viewed_collection | Company profiles that were viewed in tandem with the record company profile | array of objects |
viewed_company_url | Company profile URL | string |
viewed_company_id | Identification key relating to the company table | number (integer) |
Also viewed table data sample:
Data point | Description | Data type |
company_crunchbase_info_collection | Company Crunchbase profile | array of objects |
cb_url | Crunchbase profile URL | string |
Crunchbase info table data sample:
Data point | Description | Data type |
company_featured_employees_collection | The list of employee profiles who have the company on their profiles on the Professional network | array of objects |
url | Featured employee profile URL | string |
Featured employees table data sample:
Data point | Filter name | Data type |
company_featured_investors_collection | Consists of record metadata and company_investors_list objects | array of objects |
investor_id | Identification key relating to the company_investors_list table | number (integer) |
round_id | Identification key relating to the company_funding_rounds table | number (integer) |
company_investors_list | Company investors | object |
name | Investor name | string |
hash | Investor name processed by the MD5 algorithm | string |
cb_url | Investor Crunchbase profile URL | string |
Featured investors table data sample:
Data point | Description | Data type |
company_funding_rounds_collection | Information on the last company funding round | array of objects |
last_round_investors_count | Count of investors in the last funding round | number (integer) |
total_rounds_count | The number of total funding rounds | number (integer) |
last_round_type | The last funding round type | string |
last_round_date | The last funding round date | string |
last_round_money_raised | The amount of money raised | string |
cb_url | Funding round record URL on Crunchbase | string |
Funding rounds table data sample:
Data point | Description | Data type |
company_locations_collection | Company location information | array of objects |
location_address | Physical company address | string |
is_primary | Denotes if the location is the company's primary location (primary - 1; not primary - 0) | boolean |
Locations table data sample:
Data point | Description | Data type |
company_similar_collection | Profiles of similar companies on Professional network | array of objects |
url | Similar company profile URL | string |
Similar table data sample:
Data point | Description | Data type |
company_specialties_collection | List of company specialties | array of objects |
specialty | Company specialty | string |
Specialties table data sample:
Data point | Filter name | Data type |
company_stock_info_collection | Information on the company stocks | array of objects |
ticker | Stock ticker title | string |
exchange | Stock exchange title | string |
Stock info table data sample:
Data point | Description | Data type |
company_updates_collection | Company LinkedIn post details | array of objects |
urn | String-based identifier | string |
followers | Follower count | number (integer) |
date | Publish date (e.g., 1 month ago) | string |
description | Published text Note: may contain control characters | string |
reactions_count | Reactions count | number (integer) |
comments_count | Comment count | number (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 | number (integer) |
reshared_post_date | Date the reshared post was published (e.g., 1 month ago) | string |
Company updates table data sample: