travel-data-lookup

Look up travel data from the local CSV/TXT database for cities, restaurants, accommodations, attractions, and distances. Use this skill whenever planning a trip, building an itinerary, or querying tra

SKILL.md

GitHub

Travel Data Lookup

Data Sources

All travel data lives under /app/data/ with these files:

File Description Key Columns
background/citySet_with_states.txt City-to-state mapping (tab-separated) city, state
restaurants/clean_restaurant_2022.csv 9,550 restaurant listings Name, City, Cuisines, Average Cost, Aggregate Rating
accommodations/clean_accommodations_2022.csv 5,062 accommodation listings NAME, room type, price, minimum nights, review rate number, house_rules, maximum occupancy, city
attractions/attractions.csv 5,301 attractions Name, Latitude, Longitude, Address, Phone, Website, City
googleDistanceMatrix/distance.csv 17,601 city-pair distances origin, destination, cost, duration, distance
flights/clean_Flights_2022.csv Flight records (avoid if no-fly constraint) Flight Number, Price, DepTime, ArrTime, FlightDate, OriginCityName, DestCityName

Querying Patterns

  • Find cities in a state: grep -i "state_name" data/background/citySet_with_states.txt
  • Find restaurants by city: grep -i ",CityName" data/restaurants/clean_restaurant_2022.csv (city is last column; anchor with trailing match)
  • Filter by cuisine: After getting city restaurants, filter lines containing target cuisine keywords (American, Italian, Chinese, Mediterranean, etc.)
  • Pet-friendly accommodations: Filter OUT rows with "No pets" in house_rules column. Also check maximum occupancy >= party_size and minimum nights <= stay_duration.
  • Distances between cities: grep -i "origin_city" data/googleDistanceMatrix/distance.csv | grep -i "dest_city". Note: cost column is often empty for driving; use distance for gas estimation.

Budget Estimation

  • Accommodations: price column is per-night rate
  • Restaurants: Average Cost column is cost for two people
  • Self-driving cost: Estimate ~$0.15/km for gas based on distance column (strip commas and "km")
  • No cost data in distance matrix: The cost column for self-driving routes is typically empty; estimate from distance

Pet-Friendly Filter

The house_rules column contains rules like "No pets", "No smoking", "No parties", "No visitors", "No children under 10". To find pet-friendly places, exclude any row where house_rules contains "No pets" (case-insensitive).