De-SPAC Lifecycle
get_de_spac_eventsDe-SPAC lifecycle: one row per SPAC business combination tracked from the
definitive-agreement announcement through registration, definitive proxy, shareholder
vote, exchange listing and completion (or termination / trust liquidation). Every row
carries the SPAC's own symbol (prior_ticker), the combined company's symbol as soon as a
filing names it (new_ticker -- the definitive proxy does so in most deals, weeks before
the close), warrant ticker, exchange, SPAC / target / new company names, and the dated
milestones: announced_date, meeting_date, record_date, vote_approved_date,
listing_filed_date, expected_close_date and expected_trading_date (each with a *_basis
column saying whether the date was stated in a filing or derived), closing_date,
trading_commencement_date, terminated_date, plus next_event_date / next_event_type for
what comes next. Completed rows also carry the closing financials (redemption shares and
dollars, trust remaining, PIPE, gross proceeds, pro forma shares, enterprise and equity
value), a confidence score and the supporting evidence quote. date is the SEC filing
date of the filing that set the row's current status (for completed deals: the closing
8-K). ticker is the symbol trading for the deal today (new_ticker once listing is
pending, otherwise prior_ticker). Fields are null where no filing supported them;
quality_flags lists any rule that altered or withheld a value.
Use status=pending&upcoming=true to see de-SPACs before the new symbol trades, ticker= to follow one deal, view=history to replay what was known on a given date, or status=completed with a date range for the classic redemption-rate event study.
Requires an Alphanume Pro API key. A 403 PRO_SUBSCRIPTION_REQUIRED or DATE_RANGE_RESTRICTED error means the key's plan does not cover the request -- it does not mean the data is missing.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| date | No | Exact date, YYYY-MM-DD. Cannot be combined with the date range parameters. | |
| view | No | 'latest' (default): one row per deal with its current status. 'history': the append-only status log, one row per transition (deal_id, status, date = filing date, created_at = when the pipeline first recorded it) for point-in-time replays. | |
| status | No | Comma-separated deal statuses to return: announced, registration_filed, registration_effective, vote_scheduled, approved, listing_pending, completed, terminated, liquidated; or the shorthands 'all' (default) and 'pending' (every non-terminal status). Unknown values return a 400 listing the valid ones. | |
| ticker | No | Symbol filter matched against BOTH the SPAC's own symbol (prior_ticker) and the post-combination symbol (new_ticker), so either side of the rename works. | |
| date_gt | No | Start of date range, exclusive (YYYY-MM-DD). | |
| date_lt | No | End of date range, exclusive (YYYY-MM-DD). | |
| date_gte | No | Start of date range, inclusive (YYYY-MM-DD). | |
| date_lte | No | End of date range, inclusive (YYYY-MM-DD). | |
| max_rows | No | Maximum data rows to return to the client (applied after the API responds). Default 500. Use 0 for no cap. Prefer narrowing with date/ticker filters over raising this. | |
| upcoming | No | 'true' = only pending deals with a future milestone (next_event_date >= today); 'false' = everything else. Omit for both. | |
| updated_since | No | Only rows updated at or after this timestamp (YYYY-MM-DD or YYYY-MM-DD HH:MM:SS); for incremental syncs. | |
| next_event_lte | No | YYYY-MM-DD: only deals whose next milestone (meeting, expected close or expected first trade) is on or before this date. |