Company Data

Clean Company Data

Dictionary: Clean Company Data

28min

Request access to our full documentation
This is a simplified version of our documentation. If you want to:
Access data samples
Learn more about the cleaning and enrichment actions
Explore the complete list of data sources we offer
Contact sales
﻿
Clean Company Data provides high-quality, structured business data ready for immediate use. Our data is meticulously cleaned and enriched, allowing organizations to streamline their workflows and confidently make data-driven decisions. By leveraging Clean Company Data, businesses can reduce engineering overhead, gain access to additional insights, and work with optimized data formats for improved efficiency.
With multiple retrieval options—including flat file downloads in JSONL, Parquet, and CSV formats, as well as API access—our solution adapts to your needs, ensuring seamless integration into your existing data infrastructure.
Clean Company Data is derived from our Base Company Data﻿. 
The data points are separated into collections to visualize the data better. The data provided in the samples is strictly intended for illustrative purposes, allowing you to understand its appearance and format better. 
Data collections
﻿Metadata﻿ 
﻿Identifiers﻿ 
﻿Firmographics﻿ 
﻿Product and services overview﻿ 
﻿Contact information﻿ 
﻿Social media and websites﻿ 
﻿Location﻿ 
﻿Funding information ﻿ 
﻿Technologies﻿ 
﻿Supporting fields﻿ 
﻿Company updates﻿ 
﻿
Metadata
Data point
Processing
Description
Data type
company_last_updated
Cleaned
Record update date
String (date)
company_created_at
Cleaned
Record creation date
String (date)
professional_network_source_id
Raw
Record identification key assigned by professional network
String
Meta data
"company_created_at": "2023-12-06",
"company_last_updated": "2024-12-06",
"professional_network_source_id": "60191",
"company_created_at": "2023-12-06",
"company_last_updated": "2024-12-06",
"professional_network_source_id": "60191",
﻿
Data point
Cleaning action
company_last_updated
Value is converted to the yyyy-mm-dd format.
company_created_at
Value is converted to the yyyy-mm-dd format.
﻿
Identifiers
Data point
Processing
Description
Data type
company_id
Raw
Company ID in our database
Number (integer)
company_hash
Raw
Company profile URL processed by the MD5 algorithm.
String
company_canonical_shorthand_name_hash
Raw
Canonical shorthand name processed by the MD5 algorithm
String
company_name
Cleaned
Company name
String
company_logo
Cleaned
BASE64 encoded JPEG image of the company's logo
String
company_ticker
Cleaned
Company's stock ticker
String
company_exchange
Cleaned
Company's stock exchange
String
Clean company data
    "company_id": 7811468,
    "company_hash": "8ef8d364df382df483f47fe3e56dc4cd",
    "company_canonical_shorthand_name_hash": "8631ca96b6f656040bf3326deeb38df6",
    "company_name": "Example Company",
    "company_logo": "/9j/4AAQSkZJRgABAQAAAQABAAD/2wBDAAMCAgMCAgMDAwMEAwMEBQgFBQQEBQoHBwYIDAoMDAsKCwsNDhIQDQ4RDgsLEBYQERMUFRUVDA8XGBYUGBIUFRT/2wBDAQMEBAUEBQkFBQkUDQsNFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBT/wAARCAAjACMDASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD9U6K+K7P9rfx1cfFG7smj00aNHrBsltBbHd5Qm8v/AFm7O7HOfXtivc9N/aHsLLRr2612yuI3t/EFzoSGxj83zGjDOr7cgj5ByBnkHHHTtqYOtTtdXv2Pr8dwrmeAUHOKlzJP3Xd6/wBdLnsNFeX+EP2i/CXjjxNa6DpbXr6jcPNGqSQBQpiUNICd3YMp4zncMU/R/wBoHw3rj3S21vqWLc7Sz26gMd8CYHz5+9cR9cd/SsXQqp2cWeNPKcfTk4zoyTST26NtL72n9zPTaK5Tw78QYPFGlR6jYaTqr2zySxAyW6o26ORo3BBbPDIworNwknZnDPD1acnCas1o0fL3wn8TfCbwHqHie68ez6bY+JLfxJdzWzXsEjzIgkyhAUHo24jj39K0vgvN4g+JPg3xHq/hKO1Nu3jG/njkvoQfPtHgAOzeOHbeVz0GSD3r6ivvB2g6ndPc3ei6ddXD/emmtI3dvqSuTWjY2FtptrHbWlvFa28YwkUKBEX6AcCu+eLjK7Sd3bd3XyPtcZxHQr06kqdOTqT5b80lKMVG+kY8qdn5s+cbP4VePrO+iu49H0W2kjdQRarbqSm5/M2NsBVjG6oD/s88YJZqHwQ8U/2VZ/YNI0z7X5UInivEtzGMQxpIoABxkocEE9EPbj6YorL63O97I8NZ5ilLmSX3P/M838FaV4x0fw1a2dzBbQzxtJvX7QgyTIx3YWPABznHbPPNFekUVzOd3eyPJniHUm5uKu9f61CiiiszkCiiigAooooA/9k=",
    "company_ticker": "EXMP",
    "company_exchange": "NYSE",
    "company_id": 7811468,
    "company_hash": "8ef8d364df382df483f47fe3e56dc4cd",
    "company_canonical_shorthand_name_hash": "8631ca96b6f656040bf3326deeb38df6",
    "company_name": "Example Company",
    "company_logo": "/9j/4AAQSkZJRgABAQAAAQABAAD/2wBDAAMCAgMCAgMDAwMEAwMEBQgFBQQEBQoHBwYIDAoMDAsKCwsNDhIQDQ4RDgsLEBYQERMUFRUVDA8XGBYUGBIUFRT/2wBDAQMEBAUEBQkFBQkUDQsNFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBQUFBT/wAARCAAjACMDASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD9U6K+K7P9rfx1cfFG7smj00aNHrBsltBbHd5Qm8v/AFm7O7HOfXtivc9N/aHsLLRr2612yuI3t/EFzoSGxj83zGjDOr7cgj5ByBnkHHHTtqYOtTtdXv2Pr8dwrmeAUHOKlzJP3Xd6/wBdLnsNFeX+EP2i/CXjjxNa6DpbXr6jcPNGqSQBQpiUNICd3YMp4zncMU/R/wBoHw3rj3S21vqWLc7Sz26gMd8CYHz5+9cR9cd/SsXQqp2cWeNPKcfTk4zoyTST26NtL72n9zPTaK5Tw78QYPFGlR6jYaTqr2zySxAyW6o26ORo3BBbPDIworNwknZnDPD1acnCas1o0fL3wn8TfCbwHqHie68ez6bY+JLfxJdzWzXsEjzIgkyhAUHo24jj39K0vgvN4g+JPg3xHq/hKO1Nu3jG/njkvoQfPtHgAOzeOHbeVz0GSD3r6ivvB2g6ndPc3ei6ddXD/emmtI3dvqSuTWjY2FtptrHbWlvFa28YwkUKBEX6AcCu+eLjK7Sd3bd3XyPtcZxHQr06kqdOTqT5b80lKMVG+kY8qdn5s+cbP4VePrO+iu49H0W2kjdQRarbqSm5/M2NsBVjG6oD/s88YJZqHwQ8U/2VZ/YNI0z7X5UInivEtzGMQxpIoABxkocEE9EPbj6YorL63O97I8NZ5ilLmSX3P/M838FaV4x0fw1a2dzBbQzxtJvX7QgyTIx3YWPABznHbPPNFekUVzOd3eyPJniHUm5uKu9f61CiiiszkCiiigAooooA/9k=",
    "company_ticker": "EXMP",
    "company_exchange": "NYSE",
