Field reference: Transactions DB

All 43 fields of the Transactions DB, grouped by category.

Every field may be null unless marked required. Today funding_round_id, acquisition_id, ipo_id, company_id are 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
Funding Rounds	10
Acquisitions	10
IPOs	10
Company DB Attributes	13

Funding Rounds

Field	Type	Description
`funding_round_id`	`string` required `VARCHAR`	The Specter funding round ID.
`name`	`string` `VARCHAR`	The display name of the funding round.
`company_name`	`string` `VARCHAR`	The name of the company that raised this round.
`company_id`	`string` `VARCHAR`	The Specter company ID of the company that raised this round. Null if unmapped.
`investment_type`	`string` `VARCHAR`	The investment type / stage for this round. Null when Specter could not classify the round. One of 28 values, listed below the table.
`announced_on`	`date` `DATE`	The date the round was announced or closed.
`raised_amount_usd`	`number` `DOUBLE`	The total amount raised in this round, in USD.
`pre_money_valuation_usd`	`number` `DOUBLE`	The reported pre-money valuation in USD.
`post_money_valuation_usd`	`number` `DOUBLE`	Post-money valuation of the round, in USD.
`investors`	`array<object>` `STRUCT(…)[]`	All investors that participated in this round, including a lead flag per investor.
↳ `investor_id`	`string` `VARCHAR`
↳ `investor_name`	`string` `VARCHAR`
↳ `is_lead_investor`	`boolean` `BOOLEAN`

Parquet schema: Funding Rounds

Funding Rounds

(
  funding_round_id          VARCHAR,
  name                      VARCHAR,
  company_name              VARCHAR,
  company_id                VARCHAR,
  investment_type           VARCHAR,
  announced_on              DATE,
  raised_amount_usd         DOUBLE,
  pre_money_valuation_usd   DOUBLE,
  post_money_valuation_usd  DOUBLE,
  investors                 STRUCT(
    investor_id VARCHAR,
    investor_name VARCHAR,
    is_lead_investor BOOLEAN
  )[]
)

Accepted values for investment_type

Angel
Convertible Note
Corporate Round
Debt Financing
Equity Crowdfunding
Grant
Initial Coin Offering
Non Equity Assistance
Post Ipo Debt
Post Ipo Equity
Post Ipo Secondary
Pre Seed
Private Equity
Product Crowdfunding
Secondary Market
Seed
Series A
Series B
Series C
Series D
Series E
Series F
Series G
Series H
Series I
Series J
Series Unknown
Undisclosed

Acquisitions

Field	Type	Description
`acquisition_id`	`string` required `VARCHAR`	The Specter ID for this acquisition.
`acquirer_company_id`	`string` `VARCHAR`	The Specter company ID of the acquirer.
`acquirer_name`	`string` `VARCHAR`	The acquirer company’s display name.
`acquirer_domain`	`string` `VARCHAR`	The acquirer’s primary domain. Null if not available.
`acquiree_company_id`	`string` `VARCHAR`	The Specter company ID of the acquiree.
`acquiree_name`	`string` `VARCHAR`	The acquiree company’s display name.
`acquiree_domain`	`string` `VARCHAR`	The acquiree’s primary domain. Null if not available.
`acquisition_type`	`string` `VARCHAR`	The type of deal. Null when Specter could not classify the deal. One of `acquisition`, `merge`, `lbo`, `acquihire`, `management_buyout`.
`price_usd`	`integer` `BIGINT`	Deal value in USD, if disclosed. Null when undisclosed.
`acquisition_date`	`date` `DATE`	Date the acquisition was announced or closed.

Parquet schema: Acquisitions

Acquisitions

(
  acquisition_id       VARCHAR,
  acquirer_company_id  VARCHAR,
  acquirer_name        VARCHAR,
  acquirer_domain      VARCHAR,
  acquiree_company_id  VARCHAR,
  acquiree_name        VARCHAR,
  acquiree_domain      VARCHAR,
  acquisition_type     VARCHAR,
  price_usd            BIGINT,
  acquisition_date     DATE
)

IPOs

Field	Type	Description
`ipo_id`	`string` required `VARCHAR`	The Specter ID for this IPO.
`company_id`	`string` `VARCHAR`	The Specter company ID of the issuing company.
`company_name`	`string` `VARCHAR`	The issuing company’s display name.
`company_domain`	`string` `VARCHAR`	The issuing company’s primary domain. Null if not known.
`stock_exchange_symbol`	`string` `VARCHAR`	The exchange the company listed on (lowercase). Null if not disclosed.
`stock_symbol`	`string` `VARCHAR`	Ticker symbol of the company. Null if not disclosed.
`went_public_on`	`date` `DATE`	Date the company went public (YYYY-MM-DD). Null for private listings without published date.
`share_price_usd`	`number` `DOUBLE`	Initial offering share price in USD. Null for private listings without published share price.
`valuation_price_usd`	`number` `DOUBLE`	Implied valuation at listing in USD. Null if not disclosed.
`money_raised_usd`	`integer` `BIGINT`	Total proceeds from the offering in USD. Null if not disclosed.

Parquet schema: IPOs

IPOs

(
  ipo_id                 VARCHAR,
  company_id             VARCHAR,
  company_name           VARCHAR,
  company_domain         VARCHAR,
  stock_exchange_symbol  VARCHAR,
  stock_symbol           VARCHAR,
  went_public_on         DATE,
  share_price_usd        DOUBLE,
  valuation_price_usd    DOUBLE,
  money_raised_usd       BIGINT
)

Company DB Attributes

Field	Type	Description
`company_id`	`string` required `VARCHAR`	Specter identifier for the company. Resolves against the Company DB.
`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`	`string` `VARCHAR`	Additional domain names associated with the company.
`founded_year`	`integer` `INTEGER`	Year the company was founded.
`hq_location`	`string` `VARCHAR`	City-level location of the company’s headquarters.
`hq_regions`	`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.)
`linkedin_url`	`string` `VARCHAR`	URL of the company’s LinkedIn page.
`twitter_url`	`string` `VARCHAR`	URL of the company’s X (Twitter) profile.
`instagram_url`	`string` `VARCHAR`	Company Instagram URL.
`facebook_url`	`string` `VARCHAR`	Company Facebook URL.

Parquet schema: Company DB Attributes

Company DB Attributes

(
  company_id             VARCHAR,
  company_name           VARCHAR,
  company_name_alias     VARCHAR[],
  website_domain         VARCHAR,
  website_url            VARCHAR,
  website_other_domains  VARCHAR,
  founded_year           INTEGER,
  hq_location            VARCHAR,
  hq_regions             VARCHAR,
  linkedin_url           VARCHAR,
  twitter_url            VARCHAR,
  instagram_url          VARCHAR,
  facebook_url           VARCHAR
)

Get started

Core data

Signals

Field reference: Transactions DB

What’s in it

Funding Rounds

Acquisitions

IPOs

Company DB Attributes

​What’s in it

​Funding Rounds

​Acquisitions

​IPOs

​Company DB Attributes

What’s in it

Funding Rounds

Acquisitions

IPOs

Company DB Attributes