Field reference: Company DB

All 222 fields of the Company DB, grouped by category. Names are the Parquet field names; the CSV delivery uses its own column headers, listed under CSV column names.

Every field may be null unless marked required. Today company_id is guaranteed.

Under each type is the column’s Parquet type, as DuckDB names it: VARCHAR is a string, BIGINT a 64-bit integer, DOUBLE a 64-bit float, and [] a list. Each category ends with its full Parquet schema, ready to copy.

What’s in it

Category	Fields
ID	2
Informative Data	24
Status	1
Timestamp	1
Team	15
Financials	13
Specter Growth	2
Product	68
Web Intelligence	27
Social Engagement	34
App Performance	33
Awards & News	2

ID

Field	Type	Description
`company_id`	`string` required `VARCHAR`	Specter identifier for the company. Resolves against the Company DB.
`specter_strategic_signal_ids`	`array<string>` `VARCHAR[]`	All Investor Interest Signals IDs for this profile.

Parquet schema: ID

(
  company_id                    VARCHAR,
  specter_strategic_signal_ids  VARCHAR[]
)

Informative Data

Field	Type	Description
`company_name`	`string` `VARCHAR`	Primary name of the company.
`company_name_alias`	`array<string>` `VARCHAR[]`	Alternative names for the company, derived from its website.
`website_domain`	`string` `VARCHAR`	Company domain.
`website_url`	`string` `VARCHAR`	Company website URL.
`website_other_domains`	`array<string>` `VARCHAR[]`	Additional domain names associated with the company. In CSV, values are separated by `;`.
`operating_status`	`string` `VARCHAR`	Whether the company is still operating. One of `Active`, `Closed`, `Acquired`, `IPO`.
`primary_role`	`string` `VARCHAR`	Primary role of the company. One of `company`, `investor`, `school`. In CSV, written as `Company`, `Investor`, `School`.
`roles`	`array<string>` `VARCHAR[]`	Various roles associated with the company. One of `company`, `investor`, `school`. In CSV, written as `Company`, `Investor`, `School`. In CSV, values are separated by `;`.
`founded_year`	`integer` `INTEGER`	Year the company was founded.
`growth_stage`	`string` `VARCHAR`	Stage the company has reached in its growth. One of `Pre-seed / Seed`, `Early Stage`, `Growth Stage`, `Late Stage`, `Exit Stage`, `Bootstrapped`.
`tagline`	`string` `VARCHAR`	One-line description of the company, 10 to 20 words.
`description`	`string` `VARCHAR`	What the company does.
`customer_focus`	`string` `VARCHAR`	This data point categorizes companies based on their primary and secondary customer engagement models. One of `b2b`, `b2c`, `b2b_b2c`, `b2c_b2b`. In CSV, written as `B2B`, `B2C`, `B2B,B2C`, `B2C,B2B`.
`business_models`	`array<string>` `VARCHAR[]`	Categorizes companies based on their business model. There can be up to 3 business models assigned to the same company. One of `professional-services`, `product-sales`, `subscription`, `marketplace_brokerage`, `saas`, `advertising`, `financial-services`, `usage-based`, `licensing`, `lead-generation_affiliate`, `oem`, `franchising`.
`specter_industry`	`array<string>` `VARCHAR[]`	Classifies companies by their economic activity — the market they serve and the products or services they deliver. E.g: Construction, Utilities, Wholesale There is one industry per company, with up to three levels.
`specter_tech_verticals`	`array<array<string>>` `VARCHAR[][]`	Classifies companies by the technology domain they operate in — the technical capability or space they’re building around. E.g: AI & Machine Learning, Cybersecurity, FinTech. There can be up to 5 tech verticals per company, with 2 levels each.
`tags`	`array<string>` `VARCHAR[]`	Tags describing the company. In CSV, values are separated by `,`.
`hq_location`	`string` `VARCHAR`	City-level location of the company’s headquarters.
`hq_regions`	`array<string>` `VARCHAR[]`	Region mappings associated with the company, both metropollitan areas (e.g. London Metropolitan Area), and country-level groupings (e.g. DACH, European Union etc.)
`reported_clients`	`array<string>` `VARCHAR[]`	Clients named on the company’s website.
`customer_profile`	`string` `VARCHAR`	One sentence describing the company’s majority customer type, derived from its website.
`traction_highlights`	`string` `VARCHAR`	Traction highlights taken from the company’s website.
`pitchbook_url`	`string` `VARCHAR`	Company Pitchbook URL.
`crunchbase_url`	`string` `VARCHAR`	Company Crunchbase URL.

Parquet schema: Informative Data

Informative Data

(
  company_name            VARCHAR,
  company_name_alias      VARCHAR[],
  website_domain          VARCHAR,
  website_url             VARCHAR,
  website_other_domains   VARCHAR[],
  operating_status        VARCHAR,
  primary_role            VARCHAR,
  roles                   VARCHAR[],
  founded_year            INTEGER,
  growth_stage            VARCHAR,
  tagline                 VARCHAR,
  description             VARCHAR,
  customer_focus          VARCHAR,
  business_models         VARCHAR[],
  specter_industry        VARCHAR[],
  specter_tech_verticals  VARCHAR[][],
  tags                    VARCHAR[],
  hq_location             VARCHAR,
  hq_regions              VARCHAR[],
  reported_clients        VARCHAR[],
  customer_profile        VARCHAR,
  traction_highlights     VARCHAR,
  pitchbook_url           VARCHAR,
  crunchbase_url          VARCHAR
)

Status

Field	Type	Description
`status`	`string` `VARCHAR`	Whether the record was added, updated or removed. Incremental deliveries only. One of `added`, `updated`, `removed`.

Parquet schema: Status

Status

(
  status  VARCHAR
)

Timestamp

Field	Type	Description
`last_updated`	`date` `DATE`	Timestamp of latest update for the profile in text format.

Parquet schema: Timestamp

Timestamp

(
  last_updated  DATE
)

Team

Field	Type	Description
`founders`	`array<object>` `STRUCT(…)[]`	Company founder(s) information.
↳ `specter_person_id`	`string` `VARCHAR`
↳ `full_name`	`string` `VARCHAR`
↳ `title`	`string` `VARCHAR`
↳ `departments`	`array<string>` `VARCHAR[]`
↳ `seniority`	`string` `VARCHAR`
`founder_highlights`	`array<string>` `VARCHAR[]`	Founder highlights are awarded tags to people reflecting background and achievements of the founders. It’s a unique set of highlights held by any of the founders.
`team_location_breakdown`	`array<object>` `STRUCT(…)[]`	Team breakdown by country. Distribution of the company’s workforce across countries, showing employee counts per location.
↳ `country`	`string` `VARCHAR`
↳ `employee_count`	`integer` `UBIGINT`
`team_department_breakdown`	`array<object>` `STRUCT(…)[]`	Team breakdown by department. Distribution of the company’s workforce across functional departments, shown as a percentage of total headcount.
↳ `department`	`string` `VARCHAR`
↳ `percentage`	`number` `DOUBLE`
`founder_count`	`integer` `BIGINT`	Company number of founders.
`employee_count_range`	`object` `STRUCT(…)`	Company size range. In CSV, a single text value: `1-10`, `11-50`, `51-200`, `201-500`, `501-1000`, `1001-5000`, `5001-10000`, `10001+`.
↳ `min`	`integer` `SMALLINT`
↳ `max`	`integer` `SMALLINT`
`employee_count`	`integer` `INTEGER`	Number of employees.
`employee_count_growth_1m_percentage`	`number` % `DOUBLE`	Percentage monthly growth or loss in employees.
`employee_count_growth_2m_percentage`	`number` % `DOUBLE`	Percentage 2 month growth or loss in employees.
`employee_count_growth_3m_percentage`	`number` % `DOUBLE`	Percentage 3 month growth or loss in employees.
`employee_count_growth_4m_percentage`	`number` % `DOUBLE`	Percentage 4 month growth or loss in employees.
`employee_count_growth_5m_percentage`	`number` % `DOUBLE`	Percentage 5 month growth or loss in employees.
`employee_count_growth_6m_percentage`	`number` % `DOUBLE`	Percentage 6 month growth or loss in employees.
`employee_count_growth_12m_percentage`	`number` % `DOUBLE`	Percentage 1 year growth or loss in employees.
`employee_count_growth_24m_percentage`	`number` % `DOUBLE`	Percentage 2 year growth or loss in employees.

