google_flights | Notion

Overview

Flight data of top 10 most popular flight paths from google flights

Metadata

Frequency (UTC)	Source	Dataset ID	Cron
At 07:00 AM		travel	0 7 * * *

Dependency Policy

Data Dictionary

Column Name	Description	Type	Mode
route	Route; e.g. LAX-SFO	string	REQUIRED
price	Price of ticket	number	REQUIRED
airline	Airline	string	REQUIRED
fareType	Fare type - has to be economy, premium-economy, business, or first	string	REQUIRED
scrapeDate	Date of scraping	string	REQUIRED
flightDate	Date of flight	string	REQUIRED
stops	Number of stops - 0 stops for direct flights	number	REQUIRED
duration	Duration of flight	string	REQUIRED
isInTop3	Is this one of the top 3 recommended flights	boolean	REQUIRED
isBest	Is this one of the best flights according to Google (can have more than 3 flights under this section)	boolean	REQUIRED

Notes

Collects Google Flights one-way flight and pricing information for the top 10 routes in the US 10 weeks out by fare type (economy, business, first class etc.)
Additional parameters isBest for when a flight is considered to be one of the best flights and isInTop3 for when the flight is in the top 3 recommendations in Google Flights
Assumes any number of stops is permissible and pricing is only for 1 adult passenger