3f:null 40:["$","title",null,{"children":"EU ETS Database | Meili Vanegas-Hernandez | Observable"}] 46:T64d,{ let group = 'sector'; let baselineData = filteredData.filter(d => d.year == baselineYear) if (filteredSector) group = 'company' const groups = d3.rollup( baselineData.filter(d => d.type == 'verified_emissions'), v => d3.sum(v, d => d.value), d => d[group] ); const groups_fa = d3.rollup( baselineData.filter(d => d.type == 'free_allowances'), v => d3.sum(v, d => d.value), d => d[group] ); const sorted = Array.from(groups).sort((a, b) => d3.descending(a[1], b[1])); const top = sorted.slice(0, 20); const rest = sorted.slice(20); const children = top.map(([name, size]) => ({name: name || 'Unknown', size})); if (rest.length) children.push({name: 'Other', size: d3.sum(rest, d => d[1])}); const palette = categoricalScaleNames1.range(); const names = children.map(d => d.name); const colors = children.map(d => d.name === 'Other' ? 'lightgrey' : palette[names.indexOf(d.name) % palette.length] ); const data = { name: `${group.slice(0, 1).toUpperCase()}${group.slice(1)}`, children }; return html`

${baselineYear} Emissions by ${group} (tCO₂e)

${Treemap(data, { value: d => d.size, group: (d, n) => d.name, label: (d, n) => [...d.name.split(" "), `${formatNumber(d.size)} emissions`, `${formatNumber(groups_fa.get(d.name))} free allowances`].join("\n"), title: (d, n) => [...d.name.split(" "), d3.format(',.0f')(d.size)].join("\n"), zDomain: names, colors, width: 1000, height: 400 })}`; }47: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" }) ] }); }48: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" }) ] }); }49: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 )}

`; }4a: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 )}

`; }4b:T815,### For historic data * [EEA ETS Data Viewer](https://www.eea.europa.eu/en/analysis/maps-and-charts/emissions-trading-viewer-1-dashboards) Dashboard presenting **emissions**, **free allowances**, and **surrendered units**. Data aggregated by country and activity type (without attribution of combustion). * [GHG emissions under the ETS](https://www.eea.europa.eu/en/analysis/indicators/greenhouse-gas-emissions-under-the) Historical and projected emissions from installations covered by the EU Emissions Trading System in the European Economic Area (overview). * [Use of auctioning revenues generated by the ETS](https://www.eea.europa.eu/en/analysis/indicators/use-of-auctioning-revenues-generated) Auctioning revenues and reported usage by member state. * [EUETS Info](https://www.euets.info/) Open-data platform mirroring the Union Registry data portal. * [Bruegel ETS Tracker](https://ets.bruegel.org/) 1. Overview section: a. Presents emissions by sector* and country b. Allowances (auctioned and FA) for total stationary installations c. Auction revenues by country and fund d. EUA price 4. 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. 5. Account details (no company name), address and emissions, surrendered allowances and FA per year. \* *Without attribution of combustion and classifying only 4 most relevant industrial sectors.* * [Carbon Pulse - EU ETS Portal](https://carbon-pulse.com/eu-ets-portal/) a. Market data: Tracks EUA prices and trading volumes from major exchanges like ICE and EEX. b. Emissions tracking: Follows annual compliance emissions across various industrial sectors. c. Allocations: Monitors auctions and FA broken down by country and sector. d. Power generation: Integrates monthly electricity generation statistics categorised by source. e. Policy & reform: Highlights reform timelines, analyst forecasts, and member state regulatory positions.4c:T8d8,emi_vs_fa = { let title = 'Emissions vs. Free allowances'; let data = d3.rollup( filteredData, (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 html`${Swatches(d3.scaleOrdinal(['Emissions','Free allowances'],[colorsEmissionsFA['emissions'],colorsEmissionsFA['fa_greater']]))}

${title}

