ryanwold.net

A civic-minded citizen seeking the singularity

Back to Entries

Dataset: California Local Government Compensation Reports

idea
Date: 2013-08-25
Tags: california data finance

While browsing the California State Controller's website, I found a notice that while compensation data is available, it is not available online, rather, it is available if they send it to you. Not ideal, but certainly better than nothing. After sending an email on the website, a compact disc arrived after communicating with Ken Press.

The file has the following text descriptions on it:

City, County, and Special Districts Data, as of July 11, 2011. File Types: Excel 2007 (.xlsx) and Comma Separated Value (.csv) I appreciate that Ken readily assisted me and the data arrived relatively quickly. However, it seems to make more sense to publish this data on an ongoing basis.

If this data were available, updated on a weekly basis, the following things would become possible in the public domain due to the effort to make public data available:

changesets of positions staffing across agency staffing within agencies salaries across agencies salaries within agencies. The source file is available here: http://dl.dropbox.com/u/1186808/CityCountySD2011-07-11.csv. If you'd like it in another format, please let me know.

By Ryan Wold · © 2013–2026 Ryan Wold

Licensed CC BY-NC 4.0. AI training requires a license — machine-readable terms.

Enjoyed this? — any BSV wallet, HandCash, or plain old dollars.

Leave a tip

Tips go directly to a Bitcoin SV address I control — peer to peer, no platform in between. A few thousand satoshis is a fraction of a cent; it's the gesture that counts.

From any BSV wallet

Scan the QR code with your wallet's camera, or copy the address.

177DwUfSTW8RkFBJzYYcgr1YB8ngbhTYAc

With HandCash or any paymail wallet

Paymail is an email-style address for Bitcoin wallets. Send any amount to afomi@handcash.io

First time using Bitcoin? Yours Wallet is an open-source browser extension wallet, and HandCash is an easy mobile wallet — either takes a minute to set up.

Prefer regular money? Support via OpenCollective.