CaliforniaCivicData

An open-source team of journalists and computer programmers from news organizations across America

[CaliforniaCivicData @cacivicdata]

Apply now a free trip to #NICAR17 in Jacksonville. We're offering a new scholarship! Learn more here: https://t.co/4W2cfFvUIr

[Ben Welsh @palewire]

🤓 #NERDERY 🤓

A new version of our PostgreSQL bulk loader for @djangoproject now supports the ON CONFLICT DO NOTHING feature.

https://t.co/ITzHSQrwxI

Thank you to user @berlinnovation for the idea.

Syntax modeled on a recent patch to Django's bulk_create method.

[Ben Welsh @palewire]

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. https://t.co/W12LpxXCYr

[CaliforniaCivicData @cacivicdata]

@EMLYON @aboutaaron @washingtonpost Paris!

[Ben Welsh @palewire]

#BREAKING: A new release of @cacivicdata's PostgreSQL bulk loader for @djangoproject with four new exporting options. https://t.co/j9nRtJeRnL

These features are thanks to open-source patches from igncampa in Costa Rica! https://t.co/phHdVGQrWa

[Ben Welsh @palewire]

📡 This just in 📡

@cacivicdata data downloads are now served with CORS enabled.

https://t.co/TO5HOliYra

We did it for the culture. But really mainly to have some fun at @observablehq. Check them out!

[Ben Welsh @palewire]

📢 #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!

https://t.co/4GxO4ewLOO

[Ben Welsh @palewire]

🤓 Attn: Nerds of Twitter 🤓

Check out the new @cacivicdata drop.

https://t.co/QHVKELZfeE

It's an upgrade to our open-source database tool that will load your bulk data faster than ever.

Let me explain.

[Simon Willison @simonw]

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
https://t.co/ByPs7eFmPC

[Liza Gross @lizabio]

.@ProPublica released a guide to using its #lobbying registration database for #journalists, researchers and citizens https://t.co/1RlET2L0ts

[Ben Welsh @palewire]

🎺 #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! https://t.co/6hIEZ9wOU1

[Ben Welsh @palewire]

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! https://t.co/j9nRtJeRnL

[Ben Welsh @palewire]

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!

https://t.co/Y7oapBFung

[Ben Welsh @palewire]

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: https://t.co/Y53DX0MxEg

Here's why it matters: https://t.co/HgDXXOWdhd

[CaliforniaCivicData @cacivicdata]

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

[Ben Welsh @palewire]

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

[Ben Welsh @palewire]

Thanks to @cacivicdata's wonderful volunteers, an improved version of our @postgresql bulk loader for @djangoproject https://t.co/j9nRtJeRnL

[Ben Welsh @palewire]

Shipped a new version of @cacivicdata's import/export tool for @djangoproject with multidb support from @magnunleno https://t.co/bYXMPkEdK8

[Ben Welsh @palewire]

Students in our @cacivicdata MOOC earlier this year should check this out. https://t.co/gGkoHz0z8l

[CaliforniaCivicData @cacivicdata]

Export Django data faster than ever before. Use our open-source software! https://t.co/MbJAQihcPI

[CaliforniaCivicData @cacivicdata]

One of us. One of us! ONE OF US! https://t.co/bsTjNrWQan