Commercial Lease Renewal Patterns
This dataset provides detailed, flat-structured records of commercial lease agreements, including tenant and property information, lease terms, renewal status, and transactional details. It enables commercial real estate managers and analysts to identify patterns and factors influencing lease renewals, optimize retention strategies, and benchmark property performance across portfolios.
Sample rows
preview · 8 of 200 rows · all 28 columns| lease_idstring | lease_typestring | lease_escalation_ratefloat | lease_break_optionboolean | tenant_industrystring | property_idstring | tenant_idstring | tenant_namestring | lease_start_datedate | lease_end_datedate | lease_term_monthsinteger | renewal_statusstring | renewal_datedate | renewal_term_monthsinteger | rent_amountfloat | rent_currencystring | property_street_addressstring | property_citystring | property_statestring | property_postal_codestring | property_countrystring | property_size_sqftfloat | tenant_contact_namestring | tenant_contact_emailstring | tenant_contact_phonestring | lease_break_datedate | lease_escalation_clauseboolean | lease_notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| LSE-00001 | Gross | 3 | false | Retail | PRP-10001 | TEN-5001 | Market Fresh Retail LLC | 2018-01-01 | 2023-01-01 | 60 | Renewed | 2023-01-05 | 60 | 21000 | USD | 8477 Oakwood Ave | Dallas | TX | 75201 | USA | 12000 | Sandra Coleman | sandra.coleman@ | +1-214-555-0901 | blank | true | Renewal triggered escalation clause for annual rent increase. |
| LSE-00002 | Net | 4.5 | true | Technology | PRP-10002 | TEN-5002 | Tech Innovate GmbH | 2022-06-01 | 2027-06-01 | 60 | Pending | blank | blank | 4200 | EUR | 21 Berliner Strasse | Berlin | BE | 10115 | Germany | 3500 | Martin Fuchs | martin.fuchs@ | +49-30-555-2118 | 2025-06-01 | true | International lease in EUR with break option at 3 years. |
| LSE-00003 | Modified Gross | blank | false | Fitness | PRP-10003 | TEN-5003 | Prime Fitness Inc. | 2023-02-01 | 2024-02-01 | 12 | Not Renewed | blank | blank | 1500 | USD | 2905 Pinecrest Rd | Phoenix | AZ | 85016 | USA | 900 | Jared Mitchell | jared.mitchell@ | +1-602-555-1138 | blank | false | Tenant will vacate after term ends, fitness startup. |
| LSE-00004 | Gross | 1.25 | false | Finance | PRP-10004 | TEN-5004 | Swiss Med Finance AG | 2017-09-01 | 2027-09-01 | 120 | Renewed | 2027-09-10 | 60 | 8500 | CHF | 10 Bahnhofplatz | Zurich | ZH | 8001 | Switzerland | 5200 | Lucia Wenger | lucia.wenger@ | +41-44-555-2020 | blank | true | Escalation capped at 1.25% annually for finance tenant. |
| LSE-00005 | Net | 3.75 | true | Manufacturing | PRP-10005 | TEN-5005 | Brazuca Logistics SA | 2021-05-01 | 2022-05-01 | 12 | Pending | blank | blank | 9000 | BRL | Avenida Paulista 3000 | Sao Paulo | SP | 01310-100 | Brazil | 6500 | Carlos Oliveira | carlos.oliveira@ | +55-11-555-1234 | 2021-11-01 | true | Short-term lease for manufacturing. Break option after 6 months. |
| LSE-00006 | Modified Gross | blank | false | Food & Beverage | PRP-10006 | TEN-5006 | Urban Eats Cafe Corp | 2019-03-01 | 2024-03-01 | 60 | Renewed | 2024-03-10 | 24 | 3500 | USD | 1619 Willow St | Denver | CO | 80203 | USA | 1200 | Leah Parks | leah.parks@ | +1-303-555-4412 | blank | false | Renewed for 24 months, small business food lease. |
| LSE-00007 | Gross | blank | false | Legal | PRP-10007 | TEN-5007 | Pacific Law Partners | 2020-11-01 | 2021-11-01 | 12 | Not Renewed | blank | blank | 2100 | USD | 7320 Broadway Ave | Seattle | WA | 98101 | USA | 700 | Harold Lin | harold.lin@ | +1-206-555-6772 | blank | false | Tenant did not renew after term, legal services office. |
| LSE-00008 | Modified Gross | blank | false | Marketing | PRP-10008 | TEN-5008 | Can Marketing Solutions Ltd | 2021-01-01 | 2022-01-01 | 12 | Pending | blank | blank | 890 | CAD | 213 King St W | Toronto | ON | M5V 1E9 | Canada | 750 | Ava Forster | ava.forster@ | +1-416-555-8912 | blank | false | Pending renewal for marketing agency, compact location. |
| LSE-00009 | Gross | blank | false | Wholesale | PRP-10009 | TEN-5009 | Artisan Traders Inc. | 2022-09-01 | 2022-10-01 | 1 | Not Renewed | blank | blank | 500 | USD | 4109 Oak Ridge Blvd | Charlotte | NC | 28202 | USA | 5200 | Eli Cohen | eli.cohen@ | +1-704-555-4102 | blank | false | Short-term pop-up lease for wholesale tenant. |
| LSE-00010 | Net | 5 | false | Healthcare | PRP-10010 | TEN-5010 | Maple Health Group | 2015-07-01 | 2025-07-01 | 120 | Renewed | 2025-07-10 | 72 | 12000 | CAD | 98 Queen St | Ottawa | ON | K1P 5A9 | Canada | 8500 | Christopher Lau | christopher.lau@ | +1-613-555-7452 | blank | true | Healthcare lease with escalation clause, long-term renewal. |
| LSE-00011 | Gross | 4 | true | Retail | PRP-10011 | TEN-5011 | Outback Gear Pty Ltd | 2020-03-01 | 2025-03-01 | 60 | Renewed | 2025-03-10 | 60 | 13000 | AUD | 127 Flinders St | Melbourne | VIC | 3000 | Australia | 9800 | Gemma Fraser | gemma.fraser@ | +61-3-5550-4872 | 2022-03-01 | true | Retail lease with break option and escalation in Australia. |
| LSE-00012 | Net | 2.25 | false | Technology | PRP-10012 | TEN-5012 | Smart Systems Corp. | 2021-04-01 | 2024-04-01 | 36 | Pending | blank | blank | 3100 | USD | 4800 Digital Ave | San Jose | CA | 95110 | USA | 4200 | Sara Gentry | sara.gentry@ | +1-408-555-1882 | blank | true | Pending renewal for US tech office, escalation clause active. |
| LSE-00013 | Gross | blank | false | Legal | PRP-10013 | TEN-5013 | Legal Plus Services | 2022-07-01 | 2023-07-01 | 12 | Renewed | 2023-07-10 | 12 | 950 | CAD | 520 Laurier Ave W | Ottawa | ON | K1R 5E8 | Canada | 650 | Fiona Clark | fiona.clark@ | +1-613-555-0921 | blank | false | Legal services renewed lease for 12 months. |
| LSE-00014 | Gross | 2.5 | true | Healthcare | PRP-10014 | TEN-5014 | Zurich Wellness Group | 2016-10-01 | 2026-10-01 | 120 | Renewed | 2026-10-15 | 60 | 7500 | CHF | 15 Seefeldstrasse | Zurich | ZH | 8008 | Switzerland | 3500 | Kurt Meier | kurt.meier@ | +41-44-555-2333 | 2020-10-01 | true | Healthcare lease in Zurich, break option exercised in year 4. |
| LSE-00015 | Modified Gross | blank | false | Food & Beverage | PRP-10015 | TEN-5015 | Eatery Express LLC | 2022-11-01 | 2023-11-01 | 12 | Not Renewed | blank | blank | 800 | USD | 1764 Elm St | Houston | TX | 77002 | USA | 600 | Daniel Brooks | daniel.brooks@ | +1-713-555-3345 | blank | false | Tenant vacated after term, small restaurant lease. |
| LSE-00016 | Gross | blank | false | Fitness | PRP-10016 | TEN-5016 | Fitness Plus Studios | 2021-08-01 | 2022-08-01 | 12 | Renewed | 2022-08-10 | 24 | 1850 | USD | 4789 Glenwood Dr | Miami | FL | 33101 | USA | 1100 | Charlotte Evans | charlotte.evans@ | +1-305-555-9132 | blank | false | Renewed for 2 years, fitness studio tenant. |
| LSE-00017 | Net | 4 | true | Manufacturing | PRP-10017 | TEN-5017 | NorthStar Manufacturing | 2022-02-01 | 2027-02-01 | 60 | Pending | blank | blank | 6200 | CAD | 390 Industrial Rd | Montreal | QC | H2V 4B3 | Canada | 5200 | Jacques Tremblay | jacques.tremblay@ | +1-514-555-3125 | 2024-02-01 | true | Pending renewal, manufacturing with break option mid-term. |
| LSE-00018 | Gross | 2 | false | Finance | PRP-10018 | TEN-5018 | Balance Finance Co. | 2019-01-01 | 2029-01-01 | 120 | Renewed | 2029-01-05 | 60 | 11000 | USD | 1889 Wall St | New York | NY | 10005 | USA | 8500 | Melissa Franco | melissa.franco@ | +1-212-555-6001 | blank | true | Long-term finance lease, renewal triggered escalation. |
| LSE-00019 | Gross | 3.8 | false | Retail | PRP-10019 | TEN-5019 | Retail Junction Corp. | 2018-08-01 | 2023-08-01 | 60 | Pending | blank | blank | 25000 | USD | 9900 Northfield Dr | Chicago | IL | 60603 | USA | 20000 | Tina Brooks | tina.brooks@ | +1-312-555-6721 | blank | true | Pending renewal for large retail property. |
| LSE-00020 | Modified Gross | blank | false | Marketing | PRP-10020 | TEN-5020 | Fusion Marketing Inc. | 2022-05-01 | 2023-05-01 | 12 | Not Renewed | blank | blank | 1200 | CAD | 4129 Jasper Ave | Edmonton | AB | T5J 3L9 | Canada | 800 | Emily Nash | emily.nash@ | +1-780-555-2491 | blank | false | Not renewed, small marketing agency lease. |
What the 200 rows show
from the 200-row sampleNet (lease type) stands out: 30 of its 57 rows have lease_
- 21%lease_
break_ option = true - 2.8median lease_
escalation_ rate - 3renewal statuses
- 6rent currencies
- 10property countries
- 45property states
Median 2.8, from 1.0 to 100.0.
- string 17
- integer 2
- float 3
- date 4
- boolean 2
Columns
28 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 17 columns | |||
lease_id | string | Unique identifier for each commercial lease agreementunique | LSE-00001 |
property_id | string | Unique identifier for the commercial property | PRP-10001 |
tenant_id | string | Unique identifier for the tenant | TEN-5001 |
tenant_name | string | Legal name of the tenant company or individual | Market Fresh Retail LLC |
tenant_industry | string | Industry sector of the tenant (e.g., Retail, Technology, Finance)optional | Retail |
lease_type | string | Type of lease (e.g., Gross, Net, Modified Gross)Gross · Net · Modified Gross · optional | Gross |
renewal_status | string | Current status of lease renewal (e.g., Renewed, Not Renewed, Pending)Renewed · Not Renewed · Pending | Renewed |
rent_currency | string | Currency code for rent payment (e.g., USD, EUR)6 currencies | USD |
property_street_address | string | Street address of the leased property | 8477 Oakwood Ave |
property_city | string | City where the property is located | Dallas |
property_state | string | State or province where the property is located | TX |
property_postal_code | string | Postal code of the property location | 75201 |
property_country | string | Country where the property is located10 countries | USA |
tenant_contact_name | string | Primary contact person for the tenantoptional | Sandra Coleman |
tenant_contact_email | string | Email address of the tenant's primary contactoptional | lucia.wenger@ |
tenant_contact_phone | string | Phone number of the tenant's primary contactoptional | +1-214-555-0901 |
lease_notes | string | Additional notes or comments about the leaseoptional | Renewal triggered escalat… |
| Numbers 5 columns | |||
lease_term_months | integer | Duration of the lease in months1 or more | 60 |
renewal_term_months | integer | Duration of the renewed lease in months (if applicable)1 or more · optional | 60 |
rent_amount | float | Monthly rent amount for the lease0 or more | 21000 |
property_size_sqft | float | Size of the leased property in square feet0 or more | 12000 |
lease_escalation_rate | float | Annual escalation rate percentage (if applicable)0 to 100 · optional | 3 |
| Dates and times 4 columns | |||
lease_start_date | date | Start date of the lease agreement | 2018-01-01 |
lease_end_date | date | End date of the lease agreement | 2023-01-01 |
renewal_date | date | Date when the lease was renewed (if applicable)optional | 2023-01-05 |
lease_break_date | date | Date when the break option can be exercised (if applicable)optional | 2025-06-01 |
| True or false 2 columns | |||
lease_break_option | boolean | Indicates if the lease includes a break optionoptional | false |
lease_escalation_clause | boolean | Indicates if the lease includes an escalation clauseoptional | true |
Use it for
A real estate dashboard
The lease_
break_ option rate, lease_ escalation_ rate by lease_ type and a breakdown of tenant_ industry. Excel, Power BI or Tableau. Why do 41 of 200 rows have lease_
break_ option = true? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Leases200LSE-000013GrossLSE-000024.5NetLSE-000053.75Net
A software demo
Believable leases with property_
id, tenant_ id and tenant_ name to fill a screen in front of a buyer.
blueprint · commercial-lease-renewal-patterns
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 28 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
- Include tenant and property profiles
- Track lease renewal timing and terms
- Flag non-renewal reasons
- Exclude short-term leases
1 credit per row. Preview 20 rows free. Buy rows for the full run.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- commercial-lease-renewal-patterns