License

Copyright 2017 Carlos Paradis

This program is free software: you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version.

This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.

You should have received a copy of the GNU General Public License along with this program. If not, see http://www.gnu.org/licenses/.

Introduction

The purpose of this notebook is to generate the linkage tables between legislator names of 2014-2016 election and assess their accuracy. For an introduction on the subject, please see the introduction notebook.

The true goal of this entire Notebook is the last item of the roadmap: Obtaining a single table with 2 columns indicating what are the names used for every candidate on both websites. While they are used consistently within every website, they are not used consistently across the websites (e.g. “Michael” being called “Mike”).

Since a name similarity method is used to address the issue, it is necessary that the comparison is done between the smalest possible set of names to avoid a mismatch. The roadmap below sole purpose is to narrow down the space of name comparisons by extracting all possible information it can use from every side (e.g. knowing a candidate was running for the senate allows his name to only be compared against candidates running for senate on the other website).

Aside from the linkage, another chunk of this report is about formating the words so exact matching can be performed to narrow down the name space comparison: The names are not always consistent across tables even from the same website (e.g. In the Ethics Website one is a “Candidate, Senator” in one table and in another table a “Senate”, and must be formatted simple as “Senator” to be consistently compared within and across websites).

Roadmap

The linkage roadmap is as folllows:

  1. Collect Names + Extra Information of 2014-2016 Election ethics.legislator from Ethics website tables for:
    1. Senate + House of Representatives (Legislator Financial Disclosures Table)
    2. OHA + Governor + Lt. Governor (State Officials Financial Disclosures Table)
    3. Define Winners table as the Set-Union of 1.1 and 1.2.
  2. Collect Names + Extra Information of 2014-2016 Election Losers from Ethics website by:
    1. Obtaining names from Senate + House of Representatives + OHA Candidates of (soon to be) ethics.legislator and Losers (Candidate Financial Disclosures)
    2. Performing a name set subtraction from the ethics.legislator table names of step 1. of the ethics.legislator + Losers of step 2.1 by office (names within the same website are consistent, no need for linkage).
  3. Define Candidates Table (Winers + Losers): With steps 1, and 2, create a single table containing the following columns:
    • First Name
    • Last Name
    • Office
    • District (If Senator or House of Representatives, or “At-Large” for OHA, Gov. and Lt. Gov.)
    • IsWinner (True/False if the candidate won or not)
    • 2016 Disclosure URL
    • 2016 Disclosure Ammendment URL (If available)
  4. Collect Names + Total received amount contribution + Extra information of 2014-2016 Election of ethics.legislator and Losers from Campaign Contributions website / Campaign Contribution table. The transformed table should contain the following columns:
    1. First Name
    2. Last Name
    3. Total Amount
    4. Office
    5. District
    6. Party
  5. Establish the linkage between Ethics Website and Campaigns Website (names are not consistent) as follows:
    1. ethics.legislator (per Ethics website, in Campaign information can’t be obtained)
      1. Exact Match on District (if Senator or House of Representatives)
      2. Exact Match on Office
      3. Exact Match on Last Name
      4. Levenshtein distance on First Name
    2. Losers (per Ethics website, in Campaign information can’t be obtained)
      1. Exact Match on Office (District is not available in Ethics Website for Losers)
      2. Exact Match on Last Name
      3. Levenshtein distance on First Name
    3. Resulting table should contain all columns available from both websites + both names in the different websites.

1. Collect Ethics Website Names + Extra Info

1.1 Senate + House of Representatives

