iangow/activist_director

Consider switching to newer ISS Voting Analytics

Closed this issue · 1 comments

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).

issvoting.compvote <- tbl(pg, sql("SELECT * FROM issvoting.compvote"))

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=# 

Clearly not happening if we haven't already done it.