Parquet schema: Team

Team

(
  founders                              STRUCT(
    specter_person_id VARCHAR,
    full_name VARCHAR,
    title VARCHAR,
    departments VARCHAR[],
    seniority VARCHAR
  )[],
  founder_highlights                    VARCHAR[],
  team_location_breakdown               STRUCT(
    country VARCHAR,
    employee_count UBIGINT
  )[],
  team_department_breakdown             STRUCT(
    department VARCHAR,
    percentage DOUBLE
  )[],
  founder_count                         BIGINT,
  employee_count_range                  STRUCT(
    min SMALLINT,
    max SMALLINT
  ),
  employee_count                        INTEGER,
  employee_count_growth_1m_percentage   DOUBLE,
  employee_count_growth_2m_percentage   DOUBLE,
  employee_count_growth_3m_percentage   DOUBLE,
  employee_count_growth_4m_percentage   DOUBLE,
  employee_count_growth_5m_percentage   DOUBLE,
  employee_count_growth_6m_percentage   DOUBLE,
  employee_count_growth_12m_percentage  DOUBLE,
  employee_count_growth_24m_percentage  DOUBLE
)

Financials

Field	Type	Description
`total_funding_usd`	`integer` `BIGINT`	Company total funding amount in USD.
`last_funding_usd`	`integer` `BIGINT`	Company last funding amount in USD.
`last_funding_date`	`date` `DATE`	Company last funding date.
`last_funding_type`	`string` `VARCHAR`	Company last funding type.
`post_money_valuation_usd`	`integer` `BIGINT`	Post-money valuation of the round, in USD.
`funding_round_count`	`integer` `SMALLINT`	Number of announced funding rounds.
`investor_count`	`integer` `INTEGER`	Number of investors across all funding rounds.
`investors_details`	`array<object>` `STRUCT(…)[]`	Every investor across all funding rounds, each as a `specter_investor_id` and name pair, so an investor resolves against the Investor DB.
↳ `specter_investor_id`	`string` `VARCHAR`
↳ `name`	`string` `VARCHAR`
`funding_rounds_details`	`array<object>` `STRUCT(…)[]`	All funding rounds, newest first. Each round carries `type`, `date`, `raised`, `investors`, `lead_investors_partners`, `pre_money_valuation` and `post_money_valuation`. Each investor is a record of `specter_investor_id` — which resolves against the Investor DB — `name` and `is_lead_investor`. A valuation that is not known arrives as an empty string.
↳ `type`	`string` `VARCHAR`
↳ `date`	`string` `VARCHAR`
↳ `raised`	`number` `DOUBLE`
↳ `investors`	`array<object>` `STRUCT(…)[]`
↳ `specter_investor_id`	`string` `VARCHAR`
↳ `name`	`string` `VARCHAR`
↳ `is_lead_investor`	`boolean` `BOOLEAN`
↳ `lead_investors_partners`	`array<object>` `STRUCT(…)[]`
↳ `lead_investor_name`	`string` `VARCHAR`
↳ `partner_name`	`string` `VARCHAR`
↳ `pre_money_valuation`	`string` `VARCHAR`
↳ `post_money_valuation`	`string` `VARCHAR`
`acquisition_acquirer`	`string` `VARCHAR`	Organisation that acquired the company.
`acquisition_date`	`date` `DATE`	Date this company was acquired.
`acquisition_amount_usd`	`integer` `BIGINT`	Acquisition price (in USD)
`ipo`	`array<object>` `STRUCT(…)[]`	IPO details.
↳ `went_public_on`	`string` `VARCHAR`
↳ `stock_exchange`	`string` `VARCHAR`
↳ `stock_symbol`	`string` `VARCHAR`
↳ `share_price`	`number` `DOUBLE`
↳ `valuation_price`	`number` `DOUBLE`
↳ `raised_amount`	`number` `DOUBLE`

Parquet schema: Financials

Financials

(
  total_funding_usd         BIGINT,
  last_funding_usd          BIGINT,
  last_funding_date         DATE,
  last_funding_type         VARCHAR,
  post_money_valuation_usd  BIGINT,
  funding_round_count       SMALLINT,
  investor_count            INTEGER,
  investors_details         STRUCT(
    specter_investor_id VARCHAR,
    name VARCHAR
  )[],
  funding_rounds_details    STRUCT(
    type VARCHAR,
    date VARCHAR,
    raised DOUBLE,
    investors STRUCT(
      specter_investor_id VARCHAR,
      name VARCHAR,
      is_lead_investor BOOLEAN
    )[],
    lead_investors_partners STRUCT(
      lead_investor_name VARCHAR,
      partner_name VARCHAR
    )[],
    pre_money_valuation VARCHAR,
    post_money_valuation VARCHAR
  )[],
  acquisition_acquirer      VARCHAR,
  acquisition_date          DATE,
  acquisition_amount_usd    BIGINT,
  ipo                       STRUCT(
    went_public_on VARCHAR,
    stock_exchange VARCHAR,
    stock_symbol VARCHAR,
    share_price DOUBLE,
    valuation_price DOUBLE,
    raised_amount DOUBLE
  )[]
)

Specter Growth

Field	Type	Description
`company_rank`	`integer` `BIGINT`	Global company rank based on Specter’s proprietary algorithm.
`highlights`	`array<string>` `VARCHAR[]`	Highlights are monthly awarded tags to companies reflecting specific and different growth patterns. One of 37 values, listed below the table.

Parquet schema: Specter Growth

Specter Growth

(
  company_rank  BIGINT,
  highlights    VARCHAR[]
)

Accepted values for highlights

headcount_3mo_surge
headcount_6mo_momentum
headcount_12mo_scale_up
headcount_3mo_dip
headcount_6mo_decline
headcount_12mo_downturn
web_traffic_3mo_surge
web_traffic_6mo_momentum
web_traffic_12mo_scale_up
web_traffic_3mo_dip
web_traffic_6mo_decline
web_traffic_12mo_downturn
social_followers_3mo_surge
social_followers_6mo_momentum
social_followers_12mo_scale_up
social_followers_3mo_dip
social_followers_6mo_decline
social_followers_12mo_downturn
app_downloads_3mo_surge
app_downloads_6mo_momentum
app_downloads_12mo_scale_up
app_downloads_3mo_dip
app_downloads_6mo_decline
app_downloads_12mo_downturn
app_reviews_3mo_surge
app_reviews_6mo_momentum
app_reviews_12mo_scale_up
product_reviews_3mo_surge
product_reviews_6mo_momentum
product_reviews_12mo_scale_up
top_tier_investors
raised_last_month
recent_funding
no_recent_funding
no_funding
media_spotlight
recent_news

Product

