Home leases

Leases Review

Leases Table Structure

Column Data Type Description
lease_id number primary key, unique id assigned to each lease record
property_id number foreign key to properties.csv, id of the property involved in the lease
tenant_id number foreign key to tenants.csv, id of the tenant involved in the lease
lease_start_date date start date of the lease (yyyy-mm-dd)
lease_end_date date end date of the lease (yyyy-mm-dd)
leased_sqft number square footage leased
monthlyRent number monthly rent (in dollars)
notes unstructured text text input associated with the lease

Leases Data Profiling

1. Row Level Checks

Total number of lease records

  • 75 total lease records.

Active lease summary

  • As of Wed, 11 February 2026 there are:

    Active Lease Records

    33

    Expired Lease Records

    42

Null / Blanks summary
1
2
3
4
5
6
7
8
No Results

2. Primary key uniquness validation

Uniqueness of primary key

75 total lease records with 75 unique lease_id values.

3. Foreign key integrity checks

property_id check against properties.csv
1
2
3
4
5
6
7
8
9
10
No Results

tenant_id check against tenants.csv
1
2
3
4
5
6
7
8
9
10
No Results

Data Consistency Checks

4. Date Field Validation

Earliest & Latest date values

lease_start_date

Earliest lease_start_date

2018-03-02

Latest lease_start_date

2023-11-28

lease_end_date

Earliest lease_end_date

2019-03-02

Latest lease_end_date

2033-11-25

Check for future start dates

0 lease records with future leases_start_date

Check for lease_end_date before lease_start_date

0 lease records with lease_end_date before lease_start_date

Lease duration distribution (@TODO prorably move to end)

Loading...

5. Numeric Field Validation
1
2
No Results

leased_sqft

Loading...

monthlyRent

Loading...

6. Text Field Validation

notes
1
No Results

Most common text in notes
1
No Results

Business Logic & Reasonableness Check

7. Logical Checks

Logical Duplicates

0 logical duplicates found between property_id and tenant_id

8. Reasonableness Checks

leased_sqft vs. monthlyRent

  • check for:
    • large sqft with very low rent
    • small sqft with extremely high rent
Loading...

monthlyRent vs. lease duration in days

  • check for:
    • very long lease with unusually low rent
Loading...