tk-20260729-160233

Scanned

4443
Offers
1
Routes
0
Errors
production
Env
roundtrip
Trip
TK
Carrier

Commission by source

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

sourceoffer_countwith_commissionpct_with_commissiondistinct_valuesmin_commissionmedian_commissionmax_commissionroutes_paying
amadeus 363 0 0 0 — — 0 0
ndc_direct 4080 17 0.4 10 19.92 39.12 46.72 1

download this table as CSV

Commission amounts seen

The commission amounts actually seen, commonest first

sourcecommissionoffer_countroutespct_of_source
ndc_direct 46.72 2 1 0
ndc_direct 41.92 2 1 0
ndc_direct 41.12 2 1 0
ndc_direct 39.12 2 1 0
ndc_direct 30.72 2 1 0
ndc_direct 25.12 2 1 0
ndc_direct 19.92 2 1 0
ndc_direct 45.12 1 1 0
ndc_direct 39.52 1 1 0
ndc_direct 27.52 1 1 0

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

origindestinationsourceoffer_countwith_commissionpct_with_commissionmin_commissionmax_commission
BOS TIV ndc_direct 4080 17 0 19.92 46.72
BOS TIV amadeus 363 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

origindestinationdeparture_datereturn_dateflight_codessourcecabincommissioncheapest_netoffer_count
BOS TIV 2026-09-13 2026-09-26 TK82-TK1097 / TK1098-TK81 ndc_direct economy 46.72 1120.61 1
BOS TIV 2026-09-13 2026-09-26 TK82-TK1095 / TK1098-TK81 ndc_direct economy 46.72 1120.61 1
BOS TIV 2026-09-15 2026-09-28 TK82-TK1095 / TK1098-TK81 ndc_direct economy 45.12 1102.21 1
BOS TIV 2026-09-09 2026-09-22 TK82-TK1097 / TK1096-TK81 ndc_direct economy 41.92 1065.41 1
BOS TIV 2026-09-09 2026-09-22 TK82-TK1095 / TK1096-TK81 ndc_direct economy 41.92 1065.41 1
BOS TIV 2026-09-13 2026-09-26 TK82-TK1097 / TK1096-TK81 ndc_direct economy 41.12 1056.21 1
BOS TIV 2026-09-13 2026-09-26 TK82-TK1095 / TK1096-TK81 ndc_direct economy 41.12 1056.21 1
BOS TIV 2026-09-12 2026-09-25 TK82-TK1097 / TK1098-TK81 ndc_direct economy 39.52 1037.81 1
BOS TIV 2026-09-10 2026-09-23 TK82-TK1097 / TK1098-TK81 ndc_direct economy 39.12 1033.21 1
BOS TIV 2026-09-10 2026-09-23 TK82-TK1095 / TK1098-TK81 ndc_direct economy 39.12 1033.21 1
BOS TIV 2026-09-11 2026-09-24 TK82-TK1097 / TK1096-TK81 ndc_direct economy 30.72 936.61 1
BOS TIV 2026-09-11 2026-09-24 TK82-TK1095 / TK1096-TK81 ndc_direct economy 30.72 936.61 1
BOS TIV 2026-09-15 2026-09-28 TK82-TK1097 / TK1098-TK81 ndc_direct economy 27.52 899.81 1
BOS TIV 2026-09-08 2026-09-21 TK82-TK1095 / TK1098-TK81 ndc_direct economy 25.12 872.21 1
BOS TIV 2026-09-08 2026-09-21 TK82-TK1097 / TK1098-TK81 ndc_direct economy 25.12 872.21 1
BOS TIV 2026-09-16 2026-09-29 TK82-TK1097 / TK1096-TK81 ndc_direct economy 19.92 812.41 1
BOS TIV 2026-09-16 2026-09-29 TK82-TK1095 / TK1096-TK81 ndc_direct economy 19.92 812.41 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

driveritinerariesavg_fare_gapavg_commission_gapavg_net_gapflips_without_commission
ndc wins on fare 66 46.68 1.09 47.77 0
amadeus wins on fare 22 -163.36 0 -163.36 0

download this table as CSV

â–¶ Offer summary by source 3 Total offers by source and fare type
sourcefare_typeoffer_countmin_netavg_netmedian_netroutes
amadeus nego 363 847.33 1357.21 1288.03 1
ndc_direct nego 2040 812.33 1524.76 1473.03 1
ndc_direct published 2040 812.41 1588.8 1501.73 1

download this table as CSV

Download raw data (parquet)