OpenElections

Presentation notes for GNDEM 2014 workshop

Derek Willis, OpenElections

• What we're doing
• Why is this important? Context.
• Transparency in process, code and data
• Publishing results

Collecting and Standardizing Results

• Collecting at the lowest level
• The easy and hard bits
• Using standards
• Transparent specs and raw data
• Tools

Reasonable Restrictions

• The work it takes to produce data
• Privacy & timeliness
• Recognizing good faith vs the opposite, and changing topics
• Meeting with and providing feedback to election officials

More Information and Code

• Documentation
• Our Code
• Our Blog
• Election Data Spec
• Results Data Spec

Things to See

• Comparing elections
• Mississippi results analysis 1
• Mississippi results analysis 2
• OpenElections raw results demo

Tools to Use

• Tabula - Extracting data from PDF tables
• Open Civic Data IDs
• CSVKit - Useful for parsing large CSV files
• TableSplitter - Parse and OCR image PDF cells
• Google Spreadsheets Name Splitter