Harthliving OTA · bản chữ cho AI · dựng từ vault (nguồn sửa lần cuối 29/09/2026 09:28) · mục lục: https://harthliving-ota.pages.dev/ai/index.txt

# Bảng dữ liệu: Agoda reservations (`fact_agoda_reservations`)

Agoda reservation list (no amounts — join booking_id to fact_agoda_transactions.reference_number for money).

- Nền tảng: agoda · Nhóm: reservations · Mỗi dòng: one reservation
- Số dòng: 14 · Cập nhật: 2026-09-24
- Tải: CSV https://harthliving-ota.pages.dev/data/fact-agoda-reservations.csv · JSON https://harthliving-ota.pages.dev/data/fact-agoda-reservations.json · HTML https://harthliving-ota.pages.dev/library/data/fact-agoda-reservations/

## Cột

| Cột | Kiểu | Nghĩa |
|---|---|---|
| `snapshot_date` | date | Date the data was crawled from the platform (NOT the date the numbers refer to) |
| `channel` | string | Sales channel / platform key: booking / agoda / airbnb / pricelabs |
| `slug` | string | Internal property key (e.g. 25anthuong11, alacarte305). Join key across all datasets |
| `external_id` | string | Property/listing ID on the platform (Booking hotel_id, Agoda property ID, Airbnb listing ID) |
| `booking_id` | string | Agoda booking ID. Join to fact_agoda_transactions.reference_number for money (the list itself has no amounts) |
| `checkin` | date | Check-in date |
| `checkout` | date | Check-out date |
| `nights` | integer | Number of nights |
| `ack_type` | string | Agoda acknowledgement type code (raw) |
| `stay_type` | string | Agoda stay type code (raw, often empty) |
| `payment_model` | string | Agoda payment model code (raw) |
| `room` | string | Room type name and ID |
| `rooms` | integer | Number of rooms |
| `adults` | integer | Number of adult guests |
| `children` | integer | Number of children |

## Dữ liệu

**Phần 1/1** — dòng 1–14 / 14 · (hết bảng)

```csv
snapshot_date,channel,slug,external_id,booking_id,checkin,checkout,nights,ack_type,stay_type,payment_model,room,rooms,adults,children
2026-09-24,agoda,15nuocman5,84463562,1739184041,2026-06-26,2026-06-28,2,1,,1,home  (1323423479),1,3,0
2026-09-24,agoda,15nuocman5,84463562,1743114920,2026-07-16,2026-07-21,5,1,,1,home  (1323423479),1,3,0
2026-09-24,agoda,15nuocman5,84463562,1750220315,2026-08-02,2026-08-06,4,1,,1,home  (1323423479),1,4,0
2026-09-24,agoda,181tohienthanh,84463574,1700138196,2026-02-19,2026-02-20,1,1,,1,Private Villa (1312889663),1,6,0
2026-09-24,agoda,181tohienthanh,84463574,1700156672,2026-04-15,2026-04-18,3,3,,1,Private Villa (1312889663),1,5,1
2026-09-24,agoda,181tohienthanh,84463574,1731187602,2026-06-15,2026-06-20,5,1,,1,Private Villa (1312889663),1,6,0
2026-09-24,agoda,181tohienthanh,84463574,1754586651,2026-09-04,2026-09-07,3,1,,1,Private Villa (1312889663),1,6,0
2026-09-24,agoda,181tohienthanh,84463574,1759236001,2026-12-26,2026-12-30,4,1,,1,Private Villa (1312889663),1,4,0
2026-09-24,agoda,181tohienthanh,84463574,1761214569,2026-08-30,2026-09-02,3,1,,1,Private Villa (1312889663),1,6,0
2026-09-24,agoda,181tohienthanh,84463574,1766609131,2026-09-18,2026-09-19,1,1,,1,Private Villa (1312889663),1,3,0
2026-09-24,agoda,181tohienthanh,84463574,1771814012,2026-10-20,2026-10-23,3,1,,1,Private Villa (1312889663),1,3,0
2026-09-24,agoda,181tohienthanh,84463574,632865171,2026-03-06,2026-03-13,7,1,,1,Private Villa (1312889663),1,4,0
2026-09-24,agoda,181tohienthanh,84463574,988554310,2026-08-17,2026-08-24,7,1,,1,Private Villa (1312889663),1,5,1
2026-09-24,agoda,alacarte502,84463577,2025001589,2026-07-16,2026-07-20,4,1,,1,1BR Studio A La Carte Hotel [Free Airport Pickup From 3 Nights] (1323423599),1,2,0
```

**Phần 1/1** — dòng 1–14 / 14 · (hết bảng)