tk-20260728-155120

Scanned

233
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 151 0 0 0 β€” β€” 0 0
ndc_direct 82 82 100 54 20.3 45.66 104.46 1

download this table as CSV

Commission amounts seen

The commission amounts actually seen, commonest first

sourcecommissionoffer_countroutespct_of_source
ndc_direct 45.66 6 1 7.3
ndc_direct 88.86 5 1 6.1
ndc_direct 26.6 4 1 4.9
ndc_direct 43.47 3 1 3.7
ndc_direct 36.9 3 1 3.7
ndc_direct 70.56 2 1 2.4
ndc_direct 69.02 2 1 2.4
ndc_direct 68.67 2 1 2.4
ndc_direct 62.64 2 1 2.4
ndc_direct 53.76 2 1 2.4
ndc_direct 43.56 2 1 2.4
ndc_direct 42.06 2 1 2.4
ndc_direct 39.36 2 1 2.4
ndc_direct 38.46 2 1 2.4
ndc_direct 34.37 2 1 2.4
ndc_direct 34.02 2 1 2.4
ndc_direct 32.7 2 1 2.4
ndc_direct 104.46 1 1 1.2
ndc_direct 104.16 1 1 1.2
ndc_direct 93.36 1 1 1.2
ndc_direct 90.66 1 1 1.2
ndc_direct 89.76 1 1 1.2
ndc_direct 86.76 1 1 1.2
ndc_direct 74.46 1 1 1.2
ndc_direct 65.04 1 1 1.2
ndc_direct 63.84 1 1 1.2
ndc_direct 61.44 1 1 1.2
ndc_direct 58.74 1 1 1.2
ndc_direct 57.84 1 1 1.2
ndc_direct 57.54 1 1 1.2
ndc_direct 56.16 1 1 1.2
ndc_direct 55.58 1 1 1.2
ndc_direct 55.23 1 1 1.2
ndc_direct 54.06 1 1 1.2
ndc_direct 52.86 1 1 1.2
ndc_direct 51.66 1 1 1.2
ndc_direct 51.36 1 1 1.2
ndc_direct 51.06 1 1 1.2
ndc_direct 50.16 1 1 1.2
ndc_direct 49.86 1 1 1.2
ndc_direct 47.76 1 1 1.2
ndc_direct 44.76 1 1 1.2
ndc_direct 43.82 1 1 1.2
ndc_direct 43.26 1 1 1.2
ndc_direct 39.66 1 1 1.2
ndc_direct 39.3 1 1 1.2
ndc_direct 38.16 1 1 1.2
ndc_direct 38.1 1 1 1.2
ndc_direct 34.2 1 1 1.2
ndc_direct 33.9 1 1 1.2

Showing the first 50 of 54 rows β€” 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 82 82 100 20.3 104.46
SSH SEA amadeus 151 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-09-11 β€” TK699-TK79-UA2483 ndc_direct economy 104.46 2024.56 1
SSH SEA 2026-09-07 β€” TK699-TK79-UA2611 ndc_direct economy 104.16 2019.86 1
SSH SEA 2026-09-11 β€” TK699-TK5-UA2211 ndc_direct economy 93.36 1810.66 1
SSH SEA 2026-09-07 β€” TK699-TK5-UA2211 ndc_direct economy 90.66 1768.36 1
SSH SEA 2026-09-06 β€” TK699-TK5-UA2211 ndc_direct economy 89.76 1754.26 1
SSH SEA 2026-09-02 β€” TK701-TK79-TK9587 ndc_direct economy 88.86 1780.16 1
SSH SEA 2026-09-02 β€” TK701-TK289-TK9587 ndc_direct economy 88.86 1780.16 1
SSH SEA 2026-09-03 β€” TK701-TK79-TK9587 ndc_direct economy 88.86 1780.16 1
SSH SEA 2026-09-09 β€” TK701-TK289-TK9587 ndc_direct economy 88.86 1780.16 1
SSH SEA 2026-09-09 β€” TK701-TK79-TK9587 ndc_direct economy 88.86 1780.16 1
SSH SEA 2026-09-07 β€” TK699-TK79-UA1007 ndc_direct economy 86.76 1747.26 1
SSH SEA 2026-09-13 β€” TK699-TK5-UA2211 ndc_direct economy 74.46 1514.56 1
SSH SEA 2026-09-12 β€” TK701-TK79-TK9587 ndc_direct economy 70.56 1493.46 1
SSH SEA 2026-09-13 β€” TK699-TK79-TK9587 ndc_direct economy 70.56 1493.46 1
SSH SEA 2026-09-05 β€” TK701-TK203 ndc_direct economy 69.02 1294.9 1
SSH SEA 2026-09-05 β€” TK699-TK203 ndc_direct economy 69.02 1294.9 1
SSH SEA 2026-09-02 β€” TK701-TK203 ndc_direct economy 68.67 1290.25 1
SSH SEA 2026-09-03 β€” TK701-TK203 ndc_direct economy 68.67 1290.25 1
SSH SEA 2026-09-02 β€” TK701-TK185-TK8609 ndc_direct economy 65.04 1366.98 1
SSH SEA 2026-09-08 β€” TK699-TK5-UA2211 ndc_direct economy 63.84 1348.18 1
SSH SEA 2026-09-01 β€” TK699-TK5-UA2211 ndc_direct economy 62.64 1329.38 1
SSH SEA 2026-09-08 β€” TK699-TK5-UA341 ndc_direct economy 62.64 1351.24 1
SSH SEA 2026-09-13 β€” TK699-TK79-UA2483 ndc_direct economy 61.44 1350.58 1
SSH SEA 2026-09-08 β€” TK699-TK79-UA2483 ndc_direct economy 58.74 1308.28 1
SSH SEA 2026-09-13 β€” TK699-TK79-UA1007 ndc_direct economy 57.84 1294.18 1
SSH SEA 2026-09-01 β€” TK699-TK79-UA2611 ndc_direct economy 57.54 1289.48 1
SSH SEA 2026-09-03 β€” TK701-TK185-TK8609 ndc_direct economy 56.16 1227.86 1
SSH SEA 2026-09-06 β€” TK699-TK213 ndc_direct economy 55.58 1116.34 1
SSH SEA 2026-09-01 β€” TK699-TK203 ndc_direct economy 55.23 1111.69 1
SSH SEA 2026-09-06 β€” TK699-TK185-TK8609 ndc_direct economy 54.06 1194.96 1
SSH SEA 2026-09-07 β€” TK699-TK5-TK8609 ndc_direct economy 53.76 1190.26 1
SSH SEA 2026-09-10 β€” TK701-TK185-TK8609 ndc_direct economy 53.76 1190.26 1
SSH SEA 2026-09-12 β€” TK699-TK5-UA2211 ndc_direct economy 52.86 1176.16 1
SSH SEA 2026-09-13 β€” TK699-TK5-TK8609 ndc_direct economy 51.66 1157.36 1
SSH SEA 2026-09-11 β€” TK699-TK79-TK9587 ndc_direct economy 51.36 1192.66 1
SSH SEA 2026-09-10 β€” TK701-TK79-TK9587 ndc_direct economy 51.06 1187.96 1
SSH SEA 2026-09-06 β€” TK699-TK79-UA2611 ndc_direct economy 50.16 1173.86 1
SSH SEA 2026-09-07 β€” TK699-TK79-TK9587 ndc_direct economy 49.86 1169.16 1
SSH SEA 2026-09-12 β€” TK699-TK79-UA2483 ndc_direct economy 47.76 1136.26 1
SSH SEA 2026-09-01 β€” TK699-TK185-TK8609 ndc_direct economy 45.66 1063.36 1
SSH SEA 2026-09-07 β€” TK701-TK185-TK8609 ndc_direct economy 45.66 1063.36 1
SSH SEA 2026-09-07 β€” TK699-TK185-TK8609 ndc_direct economy 45.66 1063.36 1
SSH SEA 2026-09-08 β€” TK699-TK185-TK8609 ndc_direct economy 45.66 1063.36 1
SSH SEA 2026-09-08 β€” TK699-TK5-TK8609 ndc_direct economy 45.66 1063.36 1
SSH SEA 2026-09-09 β€” TK701-TK185-TK8609 ndc_direct economy 45.66 1063.36 1
SSH SEA 2026-09-06 β€” TK699-TK5-TK8609 ndc_direct economy 44.76 1049.26 1
SSH SEA 2026-09-06 β€” TK699-TK203 ndc_direct economy 43.82 960.1 1
SSH SEA 2026-09-11 β€” TK701-TK185-TK8609 ndc_direct economy 43.56 1030.46 1
SSH SEA 2026-09-12 β€” TK699-TK5-TK8609 ndc_direct economy 43.56 1030.46 1
SSH SEA 2026-09-07 β€” TK701-TK203 ndc_direct economy 43.47 955.45 1
SSH SEA 2026-09-07 β€” TK699-TK203 ndc_direct economy 43.47 955.45 1
SSH SEA 2026-09-10 β€” TK701-TK203 ndc_direct economy 43.47 955.45 1
SSH SEA 2026-09-01 β€” TK699-TK5-TK8609 ndc_direct economy 43.26 1025.76 1
SSH SEA 2026-09-05 β€” TK699-TK79-UA2611 ndc_direct economy 42.06 1046.96 1
SSH SEA 2026-09-06 β€” TK699-TK289-TK9587 ndc_direct economy 42.06 1046.96 1
SSH SEA 2026-09-06 β€” TK699-TK79-TK9587 ndc_direct economy 39.66 1009.36 1
SSH SEA 2026-09-07 β€” TK701-TK79-TK9587 ndc_direct economy 39.36 1004.66 1
SSH SEA 2026-09-08 β€” TK699-TK79-TK9587 ndc_direct economy 39.36 1004.66 1
SSH SEA 2026-09-13 β€” TK699-TK185-TK8609 ndc_direct economy 39.3 963.72 1
SSH SEA 2026-09-11 β€” TK701-TK79-TK9587 ndc_direct economy 38.46 990.56 1
SSH SEA 2026-09-12 β€” TK699-TK79-TK9587 ndc_direct economy 38.46 990.56 1
SSH SEA 2026-09-01 β€” TK699-TK79-TK9587 ndc_direct economy 38.16 985.86 1
SSH SEA 2026-09-05 β€” TK699-TK185-TK8609 ndc_direct economy 38.1 944.92 1
SSH SEA 2026-09-05 β€” TK699-TK5-TK8609 ndc_direct economy 36.9 926.12 1
SSH SEA 2026-09-12 β€” TK701-TK185-TK8609 ndc_direct economy 36.9 926.12 1
SSH SEA 2026-09-12 β€” TK699-TK185-TK8609 ndc_direct economy 36.9 926.12 1
SSH SEA 2026-09-11 β€” TK701-TK203 ndc_direct economy 34.37 834.55 1
SSH SEA 2026-09-11 β€” TK701-TK213 ndc_direct economy 34.37 834.55 1
SSH SEA 2026-09-05 β€” TK699-TK79-TK9587 ndc_direct economy 34.2 923.82 1
SSH SEA 2026-09-08 β€” TK699-TK203 ndc_direct economy 34.02 829.9 1
SSH SEA 2026-09-09 β€” TK701-TK203 ndc_direct economy 34.02 829.9 1
SSH SEA 2026-09-11 β€” TK699-TK5-TK8609 ndc_direct economy 33.9 879.12 1
SSH SEA 2026-09-05 β€” TK699-TK5-UA2211 ndc_direct economy 32.7 860.32 1
SSH SEA 2026-09-05 β€” TK701-TK185-TK8609 ndc_direct economy 32.7 860.32 1
SSH SEA 2026-09-11 β€” TK699-TK185-TK8609 ndc_direct economy 31.5 841.52 1
SSH SEA 2026-09-13 β€” TK699-TK289-TK9587 ndc_direct economy 28.8 839.22 1
SSH SEA 2026-09-05 β€” TK701-TK79-TK9587 ndc_direct economy 27.6 820.42 1
SSH SEA 2026-09-11 β€” TK699-TK203 ndc_direct economy 26.6 731.32 1
SSH SEA 2026-09-12 β€” TK699-TK203 ndc_direct economy 26.6 731.32 1
SSH SEA 2026-09-12 β€” TK701-TK203 ndc_direct economy 26.6 731.32 1
SSH SEA 2026-09-13 β€” TK699-TK203 ndc_direct economy 26.6 731.32 1
SSH SEA 2026-09-11 β€” TK699-TK213 ndc_direct economy 20.3 647.62 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
amadeus wins on fare 12 -136.58 44.84 -91.75 0
ndc wins on fare 11 236.09 38.1 274.19 0
ndc wins on commission 7 -7.29 57.35 50.06 7

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 151 683.92 1179.76 1162.92 1
ndc_direct published 82 647.62 1165.81 1063.36 1

download this table as CSV

Download raw data (parquet)