﻿
Data point
Cleaning/enriching action
company_name
Values ["None"; "Unknown"; "NaN"; "nan"; "na"; "null"; "Null"; "NULL"; "-"; "--"] are replaced with value None. 
company_logo
Image is resized to 50x50px.
company_ticker
Values ["None"; "Unknown"; "NaN"; "nan"; "na"; "null"; "Null"; "NULL"; "-"; "--"] are replaced with value None. 
﻿
Firmographics
Data point
Processing
Description
Data type
company_industry
Cleaned
Company's industry
String
company_type
Cleaned
Company type
String
company_founded
Cleaned
Company's founding year
String
company_size_range
Cleaned
Company size range
String
company_size_employees_count
Enriched
The number of employees working in the company
Number (integer)
company_followers
Cleaned
The number of company followers
Number (integer)
company_description
Cleaned
Company description
String
company_specialities
Raw
Company specialties
String
metadata_title
Enriched
Company title parsed from additional sources
String
metadata_description
Enriched
Company description parsed from additional sources
String
company_enriched_summary
Enriched
LLM enriched company summary
String
company_enriched_category
Enriched
Company category assigned with LLM
String
company_enriched_keywords
Enriched
LLM enriched company keywords
Array of strings
company_enriched_b2b
Enriched
Marks if the company offers B2B products/services enriched with the help of LLM
1 - B2B company
0 - not B2B company
Boolean
Clean company data
    "company_type": "Partnership",
    "company_founded": "2010",
    "company_followers": 0,
    "company_size_range": "1-10 employees",
    "company_size_employees_count": 2,
    "company_industry": "Advertising Services",
    "company_description": "We help SMEs grow their businesses through effective online marketing strategies. ",
    "company_specialities": "Email Marketing, Web Sites, Search Engine Optimisation, Inbound Marketing, Social media Marketing",
    "company_enriched_summary": "Company1 is a premier web design and digital marketing agency based in London, UK. Specializing in custom, responsive websites, they provide professional design services, training, easy content management, and ongoing support.",
    "company_enriched_keywords": [
        "website design",
        "digital marketing",
        "professional",
        "custom responsive websites",
        "training"
    ],
    "company_enriched_b2b": 1.0,
    "company_enriched_category": "Web Design",
    "metadata_title": "Marketing, London,Cost Effective Web Design",
    "metadata_description": null
    "company_type": "Partnership",
    "company_founded": "2010",
    "company_followers": 0,
    "company_size_range": "1-10 employees",
    "company_size_employees_count": 2,
    "company_industry": "Advertising Services",
    "company_description": "We help SMEs grow their businesses through effective online marketing strategies. ",
    "company_specialities": "Email Marketing, Web Sites, Search Engine Optimisation, Inbound Marketing, Social media Marketing",
    "company_enriched_summary": "Company1 is a premier web design and digital marketing agency based in London, UK. Specializing in custom, responsive websites, they provide professional design services, training, easy content management, and ongoing support.",
    "company_enriched_keywords": [
        "website design",
        "digital marketing",
        "professional",
        "custom responsive websites",
        "training"
    ],
    "company_enriched_b2b": 1.0,
    "company_enriched_category": "Web Design",
    "metadata_title": "Marketing, London,Cost Effective Web Design",
    "metadata_description": null
