{ "schema": "yard.fuel.insight.v1", "generated_at": "2026-08-07T05:12:00-05:00", "yard": { "code": "CRL", "name": "Crawler Crane Division", "cost_center": "CORPRT-000-CRL", "manager": "R. Alvarez" }, "window": { "from": "2026-07-13", "to": "2026-08-06", "days": 25 }, "totals": { "txns": 38, "gallons": 3696, "spend_usd": 19485.08, "price_per_gal_blended": 5.272, "by_product": { "Diesel": { "txns": 34, "gallons": 3567, "price_per_gal": 5.332 }, "Regular": { "txns": 4, "gallons": 129, "price_per_gal": 3.600 } }, "vs_prior_30d": { "gallons_pct": 8.4, "price_per_gal_delta": 0.09 }, "peer": { "basis": "Diesel only", "rank": 11, "of": 15, "best": { "code": "IND", "name": "Indianapolis", "price_per_gal": 5.194 }, "gap_usd_per_gal": 0.138, "gap_usd_per_month": 589.46 } }, "trends": { "grain": "iso_week", "basis": "Diesel only", "weeks": ["2026-W29", "2026-W30", "2026-W31", "2026-W32"], "n_per_week": [11, 11, 8, 4], "points": 4, "complete_weeks": 3, "partial_last_week": true, "fleet_price_per_gal": { "series": [5.0371, 5.3641, 5.3814, 5.4413], "verdict": "worsening", "slope_per_week": 0.1230, "mk_s": 6, "mk_pairs": 6, "attribution": "market" }, "price_per_gal": { "series": [5.0593, 5.4752, 5.5226, 5.3782], "verdict": "noisy", "slope_per_week": 0.1004, "mk_s": 2, "mk_pairs": 6, "first_to_last_delta": 0.3188, "attribution": "market" }, "premium_over_fleet": { "series": [0.0222, 0.1111, 0.1412, -0.0632], "verdict": "reversed_provisional", "slope_before_turn": 0.0595, "last_move": -0.2043, "peak": { "week": "2026-W31", "value": 0.1412 }, "latest": -0.0632, "mk_s": 0, "mk_pairs": 6, "attribution": "yard_controllable", "note": "Turning point falls in a partial week (n=4). Confirm on next week's close." }, "gallons": { "series": [1238.3, 1110.0, 847.7, 371.4], "verdict": "noisy", "slope_per_week": -286.3, "mk_s": -6, "mk_pairs": 6, "note": "Monotone down, but the final week is partial — do not voice." } }, "flags": [ { "flag_id": "D1|CHA19|2026-07-20", "detector": "same_day_repeat_fill", "severity": "act_today", "unit_tag": "CHA19", "driver_name": "R. Mathews", "merchant": "PILOT SITE 071, Port Wentworth GA", "occurred_at": "2026-07-20T07:00:00", "time_precision": "hour", "evidence": { "fills": 2, "gallons": [78.5, 39.1], "combined_gallons": 117.6, "unit_p95_single_fill": 92.0, "same_hour": true, "amount_usd": 646.77, "price_per_gal": 5.499 }, "exposure_usd": 140.77, "owner": "yard_manager", "deadline_local": "16:30", "fallback_text": "CHA19 took two fills in the 07:00 hour on Jul 20 — 117.6 gal against a 92 gal working ceiling.", "drill_url": "/fuel/txn?unit=CHA19&date=2026-07-20" } ], "flag_summary": { "surfaced": 3, "total_open": 7, "suppressed": 2, "exposure_usd": 217.35 }, "data_quality": { "rows_fetched": 11310, "rows_loaded": 11284, "quarantined": 26, "odometer_valid_pct": 84.0, "field_count_repairs": 11284 }, "caveats": [ "Fill time precision is hourly; the feed's minute field is always :01.", "No tank-capacity reference table yet — capacity ceilings are statistical (unit p95).", "No GPS in this feed; corridor flags are state-sequence heuristics, not route deviation.", "Trend grain is yard-week; weeks with n < 3 are dropped, and 2026-W32 is partial (4 fills)." ] }