Commission by source

Per source: how much of it carries commission, and whether that is one flat amount or a spread of values

source	offer_count	with_commission	pct_with_commission	distinct_values	min_commission	median_commission	max_commission	routes_paying
amadeus	7	0	0	0	—	—	0	0
ndc_direct	4	4	100	4	10.5	24.3	35.7	1

download this table as CSV

Commission amounts seen

The commission amounts actually seen, commonest first

source	commission	offer_count	routes	pct_of_source
ndc_direct	35.7	1	1	25
ndc_direct	27.3	1	1	25
ndc_direct	21.3	1	1	25
ndc_direct	10.5	1	1	25

download this table as CSV

Commission coverage by routeroute

How much of each route carries commission — routes where only some offers pay are listed first

origin	destination	source	offer_count	with_commission	pct_with_commission	min_commission	max_commission
JFK	WAW	ndc_direct	4	4	100	10.5	35.7
JFK	WAW	amadeus	7	0	0	—	0

download this table as CSV

Bookable itineraries carrying commissionitinerary

Bookable itineraries that carry commission, one row each — the list to pick a test case from

origin	destination	departure_date	return_date	flight_codes	source	cabin	commission	cheapest_net	offer_count
JFK	WAW	2026-12-12	2026-12-29	LO27 / LO26	ndc_direct	economy	35.7	793.19	4

download this table as CSV

Fare vs commission, where both sources quoted

For itineraries both sources quoted: whether the cheaper net price comes from the fare or from the commission paid back — net price is the fare minus commission. The last column counts the wins that would reverse if commission were removed

driver	itineraries	avg_fare_gap	avg_commission_gap	avg_net_gap	flips_without_commission
ndc wins on fare	1	4	10.5	14.5	0

download this table as CSV

▶ Offer summary by source 2 Total offers by source and fare type

source	fare_type	offer_count	min_net	avg_net	median_net	routes
amadeus	nego	7	807.69	946.55	969.69	1
ndc_direct	published	4	793.19	999.99	1009.39	1

download this table as CSV

Download raw data (parquet)