﻿
Data point
Cleaning/enriching action
company_industry
Values ["None"; "Unknown"; "NaN"; "nan"; "na"; "null"; "Null"; "NULL"; "-"; "--"] are replaced with value None. 
company_type
Values ["None"; "Unknown"; "NaN"; "nan"; "na"; "null"; "Null"; "NULL"; "-"; "--"] are replaced with value None. 
company_founded
Values ["None"; "Unknown"; "NaN"; "nan"; "na"; "null"; "Null"; "NULL"; "-"; "--"] are replaced with value None;
Values are replaced with None if the year is not between 500 and the current year.
company_followers
Values ["None"; "Unknown"; "NaN"; "nan"; "na"; "null"; "Null"; "NULL"; "-"; "--"] are replaced with value 0;
Every value is converted to an integer. 
company_size_range
Some inconsistencies are fixed with overlapping values:
"1 employee" - "Myself Only";
"2-10 employees" - "1-10 employees";
"501-1,000 employees" - "501-1000 employees";  
"1,001-5,000 employees" - "1001-5000 employees".
company_size_employees_count
We calcualte the number of employees working in the company using if company_size_employees_count does not provide enough information.
company_industry
Values ["None"; "Unknown"; "NaN"; "nan"; "na"; "null"; "Null"; "NULL"; "-"; "--"] are replaced with value None. 
company_description
Values ["None"; "Unknown"; "NaN"; "nan"; "na"; "null"; "Null"; "NULL"; "-"; "--"] are replaced with value None;
Value is replaced to None if the description is shorter than 3 characters;
Text styling tags removed; 
Multiple spaces are replaced with single ones.
﻿
Product and services overview
Data point
Processing
Description
Data type
pricing_available
Enriched
Marks if the company service pricing is available online
Boolean
free_trial_available
Enriched
Marks if the company offers a free trial of their services 
Boolean
demo_available
Enriched
Marks if the company offers a demo
Boolean
is_downloadable
Enriched
Marks if the company offers a downloadable file/service
Boolean
mobile_apps_exist
Enriched
Marks if the company has mobile apps for their service
Boolean
online_reviews_exist
Enriched
Marks if the company has any online reviews
Boolean
api_docs_exist
Enriched
Marks if the company has API docs published
Boolean
Clean company data
    "pricing_available": true,
    "free_trial_available": false,
    "demo_available": false,
    "is_downloadable": false,
    "mobile_apps_exist": false,
    "online_reviews_exist": false,
    "api_docs_exist": false,
    "pricing_available": true,
    "free_trial_available": false,
    "demo_available": false,
    "is_downloadable": false,
    "mobile_apps_exist": false,
    "online_reviews_exist": false,
    "api_docs_exist": false,