${Plot.plot({ x: { grid: true, label: null, tickFormat: d3.format(".0f"), ticks:years }, y: { label: "Emissions (MtCO₂e)", tickFormat: d=>d3.format(",.0f")(d/1000000), }, marks: [ Plot.areaY(years, { x: (d) => d, y: (d) => data.get(d).get("free_allowances"), fill: colorsEmissionsFA['fa_greater'], opacity: 0.5 }), Plot.areaY(years, { x: (d) => d, y: (d) => data.get(d).get("verified_emissions"), fill: colorsEmissionsFA['emissions'], }), Plot.lineX(years, { x: (d) => d, y: (d) => data.get(d).get("verified_emissions"), stroke: colorsEmissionsFA['emissions'], strokeWidth: 2 }), Plot.lineX(years, { x: (d) => d, y: (d) => data.get(d).get("free_allowances"), stroke: colorsEmissionsFA['fa_greater'], strokeWidth: 2 }), Plot.dotX(years, { x: (d) => d, y: (d) => data.get(d).get("verified_emissions"), fill: colorsEmissionsFA['emissions'], stroke: 'white', title: (d) => `${d3.format('.0f')(d)}: ${d3.format(',.0f')(data.get(d).get("verified_emissions"))}`, r: 5 }), Plot.dotX(years, { x: (d) => d, y: (d) => data.get(d).get("free_allowances"), fill: colorsEmissionsFA['fa_greater'], stroke: 'white', title: (d) => `${d3.format('.0f')(d)}: ${d3.format(',.0f')(data.get(d).get("free_allowances"))}`, r: 5 }) ] })}`; }4d:T74d,fa_surplus = { let filteredData = [...granular_data]; if (filteredSector) filteredData = filteredData.filter(d=>d.sector == filteredSector); if (filteredCountry) filteredData = filteredData.filter(d=>d.country == filteredCountry); if (filteredCompany) filteredData = filteredData.filter(d=>(retrieveOwner(d.installation_id, d.year) == filteredCompany['Company']) && (d.year >= 2021)); let title = 'Freely allocated allowances and cumulated surplus'; let data = d3.rollup( filteredData, (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 html`${Swatches(d3.scaleOrdinal(['Cumulated surplus','Surplus','Deficit'],['#a8bed8',colorsEmissionsFA['free_allowances'],categoricalScaleNames1('color_1')]))}

${title}

${Plot.plot({ x: { grid: true, label: null, tickFormat: d3.format(".0f") }, y: { label: "Emissions (MtCO₂e)", tickFormat: d=>d3.format(",.0f")(d/1000000) }, marks: [ Plot.ruleY([0]), Plot.barY(years, { x: (d) => d, y: (d) => data.get(d).get("free_allowances")-data.get(d).get("verified_emissions"), fill: d => data.get(d).get("verified_emissions")>data.get(d).get("free_allowances")? categoricalScaleNames1('color_1'): colorsEmissionsFA['free_allowances'], }), Plot.areaY(surplus, { x: 'year', y: d => d.value, fill: 'steelblue', curve: "monotone-x", opacity: 0.5 }), ] })}`; }4e:[{"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},{"id":"5d95994e388520374defa6deb0503c61c7ee8e1e63ef9c022515b02b4ba8dee0803f9afb5b9b6c80008c131dd4306b239813fea5a0117ae0a8b41a81233a9ec6","href":"https://static.observableusercontent.com/files/5d95994e388520374defa6deb0503c61c7ee8e1e63ef9c022515b02b4ba8dee0803f9afb5b9b6c80008c131dd4306b239813fea5a0117ae0a8b41a81233a9ec6","name":"iso_countries.csv","type":"text/csv","lastModified":1790262766553,"size":6271},{"id":"a60defc6e9f22741bc56635dfa855b496b9263c3913172a19cd8993a812c5d952d62307a3f0236f1515411e9901488a8683f7e6bfc73995599c2b7f0ba29dde2","href":"https://static.observableusercontent.com/files/a60defc6e9f22741bc56635dfa855b496b9263c3913172a19cd8993a812c5d952d62307a3f0236f1515411e9901488a8683f7e6bfc73995599c2b7f0ba29dde2","name":"owner_installations_year.csv","type":"text/csv","lastModified":1790336057174,"size":2602313},{"id":"8a0fb4a0f78c29f83f5823a0560c06a38d906acfb8cbac9bc8cbb2211031875610585729f7cb26483b5f0b1721ea11f1e641191cf8fdefd9097eeb042de30373","href":"https://static.observableusercontent.com/files/8a0fb4a0f78c29f83f5823a0560c06a38d906acfb8cbac9bc8cbb2211031875610585729f7cb26483b5f0b1721ea11f1e641191cf8fdefd9097eeb042de30373","name":"granular_data_24.csv","type":"text/csv","lastModified":1790845053964,"size":24634890},{"id":"571d4014bb6ee392e502498d0c98050264837a9cf2d879e2e6e082bcdee554a61ea195ace93e2506836249a8dcfb2bc51483893c7d4fe0faa15853d92396207a","href":"https://static.observableusercontent.com/files/571d4014bb6ee392e502498d0c98050264837a9cf2d879e2e6e082bcdee554a61ea195ace93e2506836249a8dcfb2bc51483893c7d4fe0faa15853d92396207a","name":"top_companies.csv","type":"text/csv","lastModified":1790861829758,"size":583}] 44:{"id":"f00493951295c229","slug":"eu-ets-database","title":"EU ETS Database","thumbnail":"cc951dd2efe75f28ec40abb6a2c675f8f220427f4ec90de7cc8cac7748989f43","access_level":"public","create_time":"$D2026-09-24T15:07:25.743Z","update_time":"$D2026-10-14T08:12:05.256Z","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","bio":"Data for Climate","following":false},"version":2349,"publish_version":2349,"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,"bio":"Data for Climate","following":false}],"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":{"titling":"auto","title":"EU ETS Database","cells":[{"id":0,"value":"# EU ETS Database","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1439,"value":"## Filters","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1465,"value":"","pinned":true,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1454,"value":"viewof dataset = Inputs.radio([2024, 2025], {value: 2024,label: \"Verified emissions file:\", format: d=>d3.format('.0f')(d)})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1444,"value":"viewof filteredYears = interval([2008, 2025], {\n step: 1,\n value: [2008, 2025],\n label: 'Years',\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1400,"value":"viewof filteredSector = Inputs.select([null].concat(allSectors.sort()), {label: \"Sector\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1410,"value":"viewof filteredCountry = Inputs.select([null].concat(allCountries.sort()), {label: \"Country\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1420,"value":"viewof companies = Inputs.search([null].concat(allCompanies), {placeholder: '', label: \"Company\", format: _ => ''});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1428,"value":"viewof filteredCompany = Inputs.table(companies.length == allCompanies.length? []: companies.map(Company =>({Company})), {multiple: false})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1434,"value":"html`

