31:T504,md`

CAO Project Name
Region
		Date Filled
		Concerns
		Case Status
	Synopsis	Project Information
	Complaint	Institution
		Project Name & Number
	CAO Action	Department
		Company
	Status	Sector
		Region
		Country
		Environmental Category
		Commitment

\`+ Documents\` `32:[] 2f:{"title":"CAO-IFC/MIGA Case Data","cells":[{"id":0,"value":"md`# CAO-IFC/MIGA 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 a discussion of data describing IAM case-handling processes, [click here](https://observablehq.com/@aaronkyle/iam-case-handling-data-model).\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":39,"value":"md`---`","pinned":false,"hidden":false,"mode":"ojs"},{"id":82,"value":"md`#### Office of the Compliance Advisor Ombudsman`","pinned":false,"hidden":false,"mode":"ojs"},{"id":346,"value":"md`\nThe [Office of the Compliance Advisor Ombudsman (CAO)](http://www.cao-ombudsman.org/about/) is the independent accountability mechanism for the [International Finance Corporation (IFC)](http://ifc.org) and the [Multilateral Investment Guarantee Agency (MIGA)](https://www.miga.org/)—the private sector arms of the World Bank Group.\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":131,"value":"md`\nCAO's [website](http://www.cao-ombudsman.org/) provides quite a few data points describing cases handled by the office, though some analysis is required to distill these down into structed case data attributes. \n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":352,"value":"md`\nThe office's [list of cases](http://www.cao-ombudsman.org/cases/default.aspx), for example, provides the following categories of information on an initial search of CAO's caseload:\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":249,"value":"md`\n

\n\n\n

REGION			Open \| Closed
Country	Active Function	Project Name	Status

\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":275,"value":"md`Let's distill down these first few attributes and name them verbosely:`","pinned":false,"hidden":false,"mode":"ojs"},{"id":133,"value":"md`\n\n case_region\n case_country\n cao_function\n cao_case_name\n cao_case_status\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":308,"value":"md`\nClicking into a specific project, CAO's website provides further detail.\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":377,"value":"md`\nFirst, the site lists out some general descriptive attributes:\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":283,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":381,"value":"md`\nNext, the site presents a 'case tracker' that discloses information about on the status of the cases within CAO's case-handing process, namely whether a specific subphase was triggered and whether or not each sub-phase is active or closed.\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":384,"value":"md`\nCAO's case tracker labels these sub-phase elements as follows:\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":331,"value":"md`\n

\n\n\n\n\n\n\n\n\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":388,"value":"md`\nFinally, each case detail page contains a link to official reporting documents associated with the case. These reporting documents are organized by case-handing phase and sub-phase as follows: \n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":389,"value":"md`\n\n

Eligible

Assesment Period

Facilitating Settlement

Monitoring / Close-Out

Under Appraisal

Under Audit

Monitoring

\n\n\n\n\n\n\n\n\n\n\n\n\n

Complaint
Ombudsman
- Assessment Report(s)
- IFC/MIGA Formal Response to the Assessment Report(s)
- Agreement(s)
- Close-out Report(s)
Compliance
- Appraisal Report(s)
- Terms of Reference of a Compliance Audit
- Audit Report(s)
- IFC/MIGA Formal Response to the Audit Report(s)
- Monitoring Report(s)

\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":329,"value":"md`Let's again distill these attributes down into list form and name them verbosely.`","pinned":false,"hidden":false,"mode":"ojs"},{"id":408,"value":"md`\nAttributes from CAO's case details page:\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":140,"value":"md`\n\n complaint_region\n complaint_country\n case_name\n complaint_parties_description\n complaint_received\n issues_complaint\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`","pinned":false,"hidden":false,"mode":"ojs"},{"id":413,"value":"md`\nAttributes from CAO's case tracker:\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":402,"value":"md`\n\n eligibility_status\n assesment_status\n dr_mediation_status\n dr_monitoring_status\n compliance_appraisal_status\n compliance_investigation_status\n compliance_monitoring\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":421,"value":"md`\nAttributes from the case details reporting page:\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":425,"value":"md`\n\n complaint\n assessment_report\n assessment_report_institutional_response\n dr_agreement\n dr_conclusion_report\n compliance_appraisal_report\n compliance_investigation_tor\n compliance_investigation_report\n compliance_investigation_report_institutional_response\n compliance_investigation_report\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":148,"value":"md`\nLet's quickly 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":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"},{"id":100,"value":"md`\nGreat.\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":437,"value":"md`\nThere remains still a bit more work to truly capture case data published by CAO. For example, within each of the reporting documents disclosed for a case are dates and other information, such as whether or not a case was merged with another case for report, case routing information following an assessment decision, and so on. We'll dig into these details at another time.\n\nFor now, the major task is to continue to work through all IAMnet members' case disclosures [to arrive at a comprehensive list of attributes](https://observablehq.com/@aaronkyle/iam-case-data-attributes).\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":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"},{"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"},{"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"},{"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"},{"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"},{"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":"$W32","stdlib":"1","titling":"auto"}