# LM Database Introduction / Read First

https://docs.google.com/document/d/1w-NS1uMY\_l9AWOiD5DtV95eAEs2BdiPU/edit?usp=drive\_link&amp;ouid=102660977782443621588&amp;rtpof=true&amp;sd=true

# LM data export: Read first

**<span style="color:rgb(0,0,0);">*Brief introduction to the Land Matrix data and data export files*</span>**

<div dir="ltr" id="bkmrk-the-land-matrix-is-a" style="text-align:left;margin-left:0pt;"><table style="border-collapse:collapse;width:98.8095%;height:1481.3px;border:medium none;"><colgroup><col style="width:100%;"></col></colgroup><tbody><tr style="height:104.625px;"><td style="vertical-align:bottom;padding:0pt 3.5pt;overflow:hidden;height:104.625px;"><span style="font-size:12pt;font-family:Aptos;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap;"><span style="border:none;display:inline-block;overflow:hidden;width:311px;height:83px;">![Ein Bild, das Grafiken, Schrift, Logo, Screenshot enthält.  Automatisch generierte Beschreibung](https://lh7-rt.googleusercontent.com/docsz/AD_4nXftP9bT6qJfPkZJtePBNxD0V781my4Xc4lnyThkXfJUPSKFltlgPceoEgOsUIYvpxImZZ4BpZNWc6cg-cL277PCuNvThOjssvBDO6FREYqaeTgr6eLCH-N0UnssKQOS04ProGv9F5KfkM-_jG-RPwsYMhVnjjnvrw-3GGLcMvt3FhoPH8C53g?key=L-wm-70GjQ3DQ_esb7PDFg)</span></span>

</td></tr><tr style="height:55.4479px;"><td style="vertical-align:bottom;padding:0pt 3.5pt;overflow:hidden;height:55.4479px;"><span style="font-size:11pt;font-family:Calibri, sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap;">The Land Matrix is an independent land monitoring initiative that promotes transparency and accountability in decisions over large-scale land acquisitions (LSLAs) in low- and middle-income countries (according to the World Bank classification 2010) by recording and sharing data about these land deals.</span>

</td></tr><tr style="height:24.4688px;"><td style="vertical-align:middle;padding:0pt 3.5pt;overflow:hidden;height:24.4688px;">[<span style="font-size:11pt;font-family:Calibri, sans-serif;color:#0000ff;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:underline;vertical-align:baseline;white-space:pre-wrap;">Frequently Asked Questions (FAQs) \| What is a land deal?</span>](https://landmatrix.org/faq/#what-is-a-land-deal)

</td></tr><tr style="height:19.3125px;"><td style="vertical-align:bottom;padding:0pt 3.5pt;overflow:hidden;height:19.3125px;">  
</td></tr><tr style="height:36.1875px;"><td style="vertical-align:middle;padding:0pt 3.5pt;overflow:hidden;height:36.1875px;"><span style="font-size:11pt;font-family:Calibri, sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap;">This ZIP archive contains a data export from the Land Matrix database in XLSX, CSV, or JSON format.</span>

</td></tr><tr style="height:18.9271px;"><td style="vertical-align:middle;padding:0pt 3.5pt;overflow:hidden;height:18.9271px;"><span style="font-size:11pt;font-family:Calibri, sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap;">Download date: \[YYYY-MM-DD\] (ISO8601)</span>

</td></tr><tr style="height:18.9271px;"><td style="vertical-align:middle;padding:0pt 3.5pt;overflow:hidden;height:18.9271px;"><span style="font-size:11pt;font-family:Calibri, sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap;">Download time: \[HH:MM:SS\] (UTC)</span>

</td></tr><tr style="height:25.3125px;"><td style="vertical-align:middle;padding:0pt 3.5pt;overflow:hidden;height:25.3125px;">  
</td></tr><tr style="height:25.3125px;"><td style="vertical-align:middle;padding:0pt 3.5pt;overflow:hidden;height:25.3125px;"><span style="font-size:11pt;font-family:Calibri, sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap;">To download data from the Land Matrix database, please visit:</span>

</td></tr><tr style="height:40.9167px;"><td style="vertical-align:middle;padding:0pt 3.5pt;overflow:hidden;height:40.9167px;">[<span style="font-size:11pt;font-family:Calibri, sans-serif;color:#0000ff;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:underline;vertical-align:baseline;white-space:pre-wrap;">https://landmatrix.org/list/deals/</span>](https://landmatrix.org/list/deals/)

  
</td></tr><tr style="height:38.6875px;"><td style="vertical-align:middle;padding:0pt 3.5pt;overflow:hidden;height:38.6875px;"><span style="font-size:11pt;font-family:Calibri, sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap;">Please note that the **filter settings** selected on our website before downloading determine which deals are included in the data export. The filters applied to the export in this ZIP archive can be identified from the parameters in the URL used to download it.</span>

</td></tr><tr style="height:26px;"><td style="vertical-align:middle;padding:0pt 3.5pt;overflow:hidden;height:26px;"><span style="font-size:11pt;font-family:Calibri, sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap;">This ZIP archive was downloaded from the following URL:</span>

</td></tr><tr style="height:88.1875px;"><td style="vertical-align:middle;padding:0pt 3.5pt;overflow:hidden;height:88.1875px;">[<span style="font-size:11pt;font-family:Calibri, sans-serif;color:#0000ff;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:underline;vertical-align:baseline;white-space:pre-wrap;">https://landmatrix.org/api/legacy\_export/?subset=PUBLIC&amp;negotiation\_status=ORAL\_AGREEMENT&amp;negotiation\_status=CONTRACT\_SIGNED&amp;negotiation\_status=CHANGE\_OF\_OWNERSHIP&amp;format=csv</span>](https://landmatrix.org/api/legacy_export/?subset=PUBLIC&negotiation_status=ORAL_AGREEMENT&negotiation_status=CONTRACT_SIGNED&negotiation_status=CHANGE_OF_OWNERSHIP&format=csv)

  
</td></tr><tr style="height:128.49px;"><td style="vertical-align:middle;padding:0pt 3.5pt;overflow:hidden;height:128.49px;"><span style="font-size:11pt;font-family:Calibri, sans-serif;color:#000000;background-color:transparent;font-weight:bold;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap;">IMPORTANT:</span><span style="font-size:11pt;font-family:Calibri, sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap;"> Only part of the Land Matrix data can be considered systematically collected. Land Matrix data collection traditionally focuses on transnational land acquisitions (involvement of a foreign investor / filter "Deal scope" = "transnational") for agriculture and forestry. Only for these data subsets the Land Matrix is strategically working on compiling datasets with a complete census of all respective land deals as defined by the Land Matrix (see row 3), acknowledging that in some countries the transparency is very low. Since 2024, there has been an additional focus in Land Matrix data collection on "green deals", and more specifically on land acquisitions for wind farms, solar parks, and carbon offsetting projects. Here too, the Land Matrix aims to cover all land deals as defined by the Land Matrix (see row 3). However, this part of the Land Matrix database is still under construction and thus data collection is not yet complete. </span>

</td></tr><tr style="height:25.3125px;"><td style="vertical-align:middle;padding:0pt 3.5pt;overflow:hidden;height:25.3125px;">  
</td></tr><tr style="height:47.9375px;"><td style="vertical-align:middle;padding:0pt 3.5pt;overflow:hidden;height:47.9375px;">[<span style="font-size:11pt;font-family:Calibri, sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap;">Land Matrix data is available under the </span><span style="font-size:11pt;font-family:Calibri, sans-serif;color:#0000ff;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:underline;vertical-align:baseline;white-space:pre-wrap;">Creative Commons Attribution International (CC BY 4.0) license</span><span style="font-size:11pt;font-family:Calibri, sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap;">. If you wish to use and reference the data, please cite as:</span>](https://creativecommons.org/licenses/by/4.0/)

</td></tr><tr style="height:25.3125px;"><td style="vertical-align:middle;padding:0pt 3.5pt;overflow:hidden;height:25.3125px;"><span style="font-size:11pt;font-family:Calibri, sans-serif;color:#000000;background-color:transparent;font-weight:bold;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap;">Land Matrix \[</span><span style="font-size:11pt;font-family:Calibri, sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap;">year</span><span style="font-size:11pt;font-family:Calibri, sans-serif;color:#000000;background-color:transparent;font-weight:bold;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap;">\]. Data downloaded from \[</span><span style="font-size:11pt;font-family:Calibri, sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap;">specific download URL</span><span style="font-size:11pt;font-family:Calibri, sans-serif;color:#000000;background-color:transparent;font-weight:bold;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap;">\] on \[</span><span style="font-size:11pt;font-family:Calibri, sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap;">date of data download</span><span style="font-size:11pt;font-family:Calibri, sans-serif;color:#000000;background-color:transparent;font-weight:bold;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap;">\].</span>

</td></tr><tr style="height:21px;"><td style="vertical-align:bottom;padding:0pt 3.5pt;overflow:hidden;height:21px;">  
</td></tr><tr style="height:29.0625px;"><td style="vertical-align:bottom;padding-top:0pt;padding-right:3.5pt;padding-bottom:0pt;overflow:hidden;height:29.0625px;"> </td></tr><tr style="height:20.625px;"><td style="vertical-align:top;padding:0pt 3.5pt;overflow:hidden;height:20.625px;"><span style="font-size:12pt;font-family:Calibri, sans-serif;color:#000000;background-color:transparent;font-weight:bold;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap;">TABS/FILES </span><span style="font-size:12pt;font-family:Calibri, sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap;">in this xlsx-file/csv-zip-folder:</span>

</td></tr><tr style="height:20.625px;"><td style="vertical-align:top;padding:0pt 3.5pt;overflow:hidden;height:20.625px;">  
</td></tr><tr style="height:20.625px;"><td style="vertical-align:top;padding:0pt 3.5pt;overflow:hidden;height:20.625px;"><span style="font-size:11pt;font-family:Calibri, sans-serif;color:#000000;background-color:transparent;font-weight:bold;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap;">Variable descriptions tab/file</span>

</td></tr><tr style="height:20.625px;"><td style="vertical-align:top;padding:0pt 3.5pt;overflow:hidden;height:20.625px;"><span style="font-size:11pt;font-family:Calibri, sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap;">Lists all variables and their definitions, data types, and formats. </span>

</td></tr><tr style="height:20.625px;"><td style="vertical-align:top;padding:0pt 3.5pt;overflow:hidden;height:20.625px;">  
</td></tr><tr style="height:20.625px;"><td style="vertical-align:top;padding:0pt 3.5pt;overflow:hidden;height:20.625px;"><span style="font-size:11pt;font-family:Calibri, sans-serif;color:#000000;background-color:transparent;font-weight:bold;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap;">Deals tab/file</span>

</td></tr><tr style="height:160.438px;"><td style="vertical-align:top;padding:0pt 3.5pt;overflow:hidden;height:160.438px;"><span style="font-size:11pt;font-family:Calibri, sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap;">Lists all land deals (one deal per row) that have been exported from the Land Matrix database to this file according to the selected data filter settings. This tab contains the majority of all deal variables. Deals are linked to investors through the "Operating company: Investor ID"(column BI)/"Operating company: Name"(column BJ) and the "Top parent companies" (column K containing investor names and investor IDs). A deal may have one operating company but multiple top parent companies. If no parent company has been recorded for the operating company, the operating company and the topparent company are identical. The investor network behind the operating company can be derived from the Involvement tab/file.</span>

</td></tr><tr style="height:20.625px;"><td style="vertical-align:top;padding:0pt 3.5pt;overflow:hidden;height:20.625px;">  
</td></tr><tr style="height:20.625px;"><td style="vertical-align:top;padding:0pt 3.5pt;overflow:hidden;height:20.625px;"><span style="font-size:11pt;font-family:Calibri, sans-serif;color:#000000;background-color:transparent;font-weight:bold;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap;">Locations tab/file</span>

</td></tr><tr style="height:37.1875px;"><td style="vertical-align:top;padding:0pt 3.5pt;overflow:hidden;height:37.1875px;"><span style="font-size:11pt;font-family:Calibri, sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap;">Lists all locations (one location per row) recorded for the deals listed in the deals tab. A deal can have multiple locations. The locations and their IDs are linked to deals through the Deal ID.</span>

</td></tr><tr style="height:20.625px;"><td style="vertical-align:top;padding:0pt 3.5pt;overflow:hidden;height:20.625px;">  
</td></tr><tr style="height:20.625px;"><td style="vertical-align:top;padding:0pt 3.5pt;overflow:hidden;height:20.625px;"><span style="font-size:11pt;font-family:Calibri, sans-serif;color:#000000;background-color:transparent;font-weight:bold;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap;">Contracts tab/file</span>

</td></tr><tr style="height:37.1875px;"><td style="vertical-align:top;padding:0pt 3.5pt;overflow:hidden;height:37.1875px;"><span style="font-size:11pt;font-family:Calibri, sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap;">Lists all contracts (one contract per row) recorded for the deals listed in the deals tab. A deal can have multiple contracts. The contracts and their IDs are linked to deals through the Deal ID.</span>

</td></tr><tr style="height:20.625px;"><td style="vertical-align:top;padding:0pt 3.5pt;overflow:hidden;height:20.625px;">  
</td></tr><tr style="height:20.625px;"><td style="vertical-align:top;padding:0pt 3.5pt;overflow:hidden;height:20.625px;"><span style="font-size:11pt;font-family:Calibri, sans-serif;color:#000000;background-color:transparent;font-weight:bold;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap;">Data sources tab/file</span>

</td></tr><tr style="height:38.625px;"><td style="vertical-align:top;padding:0pt 3.5pt;overflow:hidden;height:38.625px;"><span style="font-size:11pt;font-family:Calibri, sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap;">Lists all data sources (one data source per row) recorded for the deals listed in the deals tab. A deal can have multiple data sources. The data sources and their IDs are linked to deals through the Deal ID.</span>

</td></tr><tr style="height:20.625px;"><td style="vertical-align:top;padding:0pt 3.5pt;overflow:hidden;height:20.625px;">  
</td></tr><tr style="height:20.625px;"><td style="vertical-align:top;padding:0pt 3.5pt;overflow:hidden;height:20.625px;"><span style="font-size:11pt;font-family:Calibri, sans-serif;color:#000000;background-color:transparent;font-weight:bold;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap;">Involvements tab/file</span>

</td></tr><tr style="height:37.1875px;"><td style="vertical-align:top;padding:0pt 3.5pt;overflow:hidden;height:37.1875px;"><span style="font-size:11pt;font-family:Calibri, sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap;">Lists all direct involvements/holdings (one involvement per row) of one investor in another investor (parent-child investor relation) that are recorded in the Land Matrix database.</span>

</td></tr><tr style="height:20.625px;"><td style="vertical-align:top;padding:0pt 3.5pt;overflow:hidden;height:20.625px;">  
</td></tr><tr style="height:20.625px;"><td style="vertical-align:top;padding:0pt 3.5pt;overflow:hidden;height:20.625px;"><span style="font-size:11pt;font-family:Calibri, sans-serif;color:#000000;background-color:transparent;font-weight:bold;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap;">Investors tab/file</span>

</td></tr><tr style="height:20.625px;"><td style="vertical-align:top;padding:0pt 3.5pt;overflow:hidden;height:20.625px;"><span style="font-size:11pt;font-family:Calibri, sans-serif;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap;">Lists all investors (one investor per row) recorded in the Land Matrix database.</span>

</td></tr><tr style="height:20.625px;"><td style="vertical-align:top;padding:0pt 3.5pt;overflow:hidden;height:20.625px;">  
</td></tr></tbody></table>

</div><span id="bkmrk--1" style="font-weight:normal;"></span>

<span style="font-size:12pt;font-family:Aptos;color:#000000;background-color:transparent;font-weight:400;font-style:normal;font-variant:normal;text-decoration:none;vertical-align:baseline;white-space:pre-wrap;"><span style="border:none;display:inline-block;overflow:hidden;width:605px;height:395px;">![AD&#95;4nXfYsRdQpS&#95;CdQaa-oflgKtVI8MhiWO0WKtg&#95;KQg5&#95;Nq5MCJaTlPfuFmFfGVGrQ7lJVCYWYhFvH6fEo2rq4L-8BpAjGnq53zqTfmH7dMFJxIHKC3sRq4mmBEn1YX9XLOctJj2avlUuv9vM8tIOmuNN3UZv1yKMI3M7UeUZfL5OZF8D2MbsYc2xQ?key=L-wm-70GjQ3DQ&#95;esb7PDFg](https://lh7-rt.googleusercontent.com/docsz/AD_4nXfYsRdQpS_CdQaa-oflgKtVI8MhiWO0WKtg_KQg5_Nq5MCJaTlPfuFmFfGVGrQ7lJVCYWYhFvH6fEo2rq4L-8BpAjGnq53zqTfmH7dMFJxIHKC3sRq4mmBEn1YX9XLOctJj2avlUuv9vM8tIOmuNN3UZv1yKMI3M7UeUZfL5OZF8D2MbsYc2xQ?key=L-wm-70GjQ3DQ_esb7PDFg)</span></span>