Fund proxy summary — fund_proxy_summary_YYYYMMDD.txt.gz
One file of the SQXray data dictionary. Field list (.csv)
Fund proxy summary — fund_proxy_summary_YYYYMMDD.txt.gz
A daily compressed file with one row per portfolio, proxy year and vote category, summarising the fund's Form N-PX voting record: how many matters it voted on, how often it voted with and against management, its support on ESG proposals (ALL row), and how many were shareholder proposals.
| Field | Type | Nullable | Description | Example |
|---|---|---|---|---|
analysis_date | DATE | never blank | The date the row was computed for. | |
fund_isin | VARCHAR(12) | never blank | ISIN of the portfolio's representative share class, under the name every share-class file keys on. The key of this file; a portfolio with no publishable class has no row here. | |
portfolio_id | BIGINT | never blank (key) | The portfolio (SEC series) whose votes the row summarises, as published in the fund reference and portfolio holdings files. | |
series_id | VARCHAR(12) | may be blank | SEC series identifier (S000...) of the portfolio. | |
proxy_year | SMALLINT UNSIGNED | never blank (key) | The proxy year the row covers, the twelve months to June 30 of that year. | |
category | VARCHAR(48) | never blank (key) | The vote category as filed on Form N-PX Item 1(g), or ALL for every matter voted. | |
display_name | VARCHAR(64) | never blank | The category's display label. | |
description | VARCHAR(255) | never blank | A one-sentence description of what proposals the category covers. | |
vote_count | INT UNSIGNED | never blank | Number of matters the fund voted on in the category during the proxy year. | |
votes_for | INT UNSIGNED | never blank | Matters on which the fund cast shares for. | |
votes_against | INT UNSIGNED | never blank | Matters on which the fund cast shares against. | |
votes_abstain_withhold | INT UNSIGNED | never blank | Matters on which the fund abstained or withheld. | |
pct_support | DECIMAL(5,2) | may be blank | votes_for as a percentage of votes_for plus votes_against. Blank when the fund neither supported nor opposed any matter in the category. | |
pct_against | DECIMAL(5,2) | may be blank | votes_against as a percentage of votes_for plus votes_against. Blank when the fund neither supported nor opposed any matter in the category. | |
pct_with_mgmt | DECIMAL(5,2) | may be blank | Share of matters voted in line with management's recommendation, in percent of the matters where management made one and the fund voted for or against; abstentions, withheld and split votes are outside the base. | |
pct_against_mgmt | DECIMAL(5,2) | may be blank | Share of matters voted against management's recommendation, in percent, on the same base as pct_with_mgmt (abstentions, withheld and split votes excluded); the two sum to 100. Blank on an empty base. | |
pct_support_esg | DECIMAL(5,2) | may be blank | ALL row only: share of environmental, social, human-capital and diversity proposals in proxy_year voted for, in percent of those voted for or against. Blank on category rows and on an empty base. | |
shareholder_proposals | INT UNSIGNED | never blank | How many of vote_count were proposals brought by a shareholder rather than by the company. | |
filing_date | DATE | never blank | Filing date of the Form N-PX the counts come from. | |
is_amendment | TINYINT(1) | never blank | 1 when the counts come from an amended filing (N-PX/A), 0 otherwise. |