# Velarion Company Intelligence Data License API: data dictionary

Generated 2026-10-06T16:55:37+00:00 from the live database; column meanings are the field definitions the API serves. Replaces the July 17, 2026 dictionary on the AWS Marketplace listing.

## Datasets

| dataset | rows | issuers | newest | columns | source |
|---|---|---|---|---|---|
| Director compensation | 74,574 | 3421 | 2026-10-05 (filing date) | 27 | DEF 14A proxy statements, nightly |
| Director fee schedules | 6,272 | 3594 | 2027 (fiscal year) | 29 | DEF 14A proxy statements, nightly |
| Equity grants (Grants of Plan-Based Awards) | 64,034 | 2997 | 2026-07-15 (filing date) | 19 | DEF 14A proxy statements, nightly |
| Executive compensation (Summary Compensation Table) | 54,496 | 3396 | 2026-10-05 (filing date) | 35 | DEF 14A proxy statements, nightly |
| Form 4 insider transactions | 488,754 | 2452 | 2026-10-05 (filing date) | 29 | Forms 3, 4 and 5 (EDGAR daily index), one day from filing to row |
| Peer groups, as disclosed | 97,386 | 2639 | 2026-04-30 (filing date) | 11 | DEF 14A proxy statements, nightly |
| Realizable pay | 35,307 | 3461 | 2026 (fiscal year) | 12 | computed by code from awards and fiscal-year-end prices, nightly |
| Say-on-pay voting history | 22,853 | 3318 | 2026-10-02 (filing date) | 11 | Forms 8-K (meeting results), nightly |

