2b:null 2c:["$","title",null,{"children":"Asylum Sankey Data Cleaning + Restructure | Tati Kalainoff | Observable"}] 31:[] 2f:{"id":"829a66acf746a618","slug":null,"title":"Asylum Sankey Data Cleaning + Restructure","thumbnail":"4d0615224657865f730c0895a04638b1e8c67e197b57dde13dd93f1f7b4a85c0","access_level":"public","create_time":"$D2022-10-14T15:25:13.366Z","update_time":"$D2022-11-26T14:42:56.143Z","view_time":null,"first_public_time":"$D2022-10-14T15:25:13.366Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"1fc4baec3228f953","login":"tkalainoff","name":"Tati Kalainoff","avatar_url":"https://avatars-next.observableusercontent.com/627ce4e0f63f63a41d76272efc07ef6301765165ed0f39a0d7e4f62c05b71df7","tier":"starter_2024"},"version":353,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"0d22d97d18d5b77d","login":"tkalainoff","name":"Tati Kalainoff","avatar_url":"https://avatars-next.observableusercontent.com/627ce4e0f63f63a41d76272efc07ef6301765165ed0f39a0d7e4f62c05b71df7","tier":null}],"members":[{"type":"individual","id":"0d22d97d18d5b77d","login":"tkalainoff","name":"Tati Kalainoff","avatar_url":"https://avatars-next.observableusercontent.com/627ce4e0f63f63a41d76272efc07ef6301765165ed0f39a0d7e4f62c05b71df7","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Asylum Sankey Data Cleaning + Restructure","cells":[{"id":0,"value":"# Asylum Sankey Data Cleaning + Restructure","pinned":true,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":5,"value":"d3=require('d3');","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":9,"value":"rawdata = d3.json('https://raw.githubusercontent.com/tkalainoff/major-studio/main/qual/data/AFG_2021.json').then(data => _.values(data));","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":12,"value":"data = rawdata[0]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":269,"value":"totalSumofRec = parseInt(d3.sum(data, item => item['Recognized decisions']))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":296,"value":"totalSumofALLDec = parseInt(d3.sum(data, item => item['Total decisions']))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":304,"value":"data[14]['Total decisions']/parseInt(d3.sum(data, item => item['Total decisions']))*100","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":234,"value":"allLinks = wave1.concat(linksRecognized, linksProtected, linksRejected, linksClosed)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":251,"value":"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":21,"value":"// need to figure out how to merge countries to dedeupe\nfunction getNodes(array){\n let nodes = []\n\n for(let i=0; i [item[key], item])).values()]\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":43,"value":"function getLinks_wave1(array){\n let links = []\n\n for(let i=0; i item['Total decisions']))*100 < 1){\n // get target country\n newLink.target = \"Other\"\n \n // get values for target country\n newLink.value = +array[i]['Total decisions']\n newLink.color = \"darkcyan\"\n }\n else{\n // get target country\n newLink.target = array[i]['Country of asylum']\n \n // get values for target country\n newLink.value = +array[i]['Total decisions']\n newLink.color = \"darkcyan\"\n }\n links.push(newLink)\n }\n return links\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":49,"value":"wave1 = getLinks_wave1(data)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":329,"value":"sigCountries = d3.group(wave1, d=> d.target)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":332,"value":"sigCountries_sum = d3.flatRollup(wave1, v => d3.sum(v, d => d.value), d => d.target)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":52,"value":"function getLinks_Rec(array){\n let linksRecognized = []\n\n for(let i=0; i\n item['Recognized decisions']))*100 < 1){\n newLink.source = \"Other\"\n newLink.target = \"recognized\"\n newLink.value = +array[i]['Recognized decisions']\n newLink.color = \"lawngreen\"\n }\n else{\n newLink.source = array[i]['Country of asylum']\n newLink.target = \"recognized\"\n newLink.value = +array[i]['Recognized decisions']\n newLink.color = \"lawngreen\"\n }\n linksRecognized.push(newLink)\n }\nreturn linksRecognized\n}\n\n ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":89,"value":"linksRecognized = getLinks_Rec(data)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":202,"value":"function getLinks_Pro(array){\n let linksProtected = []\n\n for(let i=0; i\n item['Complementary protection']))*100 < 1){\n newLink.source = \"Other\"\n newLink.target = \"protected\"\n newLink.value = +array[i]['Complementary protection']\n newLink.color = \"gold\"\n }\n else{\n newLink.source = array[i]['Country of asylum']\n newLink.target = \"protected\"\n newLink.value = +array[i]['Complementary protection']\n newLink.color = \"gold\"\n }\n linksProtected.push(newLink)\n }\nreturn linksProtected\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":205,"value":"linksProtected = getLinks_Pro(data)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":211,"value":"function getLinks_Rej(array){\n let linksRejected = []\n\n for(let i=0; i\n item['Rejected decisions']))*100 < 1){\n newLink.source = \"Other\"\n newLink.target = \"rejected\"\n newLink.value = +array[i]['Rejected decisions']\n newLink.color = \"firebrick\"\n }\n else{\n newLink.source = array[i]['Country of asylum']\n newLink.target = \"rejected\"\n newLink.value = +array[i]['Rejected decisions']\n newLink.color = \"firebrick\"\n }\n linksRejected.push(newLink)\n }\nreturn linksRejected\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":213,"value":"linksRejected = getLinks_Rej(data)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":219,"value":"function getLinks_Clo(array){\n let linksClosed = []\n\n for(let i=0; i\n item['Otherwise closed']))*100 < 1){\n newLink.source = \"Other\"\n newLink.target = \"closed\"\n newLink.value = +array[i]['Otherwise closed']\n newLink.color = \"mediumvioletred\"\n }\n else{\n newLink.source = array[i]['Country of asylum']\n newLink.target = \"closed\"\n newLink.value = +array[i]['Otherwise closed']\n newLink.color = \"mediumvioletred\"\n }\n linksClosed.push(newLink)\n }\nreturn linksClosed\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":221,"value":"linksClosed = getLinks_Clo(data)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W31","stdlib":"1","titling":"auto"}} 30:"$2f:body"