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

spikesolution / toucan-with-methodology.csv

Created October 31, 2021 10:18

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