Let’s see just how powerful the new app from the Hawaii Campaign Spending Commission is using Honolulu Mayor Kirk Caldwell as our guinea pig.

As Civil Beat reporter Nathan Eagle wrote yesterday, the app is useful when wanting to visualize campaign spending data. But it also helps to streamline analysis.

So here we go…

Caldwell isn’t up for election until 2016, but he’s already raking in the campaign dough.

Since being elected he’s raised about $617,500, mostly from individual donors who have given more than $1,000.

But he also received some big donations from businesses and unions, including Alexander & Baldwin, United Public Workers, First Hawaiian Bank and Castle & Cooke.

As far as the size of the contributions made to Caldwell, 81 percent were greater than $1,000.

Fifteen percent of Caldwell’s contributions, or $93,000, came from out of state donors, the largest share of whom were in California.

But when looking at his local contributors the largest share are in the 96821 zip code, which includes Niu Valley and Aina Haina. Caldwell’s next largest segment of contributors come from the Kaimuki area.

Caldwell has only spent about $68,000 so far, with the largest chunk (about $25,000) going to food and beverages.

He’s also dropped over $15,000 with Olomana Loomis ISC, a strategy firm that includes Gov. Neil Abercrombie as one its clients.

The best part about all of this? It took less than 10 minutes to cobble this stuff together.

Just enter a name and the information is culled together and visualized for you.

The data can also be exported into a spreadsheet for those who want to dig a little deeper.

Enjoy.

Photo: Honolulu Mayor Kirk Caldwell after winning the Nov. 2012 election. (John Hook/Honolulu Civil Beat)

—Nick Grube

What it means to support Civil Beat.

Supporting Civil Beat means you’re investing in a newsroom that can devote months to investigate corruption. It means we can cover vulnerable, overlooked communities because those stories matter. And, it means we serve you. And only you.

Donate today and help sustain the kind of journalism Hawaiʻi cannot afford to lose.