Skip to content

Instantly share code, notes, and snippets.

@neilhawkins
Created February 18, 2018 18:36
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save neilhawkins/cfb850a11cdbf3b2ce0a99f50563d04a to your computer and use it in GitHub Desktop.
Save neilhawkins/cfb850a11cdbf3b2ce0a99f50563d04a to your computer and use it in GitHub Desktop.
Open Refine export template for UK Electoral Commission data
{"ec_ref" : {{jsonize(cells["ECRef"].value)}},"regulated_entity_name" : {{jsonize(cells["RegulatedEntityName"].value)}},"regulated_entity_type" : {{jsonize(cells["RegulatedEntityType"].value)}},"value" : {{jsonize(cells["Value"].value)}},"accepted_date" : {{jsonize(cells["AcceptedDate"].value)}},"accounting_unit_name" : {{jsonize(cells["AccountingUnitName"].value)}},"donor_name" : {{jsonize(cells["DonorName"].value)}},"accounting_units_as_central_party" : {{jsonize(cells["AccountingUnitsAsCentralParty"].value)}},"is_sponsorship" : {{jsonize(cells["IsSponsorship"].value)}},"donor_status" : {{jsonize(cells["DonorStatus"].value)}},"regulated_donee_type" : {{jsonize(cells["RegulatedDoneeType"].value)}},"company_registration_number" : {{jsonize(cells["CompanyRegistrationNumber"].value)}},"postcode" : {{jsonize(cells["Postcode"].value)}},"donation_type" : {{jsonize(cells["DonationType"].value)}},"nature_of_donation" : {{jsonize(cells["NatureOfDonation"].value)}},"purpose_of_visit" : {{jsonize(cells["PurposeOfVisit"].value)}},"donation_action" : {{jsonize(cells["DonationAction"].value)}},"received_date" : {{jsonize(cells["ReceivedDate"].value)}},"reported_date" : {{jsonize(cells["ReportedDate"].value)}},"is_reported_pre_poll" : {{jsonize(cells["IsReportedPrePoll"].value)}},"reporting_period_name" : {{jsonize(cells["ReportingPeriodName"].value)}},"is_bequest" : {{jsonize(cells["IsBequest"].value)}},"is_aggregation" : {{jsonize(cells["IsAggregation"].value)}},"regulated_entity_id" : {{jsonize(cells["RegulatedEntityId"].value)}},"accounting_unit_id" : {{jsonize(cells["AccountingUnitId"].value)}},"donor_id" : {{jsonize(cells["DonorId"].value)}},"campaigning_name" : {{jsonize(cells["CampaigningName"].value)}}}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment