25:["$","title",null,{"children":"Paraguay Soy Explainer 2021 - Bubble | Trase | Observable"}] 49:[{"id":"2b03ade3ff1c40188ce5fff93c03b79bac8fbdbec1c5b1fc9961e97ca2d03617cd524f2b0ece09ebb6a48fff44c998a55d49d0ff54d11ddce44a1061898b7bba","href":"https://static.observableusercontent.com/files/2b03ade3ff1c40188ce5fff93c03b79bac8fbdbec1c5b1fc9961e97ca2d03617cd524f2b0ece09ebb6a48fff44c998a55d49d0ff54d11ddce44a1061898b7bba","name":"raw.csv","type":"text/csv","lastModified":1624463677205.68,"size":1614}] 29:{"id":"31b03d422342fcdb","slug":null,"title":"Paraguay Soy Explainer 2021 - Bubble","thumbnail":"ae125327bdddaef960971c7251ece1f2186e3315766ecf1aab5f87a56a219769","access_level":"unlisted","create_time":"$D2021-06-23T15:42:01.442Z","update_time":"$D2021-06-28T14:50:54.787Z","view_time":null,"first_public_time":null,"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":826,"publish_version":826,"role":null,"authored":false,"authors":[{"type":"individual","id":"914ea1886092acdd","login":"harrybiddle","name":"Harry Biddle","avatar_url":"https://avatars-next.observableusercontent.com/cb2de2eafd016bd637f3f9ddfb40954d06828995d8fd2e21d31a29d494015b09","tier":null,"bio":"","followed_by_you":false,"follows_you":false}],"members":[{"type":"individual","id":"914ea1886092acdd","login":"harrybiddle","name":"Harry Biddle","avatar_url":"https://avatars-next.observableusercontent.com/cb2de2eafd016bd637f3f9ddfb40954d06828995d8fd2e21d31a29d494015b09","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":1,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Paraguay Soy Explainer 2021 - Bubble","cells":[{"id":0,"value":"md`# Paraguay Soy Explainer 2021 - Bubble`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":783,"value":"language = \"english\" // else, spanish","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":9,"value":"md`---\n**Visual 2**: Bubble chart of volumes swapping market share and deforestation risks - traders\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":282,"value":"chartTitle = {\n chart2.update(\"Volume\");\n return titleCard({\n title,\n subtitle,\n extra: [\n html`\n \n \n chart.update(\"Volume\")}>\n ${volumeLabel}\n \n \n
\n \n chart.update(\"Deforestation_Risk\")}>\n ${deforestationRiskLabel}\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":84,"value":"chart2 = chart","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":74,"value":"draw = chart.update(\"Volume\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":761,"value":"md`## Text`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":809,"value":"english = language == \"english\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":767,"value":"title = english\n ? \"Concentration of exports\"\n : \"El comercio de soja de Paraguay está concentrado\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":768,"value":"subtitle = english\n ? \"Multinational grain traders ADM, Cargill and Louis Dreyfus dominate Paraguay's soy trade in 2019, alongside emerging traders such as COFCO and Sodrugestvo\"\n : \"Las multinacionales de cereales ADM, Cargill y Louis Dreyfus dominan el comercio de la soja paraguaya, junto con comerciantes emergentes como COFCO y Sodrugestvo (2019)\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":775,"value":"volumeLabel = english ? \"Volume (Tonnes)\" : \"Volumen (toneladas)\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":779,"value":"deforestationRiskLabel = english\n ? \"Deforestation risk (Ha)\"\n : \"Riesgo de deforestación (ha)\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":763,"value":"md`## Data`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":787,"value":"data = raw.map(d => ({\n key: d.key,\n Volume: d.volume,\n Deforestation_Risk: d.deforestation_risk,\n Year: d.year\n}))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":799,"value":"raw = FileAttachment(\"raw.csv\").csv({typed: true})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":70,"value":"// raw = splitgraph`\n// SELECT\n// exporter_group as key,\n// SUM(volume) AS Volume,\n// SUM(commodity_deforestation_risk) AS deforestation_risk\n// FROM \"trase-development/supply-chains-latest\".\"supply-chains\"\n// WHERE country_of_production = 'PARAGUAY'\n// AND commodity = 'SOY'\n// AND year = 2019\n// AND exporter_group IS NOT null\n// GROUP BY exporter_group, year\n// ORDER BY volume DESC\n// `","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":73,"value":"import { chart, keys } with {\n data,\n draw,\n width\n} from \"@trase/shifting-bubble-chart\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":12,"value":"md`## Appendix`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":265,"value":"import { titleCard, html } from \"0b0a1fb420786911@643\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"// import { splitgraph } from \"@trase/splitgraph\"","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