Companies

Includes data on all companies in your Affinity instance with basic metadata, Affinity Enrichment Data, Dealroom data (if enabled), and a json object that includes your global custom fields. Multi-line text values in custom_fields are truncated to the first 40,000 characters. Name: v1_0.companies

Grant access to the share only to users who are authorized to view all organization data. There are no per-user or per-role visibility filters applied at the share level.

Columns

Column	Description
`id`	The company’s unique identifier
`name`	The company’s name
`domain`	The company’s primary domain
`domains`	All of the company’s domains
`is_global`	Whether or not the company is tenant specific
`custom_fields`	Custom field values associated with the company
`is_deleted`	Whether the company has been deleted
`last_updated_at`	Timestamp when this record was last updated

Enrichment Fields

These columns contain data from Affinity Enrichment, third-party integrations, and other dynamic data sources.

Column	Description
`source_of_introduction`	How this company was introduced/sourced
`slack_channel`	Associated Slack channel
`ms_teams_channel`	Associated Microsoft Teams channel
`affinity_data_description`	Company description from Affinity Data
`affinity_data_number_of_employees`	Number of employees
`affinity_data_industry`	Industry classification
`affinity_data_investment_stage`	Investment/funding stage
`affinity_data_investors`	List of investors
`affinity_data_last_funding_amount`	Most recent funding round amount (USD)
`affinity_data_last_funding_date`	Date of last funding round
`affinity_data_location`	Company location (structured: city, state, country)
`affinity_data_total_funding_amount`	Total funding raised (USD)
`affinity_data_year_founded`	Year company was founded
`affinity_data_keywords`	Company keywords
`affinity_data_linkedin_url`	LinkedIn company page URL
`affinity_data_linkedin_headcount`	Employee count from LinkedIn
`dealroom_url`	Dealroom profile URL
`dealroom_corporate_industries`	Corporate industry tags
`dealroom_service_industries`	Service industry tags
`dealroom_technologies`	Technology stack tags
`dealroom_income_streams`	Revenue/income stream types
`dealroom_business_models`	Business model classification
`dealroom_ownership_types`	Ownership structure type
`dealroom_alexa_rank`	Alexa rank (Deprecated)
`dealroom_employee_count_range`	Employee count range
`dealroom_super_founder`	Super founder indicator
`dealroom_similarweb_visits_last_month`	SimilarWeb visits last month (Deprecated)
`dealroom_current_job_openings`	Current job openings
`dealroom_total_tweets`	Total Twitter/X posts
`dealroom_twitter_followers_change_last_month`	Follower growth (last 30 days)
`dealroom_twitter_favorites_last_month`	Tweet likes received (last 30 days)
`dealroom_sustainable_development`	Sustainable development indicator
`dealroom_latest_revenue`	Latest revenue
`dealroom_latest_ebitda`	Latest EBITDA
`dealroom_similarweb_total_ios_downloads`	SimilarWeb total iOS downloads (Deprecated)
`dealroom_similarweb_total_android_downloads`	SimilarWeb total Android downloads (Deprecated)
`dealroom_number_of_employees`	Employee count from Dealroom
`dealroom_location`	Location from Dealroom
`dealroom_client_focus`	B2B/B2C/B2G client focus
`dealroom_has_exceptional_founder`	Has exceptional founder indicator
`dealroom_has_strong_founder`	Has strong founder indicator
`dealroom_company_status`	Company status
`dealroom_last_updated`	Last updated timestamp
`dealroom_team_members`	Team members
`dealroom_investors`	Investors
`dealroom_last_funding_valuation_eur`	Last funding valuation (EUR)
`dealroom_last_funding_date`	Last funding date
`dealroom_last_funding_investors`	Last funding investors
`dealroom_latest_revenue_update_date`	Latest revenue update date
`dealroom_core_side_value`	Core side value
`dealroom_similarweb_ios_incremental_downloads`	SimilarWeb iOS incremental downloads (Deprecated)
`dealroom_similarweb_android_incremental_downloads`	SimilarWeb Android incremental downloads (Deprecated)
`dealroom_tech_stack`	Technology stack
`dealroom_description`	Company description
`dealroom_industry`	Primary industry
`dealroom_year_founded`	Year founded
`dealroom_total_funding_amount`	Total funding (EUR)
`dealroom_last_funding_amount`	Last funding round (EUR)
`dealroom_founders`	Founders
`dealroom_twitter_followers_last_month`	Twitter follower count
`affinity_data_employee_departures_last_3_months`	Employee departures in last 3 months
`affinity_data_employee_departures_last_3_months_number`	Number of employee departures in last 3 months
`affinity_data_employee_departures_last_3_months_percentage`	Percentage of employee departures in last 3 months
`affinity_data_employee_departures_last_3_months_leadership`	Leadership departures in last 3 months
`affinity_data_employee_hires_last_3_months`	Employee hires in last 3 months
`affinity_data_employee_hires_last_3_months_number`	Number of employee hires in last 3 months
`affinity_data_employee_hires_last_3_months_percentage`	Percentage of employee hires in last 3 months
`affinity_data_employee_hires_last_3_months_leadership`	Leadership hires in last 3 months
`affinity_data_employees_current`	Current employee count
`affinity_data_employees_1_month_ago`	Employee count 1 month ago
`affinity_data_employees_3_months_ago`	Employee count 3 months ago
`affinity_data_employees_6_months_ago`	Employee count 6 months ago
`affinity_data_employees_12_months_ago`	Employee count 12 months ago
`affinity_data_employees_24_months_ago`	Employee count 24 months ago
`affinity_data_employees_growth_mom_percentage`	Employee growth month-over-month percentage
`affinity_data_employees_growth_qoq_percentage`	Employee growth quarter-over-quarter percentage
`affinity_data_employees_growth_yoy_percentage`	Employee growth year-over-year percentage
`affinity_data_founders_ceos`	Founders and CEOs
`affinity_data_linkedin_profile_founders_ceos`	LinkedIn profiles of founders and CEOs

Getting Started

Example Queries

V1_0

Changelog

Columns

Enrichment Fields

​Columns

​Enrichment Fields

Columns

Enrichment Fields