﻿
Data point
Enriching action
pricing_available
free_trial_available
demo_available
is_downloadable
mobile_apps_exist
online_reviews_exist
api_docs_exist
Information taken from the official company website.
﻿
Contact information
Data point
Processing
Description
Data type
company_phone_numbers
Enriched
Publicly available company phone number
Array of strings
company_emails
Enriched
Publicly available company email address
Array of strings
Contact information
"company_phone_numbers": [
        "0000 000 000"
    ],
    "company_emails": [
        "[email protected]"
    ],
"company_phone_numbers": [
        "0000 000 000"
    ],
    "company_emails": [
        "info@company123.com"
    ],
﻿
Data point
Enriching action
company_phone_numbers
company_emails
Information taken from the official company website.
﻿
Social media and websites
Data point
Processing
Description
Data type
company_websites_main_original
Raw
Company website 
String
company_websites_main
Enriched
Cleaned and resolved website URL
String
company_websites_facebook
Enriched
Facebook profile URL
String
company_websites_twitter
Enriched
Twitter profile URL
String
company_websites_linkedin
Raw
Company LinkedIn profile URL 
String
company_websites_linkedin_
canonical
Raw
Canonical LinkedIn profile URL
String
company_social_discord_urls
Enriched
Discord channel URL 
Array of strings
company_social_facebook_urls
Enriched
Facebook profile URL
Array of strings
company_social_instagram_urls
Enriched
Instagram profile URL 
Array of strings
company_social_linkedin_urls
Enriched
Company LinkedIn profile URL
Array of strings
company_social_pinterest_urls
Enriched
Pinterest profile URL
Array of strings
company_social_tiktok_urls
Enriched
TikTok profile URL
Array of strings
company_social_twitter_urls
Enriched
Twitter profile URL
Array of strings
company_social_x_urls
Enriched
X profile URL
Array of strings
company_social_youtube_urls
Enriched
YouTube channel/profile URL
Array of strings
company_social_github_urls
Enriched
Github page/profile URL
Array of strings
company_social_reddit_urls
Enriched
Reddit profile URL
Array of strings
Clean company data
Company social links
 "company_websites_main_original": "http://www.example-company.com.",
 "company_websites_main": "https://example-company.com.",
 "company_websites_facebook": "https://www.facebook.com/example-company",
 "company_websites_twitter": "https://www.twitter.com/example-company",
 "company_websites_linkedin": "https://www.linkedin.com/company/example-company-international-limited",
 "company_websites_linkedin_canonical": "https://www.linkedin.com/company/example-company-international-limited",
 "company_websites_main_original": "http://www.example-company.com.",
 "company_websites_main": "https://example-company.com.",
 "company_websites_facebook": "https://www.facebook.com/example-company",
 "company_websites_twitter": "https://www.twitter.com/example-company",
 "company_websites_linkedin": "https://www.linkedin.com/company/example-company-international-limited",
 "company_websites_linkedin_canonical": "https://www.linkedin.com/company/example-company-international-limited",
