Skip to main content
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 pre-joined table combines person and company data. No joins needed — query directly from the table. Every person field plus every company field, already joined for you.
MetricValue
Total recordsOne row per contact (see Contacts for counts)
Primary keyRBID_PAO
Source tablesPER_LATEST LEFT JOIN ORG_LATEST on RBID_ORG

​
Data dictionary

Field names, descriptions, and examples are sourced from the Contacts and Companies table pages. This pre-joined table includes all person fields (suffix _PER) and all company fields (suffix _ORG).

​
Identifiers

FieldDescriptionExample
RBID_PERRevenueBase’s unique identification for the person. The RBID stays the same if someone changes their job.rb-pabq6o2xf
RBID_ORGRevenueBase’s unique identifier for a companyrb-oab75n3pe
RBID_PAORevenueBase’s unique identifier for the person at a specific company.Revenue Base Internal field

​
Person fields

FieldDescriptionExample
FIRST_NAME_PERThe person’s first nameMarc
LAST_NAME_PERThe person’s last nameRojas
FULL_NAME_PERThe person’s full nameKathryn E. Gibson
MIDDLE_NAME_PERThe person’s middle nameF.
TITLE_NAME_PERThe person’s name prefixDr.
SUFFIX_NAME_PERThe person’s name suffixPh. D
EMAIL_ADDRESS_PERThe person’s work email addresskcollins@fortmckaygroup.com
EMAIL_DOMAIN_PERThe domain of the person’s work email addressfortmckaygroup.com
EMAIL_STATUS_PERThe verification status of the email.VALID, NOT AVAILABLE, LIMITED INFO
EMAIL_LAST_VERIFIED_AT_PERThe contact’s email last verified timestamp. Timestamp specifically designed to indicate last revalidation of email at RevenueBase side2013-01-01 00:00:00
HAS_EMAIL_PERIf the person has a valid emailtrue
DIRECT_PHONE_PERThe direct office contact number+1 612-876-4679
CELLPHONE_PERMobile phone number+1 352-359-7618
HAS_PHONE_PERIf the person has a valid direct phone numbertrue
HAS_CELLPHONE_PERIf the person has a valid mobile phone numbertrue
JOB_TITLE_PERThe person’s current job titleSenior Technical Consultant
JOB_LEVEL_PERThe seniority level of the person’s jobManager
JOB_FUNCTION_PERThe department that the person works in.Information Technology
JOB_DESCRIPTION_PERThe description of the person’s current jobFinancial analysts,tax analysts,account payable
JOB_IS_CURRENT_PERIndicates whether the job is currently activeTRUE
JOB_START_DATE_PERWhen the person began their job2013-01-01 00:00:00
JOB_COUNT_PERThe number of jobs a person has had4
JOB_LOCATION_CITY_PERThe city in where the person worksNew York
JOB_LOCATION_STATE_PERName of State or Province of the country that the person is locatedNew York
JOB_LOCATION_COUNTRY_PERThe country name where the person worksSouth Africa
JOB_LOCATION_COUNTRY_CODE_PERThe country code where the person worksZA
JOB_LOCATION_CONTINENT_PERThe continent where the person worksNorth America
JOB_LOCATION_COUNTRY_REGION_PERThe geographic region that a contact works inEMEA
JOB_ORG_LINKEDIN_URLThe company’s LInkedin URLhttps://www.linkedin.com/company/abbott-
CITY_PERThe city where the person livesLexington
STATE_NAME_PERThe state/province/region of the country that the person is located inDistrict of Columbia
STATE_CODE_PERThe abbreviation of the state/province/region of the country that the person is located inDC
COUNTRY_NAME_PERThe name of the country the person is located inUnited States
COUNTRY_CODE_PERThe code for the country the person is located inUS
CONTINENT_PERThe continent that the person is located inNorth America
COUNTRY_REGION_PERThe global region that the person is located inNORAM
LINKEDIN_URL_PERThe person’s linkedin URLhttps://www.linkedin.com/in/simon%c3%a9-burger-ca-sa-0a3a13158
LINKEDIN_HEADLINE_PERThe person’s Linkedin headlineSales Executive, Rapid Diagnostics, Abbott
LINKEDIN_INDUSTRY_PERThe Linkedin industry associated with the person’s employerInformation Technology & Services
LOGO_URLThe person’s linkedin profile picture URLhttps://us.cdn.com/ca-sa-0a3a13158
ABOUT_ME_PERLinkedin personal profile about me fieldExperienced Transportation Security Officer with a demonstrated history of working in the government administration industry. Skilled in Negotiation, Team Building, Public Speaking, Management, and Marketing. Strong military and protective services professional with a Doctor of Philosophy - PhD focused in Public Service Leadership Emergency Management from Capella University.
EDUCATION_PERThe person’s education[ { ""degree"": ""Bachelor’s degree, Biology"", ""end_date"": ""2003-01-01"", ""organization"": ""Louis Pasteur University Strasbourg"", ""start_date"": ""1999-01-01"" }, { ""degree"": ""Ph.D, Biochemistry"", ""description"": ""Advisor: Daniel Kern
Thesis title: New insights in tRNA-dependent asparagine biosynthesis."", ""end_date"": ""2008-01-01"", ""organization"": ""Molecular and Cellular Biology Institute (IBMC)"", ""start_date"": ""2004-01-01"" }, { ""degree"": ""Master’s degree, Biochemistry"", ""description"": ""I discovered a new type of ribonucleoprotein involved in amino acid biosynthesis in bacteria and archea."", ""end_date"": ""2004-01-01"", ""organization"": ""Louis Pasteur University Strasbourg"", ""start_date"": ""2003-01-01"" }]
CERTIFICATIONS_PERLinkedin personal profile certifications[ { ""authority"": ""Capella University"", ""linkedin_url"": ""https://www.linkedin.com/company/capella-university"", ""name"": ""Doctoral Candidate"", ""start_date"": ""2021-03-01"" }]
SKILLS_PERThe person’s job skills[ ""media tours"", ""microsoft office"", ""research"", ""photoshop"", ""photography"", ""media production"", ""social media"", ""microsoft excel"", ""safety training"", ""microsoft word"", ""hostile environment safety"", ""journalism"", ""powerpoint"", ""first aid"", ""public speaking"", ""leadership"" ]
LANGUAGES_PERThe languages spoken[ { ""language"": ""english"", ""proficiency"": ""native or bilingual proficiency"" }, { ""language"": ""german"", ""proficiency"": ""limited working proficiency"" }]
INTERESTS_PERLinkedin personal profile interests field[ ""Playing Music"" ]
PATENTS_PERAny patents listed on someone’s Linkedin profile[ { ""title"": ""Tagged Credit Profile System For Credit Applicants"", ""url"": ""https://patents.google.com/patent/US20090327120A1/&urlhash=H5PF&trk=public_profile_patent-title"" }, { ""date"": ""2004-07-01"", ""title"": ""On-line Distribution Of Per-use Media With Flexible Purchase Options"", ""url"": ""http://www.google.com/patents/US20050027616&urlhash=HU_b&trk=public_profile_patent-title"" }]
PUBLICATIONS_PERAny publications listed on someone’s Linkedin profile[ { ""date"": ""2018-07-01"", ""title"": ""Impact Des Assistantes Humanitaire Sur L’attentisme De Déplace Interne Dela Rdc"" }]
PERSONA_PERClassification of person job type by several business areasSales Engineer/Solution Architect, Information Technology
WEBSITES_PERThe contact’s personal website[ { ""url"": ""http://www.dollerhide.com"" }, { ""url"": ""http://dollerhide.blogspot.com/"" } ]
UPDATED_AT_PERThe contact’s last update timestamp. Any field update (except email and phone related fields) will trigger a change in this value. LinkedIn successful profile revalidation (even with no updates) will also update this timestamp2013-01-01 00:00:00
REVENUEBASE_CONTACT_VERIFICATION_SUMMARYVerification Summary showing details on a record observed specifing when and how it was verifiedVerified by RevenueBase | Experience last observed on LinkedIn on September 7, 2025: Proposal Manager at Metaphase | Profile: linkedin.com/in/jamie-gregory-28878356 | Email last verified on October 15, 2025 via RevenueBase’s Email Verification Tool | Next verification scheduled: November, 2025 | Learn more at https://revenuebase.ai/verified-by-revenuebase

​
Company fields

FieldDescriptionExample
COMPANY_NAME_ORGName of the organizationDell Technologies
DOMAIN_ORGDoman of the company’s websitefsiservices.com
WEBSITE_ORGCompany URLhttps://www.fsiservices.com
ABOUT_US_ORGDescription of the companyUpstream Fullvision is a full service design firm in Honolulu Hawaii. Specializing in homes and small business design, 3D rendering/virtual tour, graphic design and beyond. Upstream Fullvision will provide the best service to turn your concept into reality.
FOUNDED_ORGYear of the company’s founding1997
COMPANY_ENTITY_TYPELegal entity type of the companyPrivately Held
COMPANY_LEGAL_TYPELegal type of the company[ ""Corporation"" ]
COMPANY_NAME_LANGUAGEThe language the name of the organization is writtenen
EMPLOYEE_COUNT_MAXMaximum number of employees10000
EMPLOYEE_COUNT_MINMinimum number of employees5001
EMPLOYEE_COUNT_RANGE_ORGRange of employee count5001 to 10000
EMPLOYEE_PROFILES_ON_LINKEDIN_ORGNumber of employee profiles in LinkedIn7196
LINKEDIN_INDUSTRY_ORGIndustry description from LinkedIn[ ""Software Development"" ]
INDUSTRY_NAICS_CODE_ORGNAICS Code[ ""484121"", ""541512"", ""541511"", ""561499"" ]
INDUSTRY_NAICS_DESCRIPTION_ORGNAICS Description[ ""General Freight Trucking, Long-Distance, Truckload"", ""Computer Systems Design Services"", ""Custom Computer Programming Services"", ""All Other Business Support Services"" ]
INDUSTRY_SIC_CODE_ORGStandard Industrial Classification code[ ""7373"" ]
INDUSTRY_SIC_DESCRIPTION_ORGStandard Industrial classification description[ ""Computer systems design"" ]
IS_LINKEDIN_URL_CLAIMED_ORGIndicates if the LinkedIN URL IS claimed by the companyTRUE
IS_WEBSITE_FOR_SALE_ORGIndicates if the website is listed for saleFALSE
LINKEDIN_FOLLOWERSNumber of LinkedIn followers for the company2039
LINKEDIN_URL_ORGLinkedIn URL for the companyhttps://www.linkedin.com/company/champify-data
LINKEDIN_URL_IDLinkedIn unique identified for the company76647045
SPECIALTIES_ORGSpecialties or key areas of focus of the company[ ""technology"", ""education and implementation"", ""data synchornization"", ""product data management"", ""advisory services"", ""innovation"", ""data quality analytics"" ]
REVENUE_MAXMaximum revenue of the company9999999
REVENUE_MINMinimum revenue of the company1000000
REVENUE_RANGE_ORGRange of the company’s revenue$50M to <$100M
PHONE_ORGContact phone number for the company+1 972-577-0000
LOCATION_CITYCity where the company is locatedNew York
LOCATION_STATE_NAME_PERState name of the company locationCalifornia
LOCATION_STATE_CODE_PERState code of the company locationCA
LOCATION_POSTCODE_PERPostal code of the company location94612
LOCATION_STREET_PERStreet address of the company location2440 Sand Hill Rd 300
LOCATION_COUNTRY_NAME_PERCountry name of the company locationUnited States
LOCATION_COUNTRY_CODE_PERCountry code of the locationUS
LOCATION_COUNTRY_REGION_PERRegion of the company locationNORAM
LOCATION_CONTINENTContinent of the company locationNorth America
LOCATION_COUNT_ORGNumber of locations associated with the company1
LOCATION_IS_PRIMARYIndicates if the location is the primary oneTRUE
HEADQUARTERS_CITY_ORGCity where the company HQ is locatedNew York
HEADQUARTERS_STATE_NAME_ORGState where the company HQ is locatedNY
HEADQUARTERS_COUNTRY_NAME_ORGCountry where the company HQ is locatedUnited States
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_ADDRESS,
    JOB_TITLE,
    COMPANY_NAME_ORG,
    LINKEDIN_INDUSTRY_ORG,
    EMPLOYEE_COUNT_MAX_ORG,
    HEADQUARTERS_STATE_NAME_ORG
FROM RELEASES.RELEASE.VELOCITY_BASE_UNLIMITED_LATEST
WHERE JOB_LEVEL IN ('VP', 'Director', 'C-Suite')
  AND LINKEDIN_INDUSTRY_ORG LIKE '%Software%'
  AND EMPLOYEE_COUNT_MAX_ORG BETWEEN 100 AND 1000
  AND HEADQUARTERS_COUNTRY_NAME_ORG = 'United States'
ORDER BY EMAIL_LAST_VERIFIED_AT DESC
LIMIT 500;

​
Export for a campaign

SELECT
    FIRST_NAME,
    LAST_NAME,
    EMAIL_ADDRESS,
    JOB_TITLE,
    COMPANY_NAME_ORG,
    EMPLOYEE_COUNT_RANGE_ORG,
    LINKEDIN_INDUSTRY_ORG,
    HEADQUARTERS_CITY_ORG,
    HEADQUARTERS_STATE_NAME_ORG
FROM RELEASES.RELEASE.VELOCITY_BASE_UNLIMITED_LATEST
WHERE JOB_FUNCTION = 'Marketing'
  AND EMPLOYEE_COUNT_MAX_ORG >= 200
  AND EMAIL_LAST_VERIFIED_AT >= DATEADD(day, -30, CURRENT_DATE())
ORDER BY COMPANY_NAME_ORG, LAST_NAME;