report.json

outputs/report.json

{
  "business_date": "2027-10-18",
  "property_id": "HOTEL-001",
  "threshold": 0.63,
  "rows": [
    {
      "date": "2027-10-18",
      "occupancy_on_books": 0.6043,
      "rooms_available": 490,
      "below_threshold": true,
      "group_rooms_allocated": 2,
      "group_rooms_picked_up": 0,
      "rooms_with_open_maintenance": 45,
      "source_file": "hotel-001.json",
      "source_row": "occupancy[7]; availability[0]"
    },
    {
      "date": "2027-10-19",
      "occupancy_on_books": 0.66,
      "rooms_available": 421,
      "below_threshold": false,
      "group_rooms_allocated": 2,
      "group_rooms_picked_up": 0,
      "rooms_with_open_maintenance": 45,
      "source_file": "hotel-001.json",
      "source_row": "occupancy[8]; availability[1]"
    },
    {
      "date": "2027-10-20",
      "occupancy_on_books": 0.6478,
      "rooms_available": 436,
      "below_threshold": false,
      "group_rooms_allocated": 0,
      "group_rooms_picked_up": 0,
      "rooms_with_open_maintenance": 45,
      "source_file": "hotel-001.json",
      "source_row": "occupancy[9]; availability[2]"
    },
    {
      "date": "2027-10-21",
      "occupancy_on_books": 0.6342,
      "rooms_available": 453,
      "below_threshold": false,
      "group_rooms_allocated": 0,
      "group_rooms_picked_up": 0,
      "rooms_with_open_maintenance": 45,
      "source_file": "hotel-001.json",
      "source_row": "occupancy[10]; availability[3]"
    },
    {
      "date": "2027-10-22",
      "occupancy_on_books": 0.6355,
      "rooms_available": 451,
      "below_threshold": false,
      "group_rooms_allocated": 0,
      "group_rooms_picked_up": 0,
      "rooms_with_open_maintenance": 45,
      "source_file": "hotel-001.json",
      "source_row": "occupancy[11]; availability[4]"
    },
    {
      "date": "2027-10-23",
      "occupancy_on_books": 0.6274,
      "rooms_available": 461,
      "below_threshold": true,
      "group_rooms_allocated": 0,
      "group_rooms_picked_up": 0,
      "rooms_with_open_maintenance": 45,
      "source_file": "hotel-001.json",
      "source_row": "occupancy[12]; availability[5]"
    },
    {
      "date": "2027-10-24",
      "occupancy_on_books": 0.85,
      "rooms_available": 186,
      "below_threshold": false,
      "group_rooms_allocated": 0,
      "group_rooms_picked_up": 0,
      "rooms_with_open_maintenance": 45,
      "source_file": "hotel-001.json",
      "source_row": "occupancy[13]; derived from inventory"
    }
  ],
  "last_7_days": {
    "start_date": "2027-10-11",
    "end_date": "2027-10-17",
    "days": 7,
    "occupancy_avg": 0.5727,
    "next_7_days_occupancy_avg": 0.6656,
    "change_vs_last_7_days": 0.0929
  },
  "warnings": [
    "rooms_available for 2027-10-24 is derived from the inventory and the occupancy: the export has no hotel-level availability row for that date.",
    "The group grid covers 1 of 25 blocks listed in the export. Group numbers cover only the blocks in the grid.",
    "rooms_with_open_maintenance is one count for every date: the export has no end dates for maintenance records."
  ]
}