{
  "metric": "rfp_nights",
  "label": "Nights in play",
  "note": "Annual room nights across the open rounds.",
  "table": "rfp",
  "sort": null,
  "dir": "desc",
  "filters": {},
  "total": 12,
  "sums": {
    "annual_nights": 60515,
    "current_rate": 3650.24,
    "target_rate": 3313.25,
    "awarded_rate": 1211.19
  },
  "rows": [
    {
      "rfp_id": "RFP-202611",
      "station": "MRS",
      "city": "Marseille",
      "entity": "ASL Airlines Belgium",
      "season": "Summer 2027",
      "status": "out_to_bid",
      "opened_at": "2026-03-02",
      "due_at": "2026-10-21",
      "awarded_at": null,
      "annual_nights": 9116,
      "current_rate": 270,
      "target_rate": 234.9,
      "awarded_rate": null,
      "awarded_property": null,
      "owner": "P. Costa",
      "reason": "Crew score below threshold"
    },
    {
      "rfp_id": "RFP-202601",
      "station": "BRU",
      "city": "Brussels",
      "entity": null,
      "season": "Summer 2027",
      "status": "awarded",
      "opened_at": "2026-01-01",
      "due_at": "2026-06-20",
      "awarded_at": "2026-06-10",
      "annual_nights": 7383,
      "current_rate": 336.87,
      "target_rate": 304.41,
      "awarded_rate": 319.52,
      "awarded_property": "Thon Hotel EU",
      "owner": "R. Menon",
      "reason": "Contract expires within 90 days"
    },
    {
      "rfp_id": "RFP-202607",
      "station": "STN",
      "city": "London Stansted",
      "entity": "ASL Airlines Ireland",
      "season": "Summer 2027",
      "status": "awarded",
      "opened_at": "2026-07-07",
      "due_at": "2026-06-26",
      "awarded_at": "2026-06-16",
      "annual_nights": 7018,
      "current_rate": 339.42,
      "target_rate": 303.11,
      "awarded_rate": 321.19,
      "awarded_property": "Radisson Blu Stansted",
      "owner": "P. Costa",
      "reason": "Property suspended, replacement needed"
    },
    {
      "rfp_id": "RFP-202603",
      "station": "HKG",
      "city": "Hong Kong",
      "entity": "ASL Airlines France",
      "season": "Summer 2027",
      "status": "negotiating",
      "opened_at": "2026-03-03",
      "due_at": "2026-08-22",
      "awarded_at": null,
      "annual_nights": 6198,
      "current_rate": 348.92,
      "target_rate": 325.47,
      "awarded_rate": null,
      "awarded_property": null,
      "owner": "P. Costa",
      "reason": "Rate above benchmark for two quarters"
    },
    {
      "rfp_id": "RFP-202610",
      "station": "TLS",
      "city": "Toulouse",
      "entity": "ASL Airlines Ireland",
      "season": "Winter 2026/27",
      "status": "evaluating",
      "opened_at": "2026-02-01",
      "due_at": "2026-09-20",
      "awarded_at": null,
      "annual_nights": 5243,
      "current_rate": 273.45,
      "target_rate": 244.72,
      "awarded_rate": null,
      "awarded_property": null,
      "owner": "Loïc Berger",
      "reason": "Rate above benchmark for two quarters"
    },
    {
      "rfp_id": "RFP-202605",
      "station": "MAD",
      "city": "Madrid",
      "entity": null,
      "season": "Summer 2027",
      "status": "out_to_bid",
      "opened_at": "2026-05-05",
      "due_at": "2026-10-24",
      "awarded_at": null,
      "annual_nights": 5002,
      "current_rate": 289.45,
      "target_rate": 265.57,
      "awarded_rate": null,
      "awarded_property": null,
      "owner": "Loïc Berger",
      "reason": "No contract at this station"
    },
    {
      "rfp_id": "RFP-202604",
      "station": "DXB",
      "city": "Dubai",
      "entity": "ASL Airlines Ireland",
      "season": "Winter 2026/27",
      "status": "evaluating",
      "opened_at": "2026-04-04",
      "due_at": "2026-09-23",
      "awarded_at": null,
      "annual_nights": 4963,
      "current_rate": 326.5,
      "target_rate": 299.66,
      "awarded_rate": null,
      "awarded_property": null,
      "owner": "R. Menon",
      "reason": "Crew score below threshold"
    },
    {
      "rfp_id": "RFP-202606",
      "station": "LYS",
      "city": "Lyon",
      "entity": "ASL Airlines France",
      "season": "Winter 2026/27",
      "status": "planning",
      "opened_at": "2026-06-06",
      "due_at": "2026-11-25",
      "awarded_at": null,
      "annual_nights": 4662,
      "current_rate": 269.48,
      "target_rate": 246.48,
      "awarded_rate": null,
      "awarded_property": null,
      "owner": "Loïc Berger",
      "reason": "Allotment consistently overflowing"
    },
    {
      "rfp_id": "RFP-202609",
      "station": "JNB",
      "city": "Johannesburg",
      "entity": null,
      "season": "Summer 2027",
      "status": "negotiating",
      "opened_at": "2026-01-09",
      "due_at": "2026-08-28",
      "awarded_at": null,
      "annual_nights": 3876,
      "current_rate": 266.26,
      "target_rate": 235.48,
      "awarded_rate": null,
      "awarded_property": null,
      "owner": "R. Menon",
      "reason": "Volume now justifies contracting"
    },
    {
      "rfp_id": "RFP-202602",
      "station": "CGN",
      "city": "Cologne",
      "entity": "ASL Airlines Belgium",
      "season": "Winter 2026/27",
      "status": "awarded",
      "opened_at": "2026-02-02",
      "due_at": "2026-07-21",
      "awarded_at": "2026-07-11",
      "annual_nights": 3492,
      "current_rate": 295.42,
      "target_rate": 270.73,
      "awarded_rate": 281.98,
      "awarded_property": "Ibis Koln Messe",
      "owner": "R. Menon",
      "reason": "Volume now justifies contracting"
    },
    {
      "rfp_id": "RFP-202608",
      "station": "BHX",
      "city": "Birmingham",
      "entity": "ASL Airlines Belgium",
      "season": "Winter 2026/27",
      "status": "awarded",
      "opened_at": "2026-08-08",
      "due_at": "2026-07-27",
      "awarded_at": "2026-07-17",
      "annual_nights": 1919,
      "current_rate": 310.34,
      "target_rate": 281.88,
      "awarded_rate": 288.5,
      "awarded_property": "Novotel Birmingham Airport",
      "owner": "R. Menon",
      "reason": "Contract expires within 90 days"
    },
    {
      "rfp_id": "RFP-202612",
      "station": "EMA",
      "city": "East Midlands",
      "entity": "ASL Airlines France",
      "season": "Winter 2026/27",
      "status": "planning",
      "opened_at": "2026-04-03",
      "due_at": "2026-11-22",
      "awarded_at": null,
      "annual_nights": 1643,
      "current_rate": 324.13,
      "target_rate": 300.84,
      "awarded_rate": null,
      "awarded_property": null,
      "owner": "Loïc Berger",
      "reason": "No contract at this station"
    }
  ]
}