Consider switching to newer ISS Voting Analytics
Closed this issue · 1 comments
iangow commented
I'm not sure whether it is of any consequence, but it seems we have code using the old issvoting
data (this is from when I was at HBS). Perhaps (if relevant and not a big pain) we should point to the equivalent data in risk
(see below).
crsp=# \dt+ issvoting.
List of relations
Schema | Name | Type | Owner | Size | Description
-----------+------------------+-------+----------+------------+----------------------------------------------------------
issvoting | Agenda List | table | igow | 8192 bytes |
issvoting | Mutual Fund list | table | igow | 0 bytes |
issvoting | compvote | table | igow | 103 MB |
issvoting | director_names | table | activism | 6576 kB | CREATED USING iss_extract_names.sql
issvoting | fund_mapping | table | igow | 8192 bytes |
issvoting | fundref | table | igow | 8192 bytes |
issvoting | manual_names | table | activism | 48 kB | CREATED USING import_manual_names ON 2015-06-01 20:09:49
issvoting | npx | table | activism | 8139 MB |
issvoting | npx_id | table | activism | 255 MB |
issvoting | npx_stanford | table | igow | 8192 bytes |
(10 rows)
crsp=# \dt+ risk.
List of relations
Schema | Name | Type | Owner | Size | Description
--------+-------------------+-------+-------+------------+----------------------------------------------------------
risk | directors | table | risk | 91 MB | Last modified: 11/23/2009 15:31:11
risk | globalvoteresults | table | risk | 726 MB | Last modified: 05/06/2020 19:21:14
risk | gset | table | risk | 7112 kB | Last modified: 11/23/2009 09:39:15
risk | issrec | table | risk | 189 MB | Last modified: 05/06/2020 19:21:15
risk | issue_codes | table | igow | 48 kB |
risk | manual_names | table | risk | 16 kB | CREATED USING import_manual_names ON 2020-09-01 13:21:11
risk | missing_links | table | igow | 8192 bytes |
risk | proposals | table | risk | 4400 kB | Last modified: 03/19/2019 18:44:09
risk | rm_link | table | risk | 112 kB | Created using create_rm_link.R ON 2020-09-01 13:21:09
risk | rmdirectors | table | risk | 58 MB | Last modified: 04/10/2020 14:47:07
risk | rmgovernance | table | risk | 8128 kB | Last modified: 04/10/2020 14:49:28
risk | va_proposals | table | risk | 7976 kB | Last modified: 05/07/2020 19:48:32
risk | vavoteresults | table | risk | 146 MB | Last modified: 07/02/2020 12:56:51
risk | voteanalysis_npx | table | risk | 40 GB | Last modified: 02/21/2019 22:52:02
risk | votes | table | risk | 4000 kB | Last modified: 04/22/2010 11:22:04
(15 rows)
crsp=#
iangow commented
Clearly not happening if we haven't already done it.