Dubai transaction query revisions: cut-offs and reproducibility, 26 September 2026

Dubai transaction query revisions: cut-offs and reproducibility, 26 September 2026

Posted on byLida MoghaddamLida Moghaddam

Disclaimer: This article is for general informational purposes only. It is based on cited public data and published under Lida Moghaddam's RERA-licensed masthead. It is not financial, legal, or investment advice. Dubai's property market moves quickly, so figures, yields, and rules may change or become outdated by the time you read this. Verify current information with the relevant authority or a qualified professional before acting. Read the full disclaimer.

Table of contents+

The same official Dubai Land Department residential-sales query for 18 to 24 September 2026 returned 2,348 records at 10:25:30 GST on 25 September and 2,347 at 06:19:47 GST on 26 September. The AED total was lower by exactly AED 2,423,000.00 in the later snapshot, while a second extraction 150 seconds later returned the same normalized row set.

The saved result changed by one row

The row population changed once across the three saved snapshots, then remained stable during the same-day control. The filter selections match the fields on the DLD Real Estate Data interface. The saved request body was identical each time; only the response cut-off changed.

Official DLD snapshotRecordsReturned valueMedian row valueNormalized row set
25 Sep 2026, 10:25:30 GST2,348AED 5,561,538,842.07AED 1,320,000.0082986ae87e2a...
26 Sep 2026, 06:19:47 GST2,347AED 5,559,115,842.07AED 1,320,000.007597cc066370...
26 Sep 2026, 06:22:17 GST2,347AED 5,559,115,842.07AED 1,320,000.007597cc066370...

Source: three saved official DLD transaction responses for the 18 to 24 September 2026 filter, extracted at the timestamps shown. The DLD Real Estate Data page provides the current interface and filter context, not these historical row snapshots. Sums and medians were recomputed from the saved rows with Decimal arithmetic.

The neutral read: the first fresh result had one fewer row and AED 2,423,000.00 less returned value than the saved 25 September result, both differences equal to -0.04%. The median difference was AED 0.00. The identical normalized hashes in the two fresh runs mean no further row-content change was observed during their 2-minute, 30-second interval.

Three DLD snapshots show 2,348 records followed by two stable results of 2,347
The same query changed by one row between 25 and 26 September, then held the same normalized population across the two fresh runs.

This test starts with the raw response behind yesterday's verified week-ending 24 September pulse. It does not repeat that article's weekly breakdown. It asks a different question: what happens when its exact query is run again?

Transaction date, extraction time and publication date are different clocks

The transaction date belongs to each returned row; the extraction time belongs to the response; the publication date belongs to this report. Treating them as one date makes a live query look more final than the evidence supports.

Date or timeWhat it identifiesValue in this testSource
Filter windowThe From and To inputs sent to DLD18 to 24 Sep 2026Saved request; current filter context at DLD Real Estate Data
Transaction DateDLD's public label for the date attached to a sales rowReturned range was 17 Sep 2026 at 15:15:27 to 24 Sep 2026 at 15:13:30DLD Real Estate Data and saved rows
Extraction cut-offThe response timeStamp when that snapshot was produced25 Sep at 10:25:30 GST; 26 Sep at 06:19:47 and 06:22:17 GSTSaved official responses
Publication dateThe editorial date attached to this report26 Sep 2026This publication record
Registration TypeA category, Ready or Off Plan, not a dateBoth types were left open in the queryDLD interface and saved request

The returned minimum INSTANCE_DATE falls on 17 September even though the From input was 18 September. This report preserves the official response boundary. It does not silently remove that row or convert the filter into a midnight-to-midnight definition that the response itself does not show.

The public sales response does not supply a separate per-row registration-date field. It supplies Transaction Date and Registration Type. The extraction cut-off is therefore the response timestamp, not a presumed registration date.

The query must be frozen before the total

The reproducible population is Residential Sales for the exact DLD filter window, with every other listed dimension left open. A total without these inputs is not the same analytical object.

Query fieldExact value sentPopulation effectOfficial evidence
From and To09/18/2026 to 09/24/2026Applies DLD's date-filter boundaryDLD Real Estate Data
Transaction TypeSales, P_GROUP_ID=1Excludes Mortgages and GiftsSame official interface and saved response labels
UsageResidential, P_USAGE_ID=1Excludes Commercial and Other usageSame official interface and saved response labels
Registration TypeBlankIncludes Ready and Off Plan rowsSaved request
Freehold, Area, Property TypeBlankApplies no further filter on those fieldsSaved request
Page requestTake 5,000; skip 0Requests the first 5,000 rowsSaved request
SortINSTANCE_DATE_DESCOrders rows by the returned transaction-date fieldSaved request

