27:null 28:["$","title",null,{"children":"ADB Case Data | Aaron Kyle Dennis | Observable"}] 2d:[] 2b:{"id":"60e088da8b56f9f0","slug":null,"title":"ADB Case Data","thumbnail":"f08d66e5ac91a28823707de66d38ebc4858b1314591a463a1af21338e999a813","access_level":"unlisted","create_time":"$D2019-04-14T13:08:20.645Z","update_time":"$D2021-03-19T06:40:40.778Z","view_time":null,"first_public_time":null,"has_unpublished_edits":null,"fork":{"id":"b1a76968dda00821","slug":"iam-case-data-model","title":"IAM Case Data Model","owner":{"id":"8d652a601386fcf4","login":"aaronkyle","name":"Aaron Kyle Dennis"}},"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":305,"publish_version":305,"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,"lapsed":null,"subscribed":null,"forks":0,"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":"ADB Case Data","cells":[{"id":0,"value":"md`# ADB Case Data`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":27,"value":"md`## [Accountability Mechanism (AM-ADB)](https://www.adb.org/site/accountability-mechanism/main)
\n[Office of the Special Project Facilitator (OSPF)](https://www.adb.org/site/accountability-mechanism/problem-solving-function/office-special-facilitator) & [Compliance Review Panel (CRP)](http://compliance.adb.org/dir0035p.nsf/alldocs/BDAO-7XG526?OpenDocument)\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":186,"value":"md`ADB's Accountability Mechanism consists of two separate but complementary functions: problem solving (via the [OSPF](https://www.adb.org/site/accountability-mechanism/problem-solving-function/office-special-facilitator)) and compliance review (via the [CRP](http://compliance.adb.org/dir0035p.nsf/alldocs/BDAO-7XG526?OpenDocument)). People who seek access to the Accountability Mechanism send complaints to the Complaint Receiving Officer, which forwards the complaint to responsible function. [OSPF](https://www.adb.org/site/accountability-mechanism/problem-solving-function/complaint-registry-project) and the [CRP](http://compliance.adb.org/dir0035p.nsf/alldocs/BDAO-7XGAWN?OpenDocument&expandable=2) also maintain separate complaints registries.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":204,"value":"md`### [Complaint Receiving Officer's Complaints Registry](https://www.adb.org/site/accountability-mechanism/complaints-receiving-officer/complaints-registry)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":57,"value":"md`\nADB's Complaint Receiving Officer's online [Complaints Registry](https://www.adb.org/site/accountability-mechanism/complaints-receiving-officer/complaints-registry \"complaints_registry\") lists complaints received after 2018 and provides a PDF of it's [Complaints Registry Archive](http://compliance.adb.org/dir0035p.nsf/alldocs/BDAO-7XGAWN?OpenDocument) of complaints received from 2012 until 2018.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":33,"value":"md`\nData attributes listed in these registries are structured as follows:\n`\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":46,"value":"html`\n\t\n\n\n\n\n\n\n\n\n\n\n\n\n\n\t

No.\t	ADB-assisted Project\t	Forwarded to\t\t	Salient Dates\t
	Location\t	Name\t	Number\t	Project Data Sheet Overview

\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":85,"value":"md`Let's re-compile these attributes for our general data model—being a bit more verbose with the naming conventions:`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":66,"value":"md`\n url\n complaint_number\n complaint_country\n project_name\n project_url\n complaint_received_date\n acknowledgement_date\n forward_date\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":94,"value":"md`Sweet :) That takes care of the high-level data reflected in the CRO's registry. Next let's turn to AM-ADB's two functions: problem-solving and compliance review. `","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":36,"value":"md`\n### Compliance Review Panel (CRP)\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":269,"value":"md`ADB's Compliance Review Panel investigates alleged noncompliance by ADB with its operational policies and procedures that has caused, or is likely to cause, direct and material harm to project-affected people.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":271,"value":"md`Data attributes listed in CRP's [Registry of Complaints](http://compliance.adb.org/dir0035p.nsf/alldocs/BDAO-7XGAWN?OpenDocument&expandable=2) are structured as follows:`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":260,"value":"html`\n\t\n\n\n\n\n\n\t

Complaint number\t

Date received*\t

Project name\t

\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":274,"value":"md`Within each project page, the CRP provides the following additional details:`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":74,"value":"html`\n\t\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\t

Project information\t
Request number\t
Project name\t
Project number\t
Country\t
Summary\t
Progress Report\t
Steps and Milestones\t	Date\t	Remarks and Attachments\t
Step 1. Requesting Management Response\t
Step 2. Determining Eligibility\t
Step 3. Board Authorization of Compliance Review\t
Step 4. Conducting compliance review\t
Step 5. CRP's Draft Report\t
Step 6. CRP's Final Report\t
Step 7. ADB Board consideration of the CRP's Final Report\t
Step 9. ADB Board's Decision\t
Step 10. Monitoring of Remedial Actions\t

\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":82,"value":"md`Let's add in the new attributes, continuing our practice of verbose and patterned naming conventions:`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":296,"value":"md`\n request_number\n project_name\n project_number\n project_country\n management_response_request_date\n management_response_request_remarks\n management_response_request_attachments\n eligibility_determination_date\n eligibility_determination_remarks\n eligibility_determination_attachments\n compliance_review_board_authorization_date\n compliance_review_board_authorization_remarks\n compliance_review_board_authorization_attachments\n compliance_review_duration\n compliance_report_draft_date\n compliance_report_final_date\n compliance_report_board_considation_date\n compliance_report_board_decision_date\n compliance_report_board_decision_outcome\n compliance_monitoring\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":286,"value":"md`### Office of the Special Project Facilitator (OSPF) `","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":282,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":103,"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","output":"$undefined","database":"$undefined"},{"id":213,"value":"md`Toward this end, we'll draw together the relevant projects from the ADB [Complaints Registry](https://www.adb.org/site/accountability-mechanism/complaints-receiving-officer/complaints-registry \"complaints_registry\") (Jan 2018 - current) and the [Complaints Registry Archive](http://compliance.adb.org/dir0035p.nsf/alldocs/BDAO-7XGAWN?OpenDocument) (2012-2018).\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":149,"value":"md`## ADB Complaint's Mechanism Compliance Cases`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":106,"value":"table(adb_am_compliance_case_data_table, { \n title: \"ADB Compliance Cases\",\n sortable: true,\n paged: 5,\n}) ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":154,"value":"md`Terrific! Our table lacks a bit for formatting, but we'll return to that later. Good enough for now.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":197,"value":"md`\nOSPF\n`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":155,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":158,"value":"md`## Appendix`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":18,"value":"adb_am_compliance_case_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_compliance).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","output":"$undefined","database":"$undefined"},{"id":116,"value":"adb_am_compliance_case_data_table = adb_am_compliance_case_data.map(({key, case_number, complaint_received, project_name_am_adb, url,}) => ({\n case_number,\n complaint_received,\n project_name_am_adb,\n url,\n}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":21,"value":"data_url_compliance = \"https://docs.google.com/spreadsheets/d/e/2PACX-1vQOJQag22Qyn48CyTUuqWCyZkc970keBEHIn6nbGSSW2Y6QFr-FHFjc9YqUN2kAHTgYimHVyIOaVrk8/pub?gid=0&single=true&output=tsv\"","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":3,"value":"import {table} from \"@tmcw/tables\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2,"value":"dot = require(\"@observablehq/graphviz@0.2\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W2d","stdlib":"1","titling":"auto"}} 2c:"$2b:body"