Field	Type	Description
`certifications`	`array<string>` `VARCHAR[]`	List of certifications, JSON serialized list. Exhaustive list: SOC 1 Type 1, SOC 1 Type 2, SOC 1 Unknown Type, SOC 2 Type 1, SOC 2 Type 2, SOC 2 Unknown Type, SOC 3, B Corp, GDPR, HIPAA, ISO 27001, ISO 9001, ISO 14001, ISO 45001, FedRAMP, PCI DSS.
`g2_data`	`array<object>` `STRUCT(…)[]`	Company G2 data.
↳ `product_name`	`string` `VARCHAR`
↳ `g2_link`	`string` `VARCHAR`
↳ `reviews`	`integer` `BIGINT`
↳ `rating`	`number` `DOUBLE`
↳ `star_distribution`	`object` `STRUCT(…)`
↳ `1`	`integer` `UBIGINT`
↳ `2`	`integer` `UBIGINT`
↳ `3`	`integer` `UBIGINT`
↳ `4`	`integer` `UBIGINT`
↳ `5`	`integer` `UBIGINT`
`g2_rating`	`number` `DOUBLE`	Company rating on G2.
`g2_review_count`	`integer` `UBIGINT`	Number of total reviews on G2.
`g2_reviews_growth_1m_change`	`integer` `BIGINT`	Number of total G2 reviews gained or lost in the last month.
`g2_reviews_growth_2m_change`	`integer` `BIGINT`	Number of total G2 reviews gained or lost in the last two months.
`g2_reviews_growth_3m_change`	`integer` `BIGINT`	Number of total G2 reviews gained or lost in the last three months.
`g2_reviews_growth_4m_change`	`integer` `BIGINT`	Number of total G2 reviews gained or lost in the last four months.
`g2_reviews_growth_5m_change`	`integer` `BIGINT`	Number of total G2 reviews gained or lost in the last five months.
`g2_reviews_growth_6m_change`	`integer` `BIGINT`	Number of total G2 reviews gained or lost in the last six months.
`g2_reviews_growth_12m_change`	`integer` `BIGINT`	Number of total G2 reviews gained or lost in the last 1 year.
`g2_reviews_growth_24m_change`	`integer` `BIGINT`	Number of total G2 reviews gained or lost in the last 2 years.
`trustpilot_data`	`object` `STRUCT(…)`	Company Trustpilot data.
↳ `name`	`string` `VARCHAR`
↳ `trustpilot_url`	`string` `VARCHAR`
↳ `reviews`	`integer` `BIGINT`
↳ `star_distribution`	`object` `STRUCT(…)`
↳ `1`	`integer` `BIGINT`
↳ `2`	`integer` `BIGINT`
↳ `3`	`integer` `BIGINT`
↳ `4`	`integer` `BIGINT`
↳ `5`	`integer` `BIGINT`
`trustpilot_rating`	`number` `DOUBLE`	Company rating on Trustpilot.
`trustpilot_review_count`	`integer` `UBIGINT`	Number of total reviews on Trustpilot.
`trustpilot_reviews_growth_1m_change`	`integer` `BIGINT`	Number of total Trustpilot reviews gained or lost in the last month.
`trustpilot_reviews_growth_2m_change`	`integer` `BIGINT`	Number of total Trustpilot reviews gained or lost in the last two months.
`trustpilot_reviews_growth_3m_change`	`integer` `BIGINT`	Number of total Trustpilot reviews gained or lost in the last three months.
`trustpilot_reviews_growth_4m_change`	`integer` `BIGINT`	Number of total Trustpilot reviews gained or lost in the last four months.
`trustpilot_reviews_growth_5m_change`	`integer` `BIGINT`	Number of total Trustpilot reviews gained or lost in the last five months.
`trustpilot_reviews_growth_6m_change`	`integer` `BIGINT`	Number of total Trustpilot reviews gained or lost in the last six months.
`trustpilot_reviews_growth_12m_change`	`integer` `BIGINT`	Number of total Trustpilot reviews gained or lost in the last 1 year.
`trustpilot_reviews_growth_24m_change`	`integer` `BIGINT`	Number of total Trustpilot reviews gained or lost in the last 2 years.
`glassdoor_ratings`	`number` `DOUBLE`	Company rating on Glassdoor.
`glassdoor_review_count`	`integer` `UINTEGER`	Number of total reviews on Glassdoor.
`glassdoor_leadership_approval`	`number` `DOUBLE`	Share of Glassdoor reviewers who approve of the company’s CEO, from 0 to 1.
`glassdoor_url`	`string` `VARCHAR`	Company profile URL on Glassdoor.
`glassdoor_ratings_overall_1m_change`	`number` `DOUBLE`	Change in the company’s overall Glassdoor rating in the last month.
`glassdoor_ratings_overall_2m_change`	`number` `DOUBLE`	Change in the company’s overall Glassdoor rating in the last two months.
`glassdoor_ratings_overall_3m_change`	`number` `DOUBLE`	Change in the company’s overall Glassdoor rating in the last three months.
`glassdoor_ratings_overall_4m_change`	`number` `DOUBLE`	Change in the company’s overall Glassdoor rating in the last four months.
`glassdoor_ratings_overall_5m_change`	`number` `DOUBLE`	Change in the company’s overall Glassdoor rating in the last five months.
`glassdoor_ratings_overall_6m_change`	`number` `DOUBLE`	Change in the company’s overall Glassdoor rating in the last six months.
`glassdoor_ratings_overall_12m_change`	`number` `DOUBLE`	Change in the company’s overall Glassdoor rating in the last 1 year.
`glassdoor_ratings_overall_24m_change`	`number` `DOUBLE`	Change in the company’s overall Glassdoor rating in the last 2 years.
`glassdoor_reviews_count_1m_change`	`integer` `BIGINT`	Number of total Glassdoor reviews gained or lost in the last month.
`glassdoor_reviews_count_2m_change`	`integer` `BIGINT`	Number of total Glassdoor reviews gained or lost in the last two months.
`glassdoor_reviews_count_3m_change`	`integer` `BIGINT`	Number of total Glassdoor reviews gained or lost in the last three months.
`glassdoor_reviews_count_4m_change`	`integer` `BIGINT`	Number of total Glassdoor reviews gained or lost in the last four months.
`glassdoor_reviews_count_5m_change`	`integer` `BIGINT`	Number of total Glassdoor reviews gained or lost in the last five months.
`glassdoor_reviews_count_6m_change`	`integer` `BIGINT`	Number of total Glassdoor reviews gained or lost in the last six months.
`glassdoor_reviews_count_12m_change`	`integer` `BIGINT`	Number of total Glassdoor reviews gained or lost in the last 1 year.
`glassdoor_reviews_count_24m_change`	`integer` `BIGINT`	Number of total Glassdoor reviews gained or lost in the last 2 years.
`chrome_extensions_data`	`array<object>` `STRUCT(…)[]`	Company Google Extensions data.
↳ `name`	`string` `VARCHAR`
↳ `url`	`string` `VARCHAR`
↳ `author`	`string` `VARCHAR`
↳ `is_featured`	`boolean` `BOOLEAN`
↳ `users`	`integer` `INTEGER`
↳ `rating`	`number` `FLOAT`
↳ `rating_count`	`integer` `INTEGER`
↳ `overall_rank`	`integer` `INTEGER`
↳ `extension_type`	`string` `VARCHAR`
`chrome_extensions_rating`	`number` `FLOAT`	Company rating on Google Extensions.
`chrome_extensions_reviews`	`integer` `BIGINT`	Number of total reviews on Google Extensions.
`chrome_extensions_reviews_growth_1m_change`	`integer` `BIGINT`	Number of total Google Extensions reviews gained or lost in the last month.
`chrome_extensions_reviews_growth_2m_change`	`integer` `BIGINT`	Number of total Google Extensions reviews gained or lost in the last two months.
`chrome_extensions_reviews_growth_3m_change`	`integer` `BIGINT`	Number of total Google Extensions reviews gained or lost in the last three months.
`chrome_extensions_reviews_growth_4m_change`	`integer` `BIGINT`	Number of total Google Extensions reviews gained or lost in the last four months.
`chrome_extensions_reviews_growth_5m_change`	`integer` `BIGINT`	Number of total Google Extensions reviews gained or lost in the last five months.
`chrome_extensions_reviews_growth_6m_change`	`integer` `BIGINT`	Number of total Google Extensions reviews gained or lost in the last six months.
`chrome_extensions_reviews_growth_12m_change`	`integer` `BIGINT`	Number of total Google Extensions reviews gained or lost in the last 1 year.
`chrome_extensions_reviews_growth_24m_change`	`integer` `BIGINT`	Number of total Google Extensions reviews gained or lost in the last 2 years.
`chrome_extensions_total_users`	`integer` `BIGINT`	Number of total users on Google Extensions.
`chrome_extensions_total_users_growth_1m_change`	`integer` `BIGINT`	Number of total Google Extensions users gained or lost in the last month.
`chrome_extensions_total_users_growth_2m_change`	`integer` `BIGINT`	Number of total Google Extensions users gained or lost in the last two months.
`chrome_extensions_total_users_growth_3m_change`	`integer` `BIGINT`	Number of total Google Extensions users gained or lost in the last three months.
`chrome_extensions_total_users_growth_4m_change`	`integer` `BIGINT`	Number of total Google Extensions users gained or lost in the last four months.
`chrome_extensions_total_users_growth_5m_change`	`integer` `BIGINT`	Number of total Google Extensions users gained or lost in the last five months.
`chrome_extensions_total_users_growth_6m_change`	`integer` `BIGINT`	Number of total Google Extensions users gained or lost in the last six months.
`chrome_extensions_total_users_growth_12m_change`	`integer` `BIGINT`	Number of total Google Extensions users gained or lost in the last 1 year.
`chrome_extensions_total_users_growth_24m_change`	`integer` `BIGINT`	Number of total Google Extensions users gained or lost in the last 2 years.
`it_spend_usd`	`integer` `BIGINT`	Company expenditure on IT in USD.
`technology_count`	`integer` `BIGINT`	Number of technologies within the company.
`technologies`	`array<string>` `VARCHAR[]`	Actives technologies within the company.
`patent_count`	`integer` `BIGINT`	Number of patents.
`trademark_count`	`integer` `BIGINT`	Number of trademarks.

