2c:null 2d:["$","title",null,{"children":"Commodity Trade Tensions: Evidence from Tanker Traffic Data | Alessandra Sozzi | Observable"}] 32:T53b,map_mtc_all = { const plot = Plot.plot({ projection: "equal-earth",//"equirectangular", width, marks: [ // Map Plot.sphere({stroke: "#aaa", strokeWidth: 0.4}), Plot.geo(topojson.feature(world, world.objects.land), { fill: "#eee", stroke: "#aaa", strokeWidth: 0.4}), //topojson.feature(world, world.objects.countries).features //Plot.geo(topojson.feature(world, world.objects.countries).features, { fill: "#eee", stroke: "#aaa", strokeWidth: 0.4}), // Routes Plot.geo(negatives, { stroke: "#0052F5", strokeWidth: 0.7, opacity:0.2}), Plot.geo(positives, { stroke: "#A7001A", strokeWidth: 0.7, opacity:0.2}), // Bubbles Plot.dot(all_negatives_bubbles_by_mtc, {x: "longitude", y: "latitude", r: x=> scaleBubbleMTC(x.weight), strokeWidth: 0.2, stroke: "#0052F5", fill: "#0052F5", fillOpacity: 0.4}), Plot.dot(all_positives_bubbles_by_mtc, {x: "longitude", y: "latitude", r: x=> scaleBubbleMTC(x.weight), strokeWidth: 0.2, stroke: "#A7001A", fill: x=> "#A7001A", fillOpacity: 0.4}), // Legend //Plot.dot(legend, // {x: "longitude", y: "latitude", r: x=> scaleBubbleMTC(x.weight), // strokeWidth: 0.2, stroke: "#CCCCCC", fill: x=> "#CCCCCC", fillOpacity: 0.4}) ] }) return plot }33:[{"id":"049018a639b15487a0db027e2a9a4963f53d3b5166190f7df5607dbf5a08b4de69f66df14e1125bd382c43d88209876d9a11582ebc0bf93d1c06b19f3c897f87","href":"https://static.observableusercontent.com/files/049018a639b15487a0db027e2a9a4963f53d3b5166190f7df5607dbf5a08b4de69f66df14e1125bd382c43d88209876d9a11582ebc0bf93d1c06b19f3c897f87","name":"MT_ports_bubbles@27.csv","type":"text/csv","lastModified":1692672521945.193,"size":18670},{"id":"0d3b627ee724daeadccbee7ffed25e2ab64fc57ae6f901badb04faccf135cfde7e739a9d7cd4cad9c21c9d8f168d28b849dab8cf3df8dda781e3b2de4b8b80a5","href":"https://static.observableusercontent.com/files/0d3b627ee724daeadccbee7ffed25e2ab64fc57ae6f901badb04faccf135cfde7e739a9d7cd4cad9c21c9d8f168d28b849dab8cf3df8dda781e3b2de4b8b80a5","name":"single_sample_lines(1)@1.geojson","type":"application/geo+json","lastModified":1692673844550.225,"size":9494056},{"id":"4cfecd674980ab535f6fde9aaad77ffe25e2f1727ba78e31ae62abd70a19e2189736260707d7ad82310a9b579fd2fd9316cb44d56d782fda754a0071beeeef11","href":"https://static.observableusercontent.com/files/4cfecd674980ab535f6fde9aaad77ffe25e2f1727ba78e31ae62abd70a19e2189736260707d7ad82310a9b579fd2fd9316cb44d56d782fda754a0071beeeef11","name":"IMF_CountryPolys.json","type":"application/json","lastModified":1693659886271.21,"size":1233672}] 30:{"id":"2cb5826b05fd9e14","slug":null,"title":"Commodity Trade Tensions: Evidence from Tanker Traffic Data","thumbnail":"85ceb17b7cdf13f602a92505d801d35c3345c34c79c160c4dac8c51f4b60bcab","access_level":"public","create_time":"$D2023-08-22T02:48:41.945Z","update_time":"$D2024-01-11T23:05:31.127Z","view_time":null,"first_public_time":"$D2023-08-22T02:48:41.945Z","has_unpublished_edits":null,"fork":true,"stars":0,"starred":false,"owner":{"type":"team","id":"feafd296ad17b11e","login":"alessandrasozzi","name":"Alessandra Sozzi","avatar_url":"https://avatars-next.observableusercontent.com/5e9d0797182c08ccefb659313caa998626fdf2ce2bfc2ffc322b83243c07d18b","tier":"starter_2024"},"version":1045,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"6e90bfac93d169be","login":"alessandrasozzi","name":"Alessandra Sozzi","avatar_url":"https://avatars-next.observableusercontent.com/5e9d0797182c08ccefb659313caa998626fdf2ce2bfc2ffc322b83243c07d18b","tier":null}],"members":[{"type":"individual","id":"6e90bfac93d169be","login":"alessandrasozzi","name":"Alessandra Sozzi","avatar_url":"https://avatars-next.observableusercontent.com/5e9d0797182c08ccefb659313caa998626fdf2ce2bfc2ffc322b83243c07d18b","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Commodity Trade Tensions: Evidence from Tanker Traffic Data","cells":[{"id":0,"value":"# Commodity Trade Tensions: Evidence from Tanker Traffic Data \n\n### Changes in Tanker Shipments from Russia’s Ports from 2019:Q2 to 2023:Q2\n*The bubble size indicates the magnitude of the change (in Metric tons) for the destination port. Lines indicate travel routes. Decreases in blue and increases in red*\n\n\nSince its invasion of Ukraine, Russia’s oil exports have been subject to sanctions and have been voluntarily shunned by firms. What has been the impact on oil trade flows? Granular real-time data on tanker shipping patterns from the Automatic Identification System (AIS) data uncover significant shifts in routes, resulting in economic inefficiencies.\n\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":793,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":883,"value":"

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1005,"value":"### Single scale for bubbles radius ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":745,"value":"// Create a unique scale conversion for red and blu bubbles\nscaleBubbleMTC = d3.scaleSqrt()\n .domain(extentMTC)\n .range([0, 100]);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":996,"value":"### Extents","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":750,"value":"extentMTC = [MTC_THRESHOLD, Math.max(neg_extent_mtc[1], pos_extent_mtc[1])]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":718,"value":"neg_extent_mtc = d3.extent(all_negatives_bubbles_by_mtc.map(x=> x.weight))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":710,"value":"pos_extent_mtc = d3.extent(all_positives_bubbles_by_mtc.map(x=> x.weight))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":998,"value":"### Positive & Negative Sipping Lanes & Bubbles by difference in Metric Tons received \nDifference is calculated as total Metric Tons received in 2023Q2 minus total Metric Tons received in 2019Q2\nDifferences less than MTC_THRESHOLD in absolute values are excluded","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":704,"value":"// Exclude differences that are less than MTC_THRESHOLD Metric Tons in absolute values\nMTC_THRESHOLD = 10000","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1023,"value":"legend = [\n {latitude: -50, longitude: -20, weight: 2500000, portid: \"l1\", country: \"NL\", mtc_difference: -2500000},\n {latitude: -50, longitude: 0, weight: 1500000, portid: \"l1\", country: \"NL\", mtc_difference: -1500000},\n {latitude: -50, longitude: 15, weight: 750000, portid: \"l1\", country: \"NL\", mtc_difference: -750000},\n {latitude: -50, longitude: 30, weight: 100000, portid: \"l1\", country: \"NL\", mtc_difference: -100000},\n {latitude: -50, longitude: 45, weight: 100000, portid: \"l1\", country: \"NL\", mtc_difference: 100000},\n {latitude: -50, longitude: 60, weight: 750000, portid: \"l1\", country: \"NL\", mtc_difference: 750000},\n {latitude: -50, longitude: 75, weight: 1500000, portid: \"l1\", country: \"NL\", mtc_difference: 1500000},\n {latitude: -50, longitude: 90, weight: 2500000, portid: \"l1\", country: \"NL\", mtc_difference: 2500000},\n {latitude: -50, longitude: 105, weight: 3500000, portid: \"l1\", country: \"NL\", mtc_difference: 3500000},\n\n \n]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":701,"value":"// All the destination ports where the difference in Metric Tons is negative & greather than MTC_THRESHOLD in absolute values\nall_negatives_bubbles_by_mtc = bubbles.filter(x => x.mtc_diff < - MTC_THRESHOLD).map(x => {\n var obj = {\n latitude: x.port_lat,\n longitude: x.port_lon,\n weight: Math.abs(x.mtc_diff),\n portid: x.Arriving_Port,\n country: x.Arriving_Country,\n mtc_difference: x.mtc_diff\n\n }\n return obj\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":708,"value":"// All the destination ports where the difference in Metric Tons is positive & greather than MTC_THRESHOLD\nall_positives_bubbles_by_mtc = bubbles.filter(x => x.mtc_diff > MTC_THRESHOLD).map(x => {\n var obj = {\n latitude: x.port_lat,\n longitude: x.port_lon,\n weight: Math.abs(x.mtc_diff),\n portid: x.Arriving_Port,\n country: x.Arriving_Country,\n mtc_difference: x.mtc_diff\n }\n return obj\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":272,"value":"positives = shipping_lanes.features.filter(x => x.properties.typediff == \"positive\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":274,"value":"negatives = shipping_lanes.features.filter(x => x.properties.typediff == \"negative\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":270,"value":"shipping_lanes = FileAttachment(\"single_sample_lines(1)@1.geojson\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":648,"value":"bubbles = d3.csvParse(await FileAttachment(\"MT_ports_bubbles@27.csv\").text(), d3.autoType)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1001,"value":"### Boundaries ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":399,"value":"world = d3.json(\"https://cdn.jsdelivr.net/npm/world-atlas@2/countries-110m.json\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1008,"value":"export_output_simplified = FileAttachment(\"IMF_CountryPolys.json\").json()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W33","stdlib":"1","titling":"auto"}} 31:"$30:body"