{"text_format":"5","workbook":"xlsx","n_sheets":6,"sheets":["Deals","Locations","Contracts","Data sources","Involvements","Investors"],"props":{"creator":"openpyxl"},"read":"whole","date_system":"1900"}

{"sheet":"Deals","index":0,"n_rows":2,"n_cols":146,"rows_kept":2}
["Deal ID","Is public","Deal scope","Deal size","Target country","Current size under contract","Current size in operation (production)","Current negotiation status","Current implementation status","Fully updated","Top parent companies","Intended size (in ha)","Size under contract (leased or purchased area, in ha)","Size in operation (production, in ha)","Comment on land area","Intention of investment","Comment on intention of investment","Carbon offset project","Comment on carbon offset project","Nature of the deal","Comment on nature of the deal","Negotiation status","Comment on negotiation status","Implementation status","Comment on implementation status","Purchase price","Purchase price currency","Purchase price area type","Purchase price area","Comment on purchase price","Annual leasing fee","Annual leasing fee currency","Annual leasing fee type","Annual leasing fee area","Comment on leasing fees","Contract farming","On leased / purchased","On leased area/farmers/households","Not on leased / purchased (out-grower)","Not on leased area/farmers/households (out-grower)","Comment on contract farming","Jobs created (total)","Planned number of jobs (total)","Planned employees (total)","Planned daily/seasonal workers (total)","Current total number of jobs/employees/ daily/seasonal workers","Comment on jobs created (total)","Jobs created (foreign)","Planned number of jobs (foreign)","Planned employees (foreign)","Planned daily/seasonal workers (foreign)","Current foreign number of jobs/employees/ daily/seasonal workers","Comment on jobs created (foreign)","Jobs created (domestic)","Planned number of jobs (domestic)","Planned employees (domestic)","Planned daily/seasonal workers (domestic)","Current domestic number of jobs/employees/ daily/seasonal workers","Comment on jobs created (domestic)","Actors involved in the negotiation / admission process","Name of investment project","Comment on investment chain","Operating company: Investor ID","Operating company: Name","Operating company: Country of registration/origin","Operating company: Classification","Operating company: Investor homepage","Operating company: Opencorporates link","Operating company: Comment","Name of community","Name of indigenous people","Comment on communities / indigenous peoples affected","Recognition status of community land tenure","Comment on recognitions status of community land tenure","Community consultation","Comment on consultation of local community","Community reaction","Comment on community reaction","Presence of land conflicts","Comment on presence of land conflicts","Displacement of people","Number of people actually displaced","Number of households actually displaced","Number of people displaced out of their community land","Number of people displaced staying on community land","Number of households displaced \"only\" from their agricultural fields","Number of people facing displacement once project is fully implemented","Comment on displacement of people","Negative impacts for local communities","Comment on negative impacts for local communities","Promised compensation (e.g. for damages or resettlements)","Received compensation (e.g. for damages or resettlements)","Promised benefits for local communities","Comment on promised benefits for local communities","Materialized benefits for local communities","Comment on materialized benefits for local communities","Presence of organizations and actions taken (e.g. farmer organizations, NGOs, etc.)","Former land owner","Comment on former land owner","Former land use","Comment on former land use","Former land cover","Comment on former land cover","Crops area/yield/export","Comment on crops","Livestock area/yield/export","Comment on livestock","Mineral resources area/yield/export","Comment on mineral resources","Contract farming crops","Comment on contract farming crops","Contract farming livestock","Comment on contract farming livestock","Electricity generation","Comment on electricity generation","Carbon sequestration/offsetting","Comment on carbon sequestration/offsetting","Has domestic use","Domestic use","Has export","Export","Country 1","Country 1 ratio","Country 2","Country 2 ratio","Country 3","Country 3 ratio","Comment on use of produce","In country processing of produce","Comment on in country processing of produce","Processing facilities / production infrastructure of the project (e.g. oil mill, ethanol distillery, biomass power plant etc.)","In-country end products of the project","Water extraction envisaged","Comment on water extraction envisaged","Source of water extraction","Comment on source of water extraction","Comment on how much do investors pay for water","Water extraction amount","Comment on how much water is extracted","Use of irrigation infrastructure","Comment on use of irrigation infrastructure","Water footprint of the investment project","Comment on gender-related info","Overall comment","Not public","Comment on not public"]
[6775,"Yes","transnational","0.00","Ghana","0.00",null,"Concluded (Contract signed)","In operation (production)","2020-07-20T14:52:26.165305+00:00","Government of Ghana#1114#Ghana|Unilever PLC#3131#United Kingdom of Great Britain and Northern Ireland",null,"#current#0.0",null,null,"#current##Agriculture unspecified",{"$nulls":3},"Pure contract farming",null,"2006#current#Concluded (Contract signed)",null,"2007#current#In operation (production)",{"$nulls":11},"Yes",null,null,"Yes","#current#3300.0##","3,000 hectares of oil palm through an outgrower scheme, The  project  eventually invested and completed planting of 3300ha for 986 farmers.",{"$nulls":21},40884,"Buabin Oil Palm Outgrower Project","Ghana","Other",null,null,"Public Private Partnership\nThis is a farmer-based plantation project jointly sponsored by AFD and GoG.; with Twifo Oil Palm Plantations (TOPP) Limited as technical operator together with the farmers in a public private partnership arrangement.",{"$nulls":40},"#current#None#Oil Palm",{"$nulls":34},false]

