{"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"]
[2309,"Yes","transnational","179999.00","South Sudan","179999.00",null,"Concluded (Contract signed)","Startup phase (no production)",null,"Green Resources AS#1293#Norway",null,"2010#current#179999.0",null,null,"2010##45000.0#Timber plantation for wood and fiber, For carbon sequestration/REDD|2010#current#134999.0#Conservation","Purpose: produce timber, rehabilitate degraded forest areas, generate revenue from carbon offsets\nThe company estimates that it can realistically establish a plantation on 45,000 of the 179,000 hectares that it has leased, leaving the remainder to grow as natural forest.",null,null,"Lease",null,"2007##Intended (Under negotiation)|2010#current#Concluded (Contract signed)","negotiations started in 2007, trial planting in 2008, 2010 final stages of obtaining title on land","2008#current#Startup phase (no production)","trial planting started in 2008.",{"$nulls":5},"12500.00","US Dollar ($)","for specified area","179999.00","According to the agreement, Tindilo Community is to receive rent in the amount of US $12,500 in the  first year of the lease, followed by annual rent increases of two-percent to cover inflation, in addition to the commitments that the investor made in the Community Support Program Agreement.\n \"This translates to approximately US $0.07 per hectare per year and seems to be little more than a symbolic payment.\"","No",{"$nulls":5},"Yes",null,12,140,null,"12 full-time staff, 140 temporary employment opportunities per month",{"$nulls":14},"The parent company might have changed in 2018 to Norwegian forestry investment company- still confirming this information.",36353,"Tree Farms Sudan Ltd","Uganda","Private company",{"$nulls":3},"Tindilo#",null,"Tindilo Community",null,null,"Limited consultation",{"$nulls":5},"No",{"$nulls":6},"According to TreeFarms, Tindilo Payam is sparsely populated with a population of approximately 10,000. The company therefore asserts that it can secure access to a large portion of land without displacing host populations.",{"$nulls":4},"Health|Education|Productive infrastructure (e.g. irrigation, tractors, machinery...)|Roads|Capacity building","\"According to the terms of their investment agreement, Green Resources is supposed make annual rental payments of $12,500 US to the local community. They are also supposed to assist with a number of development projects, including the building of a school, health facilities, and a community office. It is not clear whether these projects would be funded by the annual rental payment or whether they would be provided in addition to that payment.\"",{"$nulls":3},"Community",null,"Pastoralism","State and indigenous people","Forest land","Gathering, hunting and fishing","#current####Eucalyptus, Pine, Teak, Trees (unspecified)",{"$nulls":13},"Yes",null,"Yes",{"$nulls":7},"According to the Country Manager of TreeFarms Sudan, the eucalyptus will be used mainly to provide electrical poles in Southern Sudan.","Yes","TIM (Timber production)",{"$nulls":14},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"]
["6osRxgNM",2309,"Approximate location","Tindalo, South Sudan","5.65267,31.05127",null,null,"Tindilo Community, Terekeka County in Central Equatoria State"]

{"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"]
["396VlgBo",2309,null,"2010",null,99]

{"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"]
["sF8zKVDR",2309,"Company sources","http://www.greenresources.no/Portals/0/Carbon/PIN%20Tindilo%20REDD%20Project.pdf","uploads/greenresourcesnoportals0carbonpin20tindilo20redd20projectpdf.pdf",null,"2010-01-01"]
["GS3Zxq02",2309,"Research Paper / Policy Report","http://papers.ssrn.com/sol3/papers.cfm?abstract_id=2294521","uploads/papersssrncomsol3paperscfmabstract_id2294521.pdf","THE GLOBAL LAND RUSH: MARKETS, RIGHTS, AND THE POLITICS OF FOOD- SMITA NARULA","2013"]
["tD4qCRqk",2309,"Company sources","http://www.greenresources.no/Portals/0/Reports/AR_2008_FINAL.pdf","uploads/greenresourcesnoportals0reportsar_2008_finalpdf.pdf","Green Resource Annual Report 2008","2008"]
["jCZUkf3L",2309,"Contract","http://www.openlandcontracts.org/contract/ocds-591adf-2526678534/view#/pdf","-redacted-","Land Title Agreement","2010",{"$nulls":4},"ocds-591adf-2526678534"]

{"sheet":"Involvements","index":4,"n_rows":12,"n_cols":12,"rows_kept":12}
["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"]
[918,35915,"Unknown (Green Resources AS)",1293,"Green Resources AS","Parent company"]
[1266,36353,"Tree Farms Sudan Ltd",1293,"Green Resources AS","Parent company"]
[1365,36594,"Kachung",1293,"Green Resources AS","Parent company"]
[4077,36850,"Green Resources Ltd",1293,"Green Resources AS","Parent company",null,100]
[4819,38681,"Tanga Forests Ltd (TFL)",1293,"Green Resources AS","Parent company",null,100]
[6502,39165,"Sao Hill Agriculture (SHA) Limited",1293,"Green Resources AS","Parent company",null,50]
[11594,1293,"Green Resources AS",41021,"Norfund","Tertiary investor/lender","Shares/Equity|Debt financing",41.8,32180000,null,null,"Norfund has invested in Green Resources since 2009. Since 2018 Norfund has become a shareholder with an investment of USD2.5 million. (Norfund Annual Report 2019)"]
[11595,1293,"Green Resources AS",1443,"Finnish Fund for Development Cooperation (Finnfund)","Tertiary investor/lender","Debt financing",null,13300000,null,null,"Several loans in 2012, 2018 (USD 3.55 million) and 2019 (USD 9.75 million) (Finnfund Annual Report 2019)"]
[11604,39930,"Green Resources in Mozambique",1293,"Green Resources AS","Parent company","Shares/Equity",100]
[11620,39929,"GRL Tanzania Ltd",1293,"Green Resources AS","Parent company","Shares/Equity",100]
[11621,37289,"Busoga Forest Company",1293,"Green Resources AS","Parent company","Shares/Equity",100,{"$nulls":3},"Busoga Forestry Company (BFC) Ltd is a subsidiary of Green Resources AS (GRAS)"]

{"sheet":"Investors","index":5,"n_rows":3,"n_cols":8,"rows_kept":3}
["Investor ID","Name","Country of registration/origin","Classification","Investor homepage","Opencorporates link","Comment","Action comment"]
[1293,"Green Resources AS","Norway","Private company","http://greenresources.no/",null,"Green Resources started under the name Fjordgløtt in 1995, and was later renamed Tree Farms, before adopting its current name in 2007. \nThe company received loan funding from IFC and FMO which had to be repaid at the end of 2018. This resulted in financial challenges and additional loan financing from NorFund and FinnFund.\nGreen Resources’ major shareholders include investment firms such as Phaunos Timber Fund (27%) (the company has since divested its shares), New Africa (19%), Steinerud (8%), Macama (7%), SBL Direct Investments Ltd (6%), Verbena Investment Ltd (5%), and TRG (5%). (not sure if this is still the case). Other financiers include the World Bank’s International Finance Corporation, the Norwegian Investment Fund for Developing Countries (Norfund), which has provided $7million in loans to Green Resources, as well as an additional $25million in collaboration with the Finnish Development Finance Institution (Finnfund). Green Resources is reportedly the largest plantation forestry, carbon offset, forest products, and renewable energy company (outside South Africa) operating on the African continent."]
[36353,"Tree Farms Sudan Ltd","Uganda","Private company"]