Fare Bucket Availability Tracker
Apr 30, 2005 | 3:39 pm
#1
Original Poster
Join Date: Apr 2004
Location: Boston, MA
Programs: UA 1K MM
Posts: 141
Fare Bucket Availability Tracker
Along the lines of smb12's EUA tracker, I've recently been working on a fare bucket database which monitors CO flights for the week before departure. It tracks the fare bucket availability for a set of routes, and aggregates and graphs the data.
My hope is that the data will be useful for picking flights which provide the highest chance of an upgrade (ones with higher average Z availability) as well as flights with a high probability of a bump (ones with lower average Y availability). I've also put up graphs for a few other queries, such as which day of the week has the highest availability, which hubs provide the highest availabilty from a given city, and overall average fare bucket availability.
Feel free to check out the website at http://joshua.cs.rice.edu.
While testing it, I've only been collecting data for a few routes (IAH<->EWR, IAH<->SFO, and IAH<->MSY), so these have the most data. I've recently added a good number of other routes, and the data for these will slowly trickle in.
Let me know if you find it useful, and please send any comments or suggestions my way. Thanks!
My hope is that the data will be useful for picking flights which provide the highest chance of an upgrade (ones with higher average Z availability) as well as flights with a high probability of a bump (ones with lower average Y availability). I've also put up graphs for a few other queries, such as which day of the week has the highest availability, which hubs provide the highest availabilty from a given city, and overall average fare bucket availability.
Feel free to check out the website at http://joshua.cs.rice.edu.
While testing it, I've only been collecting data for a few routes (IAH<->EWR, IAH<->SFO, and IAH<->MSY), so these have the most data. I've recently added a good number of other routes, and the data for these will slowly trickle in.
Let me know if you find it useful, and please send any comments or suggestions my way. Thanks!
Last edited by amislove; Apr 30, 2005 at 4:38 pm Reason: remove reference
Apr 30, 2005 | 5:13 pm
#2
FlyerTalk Evangelist
Join Date: Feb 2002
Location: San Francisco/Tel Aviv/YYZ
Programs: CO 1K-MM
Posts: 10,859
wow nice job!
since you've got this together, any interest in adding a form for users to enter status, time of UG or no UG , (O &D), flight, date and fare class?
since you've got the database set up.. probably it would be easy to do.
since you've got this together, any interest in adding a form for users to enter status, time of UG or no UG , (O &D), flight, date and fare class?
since you've got the database set up.. probably it would be easy to do.
May 1, 2005 | 12:32 am
#3
Join Date: Oct 2004
Location: Clinging to the edifices of a decadent past from the biggest city in America nobody really cares about.
Programs: (ಠ_ಠ)
Posts: 9,077
Wow!
Thanks a bunch for putting this together! 
May 4, 2005 | 4:40 pm
#4
Join Date: Jun 2003
Location: Tampa, FL
Programs: Hilton Diamond, Delta Platinum
Posts: 1,730
Originally Posted by entropy
wow nice job!
since you've got this together, any interest in adding a form for users to enter status, time of UG or no UG , (O &D), flight, date and fare class?
since you've got the database set up.. probably it would be easy to do.
since you've got this together, any interest in adding a form for users to enter status, time of UG or no UG , (O &D), flight, date and fare class?
since you've got the database set up.. probably it would be easy to do.
May 4, 2005 | 5:00 pm
#5
Join Date: Feb 2004
Location: LAX
Programs: UA Sliver, Marriott LT Plat
Posts: 76
Awesome! Is there anything a CS major can't do??? 
Now, can SNA-EWR and SNA-IAH city pairs?
Now, can SNA-EWR and SNA-IAH city pairs?
May 4, 2005 | 5:03 pm
#6
FlyerTalk Evangelist
Join Date: Aug 2002
Location: Bay Area, CA
Programs: UA Plat 2MM; AS MVP Gold 75K
Posts: 35,092
Originally Posted by divrdrew
Take a peek at upgradesuccess.com. We're collecting data right now and will start the search and summary functions shortly.
May 4, 2005 | 5:19 pm
#7
Join Date: Jun 2003
Location: Tampa, FL
Programs: Hilton Diamond, Delta Platinum
Posts: 1,730
I don't think that CO legal has anything to do with this. We are simply asking members to report on their experiences. We are not using anything other than the airline abbreviation codes which are public domain and I don't think that they are even the intellectual property of any of the airlines, are they? The government / FAA issues these, so I'm not sure...
May 4, 2005 | 5:50 pm
#8
Join Date: Oct 2003
Location: DCA
Programs: UA LT 1K, AA EXP, Marriott LT Titan, Avis PC, Hilton Gold
Posts: 9,925
I do not see a problem. This is sort of like consumer reports doing surveys on products - in this case the product is upgrade success.