Skip to main content

​
People + Companies

The people_companies view combines every contact record with its associated company firmographic data in a single flat table. No joins required — just query directly.

​
What’s included

This view is equivalent to: 
SELECT c.*, co.*
FROM contacts c
LEFT JOIN companies co ON c.company_id = co.company_id
Every contact field plus every company field, joined for you.
MetricValue
Total recordsTODO (one row per contact)
Primary keycontact_id
Source tablescontacts LEFT JOIN companies

​
Data dictionary & fill rates

​
Contact fields

FieldTypeFill rateDescription
contact_idVARCHAR100%Unique contact identifier
first_nameVARCHARTODO%First name
last_nameVARCHARTODO%Last name
emailVARCHARTODO%Primary email address
email_verifiedBOOLEANTODO%Whether the email passed verification
verification_statusVARCHARTODO%valid, invalid, catch_all, unknown, disposable
last_verified_atTIMESTAMPTODO%When the email was last verified
titleVARCHARTODO%Job title
seniority_levelVARCHARTODO%c_suite, vp, director, manager, senior, entry
departmentVARCHARTODO%Functional department
direct_phoneVARCHARTODO%Direct phone number
mobile_phoneVARCHARTODO%Mobile phone number
linkedin_urlVARCHARTODO%LinkedIn profile URL
location_cityVARCHARTODO%Contact’s city
location_stateVARCHARTODO%Contact’s state/province
location_countryVARCHARTODO%Contact’s country

​
Company fields

FieldTypeFill rateDescription
company_idVARCHARTODO%Company identifier (NULL if no company match)
company_nameVARCHARTODO%Company name
domainVARCHARTODO%Company primary domain
industryVARCHARTODO%Industry
sub_industryVARCHARTODO%Sub-industry / vertical
employee_countINTEGERTODO%Estimated employee count
employee_rangeVARCHARTODO%Employee range bucket
revenue_estimateFLOATTODO%Estimated annual revenue (USD)
revenue_rangeVARCHARTODO%Revenue range bucket
hq_cityVARCHARTODO%HQ city
hq_stateVARCHARTODO%HQ state/province
hq_countryVARCHARTODO%HQ country
founded_yearINTEGERTODO%Year founded
company_typeVARCHARTODO%public, private, nonprofit, etc.
tech_stackARRAYTODO%Detected technologies
Since this is a LEFT JOIN from contacts, every contact appears even if they don’t have a matched company. Company fields will be NULL for unmatched contacts.

​
Example queries

​
Prospect list — no joins needed

SELECT
    first_name,
    last_name,
    email,
    title,
    company_name,
    industry,
    employee_count,
    hq_state
FROM people_companies
WHERE email_verified = TRUE
  AND verification_status = 'valid'
  AND seniority_level IN ('vp', 'director', 'c_suite')
  AND industry = 'Software'
  AND employee_count BETWEEN 100 AND 1000
  AND hq_country = 'US'
ORDER BY last_verified_at DESC
LIMIT 500;

​
Export for a campaign

SELECT
    first_name,
    last_name,
    email,
    title,
    company_name,
    employee_range,
    industry,
    hq_city,
    hq_state
FROM people_companies
WHERE email_verified = TRUE
  AND department = 'marketing'
  AND employee_count >= 200
  AND last_verified_at >= DATEADD(day, -30, CURRENT_DATE())
ORDER BY company_name, last_name;