extract_csv_from_vumi_contacts.py

import io, json, pprint, csv
import dateutil.parser

with open('output_something_interesting.csv', 'w') as csvfile:
    fieldnames = ['encdate']
    writer = csv.DictWriter(csvfile, fieldnames=fieldnames)
    writer.writeheader()
    with io.open('vumi_account_contacts.json', 'r', encoding='utf-8') as f:
        for line in f:
            parsed = json.loads(line)
            if "is_registered_by" in parsed["extra"] and parsed["extra"]["is_registered_by"] == "clinic":
                output = {
                    'encdate': dateutil.parser.parse(parsed["created_at"]).strftime("%Y%m%d%H%M%S"),
                }
                writer.writerow(output)