Mortgages and gifts (module mortgages_gifts)
Script: scripts/modules/mortgages_gifts.py (run from the project root; a few seconds).
Source: Dubai Land Department (DLD) open data via data.dubai (Dubai Open Data Licence): the transactions file (dataset
470061), staged in data/staging.duckdb (see 00-staging.md). Nothing else is used. Data run to 2026-11-05; the latest
complete month is October 2026.
What is counted
The DLD transactions file has three transaction groups: Sales, Mortgages and Gifts. The sales statistics of the site use the Sales group only. This module publishes the other two:
- Mortgages: every record of the Mortgages group with a valid registration date, January 2008 to the latest complete month.
- Gifts: every record of the Gifts group (procedures Grant, Grant Pre-Registration, Grant on Delayed Sell and Grant Development).
A record is counted in the month of its registration date. The amount is the value DLD records with the procedure
(actual_worth): for a mortgage the amount registered with the mortgage (the loan or facility amount), for a gift the
value declared for the gifted property. It is not a sale price. Amounts are used only when they pass the staging price
check (at least AED 10,000).
The open data has no lender, borrower, donor or recipient, no interest rate or term, and no identifier that links a mortgage to the sale it finances, so loan-to-value ratios and the share of sales bought with a mortgage cannot be computed.
Procedure groups
Mortgage procedures are grouped by the words in their DLD names (first match wins; the full assignment is published in
procedure_groups):
| Group | Procedures |
|---|---|
| Portfolio mortgage | names containing "Portfolio" (one mortgage over several properties; amounts are large) |
| Lease to own / lease finance | names containing "Lease" (lease-to-own and lease-finance registrations, modifications and transfers) |
| Development mortgage | names containing "Development" (mortgages registered during development, including their modifications) |
| Mortgage modification | names containing "Modif" (Modify Mortgage, Modify Delayed Mortgage and pre-registration forms) |
| Mortgage transfer | names containing "Transfer" |
| New mortgage | everything else: Mortgage Registration, Mortgage Pre-Registration (off-plan) and Delayed Mortgage |
"New mortgage" is the headline series: a new mortgage over a property. Modifications and transfers change an existing mortgage (for example a refinance with another bank or a changed amount) and are shown separately.
A lease-to-own registration creates two records in the transactions file: one in the Sales group (counted in the sales statistics) and one in the Mortgages group (counted here, in the lease-to-own group). The two layers are never added up on the site.
Property segment
From the DLD property type of the record: Apartment (unit, flat), Villa / townhouse (villa, stacked townhouse), Land, and Other property (office, shop, hotel apartment, whole building, other). Mortgages over a whole building or a plot can cover many homes.
Published tables (data/out/mortgages_gifts/, each as .parquet and .csv)
| File | Grain | Content |
|---|---|---|
city_monthly |
month x layer x dimension x category | n, value_aed (sum of amounts), median_amount_aed; dimensions all, procedure_group, segment (all procedures) and segment_new (new mortgages and gifts only) |
community_latest |
community x layer (New mortgages, Gifts) x segment | records in the last 12 complete months (n_12m) and the 12 months before (n_prev_12m), change_12m_pct, median_amount_aed |
procedure_groups |
DLD procedure | the group each procedure is assigned to and its all-time record count |
site/data/mortgages_gifts.json holds the monthly series from January 2013, the community table and the procedure groups.
Community names come from the same resolver as the price index (price_index.md, community_map.csv), applied to the
DLD area, master project, project and building of each record.
Suppression and changes
- Any cell from fewer than 5 records has its count and statistics empty (
suppressed = true). An amount needs at least 5 records with a usable amount. change_12m_pctis published only when both 12-month periods hold at least 20 records.- Only primary suppression is applied (see
00-publication-compliance.md, section 6).
Caveats
- Registrations follow DLD registration dates. Off-plan mortgages (Mortgage Pre-Registration) and Delayed Mortgage registrations can be recorded well after the loan was agreed.
- The median amount moves with the mix of properties mortgaged in the month, not only with loan sizes.
- Gifts with a declared value are not market transactions; the value is as declared to DLD.