> ## Documentation Index > Fetch the complete documentation index at: https://docs.revenuebase.ai/llms.txt > Use this file to discover all available pages before exploring further. # Data Dictionary > A complete field-level reference for every column in RevenueBase. Covers the PER_LATEST, ORG_LATEST, INSIGHTS_LATEST, VELOCITY_BASE_UNLIMITED_LATEST, and VELOCITY_ENHANCED_UNLIMITED_LATEST tables. The `PER_LATEST` table contains one row per person. All fields appear without a table suffix. | Gigasheet label | Field | Description | Type | | ---------------------------------------- | ------------------------------------------ | ------------------------------------------------------------------------------------------ | --------- | | About Me | `ABOUT_ME` | LinkedIn personal profile about me field | Text | | Cellphone | `CELLPHONE` | Mobile phone number | Text | | Certifications | `CERTIFICATIONS` | LinkedIn personal profile certifications | Variant | | Person City | `CITY` | The city where the person lives | Text | | Company Name | `COMPANY_NAME` | Name of the person's current employer | Text | | Person Continent | `CONTINENT` | The continent that the person is located in | Text | | Person Country Code | `COUNTRY_CODE` | The code for the country the person is located in | Text | | Person Country | `COUNTRY_NAME` | The name of the country the person is located in | Text | | Person Region | `COUNTRY_REGION` | The global region that the person is located in | Text | | Direct Phone | `DIRECT_PHONE` | The direct office contact number | Text | | Education | `EDUCATION` | The person's education history | Variant | | Email Address | `EMAIL_ADDRESS` | The person's work email address | Text | | Email Domain | `EMAIL_DOMAIN` | The domain of the person's work email address | Text | | Email Last Verified At | `EMAIL_LAST_VERIFIED_AT` | The contact's email last verified timestamp | Timestamp | | Email Status | `EMAIL_STATUS` | The verification status of the email | Text | | First Name | `FIRST_NAME` | The person's first name | Text | | Person Full Name | `FULL_NAME` | The person's full name | Text | | Interests | `INTERESTS` | LinkedIn personal profile interests field | Variant | | Job Count | `JOB_COUNT` | The number of jobs a person has had | Number | | Job Description | `JOB_DESCRIPTION` | The description of the person's current job | Text | | Job End Date | `JOB_END_DATE` | When the person ended their most recent job | Date | | Job Function | `JOB_FUNCTION` | The department that the person works in | Text | | Job is Current | `JOB_IS_CURRENT` | Indicates whether the job is currently active | Boolean | | Job Level | `JOB_LEVEL` | The seniority level of the person's job | Text | | Job Location City | `JOB_LOCATION_CITY` | The city where the person works | Text | | Job Location Continent | `JOB_LOCATION_CONTINENT` | The continent where the person works | Text | | Job Location Country | `JOB_LOCATION_COUNTRY` | The country name where the person works | Text | | Job Location Country Code | `JOB_LOCATION_COUNTRY_CODE` | The country code where the person works | Text | | Job Location Region | `JOB_LOCATION_COUNTRY_REGION` | The geographic region that a contact works in | Text | | Job Location State | `JOB_LOCATION_STATE` | State or province where the person works | Text | | Job Location State Code | `JOB_LOCATION_STATE_CODE` | State/province code where the person works | Text | | — | `JOB_ORDER_IN_PROFILE` | Position of this job in the person's LinkedIn profile | Number | | LinkedIn URL Organization | `JOB_ORG_LINKEDIN_URL` | The company's LinkedIn URL associated with the person's job | Text | | Person Job Start Date | `JOB_START_DATE` | When the person began their current job | Date | | Job Title | `JOB_TITLE` | The person's current job title | Text | | Languages | `LANGUAGES` | The languages spoken | Variant | | Last Name | `LAST_NAME` | The person's last name | Text | | LinkedIn Connections | `LINKEDIN_CONNECTIONS_COUNT` | Number of LinkedIn connections the person has | Number | | LinkedIn Headline | `LINKEDIN_HEADLINE` | The person's LinkedIn headline | Text | | LinkedIn Person Industry | `LINKEDIN_INDUSTRY` | The LinkedIn industry associated with the person's employer | Text | | — | `LINKEDIN_NUM_ID` | LinkedIn's numeric identifier for the person | Text | | LinkedIn URL Person | `LINKEDIN_URL` | The person's LinkedIn profile URL | Text | | — | `LOGO_URL` | The person's LinkedIn profile picture URL | Text | | Middle Name | `MIDDLE_NAME` | The person's middle name | Text | | — | `NICKNAME_NAME` | The person's nickname | Text | | Patents | `PATENTS` | Any patents listed on someone's LinkedIn profile | Variant | | Persona | `PERSONA` | Classification of person job type by several business areas | Text | | Publications | `PUBLICATIONS` | Any publications listed on someone's LinkedIn profile | Variant | | Rbid Person | `RBID` | RevenueBase's unique identifier for the person. Stays the same if the person changes jobs. | Text | | Rbid Organization | `RBID_ORG` | RevenueBase's unique identifier for the person's current employer | Text | | Rbid Person And Organization | `RBID_PAO` | RevenueBase's unique identifier for the person at a specific organization | Text | | RevenueBase Contact Verification Summary | `REVENUEBASE_CONTACT_VERIFICATION_SUMMARY` | Verification summary showing when and how a record was verified | Text | | Skills | `SKILLS` | The person's job skills | Variant | | Person State Code | `STATE_CODE` | The abbreviation of the state/province/region the person is located in | Text | | Person State | `STATE_NAME` | The state/province/region the person is located in | Text | | Suffix | `SUFFIX_NAME` | The person's name suffix | Text | | Prefix | `TITLE_NAME` | The person's name prefix | Text | | Person Updated At | `UPDATED_AT` | The contact's last update timestamp. Any field update triggers a change in this value. | Timestamp | | Personal Websites | `WEBSITES` | The contact's personal websites | Variant | The `ORG_LATEST` table contains one row per organization. All fields appear without a table suffix. | Gigasheet label | Field | Description | Type | | --------------------------------- | ------------------------------------------- | ----------------------------------------------------------- | ------- | | LinkedIn About Us | `ABOUT_US` | Description of the organization from LinkedIn | Text | | Crunchbase Categories | `CATEGORY_CRUNCHBASE` | Organization industry categories from Crunchbase | Variant | | G2 Categories | `CATEGORY_G2` | Organization software categories from G2 | Variant | | Company Entity Type | `COMPANY_ENTITY_TYPE` | Legal entity type of the company | Text | | Company LinkedIn Headline | `COMPANY_HEADLINE` | Company LinkedIn page headline | Text | | Company Legal Type | `COMPANY_LEGAL_TYPE` | Legal type of the company | Variant | | Company Name | `COMPANY_NAME` | Name of the company | Text | | Company Name Language | `COMPANY_NAME_LANGUAGE` | The language the company name is written in | Text | | Organization Domain | `DOMAIN` | Domain of the organization's website | Text | | Domain TLD | `DOMAIN_TLD` | Top-level domain of the organization's website | Text | | Employee Count Max | `EMPLOYEE_COUNT_MAX` | Maximum number of employees | Number | | Employee Count Min | `EMPLOYEE_COUNT_MIN` | Minimum number of employees | Number | | Employee Count Range | `EMPLOYEE_COUNT_RANGE` | Range of employee count | Text | | Employee Profiles on LinkedIn | `EMPLOYEE_PROFILES_ON_LINKEDIN` | Number of employee profiles on LinkedIn | Number | | Organization Year Founded | `FOUNDED` | Year of the organization's founding | Number | | Organization City HQ | `HEADQUARTERS_CITY` | City where the organization HQ is located | Text | | Organization Continent HQ | `HEADQUARTERS_CONTINENT` | Continent where the organization HQ is located | Text | | Organization Country Code HQ | `HEADQUARTERS_COUNTRY_CODE` | Country code where the organization HQ is located | Text | | Organization Country HQ | `HEADQUARTERS_COUNTRY_NAME` | Country where the organization HQ is located | Text | | Organization Region HQ | `HEADQUARTERS_COUNTRY_REGION` | Global region where the organization HQ is located | Text | | Organization Postcode HQ | `HEADQUARTERS_POSTCODE` | Postal code of the organization HQ | Text | | Organization State Code HQ | `HEADQUARTERS_STATE_CODE` | State code where the organization HQ is located | Text | | Organization State HQ | `HEADQUARTERS_STATE_NAME` | State where the organization HQ is located | Text | | Organization Street HQ | `HEADQUARTERS_STREET` | Street address of the organization HQ | Text | | LinkedIn Company Industry | `INDUSTRY_LINKEDIN` | Industry description from LinkedIn | Text | | Industry NAICS 2022 Code | `INDUSTRY_NAICS_2022_CODE` | NAICS 2022 industry classification code | Variant | | Industry NAICS 2022 Description | `INDUSTRY_NAICS_2022_DESCRIPTION` | NAICS 2022 industry classification description | Variant | | Industry NAICS Code | `INDUSTRY_NAICS_CODE` | NAICS industry code | Text | | Industry NAICS Description | `INDUSTRY_NAICS_DESCRIPTION` | NAICS industry description | Text | | Industry SIC Code | `INDUSTRY_SIC_CODE` | Standard Industrial Classification code | Text | | Industry SIC Description | `INDUSTRY_SIC_DESCRIPTION` | Standard Industrial Classification description | Text | | UK SIC 2007 Code | `INDUSTRY_UK_STANDARD_2007_CODE` | UK Standard Industrial Classification 2007 code | Variant | | UK SIC 2007 Description | `INDUSTRY_UK_STANDARD_2007_DESCRIPTION` | UK Standard Industrial Classification 2007 description | Variant | | Is LinkedIn URL Claimed | `IS_LINKEDIN_URL_CLAIMED` | Indicates if the LinkedIn URL is claimed by the company | Boolean | | Is Website For Sale | `IS_WEBSITE_FOR_SALE` | Indicates if the website is listed for sale | Boolean | | Is Website Working | `IS_WEBSITE_WORKING` | Indicates if the organization's website is currently active | Boolean | | — | `LINKEDIN_FOLLOWERS` | Number of LinkedIn followers for the organization | Number | | LinkedIn URL Organization | `LINKEDIN_URL` | LinkedIn URL for the organization | Text | | — | `LINKEDIN_URL_ID` | LinkedIn numeric identifier for the organization | Number | | Organization City | `LOCATION_CITY` | City of the organization's listed location | Text | | Company Continent | `LOCATION_CONTINENT` | Continent of the organization's listed location | Text | | Number Of Locations On LinkedIn | `LOCATION_COUNT` | Number of locations associated with the organization | Number | | Organization Country Code | `LOCATION_COUNTRY_CODE` | Country code of the organization's listed location | Text | | Organization Country | `LOCATION_COUNTRY_NAME` | Country name of the organization's listed location | Text | | Organization Region | `LOCATION_COUNTRY_REGION` | Region of the organization's listed location | Text | | — | `LOCATION_IS_PRIMARY` | Indicates if the location is the primary one | Boolean | | Organization Postcode | `LOCATION_POSTCODE` | Postal code of the organization's listed location | Text | | Organization State Code | `LOCATION_STATE_CODE` | State code of the organization's listed location | Text | | Organization State | `LOCATION_STATE_NAME` | State name of the organization's listed location | Text | | Organization Street | `LOCATION_STREET` | Street address of the organization's listed location | Text | | Company Logo URL | `LOGO_URL` | URL to the company logo on LinkedIn | Text | | Organization Phone | `PHONE` | Contact phone number for the organization | Text | | Predicted NAICS 2022 Code | `PREDICTED_INDUSTRY_NAICS_2022_CODE` | RevenueBase's predicted NAICS 2022 industry code | Variant | | Predicted NAICS 2022 Description | `PREDICTED_INDUSTRY_NAICS_2022_DESCRIPTION` | RevenueBase's predicted NAICS 2022 industry description | Variant | | Rbid | `RBID` | RevenueBase's unique identifier for the organization | Text | | Revenue Max | `REVENUE_MAX` | Maximum revenue of the company | Number | | Revenue Min | `REVENUE_MIN` | Minimum revenue of the company | Number | | Revenue Range | `REVENUE_RANGE` | Range of the company's revenue | Text | | LinkedIn Organization Specialties | `SPECIALTIES` | Specialties or key areas of focus of the organization | Text | | Organization Updated At | `UPDATED_AT` | The organization record's last update date | Date | | Organization Website | `WEBSITE` | Organization website URL | Text | The `INSIGHTS_LATEST` table contains one row per organization. Fields use the `_ORG` suffix. It includes firmographic identity fields (shared with `ORG_LATEST`) and Insights-specific enrichment columns. | Gigasheet label | Field | Description | Type | | ---------------------------------------- | --------------------------------------------- | ---------------------------------------------------------------------------- | ------- | | LinkedIn About Us | `ABOUT_US_ORG` | Description of the organization from LinkedIn | Text | | ABM Technographics | `ABM_TECH_ORG` | Evidence of account-based management technologies in use | Text | | Account Executive Open Roles Count | `ACCOUNT_EXECUTIVE_OPEN_ROLES_COUNT_ORG` | Number of open job postings for account executive positions | Number | | Analytics Technographics | `ANALYTICS_TECH_ORG` | Evidence of analytics technologies in use | Text | | Android Dev Role Count | `ANDROID_DEV_ROLE_COUNT_ORG` | Number of people with Android developer titles | Number | | Application Security Technographics | `APPLICATION_SECURITY_TECH_ORG` | Evidence of application security technologies in use | Text | | Appstore App Category | `APPSTORE_APP_CATEGORY_ORG` | Apple App Store classification of the organization's top app | Text | | Appstore Number Of Updates | `APPSTORE_UPDATE_COUNT_ORG` | Number of updates to the organization's top App Store app | Number | | Business Development Open Roles Count | `BUSINESS_DEVELOPMENT_OPEN_ROLES_COUNT_ORG` | Number of open job postings for business development positions | Number | | Number Of Business Development Roles | `BUSINESS_DEVELOPMENT_ROLE_COUNT_ORG` | Number of people with business development titles | Number | | Organization City | `CITY_ORG` | City of the organization's listed location | Text | | Cloud Provider Technographics | `CLOUD_PROVIDER_TECH_ORG` | Evidence of cloud providers in use | Text | | Cloud Security Technographics | `CLOUD_SECURITY_TECH_ORG` | Evidence of cloud security technologies in use | Text | | CMS Technographics | `CMS_TECH_ORG` | Evidence of content management systems in use | Text | | Company Name | `COMPANY_NAME_ORG` | Name of the company | Text | | Conversation Intelligence Technographics | `CONVERSATION_INTELLIGENCE_TECH_ORG` | Evidence of conversation intelligence technologies in use | Text | | Organization Country Code | `COUNTRY_CODE_ORG` | Country code of the organization's location | Text | | Organization Country | `COUNTRY_NAME_ORG` | Country name of the organization's location | Text | | Organization Region | `COUNTRY_REGION_ORG` | Global region of the organization's location | Text | | CRM Technographics | `CRM_TECH_ORG` | Evidence of customer relationship management technologies in use | Text | | Customer Success Open Roles Count | `CUSTOMER_SUCCESS_OPEN_ROLES_COUNT_ORG` | Number of open job postings for customer success positions | Number | | Customer Success Team Size | `CUSTOMER_SUCCESS_ROLE_COUNT_ORG` | Number of people with customer success titles | Number | | Demand Generation Open Roles Count | `DEMAND_GENERATION_OPEN_ROLES_COUNT_ORG` | Number of open job postings for demand generation positions | Number | | Development Technographics | `DEVELOPMENT_TECH_ORG` | Evidence of development technologies in use | Text | | DevOps Open Roles Count | `DEVOPS_OPEN_ROLES_COUNT_ORG` | Number of open job postings for DevOps positions | Number | | DevOps Role Team Size | `DEVOPS_ROLE_COUNT_ORG` | Number of people with DevOps titles | Number | | Organization Domain | `DOMAIN_ORG` | Domain of the organization's website | Text | | E-Commerce Platform Technographics | `E_COMMERCE_PLATFORM_TECH_ORG` | Evidence of e-commerce platform technologies in use | Text | | Email Hosting Technographics | `EMAIL_HOSTING_TECH_ORG` | Evidence of email hosting providers in use | Text | | Email Security Technographics | `EMAIL_SECURITY_TECH_ORG` | Evidence of email security technologies in use | Text | | Employee Count Range | `EMPLOYEE_COUNT_RANGE_ORG` | Range of employee count | Text | | Employee LinkedIn Percent Growth Rate | `EMPLOYEE_ON_LINKEDIN_GROWTH_RATE_ORG` | Latest month's LinkedIn employee growth rate (%) | Number | | Employee Profiles on LinkedIn | `EMPLOYEE_PROFILES_ON_LINKEDIN_ORG` | Number of employee profiles on LinkedIn | Number | | Engineer Role Team Size | `ENGINEER_ROLE_COUNT_ORG` | Number of people with engineering titles | Number | | ERP Technographics | `ERP_TECH_ORG` | Evidence of ERP technologies in use | Text | | Organization Year Founded | `FOUNDED_ORG` | Year of the organization's founding | Number | | Funding Round Number of Investors | `FUNDING_ROUND_NUMBER_OF_INVESTORS_ORG` | Number of investors in the last known funding round | Number | | GRC Open Roles Count | `GRC_OPEN_ROLES_COUNT_ORG` | Number of open job postings for governance, risk, and compliance positions | Number | | GRC Team Size | `GRC_ROLE_COUNT_ORG` | Number of people with governance, risk, and compliance titles | Number | | Organization Has CIO | `HAS_CIO_ORG` | If the business has a chief information officer | Text | | Organization Has CISO | `HAS_CISO_ORG` | If the business has a chief information security officer | Text | | Has Mobile App | `HAS_MOBILE_APP_ORG` | If the business has a Google Play or Apple App Store mobile app | Text | | Has Web App | `HAS_WEB_APP_ORG` | If the business maintains a web application | Text | | Organization City HQ | `HEADQUARTERS_CITY_ORG` | City where the organization HQ is located | Text | | Organization Country HQ | `HEADQUARTERS_COUNTRY_NAME_ORG` | Country where the organization HQ is located | Text | | Organization State HQ | `HEADQUARTERS_STATE_NAME_ORG` | State where the organization HQ is located | Text | | LinkedIn Company Industry | `INDUSTRY_LINKEDIN_ORG` | Industry description from LinkedIn | Text | | Industry NAICS Code | `INDUSTRY_NAICS_CODE_ORG` | NAICS industry code | Text | | Industry NAICS Description | `INDUSTRY_NAICS_DESCRIPTION_ORG` | NAICS industry description | Text | | Industry SIC Code | `INDUSTRY_SIC_CODE_ORG` | Standard Industrial Classification code | Text | | Industry SIC Description | `INDUSTRY_SIC_DESCRIPTION_ORG` | Standard Industrial Classification description | Text | | iOS Dev Team Size | `IOS_DEV_ROLE_COUNT_ORG` | Number of people with iOS developer titles | Number | | Is LinkedIn URL Claimed | `IS_LINKEDIN_URL_CLAIMED_ORG` | Indicates if the LinkedIn URL is claimed by the company | Boolean | | Is Website For Sale | `IS_WEBSITE_FOR_SALE_ORG` | Indicates if the website is listed for sale | Boolean | | IT Open Roles Count | `IT_OPEN_ROLES_COUNT_ORG` | Number of open job postings for IT positions | Number | | IT Role Team Size | `IT_ROLE_COUNT_ORG` | Number of people with IT titles | Number | | Last Appstore Update | `LAST_APPSTORE_UPDATE_ORG` | Date of the last update to the organization's top App Store app | Date | | Last Funding Amount | `LAST_FUNDING_AMOUNT_ORG` | The last funding amount received by the organization | Number | | Last Funding Date | `LAST_FUNDING_DATE_ORG` | The date of the last funding round | Date | | Last Funding Type | `LAST_FUNDING_TYPE_ORG` | The type of the last funding round | Text | | Last Playstore Update | `LAST_PLAYSTORE_UPDATE_ORG` | Date of the last update to the most downloaded Play Store app | Date | | Organization Lead Investors | `LEAD_INVESTORS_ORG` | Lead investors in the last known funding round | Text | | LinkedIn URL Organization | `LINKEDIN_URL_ORG` | LinkedIn URL for the organization | Text | | Company Continent | `LOCATION_CONTINENT_ORG` | Continent of the organization's listed location | Text | | Number Of Locations On LinkedIn | `LOCATION_COUNT_ORG` | Number of physical offices the organization lists | Number | | Marketing Automation Tech | `MARKETING_AUTOMATION_TECH_ORG` | Evidence of marketing automation technologies in use | Text | | Marketing Open Roles Count | `MARKETING_OPEN_ROLES_COUNT_ORG` | Number of open job postings for marketing positions | Number | | Marketing Role Team Size | `MARKETING_ROLE_COUNT_ORG` | Number of people with marketing titles | Number | | G2 Martech Categories | `MARTECH_CATEGORIES_ORG` | G2 martech sub-category | Text | | Mobile Dev Role Team Size | `MOBILE_DEV_ROLE_COUNT_ORG` | Number of people with mobile developer titles | Number | | Monthly Google Adspend Dollars | `MONTHLY_GOOGLE_ADSPEND_ORG` | Estimated monthly Google Ads budget | Number | | Monthly Organic Traffic | `MONTHLY_ORGANIC_TRAFFIC_ORG` | Estimated monthly organic search traffic | Number | | Monthly Paid Traffic | `MONTHLY_PAID_TRAFFIC_ORG` | Estimated monthly paid traffic (PPC) | Number | | Network Infrastructure Open Roles Count | `NETWORK_INFRASTRUCTURE_OPEN_ROLES_COUNT_ORG` | Number of open job postings for network infrastructure positions | Number | | Network Infrastructure Role Team Size | `NETWORK_INFRASTRUCTURE_ROLE_COUNT_ORG` | Number of people with network infrastructure titles | Number | | Operations Open Roles Count | `OPERATIONS_OPEN_ROLES_COUNT_ORG` | Number of open job postings for operations positions | Number | | Operations Role Team Size | `OPERATIONS_ROLE_COUNT_ORG` | Number of people with operations titles | Number | | Organization Phone | `PHONE_ORG` | Contact phone number for the organization | Text | | Playstore App Category | `PLAYSTORE_APP_CATEGORY_ORG` | Google Play Store classification of the top app | Text | | Playstore Download Count | `PLAYSTORE_DOWNLOAD_COUNT_ORG` | Total number of downloads for the top Play Store app | Number | | Organization Postcode | `POSTCODE_ORG` | Postal code of the organization's location | Text | | QA Role Team Size | `QA_ROLE_COUNT_ORG` | Number of people with quality assurance titles | Number | | Rbid Organization | `RBID_ORG` | RevenueBase's unique identifier for the organization | Text | | Revenue Range | `REVENUE_RANGE_ORG` | Range of the company's revenue | Text | | Sales Automation Technographics | `SALES_AUTOMATION_TECH_ORG` | Evidence of sales automation technologies in use | Text | | Sales Open Roles Count | `SALES_OPEN_ROLES_COUNT_ORG` | Number of open job postings for sales positions | Number | | Sales Team Size | `SALES_ROLE_COUNT_ORG` | Number of people with sales titles | Number | | Security Open Roles | `SECURITY_OPEN_ROLES_COUNT_ORG` | Number of open job postings for security positions | Number | | Security Team Size | `SECURITY_ROLE_COUNT_ORG` | Number of people with security titles | Number | | LinkedIn Organization Specialties | `SPECIALTIES_ORG` | Specialties or key areas of focus of the organization | Text | | Organization State Code | `STATE_CODE_ORG` | State code of the organization's location | Text | | Organization State | `STATE_NAME_ORG` | State name of the organization's location | Text | | Organization Street | `STREET_ORG` | Street address of the organization's location | Text | | Top Appstore URL | `TOP_APPLEAPPSTORE_URL_ORG` | URL of the organization's top App Store app | Text | | Top Appstore Rating | `TOP_APPSTORE_RATING_ORG` | Rating of the organization's top App Store app | Number | | Top Appstore Review Count | `TOP_APPSTORE_REVIEW_COUNT_ORG` | Total reviews for the organization's top App Store app | Number | | Top Playstore Rating | `TOP_PLAYSTORE_RATING_ORG` | Rating of the most downloaded Play Store app | Number | | Top Playstore Review Count | `TOP_PLAYSTORE_REVIEW_COUNT_ORG` | Total reviews for the most downloaded Play Store app | Number | | Top Playstore URL | `TOP_PLAYSTORE_URL_ORG` | URL of the most downloaded Play Store app | Text | | Total Funding Amount | `TOTAL_FUNDING_AMOUNT_ORG` | Total funding received to date | Number | | Total Monthly Web Traffic | `TOTAL_MONTHLY_TRAFFIC_ORG` | Estimated total monthly web traffic | Number | | Total Appstore and Play Review Count | `TOTAL_REVIEWS_ORG` | Total reviews across the top App Store and Play Store apps | Number | | Organization Updated At | `UPDATED_AT` | Date this organization record was last updated | Date | | — | `VALID_EMAIL_COUNT_ORG` | Number of people with valid email addresses associated with the organization | Number | | Organization Website | `WEBSITE_ORG` | Organization website URL | Text | The `VELOCITY_BASE_UNLIMITED_LATEST` table is a pre-joined, denormalized view combining person and organization data. Person fields use the `_PER` suffix; organization fields use the `_ORG` suffix. A small subset of fields (e.g. `EMPLOYEE_COUNT_MIN`, `LOGO_URL`) appear without a suffix. | Field | Description | Type | | ------------------------------------------ | ------------------------------------------------------------------------------------------ | --------- | | `ABOUT_ME_PER` | LinkedIn personal profile about me field | Text | | `ABOUT_US_ORG` | Description of the organization from LinkedIn | Text | | `CELLPHONE_PER` | Mobile phone number | Text | | `CERTIFICATIONS_PER` | LinkedIn personal profile certifications | Variant | | `CITY_ORG` | City of the organization's location | Text | | `CITY_PER` | The city where the person lives | Text | | `COMPANY_ENTITY_TYPE` | Legal entity type of the company | Text | | `COMPANY_HEADLINE` | Company LinkedIn page headline | Text | | `COMPANY_LEGAL_TYPE` | Legal type of the company | Variant | | `COMPANY_NAME_LANGUAGE` | The language the company name is written in | Text | | `COMPANY_NAME_ORG` | Name of the company | Text | | `CONTINENT_PER` | The continent that the person is located in | Text | | `COUNTRY_CODE_ORG` | Country code of the organization's location | Text | | `COUNTRY_CODE_PER` | The code for the country the person is located in | Text | | `COUNTRY_NAME_ORG` | Country name of the organization's location | Text | | `COUNTRY_NAME_PER` | The name of the country the person is located in | Text | | `COUNTRY_REGION_ORG` | Global region of the organization's location | Text | | `COUNTRY_REGION_PER` | The global region that the person is located in | Text | | `DIRECT_PHONE_PER` | The direct office contact number | Text | | `DOMAIN_ORG` | Domain of the organization's website | Text | | `EDUCATION_PER` | The person's education history | Variant | | `EMAIL_ADDRESS_PER` | The person's work email address | Text | | `EMAIL_DOMAIN_PER` | The domain of the person's work email address | Text | | `EMAIL_LAST_VERIFIED_AT_PER` | The contact's email last verified timestamp | Timestamp | | `EMAIL_STATUS_PER` | The verification status of the email | Text | | `EMPLOYEE_COUNT_MAX` | Maximum number of employees | Number | | `EMPLOYEE_COUNT_MIN` | Minimum number of employees | Number | | `EMPLOYEE_COUNT_RANGE_ORG` | Range of employee count | Text | | `EMPLOYEE_PROFILES_ON_LINKEDIN_ORG` | Number of employee profiles on LinkedIn | Number | | `FIRST_NAME_PER` | The person's first name | Text | | `FOUNDED_ORG` | Year of the organization's founding | Number | | `FULL_NAME_PER` | The person's full name | Text | | `HAS_CELLPHONE_PER` | If the person has a valid mobile phone number | Boolean | | `HAS_EMAIL_PER` | If the person has a valid email | Boolean | | `HAS_PHONE_PER` | If the person has a valid direct phone number | Boolean | | `HEADQUARTERS_CITY_ORG` | City where the organization HQ is located | Text | | `HEADQUARTERS_COUNTRY_NAME_ORG` | Country where the organization HQ is located | Text | | `HEADQUARTERS_STATE_NAME_ORG` | State where the organization HQ is located | Text | | `INDUSTRY_LINKEDIN_ORG` | Industry description from LinkedIn | Text | | `INDUSTRY_NAICS_CODE_ORG` | NAICS industry code | Text | | `INDUSTRY_NAICS_DESCRIPTION_ORG` | NAICS industry description | Text | | `INDUSTRY_SIC_CODE_ORG` | Standard Industrial Classification code | Text | | `INDUSTRY_SIC_DESCRIPTION_ORG` | Standard Industrial Classification description | Text | | `INTERESTS_PER` | LinkedIn personal profile interests field | Variant | | `IS_WEBSITE_FOR_SALE_ORG` | Indicates if the website is listed for sale | Boolean | | `JOB_COUNT_PER` | The number of jobs a person has had | Number | | `JOB_DESCRIPTION_PER` | The description of the person's current job | Text | | `JOB_FUNCTION_PER` | The department that the person works in | Text | | `JOB_IS_CURRENT_PER` | Indicates whether the job is currently active | Boolean | | `JOB_LEVEL_PER` | The seniority level of the person's job | Text | | `JOB_LOCATION_CITY_PER` | The city where the person works | Text | | `JOB_LOCATION_CONTINENT_PER` | The continent where the person works | Text | | `JOB_LOCATION_COUNTRY_CODE_PER` | The country code where the person works | Text | | `JOB_LOCATION_COUNTRY_PER` | The country name where the person works | Text | | `JOB_LOCATION_COUNTRY_REGION_PER` | The geographic region that a contact works in | Text | | `JOB_LOCATION_STATE_PER` | State or province where the person works | Text | | `JOB_START_DATE_PER` | When the person began their current job | Date | | `JOB_TITLE_PER` | The person's current job title | Text | | `LANGUAGES_PER` | The languages spoken | Variant | | `LAST_NAME_PER` | The person's last name | Text | | `LINKEDIN_CONNECTIONS_COUNT_PER` | Number of LinkedIn connections the person has | Number | | `LINKEDIN_HEADLINE_PER` | The person's LinkedIn headline | Text | | `LINKEDIN_INDUSTRY_PER` | The LinkedIn industry associated with the person's employer | Text | | `LINKEDIN_URL_ORG` | LinkedIn URL for the organization | Text | | `LINKEDIN_URL_PER` | The person's LinkedIn profile URL | Text | | `LOCATION_CONTINENT_ORG` | Continent of the organization's listed location | Text | | `LOCATION_COUNT_ORG` | Number of locations associated with the organization | Number | | `LOCATION_COUNTRY_CODE_PER` | Country code of the person's location address | Text | | `LOCATION_COUNTRY_NAME_PER` | Country name of the person's location address | Text | | `LOCATION_COUNTRY_REGION_PER` | Region of the person's location address | Text | | `LOCATION_POSTCODE_PER` | Postal code of the person's location address | Text | | `LOCATION_STATE_CODE_PER` | State code of the person's location address | Text | | `LOCATION_STATE_NAME_PER` | State name of the person's location address | Text | | `LOCATION_STREET_PER` | Street address of the person's location | Text | | `LOGO_URL` | The person's LinkedIn profile picture URL | Text | | `LOGO_URL_ORG` | URL to the company logo on LinkedIn | Text | | `MIDDLE_NAME_PER` | The person's middle name | Text | | `PATENTS_PER` | Any patents listed on someone's LinkedIn profile | Variant | | `PERSONA_PER` | Classification of person job type by several business areas | Text | | `PHONE_ORG` | Contact phone number for the organization | Text | | `POSTCODE_ORG` | Postal code of the organization's location | Text | | `PUBLICATIONS_PER` | Any publications listed on someone's LinkedIn profile | Variant | | `RBID_ORG` | RevenueBase's unique identifier for the organization | Text | | `RBID_PAO` | RevenueBase's unique identifier for the person at a specific organization | Text | | `RBID_PER` | RevenueBase's unique identifier for the person. Stays the same if the person changes jobs. | Text | | `REVENUEBASE_CONTACT_VERIFICATION_SUMMARY` | Verification summary showing when and how a record was verified | Text | | `REVENUE_MAX` | Maximum revenue of the company | Number | | `REVENUE_MIN` | Minimum revenue of the company | Number | | `REVENUE_RANGE_ORG` | Range of the company's revenue | Text | | `SKILLS_PER` | The person's job skills | Variant | | `SPECIALTIES_ORG` | Specialties or key areas of focus of the organization | Text | | `STATE_CODE_ORG` | State code of the organization's location | Text | | `STATE_CODE_PER` | The abbreviation of the state/province/region the person is located in | Text | | `STATE_NAME_ORG` | State name of the organization's location | Text | | `STATE_NAME_PER` | The state/province/region the person is located in | Text | | `STREET_ORG` | Street address of the organization's location | Text | | `SUFFIX_NAME_PER` | The person's name suffix | Text | | `TITLE_NAME_PER` | The person's name prefix | Text | | `UPDATED_AT_PER` | The contact's last update timestamp. Any field update triggers a change in this value. | Timestamp | | `WEBSITE_ORG` | Organization website URL | Text | | `WEBSITES_PER` | The contact's personal websites | Variant | The `VELOCITY_ENHANCED_UNLIMITED_LATEST` table combines all columns from `VELOCITY_BASE_UNLIMITED_LATEST` with the full Insights enrichment layer from `INSIGHTS_LATEST`. Person fields use the `_PER` suffix; organization fields use the `_ORG` suffix. A small subset of fields (e.g. `EMPLOYEE_COUNT_MIN`, `LOGO_URL`) appear without a suffix. | Field | Description | Type | | --------------------------------------------- | ------------------------------------------------------------------------------------------ | --------- | | `ABOUT_ME_PER` | LinkedIn personal profile about me field | Text | | `ABOUT_US_ORG` | Description of the organization from LinkedIn | Text | | `ABM_TECH_ORG` | Evidence of account-based management technologies in use | Text | | `ACCOUNT_EXECUTIVE_OPEN_ROLES_COUNT_ORG` | Number of open job postings for account executive positions | Number | | `ANALYTICS_TECH_ORG` | Evidence of analytics technologies in use | Text | | `ANDROID_DEV_ROLE_COUNT_ORG` | Number of people with Android developer titles | Number | | `APPLICATION_SECURITY_TECH_ORG` | Evidence of application security technologies in use | Text | | `APPSTORE_APP_CATEGORY_ORG` | Apple App Store classification of the organization's top app | Text | | `APPSTORE_UPDATE_COUNT_ORG` | Number of updates to the organization's top App Store app | Number | | `BUSINESS_DEVELOPMENT_OPEN_ROLES_COUNT_ORG` | Number of open job postings for business development positions | Number | | `BUSINESS_DEVELOPMENT_ROLE_COUNT_ORG` | Number of people with business development titles | Number | | `CELLPHONE_PER` | Mobile phone number | Text | | `CERTIFICATIONS_PER` | LinkedIn personal profile certifications | Variant | | `CITY_ORG` | City of the organization's location | Text | | `CITY_PER` | The city where the person lives | Text | | `CLOUD_PROVIDER_TECH_ORG` | Evidence of cloud providers in use | Text | | `CLOUD_SECURITY_TECH_ORG` | Evidence of cloud security technologies in use | Text | | `CMS_TECH_ORG` | Evidence of content management systems in use | Text | | `COMPANY_ENTITY_TYPE` | Legal entity type of the company | Text | | `COMPANY_HEADLINE` | Company LinkedIn page headline | Text | | `COMPANY_LEGAL_TYPE` | Legal type of the company | Variant | | `COMPANY_NAME_LANGUAGE` | The language the company name is written in | Text | | `COMPANY_NAME_ORG` | Name of the company | Text | | `CONTINENT_PER` | The continent that the person is located in | Text | | `CONVERSATION_INTELLIGENCE_TECH_ORG` | Evidence of conversation intelligence technologies in use | Text | | `COUNTRY_CODE_ORG` | Country code of the organization's location | Text | | `COUNTRY_CODE_PER` | The code for the country the person is located in | Text | | `COUNTRY_NAME_ORG` | Country name of the organization's location | Text | | `COUNTRY_NAME_PER` | The name of the country the person is located in | Text | | `COUNTRY_REGION_ORG` | Global region of the organization's location | Text | | `COUNTRY_REGION_PER` | The global region that the person is located in | Text | | `CRM_TECH_ORG` | Evidence of customer relationship management technologies in use | Text | | `CUSTOMER_SUCCESS_OPEN_ROLES_COUNT_ORG` | Number of open job postings for customer success positions | Number | | `CUSTOMER_SUCCESS_ROLE_COUNT_ORG` | Number of people with customer success titles | Number | | `DEMAND_GENERATION_OPEN_ROLES_COUNT_ORG` | Number of open job postings for demand generation positions | Number | | `DEVELOPMENT_TECH_ORG` | Evidence of development technologies in use | Text | | `DEVOPS_OPEN_ROLES_COUNT_ORG` | Number of open job postings for DevOps positions | Number | | `DEVOPS_ROLE_COUNT_ORG` | Number of people with DevOps titles | Number | | `DIRECT_PHONE_PER` | The direct office contact number | Text | | `DOMAIN_ORG` | Domain of the organization's website | Text | | `E_COMMERCE_PLATFORM_TECH_ORG` | Evidence of e-commerce platform technologies in use | Text | | `EDUCATION_PER` | The person's education history | Variant | | `EMAIL_ADDRESS_PER` | The person's work email address | Text | | `EMAIL_DOMAIN_PER` | The domain of the person's work email address | Text | | `EMAIL_HOSTING_TECH_ORG` | Evidence of email hosting providers in use | Text | | `EMAIL_LAST_VERIFIED_AT_PER` | The contact's email last verified timestamp | Timestamp | | `EMAIL_SECURITY_TECH_ORG` | Evidence of email security technologies in use | Text | | `EMAIL_STATUS_PER` | The verification status of the email | Text | | `EMPLOYEE_COUNT_MAX` | Maximum number of employees | Number | | `EMPLOYEE_COUNT_MIN` | Minimum number of employees | Number | | `EMPLOYEE_COUNT_RANGE_ORG` | Range of employee count | Text | | `EMPLOYEE_ON_LINKEDIN_GROWTH_RATE_ORG` | Latest month's LinkedIn employee growth rate (%) | Number | | `EMPLOYEE_PROFILES_ON_LINKEDIN_ORG` | Number of employee profiles on LinkedIn | Number | | `ENGINEER_ROLE_COUNT_ORG` | Number of people with engineering titles | Number | | `ERP_TECH_ORG` | Evidence of ERP technologies in use | Text | | `FIRST_NAME_PER` | The person's first name | Text | | `FOUNDED_ORG` | Year of the organization's founding | Number | | `FULL_NAME_PER` | The person's full name | Text | | `FUNDING_ROUND_NUMBER_OF_INVESTORS_ORG` | Number of investors in the last known funding round | Number | | `GRC_OPEN_ROLES_COUNT_ORG` | Number of open job postings for governance, risk, and compliance positions | Number | | `GRC_ROLE_COUNT_ORG` | Number of people with governance, risk, and compliance titles | Number | | `HAS_CELLPHONE_PER` | If the person has a valid mobile phone number | Boolean | | `HAS_CIO_ORG` | If the business has a chief information officer | Text | | `HAS_CISO_ORG` | If the business has a chief information security officer | Text | | `HAS_EMAIL_PER` | If the person has a valid email | Boolean | | `HAS_MOBILE_APP_ORG` | If the business has a Google Play or Apple App Store mobile app | Text | | `HAS_PHONE_PER` | If the person has a valid direct phone number | Boolean | | `HAS_WEB_APP_ORG` | If the business maintains a web application | Text | | `HEADQUARTERS_CITY_ORG` | City where the organization HQ is located | Text | | `HEADQUARTERS_COUNTRY_NAME_ORG` | Country where the organization HQ is located | Text | | `HEADQUARTERS_STATE_NAME_ORG` | State where the organization HQ is located | Text | | `INDUSTRY_LINKEDIN_ORG` | Industry description from LinkedIn | Text | | `INDUSTRY_NAICS_CODE_ORG` | NAICS industry code | Text | | `INDUSTRY_NAICS_DESCRIPTION_ORG` | NAICS industry description | Text | | `INDUSTRY_SIC_CODE_ORG` | Standard Industrial Classification code | Text | | `INDUSTRY_SIC_DESCRIPTION_ORG` | Standard Industrial Classification description | Text | | `INTERESTS_PER` | LinkedIn personal profile interests field | Variant | | `IOS_DEV_ROLE_COUNT_ORG` | Number of people with iOS developer titles | Number | | `IS_LINKEDIN_URL_CLAIMED_ORG` | Indicates if the LinkedIn URL is claimed by the company | Boolean | | `IS_WEBSITE_FOR_SALE_ORG` | Indicates if the website is listed for sale | Boolean | | `IT_OPEN_ROLES_COUNT_ORG` | Number of open job postings for IT positions | Number | | `IT_ROLE_COUNT_ORG` | Number of people with IT titles | Number | | `JOB_COUNT_PER` | The number of jobs a person has had | Number | | `JOB_DESCRIPTION_PER` | The description of the person's current job | Text | | `JOB_FUNCTION_PER` | The department that the person works in | Text | | `JOB_IS_CURRENT_PER` | Indicates whether the job is currently active | Boolean | | `JOB_LEVEL_PER` | The seniority level of the person's job | Text | | `JOB_LOCATION_CITY_PER` | The city where the person works | Text | | `JOB_LOCATION_CONTINENT_PER` | The continent where the person works | Text | | `JOB_LOCATION_COUNTRY_CODE_PER` | The country code where the person works | Text | | `JOB_LOCATION_COUNTRY_PER` | The country name where the person works | Text | | `JOB_LOCATION_COUNTRY_REGION_PER` | The geographic region that a contact works in | Text | | `JOB_LOCATION_STATE_PER` | State or province where the person works | Text | | `JOB_START_DATE_PER` | When the person began their current job | Date | | `JOB_TITLE_PER` | The person's current job title | Text | | `LANGUAGES_PER` | The languages spoken | Variant | | `LAST_APPSTORE_UPDATE_ORG` | Date of the last update to the organization's top App Store app | Date | | `LAST_FUNDING_AMOUNT_ORG` | The last funding amount received by the organization | Number | | `LAST_FUNDING_DATE_ORG` | The date of the last funding round | Date | | `LAST_FUNDING_TYPE_ORG` | The type of the last funding round | Text | | `LAST_NAME_PER` | The person's last name | Text | | `LAST_PLAYSTORE_UPDATE_ORG` | Date of the last update to the most downloaded Play Store app | Date | | `LEAD_INVESTORS_ORG` | Lead investors in the last known funding round | Text | | `LINKEDIN_CONNECTIONS_COUNT_PER` | Number of LinkedIn connections the person has | Number | | `LINKEDIN_HEADLINE_PER` | The person's LinkedIn headline | Text | | `LINKEDIN_INDUSTRY_PER` | The LinkedIn industry associated with the person's employer | Text | | `LINKEDIN_URL_ORG` | LinkedIn URL for the organization | Text | | `LINKEDIN_URL_PER` | The person's LinkedIn profile URL | Text | | `LOCATION_CONTINENT_ORG` | Continent of the organization's listed location | Text | | `LOCATION_COUNT_ORG` | Number of locations associated with the organization | Number | | `LOCATION_COUNTRY_CODE_PER` | Country code of the person's location address | Text | | `LOCATION_COUNTRY_NAME_PER` | Country name of the person's location address | Text | | `LOCATION_COUNTRY_REGION_PER` | Region of the person's location address | Text | | `LOCATION_POSTCODE_PER` | Postal code of the person's location address | Text | | `LOCATION_STATE_CODE_PER` | State code of the person's location address | Text | | `LOCATION_STATE_NAME_PER` | State name of the person's location address | Text | | `LOCATION_STREET_PER` | Street address of the person's location | Text | | `LOGO_URL` | The person's LinkedIn profile picture URL | Text | | `LOGO_URL_ORG` | URL to the company logo on LinkedIn | Text | | `MARKETING_AUTOMATION_TECH_ORG` | Evidence of marketing automation technologies in use | Text | | `MARKETING_OPEN_ROLES_COUNT_ORG` | Number of open job postings for marketing positions | Number | | `MARKETING_ROLE_COUNT_ORG` | Number of people with marketing titles | Number | | `MARTECH_CATEGORIES_ORG` | G2 martech sub-category | Text | | `MIDDLE_NAME_PER` | The person's middle name | Text | | `MOBILE_DEV_ROLE_COUNT_ORG` | Number of people with mobile developer titles | Number | | `MONTHLY_GOOGLE_ADSPEND_ORG` | Estimated monthly Google Ads budget | Number | | `MONTHLY_ORGANIC_TRAFFIC_ORG` | Estimated monthly organic search traffic | Number | | `MONTHLY_PAID_TRAFFIC_ORG` | Estimated monthly paid traffic (PPC) | Number | | `NETWORK_INFRASTRUCTURE_OPEN_ROLES_COUNT_ORG` | Number of open job postings for network infrastructure positions | Number | | `NETWORK_INFRASTRUCTURE_ROLE_COUNT_ORG` | Number of people with network infrastructure titles | Number | | `OPERATIONS_OPEN_ROLES_COUNT_ORG` | Number of open job postings for operations positions | Number | | `OPERATIONS_ROLE_COUNT_ORG` | Number of people with operations titles | Number | | `PATENTS_PER` | Any patents listed on someone's LinkedIn profile | Variant | | `PERSONA_PER` | Classification of person job type by several business areas | Text | | `PHONE_ORG` | Contact phone number for the organization | Text | | `PLAYSTORE_APP_CATEGORY_ORG` | Google Play Store classification of the top app | Text | | `PLAYSTORE_DOWNLOAD_COUNT_ORG` | Total number of downloads for the top Play Store app | Number | | `POSTCODE_ORG` | Postal code of the organization's location | Text | | `PUBLICATIONS_PER` | Any publications listed on someone's LinkedIn profile | Variant | | `QA_ROLE_COUNT_ORG` | Number of people with quality assurance titles | Number | | `RBID_ORG` | RevenueBase's unique identifier for the organization | Text | | `RBID_PAO` | RevenueBase's unique identifier for the person at a specific organization | Text | | `RBID_PER` | RevenueBase's unique identifier for the person. Stays the same if the person changes jobs. | Text | | `REVENUEBASE_CONTACT_VERIFICATION_SUMMARY` | Verification summary showing when and how a record was verified | Text | | `REVENUE_MAX` | Maximum revenue of the company | Number | | `REVENUE_MIN` | Minimum revenue of the company | Number | | `REVENUE_RANGE_ORG` | Range of the company's revenue | Text | | `SALES_AUTOMATION_TECH_ORG` | Evidence of sales automation technologies in use | Text | | `SALES_OPEN_ROLES_COUNT_ORG` | Number of open job postings for sales positions | Number | | `SALES_ROLE_COUNT_ORG` | Number of people with sales titles | Number | | `SECURITY_OPEN_ROLES_COUNT_ORG` | Number of open job postings for security positions | Number | | `SECURITY_ROLE_COUNT_ORG` | Number of people with security titles | Number | | `SKILLS_PER` | The person's job skills | Variant | | `SPECIALTIES_ORG` | Specialties or key areas of focus of the organization | Text | | `STATE_CODE_ORG` | State code of the organization's location | Text | | `STATE_CODE_PER` | The abbreviation of the state/province/region the person is located in | Text | | `STATE_NAME_ORG` | State name of the organization's location | Text | | `STATE_NAME_PER` | The state/province/region the person is located in | Text | | `STREET_ORG` | Street address of the organization's location | Text | | `SUFFIX_NAME_PER` | The person's name suffix | Text | | `TITLE_NAME_PER` | The person's name prefix | Text | | `TOP_APPLEAPPSTORE_URL_ORG` | URL of the organization's top App Store app | Text | | `TOP_APPSTORE_RATING_ORG` | Rating of the organization's top App Store app | Number | | `TOP_APPSTORE_REVIEW_COUNT_ORG` | Total reviews for the organization's top App Store app | Number | | `TOP_PLAYSTORE_RATING_ORG` | Rating of the most downloaded Play Store app | Number | | `TOP_PLAYSTORE_REVIEW_COUNT_ORG` | Total reviews for the most downloaded Play Store app | Number | | `TOP_PLAYSTORE_URL_ORG` | URL of the most downloaded Play Store app | Text | | `TOTAL_FUNDING_AMOUNT_ORG` | Total funding received to date | Number | | `TOTAL_MONTHLY_TRAFFIC_ORG` | Estimated total monthly web traffic | Number | | `TOTAL_REVIEWS_ORG` | Total reviews across the top App Store and Play Store apps | Number | | `UPDATED_AT_PER` | The contact's last update timestamp. Any field update triggers a change in this value. | Timestamp | | `WEBSITE_ORG` | Organization website URL | Text | | `WEBSITES_PER` | The contact's personal websites | Variant |