{
  "metric": "contracts_expiring",
  "label": "Contracts expiring",
  "note": "Hotel contracts reaching their end date this year.",
  "table": "hotel_contract",
  "sort": null,
  "dir": "desc",
  "filters": {},
  "total": 15,
  "sums": {
    "cancellation_hours": 444,
    "allotment_rooms": 112
  },
  "rows": [
    {
      "contract_id": "C-102",
      "property_id": "P-102",
      "entity_scope": "ALL",
      "contracted_by": "routespring",
      "start_date": "2026-01-01",
      "end_date": "2026-10-31",
      "currency": "EUR",
      "rate_includes": "Breakfast, wifi, taxes, parking",
      "cancellation_terms": "Free until 24h before arrival",
      "cancellation_hours": 24,
      "payment_terms": "Prepaid, virtual card",
      "payment_terms_days": 0,
      "allotment_rooms": 9,
      "release_days": 4,
      "early_checkin": 1,
      "late_checkout": 1,
      "day_room_rate": null,
      "auto_renew": 0,
      "renewal_notice_days": null,
      "signed_on": "2025-12-03",
      "signed_by": "R. Menon",
      "status": "expiring"
    },
    {
      "contract_id": "C-105",
      "property_id": "P-105",
      "entity_scope": "ALL",
      "contracted_by": "airline",
      "start_date": "2026-01-01",
      "end_date": "2026-10-31",
      "currency": "EUR",
      "rate_includes": "Breakfast, wifi, taxes, parking",
      "cancellation_terms": "Non-refundable inside 24h",
      "cancellation_hours": 18,
      "payment_terms": "Net 30, virtual card",
      "payment_terms_days": 30,
      "allotment_rooms": 4,
      "release_days": 4,
      "early_checkin": 1,
      "late_checkout": 1,
      "day_room_rate": null,
      "auto_renew": 0,
      "renewal_notice_days": null,
      "signed_on": "2025-11-06",
      "signed_by": "P. Costa",
      "status": "expiring"
    },
    {
      "contract_id": "C-108",
      "property_id": "P-108",
      "entity_scope": "ALL",
      "contracted_by": "airline",
      "start_date": "2026-01-01",
      "end_date": "2026-10-31",
      "currency": "EUR",
      "rate_includes": "Breakfast, wifi, taxes, parking",
      "cancellation_terms": "Free until 24h before arrival",
      "cancellation_hours": 48,
      "payment_terms": "Prepaid, virtual card",
      "payment_terms_days": 0,
      "allotment_rooms": 7,
      "release_days": 6,
      "early_checkin": 0,
      "late_checkout": 0,
      "day_room_rate": null,
      "auto_renew": 1,
      "renewal_notice_days": 90,
      "signed_on": "2025-11-19",
      "signed_by": "Loïc Berger",
      "status": "expiring"
    },
    {
      "contract_id": "C-111",
      "property_id": "P-111",
      "entity_scope": "ALL",
      "contracted_by": "airline",
      "start_date": "2026-01-01",
      "end_date": "2026-10-31",
      "currency": "EUR",
      "rate_includes": "Breakfast, wifi",
      "cancellation_terms": "Non-refundable inside 24h",
      "cancellation_hours": 48,
      "payment_terms": "Net 14, virtual card",
      "payment_terms_days": 14,
      "allotment_rooms": 9,
      "release_days": 1,
      "early_checkin": 0,
      "late_checkout": 0,
      "day_room_rate": 162.03,
      "auto_renew": 1,
      "renewal_notice_days": 90,
      "signed_on": "2025-10-31",
      "signed_by": "R. Menon",
      "status": "expiring"
    },
    {
      "contract_id": "C-114",
      "property_id": "P-114",
      "entity_scope": "ALL",
      "contracted_by": "airline",
      "start_date": "2026-01-01",
      "end_date": "2026-10-31",
      "currency": "EUR",
      "rate_includes": "Breakfast, wifi, taxes",
      "cancellation_terms": "Free until 24h before arrival",
      "cancellation_hours": 18,
      "payment_terms": "Net 14, virtual card",
      "payment_terms_days": 14,
      "allotment_rooms": 7,
      "release_days": 1,
      "early_checkin": 1,
      "late_checkout": 0,
      "day_room_rate": 169.51,
      "auto_renew": 0,
      "renewal_notice_days": null,
      "signed_on": "2025-12-15",
      "signed_by": "P. Costa",
      "status": "expiring"
    },
    {
      "contract_id": "C-116",
      "property_id": "P-116",
      "entity_scope": "ASL Airlines Belgium",
      "contracted_by": "routespring",
      "start_date": "2026-01-01",
      "end_date": "2026-10-31",
      "currency": "EUR",
      "rate_includes": "Breakfast, wifi",
      "cancellation_terms": "Free until 18:00 day of arrival",
      "cancellation_hours": 24,
      "payment_terms": "Net 30, invoice",
      "payment_terms_days": 30,
      "allotment_rooms": 10,
      "release_days": 3,
      "early_checkin": 0,
      "late_checkout": 1,
      "day_room_rate": 153.84,
      "auto_renew": 0,
      "renewal_notice_days": null,
      "signed_on": "2025-11-25",
      "signed_by": "P. Costa",
      "status": "expiring"
    },
    {
      "contract_id": "C-118",
      "property_id": "P-118",
      "entity_scope": "ALL",
      "contracted_by": "airline",
      "start_date": "2026-01-01",
      "end_date": "2026-10-31",
      "currency": "EUR",
      "rate_includes": "Breakfast, wifi, taxes",
      "cancellation_terms": "Free until 48h before arrival",
      "cancellation_hours": 18,
      "payment_terms": "Net 30, virtual card",
      "payment_terms_days": 30,
      "allotment_rooms": 7,
      "release_days": 1,
      "early_checkin": 0,
      "late_checkout": 1,
      "day_room_rate": 192.34,
      "auto_renew": 0,
      "renewal_notice_days": null,
      "signed_on": "2025-11-19",
      "signed_by": "P. Costa",
      "status": "expiring"
    },
    {
      "contract_id": "C-121",
      "property_id": "P-121",
      "entity_scope": "ASL Airlines Belgium",
      "contracted_by": "airline",
      "start_date": "2026-01-01",
      "end_date": "2026-10-31",
      "currency": "EUR",
      "rate_includes": "Breakfast, wifi",
      "cancellation_terms": "Free until 18:00 day of arrival",
      "cancellation_hours": 48,
      "payment_terms": "Prepaid, virtual card",
      "payment_terms_days": 0,
      "allotment_rooms": 5,
      "release_days": 5,
      "early_checkin": 1,
      "late_checkout": 0,
      "day_room_rate": 160.48,
      "auto_renew": 0,
      "renewal_notice_days": null,
      "signed_on": "2025-11-06",
      "signed_by": "Loïc Berger",
      "status": "expiring"
    },
    {
      "contract_id": "C-123",
      "property_id": "P-123",
      "entity_scope": "ALL",
      "contracted_by": "airline",
      "start_date": "2026-01-01",
      "end_date": "2026-10-31",
      "currency": "EUR",
      "rate_includes": "Breakfast, wifi, taxes",
      "cancellation_terms": "Free until 18:00 day of arrival",
      "cancellation_hours": 18,
      "payment_terms": "Prepaid, virtual card",
      "payment_terms_days": 0,
      "allotment_rooms": 5,
      "release_days": 4,
      "early_checkin": 1,
      "late_checkout": 1,
      "day_room_rate": null,
      "auto_renew": 1,
      "renewal_notice_days": 90,
      "signed_on": "2025-12-06",
      "signed_by": "P. Costa",
      "status": "expiring"
    },
    {
      "contract_id": "C-125",
      "property_id": "P-125",
      "entity_scope": "ALL",
      "contracted_by": "airline",
      "start_date": "2026-01-01",
      "end_date": "2026-10-31",
      "currency": "EUR",
      "rate_includes": "Breakfast, wifi",
      "cancellation_terms": "Free until 18:00 day of arrival",
      "cancellation_hours": 24,
      "payment_terms": "Prepaid, virtual card",
      "payment_terms_days": 0,
      "allotment_rooms": 9,
      "release_days": 3,
      "early_checkin": 1,
      "late_checkout": 0,
      "day_room_rate": 117.3,
      "auto_renew": 0,
      "renewal_notice_days": null,
      "signed_on": "2025-11-30",
      "signed_by": "P. Costa",
      "status": "expiring"
    },
    {
      "contract_id": "C-127",
      "property_id": "P-127",
      "entity_scope": "ALL",
      "contracted_by": "routespring",
      "start_date": "2026-01-01",
      "end_date": "2026-10-31",
      "currency": "EUR",
      "rate_includes": "Wifi only",
      "cancellation_terms": "Free until 24h before arrival",
      "cancellation_hours": 48,
      "payment_terms": "Net 30, virtual card",
      "payment_terms_days": 30,
      "allotment_rooms": 6,
      "release_days": 2,
      "early_checkin": 0,
      "late_checkout": 1,
      "day_room_rate": 174.77,
      "auto_renew": 1,
      "renewal_notice_days": 60,
      "signed_on": "2025-12-11",
      "signed_by": "R. Menon",
      "status": "expiring"
    },
    {
      "contract_id": "C-130",
      "property_id": "P-130",
      "entity_scope": "ALL",
      "contracted_by": "routespring",
      "start_date": "2026-01-01",
      "end_date": "2026-10-31",
      "currency": "EUR",
      "rate_includes": "Breakfast, wifi",
      "cancellation_terms": "Free until 18:00 day of arrival",
      "cancellation_hours": 18,
      "payment_terms": "Prepaid, virtual card",
      "payment_terms_days": 0,
      "allotment_rooms": 8,
      "release_days": 5,
      "early_checkin": 1,
      "late_checkout": 1,
      "day_room_rate": null,
      "auto_renew": 0,
      "renewal_notice_days": null,
      "signed_on": "2025-11-29",
      "signed_by": "Loïc Berger",
      "status": "expiring"
    },
    {
      "contract_id": "C-132",
      "property_id": "P-132",
      "entity_scope": "ALL",
      "contracted_by": "routespring",
      "start_date": "2026-01-01",
      "end_date": "2026-10-31",
      "currency": "EUR",
      "rate_includes": "Breakfast, wifi, taxes",
      "cancellation_terms": "Free until 24h before arrival",
      "cancellation_hours": 48,
      "payment_terms": "Net 30, invoice",
      "payment_terms_days": 30,
      "allotment_rooms": 7,
      "release_days": 5,
      "early_checkin": 1,
      "late_checkout": 1,
      "day_room_rate": 165.91,
      "auto_renew": 0,
      "renewal_notice_days": null,
      "signed_on": "2025-11-12",
      "signed_by": "Loïc Berger",
      "status": "expiring"
    },
    {
      "contract_id": "C-134",
      "property_id": "P-134",
      "entity_scope": "ALL",
      "contracted_by": "routespring",
      "start_date": "2026-01-01",
      "end_date": "2026-10-31",
      "currency": "EUR",
      "rate_includes": "Breakfast, wifi",
      "cancellation_terms": "Non-refundable inside 24h",
      "cancellation_hours": 24,
      "payment_terms": "Prepaid, virtual card",
      "payment_terms_days": 0,
      "allotment_rooms": 10,
      "release_days": 6,
      "early_checkin": 1,
      "late_checkout": 1,
      "day_room_rate": null,
      "auto_renew": 0,
      "renewal_notice_days": null,
      "signed_on": "2025-11-22",
      "signed_by": "Loïc Berger",
      "status": "expiring"
    },
    {
      "contract_id": "C-136",
      "property_id": "P-136",
      "entity_scope": "ALL",
      "contracted_by": "airline",
      "start_date": "2026-01-01",
      "end_date": "2026-10-31",
      "currency": "EUR",
      "rate_includes": "Breakfast, wifi",
      "cancellation_terms": "Free until 18:00 day of arrival",
      "cancellation_hours": 18,
      "payment_terms": "Net 30, virtual card",
      "payment_terms_days": 30,
      "allotment_rooms": 9,
      "release_days": 6,
      "early_checkin": 1,
      "late_checkout": 1,
      "day_room_rate": null,
      "auto_renew": 1,
      "renewal_notice_days": 60,
      "signed_on": "2025-10-24",
      "signed_by": "P. Costa",
      "status": "expiring"
    }
  ]
}