Forensic JSON Export

Complete production data export with all fields, relationships, and integrity analysis. Test/sample data excluded and listed separately.

Entity JSON Exports (Production Data Only)

Excluded Test/Sample Data (6 records)

Bike (6 excluded)

69b0a77bb66fe235e1f36285 — ID 69b0a77bb66fe235e1f36285 in test data range (seeded 2026-03-10)

69b0a77bb66fe235e1f36293 — ID 69b0a77bb66fe235e1f36293 in test data range (seeded 2026-03-10)

69b0a77bb66fe235e1f3628a — ID 69b0a77bb66fe235e1f3628a in test data range (seeded 2026-03-10)

69b0a77bb66fe235e1f3628e — ID 69b0a77bb66fe235e1f3628e in test data range (seeded 2026-03-10)

69b0a77bb66fe235e1f36280 — ID 69b0a77bb66fe235e1f36280 in test data range (seeded 2026-03-10)

69b0a77bb66fe235e1f3627f — ID 69b0a77bb66fe235e1f3627f in test data range (seeded 2026-03-10)

Verification Counts

Entity	Production	Excluded (Test)	Total
Camp	0	0	0
Renter	0	0	0
Payment	0	0	0
ReservationRequest	0	0	0
Rental	0	0	0
RentalLineItem	0	0	0
Bike	341	6	347
CatalogOption	3	0	3
InspectionTemplate	0	0	0
Inspection	0	0	0
ServiceTicket	0	0	0
AuditLog	0	0	0
ScanHistory	0	0	0

Locations: No separate Location entity exists. Locations are an enum field (current_location) on the Bike entity. Unique values extracted and available for download above.

Lookup tables: CatalogOption (bike catalog) and InspectionTemplate (inspection checklists) are included in entity exports above.

Payment entity: Contains 0 production records.

Data Integrity Report

Duplicate Emails

Duplicate Phone Numbers

Duplicate Wix Order IDs

Duplicate Stripe Session IDs

Duplicate Bike Assignments

Reservations Without Payments

Payments Without Reservations

Reservations Without Camp

Reservations Without Bike Selections

Reservations Missing Phone

Reservations Missing Email

Orphaned Foreign Keys

Operational Master Table (0 customers)

Customer Name	Email	Phone	Billing Address	Camp	Hub	Bike 1	Bike 2	Bike 3	Bike 4	Total	E-Bikes	Pedal	Std Frame	Step-Thru	Transport	Deposit	Pmt Amt	Fee	Wix Order	Pmt Status	Res Status	Rental Status	Source	Confidence	Notes

Read-only forensic export. No production data was modified. All JSON files contain complete, unmodified records with all fields including null values. Camp is only populated when explicitly known — logistics hubs are kept separate and not used to infer camp assignments.