Home properties

Properies Review

Properties Table Structure

Column Data Type Description
property_id number unique id assigned to each property record
property_name string name of the property
property_type string categorical description of properties mode of use
city string city the property is located in
state string two-letter abbreviation of state property is located in
total_sqft number total sqft of the property
year_built number 4-digit year the property was built

Properties Data Profiling

1. Row Level & Structure Checks

Total number of property records

  • 25 total property records

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

2. Primary key uniquness validation

Uniqueness of primary key

25 total property records with 25 unique property_id values.

3. Foreign key integrity checks

No foreign keys in properties table

Data Consistency Checks

4. Date Field Validation

Earliest & Latest date values

year_built

Earliest year_built

1972

Latest year_built

2018

Check for future start dates

0 property records with future year_built values.

Check for extremely old properties

Oldest property is 54 years old.

Property age distribution

Loading...

5. Numeric Field Validation
1
2
No Results

total_sqft

Loading...

year_built

Loading...

6. Text Field Validation
1
2
3
4
No Results
1
2
3
4
5
1
2
3
4
5
1
2
3
4
5
1
2
3
4
5
No Results

property_type
No Results

property_type shows upper/lower casing discrepancies
No Results

Business Logic & Reasonableness Check

7. Logical Checks

Logical Duplicates

2 records for property_name robinson plaza

Robinson Plaza
No Results

8. Reasonableness Checks

extremely old properties

Loading...