Introduction
This page documents the SPAC API structure, methods, and data dictionary.
The SPAC API is designed for use by licensed customers only. To obtain a license and accompanying API key, please visit https://www.spacapi.com and start the appropriate subscription.
If you have questions about the API or this documentation, please reach out to us using our Support page.
Table of Contents
Calling the API
The API is designed to be called from your centralized application server so that you can update your own set of database tables. The API is *not* designed to be called directly from your distributed client application (i.e., don't have end user apps calling the SPAC API directly).
Each API call should be an HTTPS GET with a custom header called "X-Spactrax" that contains your SPAC API Key. It is your responsibility to keep your key a secret, it should never be shared in user-accessible locations including client applications or web site code.
The API response will consist of a text string in a JSON format.
The data from each response can be tied together using the value called the "CIK Code." The CIK Code is a 10-digit unique company identifier used by the SEC. Since SPACs have more than one stock ticker and those tickers can change over time, we instead use the CIK Code to uniquely identify a company.
Rate Limits
Since the API is designed for calls to be made at intervals such as 15 minutes, 30 minutes, or daily, there are no rate limits imposed. The timing guidelines provided for each endpoint should get you the data you need when you need it, please do not abuse the system.
Field Considerations
When processing API responses, do not assume the order of the fields (i.e., you should reference fields by name rather than by their position/placement in the response).
There is no guarantee that every expected field will be a part of every similar JSON entry, so you should check each field for "undefined" or incorporate proper error handling in case an expected field is not present.
Over time, new fields may be added to the API responses as they become available in the system. For this reason your code should ignore any unexpected fields or incorporate proper error handling in the case of encountering "extra" fields. The addition of new fields will not be considered a breaking change to the API and will not necessarily warrant a new API version.
Test Using cURL
cURL is a popular command line tool used for transferring data using various network protocols. It is available for free download at: https://curl.se/.
You do not have to use cURL to access the SPAC API, but we provide examples using cURL for simplicity in testing.
You can test any SPAC API endpoint via cURL using the following format:
curl -H "X-Spactrax: Your_API_Key" End_Point_URL
For example, to call the TEAMS endpoint and output it to a file:
curl -H "X-Spactrax: Your_API_Key" https://api-v1-get-all-teams.spactrax.workers.dev -o spactrax_teams.json
Please note that even though the endpoints end with a ".dev" top-level domain, these are production endpoints. The SPAC API service utilizes Cloudflare to ensure the fastest and most reliable delivery, and the ".dev" is a Cloudflare naming convention.
Endpoint: All Companies
Endpoint:
https://api-v1-get-all-companies.spactrax.workers.dev
Recommended Calling Frequency:
Once every 30 to 60 minutes on weekdays
Test using cURL:
curl -H "X-Spactrax: Your_API_Key" https://api-v1-get-all-companies.spactrax.workers.dev
The All Companies endpoint returns the list of descriptive data for all SPACs, including items like ticker symbols, key dates, target info, etc. It does not include Team or Filings information (those are accessed by separate API calls).
The data returned by this endpoint changes frequently throughout the day based on SPAC activity filed with the SEC, especially in the periods near the market open and then again during the after hours session. So the recommendation would be to update SPAC data using this API once every 30 to 60 minutes on weekdays. Calling this endpoint more frequently than once every 30 minutes is not recommended, since the data feeding this API is updated every 30 minutes on the SPAC API side (although there may be zero changes in any given 30 minute period).
See the Data Dictionary section for detailed descriptions of the specific fields returned by this endpoint.
Endpoint: All Teams
Endpoint:
https://api-v1-get-all-teams.spactrax.workers.dev
Recommended Calling Frequency:
Once per day
Test using cURL:
curl -H "X-Spactrax: Your_API_Key" https://api-v1-get-all-teams.spactrax.workers.dev
The All Teams endpoint returns the Team information associated to a given SPAC. The response is organized by CIK Code so that you can match the Team info to its respective SPAC.
Note that the Teams text returned by the All Teams API response uses "\n" to indicate new lines.
The Teams text also uses a minimal amount of markdown syntax (e.g., text surrounded by "**" to represent bold formatting). For more information on markdown, please see https://www.markdownguide.org/basic-syntax/.
The Teams information is updated very *infrequently*, so calling this endpoint once per day (e.g., late at night or early morning) is sufficient.
Endpoint: Latest Filings
Endpoint:
https://api-v1-get-latest-filings.spactrax.workers.dev
Recommended Calling Frequency:
Once every 15 to 30 minutes on weekdays
Test using cURL:
curl -H "X-Spactrax: Your_API_Key" https://api-v1-get-latest-filings.spactrax.workers.dev
The Latest Filings endpoint returns a list of SEC filings filed in the last 5 calendar days, and it is organized *chronologically* (although each filing is tied to a CIK code). This endpoint is designed to be called multiple times per day, since SEC filings happen throughout the day and thus the data is updated frequently. If you are featuring SEC filings in your app, we recommend that you call this every 15 or 30 minutes on weekdays to keep your customers up to date.
See the Data Dictionary section for detailed descriptions of the specific fields returned by this endpoint.
Data Dictionary: SPAC Summary Fields
Field: cik
Returned by: All Endpoints
Example Value: 0001708176
The CIK code is a unique 10-digit identifier code that is assigned to a company by the SEC. Because SPACs can change their name and stock symbols over time, the SPAC API uses the CIK code as the unique identifier for a company. Data from all API endpoints can be tied together using the CIK code.
Field: conformedname
Returned by: All Companies Endpoint
Example Value: Social Capital Hedosophia Holdings Corp. III
The conformed name represents the current name of the SPAC as recognized by the SEC. It can change over time: sometimes the SPAC will be renamed prior to its IPO, and the SPAC will also change its name upon the closing of its business combination.
Field: formernames
Returned by: All Companies Endpoint
Example Value (JSON):
{"names":
[
{"date":"2019-12-23", "name":"Butler Acquisition Corp"},
{"date":"2020-10-06", "name":"Churchill Capital Corp III"}
],
"_count":"2"
}
The formernames field represents previous company names that the SPAC has used. If there are no former names then the value will just be a blank space (" "). If the SPAC has one or more former names, the value will consist of an embedded JSON entry with one or more pairs of a "date" and "name." The date represents the date that the company name was changed *from* that name (e.g., in the example listed above the company was named "Churchill Capital Corp III" through Oct 6, 2020, at which point the name changed).
Field: assignedsic
Returned by: All Companies Endpoint
Example Value: 6770
The SIC code is a unique business classification code that is used by the SEC to indicate the basic type of business performed by a company. For a SPAC this code usually starts as "6770" which means "Blank Checks," and then it will eventually change to another SIC code representing the business of the SPAC's target. Note that the SPAC API also returns a corresponding field called "assignedsicdesc" that contains the descriptive text associated to the SIC code, so you don't have to perform a lookup of the code elsewhere.
Field: assignedsicdesc
Returned by: All Companies Endpoint
Example Value: BLANK CHECKS
The assignedsicdesc field returns the SIC code descriptive text that is associated with the SPAC's assigned numeric SIC code (see "assignedsic" for more). This is a short phrase that spells out the business classification that the numeric SIC code represents.
Field: stage
Returned by: All Companies Endpoint
Example Value: 2. Seeking Target
The stage field represents the approximate progress of the SPAC as it progresses through its life cycle. The SPAC API sorts each SPAC into one of 6 stages:
1. New / Forming
2. Seeking Target
3. Target Announced
4. Deal Approved
5. Merger Complete
6. Liquidated / Dissolved
Field: size_in_millions
Returned by: All Companies Endpoint
Example Value: 115
The size_in_millions field represents the approximate IPO funding of the SPAC after its initial IPO, in millions (i.e., if the value is "115" then it means that the IPO size was approximately $115,000,000). All values are in U.S. dollars. Note that this value represents the initial IPO size and is not adjusted over time if there are redemptions or other adjustments to the size of the SPAC's trust.
Field: sponsors
Returned by: All Companies Endpoint
Example Value: Globis SPAC, Up and Up Capital
The sponsors field represents one or more companies that are acting as the SPAC's sponsor(s). Most SPACs have one sponsor, but in the case of multiple sponsors the values will be delimited by a ", " (a comma and a space).
Field: underwriters
Returned by: All Companies Endpoint
Example Value: Goldman Sachs & Co, Citigroup Global Markets
The underwriters field represents one or more companies that are acting as the SPAC's underwriter(s). In the case of multiple underwriters, the values will be delimited by a ", " (a comma and a space).
Field: target_notes
Returned by: All Companies Endpoint
Example Value: Focus: data-centric, growth-oriented companies
Represents descriptive text about the SPAC's originally-stated areas of focus as detailed in the prospectus. While a SPAC is not limited to a specific sector or geography, the SPAC will often give investors hints about sectors or geographies where they will pursue potential targets-- this field contains *text snippets* of these hints from the prospectus. This field may be blank if the SPAC does not give any hints about which sectors or geographies it intends to pursue.
Returned by: All Companies Endpoint
Example Value: Healthcare, Technology
Represents one or more descriptive tags about the SPAC's areas of focus as described by the SPAC in its prospectus. While a SPAC is not limited to a specific sector or geography, the SPAC will often give investors hints about the sectors that they intend to pursue-- this field distills those hints into a handful of tags. This field may be blank if the SPAC does not give any hints about which sectors it intends to pursue. In the case of multiple tags, the values will be delimited by a ", " (a comma and a space).
Field: geo
Returned by: All Companies Endpoint
Example Value: North America, Europe
Represents one or more geographic areas of focus as described by the SPAC in its prospectus. While a SPAC is not limited to a specific sector or geography, the SPAC will often give investors hints about countries or regions where they will pursue potential targets-- this field distills those hints into a handful of words or phrases describing the geographies. This field may be blank if the SPAC does not give any hints about which geographies it intends to pursue. In the case of multiple geographies, the values will be delimited by a ", " (a comma and a space).
Field: comments
Returned by: All Companies Endpoint
Example Value: Co-CEOs previously collaborated at TIBCO Software
Contains any additional comments that may be noteworthy about the SPAC.
Data Dictionary: Symbol Fields
Data Dictionary > Symbols > Common Shares
Returned by: All Companies Endpoint
Example Value: IPOC
The symbol_shares field represents the planned or actual stock symbol of common shares for the SPAC, often referred to by SPAC traders as "commons." Note that the symbol may not yet be available for trading if the SPAC's units have not yet separated into shares and warrants.
Returned by: All Companies Endpoint
Example Value: Class A common stock, par value $0.0001 per share
The symbol_shares_desc field contains a description of the common shares stock symbol for the SPAC. It is usually the equivalent of "common stock" or "Class A common stock," and often includes the par value of the shares as listed in the SPAC's prospectus.
Returned by: All Companies Endpoint
Example Value: $10.5000
The symbol_shares_price_lastclose field contains the last closing price of the common shares for the SPAC. The value in this field is updated once daily after the market close.
Returned by: All Companies Endpoint
Example Value: 1933150
The symbol_shares_vol_last field contains the previous day's trading volume of the SPAC's common shares, or, more specifically, the share volume traded on the date in the symbol_shares_price_lasttradingday field. The value in this field is updated once daily after the market closes.
Returned by: All Companies Endpoint
Example Value: 2022-04-27
The symbol_shares_price_lasttradingday field contains the reference date for data in the SPAC's shares pricing fields. For example, if this date is "2022-04-27", then the data in any field starting with "symbol_shares_price_" and the "symbol_shares_vol_last" field would have been valid as of April 27, 2022. The value in this field is updated once daily after the market closes, and may be blank if there is no pricing data for this SPAC's common shares.
Returned by: All Companies Endpoint
Example Value: 14.6700
The symbol_shares_price_lastopen field contains the previous day's opening price of the SPAC's shares, or, more specifically, the opening price of the shares on the date in the symbol_shares_price_lasttradingday field. The value in this field is updated once daily after the market closes, and may be blank if there is no pricing data for this SPAC's common shares.
Returned by: All Companies Endpoint
Example Value: 10.4300
The symbol_shares_price_lasthigh field contains the previous day's highest trading price of the SPAC's shares, or, more specifically, the highest trading price of the shares on the date in the symbol_shares_price_lasttradingday field. The value in this field is updated once daily after the market closes, and may be blank if there is no pricing data for this SPAC's common shares.
Returned by: All Companies Endpoint
Example Value: 10.1800
The symbol_shares_price_lastlow field contains the previous day's lowest trading price of the SPAC's shares, or, more specifically, the lowest trading price of the shares on the date in the symbol_shares_price_lasttradingday field. The value in this field is updated once daily after the market closes, and may be blank if there is no pricing data for this SPAC's common shares.
Returned by: All Companies Endpoint
Example Value: 0.1100
The symbol_shares_price_lastchange field contains the previous day's price change of the SPAC's shares, or, more specifically, the price change of the shares on the date in the symbol_shares_price_lasttradingday field. The value in this field is updated once daily after the market closes, and may be blank if there is no pricing data for this SPAC's common shares.
Returned by: All Companies Endpoint
Example Value: 1.0649%
The symbol_shares_price_lastchangepct field contains the previous day's percentage price change of the SPAC's shares, or, more specifically, the percentage price change of the shares on the date in the symbol_shares_price_lasttradingday field. The value in this field is updated once daily after the market closes, and may be blank if there is no pricing data for this SPAC's common shares.
Data Dictionary > Symbols > Units
Field: symbol_units
Returned by: All Companies Endpoint
Example Value: IPOC.U
The symbol_units field represents the planned or actual stock symbol of the SPAC's units. Some SPACs do not offer units (e.g., if the SPAC offers shares only), so this field may be blank.
Field: symbol_units_desc
Returned by: All Companies Endpoint
Example Value: 1 share plus 1/2 warrant
The symbol_units_desc field contains a description of the unit's components. It is usually one share of common stock plus some portion of a warrant, and sometimes it will also include a right to purchase a fraction of a common share.
Field: symbol_units_price_lastclose
Returned by: All Companies Endpoint
Example Value: $12.7500
The symbol_units_price_lastclose field contains the last closing price of the SPAC's units. The value in this field is updated once daily after the market close.
Field: symbol_units_vol_last
Returned by: All Companies Endpoint
Example Value: 1933150
The symbol_units_vol_last field contains the previous day's trading volume of the SPAC's units, or, more specifically, the unit volume traded on the date in the symbol_units_price_lasttradingday field. The value in this field is updated once daily after the market closes.
Field: symbol_units_price_lasttradingday
Returned by: All Companies Endpoint
Example Value: 2022-04-27
The symbol_units_price_lasttradingday field contains the reference date for data in the SPAC's units pricing fields. For example, if this date is "2022-04-27", then the data in any field starting with "symbol_units_price_" and the "symbol_units_vol_last" field would have been valid as of April 27, 2022. The value in this field is updated once daily after the market closes, and may be blank if there is no pricing data for this SPAC's units.
Field: symbol_units_price_lastopen
Returned by: All Companies Endpoint
Example Value: 14.6700
The symbol_units_price_lastopen field contains the previous day's opening price of the SPAC's units, or, more specifically, the opening price of the units on the date in the symbol_units_price_lasttradingday field. The value in this field is updated once daily after the market closes, and may be blank if there is no pricing data for this SPAC's units.
Field: symbol_units_price_lasthigh
Returned by: All Companies Endpoint
Example Value: 10.4300
The symbol_units_price_lasthigh field contains the previous day's highest trading price of the SPAC's units, or, more specifically, the highest trading price of the units on the date in the symbol_units_price_lasttradingday field. The value in this field is updated once daily after the market closes, and may be blank if there is no pricing data for this SPAC's units.
Field: symbol_units_price_lastlow
Returned by: All Companies Endpoint
Example Value: 10.1800
The symbol_units_price_lastlow field contains the previous day's lowest trading price of the SPAC's units, or, more specifically, the lowest trading price of the units on the date in the symbol_units_price_lasttradingday field. The value in this field is updated once daily after the market closes, and may be blank if there is no pricing data for this SPAC's units.
Field: symbol_units_price_lastchange
Returned by: All Companies Endpoint
Example Value: 0.1100
The symbol_units_price_lastchange field contains the previous day's price change of the SPAC's units, or, more specifically, the price change of the units on the date in the symbol_units_price_lasttradingday field. The value in this field is updated once daily after the market closes, and may be blank if there is no pricing data for this SPAC's units.
Field: symbol_units_price_lastchangepct
Returned by: All Companies Endpoint
Example Value: 1.0649%
The symbol_units_price_lastchangepct field contains the previous day's percentage price change of the SPAC's units, or, more specifically, the percentage price change of the units on the date in the symbol_units_price_lasttradingday field. The value in this field is updated once daily after the market closes, and may be blank if there is no pricing data for this SPAC's units.
Data Dictionary > Symbols > Warrants
Field: symbol_warrants
Returned by: All Companies Endpoint
Example Value: IPOC/WS
The symbol_warrants field represents the planned or actual stock symbol of the SPAC's warrants. Note that the symbol may not yet be available for trading if the SPAC's units have not yet separated into shares and warrants, and may be blank if the SPAC does not offer warrants.
Field: symbol_warrants_desc
Returned by: All Companies Endpoint
Example Value: Exercisable for 1 share at $11.50 per share
The symbol_warrants_desc field contains a description of the warrant's exercise price. Note that there are additional terms and restrictions on the timing of the ability to exercise the SPAC's warrants, and these terms are detailed in the prospectus. What's important here is whether a warrant is exercisable for a whole share or some portion of a share, and also the exercise price.
Field: symbol_warrants_price_lastclose
Returned by: All Companies Endpoint
Example Value: $3.2400
The symbol_warrants_price_lastclose field contains the last closing price of the SPAC's warrants. The value in this field is updated once daily after the market close.
Field: symbol_warrants_vol_last
Returned by: All Companies Endpoint
Example Value: 325000
The symbol_warrants_vol_last field contains the previous day's trading volume of the SPAC's warrants, or, more specifically, the share volume traded on the date in the symbol_warrants_price_lasttradingday field. The value in this field is updated once daily after the market closes.
Field: symbol_warrants_price_lasttradingday
Returned by: All Companies Endpoint
Example Value: 2022-04-27
The symbol_warrants_price_lasttradingday field contains the reference date for data in the SPAC's warrants pricing fields. For example, if this date is "2022-04-27", then the data in any field starting with "symbol_warrants_price_" and the "symbol_warrants_vol_last" field would have been valid as of April 27, 2022. The value in this field is updated once daily after the market closes, and may be blank if there is no pricing data for this SPAC's warrants.
Field: symbol_warrants_price_lastopen
Returned by: All Companies Endpoint
Example Value: 14.6700
The symbol_warrants_price_lastopen field contains the previous day's opening price of the SPAC's warrants, or, more specifically, the opening price of the warrants on the date in the symbol_warrants_price_lasttradingday field. The value in this field is updated once daily after the market closes, and may be blank if there is no pricing data for this SPAC's warrants.
Field: symbol_warrants_price_lasthigh
Returned by: All Companies Endpoint
Example Value: 10.4300
The symbol_warrants_price_lasthigh field contains the previous day's highest trading price of the SPAC's warrants, or, more specifically, the highest trading price of the warrants on the date in the symbol_warrants_price_lasttradingday field. The value in this field is updated once daily after the market closes, and may be blank if there is no pricing data for this SPAC's warrants.
Field: symbol_warrants_price_lastlow
Returned by: All Companies Endpoint
Example Value: 10.1800
The symbol_warrants_price_lastlow field contains the previous day's lowest trading price of the SPAC's warrants, or, more specifically, the lowest trading price of the warrants on the date in the symbol_warrants_price_lasttradingday field. The value in this field is updated once daily after the market closes, and may be blank if there is no pricing data for this SPAC's warrants.
Field: symbol_warrants_price_lastchange
Returned by: All Companies Endpoint
Example Value: 0.1100
The symbol_warrants_price_lastchange field contains the previous day's price change of the SPAC's warrants, or, more specifically, the price change of the warrants on the date in the symbol_warrants_price_lasttradingday field. The value in this field is updated once daily after the market closes, and may be blank if there is no pricing data for this SPAC's warrants.
Field: symbol_warrants_price_lastchangepct
Returned by: All Companies Endpoint
Example Value: 1.0649%
The symbol_warrants_price_lastchangepct field contains the previous day's percentage price change of the SPAC's warrants, or, more specifically, the percentage price change of the warrants on the date in the symbol_warrants_price_lasttradingday field. The value in this field is updated once daily after the market closes, and may be blank if there is no pricing data for this SPAC's warrants.
Data Dictionary > Symbols > Rights
Field: symbol_rights
Returned by: All Companies Endpoint
Example Value: NBACR
The symbol_rights field represents the planned or actual stock symbol of the SPAC's rights. Note that most SPACs do not offer rights as a security, so this field is often blank.
Field: symbol_rights_desc
Returned by: All Companies Endpoint
Example Value: Exchangeable for one-tenth (1/10) of 1 share
The symbol_rights_desc field contains a description of the right's exchange terms. If the SPAC offers rights, this field will contain the exchange ratio of "rights to shares," which is usually 1 whole share for every 10 or 20 rights. Investors can find the full terms of the rights exchange in the SPAC's prospectus.
Field: symbol_rights_price_lastclose
Returned by: All Companies Endpoint
Example Value: $1.3200
The symbol_rights_price_lastclose field contains the last closing price of the SPAC's rights. The value in this field is updated once daily after the market close.
Field: symbol_rights_vol_last
Returned by: All Companies Endpoint
Example Value: 1933150
The symbol_rights_vol_last field contains the previous day's trading volume of the SPAC's rights, or, more specifically, the share volume traded on the date in the symbol_rights_price_lasttradingday field. The value in this field is updated once daily after the market closes.
Field: symbol_rights_price_lasttradingday
Returned by: All Companies Endpoint
Example Value: 2022-04-27
The symbol_rights_price_lasttradingday field contains the reference date for data in the SPAC's rights pricing fields. For example, if this date is "2022-04-27", then the data in any field starting with "symbol_rights_price_" and the "symbol_rights_vol_last" field would have been valid as of April 27, 2022. The value in this field is updated once daily after the market closes, and may be blank if there is no pricing data for this SPAC's rights.
Field: symbol_rights_price_lastopen
Returned by: All Companies Endpoint
Example Value: 14.6700
The symbol_rights_price_lastopen field contains the previous day's opening price of the SPAC's rights, or, more specifically, the opening price of the rights on the date in the symbol_rights_price_lasttradingday field. The value in this field is updated once daily after the market closes, and may be blank if there is no pricing data for this SPAC's rights.
Field: symbol_rights_price_lasthigh
Returned by: All Companies Endpoint
Example Value: 10.4300
The symbol_rights_price_lasthigh field contains the previous day's highest trading price of the SPAC's rights, or, more specifically, the highest trading price of the rights on the date in the symbol_rights_price_lasttradingday field. The value in this field is updated once daily after the market closes, and may be blank if there is no pricing data for this SPAC's rights.
Field: symbol_rights_price_lastlow
Returned by: All Companies Endpoint
Example Value: 10.1800
The symbol_rights_price_lastlow field contains the previous day's lowest trading price of the SPAC's rights, or, more specifically, the lowest trading price of the rights on the date in the symbol_rights_price_lasttradingday field. The value in this field is updated once daily after the market closes, and may be blank if there is no pricing data for this SPAC's rights.
Field: symbol_rights_price_lastchange
Returned by: All Companies Endpoint
Example Value: 0.1100
The symbol_rights_price_lastchange field contains the previous day's price change of the SPAC's rights, or, more specifically, the price change of the rights on the date in the symbol_rights_price_lasttradingday field. The value in this field is updated once daily after the market closes, and may be blank if there is no pricing data for this SPAC's rights.
Field: symbol_rights_price_lastchangepct
Returned by: All Companies Endpoint
Example Value: 1.0649%
The symbol_rights_price_lastchangepct field contains the previous day's percentage price change of the SPAC's rights, or, more specifically, the percentage price change of the rights on the date in the symbol_rights_price_lasttradingday field. The value in this field is updated once daily after the market closes, and may be blank if there is no pricing data for this SPAC's rights.
Field: symbol_other
Returned by: All Companies Endpoint
Example Value: SPCE
The symbol_other field is used to track any other stock symbol of a SPAC, such as the anticipated post-combination stock symbol or any non-customary offerings (e.g., sub-units). After the SPAC has completed its merger, this field will often contain the stock symbol of the original SPAC. In almost all cases, the symbol in this field is *not* currently available to trade, but is rather tracked for reference purposes.
Field: symbol_other_desc
Returned by: All Companies Endpoint
Example Value: Anticipated post-combination symbol
The symbol_other_desc field contains a text description of the "other" stock symbol that is contained in the symbol_other field.
Field: options_available
Returned by: All Companies Endpoint
Example Value: true
The options_available field indicates whether or not there are tradeable options for this SPAC. A value of "true" indicates that options are available, while a "false" value, blank value, or the absence of this field indicate that options are not currently available for this SPAC.
Data Dictionary: Date-Related Fields
Field: term_initial
Returned by: All Companies Endpoint
Example Value: 24
Represents the initial duration *in months* that the SPAC will have to complete a business combination. This value is the *initial* term as defined in the prospectus. For example, if the value in this field is "24" then it means the SPAC originally had 24 months from its IPO date to complete a business combination. Note that the SPAC can extend its duration in a couple of ways: by using a "built-in" extension that is defined in the prospectus (see the field term_extension for more details), or via a shareholder vote to extend the combination deadline. In either case, the value in the term_initial field will NOT change; however, the field date_combinationdue will reflect any extensions to the business combination deadline no matter how many extensions are passed.
Field: term_autoextension
Returned by: All Companies Endpoint
Example Value: 3
Represents a built-in extension period *in months* that is defined in the SPAC's prospectus. For example, if the value in this field is "3" then it means the SPAC can automatically extend its business combination due date by 3 months without the need for a shareholder vote. If this field is blank, that means there was no automatic extension built-in to the prospectus. The value in this field comes from the prospectus and does not change if shareholders vote on one or more extensions-- instead, see the value in the field date_combinationdue for the current combination deadline including any extensions.
Field: date_s1
Returned by: All Companies Endpoint
Example Value: 2020-12-01
Represents the date of the SPAC's first S-1 filing with the SEC. The SPAC's first S-1 filing is the initial version of the SPAC's prospectus, and this date is tracked to provide a "starting point" for the SPAC's life cycle. The S-1 filing is the first step towards the SPAC's IPO. The date value is sent in YYYY-MM-DD format.
Field: date_formed
Returned by: All Companies Endpoint
Example Value: 2020-12-20
Represents the date that the SPAC consummated its IPO. Note: this is the IPO event early in the SPAC's life cycle that makes the SPAC a public company, and is *not* related to the eventual business merger date. The value in this field may be blank until the SPAC IPO event happens. The date value is sent in YYYY-MM-DD format.
Field: date_warrants
Returned by: All Companies Endpoint
Example Value: 2022-01-09
Represents the date that the SPAC warrants may begin trading, also known as the unit separation date. The first security offered by a SPAC is usually the unit, which is a bundle of shares, warrants, and sometimes rights; after some amount of time (usually specified as 52 days from the IPO date, but it may be earlier or later), the SPAC will allow unit holders to split the units into their underlying components-- that separation date is the value stored in this field. The value in this field is usually an estimated date, because SPAC's typically do not announce the separation date until right before it happens. The value in this field may be blank if the SPAC does not offer warrants, or if the SPAC has not yet consummated its IPO. The date value is sent in YYYY-MM-DD format.
Field: date_combinationdue
Returned by: All Companies Endpoint
Example Value: 2022-06-08
Represents the date that the SPAC's business combination is due. Note that a merger can happen at any point prior to this date, and the SPAC may extend this date multiple times. The value in this field represents the most currently reported due date for the business combination, including any automaic or approved extensions. The value in this field may be blank if the SPAC has not yet consummated its IPO. The date value is sent in YYYY-MM-DD format.
Field: date_da
Returned by: All Companies Endpoint
Example Value: 2022-03-21
Represents the date that the SPAC entered into a definitive agreement with a merger target. The definitive agreement is a legal agreement announcing the *intent* to merge, but note there is a possibility that the planned merger can still "fall through" and not actually happen. The value in this field may be blank if the SPAC has not yet entered into a definitive agreement with a target company. The date value is sent in YYYY-MM-DD format.
Field: date_expectedclose
Returned by: All Companies Endpoint
Example Value: 2022 Q1 or Q2
Represents the timeframe in which the SPAC is expected to close its merger. The value in this field is *not* a specific date, but rather a text blurb describing the timeframe for merger as communicated by the SPAC. The value in this field may be blank if the SPAC has not yet communicated an estimated closing timeframe.
Field: date_expectedclose_link
Returned by: All Companies Endpoint
Example Value: https://www.sec.gov/Archives/edgar/data/1465109/000119312520326203/d54172d425.htm
Represents the link to the document where the date_expectedclose value can be found. Many investors want to know where the "expected to close" date came from, so this link allows them to check it out for themselves. The value in this field may be blank if the SPAC has not yet communicated an estimated closing timeframe.
Field: date_mergercomplete
Returned by: All Companies Endpoint
Example Value: 2022-08-04
Represents the SPAC's actual merger closing date. When the SPAC merges with its target, the stock ticker symbols change to those of the new company and the SPAC ends its life cycle. The value in this field may be blank until the SPAC announces that the merger is complete. The date value is sent in YYYY-MM-DD format.
Field: date_nextkeydate
Returned by: All Companies Endpoint
Example Value: 2022-07-11
Represents the SPAC's next key event date, usually a shareholder vote to extend the combination deadline or to approve the SPAC's merger. This field value represents only the *date* of the next key event, but there is a corresponding field called date_nextkeydate_desc that contains a text description of what this event will be. The date value is sent in YYYY-MM-DD format.
Field: date_nextkeydate_desc
Returned by: All Companies Endpoint
Example Value: Vote to Approve combination with Target
Contains a text description of the SPAC's next key date, usually a shareholder vote to extend the combination deadline or to approve the SPAC's merger. This field value contains only the *description* of the next key event, but there is a corresponding field called date_nextkeydate that contains the date itself.
Data Dictionary: Target-Related Fields
Field: target_identified
Returned by: All Companies Endpoint
Example Value: true
Indicates whether the SPAC has identified a target or not. If the value is "true" then the SPAC has either announced a target or entered into a definitive agreement with a target. If the value is anything other than "true" (e.g., blank or false), then the SPAC has *not* identified a target.
Field: target
Returned by: All Companies Endpoint
Example Value: Virgin Galactic
Contains the name of the company that the SPAC is targeting for merger if a target has been announced.
Field: target_desc
Returned by: All Companies Endpoint
Example Value: Virgin Galactic develops commercial spacecraft.
Contains a short description of the SPAC's target if a target has been announced.
Field: link_investorpres
Returned by: All Companies Endpoint
Example Value: https://www.sec.gov/Archives/edgar/data/1465109/000119312520326205/d92885d425.htm
Contains a link to an investor presentation about the SPAC target. Once a SPAC announces its target, it will often publish a presentation for analysts and investors. This field contains a link to that presentation. There is a companion field called link_investorpres_date that contains the date that the linked presentation was filed with the SEC.
Field: link_investorpres_date
Returned by: All Companies Endpoint
Example Value: 2020-12-23
Contains the date that the SPAC filed an investor presentation about its target. Once a SPAC announces its target, it will often publish a presentation for analysts and investors. This field contains the date that such a presentation was filed with the SEC. The date value is sent in YYYY-MM-DD format. There is a companion field called link_investorpres which contains the URL that links to the presentation.
Data Dictionary: Filings-Related Fields
Field: accessionnum
Returned by: Latest Filings Endpoint
Example Value: 0001213900-19-024299
The accession number is a unique identifier assigned automatically to an accepted submission by the SEC's EDGAR Filer System. Note that many filings do *not* have an accession number, so the value in this field can be blank.
Field: edgarlastupdated
Returned by: Latest Filings Endpoint
Example Value: 2020-12-18T16:07:59-05:00
The filings's last updated date/time as provided by the SEC.
Field: filesize
Returned by: Latest Filings Endpoint
Example Value: 5 MB
The filings's estimated file size as provided by the SEC.
Field: filingdate
Returned by: Latest Filings Endpoint
Example Value: 2020-12-18
The date of the filing as provided by the SEC.
Field: filingnumber
Returned by: Latest Filings Endpoint
Example Value: 333-251487
A filing identifier provided by the SEC.
Field: filingtype
Returned by: Latest Filings Endpoint
Example Value: S-4
Represents the form type of the filing. One potential use of this field is to separate out filings related to *ownership changes*, which inlude form types "3", "3/A", "4", "4/A", "SC 13G", "SC 13G/A", "SC 13D", and "SC 13D/A".
Field: id
Returned by: Latest Filings Endpoint
Example Value: urn:tag:sec.gov,2008:accession-number=0001193125-20-326207
Contains an identifier value as provided by the SEC.
Field: link
Returned by: Latest Filings Endpoint
Example Value: https://www.sec.gov/Archives/edgar/data/1829730/000156459020057669/0001564590-20-057669-index.htm
Contains a URI link to the filing on the SEC web site.
Field: title
Returned by: Latest Filings Endpoint
Example Value: S-4 - Registration of securities, business combinations
Contains the filing's title as provided by the SEC, which usually includes the form type and a generic description of the form.