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/.
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).
The linkage roadmap is as folllows:
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 |
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 |
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 |
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 |
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 |
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 |
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")]
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 |
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 |
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 |
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 |
TO-DO
TO-DO
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.
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")]
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 |
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.
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 |
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 |