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:

The best presentation of this table is likely showing a “profile” of total amount received in a given election, and an extra table with the detailed contributions a candidate received. At this point in time, I will focus on the total amount received, as it reduces the size of table considerably and reduces each row to contain only one candidate name per row (which is important for the linkage of both websites tables). After the linkage, retrieving the detailed transactions of any one candidate is trivial and will be demonstrated later.

Filter Election Year and Dept/Boards

Since we are only interested at state-wide positions as the Hawaii State Ethics Comission only contains state-level positions, we remove candidates that are not state-level at this point. For now, I also only analyze 2014-2016, but other election periods will be added later:

campaign.contributions <- fread("data/Campaign_Contributions_Received_By_Hawaii_State_and_County_Candidates_From_November_8__2006_Through_November_8__2016.csv")

campaign.contributions <- campaign.contributions[`Election Period`=='2014-2016' & (Office == "House" | Office == "Governor" | Office == "Senate" | Office == "OHA" | Office == "Lt. Governor")]

Format Amount

In order to calculate the total amount received, we need to first format the amount of each individual contribution since it doesn’t only include digits.

#Formatting functions to help with text formatted amounts. 
dollar_to_numeric <- function(dollar_value){
  return (as.numeric(gsub("\\$", "",dollar_value)))
}
numeric_to_dollar <- function(x, ...) {
  return( paste0("$", formatC(as.numeric(x), format="f", digits=2, big.mark=",")))
}

campaign.contributions <- campaign.contributions[,.(Amount=sum(dollar_to_numeric(Amount))),by=c("Candidate Name","Office","District","Party")]
kable(campaign.contributions)
Candidate Name Office District Party Amount
Holt, Daniel House 29 Democrat 35989.74
Hood, Joan House 50 Republican 8660.00
Wakai, Glenn Senate 15 Democrat 67079.52
Ichiyama, Linda House 32 Democrat 27050.00
Hussey, Ikaika House 28 Democrat 7300.00
Ige, David Governor Democrat 175288.74
Agustin, Jaci House 34 Republican 20325.00
Ihara, Les Senate 10 Democrat 12903.00
Ing, Mark House 11 Democrat 47457.24
Ilagan, Greggor Senate 2 Democrat 44172.92
Inouye, Lorraine Senate 4 Democrat 55950.00
Ito, Ken House 49 Democrat 30225.00
Johanson, Aaron House 31 Democrat 46095.00
Jeremiah, Bryan House 41 Republican 12804.33
Iwamoto, Kim Coco Senate 13 Democrat 46945.22
Jordan, Jo House 44 Democrat 26210.00
Kahele, Kaialii Senate 1 Democrat 151559.00
Kahele, Gilbert Senate 1 Democrat 23144.22
Ahuna, Kanoe Senate 8 Democrat 8037.39
Ahu, Elwin Lt. Governor Republican 450.00
Kapoi, Cranston House 8 Republican 500.00
Keith-Agaran, Gilbert Senate 5 Democrat 104978.87
Keohokalole, Jarrett House 48 Democrat 29245.00
Kidani, Michelle Senate 18 Democrat 102494.62
Kim, Donna Senate 14 Democrat 125850.00
Kimball, Heather House 1 Democrat 7014.52
Tupola, Andria House 43 Republican 43286.00
Kobayashi, Dale House 23 Democrat 63005.19
Aki, Zurishaddai House 36 Democrat 7140.01
Akina, William OHA At-Large Non-Partisan 81222.59
Allen, Julia House 20 Republican 4487.00
Kouchi, Ron Senate 8 Democrat 211201.77
Kobayashi, Bertrand House 19 Democrat 11600.00
Apo, Peter OHA Oahu Democrat 442.36
Apoliona, Haunani OHA At-Large Non-Partisan 27400.00
Aquino, Henry House 38 Democrat 44385.00
Ku, Tercia Senate 21 Republican 111.00
Arakaki, Tracy House 33 Democrat 8944.00
Lam, Ronald House 25 Republican 145.00
Lawrence, Tiare House 12 Democrat 20484.92
Ward, Gene House 17 Republican 36851.00
Lee, Christopher House 51 Democrat 45095.84
Lee, Marilyn House 36 Democrat 14400.00
Lindsey, Robert OHA Hawaii Non-Partisan 104096.46
Lowen, Nicole House 6 Democrat 37831.00
LoPresti, Matthew House 41 Democrat 36308.00
Logue, James House 29 Democrat 3692.90
Luke, Sylvia House 25 Democrat 206932.03
Awana, Karen House 43 Democrat 3700.00
Baker, Rosalyn Senate 6 Democrat 71534.07
Manipol-Larson, Grace House 2 Non-Partisan 825.00
Belatti, Della House 24 Democrat 47265.00
Marshall, Eric House 26 Republican 716.33
Martinez, Rosebella House 40 Democrat 4540.00
Brower, Tom House 22 Democrat 31050.00
McDermott, Bob House 40 Republican 42535.97
Matsumoto, Lauren House 45 Republican 28270.00
Cachola, Romy House 30 Democrat 15125.00
McKelvey, Angus House 10 Democrat 46542.34
Mizuno, John House 28 Democrat 40395.00
Nagamine, Robert Senate 25 Republican 8990.95
Morikawa, Daynette House 16 Democrat 27050.00
Nakashima, Mark House 1 Democrat 55433.51
Nakamura, Nadine House 14 Democrat 38802.41
Nakoa, Keone Senate 13 Democrat 46908.48
Nishihara, Clarence Senate 17 Democrat 12800.00
Naniole, Alexander House 3 Democrat 25750.00
Nishimoto, Scott House 21 Democrat 41864.11
Nikhilananda, Nick House 13 Green 950.00
Ohno, Takashi House 27 Democrat 30499.82
Oi, Thomas House 15 Democrat 6700.00
Onishi, Richard House 3 Democrat 29444.01
Onishi, Dennis Senate 1 Democrat 9462.45
Oshiro, Marcus House 46 Democrat 22050.00
Pekus, Daniel House 11 Republican 1635.00
Paaluhi, Marcus House 44 Republican 14866.00
Ozols, Harry Senate 13 Libertarian 220.83
Campagna, Carl Senate 14 Democrat 5213.37
Phillips, Arnold Senate 10 Libertarian 12982.63
Perez-Garreaud, Nicola House 22 Democrat 500.00
Pisciotta, Kealoha House 3 Green 3590.00
Pohle, Richard House 12 Republican 200.00
Pouha, Feki House 47 Republican 16510.00
Pratt, Bruce House 6 Republican 1300.00
Quinlan, Sean House 47 Democrat 35060.31
Rebolledo, Gilbert House 8 Republican 430.00
Rhoads, Karl Senate 13 Democrat 125937.62
Robinson, Kaloa Senate 1 Democrat 11520.09
Riviere, Gil Senate 23 Democrat 5095.00
Rosenstiel, Fern House 14 Democrat 8488.95
Ross, Karlen House 17 Democrat 6098.00
Ruderman, Russell Senate 2 Democrat 25044.20
Saiki, Scott House 26 Democrat 80859.15
Chang, Stanley Senate 9 Democrat 135747.22
Ching, Eric House 31 Republican 9968.80
San Buenaventura, Joy House 4 Democrat 19550.00
Say, Calvin House 20 Democrat 66300.00
Choy, Isaac House 23 Democrat 46350.00
Chun Oakland, Suzanne Senate 13 Democrat 650.00
Coakley, Jeffrey House 7 Republican 2350.00
Coakley, Kaiwiola House 29 Republican 4500.00
Shea, Patrick House 49 Democrat 24397.57
Shimabukuro, Maile Senate 21 Democrat 10645.00
Creagan, Richard House 5 Democrat 16050.00
Crum, Douglas OHA At-Large Independent 571.42
Cullen, Ty House 39 Democrat 50705.00
Dayao, Firmo House 29 Democrat 4225.00
DeCoite, Lynn House 13 Democrat 78019.13
Sequin, Tamiko House 44 Republican 4270.00
Dela Cruz, Donovan Senate 22 Democrat 143883.56
Slom, Sam Senate 9 Republican 25771.90
Souki, Joseph House 8 Democrat 118878.00
Dionne, Valerie House 29 Democrat 2300.00
Eli, Stacelynn House 43 Democrat 31052.38
Stump, Christopher House 17 Democrat 534.67
English, Kalani Senate 7 Democrat 75580.41
Espero, William Senate 19 Democrat 49045.00
Takayama, Gregg House 34 Democrat 26925.00
Evans, Cindy House 7 Democrat 31220.00
Fale, Richard Senate 23 Republican 250.00
Takumi, Roy House 35 Democrat 15395.00
Farrell, David Senate 10 Democrat 720.15
Tam, Rodney Senate 13 Republican 4989.15
Fidelibus, Christopher Senate 19 Republican 5150.00
Taniguchi, Brian Senate 11 Democrat 45155.00
Franks, Victoria House 16 Republican 3139.31
Fukumoto, Beth House 36 Republican 37224.50
Tarnas, David House 7 Democrat 37888.17
Tegarden, Deidre House 11 Democrat 88809.88
Gabbard, Mike Senate 20 Democrat 38356.20
Galuteria, Brickwood Senate 12 Democrat 14101.01
Thielen, Cynthia House 50 Republican 33782.00
Gates, Cedric House 44 Democrat 33499.69
Giugni, Heather House 33 Democrat 2000.00
Thielen, Laura Senate 25 Democrat 25960.50
Gonce, Randy House 40 Democrat 7972.00
Tokioka, James House 15 Democrat 46150.00
Tokuda, Jill Senate 24 Democrat 48003.75
Grace, Janet House 22 Republican 3825.00
Green, Josh Senate 3 Democrat 82300.00
Tippens, Michelle House 24 Libertarian 5900.00
Trask, Mililani OHA Hawaii Non-Partisan 30245.00
Tsuji, Clifton House 2 Democrat 39901.97
Tsutsui, Shan Lt. Governor Democrat 136002.50
Haller, Alexander House 13 Democrat 8614.95
Wong, Jonathan House 2 Democrat 16960.00
Woodson, Justin House 9 Democrat 33400.00
Yamane, Ryan House 37 Democrat 46175.00
Yamashita, Kyle House 12 Democrat 32825.00
Har, Sharon House 42 Democrat 27600.00
Young, Byron House 1 Republican 994.00
Harimoto, Breene Senate 16 Democrat 6595.00
Hashem, Mark House 18 Democrat 27080.00
Henski, Kathryn House 22 Republican 5926.05
Higa, Anthony House 19 Libertarian 6600.00
Kossow, Bronsten-Glenn House 6 Democrat 1203.49
Kupukaa, Katherine House 37 Republican 1930.97
Machado, Colette OHA Molokai Non-Partisan 1500.00
Mataafa, Toagaifasa House 47 Republican 1300.00
Rodriguez, Cody House 24 Democrat 180.00
Saunders, Rex House 23 Democrat 7283.87
Svrcina, Emil House 37 Republican 545.50
Trask, Mililani OHA At-Large Democrat 11895.66
Wendt, Mahealani OHA Maui Non-Partisan 500.00
Abercrombie, Neil Governor Democrat 7542.74
Aiona, James Governor Republican 1000.00
Amato, Terez Senate 6 Democrat 500.00
Bischoff, Stephen House 19 Republican 200.00
Combs, Sandra House 14 Republican 28450.00
Fevella, Kurt Senate 19 Republican 2200.00
Ferguson, Nicole House 42 Democrat 230.00
Fenton, Larry House 24 Republican 756.01
Golojuch, Michael House 42 Democrat 200.00
Hannemann, Mufi Governor Independent 1200.00
Velasco, Marcelino House 30 Democrat 250.00

