django-calaccess-raw-data

A Django app to download, extract and load campaign finance and lobbying activity data from the California Secretary of State’s CAL-ACCESS database

Documentation

• How to use it
  • Installing the Django app
  • Connecting to a local database
  • Loading the data
  • Exploring the data
• Management commands
  • cleancalaccessrawfile
  • downloadcalaccessrawdata
  • loadcalaccessrawfile
  • totalcalaccessrawdata
  • verifycalaccessrawfile
• Database tables
  • Campaign tables
  • Common tables
  • Lobbying tables
  • Other tables
  • Empty files
• Frequently asked questions
  • Does django-calaccess-raw-data modify the source data?
  • How far back does the CAL-ACCESS database go?
  • Who is the California Civic Data Coalition?
• Official CAL-ACCESS documentation
  • Overview
  • Forms
  • California file .CAL format
• How to contribute
  • Preparing a development environment
  • Connecting to a local database
• Changelog
  • 0.1.2 (February 2015)
  • 0.1.1 (January 2015)
  • 0.1.0 (November 2014)
  • 0.0.7 (August 2014)

Open-source resources

• Code: github.com/california-civic-data-coalition/django-calaccess-raw-data
• Issues: github.com/california-civic-data-coalition/django-calaccess-raw-data/issues
• Packaging: pypi.python.org/pypi/django-calaccess-raw-data
• Testing: travis-ci.org/california-civic-data-coalition/django-calaccess-raw-data
• Coverage: coveralls.io/r/california-civic-data-coalition/django-calaccess-raw-data

About

This library is maintained by The California Civic Data Coalition, a team of journalists leading the development of open-source software to access and analyze public data. Read more at californiacivicdata.org.