{"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"]
[3743,"Yes","transnational","21500.00","Côte d'Ivoire","21500.00","21500.00","Concluded (Contract signed)","In operation (production)","2024-06-26T15:54:33.057000+00:00","Kuok Group#438#Malaysia|Michelin#1817#France|Archer Daniels Midland Company (ADM)#3871#United States of America|SCI Parme Investissement#41866#France|ImmoRiv SA#41867#Switzerland|Moneta Asset Management#42684#France","21500.00","2011#current#21500","2011#current#21500","Another source states current size under contract is 22000ha.","#current##Non-food agricultural commodities","Production of Rubber tree (rubber farming activities )","No",null,"Lease",null,"1999#current#Concluded (Contract signed)","SIFCA’s subsidiary since 1999","1999#current#In operation (production)",{"$nulls":11},"Yes",null,null,"Yes",null,"Outgrowers supply over 60% of the SAPH-processed cup film","Yes",{"$nulls":3},"2011#current##4084#1960","It is not known how many are foreigners and how many are domestic jobs. ",{"$nulls":13},"La Société africaine de plantations d'hévéas (SAPH)","Société Africaine de Plantations d’Hévéa HAS MARKET SHARE OF27%(recorded end 2018).",37443,"SAPH SA","Côte d'Ivoire","Private company","http://www.groupesifca.com/en/saph.php",null,"17.10% of the Société Africaine de Plantations d'Hévéas is listed on the Abijan stock exchange",{"$nulls":34},"#current####Rubber tree","Producing more than 200,000 tons per year in its five factories, the subsidiary of the Sifca group, via the International Rubber Plantation Company (SIPH), wants to increase its production capacity by 60,000 tons by the end of the year.",{"$nulls":12},"Yes",null,"Yes",{"$nulls":7},"SAPH exports rubber of its own as well as that of other regional producers.","Yes","THE COMPANY ALSO SPECIALIZE IN PROCESSING OF RUBBER",{"$nulls":12},"Several female employees of SAPH were trained on how to operate machinery on the UAI of Bongo on February 09, 2023.This training, which reflects the joint commitment of the four partner entities for the development of women and the promotion of gender, aims to raise awareness and encourage women in the profession of machine operator.\n\nAt the end of the internal training, SAPH will finance the driving school courses to obtain a driving license in all categories. Making these women fit to drive machinery within integrated agricultural units and on national roads.\n",null,false]

{"sheet":"Locations","index":1,"n_rows":2,"n_cols":8,"rows_kept":2}
["ID","Deal ID","Spatial accuracy level","Location","Point","Facility name","Location description","Comment on location"]
["lLzFL70H",3743,"Country","Côte d'Ivoire","7.53999,-5.54708",null,null,"Location unknown. "]

