Skip to content
Choose your marketSelected market: United States

Deloitte Virtual Internship / Task 02

An original Ape Intern practical · Task 02

Fulfilment review and interactive dashboard

Identify priority orders and hubs using a valid historical window, and deliver a readable decision report.

Start with the completed outputs, then use the materials to deliver your own work.

Read complete output first

Materials

learner/materials/orders.csv Read the full fileDownload file
order_idhubserviceroutecreated_atdue_at
O0001HarbourstandardR112026-09-01T06:00:00Z2026-09-02T06:00:00Z
O0002HarbourstandardR122026-09-02T07:00:00Z2026-09-03T07:00:00Z
O0003HarbourstandardR112026-09-03T08:00:00Z2026-09-04T08:00:00Z
O0004HarbourstandardR122026-09-04T09:00:00Z2026-09-05T09:00:00Z
O0005HarbourstandardR112026-09-05T10:00:00Z2026-09-06T10:00:00Z
O0006HarbourstandardR122026-09-06T11:00:00Z2026-09-07T11:00:00Z
O0007HarbourstandardR112026-09-07T12:00:00Z2026-09-08T12:00:00Z
O0008HarbourstandardR122026-09-08T13:00:00Z2026-09-09T13:00:00Z
O0009HarbourstandardR112026-09-09T06:00:00Z2026-09-10T06:00:00Z
O0010HarbourstandardR122026-09-10T07:00:00Z2026-09-11T07:00:00Z
O0011HarbourstandardR112026-09-11T08:00:00Z2026-09-12T08:00:00Z
O0012HarbourstandardR122026-09-12T09:00:00Z2026-09-13T09:00:00Z
O0013HarbourstandardR112026-09-13T10:00:00Z2026-09-14T10:00:00Z
O0014HarbourstandardR122026-09-01T11:00:00Z2026-09-02T11:00:00Z
O0015HarbourstandardR112026-09-02T12:00:00Z2026-09-03T12:00:00Z
O0016HarbourstandardR122026-09-03T13:00:00Z2026-09-04T13:00:00Z
O0017HarbourstandardR112026-09-04T06:00:00Z2026-09-05T06:00:00Z
O0018HarbourstandardR122026-09-05T07:00:00Z2026-09-06T07:00:00Z
O0019HarbourstandardR112026-09-06T08:00:00Z2026-09-07T08:00:00Z
O0020HarbourstandardR122026-09-07T09:00:00Z2026-09-08T09:00:00Z
O0021HarbourstandardR112026-09-08T10:00:00Z2026-09-09T10:00:00Z
O0022HarbourstandardR122026-09-09T11:00:00Z2026-09-10T11:00:00Z
O0023HarbourstandardR112026-09-10T12:00:00Z2026-09-11T12:00:00Z
O0024HarbourstandardR122026-09-11T13:00:00Z2026-09-12T13:00:00Z
O0025HarbourstandardR112026-09-12T06:00:00Z2026-09-13T06:00:00Z
O0026HarbourstandardR122026-09-13T07:00:00Z2026-09-14T07:00:00Z
O0027HarbourstandardR112026-09-01T08:00:00Z2026-09-02T08:00:00Z
O0028HarbourstandardR122026-09-02T09:00:00Z2026-09-03T09:00:00Z
O0029HarbourstandardR112026-09-03T10:00:00Z2026-09-04T10:00:00Z
O0030HarbourstandardR122026-09-04T11:00:00Z2026-09-05T11:00:00Z
O0031HarbourstandardR112026-09-05T12:00:00Z2026-09-06T12:00:00Z
O0032HarbourstandardR122026-09-06T13:00:00Z2026-09-07T13:00:00Z
O0033HarbourstandardR112026-09-07T06:00:00Z2026-09-08T06:00:00Z
O0034HarbourstandardR122026-09-08T07:00:00Z2026-09-09T07:00:00Z
O0035HarbourstandardR112026-09-09T08:00:00Z2026-09-10T08:00:00Z
O0036HarbourstandardR122026-09-10T09:00:00Z2026-09-11T09:00:00Z
O0037HarbourstandardR112026-09-11T10:00:00Z2026-09-12T10:00:00Z
O0038HarbourstandardR122026-09-12T11:00:00Z2026-09-13T11:00:00Z
O0039HarbourstandardR112026-09-13T12:00:00Z2026-09-14T12:00:00Z
O0040HarbourstandardR122026-09-14T21:00:00Z2026-09-15T21:00:00Z
O0041HarbourexpressR112026-09-01T06:00:00Z2026-09-01T14:00:00Z
O0042HarbourexpressR122026-09-02T07:00:00Z2026-09-02T15:00:00Z
O0043HarbourexpressR112026-09-03T08:00:00Z2026-09-03T16:00:00Z
O0044HarbourexpressR122026-09-04T09:00:00Z2026-09-04T17:00:00Z
O0045HarbourexpressR112026-09-05T10:00:00Z2026-09-05T18:00:00Z
O0046HarbourexpressR122026-09-06T11:00:00Z2026-09-06T19:00:00Z
O0047HarbourexpressR112026-09-07T12:00:00Z2026-09-07T20:00:00Z
O0048HarbourexpressR122026-09-08T13:00:00Z2026-09-08T21:00:00Z
O0049HarbourexpressR112026-09-09T06:00:00Z2026-09-09T14:00:00Z
O0050HarbourexpressR122026-09-10T07:00:00Z2026-09-10T15:00:00Z
O0051HarbourexpressR112026-09-11T08:00:00Z2026-09-11T16:00:00Z
O0052HarbourexpressR122026-09-12T09:00:00Z2026-09-12T17:00:00Z
O0053HarbourexpressR112026-09-13T10:00:00Z2026-09-13T18:00:00Z
O0054HarbourexpressR122026-09-01T11:00:00Z2026-09-01T19:00:00Z
O0055HarbourexpressR112026-09-02T12:00:00Z2026-09-02T20:00:00Z
O0056HarbourexpressR122026-09-03T13:00:00Z2026-09-03T21:00:00Z
O0057HarbourexpressR112026-09-04T06:00:00Z2026-09-04T14:00:00Z
O0058HarbourexpressR122026-09-05T07:00:00Z2026-09-05T15:00:00Z
O0059HarbourexpressR112026-09-06T08:00:00Z2026-09-06T16:00:00Z
O0060HarbourexpressR122026-09-14T21:00:00Z2026-09-15T05:00:00Z
O0061EastgatestandardR212026-09-01T06:00:00Z2026-09-02T06:00:00Z
O0062EastgatestandardR222026-09-02T07:00:00Z2026-09-03T07:00:00Z
O0063EastgatestandardR212026-09-03T08:00:00Z2026-09-04T08:00:00Z
O0064EastgatestandardR222026-09-04T09:00:00Z2026-09-05T09:00:00Z
O0065EastgatestandardR212026-09-05T10:00:00Z2026-09-06T10:00:00Z
O0066EastgatestandardR222026-09-06T11:00:00Z2026-09-07T11:00:00Z
O0067EastgatestandardR212026-09-07T12:00:00Z2026-09-08T12:00:00Z
O0068EastgatestandardR222026-09-08T13:00:00Z2026-09-09T13:00:00Z
O0069EastgatestandardR212026-09-09T06:00:00Z2026-09-10T06:00:00Z
O0070EastgatestandardR222026-09-10T07:00:00Z2026-09-11T07:00:00Z
O0071EastgatestandardR212026-09-11T08:00:00Z2026-09-12T08:00:00Z
O0072EastgatestandardR222026-09-12T09:00:00Z2026-09-13T09:00:00Z
O0073EastgatestandardR212026-09-13T10:00:00Z2026-09-14T10:00:00Z
O0074EastgatestandardR222026-09-01T11:00:00Z2026-09-02T11:00:00Z
O0075EastgatestandardR212026-09-02T12:00:00Z2026-09-03T12:00:00Z
O0076EastgatestandardR222026-09-03T13:00:00Z2026-09-04T13:00:00Z
O0077EastgatestandardR212026-09-04T06:00:00Z2026-09-05T06:00:00Z
O0078EastgatestandardR222026-09-05T07:00:00Z2026-09-06T07:00:00Z
O0079EastgatestandardR212026-09-06T08:00:00Z2026-09-07T08:00:00Z
O0080EastgatestandardR222026-09-14T21:00:00Z2026-09-15T21:00:00Z
O0081EastgateexpressR212026-09-01T06:00:00Z2026-09-01T14:00:00Z
O0082EastgateexpressR222026-09-02T07:00:00Z2026-09-02T15:00:00Z
O0083EastgateexpressR212026-09-03T08:00:00Z2026-09-03T16:00:00Z
O0084EastgateexpressR222026-09-04T09:00:00Z2026-09-04T17:00:00Z
O0085EastgateexpressR212026-09-05T10:00:00Z2026-09-05T18:00:00Z
O0086EastgateexpressR222026-09-06T11:00:00Z2026-09-06T19:00:00Z
O0087EastgateexpressR212026-09-07T12:00:00Z2026-09-07T20:00:00Z
O0088EastgateexpressR222026-09-08T13:00:00Z2026-09-08T21:00:00Z
O0089EastgateexpressR212026-09-09T06:00:00Z2026-09-09T14:00:00Z
O0090EastgateexpressR222026-09-10T07:00:00Z2026-09-10T15:00:00Z
O0091EastgateexpressR212026-09-11T08:00:00Z2026-09-11T16:00:00Z
O0092EastgateexpressR222026-09-12T09:00:00Z2026-09-12T17:00:00Z
O0093EastgateexpressR212026-09-13T10:00:00Z2026-09-13T18:00:00Z
O0094EastgateexpressR222026-09-01T11:00:00Z2026-09-01T19:00:00Z
O0095EastgateexpressR212026-09-02T12:00:00Z2026-09-02T20:00:00Z
O0096EastgateexpressR222026-09-03T13:00:00Z2026-09-03T21:00:00Z
O0097EastgateexpressR212026-09-04T06:00:00Z2026-09-04T14:00:00Z
O0098EastgateexpressR222026-09-05T07:00:00Z2026-09-05T15:00:00Z
O0099EastgateexpressR212026-09-06T08:00:00Z2026-09-06T16:00:00Z
O0100EastgateexpressR222026-09-07T09:00:00Z2026-09-07T17:00:00Z
O0101EastgateexpressR212026-09-08T10:00:00Z2026-09-08T18:00:00Z
O0102EastgateexpressR222026-09-09T11:00:00Z2026-09-09T19:00:00Z
O0103EastgateexpressR212026-09-10T12:00:00Z2026-09-10T20:00:00Z
O0104EastgateexpressR222026-09-11T13:00:00Z2026-09-11T21:00:00Z
O0105EastgateexpressR212026-09-12T06:00:00Z2026-09-12T14:00:00Z
O0106EastgateexpressR222026-09-13T07:00:00Z2026-09-13T15:00:00Z
O0107EastgateexpressR212026-09-01T08:00:00Z2026-09-01T16:00:00Z
O0108EastgateexpressR222026-09-02T09:00:00Z2026-09-02T17:00:00Z
O0109EastgateexpressR212026-09-03T10:00:00Z2026-09-03T18:00:00Z
O0110EastgateexpressR222026-09-04T11:00:00Z2026-09-04T19:00:00Z
O0111EastgateexpressR212026-09-05T12:00:00Z2026-09-05T20:00:00Z
O0112EastgateexpressR222026-09-06T13:00:00Z2026-09-06T21:00:00Z
O0113EastgateexpressR212026-09-07T06:00:00Z2026-09-07T14:00:00Z
O0114EastgateexpressR222026-09-08T07:00:00Z2026-09-08T15:00:00Z
O0115EastgateexpressR212026-09-09T08:00:00Z2026-09-09T16:00:00Z
O0116EastgateexpressR222026-09-10T09:00:00Z2026-09-10T17:00:00Z
O0117EastgateexpressR212026-09-11T10:00:00Z2026-09-11T18:00:00Z
O0118EastgateexpressR222026-09-12T11:00:00Z2026-09-12T19:00:00Z
O0119EastgateexpressR212026-09-13T12:00:00Z2026-09-13T20:00:00Z
O0120EastgateexpressR222026-09-14T21:00:00Z2026-09-15T05:00:00Z
O0121WesthillstandardR312026-09-01T06:00:00Z2026-09-02T06:00:00Z
O0122WesthillstandardR322026-09-02T07:00:00Z2026-09-03T07:00:00Z
O0123WesthillstandardR312026-09-03T08:00:00Z2026-09-04T08:00:00Z
O0124WesthillstandardR322026-09-04T09:00:00Z2026-09-05T09:00:00Z
O0125WesthillstandardR312026-09-05T10:00:00Z2026-09-06T10:00:00Z
O0126WesthillstandardR322026-09-06T11:00:00Z2026-09-07T11:00:00Z
O0127WesthillstandardR312026-09-07T12:00:00Z2026-09-08T12:00:00Z
O0128WesthillstandardR322026-09-08T13:00:00Z2026-09-09T13:00:00Z
O0129WesthillstandardR312026-09-09T06:00:00Z2026-09-10T06:00:00Z
O0130WesthillstandardR322026-09-10T07:00:00Z2026-09-11T07:00:00Z
O0131WesthillstandardR312026-09-11T08:00:00Z2026-09-12T08:00:00Z
O0132WesthillstandardR322026-09-12T09:00:00Z2026-09-13T09:00:00Z
O0133WesthillstandardR312026-09-13T10:00:00Z2026-09-14T10:00:00Z
O0134WesthillstandardR322026-09-01T11:00:00Z2026-09-02T11:00:00Z
O0135WesthillstandardR312026-09-02T12:00:00Z2026-09-03T12:00:00Z
O0136WesthillstandardR322026-09-03T13:00:00Z2026-09-04T13:00:00Z
O0137WesthillstandardR312026-09-04T06:00:00Z2026-09-05T06:00:00Z
O0138WesthillstandardR322026-09-05T07:00:00Z2026-09-06T07:00:00Z
O0139WesthillstandardR312026-09-06T08:00:00Z2026-09-07T08:00:00Z
O0140WesthillstandardR322026-09-07T09:00:00Z2026-09-08T09:00:00Z
O0141WesthillstandardR312026-09-08T10:00:00Z2026-09-09T10:00:00Z
O0142WesthillstandardR322026-09-09T11:00:00Z2026-09-10T11:00:00Z
O0143WesthillstandardR312026-09-10T12:00:00Z2026-09-11T12:00:00Z
O0144WesthillstandardR322026-09-11T13:00:00Z2026-09-12T13:00:00Z
O0145WesthillstandardR312026-09-12T06:00:00Z2026-09-13T06:00:00Z
O0146WesthillstandardR322026-09-13T07:00:00Z2026-09-14T07:00:00Z
O0147WesthillstandardR312026-09-01T08:00:00Z2026-09-02T08:00:00Z
O0148WesthillstandardR322026-09-02T09:00:00Z2026-09-03T09:00:00Z
O0149WesthillstandardR312026-09-03T10:00:00Z2026-09-04T10:00:00Z
O0150WesthillstandardR322026-09-04T11:00:00Z2026-09-05T11:00:00Z
O0151WesthillstandardR312026-09-05T12:00:00Z2026-09-06T12:00:00Z
O0152WesthillstandardR322026-09-06T13:00:00Z2026-09-07T13:00:00Z
O0153WesthillstandardR312026-09-07T06:00:00Z2026-09-08T06:00:00Z
O0154WesthillstandardR322026-09-08T07:00:00Z2026-09-09T07:00:00Z
O0155WesthillstandardR312026-09-09T08:00:00Z2026-09-10T08:00:00Z
O0156WesthillstandardR322026-09-14T21:00:00Z2026-09-15T21:00:00Z
O0157WesthillexpressR312026-09-01T06:00:00Z2026-09-01T14:00:00Z
O0158WesthillexpressR322026-09-02T07:00:00Z2026-09-02T15:00:00Z
O0159WesthillexpressR312026-09-03T08:00:00Z2026-09-03T16:00:00Z
O0160WesthillexpressR322026-09-04T09:00:00Z2026-09-04T17:00:00Z
O0161WesthillexpressR312026-09-05T10:00:00Z2026-09-05T18:00:00Z
O0162WesthillexpressR322026-09-06T11:00:00Z2026-09-06T19:00:00Z
O0163WesthillexpressR312026-09-07T12:00:00Z2026-09-07T20:00:00Z
O0164WesthillexpressR322026-09-08T13:00:00Z2026-09-08T21:00:00Z
O0165WesthillexpressR312026-09-09T06:00:00Z2026-09-09T14:00:00Z
O0166WesthillexpressR322026-09-10T07:00:00Z2026-09-10T15:00:00Z
O0167WesthillexpressR312026-09-11T08:00:00Z2026-09-11T16:00:00Z
O0168WesthillexpressR322026-09-12T09:00:00Z2026-09-12T17:00:00Z
O0169WesthillexpressR312026-09-13T10:00:00Z2026-09-13T18:00:00Z
O0170WesthillexpressR322026-09-01T11:00:00Z2026-09-01T19:00:00Z
O0171WesthillexpressR312026-09-02T12:00:00Z2026-09-02T20:00:00Z
O0172WesthillexpressR322026-09-03T13:00:00Z2026-09-03T21:00:00Z
O0173WesthillexpressR312026-09-04T06:00:00Z2026-09-04T14:00:00Z
O0174WesthillexpressR322026-09-05T07:00:00Z2026-09-05T15:00:00Z
O0175WesthillexpressR312026-09-06T08:00:00Z2026-09-06T16:00:00Z
O0176WesthillexpressR322026-09-07T09:00:00Z2026-09-07T17:00:00Z
O0177WesthillexpressR312026-09-08T10:00:00Z2026-09-08T18:00:00Z
O0178WesthillexpressR322026-09-09T11:00:00Z2026-09-09T19:00:00Z
O0179WesthillexpressR312026-09-10T12:00:00Z2026-09-10T20:00:00Z
O0180WesthillexpressR322026-09-14T21:00:00Z2026-09-15T05:00:00Z
O0181SouthbaystandardR412026-09-01T06:00:00Z2026-09-02T06:00:00Z
O0182SouthbaystandardR422026-09-02T07:00:00Z2026-09-03T07:00:00Z
O0183SouthbaystandardR412026-09-03T08:00:00Z2026-09-04T08:00:00Z
O0184SouthbaystandardR422026-09-04T09:00:00Z2026-09-05T09:00:00Z
O0185SouthbaystandardR412026-09-05T10:00:00Z2026-09-06T10:00:00Z
O0186SouthbaystandardR422026-09-06T11:00:00Z2026-09-07T11:00:00Z
O0187SouthbaystandardR412026-09-07T12:00:00Z2026-09-08T12:00:00Z
O0188SouthbaystandardR422026-09-08T13:00:00Z2026-09-09T13:00:00Z
O0189SouthbaystandardR412026-09-09T06:00:00Z2026-09-10T06:00:00Z
O0190SouthbaystandardR422026-09-10T07:00:00Z2026-09-11T07:00:00Z
O0191SouthbaystandardR412026-09-11T08:00:00Z2026-09-12T08:00:00Z
O0192SouthbaystandardR422026-09-12T09:00:00Z2026-09-13T09:00:00Z
O0193SouthbaystandardR412026-09-13T10:00:00Z2026-09-14T10:00:00Z
O0194SouthbaystandardR422026-09-01T11:00:00Z2026-09-02T11:00:00Z
O0195SouthbaystandardR412026-09-02T12:00:00Z2026-09-03T12:00:00Z
O0196SouthbaystandardR422026-09-03T13:00:00Z2026-09-04T13:00:00Z
O0197SouthbaystandardR412026-09-04T06:00:00Z2026-09-05T06:00:00Z
O0198SouthbaystandardR422026-09-05T07:00:00Z2026-09-06T07:00:00Z
O0199SouthbaystandardR412026-09-06T08:00:00Z2026-09-07T08:00:00Z
O0200SouthbaystandardR422026-09-07T09:00:00Z2026-09-08T09:00:00Z
O0201SouthbaystandardR412026-09-08T10:00:00Z2026-09-09T10:00:00Z
O0202SouthbaystandardR422026-09-09T11:00:00Z2026-09-10T11:00:00Z
O0203SouthbaystandardR412026-09-10T12:00:00Z2026-09-11T12:00:00Z
O0204SouthbaystandardR422026-09-11T13:00:00Z2026-09-12T13:00:00Z
O0205SouthbaystandardR412026-09-12T06:00:00Z2026-09-13T06:00:00Z
O0206SouthbaystandardR422026-09-13T07:00:00Z2026-09-14T07:00:00Z
O0207SouthbaystandardR412026-09-01T08:00:00Z2026-09-02T08:00:00Z
O0208SouthbaystandardR422026-09-02T09:00:00Z2026-09-03T09:00:00Z
O0209SouthbaystandardR412026-09-03T10:00:00Z2026-09-04T10:00:00Z
O0210SouthbaystandardR422026-09-14T21:00:00Z2026-09-15T21:00:00Z
O0211SouthbayexpressR412026-09-01T06:00:00Z2026-09-01T14:00:00Z
O0212SouthbayexpressR422026-09-02T07:00:00Z2026-09-02T15:00:00Z
O0213SouthbayexpressR412026-09-03T08:00:00Z2026-09-03T16:00:00Z
O0214SouthbayexpressR422026-09-04T09:00:00Z2026-09-04T17:00:00Z
O0215SouthbayexpressR412026-09-05T10:00:00Z2026-09-05T18:00:00Z
O0216SouthbayexpressR422026-09-14T21:00:00Z2026-09-15T05:00:00Z
learner/materials/rules.json Read the full fileDownload file
{
  "cutoff": "2026-09-15T00:00:00Z",
  "late_target": 0.1,
  "min_sample": 15,
  "review_gap_pp": 5,
  "priority_gap_pp": 15,
  "standard_weight": 0.5,
  "express_weight": 0.5
}
learner/materials/route-notes.csv Read the full fileDownload file
routenoteevidence
R11Peak dispatch queueing; check handover scan timestamps.Investigation lead for the operations review
R12Peak dispatch queueing; check handover scan timestamps.Investigation lead for the operations review
R21Some addresses need confirmation; check support tickets.Investigation lead for the operations review
R22Some addresses need confirmation; check support tickets.Investigation lead for the operations review
R31Some addresses need confirmation; check support tickets.Investigation lead for the operations review
R32Some addresses need confirmation; check support tickets.Investigation lead for the operations review
R41Some addresses need confirmation; check support tickets.Investigation lead for the operations review
R42Some addresses need confirmation; check support tickets.Investigation lead for the operations review
learner/checkpoints/canonical-events.jsonl Read the full fileDownload file
{"event_id": "O0001-created", "order_id": "O0001", "hub": "Harbour", "service": "standard", "kind": "created", "happened_at": "2026-09-01T06:00:00Z"}
{"event_id": "O0041-created", "order_id": "O0041", "hub": "Harbour", "service": "express", "kind": "created", "happened_at": "2026-09-01T06:00:00Z"}
{"event_id": "O0061-created", "order_id": "O0061", "hub": "Eastgate", "service": "standard", "kind": "created", "happened_at": "2026-09-01T06:00:00Z"}
{"event_id": "O0081-created", "order_id": "O0081", "hub": "Eastgate", "service": "express", "kind": "created", "happened_at": "2026-09-01T06:00:00Z"}
{"event_id": "O0121-created", "order_id": "O0121", "hub": "Westhill", "service": "standard", "kind": "created", "happened_at": "2026-09-01T06:00:00Z"}
{"event_id": "O0157-created", "order_id": "O0157", "hub": "Westhill", "service": "express", "kind": "created", "happened_at": "2026-09-01T06:00:00Z"}
{"event_id": "O0181-created", "order_id": "O0181", "hub": "Southbay", "service": "standard", "kind": "created", "happened_at": "2026-09-01T06:00:00Z"}
{"event_id": "O0211-created", "order_id": "O0211", "hub": "Southbay", "service": "express", "kind": "created", "happened_at": "2026-09-01T06:00:00Z"}
{"event_id": "O0001-cancelled", "order_id": "O0001", "hub": "Harbour", "service": "standard", "kind": "cancelled", "happened_at": "2026-09-01T07:00:00Z"}
{"event_id": "O0041-cancelled", "order_id": "O0041", "hub": "Harbour", "service": "express", "kind": "cancelled", "happened_at": "2026-09-01T07:00:00Z"}
{"event_id": "O0061-cancelled", "order_id": "O0061", "hub": "Eastgate", "service": "standard", "kind": "cancelled", "happened_at": "2026-09-01T07:00:00Z"}
{"event_id": "O0081-cancelled", "order_id": "O0081", "hub": "Eastgate", "service": "express", "kind": "cancelled", "happened_at": "2026-09-01T07:00:00Z"}
{"event_id": "O0121-cancelled", "order_id": "O0121", "hub": "Westhill", "service": "standard", "kind": "cancelled", "happened_at": "2026-09-01T07:00:00Z"}
{"event_id": "O0157-cancelled", "order_id": "O0157", "hub": "Westhill", "service": "express", "kind": "cancelled", "happened_at": "2026-09-01T07:00:00Z"}
{"event_id": "O0181-cancelled", "order_id": "O0181", "hub": "Southbay", "service": "standard", "kind": "cancelled", "happened_at": "2026-09-01T07:00:00Z"}
{"event_id": "O0211-cancelled", "order_id": "O0211", "hub": "Southbay", "service": "express", "kind": "cancelled", "happened_at": "2026-09-01T07:00:00Z"}
{"event_id": "O0027-created", "order_id": "O0027", "hub": "Harbour", "service": "standard", "kind": "created", "happened_at": "2026-09-01T08:00:00Z"}
{"event_id": "O0107-created", "order_id": "O0107", "hub": "Eastgate", "service": "express", "kind": "created", "happened_at": "2026-09-01T08:00:00Z"}
{"event_id": "O0147-created", "order_id": "O0147", "hub": "Westhill", "service": "standard", "kind": "created", "happened_at": "2026-09-01T08:00:00Z"}
{"event_id": "O0207-created", "order_id": "O0207", "hub": "Southbay", "service": "standard", "kind": "created", "happened_at": "2026-09-01T08:00:00Z"}
{"event_id": "O0027-picked_up", "order_id": "O0027", "hub": "Harbour", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-01T10:00:00Z"}
{"event_id": "O0107-picked_up", "order_id": "O0107", "hub": "Eastgate", "service": "express", "kind": "picked_up", "happened_at": "2026-09-01T10:00:00Z"}
{"event_id": "O0147-picked_up", "order_id": "O0147", "hub": "Westhill", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-01T10:00:00Z"}
{"event_id": "O0207-picked_up", "order_id": "O0207", "hub": "Southbay", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-01T10:00:00Z"}
{"event_id": "O0014-created", "order_id": "O0014", "hub": "Harbour", "service": "standard", "kind": "created", "happened_at": "2026-09-01T11:00:00Z"}
{"event_id": "O0054-created", "order_id": "O0054", "hub": "Harbour", "service": "express", "kind": "created", "happened_at": "2026-09-01T11:00:00Z"}
{"event_id": "O0074-created", "order_id": "O0074", "hub": "Eastgate", "service": "standard", "kind": "created", "happened_at": "2026-09-01T11:00:00Z"}
{"event_id": "O0094-created", "order_id": "O0094", "hub": "Eastgate", "service": "express", "kind": "created", "happened_at": "2026-09-01T11:00:00Z"}
{"event_id": "O0134-created", "order_id": "O0134", "hub": "Westhill", "service": "standard", "kind": "created", "happened_at": "2026-09-01T11:00:00Z"}
{"event_id": "O0170-created", "order_id": "O0170", "hub": "Westhill", "service": "express", "kind": "created", "happened_at": "2026-09-01T11:00:00Z"}
{"event_id": "O0194-created", "order_id": "O0194", "hub": "Southbay", "service": "standard", "kind": "created", "happened_at": "2026-09-01T11:00:00Z"}
{"event_id": "O0014-picked_up", "order_id": "O0014", "hub": "Harbour", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-01T13:00:00Z"}
{"event_id": "O0054-picked_up", "order_id": "O0054", "hub": "Harbour", "service": "express", "kind": "picked_up", "happened_at": "2026-09-01T13:00:00Z"}
{"event_id": "O0074-picked_up", "order_id": "O0074", "hub": "Eastgate", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-01T13:00:00Z"}
{"event_id": "O0094-picked_up", "order_id": "O0094", "hub": "Eastgate", "service": "express", "kind": "picked_up", "happened_at": "2026-09-01T13:00:00Z"}
{"event_id": "O0134-picked_up", "order_id": "O0134", "hub": "Westhill", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-01T13:00:00Z"}
{"event_id": "O0170-picked_up", "order_id": "O0170", "hub": "Westhill", "service": "express", "kind": "picked_up", "happened_at": "2026-09-01T13:00:00Z"}
{"event_id": "O0194-picked_up", "order_id": "O0194", "hub": "Southbay", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-01T13:00:00Z"}
{"event_id": "O0107-delivered", "order_id": "O0107", "hub": "Eastgate", "service": "express", "kind": "delivered", "happened_at": "2026-09-01T14:30:00Z"}
{"event_id": "O0054-delivered", "order_id": "O0054", "hub": "Harbour", "service": "express", "kind": "delivered", "happened_at": "2026-09-01T19:50:00Z"}
{"event_id": "O0094-delivered", "order_id": "O0094", "hub": "Eastgate", "service": "express", "kind": "delivered", "happened_at": "2026-09-01T20:10:00Z"}
{"event_id": "O0170-delivered", "order_id": "O0170", "hub": "Westhill", "service": "express", "kind": "delivered", "happened_at": "2026-09-01T20:30:00Z"}
{"event_id": "O0027-delivered", "order_id": "O0027", "hub": "Harbour", "service": "standard", "kind": "delivered", "happened_at": "2026-09-02T06:30:00Z"}
{"event_id": "O0207-delivered", "order_id": "O0207", "hub": "Southbay", "service": "standard", "kind": "delivered", "happened_at": "2026-09-02T06:30:00Z"}
{"event_id": "O0002-created", "order_id": "O0002", "hub": "Harbour", "service": "standard", "kind": "created", "happened_at": "2026-09-02T07:00:00Z"}
{"event_id": "O0042-created", "order_id": "O0042", "hub": "Harbour", "service": "express", "kind": "created", "happened_at": "2026-09-02T07:00:00Z"}
{"event_id": "O0062-created", "order_id": "O0062", "hub": "Eastgate", "service": "standard", "kind": "created", "happened_at": "2026-09-02T07:00:00Z"}
{"event_id": "O0082-created", "order_id": "O0082", "hub": "Eastgate", "service": "express", "kind": "created", "happened_at": "2026-09-02T07:00:00Z"}
{"event_id": "O0122-created", "order_id": "O0122", "hub": "Westhill", "service": "standard", "kind": "created", "happened_at": "2026-09-02T07:00:00Z"}
{"event_id": "O0158-created", "order_id": "O0158", "hub": "Westhill", "service": "express", "kind": "created", "happened_at": "2026-09-02T07:00:00Z"}
{"event_id": "O0182-created", "order_id": "O0182", "hub": "Southbay", "service": "standard", "kind": "created", "happened_at": "2026-09-02T07:00:00Z"}
{"event_id": "O0212-created", "order_id": "O0212", "hub": "Southbay", "service": "express", "kind": "created", "happened_at": "2026-09-02T07:00:00Z"}
{"event_id": "O0002-picked_up", "order_id": "O0002", "hub": "Harbour", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-02T09:00:00Z"}
{"event_id": "O0028-created", "order_id": "O0028", "hub": "Harbour", "service": "standard", "kind": "created", "happened_at": "2026-09-02T09:00:00Z"}
{"event_id": "O0042-picked_up", "order_id": "O0042", "hub": "Harbour", "service": "express", "kind": "picked_up", "happened_at": "2026-09-02T09:00:00Z"}
{"event_id": "O0062-picked_up", "order_id": "O0062", "hub": "Eastgate", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-02T09:00:00Z"}
{"event_id": "O0082-picked_up", "order_id": "O0082", "hub": "Eastgate", "service": "express", "kind": "picked_up", "happened_at": "2026-09-02T09:00:00Z"}
{"event_id": "O0108-created", "order_id": "O0108", "hub": "Eastgate", "service": "express", "kind": "created", "happened_at": "2026-09-02T09:00:00Z"}
{"event_id": "O0122-picked_up", "order_id": "O0122", "hub": "Westhill", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-02T09:00:00Z"}
{"event_id": "O0148-created", "order_id": "O0148", "hub": "Westhill", "service": "standard", "kind": "created", "happened_at": "2026-09-02T09:00:00Z"}
{"event_id": "O0158-picked_up", "order_id": "O0158", "hub": "Westhill", "service": "express", "kind": "picked_up", "happened_at": "2026-09-02T09:00:00Z"}
{"event_id": "O0182-picked_up", "order_id": "O0182", "hub": "Southbay", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-02T09:00:00Z"}
{"event_id": "O0208-created", "order_id": "O0208", "hub": "Southbay", "service": "standard", "kind": "created", "happened_at": "2026-09-02T09:00:00Z"}
{"event_id": "O0212-picked_up", "order_id": "O0212", "hub": "Southbay", "service": "express", "kind": "picked_up", "happened_at": "2026-09-02T09:00:00Z"}
{"event_id": "O0134-delivered", "order_id": "O0134", "hub": "Westhill", "service": "standard", "kind": "delivered", "happened_at": "2026-09-02T09:30:00Z"}
{"event_id": "O0147-delivered", "order_id": "O0147", "hub": "Westhill", "service": "standard", "kind": "delivered", "happened_at": "2026-09-02T09:30:00Z"}
{"event_id": "O0028-picked_up", "order_id": "O0028", "hub": "Harbour", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-02T11:00:00Z"}
{"event_id": "O0108-picked_up", "order_id": "O0108", "hub": "Eastgate", "service": "express", "kind": "picked_up", "happened_at": "2026-09-02T11:00:00Z"}
{"event_id": "O0148-picked_up", "order_id": "O0148", "hub": "Westhill", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-02T11:00:00Z"}
{"event_id": "O0208-picked_up", "order_id": "O0208", "hub": "Southbay", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-02T11:00:00Z"}
{"event_id": "O0014-delivered", "order_id": "O0014", "hub": "Harbour", "service": "standard", "kind": "delivered", "happened_at": "2026-09-02T11:50:00Z"}
{"event_id": "O0015-created", "order_id": "O0015", "hub": "Harbour", "service": "standard", "kind": "created", "happened_at": "2026-09-02T12:00:00Z"}
{"event_id": "O0055-created", "order_id": "O0055", "hub": "Harbour", "service": "express", "kind": "created", "happened_at": "2026-09-02T12:00:00Z"}
{"event_id": "O0075-created", "order_id": "O0075", "hub": "Eastgate", "service": "standard", "kind": "created", "happened_at": "2026-09-02T12:00:00Z"}
{"event_id": "O0095-created", "order_id": "O0095", "hub": "Eastgate", "service": "express", "kind": "created", "happened_at": "2026-09-02T12:00:00Z"}
{"event_id": "O0135-created", "order_id": "O0135", "hub": "Westhill", "service": "standard", "kind": "created", "happened_at": "2026-09-02T12:00:00Z"}
{"event_id": "O0171-created", "order_id": "O0171", "hub": "Westhill", "service": "express", "kind": "created", "happened_at": "2026-09-02T12:00:00Z"}
{"event_id": "O0195-created", "order_id": "O0195", "hub": "Southbay", "service": "standard", "kind": "created", "happened_at": "2026-09-02T12:00:00Z"}
{"event_id": "O0074-delivered", "order_id": "O0074", "hub": "Eastgate", "service": "standard", "kind": "delivered", "happened_at": "2026-09-02T12:10:00Z"}
{"event_id": "O0194-delivered", "order_id": "O0194", "hub": "Southbay", "service": "standard", "kind": "delivered", "happened_at": "2026-09-02T12:50:00Z"}
{"event_id": "O0015-picked_up", "order_id": "O0015", "hub": "Harbour", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-02T14:00:00Z"}
{"event_id": "O0055-picked_up", "order_id": "O0055", "hub": "Harbour", "service": "express", "kind": "picked_up", "happened_at": "2026-09-02T14:00:00Z"}
{"event_id": "O0075-picked_up", "order_id": "O0075", "hub": "Eastgate", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-02T14:00:00Z"}
{"event_id": "O0095-picked_up", "order_id": "O0095", "hub": "Eastgate", "service": "express", "kind": "picked_up", "happened_at": "2026-09-02T14:00:00Z"}
{"event_id": "O0135-picked_up", "order_id": "O0135", "hub": "Westhill", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-02T14:00:00Z"}
{"event_id": "O0171-picked_up", "order_id": "O0171", "hub": "Westhill", "service": "express", "kind": "picked_up", "happened_at": "2026-09-02T14:00:00Z"}
{"event_id": "O0195-picked_up", "order_id": "O0195", "hub": "Southbay", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-02T14:00:00Z"}
{"event_id": "O0042-delivered", "order_id": "O0042", "hub": "Harbour", "service": "express", "kind": "delivered", "happened_at": "2026-09-02T15:50:00Z"}
{"event_id": "O0082-delivered", "order_id": "O0082", "hub": "Eastgate", "service": "express", "kind": "delivered", "happened_at": "2026-09-02T16:10:00Z"}
{"event_id": "O0158-delivered", "order_id": "O0158", "hub": "Westhill", "service": "express", "kind": "delivered", "happened_at": "2026-09-02T16:30:00Z"}
{"event_id": "O0212-delivered", "order_id": "O0212", "hub": "Southbay", "service": "express", "kind": "delivered", "happened_at": "2026-09-02T16:50:00Z"}
{"event_id": "O0108-delivered", "order_id": "O0108", "hub": "Eastgate", "service": "express", "kind": "delivered", "happened_at": "2026-09-02T18:10:00Z"}
{"event_id": "O0095-delivered", "order_id": "O0095", "hub": "Eastgate", "service": "express", "kind": "delivered", "happened_at": "2026-09-02T18:30:00Z"}
{"event_id": "O0171-delivered", "order_id": "O0171", "hub": "Westhill", "service": "express", "kind": "delivered", "happened_at": "2026-09-02T18:30:00Z"}
{"event_id": "O0055-delivered", "order_id": "O0055", "hub": "Harbour", "service": "express", "kind": "delivered", "happened_at": "2026-09-02T20:50:00Z"}
{"event_id": "O0028-delivered", "order_id": "O0028", "hub": "Harbour", "service": "standard", "kind": "delivered", "happened_at": "2026-09-03T07:30:00Z"}
{"event_id": "O0148-delivered", "order_id": "O0148", "hub": "Westhill", "service": "standard", "kind": "delivered", "happened_at": "2026-09-03T07:30:00Z"}
{"event_id": "O0208-delivered", "order_id": "O0208", "hub": "Southbay", "service": "standard", "kind": "delivered", "happened_at": "2026-09-03T07:30:00Z"}
{"event_id": "O0002-delivered", "order_id": "O0002", "hub": "Harbour", "service": "standard", "kind": "delivered", "happened_at": "2026-09-03T07:50:00Z"}
{"event_id": "O0003-created", "order_id": "O0003", "hub": "Harbour", "service": "standard", "kind": "created", "happened_at": "2026-09-03T08:00:00Z"}
{"event_id": "O0043-created", "order_id": "O0043", "hub": "Harbour", "service": "express", "kind": "created", "happened_at": "2026-09-03T08:00:00Z"}
{"event_id": "O0063-created", "order_id": "O0063", "hub": "Eastgate", "service": "standard", "kind": "created", "happened_at": "2026-09-03T08:00:00Z"}
{"event_id": "O0083-created", "order_id": "O0083", "hub": "Eastgate", "service": "express", "kind": "created", "happened_at": "2026-09-03T08:00:00Z"}
{"event_id": "O0123-created", "order_id": "O0123", "hub": "Westhill", "service": "standard", "kind": "created", "happened_at": "2026-09-03T08:00:00Z"}
{"event_id": "O0159-created", "order_id": "O0159", "hub": "Westhill", "service": "express", "kind": "created", "happened_at": "2026-09-03T08:00:00Z"}
{"event_id": "O0183-created", "order_id": "O0183", "hub": "Southbay", "service": "standard", "kind": "created", "happened_at": "2026-09-03T08:00:00Z"}
{"event_id": "O0213-created", "order_id": "O0213", "hub": "Southbay", "service": "express", "kind": "created", "happened_at": "2026-09-03T08:00:00Z"}
{"event_id": "O0062-delivered", "order_id": "O0062", "hub": "Eastgate", "service": "standard", "kind": "delivered", "happened_at": "2026-09-03T08:10:00Z"}
{"event_id": "O0122-delivered", "order_id": "O0122", "hub": "Westhill", "service": "standard", "kind": "delivered", "happened_at": "2026-09-03T08:30:00Z"}
{"event_id": "O0182-delivered", "order_id": "O0182", "hub": "Southbay", "service": "standard", "kind": "delivered", "happened_at": "2026-09-03T08:50:00Z"}
{"event_id": "O0003-picked_up", "order_id": "O0003", "hub": "Harbour", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-03T10:00:00Z"}
{"event_id": "O0029-created", "order_id": "O0029", "hub": "Harbour", "service": "standard", "kind": "created", "happened_at": "2026-09-03T10:00:00Z"}
{"event_id": "O0043-picked_up", "order_id": "O0043", "hub": "Harbour", "service": "express", "kind": "picked_up", "happened_at": "2026-09-03T10:00:00Z"}
{"event_id": "O0063-picked_up", "order_id": "O0063", "hub": "Eastgate", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-03T10:00:00Z"}
{"event_id": "O0083-picked_up", "order_id": "O0083", "hub": "Eastgate", "service": "express", "kind": "picked_up", "happened_at": "2026-09-03T10:00:00Z"}
{"event_id": "O0109-created", "order_id": "O0109", "hub": "Eastgate", "service": "express", "kind": "created", "happened_at": "2026-09-03T10:00:00Z"}
{"event_id": "O0123-picked_up", "order_id": "O0123", "hub": "Westhill", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-03T10:00:00Z"}
{"event_id": "O0149-created", "order_id": "O0149", "hub": "Westhill", "service": "standard", "kind": "created", "happened_at": "2026-09-03T10:00:00Z"}
{"event_id": "O0159-picked_up", "order_id": "O0159", "hub": "Westhill", "service": "express", "kind": "picked_up", "happened_at": "2026-09-03T10:00:00Z"}
{"event_id": "O0183-picked_up", "order_id": "O0183", "hub": "Southbay", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-03T10:00:00Z"}
{"event_id": "O0209-created", "order_id": "O0209", "hub": "Southbay", "service": "standard", "kind": "created", "happened_at": "2026-09-03T10:00:00Z"}
{"event_id": "O0213-picked_up", "order_id": "O0213", "hub": "Southbay", "service": "express", "kind": "picked_up", "happened_at": "2026-09-03T10:00:00Z"}
{"event_id": "O0015-delivered", "order_id": "O0015", "hub": "Harbour", "service": "standard", "kind": "delivered", "happened_at": "2026-09-03T10:30:00Z"}
{"event_id": "O0075-delivered", "order_id": "O0075", "hub": "Eastgate", "service": "standard", "kind": "delivered", "happened_at": "2026-09-03T10:30:00Z"}
{"event_id": "O0135-delivered", "order_id": "O0135", "hub": "Westhill", "service": "standard", "kind": "delivered", "happened_at": "2026-09-03T10:30:00Z"}
{"event_id": "O0195-delivered", "order_id": "O0195", "hub": "Southbay", "service": "standard", "kind": "delivered", "happened_at": "2026-09-03T10:30:00Z"}
{"event_id": "O0029-picked_up", "order_id": "O0029", "hub": "Harbour", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-03T12:00:00Z"}
{"event_id": "O0109-picked_up", "order_id": "O0109", "hub": "Eastgate", "service": "express", "kind": "picked_up", "happened_at": "2026-09-03T12:00:00Z"}
{"event_id": "O0149-picked_up", "order_id": "O0149", "hub": "Westhill", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-03T12:00:00Z"}
{"event_id": "O0209-picked_up", "order_id": "O0209", "hub": "Southbay", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-03T12:00:00Z"}
{"event_id": "O0016-created", "order_id": "O0016", "hub": "Harbour", "service": "standard", "kind": "created", "happened_at": "2026-09-03T13:00:00Z"}
{"event_id": "O0056-created", "order_id": "O0056", "hub": "Harbour", "service": "express", "kind": "created", "happened_at": "2026-09-03T13:00:00Z"}
{"event_id": "O0076-created", "order_id": "O0076", "hub": "Eastgate", "service": "standard", "kind": "created", "happened_at": "2026-09-03T13:00:00Z"}
{"event_id": "O0096-created", "order_id": "O0096", "hub": "Eastgate", "service": "express", "kind": "created", "happened_at": "2026-09-03T13:00:00Z"}
{"event_id": "O0136-created", "order_id": "O0136", "hub": "Westhill", "service": "standard", "kind": "created", "happened_at": "2026-09-03T13:00:00Z"}
{"event_id": "O0172-created", "order_id": "O0172", "hub": "Westhill", "service": "express", "kind": "created", "happened_at": "2026-09-03T13:00:00Z"}
{"event_id": "O0196-created", "order_id": "O0196", "hub": "Southbay", "service": "standard", "kind": "created", "happened_at": "2026-09-03T13:00:00Z"}
{"event_id": "O0083-delivered", "order_id": "O0083", "hub": "Eastgate", "service": "express", "kind": "delivered", "happened_at": "2026-09-03T14:30:00Z"}
{"event_id": "O0159-delivered", "order_id": "O0159", "hub": "Westhill", "service": "express", "kind": "delivered", "happened_at": "2026-09-03T14:30:00Z"}
{"event_id": "O0213-delivered", "order_id": "O0213", "hub": "Southbay", "service": "express", "kind": "delivered", "happened_at": "2026-09-03T14:30:00Z"}
{"event_id": "O0016-picked_up", "order_id": "O0016", "hub": "Harbour", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-03T15:00:00Z"}
{"event_id": "O0056-picked_up", "order_id": "O0056", "hub": "Harbour", "service": "express", "kind": "picked_up", "happened_at": "2026-09-03T15:00:00Z"}
{"event_id": "O0076-picked_up", "order_id": "O0076", "hub": "Eastgate", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-03T15:00:00Z"}
{"event_id": "O0096-picked_up", "order_id": "O0096", "hub": "Eastgate", "service": "express", "kind": "picked_up", "happened_at": "2026-09-03T15:00:00Z"}
{"event_id": "O0136-picked_up", "order_id": "O0136", "hub": "Westhill", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-03T15:00:00Z"}
{"event_id": "O0172-picked_up", "order_id": "O0172", "hub": "Westhill", "service": "express", "kind": "picked_up", "happened_at": "2026-09-03T15:00:00Z"}
{"event_id": "O0196-picked_up", "order_id": "O0196", "hub": "Southbay", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-03T15:00:00Z"}
{"event_id": "O0043-delivered", "order_id": "O0043", "hub": "Harbour", "service": "express", "kind": "delivered", "happened_at": "2026-09-03T16:50:00Z"}
{"event_id": "O0109-delivered", "order_id": "O0109", "hub": "Eastgate", "service": "express", "kind": "delivered", "happened_at": "2026-09-03T19:10:00Z"}
{"event_id": "O0172-delivered", "order_id": "O0172", "hub": "Westhill", "service": "express", "kind": "delivered", "happened_at": "2026-09-03T19:30:00Z"}
{"event_id": "O0056-delivered", "order_id": "O0056", "hub": "Harbour", "service": "express", "kind": "delivered", "happened_at": "2026-09-03T21:50:00Z"}
{"event_id": "O0096-delivered", "order_id": "O0096", "hub": "Eastgate", "service": "express", "kind": "delivered", "happened_at": "2026-09-03T22:10:00Z"}
{"event_id": "O0017-created", "order_id": "O0017", "hub": "Harbour", "service": "standard", "kind": "created", "happened_at": "2026-09-04T06:00:00Z"}
{"event_id": "O0057-created", "order_id": "O0057", "hub": "Harbour", "service": "express", "kind": "created", "happened_at": "2026-09-04T06:00:00Z"}
{"event_id": "O0077-created", "order_id": "O0077", "hub": "Eastgate", "service": "standard", "kind": "created", "happened_at": "2026-09-04T06:00:00Z"}
{"event_id": "O0097-created", "order_id": "O0097", "hub": "Eastgate", "service": "express", "kind": "created", "happened_at": "2026-09-04T06:00:00Z"}
{"event_id": "O0137-created", "order_id": "O0137", "hub": "Westhill", "service": "standard", "kind": "created", "happened_at": "2026-09-04T06:00:00Z"}
{"event_id": "O0173-created", "order_id": "O0173", "hub": "Westhill", "service": "express", "kind": "created", "happened_at": "2026-09-04T06:00:00Z"}
{"event_id": "O0197-created", "order_id": "O0197", "hub": "Southbay", "service": "standard", "kind": "created", "happened_at": "2026-09-04T06:00:00Z"}
{"event_id": "O0003-delivered", "order_id": "O0003", "hub": "Harbour", "service": "standard", "kind": "delivered", "happened_at": "2026-09-04T06:30:00Z"}
{"event_id": "O0063-delivered", "order_id": "O0063", "hub": "Eastgate", "service": "standard", "kind": "delivered", "happened_at": "2026-09-04T06:30:00Z"}
{"event_id": "O0123-delivered", "order_id": "O0123", "hub": "Westhill", "service": "standard", "kind": "delivered", "happened_at": "2026-09-04T06:30:00Z"}
{"event_id": "O0183-delivered", "order_id": "O0183", "hub": "Southbay", "service": "standard", "kind": "delivered", "happened_at": "2026-09-04T06:30:00Z"}
{"event_id": "O0017-picked_up", "order_id": "O0017", "hub": "Harbour", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-04T08:00:00Z"}
{"event_id": "O0057-picked_up", "order_id": "O0057", "hub": "Harbour", "service": "express", "kind": "picked_up", "happened_at": "2026-09-04T08:00:00Z"}
{"event_id": "O0077-picked_up", "order_id": "O0077", "hub": "Eastgate", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-04T08:00:00Z"}
{"event_id": "O0097-picked_up", "order_id": "O0097", "hub": "Eastgate", "service": "express", "kind": "picked_up", "happened_at": "2026-09-04T08:00:00Z"}
{"event_id": "O0137-picked_up", "order_id": "O0137", "hub": "Westhill", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-04T08:00:00Z"}
{"event_id": "O0173-picked_up", "order_id": "O0173", "hub": "Westhill", "service": "express", "kind": "picked_up", "happened_at": "2026-09-04T08:00:00Z"}
{"event_id": "O0197-picked_up", "order_id": "O0197", "hub": "Southbay", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-04T08:00:00Z"}
{"event_id": "O0149-delivered", "order_id": "O0149", "hub": "Westhill", "service": "standard", "kind": "delivered", "happened_at": "2026-09-04T08:30:00Z"}
{"event_id": "O0209-delivered", "order_id": "O0209", "hub": "Southbay", "service": "standard", "kind": "delivered", "happened_at": "2026-09-04T08:30:00Z"}
{"event_id": "O0004-created", "order_id": "O0004", "hub": "Harbour", "service": "standard", "kind": "created", "happened_at": "2026-09-04T09:00:00Z"}
{"event_id": "O0044-created", "order_id": "O0044", "hub": "Harbour", "service": "express", "kind": "created", "happened_at": "2026-09-04T09:00:00Z"}
{"event_id": "O0064-created", "order_id": "O0064", "hub": "Eastgate", "service": "standard", "kind": "created", "happened_at": "2026-09-04T09:00:00Z"}
{"event_id": "O0084-created", "order_id": "O0084", "hub": "Eastgate", "service": "express", "kind": "created", "happened_at": "2026-09-04T09:00:00Z"}
{"event_id": "O0124-created", "order_id": "O0124", "hub": "Westhill", "service": "standard", "kind": "created", "happened_at": "2026-09-04T09:00:00Z"}
{"event_id": "O0160-created", "order_id": "O0160", "hub": "Westhill", "service": "express", "kind": "created", "happened_at": "2026-09-04T09:00:00Z"}
{"event_id": "O0184-created", "order_id": "O0184", "hub": "Southbay", "service": "standard", "kind": "created", "happened_at": "2026-09-04T09:00:00Z"}
{"event_id": "O0214-created", "order_id": "O0214", "hub": "Southbay", "service": "express", "kind": "created", "happened_at": "2026-09-04T09:00:00Z"}
{"event_id": "O0029-delivered", "order_id": "O0029", "hub": "Harbour", "service": "standard", "kind": "delivered", "happened_at": "2026-09-04T10:50:00Z"}
{"event_id": "O0004-picked_up", "order_id": "O0004", "hub": "Harbour", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-04T11:00:00Z"}
{"event_id": "O0030-created", "order_id": "O0030", "hub": "Harbour", "service": "standard", "kind": "created", "happened_at": "2026-09-04T11:00:00Z"}
{"event_id": "O0044-picked_up", "order_id": "O0044", "hub": "Harbour", "service": "express", "kind": "picked_up", "happened_at": "2026-09-04T11:00:00Z"}
{"event_id": "O0064-picked_up", "order_id": "O0064", "hub": "Eastgate", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-04T11:00:00Z"}
{"event_id": "O0084-picked_up", "order_id": "O0084", "hub": "Eastgate", "service": "express", "kind": "picked_up", "happened_at": "2026-09-04T11:00:00Z"}
{"event_id": "O0110-created", "order_id": "O0110", "hub": "Eastgate", "service": "express", "kind": "created", "happened_at": "2026-09-04T11:00:00Z"}
{"event_id": "O0124-picked_up", "order_id": "O0124", "hub": "Westhill", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-04T11:00:00Z"}
{"event_id": "O0150-created", "order_id": "O0150", "hub": "Westhill", "service": "standard", "kind": "created", "happened_at": "2026-09-04T11:00:00Z"}
{"event_id": "O0160-picked_up", "order_id": "O0160", "hub": "Westhill", "service": "express", "kind": "picked_up", "happened_at": "2026-09-04T11:00:00Z"}
{"event_id": "O0184-picked_up", "order_id": "O0184", "hub": "Southbay", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-04T11:00:00Z"}
{"event_id": "O0214-picked_up", "order_id": "O0214", "hub": "Southbay", "service": "express", "kind": "picked_up", "happened_at": "2026-09-04T11:00:00Z"}
{"event_id": "O0016-delivered", "order_id": "O0016", "hub": "Harbour", "service": "standard", "kind": "delivered", "happened_at": "2026-09-04T11:30:00Z"}
{"event_id": "O0076-delivered", "order_id": "O0076", "hub": "Eastgate", "service": "standard", "kind": "delivered", "happened_at": "2026-09-04T11:30:00Z"}
{"event_id": "O0136-delivered", "order_id": "O0136", "hub": "Westhill", "service": "standard", "kind": "delivered", "happened_at": "2026-09-04T11:30:00Z"}
{"event_id": "O0196-delivered", "order_id": "O0196", "hub": "Southbay", "service": "standard", "kind": "delivered", "happened_at": "2026-09-04T11:30:00Z"}
{"event_id": "O0030-cancelled", "order_id": "O0030", "hub": "Harbour", "service": "standard", "kind": "cancelled", "happened_at": "2026-09-04T12:00:00Z"}
{"event_id": "O0110-cancelled", "order_id": "O0110", "hub": "Eastgate", "service": "express", "kind": "cancelled", "happened_at": "2026-09-04T12:00:00Z"}
{"event_id": "O0150-cancelled", "order_id": "O0150", "hub": "Westhill", "service": "standard", "kind": "cancelled", "happened_at": "2026-09-04T12:00:00Z"}
{"event_id": "O0057-delivered", "order_id": "O0057", "hub": "Harbour", "service": "express", "kind": "delivered", "happened_at": "2026-09-04T14:50:00Z"}
{"event_id": "O0097-delivered", "order_id": "O0097", "hub": "Eastgate", "service": "express", "kind": "delivered", "happened_at": "2026-09-04T15:10:00Z"}
{"event_id": "O0160-delivered", "order_id": "O0160", "hub": "Westhill", "service": "express", "kind": "delivered", "happened_at": "2026-09-04T15:30:00Z"}
{"event_id": "O0173-delivered", "order_id": "O0173", "hub": "Westhill", "service": "express", "kind": "delivered", "happened_at": "2026-09-04T15:30:00Z"}
{"event_id": "O0214-delivered", "order_id": "O0214", "hub": "Southbay", "service": "express", "kind": "delivered", "happened_at": "2026-09-04T15:30:00Z"}
{"event_id": "O0044-delivered", "order_id": "O0044", "hub": "Harbour", "service": "express", "kind": "delivered", "happened_at": "2026-09-04T17:50:00Z"}
{"event_id": "O0084-delivered", "order_id": "O0084", "hub": "Eastgate", "service": "express", "kind": "delivered", "happened_at": "2026-09-04T18:10:00Z"}
{"event_id": "O0077-delivered", "order_id": "O0077", "hub": "Eastgate", "service": "standard", "kind": "delivered", "happened_at": "2026-09-05T04:30:00Z"}
{"event_id": "O0197-delivered", "order_id": "O0197", "hub": "Southbay", "service": "standard", "kind": "delivered", "happened_at": "2026-09-05T04:30:00Z"}
{"event_id": "O0017-delivered", "order_id": "O0017", "hub": "Harbour", "service": "standard", "kind": "delivered", "happened_at": "2026-09-05T06:50:00Z"}
{"event_id": "O0018-created", "order_id": "O0018", "hub": "Harbour", "service": "standard", "kind": "created", "happened_at": "2026-09-05T07:00:00Z"}
{"event_id": "O0058-created", "order_id": "O0058", "hub": "Harbour", "service": "express", "kind": "created", "happened_at": "2026-09-05T07:00:00Z"}
{"event_id": "O0078-created", "order_id": "O0078", "hub": "Eastgate", "service": "standard", "kind": "created", "happened_at": "2026-09-05T07:00:00Z"}
{"event_id": "O0098-created", "order_id": "O0098", "hub": "Eastgate", "service": "express", "kind": "created", "happened_at": "2026-09-05T07:00:00Z"}
{"event_id": "O0138-created", "order_id": "O0138", "hub": "Westhill", "service": "standard", "kind": "created", "happened_at": "2026-09-05T07:00:00Z"}
{"event_id": "O0174-created", "order_id": "O0174", "hub": "Westhill", "service": "express", "kind": "created", "happened_at": "2026-09-05T07:00:00Z"}
{"event_id": "O0198-created", "order_id": "O0198", "hub": "Southbay", "service": "standard", "kind": "created", "happened_at": "2026-09-05T07:00:00Z"}
{"event_id": "O0004-delivered", "order_id": "O0004", "hub": "Harbour", "service": "standard", "kind": "delivered", "happened_at": "2026-09-05T07:30:00Z"}
{"event_id": "O0064-delivered", "order_id": "O0064", "hub": "Eastgate", "service": "standard", "kind": "delivered", "happened_at": "2026-09-05T07:30:00Z"}
{"event_id": "O0124-delivered", "order_id": "O0124", "hub": "Westhill", "service": "standard", "kind": "delivered", "happened_at": "2026-09-05T07:30:00Z"}
{"event_id": "O0137-delivered", "order_id": "O0137", "hub": "Westhill", "service": "standard", "kind": "delivered", "happened_at": "2026-09-05T07:30:00Z"}
{"event_id": "O0184-delivered", "order_id": "O0184", "hub": "Southbay", "service": "standard", "kind": "delivered", "happened_at": "2026-09-05T07:30:00Z"}
{"event_id": "O0018-picked_up", "order_id": "O0018", "hub": "Harbour", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-05T09:00:00Z"}
{"event_id": "O0058-picked_up", "order_id": "O0058", "hub": "Harbour", "service": "express", "kind": "picked_up", "happened_at": "2026-09-05T09:00:00Z"}
{"event_id": "O0078-picked_up", "order_id": "O0078", "hub": "Eastgate", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-05T09:00:00Z"}
{"event_id": "O0098-picked_up", "order_id": "O0098", "hub": "Eastgate", "service": "express", "kind": "picked_up", "happened_at": "2026-09-05T09:00:00Z"}
{"event_id": "O0138-picked_up", "order_id": "O0138", "hub": "Westhill", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-05T09:00:00Z"}
{"event_id": "O0174-picked_up", "order_id": "O0174", "hub": "Westhill", "service": "express", "kind": "picked_up", "happened_at": "2026-09-05T09:00:00Z"}
{"event_id": "O0198-picked_up", "order_id": "O0198", "hub": "Southbay", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-05T09:00:00Z"}
{"event_id": "O0005-created", "order_id": "O0005", "hub": "Harbour", "service": "standard", "kind": "created", "happened_at": "2026-09-05T10:00:00Z"}
{"event_id": "O0045-created", "order_id": "O0045", "hub": "Harbour", "service": "express", "kind": "created", "happened_at": "2026-09-05T10:00:00Z"}
{"event_id": "O0065-created", "order_id": "O0065", "hub": "Eastgate", "service": "standard", "kind": "created", "happened_at": "2026-09-05T10:00:00Z"}
{"event_id": "O0085-created", "order_id": "O0085", "hub": "Eastgate", "service": "express", "kind": "created", "happened_at": "2026-09-05T10:00:00Z"}
{"event_id": "O0125-created", "order_id": "O0125", "hub": "Westhill", "service": "standard", "kind": "created", "happened_at": "2026-09-05T10:00:00Z"}
{"event_id": "O0161-created", "order_id": "O0161", "hub": "Westhill", "service": "express", "kind": "created", "happened_at": "2026-09-05T10:00:00Z"}
{"event_id": "O0185-created", "order_id": "O0185", "hub": "Southbay", "service": "standard", "kind": "created", "happened_at": "2026-09-05T10:00:00Z"}
{"event_id": "O0215-created", "order_id": "O0215", "hub": "Southbay", "service": "express", "kind": "created", "happened_at": "2026-09-05T10:00:00Z"}
{"event_id": "O0005-picked_up", "order_id": "O0005", "hub": "Harbour", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-05T12:00:00Z"}
{"event_id": "O0031-created", "order_id": "O0031", "hub": "Harbour", "service": "standard", "kind": "created", "happened_at": "2026-09-05T12:00:00Z"}
{"event_id": "O0045-picked_up", "order_id": "O0045", "hub": "Harbour", "service": "express", "kind": "picked_up", "happened_at": "2026-09-05T12:00:00Z"}
{"event_id": "O0065-picked_up", "order_id": "O0065", "hub": "Eastgate", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-05T12:00:00Z"}
{"event_id": "O0085-picked_up", "order_id": "O0085", "hub": "Eastgate", "service": "express", "kind": "picked_up", "happened_at": "2026-09-05T12:00:00Z"}
{"event_id": "O0111-created", "order_id": "O0111", "hub": "Eastgate", "service": "express", "kind": "created", "happened_at": "2026-09-05T12:00:00Z"}
{"event_id": "O0125-picked_up", "order_id": "O0125", "hub": "Westhill", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-05T12:00:00Z"}
{"event_id": "O0151-created", "order_id": "O0151", "hub": "Westhill", "service": "standard", "kind": "created", "happened_at": "2026-09-05T12:00:00Z"}
{"event_id": "O0161-picked_up", "order_id": "O0161", "hub": "Westhill", "service": "express", "kind": "picked_up", "happened_at": "2026-09-05T12:00:00Z"}
{"event_id": "O0185-picked_up", "order_id": "O0185", "hub": "Southbay", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-05T12:00:00Z"}
{"event_id": "O0215-picked_up", "order_id": "O0215", "hub": "Southbay", "service": "express", "kind": "picked_up", "happened_at": "2026-09-05T12:00:00Z"}
{"event_id": "O0031-picked_up", "order_id": "O0031", "hub": "Harbour", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-05T14:00:00Z"}
{"event_id": "O0111-picked_up", "order_id": "O0111", "hub": "Eastgate", "service": "express", "kind": "picked_up", "happened_at": "2026-09-05T14:00:00Z"}
{"event_id": "O0151-picked_up", "order_id": "O0151", "hub": "Westhill", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-05T14:00:00Z"}
{"event_id": "O0215-delivered", "order_id": "O0215", "hub": "Southbay", "service": "express", "kind": "delivered", "happened_at": "2026-09-05T16:30:00Z"}
{"event_id": "O0045-delivered", "order_id": "O0045", "hub": "Harbour", "service": "express", "kind": "delivered", "happened_at": "2026-09-05T18:50:00Z"}
{"event_id": "O0085-delivered", "order_id": "O0085", "hub": "Eastgate", "service": "express", "kind": "delivered", "happened_at": "2026-09-05T19:10:00Z"}
{"event_id": "O0161-delivered", "order_id": "O0161", "hub": "Westhill", "service": "express", "kind": "delivered", "happened_at": "2026-09-05T19:30:00Z"}
{"event_id": "O0111-delivered", "order_id": "O0111", "hub": "Eastgate", "service": "express", "kind": "delivered", "happened_at": "2026-09-05T21:10:00Z"}
{"event_id": "O0019-created", "order_id": "O0019", "hub": "Harbour", "service": "standard", "kind": "created", "happened_at": "2026-09-06T08:00:00Z"}
{"event_id": "O0059-created", "order_id": "O0059", "hub": "Harbour", "service": "express", "kind": "created", "happened_at": "2026-09-06T08:00:00Z"}
{"event_id": "O0079-created", "order_id": "O0079", "hub": "Eastgate", "service": "standard", "kind": "created", "happened_at": "2026-09-06T08:00:00Z"}
{"event_id": "O0099-created", "order_id": "O0099", "hub": "Eastgate", "service": "express", "kind": "created", "happened_at": "2026-09-06T08:00:00Z"}
{"event_id": "O0139-created", "order_id": "O0139", "hub": "Westhill", "service": "standard", "kind": "created", "happened_at": "2026-09-06T08:00:00Z"}
{"event_id": "O0175-created", "order_id": "O0175", "hub": "Westhill", "service": "express", "kind": "created", "happened_at": "2026-09-06T08:00:00Z"}
{"event_id": "O0199-created", "order_id": "O0199", "hub": "Southbay", "service": "standard", "kind": "created", "happened_at": "2026-09-06T08:00:00Z"}
{"event_id": "O0065-delivered", "order_id": "O0065", "hub": "Eastgate", "service": "standard", "kind": "delivered", "happened_at": "2026-09-06T08:30:00Z"}
{"event_id": "O0125-delivered", "order_id": "O0125", "hub": "Westhill", "service": "standard", "kind": "delivered", "happened_at": "2026-09-06T08:30:00Z"}
{"event_id": "O0185-delivered", "order_id": "O0185", "hub": "Southbay", "service": "standard", "kind": "delivered", "happened_at": "2026-09-06T08:30:00Z"}
{"event_id": "O0019-picked_up", "order_id": "O0019", "hub": "Harbour", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-06T10:00:00Z"}
{"event_id": "O0059-picked_up", "order_id": "O0059", "hub": "Harbour", "service": "express", "kind": "picked_up", "happened_at": "2026-09-06T10:00:00Z"}
{"event_id": "O0079-picked_up", "order_id": "O0079", "hub": "Eastgate", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-06T10:00:00Z"}
{"event_id": "O0099-picked_up", "order_id": "O0099", "hub": "Eastgate", "service": "express", "kind": "picked_up", "happened_at": "2026-09-06T10:00:00Z"}
{"event_id": "O0139-picked_up", "order_id": "O0139", "hub": "Westhill", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-06T10:00:00Z"}
{"event_id": "O0175-picked_up", "order_id": "O0175", "hub": "Westhill", "service": "express", "kind": "picked_up", "happened_at": "2026-09-06T10:00:00Z"}
{"event_id": "O0199-picked_up", "order_id": "O0199", "hub": "Southbay", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-06T10:00:00Z"}
{"event_id": "O0031-delivered", "order_id": "O0031", "hub": "Harbour", "service": "standard", "kind": "delivered", "happened_at": "2026-09-06T10:30:00Z"}
{"event_id": "O0151-delivered", "order_id": "O0151", "hub": "Westhill", "service": "standard", "kind": "delivered", "happened_at": "2026-09-06T10:30:00Z"}
{"event_id": "O0005-delivered", "order_id": "O0005", "hub": "Harbour", "service": "standard", "kind": "delivered", "happened_at": "2026-09-06T10:50:00Z"}
{"event_id": "O0006-created", "order_id": "O0006", "hub": "Harbour", "service": "standard", "kind": "created", "happened_at": "2026-09-06T11:00:00Z"}
{"event_id": "O0046-created", "order_id": "O0046", "hub": "Harbour", "service": "express", "kind": "created", "happened_at": "2026-09-06T11:00:00Z"}
{"event_id": "O0066-created", "order_id": "O0066", "hub": "Eastgate", "service": "standard", "kind": "created", "happened_at": "2026-09-06T11:00:00Z"}
{"event_id": "O0086-created", "order_id": "O0086", "hub": "Eastgate", "service": "express", "kind": "created", "happened_at": "2026-09-06T11:00:00Z"}
{"event_id": "O0126-created", "order_id": "O0126", "hub": "Westhill", "service": "standard", "kind": "created", "happened_at": "2026-09-06T11:00:00Z"}
{"event_id": "O0162-created", "order_id": "O0162", "hub": "Westhill", "service": "express", "kind": "created", "happened_at": "2026-09-06T11:00:00Z"}
{"event_id": "O0186-created", "order_id": "O0186", "hub": "Southbay", "service": "standard", "kind": "created", "happened_at": "2026-09-06T11:00:00Z"}
{"event_id": "O0006-picked_up", "order_id": "O0006", "hub": "Harbour", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-06T13:00:00Z"}
{"event_id": "O0032-created", "order_id": "O0032", "hub": "Harbour", "service": "standard", "kind": "created", "happened_at": "2026-09-06T13:00:00Z"}
{"event_id": "O0046-picked_up", "order_id": "O0046", "hub": "Harbour", "service": "express", "kind": "picked_up", "happened_at": "2026-09-06T13:00:00Z"}
{"event_id": "O0066-picked_up", "order_id": "O0066", "hub": "Eastgate", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-06T13:00:00Z"}
{"event_id": "O0086-picked_up", "order_id": "O0086", "hub": "Eastgate", "service": "express", "kind": "picked_up", "happened_at": "2026-09-06T13:00:00Z"}
{"event_id": "O0112-created", "order_id": "O0112", "hub": "Eastgate", "service": "express", "kind": "created", "happened_at": "2026-09-06T13:00:00Z"}
{"event_id": "O0126-picked_up", "order_id": "O0126", "hub": "Westhill", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-06T13:00:00Z"}
{"event_id": "O0152-created", "order_id": "O0152", "hub": "Westhill", "service": "standard", "kind": "created", "happened_at": "2026-09-06T13:00:00Z"}
{"event_id": "O0162-picked_up", "order_id": "O0162", "hub": "Westhill", "service": "express", "kind": "picked_up", "happened_at": "2026-09-06T13:00:00Z"}
{"event_id": "O0186-picked_up", "order_id": "O0186", "hub": "Southbay", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-06T13:00:00Z"}
{"event_id": "O0175-delivered", "order_id": "O0175", "hub": "Westhill", "service": "express", "kind": "delivered", "happened_at": "2026-09-06T14:30:00Z"}
{"event_id": "O0032-picked_up", "order_id": "O0032", "hub": "Harbour", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-06T15:00:00Z"}
{"event_id": "O0112-picked_up", "order_id": "O0112", "hub": "Eastgate", "service": "express", "kind": "picked_up", "happened_at": "2026-09-06T15:00:00Z"}
{"event_id": "O0152-picked_up", "order_id": "O0152", "hub": "Westhill", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-06T15:00:00Z"}
{"event_id": "O0059-delivered", "order_id": "O0059", "hub": "Harbour", "service": "express", "kind": "delivered", "happened_at": "2026-09-06T16:50:00Z"}
{"event_id": "O0099-delivered", "order_id": "O0099", "hub": "Eastgate", "service": "express", "kind": "delivered", "happened_at": "2026-09-06T17:10:00Z"}
{"event_id": "O0086-delivered", "order_id": "O0086", "hub": "Eastgate", "service": "express", "kind": "delivered", "happened_at": "2026-09-06T17:30:00Z"}
{"event_id": "O0046-delivered", "order_id": "O0046", "hub": "Harbour", "service": "express", "kind": "delivered", "happened_at": "2026-09-06T19:50:00Z"}
{"event_id": "O0162-delivered", "order_id": "O0162", "hub": "Westhill", "service": "express", "kind": "delivered", "happened_at": "2026-09-06T20:30:00Z"}
{"event_id": "O0112-delivered", "order_id": "O0112", "hub": "Eastgate", "service": "express", "kind": "delivered", "happened_at": "2026-09-06T22:10:00Z"}
{"event_id": "O0033-created", "order_id": "O0033", "hub": "Harbour", "service": "standard", "kind": "created", "happened_at": "2026-09-07T06:00:00Z"}
{"event_id": "O0113-created", "order_id": "O0113", "hub": "Eastgate", "service": "express", "kind": "created", "happened_at": "2026-09-07T06:00:00Z"}
{"event_id": "O0153-created", "order_id": "O0153", "hub": "Westhill", "service": "standard", "kind": "created", "happened_at": "2026-09-07T06:00:00Z"}
{"event_id": "O0019-delivered", "order_id": "O0019", "hub": "Harbour", "service": "standard", "kind": "delivered", "happened_at": "2026-09-07T06:30:00Z"}
{"event_id": "O0079-delivered", "order_id": "O0079", "hub": "Eastgate", "service": "standard", "kind": "delivered", "happened_at": "2026-09-07T06:30:00Z"}
{"event_id": "O0139-delivered", "order_id": "O0139", "hub": "Westhill", "service": "standard", "kind": "delivered", "happened_at": "2026-09-07T06:30:00Z"}
{"event_id": "O0199-delivered", "order_id": "O0199", "hub": "Southbay", "service": "standard", "kind": "delivered", "happened_at": "2026-09-07T06:30:00Z"}
{"event_id": "O0033-picked_up", "order_id": "O0033", "hub": "Harbour", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-07T08:00:00Z"}
{"event_id": "O0113-picked_up", "order_id": "O0113", "hub": "Eastgate", "service": "express", "kind": "picked_up", "happened_at": "2026-09-07T08:00:00Z"}
{"event_id": "O0153-picked_up", "order_id": "O0153", "hub": "Westhill", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-07T08:00:00Z"}
{"event_id": "O0020-created", "order_id": "O0020", "hub": "Harbour", "service": "standard", "kind": "created", "happened_at": "2026-09-07T09:00:00Z"}
{"event_id": "O0100-created", "order_id": "O0100", "hub": "Eastgate", "service": "express", "kind": "created", "happened_at": "2026-09-07T09:00:00Z"}
{"event_id": "O0140-created", "order_id": "O0140", "hub": "Westhill", "service": "standard", "kind": "created", "happened_at": "2026-09-07T09:00:00Z"}
{"event_id": "O0176-created", "order_id": "O0176", "hub": "Westhill", "service": "express", "kind": "created", "happened_at": "2026-09-07T09:00:00Z"}
{"event_id": "O0200-created", "order_id": "O0200", "hub": "Southbay", "service": "standard", "kind": "created", "happened_at": "2026-09-07T09:00:00Z"}
{"event_id": "O0006-delivered", "order_id": "O0006", "hub": "Harbour", "service": "standard", "kind": "delivered", "happened_at": "2026-09-07T09:30:00Z"}
{"event_id": "O0126-delivered", "order_id": "O0126", "hub": "Westhill", "service": "standard", "kind": "delivered", "happened_at": "2026-09-07T09:30:00Z"}
{"event_id": "O0186-delivered", "order_id": "O0186", "hub": "Southbay", "service": "standard", "kind": "delivered", "happened_at": "2026-09-07T09:30:00Z"}
{"event_id": "O0020-picked_up", "order_id": "O0020", "hub": "Harbour", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-07T11:00:00Z"}
{"event_id": "O0100-picked_up", "order_id": "O0100", "hub": "Eastgate", "service": "express", "kind": "picked_up", "happened_at": "2026-09-07T11:00:00Z"}
{"event_id": "O0140-picked_up", "order_id": "O0140", "hub": "Westhill", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-07T11:00:00Z"}
{"event_id": "O0176-picked_up", "order_id": "O0176", "hub": "Westhill", "service": "express", "kind": "picked_up", "happened_at": "2026-09-07T11:00:00Z"}
{"event_id": "O0200-picked_up", "order_id": "O0200", "hub": "Southbay", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-07T11:00:00Z"}
{"event_id": "O0007-created", "order_id": "O0007", "hub": "Harbour", "service": "standard", "kind": "created", "happened_at": "2026-09-07T12:00:00Z"}
{"event_id": "O0047-created", "order_id": "O0047", "hub": "Harbour", "service": "express", "kind": "created", "happened_at": "2026-09-07T12:00:00Z"}
{"event_id": "O0067-created", "order_id": "O0067", "hub": "Eastgate", "service": "standard", "kind": "created", "happened_at": "2026-09-07T12:00:00Z"}
{"event_id": "O0087-created", "order_id": "O0087", "hub": "Eastgate", "service": "express", "kind": "created", "happened_at": "2026-09-07T12:00:00Z"}
{"event_id": "O0127-created", "order_id": "O0127", "hub": "Westhill", "service": "standard", "kind": "created", "happened_at": "2026-09-07T12:00:00Z"}
{"event_id": "O0163-created", "order_id": "O0163", "hub": "Westhill", "service": "express", "kind": "created", "happened_at": "2026-09-07T12:00:00Z"}
{"event_id": "O0187-created", "order_id": "O0187", "hub": "Southbay", "service": "standard", "kind": "created", "happened_at": "2026-09-07T12:00:00Z"}
{"event_id": "O0066-delivered", "order_id": "O0066", "hub": "Eastgate", "service": "standard", "kind": "delivered", "happened_at": "2026-09-07T12:10:00Z"}
{"event_id": "O0113-delivered", "order_id": "O0113", "hub": "Eastgate", "service": "express", "kind": "delivered", "happened_at": "2026-09-07T12:30:00Z"}
{"event_id": "O0032-delivered", "order_id": "O0032", "hub": "Harbour", "service": "standard", "kind": "delivered", "happened_at": "2026-09-07T13:50:00Z"}
{"event_id": "O0007-picked_up", "order_id": "O0007", "hub": "Harbour", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-07T14:00:00Z"}
{"event_id": "O0047-picked_up", "order_id": "O0047", "hub": "Harbour", "service": "express", "kind": "picked_up", "happened_at": "2026-09-07T14:00:00Z"}
{"event_id": "O0067-picked_up", "order_id": "O0067", "hub": "Eastgate", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-07T14:00:00Z"}
{"event_id": "O0087-picked_up", "order_id": "O0087", "hub": "Eastgate", "service": "express", "kind": "picked_up", "happened_at": "2026-09-07T14:00:00Z"}
{"event_id": "O0127-picked_up", "order_id": "O0127", "hub": "Westhill", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-07T14:00:00Z"}
{"event_id": "O0163-picked_up", "order_id": "O0163", "hub": "Westhill", "service": "express", "kind": "picked_up", "happened_at": "2026-09-07T14:00:00Z"}
{"event_id": "O0187-picked_up", "order_id": "O0187", "hub": "Southbay", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-07T14:00:00Z"}
{"event_id": "O0152-delivered", "order_id": "O0152", "hub": "Westhill", "service": "standard", "kind": "delivered", "happened_at": "2026-09-07T14:30:00Z"}
{"event_id": "O0176-delivered", "order_id": "O0176", "hub": "Westhill", "service": "express", "kind": "delivered", "happened_at": "2026-09-07T15:30:00Z"}
{"event_id": "O0100-delivered", "order_id": "O0100", "hub": "Eastgate", "service": "express", "kind": "delivered", "happened_at": "2026-09-07T18:10:00Z"}
{"event_id": "O0163-delivered", "order_id": "O0163", "hub": "Westhill", "service": "express", "kind": "delivered", "happened_at": "2026-09-07T18:30:00Z"}
{"event_id": "O0047-delivered", "order_id": "O0047", "hub": "Harbour", "service": "express", "kind": "delivered", "happened_at": "2026-09-07T20:50:00Z"}
{"event_id": "O0087-delivered", "order_id": "O0087", "hub": "Eastgate", "service": "express", "kind": "delivered", "happened_at": "2026-09-07T21:10:00Z"}
{"event_id": "O0033-delivered", "order_id": "O0033", "hub": "Harbour", "service": "standard", "kind": "delivered", "happened_at": "2026-09-08T04:30:00Z"}
{"event_id": "O0153-delivered", "order_id": "O0153", "hub": "Westhill", "service": "standard", "kind": "delivered", "happened_at": "2026-09-08T04:30:00Z"}
{"event_id": "O0034-created", "order_id": "O0034", "hub": "Harbour", "service": "standard", "kind": "created", "happened_at": "2026-09-08T07:00:00Z"}
{"event_id": "O0114-created", "order_id": "O0114", "hub": "Eastgate", "service": "express", "kind": "created", "happened_at": "2026-09-08T07:00:00Z"}
{"event_id": "O0154-created", "order_id": "O0154", "hub": "Westhill", "service": "standard", "kind": "created", "happened_at": "2026-09-08T07:00:00Z"}
{"event_id": "O0140-delivered", "order_id": "O0140", "hub": "Westhill", "service": "standard", "kind": "delivered", "happened_at": "2026-09-08T07:30:00Z"}
{"event_id": "O0034-picked_up", "order_id": "O0034", "hub": "Harbour", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-08T09:00:00Z"}
{"event_id": "O0114-picked_up", "order_id": "O0114", "hub": "Eastgate", "service": "express", "kind": "picked_up", "happened_at": "2026-09-08T09:00:00Z"}
{"event_id": "O0154-picked_up", "order_id": "O0154", "hub": "Westhill", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-08T09:00:00Z"}
{"event_id": "O0020-delivered", "order_id": "O0020", "hub": "Harbour", "service": "standard", "kind": "delivered", "happened_at": "2026-09-08T09:50:00Z"}
{"event_id": "O0021-created", "order_id": "O0021", "hub": "Harbour", "service": "standard", "kind": "created", "happened_at": "2026-09-08T10:00:00Z"}
{"event_id": "O0101-created", "order_id": "O0101", "hub": "Eastgate", "service": "express", "kind": "created", "happened_at": "2026-09-08T10:00:00Z"}
{"event_id": "O0141-created", "order_id": "O0141", "hub": "Westhill", "service": "standard", "kind": "created", "happened_at": "2026-09-08T10:00:00Z"}
{"event_id": "O0177-created", "order_id": "O0177", "hub": "Westhill", "service": "express", "kind": "created", "happened_at": "2026-09-08T10:00:00Z"}
{"event_id": "O0201-created", "order_id": "O0201", "hub": "Southbay", "service": "standard", "kind": "created", "happened_at": "2026-09-08T10:00:00Z"}
{"event_id": "O0007-delivered", "order_id": "O0007", "hub": "Harbour", "service": "standard", "kind": "delivered", "happened_at": "2026-09-08T10:30:00Z"}
{"event_id": "O0067-delivered", "order_id": "O0067", "hub": "Eastgate", "service": "standard", "kind": "delivered", "happened_at": "2026-09-08T10:30:00Z"}
{"event_id": "O0187-delivered", "order_id": "O0187", "hub": "Southbay", "service": "standard", "kind": "delivered", "happened_at": "2026-09-08T10:30:00Z"}
{"event_id": "O0200-delivered", "order_id": "O0200", "hub": "Southbay", "service": "standard", "kind": "delivered", "happened_at": "2026-09-08T10:50:00Z"}
{"event_id": "O0021-picked_up", "order_id": "O0021", "hub": "Harbour", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-08T12:00:00Z"}
{"event_id": "O0101-picked_up", "order_id": "O0101", "hub": "Eastgate", "service": "express", "kind": "picked_up", "happened_at": "2026-09-08T12:00:00Z"}
{"event_id": "O0141-picked_up", "order_id": "O0141", "hub": "Westhill", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-08T12:00:00Z"}
{"event_id": "O0177-picked_up", "order_id": "O0177", "hub": "Westhill", "service": "express", "kind": "picked_up", "happened_at": "2026-09-08T12:00:00Z"}
{"event_id": "O0201-picked_up", "order_id": "O0201", "hub": "Southbay", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-08T12:00:00Z"}
{"event_id": "O0008-created", "order_id": "O0008", "hub": "Harbour", "service": "standard", "kind": "created", "happened_at": "2026-09-08T13:00:00Z"}
{"event_id": "O0048-created", "order_id": "O0048", "hub": "Harbour", "service": "express", "kind": "created", "happened_at": "2026-09-08T13:00:00Z"}
{"event_id": "O0068-created", "order_id": "O0068", "hub": "Eastgate", "service": "standard", "kind": "created", "happened_at": "2026-09-08T13:00:00Z"}
{"event_id": "O0088-created", "order_id": "O0088", "hub": "Eastgate", "service": "express", "kind": "created", "happened_at": "2026-09-08T13:00:00Z"}
{"event_id": "O0128-created", "order_id": "O0128", "hub": "Westhill", "service": "standard", "kind": "created", "happened_at": "2026-09-08T13:00:00Z"}
{"event_id": "O0164-created", "order_id": "O0164", "hub": "Westhill", "service": "express", "kind": "created", "happened_at": "2026-09-08T13:00:00Z"}
{"event_id": "O0188-created", "order_id": "O0188", "hub": "Southbay", "service": "standard", "kind": "created", "happened_at": "2026-09-08T13:00:00Z"}
{"event_id": "O0127-delivered", "order_id": "O0127", "hub": "Westhill", "service": "standard", "kind": "delivered", "happened_at": "2026-09-08T13:30:00Z"}
{"event_id": "O0008-picked_up", "order_id": "O0008", "hub": "Harbour", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-08T15:00:00Z"}
{"event_id": "O0048-picked_up", "order_id": "O0048", "hub": "Harbour", "service": "express", "kind": "picked_up", "happened_at": "2026-09-08T15:00:00Z"}
{"event_id": "O0068-picked_up", "order_id": "O0068", "hub": "Eastgate", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-08T15:00:00Z"}
{"event_id": "O0088-picked_up", "order_id": "O0088", "hub": "Eastgate", "service": "express", "kind": "picked_up", "happened_at": "2026-09-08T15:00:00Z"}
{"event_id": "O0128-picked_up", "order_id": "O0128", "hub": "Westhill", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-08T15:00:00Z"}
{"event_id": "O0164-picked_up", "order_id": "O0164", "hub": "Westhill", "service": "express", "kind": "picked_up", "happened_at": "2026-09-08T15:00:00Z"}
{"event_id": "O0188-picked_up", "order_id": "O0188", "hub": "Southbay", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-08T15:00:00Z"}
{"event_id": "O0114-delivered", "order_id": "O0114", "hub": "Eastgate", "service": "express", "kind": "delivered", "happened_at": "2026-09-08T16:10:00Z"}
{"event_id": "O0101-delivered", "order_id": "O0101", "hub": "Eastgate", "service": "express", "kind": "delivered", "happened_at": "2026-09-08T16:30:00Z"}
{"event_id": "O0164-delivered", "order_id": "O0164", "hub": "Westhill", "service": "express", "kind": "delivered", "happened_at": "2026-09-08T19:30:00Z"}
{"event_id": "O0177-delivered", "order_id": "O0177", "hub": "Westhill", "service": "express", "kind": "delivered", "happened_at": "2026-09-08T19:30:00Z"}
{"event_id": "O0048-delivered", "order_id": "O0048", "hub": "Harbour", "service": "express", "kind": "delivered", "happened_at": "2026-09-08T21:50:00Z"}
{"event_id": "O0088-delivered", "order_id": "O0088", "hub": "Eastgate", "service": "express", "kind": "delivered", "happened_at": "2026-09-08T22:10:00Z"}
{"event_id": "O0034-delivered", "order_id": "O0034", "hub": "Harbour", "service": "standard", "kind": "delivered", "happened_at": "2026-09-09T05:30:00Z"}
{"event_id": "O0154-delivered", "order_id": "O0154", "hub": "Westhill", "service": "standard", "kind": "delivered", "happened_at": "2026-09-09T05:30:00Z"}
{"event_id": "O0009-created", "order_id": "O0009", "hub": "Harbour", "service": "standard", "kind": "created", "happened_at": "2026-09-09T06:00:00Z"}
{"event_id": "O0049-created", "order_id": "O0049", "hub": "Harbour", "service": "express", "kind": "created", "happened_at": "2026-09-09T06:00:00Z"}
{"event_id": "O0069-created", "order_id": "O0069", "hub": "Eastgate", "service": "standard", "kind": "created", "happened_at": "2026-09-09T06:00:00Z"}
{"event_id": "O0089-created", "order_id": "O0089", "hub": "Eastgate", "service": "express", "kind": "created", "happened_at": "2026-09-09T06:00:00Z"}
{"event_id": "O0129-created", "order_id": "O0129", "hub": "Westhill", "service": "standard", "kind": "created", "happened_at": "2026-09-09T06:00:00Z"}
{"event_id": "O0165-created", "order_id": "O0165", "hub": "Westhill", "service": "express", "kind": "created", "happened_at": "2026-09-09T06:00:00Z"}
{"event_id": "O0189-created", "order_id": "O0189", "hub": "Southbay", "service": "standard", "kind": "created", "happened_at": "2026-09-09T06:00:00Z"}
{"event_id": "O0009-picked_up", "order_id": "O0009", "hub": "Harbour", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-09T08:00:00Z"}
{"event_id": "O0035-created", "order_id": "O0035", "hub": "Harbour", "service": "standard", "kind": "created", "happened_at": "2026-09-09T08:00:00Z"}
{"event_id": "O0049-picked_up", "order_id": "O0049", "hub": "Harbour", "service": "express", "kind": "picked_up", "happened_at": "2026-09-09T08:00:00Z"}
{"event_id": "O0069-picked_up", "order_id": "O0069", "hub": "Eastgate", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-09T08:00:00Z"}
{"event_id": "O0089-picked_up", "order_id": "O0089", "hub": "Eastgate", "service": "express", "kind": "picked_up", "happened_at": "2026-09-09T08:00:00Z"}
{"event_id": "O0115-created", "order_id": "O0115", "hub": "Eastgate", "service": "express", "kind": "created", "happened_at": "2026-09-09T08:00:00Z"}
{"event_id": "O0129-picked_up", "order_id": "O0129", "hub": "Westhill", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-09T08:00:00Z"}
{"event_id": "O0155-created", "order_id": "O0155", "hub": "Westhill", "service": "standard", "kind": "created", "happened_at": "2026-09-09T08:00:00Z"}
{"event_id": "O0165-picked_up", "order_id": "O0165", "hub": "Westhill", "service": "express", "kind": "picked_up", "happened_at": "2026-09-09T08:00:00Z"}
{"event_id": "O0189-picked_up", "order_id": "O0189", "hub": "Southbay", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-09T08:00:00Z"}
{"event_id": "O0021-delivered", "order_id": "O0021", "hub": "Harbour", "service": "standard", "kind": "delivered", "happened_at": "2026-09-09T08:30:00Z"}
{"event_id": "O0141-delivered", "order_id": "O0141", "hub": "Westhill", "service": "standard", "kind": "delivered", "happened_at": "2026-09-09T08:30:00Z"}
{"event_id": "O0201-delivered", "order_id": "O0201", "hub": "Southbay", "service": "standard", "kind": "delivered", "happened_at": "2026-09-09T08:30:00Z"}
{"event_id": "O0035-picked_up", "order_id": "O0035", "hub": "Harbour", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-09T10:00:00Z"}
{"event_id": "O0115-picked_up", "order_id": "O0115", "hub": "Eastgate", "service": "express", "kind": "picked_up", "happened_at": "2026-09-09T10:00:00Z"}
{"event_id": "O0155-picked_up", "order_id": "O0155", "hub": "Westhill", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-09T10:00:00Z"}
{"event_id": "O0022-created", "order_id": "O0022", "hub": "Harbour", "service": "standard", "kind": "created", "happened_at": "2026-09-09T11:00:00Z"}
{"event_id": "O0102-created", "order_id": "O0102", "hub": "Eastgate", "service": "express", "kind": "created", "happened_at": "2026-09-09T11:00:00Z"}
{"event_id": "O0142-created", "order_id": "O0142", "hub": "Westhill", "service": "standard", "kind": "created", "happened_at": "2026-09-09T11:00:00Z"}
{"event_id": "O0178-created", "order_id": "O0178", "hub": "Westhill", "service": "express", "kind": "created", "happened_at": "2026-09-09T11:00:00Z"}
{"event_id": "O0202-created", "order_id": "O0202", "hub": "Southbay", "service": "standard", "kind": "created", "happened_at": "2026-09-09T11:00:00Z"}
{"event_id": "O0068-delivered", "order_id": "O0068", "hub": "Eastgate", "service": "standard", "kind": "delivered", "happened_at": "2026-09-09T11:30:00Z"}
{"event_id": "O0128-delivered", "order_id": "O0128", "hub": "Westhill", "service": "standard", "kind": "delivered", "happened_at": "2026-09-09T11:30:00Z"}
{"event_id": "O0089-delivered", "order_id": "O0089", "hub": "Eastgate", "service": "express", "kind": "delivered", "happened_at": "2026-09-09T12:30:00Z"}
{"event_id": "O0022-picked_up", "order_id": "O0022", "hub": "Harbour", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-09T13:00:00Z"}
{"event_id": "O0102-picked_up", "order_id": "O0102", "hub": "Eastgate", "service": "express", "kind": "picked_up", "happened_at": "2026-09-09T13:00:00Z"}
{"event_id": "O0142-picked_up", "order_id": "O0142", "hub": "Westhill", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-09T13:00:00Z"}
{"event_id": "O0178-picked_up", "order_id": "O0178", "hub": "Westhill", "service": "express", "kind": "picked_up", "happened_at": "2026-09-09T13:00:00Z"}
{"event_id": "O0202-picked_up", "order_id": "O0202", "hub": "Southbay", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-09T13:00:00Z"}
{"event_id": "O0008-delivered", "order_id": "O0008", "hub": "Harbour", "service": "standard", "kind": "delivered", "happened_at": "2026-09-09T13:50:00Z"}
{"event_id": "O0049-delivered", "order_id": "O0049", "hub": "Harbour", "service": "express", "kind": "delivered", "happened_at": "2026-09-09T14:50:00Z"}
{"event_id": "O0188-delivered", "order_id": "O0188", "hub": "Southbay", "service": "standard", "kind": "delivered", "happened_at": "2026-09-09T14:50:00Z"}
{"event_id": "O0165-delivered", "order_id": "O0165", "hub": "Westhill", "service": "express", "kind": "delivered", "happened_at": "2026-09-09T15:30:00Z"}
{"event_id": "O0102-delivered", "order_id": "O0102", "hub": "Eastgate", "service": "express", "kind": "delivered", "happened_at": "2026-09-09T20:10:00Z"}
{"event_id": "O0178-delivered", "order_id": "O0178", "hub": "Westhill", "service": "express", "kind": "delivered", "happened_at": "2026-09-09T20:30:00Z"}
{"event_id": "O0009-delivered", "order_id": "O0009", "hub": "Harbour", "service": "standard", "kind": "delivered", "happened_at": "2026-09-10T04:30:00Z"}
{"event_id": "O0069-delivered", "order_id": "O0069", "hub": "Eastgate", "service": "standard", "kind": "delivered", "happened_at": "2026-09-10T04:30:00Z"}
{"event_id": "O0129-delivered", "order_id": "O0129", "hub": "Westhill", "service": "standard", "kind": "delivered", "happened_at": "2026-09-10T04:30:00Z"}
{"event_id": "O0189-delivered", "order_id": "O0189", "hub": "Southbay", "service": "standard", "kind": "delivered", "happened_at": "2026-09-10T04:30:00Z"}
{"event_id": "O0010-created", "order_id": "O0010", "hub": "Harbour", "service": "standard", "kind": "created", "happened_at": "2026-09-10T07:00:00Z"}
{"event_id": "O0050-created", "order_id": "O0050", "hub": "Harbour", "service": "express", "kind": "created", "happened_at": "2026-09-10T07:00:00Z"}
{"event_id": "O0070-created", "order_id": "O0070", "hub": "Eastgate", "service": "standard", "kind": "created", "happened_at": "2026-09-10T07:00:00Z"}
{"event_id": "O0090-created", "order_id": "O0090", "hub": "Eastgate", "service": "express", "kind": "created", "happened_at": "2026-09-10T07:00:00Z"}
{"event_id": "O0130-created", "order_id": "O0130", "hub": "Westhill", "service": "standard", "kind": "created", "happened_at": "2026-09-10T07:00:00Z"}
{"event_id": "O0166-created", "order_id": "O0166", "hub": "Westhill", "service": "express", "kind": "created", "happened_at": "2026-09-10T07:00:00Z"}
{"event_id": "O0190-created", "order_id": "O0190", "hub": "Southbay", "service": "standard", "kind": "created", "happened_at": "2026-09-10T07:00:00Z"}
{"event_id": "O0010-picked_up", "order_id": "O0010", "hub": "Harbour", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-10T09:00:00Z"}
{"event_id": "O0036-created", "order_id": "O0036", "hub": "Harbour", "service": "standard", "kind": "created", "happened_at": "2026-09-10T09:00:00Z"}
{"event_id": "O0050-picked_up", "order_id": "O0050", "hub": "Harbour", "service": "express", "kind": "picked_up", "happened_at": "2026-09-10T09:00:00Z"}
{"event_id": "O0070-picked_up", "order_id": "O0070", "hub": "Eastgate", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-10T09:00:00Z"}
{"event_id": "O0090-picked_up", "order_id": "O0090", "hub": "Eastgate", "service": "express", "kind": "picked_up", "happened_at": "2026-09-10T09:00:00Z"}
{"event_id": "O0116-created", "order_id": "O0116", "hub": "Eastgate", "service": "express", "kind": "created", "happened_at": "2026-09-10T09:00:00Z"}
{"event_id": "O0130-picked_up", "order_id": "O0130", "hub": "Westhill", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-10T09:00:00Z"}
{"event_id": "O0166-picked_up", "order_id": "O0166", "hub": "Westhill", "service": "express", "kind": "picked_up", "happened_at": "2026-09-10T09:00:00Z"}
{"event_id": "O0190-picked_up", "order_id": "O0190", "hub": "Southbay", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-10T09:00:00Z"}
{"event_id": "O0022-delivered", "order_id": "O0022", "hub": "Harbour", "service": "standard", "kind": "delivered", "happened_at": "2026-09-10T09:30:00Z"}
{"event_id": "O0202-delivered", "order_id": "O0202", "hub": "Southbay", "service": "standard", "kind": "delivered", "happened_at": "2026-09-10T09:30:00Z"}
{"event_id": "O0036-picked_up", "order_id": "O0036", "hub": "Harbour", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-10T11:00:00Z"}
{"event_id": "O0116-picked_up", "order_id": "O0116", "hub": "Eastgate", "service": "express", "kind": "picked_up", "happened_at": "2026-09-10T11:00:00Z"}
{"event_id": "O0023-created", "order_id": "O0023", "hub": "Harbour", "service": "standard", "kind": "created", "happened_at": "2026-09-10T12:00:00Z"}
{"event_id": "O0103-created", "order_id": "O0103", "hub": "Eastgate", "service": "express", "kind": "created", "happened_at": "2026-09-10T12:00:00Z"}
{"event_id": "O0143-created", "order_id": "O0143", "hub": "Westhill", "service": "standard", "kind": "created", "happened_at": "2026-09-10T12:00:00Z"}
{"event_id": "O0179-created", "order_id": "O0179", "hub": "Westhill", "service": "express", "kind": "created", "happened_at": "2026-09-10T12:00:00Z"}
{"event_id": "O0203-created", "order_id": "O0203", "hub": "Southbay", "service": "standard", "kind": "created", "happened_at": "2026-09-10T12:00:00Z"}
{"event_id": "O0142-delivered", "order_id": "O0142", "hub": "Westhill", "service": "standard", "kind": "delivered", "happened_at": "2026-09-10T12:30:00Z"}
{"event_id": "O0023-picked_up", "order_id": "O0023", "hub": "Harbour", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-10T14:00:00Z"}
{"event_id": "O0103-picked_up", "order_id": "O0103", "hub": "Eastgate", "service": "express", "kind": "picked_up", "happened_at": "2026-09-10T14:00:00Z"}
{"event_id": "O0143-picked_up", "order_id": "O0143", "hub": "Westhill", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-10T14:00:00Z"}
{"event_id": "O0179-picked_up", "order_id": "O0179", "hub": "Westhill", "service": "express", "kind": "picked_up", "happened_at": "2026-09-10T14:00:00Z"}
{"event_id": "O0203-picked_up", "order_id": "O0203", "hub": "Southbay", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-10T14:00:00Z"}
{"event_id": "O0116-delivered", "order_id": "O0116", "hub": "Eastgate", "service": "express", "kind": "delivered", "happened_at": "2026-09-10T15:30:00Z"}
{"event_id": "O0050-delivered", "order_id": "O0050", "hub": "Harbour", "service": "express", "kind": "delivered", "happened_at": "2026-09-10T15:50:00Z"}
{"event_id": "O0090-delivered", "order_id": "O0090", "hub": "Eastgate", "service": "express", "kind": "delivered", "happened_at": "2026-09-10T16:10:00Z"}
{"event_id": "O0166-delivered", "order_id": "O0166", "hub": "Westhill", "service": "express", "kind": "delivered", "happened_at": "2026-09-10T16:30:00Z"}
{"event_id": "O0179-delivered", "order_id": "O0179", "hub": "Westhill", "service": "express", "kind": "delivered", "happened_at": "2026-09-10T18:30:00Z"}
{"event_id": "O0103-delivered", "order_id": "O0103", "hub": "Eastgate", "service": "express", "kind": "delivered", "happened_at": "2026-09-10T21:10:00Z"}
{"event_id": "O0010-delivered", "order_id": "O0010", "hub": "Harbour", "service": "standard", "kind": "delivered", "happened_at": "2026-09-11T05:30:00Z"}
{"event_id": "O0130-delivered", "order_id": "O0130", "hub": "Westhill", "service": "standard", "kind": "delivered", "happened_at": "2026-09-11T05:30:00Z"}
{"event_id": "O0190-delivered", "order_id": "O0190", "hub": "Southbay", "service": "standard", "kind": "delivered", "happened_at": "2026-09-11T05:30:00Z"}
{"event_id": "O0036-delivered", "order_id": "O0036", "hub": "Harbour", "service": "standard", "kind": "delivered", "happened_at": "2026-09-11T07:30:00Z"}
{"event_id": "O0011-created", "order_id": "O0011", "hub": "Harbour", "service": "standard", "kind": "created", "happened_at": "2026-09-11T08:00:00Z"}
{"event_id": "O0051-created", "order_id": "O0051", "hub": "Harbour", "service": "express", "kind": "created", "happened_at": "2026-09-11T08:00:00Z"}
{"event_id": "O0071-created", "order_id": "O0071", "hub": "Eastgate", "service": "standard", "kind": "created", "happened_at": "2026-09-11T08:00:00Z"}
{"event_id": "O0091-created", "order_id": "O0091", "hub": "Eastgate", "service": "express", "kind": "created", "happened_at": "2026-09-11T08:00:00Z"}
{"event_id": "O0131-created", "order_id": "O0131", "hub": "Westhill", "service": "standard", "kind": "created", "happened_at": "2026-09-11T08:00:00Z"}
{"event_id": "O0167-created", "order_id": "O0167", "hub": "Westhill", "service": "express", "kind": "created", "happened_at": "2026-09-11T08:00:00Z"}
{"event_id": "O0191-created", "order_id": "O0191", "hub": "Southbay", "service": "standard", "kind": "created", "happened_at": "2026-09-11T08:00:00Z"}
{"event_id": "O0070-delivered", "order_id": "O0070", "hub": "Eastgate", "service": "standard", "kind": "delivered", "happened_at": "2026-09-11T08:10:00Z"}
{"event_id": "O0011-picked_up", "order_id": "O0011", "hub": "Harbour", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-11T10:00:00Z"}
{"event_id": "O0037-created", "order_id": "O0037", "hub": "Harbour", "service": "standard", "kind": "created", "happened_at": "2026-09-11T10:00:00Z"}
{"event_id": "O0051-picked_up", "order_id": "O0051", "hub": "Harbour", "service": "express", "kind": "picked_up", "happened_at": "2026-09-11T10:00:00Z"}
{"event_id": "O0071-picked_up", "order_id": "O0071", "hub": "Eastgate", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-11T10:00:00Z"}
{"event_id": "O0091-picked_up", "order_id": "O0091", "hub": "Eastgate", "service": "express", "kind": "picked_up", "happened_at": "2026-09-11T10:00:00Z"}
{"event_id": "O0117-created", "order_id": "O0117", "hub": "Eastgate", "service": "express", "kind": "created", "happened_at": "2026-09-11T10:00:00Z"}
{"event_id": "O0131-picked_up", "order_id": "O0131", "hub": "Westhill", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-11T10:00:00Z"}
{"event_id": "O0167-picked_up", "order_id": "O0167", "hub": "Westhill", "service": "express", "kind": "picked_up", "happened_at": "2026-09-11T10:00:00Z"}
{"event_id": "O0191-picked_up", "order_id": "O0191", "hub": "Southbay", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-11T10:00:00Z"}
{"event_id": "O0143-delivered", "order_id": "O0143", "hub": "Westhill", "service": "standard", "kind": "delivered", "happened_at": "2026-09-11T10:30:00Z"}
{"event_id": "O0203-delivered", "order_id": "O0203", "hub": "Southbay", "service": "standard", "kind": "delivered", "happened_at": "2026-09-11T10:30:00Z"}
{"event_id": "O0037-picked_up", "order_id": "O0037", "hub": "Harbour", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-11T12:00:00Z"}
{"event_id": "O0117-picked_up", "order_id": "O0117", "hub": "Eastgate", "service": "express", "kind": "picked_up", "happened_at": "2026-09-11T12:00:00Z"}
{"event_id": "O0023-delivered", "order_id": "O0023", "hub": "Harbour", "service": "standard", "kind": "delivered", "happened_at": "2026-09-11T12:50:00Z"}
{"event_id": "O0024-created", "order_id": "O0024", "hub": "Harbour", "service": "standard", "kind": "created", "happened_at": "2026-09-11T13:00:00Z"}
{"event_id": "O0104-created", "order_id": "O0104", "hub": "Eastgate", "service": "express", "kind": "created", "happened_at": "2026-09-11T13:00:00Z"}
{"event_id": "O0144-created", "order_id": "O0144", "hub": "Westhill", "service": "standard", "kind": "created", "happened_at": "2026-09-11T13:00:00Z"}
{"event_id": "O0204-created", "order_id": "O0204", "hub": "Southbay", "service": "standard", "kind": "created", "happened_at": "2026-09-11T13:00:00Z"}
{"event_id": "O0167-delivered", "order_id": "O0167", "hub": "Westhill", "service": "express", "kind": "delivered", "happened_at": "2026-09-11T14:30:00Z"}
{"event_id": "O0024-picked_up", "order_id": "O0024", "hub": "Harbour", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-11T15:00:00Z"}
{"event_id": "O0104-picked_up", "order_id": "O0104", "hub": "Eastgate", "service": "express", "kind": "picked_up", "happened_at": "2026-09-11T15:00:00Z"}
{"event_id": "O0144-picked_up", "order_id": "O0144", "hub": "Westhill", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-11T15:00:00Z"}
{"event_id": "O0204-picked_up", "order_id": "O0204", "hub": "Southbay", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-11T15:00:00Z"}
{"event_id": "O0051-delivered", "order_id": "O0051", "hub": "Harbour", "service": "express", "kind": "delivered", "happened_at": "2026-09-11T16:50:00Z"}
{"event_id": "O0091-delivered", "order_id": "O0091", "hub": "Eastgate", "service": "express", "kind": "delivered", "happened_at": "2026-09-11T17:10:00Z"}
{"event_id": "O0117-delivered", "order_id": "O0117", "hub": "Eastgate", "service": "express", "kind": "delivered", "happened_at": "2026-09-11T19:10:00Z"}
{"event_id": "O0104-delivered", "order_id": "O0104", "hub": "Eastgate", "service": "express", "kind": "delivered", "happened_at": "2026-09-11T19:30:00Z"}
{"event_id": "O0025-created", "order_id": "O0025", "hub": "Harbour", "service": "standard", "kind": "created", "happened_at": "2026-09-12T06:00:00Z"}
{"event_id": "O0105-created", "order_id": "O0105", "hub": "Eastgate", "service": "express", "kind": "created", "happened_at": "2026-09-12T06:00:00Z"}
{"event_id": "O0145-created", "order_id": "O0145", "hub": "Westhill", "service": "standard", "kind": "created", "happened_at": "2026-09-12T06:00:00Z"}
{"event_id": "O0205-created", "order_id": "O0205", "hub": "Southbay", "service": "standard", "kind": "created", "happened_at": "2026-09-12T06:00:00Z"}
{"event_id": "O0071-delivered", "order_id": "O0071", "hub": "Eastgate", "service": "standard", "kind": "delivered", "happened_at": "2026-09-12T06:30:00Z"}
{"event_id": "O0131-delivered", "order_id": "O0131", "hub": "Westhill", "service": "standard", "kind": "delivered", "happened_at": "2026-09-12T06:30:00Z"}
{"event_id": "O0191-delivered", "order_id": "O0191", "hub": "Southbay", "service": "standard", "kind": "delivered", "happened_at": "2026-09-12T06:30:00Z"}
{"event_id": "O0025-picked_up", "order_id": "O0025", "hub": "Harbour", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-12T08:00:00Z"}
{"event_id": "O0105-picked_up", "order_id": "O0105", "hub": "Eastgate", "service": "express", "kind": "picked_up", "happened_at": "2026-09-12T08:00:00Z"}
{"event_id": "O0145-picked_up", "order_id": "O0145", "hub": "Westhill", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-12T08:00:00Z"}
{"event_id": "O0205-picked_up", "order_id": "O0205", "hub": "Southbay", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-12T08:00:00Z"}
{"event_id": "O0037-delivered", "order_id": "O0037", "hub": "Harbour", "service": "standard", "kind": "delivered", "happened_at": "2026-09-12T08:30:00Z"}
{"event_id": "O0011-delivered", "order_id": "O0011", "hub": "Harbour", "service": "standard", "kind": "delivered", "happened_at": "2026-09-12T08:50:00Z"}
{"event_id": "O0012-created", "order_id": "O0012", "hub": "Harbour", "service": "standard", "kind": "created", "happened_at": "2026-09-12T09:00:00Z"}
{"event_id": "O0052-created", "order_id": "O0052", "hub": "Harbour", "service": "express", "kind": "created", "happened_at": "2026-09-12T09:00:00Z"}
{"event_id": "O0072-created", "order_id": "O0072", "hub": "Eastgate", "service": "standard", "kind": "created", "happened_at": "2026-09-12T09:00:00Z"}
{"event_id": "O0092-created", "order_id": "O0092", "hub": "Eastgate", "service": "express", "kind": "created", "happened_at": "2026-09-12T09:00:00Z"}
{"event_id": "O0132-created", "order_id": "O0132", "hub": "Westhill", "service": "standard", "kind": "created", "happened_at": "2026-09-12T09:00:00Z"}
{"event_id": "O0168-created", "order_id": "O0168", "hub": "Westhill", "service": "express", "kind": "created", "happened_at": "2026-09-12T09:00:00Z"}
{"event_id": "O0192-created", "order_id": "O0192", "hub": "Southbay", "service": "standard", "kind": "created", "happened_at": "2026-09-12T09:00:00Z"}
{"event_id": "O0012-picked_up", "order_id": "O0012", "hub": "Harbour", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-12T11:00:00Z"}
{"event_id": "O0038-created", "order_id": "O0038", "hub": "Harbour", "service": "standard", "kind": "created", "happened_at": "2026-09-12T11:00:00Z"}
{"event_id": "O0052-picked_up", "order_id": "O0052", "hub": "Harbour", "service": "express", "kind": "picked_up", "happened_at": "2026-09-12T11:00:00Z"}
{"event_id": "O0072-picked_up", "order_id": "O0072", "hub": "Eastgate", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-12T11:00:00Z"}
{"event_id": "O0092-picked_up", "order_id": "O0092", "hub": "Eastgate", "service": "express", "kind": "picked_up", "happened_at": "2026-09-12T11:00:00Z"}
{"event_id": "O0118-created", "order_id": "O0118", "hub": "Eastgate", "service": "express", "kind": "created", "happened_at": "2026-09-12T11:00:00Z"}
{"event_id": "O0132-picked_up", "order_id": "O0132", "hub": "Westhill", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-12T11:00:00Z"}
{"event_id": "O0168-picked_up", "order_id": "O0168", "hub": "Westhill", "service": "express", "kind": "picked_up", "happened_at": "2026-09-12T11:00:00Z"}
{"event_id": "O0192-picked_up", "order_id": "O0192", "hub": "Southbay", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-12T11:00:00Z"}
{"event_id": "O0024-delivered", "order_id": "O0024", "hub": "Harbour", "service": "standard", "kind": "delivered", "happened_at": "2026-09-12T11:30:00Z"}
{"event_id": "O0144-delivered", "order_id": "O0144", "hub": "Westhill", "service": "standard", "kind": "delivered", "happened_at": "2026-09-12T11:30:00Z"}
{"event_id": "O0204-delivered", "order_id": "O0204", "hub": "Southbay", "service": "standard", "kind": "delivered", "happened_at": "2026-09-12T11:30:00Z"}
{"event_id": "O0038-picked_up", "order_id": "O0038", "hub": "Harbour", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-12T13:00:00Z"}
{"event_id": "O0118-picked_up", "order_id": "O0118", "hub": "Eastgate", "service": "express", "kind": "picked_up", "happened_at": "2026-09-12T13:00:00Z"}
{"event_id": "O0105-delivered", "order_id": "O0105", "hub": "Eastgate", "service": "express", "kind": "delivered", "happened_at": "2026-09-12T15:10:00Z"}
{"event_id": "O0092-delivered", "order_id": "O0092", "hub": "Eastgate", "service": "express", "kind": "delivered", "happened_at": "2026-09-12T15:30:00Z"}
{"event_id": "O0168-delivered", "order_id": "O0168", "hub": "Westhill", "service": "express", "kind": "delivered", "happened_at": "2026-09-12T15:30:00Z"}
{"event_id": "O0052-delivered", "order_id": "O0052", "hub": "Harbour", "service": "express", "kind": "delivered", "happened_at": "2026-09-12T17:50:00Z"}
{"event_id": "O0118-delivered", "order_id": "O0118", "hub": "Eastgate", "service": "express", "kind": "delivered", "happened_at": "2026-09-12T20:10:00Z"}
{"event_id": "O0025-delivered", "order_id": "O0025", "hub": "Harbour", "service": "standard", "kind": "delivered", "happened_at": "2026-09-13T04:30:00Z"}
{"event_id": "O0145-delivered", "order_id": "O0145", "hub": "Westhill", "service": "standard", "kind": "delivered", "happened_at": "2026-09-13T04:30:00Z"}
{"event_id": "O0205-delivered", "order_id": "O0205", "hub": "Southbay", "service": "standard", "kind": "delivered", "happened_at": "2026-09-13T04:30:00Z"}
{"event_id": "O0026-created", "order_id": "O0026", "hub": "Harbour", "service": "standard", "kind": "created", "happened_at": "2026-09-13T07:00:00Z"}
{"event_id": "O0106-created", "order_id": "O0106", "hub": "Eastgate", "service": "express", "kind": "created", "happened_at": "2026-09-13T07:00:00Z"}
{"event_id": "O0146-created", "order_id": "O0146", "hub": "Westhill", "service": "standard", "kind": "created", "happened_at": "2026-09-13T07:00:00Z"}
{"event_id": "O0206-created", "order_id": "O0206", "hub": "Southbay", "service": "standard", "kind": "created", "happened_at": "2026-09-13T07:00:00Z"}
{"event_id": "O0012-delivered", "order_id": "O0012", "hub": "Harbour", "service": "standard", "kind": "delivered", "happened_at": "2026-09-13T07:30:00Z"}
{"event_id": "O0072-delivered", "order_id": "O0072", "hub": "Eastgate", "service": "standard", "kind": "delivered", "happened_at": "2026-09-13T07:30:00Z"}
{"event_id": "O0192-delivered", "order_id": "O0192", "hub": "Southbay", "service": "standard", "kind": "delivered", "happened_at": "2026-09-13T07:30:00Z"}
{"event_id": "O0026-picked_up", "order_id": "O0026", "hub": "Harbour", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-13T09:00:00Z"}
{"event_id": "O0106-picked_up", "order_id": "O0106", "hub": "Eastgate", "service": "express", "kind": "picked_up", "happened_at": "2026-09-13T09:00:00Z"}
{"event_id": "O0146-picked_up", "order_id": "O0146", "hub": "Westhill", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-13T09:00:00Z"}
{"event_id": "O0206-picked_up", "order_id": "O0206", "hub": "Southbay", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-13T09:00:00Z"}
{"event_id": "O0013-created", "order_id": "O0013", "hub": "Harbour", "service": "standard", "kind": "created", "happened_at": "2026-09-13T10:00:00Z"}
{"event_id": "O0053-created", "order_id": "O0053", "hub": "Harbour", "service": "express", "kind": "created", "happened_at": "2026-09-13T10:00:00Z"}
{"event_id": "O0073-created", "order_id": "O0073", "hub": "Eastgate", "service": "standard", "kind": "created", "happened_at": "2026-09-13T10:00:00Z"}
{"event_id": "O0093-created", "order_id": "O0093", "hub": "Eastgate", "service": "express", "kind": "created", "happened_at": "2026-09-13T10:00:00Z"}
{"event_id": "O0133-created", "order_id": "O0133", "hub": "Westhill", "service": "standard", "kind": "created", "happened_at": "2026-09-13T10:00:00Z"}
{"event_id": "O0169-created", "order_id": "O0169", "hub": "Westhill", "service": "express", "kind": "created", "happened_at": "2026-09-13T10:00:00Z"}
{"event_id": "O0193-created", "order_id": "O0193", "hub": "Southbay", "service": "standard", "kind": "created", "happened_at": "2026-09-13T10:00:00Z"}
{"event_id": "O0132-delivered", "order_id": "O0132", "hub": "Westhill", "service": "standard", "kind": "delivered", "happened_at": "2026-09-13T10:30:00Z"}
{"event_id": "O0038-delivered", "order_id": "O0038", "hub": "Harbour", "service": "standard", "kind": "delivered", "happened_at": "2026-09-13T11:50:00Z"}
{"event_id": "O0013-picked_up", "order_id": "O0013", "hub": "Harbour", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-13T12:00:00Z"}
{"event_id": "O0039-created", "order_id": "O0039", "hub": "Harbour", "service": "standard", "kind": "created", "happened_at": "2026-09-13T12:00:00Z"}
{"event_id": "O0053-picked_up", "order_id": "O0053", "hub": "Harbour", "service": "express", "kind": "picked_up", "happened_at": "2026-09-13T12:00:00Z"}
{"event_id": "O0073-picked_up", "order_id": "O0073", "hub": "Eastgate", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-13T12:00:00Z"}
{"event_id": "O0093-picked_up", "order_id": "O0093", "hub": "Eastgate", "service": "express", "kind": "picked_up", "happened_at": "2026-09-13T12:00:00Z"}
{"event_id": "O0119-created", "order_id": "O0119", "hub": "Eastgate", "service": "express", "kind": "created", "happened_at": "2026-09-13T12:00:00Z"}
{"event_id": "O0133-picked_up", "order_id": "O0133", "hub": "Westhill", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-13T12:00:00Z"}
{"event_id": "O0169-picked_up", "order_id": "O0169", "hub": "Westhill", "service": "express", "kind": "picked_up", "happened_at": "2026-09-13T12:00:00Z"}
{"event_id": "O0193-picked_up", "order_id": "O0193", "hub": "Southbay", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-13T12:00:00Z"}
{"event_id": "O0039-picked_up", "order_id": "O0039", "hub": "Harbour", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-13T14:00:00Z"}
{"event_id": "O0119-picked_up", "order_id": "O0119", "hub": "Eastgate", "service": "express", "kind": "picked_up", "happened_at": "2026-09-13T14:00:00Z"}
{"event_id": "O0106-delivered", "order_id": "O0106", "hub": "Eastgate", "service": "express", "kind": "delivered", "happened_at": "2026-09-13T16:10:00Z"}
{"event_id": "O0119-delivered", "order_id": "O0119", "hub": "Eastgate", "service": "express", "kind": "delivered", "happened_at": "2026-09-13T18:30:00Z"}
{"event_id": "O0053-delivered", "order_id": "O0053", "hub": "Harbour", "service": "express", "kind": "delivered", "happened_at": "2026-09-13T18:50:00Z"}
{"event_id": "O0093-delivered", "order_id": "O0093", "hub": "Eastgate", "service": "express", "kind": "delivered", "happened_at": "2026-09-13T19:10:00Z"}
{"event_id": "O0169-delivered", "order_id": "O0169", "hub": "Westhill", "service": "express", "kind": "delivered", "happened_at": "2026-09-13T19:30:00Z"}
{"event_id": "O0146-delivered", "order_id": "O0146", "hub": "Westhill", "service": "standard", "kind": "delivered", "happened_at": "2026-09-14T05:30:00Z"}
{"event_id": "O0026-delivered", "order_id": "O0026", "hub": "Harbour", "service": "standard", "kind": "delivered", "happened_at": "2026-09-14T07:50:00Z"}
{"event_id": "O0013-delivered", "order_id": "O0013", "hub": "Harbour", "service": "standard", "kind": "delivered", "happened_at": "2026-09-14T08:30:00Z"}
{"event_id": "O0073-delivered", "order_id": "O0073", "hub": "Eastgate", "service": "standard", "kind": "delivered", "happened_at": "2026-09-14T08:30:00Z"}
{"event_id": "O0133-delivered", "order_id": "O0133", "hub": "Westhill", "service": "standard", "kind": "delivered", "happened_at": "2026-09-14T08:30:00Z"}
{"event_id": "O0193-delivered", "order_id": "O0193", "hub": "Southbay", "service": "standard", "kind": "delivered", "happened_at": "2026-09-14T08:30:00Z"}
{"event_id": "O0206-delivered", "order_id": "O0206", "hub": "Southbay", "service": "standard", "kind": "delivered", "happened_at": "2026-09-14T08:50:00Z"}
{"event_id": "O0039-delivered", "order_id": "O0039", "hub": "Harbour", "service": "standard", "kind": "delivered", "happened_at": "2026-09-14T10:30:00Z"}
{"event_id": "O0040-created", "order_id": "O0040", "hub": "Harbour", "service": "standard", "kind": "created", "happened_at": "2026-09-14T21:00:00Z"}
{"event_id": "O0060-created", "order_id": "O0060", "hub": "Harbour", "service": "express", "kind": "created", "happened_at": "2026-09-14T21:00:00Z"}
{"event_id": "O0080-created", "order_id": "O0080", "hub": "Eastgate", "service": "standard", "kind": "created", "happened_at": "2026-09-14T21:00:00Z"}
{"event_id": "O0120-created", "order_id": "O0120", "hub": "Eastgate", "service": "express", "kind": "created", "happened_at": "2026-09-14T21:00:00Z"}
{"event_id": "O0156-created", "order_id": "O0156", "hub": "Westhill", "service": "standard", "kind": "created", "happened_at": "2026-09-14T21:00:00Z"}
{"event_id": "O0180-created", "order_id": "O0180", "hub": "Westhill", "service": "express", "kind": "created", "happened_at": "2026-09-14T21:00:00Z"}
{"event_id": "O0210-created", "order_id": "O0210", "hub": "Southbay", "service": "standard", "kind": "created", "happened_at": "2026-09-14T21:00:00Z"}
{"event_id": "O0216-created", "order_id": "O0216", "hub": "Southbay", "service": "express", "kind": "created", "happened_at": "2026-09-14T21:00:00Z"}
{"event_id": "O0210-cancelled", "order_id": "O0210", "hub": "Southbay", "service": "standard", "kind": "cancelled", "happened_at": "2026-09-14T22:00:00Z"}
{"event_id": "O0040-picked_up", "order_id": "O0040", "hub": "Harbour", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-14T23:00:00Z"}
{"event_id": "O0060-picked_up", "order_id": "O0060", "hub": "Harbour", "service": "express", "kind": "picked_up", "happened_at": "2026-09-14T23:00:00Z"}
{"event_id": "O0080-picked_up", "order_id": "O0080", "hub": "Eastgate", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-14T23:00:00Z"}
{"event_id": "O0120-picked_up", "order_id": "O0120", "hub": "Eastgate", "service": "express", "kind": "picked_up", "happened_at": "2026-09-14T23:00:00Z"}
{"event_id": "O0156-picked_up", "order_id": "O0156", "hub": "Westhill", "service": "standard", "kind": "picked_up", "happened_at": "2026-09-14T23:00:00Z"}
{"event_id": "O0180-picked_up", "order_id": "O0180", "hub": "Westhill", "service": "express", "kind": "picked_up", "happened_at": "2026-09-14T23:00:00Z"}
{"event_id": "O0216-picked_up", "order_id": "O0216", "hub": "Southbay", "service": "express", "kind": "picked_up", "happened_at": "2026-09-14T23:00:00Z"}
{"event_id": "O0180-delivered", "order_id": "O0180", "hub": "Westhill", "service": "express", "kind": "delivered", "happened_at": "2026-09-15T03:30:00Z"}
{"event_id": "O0060-delivered", "order_id": "O0060", "hub": "Harbour", "service": "express", "kind": "delivered", "happened_at": "2026-09-15T05:50:00Z"}
{"event_id": "O0120-delivered", "order_id": "O0120", "hub": "Eastgate", "service": "express", "kind": "delivered", "happened_at": "2026-09-15T06:10:00Z"}
{"event_id": "O0216-delivered", "order_id": "O0216", "hub": "Southbay", "service": "express", "kind": "delivered", "happened_at": "2026-09-15T06:50:00Z"}
{"event_id": "O0040-delivered", "order_id": "O0040", "hub": "Harbour", "service": "standard", "kind": "delivered", "happened_at": "2026-09-15T19:30:00Z"}
{"event_id": "O0080-delivered", "order_id": "O0080", "hub": "Eastgate", "service": "standard", "kind": "delivered", "happened_at": "2026-09-15T19:30:00Z"}
{"event_id": "O0156-delivered", "order_id": "O0156", "hub": "Westhill", "service": "standard", "kind": "delivered", "happened_at": "2026-09-15T19:30:00Z"}
learner/materials/data-dictionary.md Read the full fileDownload file

Data dictionary and decision rules

Assignment brief

You join the cold-chain fulfilment operations team. The operations lead needs to decide which orders and hubs to review first, where export controls failed, and what the next operations workbench must deliver. The four hubs are Harbour, Eastgate, Westhill and Southbay. Standard service promises delivery within 24 hours and express within 8 hours. Use the actual due_at value in orders.csv for each order.

The review cutoff is 2026-09-15T00:00:00Z, defined in rules.json. Convert every business timestamp to UTC. Records can contain events after the cutoff so that you can test whether a historical review accidentally uses future information.

Orders

One row in orders.csv is one order. order_id is a unique text identifier; keep its leading zeros. hub is the operating hub, service is standard or express, and route identifies the route. created_at and due_at are timezone-aware ISO 8601 timestamps. Counting event rows is not a valid way to count orders.

Event feeds and canonical schema

Feed A maps event_id to event_id, order_ref to order_id, hub to hub, service to service, event to kind, and event_time to happened_at.

Feed B maps id to event_id, shipment.number to order_id, shipment.station to hub, shipment.product to service, and at_ms to happened_at. at_ms is an integer Unix timestamp in milliseconds. Map OPEN, COLLECT, DROP and VOID to created, picked_up, delivered and cancelled respectively.

The canonical event contains event_id, order_id, hub, service, kind and happened_at. happened_at is UTC ISO 8601 with a Z suffix. Validate required fields, action names and dimensions. Reject timezone-free timestamps and non-integer epochs. Do not change the raw inputs.

Identical canonical content under the same event_id is an exact replay: retain one event and list every removed replay. Different content under one immutable event_id is a conflict: quarantine the entire group. Never accept the first arrival and silently overwrite it later. Keep the source filename, 1-based line number and reason for every rejected record or replay. Reconcile raw records = canonical events + quarantined records + removed replays.

Historical fulfilment cohort

Group events by order_id and retain only events with happened_at <= cutoff. A visible cancellation takes precedence and is excluded from the mature denominator. A non-cancelled order with due_at > cutoff is not_mature. Otherwise, no visible delivery means overdue_open; the first visible delivery after due_at means delivered_late; delivery at or before due_at means on_time. Exactly at the due timestamp is mature, and delivery exactly at that timestamp is on time.

Eligible mature orders = on_time + delivered_late + overdue_open. Late orders = delivered_late + overdue_open. Never classify cancellation or an order not yet due as successful delivery. Keep delivered lateness minutes (delivery minus due_at) separate from open overdue minutes (cutoff minus due_at). The inputs do not contain actual refunds, damaged-goods values or costs, so do not calculate those amounts.

Service review

The fixed late-rate target is 10%, and the minimum mature sample is 15 per hub/service cell. gap_pp = (late_rate - 0.10) * 100, measured in percentage points. Apply sample size first: below 15 is More data needed. A gap above 15 points is Priority review; above 5 and at most 15 is Review needed; at most 5 is Within threshold. These are operational triage rules, not a statistical finding of unfair treatment.

For a comparable service mix, give standard and express equal 50% weights. Calculate a hub's standardized late rate only when both service cells meet the minimum sample. Otherwise retain a missing value and state which cell is insufficient. Do not impute an overall mean or rank a small sample as the best hub. Separate observations, possible explanations and causal claims.

Access logs and policy

One access-log.csv row is one request. request_id is unique; at is UTC. user, session and role are gateway request context. method and path identify the resource; status is the response code; rows and bytes are gateway response counts. These counts do not prove unique customers, file retention or subsequent use.

access-policy.json defines the baseline. An operator can read only the assigned hub and cannot export. A supervisor or approved service role can export. A session lasts 30 minutes after a successful login: exactly 30 minutes is valid, and later requests must be rejected. Failed logins do not renew sessions. A 401 is a denied attempt, not confirmed disclosure. svc-archive is approved, so a frequent large export is not automatically suspicious. The IP ranges are documentation addresses; the logs cannot establish geography, a natural person's identity or the actual access path. Endpoint and VPN evidence would be needed.

Steps

  1. Open the completed workbench to understand the output. Use your task-one canonical events, or start independently from learner/checkpoints/canonical-events.jsonl.
  1. Group events by order_id and apply the cutoff before classifying orders. Manually check a cancellation, an order not yet due, an undelivered overdue order and delivery exactly at due time.
  1. Produce order-review.csv with cohort, delivered lateness and open overdue minutes. Reconcile all five cohorts to the order count.
  1. Aggregate mature counts, late counts and late rates by hub and route. Always show numerator and denominator, with cancellations and not-mature counts separately. Do not average hub percentages for the overall rate.
  1. Build filters and event timelines. Verify that filter selections, result counts and displayed orders agree. Prioritize overdue_open before historical late deliveries.
  1. Write decision-report.md with a conclusion, evidence table, two priority actions, unproven explanations and a specific plan to collect more evidence. Treat route notes as leads only.

Complete outputs

Fulfilment operations decision report

Decision

Review Harbour express first, then Eastgate. Harbour has 32 late orders among 55 mature orders (58.18%), and its express cell is 18/18. Across all hubs, 90 of 197 mature, non-cancelled orders are late: 45.69%.

HubMatureLateLate rateOpen overdue
Eastgate553156.36%3
Southbay32721.88%1
Harbour553258.18%3
Westhill552036.36%3

Denominator and completeness

The 216 orders comprise 12 cancelled, 7 not yet due, 107 on-time deliveries, 80 late deliveries and 10 still-undelivered overdue orders. These cohorts sum to 216. Mature denominator = 107 + 80 + 10 = 197; late numerator = 80 + 10 = 90. Using 90/216 understates lateness. The seven not-mature orders are not completed successes.

Actions

First inspect the ten overdue_open orders, sorted by due_at then order_id, and open each event timeline. Confirm whether delivery is still outstanding or whether the delivery feed is incomplete. Follow the hub operations process after confirmation; this workbench does not dispatch vehicles or send customer notifications.

For Harbour express, compare collection-to-delivery intervals with scheduled departures and handover scans. The route notes suggest queueing or address correction as leads. They do not prove the cause of a delay or establish employee responsibility. Costs and refunds are absent, so no loss estimate is supported.

Review limits

The cutoff is 2026-09-15 00:00 UTC. Future deliveries are excluded. Delivered lateness and open overdue minutes remain separate, because an unfinished order does not have a completed delivery duration. Southbay has a different service mix and a small express sample; use task four before comparing hubs. In the next review, preserve this historical snapshot and introduce a new observation date rather than rewriting the earlier decision with later evidence.

Download fileOpen complete workbench

Reference answers

instructor/answers/order-review.csv Read the full fileDownload file
order_idhubserviceroutecreated_atdue_atcohortlate_minutesoverdue_minutes
O0001HarbourstandardR112026-09-01T06:00:00Z2026-09-02T06:00:00Zcancelled00
O0002HarbourstandardR122026-09-02T07:00:00Z2026-09-03T07:00:00Zdelivered_late500
O0003HarbourstandardR112026-09-03T08:00:00Z2026-09-04T08:00:00Zon_time00
O0004HarbourstandardR122026-09-04T09:00:00Z2026-09-05T09:00:00Zon_time00
O0005HarbourstandardR112026-09-05T10:00:00Z2026-09-06T10:00:00Zdelivered_late500
O0006HarbourstandardR122026-09-06T11:00:00Z2026-09-07T11:00:00Zon_time00
O0007HarbourstandardR112026-09-07T12:00:00Z2026-09-08T12:00:00Zon_time00
O0008HarbourstandardR122026-09-08T13:00:00Z2026-09-09T13:00:00Zdelivered_late500
O0009HarbourstandardR112026-09-09T06:00:00Z2026-09-10T06:00:00Zon_time00
O0010HarbourstandardR122026-09-10T07:00:00Z2026-09-11T07:00:00Zon_time00
O0011HarbourstandardR112026-09-11T08:00:00Z2026-09-12T08:00:00Zdelivered_late500
O0012HarbourstandardR122026-09-12T09:00:00Z2026-09-13T09:00:00Zon_time00
O0013HarbourstandardR112026-09-13T10:00:00Z2026-09-14T10:00:00Zon_time00
O0014HarbourstandardR122026-09-01T11:00:00Z2026-09-02T11:00:00Zdelivered_late500
O0015HarbourstandardR112026-09-02T12:00:00Z2026-09-03T12:00:00Zon_time00
O0016HarbourstandardR122026-09-03T13:00:00Z2026-09-04T13:00:00Zon_time00
O0017HarbourstandardR112026-09-04T06:00:00Z2026-09-05T06:00:00Zdelivered_late500
O0018HarbourstandardR122026-09-05T07:00:00Z2026-09-06T07:00:00Zoverdue_open012540
O0019HarbourstandardR112026-09-06T08:00:00Z2026-09-07T08:00:00Zon_time00
O0020HarbourstandardR122026-09-07T09:00:00Z2026-09-08T09:00:00Zdelivered_late500
O0021HarbourstandardR112026-09-08T10:00:00Z2026-09-09T10:00:00Zon_time00
O0022HarbourstandardR122026-09-09T11:00:00Z2026-09-10T11:00:00Zon_time00
O0023HarbourstandardR112026-09-10T12:00:00Z2026-09-11T12:00:00Zdelivered_late500
O0024HarbourstandardR122026-09-11T13:00:00Z2026-09-12T13:00:00Zon_time00
O0025HarbourstandardR112026-09-12T06:00:00Z2026-09-13T06:00:00Zon_time00
O0026HarbourstandardR122026-09-13T07:00:00Z2026-09-14T07:00:00Zdelivered_late500
O0027HarbourstandardR112026-09-01T08:00:00Z2026-09-02T08:00:00Zon_time00
O0028HarbourstandardR122026-09-02T09:00:00Z2026-09-03T09:00:00Zon_time00
O0029HarbourstandardR112026-09-03T10:00:00Z2026-09-04T10:00:00Zdelivered_late500
O0030HarbourstandardR122026-09-04T11:00:00Z2026-09-05T11:00:00Zcancelled00
O0031HarbourstandardR112026-09-05T12:00:00Z2026-09-06T12:00:00Zon_time00
O0032HarbourstandardR122026-09-06T13:00:00Z2026-09-07T13:00:00Zdelivered_late500
O0033HarbourstandardR112026-09-07T06:00:00Z2026-09-08T06:00:00Zon_time00
O0034HarbourstandardR122026-09-08T07:00:00Z2026-09-09T07:00:00Zon_time00
O0035HarbourstandardR112026-09-09T08:00:00Z2026-09-10T08:00:00Zoverdue_open06720
O0036HarbourstandardR122026-09-10T09:00:00Z2026-09-11T09:00:00Zon_time00
O0037HarbourstandardR112026-09-11T10:00:00Z2026-09-12T10:00:00Zon_time00
O0038HarbourstandardR122026-09-12T11:00:00Z2026-09-13T11:00:00Zdelivered_late500
O0039HarbourstandardR112026-09-13T12:00:00Z2026-09-14T12:00:00Zon_time00
O0040HarbourstandardR122026-09-14T21:00:00Z2026-09-15T21:00:00Znot_mature00
O0041HarbourexpressR112026-09-01T06:00:00Z2026-09-01T14:00:00Zcancelled00
O0042HarbourexpressR122026-09-02T07:00:00Z2026-09-02T15:00:00Zdelivered_late500
O0043HarbourexpressR112026-09-03T08:00:00Z2026-09-03T16:00:00Zdelivered_late500
O0044HarbourexpressR122026-09-04T09:00:00Z2026-09-04T17:00:00Zdelivered_late500
O0045HarbourexpressR112026-09-05T10:00:00Z2026-09-05T18:00:00Zdelivered_late500
O0046HarbourexpressR122026-09-06T11:00:00Z2026-09-06T19:00:00Zdelivered_late500
O0047HarbourexpressR112026-09-07T12:00:00Z2026-09-07T20:00:00Zdelivered_late500
O0048HarbourexpressR122026-09-08T13:00:00Z2026-09-08T21:00:00Zdelivered_late500
O0049HarbourexpressR112026-09-09T06:00:00Z2026-09-09T14:00:00Zdelivered_late500
O0050HarbourexpressR122026-09-10T07:00:00Z2026-09-10T15:00:00Zdelivered_late500
O0051HarbourexpressR112026-09-11T08:00:00Z2026-09-11T16:00:00Zdelivered_late500
O0052HarbourexpressR122026-09-12T09:00:00Z2026-09-12T17:00:00Zdelivered_late500
O0053HarbourexpressR112026-09-13T10:00:00Z2026-09-13T18:00:00Zdelivered_late500
O0054HarbourexpressR122026-09-01T11:00:00Z2026-09-01T19:00:00Zdelivered_late500
O0055HarbourexpressR112026-09-02T12:00:00Z2026-09-02T20:00:00Zdelivered_late500
O0056HarbourexpressR122026-09-03T13:00:00Z2026-09-03T21:00:00Zdelivered_late500
O0057HarbourexpressR112026-09-04T06:00:00Z2026-09-04T14:00:00Zdelivered_late500
O0058HarbourexpressR122026-09-05T07:00:00Z2026-09-05T15:00:00Zoverdue_open013500
O0059HarbourexpressR112026-09-06T08:00:00Z2026-09-06T16:00:00Zdelivered_late500
O0060HarbourexpressR122026-09-14T21:00:00Z2026-09-15T05:00:00Znot_mature00
O0061EastgatestandardR212026-09-01T06:00:00Z2026-09-02T06:00:00Zcancelled00
O0062EastgatestandardR222026-09-02T07:00:00Z2026-09-03T07:00:00Zdelivered_late700
O0063EastgatestandardR212026-09-03T08:00:00Z2026-09-04T08:00:00Zon_time00
O0064EastgatestandardR222026-09-04T09:00:00Z2026-09-05T09:00:00Zon_time00
O0065EastgatestandardR212026-09-05T10:00:00Z2026-09-06T10:00:00Zon_time00
O0066EastgatestandardR222026-09-06T11:00:00Z2026-09-07T11:00:00Zdelivered_late700
O0067EastgatestandardR212026-09-07T12:00:00Z2026-09-08T12:00:00Zon_time00
O0068EastgatestandardR222026-09-08T13:00:00Z2026-09-09T13:00:00Zon_time00
O0069EastgatestandardR212026-09-09T06:00:00Z2026-09-10T06:00:00Zon_time00
O0070EastgatestandardR222026-09-10T07:00:00Z2026-09-11T07:00:00Zdelivered_late700
O0071EastgatestandardR212026-09-11T08:00:00Z2026-09-12T08:00:00Zon_time00
O0072EastgatestandardR222026-09-12T09:00:00Z2026-09-13T09:00:00Zon_time00
O0073EastgatestandardR212026-09-13T10:00:00Z2026-09-14T10:00:00Zon_time00
O0074EastgatestandardR222026-09-01T11:00:00Z2026-09-02T11:00:00Zdelivered_late700
O0075EastgatestandardR212026-09-02T12:00:00Z2026-09-03T12:00:00Zon_time00
O0076EastgatestandardR222026-09-03T13:00:00Z2026-09-04T13:00:00Zon_time00
O0077EastgatestandardR212026-09-04T06:00:00Z2026-09-05T06:00:00Zon_time00
O0078EastgatestandardR222026-09-05T07:00:00Z2026-09-06T07:00:00Zoverdue_open012540
O0079EastgatestandardR212026-09-06T08:00:00Z2026-09-07T08:00:00Zon_time00
O0080EastgatestandardR222026-09-14T21:00:00Z2026-09-15T21:00:00Znot_mature00
O0081EastgateexpressR212026-09-01T06:00:00Z2026-09-01T14:00:00Zcancelled00
O0082EastgateexpressR222026-09-02T07:00:00Z2026-09-02T15:00:00Zdelivered_late700
O0083EastgateexpressR212026-09-03T08:00:00Z2026-09-03T16:00:00Zon_time00
O0084EastgateexpressR222026-09-04T09:00:00Z2026-09-04T17:00:00Zdelivered_late700
O0085EastgateexpressR212026-09-05T10:00:00Z2026-09-05T18:00:00Zdelivered_late700
O0086EastgateexpressR222026-09-06T11:00:00Z2026-09-06T19:00:00Zon_time00
O0087EastgateexpressR212026-09-07T12:00:00Z2026-09-07T20:00:00Zdelivered_late700
O0088EastgateexpressR222026-09-08T13:00:00Z2026-09-08T21:00:00Zdelivered_late700
O0089EastgateexpressR212026-09-09T06:00:00Z2026-09-09T14:00:00Zon_time00
O0090EastgateexpressR222026-09-10T07:00:00Z2026-09-10T15:00:00Zdelivered_late700
O0091EastgateexpressR212026-09-11T08:00:00Z2026-09-11T16:00:00Zdelivered_late700
O0092EastgateexpressR222026-09-12T09:00:00Z2026-09-12T17:00:00Zon_time00
O0093EastgateexpressR212026-09-13T10:00:00Z2026-09-13T18:00:00Zdelivered_late700
O0094EastgateexpressR222026-09-01T11:00:00Z2026-09-01T19:00:00Zdelivered_late700
O0095EastgateexpressR212026-09-02T12:00:00Z2026-09-02T20:00:00Zon_time00
O0096EastgateexpressR222026-09-03T13:00:00Z2026-09-03T21:00:00Zdelivered_late700
O0097EastgateexpressR212026-09-04T06:00:00Z2026-09-04T14:00:00Zdelivered_late700
O0098EastgateexpressR222026-09-05T07:00:00Z2026-09-05T15:00:00Zoverdue_open013500
O0099EastgateexpressR212026-09-06T08:00:00Z2026-09-06T16:00:00Zdelivered_late700
O0100EastgateexpressR222026-09-07T09:00:00Z2026-09-07T17:00:00Zdelivered_late700
O0101EastgateexpressR212026-09-08T10:00:00Z2026-09-08T18:00:00Zon_time00
O0102EastgateexpressR222026-09-09T11:00:00Z2026-09-09T19:00:00Zdelivered_late700
O0103EastgateexpressR212026-09-10T12:00:00Z2026-09-10T20:00:00Zdelivered_late700
O0104EastgateexpressR222026-09-11T13:00:00Z2026-09-11T21:00:00Zon_time00
O0105EastgateexpressR212026-09-12T06:00:00Z2026-09-12T14:00:00Zdelivered_late700
O0106EastgateexpressR222026-09-13T07:00:00Z2026-09-13T15:00:00Zdelivered_late700
O0107EastgateexpressR212026-09-01T08:00:00Z2026-09-01T16:00:00Zon_time00
O0108EastgateexpressR222026-09-02T09:00:00Z2026-09-02T17:00:00Zdelivered_late700
O0109EastgateexpressR212026-09-03T10:00:00Z2026-09-03T18:00:00Zdelivered_late700
O0110EastgateexpressR222026-09-04T11:00:00Z2026-09-04T19:00:00Zcancelled00
O0111EastgateexpressR212026-09-05T12:00:00Z2026-09-05T20:00:00Zdelivered_late700
O0112EastgateexpressR222026-09-06T13:00:00Z2026-09-06T21:00:00Zdelivered_late700
O0113EastgateexpressR212026-09-07T06:00:00Z2026-09-07T14:00:00Zon_time00
O0114EastgateexpressR222026-09-08T07:00:00Z2026-09-08T15:00:00Zdelivered_late700
O0115EastgateexpressR212026-09-09T08:00:00Z2026-09-09T16:00:00Zoverdue_open07680
O0116EastgateexpressR222026-09-10T09:00:00Z2026-09-10T17:00:00Zon_time00
O0117EastgateexpressR212026-09-11T10:00:00Z2026-09-11T18:00:00Zdelivered_late700
O0118EastgateexpressR222026-09-12T11:00:00Z2026-09-12T19:00:00Zdelivered_late700
O0119EastgateexpressR212026-09-13T12:00:00Z2026-09-13T20:00:00Zon_time00
O0120EastgateexpressR222026-09-14T21:00:00Z2026-09-15T05:00:00Znot_mature00
O0121WesthillstandardR312026-09-01T06:00:00Z2026-09-02T06:00:00Zcancelled00
O0122WesthillstandardR322026-09-02T07:00:00Z2026-09-03T07:00:00Zdelivered_late900
O0123WesthillstandardR312026-09-03T08:00:00Z2026-09-04T08:00:00Zon_time00
O0124WesthillstandardR322026-09-04T09:00:00Z2026-09-05T09:00:00Zon_time00
O0125WesthillstandardR312026-09-05T10:00:00Z2026-09-06T10:00:00Zon_time00
O0126WesthillstandardR322026-09-06T11:00:00Z2026-09-07T11:00:00Zon_time00
O0127WesthillstandardR312026-09-07T12:00:00Z2026-09-08T12:00:00Zdelivered_late900
O0128WesthillstandardR322026-09-08T13:00:00Z2026-09-09T13:00:00Zon_time00
O0129WesthillstandardR312026-09-09T06:00:00Z2026-09-10T06:00:00Zon_time00
O0130WesthillstandardR322026-09-10T07:00:00Z2026-09-11T07:00:00Zon_time00
O0131WesthillstandardR312026-09-11T08:00:00Z2026-09-12T08:00:00Zon_time00
O0132WesthillstandardR322026-09-12T09:00:00Z2026-09-13T09:00:00Zdelivered_late900
O0133WesthillstandardR312026-09-13T10:00:00Z2026-09-14T10:00:00Zon_time00
O0134WesthillstandardR322026-09-01T11:00:00Z2026-09-02T11:00:00Zon_time00
O0135WesthillstandardR312026-09-02T12:00:00Z2026-09-03T12:00:00Zon_time00
O0136WesthillstandardR322026-09-03T13:00:00Z2026-09-04T13:00:00Zon_time00
O0137WesthillstandardR312026-09-04T06:00:00Z2026-09-05T06:00:00Zdelivered_late900
O0138WesthillstandardR322026-09-05T07:00:00Z2026-09-06T07:00:00Zoverdue_open012540
O0139WesthillstandardR312026-09-06T08:00:00Z2026-09-07T08:00:00Zon_time00
O0140WesthillstandardR322026-09-07T09:00:00Z2026-09-08T09:00:00Zon_time00
O0141WesthillstandardR312026-09-08T10:00:00Z2026-09-09T10:00:00Zon_time00
O0142WesthillstandardR322026-09-09T11:00:00Z2026-09-10T11:00:00Zdelivered_late900
O0143WesthillstandardR312026-09-10T12:00:00Z2026-09-11T12:00:00Zon_time00
O0144WesthillstandardR322026-09-11T13:00:00Z2026-09-12T13:00:00Zon_time00
O0145WesthillstandardR312026-09-12T06:00:00Z2026-09-13T06:00:00Zon_time00
O0146WesthillstandardR322026-09-13T07:00:00Z2026-09-14T07:00:00Zon_time00
O0147WesthillstandardR312026-09-01T08:00:00Z2026-09-02T08:00:00Zdelivered_late900
O0148WesthillstandardR322026-09-02T09:00:00Z2026-09-03T09:00:00Zon_time00
O0149WesthillstandardR312026-09-03T10:00:00Z2026-09-04T10:00:00Zon_time00
O0150WesthillstandardR322026-09-04T11:00:00Z2026-09-05T11:00:00Zcancelled00
O0151WesthillstandardR312026-09-05T12:00:00Z2026-09-06T12:00:00Zon_time00
O0152WesthillstandardR322026-09-06T13:00:00Z2026-09-07T13:00:00Zdelivered_late900
O0153WesthillstandardR312026-09-07T06:00:00Z2026-09-08T06:00:00Zon_time00
O0154WesthillstandardR322026-09-08T07:00:00Z2026-09-09T07:00:00Zon_time00
O0155WesthillstandardR312026-09-09T08:00:00Z2026-09-10T08:00:00Zoverdue_open06720
O0156WesthillstandardR322026-09-14T21:00:00Z2026-09-15T21:00:00Znot_mature00
O0157WesthillexpressR312026-09-01T06:00:00Z2026-09-01T14:00:00Zcancelled00
O0158WesthillexpressR322026-09-02T07:00:00Z2026-09-02T15:00:00Zdelivered_late900
O0159WesthillexpressR312026-09-03T08:00:00Z2026-09-03T16:00:00Zon_time00
O0160WesthillexpressR322026-09-04T09:00:00Z2026-09-04T17:00:00Zon_time00
O0161WesthillexpressR312026-09-05T10:00:00Z2026-09-05T18:00:00Zdelivered_late900
O0162WesthillexpressR322026-09-06T11:00:00Z2026-09-06T19:00:00Zdelivered_late900
O0163WesthillexpressR312026-09-07T12:00:00Z2026-09-07T20:00:00Zon_time00
O0164WesthillexpressR322026-09-08T13:00:00Z2026-09-08T21:00:00Zon_time00
O0165WesthillexpressR312026-09-09T06:00:00Z2026-09-09T14:00:00Zdelivered_late900
O0166WesthillexpressR322026-09-10T07:00:00Z2026-09-10T15:00:00Zdelivered_late900
O0167WesthillexpressR312026-09-11T08:00:00Z2026-09-11T16:00:00Zon_time00
O0168WesthillexpressR322026-09-12T09:00:00Z2026-09-12T17:00:00Zon_time00
O0169WesthillexpressR312026-09-13T10:00:00Z2026-09-13T18:00:00Zdelivered_late900
O0170WesthillexpressR322026-09-01T11:00:00Z2026-09-01T19:00:00Zdelivered_late900
O0171WesthillexpressR312026-09-02T12:00:00Z2026-09-02T20:00:00Zon_time00
O0172WesthillexpressR322026-09-03T13:00:00Z2026-09-03T21:00:00Zon_time00
O0173WesthillexpressR312026-09-04T06:00:00Z2026-09-04T14:00:00Zdelivered_late900
O0174WesthillexpressR322026-09-05T07:00:00Z2026-09-05T15:00:00Zoverdue_open013500
O0175WesthillexpressR312026-09-06T08:00:00Z2026-09-06T16:00:00Zon_time00
O0176WesthillexpressR322026-09-07T09:00:00Z2026-09-07T17:00:00Zon_time00
O0177WesthillexpressR312026-09-08T10:00:00Z2026-09-08T18:00:00Zdelivered_late900
O0178WesthillexpressR322026-09-09T11:00:00Z2026-09-09T19:00:00Zdelivered_late900
O0179WesthillexpressR312026-09-10T12:00:00Z2026-09-10T20:00:00Zon_time00
O0180WesthillexpressR322026-09-14T21:00:00Z2026-09-15T05:00:00Znot_mature00
O0181SouthbaystandardR412026-09-01T06:00:00Z2026-09-02T06:00:00Zcancelled00
O0182SouthbaystandardR422026-09-02T07:00:00Z2026-09-03T07:00:00Zdelivered_late1100
O0183SouthbaystandardR412026-09-03T08:00:00Z2026-09-04T08:00:00Zon_time00
O0184SouthbaystandardR422026-09-04T09:00:00Z2026-09-05T09:00:00Zon_time00
O0185SouthbaystandardR412026-09-05T10:00:00Z2026-09-06T10:00:00Zon_time00
O0186SouthbaystandardR422026-09-06T11:00:00Z2026-09-07T11:00:00Zon_time00
O0187SouthbaystandardR412026-09-07T12:00:00Z2026-09-08T12:00:00Zon_time00
O0188SouthbaystandardR422026-09-08T13:00:00Z2026-09-09T13:00:00Zdelivered_late1100
O0189SouthbaystandardR412026-09-09T06:00:00Z2026-09-10T06:00:00Zon_time00
O0190SouthbaystandardR422026-09-10T07:00:00Z2026-09-11T07:00:00Zon_time00
O0191SouthbaystandardR412026-09-11T08:00:00Z2026-09-12T08:00:00Zon_time00
O0192SouthbaystandardR422026-09-12T09:00:00Z2026-09-13T09:00:00Zon_time00
O0193SouthbaystandardR412026-09-13T10:00:00Z2026-09-14T10:00:00Zon_time00
O0194SouthbaystandardR422026-09-01T11:00:00Z2026-09-02T11:00:00Zdelivered_late1100
O0195SouthbaystandardR412026-09-02T12:00:00Z2026-09-03T12:00:00Zon_time00
O0196SouthbaystandardR422026-09-03T13:00:00Z2026-09-04T13:00:00Zon_time00
O0197SouthbaystandardR412026-09-04T06:00:00Z2026-09-05T06:00:00Zon_time00
O0198SouthbaystandardR422026-09-05T07:00:00Z2026-09-06T07:00:00Zoverdue_open012540
O0199SouthbaystandardR412026-09-06T08:00:00Z2026-09-07T08:00:00Zon_time00
O0200SouthbaystandardR422026-09-07T09:00:00Z2026-09-08T09:00:00Zdelivered_late1100
O0201SouthbaystandardR412026-09-08T10:00:00Z2026-09-09T10:00:00Zon_time00
O0202SouthbaystandardR422026-09-09T11:00:00Z2026-09-10T11:00:00Zon_time00
O0203SouthbaystandardR412026-09-10T12:00:00Z2026-09-11T12:00:00Zon_time00
O0204SouthbaystandardR422026-09-11T13:00:00Z2026-09-12T13:00:00Zon_time00
O0205SouthbaystandardR412026-09-12T06:00:00Z2026-09-13T06:00:00Zon_time00
O0206SouthbaystandardR422026-09-13T07:00:00Z2026-09-14T07:00:00Zdelivered_late1100
O0207SouthbaystandardR412026-09-01T08:00:00Z2026-09-02T08:00:00Zon_time00
O0208SouthbaystandardR422026-09-02T09:00:00Z2026-09-03T09:00:00Zon_time00
O0209SouthbaystandardR412026-09-03T10:00:00Z2026-09-04T10:00:00Zon_time00
O0210SouthbaystandardR422026-09-14T21:00:00Z2026-09-15T21:00:00Zcancelled00
O0211SouthbayexpressR412026-09-01T06:00:00Z2026-09-01T14:00:00Zcancelled00
O0212SouthbayexpressR422026-09-02T07:00:00Z2026-09-02T15:00:00Zdelivered_late1100
O0213SouthbayexpressR412026-09-03T08:00:00Z2026-09-03T16:00:00Zon_time00
O0214SouthbayexpressR422026-09-04T09:00:00Z2026-09-04T17:00:00Zon_time00
O0215SouthbayexpressR412026-09-05T10:00:00Z2026-09-05T18:00:00Zon_time00
O0216SouthbayexpressR422026-09-14T21:00:00Z2026-09-15T05:00:00Znot_mature00
instructor/answers/hub-metrics.csv Read the full fileDownload file
hubtotaleligiblelatelate_rateon_timedelivered_lateoverdue_opencancellednot_maturedelivered_late_minutesopen_overdue_minutes
Eastgate6055310.5636362428332196033720
Harbour6055320.5818182329332145032760
Southbay363270.2187525613166012540
Westhill6055200.3636363517332153032760
instructor/answers/route-metrics.csv Read the full fileDownload file
routetotaleligiblelatelate_rateon_timedelivered_lateoverdue_opencancellednot_maturedelivered_late_minutesopen_overdue_minutes
R113028150.53571413141207006720
R123027170.62963101521275026040
R213028120.42857116111207707680
R223027190.703704817212119026040
R31302890.3214291981207206720
R323027110.40740716921281026040
R41181600.016002000
R42181670.43759611166012540
Complete reference implementation Read the full fileDownload file
"""Reference implementation for the Ape Intern cold-chain operations lab."""
import csv,json
from collections import defaultdict,Counter
from datetime import datetime,timezone
from pathlib import Path
from urllib.parse import urlparse,parse_qs
UTC=timezone.utc
KINDS={'OPEN':'created','COLLECT':'picked_up','DROP':'delivered','VOID':'cancelled'}
HUBS={'Harbour','Eastgate','Westhill','Southbay'}
def parse_time(value):
    t=datetime.fromisoformat(value.replace('Z','+00:00'))
    if t.tzinfo is None:raise ValueError('timezone_required')
    return t.astimezone(UTC)
def iso(t):return t.isoformat(timespec='seconds').replace('+00:00','Z')
def readcsv(p):
    with Path(p).open(encoding='utf-8-sig',newline='') as f:return list(csv.DictReader(f))
def writecsv(p,rows,fields=None):
    rows=list(rows)
    with Path(p).open('w',encoding='utf-8-sig',newline='') as f:
        w=csv.DictWriter(f,fieldnames=fields or list(rows[0]));w.writeheader();w.writerows(rows)
def dump(p,value):Path(p).write_text(json.dumps(value,ensure_ascii=False,indent=2)+'\n')
def _normalize(record,source):
    if source=='A':
        e=dict(event_id=record['event_id'],order_id=record['order_ref'],hub=record['hub'],service=record['service'],kind=record['event'],happened_at=iso(parse_time(record['event_time'])))
    else:
        ms=record['at_ms']
        if type(ms) is not int:raise ValueError('epoch_must_be_integer')
        e=dict(event_id=record['id'],order_id=record['shipment']['number'],hub=record['shipment']['station'],service=record['shipment']['product'],kind=KINDS[record['action']],happened_at=iso(datetime.fromtimestamp(ms/1000,UTC)))
    if e['kind'] not in KINDS.values():raise ValueError('unsupported_event')
    if e['hub'] not in HUBS or e['service'] not in {'standard','express'}:raise ValueError('unknown_dimension')
    if not e['event_id'] or not e['order_id']:raise ValueError('empty_key')
    return e

def normalize(record,source):
    try:return _normalize(record,source)
    except (KeyError,TypeError,OverflowError) as error:raise ValueError(str(error).strip("'")) from error

def ingest(data):
    grouped=defaultdict(list);rejected=[];duplicates=[]
    for source,name in [('A','dispatch-a.jsonl'),('B','courier-b.jsonl')]:
        for line,text in enumerate((data/name).read_text().splitlines(),1):
            loc={'source':name,'line':line}
            try:
                event=normalize(json.loads(text),source);grouped[event['event_id']].append((event,loc))
            except (ValueError,KeyError,TypeError,OverflowError) as ex:
                rejected.append(dict(loc,reason=str(ex).strip("'")))
    accepted=[]
    for eid,items in grouped.items():
        distinct={json.dumps(e,sort_keys=True,ensure_ascii=False) for e,loc in items}
        if len(distinct)>1:
            rejected.extend(dict(loc,reason='immutable_id_conflict') for e,loc in items);continue
        accepted.append(items[0][0])
        duplicates.extend(dict(loc,event_id=eid,reason='exact_replay') for e,loc in items[1:])
    accepted.sort(key=lambda e:(e['happened_at'],e['event_id']))
    return accepted,rejected,duplicates

def classify_order(order,events,cutoff):
    # Only facts available at cutoff can influence a retrospective result.
    visible=[e for e in events if parse_time(e['happened_at'])<=cutoff]
    visible.sort(key=lambda e:parse_time(e['happened_at']))
    delivered=[parse_time(e['happened_at']) for e in visible if e['kind']=='delivered']
    cancelled=any(e['kind']=='cancelled' for e in visible)
    due=parse_time(order['due_at'])
    if cancelled:state='cancelled'
    elif due>cutoff:state='not_mature'
    elif not delivered:state='overdue_open'
    elif min(delivered)>due:state='delivered_late'
    else:state='on_time'
    delay=round((min(delivered)-due).total_seconds()/60) if state=='delivered_late' else 0
    overdue=round((cutoff-due).total_seconds()/60) if state=='overdue_open' else 0
    return dict(order,cohort=state,late_minutes=delay,overdue_minutes=overdue)

def aggregate(rows,keys):
    groups=defaultdict(list)
    for row in rows:groups[tuple(row[k] for k in keys)].append(row)
    result=[]
    for dims,records in sorted(groups.items()):
        counts=Counter(r['cohort'] for r in records)
        eligible=sum(counts[x] for x in ['on_time','delivered_late','overdue_open'])
        late=counts['delivered_late']+counts['overdue_open']
        result.append(dict(zip(keys,dims),total=len(records),eligible=eligible,late=late,late_rate=round(late/eligible,6) if eligible else None,on_time=counts['on_time'],delivered_late=counts['delivered_late'],overdue_open=counts['overdue_open'],cancelled=counts['cancelled'],not_mature=counts['not_mature'],delivered_late_minutes=sum(r['late_minutes'] for r in records),open_overdue_minutes=sum(r['overdue_minutes'] for r in records)))
    return result

def service_band(rate,n,rules):
    if n<rules['min_sample']:return 'More data needed'
    gap=(rate-rules['late_target'])*100
    if gap>rules['priority_gap_pp']:return 'Priority review'
    if gap>rules['review_gap_pp']:return 'Review needed'
    return 'Within threshold'
def fairness(hub_tiers,rules):
    rows=[]
    for x in hub_tiers:
        rate=x['late_rate'];rows.append(dict(hub=x['hub'],service=x['service'],eligible=x['eligible'],late=x['late'],late_rate=rate,target=rules['late_target'],gap_pp=round((rate-rules['late_target'])*100,3) if rate is not None else None,review=service_band(rate,x['eligible'],rules)))
    standardized=[]
    for hub in sorted(HUBS):
        parts=[r for r in rows if r['hub']==hub]
        enough=len(parts)==2 and all(r['eligible']>=rules['min_sample'] for r in parts)
        value=sum(r['late_rate']*rules[r['service']+'_weight'] for r in parts) if enough else None
        standardized.append(dict(hub=hub,standardized_late_rate=round(value,6) if value is not None else None,status='Comparable' if enough else 'More data needed'))
    return rows,standardized

def investigate(logs,policy):
    logins={};findings=[]
    for row in sorted(logs,key=lambda r:(r['at'],r['request_id'])):
        t=parse_time(row['at']);status=int(row['status']);route=urlparse(row['path']);query=parse_qs(route.query)
        if route.path=='/login' and status==200:logins[(row['user'],row['session'])]=t;continue
        if status!=200:continue
        types=[]
        if route.path=='/export' and row['role'] not in policy['export_roles']:types.append('unauthorised_export')
        hub=query.get('hub',[''])[0]
        if row['role']=='operator' and hub and hub!=policy['operator_hub'].get(row['user']):types.append('hub_scope_violation')
        login=logins.get((row['user'],row['session']))
        if login is None or (t-login).total_seconds()>policy['session_ttl_minutes']*60:types.append('expired_or_missing_session')
        if types:findings.append(dict(request_id=row['request_id'],at=row['at'],user=row['user'],session=row['session'],finding=';'.join(types),status=status,rows=int(row['rows']),bytes=int(row['bytes'])))
    return findings

def solve(data,out):
    data=Path(data);out=Path(out);out.mkdir(parents=True,exist_ok=True)
    events,rejects,dups=ingest(data)
    (out/'canonical-events.jsonl').write_text(''.join(json.dumps(e,ensure_ascii=False)+'\n' for e in events))
    writecsv(out/'rejected.csv',rejects);writecsv(out/'duplicates.csv',dups)
    rules=json.loads((data/'rules.json').read_text());cutoff=parse_time(rules['cutoff'])
    by_order=defaultdict(list)
    for e in events:by_order[e['order_id']].append(e)
    orders=readcsv(data/'orders.csv')
    records=[classify_order(o,by_order[o['order_id']],cutoff) for o in orders]
    writecsv(out/'order-review.csv',records)
    hubs=aggregate(records,['hub']);tiers=aggregate(records,['hub','service']);routes=aggregate(records,['route'])
    writecsv(out/'hub-metrics.csv',hubs);writecsv(out/'route-metrics.csv',routes)
    bands,std=fairness(tiers,rules)
    writecsv(out/'service-review.csv',bands);writecsv(out/'standardized-comparison.csv',std)
    findings=investigate(readcsv(data/'access-log.csv'),json.loads((data/'access-policy.json').read_text()))
    writecsv(out/'security-findings.csv',findings)
    summary=dict(orders=len(orders),accepted_events=len(events),rejected=len(rejects),duplicates=len(dups),cohorts=dict(Counter(r['cohort'] for r in records)),hubs=hubs,service_review=bands,standardized=std,security=dict(flagged_requests=len(findings),potential_export_rows=sum(f['rows'] for f in findings if 'unauthorised_export' in f['finding']),potential_export_bytes=sum(f['bytes'] for f in findings if 'unauthorised_export' in f['finding']),findings=findings))
    dump(out/'results.json',summary)
    return summary
if __name__=='__main__':
    import sys
    print(json.dumps(solve(sys.argv[1],sys.argv[2]),ensure_ascii=False,indent=2))

Each task is worth 20 points. Reach at least 14 and correct all critical rule errors before the next review. Editing raw inputs, silently dropping records, including not-yet-due orders in the denominator, counting 401 attempts as disclosure, ranking an insufficient sample or treating a UI filter as authorization requires correction and re-testing.

  • Cutoff and mature denominator: 7
  • Aggregation and order traceability: 5
  • Complete interactive output: 4
  • Evidence-based actions and causal limits: 4