Source: the official DLD Real Estate Data interface, checked 26 September 2026, plus the exact saved request and three saved official responses extracted at the stated cut-offs. The interface page supplies current filter context; it does not expose those historical rows.

Each response repeated a TOTAL equal to the number of saved rows. The largest result had 2,348 rows, below the 5,000-row request. That makes the response internally complete for this request; it does not turn the snapshot into a permanent historical version.

The broader DLD data-source map explains which official surface fits transactions, rents, projects and other questions. This method stays inside one transaction population.

The field dictionary prevents category drift

The calculation uses DLD's returned labels as they stand. It does not translate Unit into apartment, Ready into completed construction evidence, or a response row into a unique legal file.

Returned fieldMeaning used hereTreatment in the calculationSource
TRANSACTION_NUMBERDLD's returned transaction identifierCounted for a distinct-identifier checkSaved DLD rows
INSTANCE_DATEThe row's Transaction Date fieldUsed only for returned range and sortingDLD public output label and saved rows
GROUP_ENTransaction familyRequired to equal SalesSaved DLD rows
USAGE_ENUsage categoryRequired to equal ResidentialSaved DLD rows
IS_OFFPLAN, IS_OFFPLAN_ENRegistration Type flag and labelPreserved as Ready or Off PlanDLD public output label and saved rows
IS_FREE_HOLD_ENFreehold labelPreserved, not filteredDLD public output label and saved rows
AREA_ENDLD area labelPreserved exactlySaved DLD rows
PROP_TYPE_ENDLD Property TypePreserved as Unit, Building or LandDLD public output label and saved rows
TRANS_VALUEReturned AmountConverted from its saved value to Decimal before sums and mediansDLD public output label and saved rows
RN, TOTALPage row number and repeated response totalAudited, then excluded from the normalized content hashSaved DLD rows and calculation method

Source: DLD Real Estate Data, checked 26 September 2026, plus the three official saved responses.

The first snapshot had 2,348 distinct transaction numbers across 2,348 rows. Each fresh snapshot had 2,347 distinct numbers across 2,347 rows. That equality is a control for this population, not a rule that every DLD query always has one row per identifier.

Two hashes answer different audit questions

The full-file hash proves which exact response file was used; the normalized-row hash tests whether the substantive returned row population matches. Both are needed because a fresh response carries a fresh timestamp even when its rows are unchanged.

ArtefactSHA-256What the comparison showedSource period
Exact query JSON8dad1fecf248b1c67558aadf27793821aff00d1a7acd90c758a85ec2a9dc1f91One request body controlled all runsSaved 18 to 24 Sep 2026 query
25 Sep raw responseb7241c47e7b0bcf7a9be59939894e9b14827e65ae671ce1d08600fc4c8153a3dExact file behind the earlier cut-offExtracted 25 Sep 2026
26 Sep run A raw response5d56d7ac667cede27df0b45245f6ee79771fd8c05de7588d77054e5cacd4577dDifferent file and different row populationExtracted 26 Sep 2026
26 Sep run B raw response25f16c2ec995c2e52caa2584f93b5d0611e0700176398212b5d9ac53e4f2cc78Different file, same normalized rows as run AExtracted 26 Sep 2026
26 Sep normalized rows7597cc06637036db6bad603792d777d13c9d8b3a51b4b894fc6f6bde06e61ec3Identical in run A and run BExtracted 26 Sep 2026

Source: SHA-256 hashes calculated from the saved official DLD responses and the exact query file on 26 September 2026.

The normalization sorts every row and excludes only RN and the repeated TOTAL before hashing. Row membership and every other returned field remain in the fingerprint. That is why the 25 September normalized hash differs from 26 September, while both 26 September normalized hashes match.

Reproduce a dated result in six saved steps

A reproducible result freezes the question, input, output, calculation and editorial cut-off as one evidence bundle. Re-running the live query later answers a new as-of question.