Parquet schema: Product

Product

(
  certifications                                   VARCHAR[],
  g2_data                                          STRUCT(
    product_name VARCHAR,
    g2_link VARCHAR,
    reviews BIGINT,
    rating DOUBLE,
    star_distribution STRUCT(
      "1" UBIGINT,
      "2" UBIGINT,
      "3" UBIGINT,
      "4" UBIGINT,
      "5" UBIGINT
    )
  )[],
  g2_rating                                        DOUBLE,
  g2_review_count                                  UBIGINT,
  g2_reviews_growth_1m_change                      BIGINT,
  g2_reviews_growth_2m_change                      BIGINT,
  g2_reviews_growth_3m_change                      BIGINT,
  g2_reviews_growth_4m_change                      BIGINT,
  g2_reviews_growth_5m_change                      BIGINT,
  g2_reviews_growth_6m_change                      BIGINT,
  g2_reviews_growth_12m_change                     BIGINT,
  g2_reviews_growth_24m_change                     BIGINT,
  trustpilot_data                                  STRUCT(
    name VARCHAR,
    trustpilot_url VARCHAR,
    reviews BIGINT,
    star_distribution STRUCT(
      "1" BIGINT,
      "2" BIGINT,
      "3" BIGINT,
      "4" BIGINT,
      "5" BIGINT
    )
  ),
  trustpilot_rating                                DOUBLE,
  trustpilot_review_count                          UBIGINT,
  trustpilot_reviews_growth_1m_change              BIGINT,
  trustpilot_reviews_growth_2m_change              BIGINT,
  trustpilot_reviews_growth_3m_change              BIGINT,
  trustpilot_reviews_growth_4m_change              BIGINT,
  trustpilot_reviews_growth_5m_change              BIGINT,
  trustpilot_reviews_growth_6m_change              BIGINT,
  trustpilot_reviews_growth_12m_change             BIGINT,
  trustpilot_reviews_growth_24m_change             BIGINT,
  glassdoor_ratings                                DOUBLE,
  glassdoor_review_count                           UINTEGER,
  glassdoor_leadership_approval                    DOUBLE,
  glassdoor_url                                    VARCHAR,
  glassdoor_ratings_overall_1m_change              DOUBLE,
  glassdoor_ratings_overall_2m_change              DOUBLE,
  glassdoor_ratings_overall_3m_change              DOUBLE,
  glassdoor_ratings_overall_4m_change              DOUBLE,
  glassdoor_ratings_overall_5m_change              DOUBLE,
  glassdoor_ratings_overall_6m_change              DOUBLE,
  glassdoor_ratings_overall_12m_change             DOUBLE,
  glassdoor_ratings_overall_24m_change             DOUBLE,
  glassdoor_reviews_count_1m_change                BIGINT,
  glassdoor_reviews_count_2m_change                BIGINT,
  glassdoor_reviews_count_3m_change                BIGINT,
  glassdoor_reviews_count_4m_change                BIGINT,
  glassdoor_reviews_count_5m_change                BIGINT,
  glassdoor_reviews_count_6m_change                BIGINT,
  glassdoor_reviews_count_12m_change               BIGINT,
  glassdoor_reviews_count_24m_change               BIGINT,
  chrome_extensions_data                           STRUCT(
    name VARCHAR,
    url VARCHAR,
    author VARCHAR,
    is_featured BOOLEAN,
    users INTEGER,
    rating FLOAT,
    rating_count INTEGER,
    overall_rank INTEGER,
    extension_type VARCHAR
  )[],
  chrome_extensions_rating                         FLOAT,
  chrome_extensions_reviews                        BIGINT,
  chrome_extensions_reviews_growth_1m_change       BIGINT,
  chrome_extensions_reviews_growth_2m_change       BIGINT,
  chrome_extensions_reviews_growth_3m_change       BIGINT,
  chrome_extensions_reviews_growth_4m_change       BIGINT,
  chrome_extensions_reviews_growth_5m_change       BIGINT,
  chrome_extensions_reviews_growth_6m_change       BIGINT,
  chrome_extensions_reviews_growth_12m_change      BIGINT,
  chrome_extensions_reviews_growth_24m_change      BIGINT,
  chrome_extensions_total_users                    BIGINT,
  chrome_extensions_total_users_growth_1m_change   BIGINT,
  chrome_extensions_total_users_growth_2m_change   BIGINT,
  chrome_extensions_total_users_growth_3m_change   BIGINT,
  chrome_extensions_total_users_growth_4m_change   BIGINT,
  chrome_extensions_total_users_growth_5m_change   BIGINT,
  chrome_extensions_total_users_growth_6m_change   BIGINT,
  chrome_extensions_total_users_growth_12m_change  BIGINT,
  chrome_extensions_total_users_growth_24m_change  BIGINT,
  it_spend_usd                                     BIGINT,
  technology_count                                 BIGINT,
  technologies                                     VARCHAR[],
  patent_count                                     BIGINT,
  trademark_count                                  BIGINT
)

Web Intelligence

Field	Type	Description
`web_visits`	`integer` `BIGINT`	Company monthly web visits.
`web_visits_growth_1m_percentage`	`number` % `DOUBLE`	Percentage monthly growth or loss in web visits.
`web_visits_growth_2m_percentage`	`number` % `DOUBLE`	Percentage 2 month growth or loss in web visits.
`web_visits_growth_3m_percentage`	`number` % `DOUBLE`	Percentage 3 month growth or loss in web visits.
`web_visits_growth_4m_percentage`	`number` % `DOUBLE`	Percentage 4 month growth or loss in web visits.
`web_visits_growth_5m_percentage`	`number` % `DOUBLE`	Percentage 5 month growth or loss in web visits.
`web_visits_growth_6m_percentage`	`number` % `DOUBLE`	Percentage 6 month growth or loss in web visits.
`web_visits_growth_12m_percentage`	`number` % `DOUBLE`	Percentage 1 year growth or loss in web visits.
`web_visits_growth_24m_percentage`	`number` % `DOUBLE`	Percentage 2 year growth or loss in web visits.
`web_top_country`	`string` `VARCHAR`	Top country in terms of monthly web visits.
`web_country_breakdown`	`array<object>` % `STRUCT(…)[]`	Country breakdown of monthly web visits.
↳ `country_code`	`string` `VARCHAR`
↳ `value`	`number` `DOUBLE`
`web_traffic_breakdown`	`array<object>` % `STRUCT(…)[]`	Breakdown of traffic sources of monthly web visits.
↳ `key`	`string` `VARCHAR`
↳ `value`	`number` `DOUBLE`
`web_bounce_rate`	`number` % `DOUBLE`	Share of website visits that leave after a single page.
`web_bounce_rate_growth_3m_change`	`number` % `DOUBLE`	Percentage 3 month growth or loss in bounce rate.
`web_session_duration`	`integer` `BIGINT`	Average session duration in seconds.
`web_session_duration_growth_3m_change`	`integer` `BIGINT`	Absolute 3 month growth or loss in session duration.
`web_pages_per_visit`	`number` `DOUBLE`	Average pages per visit.
`web_pages_per_visit_growth_3m_change`	`number` `DOUBLE`	Absolute 3 month growth or loss in pages per visit.
`web_popularity_rank`	`integer` `INTEGER`	Website popularity rank.
`web_popularity_rank_growth_1m_change`	`integer` `BIGINT`	Website popularity rank monthly growth or loss.
`web_popularity_rank_growth_2m_change`	`integer` `BIGINT`	Website popularity rank 2 month growth or loss.
`web_popularity_rank_growth_3m_change`	`integer` `BIGINT`	Website popularity rank 3 month growth or loss.
`web_popularity_rank_growth_4m_change`	`integer` `BIGINT`	Website popularity rank 4 month growth or loss.
`web_popularity_rank_growth_5m_change`	`integer` `BIGINT`	Website popularity rank 5 month growth or loss.
`web_popularity_rank_growth_6m_change`	`integer` `BIGINT`	Website popularity rank 6 month growth or loss.
`web_popularity_rank_growth_12m_change`	`integer` `BIGINT`	Website popularity rank 1 year growth or loss.
`web_popularity_rank_growth_24m_change`	`integer` `BIGINT`	Website popularity rank 2 year growth or loss.

