Dictionary: Base Company Data

Contains explanations and examples of all data fields available in the Base Company dataset.

Data fields per category

1. Company information

2. Affiliated

3. Financial website info

4. Featured employees

5. Investors

6. Funding rounds

7. Locations

8. Similar companies

9. Specialties

10. Stock info

11. Company updates

Legacy data fields per category

All company information mentioned in this data dictionary is fictional and is solely intended for illustrative purposes.

Company information

Repeated fields

Data field	Description	Data type	Example values
id	Identification key for a company profile record; Each record in the dataset has its ID value; ID in the company table becomes company_id later in the other tables of the dataset.	Number (integer)	62195
company_id	Company record ID assigned in the database	Number (integer)	30707
created	The time and date when we first scraped the record	String	2023-12-07 22:07:18
last_updated	The time and date when we last scraped the record	String	2024-09-06 04:51:48
deleted	One of two values: 1 – the last time we scraped the profile, the Page not found was returned, or a particular record was deleted from the profile; 0 – the last time we scraped the profile, the record was added to our data and marked with the value of 0	Number (integer)	deleted: 0

Data field	Description	Data type
url	Professional network URL where the company was first discovered. It can be outdated if the company has changed its profile	String
hash	Profile URL processed by the MD5 algorithm	String
name	Name	String
website	Website	String
size	Size category	String
industry	Associated industry	String
description	Description	String
followers	Profile follower count	Integer
founded	Founding year	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 address) Note: legacy field that is rarely filled	String
headquarters_street2	Headquarters location (street address) Note: legacy field that is rarely filled	String
headquarters_zip	Headquarters location (zip code) Note: legacy field that is rarely filled	String
logo_url	Logo URL	String
last_response_code	Response code to the last scraping request	Integer
type	Company type	String
headquarters_new_address	Newly exposed company headquarters address	String
employees_count	Number of employees on the professional network who associated their experience with the company	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	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 current official Professional network URL for the company, reflecting the most recent updates	String
canonical_hash	Canonical_url processed by the MD5 algorithm	String
canonical_shorthand_name	Dynamic part of a canonical_url, used to identify companies (the part of the professional network URL that has the company name)	String
canonical_shorthand_name_hash	Canonical shorthand name processed by the MD5 algorithm	String
last_updated_ux	Date and time when the record was last updated (Unix timestamp)	Integer
source_id	In-house company ID (static) on the professional network	Integer

The main company table data sample:

Main company data

