Real estate sales sample database — MongoDB, flat (218,766 rows)

A collection per table. Each primary key is the document _id; foreign keys are fields under their own names, so the SQL version's joins become $lookup stages.

Load it:
  sh import.sh                    (into mongodb://localhost:27017)
  sh import.sh "<connection string>"

Or one collection at a time: mongoimport --db real-estate-sales --collection <name> --file <name>.ndjson

Collections:
  agencies — 1,563 documents
  agent_agencies — 12,500 documents
  agents — 12,500 documents
  appraisals — 12,500 documents
  appraisers — 1,563 documents
  clients — 12,500 documents
  inspections — 12,500 documents
  inspectors — 1,563 documents
  neighbourhoods — 1,563 documents
  offers — 12,500 documents
  payment_methods — 6 documents
  properties — 12,500 documents
  property_neighbourhoods — 12,500 documents
  property_types — 8 documents
  repairs — 12,500 documents
  transactions — 100,000 documents

Types: numeric columns are Decimal128, so totals stay exact; dates and timestamps are
Date values read as UTC (the data has no time zone); times and UUIDs are strings;
JSON columns are embedded objects.

Synthetic data, CC0-1.0, from databasesample.com. The same rows as the SQL and CSV files.