Parquet schema: Web Intelligence

Web Intelligence

(
  web_visits                             BIGINT,
  web_visits_growth_1m_percentage        DOUBLE,
  web_visits_growth_2m_percentage        DOUBLE,
  web_visits_growth_3m_percentage        DOUBLE,
  web_visits_growth_4m_percentage        DOUBLE,
  web_visits_growth_5m_percentage        DOUBLE,
  web_visits_growth_6m_percentage        DOUBLE,
  web_visits_growth_12m_percentage       DOUBLE,
  web_visits_growth_24m_percentage       DOUBLE,
  web_top_country                        VARCHAR,
  web_country_breakdown                  STRUCT(
    country_code VARCHAR,
    value DOUBLE
  )[],
  web_traffic_breakdown                  STRUCT(
    key VARCHAR,
    value DOUBLE
  )[],
  web_bounce_rate                        DOUBLE,
  web_bounce_rate_growth_3m_change       DOUBLE,
  web_session_duration                   BIGINT,
  web_session_duration_growth_3m_change  BIGINT,
  web_pages_per_visit                    DOUBLE,
  web_pages_per_visit_growth_3m_change   DOUBLE,
  web_popularity_rank                    INTEGER,
  web_popularity_rank_growth_1m_change   BIGINT,
  web_popularity_rank_growth_2m_change   BIGINT,
  web_popularity_rank_growth_3m_change   BIGINT,
  web_popularity_rank_growth_4m_change   BIGINT,
  web_popularity_rank_growth_5m_change   BIGINT,
  web_popularity_rank_growth_6m_change   BIGINT,
  web_popularity_rank_growth_12m_change  BIGINT,
  web_popularity_rank_growth_24m_change  BIGINT
)

Field	Type	Description
`linkedin_url`	`string` `VARCHAR`	URL of the company’s LinkedIn page.
`linkedin_follower_count`	`integer` `INTEGER`	Number of LinkedIn followers.
`linkedin_followers_growth_1m_change`	`integer` `BIGINT`	Number of LinkedIn followers gained or lost in the last month.
`linkedin_followers_growth_2m_change`	`integer` `BIGINT`	Number of LinkedIn followers gained or lost in the last two months.
`linkedin_followers_growth_3m_change`	`integer` `BIGINT`	Number of LinkedIn followers gained or lost in the last three months.
`linkedin_followers_growth_4m_change`	`integer` `BIGINT`	Number of LinkedIn followers gained or lost in the last four months.
`linkedin_followers_growth_5m_change`	`integer` `BIGINT`	Number of LinkedIn followers gained or lost in the last five months.
`linkedin_followers_growth_6m_change`	`integer` `BIGINT`	Number of LinkedIn followers gained or lost in the last six months.
`linkedin_followers_growth_12m_change`	`integer` `BIGINT`	Number of LinkedIn followers gained or lost in the last one year.
`linkedin_followers_growth_24m_change`	`integer` `BIGINT`	Number of LinkedIn followers gained or lost in the last two years.
`twitter_url`	`string` `VARCHAR`	URL of the company’s X (Twitter) profile.
`twitter_follower_count`	`integer` `INTEGER`	Number of Twitter followers.
`twitter_followers_growth_1m_change`	`integer` `BIGINT`	Number of Twitter followers gained or lost in the last month.
`twitter_followers_growth_2m_change`	`integer` `BIGINT`	Number of Twitter followers gained or lost in the last two months.
`twitter_followers_growth_3m_change`	`integer` `BIGINT`	Number of Twitter followers gained or lost in the last three months.
`twitter_followers_growth_4m_change`	`integer` `BIGINT`	Number of Twitter followers gained or lost in the last four months.
`twitter_followers_growth_5m_change`	`integer` `BIGINT`	Number of Twitter followers gained or lost in the last five months.
`twitter_followers_growth_6m_change`	`integer` `BIGINT`	Number of Twitter followers gained or lost in the last six months.
`twitter_followers_growth_12m_change`	`integer` `BIGINT`	Number of Twitter followers gained or lost in the last one year.
`twitter_followers_growth_24m_change`	`integer` `BIGINT`	Number of Twitter followers gained or lost in the last two years.
`instagram_url`	`string` `VARCHAR`	Company Instagram URL.
`instagram_follower_count`	`integer` `INTEGER`	Number of Instagram followers.
`instagram_followers_growth_1m_change`	`integer` `BIGINT`	Number of Instagram followers gained or lost in the last month.
`instagram_followers_growth_2m_change`	`integer` `BIGINT`	Number of Instagram followers gained or lost in the last two months.
`instagram_followers_growth_3m_change`	`integer` `BIGINT`	Number of Instagram followers gained or lost in the last three months.
`instagram_followers_growth_4m_change`	`integer` `BIGINT`	Number of Instagram followers gained or lost in the last four months.
`instagram_followers_growth_5m_change`	`integer` `BIGINT`	Number of Instagram followers gained or lost in the last five months.
`instagram_followers_growth_6m_change`	`integer` `BIGINT`	Number of Instagram followers gained or lost in the last six months.
`instagram_followers_growth_12m_change`	`integer` `BIGINT`	Number of Instagram followers gained or lost in the last one year.
`instagram_followers_growth_24m_change`	`integer` `BIGINT`	Number of Instagram followers gained or lost in the last two years.
`instagram_following_count`	`integer` `INTEGER`	Number of accounts the company follows on Instagram.
`contact_email`	`string` `VARCHAR`	Company general email.
`contact_phone_number`	`string` `VARCHAR`	Company general office phone number.
`facebook_url`	`string` `VARCHAR`	Company Facebook URL.

Social Engagement

(
  linkedin_url                           VARCHAR,
  linkedin_follower_count                INTEGER,
  linkedin_followers_growth_1m_change    BIGINT,
  linkedin_followers_growth_2m_change    BIGINT,
  linkedin_followers_growth_3m_change    BIGINT,
  linkedin_followers_growth_4m_change    BIGINT,
  linkedin_followers_growth_5m_change    BIGINT,
  linkedin_followers_growth_6m_change    BIGINT,
  linkedin_followers_growth_12m_change   BIGINT,
  linkedin_followers_growth_24m_change   BIGINT,
  twitter_url                            VARCHAR,
  twitter_follower_count                 INTEGER,
  twitter_followers_growth_1m_change     BIGINT,
  twitter_followers_growth_2m_change     BIGINT,
  twitter_followers_growth_3m_change     BIGINT,
  twitter_followers_growth_4m_change     BIGINT,
  twitter_followers_growth_5m_change     BIGINT,
  twitter_followers_growth_6m_change     BIGINT,
  twitter_followers_growth_12m_change    BIGINT,
  twitter_followers_growth_24m_change    BIGINT,
  instagram_url                          VARCHAR,
  instagram_follower_count               INTEGER,
  instagram_followers_growth_1m_change   BIGINT,
  instagram_followers_growth_2m_change   BIGINT,
  instagram_followers_growth_3m_change   BIGINT,
  instagram_followers_growth_4m_change   BIGINT,
  instagram_followers_growth_5m_change   BIGINT,
  instagram_followers_growth_6m_change   BIGINT,
  instagram_followers_growth_12m_change  BIGINT,
  instagram_followers_growth_24m_change  BIGINT,
  instagram_following_count              INTEGER,
  contact_email                          VARCHAR,
  contact_phone_number                   VARCHAR,
  facebook_url                           VARCHAR
)

App Performance

