Skip to content

Visualizations for Civic*Celerator primarily based on Campaign Spending data for Hawaii

Notifications You must be signed in to change notification settings



Repository files navigation

Vizualization Screenshot Vizualization Gif


This project is a vizualization of Hawaii Campaign Spending data for Candidates. It was initially created for Civic*Celerator 2013.

View Online

Please note that this visualization is based on the official Hawaii Campaign Spending data which you can find on

But the data is actually pulled from a filtered/rolled-up view:

Socrata Filter Settings

Also the Candidate Committee report is used:

My sorted view of the dataset:

Candidate Committee Socrata Filter Settings

To better understand the data you should take a look at the Campaign Finance Data Primer



bundle install

Visit http://localhost:4000 in a web browser

Getting a Socrata API key

After creating a filtered/rolled-up view as above

curl '' -i -X POST -H 'Content-Type: application/json'  -H 'Accept-Language: en-US,en;q=0.5' --compressed -H 'Pragma: no-cache' -H 'Cache-Control: no-cache' --data '{"keyName": "Example key."}' -u "$USERNAME@$PASSWORD"

Then put your api key username and password key in .env (based on .env.sample)

NOTE: The username is the keyId field and the password is the keySecret field

Updating Data

In this project the data is updated manually rather than automatically fetched (this may change in the future).

bundle exec dotenv ./

Then commit the changes to the data (if any) and then deploy.

Then run:

bundle exec ruby parse.rb


Run deploys script


Then commit the changes. The site is served from the master branch of the common cause repo:


If you'd like to contribute, simply fork the repo, push your commits, and submit your pull request.


Visualizations for Civic*Celerator primarily based on Campaign Spending data for Hawaii








  • JavaScript 78.2%
  • CoffeeScript 9.0%
  • HTML 8.4%
  • SCSS 1.8%
  • CSS 1.7%
  • Ruby 0.7%
  • Shell 0.2%