API & data

DVF: why several rows can describe one sale

Counting rows and counting transactions are different operations. That distinction changes your charts.

Inspect the structure

A transaction may cover several real estate components. Before totaling export amounts, inspect identifiers and the detail represented by each row. If a transaction value appears on several components, adding every row may count the same amount more than once.

Build a small control case

Take a fictional apartment and outbuilding sold together. Write down the expected result first: one overall sale with several descriptive components. Compare your grouping against that expectation. A manual check on a small sample is more informative than a large total with an unexplained calculation method.

Explain the denominator

In a summary, state whether you count rows, premises, or distinct transactions. Keep the definition consistent across neighborhoods and periods. Otherwise, a structural difference may look like a market change.

Checklist

  • Identify what rows represent
  • Test a simple grouping
  • Name what you count

Primary sources