2e:null 2f:["$","title",null,{"children":"Inspection Panel - World Bank Case Data | Aaron Kyle Dennis | Observable"}] 34:[] 32:{"id":"171631681a4eceb0","slug":"world-bank-case-data","title":"Inspection Panel - World Bank Case Data","thumbnail":"f55512591a6985dc23142e4fc0362e1fce3ab834ae9772860798585e9164c7df","access_level":"public","create_time":"$D2019-04-18T12:23:26.651Z","update_time":"$D2019-11-16T00:50:39.321Z","view_time":null,"first_public_time":"$D2019-11-16T00:38:42.867Z","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":327,"publish_version":327,"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":"Inspection Panel - World Bank Case Data","cells":[{"id":0,"value":"md`# Inspection Panel - World Bank Case Data`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$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","output":"$undefined","database":"$undefined"},{"id":244,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":69,"value":"md`#### Inspection Panel`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$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","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$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","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$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\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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":265,"value":"md`\nLet's also transcribe these attributes to better fit our generalized data model. \n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":275,"value":"md`\nAnd not to forget the case status tracker, which comprises the following stages:\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":293,"value":"md`\nWe'll re-cast these attributes for our generalized data model as follows:\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"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","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$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","output":"$undefined","database":"$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","output":"$undefined","database":"$undefined"},{"id":83,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":17,"value":"md`\nNice.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":80,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":78,"value":"md` ## Appendix`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$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","output":"$undefined","database":"$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","output":"$undefined","database":"$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","output":"$undefined","database":"$undefined"},{"id":3,"value":"import {table} from \"@tmcw/tables/2\"","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"}],"files":"$W34","stdlib":"1","titling":"auto"}} 33:"$32:body"