library(knitr)
library(data.table)
ethics.legislator <- fread("data/Hawaii_State_Ethics_Commission_s_2016_Legislator_Financial_Disclosure.csv")
kable(ethics.legislator)
Filer View Title Dept/Board Date Filed Original Amended File Type File Year
Ruderman, Russell E. Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8458.pdf) Legislator, District 2 Senate 01/03/2016 true false Financial 2016
Mizuno, John Musashi Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8483.pdf) Legislator, District 28 House of Representatives 01/06/2016 true false Financial 2016
Nishihara, Clarence K. Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8484.pdf) Legislator, District 17 Senate 01/06/2016 true false Financial 2016
Aquino, Henry James C. Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8501.pdf) Legislator, District 38 House of Representatives 01/07/2016 true false Financial 2016
Kong, Samuel Satoru Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8517.pdf) Legislator, District 33 House of Representatives 01/07/2016 true false Financial 2016
Evans, Cynthia Frances Wood Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8521.pdf) Legislator, District 7 House of Representatives 01/10/2016 true false Financial 2016
McKelvey, Angus L.K. Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8525.pdf) Legislator, District 10 House of Representatives 01/11/2016 true false Financial 2016
Tokioka, James K. Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8526.pdf) Legislator, District 15 House of Representatives 01/11/2016 true false Financial 2016
Thielen, Laura H. Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8580.pdf) Legislator, District 25 Senate 01/14/2016 true false Financial 2016
Ohno, Takashi Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8601.pdf) Legislator, District 27 House of Representatives 01/19/2016 true false Financial 2016
Shimabukuro, Maile S.L. Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8603.pdf) Legislator, District 21 Senate 01/19/2016 true false Financial 2016
Thielen, Cynthia H. Form (http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-10973.pdf) Legislator, District 50 House of Representatives 01/06/2016 true false Financial 2016
Green, Joshua B. Form (http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-10975.pdf) Legislator, District 3 Senate 01/11/2016 true false Financial 2016
Taniguchi, Brian T. Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8642.pdf) Legislator, District 11 Senate 01/23/2016 true false Financial 2016
Kobayashi, Bertrand Y. Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8645.pdf) Legislator, District 19 House of Representatives 01/24/2016 true false Financial 2016
Ward, Gene R. Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8646.pdf) Legislator, District 17 House of Representatives 01/24/2016 true false Financial 2016
Gabbard, Gerald Michael Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8651.pdf) Legislator, District 20 Senate 01/25/2016 true false Financial 2016
Say, Calvin K.Y. Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8659.pdf) Legislator, District 20 House of Representatives 01/25/2016 true false Financial 2016
Yamashita, Kyle T. Form (http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11062.pdf) Legislator, District 12 House of Representatives 01/25/2016 true false Financial 2016
Kim, Donna Mercado Form (http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11081.pdf) Legislator, District 14 Senate 01/27/2016 true false Financial 2016
Dela Cruz, Donovan Michael Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8696.pdf) Legislator, District 22 Senate 01/26/2016 true false Financial 2016
Luke, Sylvia J. Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8708.pdf) Legislator, District 25 House of Representatives 01/27/2016 true false Financial 2016
Ichiyama, Linda Eileen Form (http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11111.pdf) Legislator, District 32 House of Representatives 01/27/2016 true false Financial 2016
Keith-Agaran, Gilbert S.C. Form (http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11112.pdf) Legislator, District 5 Senate 01/27/2016 true false Financial 2016
Woodson, Justin H. Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8749.pdf) Legislator, District 9 House of Representatives 01/27/2016 true false Financial 2016
LoPresti, Matthew S. Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8746.pdf) Legislator, District 41 House of Representatives 01/27/2016 true false Financial 2016
Cachola, Romeo M. Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8738.pdf) Legislator, District 30 House of Representatives 01/27/2016 true false Financial 2016
DeCoite, Lynn P. Form (http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11126.pdf) Legislator, District 13 House of Representatives 01/28/2016 true false Financial 2016
Takumi, Roy M. Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8767.pdf) Legislator, District 35 House of Representatives 01/28/2016 true false Financial 2016
Ito, Kenneth T. Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8761.pdf) Legislator, District 49 House of Representatives 01/28/2016 true false Financial 2016
Thielen, Laura H. Form (http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11196.pdf) Legislator, District 25 Senate 01/29/2016 true true Financial 2016
English, J. Kalani Form (http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11198.pdf) Legislator, District 7 Senate 01/29/2016 true false Financial 2016
Tokuda, Jill Naomi Form (http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11199.pdf) Legislator, District 24 Senate 01/29/2016 true false Financial 2016
Espero, William Calip Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8784.pdf) Legislator, District 19 Senate 01/28/2016 true false Financial 2016
Creagan, Richard P. Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8786.pdf) Legislator, District 5 House of Representatives 01/28/2016 true false Financial 2016
San Buenaventura, Joy A. Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8787.pdf) Legislator, District 4 House of Representatives 01/28/2016 true false Financial 2016
Morikawa, Daynette S.P. Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8799.pdf) Legislator, District 16 House of Representatives 01/29/2016 true false Financial 2016
Inouye, Lorraine Rodero Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8800.pdf) Legislator, District 4 Senate 01/29/2016 true false Financial 2016
Nishimoto, Scott Y. Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8831.pdf) Legislator, District 21 House of Representatives 01/29/2016 true false Financial 2016
Baker, Rosalyn H. Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8863.pdf) Legislator, District 6 Senate 01/29/2016 true false Financial 2016
Keohokalole, Jarrett K. Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8868.pdf) Legislator, District 48 House of Representatives 01/30/2016 true false Financial 2016
Hashem, Mark Jun Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8871.pdf) Legislator, District 18 House of Representatives 01/30/2016 true false Financial 2016
Saiki, Scott K. Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8877.pdf) Legislator, District 26 House of Representatives 01/31/2016 true false Financial 2016
Harimoto, Breene Y. Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8878.pdf) Legislator, District 16 Senate 01/31/2016 true false Financial 2016
Takayama, Gregg T. Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8879.pdf) Legislator, District 34 House of Representatives 01/31/2016 true false Financial 2016
Choy, Isaac William Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8882.pdf) Legislator, District 23 House of Representatives 01/31/2016 true false Financial 2016
Oshiro, Marcus R. Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8884.pdf) Legislator, District 46 House of Representatives 01/31/2016 true false Financial 2016
Ihara, Les S. Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8885.pdf) Legislator, District 10 Senate 01/31/2016 true false Financial 2016
Riviere, Gilbert R. Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8886.pdf) Legislator, District 23 Senate 01/31/2016 true false Financial 2016
Har, Sharon E. Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8890.pdf) Legislator, District 42 House of Representatives 02/01/2016 true false Financial 2016
Nakashima, Mark M. Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8895.pdf) Legislator, District 1 House of Representatives 02/01/2016 true false Financial 2016
Belatti, Della Au Form (http://files.hawaii.gov/ethics/disc/2016/FinShort_8896.pdf) Legislator, District 24 House of Representatives 02/01/2016 true true Financial 2016
Galuteria, Brickwood M. Form (http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11208.pdf) Legislator, District 12 Senate 01/30/2016 true false Financial 2016
Souki, Joseph Mark Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8914.pdf) Legislator, District 8 House of Representatives 02/01/2016 true false Financial 2016
Belatti, Della Au Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8887.pdf) Legislator, District 24 House of Representatives 02/01/2016 true false Financial 2016
Brower, Thomas M. Form (http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11218.pdf) Legislator, District 22 House of Representatives 02/01/2016 true false Financial 2016
Johanson, Aaron L. Form (http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11243.pdf) Legislator, District 31 House of Representatives 02/01/2016 true false Financial 2016
Onishi, Richard H.K. Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8920.pdf) Legislator, District 3 House of Representatives 02/01/2016 true false Financial 2016
Tupola, Andria P. Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8926.pdf) Legislator, District 43 House of Representatives 02/01/2016 true false Financial 2016
Lowen, Nicole E. Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8927.pdf) Legislator, District 6 House of Representatives 02/01/2016 true false Financial 2016
Kidani, Michelle N. Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8932.pdf) Legislator, District 18 Senate 02/01/2016 true false Financial 2016
Creagan, Richard P. Form (http://files.hawaii.gov/ethics/disc/2016/FinShort_8933.pdf) Legislator, District 5 House of Representatives 02/01/2016 true true Financial 2016
Kouchi, Ronald D. Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8938.pdf) Legislator, District 8 Senate 02/01/2016 true false Financial 2016
Cullen, Ty J.K. Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8940.pdf) Legislator, District 39 House of Representatives 02/01/2016 true false Financial 2016
Ing, Mark Kaniela Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8941.pdf) Legislator, District 11 House of Representatives 02/01/2016 true false Financial 2016
Wakai, Glenn Satoru Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8944.pdf) Legislator, District 15 Senate 02/01/2016 true false Financial 2016
Matsumoto, Lauren K. Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8945.pdf) Legislator, District 45 House of Representatives 02/01/2016 true false Financial 2016
Fukumoto Chang, Beth Keiko Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8946.pdf) Legislator, District 36 House of Representatives 02/01/2016 true false Financial 2016
McDermott, Robert C. Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8950.pdf) Legislator, District 40 House of Representatives 02/01/2016 true false Financial 2016
Lee, Christopher Kalani Cushman Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8951.pdf) Legislator, District 51 House of Representatives 02/01/2016 true false Financial 2016
Matsumoto, Lauren K. Form (http://files.hawaii.gov/ethics/disc/2016/FinShort_8961.pdf) Legislator, District 45 House of Representatives 02/03/2016 true true Financial 2016
Green, Joshua B. Form (http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11474.pdf) Legislator, District 3 Senate 03/09/2016 true true Financial 2016
Kahele, Kaialii Form (http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11734.pdf) Legislator, District 1 Senate 03/31/2016 true false Financial 2016
Yamane, Ryan Ichiro Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_8861.pdf) Legislator, District 37 House of Representatives 01/29/2016 true false Financial 2016
Morikawa, Daynette S.P. Form (http://files.hawaii.gov/ethics/disc/2016/FinShort_11303.pdf) Legislator, District 16 House of Representatives 07/07/2016 true true Financial 2016
Kahele, Kaialii Form (http://files.hawaii.gov/ethics/disc/2016/FinShort_11350.pdf) Legislator, District 1 Senate 07/20/2016 true false Financial 2016
Wakai, Glenn Satoru Form (http://files.hawaii.gov/ethics/disc/2016/FinShort_11426.pdf) Legislator, District 15 Senate 08/01/2016 true false Financial 2016
McDermott, Robert C. Form (http://files.hawaii.gov/ethics/disc/2016/FinShort_11680.pdf) Legislator, District 40 House of Representatives 10/07/2016 true true Financial 2016
McDermott, Robert C. Form (http://files.hawaii.gov/ethics/disc/2016/FinShort_11681.pdf) Legislator, District 40 House of Representatives 10/07/2016 true true Financial 2016

Removing Repeated Names

First, we must remove the repeated names. The name is repeated only once in most of the cases (counter example: McDermott, Robert C. has 3!), if there is an amendment. When the “Amended” column is True, then the “View” column links the amended PDF. Otherwise, it links the Original PDF. To simplify the logic, I just replace the Original and Amended columns to contain the URL instead, while filtering the redundant row, so the table contains an exact unique person per row. Note on the exceptional case a person has more than 2 rows on the original table, it will guess using the same logic if it is an ammend or original form, and concatenate the urls using the “;” symbol. See below the links for McDermott for an example on the amended having 2 urls, and Kahele, Kaialii for an example of original having 2 urls.

library(stringr)
#Since all tables in Ethics department contain the same logic, the function applies to all tables.
links_pdfs <- function(view,ammended,datefiled){
    #At this scope, View, Original and Ammended are character vectors of length 1, 2, or (usually up to) 3 of every filer. (The length is consistent in size for a given candidate since the input is a table). 
    ammend_index <- which(ammended == 'true')
    ammend_url <- ifelse(length(ammend_index) != 0,
           str_c(view[ammend_index],collapse=";"), #Test is TRUE if there was at least one ammend by the filer and concatenate all ammend urls
           '') #ELSE return empty string
    
    
    
    original_index <- which(ammended == 'false') #Can't use Original column since it is always true
    original_url <- ifelse(length(original_index) != 0,
           str_c(view[original_index],collapse=";"), #Test is TRUE if there was at least one ammend by the filer and concatenate all ammend urls
           '') #ELSE return empty string
    
    
    #Combine data fields in the same order to stay consistent
    dates <- str_c(datefiled,collapse=";")
    
    #pdfs <- ifelse(ammend_url != '',str_c(original_url,ammend_url,sep=';'),original_url)
    pdfs <- list(original_url=original_url,ammend_url=ammend_url,dates=dates)
    return(pdfs)
}
#http://www.astrostatistics.psu.edu/su07/R/html/base/html/regex.html
#http://stackoverflow.com/questions/13498843/regex-to-pickout-some-text-between-parenthesis
format_url <- function (x) gsub(".*\\((.*)\\).*", "\\1", x) 

ethics.legislator <- ethics.legislator
ethics.legislator$View <- format_url(ethics.legislator$View)
ethics.legislator <- ethics.legislator[,links_pdfs(View,Amended,`Date Filed`),by=c("Filer","Title","Dept/Board","File Year")]
kable(ethics.legislator)
Filer Title Dept/Board File Year original_url ammend_url dates
Ruderman, Russell E. Legislator, District 2 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8458.pdf 01/03/2016
Mizuno, John Musashi Legislator, District 28 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8483.pdf 01/06/2016
Nishihara, Clarence K. Legislator, District 17 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8484.pdf 01/06/2016
Aquino, Henry James C. Legislator, District 38 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8501.pdf 01/07/2016
Kong, Samuel Satoru Legislator, District 33 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8517.pdf 01/07/2016
Evans, Cynthia Frances Wood Legislator, District 7 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8521.pdf 01/10/2016
McKelvey, Angus L.K. Legislator, District 10 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8525.pdf 01/11/2016
Tokioka, James K. Legislator, District 15 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8526.pdf 01/11/2016
Thielen, Laura H. Legislator, District 25 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8580.pdf http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11196.pdf 01/14/2016;01/29/2016
Ohno, Takashi Legislator, District 27 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8601.pdf 01/19/2016
Shimabukuro, Maile S.L. Legislator, District 21 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8603.pdf 01/19/2016
Thielen, Cynthia H. Legislator, District 50 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-10973.pdf 01/06/2016
Green, Joshua B. Legislator, District 3 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-10975.pdf http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11474.pdf 01/11/2016;03/09/2016
Taniguchi, Brian T. Legislator, District 11 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8642.pdf 01/23/2016
Kobayashi, Bertrand Y. Legislator, District 19 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8645.pdf 01/24/2016
Ward, Gene R. Legislator, District 17 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8646.pdf 01/24/2016
Gabbard, Gerald Michael Legislator, District 20 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8651.pdf 01/25/2016
Say, Calvin K.Y. Legislator, District 20 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8659.pdf 01/25/2016
Yamashita, Kyle T. Legislator, District 12 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11062.pdf 01/25/2016
Kim, Donna Mercado Legislator, District 14 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11081.pdf 01/27/2016
Dela Cruz, Donovan Michael Legislator, District 22 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8696.pdf 01/26/2016
Luke, Sylvia J. Legislator, District 25 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8708.pdf 01/27/2016
Ichiyama, Linda Eileen Legislator, District 32 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11111.pdf 01/27/2016
Keith-Agaran, Gilbert S.C. Legislator, District 5 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11112.pdf 01/27/2016
Woodson, Justin H. Legislator, District 9 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8749.pdf 01/27/2016
LoPresti, Matthew S. Legislator, District 41 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8746.pdf 01/27/2016
Cachola, Romeo M. Legislator, District 30 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8738.pdf 01/27/2016
DeCoite, Lynn P. Legislator, District 13 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11126.pdf 01/28/2016
Takumi, Roy M. Legislator, District 35 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8767.pdf 01/28/2016
Ito, Kenneth T. Legislator, District 49 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8761.pdf 01/28/2016
English, J. Kalani Legislator, District 7 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11198.pdf 01/29/2016
Tokuda, Jill Naomi Legislator, District 24 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11199.pdf 01/29/2016
Espero, William Calip Legislator, District 19 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8784.pdf 01/28/2016
Creagan, Richard P. Legislator, District 5 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8786.pdf http://files.hawaii.gov/ethics/disc/2016/FinShort_8933.pdf 01/28/2016;02/01/2016
San Buenaventura, Joy A. Legislator, District 4 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8787.pdf 01/28/2016
Morikawa, Daynette S.P. Legislator, District 16 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8799.pdf http://files.hawaii.gov/ethics/disc/2016/FinShort_11303.pdf 01/29/2016;07/07/2016
Inouye, Lorraine Rodero Legislator, District 4 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8800.pdf 01/29/2016
Nishimoto, Scott Y. Legislator, District 21 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8831.pdf 01/29/2016
Baker, Rosalyn H. Legislator, District 6 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8863.pdf 01/29/2016
Keohokalole, Jarrett K. Legislator, District 48 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8868.pdf 01/30/2016
Hashem, Mark Jun Legislator, District 18 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8871.pdf 01/30/2016
Saiki, Scott K. Legislator, District 26 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8877.pdf 01/31/2016
Harimoto, Breene Y. Legislator, District 16 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8878.pdf 01/31/2016
Takayama, Gregg T. Legislator, District 34 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8879.pdf 01/31/2016
Choy, Isaac William Legislator, District 23 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8882.pdf 01/31/2016
Oshiro, Marcus R. Legislator, District 46 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8884.pdf 01/31/2016
Ihara, Les S. Legislator, District 10 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8885.pdf 01/31/2016
Riviere, Gilbert R. Legislator, District 23 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8886.pdf 01/31/2016
Har, Sharon E. Legislator, District 42 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8890.pdf 02/01/2016
Nakashima, Mark M. Legislator, District 1 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8895.pdf 02/01/2016
Belatti, Della Au Legislator, District 24 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8887.pdf http://files.hawaii.gov/ethics/disc/2016/FinShort_8896.pdf 02/01/2016;02/01/2016
Galuteria, Brickwood M. Legislator, District 12 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11208.pdf 01/30/2016
Souki, Joseph Mark Legislator, District 8 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8914.pdf 02/01/2016
Brower, Thomas M. Legislator, District 22 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11218.pdf 02/01/2016
Johanson, Aaron L. Legislator, District 31 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11243.pdf 02/01/2016
Onishi, Richard H.K. Legislator, District 3 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8920.pdf 02/01/2016
Tupola, Andria P. Legislator, District 43 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8926.pdf 02/01/2016
Lowen, Nicole E. Legislator, District 6 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8927.pdf 02/01/2016
Kidani, Michelle N. Legislator, District 18 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8932.pdf 02/01/2016
Kouchi, Ronald D. Legislator, District 8 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8938.pdf 02/01/2016
Cullen, Ty J.K. Legislator, District 39 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8940.pdf 02/01/2016
Ing, Mark Kaniela Legislator, District 11 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8941.pdf 02/01/2016
Wakai, Glenn Satoru Legislator, District 15 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8944.pdf;http://files.hawaii.gov/ethics/disc/2016/FinShort_11426.pdf 02/01/2016;08/01/2016
Matsumoto, Lauren K. Legislator, District 45 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8945.pdf http://files.hawaii.gov/ethics/disc/2016/FinShort_8961.pdf 02/01/2016;02/03/2016
Fukumoto Chang, Beth Keiko Legislator, District 36 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8946.pdf 02/01/2016
McDermott, Robert C. Legislator, District 40 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8950.pdf http://files.hawaii.gov/ethics/disc/2016/FinShort_11680.pdf;http://files.hawaii.gov/ethics/disc/2016/FinShort_11681.pdf 02/01/2016;10/07/2016;10/07/2016
Lee, Christopher Kalani Cushman Legislator, District 51 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8951.pdf 02/01/2016
Kahele, Kaialii Legislator, District 1 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11734.pdf;http://files.hawaii.gov/ethics/disc/2016/FinShort_11350.pdf 03/31/2016;07/20/2016
Yamane, Ryan Ichiro Legislator, District 37 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8861.pdf 01/29/2016

Separate First and Last Name

For crossing this table eventually against the campaign website table, the (1) name must be split into first and last name (using the ‘,’ symbol) and (2) any extra leading or trailing whitespace after the words are split must also be removed to avoid matching inconsistencies. The Filer name is kept although renamed, as we still need it to compare people across tables within the ethics website.

trim <- function (x) gsub("^\\s+|\\s+$", "", x) #removes leading and trailing whitespace

get_first_last_name <- function(name){
  name_list <- strsplit(name,",")
  last_name <- trim(sapply(name_list,"[[",1))
  first_name <- trim(sapply(name_list,"[[",2))
  return(data.table(ethics_first_name=first_name,ethics_last_name=last_name))
}

ethics.legislator <- cbind(get_first_last_name(ethics.legislator$Filer),ethics.legislator)
colnames(ethics.legislator)[3] <- "ethics_full_name" 
kable(ethics.legislator)
ethics_first_name ethics_last_name ethics_full_name Title Dept/Board File Year original_url ammend_url dates
Russell E. Ruderman Ruderman, Russell E. Legislator, District 2 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8458.pdf 01/03/2016
John Musashi Mizuno Mizuno, John Musashi Legislator, District 28 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8483.pdf 01/06/2016
Clarence K. Nishihara Nishihara, Clarence K. Legislator, District 17 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8484.pdf 01/06/2016
Henry James C. Aquino Aquino, Henry James C. Legislator, District 38 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8501.pdf 01/07/2016
Samuel Satoru Kong Kong, Samuel Satoru Legislator, District 33 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8517.pdf 01/07/2016
Cynthia Frances Wood Evans Evans, Cynthia Frances Wood Legislator, District 7 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8521.pdf 01/10/2016
Angus L.K. McKelvey McKelvey, Angus L.K. Legislator, District 10 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8525.pdf 01/11/2016
James K. Tokioka Tokioka, James K. Legislator, District 15 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8526.pdf 01/11/2016
Laura H. Thielen Thielen, Laura H. Legislator, District 25 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8580.pdf http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11196.pdf 01/14/2016;01/29/2016
Takashi Ohno Ohno, Takashi Legislator, District 27 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8601.pdf 01/19/2016
Maile S.L. Shimabukuro Shimabukuro, Maile S.L. Legislator, District 21 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8603.pdf 01/19/2016
Cynthia H. Thielen Thielen, Cynthia H. Legislator, District 50 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-10973.pdf 01/06/2016
Joshua B. Green Green, Joshua B. Legislator, District 3 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-10975.pdf http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11474.pdf 01/11/2016;03/09/2016
Brian T. Taniguchi Taniguchi, Brian T. Legislator, District 11 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8642.pdf 01/23/2016
Bertrand Y. Kobayashi Kobayashi, Bertrand Y. Legislator, District 19 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8645.pdf 01/24/2016
Gene R. Ward Ward, Gene R. Legislator, District 17 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8646.pdf 01/24/2016
Gerald Michael Gabbard Gabbard, Gerald Michael Legislator, District 20 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8651.pdf 01/25/2016
Calvin K.Y. Say Say, Calvin K.Y. Legislator, District 20 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8659.pdf 01/25/2016
Kyle T. Yamashita Yamashita, Kyle T. Legislator, District 12 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11062.pdf 01/25/2016
Donna Mercado Kim Kim, Donna Mercado Legislator, District 14 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11081.pdf 01/27/2016
Donovan Michael Dela Cruz Dela Cruz, Donovan Michael Legislator, District 22 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8696.pdf 01/26/2016
Sylvia J. Luke Luke, Sylvia J. Legislator, District 25 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8708.pdf 01/27/2016
Linda Eileen Ichiyama Ichiyama, Linda Eileen Legislator, District 32 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11111.pdf 01/27/2016
Gilbert S.C. Keith-Agaran Keith-Agaran, Gilbert S.C. Legislator, District 5 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11112.pdf 01/27/2016
Justin H. Woodson Woodson, Justin H. Legislator, District 9 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8749.pdf 01/27/2016
Matthew S. LoPresti LoPresti, Matthew S. Legislator, District 41 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8746.pdf 01/27/2016
Romeo M. Cachola Cachola, Romeo M. Legislator, District 30 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8738.pdf 01/27/2016
Lynn P. DeCoite DeCoite, Lynn P. Legislator, District 13 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11126.pdf 01/28/2016
Roy M. Takumi Takumi, Roy M. Legislator, District 35 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8767.pdf 01/28/2016
Kenneth T. Ito Ito, Kenneth T. Legislator, District 49 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8761.pdf 01/28/2016
J. Kalani English English, J. Kalani Legislator, District 7 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11198.pdf 01/29/2016
Jill Naomi Tokuda Tokuda, Jill Naomi Legislator, District 24 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11199.pdf 01/29/2016
William Calip Espero Espero, William Calip Legislator, District 19 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8784.pdf 01/28/2016
Richard P. Creagan Creagan, Richard P. Legislator, District 5 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8786.pdf http://files.hawaii.gov/ethics/disc/2016/FinShort_8933.pdf 01/28/2016;02/01/2016
Joy A. San Buenaventura San Buenaventura, Joy A. Legislator, District 4 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8787.pdf 01/28/2016
Daynette S.P. Morikawa Morikawa, Daynette S.P. Legislator, District 16 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8799.pdf http://files.hawaii.gov/ethics/disc/2016/FinShort_11303.pdf 01/29/2016;07/07/2016
Lorraine Rodero Inouye Inouye, Lorraine Rodero Legislator, District 4 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8800.pdf 01/29/2016
Scott Y. Nishimoto Nishimoto, Scott Y. Legislator, District 21 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8831.pdf 01/29/2016
Rosalyn H. Baker Baker, Rosalyn H. Legislator, District 6 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8863.pdf 01/29/2016
Jarrett K. Keohokalole Keohokalole, Jarrett K. Legislator, District 48 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8868.pdf 01/30/2016
Mark Jun Hashem Hashem, Mark Jun Legislator, District 18 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8871.pdf 01/30/2016
Scott K. Saiki Saiki, Scott K. Legislator, District 26 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8877.pdf 01/31/2016
Breene Y. Harimoto Harimoto, Breene Y. Legislator, District 16 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8878.pdf 01/31/2016
Gregg T. Takayama Takayama, Gregg T. Legislator, District 34 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8879.pdf 01/31/2016
Isaac William Choy Choy, Isaac William Legislator, District 23 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8882.pdf 01/31/2016
Marcus R. Oshiro Oshiro, Marcus R. Legislator, District 46 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8884.pdf 01/31/2016
Les S. Ihara Ihara, Les S. Legislator, District 10 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8885.pdf 01/31/2016
Gilbert R. Riviere Riviere, Gilbert R. Legislator, District 23 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8886.pdf 01/31/2016
Sharon E. Har Har, Sharon E. Legislator, District 42 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8890.pdf 02/01/2016
Mark M. Nakashima Nakashima, Mark M. Legislator, District 1 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8895.pdf 02/01/2016
Della Au Belatti Belatti, Della Au Legislator, District 24 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8887.pdf http://files.hawaii.gov/ethics/disc/2016/FinShort_8896.pdf 02/01/2016;02/01/2016
Brickwood M. Galuteria Galuteria, Brickwood M. Legislator, District 12 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11208.pdf 01/30/2016
Joseph Mark Souki Souki, Joseph Mark Legislator, District 8 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8914.pdf 02/01/2016
Thomas M. Brower Brower, Thomas M. Legislator, District 22 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11218.pdf 02/01/2016
Aaron L. Johanson Johanson, Aaron L. Legislator, District 31 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11243.pdf 02/01/2016
Richard H.K. Onishi Onishi, Richard H.K. Legislator, District 3 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8920.pdf 02/01/2016
Andria P. Tupola Tupola, Andria P. Legislator, District 43 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8926.pdf 02/01/2016
Nicole E. Lowen Lowen, Nicole E. Legislator, District 6 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8927.pdf 02/01/2016
Michelle N. Kidani Kidani, Michelle N. Legislator, District 18 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8932.pdf 02/01/2016
Ronald D. Kouchi Kouchi, Ronald D. Legislator, District 8 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8938.pdf 02/01/2016
Ty J.K. Cullen Cullen, Ty J.K. Legislator, District 39 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8940.pdf 02/01/2016
Mark Kaniela Ing Ing, Mark Kaniela Legislator, District 11 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8941.pdf 02/01/2016
Glenn Satoru Wakai Wakai, Glenn Satoru Legislator, District 15 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8944.pdf;http://files.hawaii.gov/ethics/disc/2016/FinShort_11426.pdf 02/01/2016;08/01/2016
Lauren K. Matsumoto Matsumoto, Lauren K. Legislator, District 45 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8945.pdf http://files.hawaii.gov/ethics/disc/2016/FinShort_8961.pdf 02/01/2016;02/03/2016
Beth Keiko Fukumoto Chang Fukumoto Chang, Beth Keiko Legislator, District 36 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8946.pdf 02/01/2016
Robert C. McDermott McDermott, Robert C. Legislator, District 40 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8950.pdf http://files.hawaii.gov/ethics/disc/2016/FinShort_11680.pdf;http://files.hawaii.gov/ethics/disc/2016/FinShort_11681.pdf 02/01/2016;10/07/2016;10/07/2016
Christopher Kalani Cushman Lee Lee, Christopher Kalani Cushman Legislator, District 51 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8951.pdf 02/01/2016
Kaialii Kahele Kahele, Kaialii Legislator, District 1 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11734.pdf;http://files.hawaii.gov/ethics/disc/2016/FinShort_11350.pdf 03/31/2016;07/20/2016
Ryan Ichiro Yamane Yamane, Ryan Ichiro Legislator, District 37 House of Representatives 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8861.pdf 01/29/2016

Parse Dept/Board

In order to compare against the campaign website, I must also adopt a consistent definition for the dept/board on both ends. Senate, OHA, and House will be used instead, which requires House of Representatives being renamed here.

ethics.legislator <- ethics.legislator[`Dept/Board`=="House of Representatives",`Dept/Board`:="House"]
kable(ethics.legislator)
ethics_first_name ethics_last_name ethics_full_name Title Dept/Board File Year original_url ammend_url dates
Russell E. Ruderman Ruderman, Russell E. Legislator, District 2 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8458.pdf 01/03/2016
John Musashi Mizuno Mizuno, John Musashi Legislator, District 28 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8483.pdf 01/06/2016
Clarence K. Nishihara Nishihara, Clarence K. Legislator, District 17 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8484.pdf 01/06/2016
Henry James C. Aquino Aquino, Henry James C. Legislator, District 38 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8501.pdf 01/07/2016
Samuel Satoru Kong Kong, Samuel Satoru Legislator, District 33 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8517.pdf 01/07/2016
Cynthia Frances Wood Evans Evans, Cynthia Frances Wood Legislator, District 7 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8521.pdf 01/10/2016
Angus L.K. McKelvey McKelvey, Angus L.K. Legislator, District 10 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8525.pdf 01/11/2016
James K. Tokioka Tokioka, James K. Legislator, District 15 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8526.pdf 01/11/2016
Laura H. Thielen Thielen, Laura H. Legislator, District 25 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8580.pdf http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11196.pdf 01/14/2016;01/29/2016
Takashi Ohno Ohno, Takashi Legislator, District 27 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8601.pdf 01/19/2016
Maile S.L. Shimabukuro Shimabukuro, Maile S.L. Legislator, District 21 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8603.pdf 01/19/2016
Cynthia H. Thielen Thielen, Cynthia H. Legislator, District 50 House 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-10973.pdf 01/06/2016
Joshua B. Green Green, Joshua B. Legislator, District 3 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-10975.pdf http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11474.pdf 01/11/2016;03/09/2016
Brian T. Taniguchi Taniguchi, Brian T. Legislator, District 11 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8642.pdf 01/23/2016
Bertrand Y. Kobayashi Kobayashi, Bertrand Y. Legislator, District 19 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8645.pdf 01/24/2016
Gene R. Ward Ward, Gene R. Legislator, District 17 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8646.pdf 01/24/2016
Gerald Michael Gabbard Gabbard, Gerald Michael Legislator, District 20 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8651.pdf 01/25/2016
Calvin K.Y. Say Say, Calvin K.Y. Legislator, District 20 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8659.pdf 01/25/2016
Kyle T. Yamashita Yamashita, Kyle T. Legislator, District 12 House 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11062.pdf 01/25/2016
Donna Mercado Kim Kim, Donna Mercado Legislator, District 14 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11081.pdf 01/27/2016
Donovan Michael Dela Cruz Dela Cruz, Donovan Michael Legislator, District 22 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8696.pdf 01/26/2016
Sylvia J. Luke Luke, Sylvia J. Legislator, District 25 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8708.pdf 01/27/2016
Linda Eileen Ichiyama Ichiyama, Linda Eileen Legislator, District 32 House 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11111.pdf 01/27/2016
Gilbert S.C. Keith-Agaran Keith-Agaran, Gilbert S.C. Legislator, District 5 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11112.pdf 01/27/2016
Justin H. Woodson Woodson, Justin H. Legislator, District 9 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8749.pdf 01/27/2016
Matthew S. LoPresti LoPresti, Matthew S. Legislator, District 41 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8746.pdf 01/27/2016
Romeo M. Cachola Cachola, Romeo M. Legislator, District 30 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8738.pdf 01/27/2016
Lynn P. DeCoite DeCoite, Lynn P. Legislator, District 13 House 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11126.pdf 01/28/2016
Roy M. Takumi Takumi, Roy M. Legislator, District 35 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8767.pdf 01/28/2016
Kenneth T. Ito Ito, Kenneth T. Legislator, District 49 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8761.pdf 01/28/2016
J. Kalani English English, J. Kalani Legislator, District 7 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11198.pdf 01/29/2016
Jill Naomi Tokuda Tokuda, Jill Naomi Legislator, District 24 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11199.pdf 01/29/2016
William Calip Espero Espero, William Calip Legislator, District 19 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8784.pdf 01/28/2016
Richard P. Creagan Creagan, Richard P. Legislator, District 5 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8786.pdf http://files.hawaii.gov/ethics/disc/2016/FinShort_8933.pdf 01/28/2016;02/01/2016
Joy A. San Buenaventura San Buenaventura, Joy A. Legislator, District 4 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8787.pdf 01/28/2016
Daynette S.P. Morikawa Morikawa, Daynette S.P. Legislator, District 16 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8799.pdf http://files.hawaii.gov/ethics/disc/2016/FinShort_11303.pdf 01/29/2016;07/07/2016
Lorraine Rodero Inouye Inouye, Lorraine Rodero Legislator, District 4 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8800.pdf 01/29/2016
Scott Y. Nishimoto Nishimoto, Scott Y. Legislator, District 21 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8831.pdf 01/29/2016
Rosalyn H. Baker Baker, Rosalyn H. Legislator, District 6 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8863.pdf 01/29/2016
Jarrett K. Keohokalole Keohokalole, Jarrett K. Legislator, District 48 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8868.pdf 01/30/2016
Mark Jun Hashem Hashem, Mark Jun Legislator, District 18 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8871.pdf 01/30/2016
Scott K. Saiki Saiki, Scott K. Legislator, District 26 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8877.pdf 01/31/2016
Breene Y. Harimoto Harimoto, Breene Y. Legislator, District 16 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8878.pdf 01/31/2016
Gregg T. Takayama Takayama, Gregg T. Legislator, District 34 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8879.pdf 01/31/2016
Isaac William Choy Choy, Isaac William Legislator, District 23 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8882.pdf 01/31/2016
Marcus R. Oshiro Oshiro, Marcus R. Legislator, District 46 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8884.pdf 01/31/2016
Les S. Ihara Ihara, Les S. Legislator, District 10 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8885.pdf 01/31/2016
Gilbert R. Riviere Riviere, Gilbert R. Legislator, District 23 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8886.pdf 01/31/2016
Sharon E. Har Har, Sharon E. Legislator, District 42 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8890.pdf 02/01/2016
Mark M. Nakashima Nakashima, Mark M. Legislator, District 1 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8895.pdf 02/01/2016
Della Au Belatti Belatti, Della Au Legislator, District 24 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8887.pdf http://files.hawaii.gov/ethics/disc/2016/FinShort_8896.pdf 02/01/2016;02/01/2016
Brickwood M. Galuteria Galuteria, Brickwood M. Legislator, District 12 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11208.pdf 01/30/2016
Joseph Mark Souki Souki, Joseph Mark Legislator, District 8 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8914.pdf 02/01/2016
Thomas M. Brower Brower, Thomas M. Legislator, District 22 House 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11218.pdf 02/01/2016
Aaron L. Johanson Johanson, Aaron L. Legislator, District 31 House 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11243.pdf 02/01/2016
Richard H.K. Onishi Onishi, Richard H.K. Legislator, District 3 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8920.pdf 02/01/2016
Andria P. Tupola Tupola, Andria P. Legislator, District 43 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8926.pdf 02/01/2016
Nicole E. Lowen Lowen, Nicole E. Legislator, District 6 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8927.pdf 02/01/2016
Michelle N. Kidani Kidani, Michelle N. Legislator, District 18 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8932.pdf 02/01/2016
Ronald D. Kouchi Kouchi, Ronald D. Legislator, District 8 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8938.pdf 02/01/2016
Ty J.K. Cullen Cullen, Ty J.K. Legislator, District 39 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8940.pdf 02/01/2016
Mark Kaniela Ing Ing, Mark Kaniela Legislator, District 11 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8941.pdf 02/01/2016
Glenn Satoru Wakai Wakai, Glenn Satoru Legislator, District 15 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8944.pdf;http://files.hawaii.gov/ethics/disc/2016/FinShort_11426.pdf 02/01/2016;08/01/2016
Lauren K. Matsumoto Matsumoto, Lauren K. Legislator, District 45 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8945.pdf http://files.hawaii.gov/ethics/disc/2016/FinShort_8961.pdf 02/01/2016;02/03/2016
Beth Keiko Fukumoto Chang Fukumoto Chang, Beth Keiko Legislator, District 36 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8946.pdf 02/01/2016
Robert C. McDermott McDermott, Robert C. Legislator, District 40 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8950.pdf http://files.hawaii.gov/ethics/disc/2016/FinShort_11680.pdf;http://files.hawaii.gov/ethics/disc/2016/FinShort_11681.pdf 02/01/2016;10/07/2016;10/07/2016
Christopher Kalani Cushman Lee Lee, Christopher Kalani Cushman Legislator, District 51 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8951.pdf 02/01/2016
Kaialii Kahele Kahele, Kaialii Legislator, District 1 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11734.pdf;http://files.hawaii.gov/ethics/disc/2016/FinShort_11350.pdf 03/31/2016;07/20/2016
Ryan Ichiro Yamane Yamane, Ryan Ichiro Legislator, District 37 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8861.pdf 01/29/2016

Parse District

For the district, I only maintain the number:

ethics.legislator$Title <- sapply(str_split(ethics.legislator$Title," "),"[[",3)
colnames(ethics.legislator)[4] <- "district"
kable(ethics.legislator)
ethics_first_name ethics_last_name ethics_full_name district Dept/Board File Year original_url ammend_url dates
Russell E. Ruderman Ruderman, Russell E. 2 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8458.pdf 01/03/2016
John Musashi Mizuno Mizuno, John Musashi 28 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8483.pdf 01/06/2016
Clarence K. Nishihara Nishihara, Clarence K. 17 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8484.pdf 01/06/2016
Henry James C. Aquino Aquino, Henry James C. 38 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8501.pdf 01/07/2016
Samuel Satoru Kong Kong, Samuel Satoru 33 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8517.pdf 01/07/2016
Cynthia Frances Wood Evans Evans, Cynthia Frances Wood 7 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8521.pdf 01/10/2016
Angus L.K. McKelvey McKelvey, Angus L.K. 10 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8525.pdf 01/11/2016
James K. Tokioka Tokioka, James K. 15 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8526.pdf 01/11/2016
Laura H. Thielen Thielen, Laura H. 25 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8580.pdf http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11196.pdf 01/14/2016;01/29/2016
Takashi Ohno Ohno, Takashi 27 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8601.pdf 01/19/2016
Maile S.L. Shimabukuro Shimabukuro, Maile S.L. 21 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8603.pdf 01/19/2016
Cynthia H. Thielen Thielen, Cynthia H. 50 House 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-10973.pdf 01/06/2016
Joshua B. Green Green, Joshua B. 3 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-10975.pdf http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11474.pdf 01/11/2016;03/09/2016
Brian T. Taniguchi Taniguchi, Brian T. 11 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8642.pdf 01/23/2016
Bertrand Y. Kobayashi Kobayashi, Bertrand Y. 19 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8645.pdf 01/24/2016
Gene R. Ward Ward, Gene R. 17 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8646.pdf 01/24/2016
Gerald Michael Gabbard Gabbard, Gerald Michael 20 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8651.pdf 01/25/2016
Calvin K.Y. Say Say, Calvin K.Y. 20 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8659.pdf 01/25/2016
Kyle T. Yamashita Yamashita, Kyle T. 12 House 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11062.pdf 01/25/2016
Donna Mercado Kim Kim, Donna Mercado 14 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11081.pdf 01/27/2016
Donovan Michael Dela Cruz Dela Cruz, Donovan Michael 22 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8696.pdf 01/26/2016
Sylvia J. Luke Luke, Sylvia J. 25 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8708.pdf 01/27/2016
Linda Eileen Ichiyama Ichiyama, Linda Eileen 32 House 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11111.pdf 01/27/2016
Gilbert S.C. Keith-Agaran Keith-Agaran, Gilbert S.C. 5 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11112.pdf 01/27/2016
Justin H. Woodson Woodson, Justin H. 9 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8749.pdf 01/27/2016
Matthew S. LoPresti LoPresti, Matthew S. 41 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8746.pdf 01/27/2016
Romeo M. Cachola Cachola, Romeo M. 30 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8738.pdf 01/27/2016
Lynn P. DeCoite DeCoite, Lynn P. 13 House 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11126.pdf 01/28/2016
Roy M. Takumi Takumi, Roy M. 35 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8767.pdf 01/28/2016
Kenneth T. Ito Ito, Kenneth T. 49 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8761.pdf 01/28/2016
J. Kalani English English, J. Kalani 7 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11198.pdf 01/29/2016
Jill Naomi Tokuda Tokuda, Jill Naomi 24 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11199.pdf 01/29/2016
William Calip Espero Espero, William Calip 19 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8784.pdf 01/28/2016
Richard P. Creagan Creagan, Richard P. 5 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8786.pdf http://files.hawaii.gov/ethics/disc/2016/FinShort_8933.pdf 01/28/2016;02/01/2016
Joy A. San Buenaventura San Buenaventura, Joy A. 4 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8787.pdf 01/28/2016
Daynette S.P. Morikawa Morikawa, Daynette S.P. 16 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8799.pdf http://files.hawaii.gov/ethics/disc/2016/FinShort_11303.pdf 01/29/2016;07/07/2016
Lorraine Rodero Inouye Inouye, Lorraine Rodero 4 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8800.pdf 01/29/2016
Scott Y. Nishimoto Nishimoto, Scott Y. 21 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8831.pdf 01/29/2016
Rosalyn H. Baker Baker, Rosalyn H. 6 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8863.pdf 01/29/2016
Jarrett K. Keohokalole Keohokalole, Jarrett K. 48 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8868.pdf 01/30/2016
Mark Jun Hashem Hashem, Mark Jun 18 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8871.pdf 01/30/2016
Scott K. Saiki Saiki, Scott K. 26 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8877.pdf 01/31/2016
Breene Y. Harimoto Harimoto, Breene Y. 16 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8878.pdf 01/31/2016
Gregg T. Takayama Takayama, Gregg T. 34 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8879.pdf 01/31/2016
Isaac William Choy Choy, Isaac William 23 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8882.pdf 01/31/2016
Marcus R. Oshiro Oshiro, Marcus R. 46 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8884.pdf 01/31/2016
Les S. Ihara Ihara, Les S. 10 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8885.pdf 01/31/2016
Gilbert R. Riviere Riviere, Gilbert R. 23 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8886.pdf 01/31/2016
Sharon E. Har Har, Sharon E. 42 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8890.pdf 02/01/2016
Mark M. Nakashima Nakashima, Mark M. 1 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8895.pdf 02/01/2016
Della Au Belatti Belatti, Della Au 24 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8887.pdf http://files.hawaii.gov/ethics/disc/2016/FinShort_8896.pdf 02/01/2016;02/01/2016
Brickwood M. Galuteria Galuteria, Brickwood M. 12 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11208.pdf 01/30/2016
Joseph Mark Souki Souki, Joseph Mark 8 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8914.pdf 02/01/2016
Thomas M. Brower Brower, Thomas M. 22 House 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11218.pdf 02/01/2016
Aaron L. Johanson Johanson, Aaron L. 31 House 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11243.pdf 02/01/2016
Richard H.K. Onishi Onishi, Richard H.K. 3 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8920.pdf 02/01/2016
Andria P. Tupola Tupola, Andria P. 43 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8926.pdf 02/01/2016
Nicole E. Lowen Lowen, Nicole E. 6 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8927.pdf 02/01/2016
Michelle N. Kidani Kidani, Michelle N. 18 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8932.pdf 02/01/2016
Ronald D. Kouchi Kouchi, Ronald D. 8 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8938.pdf 02/01/2016
Ty J.K. Cullen Cullen, Ty J.K. 39 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8940.pdf 02/01/2016
Mark Kaniela Ing Ing, Mark Kaniela 11 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8941.pdf 02/01/2016
Glenn Satoru Wakai Wakai, Glenn Satoru 15 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8944.pdf;http://files.hawaii.gov/ethics/disc/2016/FinShort_11426.pdf 02/01/2016;08/01/2016
Lauren K. Matsumoto Matsumoto, Lauren K. 45 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8945.pdf http://files.hawaii.gov/ethics/disc/2016/FinShort_8961.pdf 02/01/2016;02/03/2016
Beth Keiko Fukumoto Chang Fukumoto Chang, Beth Keiko 36 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8946.pdf 02/01/2016
Robert C. McDermott McDermott, Robert C. 40 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8950.pdf http://files.hawaii.gov/ethics/disc/2016/FinShort_11680.pdf;http://files.hawaii.gov/ethics/disc/2016/FinShort_11681.pdf 02/01/2016;10/07/2016;10/07/2016
Christopher Kalani Cushman Lee Lee, Christopher Kalani Cushman 51 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8951.pdf 02/01/2016
Kaialii Kahele Kahele, Kaialii 1 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11734.pdf;http://files.hawaii.gov/ethics/disc/2016/FinShort_11350.pdf 03/31/2016;07/20/2016
Ryan Ichiro Yamane Yamane, Ryan Ichiro 37 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8861.pdf 01/29/2016

2.2 OHA + Governor + Lt. Governor

We need to do the same as 2.1 for obtaining the formatted information from OHA + Governor and Lt. Governor in a different table.

ethics.officials <- fread("data/Hawaii_State_Ethics_Commission_s_2016_State_Officials_Financial_Disclosure.csv")
ethics.officials <- ethics.officials[`Dept/Board` == "Office of Hawaiian Affairs" | Title == "Governor" | Title == "Lieutenant Governor"]
kable(ethics.officials)
Filer View Title Dept/Board File Type File Year Date Filed Original Amended
Crabbe, Kamana’opono Matthew Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_9559.pdf) Department Head, Chief Executive Officer Office of Hawaiian Affairs Financial 2016 04/28/2016 true false
Machado, Colette Y.P. Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_9991.pdf) Trustee Office of Hawaiian Affairs Financial 2016 05/18/2016 true false
Lindsey, Robert K. Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_10018.pdf) Trustee Office of Hawaiian Affairs Financial 2016 05/18/2016 true false
Akana, Rowena M.N. Form (http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11978.pdf) Trustee Office of Hawaiian Affairs Financial 2016 05/23/2016 true false
Ahuna, Daniel Chester Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_10374.pdf) Trustee Office of Hawaiian Affairs Financial 2016 05/23/2016 true false
Tsutsui, Shan S. Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_10467.pdf) Lieutenant Governor Office of the Lieutenant Governor Financial 2016 05/25/2016 true false
Ige, David Y. Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_10781.pdf) Governor Office of the Governor Financial 2016 05/31/2016 true false
Lindsey, Carmen Kahulumealani Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_11024.pdf) Trustee Office of Hawaiian Affairs Financial 2016 05/31/2016 true false
Waihe’e, IV, John David Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_11026.pdf) Trustee Office of Hawaiian Affairs Financial 2016 05/31/2016 true false
Apo, Peter Kamamo Form (http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-12245.pdf) Trustee Office of Hawaiian Affairs Financial 2016 06/07/2016 true false
Ahu Isa, Leinaala S.P. Form (http://files.hawaii.gov/ethics/disc/2016/FinLong_11514.pdf) Trustee Office of Hawaiian Affairs Financial 2016 09/18/2016 true false

Removing Repeated Names

ethics.officials$View <- format_url(ethics.officials$View)
ethics.officials <- ethics.officials[,links_pdfs(View,Amended,`Date Filed`),by=c("Filer","Title","Dept/Board","File Year")]

Separate First and Last Name

ethics.officials <- cbind(get_first_last_name(ethics.officials$Filer),ethics.officials)
colnames(ethics.officials)[3] <- "ethics_full_name" 
kable(ethics.officials)
ethics_first_name ethics_last_name ethics_full_name Title Dept/Board File Year original_url ammend_url dates
Kamana’opono Matthew Crabbe Crabbe, Kamana’opono Matthew Department Head, Chief Executive Officer Office of Hawaiian Affairs 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_9559.pdf 04/28/2016
Colette Y.P. Machado Machado, Colette Y.P. Trustee Office of Hawaiian Affairs 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_9991.pdf 05/18/2016
Robert K. Lindsey Lindsey, Robert K. Trustee Office of Hawaiian Affairs 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_10018.pdf 05/18/2016
Rowena M.N. Akana Akana, Rowena M.N. Trustee Office of Hawaiian Affairs 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11978.pdf 05/23/2016
Daniel Chester Ahuna Ahuna, Daniel Chester Trustee Office of Hawaiian Affairs 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_10374.pdf 05/23/2016
Shan S. Tsutsui Tsutsui, Shan S. Lieutenant Governor Office of the Lieutenant Governor 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_10467.pdf 05/25/2016
David Y. Ige Ige, David Y. Governor Office of the Governor 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_10781.pdf 05/31/2016
Carmen Kahulumealani Lindsey Lindsey, Carmen Kahulumealani Trustee Office of Hawaiian Affairs 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_11024.pdf 05/31/2016
IV Waihe’e Waihe’e, IV, John David Trustee Office of Hawaiian Affairs 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_11026.pdf 05/31/2016
Peter Kamamo Apo Apo, Peter Kamamo Trustee Office of Hawaiian Affairs 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-12245.pdf 06/07/2016
Leinaala S.P. Ahu Isa Ahu Isa, Leinaala S.P. Trustee Office of Hawaiian Affairs 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_11514.pdf 09/18/2016

Parse Dept/Board

ethics.officials <- ethics.officials[`Dept/Board`=="Office of Hawaiian Affairs",`Dept/Board`:="OHA"]
ethics.officials <- ethics.officials[`Dept/Board`=="Office of the Lieutenant Governor",`Dept/Board`:="Lt. Governor"]
ethics.officials <- ethics.officials[`Dept/Board`=="Office of the Governor",`Dept/Board`:="Governor"]
kable(ethics.officials)
ethics_first_name ethics_last_name ethics_full_name Title Dept/Board File Year original_url ammend_url dates
Kamana’opono Matthew Crabbe Crabbe, Kamana’opono Matthew Department Head, Chief Executive Officer OHA 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_9559.pdf 04/28/2016
Colette Y.P. Machado Machado, Colette Y.P. Trustee OHA 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_9991.pdf 05/18/2016
Robert K. Lindsey Lindsey, Robert K. Trustee OHA 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_10018.pdf 05/18/2016
Rowena M.N. Akana Akana, Rowena M.N. Trustee OHA 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11978.pdf 05/23/2016
Daniel Chester Ahuna Ahuna, Daniel Chester Trustee OHA 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_10374.pdf 05/23/2016
Shan S. Tsutsui Tsutsui, Shan S. Lieutenant Governor Lt. Governor 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_10467.pdf 05/25/2016
David Y. Ige Ige, David Y. Governor Governor 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_10781.pdf 05/31/2016
Carmen Kahulumealani Lindsey Lindsey, Carmen Kahulumealani Trustee OHA 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_11024.pdf 05/31/2016
IV Waihe’e Waihe’e, IV, John David Trustee OHA 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_11026.pdf 05/31/2016
Peter Kamamo Apo Apo, Peter Kamamo Trustee OHA 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-12245.pdf 06/07/2016
Leinaala S.P. Ahu Isa Ahu Isa, Leinaala S.P. Trustee OHA 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_11514.pdf 09/18/2016

Parse District

ethics.officials$Title <- ""
colnames(ethics.officials)[4] <- "district"
kable(ethics.officials)
ethics_first_name ethics_last_name ethics_full_name district Dept/Board File Year original_url ammend_url dates
Kamana’opono Matthew Crabbe Crabbe, Kamana’opono Matthew OHA 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_9559.pdf 04/28/2016
Colette Y.P. Machado Machado, Colette Y.P. OHA 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_9991.pdf 05/18/2016
Robert K. Lindsey Lindsey, Robert K. OHA 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_10018.pdf 05/18/2016
Rowena M.N. Akana Akana, Rowena M.N. OHA 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11978.pdf 05/23/2016
Daniel Chester Ahuna Ahuna, Daniel Chester OHA 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_10374.pdf 05/23/2016
Shan S. Tsutsui Tsutsui, Shan S. Lt. Governor 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_10467.pdf 05/25/2016
David Y. Ige Ige, David Y. Governor 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_10781.pdf 05/31/2016
Carmen Kahulumealani Lindsey Lindsey, Carmen Kahulumealani OHA 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_11024.pdf 05/31/2016
IV Waihe’e Waihe’e, IV, John David OHA 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_11026.pdf 05/31/2016
Peter Kamamo Apo Apo, Peter Kamamo OHA 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-12245.pdf 06/07/2016
Leinaala S.P. Ahu Isa Ahu Isa, Leinaala S.P. OHA 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_11514.pdf 09/18/2016

2.3 Winners Table

winners <- rbind(ethics.legislator,ethics.officials)
kable(winners)
ethics_first_name ethics_last_name ethics_full_name district Dept/Board File Year original_url ammend_url dates
Russell E. Ruderman Ruderman, Russell E. 2 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8458.pdf 01/03/2016
John Musashi Mizuno Mizuno, John Musashi 28 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8483.pdf 01/06/2016
Clarence K. Nishihara Nishihara, Clarence K. 17 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8484.pdf 01/06/2016
Henry James C. Aquino Aquino, Henry James C. 38 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8501.pdf 01/07/2016
Samuel Satoru Kong Kong, Samuel Satoru 33 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8517.pdf 01/07/2016
Cynthia Frances Wood Evans Evans, Cynthia Frances Wood 7 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8521.pdf 01/10/2016
Angus L.K. McKelvey McKelvey, Angus L.K. 10 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8525.pdf 01/11/2016
James K. Tokioka Tokioka, James K. 15 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8526.pdf 01/11/2016
Laura H. Thielen Thielen, Laura H. 25 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8580.pdf http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11196.pdf 01/14/2016;01/29/2016
Takashi Ohno Ohno, Takashi 27 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8601.pdf 01/19/2016
Maile S.L. Shimabukuro Shimabukuro, Maile S.L. 21 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8603.pdf 01/19/2016
Cynthia H. Thielen Thielen, Cynthia H. 50 House 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-10973.pdf 01/06/2016
Joshua B. Green Green, Joshua B. 3 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-10975.pdf http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11474.pdf 01/11/2016;03/09/2016
Brian T. Taniguchi Taniguchi, Brian T. 11 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8642.pdf 01/23/2016
Bertrand Y. Kobayashi Kobayashi, Bertrand Y. 19 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8645.pdf 01/24/2016
Gene R. Ward Ward, Gene R. 17 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8646.pdf 01/24/2016
Gerald Michael Gabbard Gabbard, Gerald Michael 20 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8651.pdf 01/25/2016
Calvin K.Y. Say Say, Calvin K.Y. 20 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8659.pdf 01/25/2016
Kyle T. Yamashita Yamashita, Kyle T. 12 House 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11062.pdf 01/25/2016
Donna Mercado Kim Kim, Donna Mercado 14 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11081.pdf 01/27/2016
Donovan Michael Dela Cruz Dela Cruz, Donovan Michael 22 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8696.pdf 01/26/2016
Sylvia J. Luke Luke, Sylvia J. 25 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8708.pdf 01/27/2016
Linda Eileen Ichiyama Ichiyama, Linda Eileen 32 House 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11111.pdf 01/27/2016
Gilbert S.C. Keith-Agaran Keith-Agaran, Gilbert S.C. 5 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11112.pdf 01/27/2016
Justin H. Woodson Woodson, Justin H. 9 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8749.pdf 01/27/2016
Matthew S. LoPresti LoPresti, Matthew S. 41 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8746.pdf 01/27/2016
Romeo M. Cachola Cachola, Romeo M. 30 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8738.pdf 01/27/2016
Lynn P. DeCoite DeCoite, Lynn P. 13 House 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11126.pdf 01/28/2016
Roy M. Takumi Takumi, Roy M. 35 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8767.pdf 01/28/2016
Kenneth T. Ito Ito, Kenneth T. 49 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8761.pdf 01/28/2016
J. Kalani English English, J. Kalani 7 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11198.pdf 01/29/2016
Jill Naomi Tokuda Tokuda, Jill Naomi 24 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11199.pdf 01/29/2016
William Calip Espero Espero, William Calip 19 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8784.pdf 01/28/2016
Richard P. Creagan Creagan, Richard P. 5 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8786.pdf http://files.hawaii.gov/ethics/disc/2016/FinShort_8933.pdf 01/28/2016;02/01/2016
Joy A. San Buenaventura San Buenaventura, Joy A. 4 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8787.pdf 01/28/2016
Daynette S.P. Morikawa Morikawa, Daynette S.P. 16 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8799.pdf http://files.hawaii.gov/ethics/disc/2016/FinShort_11303.pdf 01/29/2016;07/07/2016
Lorraine Rodero Inouye Inouye, Lorraine Rodero 4 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8800.pdf 01/29/2016
Scott Y. Nishimoto Nishimoto, Scott Y. 21 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8831.pdf 01/29/2016
Rosalyn H. Baker Baker, Rosalyn H. 6 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8863.pdf 01/29/2016
Jarrett K. Keohokalole Keohokalole, Jarrett K. 48 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8868.pdf 01/30/2016
Mark Jun Hashem Hashem, Mark Jun 18 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8871.pdf 01/30/2016
Scott K. Saiki Saiki, Scott K. 26 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8877.pdf 01/31/2016
Breene Y. Harimoto Harimoto, Breene Y. 16 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8878.pdf 01/31/2016
Gregg T. Takayama Takayama, Gregg T. 34 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8879.pdf 01/31/2016
Isaac William Choy Choy, Isaac William 23 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8882.pdf 01/31/2016
Marcus R. Oshiro Oshiro, Marcus R. 46 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8884.pdf 01/31/2016
Les S. Ihara Ihara, Les S. 10 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8885.pdf 01/31/2016
Gilbert R. Riviere Riviere, Gilbert R. 23 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8886.pdf 01/31/2016
Sharon E. Har Har, Sharon E. 42 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8890.pdf 02/01/2016
Mark M. Nakashima Nakashima, Mark M. 1 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8895.pdf 02/01/2016
Della Au Belatti Belatti, Della Au 24 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8887.pdf http://files.hawaii.gov/ethics/disc/2016/FinShort_8896.pdf 02/01/2016;02/01/2016
Brickwood M. Galuteria Galuteria, Brickwood M. 12 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11208.pdf 01/30/2016
Joseph Mark Souki Souki, Joseph Mark 8 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8914.pdf 02/01/2016
Thomas M. Brower Brower, Thomas M. 22 House 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11218.pdf 02/01/2016
Aaron L. Johanson Johanson, Aaron L. 31 House 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11243.pdf 02/01/2016
Richard H.K. Onishi Onishi, Richard H.K. 3 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8920.pdf 02/01/2016
Andria P. Tupola Tupola, Andria P. 43 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8926.pdf 02/01/2016
Nicole E. Lowen Lowen, Nicole E. 6 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8927.pdf 02/01/2016
Michelle N. Kidani Kidani, Michelle N. 18 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8932.pdf 02/01/2016
Ronald D. Kouchi Kouchi, Ronald D. 8 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8938.pdf 02/01/2016
Ty J.K. Cullen Cullen, Ty J.K. 39 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8940.pdf 02/01/2016
Mark Kaniela Ing Ing, Mark Kaniela 11 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8941.pdf 02/01/2016
Glenn Satoru Wakai Wakai, Glenn Satoru 15 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8944.pdf;http://files.hawaii.gov/ethics/disc/2016/FinShort_11426.pdf 02/01/2016;08/01/2016
Lauren K. Matsumoto Matsumoto, Lauren K. 45 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8945.pdf http://files.hawaii.gov/ethics/disc/2016/FinShort_8961.pdf 02/01/2016;02/03/2016
Beth Keiko Fukumoto Chang Fukumoto Chang, Beth Keiko 36 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8946.pdf 02/01/2016
Robert C. McDermott McDermott, Robert C. 40 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8950.pdf http://files.hawaii.gov/ethics/disc/2016/FinShort_11680.pdf;http://files.hawaii.gov/ethics/disc/2016/FinShort_11681.pdf 02/01/2016;10/07/2016;10/07/2016
Christopher Kalani Cushman Lee Lee, Christopher Kalani Cushman 51 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8951.pdf 02/01/2016
Kaialii Kahele Kahele, Kaialii 1 Senate 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11734.pdf;http://files.hawaii.gov/ethics/disc/2016/FinShort_11350.pdf 03/31/2016;07/20/2016
Ryan Ichiro Yamane Yamane, Ryan Ichiro 37 House 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_8861.pdf 01/29/2016
Kamana’opono Matthew Crabbe Crabbe, Kamana’opono Matthew OHA 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_9559.pdf 04/28/2016
Colette Y.P. Machado Machado, Colette Y.P. OHA 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_9991.pdf 05/18/2016
Robert K. Lindsey Lindsey, Robert K. OHA 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_10018.pdf 05/18/2016
Rowena M.N. Akana Akana, Rowena M.N. OHA 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11978.pdf 05/23/2016
Daniel Chester Ahuna Ahuna, Daniel Chester OHA 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_10374.pdf 05/23/2016
Shan S. Tsutsui Tsutsui, Shan S. Lt. Governor 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_10467.pdf 05/25/2016
David Y. Ige Ige, David Y. Governor 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_10781.pdf 05/31/2016
Carmen Kahulumealani Lindsey Lindsey, Carmen Kahulumealani OHA 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_11024.pdf 05/31/2016
IV Waihe’e Waihe’e, IV, John David OHA 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_11026.pdf 05/31/2016
Peter Kamamo Apo Apo, Peter Kamamo OHA 2016 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-12245.pdf 06/07/2016
Leinaala S.P. Ahu Isa Ahu Isa, Leinaala S.P. OHA 2016 http://files.hawaii.gov/ethics/disc/2016/FinLong_11514.pdf 09/18/2016

2. Collect 2014-2016 Losers Names + Extra Info

TO-DO

3. Define Candidates Table

TO-DO

4. Collect Contributions Website Names + Total

This table is much larger and complex than the previous discussed ones. It has been discussed and normalized in the introduction notebook, the created model is reproduced here for clarity: