tk-20260728-152646

Scanned

263
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 185 0 0 0 β€” β€” 0 0
ndc_direct 78 39 50 7 25.12 29.6 52.08 1

download this table as CSV

Commission amounts seen

The commission amounts actually seen, commonest first

sourcecommissionoffer_countroutespct_of_source
ndc_direct 25.12 17 1 21.8
ndc_direct 44.64 5 1 6.4
ndc_direct 35.04 5 1 6.4
ndc_direct 29.6 5 1 6.4
ndc_direct 52.08 4 1 5.1
ndc_direct 41.44 2 1 2.6
ndc_direct 28.32 1 1 1.3

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
JFK DAC ndc_direct 78 39 50 25.12 52.08
JFK DAC amadeus 185 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
JFK DAC 2026-10-09 β€” TK12-TK712 ndc_direct economy 52.08 972.42 1
JFK DAC 2026-10-09 β€” TK12-TK722 ndc_direct economy 52.08 972.42 1
JFK DAC 2026-10-10 β€” TK12-TK712 ndc_direct economy 52.08 972.42 1
JFK DAC 2026-10-10 β€” TK4-TK712 ndc_direct economy 52.08 972.42 1
JFK DAC 2026-10-09 β€” TK4-TK712 ndc_direct economy 44.64 886.86 1
JFK DAC 2026-10-09 β€” TK2-TK722 ndc_direct economy 44.64 886.86 1
JFK DAC 2026-10-09 β€” TK2-TK712 ndc_direct economy 44.64 886.86 1
JFK DAC 2026-10-09 β€” TK4-TK722 ndc_direct economy 44.64 886.86 1
JFK DAC 2026-10-10 β€” TK2-TK712 ndc_direct economy 44.64 886.86 1
JFK DAC 2026-10-05 β€” TK4-TK712 ndc_direct economy 41.44 850.06 1
JFK DAC 2026-10-08 β€” TK12-TK712 ndc_direct economy 41.44 850.06 1
JFK DAC 2026-10-07 β€” TK12-TK712 ndc_direct economy 35.04 776.46 1
JFK DAC 2026-10-07 β€” TK4-TK712 ndc_direct economy 35.04 776.46 1
JFK DAC 2026-10-08 β€” TK112-TK712 ndc_direct economy 35.04 776.46 1
JFK DAC 2026-10-08 β€” TK112-TK722 ndc_direct economy 35.04 776.46 1
JFK DAC 2026-10-13 β€” TK4-TK712 ndc_direct economy 35.04 776.46 1
JFK DAC 2026-10-04 β€” TK12-TK712 ndc_direct economy 29.6 713.9 1
JFK DAC 2026-10-05 β€” TK2-TK712 ndc_direct economy 29.6 713.9 1
JFK DAC 2026-10-08 β€” TK4-TK712 ndc_direct economy 29.6 713.9 1
JFK DAC 2026-10-11 β€” TK12-TK712 ndc_direct economy 29.6 713.9 1
JFK DAC 2026-10-14 β€” TK4-TK712 ndc_direct economy 29.6 713.9 1
JFK DAC 2026-10-10 β€” TK112-TK712 ndc_direct economy 28.32 699.18 1
JFK DAC 2026-10-04 β€” TK2-TK712 ndc_direct economy 25.12 662.38 1
JFK DAC 2026-10-04 β€” TK4-TK712 ndc_direct economy 25.12 662.38 1
JFK DAC 2026-10-05 β€” TK12-TK712 ndc_direct economy 25.12 662.38 1
JFK DAC 2026-10-07 β€” TK2-TK712 ndc_direct economy 25.12 662.38 1
JFK DAC 2026-10-08 β€” TK12-TK722 ndc_direct economy 25.12 662.38 1
JFK DAC 2026-10-08 β€” TK2-TK722 ndc_direct economy 25.12 662.38 1
JFK DAC 2026-10-08 β€” TK4-TK722 ndc_direct economy 25.12 662.38 1
JFK DAC 2026-10-08 β€” TK2-TK712 ndc_direct economy 25.12 662.38 1
JFK DAC 2026-10-11 β€” TK2-TK712 ndc_direct economy 25.12 662.38 1
JFK DAC 2026-10-11 β€” TK4-TK712 ndc_direct economy 25.12 662.38 1
JFK DAC 2026-10-12 β€” TK4-TK712 ndc_direct economy 25.12 662.38 1
JFK DAC 2026-10-12 β€” TK12-TK712 ndc_direct economy 25.12 662.38 1
JFK DAC 2026-10-12 β€” TK2-TK712 ndc_direct economy 25.12 662.38 1
JFK DAC 2026-10-13 β€” TK12-TK712 ndc_direct economy 25.12 662.38 1
JFK DAC 2026-10-13 β€” TK2-TK712 ndc_direct economy 25.12 662.38 1
JFK DAC 2026-10-14 β€” TK12-TK712 ndc_direct economy 25.12 662.38 1
JFK DAC 2026-10-14 β€” TK2-TK712 ndc_direct economy 25.12 662.38 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 27 18.11 18.78 36.89 0
ndc wins on commission 10 -2.8 46.23 43.43 10

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 185 698.5 785.91 751.5 1
ndc_direct nego 39 662.5 752.73 713.5 1
ndc_direct published 39 662.38 754.76 713.9 1

download this table as CSV

Download raw data (parquet)