This table provides a comprehensive overview of the available data assets in the Explorium AgentSource.
Each row represents a specific data field, categorized by event type and data asset, with detailed information about its purpose, structure, and accessibility.
For each field, you’ll find:
- Display Name – the user-friendly label shown in the UI
- Technical Name – the internal identifier used in the system
- Description – explanation of the field's meaning and context
- Ontology – the data format (e.g., TEXT, DATETIME, BOOLEAN)
This catalog helps users understand what data is available, how to use it, and where it fits within the partner service infrastructure.
| Data Type | Data Asset - display name | Data Asset - name | Prospect /Business | Name | Display Name | Description | Ontology |
|---|---|---|---|---|---|---|---|
| Event | Company awards | company_award | Business | award_name | Award name | Name of the award or endorsement that was given to the company. | TEXT |
| Event | Company awards | company_award | Business | awarding_body | Organisation bestowing award | Name of the institution or organisation that granted the award, accolade, or certification. | TEXT |
| Event | Company awards | company_award | Business | award_reason | Reason for award win | Text describing justification for the company receiving an award including the key criteria and accomplishments that led to the win. | TEXT |
| Event | Office closing | closing_office | Business | reason_for_closure | Reason for office closing | Text describing the reason for the office closing. | TEXT |
| Event | Office closing | closing_office | Business | event_time | News report publishing date | Date news report on company's new office was published. Formatted YYYY-MM-DD | DATETIME |
| Event | Office closing | closing_office | Business | office_location | Location of closing office | Text describing where the office is located. | TEXT |
| Event | Office closing | closing_office | Business | closure_date | Date of office closing | Date company's new office is closing. Formatted YYYY-MM-DD. | DATETIME |
| Event | Office closing | closing_office | Business | event_id | News event ID | Unique ID representing a news event. | TEXT |
| Event | Office closing | closing_office | Business | number_of_employees_affected | Number of employees impacted | Number of employees impacted by the office location closing. | NUMERIC |
| Event | Office closing | closing_office | Business | link | Link to article | Link to article announcing the company's new office closing. | URL |
| Event | Employee's workplace anniversary | prospect_job_start_anniversary | Prospect | full_name | Employee's full name | First and last names associated with the individual, appended with a space. | TEXT |
| Event | Employee's workplace anniversary | prospect_job_start_anniversary | Prospect | company_name | Workplace company name | Name of the company where the individual is employed. | TEXT |
| Event | Employee's workplace anniversary | prospect_job_start_anniversary | Prospect | years_at_company | Number of years at company | Number of years employee has been working at the company. | NUMERIC |
| Event | Employee's workplace anniversary | prospect_job_start_anniversary | Prospect | job_title | Employee's job title | Current job title listed on the employee's professional profile. | TEXT |
| Event | Employee's workplace anniversary | prospect_job_start_anniversary | Prospect | job_anniversary_date | Workplace anniversary date | Date and time the employee's anniversary data was collected by Explorium. | DATETIME |
| Event | Employee's workplace anniversary | prospect_job_start_anniversary | Prospect | event_time | Employee event timestamp | Date of employee's upcoming workplace anniversary. Formatted YYYY-MM-DD. | DATETIME |
| Event | Employee's workplace anniversary | prospect_job_start_anniversary | Prospect | linkedin_url | Employee LinkedIn URL | URL associated with the individual's LinkedIn profile. | URL |
| Event | New office | new_office | Business | purpose_of_new_office | Purpose of new office | Short description of the new office's purpose, extracted from the article. | TEXT |
| Event | New office | new_office | Business | link | Link to article | Link to article announcing the company's new office. | URL |
| Event | New office | new_office | Business | opening_date | Date of office opening | Date company's new office is planned to open. Formatted YYYY-MM-DD. | DATE |
| Event | New office | new_office | Business | event_id | News event ID | Unique ID representing a news event. | TEXT |
| Event | New office | new_office | Business | office_location | Location of new office | Text extracted from the article indicating where the new office is located. | TEXT |
| Event | New office | new_office | Business | number_of_employees | Number of employees at new office | Number of employees working from the new office's location. | NUMERIC |
| Event | New funding round | new_funding_round | Business | founding_date | Date of funding round | Date funding round took place. Formatted YYYY-MM-DD. | DATETIME |
| Event | New funding round | new_funding_round | Business | amount_raised | Amount raised in funding | Size of investment in dollars extracted from the article. | NUMERIC |
| Event | New funding round | new_funding_round | Business | link | Link to article | Link to article announcing the company's new investment. | URL |
| Event | New funding round | new_funding_round | Business | founding_stage | Funding round stage | Funding round stage extracted from the report or article. | TEXT |
| Event | New funding round | new_funding_round | Business | event_id | News event ID | Unique ID representing a news event. | TEXT |
| Event | New funding round | new_funding_round | Business | event_time | News event timestamp | Date and time the article reporting on the new funding round was collected by Explorium. | DATETIME |
| Event | New funding round | new_funding_round | Business | investors | Investors in funding round | List of investors in the funding round. | TEXT |
| Event | New funding round | new_funding_round | Business | lead_investor | Lead investor | Name of the lead investor in the funding round. | TEXT |
| Event | New product launch | new_product | Business | product_name | Name of product | Name of the company's newly announced product. | TEXT |
| Event | New product launch | new_product | Business | event_time | News report publishing date | Date news report on company's new product was published. Formatted YYYY-MM-DD | DATETIME |
| Event | New product launch | new_product | Business | event_id | News event ID | Unique ID representing a news event. | TEXT |
| Event | New product launch | new_product | Business | link | Link to article | Link to article announcing the company's new product. | URL |
| Event | New investment | new_investment | Business | investment_date | News event timestamp | Date and time the article reporting on the new investment was collected by Explorium. | DATETIME |
| Event | New investment | new_investment | Business | investment_type | Type of investment | Type of investment extracted from the report or article. | TEXT |
| Event | New investment | new_investment | Business | event_time | News report publishing date | Date news report on company's new investment was published. Formatted YYYY-MM-DD | DATETIME |
| Event | New investment | new_investment | Business | event_id | News event ID | Unique ID representing a news event. | TEXT |
| Event | New investment | new_investment | Business | investment_target | Target of investment | Text extracted from the article describing the target of the investment. | TEXT |
| Event | New investment | new_investment | Business | link | Link to article | Link to article announcing the company's new investment. | URL |
| Event | New investment | new_investment | Business | investment_amount | Amount of investment | Size of investment in dollars extracted from the article. | NUMERIC |
| Event | IPO announcement | ipo_announcement | Business | link | Link to article | Link to article announcing the company's IPO. | URL |
| Event | IPO announcement | ipo_announcement | Business | ipo_date | Date of IPO | Date and time the article reporting on the company's IPO was collected by Explorium. | DATETIME |
| Event | IPO announcement | ipo_announcement | Business | event_id | News event ID | Unique ID representing a news event. | TEXT |
| Event | IPO announcement | ipo_announcement | Business | company_name | Company name | Name of company appearing in news reports and articles. | TEXT |
| Event | IPO announcement | ipo_announcement | Business | offer_amount | Company valuation | Valuation of company at time of IPO. | NUMERIC |
| Event | IPO announcement | ipo_announcement | Business | number_of_shares | Number of issued shares | Number of shares issued at the time of IPO. | NUMERIC |
| Event | IPO announcement | ipo_announcement | Business | stock_exchange | IPO stock exchange | Stock exchange where the IPO occurred. | TEXT |
| Event | IPO announcement | ipo_announcement | Business | event_time | News event timestamp | Date and time the article reporting on the company's IPO was collected by Explorium. | DATETIME |
| Event | IPO announcement | ipo_announcement | Business | price_per_share | Price per share | Company's price per share at time of IPO. | NUMERIC |
| Event | IPO announcement | ipo_announcement | Business | ticker | Ticker | Stock symbol of the company that IPOd. | TEXT |
| Event | New partnership | new_partnership | Business | link | Link to article | Link to article announcing the company's new partnership. | URL |
| Event | New partnership | new_partnership | Business | partner_company | Name of partnering company | Name of the company's newly announced partner. | TEXT |
| Event | New partnership | new_partnership | Business | partnership_date | Date of partnership | Date company's partnership occurred. Formatted YYYY-MM-DD | DATETIME |
| Event | New partnership | new_partnership | Business | event_time | News report publishing date | Date news report on company's new partnership was published. Formatted YYYY-MM-DD | DATETIME |
| Event | New partnership | new_partnership / business_partnership | Business | purpose_of_partnership | Partnership purpose | Short description of the partnership's purpose. | TEXT |
| Event | New partnership | new_partnership | Business | event_id | News event ID | Unique ID representing a news event. | TEXT |
| Event | New executive level hires | employee_joined_company | Business | job_department | Executive's current job department | Individual's current job department, derived from their current job title. If employee change type is 'Employee left the company', value is NULL. | TEXT |
| Event | New executive level hires | employee_joined_company | Business | full_name | Executive's full name | First and last names associated with the individual, appended with a space. | TEXT |
| Event | New executive level hires | employee_joined_company | Business | job_role_title | Executive's current job title | Individual's current job title listed on their professional profile. If employee change type is 'Employee left the company', value is NULL. | TEXT |
| Event | New executive level hires | employee_joined_company | Business | event_id | Executive's event ID | Hash personal linkedin_url, change date and event type. | TEXT |
| Event | New executive level hires | employee_joined_company | Business | linkedin_url | Executive's LinkedIn URL | URL of the individual's LinkedIn profile. | URL |
| Event | Employee changed role | prospect_changed_role | Prospect | previous_job_title | Employee's previous job title | Individual's previous job title listed on their professional profile. | TEXT |
| Event | Employee changed role | prospect_changed_role | Prospect | event_time | Employee left previous role timestamp | Date and time of when individual listed on their profile that they completed their role. | DATETIME |
| Event | Employee changed role | prospect_changed_role | Prospect | current_job_title | Employee's current job title | Individual's current job title listed on their professional profile. | TEXT |
| Event | Employee changed role | prospect_changed_role | Prospect | current_company_name | Employee's current workplace | Name of the company where the individual currently works. | COMPANY |
| Event | Employee changed role | prospect_changed_role | Prospect | current_company_id | Current workplace entity ID | Explorium's 32 character unique entity ID associated with the individual's current workplace. | TEXT |
| Event | Employee changed role | prospect_changed_role | Prospect | event_id | Job change event ID | Unique ID representing a job change event. | TEXT |
| Event | Employee changed workplace | prospect_changed_company | Prospect | current_company_name | New Company Name | Name of the company where the individual currently works after the job change. | TEXT |
| Event | Employee changed workplace | prospect_changed_company | Prospect | current_company_id | New Company ID | Unique identifier of the company where the individual currently works. | TEXT |
| Event | Employee changed workplace | prospect_changed_company | Prospect | current_job_title | New Job Title | Individual's current job title at the new company. | TEXT |
| Event | Employee changed workplace | prospect_changed_company | Prospect | previous_company_name | Previous Company Name | Name of the company where the individual was previously employed. | TEXT |
| Event | Employee changed workplace | prospect_changed_company | Prospect | previous_company_id | Previous Company ID | Unique identifier of the company where the individual was previously employed. | TEXT |
| Event | Employee changed workplace | prospect_changed_company | Prospect | previous_job_title | Previous Job Title | Individual's job title before switching companies. | TEXT |
| Event | Employee changed workplace | prospect_changed_company | Prospect | event_id | Company Change Date | Date when the employee changed companies. | DATETIME |
| Event | Employee changed workplace | prospect_changed_company | Prospect | event_time | Company Change Event ID | Unique identifier for the company change event, generated based on employee details | TEXT |
| Event | Hiring (per department) | hiring | Business | location | Role location | Location of the position inferred from the available information. | TEXT |
| Event | Hiring (per department) | hiring | Business | event_id | Company hiring event ID | Unique ID representing a company hiring for a position. | TEXT |
| Event | Hiring (per department) | hiring | Business | event_time | Company published role | Date and time when company published that they are hiring for this role. When multiple roles are open in a site and department the earliest date of position opening is displayed. | TEXT |
| Event | Hiring (per department) | hiring | Business | job_count | Number of available roles | Number of open positions company is hiring for at the selected site and department. | NUMERIC |
| Event | Hiring (per department) | hiring | Business | job_titles | Job titles | List of the open position titles listed per department and site. | TEXT |
| Event | Hiring (per department) | hiring | Business | department | Department | Company department where the open positions were listed. | TEXT |
| Event | Department trend (per department) | Workforce Increase / Decrease | Business | department_change | QoQ change in department count | Quarter over quarter rate of change in the number of employees working at the selected department. Calculation: (current quarter headcount of department / prev. quarter headcount of department) * 100. | NUMERIC |
| Event | Department trend (per department) | Workforce Increase / Decrease | Business | event_time | Department event timestamp | Date and time the department change occurred. | DATE |
| Event | Department trend (per department) | Workforce Increase / Decrease | Business | event_id | Department event ID | Unique ID representing a department change event. | TEXT |
| Event | Department trend (per department) | Workforce Increase / Decrease | Business | quarter_partition | Quarter | Quarter when department change occurred. Formatted Qn-YYYY. | TEXT |
| Event | Department trend (per department) | Workforce Increase / Decrease | Business | insertion_time | Event collection timestamp | Date and time the department change was collected by Explorium. | TEXT |
| Event | Department trend (per department) | Workforce Increase / Decrease | Business | department | Department | Name of the department. | CATEGORY |
| Event | Department trend (per department) | Workforce Increase / Decrease | Business | change_type | Department trend type | Type of department change type: Increase | Decrease |
| Event | Mergers and acquisitions | merger_and_acquisitions | Business | merger_or_acquisition | Merger or acquisition | Indicates if the event is a merger or acquisition. | TEXT |
| Event | Mergers and acquisitions | merger_and_acquisitions | Business | description | Description | A summary or overview of the merger or acquisition. | TEXT |
| Event | Mergers and acquisitions | merger_and_acquisitions | Business | companies_involved | Involved companies | List of companies involved in the merger or acquisition. | TEXT |
| Event | Mergers and acquisitions | merger_and_acquisitions | Business | acquisition_price_amount | Acquisition price | Price of the acquisition, if applicable. | TEXT |
| Event | Mergers and acquisitions | merger_and_acquisitions | Business | strategic_objective | Strategic objective | Text describing the strategic objective or motivation behind the merger or acquisition. | TEXT |
| Event | Mergers and acquisitions | merger_and_acquisitions | Business | acquisition_price_currency | Acquisition currency | Currency used for the acquisition. | TEXT |
| Event | Mergers and acquisitions | merger_and_acquisitions | Business | link | Link to article | URL to article about the merger or acquisition. | URL |
| Event | Lawsuits and legal proceedings | lawsuits_and_legal_issues | Business | case_type | Legal case type | Classification of the legal case e.g. Patent infringement, Fraud, etc. | TEXT |
| Event | Lawsuits and legal proceedings | lawsuits_and_legal_issues | Business | court | Court | Court or legal body overseeing the case e.g. U.S. District Court. | TEXT |
| Event | Lawsuits and legal proceedings | lawsuits_and_legal_issues | Business | link | Link to report | Link to article or report about the legal issue. | URL |
| Event | Outages and security breaches | outages_and_security_breaches | Business | - | Type of incident | Categorization of the type of incident that occurred e.g., outage, data breach. | TEXT |
| Event | Outages and security breaches | outages_and_security_breaches | Business | - | Impacted systems | Text listing the systems that were impacted by the incident. | TEXT |
| Event | Outages and security breaches | outages_and_security_breaches | Business | - | Number of affected customers | Number of company's customers affected by the incident. | TEXT |
| Event | Outages and security breaches | outages_and_security_breaches | Business | - | Link to article | Link to article reporting the outage, security incident, or data breach. | TEXT |
| Event | Cost cutting | cost_cutting | Business | actions_taken | Cost cutting actions | A summary of the measures implemented to reduce costs. | TEXT |
| Event | Cost cutting | cost_cutting | Business | expected_savings_amount | Expected savings | Projected amount of cost savings as a result of the cost cutting measures, if appears in the text. | TEXT |
| Event | Cost cutting | cost_cutting | Business | departments_affected | Affected departments | A list of departments impacted by the cost-cutting measures. | TEXT |
| Event | Cost cutting | cost_cutting | Business | expected_savings_currency | Savings currency | Currency of the projected amount of savings resulting from the cost cutting measures. | TEXT |
| Event | Cost cutting | cost_cutting | Business | link | Link to article | Link to article reporting the cust cutting measures taken by the company. | URL |
| Enrichment | Firmographics | firmographics | Business | business_id | Explorium entity ID | Explorium's 32 character unique entity ID associated with a company's specific site, branch, or HQ. | EXPLORIUM_ID |
| Enrichment | Firmographics | firmographics | Business | ticker | Ticker symbol | A stock symbol associated with the company, that is compiled of an arrangement of characters representing publicly-traded securities on an exchange. The symbol is used to place trade orders. | TICKER |
| Enrichment | Firmographics | firmographics | Business | region_name | Region | State or region where the company's headquarters are located. Region equivalent in the UK is county or shire. | REGION |
| Enrichment | Firmographics | firmographics | Business | country_name | Country | The country where the company's headquarters are located. | COUNTRY |
| Enrichment | Firmographics | firmographics | Business | business_description | Business description | An overview or summary of the business' mission statement, offered services and general industry. | TEXT |
| Enrichment | Firmographics | firmographics | Business | sic_code | SIC code | Company's Standard Industrial Classification four-digit code. | SIC Code |
| Enrichment | Firmographics | firmographics | Business | sic_code_description | SIC code description | Description of the Company's Standard Industrial Classification four-digit code. | TEXT |
| Enrichment | Firmographics | firmographics | Business | linkedin_industry_category | LinkedIn industry category | Industry category classification the business was assigned by LinkedIn. | CATEGORY |
| Enrichment | Firmographics | firmographics | Business | naics_description | NAICS description | Description of the 2017 NAICS industry code. | TEXT |
| Enrichment | Firmographics | firmographics | Business | naics | NAICS | 2017 North American Industry Classification System code that classifies the particular organization or business. | NAICS Code |
| Enrichment | Firmographics | firmographics | Business | yearly_revenue_range | Yearly revenue range all sites | Assigned revenue range category, generated at all company sites. All company sites includes the company's headquarters and all company branches. Company revenue is measured per fiscal year. Search 'Firmographics: Yearly revenue bucket categories' in Explorium's resource center for additional information. | CATEGORY |
| Enrichment | Firmographics | firmographics | Business | number_of_employees_range | Number of employees range all sites | Value displayed is the range of the company's number of employees falls. The number of employees is the sum of employees from all company sites, including the headquarters and all of the company branches. Search 'Firmographics: number of employees bucket categories' in Explorium's resource center for additional information. | CATEGORY |
| Enrichment | Firmographics | firmographics | Business | linkedin_profile | Linkedin profile | Company's LinkedIn profile page | LINKEDIN_URL |
| Enrichment | Firmographics | firmographics | Business | website | Company website | Company's main website URL | URL |
| Enrichment | Firmographics | firmographics | Business | name | Company name | Name of the company | COMPANY |
| Enrichment | Technographics | technographics | Business | full_tech_stack | Company's full tech stack | Full list of technologies used by the company in all categories. | TEXT |
| Enrichment | Technographics | technographics | Business | full_nested_tech_stack | Company's full nested tech stack | Full nested list of technologies used by the company. | TEXT |
| Enrichment | Technographics | technographics | Business | testing_and_qa | Testing and QA tech stack | List of testing and QA technologies used by the company. | TEXT |
| Enrichment | Technographics | technographics | Business | sales | Sales tech stack | List of sales technologies used by the company. | TEXT |
| Enrichment | Technographics | technographics | Business | prog_langs_and_frameworks | Programming languages and frameworks tech stack | List of programming, languages, and frameworks technologies used by the company. | TEXT |
| Enrichment | Technographics | technographics | Business | productivity_and_operations | Productivity and operations tech stack | List of productivity and operations technologies used by the company. | TEXT |
| Enrichment | Technographics | technographics | Business | product_and_design | Product and design tech stack | List of product and design technologies used by the company. | TEXT |
| Enrichment | Technographics | technographics | Business | platform_and_storage | Platform and storage tech stack | List of platform and storage technologies used by the company. | TEXT |
| Enrichment | Technographics | technographics | Business | operations_software | Operations software tech stack | List of operations software technologies used by the company. | TEXT |
| Enrichment | Technographics | technographics | Business | operations_management | Operations management tech stack | List of operations management technologies used by the company. | TEXT |
| Enrichment | Technographics | technographics | Business | marketing | Marketing tech stack | List of marketing technologies used by the company. | TEXT |
| Enrichment | Technographics | technographics | Business | it_security | IT security tech stack | List of IT security technologies used by the company. | TEXT |
| Enrichment | Technographics | technographics | Business | it_management | IT management tech stack | List of IT management technologies used by the company. | TEXT |
| Enrichment | Technographics | technographics | Business | hr | HR tech stack | List of HR technologies used by the company. | TEXT |
| Enrichment | Technographics | technographics | Business | health_tech | Health tech tech stack | List of health tech technologies used by the company. | TEXT |
| Enrichment | Technographics | technographics | Business | finance_and_accounting | Finance and accounting tech stack | List of finance and accounting technologies used by the company. | TEXT |
| Enrichment | Technographics | technographics | Business | ecommerce | Ecommerce tech stack | List of ecommerce technologies used by the company. | TEXT |
| Enrichment | Technographics | technographics | Business | devops_and_development | Devops and development tech stack | List of devops and development technologies used by the company. | TEXT |
| Enrichment | Technographics | technographics | Business | customer_management | Customer management tech stack | List of customer management technologies used by the company. | TEXT |
| Enrichment | Technographics | technographics | Business | computer_networks | Computer networks tech stack | List of computer networks technologies used by the company. | TEXT |
| Enrichment | Technographics | technographics | Business | communications | Communications tech stack | List of communications technologies used by the company. | TEXT |
| Enrichment | Technographics | technographics | Business | collaboration | Collaboration tech stack | List of collaboration technologies used by the company. | TEXT |
| Enrichment | Technographics | technographics | Business | bi_and_analytics | Business intelligence and analytics tech stack | List of business, intelligence, and analytics technologies used by the company. | TEXT |
| Enrichment | Contact details | contacts_information | Prospect | professional_email_status | Individual's professional email validity status | Recommended validity status for the listed 'Professional email' address. Returns one of the following possible values: 'valid' emails are determined as safe to email, 'invalid' emails are addresses we recommend to erase from mailing lists, 'catch-all' emails are created as a precaution by domain owners. For recommendations on how best to use 'catch all' emails, read more on our resource center page 'Email validation: catch-all domains'. | CATEGORY |
| Enrichment | Contact details | contacts_information | Prospect | emails | Individual's emails | List of all email addresses associated with the individual labeled as a professional or personal email address. | TEXT |
| Enrichment | Contact details | contacts_information | Prospect | professions_email | Individual's professional email | Current professional email address associated with the individual | |
| Enrichment | Contact details | contacts_information | Prospect | mobile_phone | Individual's mobile phone | Individual's direct dial mobile phone number. | PHONE NUMBER |
| Enrichment | Contact details | contacts_information | Prospect | phone_numbers | Individual's phone numbers | List of all phone numbers associated with the individual. | TEXT |
| Enrichment | Professional profile: contact and workplace | profiles | Prospect | gender | Individual's gender | Gender reported by the individual on their profile. If gender is not reported on profile, returned value is 'null'. | CATEGORY |
| Enrichment | Professional profile: contact and workplace | profiles | Prospect | city | Individual's city of residence | Individual's city of residence reported on profile. | CITY |
| Enrichment | Professional profile: contact and workplace | profiles | Prospect | country_name | Individual's country of residence | Individual's country of residence reported on profile. | COUNTRY |
| Enrichment | Professional profile: contact and workplace | profiles | Prospect | region_name | Individual's State / Region of residence | Individual's state or region of residence reported on profile. | REGION |
| Enrichment | Professional profile: contact and workplace | profiles | Prospect | company_website | Individual's workplace: company website | URL to the company website belonging to the individual's workplace. | URL |
| Enrichment | Professional profile: contact and workplace | profiles | Prospect | company_linkedin | Individual's workplace: company LinkedIn url | URL to the company LinkedIn page belonging to the individual's workplace. | URL |
| Enrichment | Professional profile: contact and workplace | profiles | Prospect | Individual's LinkedIn URL | URL of the individual's LinkedIn profile. | URL | |
| Enrichment | Professional profile: contact and workplace | profiles | Prospect | age_group | Individual's age group | Individual's estimated age group. | CATEGORY |
| Enrichment | Professional profile: contact and workplace | profiles | Prospect | experience | Individual's work experience background | List of work experience background entries on the individual's profile. May include: company name, company website, job title, seniority level, role, start date, end date, and more. Includes current work experience activities if listed. | TEXT |
| Enrichment | Professional profile: contact and workplace | profiles | Prospect | education | Individual's educational background | List of educational background entries on the individual's profile. May include: institutions name, institutions website, degree category, major, start date, end date, and more. Includes current educational activities if listed. | TEXT |
| Enrichment | Professional profile: contact and workplace | profiles | Prospect | interests | Individual's interests | List of all interests reported by the individual on their profile. | TEXT |
| Enrichment | Professional profile: contact and workplace | profiles | Prospect | skills | Individual's skills | List of all skills reported by the individual on their profile. | TEXT |
| Enrichment | Professional profile: contact and workplace | profiles | Prospect | job_department | Individual's job department | Individual's job department, derived from their current job title. | CATEGORY |
| Enrichment | Professional profile: contact and workplace | profiles | Prospect | job_seniority_level | Individual's seniority level | Individual's top seniority level, derived from their current job title. | CATEGORY |
| Enrichment | Professional profile: contact and workplace | profiles | Prospect | company_name | Individual's workplace: company name | Name of the company the individual listed as their workplace. | COMPANY |
| Enrichment | Professional profile: contact and workplace | profiles | Prospect | job_title | Individual's job title | Individual's current job title listed on their professional profile. | CATEGORY |
| Enrichment | Professional profile: contact and workplace | profiles | Prospect | full_name | Individual's full name | First and last names associated with the individual, appended with a space. | Full Name |
| Enrichment | Strategic insights on public companies | pc_strategy_10k | Business | form_description | Form description | Summary of the filing, including the type of form submitted, the statutory authority requiring its submission, and details on whether specific disclosures are included or excluded. The filing is prepared and submitted by the company it pertains to, in compliance with SEC regulations. | TEXT |
| Enrichment | Strategic insights on public companies | pc_strategy_10k | Business | link_to_html | 10-K filing document link | URL linking to the main HTML document of the company's specific 10-K filing, containing financial statements, management analysis, and other key information submitted to the SEC. | TEXT |
| Enrichment | Strategic insights on public companies | pc_strategy_10k | Business | accession_number | File's accession number | Unique identifier for the file submitted by the company to the SEC, including the company’s CIK, the fiscal year of the filing, and the sequential number of the filing within that year. | TEXT |
| Enrichment | Strategic insights on public companies | pc_strategy_10k | Business | form_type | Form type | Type of form that was filed by the company. In most cases the form type is 10-K. | TEXT |
| Enrichment | Strategic insights on public companies | pc_strategy_10k | Business | target_market | Company's target market strategy | Text describing the company's target market strategy. Insights extracted from publicly published reports. | TEXT |
| Enrichment | Strategic insights on public companies | pc_strategy_10k | Business | company_value_proposition | Company's value proposition | Text describing the company's core product or service value proposition strategy. Insights extracted from publicly published reports. | TEXT |
| Enrichment | Strategic insights on public companies | pc_strategy_10k | Business | company_focus | Company's focus and strategy | Text describing the company's main focus areas and business strategy. Insights extracted from publicly published reports. | TEXT |
| Enrichment | Strategic insights on public companies | pc_strategy_10k | Business | cik | Company's CIK | Unique numeric identifier assigned by the SEC distinguishing a company in the EDGAR filing system. Typically consists of up to 10 digits and may include leading zeros. Used for retrieving financial filings and compliance documents. | TEXT |
| Enrichment | Strategic insights on public companies | pc_strategy_10k | Business | company_name | Company name | Name of the company. | TEXT |
| Enrichment | Strategic insights on public companies | pc_strategy_10k | Business | filed_at | Time of filing | Date and time the filing was submitted, formatted YYYY-MM-DDTHH:MM:SS±HH:MM. | DATETIME |
| Enrichment | Strategic insights on public companies | pc_strategy_10k | Business | link_to_filing_details | 10-K filing index link | URL linking to the index page of the company's specific 10-K filing, which lists the main filing document, exhibits, and supplemental files submitted to the SEC. | TEXT |
| Enrichment | Strategic insights on public companies | pc_strategy_10k | Business | company_partnerships | Company's partnership strategy | Text describing the company's partnership strategy. Insights extracted from publicly published reports. | TEXT |
| Enrichment | Strategic insights on public companies | pc_strategy_10k | Business | company_product_development | Company's product development | Text describing the company's product development focus and strategy. Insights extracted from publicly published reports. | TEXT |
| Enrichment | Strategic insights on public companies | pc_strategy_10k | Business | company_marketing_sales | Company's marketing and sales strategy | Text describing the company's marketing and sales strategy. Insights extracted from publicly published reports. | TEXT |
| Enrichment | Strategic insights on public companies | pc_strategy_10k | Business | ticker | Ticker symbol | Stock symbol associated with the company, that is compiled of an arrangement of characters representing publicly-traded securities on an exchange. The symbol is used to place trade orders. | TICKER |
| Enrichment | Business challenges of public companies | pc_business_challenges_10k | Business | technological_disruption | Company's innovation | Text describing the company's technological disruption and innovation. Insights extracted from publicly published reports. | TEXT |
| Enrichment | Business challenges of public companies | pc_business_challenges_10k | Business | link_to_html | 10-K filing document link | URL linking to the main HTML document of the company's specific 10-K filing, containing financial statements, management analysis, and other key information submitted to the SEC. | TEXT |
| Enrichment | Business challenges of public companies | pc_business_challenges_10k | Business | link_to_filing_details | 10-K filing index link | URL linking to the index page of the company's specific 10-K filing, which lists the main filing document, exhibits, and supplemental files submitted to the SEC. | TEXT |
| Enrichment | Business challenges of public companies | pc_business_challenges_10k | Business | form_type | Form type | Type of form that was filed by the company. In most cases the form type is 10-K. | TEXT |
| Enrichment | Business challenges of public companies | pc_business_challenges_10k | Business | accession_number | File's accession number | Unique identifier for the file submitted by the company to the SEC, including the company’s CIK, the fiscal year of the filing, and the sequential number of the filing within that year. | TEXT |
| Enrichment | Business challenges of public companies | pc_business_challenges_10k | Business | company_data_security_breach | Company's data security breaches | Text describing the company's data security breaches. Insights extracted from publicly published reports. | TEXT |
| Enrichment | Business challenges of public companies | pc_business_challenges_10k | Business | company_market_saturation | Company's market saturation | Text describing the company's market saturation. Insights extracted from publicly published reports. | TEXT |
| Enrichment | Business challenges of public companies | pc_business_challenges_10k | Business | form_description | Form description | Summary of the filing, including the type of form submitted, the statutory authority requiring its submission, and details on whether specific disclosures are included or excluded. The filing is prepared and submitted by the company it pertains to, in compliance with SEC regulations. | TEXT |
| Enrichment | Business challenges of public companies | pc_business_challenges_10k | Business | company_name | Company name | Name of the company. | TEXT |
| Enrichment | Business challenges of public companies | pc_business_challenges_10k | Business | cik | Company's CIK | Unique numeric identifier assigned by the SEC distinguishing a company in the EDGAR filing system. Typically consists of up to 10 digits and may include leading zeros. Used for retrieving financial filings and compliance documents. | TEXT |
| Enrichment | Business challenges of public companies | pc_business_challenges_10k | Business | filed_at | Time of filing | Date and time the filing was submitted, formatted YYYY-MM-DDTHH:MM:SS±HH:MM. | TEXT |
| Enrichment | Business challenges of public companies | pc_business_challenges_10k | Business | company_data_security_privacy | Company's data security and privacy | Text describing the company's data security and privacy approach. Insights extracted from publicly published reports. | TEXT |
| Enrichment | Business challenges of public companies | pc_business_challenges_10k | Business | company_competition | Company's competition | Text describing the company's competitive landscape. Insights extracted from publicly published reports. | TEXT |
| Enrichment | Business challenges of public companies | pc_business_challenges_10k | Business | company_customer_adoption | Company's customer adoption | Text describing the company's customer adoption. Insights extracted from publicly published reports. | TEXT |
| Enrichment | Business challenges of public companies | pc_business_challenges_10k | Business | ticker | Ticker symbol | Stock symbol associated with the company, that is compiled of an arrangement of characters representing publicly-traded securities on an exchange. The symbol is used to place trade orders. | TICKER |
| Enrichment | Competitive landscape of public companies | pc_competitive_landscape_10k | Business | cik | Company's CIK | Unique numeric identifier assigned by the SEC distinguishing a company in the EDGAR filing system. Typically consists of up to 10 digits and may include leading zeros. Used for retrieving financial filings and compliance documents. | TEXT |
| Enrichment | Competitive landscape of public companies | pc_competitive_landscape_10k | Business | link_to_filing_details | 10-K filing index link | URL linking to the index page of the company's specific 10-K filing, which lists the main filing document, exhibits, and supplemental files submitted to the SEC. | TEXT |
| Enrichment | Competitive landscape of public companies | pc_competitive_landscape_10k | Business | form_description | Form description | Summary of the filing, including the type of form submitted, the statutory authority requiring its submission, and details on whether specific disclosures are included or excluded. The filing is prepared and submitted by the company it pertains to, in compliance with SEC regulations. | TEXT |
| Enrichment | Competitive landscape of public companies | pc_competitive_landscape_10k | Business | competitive_differentiation | Competitive differentiation | Text describing the company's unique value and differentiators from competitors. | TEXT |
| Enrichment | Competitive landscape of public companies | pc_competitive_landscape_10k | Business | filed_at | Time of filing | Date and time the filing was submitted, formatted YYYY-MM-DDTHH:MM:SS±HH:MM. | TEXT |
| Enrichment | Competitive landscape of public companies | pc_competitive_landscape_10k | Business | company_name | Company name | Name of the company. | TEXT |
| Enrichment | Competitive landscape of public companies | pc_competitive_landscape_10k | Business | link_to_html | 10-K filing document link | URL linking to the main HTML document of the company's specific 10-K filing, containing financial statements, management analysis, and other key information submitted to the SEC. | TEXT |
| Enrichment | Competitive landscape of public companies | pc_competitive_landscape_10k | Business | key_competitors | Key competitors | List of the company's competitors. | TEXT |
| Enrichment | Competitive landscape of public companies | pc_competitive_landscape_10k | Business | accession_number | File's accession number | Unique identifier for the file submitted by the company to the SEC, including the company’s CIK, the fiscal year of the filing, and the sequential number of the filing within that year. | TEXT |
| Enrichment | Competitive landscape of public companies | pc_competitive_landscape_10k | Business | form_type | Form type | Type of form that was filed by the company. In most cases the form type is 10-K. | TEXT |
| Enrichment | Competitive landscape of public companies | pc_competitive_landscape_10k | Business | ticker | Ticker symbol | Stock symbol associated with the company, that is compiled of an arrangement of characters representing publicly-traded securities on an exchange. The symbol is used to place trade orders. | TICKER |
| Enrichment | Keyword search on websites | company_website_keywords | Business | text_results | Keyword search result | JSON-formatted list of search results, indicating the location of the queried keywords within the snippet. Each result includes a snippet of text containing the keywords, the corresponding URL, and a numeric ranking of where the keyword is positioned within the snippet. | TEXT |
| Enrichment | Keyword search on websites | company_website_keywords | Business | keywords_indicator | URL has keyword | True if the URL contains the queried keywords. | TEXT |
| Enrichment | Keyword search on websites | company_website_keywords | Business | url | URL | Website associated with Explorium's entity ID queried for the input keywords. | URL |
| Enrichment | Company’s website content changes | website_changes | Business | url | Website page of detected change | URL from which the changes were derived | URL |
| Enrichment | Company’s website content changes | website_changes | Business | change_description | Type of content change | Text describing the content modification on the website as compared to the previous version. | TEXT |
| Enrichment | Company’s website content changes | website_changes | Business | change_implication | Description of content change | Text indicating the strategic significance of the content change on the website | TEXT |
| Enrichment | Company’s website content changes | website_changes | Business | date | Content change timestamp | Date the content change on the website occurred. | DATETIME |
| Enrichment | Individual’s social media presence | prospects_linkedin_posts | Business | created_at | Time of posting | Timestamp of when the individual's post was published. | TEXT |
| Enrichment | Individual’s social media presence | prospects_linkedin_posts | Business | number_of_likes | Number of post likes | Number of likes the individual's post received by time of collection. | NUMERIC |
| Enrichment | Individual’s social media presence | prospects_linkedin_posts | Business | post_url | LinkedIn post URL | URL to the LinkedIn post published by individual. | URL |
| Enrichment | Individual’s social media presence | prospects_linkedin_posts | Business | number_of_comments | Number of post comments | Number of comments on the individual's post by time of collection. | NUMERIC |
| Enrichment | Individual’s social media presence | prospects_linkedin_posts | Business | days_since_posted | Days since post | Number of days since the post was published by the individual. | NUMERIC |
| Enrichment | Individual’s social media presence | prospects_linkedin_posts | Business | post_text | Post text content | Text content of the LinkedIn post published by individual. | TEXT |
| Enrichment | Individual’s social media presence | companies_linkedin_posts | Business | post_text | Post text content | Text content of the LinkedIn post published by company profile. | TEXT |
| Enrichment | Individual’s social media presence | companies_linkedin_posts | Business | days_since_posted | Days since post | Number of days since the post was published by the company. | NUMERIC |
| Enrichment | Individual’s social media presence | companies_linkedin_posts | Business | post_url | LinkedIn post URL | URL to the LinkedIn post published by individual. | URL |
| Enrichment | Individual’s social media presence | companies_linkedin_posts | Business | number_of_comments | Number of post comments | Number of comments on the company's post by time of collection. | NUMERIC |
| Enrichment | Individual’s social media presence | companies_linkedin_posts | Business | number_of_likes | Number of post likes | Number of likes the company's post received by time of collection. | NUMERIC |
| Enrichment | Individual’s social media presence | companies_linkedin_posts | Business | created_at | Time of posting | Timestamp of when the company's post was published. | TEXT |
| Enrichment | Workforce trends by company department | workforce_trends | Business | change_in_real_estate_roles | QoQ real estate roles | QoQ stands for quarter over quarter and is the rate of change in the percentage of employees working in real estate related positions in the quarter prior to the selected quarter, compared to the selected quarter. Calculation: (% Selected Quarter / % Previous Quarter)-1. | NUMERIC |
| Enrichment | Workforce trends by company department | workforce_trends | Business | perc_design_roles | Percentage of design roles | Percentage out of employee profiles that disclose the employee’s role who listed a design related position. This calculation is relevant to the selected timeframe. Designer roles include product designers, web designers, and graphic designers. | NUMERIC |
| Enrichment | Workforce trends by company department | workforce_trends | Business | profiles_found_per_quarter | Number of profiles | Number of detected profiles containing information on the employee | NUMERIC |
| Enrichment | Workforce trends by company department | workforce_trends | Business | perc_sales_roles | Percentage of sales roles | Percentage out of employee profiles that disclose the employee’s role who listed a sales related position. This calculation is relevant to the selected quarter. | NUMERIC |
| Enrichment | Workforce trends by company department | workforce_trends | Business | perc_hr_roles | Percentage of human resources roles | Percentage out of employee profiles that disclose the employee’s role who listed a human resources related position. This calculation refers to the selected quarter. Health related positions include sanitarians, nurses, and doctors. | NUMERIC |
| Enrichment | Workforce trends by company department | workforce_trends | Business | perc_operations_roles | Percentage of operations roles | Percentage out of employee profiles that disclose the employee’s role who listed an operations position. This calculation is relevant to the selected quarter. | NUMERIC |
| Enrichment | Workforce trends by company department | workforce_trends | Business | perc_pr_roles | Percentage of public relations roles | Percentage out of employee profiles that disclose the employee’s role who listed a PR position. This calculation is relevant to the selected quarter. | NUMERIC |
| Enrichment | Workforce trends by company department | workforce_trends | Business | perc_health_roles | Percentage of health roles | Percentage out of employee profiles that disclose the employee’s role who listed a health related position. This calculation refers to the selected quarter. Health related positions include sanitarians, nurses, and doctors. | NUMERIC |
| Enrichment | Workforce trends by company department | workforce_trends | Business | perc_trades_roles | Percentage of professional trades roles | Percentage out of employee profiles that disclose the employee’s role who listed a professional trades position. This calculation is relevant to the selected quarter. Professional trades roles include plumbers, construction workers, and electricians. | NUMERIC |
| Enrichment | Workforce trends by company department | workforce_trends | Business | perc_engineering_roles | Percentage of engineering roles | Percentage out of employee profiles that disclose the employee’s role who listed an engineering related position. This calculation refers to the selected quarter. Engineering roles include data, devops, electrical, mechanical, network, information technology, project engineering, quality assurance, security, software, systems and web roles. This calculation refers to the selected quarter. | NUMERIC |
| Enrichment | Workforce trends by company department | workforce_trends | Business | perc_finance_roles | Percentage of finance roles | Percentage out of employee profiles that disclose the employee’s role who listed a finance related position. This calculation refers to the selected quarter. | NUMERIC |
| Enrichment | Workforce trends by company department | workforce_trends | Business | perc_customer_service_roles | Percentage of customer service roles | Percentage out of employee profiles that disclose the employee’s role who listed a customer service position. This calculation is relevant to the selected timeframe. | NUMERIC |
| Enrichment | Workforce trends by company department | workforce_trends | Business | perc_legal_roles | Percentage of legal roles | Percentage out of employee profiles that disclose the employee’s role who listed a legal related position. This calculation refers to the selected quarter. | NUMERIC |
| Enrichment | Workforce trends by company department | workforce_trends | Business | perc_media_roles | Percentage of media roles | Percentage out of employee profiles that disclose the employee’s role who listed a marketing position. This calculation is relevant to the selected quarter. | NUMERIC |
| Enrichment | Workforce trends by company department | workforce_trends | Business | perc_marketing_roles | Percentage of marketing roles | Percentage out of employee profiles that disclose the employee’s role who listed a marketing position. This calculation is relevant to the selected quarter. | NUMERIC |
| Enrichment | Workforce trends by company department | workforce_trends | Business | change_in_real_estate_roles | Percentage of real estate roles | Percentage out of employee profiles that disclose the employee’s role who listed a real estate position. This calculation is relevant to the selected quarter. | NUMERIC |
| Enrichment | Workforce trends by company department | workforce_trends | Business | perc_education_roles | Percentage of education roles | The percentage out of employee profiles that disclose the employee’s role who listed an education related position. Education roles include teachers, researchers, professors, and education administrators. This calculation refers to the selected quarter. | NUMERIC |
| Enrichment | Workforce trends by company department | workforce_trends | Business | change_in_design_roles | QoQ design roles | QoQ stands for quarter over quarter and is the rate of change in the percentage of employees working in design roles in the quarter prior to the selected quarter compared to the selected quarter. Calculation: (% Selected Quarter / % Previous Quarter)-1. Designer roles include product designers, web designers, and graphic designers. | NUMERIC |
| Enrichment | Workforce trends by company department | workforce_trends | Business | change_in_education_roles | QoQ education roles | QoQ stands for quarter over quarter and is the rate of change in the percentage of employees working in education related roles in the quarter prior to the selected quarter, compared to the selected quarter. Calculation: (% Selected Quarter / % Previous Quarter)-1. Education roles include teachers, researchers, professors, and education administrators. | NUMERIC |
| Enrichment | Workforce trends by company department | workforce_trends | Business | change_in_pr_roles | QoQ public relation roles | QoQ stands for quarter over quarter and is the rate of change in the percentage of employees working in public relations related positions in the quarter prior to the selected quarter, compared to the selected quarter. Calculation: (% Selected Quarter / % Previous Quarter)-1. | NUMERIC |
| Enrichment | Workforce trends by company department | workforce_trends | Business | change_in_trades_roles | QoQ professional trades roles | QoQ stands for quarter over quarter and is the rate of change in the percentage of employees working in trades related positions in the quarter prior to the selected quarter, compared to the selected quarter. Calculation: (% Selected Quarter / % Previous Quarter)-1. | NUMERIC |
| Enrichment | Workforce trends by company department | workforce_trends | Business | change_in_customer_service_roles | QoQ customer service roles | QoQ stands for quarter over quarter and is the rate of change in the percentage of employees working in customer service roles in the quarter prior to the selected quarter, compared to the selected quarter. Calculation: (% Selected Quarter / % Previous Quarter)-1. | NUMERIC |
| Enrichment | Workforce trends by company department | workforce_trends | Business | change_in_health_roles | QoQ health roles | QoQ stands for quarter over quarter and is the rate of change in the percentage of employees working in health roles in the quarter prior to the selected quarter, compared to the selected quarter. Calculation: (% Selected Quarter / % Previous Quarter)-1. Health roles include sanitarians, nurses, and doctors. | NUMERIC |
| Enrichment | Workforce trends by company department | workforce_trends | Business | change_in_operations_roles | QoQ operations roles | QoQ stands for quarter over quarter and is the rate of change in the percentage of employees working in operations related positions in the quarter prior to the selected quarter, compared to the selected quarter. Calculation: (% Selected Quarter / % Previous Quarter)-1. | NUMERIC |
| Enrichment | Workforce trends by company department | workforce_trends | Business | change_in_sales_roles | QoQ sales roles | QoQ stands for quarter over quarter and is the rate of change in the percentage of employees working in sales related positions in the quarter prior to the selected quarter, compared to the selected quarter. Calculation: (% Selected Quarter / % Previous Quarter)-1. | NUMERIC |
| Enrichment | Workforce trends by company department | workforce_trends | Business | change_in_legal_roles | QoQ legal roles | QoQ stands for quarter over quarter and is the rate of change in the percentage of employees working in legal realted roles in the quarter prior to the selected quarter, compared to the selected quarter. Calculation: (% Selected Quarter / % Previous Quarter)-1. | NUMERIC |
| Enrichment | Workforce trends by company department | workforce_trends | Business | change_in_roles_divisor | QoQ profiles that disclose employee's role | QoQ stands for quarter over quarter and is the rate of change in the percentage of employee profiles that contain information about the employee’s role or position at the company in the quarter prior to the selected quarter, compared to the selected quarter. Calculation: (% Selected Quarter / % Previous Quarter)-1. | NUMERIC |
| Enrichment | Workforce trends by company department | workforce_trends | Business | change_in_finance_roles | QoQ finance roles | QoQ stands for quarter over quarter and is the rate of change in the percentage of employees working in finance roles in the quarter prior to the selected quarter, compared to the selected quarter. Calculation: (% Selected Quarter / % Previous Quarter)-1. | NUMERIC |
| Enrichment | Workforce trends by company department | workforce_trends | Business | change_in_media_roles | QoQ media roles | QoQ stands for quarter over quarter and is the rate of change in the percentage of employees working in media related roles in the quarter prior to the selected quarter, compared to the selected quarter. Calculation: (% Selected Quarter / % Previous Quarter)-1. | NUMERIC |
| Enrichment | Workforce trends by company department | workforce_trends | Business | change_in_hr_roles | QoQ human resources roles | QoQ stands for quarter over quarter and is the rate of change in the percentage of employees working in human resources roles in the quarter prior to the selected quarter, compared to the selected quarter. Calculation: (% Selected Quarter / % Previous Quarter)-1. | NUMERIC |
| Enrichment | Workforce trends by company department | workforce_trends | Business | change_in_marketing_roles | QoQ marketing roles | QoQ stands for quarter over quarter and is the rate of change in the percentage of employees working in marketing related roles in the quarter prior to the selected quarter, compared to the selected quarter. Calculation: (% Selected Quarter / % Previous Quarter)-1. | NUMERIC |
| Enrichment | Workforce trends by company department | workforce_trends | Business | change_in_engineering_roles | QoQ engineering roles | QoQ stands for quarter over quarter and is the rate of change in the percentage of employees working in engineering related positions in the quarter prior to the selected quarter, compared to the selected quarter. Calculation: (% Selected Quarter / % Previous Quarter)-1. Engineering roles include data, devops, electrical, mechanical, network, information technology, project engineering, quality assurance, security, software, systems and web roles. | NUMERIC |
| Enrichment | Workforce trends by company department | workforce_trends | Business | quarters | Quarter | Cutoff date of the data's quarterly period, e.g. 01/01/2001. | DATETIME |
| Enrichment | Company ratings by employees | company_ratings_by_employees | Business | company_city | Company's city | The city where the company's headquarters are located. | CITY |
| Enrichment | Company ratings by employees | company_ratings_by_employees | Business | company_country | Company's country | The country where the company's headquarters are located. | COUNTRY |
| Enrichment | Company ratings by employees | company_ratings_by_employees | Business | company_name | Company's name | The name of the company. | COMPANY |
| Enrichment | Company ratings by employees | company_ratings_by_employees | Business | company_region | Company's region | The state region where the company's headquarters are located. | REGION |
| Enrichment | Company ratings by employees | company_ratings_by_employees | Business | company_street | Company's street | The street name and number where the company's headquarters are located. | STREET |
| Enrichment | Company ratings by employees | company_ratings_by_employees | Business | company_url | Company's URL | The URL of the website associated with the company. | URL |
| Enrichment | Company ratings by employees | company_ratings_by_employees | Business | company_zip_code | Company Zip code | The postal code where the company's headquarters are located. | CATEGORY |
| Enrichment | Company ratings by employees | company_ratings_by_employees | Business | experience_negative | Negative experience | Percentage out of interviewees who published reviews that reported having a negative sentiment following a job interview. | NUMERIC |
| Enrichment | Company ratings by employees | company_ratings_by_employees | Business | experience_neutral | Neutral experience | Percentage out of interviewees who published reviews that reported having a neutral sentiment following a job interview. | NUMERIC |
| Enrichment | Company ratings by employees | company_ratings_by_employees | Business | experience_positive | Positive experience | Percentage out of interviewees who published reviews that reported having a positive sentiment following a job interview. | NUMERIC |
| Enrichment | Company ratings by employees | company_ratings_by_employees | Business | ratings_all_reviews_count | Number of ratings | Overall number of company ratings published by current and former employees. | NUMERIC |
| Enrichment | Company ratings by employees | company_ratings_by_employees | Business | ratings_business_outlook | Business outlook rating | The percentage out of current and former employees who published reviews that believe the company will succeed in the near future. | NUMERIC |
| Enrichment | Company ratings by employees | company_ratings_by_employees | Business | ratings_career_opportunities | Career opportunities rating | Current and former Employees rating between 1-5 of the personal career development opportunities at the company. | 1=low rating, 5=high rating |
| Enrichment | Company ratings by employees | company_ratings_by_employees | Business | ratings_ceo_approval | CEO approval rating | The percent of current and former employees that published reviews who approved of the company's CEO. | NUMERIC |
| Enrichment | Company ratings by employees | company_ratings_by_employees | Business | ratings_ceo_approval_count | CEO approval ratings count | Number of CEO approval ratings collected. | NUMERIC |
| Enrichment | Company ratings by employees | company_ratings_by_employees | Business | ratings_compensation_benefits | Compensation benefits rating | Compensation and benefits rating between 1-5 published by its current and former employees. | 1=low rating, 5=high rating |
| Enrichment | Company ratings by employees | company_ratings_by_employees | Business | ratings_cutlure_values | Culture values rating | Culture values rating between 1-5 as rated by its current and former employees. | 1=low rating, 5=high rating |
| Enrichment | Company ratings by employees | company_ratings_by_employees | Business | ratings_diversity_inclusion | Diversity inclusion rating | Diversity inclusion rating between 1-5 as viewed by the company’s current and former employees. | 1=low rating, 5=high rating |
| Enrichment | Company ratings by employees | company_ratings_by_employees | Business | ratings_overall | Overall Ratings | A company’s overall score between 1-5 rated by its employees, interviewees and former employees. | 1=low rating, 5=high rating |
| Enrichment | Company ratings by employees | company_ratings_by_employees | Business | ratings_recommend_to_friend | Recommend to friend rating | The chance that a current or former employee will recommend a friend to work in said company. | NUMERIC |
| Enrichment | Company ratings by employees | company_ratings_by_employees | Business | ratings_senior_management | Senior management rating | Rating between 1-5 of the senior management as viewed by its current and former employees. | 1=low rating, 5=high rating |
| Enrichment | Company ratings by employees | company_ratings_by_employees | Business | ratings_work_life_balance | Work life balance rating | Work life balance rating between 1-5 as viewed by its current and former employees. | 1=low rating, 5=high rating |
| Enrichment | Company ratings by employees | company_ratings_by_employees | Business | total_reviews_count | Total reviews count | Total number of company reviews published by current and former employees. | NUMERIC |
| Enrichment | Company ratings by employees | company_ratings_by_employees | Business | company_score | Trend of company rating by employees | A dictionary listing the overall company score rated by current and former employees over the recent year between 1-5. | 1=low rating, 5=high rating |
| Enrichment | Funding and acquisitions for public and private companies | founding_and_acquisition | Business | domain | Company's domain | Company's domain | DOMAIN |
| Enrichment | Funding and acquisitions for public and private companies | founding_and_acquisition | Business | company_name | Company name | Company name | COMPANY |
| Enrichment | Funding and acquisitions for public and private companies | founding_and_acquisition | Business | investors | Company's investors | List of all company's investors from all funding rounds. | TEXT |
| Enrichment | Funding and acquisitions for public and private companies | founding_and_acquisition | Business | number_of_advisors | Number of advisors | Number of the company''s listed advisors. If the advisor''s data is unavailable, returned value is 'null'. | NUMERIC |
| Enrichment | Funding and acquisitions for public and private companies | founding_and_acquisition | Business | num_news | Number of company's news events | Selected company's number of listed news appearances, articles, or events. | NUMERIC |
| Enrichment | Funding and acquisitions for public and private companies | founding_and_acquisition | Business | current_advisors | Names and job titles of current advisors | List of advisors to the company. Includes the advisor name and job title. If the advisor's data is unavailable, returned value is 'null'. | TEXT |
| Enrichment | Funding and acquisitions for public and private companies | founding_and_acquisition | Business | ipo_size_usd | IPO value, US dollars | Amount of money raised in the IPO. If the company didn't go public or the data is unavailable, returned value is 'null'. | NUMERIC |
| Enrichment | Funding and acquisitions for public and private companies | founding_and_acquisition | Business | ipo_date | IPO date | Date the selected company's IPO was announced, formatted YYYY-MM-DD. If the company didn't go public or the data is unavailable, returned value is 'null'. | DATETIME |
| Enrichment | Funding and acquisitions for public and private companies | founding_and_acquisition | Business | is_ipo | Company had IPO | True if the company has gone public. | BOOLEAN |
| Enrichment | Funding and acquisitions for public and private companies | founding_and_acquisition | Business | number_of_investors_for_first_funding_round | First funding round: number of investors | Number of investors involved in the company's first funding round. If the company didn't have a funding round, or the data is unavailable, returned value is 'null'. | NUMERIC |
| Enrichment | Funding and acquisitions for public and private companies | founding_and_acquisition | Business | first_funding_round_value_usd | First funding round: size | Amount of money raised in first funding round, displayed in US dollars (e.g. how many US dollars were raised by the selected company in a funding round). If the company didn't have founding round, or the data is unavailable, returned value is 'null'. | NUMERIC |
| Enrichment | Funding and acquisitions for public and private companies | founding_and_acquisition | Business | first_funding_round_type | First funding round: details | Type of capital raised during the selected company's first funding round. E.g seed, venture, angel, round A, and more. If the company didn't have a funding round, or the data is unavailable, returned value is 'null'. | TEXT |
| Enrichment | Funding and acquisitions for public and private companies | founding_and_acquisition | Business | first_funding_round_date | First funding round: date | Date the selected company's first funding round was announced, formatted YYYY-MM-DD. If the company didn't have a funding round, or the data is unavailable, returned value is 'null'. | DATETIME |
| Enrichment | Funding and acquisitions for public and private companies | founding_and_acquisition | Business | number_of_funding_rounds | Number of funding rounds | Number of funding rounds listed for the company. | NUMERIC |
| Enrichment | Funding and acquisitions for public and private companies | founding_and_acquisition | Business | acquired_by | Details of company's acquisition by other company | Additional information regarding the company's acquisition by another party, including: name of other party, price of acquisition in US dollars, and date of acquisition formatted YYYY-MM-DD. If acquisitions were not made or data is unavailable, returned value is 'null'. | TEXT |
| Enrichment | Funding and acquisitions for public and private companies | founding_and_acquisition | Business | latest_funding_increase_in_percents | Change trend of company's funding round size | Percent change in funding round size between the most recent funding round and the one that preceded it. Calculation: 100 * (( previous funding round size - last funding round size) / last funding round size) | NUMERIC |
| Enrichment | Funding and acquisitions for public and private companies | founding_and_acquisition | Business | last_funding_round_date | Most recent funding round: date | Date the selected company''s last funding round was announced, formatted YYYY-MM-DD. If the company didn''t have a funding round, or the data is unavailable, returned value is 'null'. | DATETIME |
| Enrichment | Funding and acquisitions for public and private companies | founding_and_acquisition | Business | last_funding_round_value_usd | Most recent funding round: size, US dollars | Amount of money raised in the selected company's most recent funding round, displayed in US dollars. If the company didn't have a funding round, or the data is unavailable, returned value is 'null'. | NUMERIC |
| Enrichment | Funding and acquisitions for public and private companies | founding_and_acquisition | Business | last_funding_round_type | Most recent funding round: details | Type of capital raised during the selected company's most recent funding round. E.g seed, venture, angel, round A, and more. If the company didn't have a funding round, or the data is unavailable, returned value is 'null'. | TEXT |
| Enrichment | Funding and acquisitions for public and private companies | founding_and_acquisition | Business | number_of_investors_for_last_funding_round | Most recent funding round: number of investors | Number of investors involved in the company's last funding round. If the company didn't have a funding round, or the data is unavailable, returned value is 'null'. | NUMERIC |
| Enrichment | Funding and acquisitions for public and private companies | founding_and_acquisition | Business | funding_rounds_info | List of all funding rounds | List of all of the company's funding round events, including: announcement date formatted YYYY-MM-DD, names of lead investors, currency of the money raised, value of the money raised, and value of the money raised in US dollars. If the company didn't have a funding round, or the data is unavailable, returned value is 'null'. | TEXT |
| Enrichment | Funding and acquisitions for public and private companies | founding_and_acquisition | Business | known_funding_total_value | Total funding value, US dollars | Total amount of money raised in all of the company's funding rounds. Calculated using all available data, displayed in US dollars. | NUMERIC |
| Enrichment | Financial metrics for public companies | financial_indicators | Business | asset_turnover | Asset turnover | The company's quarterly ratio between the total sales or revenue, and the average company assets. Numbers are displayed in the currency of the country where the company is legally registered. | NUMERIC |
| Enrichment | Financial metrics for public companies | financial_indicators | Business | cagr | Revenue CAGR | The company’s revenue compound annual growth rate. It is calculated by dividing the yearly fiscal revenue by the previous fiscal year revenue and subtracting by 1. Both figures appear on the company’s annual reports. This feature is calculated only per year, so it will not take into account the date that was specified in the input query. The calculations are based on the currency of the country where the company is legally registered. | NUMERIC |
| Enrichment | Financial metrics for public companies | financial_indicators | Business | cogs | COGS | Cost of goods sold (COGS) refers to the direct costs of producing the goods sold by a company. This amount includes the cost of the materials and labor directly used to create the good. Cost of goods sold is also referred to as 'cost of sales.' Formula: quarterly_revenue / gross_profit quarterly_revenue, gross_profit - taken from company’s quarterly report | NUMERIC |
| Enrichment | Financial metrics for public companies | financial_indicators | Business | earnings_surprises | Earning surprise | The company’s earning surprise occurs when a company reports figures that are drastically different from the stock market estimates, and is calculated per quarter. This feature will display both the estimated earning per share and the actual earning per share. Numbers are displayed in the currency of the country where the company is legally registered. | TEXT |
| Enrichment | Financial metrics for public companies | financial_indicators | Business | ebitda | Quarterly EBITDA | The company’s reported earnings before interest, taxes, depreciation, and amortization. Calculations are based on the currency of the country where the company is legally registered. | NUMERIC |
| Enrichment | Financial metrics for public companies | financial_indicators | Business | enterprise_value_over_ebdita | Quarterly valuation multiples (EV / EBITDA) | Enterprise multiple, also known as the EV-to-EBITDA multiple, is a ratio used to determine the value of a company. It is computed by dividing enterprise value by EBITDA. The enterprise multiple takes into account a company's debt and cash levels in addition to its stock price and relates that value to the firm's cash profitability. Enterprise multiples can vary depending on the industry. Higher enterprise multiples are expected in high-growth industries and lower multiples in industries with slow growth. Calculated based on quarter values. | NUMERIC |
| Enrichment | Financial metrics for public companies | financial_indicators | Business | leadership | Leadership | Key executives are the people at the top of a company who make critical decisions that affect the company. We keep track of who they are, what their titles are, and how much money they make. | TEXT |
| Enrichment | Financial metrics for public companies | financial_indicators | Business | peer_companies | Peer companies | A list of companies that are in the same industry or sector as the company. | TEXT |
| Enrichment | Financial metrics for public companies | financial_indicators | Business | price_earnings_ratio | Quarterly valuation multiples (P / E) | The price-to-earnings ratio (P/E ratio) is the ratio for valuing a company that measures its current share price relative to its earnings per share (EPS). The price-to-earnings ratio is also sometimes known as the price multiple or the earnings multiple. Calculated based on quarter values. | NUMERIC |
| Enrichment | Financial metrics for public companies | financial_indicators | Business | revenue_yearly | Annual revenue | Company’s yearly revenue. This feature is calculated only per fiscal year, so it will not take into account the date that was specified in the input query. The calculations are based on the currency of the country where the company is legally registered. | NUMERIC |
| Enrichment | Financial metrics for public companies | financial_indicators | Business | roa | Quarterly ROA | The company’s quarterly Return On Assets. It is calculated by dividing the company’s net income by the company’s total assets. The net income is reported in the company’s cash flow statement, and the company’s total assets are reported in the company’s balance statement. Numbers are displayed in the currency of the country where the company is legally registered. | NUMERIC |
| Enrichment | Financial metrics for public companies | financial_indicators | Business | roc | Quarterly ROC | Company’s quarterly Return On Capital is calculated in the following way: (net_income - dividends_paid) / (total_debt - total_equity). Both the dividends paid and net income figures were reported in the company’s cash flow statement. The total debt and total equity figures are from the company’s balance statements. The calculations are based on the currency of the country where the company is legally registered. | NUMERIC |
| Enrichment | Financial metrics for public companies | financial_indicators | Business | sg_and_a | SG&A | Quarterly Selling General & Administrative expenses is based on the company’s quarterly income report. Numbers are displayed in the currency of the country where the company is legally registered. | NUMERIC |
| Enrichment | Financial metrics for public companies | financial_indicators | Business | tsr_1 | TSR (1-year) | Total shareholder return (TSR) is a measure of financial performance, indicating the total amount an investor reaps from an investment—specifically, equities or shares of stock. Total shareholder return factors in capital gains and dividends when measuring the total return generated by a stock. TSR represents an easily understood figure of the overall financial benefits generated for stockholders. TSR is a good gauge of an investment's long-term value, but it is limited to past performance, requires an investment to generate cash flows, and can be sensitive to stock market volatility. Formula: ((year_stock_price - previous_year_stock_price) + dividends) / previous_year_stock_price for example: query AAPL 2020-Q3 will be calculated with these values: year_stock_price = last stock price of AAPL in 2020 previous_year_stock_price = stock price of AAPL at the beginning of 2020 dividends = dividends given during 2020 | NUMERIC |
| Enrichment | Financial metrics for public companies | financial_indicators | Business | tsr_3 | TSR (3-year) | Total shareholder return (TSR) is a measure of financial performance, indicating the total amount an investor reaps from an investment—specifically, equities or shares of stock. Total shareholder return factors in capital gains and dividends when measuring the total return generated by a stock. TSR represents an easily understood figure of the overall financial benefits generated for stockholders. TSR is a good gauge of an investment's long-term value, but it is limited to past performance, requires an investment to generate cash flows, and can be sensitive to stock market volatility. Formula: ((year_stock_price - 3_years_ago_stock_price) + dividends) / 3_years_ago_stock_price for example: query AAPL 2020-Q3 will be calculated with these values: year_stock_price = last stock price of AAPL in 2020 3_years_ago_stock_price = stock price of AAPL at the beginning of 2018 dividends = dividends given during 2018-2020 | NUMERIC |
| Enrichment | Financial metrics for public companies | financial_indicators | Business | tsr_5 | TSR (5-years) | Indication of the total amount an investor reaps from an investment—specifically, equities or shares of stock. Total shareholder return factors in capital gains and dividends when measuring the total return generated by a stock. TSR represents an easily understood figure of the overall financial benefits generated for stockholders. TSR is a good gauge of an investment's long-term value, but it is limited to past performance, requires an investment to generate cash flows, and can be sensitive to stock market volatility. Formula: ((year_stock_price - 5_years_ago_stock_price) + dividends) / 5_years_ago_stock_price for example: query AAPL 2020-Q3 will be calculated with these values: year_stock_price = last stock price of AAPL in 2020 5_years_ago_stock_price = stock price of AAPL at the beginning of 2016 dividends = dividends given during 2016-2020 | NUMERIC |
| Enrichment | Financial metrics for public companies | financial_indicators | Business | working_capital | Working capital | Working capital, also known as net working capital (NWC), is the difference between a company’s current assets - such as cash, accounts receivable/customers’ unpaid bills, and inventories of raw materials and finished goods - and its current liabilities, such as accounts payable and debts. Calculated based on quarter values. | NUMERIC |