Insurance sample database — MongoDB, embedded (3,150 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 insurance --collection <name> --file <name>.ndjson

Collections:
  addresses — 65 documents
  adjusters — 60 documents
  agencies — 12 documents
  agents — 300 documents
  beneficiaries — 20 documents
  branches — 40 documents
  claims — 20 documents, each with its claim_assessments, its claim_documents, its claim_payments
  commissions — 80 documents
  companies — 6 documents
  customers — 60 documents, each with its customer_support_tickets
  documents — 40 documents
  invoices — 1,000 documents
  medical_providers — 80 documents
  medical_treatments — 10 documents
  payments — 920 documents
  policies — 80 documents, each with its policy_riders
  policy_categories — 5 documents
  policy_plans — 25 documents
  properties — 20 documents
  reinsurance_claims — 10 documents
  reinsurance_companies — 5 documents
  reinsurance_contracts — 12 documents
  renewals — 30 documents
  underwriters — 40 documents
  underwriting_assessments — 80 documents
  vehicles — 30 documents

Folded in (no collection of their own):
  claim_assessments — 20 rows, as the "claim_assessments" array on claims (its claim_id is the parent's _id)
  claim_documents — 30 rows, as the "claim_documents" array on claims (its claim_id is the parent's _id)
  claim_payments — 10 rows, as the "claim_payments" array on claims (its claim_id is the parent's _id)
  customer_support_tickets — 10 rows, as the "customer_support_tickets" array on customers (its customer_id is the parent's _id)
  policy_riders — 30 rows, as the "policy_riders" array on policies (its policy_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.