{
    "id": 111371,
    "url": "https://www.professional-network.com/company/luxury-store-brand",
    "hash": "83627f1b6ccb868ce2450d63124a1562",
    "name": "Luxury store brand",
    "website": "http://www.luxury-store-brand.com",
    "size": "1,001-5,000 employees",
    "industry": "Retail Apparel and Fashion",
    "description": "Luxury store brand is the go-to destination for chic, contemporary fashion. The brand evokes a mindset - an attitude, not an age. It's a true original, always defining fashion's next stride forward. Designed for the confident, sexy, modern woman, Luxury store brand is a global label that embodies a sensual, sophisticated lifestyle.\n\nChairman and Founder John Doe opened the first Luxury store brand boutique in 1980 in San Francisco. Recognizing a demographic that was neither junior nor bridge, Manny created the first contemporary fashion brand. Over 35 years later, Luxury store brand has established itself as one of the world's top fashion retailers.\n\nLuxury store brand STORES\n\nWithin its stores and on luxurystorebrand.com, Luxury store brand seeks to create an upscale, visually stimulating boutique environment while providing top-notch service to ensure an exceptional shopping experience. Stylists are knowledgeable, passionate about fashion and skilled at addressing clients' styling needs. Luxury store brand also offers a line of merchandise branded with the distinctive Luxury store brand logo for those who love to wear the Luxury store brand name.\n\nLuxury store brand markets its merchandise under the Luxury store brand and Luxury store brand outlet names through more than 200 retail stores, more than 100 international-licensee operated stores and luxury-store-brand.com. \n\nluxury-store-brand.com\nLaunched in 1998, luxury-store-brand.com continues the Luxury store brand store experience and provides a complete assortment of Luxury store brand merchandise to clients in the United States and internationally.",
    "followers": 23288,
    "founded": 1976,
    "headquarters_city": null,
    "headquarters_country": null,
    "headquarters_state": null,
    "headquarters_street1": null,
    "headquarters_street2": null,
    "headquarters_zip": null,
    "logo_url": "https://media.prof-ntwk.com/dms/image/C560BAQFmmRv6bZ4u_A/company-logo_200_200/0/1519856046980?e=2147483647&v=beta&t=PihtlecPzQHcPSUJFPYlpCI_KxUnwqOvzJqWgkr7StY",
    "created": "2016-06-17 20:08:21",
    "last_updated": "2023-09-09 18:08:29",
    "last_response_code": 200,
    "type": "Public Company",
    "headquarters_new_address": "Los Angeles, California",
    "employees_count": 1246,
    "headquarters_country_restored": "United States",
    "headquarters_country_parsed": "United States",
    "company_shorthand_name": "luxury-store-brand",
    "company_shorthand_name_hash": "44584e20693d123abce7729e4a2b9acb",
    "canonical_url": "https://www.professional-network.com/company/luxury-store-brand",
    "canonical_hash": "83627f1b6ccb868ce2450d63124a1562",
    "canonical_shorthand_name": "luxury-store-brand",
    "canonical_shorthand_name_hash": "44584e20693d123abce7729e4a2b9acb",
    "deleted": 0,
    "last_updated_ux": 1694282909,
    "source_id": 16753,

Affiliated

This category also includes data fields from Repeated fields.

Data field	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	Integer

Affiliated table data sample:

Afiiliated table

"company_affiliated_collection": [
    {
        "id": 735765,
        "company_id": 7410562,
        "affiliated_company_url": "https://www.professional-network.com/company/rental-company",
        "affiliated_company_id": 7125453,
        "created": "2020-02-04 08:32:23",
        "last_updated": "2022-09-21 08:16:07",
        "deleted": 1
    }
],

Also viewed

This category also includes data fields from Repeated fields.

A legacy table that is no longer filled.

Data field	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	Integer

Also viewed table data sample:

Also viewed table

"company_also_viewed_collection": [
        {
            "id": 448146,
            "company_id": 111371,
            "viewed_company_url": "https://www.professional-network.com/company/fashion-brand",
            "viewed_company_id": null,
            "created": "2023-06-17 20:08:21",
            "last_updated": "2024-11-14 01:07:39",
            "deleted": 1
        }
   ],

Financial website info

This category also includes data fields from Repeated fields.

Data field	Description	Data type
company_financial_website_info_collection	Company profile on the financial website	Array of objects
financial_website_url	Profile URL on the financial website	String

Financial website info table data sample:

Financial website info

 "company_financial_website_url_info_collection": [
        {
            "id": 258123,
            "company_id": 111371,
            "financial_website_url": "https://www.financial-website.com/organization/luxury-store-brand",
            "created": "2023-02-06 14:06:55",
            "last_updated": "2023-09-09 18:08:29",
            "deleted": 0
        }
    ],

Featured employees

This category also includes data fields from Repeated fields.

Data field	Description	Data type
company_featured_employees_collection	List of associated employees	Array of objects
url	Employee profile URL	String

Featured employees table data sample:

Featured employees table

"company_featured_employees_collection": [
        {
            "id": 26392978,
            "company_id": 111371,
            "url": "https://www.professional-network.com/john-doe",
            "created": "2019-11-14 01:07:39",
            "last_updated": "2020-02-22 12:17:32",
            "deleted": 1
        }
  ],

Investors

This category also includes data fields from Repeated fields.

Data field	Description	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	Integer
round_id	Identification key relating to the company_funding_rounds table	Integer
company_investors_list	List of company investors	Object
name	Investor's name	String
hash	Investor's name processed by the MD5 algorithm	String
financial_website_url	Investor's profile URL on the financial website	String

Featured investors table data sample:

Featured investors table

 "company_featured_investors_collection": [
        {
            "id": 812666,
            "company_id": 111371,
            "investor_id": 5311,
            "round_id": 1822807,
            "created": "2021-11-29 16:02:04",
            "last_updated": "2021-12-28 09:06:11",
            "deleted": 1,
            "company_investors_list": {
                "id": 5311,
                "name": "The Investor Company",
                "hash": "7b1fcd743ad2e20a8f72819749131678",
                "financial_website_url": "https://www.financial-website.com/organization/the-investor-company",
                "created": "2020-09-10 00:02:42",
                "last_updated": "2022-02-07 10:32:06"
            }
        }
    ],

Funding rounds

This category also includes data fields from Repeated fields.

Data field	Description	Data type
company_funding_rounds_collection	Last funding round details	Array of objects
last_round_investors_count	Number of investors who have participated in the funding round	Integer
total_rounds_count	Total number of completed funding rounds	Integer
last_round_type	Last funding round type	String
last_round_date	Last funding round date	String
last_round_money_raised	Amount of money raised in the last funding round	String
financial_website_url	Funding round record URL on financial website	String

Funding rounds table data sample:

Funding rounds table

"company_funding_rounds_collection": [
        {
            "id": 2,
            "last_round_investors_count": 0,
            "total_rounds_count": 4,
            "last_round_type": "Seed",
            "last_round_date": "2016-06-01 00:00:00",
            "last_round_money_raised": "US$ 224.2K",
            "financial_website_url": "https://www.financial-website.com/funding_round/software-company-seed--92e35c7f",
            "created": "2020-09-07 13:01:57",
            "last_updated": "2020-09-26 16:29:54",
            "deleted": 1
        }
    ],

Locations

This category also includes data fields from Repeated fields.

Data field	Description	Data type
company_locations_collection	Company locations	Array of objects
location_address	Company address	String
is_primary	Denotes if the location is the company's primary location 0 – not a primary location 1 – primary location	Boolean

Locations table data sample:

Locations table

"company_locations_collection": [
        {
            "id": 11612582,
            "company_id": 111371,
            "location_address": "Los Angeles, California, US",
            "is_primary": 1,
            "created": "2019-11-14 01:07:39",
            "last_updated": "2023-09-09 18:08:29",
            "deleted": 0
        },
        {
            "id": 11612583,
            "company_id": 111371,
            "location_address": "New York, US",
            "is_primary": 0,
            "created": "2019-11-14 01:07:39",
            "last_updated": "2023-09-09 18:08:29",
            "deleted": 0
        }
    ],

Similar companies

This category also includes data fields from Repeated fields.

Data field	Description	Data type
company_similar_collection	Companies similar to the record company	Array of objects
url	Similar company profile URL	String

Similar table data sample:

Similar table

 "company_similar_collection": [
        {
            "id": 45310284,
            "company_id": 111371,
            "url": "https://www.professional-network.com/company/luxury-clothing-brand",
            "created": "2019-11-14 01:07:39",
            "last_updated": "2021-06-22 02:08:26",
            "deleted": 0
        }
   ],

Specialties

This category also includes data fields from Repeated fields.

Data field	Description	Data type
company_specialties_collection	List of company specialties	Array of objects
specialty	Specialty	String

Specialties table data sample:

Specialties table

"company_specialties_collection": [
        {
            "id": 160305,
            "company_id": 111371,
            "specialty": "Luxury store brand stores",
            "created": "2016-06-17 20:08:21",
            "last_updated": "2024-07-25 04:42:17",
            "deleted": 1
        }
    ],

Stock info

This category also includes data fields from Repeated fields.

Data field	Filter name	Data type
company_stock_info_collection	Stock details	Array of objects
ticker	Stock ticker	String
exchange	Stock exchange	String

Stock info table data sample:

Stock info table

"company_stock_info_collection": [
        {
            "id": 2789,
            "company_id": 111371,
            "ticker": "LSB",
            "exchange": "OTCM",
            "created": "2023-05-07 14:38:14",
            "last_updated": "2023-07-19 09:39:38",
            "deleted": 1
        }
    ],

Company updates

This category also includes data fields from Repeated fields.

Data field	Description	Data type
company_updates_collection	Company's posts/updates on professional network	Array of objects
urn	String-based identifier	String
followers	Number of followers	Integer
date	Publish date (e.g., 1 month ago)	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 (e.g., 1 month ago)	String

Company updates table data sample:

Company updates table

"company_updates_collection": [
      {
        "id": 193,
        "company_id": 12695930,
        "urn": "urn:li:activity:6991335602751201281",
        "followers": 1371,
        "date": "1mo",
        "description": "We are delighted to share with you our success at the Expo 2022. Prime Minister spent the highest time in the expo at our Virtual Reality Aircraft Simulator, took an entire sortie on the virtual ALH MK III, experienced it to the fullest. \n\nKudos to the entire team of the Tech Company for this remarkable achievement ! Hands down by far the best show we've ever had !",
        "reactions_count": 22,
        "comments_count": 2,
        "reshared_post_author": "John Doe",
        "reshared_post_author_url": "https://www.professional-network.com/john-doe",
        "reshared_post_author_headline": "Co-Founder at Tech Company, VR/AR Training Facilitator, TEDx & Keynote Speaker",
        "reshared_post_description": "We are delighted to share with you our success at the Expo 2022. Prime Minister spent the highest time in the expo at our Virtual Reality Aircraft Simulator, took an entire sortie on the virtual ALH MK III, experienced it to the fullest. \n\nKudos to the entire team of the Tech Company for this remarkable achievement ! Hands down by far the best show we've ever had !",
        "reactions_count": 22,
        "reshared_post_followers": 30,
        "reshared_post_date": "1mo",
        "last_updated": "2023-01-04 10:09:34",
        "deleted": 1
      }
    ],