Source: Dubai Land Department open data via data.dubai, Dubai Open Data Licence (licence text). Independent analysis by WIZI Premium, not affiliated with or endorsed by the Dubai Land Department, any government entity, developer, management company or data provider.

Staging schema (data/staging.duckdb)

buildings_raw (259,202 rows)

actual_area VARCHAR, actual_common_area VARCHAR, area_id VARCHAR, area_name_ar VARCHAR, area_name_en VARCHAR, bld_levels VARCHAR, building_number VARCHAR, built_up_area VARCHAR, car_parks VARCHAR, common_area VARCHAR, creation_date VARCHAR, elevators VARCHAR, flats VARCHAR, floors VARCHAR, is_free_hold VARCHAR, is_lease_hold VARCHAR, is_registered VARCHAR, land_number VARCHAR, land_sub_number VARCHAR, land_type_ar VARCHAR, land_type_en VARCHAR, land_type_id VARCHAR, master_project_ar VARCHAR, master_project_en VARCHAR, master_project_id VARCHAR, offices VARCHAR, parcel_id VARCHAR, parent_property_id VARCHAR, pre_registration_number VARCHAR, project_id VARCHAR, project_name_ar VARCHAR, project_name_en VARCHAR, property_id VARCHAR, property_sub_type_ar VARCHAR, property_sub_type_en VARCHAR, property_sub_type_id VARCHAR, property_type_ar VARCHAR, property_type_en VARCHAR, property_type_id VARCHAR, rooms VARCHAR, rooms_ar VARCHAR, rooms_en VARCHAR, shops VARCHAR, swimming_pools VARCHAR, zone_id VARCHAR, load_timestamp VARCHAR

developers (2,370 rows)

developer_id BIGINT, developer_number BIGINT, developer_name_en VARCHAR, legal_status_en VARCHAR, registration_date DATE, license_source_en VARCHAR, license_type_en VARCHAR

dld_sale_index (159 rows)

month DATE, all_monthly_index VARCHAR, all_monthly_price_index VARCHAR, all_quarterly_index VARCHAR, all_quarterly_price_index VARCHAR, all_yearly_index VARCHAR, all_yearly_price_index VARCHAR, flat_monthly_index VARCHAR, flat_monthly_price_index VARCHAR, flat_quarterly_index VARCHAR, flat_quarterly_price_index VARCHAR, flat_yearly_index VARCHAR, flat_yearly_price_index VARCHAR, villa_monthly_index VARCHAR, villa_monthly_price_index VARCHAR, villa_quarterly_index VARCHAR, villa_quarterly_price_index VARCHAR, villa_yearly_index VARCHAR, villa_yearly_price_index VARCHAR

lkp_areas (301 rows)

area_id INTEGER, area_name_en VARCHAR, municipality_number VARCHAR

lkp_procedures (64 rows)

group_id INTEGER, procedure_id INTEGER, is_pre_registration INTEGER, name_en VARCHAR

projects (3,474 rows)

project_id BIGINT, project_number BIGINT, project_name VARCHAR, master_project_en VARCHAR, area_id INTEGER, area_name_en VARCHAR, developer_id BIGINT, developer_name VARCHAR, master_developer_name VARCHAR, project_status VARCHAR, percent_completed DOUBLE, project_start_date DATE, project_end_date DATE, completion_date DATE, cancellation_date DATE, no_of_buildings INTEGER, no_of_villas INTEGER, no_of_units INTEGER, no_of_lands INTEGER, escrow_agent_name VARCHAR, project_classification_id VARCHAR, project_type_id VARCHAR, zoning_authority_en VARCHAR, project_description_en VARCHAR

sales_residential (1,115,144 rows)

txn_id VARCHAR, date DATE, month DATE, txn_group VARCHAR, procedure_id INTEGER, procedure_name VARCHAR, registration VARCHAR, is_offplan BOOLEAN, usage VARCHAR, property_type VARCHAR, property_sub_type VARCHAR, segment VARCHAR, rooms_raw VARCHAR, bedrooms INTEGER, area_sqm DOUBLE, area_sqft DOUBLE, price_aed DOUBLE, price_aed_sqft DOUBLE, area_id INTEGER, area_name_en VARCHAR, master_project VARCHAR, project_number BIGINT, project_name VARCHAR, building_name VARCHAR, has_parking BOOLEAN, parties_1 INTEGER, parties_2 INTEGER, nearest_metro VARCHAR, nearest_mall VARCHAR, nearest_landmark VARCHAR, q_date_ok BOOLEAN, q_price_ok BOOLEAN, q_area_ok BOOLEAN

service_charges (169,109 rows)

budget_year INTEGER, master_community_id BIGINT, master_community_name_en VARCHAR, project_id BIGINT, project_name VARCHAR, property_group_id BIGINT, property_group_name_en VARCHAR, service_category_id INTEGER, service_category_name_en VARCHAR, usage_id INTEGER, usage_name_en VARCHAR, aed_per_sqft DOUBLE, management_company_id BIGINT, management_company_name_en VARCHAR

transactions (1,814,844 rows)

txn_id VARCHAR, date DATE, month DATE, txn_group VARCHAR, procedure_id INTEGER, procedure_name VARCHAR, registration VARCHAR, is_offplan BOOLEAN, usage VARCHAR, property_type VARCHAR, property_sub_type VARCHAR, segment VARCHAR, rooms_raw VARCHAR, bedrooms INTEGER, area_sqm DOUBLE, area_sqft DOUBLE, price_aed DOUBLE, price_aed_sqft DOUBLE, area_id INTEGER, area_name_en VARCHAR, master_project VARCHAR, project_number BIGINT, project_name VARCHAR, building_name VARCHAR, has_parking BOOLEAN, parties_1 INTEGER, parties_2 INTEGER, nearest_metro VARCHAR, nearest_mall VARCHAR, nearest_landmark VARCHAR, q_date_ok BOOLEAN, q_price_ok BOOLEAN, q_area_ok BOOLEAN

units (2,388,184 rows)

property_id BIGINT, parent_property_id BIGINT, area_id INTEGER, area_name_en VARCHAR, master_project_en VARCHAR, project_id BIGINT, project_name_en VARCHAR, land_number BIGINT, parcel_id BIGINT, building_number VARCHAR, unit_number VARCHAR, floor DOUBLE, property_type_en VARCHAR, property_sub_type_en VARCHAR, rooms_en VARCHAR, bedrooms INTEGER, actual_area_sqm DOUBLE, actual_area_sqft DOUBLE, balcony_area_sqm DOUBLE, is_free_hold INTEGER, creation_date DATE

valuations (91,751 rows)

date DATE, month TIMESTAMP, area_id INTEGER, area_name_en VARCHAR, property_type_en VARCHAR, property_sub_type_en VARCHAR, procedure_name_en VARCHAR, actual_worth DOUBLE, property_total_value DOUBLE, procedure_area_sqm DOUBLE, actual_area_sqm DOUBLE