CaliforniaCivicData

Apply now a free trip to #NICAR17 in Jacksonville. We're offering a new scholarship! Learn more here: californiacivicdata.org/2017/01/05/nic…

🤓 #NERDERY 🤓 A new version of our PostgreSQL bulk loader for @djangoproject now supports the ON CONFLICT DO NOTHING feature. django-postgres-copy.readthedocs.io Thank you to user @berlinnovation for the idea. Syntax modeled on a recent patch to Django's bulk_create method.

It's rare to see California campaign cash put in historical context. Why? The state computer system tracking the money is a total mess. Today @ryanvmenezes made it happen by grinding ~20 years of filings from @cacivicdata's tidied up, open-source version of the database. twitter.com/latimesfirehos…

@EMLYON @aboutaaron @washingtonpost Paris!

Welcome @aboutaaron, a reporter in data analysis and #visualization for the @washingtonpost, co-founder of @cacivicdata ! Today he will show us how #data and the visulaization of it, helps us understand us ... #OpenVisConf #Datavisualization

#BREAKING: A new release of @cacivicdata's PostgreSQL bulk loader for @djangoproject with four new exporting options. …postgres-copy.californiacivicdata.org/en/latest/ These features are thanks to open-source patches from igncampa in Costa Rica! github.com/igncampa

📡 This just in 📡 @cacivicdata data downloads are now served with CORS enabled. californiacivicdata.org/2018/02/26/hel… We did it for the culture. But really mainly to have some fun at @observablehq. Check them out!

📢 #ICYMI 📢 @cacivicdata's hired gun @JE_Gordon is moving on to a new gig at @RJIFuturesLab! I interviewed him to learn more about his new role as an innovator and educator. Read all about it! californiacivicdata.org/2018/02/16/gor…

🤓 Attn: Nerds of Twitter 🤓 Check out the new @cacivicdata drop. californiacivicdata.org/2018/01/25/ind… It's an upgrade to our open-source database tool that will load your bulk data faster than ever. Let me explain.

I just released Datasette Publish - a web app that lets you upload CSVs and deploy them as a SQLite-backed browseable interface and JSON API simonwillison.net/2018/Jan/17/da…

.@ProPublica released a guide to using its #lobbying registration database for #journalists, researchers and citizens propublica.org/nerds/lobbying…

🎺 #NICAR18 update 🎺 The hands-on schedule is out. I'm teaching two: 🐍 "First Python Notebook" with @cacivicdata, @JE_Gordon, @cephillips 📊 "First Graphics Story" with @write_this_way, @emamd It's gonna be a blast. Seats are limited. Sign up today! ire.org/conferences/ni…

Thanks to @cacivicdata volunteer @rdmurphy, our PostgreSQL bulk loader now supports Django 2.0. Here's how we configured @travisci to keep testing 1.11 with Python 2.7. Your job: Upgrade and try to break it! …postgres-copy.californiacivicdata.org/en/latest/

Check it. @cacivicdata's #NICAR17 scholar @lizabio is leading the @Verge homepage rn. Her deep investigation of the potent e-cigarette lobby draws from our team's open-source database. Read all about it! californiacivicdata.org/2017/11/16/gro…

Another small landmark for our @cacivicdata project today. @JE_Gordon's open-source spec for elections data has been formally accepted by the OpenCivicData committee. Here's the spec: docs.opencivicdata.org/en/latest/prop… Here's why it matters: californiacivicdata.org/2017/10/31/pro…

@JTaylor_36 I didn't know that. Our project is entirely open source so if you want to join check us out on @GitHub.

Good morning! Today I'm excited to share the latest release from our team at the @cacivicdata. Hold on. Here it go. 1/

Thanks to @cacivicdata's wonderful volunteers, an improved version of our @postgresql bulk loader for @djangoproject …postgres-copy.californiacivicdata.org/en/latest/

Shipped a new version of @cacivicdata's import/export tool for @djangoproject with multidb support from @magnunleno …postgres-copy.californiacivicdata.org

Students in our @cacivicdata MOOC earlier this year should check this out. twitter.com/pilhofer/statu…

Export Django data faster than ever before. Use our open-source software! californiacivicdata.org/2017/09/05/dja…

One of us. One of us! ONE OF US! twitter.com/hodgesmr/statu…