Real estate sales sample database — MongoDB, embedded (2,187,514 rows)

Tables that belong to another are folded into it as arrays, so the documents read the way the application uses them. The rest are collections of their own, joined by key as in the flat version.

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 — 15,625 documents
  agents — 125,000 documents, each with its agent_agencies
  appraisals — 125,000 documents
  appraisers — 15,625 documents
  clients — 125,000 documents
  inspections — 125,000 documents
  inspectors — 15,625 documents
  neighbourhoods — 15,625 documents
  offers — 125,000 documents
  payment_methods — 6 documents
  properties — 125,000 documents, each with its property_neighbourhoods
  property_types — 8 documents
  repairs — 125,000 documents
  transactions — 1,000,000 documents

Folded in (no collection of their own):
  agent_agencies — 125,000 rows, as the "agent_agencies" array on agents (its agent_id is the parent's _id)
  property_neighbourhoods — 125,000 rows, as the "property_neighbourhoods" array on properties (its property_id is the parent's _id)

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.