\n ${filteredSector? `

Sector:

${filteredSector}`: '

All sectors

'}\n
\n

Region:

${filteredCountry? filteredCountry: 'EU 27'}\n
\n ${filteredCompany? `

Company:

${filteredCompany['Company']}`: ''}\n`","pinned":false,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1436,"value":"html`

${emi_vs_fa}${fa_surplus}

`","pinned":false,"hidden":false,"mode":"ts","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1440,"value":"$46","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1424,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1457,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1261,"value":"$47","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1159,"value":"$48","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":712,"value":"$49","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":820,"value":"$4a","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":841,"value":"----","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":835,"value":"-----","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1396,"value":"## Useful links","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1411,"value":"$4b","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1447,"value":"---\n\n\n\n\n\n---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1438,"value":"# Utilities","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1461,"value":"baselineYear = 2024;","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1452,"value":"// {\n// let figure = ''\n// if (filteredCountry || filteredCompany || filteredSector) {\n// figure = '

{\n\n// }

';\n// }\n// else\n// figure = '';\n// return html`${figure}`;\n// }","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1442,"value":"filteredData = {\n let filteredData = [...granular_data];\n\n filteredData = filteredData.map(d => ({...d, 'company': (d.year >= 2021? retrieveOwner(d.installation_id, d.year): 'Unknown')}));\n\n filteredData = filteredData.filter(d=>d.year >= filteredYears[0] && d.year <= filteredYears[1]);\n\n if (filteredSector)\n filteredData = filteredData.filter(d=>d.sector == filteredSector);\n\n if (filteredCountry)\n filteredData = filteredData.filter(d=>d.country == filteredCountry);\n\n if (filteredCompany)\n filteredData = filteredData.filter(d=>d.company == filteredCompany['Company']);\n\n return filteredData;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1460,"value":"rolledSectors = {\n if (!filteredSector)\n return d3.rollup(\n filteredData.filter(d => d.type == 'free_allowances'),\n v => d3.sum(v, d => d.value),\n d => d.year,\n d => d.sector,\n );\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1423,"value":"retrieveOwner = (installation_id, year) => {\n if (installation_id in ownerDict) {\n if (year in ownerDict[installation_id])\n return ownerDict[installation_id][year];\n else {\n let owner = '';\n let distance = 1000;\n Object.keys(ownerDict[installation_id]).map(d => {\n if (Math.abs(d - year) < distance) {\n distance = Math.abs(d - year);\n owner = ownerDict[installation_id][d];\n }\n })\n return owner;\n }\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1315,"value":"$4c","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1432,"value":"$4d","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1466,"value":"formatNumber = number => {\n if (number > 1000000000)\n return `${d3.format(',.0f')(number/1000000)}M`\n else if (number > 1000000)\n return `${d3.format(',.1f')(number/1000000)}M`\n else if (number > 1000)\n return `${d3.format(',.1f')(number/1000)}k`\n else\n return d3.format(',.0f')(number)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":27,"value":"# Data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":519,"value":"## Sectors","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":914,"value":"transport = [\"Aviation\", \"Maritime\"]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1309,"value":"## Granular data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1463,"value":"top_companies = {\n let top = {};\n let data = await FileAttachment(\"top_companies.csv\").csv({typed: \"auto\"});\n await data.map(d => {\n top[d.company.toUpperCase()] = d.sector;\n });\n top['LHOIST'] = 'Lime & plaster';\n top['VICAT'] = 'Cement';\n top['NAPHTACHIMIE'] = 'Chemicals';\n top['INEOS LIMITED'] = 'Chemicals';\n top['LYONDELLBASELL INDUSTRIES N.V.'] = 'Chemicals';\n top['INEOS'] = 'Chemicals';\n top['INEOS'] = 'Chemicals';\n top['INEOS'] = 'Chemicals';\n top['INEOS'] = 'Chemicals';\n return {\n \"TOTALENERGIES SE\":\"Refineries\",\n \"ARCELORMITTAL SA\":\"Iron and steel\",\n \"HOLCIM AG\":\"Cement\",\n \"HEIDELBERG MATERIALS AG\":\"Cement\",\n \"LHOIST\":\"Lime & plaster\",\n \"VICAT\":\"Cement\"\n};\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1414,"value":"iso_countries = {\n let data = await FileAttachment(\"iso_countries.csv\").csv({typed: \"auto\"});\n let dict = {'XI': 'Northern Ireland'};\n await data.map(d => dict[d['Alpha-2 code']] = d['Country'])\n return dict;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1312,"value":"datasets = {\n\n let data24 = await FileAttachment(\"granular_data_24.csv\").csv({typed: \"auto\"});\n data24 = await data24.map(d => ({\n installation_id: d.installation_id,\n year: d.year,\n type: d.type,\n value: d.value,\n sector: d.sector?d.sector:'Other',\n country: iso_countries[d.installation_id.substring(0,2)]?iso_countries[d.installation_id.substring(0,2)]:d.installation_id.substring(0,2)\n }));\n\n let data25 = await FileAttachment(\"granular_data.csv\").csv({ typed: true });\n data25 = await data25.map(d => ({\n installation_id: d.installation_id,\n year: d.year,\n type: d.type,\n value: d.value,\n sector: d.sector?d.sector:'Other',\n country: iso_countries[d.installation_id.substring(0,2)]?iso_countries[d.installation_id.substring(0,2)]:d.installation_id.substring(0,2)\n }));\n\n return {\n 2024: data24,\n 2025: data25,\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1456,"value":"granular_data = datasets[dataset]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1402,"value":"allSectors = [...new Set([...granular_data.map(d=>d.sector)])]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1413,"value":"allCountries = [...new Set([...granular_data.map(d=>d.country)])]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1417,"value":"owner_installations_year = FileAttachment(\"owner_installations_year.csv\").csv({typed: \"auto\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1421,"value":"ownerDict = {\n let ownerDict = {};\n owner_installations_year.map(d => {\n if (!(d.installation_id in ownerDict))\n ownerDict[d.installation_id] = {};\n ownerDict[d.installation_id][d.year] = d.owner_name;\n });\n return ownerDict;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1418,"value":"allCompanies = [...new Set(owner_installations_year.map(d=>d.owner_name.trim()))].sort()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":11,"value":"# Imports","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1404,"value":"import {Swatches} from \"@d3/color-legend\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1443,"value":"import { Treemap } from \"@d3/treemap-component\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1445,"value":"import {interval} from '@mootari/range-slider'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W4e","stdlib":"1"}} 45:"$44:body"