2b:null 2c:["$","title",null,{"children":"OECD Data | Ernesto Laval | Observable"}] 31:T63f,inputs = (structureData) => { d3; let dummy = d3.json() let selections = {}; let seriesStructure = structureData.structure.dimensions.series const dimensionsData = seriesStructure.map((d) => { let options = d.values.map(e => {return {"id":e.id, "name":e.name }}); options = d.id == 'COUNTRY' ? _.sortBy(options, d => d.name) : options; return {"id": d.id, "name":d.name, "options" : options}; }) const form = html` ` form.value = {}; form.addEventListener('input', e => { updateFormValue(); }) function updateFormValue() { const selects = d3.select(form).selectAll("select"); selects.each(function (d) { const id = this.name; selections[id] = []; for (let opt of this.selectedOptions) { opt.value !== "_" ? selections[id].push(opt.value) : null; } }) form.value = buildFilter(selections, structureData) } function buildFilter(selections, structureData) { const values = structureData.structure.dimensions.series.map((d,i) => selections[d.id] && selections[d.id].length ? selections[d.id].join("+") : "") return values.join("."); } updateFormValue(); return form; }32:[] 2f:{"id":"ad375297558e785b","slug":"oecd-data","title":"OECD Data","thumbnail":"729334fc66772bbbd491f915b2754b9d99b328be14cf8c249eacc92e7ee6308c","access_level":"public","create_time":"$D2018-04-29T19:09:23.505Z","update_time":"$D2018-05-19T11:59:34.967Z","view_time":null,"first_public_time":"$D2018-05-15T19:40:53.734Z","fork":false,"stars":2,"starred":false,"owner":{"type":"team","id":"0843f5dc42ca68a0","login":"elaval","name":"Ernesto Laval","avatar_url":"https://avatars-next.observableusercontent.com/089f0414fc9025dadb05cc06d7a406bc9be10093187c46729cb4ba3a4098dc30","tier":"starter_2024"},"version":926,"publish_version":926,"role":null,"authored":false,"authors":[{"type":"individual","id":"e04cd7b5f4351ae9","login":"elaval","name":"Ernesto Laval","avatar_url":"https://avatars-next.observableusercontent.com/089f0414fc9025dadb05cc06d7a406bc9be10093187c46729cb4ba3a4098dc30","tier":null}],"members":[{"type":"individual","id":"e04cd7b5f4351ae9","login":"elaval","name":"Ernesto Laval","avatar_url":"https://avatars-next.observableusercontent.com/089f0414fc9025dadb05cc06d7a406bc9be10093187c46729cb4ba3a4098dc30","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"subscribed":null,"forks":3,"collection":null,"type":"notebook","body":{"title":"OECD Data","cells":[{"id":0,"value":"md`# OECD Data`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":766,"value":"dbData = [\n {id: 'EAG_EARNINGS', name: 'EAG_EARNINGS'},\n {id: 'CHAPTER_C_EAG2014', name: 'CHAPTER_C_EAG2014'},\n {id: 'EAG_FIN_RATIO_CATEGORY', name: 'EAG_FIN_RATIO_CATEGORY'},\n {id: 'SNA_TABLE1', name: 'SNA_TABLE1'},\n \n {id: 'QNA', name: 'QNA'},\n {id: 'EAG_AL', name: 'EAG_AL'}\n]\n\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":771,"value":"dbSelector = () => {\n const form = html`\n \n `\n \n form.addEventListener('input', e => {\n updateFormValue();\n })\n \n function updateFormValue() {\n const select = form.querySelector(\"select\");\n form.value = select.value;\n }\n \n updateFormValue();\n \n return form\n}\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":780,"value":"viewof datasetIdentifier = dbSelector()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":69,"value":"datasetIdentifier","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":563,"value":"viewof myInputs = {\n yield loadingView(\"Loading filter ...\");\n yield filterBuilder(datasetIdentifier);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":668,"value":"myInputs","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":624,"value":"viewof dateRange = {\n const form = html``\n \n d3.select(form).on(\"input\", () => {\n updateFormValue();\n });\n \n function updateFormValue() {\n form.value = {\n from: d3.select(form).select(\"#fromYear\").property(\"value\"),\n to: d3.select(form).select(\"#toYear\").property(\"value\")\n }\n }\n \n updateFormValue();\n\n \n return form\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":848,"value":"tableBuilder = (data) => {\n const columns = _.map(data[0].dimensions, (d,i) => d.id);\n \n return html`\n

\n \n \n ${columns.map(d => `\n \n `)}\n \n \n ${data.map(d => `\n \n ${d.dimensions.map(c => ``).join(\"\")}\n \n \n \n `)}\n\n

\n ${d}\n	METRIC
${c.value.id}	${d.metric[0]}

\n \n `\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":851,"value":"table = tableBuilder(data)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":794,"value":"filterBuilder = (identifier) => {\n let url = `https://stats.oecd.org/sdmx-json/data/${identifier}/all/all?detail=${detail(3)}`\n \n //return inputs(structureData)\n return new Promise((resolve, reject) => {\n d3.json(url)\n .then(data => {\n resolve(inputs(data));\n })\n })\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":561,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":129,"value":"detail = (i) => {\n const options = {\n 1: \"full\", //The data - series and observations - and the attributes will be returned. This is the default\n 2: \"dataonly\", //The attributes will be excluded from the returned message.\n 3: \"serieskeysonly\", // Only the series, but without the attributes and the observations, will be returned. This can be useful for performance reasons, to return the series that match a certain query, without returning the actual data.\n 4: \"nodata\" // The series, including the attributes, will be returned, but the observations will not be returned.\n }\n\n return options[i];\n}\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":746,"value":"data = oecdData(datasetIdentifier, filter)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":743,"value":"oecdData = (identifier, filter) => { \n return new Promise((resolve, reject) => {\n d3.json(`https://stats.oecd.org/sdmx-json/data/${identifier}/${filter}/all?detail=full`)\n .then(a => {\n resolve(extractData(a));\n })\n })\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":759,"value":"identifier = \"EAG_EARNINGS\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":761,"value":"filter = \"AUS.L0T2.T.Y25T64.ALL_EARNERS.EARN_RELATIVE_ISCED_3\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":757,"value":"test = {\n return oecdData(identifier, filter)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":683,"value":"fullData = d3.json(`https://stats.oecd.org/sdmx-json/data/${datasetIdentifier}/${filter}/all? startTime=${dateRange.from}&endTime=${dateRange.to}&detail=${detail(1)}`)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":524,"value":"extractData = (data) => {\n const results = [];\n data.dataSets.forEach((dataSet,i) => {\n _.each(dataSet.series, (d,key) => {\n const dimensions = decodeKey(key, data.structure.dimensions.series);\n const observations = decodeObservation(d.observations, data.structure.dimensions.observation[i]);\n\n observations.forEach(obs => {\n const dims = _.clone(dimensions);\n dims.push(obs.reference);\n results.push({\"dimensions\": dims, \"metric\": obs.metric});\n }) \n })\n })\n \n return results;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":477,"value":"decodeObservation = (observation, structure) => {\n const data = _.map(observation, (d,pos) => {\n const record = {\n reference: {},\n metric:{}\n }\n record.reference['id'] = structure['id'];\n record.reference['name'] = structure['name'];\n record.reference['value'] = structure.values[pos];\n\n record.metric = d\n return record\n })\n return data\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":195,"value":"decodeKey = (key, structure) => {\n const keys = key.split(\":\"); \n \n const values = keys.map((keyValue,pos) => {\n const s = structure[pos];\n return {\n id : s.id,\n name: s.name,\n value: s.values[keyValue]\n }\n })\n \n return values;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":861,"value":"loadingView = (msg) => {\n msg = msg || \"Loading ...\";\n const loading = html`\n

${msg}

\n `\n loading.value = null\n \n return loading\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"d3 = require(\"d3\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":29,"value":"_ = require(\"lodash\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":625,"value":"bootstrapContent = d3.text(\"https://stackpath.bootstrapcdn.com/bootstrap/4.1.1/css/bootstrap.min.css\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":627,"value":"bootstrapStyle = html`\n\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":873,"value":"rxjs = require(\"https://cdnjs.cloudflare.com/ajax/libs/rxjs/6.1.0/rxjs.umd.js\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":878,"value":"keyObservable = {\n const subject = new rxjs.BehaviorSubject(null);\n \n subject.next(myInputs)\n \n return subject.asObservable()\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":897,"value":"new Promise((resolve, reject) => {\n \n \n //const a = new rxjs.Subject();\n \n keyObservable.subscribe(b => resolve(b))\n \n //a.next(2)\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W32","stdlib":"1","titling":"auto"}} 30:"$2f:body"