25:["$","title",null,{"children":"Paraguay Beef Explainer 2021 - Visual 1 (English) | Trase | Observable"}] 49:[{"id":"2d0d976655161596203b3eab9ad62a4b08a8c68bcb40b115ebefacf32ce5a91e92a1bbd4e9f45e8483d1358fe051971145c4c60197c47f06e089c91c201b2585","href":"https://static.observableusercontent.com/files/2d0d976655161596203b3eab9ad62a4b08a8c68bcb40b115ebefacf32ce5a91e92a1bbd4e9f45e8483d1358fe051971145c4c60197c47f06e089c91c201b2585","name":"shiftingBubbleDataRaw.csv","type":"text/csv","lastModified":1624461079349.148,"size":777}] 29:{"id":"cacb4046f40aac47","slug":null,"title":"Paraguay Beef Explainer 2021 - Visual 1 (English)","thumbnail":"0b6696c490a8e8ed4f1f6e1ac11a27ac3e8cc96c7844b1cd2e222315586bcd6d","access_level":"unlisted","create_time":"$D2021-06-23T14:50:11.259Z","update_time":"$D2021-06-23T18:37:07.569Z","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":715,"publish_version":715,"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"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Paraguay Beef Explainer 2021 - Visual 1 (English)","cells":[{"id":0,"value":"md`# Paraguay Beef Explainer 2021 - Visual 1 (English)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":673,"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":5,"value":"md`---\n**Visual 1**: Toggle between two bubble plots, each showing market share and deforestation risk share\n\nhttps://observablehq.com/@trase/shifting-bubble-chart\n\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":260,"value":"titleCard1 = {\n shiftingBubbleChart.update(\"Volume\");\n return titleCard({\n title,\n subtitle,\n extra: html`\n \n \n shiftingBubbleChart.update(\"Volume\")}>\n ${volumeLabel}\n \n \n
\n \n shiftingBubbleChart.update(\"Deforestation_Risk\")}>\n ${deforestationRiskLabel}\n \n \n \n

`,\n footnote\n });\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":22,"value":"chart1 = shiftingBubbleChart","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":703,"value":"md`### Text`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":713,"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":677,"value":"title = english\n ? \"Concentration of deforestation risk\"\n : \"Concentración del riesgo de deforestación\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":681,"value":"subtitle = english\n ? \"In 2019, the beef exported by just five companies from Paraguay was associated with 94% of the deforestation risk of exports from the Chaco\"\n : \"La carne vacuna exportada por solo cinco empresas de Paraguay se asocia al 94 % del riesgo de deforestación de las exportaciones del Chaco\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":688,"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":692,"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":695,"value":"footnote = english\n ? \"Deforestation risk data are only available for the Chaco.\"\n : \"Los datos de riesgo de deforestación solo están disponibles para el Chaco.\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":700,"value":"md`### Chart Data`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":18,"value":"shiftingBubbleData = shiftingBubbleDataRaw.map(d => ({\n key: d.key.replace(/^(FRIGORIFICO|COOPERATIVA)\\s(.*)/, \"$2 $1\"),\n Volume: d.volume,\n Deforestation_Risk: d.deforestation_risk\n}))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":663,"value":"shiftingBubbleDataRaw = FileAttachment(\"shiftingBubbleDataRaw.csv\").csv({\n typed: true\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":656,"value":"// shiftingBubbleDataRaw = 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 country_of_production != country_of_import\n// AND commodity = 'BEEF'\n// AND year = 2019\n// GROUP BY exporter_group\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":16,"value":"import { chart as shiftingBubbleChart, keys } with {\n shiftingBubbleData as data,\n width\n} from \"@trase/shifting-bubble-chart\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":84,"value":"md`## Appendix`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":619,"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":13,"value":"// import { splitgraph } from \"@trase/splitgraph\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W49","stdlib":"1"}} 24:null