handy OpenRefine functions for Baltimore City Arrests data mapping

bcArrestRefine.md

Convert dates to ISO 8601

value.toDate('mm/dd/yyyy').toString('yyyy-mm-dd')

Combine date / time columns

cells["arrestDate"].value + "T" + cells["arrestTime"].value + ":00-05:00"

Capitalize CDS abbrieve

value.replace('Cds','CDS')

Filter nulls out in CartoDB

SELECT * FROM bpd_arrests_talk_1 WHERE (incidentoffense_1 IS NOT NULL)

Filter white females

SELECT * FROM bpd_arrests_talk_1 WHERE sex IN ('F') AND race IN ('W')