tk-20260728-160842

Scanned

154
Offers
1
Routes
0
Errors
production
Env
oneway
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 91 0 0 0 β€” β€” 0 0
ndc_direct 63 63 100 32 19.25 32.1 88.56 1

download this table as CSV

Commission amounts seen

The commission amounts actually seen, commonest first

sourcecommissionoffer_countroutespct_of_source
ndc_direct 27 7 1 11.1
ndc_direct 19.6 7 1 11.1
ndc_direct 88.26 4 1 6.3
ndc_direct 30.6 4 1 6.3
ndc_direct 52.2 3 1 4.8
ndc_direct 25.8 3 1 4.8
ndc_direct 19.25 3 1 4.8
ndc_direct 62.34 2 1 3.2
ndc_direct 46.8 2 1 3.2
ndc_direct 46.56 2 1 3.2
ndc_direct 34.5 2 1 3.2
ndc_direct 33.3 2 1 3.2
ndc_direct 31.8 2 1 3.2
ndc_direct 25.5 2 1 3.2
ndc_direct 88.56 1 1 1.6
ndc_direct 83.04 1 1 1.6
ndc_direct 64.74 1 1 1.6
ndc_direct 61.14 1 1 1.6
ndc_direct 57.24 1 1 1.6
ndc_direct 55.86 1 1 1.6
ndc_direct 53.46 1 1 1.6
ndc_direct 52.8 1 1 1.6
ndc_direct 50.76 1 1 1.6
ndc_direct 50.46 1 1 1.6
ndc_direct 44.16 1 1 1.6
ndc_direct 42.66 1 1 1.6
ndc_direct 38.76 1 1 1.6
ndc_direct 33.32 1 1 1.6
ndc_direct 32.1 1 1 1.6
ndc_direct 29.4 1 1 1.6
ndc_direct 26.7 1 1 1.6
ndc_direct 25.55 1 1 1.6

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
SSH SEA ndc_direct 63 63 100 19.25 88.56
SSH SEA amadeus 91 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
SSH SEA 2026-10-18 β€” TK699-TK79-TK9587 ndc_direct economy 88.56 1775.46 1
SSH SEA 2026-10-14 β€” TK701-TK79-TK9587 ndc_direct economy 88.26 1770.76 1
SSH SEA 2026-10-14 β€” TK701-TK289-TK9587 ndc_direct economy 88.26 1770.76 1
SSH SEA 2026-10-21 β€” TK701-TK289-TK9587 ndc_direct economy 88.26 1770.76 1
SSH SEA 2026-10-21 β€” TK701-TK79-TK9587 ndc_direct economy 88.26 1770.76 1
SSH SEA 2026-10-18 β€” TK699-TK5-UA2211 ndc_direct economy 83.04 1648.98 1
SSH SEA 2026-10-24 β€” TK699-TK5-TK8609 ndc_direct economy 64.74 1305.88 2
SSH SEA 2026-10-04 β€” TK699-TK5-UA2211 ndc_direct economy 62.34 1324.68 1
SSH SEA 2026-10-24 β€” TK699-TK5-UA2211 ndc_direct economy 62.34 1324.68 1
SSH SEA 2026-10-31 β€” TK699-TK79-UA5579 ndc_direct economy 57.24 1284.78 1
SSH SEA 2026-10-11 β€” TK699-TK5-TK8609 ndc_direct economy 55.86 1223.16 1
SSH SEA 2026-10-11 β€” TK699-TK185-TK8609 ndc_direct economy 53.46 1185.56 1
SSH SEA 2026-10-11 β€” TK699-TK5-UA2211 ndc_direct economy 52.8 1175.22 1
SSH SEA 2026-10-18 β€” TK699-TK79-UA1007 ndc_direct economy 52.2 1205.82 1
SSH SEA 2026-10-18 β€” TK699-TK79-UA5579 ndc_direct economy 52.2 1205.82 1
SSH SEA 2026-10-18 β€” TK699-TK79-UA1097 ndc_direct economy 52.2 1205.82 1
SSH SEA 2026-10-04 β€” TK699-TK79-TK9587 ndc_direct economy 50.76 1183.26 1
SSH SEA 2026-10-08 β€” TK701-TK79-TK9587 ndc_direct economy 50.46 1178.56 1
SSH SEA 2026-10-04 β€” TK699-TK79-UA1097 ndc_direct economy 46.8 1121.22 1
SSH SEA 2026-10-11 β€” TK699-TK79-UA1097 ndc_direct economy 46.8 1121.22 1
SSH SEA 2026-10-31 β€” TK699-TK185-TK8609 ndc_direct economy 46.56 1077.46 1
SSH SEA 2026-10-31 β€” TK701-TK185-TK8609 ndc_direct economy 46.56 1077.46 1
SSH SEA 2026-10-04 β€” TK699-TK5-TK8609 ndc_direct economy 44.16 1039.86 1
SSH SEA 2026-10-01 β€” TK701-TK185-TK8609 ndc_direct economy 42.66 1016.36 1
SSH SEA 2026-10-01 β€” TK701-TK79-TK9587 ndc_direct economy 38.76 995.26 1
SSH SEA 2026-10-24 β€” TK699-TK185-TK8609 ndc_direct economy 34.5 888.52 1
SSH SEA 2026-10-24 β€” TK701-TK185-TK8609 ndc_direct economy 34.5 888.52 1
SSH SEA 2026-10-01 β€” TK701-TK203 ndc_direct economy 33.32 820.6 1
SSH SEA 2026-10-18 β€” TK699-TK185-TK8609 ndc_direct economy 33.3 869.72 1
SSH SEA 2026-10-18 β€” TK699-TK5-TK8609 ndc_direct economy 33.3 869.72 1
SSH SEA 2026-10-04 β€” TK699-TK185-TK8609 ndc_direct economy 32.1 850.92 1
SSH SEA 2026-10-28 β€” TK699-TK185-TK8609 ndc_direct economy 31.8 846.22 1
SSH SEA 2026-10-28 β€” TK699-TK5-TK8609 ndc_direct economy 31.8 859.93 1
SSH SEA 2026-10-08 β€” TK701-TK185-TK8609 ndc_direct economy 30.6 827.42 1
SSH SEA 2026-10-11 β€” TK699-TK79-UA1007 ndc_direct economy 30.6 867.42 1
SSH SEA 2026-10-14 β€” TK701-TK185-TK8609 ndc_direct economy 30.6 827.42 1
SSH SEA 2026-10-21 β€” TK701-TK185-TK8609 ndc_direct economy 30.6 827.42 1
SSH SEA 2026-10-11 β€” TK699-TK79-TK9587 ndc_direct economy 29.4 848.62 1
SSH SEA 2026-10-04 β€” TK699-TK79-UA1007 ndc_direct economy 27 811.02 1
SSH SEA 2026-10-04 β€” TK699-TK289-TK9587 ndc_direct economy 27 811.02 1
SSH SEA 2026-10-04 β€” TK699-TK79-UA5579 ndc_direct economy 27 811.02 1
SSH SEA 2026-10-11 β€” TK699-TK79-UA5579 ndc_direct economy 27 811.02 1
SSH SEA 2026-10-11 β€” TK699-TK289-TK9587 ndc_direct economy 27 811.02 1
SSH SEA 2026-10-24 β€” TK699-TK79-UA1097 ndc_direct economy 27 811.02 1
SSH SEA 2026-10-24 β€” TK699-TK79-UA1007 ndc_direct economy 27 811.02 1
SSH SEA 2026-10-28 β€” TK699-TK79-UA494 ndc_direct economy 26.7 814.33 1
SSH SEA 2026-10-18 β€” TK699-TK289-TK9587 ndc_direct economy 25.8 792.22 1
SSH SEA 2026-10-24 β€” TK701-TK79-TK9587 ndc_direct economy 25.8 792.22 1
SSH SEA 2026-10-24 β€” TK699-TK79-TK9587 ndc_direct economy 25.8 792.22 1
SSH SEA 2026-10-08 β€” TK701-TK203 ndc_direct economy 25.55 717.37 1
SSH SEA 2026-10-28 β€” TK699-TK79-TK9587 ndc_direct economy 25.5 787.52 1
SSH SEA 2026-10-28 β€” TK699-TK79-UA1007 ndc_direct economy 25.5 787.52 1
SSH SEA 2026-10-04 β€” TK699-TK203 ndc_direct economy 19.6 638.32 1
SSH SEA 2026-10-11 β€” TK699-TK203 ndc_direct economy 19.6 638.32 1
SSH SEA 2026-10-18 β€” TK699-TK203 ndc_direct economy 19.6 638.32 1
SSH SEA 2026-10-24 β€” TK701-TK203 ndc_direct economy 19.6 638.32 1
SSH SEA 2026-10-24 β€” TK699-TK203 ndc_direct economy 19.6 638.32 1
SSH SEA 2026-10-31 β€” TK701-TK203 ndc_direct economy 19.6 638.32 1
SSH SEA 2026-10-31 β€” TK699-TK203 ndc_direct economy 19.6 638.32 1
SSH SEA 2026-10-14 β€” TK701-TK203 ndc_direct economy 19.25 633.67 1
SSH SEA 2026-10-21 β€” TK701-TK203 ndc_direct economy 19.25 633.67 1
SSH SEA 2026-10-28 β€” TK699-TK203 ndc_direct economy 19.25 633.67 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 14 27.57 23.82 51.39 0
amadeus wins on fare 3 -249 40 -209 0
ndc wins on commission 3 -7 65.06 58.06 3

download this table as CSV

β–Ά Offer summary by source 2 Total offers by source and fare type
sourcefare_typeoffer_countmin_netavg_netmedian_netroutes
amadeus nego 91 668.92 859.92 673.92 1
ndc_direct published 63 633.67 996.29 859.93 1

download this table as CSV

Download raw data (parquet)