Every field may be null unless marked required. Today
strategic_signal_id is guaranteed.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 | 3 |
| Signal Data | 6 |
| Company / Personal Data | 16 |
| Financials | 4 |
ID
| Field | Type | Description |
|---|---|---|
strategic_signal_id | string requiredVARCHAR | Investor Interest ID. |
specter_person_id | stringVARCHAR | Specter identifier for the person. Resolves against the People DB. |
company_id | stringVARCHAR | Specter identifier for the company. Resolves against the Company DB. |
Parquet schema: ID
Parquet schema: ID
ID
(
strategic_signal_id VARCHAR,
specter_person_id VARCHAR,
company_id VARCHAR
)
Signal Data
| Field | Type | Description |
|---|---|---|
signal_date | dateDATE | Signal featured date. |
signal_score | integerTINYINT | Signal score from Specter’s proprietary algorithm, 1 to 10, with 10 the highest. Based on signal source, signal strength and company performance. |
source_type | stringVARCHAR | Based on signal source. A signal with several sources lists each, separated by ; . One of venture capital, insider, private equity, investment bank, angel, journalist, influencer. |
signal_type | stringVARCHAR | Whether the signal is about a company or a person. One of Talent, Company. |
signal_source | stringVARCHAR | The VC firm, corporation, or individual that is the source of the signal. |
signal_summary | stringVARCHAR | Brief on the investor activity and what the company does. |
Parquet schema: Signal Data
Parquet schema: Signal Data
Signal Data
(
signal_date DATE,
signal_score TINYINT,
source_type VARCHAR,
signal_type VARCHAR,
signal_source VARCHAR,
signal_summary VARCHAR
)
Company / Personal Data
| Field | Type | Description |
|---|---|---|
name | stringVARCHAR | Name of the company or person the signal is about. |
website | stringVARCHAR | Company website URL or LinkedIn personal profile URL in case of a Signal Type = Talent. |
screenshot | stringVARCHAR | Company website screenshot. |
hq_location | stringVARCHAR | City-level location of the company’s headquarters. |
hq_region | stringVARCHAR | Region the company’s headquarters sits in. One of Africa, Asia, Oceania, Canada, Europe, LATAM, MENA, United States, Russia. |
growth_stage | stringVARCHAR | Stage the company has reached in its growth. One of Pre-Launch, Bootstrapped, Early Stage, Growth Stage, Late Stage. |
company_linkedin_url | stringVARCHAR | URL of the company’s LinkedIn page. |
twitter_url | stringVARCHAR | URL of the company’s X (Twitter) profile. |
talent_github_url | stringVARCHAR | GitHub profile URL (only available when Signal Type = Talent) |
contact_email | stringVARCHAR | Recommended contact email address for the person behind the signal. |
company_description | stringVARCHAR | Short description of what the company does. |
company_founded_year | integerSMALLINT | Company founded date. |
customer_focus | stringVARCHAR | This data point categorizes companies based on their primary and secondary customer engagement models. One of B2B, B2C, B2B,B2C, B2C,B2B. |
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. |
is_industry_estimated | booleanBOOLEAN | True if new position industry and tech verticals are estimated. |
Parquet schema: Company / Personal Data
Parquet schema: Company / Personal Data
Company / Personal Data
(
name VARCHAR,
website VARCHAR,
screenshot VARCHAR,
hq_location VARCHAR,
hq_region VARCHAR,
growth_stage VARCHAR,
company_linkedin_url VARCHAR,
twitter_url VARCHAR,
talent_github_url VARCHAR,
contact_email VARCHAR,
company_description VARCHAR,
company_founded_year SMALLINT,
customer_focus VARCHAR,
specter_industry VARCHAR[],
specter_tech_verticals VARCHAR[][],
is_industry_estimated BOOLEAN
)
Financials
| Field | Type | Description |
|---|---|---|
company_funding_amount_usd | stringVARCHAR | Total funding the company has raised, in USD. Delivered as a string of digits, without a currency symbol or separators. |
company_last_funding_date | dateDATE | Date of the company’s most recent funding round. |
company_last_funding_amount_usd | stringVARCHAR | Amount of the company’s most recent funding round, in USD. Delivered as a string of digits, without a currency symbol or separators. |
company_investors | array<string>VARCHAR[] | Investors in the company. |
Parquet schema: Financials
Parquet schema: Financials
Financials
(
company_funding_amount_usd VARCHAR,
company_last_funding_date DATE,
company_last_funding_amount_usd VARCHAR,
company_investors VARCHAR[]
)
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 |
|---|---|
strategic_signal_id | Specter - Strategic Signal ID |
specter_person_id | Specter - Person ID |
company_id | Specter - Organization ID |
signal_date | Signal Date |
signal_score | Signal Score |
source_type | Source Type |
signal_type | Signal Type |
signal_source | Signal Sources |
signal_summary | Signal Summary |
name | Name |
website | Website |
screenshot | Screenshots |
hq_location | HQ Location |
hq_region | HQ Region |
growth_stage | Growth Stage |
company_linkedin_url | LinkedIn - URL |
twitter_url | Twitter - URL |
talent_github_url | GitHub - URL |
contact_email | |
company_description | Description |
company_founded_year | Founded |
customer_focus | Customer Focus |
specter_industry | Industry |
specter_tech_verticals | Tech Verticals |
is_industry_estimated | Is Industry Estimated |
company_funding_amount_usd | Total Funding Amount (in USD) |
company_last_funding_date | Last Funding Date |
company_last_funding_amount_usd | Last Funding Amount (in USD) |
company_investors | Investors |