{"sheet":"Locations","index":1,"n_rows":3,"n_cols":8,"rows_kept":3}
["ID","Deal ID","Spatial accuracy level","Location","Point","Facility name","Location description","Comment on location"]
["tIVky0K3",6775,"Administrative region","Central, Ghana","5.56078,-1.05861",null,null,"42 rural communities in 4 Districts from the Central and Western Regions"]
["potH3PWi",6775,"Administrative region","Western Region, Ghana","5.3902,-2.14502"]

{"sheet":"Contracts","index":2,"n_rows":1,"n_cols":7,"rows_kept":1}
["ID","Deal ID","Contract number","Contract date","Contract expiration date","Duration of the agreement","Comment on contract"]

{"sheet":"Data sources","index":3,"n_rows":5,"n_cols":13,"rows_kept":5}
["ID","Deal ID","Data source type","URL","File","Publication title","Date","Name","Organisation","Email","Phone","Open Contracting ID","Comment on data source"]
["r2ZWWR4E",6775,"Company sources","http://www.toppghana.com/view-content/19/Outgrowers.html",null,"BUABIN OIL PALM OUTGROWER PROJECT"]
["wdPVE7-w",6775,"Research Paper / Policy Report","http://www.fao.org/3/aq231e/aq231e.pdf",null,"AGRIBUSINESS PUBLIC-PRIVATE PARTNERSHIPS A country report of Ghana","2013"]
["9_SzQhaZ",6775,"Research Paper / Policy Report","https://www.proforest.net/proforest/en/files/ghana_company-smallholder_profiles.pdf",null,"Profiles of Company-Smallholder Working Arrangements for five Ghanaian palm oil companies",{"$nulls":6},"By SHARP"]
["61MiLgsJ",6775,"Personal information",null,"-redacted-",null,"2020-07-18",{"$nulls":5},"Ghana Data Campaign"]

