Parsing or interaction via API (booking.com or others)

What needs to be done:
Create a comprehensive and clear table of hotel brands and loyalty programs

The table should include:

1. Loyalty Programs (names)

• A list of all hotel loyalty programs. (only take the 40-50 largest)
• The total number of brands in each program.

2. Hotel Brands and Quantity

• A list of all brands included in each loyalty program.
• The total number of hotels belonging to each brand.
• A list of all hotels for each brand (with ratings for each hotel and price(s))
• For each hotel, specify:
  • Hotel style/vibe (e.g., classic, modern, resort, luxury).
  • Price category.
  • Rating (based on available data).

3. Price Category of Brands

• Determine the price category for each brand (e.g., budget, mid-range, luxury). (can take average across hotels)
• Calculate the average price category for each loyalty program. (average across brands)
• Determine the price category for winter and summer seasons separately.

4. Geographic Coverage

• The total number of countries covered by the program.
• The number of hotels in each country for each brand in each loyalty program

5. Average Ratings

• Collect hotel ratings for each brand.
• Calculate the average for each brand.
• Calculate the average ratings for the entire loyalty program.

6. Comparison of Loyalty Programs

• Using the collected data (price category, average ratings, number of countries, hotel styles, seasonal factors), build a ranking of loyalty programs.
• Evaluate programs by regions and seasons.

Important:
Hotel styles can be:

Very important, if possible, add this data as well!!!:

Points Accumulation: Hotels allow guests to earn points based on hotel stays, dining, and other activities with program partners. The higher the guest's level, the higher their potential earnings, which contributes to increased loyalty and repeat business. If it is possible to gather this somehow, that would be great!

Usage: just understand what criteria exist, 

Multi-level Programs: Typically, there are several levels, and participants progress based on nights stayed or points earned. Elite levels usually have additional benefits, such as better upgrades, early check-in, late check-out, or other personalized services. Need to understand what benefits and the accumulation system!

Flexibility: Hotels usually simplify registration in loyalty programs and ensure that points do not expire (there may be some information available on this)

Partnerships: Hotels often collaborate with other companies, such as airlines, car rental companies, restaurants, and travel companies, to allow members to earn points in multiple ways. This provides guests with more opportunities to regularly use points. (What partnerships does each loyalty program have, with whom exactly, possibly conditions)

Any additional information can be useful, so if there is a possibility to gather it (even if something is not specified here, but you can extract it) I would be very grateful!!!

This needs to be done quickly, so those who cannot submit the completed work within 1 day, please do not bid. Thank you!