Saved artefactMinimum contentAudit question it answersEvidence in this test
Query fileEvery filter, page limit, offset and sortWas the population definition identical?One JSON file, one query hash
Raw responseComplete unedited server outputWhich exact rows existed at that cut-off?Three complete JSON responses
Response timeTimestamp and timezone from the serverWhen did this snapshot exist?Three timeStamp values in GST
Calculation programDecimal parsing, counts, sums, median and assertionsCan every displayed metric be regenerated?One saved program and JSON output
File and row hashesRaw-file and normalized-row SHA-256Did bytes change, and did row content change?Four artefact hashes plus two normalized populations
Publication recordDate and named source cut-offWhich snapshot did the article report?26 Sep 2026 publication, 06:22:17 GST final data cut-off

Source: the saved 25 and 26 September 2026 official DLD responses, exact query, recompute.py and its machine-readable output.

  1. Name the population

    Write the date window, transaction type, usage and every open dimension before running the query. “Dubai transactions” alone is not a reproducible scope.

  2. Save the exact request

    Keep the JSON bytes that were sent, then hash that file. A later analyst can distinguish a data revision from a filter change.

  3. Keep the raw response untouched

    Store the complete response before opening it in a spreadsheet or transforming a field. Record the endpoint, response timestamp and timezone beside it.

  4. Calculate from saved rows

    Parse each TRANS_VALUE as Decimal. Recompute the count, sum and median from the rows, and assert that the repeated DLD TOTAL equals the saved row count.

  5. Compare content, not only bytes

    Hash the raw file for exact identity. Separately sort and hash normalized rows so a new response timestamp does not masquerade as a population revision.

  6. Publish the cut-off

    Put the query period and final extraction time beside the number. If a later run differs, publish it as a new snapshot or a documented revision, not as an invisible replacement.

Five-stage reproducibility path from query to raw JSON, hash, Decimal calculation and publication
The audit trail keeps the request, response, hash, calculation and publication cut-off together.

The observed revision proves a difference, not its cause

The saved responses establish that one row left this query population between the two cut-offs. They do not establish why it left or what happened in any private transaction file.

Established by the saved evidenceNot established by the saved evidenceRequired additional evidence
One Ready, Residential, Free Hold, Land row dated 24 Sep 2026 at 13:33:51 was present first and absent laterWhether it was corrected, cancelled, reclassified or temporarily omittedAn official revision note or a transaction-specific record explicitly proving the cause
Its returned value was AED 2,423,000.00The parties' contractual position, payment history or completion statusThe relevant official record and supplied transaction documents
The total and count were each -0.04% at run A versus the earlier snapshotA citywide price movement or a forecastA dataset and method designed for that separate question
Run A and run B matched for 150 secondsThat the population will never change againA later dated extraction using the same query

Source: row-level diff of three saved official DLD transaction responses extracted 25 and 26 September 2026. The resolving DLD Real Estate Data page is linked for current interface context, not as a host for the saved historical rows.

No SPA, valuation, offer, receipt, bank statement, completion statement or other transaction-specific document was supplied for this report. The method therefore stops at the public row-set evidence.

FAQ, checked 26 September 2026

Why can the same Dubai transaction query show a different total?

This controlled test proves that the same saved DLD Real Estate Data inputs returned one fewer row on 26 September than at the 25 September cut-off. The public response does not identify the cause, so this report does not assign one.

How do I check Dubai real estate transactions?

Use the official DLD Real Estate Data interface for current data. Record the From and To dates, Transaction Type, Registration Type, Freehold, Area, Usage and Property Type selections, then save the output and extraction time together.

Is transaction date the same as extraction date?

No. DLD labels the row field Transaction Date, while the response timeStamp records when that query snapshot was produced. This report was published on 26 September 2026 using a final data cut-off of 06:22:17 GST that day.

Which DLD transaction total is correct when two snapshots differ?

Each total is a dated result for its named query and extraction cut-off. For the 18 to 24 September 2026 population, 2,348 records is the 25 September snapshot and 2,347 records is the later 26 September snapshot.

Does a matching raw-file hash prove the rows are unchanged?

A matching full-file hash proves identical bytes. In this test the fresh raw-file hashes differed because their response timestamps differed, while the normalized-row hash matched and established that the row content was stable across the 150-second control.

Last updated
CategoryData
Written byLida MoghaddamLida Moghaddam

Architect-turned-real-estate-specialist based in Dubai. She helps buyers, sellers, and investors read property with a designer's eye — structure, location, and long-term value.

More from Data

View all Data
Newsletter

The sharpest read on Dubai real estate.

Sourced guides, original data, and plain-language process reporting — in your inbox every week. No listings, no sales pressure.

Free. Unsubscribe anytime.