{"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"]
[779,"Yes","transnational","13281.00","Brazil","13281.00","13281.00","Concluded (Contract signed)","In operation (production)","2023-07-29T22:40:42.814000+00:00","Adecoagro S.A.#662#Luxembourg",null,"2014#current#13281","2014#current#13281","De acuerdo a lo que se indica en el informe de TASACIÓN DE BIENES INMUEBLES de la empresa en 2014. (http://ir.adecoagro.com/Download/20150320013939.pdf)","#current##Biomass for biofuels, Food crops",{"$nulls":3},"Outright purchase",null,"2006#current#Concluded (Contract signed)",null,"2006#current#In operation (production)",{"$nulls":17},"Yes",{"$nulls":3},"#current#4883##","el numero corresponde a los empleados de la empresa en sus dos unidades industriales en Mato Grosso do Sul, Usina Ivinhema y Usina Angélica.",{"$nulls":14},"De acuerdo a la presentaión institucional de la empresa Adecoagro, los principales inversores son Soros Fund Management LLC y Qatar Investment Authority",43893,"Adecoagro Brasil Participações","Brazil","Private company","https://www.adecoagro.com/",{"$nulls":28},"La empresa impulsa iniciativas para promover el desarrollo integral en las comunidades donde opera y trabaja conjuntamente con el sector público y organizaciones sociales. Las acciones sociales que realizan están vinculadas a la educación y al desarrollo local, de manera estratégica, integral y planificada, a largo plazo.",{"$nulls":7},"#current####Sugar Cane",{"$nulls":14},100,{"$nulls":10},"En el Brasil, las operaciones abarcan la producción y comercialización de etanol y azúcar, así como la cogeneración y la comercialización de electricidad, en los estados de Mato Grosso do sul y Minas Gerais.","Planta de energía de biomasa, destilería de etanol","Etanol, azúcar y energía eléctrica",{"$nulls":3},"Puntos de captación\nUsina Ivinhema\nPozo 01- Consumo Industrial - 22°23'16.59\"S - 53°53'21.18\"O - Acuífero Guaraní\nPozo 02- Consumo Industrial - 22°23'46.70\"S - 53°53'36.00\"O - Acuífero Guaraní\nPozo 03- Consumo Industrial - 22°23'31.20\"S - 53°52'59.00\"O - Acuífero Guaraní\nPozo 04- Consumo Humano - 22°23'25.16\"S - 53°53'19.89\"O - Acuífero Bauru\nPozo 05- Consumo Humano - 22°23'45.60\"S - 53°53'37.10\"O - Acuífero Bauru",null,null,"Este valor corresponde al agua captada en la Unidad Ivinhema (MS) en el año 2019\n\nwater_extraction_amount=2.684.893",{"$nulls":3},"El 29 de octubre de 2019, representantes del sector sucroenergético, reunidos en la 19ª Conferencia Internacional DATAGRO sobre Azúcar y Etanol, en São Paulo, firmaron un término de compromiso con los Principios de Empoderamiento de las Mujeres, conjunto de directrices, para el medio empresarial, organizado de forma conjunta por la ONU Mujeres y el Pacto Global de las Naciones Unidas. Entre las empresas participantes, estaba Adecoagro, es decir, adhieren a los principios.\nEn total son siete principios que fueron definidos en los Principios de Empoderamiento de las Mujeres, para ayudar a las empresas a incorporar valores y prácticas persiguiendo la equidad de género en sus negocios. De manera resumida, los compromisos son:\n•\tEl establecimiento de un líder corporativo sensible al tema.\n•\tEl tratamiento de mujeres y hombres de forma justa, respetando y apoyando los derechos humanos y la no discriminación.\n•\tLa garantía de salud, seguridad y bienestar de los públicos femenino y masculino en las empresas.\n•\tEl estímulo a la educación, a la capacitación y al desarrollo profesional de mujeres.\n•\tEl apoyo al emprendedorismo femenino y a la promoción de políticas de empoderamiento.\n•\tEl incentivo a la igualdad de género, mediante iniciativas destinadas a la comunidad y al activismo social.\n•\tLa medición, documentación y publicación de los progresos de las empresas en la promoción de la igualdad de género.","La empresa posee más de 270.000 hectáreas en Argentina, Brasil y Uruguay y posee molinos de azúcar, destilerías de etanol, molinos de arroz, granjas lecheras y fábricas.",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"]
["NjQX963-",779,"Coordinates","Ivinhema - Mato Grosso do Sul, Brazil","-22.3822,-53.89542",null,null,"Usina Ivinhema -22.382201, -53.895418\nUsina Angelica -22.039654318209784, -53.84371344205901"]

{"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":10,"n_cols":13,"rows_kept":10}
["ID","Deal ID","Data source type","URL","File","Publication title","Date","Name","Organisation","Email","Phone","Open Contracting ID","Comment on data source"]
["UkL17vaH",779,"Media report","http://farmlandgrab.org/post/view/18453","uploads/farmlandgraborgpostview18453.pdf","El Cerrado: la otra región biodiversa de Brasil pierde terreno","2011-04-14",{"$nulls":5},"\"The Cerrado: Brazil’s other biodiverse region loses ground\", by Fred Pearce, Yale e360 | 14 April 2011"]
["Cwtt1IyA",779,"Media report","http://www.adecoagro.com/index.php?idioma=ingles&seccion_generica_id=128","uploads/www-adecoagro-com-index-php.pdf"]
["oASzd2dM",779,"Company sources","http://ir.adecoagro.com/Download/20150320013908.pdf","uploads/iradecoagrocomdownload20150320013908pdf.pdf","Institutional Presentation"]
["YB_TMMm-",779,"Media report","http://bioenergycrops.com/bndes-approves-241-million-to-adecoagro-for-brazil-ethanol-mill/","uploads/bioenergycropscombndes-approves-241-million-to-adecoagro-for-brazil-ethanol-mill.pdf","BNDES Approves $241 Million to Adecoagro for Brazil Ethanol Mill","2013-01-14"]
["LOtglJIA",779,"Company sources","http://www.adecoagro.com/DinamicPage.Aspx?midpid=13&mimid=12&miid=16","uploads/adecoagrocomdinamicpageaspxmidpid13mimid12miid16.pdf","Our Company/ History"]
["uvbiMHjX",779,"Company sources","http://www.adecoagro.com/DinamicPage.Aspx?midpid=102&mimid=3&miid=98","uploads/adecoagrocomdinamicpageaspxmidpid102mimid3miid98.pdf","Nuestros Activos Brasil"]
["75H5xVED",779,"Company sources","http://www.adecoagro.com/DinamicPage.Aspx?midpid=22&mimid=13&miid=25","uploads/adecoagrocomdinamicpageaspxmidpid22mimid13miid25.pdf","Our Business / Sugar, Ethanol and Energy"]
["CbtMQh5t",779,"Company sources","http://ir.adecoagro.com/Download/20150320013939.pdf","uploads/iradecoagrocomdownload20150320013939pdf.pdf","APPRAISAL OF REAL PROPERTY ","2014-09-30"]
["ryFNtfwA",779,"Company sources",null,"uploads/2019-3.pdf","Reporte de Sustentabilidad Año 2019","2019"]

{"sheet":"Involvements","index":4,"n_rows":4,"n_cols":12,"rows_kept":4}
["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"]
[6199,35594,"Adecoagro SA. - El Tejar SA.",662,"Adecoagro S.A.","Parent company"]
[8090,38520,"Unknown (Adecoagro S.A., in Argentina, 38520)",662,"Adecoagro S.A.","Parent company"]
[12965,43893,"Adecoagro Brasil Participações",662,"Adecoagro S.A.","Parent company"]

{"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"]
[662,"Adecoagro S.A.","Luxembourg","Stock-exchange listed company"]
[43893,"Adecoagro Brasil Participações","Brazil","Private company","https://www.adecoagro.com/"]