25:["$","title",null,{"children":"Cocoa 2022 - Farm Sourcing by company (French) | Trase | Observable"}] 49:[{"id":"75dc2d9801fe7542b4b2ddd0f0b48798173a4acd13526299bfee35b4ff0b8116590b98b44f6aaf4433e872512ce878d06d35fca4615749ba9582f567b45dd320","href":"https://static.observableusercontent.com/files/75dc2d9801fe7542b4b2ddd0f0b48798173a4acd13526299bfee35b4ff0b8116590b98b44f6aaf4433e872512ce878d06d35fca4615749ba9582f567b45dd320","name":"civ_cfi_mapped_farms_vs_estimated_total_farms_all_and_eu_pivot.csv","type":"text/csv","lastModified":1668601264171.36,"size":402}] 29:{"id":"26196bc3013bcf9c","slug":null,"title":"Cocoa 2022 - Farm Sourcing by company (French)","thumbnail":"128beef58c19a4b7320c2663b82feebe5861578f1c0fb5b8b61e82dfe266e164","access_level":"unlisted","create_time":"$D2022-11-16T12:21:04.171Z","update_time":"$D2022-11-18T13:46:05.579Z","view_time":null,"first_public_time":"$D2022-11-16T12:33:44.596Z","has_unpublished_edits":null,"fork":true,"stars":0,"starred":false,"owner":{"type":"team","id":"7ad1222ddb4e496a","login":"trase","name":"Trase","avatar_url":"https://avatars-next.observableusercontent.com/b224aa7961f5a048a8038ec6325c50964fe0466aeb33b4e09887e1f552e8a676","tier":"pro","bio":"Trase is a supply chain transparency initiative that seeks to transform our understanding of how companies and governments involved in the trade of agricultural commodities are linked to impacts and opportunities for more sustainable production","followed_by_you":false,"follows_you":false},"version":239,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"2afbe130e224f76e","login":"bernardol","name":"Bernardo Loureiro","avatar_url":"https://avatars-next.observableusercontent.com/3ddb97df58abc437d5bbc6349f9def4591d2d148c1ccc8047e6c56067eb89987","tier":null,"bio":"","followed_by_you":false,"follows_you":false}],"members":[{"type":"individual","id":"2afbe130e224f76e","login":"bernardol","name":"Bernardo Loureiro","avatar_url":"https://avatars-next.observableusercontent.com/3ddb97df58abc437d5bbc6349f9def4591d2d148c1ccc8047e6c56067eb89987","tier":null,"role":"editor"},{"type":"team","id":"7ad1222ddb4e496a","login":"trase","name":"Trase","avatar_url":"https://avatars-next.observableusercontent.com/b224aa7961f5a048a8038ec6325c50964fe0466aeb33b4e09887e1f552e8a676","tier":"pro","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Cocoa 2022 - Farm Sourcing by company (French)","cells":[{"id":130,"value":"# Cocoa 2022 - Farm Sourcing by company (French)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":147,"value":"chartTitle = titleCard({\n title:\n \"Progrès des négociants de cacao dans la traçabilité à la plantation de leurs approvisionnements en cacao\",\n subtitle:\n \"Plantations cartographiées, telles que signalées par les entreprises dans les rapports de l’ICF, par rapport au nombre estimé de plantations d’approvisionnement, 2019 (Source : Chaînes d’approvisionnement de Trase).\",\n width: \"100%\"\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":26,"value":"chart = {\n const styleWidth = width >= 800 ? \"50\" : \"100\";\n return htl.html`\n${chartTitle}\n

Toutes les plantations

\n${totalLegend}\n${totalChart}\n

Plantations vendant à l'UE

\n${euLegend}\n${euChart}\n

Plantations dans l'approvisionnement tracé à la coopérative

\n${coopLegend}\n${coopChart}\n

\n`;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3,"value":"dataRaw = FileAttachment(\n \"civ_cfi_mapped_farms_vs_estimated_total_farms_all_and_eu_pivot.csv\"\n).csv({ typed: true })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":80,"value":"data = dataRaw.sort((a, b) => a[keyCol].localeCompare(b[keyCol]))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":84,"value":"xMax = d3.max([\n d3.max(data, (d) => Number(d[valueColTotal])),\n d3.max(data, (d) => Number(d[valueColCoop])),\n d3.max(data, (d) => Number(d[valueColEu])),\n d3.max(data, (d) => Number(d[secondaryValueCol]))\n])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":20,"value":"keyCol = \"EXPORTER\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":9,"value":"// valueUnits = \"# Farms\"\nvalueUnits = \"\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":11,"value":"secondaryValueCol = \"MAPPED\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":13,"value":"secondaryValueTitle = \"Plantations cartographiées\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":15,"value":"// secondaryValueUnits = \"# Farms\"\nsecondaryValueUnits = \"\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":17,"value":"showValueLabels = false","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":94,"value":"valueColTotal = \"SOURCED FROM\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":96,"value":"valueColEu = \"SOURCED FROM FOR EU SALES\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":99,"value":"valueColCoop = \"IN SOURCING TRACED TO COOPERATIVES\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":38,"value":"chartUrl = \"@trase/overlay-horizontal-bar-chart-2-0\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":117,"value":"margin = ({ top: 20, right: 30, bottom: 30, left: 160 })","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":55,"value":"defaultConfigs = ({\n keyCol: keyCol,\n valueUnits: valueUnits,\n secondaryValueCol: secondaryValueCol,\n secondaryValueTitle: secondaryValueTitle,\n secondaryValueUnits: secondaryValueUnits,\n showValueLabels: showValueLabels,\n data: data,\n sort: false,\n xMax: xMax,\n width: chartWidth,\n height: chartHeight,\n margin: margin\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":205,"value":"chartWidth = width >= 800 ? width / 2 : width","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":207,"value":"chartHeight = width >= 800 ? width / 5 : width * 0.65","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":217,"value":"width","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":7,"value":"totalConfigs = ({\n ...defaultConfigs,\n valueCol: valueColTotal,\n valueTitle: \"Toutes les plantations\"\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":60,"value":"coopConfigs = ({\n ...defaultConfigs,\n valueCol: valueColCoop,\n valueTitle: \"Plantations tracé à la coopérative\"\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":64,"value":"euConfigs = ({\n ...defaultConfigs,\n valueCol: valueColEu,\n valueTitle: \"Plantations vendant à l'UE\"\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":33,"value":"totalChart = importCell(\"chart\", chartUrl, totalConfigs)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":50,"value":"totalLegend = importCell(\"legend\", chartUrl, totalConfigs)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":66,"value":"coopChart = importCell(\"chart\", chartUrl, coopConfigs)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":69,"value":"coopLegend = importCell(\"legend\", chartUrl, coopConfigs)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":71,"value":"euChart = importCell(\"chart\", chartUrl, euConfigs)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":73,"value":"euLegend = importCell(\"legend\", chartUrl, euConfigs)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":23,"value":"// import {\n// chart as chartTotal,\n// legend as legendTotal\n// } with { totalConfigs as c } from \"@trase/overlay-horizontal-bar-chart-2-0\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":35,"value":"import { importCell } from \"@mbostock/dataflow\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":134,"value":"import { titleCard } from \"@trase/title-card\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W49","stdlib":"1"}} 24:null