Every row names the filing it was read from (accession and URL on the delivered feed). Delivered as CSV and Parquet with a manifest, and through the API (https://api.velarion.ai/api/v1/, OpenAPI published).

## Director compensation (`director_comp`)

Source: DEF 14A proxy statements, nightly. 74,574 rows across 3,421 issuers.

| field | type | meaning |
|---|---|---|
| company_name | text | Company name |
| ticker | text | Company stock ticker |
| fiscal_year | integer | Fiscal year |
| director_name | text | Director name as disclosed |
| age | integer | Director age as disclosed |
| director_since | integer | Year first elected |
| is_independent | boolean | Independence classification |
| is_board_chair | boolean | Board chair flag |
| is_lead_independent | boolean | Lead independent director flag |
| committees | jsonb | Committee memberships |
| fees_earned_cash | numeric | Cash fees earned or paid |
| stock_awards | numeric | Stock awards, grant-date fair value |
| option_awards | numeric | Option awards, grant-date fair value |
| non_equity_incentive | numeric | Non-equity incentive compensation |
| change_in_pension | numeric | Change in pension value |
| all_other_comp | numeric | All other compensation |
| total_comp | numeric | Total director compensation |
| hq_city | text | Headquarters city |
| hq_state | text | Headquarters state |
| property_type | text | Real-estate sub-sector (real-estate companies) |
| is_departed | boolean | Departed during the fiscal year |
| is_not_standing | boolean | Not standing for re-election |
| is_newly_elected | boolean | Newly elected during the year |
| director_note | text | Disclosure note for the director |
| is_employee_director | boolean | Employee (non-independent) director |
| board_transition_note | text | Board transition note |
| is_transition | boolean | Transition-year flag |

## Director fee schedules (`director_fee_schedule`)

Source: DEF 14A proxy statements, nightly. 6,272 rows across 3,594 issuers.

| field | type | meaning |
|---|---|---|
| ticker | text | Company stock ticker |
| company_name | text | Company name |
| cash_retainer | integer | Annual board cash retainer |
| equity_retainer | integer | Annual board equity retainer |
| total_retainer | integer | Total annual retainer |
| lead_director_premium | integer | Lead independent director premium |
| chair_premium | integer | Board chair premium |
| audit_chair | integer | Audit committee chair fee |
| audit_member | integer | Audit committee member fee |
| comp_chair | integer | Compensation committee chair fee |
| comp_member | integer | Compensation committee member fee |
| nomgov_chair | integer | Nominating/governance chair fee |
| nomgov_member | integer | Nominating/governance member fee |
| meeting_fee_board | integer | Per-meeting board fee |
| meeting_fee_committee | integer | Per-meeting committee fee |
| equity_vehicle | text | Equity vehicle for director grants |
| equity_vesting | text | Director grant vesting terms |
| num_board_meetings | integer | Board meetings held |
| num_committees | integer | Number of standing committees |
| stock_ownership_guideline | text | Director stock ownership guideline |
| finance_chair | integer | Finance committee chair fee |
| finance_member | integer | Finance committee member fee |
| tech_chair | integer | Technology committee chair fee |
| tech_member | integer | Technology committee member fee |
| other_chair | integer | Other committee chair fee |
| other_member | integer | Other committee member fee |
| other_committee_name | text | Name of the other committee |
| committee_fees | jsonb | Full committee fee structure (JSON) |
| disclosure_regime | text | Fee-disclosure pattern classification |

## Equity grants (Grants of Plan-Based Awards) (`equity_grants`)

Source: DEF 14A proxy statements, nightly. 64,034 rows across 2,997 issuers.

| field | type | meaning |
|---|---|---|
| ticker | text | Company stock ticker |
| fiscal_year | integer | Fiscal year of grant |
| exec_name | text | Executive name |
| position | text | Standardized position code |
| grant_date | date | Grant date |
| award_type | text | Award type (RSU, PSU, option, ...) |
| shares_granted | integer | Shares granted (time-based awards) |
| shares_threshold | integer | Shares at threshold payout (performance awards) |
| shares_target | integer | Shares at target payout |
| shares_maximum | integer | Shares at maximum payout |
| exercise_price | numeric | Option exercise price |
| grant_date_fair_value | numeric | Grant-date fair value of the award |
| is_unusual | boolean | Unusual-award flag |
| unusual_note | text | Structural note (e.g. unvalued performance tiers) |
| company_name | text | Company name |
| unusual_award_class | text | Standardized unusual-award classification |
| unusual_award_confidence | text | Classification confidence |
| unusual_award_reason | text | Why the award is classified unusual |
| fv_source | text | Fair-value source basis |

## Executive compensation (Summary Compensation Table) (`exec_comp`)

Source: DEF 14A proxy statements, nightly. 54,496 rows across 3,396 issuers.

| field | type | meaning |
|---|---|---|
| company_name | text | Company name as disclosed |
| ticker | text | Company stock ticker |
| fiscal_year | integer | Fiscal year the compensation was earned in |
| first_name | text | Executive first name as disclosed |
| last_name | text | Executive last name as disclosed |
| title | text | Raw title as disclosed |
| position | text | Standardized position code (CEO, PRESIDENT, CFO, ...) |
| base_salary | numeric | Convenience: base salary |
| cash_bonus_incentive | numeric | Convenience: bonus + annual incentive payout |
| stock_based_comp | numeric | Convenience: stock + option awards (grant-date fair value) |
| total_comp | numeric | Total compensation as disclosed |
| hq_city | text | Headquarters city |
| hq_state | text | Headquarters state |
| geographic_region | text | Geographic region classification |
| property_type | text | Real-estate sub-sector (real-estate companies) |
| reit_type | text | Real-estate classification (equity / mortgage) |
| market_cap | integer | Market capitalization at extraction |
| other_comp | numeric | Convenience: pension change + all other compensation |
| index_group | text | Index membership (e.g. S&P 500) |
| display_title | text | Cleaned title for display |
| sct_salary | integer | Salary |
| sct_bonus | integer | Discretionary bonus |
| sct_stock_awards | integer | Stock awards, grant-date fair value |
| sct_option_awards | integer | Option awards, grant-date fair value |
| sct_non_equity_incentive | integer | Annual incentive plan payout (cash) |
| sct_change_pension | integer | Change in pension value and deferred-compensation earnings (can be negative) |
| sct_all_other | integer | All other compensation (perquisites, retirement match, etc.) |
| is_departed | boolean | TRUE if the executive departed during the fiscal year |
| is_transition | boolean | TRUE if mid-year start or title change |
| salary_is_partial_year | boolean | TRUE when the disclosed salary covers a partial year |
| sti_cash_payout | integer | Annual short-term incentive cash payout, isolated from long-term cash |
| ltip_cash_payout | integer | Long-term cash incentive plan payout for the year |
| ltip_cash_plan_name | text | Long-term cash plan name as disclosed |
| ltip_cash_cycle_start | integer | First year of the long-term cash performance cycle |
| ltip_cash_cycle_end | integer | Final year of the long-term cash performance cycle |

## Form 4 insider transactions (`form4_transactions`)

Source: Forms 3, 4 and 5 (EDGAR daily index), one day from filing to row. 488,754 rows across 2,452 issuers.

| field | type | meaning |
|---|---|---|
| accession | text | SEC accession number of the Form 3, 4 or 5 the row was read from |
| line_index | integer | Row position within the filing's transaction table |
| ticker | text | Issuer stock ticker |
| issuer_cik | text | Issuer SEC Central Index Key |
| insider_name | text | Reporting person's name as filed |
| officer_title | text | Officer title as filed |
| is_director | boolean | True when the reporting person is a director |
| is_officer | boolean | True when the reporting person is an officer |
| is_ten_pct | boolean | True when the reporting person is a ten-percent owner |
| filing_date | date | Date the form was filed |
| period_of_report | date | Period of report stated on the form |
| form4_url | text | EDGAR URL of the filing |
| table_i_or_ii | text | Table I (non-derivative) or Table II (derivative) of the form |
| transaction_code | text | Transaction code as filed (P, S, A, M, F, G and the rest) |
| transaction_date | date | Date of the transaction |
| shares | numeric | Number of shares or units in the transaction |
| price | numeric | Price per share as filed |
| acquired_disposed | text | A (acquired) or D (disposed) |
| post_transaction_shares | numeric | Shares owned following the transaction |
| direct_indirect | text | D (direct) or I (indirect) ownership |
| indirect_nature | text | Nature of indirect ownership as filed |
| underlying_security | text | Underlying security for a derivative row |
| conversion_exercise_price | numeric | Conversion or exercise price for a derivative row |
| exercise_date | date | Exercisable date for a derivative row |
| expiration_date | date | Expiration date for a derivative row |
| award_classification | text | What the row is, classified from the filing text (open-market purchase, sale, tax withholding, option exercise, grant, gift, and the rest) |
| is_10b5_1 | boolean | True when the filing states the transaction was under a Rule 10b5-1 plan |
| footnote_text | text | Footnote text from the filing that the classification rests on |
| classification_quote | text | The quoted filing words behind the classification |

## Peer groups, as disclosed (`proxy_peer_groups`)

Source: DEF 14A proxy statements, nightly. 97,386 rows across 2,639 issuers.

| field | type | meaning |
|---|---|---|
| ticker | text | Disclosing company ticker |
| company_name | text | Disclosing company name |
| peer_name_as_disclosed | text | Peer name exactly as disclosed |
| peer_ticker | text | Peer company ticker |
| peer_cik | text | Peer registry identifier |
| fiscal_year | integer | Fiscal year of the disclosure |
| coverage_note | text | Coverage note when peer data is limited |
| peer_status_at_fy | text | Peer disposition at the fiscal year (foreign_private_issuer, foreign_listed_no_sec_filing, data_gap, inactive_at_disclosure) |
| peer_status_reason | text | Reason for the peer status |
| peer_group_label | text | Label of the disclosed group when several exist |
| peer_activity_at_fy | text | Peer activity at the fiscal year (ACTIVE, UNVERIFIABLE) |

## Realizable pay (`realizable_pay`)

Source: computed by code from awards and fiscal-year-end prices, nightly. 35,307 rows across 3,461 issuers.

| field | type | meaning |
|---|---|---|
| ticker | text | Company stock ticker |
| fiscal_year | integer | Fiscal year |
| exec_last_name | text | Executive last name |
| exec_first_name | text | Executive first name |
| base_salary | integer | Base salary in the measurement year |
| actual_sti | integer | Actual annual incentive paid |
| unvested_equity_value | integer | Current value of unvested equity (nightly price) |
| realizable_total | integer | Total realizable pay |
| price_used | numeric | Share price used in the valuation |
| award_count | integer | Awards included in the calculation |
| fye_close_price | numeric | Fiscal-year-end close price |
| unvested_equity_value_at_fye | numeric | Value of unvested equity at fiscal year end |

## Say-on-pay voting history (`say_on_pay`)

Source: Forms 8-K (meeting results), nightly. 22,853 rows across 3,318 issuers.

| field | type | meaning |
|---|---|---|
| ticker | text | Company stock ticker |
| company_name | text | Company name |
| fiscal_year | integer | Fiscal year the vote covers |
| meeting_date | text | Meeting date |
| votes_for | integer | Votes for |
| votes_against | integer | Votes against |
| votes_abstain | integer | Abstentions |
| broker_non_votes | integer | Broker non-votes |
| approval_pct | numeric | Approval percentage (documented basis) |
| vote_frequency | text | Say-on-frequency preference where voted |
| vote_type | text | annual_sop for the regular annual advisory vote |