Field	Type	Description
`total_app_downloads`	`integer` `BIGINT`	Sum of monthly app downloads across all apps of the organization.
`total_app_downloads_growth_1m_percentage`	`number` % `DOUBLE`	Percentage monthly growth or loss in total app downloads.
`total_app_downloads_growth_2m_percentage`	`number` % `DOUBLE`	Percentage 2 month growth or loss in total app downloads.
`total_app_downloads_growth_3m_percentage`	`number` % `DOUBLE`	Percentage 3 month growth or loss in total app downloads.
`total_app_downloads_growth_4m_percentage`	`number` % `DOUBLE`	Percentage 4 month growth or loss in total app downloads.
`total_app_downloads_growth_5m_percentage`	`number` % `DOUBLE`	Percentage 5 month growth or loss in total app downloads.
`total_app_downloads_growth_6m_percentage`	`number` % `DOUBLE`	Percentage 6 month growth or loss in total app downloads.
`total_app_downloads_growth_12m_percentage`	`number` % `DOUBLE`	Percentage 1 year growth or loss in total app downloads.
`total_app_downloads_growth_24m_percentage`	`number` % `DOUBLE`	Percentage 2 years growth or loss in total app downloads.
`app_store_publisher_urls`	`array<string>` `VARCHAR[]`	All app store publisher URLs of the company. In CSV, values are separated by `;`.
`app_store_data`	`array<object>` `STRUCT(…)[]`	Detailed metrics for each of company’s app store apps.
↳ `publisher_id`	`string` `VARCHAR`
↳ `publisher_name`	`string` `VARCHAR`
↳ `apps`	`array<object>` `STRUCT(…)[]`
↳ `id`	`string` `VARCHAR`
↳ `name`	`string` `VARCHAR`
↳ `app_url`	`string` `VARCHAR`
↳ `reviews`	`integer` `BIGINT`
↳ `rating`	`number` `DOUBLE`
↳ `app_icon`	`string` `VARCHAR`
↳ `downloads`	`integer` `BIGINT`
`app_store_rating`	`number` `DOUBLE`	Weighted average rating of company’s app store apps (weighted by downloads)
`app_store_reviews`	`integer` `BIGINT`	Total number of reviews across company’s app store apps.
`app_store_reviews_growth_1m_change`	`integer` `BIGINT`	Number of App Store reviews gained or lost in the last month.
`app_store_reviews_growth_2m_change`	`integer` `BIGINT`	Number of App Store reviews gained or lost in the last two months.
`app_store_reviews_growth_3m_change`	`integer` `BIGINT`	Number of App Store reviews gained or lost in the last three months.
`app_store_reviews_growth_4m_change`	`integer` `BIGINT`	Number of App Store reviews gained or lost in the last four months.
`app_store_reviews_growth_5m_change`	`integer` `BIGINT`	Number of App Store reviews gained or lost in the last five months.
`app_store_reviews_growth_6m_change`	`integer` `BIGINT`	Number of App Store reviews gained or lost in the last six months.
`app_store_reviews_growth_12m_change`	`integer` `BIGINT`	Number of App Store reviews gained or lost in the last 1 year.
`app_store_reviews_growth_24m_change`	`integer` `BIGINT`	Number of App Store reviews gained or lost in the last 2 years.
`googleplay_publisher_urls`	`array<string>` `VARCHAR[]`	All Google Play publisher URLs of the company. In CSV, values are separated by `;`.
`googleplay_data`	`array<object>` `STRUCT(…)[]`	Detailed metrics for each of company’s googleplay apps.
↳ `publisher_id`	`string` `VARCHAR`
↳ `publisher_name`	`string` `VARCHAR`
↳ `apps`	`array<object>` `STRUCT(…)[]`
↳ `id`	`string` `VARCHAR`
↳ `name`	`string` `VARCHAR`
↳ `app_url`	`string` `VARCHAR`
↳ `reviews`	`integer` `BIGINT`
↳ `rating`	`number` `DOUBLE`
↳ `app_icon`	`string` `VARCHAR`
↳ `downloads`	`integer` `BIGINT`
`googleplay_rating`	`number` `DOUBLE`	Weighted average rating of company’s Google Play apps (weighted by downloads)
`googleplay_reviews`	`integer` `BIGINT`	Total number of reviews across company’s Google Play apps.
`googleplay_reviews_growth_1m_change`	`integer` `BIGINT`	Number of Google Play reviews gained or lost in the last month.
`googleplay_reviews_growth_2m_change`	`integer` `BIGINT`	Number of Google Play reviews gained or lost in the last two months.
`googleplay_reviews_growth_3m_change`	`integer` `BIGINT`	Number of Google Play reviews gained or lost in the last three months.
`googleplay_reviews_growth_4m_change`	`integer` `BIGINT`	Number of Google Play reviews gained or lost in the last four months.
`googleplay_reviews_growth_5m_change`	`integer` `BIGINT`	Number of Google Play reviews gained or lost in the last five months.
`googleplay_reviews_growth_6m_change`	`integer` `BIGINT`	Number of Google Play reviews gained or lost in the last six months.
`googleplay_reviews_growth_12m_change`	`integer` `BIGINT`	Number of Google Play reviews gained or lost in the last 1 year.
`googleplay_reviews_growth_24m_change`	`integer` `BIGINT`	Number of Google Play reviews gained or lost in the last 2 years.

Parquet schema: App Performance

App Performance

(
  total_app_downloads                        BIGINT,
  total_app_downloads_growth_1m_percentage   DOUBLE,
  total_app_downloads_growth_2m_percentage   DOUBLE,
  total_app_downloads_growth_3m_percentage   DOUBLE,
  total_app_downloads_growth_4m_percentage   DOUBLE,
  total_app_downloads_growth_5m_percentage   DOUBLE,
  total_app_downloads_growth_6m_percentage   DOUBLE,
  total_app_downloads_growth_12m_percentage  DOUBLE,
  total_app_downloads_growth_24m_percentage  DOUBLE,
  app_store_publisher_urls                   VARCHAR[],
  app_store_data                             STRUCT(
    publisher_id VARCHAR,
    publisher_name VARCHAR,
    apps STRUCT(
      id VARCHAR,
      name VARCHAR,
      app_url VARCHAR,
      reviews BIGINT,
      rating DOUBLE,
      app_icon VARCHAR,
      downloads BIGINT
    )[]
  )[],
  app_store_rating                           DOUBLE,
  app_store_reviews                          BIGINT,
  app_store_reviews_growth_1m_change         BIGINT,
  app_store_reviews_growth_2m_change         BIGINT,
  app_store_reviews_growth_3m_change         BIGINT,
  app_store_reviews_growth_4m_change         BIGINT,
  app_store_reviews_growth_5m_change         BIGINT,
  app_store_reviews_growth_6m_change         BIGINT,
  app_store_reviews_growth_12m_change        BIGINT,
  app_store_reviews_growth_24m_change        BIGINT,
  googleplay_publisher_urls                  VARCHAR[],
  googleplay_data                            STRUCT(
    publisher_id VARCHAR,
    publisher_name VARCHAR,
    apps STRUCT(
      id VARCHAR,
      name VARCHAR,
      app_url VARCHAR,
      reviews BIGINT,
      rating DOUBLE,
      app_icon VARCHAR,
      downloads BIGINT
    )[]
  )[],
  googleplay_rating                          DOUBLE,
  googleplay_reviews                         BIGINT,
  googleplay_reviews_growth_1m_change        BIGINT,
  googleplay_reviews_growth_2m_change        BIGINT,
  googleplay_reviews_growth_3m_change        BIGINT,
  googleplay_reviews_growth_4m_change        BIGINT,
  googleplay_reviews_growth_5m_change        BIGINT,
  googleplay_reviews_growth_6m_change        BIGINT,
  googleplay_reviews_growth_12m_change       BIGINT,
  googleplay_reviews_growth_24m_change       BIGINT
)

Awards & News

Field	Type	Description
`awards`	`array<object>` `STRUCT(…)[]`	Awards presented to company.
↳ `awarding_organization`	`string` `VARCHAR`
↳ `award_name`	`string` `VARCHAR`
↳ `award_details`	`string` `VARCHAR`
↳ `award_link`	`string` `VARCHAR`
↳ `award_year`	`integer` `INTEGER`
`awards_count`	`integer` `UINTEGER`	Number of awards presented to company.

Parquet schema: Awards & News

Awards & News

