Hawaii State Ethics Commission’s Lobbyists’ Expenditure Statements

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.hawaii.gov
Id 667b-qk6q
Name Hawaii State Ethics Commission’s Lobbyists’ Expenditure Statements
Created 2013-12-07T00:22:12Z
Publication Date 2017-04-18T02:08:35Z

Columns

| Included | Schema Type    | Field Name       | Name          | Data Type     | Render Type   |
| ======== | ============== | ================ | ============= | ============= | ============= |
| Yes      | series tag     | full_name        | Lobbyist Name | text          | text          |
| Yes      | series tag     | expenditure_form | View          | url           | url           |
| Yes      | numeric metric | total            | Total Expense | money         | money         |
| Yes      | series tag     | period           | Lobby Period  | text          | text          |
| No       |                | lobyear          | Year          | number        | text          |
| Yes      | time           | received_date    | Date Filed    | calendar_date | calendar_date |
| Yes      | series tag     | original         | Original      | checkbox      | checkbox      |
| Yes      | series tag     | amended          | Amended       | checkbox      | checkbox      |

Time Field

Value = received_date
Format & Zone = yyyy-MM-dd'T'HH:mm:ss

Series Fields

Excluded Fields = lobyear

Data Commands

series e:667b-qk6q d:2013-03-27T00:00:00.000Z t:amended=false t:original=true t:expenditure_form=http://files.hawaii.gov/ethics/lobexp/2013/LOB-1803-2013-01_Kfx10-2641.pdf t:period="Jan. 1-Feb. 28, 2013" t:full_name="Chun, Cory M." m:total=0

series e:667b-qk6q d:2013-05-22T00:00:00.000Z t:amended=false t:original=true t:expenditure_form=http://files.hawaii.gov/ethics/lobexp/2013/LOB-1803-2013-02.pdf t:period="Mar. 1-Apr. 30, 2013" t:full_name="Chun, Cory M." m:total=0

series e:667b-qk6q d:2015-03-31T00:00:00.000Z t:amended=false t:original=true t:expenditure_form=http://files.hawaii.gov/ethics/lobexp/2015/LOB-1803-2015-01_Kfx10-9556.pdf t:period="Jan. 1-Feb. 28, 2015" t:full_name="Chun, Cory M." m:total=0

Meta Commands

metric m:total p:double l:"Total Expense" t:dataTypeName=money

entity e:667b-qk6q l:"Hawaii State Ethics Commission's Lobbyists' Expenditure Statements" t:url=https://data.hawaii.gov/api/views/667b-qk6q

property e:667b-qk6q t:meta.view v:id=667b-qk6q v:averageRating=0 v:name="Hawaii State Ethics Commission's Lobbyists' Expenditure Statements"

property e:667b-qk6q t:meta.view.owner v:id=ikz2-vjne v:screenName=PatrickLui v:displayName=PatrickLui

property e:667b-qk6q t:meta.view.tableauthor v:id=ikz2-vjne v:screenName=PatrickLui v:roleName=editor v:displayName=PatrickLui

Top Records

| full_name                | expenditure_form                                                                    | total    | period               | lobyear | received_date       | original | amended | 
| ======================== | =================================================================================== | ======== | ==================== | ======= | =================== | ======== | ======= | 
| Chun, Cory M.            | [http://files.hawaii.gov/ethics/lobexp/2013/LOB-1803-2013-01_Kfx10-2641.pdf, Form]  | 0.00     | Jan. 1-Feb. 28, 2013 | 2013    | 2013-03-27T00:00:00 | true     | false   | 
| Chun, Cory M.            | [http://files.hawaii.gov/ethics/lobexp/2013/LOB-1803-2013-02.pdf, Form]             | 0.00     | Mar. 1-Apr. 30, 2013 | 2013    | 2013-05-22T00:00:00 | true     | false   | 
| Chun, Cory M.            | [http://files.hawaii.gov/ethics/lobexp/2015/LOB-1803-2015-01_Kfx10-9556.pdf, Form]  | 0.00     | Jan. 1-Feb. 28, 2015 | 2015    | 2015-03-31T00:00:00 | true     | false   | 
| Trask Murakami, Mahie P. | [http://files.hawaii.gov/ethics/lobexp/2013/LOB-1804-2013-01.pdf, Form]             | 0.00     | Jan. 1-Feb. 28, 2013 | 2013    | 2013-07-17T00:00:00 | true     | false   | 
| Trask Murakami, Mahie P. | [http://files.hawaii.gov/ethics/lobexp/2013/LOB-1804-2013-02.pdf, Form]             | 0.00     | Mar. 1-Apr. 30, 2013 | 2013    | 2013-07-17T00:00:00 | true     | false   | 
| Trask Murakami, Mahie P. | [http://files.hawaii.gov/ethics/lobexp/2016/LOB-1804-2016-03_Kfx10-13156.pdf, Form] | 0.00     | May 1-Dec. 31, 2016  | 2016    | 2017-01-18T00:00:00 | true     | false   | 
| Dold, James L.           | [http://files.hawaii.gov/ethics/lobexp/2014/LOB-1807-2014-02_Kfx10-6580.pdf, Form]  | 12000.00 | Mar. 1-Apr. 30, 2014 | 2014    | 2014-05-09T00:00:00 | true     | false   | 
| Dold, James L.           | [http://files.hawaii.gov/ethics/lobexp/2014/LOB-1807-2014-03_Kfx10-8325.pdf, Form]  | 42000.00 | May 1-Dec. 31, 2014  | 2014    | 2015-01-02T00:00:00 | true     | false   | 
| Donaldson, Robert E.     | [http://files.hawaii.gov/ethics/lobexp/2013/LOB-1809-2013-01_Kfx10-2697.pdf, Form]  | 0.00     | Jan. 1-Feb. 28, 2013 | 2013    | 2013-04-01T00:00:00 | true     | false   | 
| Donaldson, Robert E.     | [http://files.hawaii.gov/ethics/lobexp/2013/LOB-1809-2013-02.pdf, Form]             | 0.00     | Mar. 1-Apr. 30, 2013 | 2013    | 2013-05-28T00:00:00 | true     | false   |