27:null 28:["$","title",null,{"children":"Dia 28 — Challenge final!✨ | Laia's | Observable"}] 2d:[{"id":"c995d574d18f3582572fba4ca868594e45fad814005618c04aff744848f6486f247171fd71e4c4d7b138cee5e102f316e5e22be82529b18feda950b81a60453c","href":"https://static.observableusercontent.com/files/c995d574d18f3582572fba4ca868594e45fad814005618c04aff744848f6486f247171fd71e4c4d7b138cee5e102f316e5e22be82529b18feda950b81a60453c","name":"production-vs-consumption-co2-emissions.csv","type":"text/csv","lastModified":1753942719655.945,"size":879414},{"id":"5f73ea1bd650cb059a2cdc279c7581967e9c1f11398adc1e473bbdbb1e471c287965ac05f5d8a2c6b06fae3348afe61ba291e16da51eafe2e9c442bbf3700def","href":"https://static.observableusercontent.com/files/5f73ea1bd650cb059a2cdc279c7581967e9c1f11398adc1e473bbdbb1e471c287965ac05f5d8a2c6b06fae3348afe61ba291e16da51eafe2e9c442bbf3700def","name":"emissions.csv","type":"text/csv","lastModified":1753943052412.668,"size":1493942},{"id":"b323686a1e4fb17bbbbcced3e87894d0069d898719b53f1cb8740bacf55e6c2423d943e588cdd5e6c544bdceb606ac5aa21b257aae3d2a0cd2fbb189a3fdfad0","href":"https://static.observableusercontent.com/files/b323686a1e4fb17bbbbcced3e87894d0069d898719b53f1cb8740bacf55e6c2423d943e588cdd5e6c544bdceb606ac5aa21b257aae3d2a0cd2fbb189a3fdfad0","name":"populationRaw.csv","type":"text/csv","lastModified":1753950934368.071,"size":1568453},{"id":"9d938e0b7d9f6fc3b81d46f5d04781cfb7cb11ab3f3d9c72e5f4b4d7b34acadae02978bc5f8882295ee973ce007bc55c0b891a47bf5caf7394f363ac32631d9f","href":"https://static.observableusercontent.com/files/9d938e0b7d9f6fc3b81d46f5d04781cfb7cb11ab3f3d9c72e5f4b4d7b34acadae02978bc5f8882295ee973ce007bc55c0b891a47bf5caf7394f363ac32631d9f","name":"owid-co2-data.csv","type":"text/csv","lastModified":1754074085044.266,"size":14280395}] 2b:{"id":"abf6968a1aedf46f","slug":null,"title":"Dia 28 — Challenge final!✨","thumbnail":"d8eb8a413aaff6d5ff82020fe685ca32e5fee810e053df873cb6e31b109ed6fd","access_level":"public","create_time":"$D2025-07-30T09:34:58.116Z","update_time":"$D2025-08-05T05:25:50.401Z","view_time":null,"first_public_time":"$D2025-07-30T09:34:58.116Z","has_unpublished_edits":null,"fork":{"id":"4c311cdea7823544","slug":null,"title":"Dia 28 — Challenge final!✨","owner":{"id":"4bce174a609780f2","login":"fndvit","name":"Visualization for Transparency Foundation (Fundació ViT)"}},"stars":0,"starred":false,"owner":{"type":"team","id":"d731b32f3012da30","login":"laias","name":"Laia's","avatar_url":"https://avatars-next.observableusercontent.com/be24205c7ed3d33bf874278d51cb377c2d0246a6222168762353f5f1973f8a76","tier":"starter_2024"},"version":537,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"3e5bb3ad8262f4d8","login":"laia2","name":"Laia","avatar_url":"https://avatars-next.observableusercontent.com/9582edf1c51ba105ebf719ebab95f698e1e0902126e3b0aad3431a2320f9bafa","tier":null}],"members":[{"type":"individual","id":"3e5bb3ad8262f4d8","login":"laia2","name":"Laia","avatar_url":"https://avatars-next.observableusercontent.com/9582edf1c51ba105ebf719ebab95f698e1e0902126e3b0aad3431a2320f9bafa","tier":null,"role":"editor"},{"type":"team","id":"d731b32f3012da30","login":"laias","name":"Laia's","avatar_url":"https://avatars-next.observableusercontent.com/be24205c7ed3d33bf874278d51cb377c2d0246a6222168762353f5f1973f8a76","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"title":"Dia 28 — Challenge final!✨","cells":[{"id":0,"value":"# Dia 28 — Challenge final!✨","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":7,"value":"### EXERCICI\n🎯 Objectiu: Pensar una història pròpia, obtenir les dades i explicar-la amb la vostra pròpia narrativa.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":115,"value":"*Documentació*: \n- [Col·lecció dels notebooks del curs](https://observablehq.com/collection/@fndvit/retech)\n- [Llibreria Plot](https://observablehq.com/plot/what-is-plot)\n- [Catàleg de dades obertes de la Generalitat de Catalunya](https://analisi.transparenciacatalunya.cat/)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":152,"value":"## PAS 1 — Escolliu el conjunt de dades que voldreu usar en la vostra història\n- Podeu usar dades pròpies o dades obertes (podeu usar els conjunts de dades que hem anat fent servir al llarg del curs: [llistat 1](https://docs.google.com/document/d/1igfmrrn8NcLwvLA1_RFRDjoJU9NG-1crsLtxjJp31bc/edit?tab=t.0) o [llistat 2](https://docs.google.com/spreadsheets/d/1paVwpPaAOdyAIcnPwVT32XPhPCvdo7wVR3fGkGZdhGA/edit?gid=0#gid=0))","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":164,"value":"Emissions històriques territorials **1850–2020** del **GCP** (les que hem fet servir del NYT) + **Our World in Data per ampliar fins 2023**
https://ourworldindata.org/co2-and-greenhouse-gas-emissions
\nhttps://github.com/owid/co2-data?tab=readme-ov-file","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":166,"value":"Emissions per consum **1990-2024**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":169,"value":"Emissions per sectors **2015-2024**: Climate TRACE","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":20,"value":"## PAS 2 — Penseu la vostra història\n- Quins són els punts clau de la vostra anàlisi?\n\n ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":207,"value":"** 1. La responsabilitat històrica:**
\nQui ha emès més CO₂ acumulat des de 1850 fins al 2024?\n
Context, pes històric i legitimar el debat sobre justícia climàtica.\n

\n**2. El desequilibri entre emissions i població:**
\nEls països rics han emès molt més que la seva proporció de població.
\nConvidar a una reflexió sobre l’equitat.

\n** 3.La diferència entre produir i consumir emissions:**
\nHi ha països que exporten les emissions que altres importen amb el seu consum.
\nActualitzar el concepte de responsabilitat.

\n**4.Els sectors que impulsen les emissions: **
\nQuè causa realment les emissions avui? Energia, transport, agricultura…?
\nFa la crisi més concreta i comprensible.

\n**5.El present i la tendència:**
\nL’any 2024 torna a marcar rècords. On som ara?
\nTancar la narrativa amb una mirada cap al futur immediat.\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":203,"value":"\n- Quin és el fil conductor i la lògica d’aquest ordre?","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":221,"value":"“Qui ha provocat el canvi climàtic? I com el continuem provocant avui?”\n\nOrdre lògic:
\n\t**1.Mirada llarga:** acumulat des de 1850
\n\t**2.Justícia i desigualtat:** contrast amb població
\n\t**3.Mirada present:** emissions per consum
\n\t**4.Actualitat i urgència:** 2024 → línia temporal i gràfic comparatiu
\n\t**5.Tancament reflexiu:** síntesi comparativa
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":224,"value":"- Quin format narratiu fareu servir?\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":234,"value":"**Narrativa guiada** de vistes múltiples *(com l'exemple resolt a classe del NYT)*
\n\t•\tDividit en seccions clares amb títol
\n\t•\tUna idea clau per secció
\n\t•\tText introductori + visual associat
\n\t•\tInteracció intuïtiva integrada dins les metàfores utilitzades: hover, toggle, selecció d’any, tipus o sector d'emissions...
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":226,"value":"- Quines metàfores visuals usareu?","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":243,"value":"**Emissions acumulades**: Treemap resolt a classe amb dades actualitzades fins 2023 (Pes, magnitud, herència històrica i culpables)
\n**Emissions vs població**: Barres comparatives i/o stacked (Desigualtat, injustícia)
\n\n**Emissions per consum**: Canvi de mirada (de culpar el productor a culpar el consumidor)
\n**Evolució temporal**: Tendència, inèrcia, urgència
\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":48,"value":"## PAS 3 — Obteniu les dades i incoporeu-les al notebook\n\n- Teniu algun comentari/crítica respecte a les dades?","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":174,"value":"emissions = await FileAttachment(\"emissions.csv\").csv({typed: \"auto\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"emissions","database":"$undefined"},{"id":260,"value":"owidCo2Data = await FileAttachment(\"owid-co2-data.csv\").csv({typed: \"auto\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"owidCo2Data","database":"$undefined"},{"id":262,"value":"**Les emissions de Co2 de emissions no coincideixen amb les de OWID:**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":264,"value":"Hi hauria un salt rellevant si fem servir les dades d'emissions que teniem fins 2020 i de 2021 a 2023 les d'owid. Això ens porta a pensar que probablement la millor decisió és fer servir només les emissions d'owid. Abans de prendre la decisió, ens plantegem: “Tenim una sèrie d’anys sòlida i coherent per a cada país, tot i que alguns valors siguin zero o nul per motius històrics amb les emissions d'owid?”","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":266,"value":"Comprovarem:
\n •\tSi un país té dades contínues des del primer any en què comença a emetre fins al 2023, el dataset és vàlid.
\n\t•\tNo cal que tingui dades des de 1850 si no existia o no emetia res llavors.
\n\t•\tPodem tolerar valors nuls puntuals, però no buits totals entre 1990–2023.
","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":270,"value":"validCo2ByCountry = d3.groups(\n owidCo2Data.filter(d => d.co2 !== null && d.co2 !== \"\"),\n d => d.iso_code\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":273,"value":"co2Coverage = validCo2ByCountry.map(([iso_code, records]) => {\n const years = records.map(d => d.year);\n const country = records[0]?.country ?? iso_code;\n return {\n iso_code,\n country,\n year_start: Math.min(...years),\n year_end: Math.max(...years),\n complete_to_2023: Math.max(...years) >= 2023\n };\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":276,"value":"validCountries = validCo2ByCountry.filter(([iso, data]) => iso !== \"\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":281,"value":"coverageSummary = validCountries.map(([iso_code, records]) => {\n const years = records.map(d => d.year);\n return {\n iso_code,\n country: records[0]?.country ?? iso_code,\n start: Math.min(...years),\n end: Math.max(...years),\n complete_to_2023: Math.max(...years) >= 2023\n };\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":287,"value":"Farem servir el dataset d’OWID (owidCo2Data) per representar emissions de CO₂ des de 1850 fins a 2023, amb aquestes condicions:\n\t1.\tNo cal fusionar amb emissions.csv: la cobertura d’owid és molt bona i farem servir els seus valors d'emissions de CO2\n\t2.\tÉs millor per consistència: les unitats i formats ja són homogenis.\n\t3.\tNomés exclourem agregats regionals i territoris no independents com “Africa”, “Europe”, “World”, etc.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":292,"value":"**Definim noms a corregir de països, no-països i agregats a excloure del data set emissions:**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":296,"value":"nameFixes = Object.fromEntries([\n [\"Bonaire, Saint Eustatius and Saba\", \"Bonaire Sint Eustatius and Saba\"],\n [\"Cura\\uFFFDao\", \"Curacao\"],\n [\"Czech Republic\", \"Czechia\"],\n [\"C\\uFFFDte d'Ivoire\", \"Cote d'Ivoire\"],\n [\"Democratic Republic of the Congo\", \"Democratic Republic of Congo\"],\n [\"Faeroe Islands\", \"Faroe Islands\"],\n [\"French Guiana\", \"France\"],\n [\"Micronesia (Federated States of)\", \"Micronesia (country)\"],\n [\"Occupied Palestinian Territory\", \"Palestine\"],\n [\"Pacific Islands (Palau)\", \"Palau\"],\n [\"Puerto Rico\", \"United States\"],\n [\"R\\uFFFDunion\", \"Reunion\"],\n [\"Swaziland\", \"Eswatini\"],\n [\"Timor-Leste\", \"East Timor\"],\n [\"USA\", \"United States\"],\n [\"Viet Nam\", \"Vietnam\"],\n [\"Wallis and Futuna Islands\", \"Wallis and Futuna\"]\n])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":300,"value":"nonCountries_emissions = [\n \"Brunei Darussalam\",\n \"French Equatorial Africa\",\n \"French West Africa\",\n \"Global\",\n \"Guadeloupe\",\n \"International Transport\",\n \"Leeward Islands\",\n \"Martinique\",\n \"Mayotte\",\n \"Panama Canal Zone\",\n \"St. Kitts-Nevis-Anguilla\"\n]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":303,"value":"normalize = d => ({ ...d, year: d.year === \"all\" ? null : +d.year });","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":305,"value":"emissionsPreExclusion = emissions\n .map(normalize)\n .filter(d => d.id && d.id.length === 3)\n .filter(d => d.emissions != null && !Number.isNaN(+d.emissions))\n .filter(d => d.year == null || (d.year >= 1850 && d.year <= 2023));","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":308,"value":"normalizeName = s => (nameFixes[s] || s || \"\").trim();","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":312,"value":"nameToIso = new Map(emissionsPreExclusion.map(d => [d.country, d.id]))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":315,"value":"**Netegem i corregim noms de països del data set \"emissions\":**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":322,"value":"exclude = new Set([\"KNA\", \"BRN\"]);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":319,"value":"nonCountriesISO = new Set(\n nonCountries_emissions\n .map(n => nameToIso.get(normalizeName(n)))\n .filter(Boolean)\n .filter(c => !exclude.has(c))\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":327,"value":"emissionsClean = emissionsPreExclusion.filter(d => !nonCountriesISO.has(d.id))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":330,"value":"**Netegem i corregim noms de països del dataset owidCo2Data**
\nArray d'agregats a excloure del data set owidCo2Data:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":334,"value":"nonCountries_owid = [\n \"Africa\", \"Africa (GCP)\",\n \"Asia\", \"Asia (GCP)\", \"Asia (excl. China and India)\",\n \"Central America (GCP)\",\n \"Europe\", \"Europe (GCP)\", \"Europe (excl. EU-27)\", \"Europe (excl. EU-28)\",\n \"European Union (27)\", \"European Union (28)\",\n \"High-income countries\", \"Low-income countries\", \"Upper-middle-income countries\", \"Lower-middle-income countries\",\n \"Least developed countries (Jones et al.)\",\n \"Middle East (GCP)\", \"Non-OECD (GCP)\", \"OECD (GCP)\", \"OECD (Jones et al.)\",\n \"North America\", \"North America (GCP)\", \"North America (excl. USA)\",\n \"South America\", \"South America (GCP)\",\n \"Oceania\", \"Oceania (GCP)\",\n \"World\",\n \"International aviation\", \"International shipping\", \"International transport\"\n]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":337,"value":"nonCountries_extra = [\n \"Kuwaiti Oil Fires\", \"Kuwaiti Oil Fires (GCP)\",\n \"Ryukyu Islands\", \"Ryukyu Islands (GCP)\"\n]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":340,"value":"owidClean = {\n const normalized = owidCo2Data.map(d =>\n d.country === \"Kosovo\" && (!d.iso_code || d.iso_code === \"\")\n ? { ...d, iso_code: \"XKX\" }\n : d\n );\n\n return normalized.filter(d =>\n d.iso_code && d.iso_code.length === 3 &&\n ![\"MCO\", \"SMR\", \"VAT\"].includes(d.iso_code) &&\n ![...nonCountries_owid, ...nonCountries_extra].includes(d.country) &&\n d.year >= 1850 && d.year <= 2023 &&\n d.co2 != null\n );\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":343,"value":"**Preparem el map a partir d'emissionsClean:**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":351,"value":"Cal remapejar els 4 ISO que falten a OWID\n\nA emissions tenim ID que OWID no usa com a sèries pròpies:
\n\t•\tGUF (French Guiana) → s’atribueix a France (FRA) a OWID
\n\t•\tPRI (Puerto Rico) → s’atribueix als United States (USA)
\n\t•\tREU (Réunion) → s’atribueix a France (FRA)
\n\t•\tKSV (Kosovo) → OWID fa servir XKX","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":354,"value":"isoFixes = new Map([\n [\"GUF\",\"FRA\"],\n [\"PRI\",\"USA\"],\n [\"REU\",\"FRA\"],\n [\"KSV\",\"XKX\"]\n]);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":357,"value":"emissionsMap = {\n const map = new Map();\n for (const d of emissionsClean) {\n if (!d.id || d.id.length !== 3) continue;\n const fixedIso = isoFixes.get(d.id) ?? d.id;\n const key = `${fixedIso}_${d.year}`;\n map.set(key, {\n // NO sobreescrivim co2 d’OWID\n region: d.region,\n annex2: d.annex2,\n country_emissions: d.country,\n id_emissions: d.id\n });\n }\n return map;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":360,"value":"**Merge net amb owidClean:**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":362,"value":"// Helper: fusiona sense sobreescriure amb null/undefined\nsafeMerge = (base, extra) => {\n const out = { ...base };\n for (const [k, v] of Object.entries(extra)) {\n if (v !== null && v !== undefined) out[k] = v;\n }\n return out;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":365,"value":"owidMerged = owidClean.map(d => {\n const iso = isoFixes.get(d.iso_code) ?? d.iso_code; // ISO normalitzat\n const key = `${iso}_${d.year}`; // clau consistent\n const extra = emissionsMap.get(key);\n\n // Partim de OWID, i només sobrescrivim amb camps vàlids de `extra`\n const merged = extra ? safeMerge({ ...d, iso_code: iso }, extra)\n : { ...d, iso_code: iso };\n\n return {\n ...merged,\n hasAnnex2: ANNEX2.has(iso)\n };\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":367,"value":"**Comprovacions del merge:**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":369,"value":"nameDifferences = owidMerged.filter(d =>\n d.country_emissions && d.country !== d.country_emissions\n).map(d => ({\n iso: d.iso_code, year: d.year, owid: d.country, emissions: d.country_emissions\n}))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":371,"value":"[...new Set(owidMerged.map(d => d.country))].sort()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":373,"value":"[...new Set(owidMerged.map(d => d.iso_code))].sort()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":375,"value":"isoToNames = d3.rollup(owidMerged, v => new Set(v.map(d => d.country)), d => d.iso_code)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":378,"value":"// 5) Forats 2021–2023 (ISO on tots 3 anys són null a co2)\ngaps2123 = d3.rollups(\n owidMerged.filter(d => [2021, 2022, 2023].includes(d.year)),\n v => v.every(d => d.co2 == null),\n d => d.iso_code\n).filter(([iso, allNull]) => allNull)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":381,"value":"//IDs d’emissions que no apareixen a OWID (hauria d’estar buit)\nidsEmissions = new Set(emissionsClean.filter(d => d.id && d.id.length === 3).map(d => isoFixes.get(d.id) ?? d.id))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":384,"value":"idsOWID = new Set(owidMerged.map(d => d.iso_code))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":386,"value":"**Tenim 5 països sense Annex definit**
\nNota: CUW (Curaçao) i PLW (Palau) són Partes no‑Annex I; XKX (Kosovo) no és Part de la UNFCCC; CIV (Côte d’Ivoire) també és no‑Annex I. FRA sí que és Annex II. Ho corregim","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":388,"value":"// Llista UNFCCC Annex II (OECD 1992; Turquia no hi és)\nANNEX2 = new Set([\n \"AUS\",\"AUT\",\"BEL\",\"CAN\",\"DNK\",\"FIN\",\"FRA\",\"DEU\",\"GRC\",\"ISL\",\n \"IRL\",\"ITA\",\"JPN\",\"LUX\",\"NLD\",\"NZL\",\"NOR\",\"PRT\",\"ESP\",\"SWE\",\n \"CHE\",\"GBR\",\"USA\"\n])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":390,"value":"metaByIso = new Map(\n [...idsEmissions].map(id => [id, { hasAnnex2: ANNEX2.has(id) }])\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":396,"value":"Ara ja tenim owidMerged amb:\n\n totes les files per país i any\n\n l’iso_code netejat amb isoFixes\n\n els camps d’emissions (del merge amb emissionsMap)\n\n i el flag hasAnnex2","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":398,"value":"**Hi ha països que no tenen Region assignat:**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":400,"value":"// Si tens isoFixes, normalitza; si no, això retorna el mateix ISO.\nnormIso = iso => (isoFixes?.get?.(iso) ?? iso)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":403,"value":"// Treballem amb owidMerged\nbase = owidMerged ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":406,"value":"regionByIso = new Map(\n d3.rollups(\n base.filter(d => d.region != null && d.region !== \"\"),\n v => {\n const counts = d3.rollup(v, vv => vv.length, d => d.region);\n const max = d3.max(counts.values());\n const modes = [...counts].filter(([, c]) => c === max).map(([r]) => r);\n if (modes.length === 1) return modes[0];\n // Desempat: el valor de regió més recent entre les modals\n return d3.sort(\n v.filter(d => modes.includes(d.region)),\n (a, b) => d3.descending(a.year, b.year)\n )[0].region;\n },\n d => normIso(d.iso_code)\n )\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":409,"value":"filledAll = base.map(d => {\n const iso = normIso(d.iso_code);\n const needsFill = d.region == null || d.region === \"\";\n return {\n ...d,\n iso_code: iso,\n region: needsFill ? (regionByIso.get(iso) ?? d.region) : d.region\n };\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":412,"value":"manualRegions = new Map([\n [\"CIV\", \"Africa\"], // Côte d’Ivoire\n [\"CUW\", \"Americas\"], // Curaçao (Carib → North America a OWID)\n [\"FRA\", \"Europe\"], // France\n [\"PLW\", \"Oceania\"], // Palau\n [\"XKX\", \"Europe\"] // Kosovo\n])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":415,"value":"owidFinal = filledAll.map(d => {\n const needsFill = d.region == null || d.region === \"\";\n const manual = manualRegions.get(d.iso_code);\n return {\n ...d,\n region: needsFill ? (manual ?? d.region) : d.region\n };\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":417,"value":"**eliminem ATA** (Antarctica)\n No és un país sobirà ni membre de la UNFCCC, sinó un territori internacional sense població estable.\n Les seves emissions al dataset OWID/EDGAR solen ser zero o molt petites (excepte “aviation bunkers” que no són realment “Antarctica”).\n Si deixem ATA, a alguns gràfics pot aparèixer un “país fantasma” que distorsiona llegendes i comptatges.\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":421,"value":"**Array net i definitiu!!**:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":425,"value":"owidBase = owidFinal.filter(d => d.iso_code !== \"ATA\" && d.country !== \"World\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":428,"value":"**Últims checks:**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":432,"value":"//Integritat ANNEX2 vs total global\nbyYear = d3.rollups(\n owidFinal,\n v => ({\n total: d3.sum(v, d => d.co2 || 0),\n annex2: d3.sum(v.filter(d => d.hasAnnex2), d => d.co2 || 0),\n nonAnnex2: d3.sum(v.filter(d => !d.hasAnnex2), d => d.co2 || 0)\n }),\n d => d.year\n).map(([year, o]) => ({ year, ...o, ok: Math.abs((o.annex2+o.nonAnnex2) - o.total) < 1e-6 }))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":435,"value":"byYear.every(d => d.ok) // ha de ser true","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":438,"value":"//Sense duplicats iso_code+year\nd3.rollups(owidFinal, v => v.length, d => `${d.iso_code}_${d.year}`)\n .some(([, n]) => n > 1) // ha de ser false","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":441,"value":"//Distribució de països per regió\nd3.rollups(new Set(owidFinal.map(d => d.iso_code)), \n _ => 0, d => owidFinal.find(x => x.iso_code===d).region)\n .map(([region, _]) => ({ region, countries:\n new Set(owidFinal.filter(x => x.region===region).map(x => x.iso_code)).size\n }))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":443,"value":"d3.rollups(\n owidFinal.filter(d => d.year >= 2020),\n v => ({\n co2_nulls: v.filter(d => d.co2 == null).length,\n co2pc_nulls: v.filter(d => d.co2_per_capita == null).length,\n region_nulls: v.filter(d => d.region == null || d.region === \"\").length\n }),\n d => d.year\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":445,"value":"// Únics per ISO, triant el nom de país més recent si cal\nbyIso = d3.rollups(\n owidBase,\n v => d3.sort(v, (a,b) => d3.descending(a.year, b.year))[0],\n d => d.iso_code\n).map(([, d]) => ({ iso: d.iso_code, country: d.country, region: d.region }))\n .sort((a,b) => d3.ascending(a.iso, b.iso))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":464,"value":"**Recuperem les dades de International Transport i alguns tipus d'emissions**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":472,"value":"// 1) Extres que volem recuperar de l’OWID original\nintlWanted = new Set([\n \"International transport\",\n \"International aviation\",\n \"International shipping\",\n \"World\" // opcional\n])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":476,"value":"owidExtras = owidCo2Data\n .filter(d => intlWanted.has(d.country))\n .map(d => ({\n ...d,\n year: +d.year,\n co2: +d.co2,\n hasAnnex2: null\n }))\n .filter(d => d.year >= 1850 && d.year <= 2023);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":483,"value":"**Array net i definitiu amb transport internacional!!**:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":478,"value":"// 2) Unir amb owidBase evitant duplicats per (country, year)\nowidBasePlus = {\n const key = d => `${d.country}|${+d.year}`;\n const seen = new Set(owidBase.map(key));\n return owidBase.concat(owidExtras.filter(d => !seen.has(key(d))));\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":456,"value":"**Carreguem les dades \"productionVsConsumptionCo2Emissions\" s'OWID**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":162,"value":"productionVsConsumptionCo2Emissions = await FileAttachment(\"production-vs-consumption-co2-emissions.csv\").csv({typed: \"auto\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"productionVsConsumptionCo2Emissions","database":"$undefined"},{"id":487,"value":"Valors nuls per columna:\n
Entity: 0 (cap fila sense nom de país/entitat)\n\nCode: 5674 (hi ha 5674 files sense codi ISO3!)\n\nYear: 0\n\nAnnual CO₂ emissions: 35 nuls\n\nAnnual consumption-based CO₂ emissions: 24306 nuls, les dades comencen a partir de 1990.\n
\n
\nFiltrem per codi i franja d'anys:\n\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":490,"value":"PvsCCo2Efiltered = productionVsConsumptionCo2Emissions.filter(d =>\n d.Code && d.Code.length === 3 &&\n d.Year >= 1990 && d.Year <= 2023\n )","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":493,"value":"nullConsumptionRows = PvsCCo2Efiltered.filter(d =>\n d[\"Annual consumption-based CO₂ emissions\"] === \"\" ||\n d[\"Annual consumption-based CO₂ emissions\"] == null ||\n isNaN(+d[\"Annual consumption-based CO₂ emissions\"])\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":495,"value":"countriesWithNulls = Array.from(new Set(nullConsumptionRows.map(d => d.Code)))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":497,"value":"// la llista de noms de país i codi:\ncountriesWithNulls.map(code => {\n const country = nullConsumptionRows.find(d => d.Code === code)?.Entity;\n return { country, code };\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":511,"value":"Molts països no tenen dades a Annual consumption-based CO2 emissions, alguns no tenen cap dada i a molts els falta la de 2023, farem el gràfic fins 2022 i tot i així ens faltaran països.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":499,"value":"Object.fromEntries(\n countriesWithNulls.map(code => [\n code,\n nullConsumptionRows.filter(d => d.Code === code).length\n ])\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":519,"value":"filteredTo2022 = PvsCCo2Efiltered.filter(d =>\n d.Year >= 1990 && d.Year <= 2022\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":521,"value":"countriesWithCO2ConsumptionData = Array.from(\n new Set(\n filteredTo2022\n .filter(d => d[\"Annual consumption-based CO₂ emissions\"] !== \"\" && d[\"Annual consumption-based CO₂ emissions\"] != null)\n .map(d => d.Code)\n )\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":525,"value":"cleanPvsCCo2E = filteredTo2022.filter(d => countriesWithCO2ConsumptionData.includes(d.Code))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":527,"value":"cleanPvsCCo2E","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":39,"value":"## PAS 4 — Creeu la vostra història\n- Podeu fer-la en un notebook apart i enllaçar-lo en aquesta secció","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":531,"value":"https://observablehq.com/d/c552448cb046fe91","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"}],"files":"$W2d","stdlib":"1","titling":"auto"}} 2c:"$2b:body"