31:[] 2f:{"title":"Inspection Panel - World Bank Case Data","cells":[{"id":0,"value":"md`# Inspection Panel - World Bank Case Data`","pinned":false,"hidden":false,"mode":"ojs"},{"id":26,"value":"md`\nThis notebook is part of [a collection](https://observablehq.com/@aaronkyle/iam-case-data-model/forks) of analyses seeking to define a common attributes that describe independent accountability mechanisms' caseload data. The general methodology for these analyses is described [here](https://observablehq.com/@aaronkyle/iam-case-data-model).\n`","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"id":244,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs"},{"id":69,"value":"md`#### Inspection Panel`","pinned":false,"hidden":false,"mode":"ojs"},{"id":246,"value":"md`\nThe [Inspection Panel](https://www.inspectionpanel.org/) is the independent accountability mechanism for the [World Bank](https://www.worldbank.org/) ([IBRD](https://www.worldbank.org/en/who-we-are/ibrd)/[IDA](http://ida.worldbank.org/)).\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":250,"value":"md`\nThe Inspection Panel's [website](https://www.inspectionpanel.org) discloses [case data about Panel cases](http://www.inspectionpanel.org/panel-cases) in map, list and graphical formats. \n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":86,"value":"md`IPN's [list of cases](http://www.inspectionpanel.org/panel-cases) is organized into the following attributes:`","pinned":false,"hidden":false,"mode":"ojs"},{"id":67,"value":"html`\n\n\n\n\n\n\n\n

Case #

Project Title

Country

Year

\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":71,"value":"md`\nLet's re-cast these attributes slightly (and more verbosely) so that to better serve our more general model. \n`","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"id":90,"value":"md`\nUpon clicking into a specific case, the IPN website publishes further processing and status details, organized roughly as follows:\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":91,"value":"html`\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n

Country: Project Name (Project #)
Case Status / Case Tracker
Case Number	Received	Request
Requesters
Case Description
Project Information
Operations	Project ID	Environmental Catego ry	Project Approval Date
Documents
Publication Date

\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":265,"value":"md`\nLet's also transcribe these attributes to better fit our generalized data model. \n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":95,"value":"md`\n\n project_country\n project_name\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"},{"id":275,"value":"md`\nAnd not to forget the case status tracker, which comprises the following stages:\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":280,"value":"md`\n\n\n\n\n\n\n\n\n\n\n\n\n

Notice of Receipt

Registration Decision

Management Response

Eligibility Report

Board Approval

Investigation Ongoing

Investigation Report

Management Report and Recommendation

Board Discussion

Follow up and Progress Report

Process Completed

\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":293,"value":"md`\nWe'll re-cast these attributes for our generalized data model as follows:\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":299,"value":"md`\n complaint_acknowledgement\n complaint_registration_decision\n complaint_registration_management_response\n eligibility_report\n eligibility_report_approval\n investigation_status\n investigation_report\n investigation_report_management_response\n investigation_report_board_discussion\n investigation_progress_report\n closure\n`","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"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"},{"id":83,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs"},{"id":17,"value":"md`\nNice.\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":80,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs"},{"id":78,"value":"md` ## Appendix`","pinned":false,"hidden":false,"mode":"ojs"},{"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"},{"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"},{"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"},{"id":3,"value":"import {table} from \"@tmcw/tables/2\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":5,"value":"d3 = require('d3')","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W31","stdlib":"1","titling":"auto"}