Skip to content

Instantly share code, notes, and snippets.

We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 3.
"Issuance Date","Vintage Start","Vintage End","ID","Name","Country","Project Type","Methodology","Total Vintage Quantity","Credits Quantity Issued","Serial Number","Additional Certifications","Retirement/Cancellation Date","Retirement Beneficiary","Retirement Reason","Retirement Details"
"21/10/2021","01/04/2016","31/12/2016","493","5 MW Brahm Ganga Hydro – Electric Project at Kullu district of Himachal Pradesh, India","India","Energy industries (renewable/non-renewable sources)","Grid connected renewable electricity generation","17,058","17,058","11522-337737512-337754569-VCS-VCU-291-VER-IN-1-493-01042016-31122016-0","","27/10/2021","0x00000016F127c94A667Ae3C9fDF0C31c9C79826f","Other","TOUCAN-1.0-137-0x293c24f8dedbd5e6a881cfdef111806449dcf71c7fca95d458a920efeec10c9d-481"
"21/10/2021","01/01/2017","31/12/2017","535","78 MW AKOCAK Hydroelectric Power Plant","Turkey","Energy industries (renewable/non-renewable sources)","Grid-connected electricity generation from renewable sources","106,299","28,580","11543-338
@spikesolution
spikesolution / get-toucan-csv.sh
Last active September 21, 2024 01:17
Shell script to download Verra Registry CSV data for Toucan-retired carbon offsets
#!/bin/bash
# Script to download Toucan-retired VCU data from the Verra Registry.
# The Verra API does not allow filtering on the value of "Retirement reason",
# so we have to download CSV data for all "retired" VCUs, and then filter
# those to get ones which mention the string 'TOUCAN'.
#
# NB: The string 'TOUCAN' appears at the start of the "Retirement reason" column
# for projects which were retired via the Toucan Bridge. However, if the
# same string appears in any other column, for unrelated reasons, that data