Hacker News Reader

Thanks for finding this, I owe you a beer. Payable any time in the bay area.

It is probably a bug in my data pipeline. I will look into this.

I consolidate all airports in a metro area, MDW and ORD for Chicago.

I'm pretty sure UA has more than 48 flights a week to the NY area as well if you're aggregating JFK, LGA and EWR,the number should be closer to 20 per day. I just arbitrarily picked Friday, 10/17 from SFO => NYC and there are 23 flights. Your number might be right if excluding EWR, which like SFO is a major UA hub.

yeah, EWR comes under Newark. Though I should consider merging metropolitan areas beyond cities.

http://flightsphere.com/flight-time/from/newark/to/san-franc...

Most cities actually have an airport code as well, ie CHI for Chicago and NYC for New York. It might be worthwhile to piggyback off of that for consistencies sake.

I'll take you up on that sometime soon hopefully. I'm a bit far from the bay area atm.

What is the data source?

http://www.transtats.bts.gov/Fields.asp?Table_ID=236

just contact me at nikhilb at ml1.net and you've got your beers.

Reply on news.ycombinator.com