Separate First and Last Name

campaign.contributions <- cbind(get_first_last_name(campaign.contributions$`Candidate Name`),campaign.contributions)
colnames(campaign.contributions)[c(1,2,3,4,5)] <- c("contribution_first_name","contribution_last_name","contribution_full_name","Dept/Board","district") #TODO: Fix function first_last name assignment to be more generic.
kable(campaign.contributions)
contribution_first_name contribution_last_name contribution_full_name Dept/Board district Party Amount
Daniel Holt Holt, Daniel House 29 Democrat 35989.74
Joan Hood Hood, Joan House 50 Republican 8660.00
Glenn Wakai Wakai, Glenn Senate 15 Democrat 67079.52
Linda Ichiyama Ichiyama, Linda House 32 Democrat 27050.00
Ikaika Hussey Hussey, Ikaika House 28 Democrat 7300.00
David Ige Ige, David Governor Democrat 175288.74
Jaci Agustin Agustin, Jaci House 34 Republican 20325.00
Les Ihara Ihara, Les Senate 10 Democrat 12903.00
Mark Ing Ing, Mark House 11 Democrat 47457.24
Greggor Ilagan Ilagan, Greggor Senate 2 Democrat 44172.92
Lorraine Inouye Inouye, Lorraine Senate 4 Democrat 55950.00
Ken Ito Ito, Ken House 49 Democrat 30225.00
Aaron Johanson Johanson, Aaron House 31 Democrat 46095.00
Bryan Jeremiah Jeremiah, Bryan House 41 Republican 12804.33
Kim Coco Iwamoto Iwamoto, Kim Coco Senate 13 Democrat 46945.22
Jo Jordan Jordan, Jo House 44 Democrat 26210.00
Kaialii Kahele Kahele, Kaialii Senate 1 Democrat 151559.00
Gilbert Kahele Kahele, Gilbert Senate 1 Democrat 23144.22
Kanoe Ahuna Ahuna, Kanoe Senate 8 Democrat 8037.39
Elwin Ahu Ahu, Elwin Lt. Governor Republican 450.00
Cranston Kapoi Kapoi, Cranston House 8 Republican 500.00
Gilbert Keith-Agaran Keith-Agaran, Gilbert Senate 5 Democrat 104978.87
Jarrett Keohokalole Keohokalole, Jarrett House 48 Democrat 29245.00
Michelle Kidani Kidani, Michelle Senate 18 Democrat 102494.62
Donna Kim Kim, Donna Senate 14 Democrat 125850.00
Heather Kimball Kimball, Heather House 1 Democrat 7014.52
Andria Tupola Tupola, Andria House 43 Republican 43286.00
Dale Kobayashi Kobayashi, Dale House 23 Democrat 63005.19
Zurishaddai Aki Aki, Zurishaddai House 36 Democrat 7140.01
William Akina Akina, William OHA At-Large Non-Partisan 81222.59
Julia Allen Allen, Julia House 20 Republican 4487.00
Ron Kouchi Kouchi, Ron Senate 8 Democrat 211201.77
Bertrand Kobayashi Kobayashi, Bertrand House 19 Democrat 11600.00
Peter Apo Apo, Peter OHA Oahu Democrat 442.36
Haunani Apoliona Apoliona, Haunani OHA At-Large Non-Partisan 27400.00
Henry Aquino Aquino, Henry House 38 Democrat 44385.00
Tercia Ku Ku, Tercia Senate 21 Republican 111.00
Tracy Arakaki Arakaki, Tracy House 33 Democrat 8944.00
Ronald Lam Lam, Ronald House 25 Republican 145.00
Tiare Lawrence Lawrence, Tiare House 12 Democrat 20484.92
Gene Ward Ward, Gene House 17 Republican 36851.00
Christopher Lee Lee, Christopher House 51 Democrat 45095.84
Marilyn Lee Lee, Marilyn House 36 Democrat 14400.00
Robert Lindsey Lindsey, Robert OHA Hawaii Non-Partisan 104096.46
Nicole Lowen Lowen, Nicole House 6 Democrat 37831.00
Matthew LoPresti LoPresti, Matthew House 41 Democrat 36308.00
James Logue Logue, James House 29 Democrat 3692.90
Sylvia Luke Luke, Sylvia House 25 Democrat 206932.03
Karen Awana Awana, Karen House 43 Democrat 3700.00
Rosalyn Baker Baker, Rosalyn Senate 6 Democrat 71534.07
Grace Manipol-Larson Manipol-Larson, Grace House 2 Non-Partisan 825.00
Della Belatti Belatti, Della House 24 Democrat 47265.00
Eric Marshall Marshall, Eric House 26 Republican 716.33
Rosebella Martinez Martinez, Rosebella House 40 Democrat 4540.00
Tom Brower Brower, Tom House 22 Democrat 31050.00
Bob McDermott McDermott, Bob House 40 Republican 42535.97
Lauren Matsumoto Matsumoto, Lauren House 45 Republican 28270.00
Romy Cachola Cachola, Romy House 30 Democrat 15125.00
Angus McKelvey McKelvey, Angus House 10 Democrat 46542.34
John Mizuno Mizuno, John House 28 Democrat 40395.00
Robert Nagamine Nagamine, Robert Senate 25 Republican 8990.95
Daynette Morikawa Morikawa, Daynette House 16 Democrat 27050.00
Mark Nakashima Nakashima, Mark House 1 Democrat 55433.51
Nadine Nakamura Nakamura, Nadine House 14 Democrat 38802.41
Keone Nakoa Nakoa, Keone Senate 13 Democrat 46908.48
Clarence Nishihara Nishihara, Clarence Senate 17 Democrat 12800.00
Alexander Naniole Naniole, Alexander House 3 Democrat 25750.00
Scott Nishimoto Nishimoto, Scott House 21 Democrat 41864.11
Nick Nikhilananda Nikhilananda, Nick House 13 Green 950.00
Takashi Ohno Ohno, Takashi House 27 Democrat 30499.82
Thomas Oi Oi, Thomas House 15 Democrat 6700.00
Richard Onishi Onishi, Richard House 3 Democrat 29444.01
Dennis Onishi Onishi, Dennis Senate 1 Democrat 9462.45
Marcus Oshiro Oshiro, Marcus House 46 Democrat 22050.00
Daniel Pekus Pekus, Daniel House 11 Republican 1635.00
Marcus Paaluhi Paaluhi, Marcus House 44 Republican 14866.00
Harry Ozols Ozols, Harry Senate 13 Libertarian 220.83
Carl Campagna Campagna, Carl Senate 14 Democrat 5213.37
Arnold Phillips Phillips, Arnold Senate 10 Libertarian 12982.63
Nicola Perez-Garreaud Perez-Garreaud, Nicola House 22 Democrat 500.00
Kealoha Pisciotta Pisciotta, Kealoha House 3 Green 3590.00
Richard Pohle Pohle, Richard House 12 Republican 200.00
Feki Pouha Pouha, Feki House 47 Republican 16510.00
Bruce Pratt Pratt, Bruce House 6 Republican 1300.00
Sean Quinlan Quinlan, Sean House 47 Democrat 35060.31
Gilbert Rebolledo Rebolledo, Gilbert House 8 Republican 430.00
Karl Rhoads Rhoads, Karl Senate 13 Democrat 125937.62
Kaloa Robinson Robinson, Kaloa Senate 1 Democrat 11520.09
Gil Riviere Riviere, Gil Senate 23 Democrat 5095.00
Fern Rosenstiel Rosenstiel, Fern House 14 Democrat 8488.95
Karlen Ross Ross, Karlen House 17 Democrat 6098.00
Russell Ruderman Ruderman, Russell Senate 2 Democrat 25044.20
Scott Saiki Saiki, Scott House 26 Democrat 80859.15
Stanley Chang Chang, Stanley Senate 9 Democrat 135747.22
Eric Ching Ching, Eric House 31 Republican 9968.80
Joy San Buenaventura San Buenaventura, Joy House 4 Democrat 19550.00
Calvin Say Say, Calvin House 20 Democrat 66300.00
Isaac Choy Choy, Isaac House 23 Democrat 46350.00
Suzanne Chun Oakland Chun Oakland, Suzanne Senate 13 Democrat 650.00
Jeffrey Coakley Coakley, Jeffrey House 7 Republican 2350.00
Kaiwiola Coakley Coakley, Kaiwiola House 29 Republican 4500.00
Patrick Shea Shea, Patrick House 49 Democrat 24397.57
Maile Shimabukuro Shimabukuro, Maile Senate 21 Democrat 10645.00
Richard Creagan Creagan, Richard House 5 Democrat 16050.00
Douglas Crum Crum, Douglas OHA At-Large Independent 571.42
Ty Cullen Cullen, Ty House 39 Democrat 50705.00
Firmo Dayao Dayao, Firmo House 29 Democrat 4225.00
Lynn DeCoite DeCoite, Lynn House 13 Democrat 78019.13
Tamiko Sequin Sequin, Tamiko House 44 Republican 4270.00
Donovan Dela Cruz Dela Cruz, Donovan Senate 22 Democrat 143883.56
Sam Slom Slom, Sam Senate 9 Republican 25771.90
Joseph Souki Souki, Joseph House 8 Democrat 118878.00
Valerie Dionne Dionne, Valerie House 29 Democrat 2300.00
Stacelynn Eli Eli, Stacelynn House 43 Democrat 31052.38
Christopher Stump Stump, Christopher House 17 Democrat 534.67
Kalani English English, Kalani Senate 7 Democrat 75580.41
William Espero Espero, William Senate 19 Democrat 49045.00
Gregg Takayama Takayama, Gregg House 34 Democrat 26925.00
Cindy Evans Evans, Cindy House 7 Democrat 31220.00
Richard Fale Fale, Richard Senate 23 Republican 250.00
Roy Takumi Takumi, Roy House 35 Democrat 15395.00
David Farrell Farrell, David Senate 10 Democrat 720.15
Rodney Tam Tam, Rodney Senate 13 Republican 4989.15
Christopher Fidelibus Fidelibus, Christopher Senate 19 Republican 5150.00
Brian Taniguchi Taniguchi, Brian Senate 11 Democrat 45155.00
Victoria Franks Franks, Victoria House 16 Republican 3139.31
Beth Fukumoto Fukumoto, Beth House 36 Republican 37224.50
David Tarnas Tarnas, David House 7 Democrat 37888.17
Deidre Tegarden Tegarden, Deidre House 11 Democrat 88809.88
Mike Gabbard Gabbard, Mike Senate 20 Democrat 38356.20
Brickwood Galuteria Galuteria, Brickwood Senate 12 Democrat 14101.01
Cynthia Thielen Thielen, Cynthia House 50 Republican 33782.00
Cedric Gates Gates, Cedric House 44 Democrat 33499.69
Heather Giugni Giugni, Heather House 33 Democrat 2000.00
Laura Thielen Thielen, Laura Senate 25 Democrat 25960.50
Randy Gonce Gonce, Randy House 40 Democrat 7972.00
James Tokioka Tokioka, James House 15 Democrat 46150.00
Jill Tokuda Tokuda, Jill Senate 24 Democrat 48003.75
Janet Grace Grace, Janet House 22 Republican 3825.00
Josh Green Green, Josh Senate 3 Democrat 82300.00
Michelle Tippens Tippens, Michelle House 24 Libertarian 5900.00
Mililani Trask Trask, Mililani OHA Hawaii Non-Partisan 30245.00
Clifton Tsuji Tsuji, Clifton House 2 Democrat 39901.97
Shan Tsutsui Tsutsui, Shan Lt. Governor Democrat 136002.50
Alexander Haller Haller, Alexander House 13 Democrat 8614.95
Jonathan Wong Wong, Jonathan House 2 Democrat 16960.00
Justin Woodson Woodson, Justin House 9 Democrat 33400.00
Ryan Yamane Yamane, Ryan House 37 Democrat 46175.00
Kyle Yamashita Yamashita, Kyle House 12 Democrat 32825.00
Sharon Har Har, Sharon House 42 Democrat 27600.00
Byron Young Young, Byron House 1 Republican 994.00
Breene Harimoto Harimoto, Breene Senate 16 Democrat 6595.00
Mark Hashem Hashem, Mark House 18 Democrat 27080.00
Kathryn Henski Henski, Kathryn House 22 Republican 5926.05
Anthony Higa Higa, Anthony House 19 Libertarian 6600.00
Bronsten-Glenn Kossow Kossow, Bronsten-Glenn House 6 Democrat 1203.49
Katherine Kupukaa Kupukaa, Katherine House 37 Republican 1930.97
Colette Machado Machado, Colette OHA Molokai Non-Partisan 1500.00
Toagaifasa Mataafa Mataafa, Toagaifasa House 47 Republican 1300.00
Cody Rodriguez Rodriguez, Cody House 24 Democrat 180.00
Rex Saunders Saunders, Rex House 23 Democrat 7283.87
Emil Svrcina Svrcina, Emil House 37 Republican 545.50
Mililani Trask Trask, Mililani OHA At-Large Democrat 11895.66
Mahealani Wendt Wendt, Mahealani OHA Maui Non-Partisan 500.00
Neil Abercrombie Abercrombie, Neil Governor Democrat 7542.74
James Aiona Aiona, James Governor Republican 1000.00
Terez Amato Amato, Terez Senate 6 Democrat 500.00
Stephen Bischoff Bischoff, Stephen House 19 Republican 200.00
Sandra Combs Combs, Sandra House 14 Republican 28450.00
Kurt Fevella Fevella, Kurt Senate 19 Republican 2200.00
Nicole Ferguson Ferguson, Nicole House 42 Democrat 230.00
Larry Fenton Fenton, Larry House 24 Republican 756.01
Michael Golojuch Golojuch, Michael House 42 Democrat 200.00
Mufi Hannemann Hannemann, Mufi Governor Independent 1200.00
Marcelino Velasco Velasco, Marcelino House 30 Democrat 250.00

