{"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"]
[2009,"Yes","transnational","4075.00","Congo, Dem. Rep.","4075.00",null,"Concluded (Contract signed)","Startup phase (no production)","2022-01-12T09:30:12.452954+00:00","Glencore Xstrata PLC#651#Switzerland|Gecamines#2521#Congo, Dem. Rep.","4075.00","#current#4075.0",null,"Various operations- totaling 40.757 square kilometers (4075.7 hectares).","#current##Mining","copper, cobalt",null,null,"Exploitation permit / license / concession (for mineral resources)","Term of 20 years from the date of operations. Automatically renewable twice for a period of 10 years each.","#current#Concluded (Contract signed)","JV agreement amended 25/07/2009","##In operation (production)|2015#current#Startup phase (no production)","Re-establishment of old mining operations. Activities placed on hold in 2015 due to the low cobalt and copper prices. The company is upgrading their processing plant during the shut.",{"$nulls":10},"No",{"$nulls":25},"Katanga, through its 75% owned subsidiary Kamoto Copper Company SARL (“KCC”), is engaged in copper and cobalt mining and related activities in the Democratic Republic of Congo (“DRC”). \nKatanga's ultimate parent company is Glencore Xstrata\nplc (“Glencore Xstrata”) which owns 75. 3% of Katanga's shares.",37329,"Katanga Mining Limited","Congo, Dem. Rep.","Private company",{"$nulls":3},"Nishinga#",{"$nulls":4},"Not consulted","The  way of allocating land is not safe, explain today the peasants, because they do not receive any document that officially acts this land transfer","Mixed reaction",null,"Yes","70 farmers in Nshinga village were dispossessed of their fields by the land registry service","Yes",{"$nulls":6},"70 farmers in Nshinga village were dispossessed of their fields by the land registry service.The plot was sold to a large farmer without compensation for the people who cultivated it.","Socio-economic|Displacement","70 farmers in Nshinga village were dispossessed of their fields by the land registry service,\nIn the Katanga region of southern DRC, peasants are increasingly dispossessed of their agricultural land for the benefit of either large farmers or miners. Compensation is almost non-existent and if there is, it is often ridiculous. As a result, small-scale producers are losing their livelihoods .",null,null,"Health|Education",{"$nulls":14},"#current####Cobalt, Copper, Gold",{"$nulls":20},"Yes","Processing was suspended in Sep 2015 for 18 months.",{"$nulls":13},"Many mining companies active in Katanga region of DRC. None seem to have Chinese interests, unless the Chinese have an influence in Gecamines. Illegal miners dided on site in June 2019. The company is trying to stop this from happening in the future.",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"]
["5hGIuj76",2009,"Exact location","Kolwezi, Katanga, Democratic Republic of the Congo","-10.68008,25.39056"]

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

{"sheet":"Data sources","index":3,"n_rows":11,"n_cols":13,"rows_kept":11}
["ID","Deal ID","Data source type","URL","File","Publication title","Date","Name","Organisation","Email","Phone","Open Contracting ID","Comment on data source"]
["vlhaxspK",2009,"Media report","http://www.pambazuka.org/en/category/features/61992","uploads/pambazukaorgencategoryfeatures61992.pdf","DRC’s magic dust: Who benefits?","2010-02-04",{"$nulls":5},"Pamzuka News"]
["BQHnbD3V",2009,"Company sources","http://www.katangamining.com/about-us/history.aspx","uploads/katangaminingcomabout-ushistoryaspx.pdf",{"$nulls":7},"Page no longer available"]
["zRiyf-4r",2009,"Media report","http://seekingalpha.com/article/4033629-katanga-mining-potential-turnaround-story","uploads/seekingalphacomarticle4033629-katanga-mining-potential-turnaround-story.pdf",null,"2017-01-01",{"$nulls":5},"Katanga Mining Is A Potential Turnaround Story"]
["jtbpfEcm",2009,"Company sources","http://www.katangamining.com/~/media/Files/K/Katanga-mining-v2/investor_relations/financialresults/res2013/q12013/fin-stat-q1-2013.pdf","uploads/katangaminingcommediafileskkatanga-mining-v2investor_relationsfinancialresultsres2013q12013fin-stat-q1-2013pdf.pdf"]
["eazng7Jb",2009,"Company sources","http://www.katangamining.com/~/media/Files/K/Katanga-mining-v2/operations/reportsoperational/reop2006/technicalreport/techreport10.pdf","uploads/katangaminingcommediafileskkatanga-mining-v2operationsreportsoperationalreop2006technicalreporttechreport10pdf.pdf","A Technical Report on the Material Assets of Katanga Mining Limited Katanga Province, DRC","2010-03-31",{"$nulls":5},"link no longer working"]
["TpCUOrWX",2009,"Contract","http://www.resourcecontracts.org/contract/ocds-591adf-7793227103/view#/pdf","uploads/710-kcc-drc-2009.pdf","Gécamines, Global Enterprises Corporate Ltd, KFL Limited, JVA, 2011","2011",{"$nulls":4},"ocds-591adf-7793227103","Joint Venture Agreement"]
["Yl3g2Njj",2009,"Media report","http://www.mining-technology.com/news/newskatanga-mining-suspend-copper-cobalt-processing-4669580","uploads/mining-technologycomnewsnewskatanga-mining-suspend-copper-cobalt-processing-4669580.pdf","Mining Technology- Katanga Mining to suspend copper and cobalt processing","2015-09-14",{"$nulls":5},"MARKET DATA"]
["qCKMmuH5",2009,"Company sources","http://www.katangamining.com/~/media/Files/K/Katanga-mining-v2/media/newsreleases/news2017/pr-08-02-2017.pdf","uploads/katangaminingcommediafileskkatanga-mining-v2medianewsreleasesnews2017pr-08-02-2017pdf.pdf",{"$nulls":7},"News Release- No. 3/2017. KATANGA  MINING  ANNOUNCES  2016 FOURTH QUARTER AND  YEAR  END FINANCIAL RESULTS"]
["1sq6dB4D",2009,"Company sources","https://www.glencore.com/media-and-insights/news/announcement-regarding-fatalities-of-illegal-artisanal-miners-at-kcc",null,"Announcement regarding fatalities of illegal artisanal miners at KCC","2019-06-27",{"$nulls":5},"Glencore"]
["Y-kS-gqV",2009,"Media report","https://www.rfi.fr/fr/podcasts/afrique-%C3%A9conomie/20220104-rdc-dans-le-katanga-les-paysans-souhaitent-une-plus-grande-s%C3%A9curit%C3%A9-fonci%C3%A8re","uploads/drc_-farmers-in-katanga-want-greater-land-security-africa-economy.pdf","DRC: Farmers in Katanga want greater land security","2022-01-05",{"$nulls":5},"RFI"]

{"sheet":"Involvements","index":4,"n_rows":11,"n_cols":12,"rows_kept":11}
["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"]
[6597,35362,"Glencore Grain Ukraine",651,"Glencore Xstrata PLC","Parent company"]
[6604,37329,"Katanga Mining Limited",2521,"Gecamines","Parent company",null,25]
[6605,37329,"Katanga Mining Limited",651,"Glencore Xstrata PLC","Parent company",null,75]
[6753,39262,"Tenke Fungurume Mining S.A",2521,"Gecamines","Parent company",null,20]
[7711,39008,"Unknown (Glencore Xstrata PLAC, Chad Government)",651,"Glencore Xstrata PLC","Parent company",null,85]
[7938,39908,"Glencore Grain Ukraine in Argentina",651,"Glencore Xstrata PLC","Parent company"]
[7939,39909,"Glencore Grain Ukraine in Ukraine",651,"Glencore Xstrata PLC","Parent company"]
[8342,40010,"Sino–Congolais des Mines (Sicomines)",2521,"Gecamines","Parent company",null,32]
[12278,39268,"Kalukundi Mines",2521,"Gecamines","Parent company","Shares/Equity"]
[12279,38966,"Boss Mining Sprl",2521,"Gecamines","Parent company","Shares/Equity",49,{"$nulls":3},"Previously 30%. JV agreement renewed in 2018."]

{"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"]
[651,"Glencore Xstrata PLC","Switzerland","Stock-exchange listed company",null,null,"Glencore Xstrata PLC was created in May 2013 through the merger of Glencore with Xstrata."]
[2521,"Gecamines","Congo, Dem. Rep.","State-/government (owned) company"]
[37329,"Katanga Mining Limited","Congo, Dem. Rep.","Private company"]