{"sheet":"Involvements","index":4,"n_rows":17,"n_cols":12,"rows_kept":17}
["Involvement ID","Investor ID Downstream","Investor Name Downstream","Investor ID Upstream","Investor Name Upstream","Relation type","Investment type","Ownership share","Loan amount","Loan currency","Loan date","Comment"]
[7775,38289,"Unknown (Marubeni Corporation and Government)",1114,"Government of Ghana","Parent company"]
[7777,37341,"Prairie Volta Rice Ltd",1114,"Government of Ghana","Parent company",null,30]
[9728,41607,"Chirano Gold mine limited",1114,"Government of Ghana","Parent company",null,10,{"$nulls":3},"It is 90% owned by Toronto-based Kinross Gold Corporation. The Government of Ghana has a 10% carried interest."]
[9824,41755,"Africa Agriculture and Trade Investment Fund (AATIF)",41758,"KfW Bankengruppe","Parent company"]
[10744,39661,"Bui Power Authority",1114,"Government of Ghana","Tertiary investor/lender","Shares/Equity",15,{"$nulls":3},"US$60 million investment"]
[10946,5037,"PBC Limited",1114,"Government of Ghana","Parent company","Shares/Equity",36.69]
[11110,36652,"GREL Ghana Rubber Estates LTD",1114,"Government of Ghana","Parent company","Shares/Equity",25]
[11316,40884,"Buabin Oil Palm Outgrower Project",40817,"Twifo Oil Palm Plantations Limited TOPP","Parent company"]
[11317,40884,"Buabin Oil Palm Outgrower Project",1114,"Government of Ghana","Parent company"]
[11318,40884,"Buabin Oil Palm Outgrower Project",42730,"Agence Francaise de Developpement (AFD)","Tertiary investor/lender","Debt financing"]
[11319,40884,"Buabin Oil Palm Outgrower Project",41758,"KfW Bankengruppe","Tertiary investor/lender","Debt financing"]
[11321,41208,"Palm Farmers Project of Ghana",1114,"Government of Ghana","Tertiary investor/lender",{"$nulls":5},"The Project is being funded by the Minerals Development Fund of the Lands Ministry with a decentralised monitoring system on progress of  farmers."]
[11882,40817,"Twifo Oil Palm Plantations Limited TOPP",1114,"Government of Ghana","Parent company","Shares/Equity"]
[11883,40817,"Twifo Oil Palm Plantations Limited TOPP",3131,"Unilever PLC","Parent company","Shares/Equity",40,{"$nulls":3},"1998: Unilever Ghana acquired 50% of the shares held by the Government of Ghana (40% of total shares in TOPP) and gained management control. A managing director was appointed in September.\n2012: Supreme Court ruling that the sale of shares to Unilever in 1998 is null and void. Nevertheless, Unilever continues to manage TOPP."]
[12436,43509,"Green Watts Renewable Energy (GWRE)",41758,"KfW Bankengruppe","Tertiary investor/lender","Debt financing",null,19400000,null,"2016","The EBRD loan will be accompanied by parallel loans of US$ 50 million from Proparco (Société de Promotion et de Participation pour la Coopération Economique S.A.) and US$ 19.4 million from DEG-Deutsche Investitions- und Entwicklungsgesellschaft mbH (German Investment and Development Corporation)."]
[13898,38071,"Meru Wind Farm",41758,"KfW Bankengruppe","Tertiary investor/lender"]

{"sheet":"Investors","index":5,"n_rows":6,"n_cols":8,"rows_kept":6}
["Investor ID","Name","Country of registration/origin","Classification","Investor homepage","Opencorporates link","Comment","Action comment"]
[1114,"Government of Ghana","Ghana","State-/government (owned) company"]
[40817,"Twifo Oil Palm Plantations Limited TOPP","Ghana","Semi state-owned company","http://www.toppghana.com/"]
[40884,"Buabin Oil Palm Outgrower Project","Ghana","Other",null,null,"Public Private Partnership\nThis is a farmer-based plantation project jointly sponsored by AFD and GoG.; with Twifo Oil Palm Plantations (TOPP) Limited as technical operator together with the farmers in a public private partnership arrangement."]
[41758,"KfW Bankengruppe","Germany","Bilateral Development Bank / Development Finance Institution",null,null,"KfW Bankengruppe, founded in 1948, provides positive impulses for economic and social development and for environmental protection worldwide. Internationally, it acts as the German Federal Government’s Development Bank and is also providing commercial project and export finance. The shareholders of KfW are the German Federal Government and the federal states. KfW has been active in development finance"]
[42730,"Agence Francaise de Developpement (AFD)","France","Government institution","https://www.afd.fr/en",null,"The French Development Agency is a public financial institution that implements the policy defined by the French Government."]