{"id":24514,"date":"2023-12-12T21:27:22","date_gmt":"2023-12-12T20:27:22","guid":{"rendered":"https:\/\/www.graviton.at\/letterswaplibrary\/ets-compliance-data-in-useable-format\/"},"modified":"2023-12-12T21:27:22","modified_gmt":"2023-12-12T20:27:22","slug":"ets-compliance-data-in-useable-format","status":"publish","type":"post","link":"https:\/\/www.graviton.at\/letterswaplibrary\/ets-compliance-data-in-useable-format\/","title":{"rendered":"ETS Compliance Data In Useable Format?"},"content":{"rendered":"<p><!-- SC_OFF --><\/p>\n<div class=\"md\">\n<p>I would like to have a panel dataset with for each year the ETS system existed:<br \/> &#8211; all firms that handed in too little ETS rights for their emissions<br \/> &#8211; the number of EST rights they were short<br \/> &#8211; (nice to have: sector and country)<\/p>\n<p>This data is available at <a href=\"https:\/\/ec.europa.eu\/clima\/ets\/allocationComplianceMgt.do?languageCode=en\">https:\/\/ec.europa.eu\/clima\/ets\/allocationComplianceMgt.do?languageCode=en<\/a>, but the format is really poor. To create a panel, I would need to select each country individually, select years one by one, export the compliance data and add all resulting csv files together. Using a webscrapper this should be doable maybe, but I haven&#8217;t done that before. <\/p>\n<p>Companies not handing in enough ETS (and hence being fined) are identified by compliance status &#8220;B&#8221;. The number of rights they are short can be calculated based on the tables too.<\/p>\n<p>My question is if anybody maybe knows if there is a more accessible version of this data available online. Or maybe someone already scrapped the database? Any leads are appreciated. <\/p>\n<\/div>\n<p><!-- SC_ON -->   submitted by   <a href=\"https:\/\/www.reddit.com\/user\/AtkinsonStiglitz\"> \/u\/AtkinsonStiglitz <\/a> <br \/> <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/18guxra\/ets_compliance_data_in_useable_format\/\">[link]<\/a><\/span>   <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/18guxra\/ets_compliance_data_in_useable_format\/\">[comments]<\/a><\/span><\/p><div class='watch-action'><div class='watch-position align-right'><div class='action-like'><a class='lbg-style1 like-24514 jlk' href='javascript:void(0)' data-task='like' data-post_id='24514' data-nonce='65e0e39b87' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.graviton.at\/letterswaplibrary\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-24514 lc'>0<\/span><\/a><\/div><\/div> <div class='status-24514 status align-right'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>I would like to have a panel dataset with for each year the ETS system existed: &#8211;&#8230;<\/p>\n","protected":false},"author":0,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[85],"tags":[],"class_list":["post-24514","post","type-post","status-publish","format-standard","hentry","category-datatards","wpcat-85-id"],"_links":{"self":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/24514","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/types\/post"}],"replies":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/comments?post=24514"}],"version-history":[{"count":0,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/24514\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/media?parent=24514"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/categories?post=24514"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/tags?post=24514"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}