Fleet management sample database — MongoDB, flat (192,735 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 fleet-management --collection <name> --file <name>.ndjson

Collections:
  accident_vehicles — 50 documents
  accidents — 40 documents
  branches — 8 documents
  departments — 24 documents
  device_assignments — 300 documents
  driver_shifts — 5,000 documents
  drivers — 250 documents
  employees — 400 documents
  fuel_cards — 300 documents
  fuel_transactions — 3,000 documents
  gps_logs — 50,000 documents
  inspection_items — 12 documents
  inspection_results — 4,000 documents
  inspections — 500 documents
  insurance_claims — 30 documents
  insurance_policies — 300 documents
  maintenance_schedules — 300 documents
  maintenance_shops — 15 documents
  maintenance_tasks — 15 documents
  manufacturers — 8 documents
  models — 20 documents
  organizations — 1 documents
  parts — 150 documents
  parts_inventory — 450 documents
  roles — 6 documents
  routes — 120 documents
  telemetry_devices — 300 documents
  trip_stops — 100,000 documents
  trips — 25,000 documents
  vehicle_types — 6 documents
  vehicles — 300 documents
  vendors — 30 documents
  work_order_parts — 900 documents
  work_order_tasks — 600 documents
  work_orders — 300 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.
