From a 500-row sample across 16 columns.
| system | company_name | ticker | country | primary_isin | primary_sedol | provider_security_id | meeting_type | meeting_date | record_date | proponent | proposal_number |
|---|---|---|---|---|---|---|---|---|---|---|---|
| City | Conyers Park Acquisition Corp. | CPAA | USA | US82900L1026 | BF27XF9 | 212894208 | Special | 2017-07-05T00:00:00.000 | 2017-05-26T00:00:00.000 | Management | 1 |
| City |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
system | text | This column sets forth the particular New York City Retirement System that holds the security that is being voted. "City" stands for the New York City Employees' Retirement System; "Teachers" stands for the Teachers' Retirement System of New York City; "Fire" stands for the New York City Fire Department Pension Fund; "Police" stands for the New York City Police Department Pension Fund; "BOE" stands for the Board of Education Retirement System of the City of New York; "Group Trust" indicates that | 0% | NYCC-49 Group Trust Glob…Group TrustPolice |
company_name | text | This column sets forth the name of the company that issued the security that is being voted | 0% | Grupo Financiero Banorte…ASML Holding NVNestle SA |
ticker | text | This row provides the ticker symbol for the security that is being voted. A ticker symbol is an abbreviation used to uniquely identify publicly traded shares of a particular stock on a particular stock market. | 0% |
GET /api/datasets/fpxc-zjtm GET /api/datasets/fpxc-zjtm/quality GET /api/datasets/fpxc-zjtm/related GET /api/columns?dataset=fpxc-zjtm
| Conyers Park Acquisition Corp. |
| CPAA |
| USA |
| US82900L1026 |
| BF27XF9 |
| 212894208 |
| Special |
| 2017-07-05T00:00:00.000 |
| 2017-05-26T00:00:00.000 |
| Management |
| A1 |
| City | Conyers Park Acquisition Corp. | CPAA | USA | US82900L1026 | BF27XF9 | 212894208 | Special | 2017-07-05T00:00:00.000 | 2017-05-26T00:00:00.000 | Management | A2 |
| City | Conyers Park Acquisition Corp. | CPAA | USA | US82900L1026 | BF27XF9 | 212894208 | Special | 2017-07-05T00:00:00.000 | 2017-05-26T00:00:00.000 | Management | 2 |
| City | Galena Biopharma, Inc. | GALE | USA | US81642T1007 | BDTMGW1 | 363256504 | Special | 2017-07-06T00:00:00.000 | 2017-06-01T00:00:00.000 | Management | 1 |
| City | Galena Biopharma, Inc. | GALE | USA | US81642T1007 | BDTMGW1 | 363256504 | Special | 2017-07-06T00:00:00.000 | 2017-06-01T00:00:00.000 | Management | 2 |
| City | Galena Biopharma, Inc. | GALE | USA | US81642T1007 | BDTMGW1 | 363256504 | Special | 2017-07-06T00:00:00.000 | 2017-06-01T00:00:00.000 | Management | 3 |
| City | Galena Biopharma, Inc. | GALE | USA | US81642T1007 | BDTMGW1 | 363256504 | Special | 2017-07-06T00:00:00.000 | 2017-06-01T00:00:00.000 | Management | 4 |
| City | Galena Biopharma, Inc. | GALE | USA | US81642T1007 | BDTMGW1 | 363256504 | Special | 2017-07-06T00:00:00.000 | 2017-06-01T00:00:00.000 | Management | 5 |
| City | Galena Biopharma, Inc. | GALE | USA | US81642T1007 | BDTMGW1 | 363256504 | Special | 2017-07-06T00:00:00.000 | 2017-06-01T00:00:00.000 | Management | 6 |
Showing 12 of 16 columns. All of them are listed below.
MCGFNORTEOASMLcountry | text | This column sets forth the home country of the company | 0% | USAJapanChina |
primary_isin | text | This row provides the ISIN number for the security that is being voted. An ISIN number is a code that uniquely identifies a specific securities issue. ISIN is an acronym for International Securities Identification Number | 0% | MXP370711014NL0010273215CH0038863350 |
primary_sedol | text | This row sets forth SEDOL numbers. SEDOLs are security identifies used in the United Kingdom and Ireland for clearing purposes. SEDOL is an acronym for Stock Exchange Daily Official List | 0% | 2421041B929F467123870 |
provider_security_id | text | This column sets forth the security identification number of the security that is being voted | 0% | P49501201H57312649F58485115 |
meeting_type | categorical | The row sets forth the type of meeting that took place. There are various types of meetings listed in these records, including annual shareholder meetings, special shareholder meetings and contested meetings. | 0% | AnnualSpecialAnnual/Specialof 8 |
meeting_date | datetime | This row sets for the date of the meeting. | 0% | 2019-06-27T00:00:00.0002019-04-25T00:00:00.0002019-06-21T00:00:00.000 |
record_date | datetime | This row sets for the record date. The record date is the date set by the company as the official date a shareholder must be an owner on the company's records in order to participate in the annual meeting and corporate election. | 6% | 2022-03-31T00:00:00.0002019-03-31T00:00:00.0002021-03-31T00:00:00.000 |
proponent | categorical | This column sets forth who made the proposal that is being voted on. | 0% | ManagementShareholderShare Holderof 3 |
proposal_number | text | This column sets forth the proposal number that was voted on. | 0% | 231 |
proposal_text | text | This column sets forth the proposals that were voted on at the meeting. The proposals generally consist of directors who are being elected or proposals that are being voted on | 0% | Advisory Vote to Ratify …Accept Financial Stateme…Ratify Ernst & Young LLP… |
vote_instruction | categorical | This column sets forth how the Systems actually voted on the proposal. There are three options: For the proposal, against the proposal, or the vote may be withheld | 2% | ForAgainstAbstainof 6 |
vote_against_management | categorical | This column sets forth how the company's management recommended voting. | 0% | NoYesof 2 |
ballot_cutoff_date | datetime | This row sets forth the date by which votes must be made | 81% | 2019-06-19T00:00:00.0002019-05-15T00:00:00.0002019-06-25T00:00:00.000 |