At this stage, we are ready to perform the cross-site linkage.

5. Ethics Website and Campaigns Website Linkage

5.1 Legislators Linkage

5.1.1 Exact Match

financial_ties.winners <- merge(winners[`Dept/Board` != "OHA" & `Dept/Board` != "Lt. Governor" & `Dept/Board` != "Governor"],campaign.contributions[`Dept/Board` != "OHA" & `Dept/Board` != "Lt. Governor" & `Dept/Board` != "Governor"],by.x = c("ethics_last_name","Dept/Board","district"),by.y=c("contribution_last_name","Dept/Board","district"),all.x=TRUE,all.y=TRUE)

#order columns for easier comparison

financial_ties.winners_header <- colnames(financial_ties.winners)
financial_ties.winners <- financial_ties.winners[,.(ethics_first_name,contribution_first_name,ethics_last_name,`Dept/Board`,district,Party,Amount,original_url,ammend_url,dates,`File Year`)]


kable(financial_ties.winners[order(as.integer(district),`Dept/Board`)])
ethics_first_name contribution_first_name ethics_last_name Dept/Board district Party Amount original_url ammend_url dates File Year
NA Heather Kimball House 1 Democrat 7014.52 NA NA NA NA
Mark M. Mark Nakashima House 1 Democrat 55433.51 http://files.hawaii.gov/ethics/disc/2016/FinLong_8895.pdf 02/01/2016 2016
NA Byron Young House 1 Republican 994.00 NA NA NA NA
Kaialii Kaialii Kahele Senate 1 Democrat 151559.00 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 2016
Kaialii Gilbert Kahele Senate 1 Democrat 23144.22 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 2016
NA Dennis Onishi Senate 1 Democrat 9462.45 NA NA NA NA
NA Kaloa Robinson Senate 1 Democrat 11520.09 NA NA NA NA
NA Grace Manipol-Larson House 2 Non-Partisan 825.00 NA NA NA NA
NA Clifton Tsuji House 2 Democrat 39901.97 NA NA NA NA
NA Jonathan Wong House 2 Democrat 16960.00 NA NA NA NA
NA Greggor Ilagan Senate 2 Democrat 44172.92 NA NA NA NA
Russell E. Russell Ruderman Senate 2 Democrat 25044.20 http://files.hawaii.gov/ethics/disc/2016/FinLong_8458.pdf 01/03/2016 2016
NA Alexander Naniole House 3 Democrat 25750.00 NA NA NA NA
Richard H.K. Richard Onishi House 3 Democrat 29444.01 http://files.hawaii.gov/ethics/disc/2016/FinLong_8920.pdf 02/01/2016 2016
NA Kealoha Pisciotta House 3 Green 3590.00 NA NA NA NA
Joshua B. Josh Green Senate 3 Democrat 82300.00 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 2016
Joy A. Joy San Buenaventura House 4 Democrat 19550.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8787.pdf 01/28/2016 2016
Lorraine Rodero Lorraine Inouye Senate 4 Democrat 55950.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8800.pdf 01/29/2016 2016
Richard P. Richard Creagan House 5 Democrat 16050.00 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 2016
Gilbert S.C. Gilbert Keith-Agaran Senate 5 Democrat 104978.87 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11112.pdf 01/27/2016 2016
NA Bronsten-Glenn Kossow House 6 Democrat 1203.49 NA NA NA NA
Nicole E. Nicole Lowen House 6 Democrat 37831.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8927.pdf 02/01/2016 2016
NA Bruce Pratt House 6 Republican 1300.00 NA NA NA NA
NA Terez Amato Senate 6 Democrat 500.00 NA NA NA NA
Rosalyn H. Rosalyn Baker Senate 6 Democrat 71534.07 http://files.hawaii.gov/ethics/disc/2016/FinLong_8863.pdf 01/29/2016 2016
NA Jeffrey Coakley House 7 Republican 2350.00 NA NA NA NA
Cynthia Frances Wood Cindy Evans House 7 Democrat 31220.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8521.pdf 01/10/2016 2016
NA David Tarnas House 7 Democrat 37888.17 NA NA NA NA
J. Kalani Kalani English Senate 7 Democrat 75580.41 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11198.pdf 01/29/2016 2016
NA Cranston Kapoi House 8 Republican 500.00 NA NA NA NA
NA Gilbert Rebolledo House 8 Republican 430.00 NA NA NA NA
Joseph Mark Joseph Souki House 8 Democrat 118878.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8914.pdf 02/01/2016 2016
NA Kanoe Ahuna Senate 8 Democrat 8037.39 NA NA NA NA
Ronald D. Ron Kouchi Senate 8 Democrat 211201.77 http://files.hawaii.gov/ethics/disc/2016/FinLong_8938.pdf 02/01/2016 2016
Justin H. Justin Woodson House 9 Democrat 33400.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8749.pdf 01/27/2016 2016
NA Stanley Chang Senate 9 Democrat 135747.22 NA NA NA NA
NA Sam Slom Senate 9 Republican 25771.90 NA NA NA NA
Angus L.K. Angus McKelvey House 10 Democrat 46542.34 http://files.hawaii.gov/ethics/disc/2016/FinLong_8525.pdf 01/11/2016 2016
NA David Farrell Senate 10 Democrat 720.15 NA NA NA NA
Les S. Les Ihara Senate 10 Democrat 12903.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8885.pdf 01/31/2016 2016
NA Arnold Phillips Senate 10 Libertarian 12982.63 NA NA NA NA
Mark Kaniela Mark Ing House 11 Democrat 47457.24 http://files.hawaii.gov/ethics/disc/2016/FinLong_8941.pdf 02/01/2016 2016
NA Daniel Pekus House 11 Republican 1635.00 NA NA NA NA
NA Deidre Tegarden House 11 Democrat 88809.88 NA NA NA NA
Brian T. Brian Taniguchi Senate 11 Democrat 45155.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8642.pdf 01/23/2016 2016
NA Tiare Lawrence House 12 Democrat 20484.92 NA NA NA NA
NA Richard Pohle House 12 Republican 200.00 NA NA NA NA
Kyle T. Kyle Yamashita House 12 Democrat 32825.00 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11062.pdf 01/25/2016 2016
Brickwood M. Brickwood Galuteria Senate 12 Democrat 14101.01 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11208.pdf 01/30/2016 2016
Lynn P. Lynn DeCoite House 13 Democrat 78019.13 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11126.pdf 01/28/2016 2016
NA Alexander Haller House 13 Democrat 8614.95 NA NA NA NA
NA Nick Nikhilananda House 13 Green 950.00 NA NA NA NA
NA Suzanne Chun Oakland Senate 13 Democrat 650.00 NA NA NA NA
NA Kim Coco Iwamoto Senate 13 Democrat 46945.22 NA NA NA NA
NA Keone Nakoa Senate 13 Democrat 46908.48 NA NA NA NA
NA Harry Ozols Senate 13 Libertarian 220.83 NA NA NA NA
NA Karl Rhoads Senate 13 Democrat 125937.62 NA NA NA NA
NA Rodney Tam Senate 13 Republican 4989.15 NA NA NA NA
NA Sandra Combs House 14 Republican 28450.00 NA NA NA NA
NA Nadine Nakamura House 14 Democrat 38802.41 NA NA NA NA
NA Fern Rosenstiel House 14 Democrat 8488.95 NA NA NA NA
NA Carl Campagna Senate 14 Democrat 5213.37 NA NA NA NA
Donna Mercado Donna Kim Senate 14 Democrat 125850.00 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11081.pdf 01/27/2016 2016
NA Thomas Oi House 15 Democrat 6700.00 NA NA NA NA
James K. James Tokioka House 15 Democrat 46150.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8526.pdf 01/11/2016 2016
Glenn Satoru Glenn Wakai Senate 15 Democrat 67079.52 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 2016
NA Victoria Franks House 16 Republican 3139.31 NA NA NA NA
Daynette S.P. Daynette Morikawa House 16 Democrat 27050.00 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 2016
Breene Y. Breene Harimoto Senate 16 Democrat 6595.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8878.pdf 01/31/2016 2016
NA Karlen Ross House 17 Democrat 6098.00 NA NA NA NA
NA Christopher Stump House 17 Democrat 534.67 NA NA NA NA
Gene R. Gene Ward House 17 Republican 36851.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8646.pdf 01/24/2016 2016
Clarence K. Clarence Nishihara Senate 17 Democrat 12800.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8484.pdf 01/06/2016 2016
Mark Jun Mark Hashem House 18 Democrat 27080.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8871.pdf 01/30/2016 2016
Michelle N. Michelle Kidani Senate 18 Democrat 102494.62 http://files.hawaii.gov/ethics/disc/2016/FinLong_8932.pdf 02/01/2016 2016
NA Stephen Bischoff House 19 Republican 200.00 NA NA NA NA
NA Anthony Higa House 19 Libertarian 6600.00 NA NA NA NA
Bertrand Y. Bertrand Kobayashi House 19 Democrat 11600.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8645.pdf 01/24/2016 2016
William Calip William Espero Senate 19 Democrat 49045.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8784.pdf 01/28/2016 2016
NA Kurt Fevella Senate 19 Republican 2200.00 NA NA NA NA
NA Christopher Fidelibus Senate 19 Republican 5150.00 NA NA NA NA
NA Julia Allen House 20 Republican 4487.00 NA NA NA NA
Calvin K.Y. Calvin Say House 20 Democrat 66300.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8659.pdf 01/25/2016 2016
Gerald Michael Mike Gabbard Senate 20 Democrat 38356.20 http://files.hawaii.gov/ethics/disc/2016/FinLong_8651.pdf 01/25/2016 2016
Scott Y. Scott Nishimoto House 21 Democrat 41864.11 http://files.hawaii.gov/ethics/disc/2016/FinLong_8831.pdf 01/29/2016 2016
NA Tercia Ku Senate 21 Republican 111.00 NA NA NA NA
Maile S.L. Maile Shimabukuro Senate 21 Democrat 10645.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8603.pdf 01/19/2016 2016
Thomas M. Tom Brower House 22 Democrat 31050.00 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11218.pdf 02/01/2016 2016
NA Janet Grace House 22 Republican 3825.00 NA NA NA NA
NA Kathryn Henski House 22 Republican 5926.05 NA NA NA NA
NA Nicola Perez-Garreaud House 22 Democrat 500.00 NA NA NA NA
Donovan Michael Donovan Dela Cruz Senate 22 Democrat 143883.56 http://files.hawaii.gov/ethics/disc/2016/FinLong_8696.pdf 01/26/2016 2016
Isaac William Isaac Choy House 23 Democrat 46350.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8882.pdf 01/31/2016 2016
NA Dale Kobayashi House 23 Democrat 63005.19 NA NA NA NA
NA Rex Saunders House 23 Democrat 7283.87 NA NA NA NA
NA Richard Fale Senate 23 Republican 250.00 NA NA NA NA
Gilbert R. Gil Riviere Senate 23 Democrat 5095.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8886.pdf 01/31/2016 2016
Della Au Della Belatti House 24 Democrat 47265.00 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 2016
NA Larry Fenton House 24 Republican 756.01 NA NA NA NA
NA Cody Rodriguez House 24 Democrat 180.00 NA NA NA NA
NA Michelle Tippens House 24 Libertarian 5900.00 NA NA NA NA
Jill Naomi Jill Tokuda Senate 24 Democrat 48003.75 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11199.pdf 01/29/2016 2016
NA Ronald Lam House 25 Republican 145.00 NA NA NA NA
Sylvia J. Sylvia Luke House 25 Democrat 206932.03 http://files.hawaii.gov/ethics/disc/2016/FinLong_8708.pdf 01/27/2016 2016
NA Robert Nagamine Senate 25 Republican 8990.95 NA NA NA NA
Laura H. Laura Thielen Senate 25 Democrat 25960.50 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 2016
NA Eric Marshall House 26 Republican 716.33 NA NA NA NA
Scott K. Scott Saiki House 26 Democrat 80859.15 http://files.hawaii.gov/ethics/disc/2016/FinLong_8877.pdf 01/31/2016 2016
Takashi Takashi Ohno House 27 Democrat 30499.82 http://files.hawaii.gov/ethics/disc/2016/FinLong_8601.pdf 01/19/2016 2016
NA Ikaika Hussey House 28 Democrat 7300.00 NA NA NA NA
John Musashi John Mizuno House 28 Democrat 40395.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8483.pdf 01/06/2016 2016
NA Kaiwiola Coakley House 29 Republican 4500.00 NA NA NA NA
NA Firmo Dayao House 29 Democrat 4225.00 NA NA NA NA
NA Valerie Dionne House 29 Democrat 2300.00 NA NA NA NA
NA Daniel Holt House 29 Democrat 35989.74 NA NA NA NA
NA James Logue House 29 Democrat 3692.90 NA NA NA NA
Romeo M. Romy Cachola House 30 Democrat 15125.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8738.pdf 01/27/2016 2016
NA Marcelino Velasco House 30 Democrat 250.00 NA NA NA NA
NA Eric Ching House 31 Republican 9968.80 NA NA NA NA
Aaron L. Aaron Johanson House 31 Democrat 46095.00 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11243.pdf 02/01/2016 2016
Linda Eileen Linda Ichiyama House 32 Democrat 27050.00 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11111.pdf 01/27/2016 2016
NA Tracy Arakaki House 33 Democrat 8944.00 NA NA NA NA
NA Heather Giugni House 33 Democrat 2000.00 NA NA NA NA
Samuel Satoru NA Kong House 33 NA NA http://files.hawaii.gov/ethics/disc/2016/FinLong_8517.pdf 01/07/2016 2016
NA Jaci Agustin House 34 Republican 20325.00 NA NA NA NA
Gregg T. Gregg Takayama House 34 Democrat 26925.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8879.pdf 01/31/2016 2016
Roy M. Roy Takumi House 35 Democrat 15395.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8767.pdf 01/28/2016 2016
NA Zurishaddai Aki House 36 Democrat 7140.01 NA NA NA NA
NA Beth Fukumoto House 36 Republican 37224.50 NA NA NA NA
Beth Keiko NA Fukumoto Chang House 36 NA NA http://files.hawaii.gov/ethics/disc/2016/FinLong_8946.pdf 02/01/2016 2016
NA Marilyn Lee House 36 Democrat 14400.00 NA NA NA NA
NA Katherine Kupukaa House 37 Republican 1930.97 NA NA NA NA
NA Emil Svrcina House 37 Republican 545.50 NA NA NA NA
Ryan Ichiro Ryan Yamane House 37 Democrat 46175.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8861.pdf 01/29/2016 2016
Henry James C. Henry Aquino House 38 Democrat 44385.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8501.pdf 01/07/2016 2016
Ty J.K. Ty Cullen House 39 Democrat 50705.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8940.pdf 02/01/2016 2016
NA Randy Gonce House 40 Democrat 7972.00 NA NA NA NA
NA Rosebella Martinez House 40 Democrat 4540.00 NA NA NA NA
Robert C. Bob McDermott House 40 Republican 42535.97 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 2016
NA Bryan Jeremiah House 41 Republican 12804.33 NA NA NA NA
Matthew S. Matthew LoPresti House 41 Democrat 36308.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8746.pdf 01/27/2016 2016
NA Nicole Ferguson House 42 Democrat 230.00 NA NA NA NA
NA Michael Golojuch House 42 Democrat 200.00 NA NA NA NA
Sharon E. Sharon Har House 42 Democrat 27600.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8890.pdf 02/01/2016 2016
NA Karen Awana House 43 Democrat 3700.00 NA NA NA NA
NA Stacelynn Eli House 43 Democrat 31052.38 NA NA NA NA
Andria P. Andria Tupola House 43 Republican 43286.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8926.pdf 02/01/2016 2016
NA Cedric Gates House 44 Democrat 33499.69 NA NA NA NA
NA Jo Jordan House 44 Democrat 26210.00 NA NA NA NA
NA Marcus Paaluhi House 44 Republican 14866.00 NA NA NA NA
NA Tamiko Sequin House 44 Republican 4270.00 NA NA NA NA
Lauren K. Lauren Matsumoto House 45 Republican 28270.00 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 2016
Marcus R. Marcus Oshiro House 46 Democrat 22050.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8884.pdf 01/31/2016 2016
NA Toagaifasa Mataafa House 47 Republican 1300.00 NA NA NA NA
NA Feki Pouha House 47 Republican 16510.00 NA NA NA NA
NA Sean Quinlan House 47 Democrat 35060.31 NA NA NA NA
Jarrett K. Jarrett Keohokalole House 48 Democrat 29245.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8868.pdf 01/30/2016 2016
Kenneth T. Ken Ito House 49 Democrat 30225.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8761.pdf 01/28/2016 2016
NA Patrick Shea House 49 Democrat 24397.57 NA NA NA NA
NA Joan Hood House 50 Republican 8660.00 NA NA NA NA
Cynthia H. Cynthia Thielen House 50 Republican 33782.00 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-10973.pdf 01/06/2016 2016
Christopher Kalani Cushman Christopher Lee House 51 Democrat 45095.84 http://files.hawaii.gov/ethics/disc/2016/FinLong_8951.pdf 02/01/2016 2016

