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	35	0	0	0	—	—	0	0
ndc_direct	14	14	100	6	27.79	27.79	322.42	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	27.79	9	1	64.3
ndc_direct	322.42	1	1	7.1
ndc_direct	67.76	1	1	7.1
ndc_direct	47.39	1	1	7.1
ndc_direct	39.69	1	1	7.1
ndc_direct	33.18	1	1	7.1

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
PRN	IAH	ndc_direct	14	14	100	27.79	322.42
PRN	IAH	amadeus	35	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
PRN	IAH	2026-08-28	—	TK1020-TK33	ndc_direct	business	322.42	2637.31	1
PRN	IAH	2026-08-29	—	TK1020-TK33	ndc_direct	economy	67.76	1258.27	1
PRN	IAH	2026-08-30	—	TK1018-TK33	ndc_direct	economy	47.39	987.64	1
PRN	IAH	2026-08-29	—	TK1018-TK33	ndc_direct	economy	39.69	885.34	1
PRN	IAH	2026-08-31	—	TK1020-TK33	ndc_direct	economy	33.18	798.85	1
PRN	IAH	2026-08-27	—	TK1020-TK133	ndc_direct	economy	27.79	727.24	1
PRN	IAH	2026-08-27	—	TK1020-TK33	ndc_direct	economy	27.79	727.24	1
PRN	IAH	2026-08-27	—	TK1018-TK133	ndc_direct	economy	27.79	727.24	1
PRN	IAH	2026-08-27	—	TK1018-TK33	ndc_direct	economy	27.79	727.24	1
PRN	IAH	2026-08-28	—	TK1018-TK33	ndc_direct	economy	27.79	727.24	1
PRN	IAH	2026-08-30	—	TK1020-TK133	ndc_direct	economy	27.79	727.24	1
PRN	IAH	2026-08-30	—	TK1020-TK33	ndc_direct	economy	27.79	727.24	1
PRN	IAH	2026-08-30	—	TK1018-TK133	ndc_direct	economy	27.79	727.24	1
PRN	IAH	2026-08-31	—	TK1018-TK33	ndc_direct	economy	27.79	727.24	1

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	5	9.1	27.79	36.89	0
amadeus wins on fare	2	-215.9	43.54	-172.36	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	35	764.13	764.13	764.13	1
ndc_direct	published	14	727.24	936.61	727.24	1

download this table as CSV

Download raw data (parquet)