{"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"]
[2363,"Yes","transnational","6900.00","Tanzania","6900.00","1400.00","Concluded (Contract signed)","In operation (production)","2016-05-27T14:34:46+00:00","China Development Bank#412#China|China  Agricultural Development Company#3323#China","6900.00","1999#current#6900.0","2012##1386.0|2013#current#1400.0",null,"#current##Non-food agricultural commodities",{"$nulls":3},"Lease",null,"1999#current#Concluded (Contract signed)",null,"2000#current#In operation (production)","After 12 years of development, the farm is now poised for peak production. From 2013, the company will add 300 hectares of plantation area every year, so that the sisal plantation covers 3,000 hectares by 2020 with an annual output of 10,000 metric tons",{"$nulls":5},"200.00","Tanzanian Shilling","per ha",{"$nulls":14},"Yes",null,8,null,"2013#current##9#","There are four or five Chinese managers at the farm, several Chinese sales managers in Dar es Salaam","Yes",null,null,1000,"2013#current##700#300",null,null,"Rudewa Estate and Kisangata Estate","Ownership of the two sisal farms was recently transferred to a new company set up by the China \nAgricultural Development Company and the China Africa Development Fund: China State Farms Agribusiness (G) Corp. Tanzania Ltd",36947,"China State Farms Agribusiness (G) Corp. Tanzania Ltd","Tanzania","Private company",{"$nulls":26},"Health|Other","Clinic and potable water- the groundwater from the well provides safe and clean drinking water to the community.",{"$nulls":9},"#current####Sisal",{"$nulls":13},"Yes",50,"Yes",50,"China",{"$nulls":5},"Also export to Middle East. Raw material for marine ropes, sacks and mats, but in recent years have gained wider uses as well, including as the core of the steel cables used in lifts in tall buildings and as the raw material for stainless steel polishing cloths",{"$nulls":15},"\"Operating a sisal farm in Tanzania also helps conserve land in China for other domestic crops,\" says Wang Lusheng, chief engineer of the Chinese company's Tanzania subsidiary. ",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"]
["4Pdpz1Y3",2363,"Administrative region","Rudewa, Tanzania","-6.68333,37.13333",null,null,"West along the Morogoro road; 320 kilometres away, in the interior of the Morogoro region"]

{"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"]
["0jlbOE03",2363,{"$nulls":3},99]

{"sheet":"Data sources","index":3,"n_rows":6,"n_cols":13,"rows_kept":6}
["ID","Deal ID","Data source type","URL","File","Publication title","Date","Name","Organisation","Email","Phone","Open Contracting ID","Comment on data source"]
["wKqGIXNW",2363,"Research Paper / Policy Report","http://www.ifpri.org/sites/default/files/publications/ifpridp01214.pdf","uploads/ifpriorgsitesdefaultfilespublicationsifpridp01214pdf.pdf",{"$nulls":7},"An Overview of Chinese Agricultural and \nRural Engagement in Tanzania, Deborah \nBräutigam and Xiaoyang Tang, October 2012."]
["AlosB7MW",2363,"Company sources","http://www.caaic.com.cn/en/NewsInfo.aspx?NId=1249","uploads/caaiccomcnennewsinfoaspxnid1249.pdf",{"$nulls":7},"China Africa Agriculture Investment Corporation Ltd."]
["0yRpUuO8",2363,"Research Paper / Policy Report","http://china-africa-reporting.co.za/wp-content/uploads/2015/07/Trailblazers-2015-Story-of-Chinese-sisal-farm-in-Tanzania-Chen.pdf","uploads/china-africa-reportingcozawp-contentuploads201507trailblazers-2015-story-of-chinese-sisal-farm-in-tanzania-chenpdf.pdf",null,"2013-05-21",{"$nulls":5},"PLOUGHING IN AFRICA: THE STORY OF A CHINESE SISAL FARM IN TANZANIA,  Chen Xiaochen"]
["5PpuGwAX",2363,"Government sources","http://english.agri.gov.cn/np/201304/t20130403_11969.htm","uploads/englishagrigovcnnp201304t20130403_11969htm.pdf",null,"2013-03-26",{"$nulls":5},"Ministry of Agriculture of the People's Republic of China: Sowing the seeds of success in Tanzania"]
["WiVnstYz",2363,"Research Paper / Policy Report","http://www.sais-cari.org/data-chinese-agricultural-investments-in-africa","uploads/sais-cariorgdata-chinese-agricultural-investments-in-africa.pdf",{"$nulls":7},"Data: Chinese Agricultural\nInvestments in Africa"]

{"sheet":"Involvements","index":4,"n_rows":5,"n_cols":12,"rows_kept":5}
["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"]
[4214,36947,"China State Farms Agribusiness (G) Corp. Tanzania Ltd",3324,"China Africa Development Fund","Parent company"]
[4215,36947,"China State Farms Agribusiness (G) Corp. Tanzania Ltd",3323,"China  Agricultural Development Company","Parent company"]
[10378,37748,"Wanbao Africa agriculture Development Limitada  (WAADL)",3324,"China Africa Development Fund","Tertiary investor/lender","Debt financing",{"$nulls":4},"CDB is financing the project, and at the end of 2013 claimed to have disbursed US$20m for the project ."]
[10383,3324,"China Africa Development Fund",412,"China Development Bank","Parent company","Shares/Equity",{"$nulls":4},"The China-Africa Development Fund, is a Chinese private equity fund solely funded by China Development Bank, a Chinese government policy bank."]

{"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"]
[3323,"China  Agricultural Development Company","China","State-/government (owned) company"]
[3324,"China Africa Development Fund","China","Private equity firm"]
[36947,"China State Farms Agribusiness (G) Corp. Tanzania Ltd","Tanzania","Private company"]