25:["$","title",null,{"children":"Cocoa 2022 - Farm Sourcing by company | 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":1666714693944.368,"size":402}] 29:{"id":"a66fb2bbc21345a0","slug":null,"title":"Cocoa 2022 - Farm Sourcing by company","thumbnail":"ab287d563987eea1344ada8b7de2ef136583c2b822f7d828e2fe040db2d7a787","access_level":"unlisted","create_time":"$D2022-10-25T16:18:07.148Z","update_time":"$D2022-11-16T12:44:45.128Z","view_time":null,"first_public_time":"$D2022-10-25T16:45:57.549Z","has_unpublished_edits":null,"fork":false,"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":164,"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":[{"id":"3cfb41335edd3bae","reply_to_id":null,"content":"Subtitle could be : \"Mapped farms as reported by the companies in their CFI report vs. Estimated number of farms supplying them\". \n\n\"Cocoa Farms Traced to Cooperatives\" sounds a bit strange - perhaps change to \"Cocoa Farms in the Sourcing Traced to Cooperatives\"","create_time":"$D2022-10-31T13:48:23.148Z","update_time":null,"resolved":true,"user":{"type":"individual","id":"98f32dac1e94cdef","login":"cecilere","name":"Cécile Renier","avatar_url":"https://avatars-next.observableusercontent.com/af28acdddb6ba138a5661e54cc7f2fd1c230f5d41e8d7652b63bd40858432b0b","tier":null}}],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Cocoa 2022 - Farm Sourcing by company","cells":[{"id":130,"value":"# Cocoa 2022 - Farm Sourcing by company","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: \"Cocoa traders’ progress on mapping cocoa supplies\",\n subtitle:\n \"Mapped farms as reported by the companies in CFI reports compared to estimated numbers of supplier farms, 2019 (Source: Trase Supply Chains).\",\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 >= 680 ? \"50\" : \"100\";\n return htl.html`\n${chartTitle}\n

All farms

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

Farms selling to the EU

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

Farms in sourcing traced to cooperatives

\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 = \"Farms Mapped\"","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":158,"value":"chartWidth = width >= 800 ? width / 3 : width","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":160,"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":162,"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: \"All Farms\"\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: \"Farms Traced to Cooperatives\"\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: \"Farms Selling to the EU\"\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