Home Blog Blog Posts by members of the California Civic Data Coalition. We’re storing open data at archive.org, and you can too By Ben Welsh June 29, 2021 Our downloads are now served with CORS By Ben Welsh February 26, 2018 James Gordon explains it all By Ben Welsh February 16, 2018 A new feature imported from Berlin By Ben Welsh February 6, 2018 Cut down database imports by a third using this one weird trick By Ben Welsh January 25, 2018 Coalition scholar published by The Verge By Ben Welsh November 16, 2017 Introducing a new source for California elections data By James Gordon and the California Civic Data Coalition October 31, 2017 How to export Django data faster than ever before By Ben Welsh September 5, 2017 California Code Rush 5 crushes CAL-ACCESS By Ben Welsh August 4, 2017 Join California Code Rush 5 in the cloud By Ben Welsh August 2, 2017 Seven lessons I learned teaching data analysis with Python By Amy Schmitz Weiss July 12, 2017 Our site is now encrypted with HTTPS By Ben Welsh June 7, 2017 First Python Notebook goes to Washington By David Eads June 7, 2017 First Python Notebook goes viral By Ben Welsh June 1, 2017 First Python Notebook goes pro at NICAR17 By Ben Welsh March 12, 2017 First Python Notebook goes to college By Ben Welsh February 17, 2017 Meet the California Civic Data Coalition's NICAR scholarship winner By Ben Welsh and the California Civic Data Coalition January 30, 2017 Apply now for a free trip to NICAR17 in Jacksonville By Ben Welsh January 5, 2017 Introducing django-postgres-copy v0.1 By Ben Welsh November 14, 2016 How to analyze California campaign cash in the cloud with Apache Spark and Databricks By Bill Chambers October 24, 2016 Learn how to explore data with Python's Jupyter Notebook By Ben Welsh October 8, 2016 Meet the volunteers who improved our online archive and walked away with a free t-shirt By Ben Welsh October 4, 2016 Introducing a new bulk downloads site tracking money in California politics By James Gordon, Aaron Williams, Sahil Chinoy, Ben Welsh and the California Civic Data Coalition September 15, 2016 Meet the California Civic Data Coalition's first student developer By Ben Welsh, Cheryl Phillips, Aaron Williams and Jennifer LaFleur July 20, 2016 How to use Amazon S3's transfer acceleration with django-storages By James Gordon June 1, 2016 CAL-ACCESS app hits version 1.0 By James Gordon May 27, 2016 Join California Code Rush 4 at NICAR in Denver By Ben Welsh and James Gordon March 7, 2016 Introducing django-postgres-copy v0.0.7 By Ben Welsh February 12, 2016 New CAL-ACCESS code release offers more command options, flexibility for users By James Gordon January 25, 2016 Meet the California Civic Data Coalition's new lead developer By Ben Welsh, Cheryl Phillips, Aaron Williams and Jennifer LaFleur January 4, 2016 ONA attendees map dozens of crucial CAL-ACCESS database keys By Ben Welsh October 4, 2015 Join California Code Rush 3 at ONA15 in L.A. By Ben Welsh and Aaron Williams September 22, 2015 Volunteers finish decoding 1,400 cryptic CAL-ACCESS database fields By Ben Welsh September 1, 2015 Talk: Media Party 2015 in Buenos Aires By Ben Welsh August 27, 2015 Join California Code Rush 2 at Media Party 2015 in Buenos Aires By Ben Welsh August 18, 2015 Sacramento Bee editor agrees: CAL-ACCESS is a mess By Ben Welsh August 16, 2015 Opening: Lead developer By Ben Welsh, Cheryl Phillips, Aaron Williams and Jennifer LaFleur August 5, 2015 California Civic Data Coalition named Knight News Challenge winner By Ben Welsh, Cheryl Phillips, Aaron Williams and Jennifer LaFleur July 22, 2015 Say hello to our new open-source software for loading bulk data into PostgreSQL By Ben Welsh July 17, 2015 The 2015 CAL-ACCESS challenge By Ben Welsh, Aaron Williams and Cheryl Phillips April 16, 2015 California secretary of state refuses to open arcane data systems By Ben Welsh March 15, 2015 Lessons from the first California Code Rush By Ben Welsh and Aaron Williams March 11, 2015 Join the California Code Rush at NICAR 2015 By Ben Welsh and Aaron Williams February 26, 2015 OpenNews fellows liberate crucial California elections data By Ben Welsh February 17, 2015 New packages deploy CAL-ACCESS apps with Docker, Chef By Ben Welsh January 26, 2015 CAL-ACCESS app now supports PostgreSQL By Ben Welsh November 24, 2014 CAL-ACCESS in action By Ben Welsh October 31, 2014 Package data like software, and the stories will flow like wine By Ben Welsh, Agustin Armendariz and Aaron Williams September 24, 2014 Introducing the California Civic Data Coalition By Aaron Williams, Agustin Armendariz and Ben Welsh September 24, 2014
Introducing a new source for California elections data By James Gordon and the California Civic Data Coalition October 31, 2017
Meet the California Civic Data Coalition's NICAR scholarship winner By Ben Welsh and the California Civic Data Coalition January 30, 2017
How to analyze California campaign cash in the cloud with Apache Spark and Databricks By Bill Chambers October 24, 2016
Meet the volunteers who improved our online archive and walked away with a free t-shirt By Ben Welsh October 4, 2016
Introducing a new bulk downloads site tracking money in California politics By James Gordon, Aaron Williams, Sahil Chinoy, Ben Welsh and the California Civic Data Coalition September 15, 2016
Meet the California Civic Data Coalition's first student developer By Ben Welsh, Cheryl Phillips, Aaron Williams and Jennifer LaFleur July 20, 2016
New CAL-ACCESS code release offers more command options, flexibility for users By James Gordon January 25, 2016
Meet the California Civic Data Coalition's new lead developer By Ben Welsh, Cheryl Phillips, Aaron Williams and Jennifer LaFleur January 4, 2016
Opening: Lead developer By Ben Welsh, Cheryl Phillips, Aaron Williams and Jennifer LaFleur August 5, 2015
California Civic Data Coalition named Knight News Challenge winner By Ben Welsh, Cheryl Phillips, Aaron Williams and Jennifer LaFleur July 22, 2015
Say hello to our new open-source software for loading bulk data into PostgreSQL By Ben Welsh July 17, 2015
Package data like software, and the stories will flow like wine By Ben Welsh, Agustin Armendariz and Aaron Williams September 24, 2014
Introducing the California Civic Data Coalition By Aaron Williams, Agustin Armendariz and Ben Welsh September 24, 2014