5.1.2 Levenshtein distance on First Name

library(RecordLinkage)
financial_ties.winners$first_name_similarity <- levenshteinSim(financial_ties.winners$ethics_first_name,financial_ties.winners$contribution_first_name)


#Pretty format score for readability
percent <- function(x, digits = 2, format = "f", ...) {
  ifelse(!is.na(x),paste0(formatC(100 * x, format = format, digits = digits, ...), "%"),NA)
}

financial_ties.winners <- financial_ties.winners[,.(ethics_first_name,contribution_first_name,first_name_similarity=percent(first_name_similarity),ethics_last_name,`Dept/Board`,district,Party,Amount,original_url,ammend_url,dates,`File Year`)]



#write.csv(financial_ties.winners[order(as.integer(district))],"curated_data/winner_legislators_linkage.csv",row.names=FALSE)
kable(financial_ties.winners[order(as.integer(district))])
ethics_first_name contribution_first_name first_name_similarity ethics_last_name Dept/Board district Party Amount original_url ammend_url dates File Year
Kaialii Kaialii 100.00% Kahele Senate 1 Democrat 151559.00 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 2016
Kaialii Gilbert 0.00% Kahele Senate 1 Democrat 23144.22 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 2016
NA Heather NA Kimball House 1 Democrat 7014.52 NA NA NA NA
Mark M. Mark 57.14% Nakashima House 1 Democrat 55433.51 http://files.hawaii.gov/ethics/disc/2016/FinLong_8895.pdf 02/01/2016 2016
NA Dennis NA Onishi Senate 1 Democrat 9462.45 NA NA NA NA
NA Kaloa NA Robinson Senate 1 Democrat 11520.09 NA NA NA NA
NA Byron NA Young House 1 Republican 994.00 NA NA NA NA
NA Greggor NA Ilagan Senate 2 Democrat 44172.92 NA NA NA NA
NA Grace NA Manipol-Larson House 2 Non-Partisan 825.00 NA NA NA NA
Russell E. Russell 70.00% Ruderman Senate 2 Democrat 25044.20 http://files.hawaii.gov/ethics/disc/2016/FinLong_8458.pdf 01/03/2016 2016
NA Clifton NA Tsuji House 2 Democrat 39901.97 NA NA NA NA
NA Jonathan NA Wong House 2 Democrat 16960.00 NA NA NA NA
Joshua B. Josh 44.44% Green Senate 3 Democrat 82300.00 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 2016
NA Alexander NA Naniole House 3 Democrat 25750.00 NA NA NA NA
Richard H.K. Richard 58.33% Onishi House 3 Democrat 29444.01 http://files.hawaii.gov/ethics/disc/2016/FinLong_8920.pdf 02/01/2016 2016
NA Kealoha NA Pisciotta House 3 Green 3590.00 NA NA NA NA
Lorraine Rodero Lorraine 53.33% Inouye Senate 4 Democrat 55950.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8800.pdf 01/29/2016 2016
Joy A. Joy 50.00% San Buenaventura House 4 Democrat 19550.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8787.pdf 01/28/2016 2016
Richard P. Richard 70.00% Creagan House 5 Democrat 16050.00 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 2016
Gilbert S.C. Gilbert 58.33% Keith-Agaran Senate 5 Democrat 104978.87 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11112.pdf 01/27/2016 2016
NA Terez NA Amato Senate 6 Democrat 500.00 NA NA NA NA
Rosalyn H. Rosalyn 70.00% Baker Senate 6 Democrat 71534.07 http://files.hawaii.gov/ethics/disc/2016/FinLong_8863.pdf 01/29/2016 2016
NA Bronsten-Glenn NA Kossow House 6 Democrat 1203.49 NA NA NA NA
Nicole E. Nicole 66.67% Lowen House 6 Democrat 37831.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8927.pdf 02/01/2016 2016
NA Bruce NA Pratt House 6 Republican 1300.00 NA NA NA NA
NA Jeffrey NA Coakley House 7 Republican 2350.00 NA NA NA NA
J. Kalani Kalani 66.67% English Senate 7 Democrat 75580.41 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11198.pdf 01/29/2016 2016
Cynthia Frances Wood Cindy 15.00% Evans House 7 Democrat 31220.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8521.pdf 01/10/2016 2016
NA David NA Tarnas House 7 Democrat 37888.17 NA NA NA NA
NA Kanoe NA Ahuna Senate 8 Democrat 8037.39 NA NA NA NA
NA Cranston NA Kapoi House 8 Republican 500.00 NA NA NA NA
Ronald D. Ron 33.33% Kouchi Senate 8 Democrat 211201.77 http://files.hawaii.gov/ethics/disc/2016/FinLong_8938.pdf 02/01/2016 2016
NA Gilbert NA Rebolledo House 8 Republican 430.00 NA NA NA NA
Joseph Mark Joseph 54.55% Souki House 8 Democrat 118878.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8914.pdf 02/01/2016 2016
NA Stanley NA Chang Senate 9 Democrat 135747.22 NA NA NA NA
NA Sam NA Slom Senate 9 Republican 25771.90 NA NA NA NA
Justin H. Justin 66.67% Woodson House 9 Democrat 33400.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8749.pdf 01/27/2016 2016
NA David NA Farrell Senate 10 Democrat 720.15 NA NA NA NA
Les S. Les 50.00% Ihara Senate 10 Democrat 12903.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8885.pdf 01/31/2016 2016
Angus L.K. Angus 50.00% McKelvey House 10 Democrat 46542.34 http://files.hawaii.gov/ethics/disc/2016/FinLong_8525.pdf 01/11/2016 2016
NA Arnold NA Phillips Senate 10 Libertarian 12982.63 NA NA NA NA
Mark Kaniela Mark 33.33% Ing House 11 Democrat 47457.24 http://files.hawaii.gov/ethics/disc/2016/FinLong_8941.pdf 02/01/2016 2016
NA Daniel NA Pekus House 11 Republican 1635.00 NA NA NA NA
Brian T. Brian 62.50% Taniguchi Senate 11 Democrat 45155.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8642.pdf 01/23/2016 2016
NA Deidre NA Tegarden House 11 Democrat 88809.88 NA NA NA NA
Brickwood M. Brickwood 75.00% Galuteria Senate 12 Democrat 14101.01 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11208.pdf 01/30/2016 2016
NA Tiare NA Lawrence House 12 Democrat 20484.92 NA NA NA NA
NA Richard NA Pohle House 12 Republican 200.00 NA NA NA NA
Kyle T. Kyle 57.14% Yamashita House 12 Democrat 32825.00 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11062.pdf 01/25/2016 2016
NA Suzanne NA Chun Oakland Senate 13 Democrat 650.00 NA NA NA NA
Lynn P. Lynn 57.14% DeCoite House 13 Democrat 78019.13 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11126.pdf 01/28/2016 2016
NA Alexander NA Haller House 13 Democrat 8614.95 NA NA NA NA
NA Kim Coco NA Iwamoto Senate 13 Democrat 46945.22 NA NA NA NA
NA Keone NA Nakoa Senate 13 Democrat 46908.48 NA NA NA NA
NA Nick NA Nikhilananda House 13 Green 950.00 NA NA NA NA
NA Harry NA Ozols Senate 13 Libertarian 220.83 NA NA NA NA
NA Karl NA Rhoads Senate 13 Democrat 125937.62 NA NA NA NA
NA Rodney NA Tam Senate 13 Republican 4989.15 NA NA NA NA
NA Carl NA Campagna Senate 14 Democrat 5213.37 NA NA NA NA
NA Sandra NA Combs House 14 Republican 28450.00 NA NA NA NA
Donna Mercado Donna 38.46% Kim Senate 14 Democrat 125850.00 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11081.pdf 01/27/2016 2016
NA Nadine NA Nakamura House 14 Democrat 38802.41 NA NA NA NA
NA Fern NA Rosenstiel House 14 Democrat 8488.95 NA NA NA NA
NA Thomas NA Oi House 15 Democrat 6700.00 NA NA NA NA
James K. James 62.50% Tokioka House 15 Democrat 46150.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8526.pdf 01/11/2016 2016
Glenn Satoru Glenn 41.67% Wakai Senate 15 Democrat 67079.52 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 2016
NA Victoria NA Franks House 16 Republican 3139.31 NA NA NA NA
Breene Y. Breene 66.67% Harimoto Senate 16 Democrat 6595.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8878.pdf 01/31/2016 2016
Daynette S.P. Daynette 61.54% Morikawa House 16 Democrat 27050.00 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 2016
Clarence K. Clarence 72.73% Nishihara Senate 17 Democrat 12800.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8484.pdf 01/06/2016 2016
NA Karlen NA Ross House 17 Democrat 6098.00 NA NA NA NA
NA Christopher NA Stump House 17 Democrat 534.67 NA NA NA NA
Gene R. Gene 57.14% Ward House 17 Republican 36851.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8646.pdf 01/24/2016 2016
Mark Jun Mark 50.00% Hashem House 18 Democrat 27080.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8871.pdf 01/30/2016 2016
Michelle N. Michelle 72.73% Kidani Senate 18 Democrat 102494.62 http://files.hawaii.gov/ethics/disc/2016/FinLong_8932.pdf 02/01/2016 2016
NA Stephen NA Bischoff House 19 Republican 200.00 NA NA NA NA
William Calip William 53.85% Espero Senate 19 Democrat 49045.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8784.pdf 01/28/2016 2016
NA Kurt NA Fevella Senate 19 Republican 2200.00 NA NA NA NA
NA Christopher NA Fidelibus Senate 19 Republican 5150.00 NA NA NA NA
NA Anthony NA Higa House 19 Libertarian 6600.00 NA NA NA NA
Bertrand Y. Bertrand 72.73% Kobayashi House 19 Democrat 11600.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8645.pdf 01/24/2016 2016
NA Julia NA Allen House 20 Republican 4487.00 NA NA NA NA
Gerald Michael Mike 21.43% Gabbard Senate 20 Democrat 38356.20 http://files.hawaii.gov/ethics/disc/2016/FinLong_8651.pdf 01/25/2016 2016
Calvin K.Y. Calvin 54.55% Say House 20 Democrat 66300.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8659.pdf 01/25/2016 2016
NA Tercia NA Ku Senate 21 Republican 111.00 NA NA NA NA
Scott Y. Scott 62.50% Nishimoto House 21 Democrat 41864.11 http://files.hawaii.gov/ethics/disc/2016/FinLong_8831.pdf 01/29/2016 2016
Maile S.L. Maile 50.00% Shimabukuro Senate 21 Democrat 10645.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8603.pdf 01/19/2016 2016
Thomas M. Tom 33.33% Brower House 22 Democrat 31050.00 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11218.pdf 02/01/2016 2016
Donovan Michael Donovan 46.67% Dela Cruz Senate 22 Democrat 143883.56 http://files.hawaii.gov/ethics/disc/2016/FinLong_8696.pdf 01/26/2016 2016
NA Janet NA Grace House 22 Republican 3825.00 NA NA NA NA
NA Kathryn NA Henski House 22 Republican 5926.05 NA NA NA NA
NA Nicola NA Perez-Garreaud House 22 Democrat 500.00 NA NA NA NA
Isaac William Isaac 38.46% Choy House 23 Democrat 46350.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8882.pdf 01/31/2016 2016
NA Richard NA Fale Senate 23 Republican 250.00 NA NA NA NA
NA Dale NA Kobayashi House 23 Democrat 63005.19 NA NA NA NA
Gilbert R. Gil 30.00% Riviere Senate 23 Democrat 5095.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8886.pdf 01/31/2016 2016
NA Rex NA Saunders House 23 Democrat 7283.87 NA NA NA NA
Della Au Della 62.50% Belatti House 24 Democrat 47265.00 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 2016
NA Larry NA Fenton House 24 Republican 756.01 NA NA NA NA
NA Cody NA Rodriguez House 24 Democrat 180.00 NA NA NA NA
NA Michelle NA Tippens House 24 Libertarian 5900.00 NA NA NA NA
Jill Naomi Jill 40.00% Tokuda Senate 24 Democrat 48003.75 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11199.pdf 01/29/2016 2016
NA Ronald NA Lam House 25 Republican 145.00 NA NA NA NA
Sylvia J. Sylvia 66.67% Luke House 25 Democrat 206932.03 http://files.hawaii.gov/ethics/disc/2016/FinLong_8708.pdf 01/27/2016 2016
NA Robert NA Nagamine Senate 25 Republican 8990.95 NA NA NA NA
Laura H. Laura 62.50% Thielen Senate 25 Democrat 25960.50 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 2016
NA Eric NA Marshall House 26 Republican 716.33 NA NA NA NA
Scott K. Scott 62.50% Saiki House 26 Democrat 80859.15 http://files.hawaii.gov/ethics/disc/2016/FinLong_8877.pdf 01/31/2016 2016
Takashi Takashi 100.00% Ohno House 27 Democrat 30499.82 http://files.hawaii.gov/ethics/disc/2016/FinLong_8601.pdf 01/19/2016 2016
NA Ikaika NA Hussey House 28 Democrat 7300.00 NA NA NA NA
John Musashi John 33.33% Mizuno House 28 Democrat 40395.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8483.pdf 01/06/2016 2016
NA Kaiwiola NA Coakley House 29 Republican 4500.00 NA NA NA NA
NA Firmo NA Dayao House 29 Democrat 4225.00 NA NA NA NA
NA Valerie NA Dionne House 29 Democrat 2300.00 NA NA NA NA
NA Daniel NA Holt House 29 Democrat 35989.74 NA NA NA NA
NA James NA Logue House 29 Democrat 3692.90 NA NA NA NA
Romeo M. Romy 37.50% Cachola House 30 Democrat 15125.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8738.pdf 01/27/2016 2016
NA Marcelino NA Velasco House 30 Democrat 250.00 NA NA NA NA
NA Eric NA Ching House 31 Republican 9968.80 NA NA NA NA
Aaron L. Aaron 62.50% Johanson House 31 Democrat 46095.00 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11243.pdf 02/01/2016 2016
Linda Eileen Linda 41.67% Ichiyama House 32 Democrat 27050.00 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-11111.pdf 01/27/2016 2016
NA Tracy NA Arakaki House 33 Democrat 8944.00 NA NA NA NA
NA Heather NA Giugni House 33 Democrat 2000.00 NA NA NA NA
Samuel Satoru NA NA Kong House 33 NA NA http://files.hawaii.gov/ethics/disc/2016/FinLong_8517.pdf 01/07/2016 2016
NA Jaci NA Agustin House 34 Republican 20325.00 NA NA NA NA
Gregg T. Gregg 62.50% Takayama House 34 Democrat 26925.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8879.pdf 01/31/2016 2016
Roy M. Roy 50.00% Takumi House 35 Democrat 15395.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8767.pdf 01/28/2016 2016
NA Zurishaddai NA Aki House 36 Democrat 7140.01 NA NA NA NA
NA Beth NA Fukumoto House 36 Republican 37224.50 NA NA NA NA
Beth Keiko NA NA Fukumoto Chang House 36 NA NA http://files.hawaii.gov/ethics/disc/2016/FinLong_8946.pdf 02/01/2016 2016
NA Marilyn NA Lee House 36 Democrat 14400.00 NA NA NA NA
NA Katherine NA Kupukaa House 37 Republican 1930.97 NA NA NA NA
NA Emil NA Svrcina House 37 Republican 545.50 NA NA NA NA
Ryan Ichiro Ryan 36.36% Yamane House 37 Democrat 46175.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8861.pdf 01/29/2016 2016
Henry James C. Henry 35.71% Aquino House 38 Democrat 44385.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8501.pdf 01/07/2016 2016
Ty J.K. Ty 28.57% Cullen House 39 Democrat 50705.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8940.pdf 02/01/2016 2016
NA Randy NA Gonce House 40 Democrat 7972.00 NA NA NA NA
NA Rosebella NA Martinez House 40 Democrat 4540.00 NA NA NA NA
Robert C. Bob 22.22% McDermott House 40 Republican 42535.97 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 2016
NA Bryan NA Jeremiah House 41 Republican 12804.33 NA NA NA NA
Matthew S. Matthew 70.00% LoPresti House 41 Democrat 36308.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8746.pdf 01/27/2016 2016
NA Nicole NA Ferguson House 42 Democrat 230.00 NA NA NA NA
NA Michael NA Golojuch House 42 Democrat 200.00 NA NA NA NA
Sharon E. Sharon 66.67% Har House 42 Democrat 27600.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8890.pdf 02/01/2016 2016
NA Karen NA Awana House 43 Democrat 3700.00 NA NA NA NA
NA Stacelynn NA Eli House 43 Democrat 31052.38 NA NA NA NA
Andria P. Andria 66.67% Tupola House 43 Republican 43286.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8926.pdf 02/01/2016 2016
NA Cedric NA Gates House 44 Democrat 33499.69 NA NA NA NA
NA Jo NA Jordan House 44 Democrat 26210.00 NA NA NA NA
NA Marcus NA Paaluhi House 44 Republican 14866.00 NA NA NA NA
NA Tamiko NA Sequin House 44 Republican 4270.00 NA NA NA NA
Lauren K. Lauren 66.67% Matsumoto House 45 Republican 28270.00 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 2016
Marcus R. Marcus 66.67% Oshiro House 46 Democrat 22050.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8884.pdf 01/31/2016 2016
NA Toagaifasa NA Mataafa House 47 Republican 1300.00 NA NA NA NA
NA Feki NA Pouha House 47 Republican 16510.00 NA NA NA NA
NA Sean NA Quinlan House 47 Democrat 35060.31 NA NA NA NA
Jarrett K. Jarrett 70.00% Keohokalole House 48 Democrat 29245.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8868.pdf 01/30/2016 2016
Kenneth T. Ken 30.00% Ito House 49 Democrat 30225.00 http://files.hawaii.gov/ethics/disc/2016/FinLong_8761.pdf 01/28/2016 2016
NA Patrick NA Shea House 49 Democrat 24397.57 NA NA NA NA
NA Joan NA Hood House 50 Republican 8660.00 NA NA NA NA
Cynthia H. Cynthia 70.00% Thielen House 50 Republican 33782.00 http://files.hawaii.gov/ethics/disc/2016/Kfx10Dis-10973.pdf 01/06/2016 2016
Christopher Kalani Cushman Christopher 42.31% Lee House 51 Democrat 45095.84 http://files.hawaii.gov/ethics/disc/2016/FinLong_8951.pdf 02/01/2016 2016