﻿
Data point
Cleaning/enriching action
company_websites_main
Every company_website_main_original URL is resolved;
Each URL we collect is parsed, parameters are removed and added to the company_websites_main column;
Expired domains are removed;
Additional enrichment actions are completed
company_websites_twitter
If <domain> (from company_websites_main) == twitter, we move the URL value to company_websites_twitter.
company_websites_facebook
If <domain> (from company_websites_main) == facebook, we move the URL value to company_websites_facebook.
company_websites_linkedin
If <domain> (from company_websites_main) == linkedin, we move the URL value to company_websites_linkedin.
company_social_discord_urls
company_social_facebook_urls
company_social_instagram_urls
company_social_linkedin_urls
company_social_pinterest_urls
company_social_tiktok_urls
company_social_twitter_urls
company_social_x_urls
company_social_youtube_urls
company_social_github_urls
company_social_reddit_urls
URLs taken from the official company website.
﻿
Location
Data point
Processing
Description
Data type
company_location_hq_country
Cleaned
Headquarters country
String
company_location_hq_raw_address
Cleaned
Detailed company location
String
company_location_hq_regions
Enriched
Geographical region(s) the company is associated with based on the company_location_hq_country value.
String
company_locations_full
Raw
Full company location information
Array of objects
location_address
Raw
Company HQ location
String
is_primary
Raw
Marks if the listed location is the primary
Boolean
Locations
Full location
"company_location_hq_raw_address": "Los Angeles, CA, United States",
"company_location_hq_country": "United States",
"company_location_hq_regions": "[Northern America, Northern America, AMER]",
"company_location_hq_raw_address": "Los Angeles, CA, United States",
"company_location_hq_country": "United States",
"company_location_hq_regions": "[Northern America, Northern America, AMER]",
﻿
Data point
Cleaning action
location_hq_country
Values ["None"; "Unknown"; "NaN"; "nan"; "na"; "null"; "Null"; "NULL"; "-"; "--"] are replaced with value None. 
location_hq_raw_address
Values ["None"; "Unknown"; "NaN"; "nan"; "na"; "null"; "Null"; "NULL"; "-"; "--"] are replaced with value None;
Special trailing characters trimmed; 
Value company_location_hq_country added to the end of the string (separated by a comma).
﻿
Funding information
Data point
Processing
Description
Data type 
company_funding_rounds
﻿
Funding round details 
Array of objects
last_round_investors_count
Cleaned
The number of investors that participated in the last funding round
Number (integer)
total_rounds_count
Cleaned
Total number of funding rounds
Number (integer)
last_round_type
Cleaned
Last funding round type 
String
last_round_date
Cleaned
Last funding round date
String
last_round_money_raised
Cleaned
Total funds raised 
number (integer)
financial_website_url
Raw
Financial website URL of the last funding round
String
Clean company data
 "company_funding_rounds": [
        {
            "last_round_investors_count": 5,
            "total_rounds_count": 3,
            "last_round_type": "Series A",
            "last_round_date": "2020-11-10",
            "last_round_money_raised": 15600000,
            "financial_website_url": "https://www.financial_website.com/funding_round/example-company-series-a--f1687fe3"
        }
    ]
}
 "company_funding_rounds": [
        {
            "last_round_investors_count": 5,
            "total_rounds_count": 3,
            "last_round_type": "Series A",
            "last_round_date": "2020-11-10",
            "last_round_money_raised": 15600000,
            "financial_website_url": "https://www.financial_website.com/funding_round/example-company-series-a--f1687fe3"
        }
    ]
}
﻿
Data point
Cleaning action
location_hq_country
Values ["None"; "Unknown"; "NaN"; "nan"; "na"; "null"; "Null"; "NULL"; "-"; "--"] are replaced with value None. 
location_hq_raw_address
Values ["None"; "Unknown"; "NaN"; "nan"; "na"; "null"; "Null"; "NULL"; "-"; "--"] are replaced with value None;
Special trailing characters trimmed; 
Value company_location_hq_country added to the end of the string (separated by a comma).
﻿
Technologies
Data point
Processing
Description
Data type
company_technologies
Enriched
Technologies used by the company
Array of structs
technology
Enriched
Technology name
String
first_verified_at
Enriched
Date this technology was first assigned to the company.
Date format: YYYY-MM-DD
String (date)
last_verified_at
Enriched
Date this technology was last assigned to the company.
Date format: YYYY-MM-DD
String (date)
Technologies
"company_technologies": [
    {
      "technology": "React",
      "first_verified_at": "2022-03-15",
      "last_verified_at": "2025-02-15"
    }
  ]
"company_technologies": [
    {
      "technology": "React",
      "first_verified_at": "2022-03-15",
      "last_verified_at": "2025-02-15"
    }
  ]
﻿
Data point
Enriching action
company_technologies
Enriched by our ML model from multiple sources.
﻿
Supporting fields
Data point
Processing
Description
Data type 
expired_domain
Enriched
Indicates that the company_websites_main_original
URL redirects to a domain dealer
Boolean
unique_subdomain
Enriched
Indicates that only the record company owns the subdomain 
Boolean
unique_domain
Enriched
Indicates that only this company has the right to have this unique domain, e.g., company_websites_main: https://ibm.com
Boolean
unique_website
Enriched
Indicates that only this company has a unique website but not necessarily a unique domain, e.g., company_websites_main: https://ibm.com/generation
Boolean
Clean company data
    "expired_domain": 0,
    "unique_domain": 1,
    "unique_subdomain": 1,
    "unique_website": 0,
    "expired_domain": 0,
    "unique_domain": 1,
    "unique_subdomain": 1,
    "unique_website": 0,
