28:null 29:["$","title",null,{"children":"EU ETS Database | Meili Vanegas-Hernandez | Observable"}] 2e:T5a6,{ let data = d3.rollup( filteredSector? granular_data.filter(d=>d.sector == filteredSector): granular_data, (v, d) => d3.sum(v, (d) => d.value), (d) => d.year, (d) => d.type ); let years = [...data.keys()].sort() let cummulated_surplus = 0 let surplus = years.map((d) => { let temp = { year: d, value: cummulated_surplus } cummulated_surplus += (data.get(d).get("free_allowances")-data.get(d).get("verified_emissions")) return temp; }); return Plot.plot({ subtitle: filteredSector? filteredSector: 'Total emissions', x: { grid: true, label: null, tickFormat: d3.format(".0f") }, y: { label: "Emissions (MtCO₂e)", tickFormat: d=>d3.format(",.0f")(d/1000000) }, marks: [ Plot.areaY(surplus, { x: 'year', y: d => d.value > 0 ? d.value: 0, fill: 'steelblue',//ategoricalScaleNames1('color_6'), curve: "monotone-x", opacity: 0.5 }), Plot.lineX(years, { x: (d) => d, y: (d) => data.get(d).get("free_allowances"), stroke: colorsEmissionsFA['free_allowances'], // curve: "monotone-x", strokeWidth: 5 }), Plot.lineX(years, { x: (d) => d, y: (d) => data.get(d).get("verified_emissions"), stroke: colorsEmissionsFA['emissions'], // curve: "monotone-x", strokeWidth: 5 }) ] }); }2f:T541,{ let totalCombustion = d3.sum(stationary2024, (d) => sectors_combustion.get(d.sector) ); return Plot.plot({ title: "2024 emissions by sector for stationary installations", color: { legend: true, domain: ["Process", "Combustion"], range: [ categoricalScaleNames1("color_3"), categoricalScaleNames1("color_6") ], tickFormat: (d) => d == "Combustion" ? "(of which combustion of fuels %)" : "Emissions" }, x: { label: "MtCO₂e", grid: true, tickFormat: (d) => d3.format(",.0f")(d / 1000000) }, marks: [ Plot.barX([1], { x: totalStationary, fill: categoricalScaleNames1("color_3") }), Plot.barX([1], { x: totalCombustion, fill: categoricalScaleNames1("color_6") }), Plot.text([1], { x: (d) => totalStationary, text: (d) => d3.format(",.0f")(totalStationary / 1000000), dx: -3, fill: "white", fontSize: 10, fontWeight: "bold", textAnchor: "end" }), Plot.text([1], { x: (d) => totalCombustion, text: (d) => d3.format(",.0%")(totalCombustion / totalStationary), dx: -3, fill: "white", fontSize: 10, fontWeight: "bold", textAnchor: "end" }) ] }); }30:T9a5,{ let _data = stationary2024.sort( (a, b) => b.verified_emissions - a.verified_emissions ); _data = _data.map((d, i) => ({ ...d, index: i })); let data = [ ..._data.map((d) => ({ ...d, verified_emissions: sectors_combustion.get(d.sector), type: "Combustion" })), ..._data.map((d) => ({ ...d, verified_emissions: d.verified_emissions - sectors_combustion.get(d.sector), type: "Process" })) ]; return Plot.plot({ marginLeft: 150, caption: "Source: European Commission, processed by CMW. Data extracted on 15 April 2026.", color: { legend: false, domain: ["Process", "Combustion"], range: [ categoricalScaleNames1("color_3"), categoricalScaleNames1("color_6") ], tickFormat: (d) => d == "Combustion" ? "(of which combustion of fuels %)" : "Emissions" }, x: { label: "MtCO₂e", grid: true, tickFormat: (d) => d3.format(",.0f")(d / 1000000) }, y: { label: null }, marks: [ Plot.barX(data, { x: "verified_emissions", y: "sector", fill: "type", channels: { sort_by: (d) => d.sector == "Other indust. emissions" ? 100 : d.index }, sort: { y: "sort_by" } }), Plot.text(stationary2024, { x: (d) => d.verified_emissions, y: "sector", dx: 3, text: (d) => `${ ["Aluminium", "Ceramics"].includes(d.sector) ? "(" + d3.format(",.0%")( sectors_combustion.get(d.sector) / d.verified_emissions ) + ") " : "" }${d3.format(",.0f")(d.verified_emissions / 1000000)}`, fill: "black", fontSize: 9, fontWeight: "bold", textAnchor: "start" }), Plot.text(stationary2024, { x: (d) => sectors_combustion.get(d.sector) + (["Power", "Chemicals", "Other indust. emissions"].includes(d.sector) ? -3000000 : 15000000), y: "sector", text: (d) => ["Aluminium", "Ceramics"].includes(d.sector) ? "" : d3.format(",.0%")( sectors_combustion.get(d.sector) / d.verified_emissions ), fill: "white", fontSize: 8, fontWeight: "bold", textAnchor: "end" }) ] }); }31:T1586,{ return html`

Emissions by sector

${stationary2024.map( (row) => html`` )}

Sector	Percentage of emissions (2024)	2024 emissions (MtCO₂e)	of which combustion (%)	Emissions reductions since 2013	Total emissions (MtCO₂e) Phase 3 (2013-2020)	Total emissions (MtCO₂e) Phase 4 (2021-2024)
${row["sector"]}	${d3.format(",.0%")( row["verified_emissions"] / totalEm2024 )}	${d3.format(",.0f")( row["verified_emissions"] / 1000000 )}	${d3.format(",.0%")( sectors_combustion.get(row["sector"]) / row["verified_emissions"] )}	${ historicalGroupData.get(2013).get(row.sector) ? d3.format(",.0%")( 1 - row["verified_emissions"] / historicalGroupData.get(2013).get(row.sector) .verified_emissions ) : "NA" }	${d3.format(",.0f")( d3.sum( stationaryPhase3.filter((d) => d.sector == row.sector), (d) => d.verified_emissions ) / 1000000 )}	${d3.format(",.0f")( d3.sum( stationaryPhase4.filter((d) => d.sector == row.sector), (d) => d.verified_emissions ) / 1000000 )}
Total Stationary	${d3.format(",.0%")( d3.sum(stationary2024, (d) => d.verified_emissions) / totalEm2024 )}	${d3.format(",.0f")( d3.sum(stationary2024, (d) => d.verified_emissions) / 1000000 )}	${d3.format(",.0%")( d3.sum(sectors_combustion.values(), (d) => d) / d3.sum(stationary2024, (d) => d.verified_emissions) )}	${d3.format(",.0%")( d3.sum(stationary2024, (d) => d.verified_emissions) / d3.sum( stationaryPhase3.filter((d) => d.year == 2013), (d) => d.verified_emissions ) )}	${d3.format(",.0f")( d3.sum(stationaryPhase3, (d) => d.verified_emissions) / 1000000 )}	${d3.format(",.0f")( d3.sum(stationaryPhase4, (d) => d.verified_emissions) / 1000000 )}
Aviation	${d3.format(",.0%")( historicalGroupData.get(2024).get("Aviation").verified_emissions / totalEm2024 )}	${d3.format(",.0f")( historicalGroupData.get(2024).get("Aviation").verified_emissions / 1000000 )}	NA	${d3.format(",.0%")( 1 - historicalGroupData.get(2024).get("Aviation").verified_emissions / historicalGroupData.get(2013).get("Aviation").verified_emissions )}	${d3.format(",.0f")( d3.sum( allPhase3.filter((d) => d.sector == "Aviation"), (d) => d.verified_emissions ) / 1000000 )}	${d3.format(",.0f")( d3.sum( allPhase4.filter((d) => d.sector == "Aviation"), (d) => d.verified_emissions ) / 1000000 )}
Maritime	${d3.format(",.0%")( historicalGroupData.get(2024).get("Maritime").verified_emissions / totalEm2024 )}	${d3.format(",.0f")( historicalGroupData.get(2024).get("Maritime").verified_emissions / 1000000 )}	NA	NA	0	${d3.format(",.0f")( d3.sum( allPhase4.filter((d) => d.sector == "Maritime"), (d) => d.verified_emissions ) / 1000000 )}
Total	${d3.format(",.0%")(1)}	${d3.format(",.0f")( totalEm2024 / 1000000 )}	${d3.format(",.0%")( d3.sum(sectors_combustion.values(), (d) => d) / totalEm2024 )}	${d3.format(",.0%")( totalEm2024 / d3.sum( historical_sector_trend.filter((d) => d.year == 2013), (d) => d.verified_emissions ) )}	${d3.format(",.0f")( d3.sum(allPhase3, (d) => d.verified_emissions) / 1000000 )}	${d3.format(",.0f")( d3.sum(allPhase4, (d) => d.verified_emissions) / 1000000 )}

`; }32:T1bdb,{ let totalFA2024 = d3.sum(sectors2024, (d) => d.free_allowances); return html`

Free allowances by sector

${stationary2024.map( (row) => html` ` )}

Sector	2024 free allowances (in M)	Free allowances vs. Emissions (2024)	Average free allowances vs. emissions Phase 3	Average free allowances vs. emissions Phase 4	Estimated value of free allowances, 2013–2024 (€bn)
${row["sector"]}	${d3.format(",.0f")( row["free_allowances"] / 1000000 )}	${d3.format(",.0%")( row["free_allowances"] / row["verified_emissions"] )}	${d3.format(",.0%")( d3.sum( stationaryPhase3.filter((e) => e.sector == row.sector), (d) => d.free_allowances ) / d3.sum( stationaryPhase3.filter((d) => row.sector == d.sector), (d) => d.verified_emissions ) )}	${d3.format(",.0%")( d3.sum( stationaryPhase4.filter((d) => row.sector == d.sector), (d) => d.free_allowances ) / d3.sum( stationaryPhase4.filter((d) => row.sector == d.sector), (d) => d.verified_emissions ) )}	${d3.format(",.0f")( d3.sum( [...Array(12)].map((_, i) => { return ( d3.sum( historical_sector_trend.filter( (d) => d.year == i + 2013 && d.sector == row.sector ), (d) => d.free_allowances ) * eua_avg_price.get(i + 2013) ); }) ) / 1000000000 )}
Total Stationary	${d3.format(",.0f")( d3.sum(stationary2024, (d) => d.free_allowances) / 1000000 )}	${d3.format(",.0%")( d3.sum(stationary2024, (d) => d.free_allowances) / d3.sum(stationary2024, (d) => d.verified_emissions) )}	${d3.format(",.0%")( d3.sum(stationaryPhase3, (v) => v.free_allowances) / d3.sum(stationaryPhase3, (v) => v.verified_emissions) )}	${d3.format(",.0%")( d3.sum(stationaryPhase4, (v) => v.free_allowances) / d3.sum(stationaryPhase4, (v) => v.verified_emissions) )}	${d3.format(",.0f")( d3.sum( [...Array(12)].map((_, i) => { return ( d3.sum( historical_sector_trend.filter( (d) => d.year == i + 2013 && !transport.includes(d.sector) ), (d) => d.free_allowances ) * eua_avg_price.get(i + 2013) ); }) ) / 1000000000 )}
Aviation	${d3.format(",.0f")( historicalGroupData.get(2024).get("Aviation").free_allowances / 1000000 )}	${d3.format(",.0%")( historicalGroupData.get(2024).get("Aviation").free_allowances / historicalGroupData.get(2024).get("Aviation").verified_emissions )}	${d3.format(",.0%")( d3.sum( allPhase3.filter((d) => d.sector == "Aviation"), (d) => d.free_allowances ) / d3.sum( allPhase3.filter((d) => d.sector == "Aviation"), (d) => d.verified_emissions ) )}	${d3.format(",.0%")( d3.sum( allPhase4.filter((d) => d.sector == "Aviation"), (d) => d.free_allowances ) / d3.sum( allPhase4.filter((d) => d.sector == "Aviation"), (d) => d.verified_emissions ) )}	${d3.format(",.0f")( d3.sum( [...Array(12)].map((_, i) => { return ( d3.sum( historical_sector_trend.filter( (d) => d.year == i + 2013 && d.sector == "Aviation" ), (d) => d.free_allowances ) * eua_avg_price.get(i + 2013) ); }) ) / 1000000000 )}
Maritime	${d3.format(",.0f")( historicalGroupData.get(2024).get("Maritime").free_allowances / 1000000 )}	${d3.format(",.0%")( historicalGroupData.get(2024).get("Maritime").free_allowances / historicalGroupData.get(2024).get("Maritime").verified_emissions )}	0	${d3.format(",.0f")( d3.sum( allPhase4.filter((d) => d.sector == "Maritime"), (d) => d.free_allowances ) / d3.sum( allPhase4.filter((d) => d.sector == "Maritime"), (d) => d.verified_emissions ) )}	${d3.format(",.0f")( d3.sum( [...Array(12)].map((_, i) => { return ( d3.sum( historical_sector_trend.filter( (d) => d.year == i + 2013 && d.sector == "Maritime" ), (d) => d.free_allowances ) * eua_avg_price.get(i + 2013) ); }) ) / 1000000000 )}
Total	${d3.format(",.0f")( totalFA2024 / 1000000 )}	${d3.format(",.0%")( totalFA2024 / totalEm2024 )}	${d3.format(",.0%")( d3.sum(allPhase3, (d) => d.free_allowances) / d3.sum(allPhase3, (d) => d.verified_emissions) )}	${d3.format(",.0f")( d3.sum(allPhase4, (d) => d.free_allowances) / d3.sum(allPhase4, (d) => d.verified_emissions) )}	${d3.format(",.0f")( d3.sum( [...Array(12)].map((_, i) => { return ( d3.sum( historical_sector_trend.filter((d) => d.year == i + 2013), (d) => d.free_allowances ) * eua_avg_price.get(i + 2013) ); }) ) / 1000000000 )}

`; }33:[{"id":"6a5a8cbdb246cd58006385f7476942ee0b2f47d26c64729b5e1995fc96630acbd6d1bf03eaf40708165cfe3cfd1f27344b6212702fa47bd59749bbbba9b019f4","href":"https://static.observableusercontent.com/files/6a5a8cbdb246cd58006385f7476942ee0b2f47d26c64729b5e1995fc96630acbd6d1bf03eaf40708165cfe3cfd1f27344b6212702fa47bd59749bbbba9b019f4","name":"eua_price.csv","type":"text/csv","lastModified":1787741200441.444,"size":412},{"id":"a0c257fbca97e232a4cd45bd67b4db3421229901464bbd089a09e254144ef0e799fa702a771b6da2c3e7cfe1a4002077d8fe575d9399f06fcc0242f63ace057d","href":"https://static.observableusercontent.com/files/a0c257fbca97e232a4cd45bd67b4db3421229901464bbd089a09e254144ef0e799fa702a771b6da2c3e7cfe1a4002077d8fe575d9399f06fcc0242f63ace057d","name":"eu_emissions_target_2040@1.csv","type":"text/csv","lastModified":1788180715250.465,"size":2581},{"id":"acc046371715bd6845270db3b1e1940566998a0f81e616c5d35582f9d222eb8c43568599fdb9ac84756a6f38c56084f1c0c313caf091d773ec9077e26c3d7dab","href":"https://static.observableusercontent.com/files/acc046371715bd6845270db3b1e1940566998a0f81e616c5d35582f9d222eb8c43568599fdb9ac84756a6f38c56084f1c0c313caf091d773ec9077e26c3d7dab","name":"eu_emissions_target_2040@2.csv","type":"text/csv","lastModified":1788181758232.94,"size":2719},{"id":"c27ad979c76f0a09c186617edaa33a7ab1a6ce3b9b918b9337754a51ccbfecc9d931dedce553c5d45425ac207e5652ef1778a8ca0fe43889c78fb8e78060978b","href":"https://static.observableusercontent.com/files/c27ad979c76f0a09c186617edaa33a7ab1a6ce3b9b918b9337754a51ccbfecc9d931dedce553c5d45425ac207e5652ef1778a8ca0fe43889c78fb8e78060978b","name":"eu_emissions_target_2040@3.csv","type":"text/csv","lastModified":1788183220682.169,"size":3066},{"id":"cd9de57aa438be08593be0a62eb60eb61880aa9b4434823e30987969680188ca01e3d020d24d6382ee6e05b95063557ad80a2393a4c216bb9b7714483b96b134","href":"https://static.observableusercontent.com/files/cd9de57aa438be08593be0a62eb60eb61880aa9b4434823e30987969680188ca01e3d020d24d6382ee6e05b95063557ad80a2393a4c216bb9b7714483b96b134","name":"eu_emissions_target_2040@4.csv","type":"text/csv","lastModified":1788183494115.696,"size":3411},{"id":"0ba3354e4f578ec3bb28b4034cf119670c9c981ba0c7ef1c6b509eaf56edc10c2092739710fb23f8cdc43ea4eecab25251f6a485e1146c342d30ecc2b3a94e7c","href":"https://static.observableusercontent.com/files/0ba3354e4f578ec3bb28b4034cf119670c9c981ba0c7ef1c6b509eaf56edc10c2092739710fb23f8cdc43ea4eecab25251f6a485e1146c342d30ecc2b3a94e7c","name":"eu_emissions_target_2040.csv","type":"text/csv","lastModified":1788178911186.578,"size":2581},{"id":"72f36e3a2ee0214b3ebbbcc3d50df13160ff9fd278472ee7a157686999b4ee9a9d0a80059aa8989984caba468214f0f98737337f8c8954314b7b45d24d777d52","href":"https://static.observableusercontent.com/files/72f36e3a2ee0214b3ebbbcc3d50df13160ff9fd278472ee7a157686999b4ee9a9d0a80059aa8989984caba468214f0f98737337f8c8954314b7b45d24d777d52","name":"granular_data.csv","type":"text/csv","lastModified":1787756811805.642,"size":15796007},{"id":"7a37696e973b4d1c671d95523828ea615e7758d9f28bd1feed73b2c5cd1b934af890e05ea28c45ac090b63ba66c836ede20db9f324ce687f0988e2d3b42e7fbe","href":"https://static.observableusercontent.com/files/7a37696e973b4d1c671d95523828ea615e7758d9f28bd1feed73b2c5cd1b934af890e05ea28c45ac090b63ba66c836ede20db9f324ce687f0988e2d3b42e7fbe","name":"historical_sector_trend.csv","type":"text/csv","lastModified":1787741200441.444,"size":8375},{"id":"f54bcb76574ab8d98f482a1ad9013870e150b06da2e0b526e869c0838519049bd4922a2e7c744a0dcfaab9d216df58cd054fcfef8ebb43a0c691ce61cfddcb6a","href":"https://static.observableusercontent.com/files/f54bcb76574ab8d98f482a1ad9013870e150b06da2e0b526e869c0838519049bd4922a2e7c744a0dcfaab9d216df58cd054fcfef8ebb43a0c691ce61cfddcb6a","name":"industrial_sector_emissions_2024@1.json","type":"application/json","lastModified":1787741200441.444,"size":1983},{"id":"8bdac54f5ccc809c151558be07b6dcbd2ebfa8274f43c8f881193f30bc2aa0104b44ff0a1b4643aa3f4b25d58f38168f506f8f8d132d906614611aecddcb0252","href":"https://static.observableusercontent.com/files/8bdac54f5ccc809c151558be07b6dcbd2ebfa8274f43c8f881193f30bc2aa0104b44ff0a1b4643aa3f4b25d58f38168f506f8f8d132d906614611aecddcb0252","name":"industrial_sector_emissions_2024.csv","type":"text/csv","lastModified":1787741200441.444,"size":807},{"id":"1baec9cd1c642c098962a63eab6275e40bda7cacaa52a9d6162c75d7b7df2f3801d87b2c08201ba28f395070a1f9ee9307eccab0c93e18a732522c8ca2c0fcef","href":"https://static.observableusercontent.com/files/1baec9cd1c642c098962a63eab6275e40bda7cacaa52a9d6162c75d7b7df2f3801d87b2c08201ba28f395070a1f9ee9307eccab0c93e18a732522c8ca2c0fcef","name":"owners_2024.csv","type":"text/csv","lastModified":1789454035503,"size":578301},{"id":"e7b8cf2707821ed652f9771c76936bdbd588afc6ce6e4e3f8a713cdcad1943b1a25a2c1ae264f951d71c05170c52f364e1120efef0cbef41270b92892e2292e3","href":"https://static.observableusercontent.com/files/e7b8cf2707821ed652f9771c76936bdbd588afc6ce6e4e3f8a713cdcad1943b1a25a2c1ae264f951d71c05170c52f364e1120efef0cbef41270b92892e2292e3","name":"sectors_combustion@1.csv","type":"text/csv","lastModified":1787741200441.444,"size":407}] 2c:{"id":"f00493951295c229","slug":"eu-ets-database","title":"EU ETS Database","thumbnail":null,"access_level":"public","create_time":"$D2026-09-24T15:07:25.743Z","update_time":"$D2026-09-24T15:35:00.846Z","view_time":null,"first_public_time":"$D2026-09-24T15:07:53.260Z","has_unpublished_edits":null,"fork":true,"stars":0,"starred":false,"owner":{"type":"team","id":"7e421362d6355592","login":"meilivh","name":"Meili Vanegas-Hernandez","avatar_url":"https://avatars-next.observableusercontent.com/65fb99c719a764c44bbfab2b29aebc3a656d4d7555acc712e1a1a379bc5849fb","tier":"starter_2024"},"version":1666,"publish_version":1666,"role":null,"authored":false,"authors":[{"type":"individual","id":"1eeec6caba8cf3b9","login":"meilivh","name":"Meili Vanegas-Hernandez","avatar_url":"https://avatars-next.observableusercontent.com/c39e2af6a77192324fc005b266944cfdbe7d008610a81905c77831fdd4e122b1","tier":null}],"members":[{"type":"team","id":"7e421362d6355592","login":"meilivh","name":"Meili Vanegas-Hernandez","avatar_url":"https://avatars-next.observableusercontent.com/65fb99c719a764c44bbfab2b29aebc3a656d4d7555acc712e1a1a379bc5849fb","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"EU ETS Database","cells":[{"id":0,"value":"# EU ETS Database","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1406,"value":"france_groups = {\n let data = granular_data.map(d => ({'country': d.installation_id.substring(0,2),...d, owner_name: owners_2024[d.installation_id]})).filter(d => d.year == 2024 && d.country == 'FR' && d.type == 'free_allowances');\n return d3.rollup(data, (v,d) => d3.sum(v, d => d.value), d => d.owner_name, d => d.country);\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1409,"value":"display(Inputs.table(france_groups.values()))","pinned":true,"hidden":false,"mode":"js","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1400,"value":"viewof filteredSector = Inputs.select([null].concat(allSectors), {label: \"Sector\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1410,"value":"viewof filteredCountry = Inputs.select([null].concat(allCountries), {label: \"Country\"})","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1405,"value":"Swatches(d3.scaleOrdinal(['Emissions','Free allowances', 'Surplus'],[colorsEmissionsFA['emissions'],colorsEmissionsFA['free_allowances'], '#a8bed8']))","pinned":false,"hidden":false,"mode":"js","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1315,"value":"$2e","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1261,"value":"$2f","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1159,"value":"$30","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":712,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":820,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":841,"value":"----","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":5,"value":"style = html`\n\n\n\n\n\n\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":835,"value":"-----","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1396,"value":"## Useful links","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1411,"value":"* [EEA ETS Data Viewer](https://www.eea.europa.eu/en/analysis/maps-and-charts/emissions-trading-viewer-1-dashboards)\n\nDashboard presenting **emissions**, **free allowances**, and **surrendered units**.\n\nData aggregated by country and activity type (without attribution of combustion).","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1412,"value":"* [Bruegel ETS Tracker](https://ets.bruegel.org/)\n\n\n1. Overview section:\n\n a. Presents emissions by sector* and country\n\n b. Allowances (auctioned and FA) for total stationary installations\n\n c. Auction revenues by country and fund\n\n d. EUA price\n\n4. Map section: Shows emissions by installation. You can filter by sector*, year and country. Nice feature: when clicking on the map, it takes you to the installation-detail view, described below.\n5. Account details (no company name), address and emissions, surrendered allowances and FA per year.\n\n\\* *Without attribution of combustion and classifying only 4 most relevant industrial sectors.*","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":27,"value":"# Data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":875,"value":"eua_avg_price = {\n let data = await FileAttachment(\"eua_price.csv\").csv({ typed: true });\n return d3.rollup(\n data,\n (v, d) => d3.sum(v, (d) => d.avg_price),\n (d) => d.year\n );\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":519,"value":"## Sectors","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1140,"value":"sectors_combustion = {\n let data = await FileAttachment(\"sectors_combustion@1.csv\").csv({\n typed: true\n });\n return d3.rollup(\n data,\n (v, d) => d3.sum(v, (d) => d.combustion),\n (d) => d.sector\n );\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":521,"value":"stationary_json = FileAttachment(\"industrial_sector_emissions_2024@1.json\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":567,"value":"stationary_emissions_24 = FileAttachment(\n \"industrial_sector_emissions_2024.csv\"\n).csv({ typed: true })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":573,"value":"stationaryGroups = d3.rollup(\n stationary_emissions_24,\n (v, d) => d3.sum(v, (d) => d.value),\n (d) => d.group\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":576,"value":"totalStationary = d3.sum(stationary_emissions_24, (d) => d.value)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":609,"value":"sortedSectors = {\n return [...stationaryGroups.keys()].sort(\n (a, b) => stationaryGroups.get(a) - stationaryGroups.get(b)\n );\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":606,"value":"historical_sector_trend = FileAttachment(\"historical_sector_trend.csv\").csv({\n typed: true\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":735,"value":"historicalGroupData = d3.rollup(\n historical_sector_trend,\n (v, d) =>\n Object.fromEntries(\n [\"verified_emissions\", \"free_allowances\"].map((col) => [\n col,\n d3.sum(v, (d) => +d[col])\n ])\n ),\n (d) => d.year,\n (d) => d.sector\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":914,"value":"transport = [\"Aviation\", \"Maritime\"]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":920,"value":"sectors2024 = {\n let data = historical_sector_trend.filter((d) => d.year == 2024);\n return data.sort((a, b) => b.verified_emissions - a.verified_emissions);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":971,"value":"allPhase3 = historical_sector_trend.filter(\n (d) => d.year >= 2013 && d.year < 2021\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":974,"value":"allPhase4 = historical_sector_trend.filter(\n (d) => d.year >= 2021 && d.year < 2025\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":929,"value":"stationaryPhase3 = historical_sector_trend.filter(\n (d) => !transport.includes(d.sector) && d.year >= 2013 && d.year < 2021\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":932,"value":"stationaryPhase4 = historical_sector_trend.filter(\n (d) => !transport.includes(d.sector) && d.year >= 2021 && d.year < 2025\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":949,"value":"stationary2024 = sectors2024.filter((d) => !transport.includes(d.sector))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1017,"value":"totalEm2024 = d3.sum(sectors2024, (d) => d.verified_emissions)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1309,"value":"## Granular data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1402,"value":"allSectors = [...new Set([...granular_data.map(d=>d.sector)])]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1312,"value":"granular_data = FileAttachment(\"granular_data.csv\").csv({ typed: true })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1407,"value":"owners_2024 = {\n let data = await FileAttachment(\"owners_2024.csv\").csv({typed: \"auto\"});\n let owners = {};\n data.map(d => owners[d['installation_id']] = d.owner_name)\n return owners;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":11,"value":"# Imports","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":13,"value":"import {\n categoricalScaleNames1,\n strippedDefs,\n colorsEmissionsFA\n} from \"@meilivh/carbon-market-watch-colour-scales\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1404,"value":"import {Swatches} from \"@d3/color-legend\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W33","stdlib":"1","titling":"auto"}} 2d:"$2c:body"