2b:null 2c:["$","title",null,{"children":"IAM Case Data Model | Aaron Kyle Dennis | Observable"}] 31:[] 2f:{"id":"b1a76968dda00821","slug":"iam-case-data-model","title":"IAM Case Data Model","thumbnail":"c2eb6244556902d4cf617dafcc25bf65aa8295e9b7ce8a56e22122d09a753bd6","access_level":"public","create_time":"$D2019-04-14T12:50:20.998Z","update_time":"$D2019-04-16T15:24:35.117Z","view_time":null,"first_public_time":"$D2019-04-16T01:16:03.771Z","fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"8d652a601386fcf4","login":"aaronkyle","name":"Aaron Kyle Dennis","avatar_url":"https://avatars-next.observableusercontent.com/eb6d0b32ccc6c8febbf105ce4d2a938819bcbd1c6a2c108d3a9c01745d3590f2","tier":"starter_2024"},"version":210,"publish_version":210,"role":null,"authored":false,"authors":[{"type":"individual","id":"a7fa3027921865cf","login":"aaronkyle","name":"Aaron Kyle Dennis","avatar_url":"https://avatars-next.observableusercontent.com/eb6d0b32ccc6c8febbf105ce4d2a938819bcbd1c6a2c108d3a9c01745d3590f2","tier":null}],"members":[{"type":"individual","id":"a7fa3027921865cf","login":"aaronkyle","name":"Aaron Kyle Dennis","avatar_url":"https://avatars-next.observableusercontent.com/eb6d0b32ccc6c8febbf105ce4d2a938819bcbd1c6a2c108d3a9c01745d3590f2","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"subscribed":null,"forks":8,"collection":{"id":"2f87dff3290cc363","slug":"independent-accountability-mechanisms-iam","title":"Independent Accountability Mechanisms (IAM)","owner":{"id":"8d652a601386fcf4","login":"aaronkyle","name":"Aaron Kyle Dennis"}},"type":"notebook","body":{"title":"IAM Case Data Model","cells":[{"id":0,"value":"md`# IAM Case Data Model`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":26,"value":"md`\nThis notebook outlines an approach to defining a set of common data attribute names to describe independent accountability mechanisms' case data. Specifically, this work focuses on members of [IAMnet](http://independentaccountabilitymechanism.net/).\n\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":25,"value":"md`\nIf you're looking for the notebook that addresses IAM case-handling processes, [click here](https://observablehq.com/@aaronkyle/iam-case-handling-data-model).\n\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":39,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":30,"value":"md`\n## IAMnet Member Organizations\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":31,"value":"html`

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":50,"value":"md`\nPlease note that the acronyms supplied in this table are my own creations. To help reduce ambiguity, I define IAM acronyms to also reference the institution it oversees. Where IAM names are similar, I will use full acronyms. Otherwise I use the prefix.\n\nI haven't yet defined acroynms for a few organizations. Some institutions, like ADB, have split functions. Others have single-word names, which looks weird when rendering tables with prefixes only. I haven't yet concluded how to handle these cases. Please offer your suggestions and proposals!\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":36,"value":"iam_member_table = {\nvar html = \"\";\n html+=\"\";\n html+=\"\";\n html+=\"\";\nfor (var i = 1; i < iam_data.length; i++) {\n html+=\"\";\n html+=\"\";\n html+=\"\";\n html+=\"\";\n html+=\"\";\n html+=\"\";\n}\nhtml+=\"

\"+iam_data[0].iam+\"	\"+iam_data[0].iam_acronym+\"	\"+iam_data[0].institution+\"	\"+iam_data[0].institution_acronym+\"
\"+iam_data[i].iam+\"	\"+iam_data[i].iam_acronym+\"	\"+iam_data[i].institution+\"	\"+iam_data[i].institution_acronym+\"

\";\ndocument.getElementById(\"box\").innerHTML = html;\n\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":23,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":46,"value":"md`## IAM Case Data: Toward a Common List of Attributes`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":168,"value":"md`\nTo reiterate the point I made at the outset of this notebook: My intention is to outline an approach to defining common data attribute names for comparing IAMs. To illustrate this approach, this notebook takes inventory of case data attributes published by two IAMs: the Inspection Panel and CAO. The data attribute values I define here, however, are likely to change as I continue working through other IAM case data disclosures and refining the data model.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":11,"value":"md`\nFor a bit of additional context: When I started on this process in ca. [July 2017 or so](https://github.com/aaronkyle/social-development/commit/c862356f4df0c3efbaf3b89e308e467b486cea10#diff-202013310fa60f390fdb196b83cdce36), I started with [a subset of the IAMnet member website 'case detail' pages](https://github.com/aaronkyle/iam-research). I haven't yet gotten through all IAM websites to finish building out a complete list of attributes.\n\nIf you decide to use these source datasets for your own research, **be warned**—they are already out of date. \n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":15,"value":"md`\nAs I eventually get back to the task of comparing IAM caseloads, I'll return to updating our shared case data repositories. Eventually, I also plan to expand the number of institutions for which I have full case data. Before that, however, I have other chores pertinent to model development and data verification.\n\nIf any of this interests you, please feel free to jump in and help!\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":69,"value":"md`#### Inspection Panel`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":86,"value":"md`The Inspection Panel's [list of cases](http://www.inspectionpanel.org/panel-cases?search=&order=field_case_date_received&sort=desc) provides a table organized into the following attributes:`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":67,"value":"html`\n\n\n\n\n\n\n\n

Case #

Project Title

Country

Year

\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":71,"value":"md`\nLet's re-cast the attribute names slightly (more verbosely) so that they might serve more generally. \n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":73,"value":"md`\n case_number\n complaint_country\n complaint_received_fy\n url\n project_name_ipn_wb\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":90,"value":"md`\nIt's a good starting point, but five attribute values hardly suffice for describing an IAM's caseload in any detail. Let's see what additional case data attributes IPN publishes for specific projects:\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":91,"value":"html`\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Case Number	Received	Request
Requesters	Case Description
Operations	Project ID	Environmental Category	Project Approval Date
Documents

\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":98,"value":"md`\n\nBetter.\n\nLet's also re-cast these attributes for our more generalizable data model:\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":95,"value":"md`\n\n case_number\n complaint_received\n complaint_id\n\n complainant_description\n complaint_description\n\n institution\n project_number\n project_env_category\n project_board_approval\n\n documents\n\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":106,"value":"md`\nNow let's build out a means of displaying these data so that we can verify that everything's working...\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":112,"value":"table(case_data_ipn_wb_table, { \n title: \"World Bank Inspection Panel Compliance Cases\",\n sortable: true,\n pageSize: 8,\n}) ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":100,"value":"md`\nTerrific. Let's keep going. I'll look into what case information other IAMs are collecting, and add any new attributes to our model.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":83,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":82,"value":"md`#### CAO`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":131,"value":"md`\nCAO's [list of cases](http://www.cao-ombudsman.org/cases/default.aspx) provides quite a few data points, though it's not as immediately apparent as with the IPN list discussed above. In my reading, here's what we've got:\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":133,"value":"md`\n\n region\n country\n function\n case_name\n status\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":136,"value":"md`\nAlso a good starting point, but let's see what additional case data attributes CAO publishes for specific projects:\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":140,"value":"md`\n\n complaint_region\n complaint_country\n case_name\n complainant_description\n complaint_received\n complaint_issues\n case_status\n complaint_description\n institution\n project_name \n project_number\n project_department\n client\n project_sector\n project_region\n project_country\n project_env_category\n project_commitment\n\n documents\n\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":145,"value":"md`Wow! CAO's case data pages extends our list of IAM case data attributes quite a bit.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":148,"value":"md`\nNow let's build out a means of displaying these data so that we can verify that everything's working...\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":150,"value":"table(case_data_cao_ifc_miga_table, { \n title: \"IFC/MIGA CAO Cases\",\n sortable: true,\n pageSize: 8,\n}) ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":17,"value":"md`\nNice.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":129,"value":"md`\nEventually, we can work through all IAMnet members' case disclosures [to arrive at a comprehensive list of attributes](https://observablehq.com/@aaronkyle/iam-case-data-attributes). For now, this should suffice as a demonstration of how I'll go about compiling target attributes for describing IAM case data. Yay!\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":80,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":78,"value":"md` ## Appendix`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":54,"value":"data_url_ipn_wb = \"https://docs.google.com/spreadsheets/d/e/2PACX-1vQOJQag22Qyn48CyTUuqWCyZkc970keBEHIn6nbGSSW2Y6QFr-FHFjc9YqUN2kAHTgYimHVyIOaVrk8/pub?gid=837526710&single=true&output=tsv\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":57,"value":"case_data_ipn_wb = { // this is a JS Array of Objects; the key-value pairs consist of the column headers and the cell data\n let case_data_ipn_wb =[];\n const spreadsheet = await d3.tsv(data_url_ipn_wb).then(data => data.forEach(d => case_data_ipn_wb.push(d))); // d3.tsv returns a Promise\n return case_data_ipn_wb;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":121,"value":"case_data_ipn_wb_table = case_data_ipn_wb.map(({case_number, complaint_country, project_name_ipn_wb}) => ({\n case_number,\n complaint_country,\n project_name_ipn_wb,\n\n}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":154,"value":"data_url_cao_ifc_miga = \"https://docs.google.com/spreadsheets/d/e/2PACX-1vQOJQag22Qyn48CyTUuqWCyZkc970keBEHIn6nbGSSW2Y6QFr-FHFjc9YqUN2kAHTgYimHVyIOaVrk8/pub?gid=71091982&single=true&output=tsv\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":160,"value":"case_data_cao_ifc_miga = { // this is a JS Array of Objects; the key-value pairs consist of the column headers and the cell data\n let case_data_cao_ifc_miga =[];\n const spreadsheet = await d3.tsv(data_url_cao_ifc_miga).then(data => data.forEach(d => case_data_cao_ifc_miga.push(d))); // d3.tsv returns a Promise\n return case_data_cao_ifc_miga;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":162,"value":"case_data_cao_ifc_miga_table = case_data_cao_ifc_miga.map(({case_name, complaint_country, project_name}) => ({\n case_name,\n complaint_country,\n project_name,\n\n}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":21,"value":"data_url = \"https://docs.google.com/spreadsheets/d/e/2PACX-1vQOJQag22Qyn48CyTUuqWCyZkc970keBEHIn6nbGSSW2Y6QFr-FHFjc9YqUN2kAHTgYimHVyIOaVrk8/pub?gid=2055378148&single=true&output=tsv\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":34,"value":"iam_data = { // this is a JS Array of Objects; the key-value pairs consist of the column headers and the cell data\n let iam_data =[];\n const spreadsheet = await d3.tsv(data_url).then(data => data.forEach(d => iam_data.push(d))); // d3.tsv returns a Promise\n return iam_data;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":3,"value":"import {table} from \"@tmcw/tables/2\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":5,"value":"d3 = require('d3')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"}],"files":"$W31","stdlib":"1","titling":"auto"}} 30:"$2f:body"