﻿
﻿
Company updates
Data point
Processing
Description
Data type
company_updates
﻿
Company posts and related details
Array of objects
urn
Raw
String-based identifier
﻿
String
followers
Raw
Number of followers
String
date
Raw
Post  publish date
(e.g., 1 month ago)
String
description
Raw
Published text
Note: may contain control characters
String
reactions_count
Raw
Number of reactions on the post
Integer
comments_count
Raw
Number of comments on the post
Integer
reshared_post_author
Raw
Reshared post author
String
reshared_post_author_url
Raw
Author's profile URL
String
reshared_post_author_headline
Raw
Author's headline
String
reshared_post_description
Raw
Reshared post text
String
reshared_post_followers
Raw
The number of followers of the reshared post author
Integer
reshared_post_date
Raw
Date the reshared post was published

(e.g., 1 month ago)
String
Company updates table
"company_updates_collection": [
      {
        "urn": "urn:pn:activity:6991335602751201281",
        "followers": 1371,
        "date": "1mo",
        "description": "Example description",
        "reactions_count": 22,
        "comments_count": 2,
        "reshared_post_author": "John Doe",
        "reshared_post_author_url": "https://www.professional_network.com/in/john-doe",
        "reshared_post_author_headline": "Co-Founder at Example Company, TEDx & Keynote Speaker",
        "reshared_post_description": "Example description",
        "reshared_post_followers": 45,
        "reshared_post_date": "1mo"
      }
  ]
"company_updates_collection": [
      {
        "urn": "urn:pn:activity:6991335602751201281",
        "followers": 1371,
        "date": "1mo",
        "description": "Example description",
        "reactions_count": 22,
        "comments_count": 2,
        "reshared_post_author": "John Doe",
        "reshared_post_author_url": "https://www.professional_network.com/in/john-doe",
        "reshared_post_author_headline": "Co-Founder at Example Company, TEDx & Keynote Speaker",
        "reshared_post_description": "Example description",
        "reshared_post_followers": 45,
        "reshared_post_date": "1mo"
      }
  ]
﻿
﻿

Data point	Processing	Description	Data type
company_last_updated	Cleaned	Record update date	String (date)
company_created_at	Cleaned	Record creation date	String (date)
professional_network_source_id	Raw	Record identification key assigned by professional network	String

Data point	Cleaning action
company_last_updated	Value is converted to the yyyy-mm-dd format.
company_created_at	Value is converted to the yyyy-mm-dd format.

Data point	Processing	Description	Data type
company_id	Raw	Company ID in our database	Number (integer)
company_hash	Raw	Company profile URL processed by the MD5 algorithm.	String
company_canonical_shorthand_name_hash	Raw	Canonical shorthand name processed by the MD5 algorithm	String
company_name	Cleaned	Company name	String
company_logo	Cleaned	BASE64 encoded JPEG image of the company's logo	String
company_ticker	Cleaned	Company's stock ticker	String
company_exchange	Cleaned	Company's stock exchange	String

Data point	Cleaning/enriching action
company_name	Values ["None"; "Unknown"; "NaN"; "nan"; "na"; "null"; "Null"; "NULL"; "-"; "--"] are replaced with value None.
company_logo	Image is resized to 50x50px.
company_ticker	Values ["None"; "Unknown"; "NaN"; "nan"; "na"; "null"; "Null"; "NULL"; "-"; "--"] are replaced with value None.

Data point	Processing	Description	Data type
company_industry	Cleaned	Company's industry	String
company_type	Cleaned	Company type	String
company_founded	Cleaned	Company's founding year	String
company_size_range	Cleaned	Company size range	String
company_size_employees_count	Enriched	The number of employees working in the company	Number (integer)
company_followers	Cleaned	The number of company followers	Number (integer)
company_description	Cleaned	Company description	String
company_specialities	Raw	Company specialties	String
metadata_title	Enriched	Company title parsed from additional sources	String
metadata_description	Enriched	Company description parsed from additional sources	String
company_enriched_summary	Enriched	LLM enriched company summary	String
company_enriched_category	Enriched	Company category assigned with LLM	String
company_enriched_keywords	Enriched	LLM enriched company keywords	Array of strings
company_enriched_b2b	Enriched	Marks if the company offers B2B products/services enriched with the help of LLM 1 - B2B company 0 - not B2B company	Boolean

