## civic hacking meetup
---
22Jan2013 1830
---
*Baltimore* #opendata + + + + +
---
[OpenRefine](http://openrefine.org/index.html)!
---
Elliott Plack
@talllguy
---
*OpenRefine* is a tool originally developed by Google
---
Stable version *2.5* is still branded Google Refine
---
Get it at
[openrefine.org](http://openrefine.org/index.html)
---
*Why* use it?
---
*#opendata* is messy!
---
gov't data
---
Exported from mainframe
---
top *complaints*
* ALL CAPS
* combined columns
---
* non-standard dates
* funky lat/long
---
fix *all* these things easily!
---
what is OpenRefine?
---
runs *locally* as server
---
all input in *browser*
---
processing is *local*
---
fast
---
free
---
programmable
---
or GUI
---
live demo
---
start [here](https://data.baltimorecity.gov/Public-Safety/BPD-Arrests/3i3v-ibrt)
---
questions?