Skip to main content
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. Name: companies
Grant access to the Snowflake 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

ColumnDescription
entity_typeInternal identifier for the entity type
idThe company’s unique identifier
nameThe company’s name
domainThe company’s primary domain
domainsAll of the company’s domains
is_globalWhether or not the company is tenant specific
custom_fieldsCustom field values associated with the company
last_updated_atTimestamp when this record was last updated

​
Enrichment Fields

These columns contain data from Affinity Enrichment, third-party integrations, and other dynamic data sources.
ColumnDescription
source_of_introductionHow this company was introduced/sourced
slack_channelAssociated Slack channel
ms_teams_channelAssociated Microsoft Teams channel
affinity_data_descriptionCompany description from Affinity Data
affinity_data_number_of_employeesNumber of employees
affinity_data_industryIndustry classification
affinity_data_investment_stageInvestment/funding stage
affinity_data_investorsList of investors
affinity_data_last_funding_amountMost recent funding round amount (USD)
affinity_data_last_funding_dateDate of last funding round
affinity_data_locationCompany location (structured: city, state, country)
affinity_data_total_funding_amountTotal funding raised (USD)
affinity_data_year_foundedYear company was founded
affinity_data_keywordsCompany keywords
affinity_data_linkedin_urlLinkedIn company page URL
affinity_data_linkedin_headcountEmployee count from LinkedIn
dealroom_urlDealroom profile URL
dealroom_corporate_industriesCorporate industry tags
dealroom_service_industriesService industry tags
dealroom_technologiesTechnology stack tags
dealroom_income_streamsRevenue/income stream types
dealroom_business_modelsBusiness model classification
dealroom_ownership_typesOwnership structure type
dealroom_alexa_rankAlexa rank (Deprecated)
dealroom_employee_count_rangeEmployee count range
dealroom_super_founderSuper founder indicator
dealroom_similarweb_visits_last_monthSimilarWeb visits last month (Deprecated)
dealroom_current_job_openingsCurrent job openings
dealroom_total_tweetsTotal Twitter/X posts
dealroom_twitter_followers_change_last_monthFollower growth (last 30 days)
dealroom_twitter_favorites_last_monthTweet likes received (last 30 days)
dealroom_sustainable_developmentSustainable development indicator
dealroom_latest_revenueLatest revenue
dealroom_latest_ebitdaLatest EBITDA
dealroom_similarweb_total_ios_downloadsSimilarWeb total iOS downloads (Deprecated)
dealroom_similarweb_total_android_downloadsSimilarWeb total Android downloads (Deprecated)
dealroom_number_of_employeesEmployee count from Dealroom
dealroom_locationLocation from Dealroom
dealroom_client_focusB2B/B2C/B2G client focus
dealroom_has_exceptional_founderHas exceptional founder indicator
dealroom_has_strong_founderHas strong founder indicator
dealroom_company_statusCompany status
dealroom_last_updatedLast updated timestamp
dealroom_team_membersTeam members
dealroom_investorsInvestors
dealroom_last_funding_valuation_eurLast funding valuation (EUR)
dealroom_last_funding_dateLast funding date
dealroom_last_funding_investorsLast funding investors
dealroom_latest_revenue_update_dateLatest revenue update date
dealroom_core_side_valueCore side value
dealroom_similarweb_ios_incremental_downloadsSimilarWeb iOS incremental downloads (Deprecated)
dealroom_similarweb_android_incremental_downloadsSimilarWeb Android incremental downloads (Deprecated)
dealroom_tech_stackTechnology stack
dealroom_descriptionCompany description
dealroom_industryPrimary industry
dealroom_year_foundedYear founded
dealroom_total_funding_amountTotal funding (EUR)
dealroom_last_funding_amountLast funding round (EUR)
dealroom_foundersFounders
dealroom_twitter_followers_last_monthTwitter follower count
affinity_data_employee_departures_last_3_monthsEmployee departures in last 3 months
affinity_data_employee_departures_last_3_months_numberNumber of employee departures in last 3 months
affinity_data_employee_departures_last_3_months_percentagePercentage of employee departures in last 3 months
affinity_data_employee_departures_last_3_months_leadershipLeadership departures in last 3 months
affinity_data_employee_hires_last_3_monthsEmployee hires in last 3 months
affinity_data_employee_hires_last_3_months_numberNumber of employee hires in last 3 months
affinity_data_employee_hires_last_3_months_percentagePercentage of employee hires in last 3 months
affinity_data_employee_hires_last_3_months_leadershipLeadership hires in last 3 months
affinity_data_employees_currentCurrent employee count
affinity_data_employees_1_month_agoEmployee count 1 month ago
affinity_data_employees_3_months_agoEmployee count 3 months ago
affinity_data_employees_6_months_agoEmployee count 6 months ago
affinity_data_employees_12_months_agoEmployee count 12 months ago
affinity_data_employees_24_months_agoEmployee count 24 months ago
affinity_data_employees_growth_mom_percentageEmployee growth month-over-month percentage
affinity_data_employees_growth_qoq_percentageEmployee growth quarter-over-quarter percentage
affinity_data_employees_growth_yoy_percentageEmployee growth year-over-year percentage
affinity_data_founders_ceosFounders and CEOs
affinity_data_linkedin_profile_founders_ceosLinkedIn profiles of founders and CEOs