(
  awards        STRUCT(
    awarding_organization VARCHAR,
    award_name VARCHAR,
    award_details VARCHAR,
    award_link VARCHAR,
    award_year INTEGER
  )[],
  awards_count  UINTEGER
)

CSV column names

The CSV delivery carries the same fields under the headers below. Parquet, JSONL and the API all use the field name.

Field	CSV column
`company_id`	Specter - Organization ID
`specter_strategic_signal_ids`	Specter - Strategic Signal IDs
`company_rank`	Rank
`highlights`	Highlights
`last_updated`	Last Updated
`status`	Status
`company_name`	Company Name
`company_name_alias`	Company Name Aliases
`website_domain`	Domain
`website_url`	Website
`website_other_domains`	Other Domains
`operating_status`	Operating Status
`primary_role`	Primary Role
`roles`	Roles
`founded_year`	Founded Date
`growth_stage`	Growth Stage
`tagline`	Tagline
`description`	Description
`customer_focus`	Customer Focus
`business_models`	Business Models
`specter_industry`	Industry
`specter_tech_verticals`	Tech Verticals
`tags`	Tags
`hq_location`	HQ Location
`hq_regions`	HQ Regions
`reported_clients`	Reported Clients
`customer_profile`	Typical Customer Profile
`traction_highlights`	Reported Traction Highlights
`total_funding_usd`	Total Funding Amount (in USD)
`last_funding_usd`	Last Funding Amount (in USD)
`last_funding_date`	Last Funding Date
`last_funding_type`	Last Funding Type
`post_money_valuation_usd`	Post Money Valuation (in USD)
`funding_round_count`	Number of Funding Rounds
`investor_count`	Number of Investors
`investors_details`	Investors Details
`funding_rounds_details`	Funding Rounds Details
`acquisition_acquirer`	Acquired By
`acquisition_date`	Acquisition Date
`acquisition_amount_usd`	Acquisition Price (in USD)
`ipo`	IPO Details
`founders`	Founders
`founder_highlights`	Founder Highlights
`team_location_breakdown`	Team Location Breakdown
`team_department_breakdown`	Team Department Breakdown
`founder_count`	Number of Founders
`employee_count_range`	Company Size
`employee_count`	Employee Count
`employee_count_growth_1m_percentage`	Employees - Monthly Growth
`employee_count_growth_2m_percentage`	Employees - 2 Months Growth
`employee_count_growth_3m_percentage`	Employees - 3 Months Growth
`employee_count_growth_4m_percentage`	Employees - 4 Months Growth
`employee_count_growth_5m_percentage`	Employees - 5 Months Growth
`employee_count_growth_6m_percentage`	Employees - 6 Months Growth
`employee_count_growth_12m_percentage`	Employees - 1 Year Growth
`employee_count_growth_24m_percentage`	Employees - 2 Year Growth
`web_visits`	Web Visits
`web_visits_growth_1m_percentage`	Web Visits - Monthly Growth
`web_visits_growth_2m_percentage`	Web Visits - 2 Months Growth
`web_visits_growth_3m_percentage`	Web Visits - 3 Months Growth
`web_visits_growth_4m_percentage`	Web Visits - 4 Months Growth
`web_visits_growth_5m_percentage`	Web Visits - 5 Months Growth
`web_visits_growth_6m_percentage`	Web Visits - 6 Months Growth
`web_visits_growth_12m_percentage`	Web Visits - 1 Year Growth
`web_visits_growth_24m_percentage`	Web Visits - 2 Year Growth
`web_top_country`	Top Country
`web_country_breakdown`	Country Breakdown
`web_traffic_breakdown`	Traffic Sources
`web_bounce_rate`	Bounce Rate
`web_bounce_rate_growth_3m_change`	Bounce Rate - 3 Months Growth
`web_session_duration`	Session Duration (s)
`web_session_duration_growth_3m_change`	Session Duration (s) - 3 Months Growth
`web_pages_per_visit`	Pages per Visit
`web_pages_per_visit_growth_3m_change`	Pages per Visit - 3 Months Growth
`web_popularity_rank`	Website Popularity Rank
`web_popularity_rank_growth_1m_change`	Website Popularity Rank - Monthly Growth
`web_popularity_rank_growth_2m_change`	Website Popularity Rank - 2 Months Growth
`web_popularity_rank_growth_3m_change`	Website Popularity Rank - 3 Months Growth
`web_popularity_rank_growth_4m_change`	Website Popularity Rank - 4 Months Growth
`web_popularity_rank_growth_5m_change`	Website Popularity Rank - 5 Months Growth
`web_popularity_rank_growth_6m_change`	Website Popularity Rank - 6 Months Growth
`web_popularity_rank_growth_12m_change`	Website Popularity Rank - 1 Year Growth
`web_popularity_rank_growth_24m_change`	Website Popularity Rank - 2 Year Growth
`linkedin_url`	LinkedIn - URL
`linkedin_follower_count`	LinkedIn - Followers
`linkedin_followers_growth_1m_change`	LinkedIn - Monthly Followers Growth
`linkedin_followers_growth_2m_change`	LinkedIn - 2 Months Followers Growth
`linkedin_followers_growth_3m_change`	LinkedIn - 3 Months Followers Growth
`linkedin_followers_growth_4m_change`	LinkedIn - 4 Months Followers Growth
`linkedin_followers_growth_5m_change`	LinkedIn - 5 Months Followers Growth
`linkedin_followers_growth_6m_change`	LinkedIn - 6 Months Followers Growth
`linkedin_followers_growth_12m_change`	LinkedIn - 1 Year Followers Growth
`linkedin_followers_growth_24m_change`	LinkedIn - 2 Year Followers Growth
`twitter_url`	Twitter - URL
`twitter_follower_count`	Twitter - Followers
`twitter_followers_growth_1m_change`	Twitter - Monthly Followers Growth
`twitter_followers_growth_2m_change`	Twitter - 2 Months Followers Growth
`twitter_followers_growth_3m_change`	Twitter - 3 Months Followers Growth
`twitter_followers_growth_4m_change`	Twitter - 4 Months Followers Growth
`twitter_followers_growth_5m_change`	Twitter - 5 Months Followers Growth
`twitter_followers_growth_6m_change`	Twitter - 6 Months Followers Growth
`twitter_followers_growth_12m_change`	Twitter - 1 Year Followers Growth
`twitter_followers_growth_24m_change`	Twitter - 2 Year Followers Growth
`instagram_url`	Instagram - URL
`instagram_follower_count`	Instagram - Followers
`instagram_followers_growth_1m_change`	Instagram - Monthly Followers Growth
`instagram_followers_growth_2m_change`	Instagram - 2 Months Followers Growth
`instagram_followers_growth_3m_change`	Instagram - 3 Months Followers Growth
`instagram_followers_growth_4m_change`	Instagram - 4 Months Followers Growth
`instagram_followers_growth_5m_change`	Instagram - 5 Months Followers Growth
`instagram_followers_growth_6m_change`	Instagram - 6 Months Followers Growth
`instagram_followers_growth_12m_change`	Instagram - 1 Year Followers Growth
`instagram_followers_growth_24m_change`	Instagram - 2 Year Followers Growth
`instagram_following_count`	Instagram - Following
`contact_email`	Contact Email
`contact_phone_number`	Phone Number
`facebook_url`	Facebook - URL
`total_app_downloads`	Total App Downloads
`total_app_downloads_growth_1m_percentage`	Total App Downloads - Monthly Growth
`total_app_downloads_growth_2m_percentage`	Total App Downloads - 2 Months Growth
`total_app_downloads_growth_3m_percentage`	Total App Downloads - 3 Months Growth
`total_app_downloads_growth_4m_percentage`	Total App Downloads - 4 Months Growth
`total_app_downloads_growth_5m_percentage`	Total App Downloads - 5 Months Growth
`total_app_downloads_growth_6m_percentage`	Total App Downloads - 6 Months Growth
`total_app_downloads_growth_12m_percentage`	Total App Downloads - 1 Year Growth
`total_app_downloads_growth_24m_percentage`	Total App Downloads - 2 Year Growth
`app_store_publisher_urls`	App Store - Publisher URLs
`app_store_data`	App Store - Data
`app_store_rating`	App Store - Rating
`app_store_reviews`	App Store - Reviews
`app_store_reviews_growth_1m_change`	App Store - Monthly Reviews Growth
`app_store_reviews_growth_2m_change`	App Store - 2 Months Reviews Growth
`app_store_reviews_growth_3m_change`	App Store - 3 Months Reviews Growth
`app_store_reviews_growth_4m_change`	App Store - 4 Months Reviews Growth
`app_store_reviews_growth_5m_change`	App Store - 5 Months Reviews Growth
`app_store_reviews_growth_6m_change`	App Store - 6 Months Reviews Growth
`app_store_reviews_growth_12m_change`	App Store - 1 Year Reviews Growth
`app_store_reviews_growth_24m_change`	App Store - 2 Year Reviews Growth
`googleplay_publisher_urls`	Google Play - Publisher URLs
`googleplay_data`	Google Play - Data
`googleplay_rating`	Google Play - Rating
`googleplay_reviews`	Google Play - Reviews
`googleplay_reviews_growth_1m_change`	Google Play - Monthly Reviews Growth
`googleplay_reviews_growth_2m_change`	Google Play - 2 Months Reviews Growth
`googleplay_reviews_growth_3m_change`	Google Play - 3 Months Reviews Growth
`googleplay_reviews_growth_4m_change`	Google Play - 4 Months Reviews Growth
`googleplay_reviews_growth_5m_change`	Google Play - 5 Months Reviews Growth
`googleplay_reviews_growth_6m_change`	Google Play - 6 Months Reviews Growth
`googleplay_reviews_growth_12m_change`	Google Play - 1 Year Reviews Growth
`googleplay_reviews_growth_24m_change`	Google Play - 2 Year Reviews Growth
`certifications`	Certifications
`g2_data`	G2 - Data
`g2_rating`	G2 - Rating
`g2_review_count`	G2 - Total Reviews
`g2_reviews_growth_1m_change`	G2 - Total Monthly Reviews Growth
`g2_reviews_growth_2m_change`	G2 - Total 2 Months Reviews Growth
`g2_reviews_growth_3m_change`	G2 - Total 3 Months Reviews Growth
`g2_reviews_growth_4m_change`	G2 - Total 4 Months Reviews Growth
`g2_reviews_growth_5m_change`	G2 - Total 5 Months Reviews Growth
`g2_reviews_growth_6m_change`	G2 - Total 6 Months Reviews Growth
`g2_reviews_growth_12m_change`	G2 - Total 1 Year Reviews Growth
`g2_reviews_growth_24m_change`	G2 - Total 2 Year Reviews Growth
`trustpilot_data`	Trustpilot - Data
`trustpilot_rating`	Trustpilot - Rating
`trustpilot_review_count`	Trustpilot - Total Reviews
`trustpilot_reviews_growth_1m_change`	Trustpilot - Total Monthly Reviews Growth
`trustpilot_reviews_growth_2m_change`	Trustpilot - Total 2 Months Reviews Growth
`trustpilot_reviews_growth_3m_change`	Trustpilot - Total 3 Months Reviews Growth
`trustpilot_reviews_growth_4m_change`	Trustpilot - Total 4 Months Reviews Growth
`trustpilot_reviews_growth_5m_change`	Trustpilot - Total 5 Months Reviews Growth
`trustpilot_reviews_growth_6m_change`	Trustpilot - Total 6 Months Reviews Growth
`trustpilot_reviews_growth_12m_change`	Trustpilot - Total 1 Year Reviews Growth
`trustpilot_reviews_growth_24m_change`	Trustpilot - Total 2 Year Reviews Growth
`glassdoor_ratings`	Glassdoor - Rating
`glassdoor_review_count`	Glassdoor - Total Reviews
`glassdoor_leadership_approval`	Glassdoor - Leadership Approval (%)
`glassdoor_url`	Glassdoor - URL
`glassdoor_ratings_overall_1m_change`	Glassdoor - Rating Monthly Growth
`glassdoor_ratings_overall_2m_change`	Glassdoor - Rating 2 Months Growth
`glassdoor_ratings_overall_3m_change`	Glassdoor - Rating 3 Months Growth
`glassdoor_ratings_overall_4m_change`	Glassdoor - Rating 4 Months Growth
`glassdoor_ratings_overall_5m_change`	Glassdoor - Rating 5 Months Growth
`glassdoor_ratings_overall_6m_change`	Glassdoor - Rating 6 Months Growth
`glassdoor_ratings_overall_12m_change`	Glassdoor - Rating 1 Year Growth
`glassdoor_ratings_overall_24m_change`	Glassdoor - Rating 2 Year Growth
`glassdoor_reviews_count_1m_change`	Glassdoor - Total Reviews Monthly Growth
`glassdoor_reviews_count_2m_change`	Glassdoor - Total Reviews 2 Months Growth
`glassdoor_reviews_count_3m_change`	Glassdoor - Total Reviews 3 Months Growth
`glassdoor_reviews_count_4m_change`	Glassdoor - Total Reviews 4 Months Growth
`glassdoor_reviews_count_5m_change`	Glassdoor - Total Reviews 5 Months Growth
`glassdoor_reviews_count_6m_change`	Glassdoor - Total Reviews 6 Months Growth
`glassdoor_reviews_count_12m_change`	Glassdoor - Total Reviews 1 Year Growth
`glassdoor_reviews_count_24m_change`	Glassdoor - Total Reviews 2 Year Growth
`chrome_extensions_data`	Chrome Extension - Data
`chrome_extensions_rating`	Chrome Extension - Rating
`chrome_extensions_reviews`	Chrome Extension - Total Reviews
`chrome_extensions_reviews_growth_1m_change`	Chrome Extension - Total Monthly Reviews Growth
`chrome_extensions_reviews_growth_2m_change`	Chrome Extension - Total 2 Months Reviews Growth
`chrome_extensions_reviews_growth_3m_change`	Chrome Extension - Total 3 Months Reviews Growth
`chrome_extensions_reviews_growth_4m_change`	Chrome Extension - Total 4 Months Reviews Growth
`chrome_extensions_reviews_growth_5m_change`	Chrome Extension - Total 5 Months Reviews Growth
`chrome_extensions_reviews_growth_6m_change`	Chrome Extension - Total 6 Months Reviews Growth
`chrome_extensions_reviews_growth_12m_change`	Chrome Extension - Total 1 Year Reviews Growth
`chrome_extensions_reviews_growth_24m_change`	Chrome Extension - Total 2 Year Reviews Growth
`chrome_extensions_total_users`	Chrome Extension - Total Users
`chrome_extensions_total_users_growth_1m_change`	Chrome Extension - Total Monthly Users Growth
`chrome_extensions_total_users_growth_2m_change`	Chrome Extension - Total 2 Months Users Growth
`chrome_extensions_total_users_growth_3m_change`	Chrome Extension - Total 3 Months Users Growth
`chrome_extensions_total_users_growth_4m_change`	Chrome Extension - Total 4 Months Users Growth
`chrome_extensions_total_users_growth_5m_change`	Chrome Extension - Total 5 Months Users Growth
`chrome_extensions_total_users_growth_6m_change`	Chrome Extension - Total 6 Months Users Growth
`chrome_extensions_total_users_growth_12m_change`	Chrome Extension - Total 1 Year Users Growth
`chrome_extensions_total_users_growth_24m_change`	Chrome Extension - Total 2 Year Users Growth
`pitchbook_url`	Pitchbook - URL
`crunchbase_url`	Crunchbase - URL
`it_spend_usd`	IT Spend (in USD)
`technology_count`	Number of Technologies
`technologies`	Active Technologies
`patent_count`	Number of Patents
`trademark_count`	Number of Trademarks
`awards`	Awards
`awards_count`	Award - Count

Get started

Core data

Signals

Field reference: Company DB

What’s in it

ID

Informative Data

Status

Timestamp

Team

Financials

Specter Growth

Product

Web Intelligence

App Performance

Awards & News

CSV column names

​What’s in it

​ID

​Informative Data

​Status

​Timestamp

​Team

​Financials

​Specter Growth

​Product

​Web Intelligence

​Social Engagement

​App Performance

​Awards & News

​CSV column names

What’s in it

ID

Informative Data

Status

Timestamp

Team

Financials

Specter Growth

Product

Web Intelligence

Social Engagement

App Performance

Awards & News

CSV column names