Data point	Cleaning/enriching action
company_industry	Values ["None"; "Unknown"; "NaN"; "nan"; "na"; "null"; "Null"; "NULL"; "-"; "--"] are replaced with value None.
company_type	Values ["None"; "Unknown"; "NaN"; "nan"; "na"; "null"; "Null"; "NULL"; "-"; "--"] are replaced with value None.
company_founded	Values ["None"; "Unknown"; "NaN"; "nan"; "na"; "null"; "Null"; "NULL"; "-"; "--"] are replaced with value None; Values are replaced with None if the year is not between 500 and the current year.
company_followers	Values ["None"; "Unknown"; "NaN"; "nan"; "na"; "null"; "Null"; "NULL"; "-"; "--"] are replaced with value 0; Every value is converted to an integer.
company_size_range	Some inconsistencies are fixed with overlapping values: "1 employee" - "Myself Only"; "2-10 employees" - "1-10 employees"; "501-1,000 employees" - "501-1000 employees";  "1,001-5,000 employees" - "1001-5000 employees".
company_size_employees_count	We calcualte the number of employees working in the company using if company_size_employees_count does not provide enough information.
company_industry	Values ["None"; "Unknown"; "NaN"; "nan"; "na"; "null"; "Null"; "NULL"; "-"; "--"] are replaced with value None.
company_description	Values ["None"; "Unknown"; "NaN"; "nan"; "na"; "null"; "Null"; "NULL"; "-"; "--"] are replaced with value None; Value is replaced to None if the description is shorter than 3 characters; Text styling tags removed;  Multiple spaces are replaced with single ones.

Data point	Processing	Description	Data type
pricing_available	Enriched	Marks if the company service pricing is available online	Boolean
free_trial_available	Enriched	Marks if the company offers a free trial of their services	Boolean
demo_available	Enriched	Marks if the company offers a demo	Boolean
is_downloadable	Enriched	Marks if the company offers a downloadable file/service	Boolean
mobile_apps_exist	Enriched	Marks if the company has mobile apps for their service	Boolean
online_reviews_exist	Enriched	Marks if the company has any online reviews	Boolean
api_docs_exist	Enriched	Marks if the company has API docs published	Boolean

Data point	Enriching action
pricing_available free_trial_available demo_available is_downloadable mobile_apps_exist online_reviews_exist api_docs_exist	Information taken from the official company website.

Data point	Processing	Description	Data type
company_phone_numbers	Enriched	Publicly available company phone number	Array of strings
company_emails	Enriched	Publicly available company email address	Array of strings

Data point	Enriching action
company_phone_numbers company_emails	Information taken from the official company website.

Data point	Processing	Description	Data type
company_websites_main_original	Raw	Company website	String
company_websites_main	Enriched	Cleaned and resolved website URL	String
company_websites_facebook	Enriched	Facebook profile URL	String
company_websites_twitter	Enriched	Twitter profile URL	String
company_websites_linkedin	Raw	Company LinkedIn profile URL	String
company_websites_linkedin_ canonical	Raw	Canonical LinkedIn profile URL	String
company_social_discord_urls	Enriched	Discord channel URL	Array of strings
company_social_facebook_urls	Enriched	Facebook profile URL	Array of strings
company_social_instagram_urls	Enriched	Instagram profile URL	Array of strings
company_social_linkedin_urls	Enriched	Company LinkedIn profile URL	Array of strings
company_social_pinterest_urls	Enriched	Pinterest profile URL	Array of strings
company_social_tiktok_urls	Enriched	TikTok profile URL	Array of strings
company_social_twitter_urls	Enriched	Twitter profile URL	Array of strings
company_social_x_urls	Enriched	X profile URL	Array of strings
company_social_youtube_urls	Enriched	YouTube channel/profile URL	Array of strings
company_social_github_urls	Enriched	Github page/profile URL	Array of strings
company_social_reddit_urls	Enriched	Reddit profile URL	Array of strings

Data point	Cleaning/enriching action
company_websites_main	Every company_website_main_original URL is resolved; Each URL we collect is parsed, parameters are removed and added to the company_websites_main column; Expired domains are removed; Additional enrichment actions are completed
company_websites_twitter	If <domain> (from company_websites_main) == twitter, we move the URL value to company_websites_twitter.
company_websites_facebook	If <domain> (from company_websites_main) == facebook, we move the URL value to company_websites_facebook.
company_websites_linkedin	If <domain> (from company_websites_main) == linkedin, we move the URL value to company_websites_linkedin.
company_social_discord_urls company_social_facebook_urls company_social_instagram_urls company_social_linkedin_urls company_social_pinterest_urls company_social_tiktok_urls company_social_twitter_urls company_social_x_urls company_social_youtube_urls company_social_github_urls company_social_reddit_urls	URLs taken from the official company website.

