Hawaii Fiscal Data FY 2014 - FY 2015 - FY 2016


Purpose

During the Code for Hawaii #CodeAcross Panel of the 2016 Unconferenz in Honolulu, the State of Hawaii CIO, Todd Nacapuy, mentioned that they have a need for matching budget data with spending. It was one of the many things that State legislators and officials need help with given the constraints that they face.

At the 2016 National Day of Civic Hacking, a group of coders created a variety of different visualizations.


More information about this project can be found at our Github repository


Background on Budget & Expenditures


Expenditures:

- All expenditues from all agencies / depts are input into FAMIS (cobol database), and contains information on actual expenditure, dept, vendor, agency.

- DataMart software pulls from FAMIS, groups / filters data into a list which then goes to the Dept Acct Gen Svc as excel, csv, etc, but needs to be manually scrubbed since it contains SSNs & personal data, which potentially takes months.

- The scrubbed expenditure data is then put on data.hawaii.gov.


Budget:

- Every 8 months the deputy director of budget and finance provides a budget spreadsheet (xlsx), minus DOE, UH, executive branches, which have their own budget data worksheets; most of which is available in pdfs on captial.hawaii.gov.


Important Disclaimers

Data was sourced from data.hawaii.gov (see sources below). After doing a cursory review it became clear that the expenditures data is missing substantial portions. We are continuing to meet with different Hawaii State stakeholders to establish which portions are missing and why, also to try to get more complete and accurate datasets released to the public in the future.

Overall, there has been very little effort to ensure the information contained in this repository is accurate or current. The author(s), nor Code for Hawaii, nor Code for America warrants the accuracy, reliability, or timeliness of any information in this repository and shall not be held liable for any losses caused by reliance on the accuracy, reliability or timeliness of such information. Portions of the information may be incorrect or not current. Any person or entity that relies on any information obtained from this repository does so at their own risk.


Expenditures


Data


DATA DISCLAIMER


Budget Data Sets:

Currently used data:

Approved budget data - data.hawaii.gov/dataset/Hawaii-Operating-Budget/p8xe-w4xh


Other Available data:

Budget Table J1 (Salary and FTE) - data.hawaii.gov/dataset/Budget-Table-J1-Salary-and-FTE-/i4ce-99gr

Budget Table J2 (Other Current Expenses) - data.hawaii.gov/dataset/Budget-Table-J2-Other-Current-Expenses-/qp7g-996d

McKay's scraped dataset from Director of Budget Dept (mult. worksheets)


Expenditures Data Sets:


Currently used data: data.hawaii.gov/dataset/Expenditures/mkz8-mgjp

Contact


Our National Day of Civic Hacking Visualization Team


Andrew Wong

Jarren Lee

Jennifer Pearcey

Jonathan Geyer

Jonathan Page

Krislin Lee

Yukio Yamamoto


Additional Contributors


McKay Davis

Sunny Bak Hospital