{"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":8,"n_cols":13,"rows_kept":8}
["ID","Deal ID","Data source type","URL","File","Publication title","Date","Name","Organisation","Email","Phone","Open Contracting ID","Comment on data source"]
["ATDwsACg",3743,"Company sources","http://groupesifca.com/pdf/rapports_annuels/ra_sifca_2011.pdf","uploads/groupesifcacompdfrapports_annuelsra_sifca_2011pdf.pdf","2011 Annual Report","2011",null,"groupe sifca",{"$nulls":3},"2011 Annual report"]
["i_8hDEhc",3743,"Research Paper / Policy Report","https://www.avsf.org/public/posts/1642/course_acquisition_terres_avsf_2014.pdf","uploads/savsforgpublicposts1642course_acquisition_terres_avsf_2014pdf.pdf","Les entreprises françaises impliquées dans l’acquisition et la gestion de grands domaines agricoles et plantations à l’international","2014","Yves Roger-Machart","avsf",{"$nulls":3},"Les entreprises françaises\nimpliquées dans l’acquisition\net la gestion de grands domaines\nagricoles et plantations\nà l’international"]
["FVXVgSGU",3743,"Company sources","http://siph.com/","uploads/SOURCE_3743_3.pdf"]
["Crjxyc09",3743,"Media report","https://www.wrm.org.uy/bulletin-articles/oil-palm-plantations-and-water-grabbing-ivory-coast-and-gabon","uploads/Oil Palm Plantations and Water Grabbing_ Ivory Coast and Gabon _ World Rainforest Movement.pdf","Oil Palm Plantations and Water Grabbing: Ivory Coast and Gabon","2022-09-12",{"$nulls":5},"WRM"]
["frL7MYDB",3743,"Crowdsourcing","https://fr.wikipedia.org/wiki/Soci%C3%A9t%C3%A9_africaine_de_plantations_d%27h%C3%A9v%C3%A9as","uploads/African Rubber Plantation Society - Wikipedia.pdf","African Rubber Plantation Company","2022-02",null,"wikipedia"]
["7kancVUG",3743,"Media report","https://www.investing.com/equities/societe-africaine-de-plantations","uploads/Societe Africaine de Plantations d’Heveas SA Stock Price Today _ CI SPHC Live Ticker - Investing.com.pdf","Societe Africaine de Plantations d’Heveas SA Stock Price Today _ CI SPHC Live Ticker",null,null," Investing.com"]
["GTxTMfHT",3743,"Media report","https://www.jeuneafrique.com/1414653/economie/le-leader-ivoirien-de-lhevea-saph-lance-les-grandes-manoeuvres/","uploads/SOURCE_3743_7.pdf","The Ivorian rubber leader SAPH wants to transform the test","2023-04-17",null,"Jeune Afrique"]

{"sheet":"Involvements","index":4,"n_rows":7,"n_cols":12,"rows_kept":7}
["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"]
[11244,4314,"Société Internationale de Plantations d'Hévéas (SIPH)",1817,"Michelin","Parent company","Shares/Equity",34.29,{"$nulls":3},"Through its subsidiary CFM (COMPAGNIE FINANCIERE MICHELIN). Michelin increased its shareholding in 2017."]
[11245,4314,"Société Internationale de Plantations d'Hévéas (SIPH)",2396,"SIFCA","Parent company","Shares/Equity",55.59]
[11246,4314,"Société Internationale de Plantations d'Hévéas (SIPH)",42684,"Moneta Asset Management","Parent company","Shares/Equity",5.05,{"$nulls":3},"Since August 2017 (https://www.boursier.com/actions/actualites/news/siph-moneta-asset-management-sur-les-5-du-capital-737814.html)"]
[11252,36764,"Cavalla Rubber Corporation (CRC)",4314,"Société Internationale de Plantations d'Hévéas (SIPH)","Parent company","Shares/Equity",100]
[11418,37443,"SAPH SA",1817,"Michelin","Parent company","Shares/Equity",14.84]
[11419,37443,"SAPH SA",4314,"Société Internationale de Plantations d'Hévéas (SIPH)","Parent company","Shares/Equity",68]

{"sheet":"Investors","index":5,"n_rows":4,"n_cols":8,"rows_kept":4}
["Investor ID","Name","Country of registration/origin","Classification","Investor homepage","Opencorporates link","Comment","Action comment"]
[1817,"Michelin","France","Stock-exchange listed company",null,null,"Holds 20% of SIPH which owns 70.3% of RENL."]
[4314,"Société Internationale de Plantations d'Hévéas (SIPH)","France","Stock-exchange listed company",null,"https://opencorporates.com/companies/fr/312397730","SIPH’s main activity is the production and the trade of the natural rubber produced by its African subsidiaries.\n55.59% SIFCA, 34.29% Michelin, Moneta Asset Management 5.05%, Public shares 5.07% (https://www.groupesifca.com/pdf/rapports_annuels/ra-siph-2017.pdf)"]
[37443,"SAPH SA","Côte d'Ivoire","Private company","http://www.groupesifca.com/en/saph.php",null,"17.10% of the Société Africaine de Plantations d'Hévéas is listed on the Abijan stock exchange"]