Data point	Processing	Description	Data type
company_location_hq_country	Cleaned	Headquarters country	String
company_location_hq_raw_address	Cleaned	Detailed company location	String
company_location_hq_regions	Enriched	Geographical region(s) the company is associated with based on the company_location_hq_country value.	String
company_locations_full	Raw	Full company location information	Array of objects
location_address	Raw	Company HQ location	String
is_primary	Raw	Marks if the listed location is the primary	Boolean

Data point	Cleaning action
location_hq_country	Values ["None"; "Unknown"; "NaN"; "nan"; "na"; "null"; "Null"; "NULL"; "-"; "--"] are replaced with value None.
location_hq_raw_address	Values ["None"; "Unknown"; "NaN"; "nan"; "na"; "null"; "Null"; "NULL"; "-"; "--"] are replaced with value None; Special trailing characters trimmed;  Value company_location_hq_country added to the end of the string (separated by a comma).

Data point	Processing	Description	Data type
company_funding_rounds		Funding round details	Array of objects
last_round_investors_count	Cleaned	The number of investors that participated in the last funding round	Number (integer)
total_rounds_count	Cleaned	Total number of funding rounds	Number (integer)
last_round_type	Cleaned	Last funding round type	String
last_round_date	Cleaned	Last funding round date	String
last_round_money_raised	Cleaned	Total funds raised	number (integer)
financial_website_url	Raw	Financial website URL of the last funding round	String

Data point	Cleaning action
location_hq_country	Values ["None"; "Unknown"; "NaN"; "nan"; "na"; "null"; "Null"; "NULL"; "-"; "--"] are replaced with value None.
location_hq_raw_address	Values ["None"; "Unknown"; "NaN"; "nan"; "na"; "null"; "Null"; "NULL"; "-"; "--"] are replaced with value None; Special trailing characters trimmed;  Value company_location_hq_country added to the end of the string (separated by a comma).

Data point	Processing	Description	Data type
company_technologies	Enriched	Technologies used by the company	Array of structs
technology	Enriched	Technology name	String
first_verified_at	Enriched	Date this technology was first assigned to the company. Date format: YYYY-MM-DD	String (date)
last_verified_at	Enriched	Date this technology was last assigned to the company. Date format: YYYY-MM-DD	String (date)

Data point	Enriching action
company_technologies	Enriched by our ML model from multiple sources.

Data point	Processing	Description	Data type
expired_domain	Enriched	Indicates that the company_websites_main_original URL redirects to a domain dealer	Boolean
unique_subdomain	Enriched	Indicates that only the record company owns the subdomain	Boolean
unique_domain	Enriched	Indicates that only this company has the right to have this unique domain, e.g., company_websites_main: https://ibm.com	Boolean
unique_website	Enriched	Indicates that only this company has a unique website but not necessarily a unique domain, e.g., company_websites_main: https://ibm.com/generation	Boolean

Data point	Processing	Description	Data type
company_updates		Company posts and related details	Array of objects
urn	Raw	String-based identifier	String
followers	Raw	Number of followers	String
date	Raw	Post publish date (e.g., 1 month ago)	String
description	Raw	Published text Note: may contain control characters	String
reactions_count	Raw	Number of reactions on the post	Integer
comments_count	Raw	Number of comments on the post	Integer
reshared_post_author	Raw	Reshared post author	String
reshared_post_author_url	Raw	Author's profile URL	String
reshared_post_author_headline	Raw	Author's headline	String
reshared_post_description	Raw	Reshared post text	String
reshared_post_followers	Raw	The number of followers of the reshared post author	Integer
reshared_post_date	Raw	Date the reshared post was published (e.g., 1 month ago)	String

Updated 25 Mar 2025

Did this page help you?

Clean Company Data

Base Company Data

Dictionary: Clean Company Data

Request access to our full documentation

Metadata

Data sample

Cleaning actions

Identifiers

Data sample

Cleaning and enriching actions

Firmographics

Data sample

Cleaning and enriching actions

Product and services overview

Data sample

Enriching actions

Contact information

Data sample

Enriching actions

Social media and websites

Data sample

Cleaning and enriching actions

Location

Data sample

Cleaning actions

Funding information

Data sample

Cleaning actions

Technologies

Data sample

Enriching actions

Supporting fields

Data sample

Company updates

Data sample