lo-20260728-141655

Scanned

1190
Offers
1
Routes
0
Errors
production
Env
roundtrip
Trip
LO
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 650 0 0 0 โ€” โ€” 0 0
ndc_direct 540 540 100 12 11.1 27.24 40.98 1

download this table as CSV

Commission amounts seen

The commission amounts actually seen, commonest first

sourcecommissionoffer_countroutespct_of_source
ndc_direct 36.3 115 1 21.3
ndc_direct 27.9 115 1 21.3
ndc_direct 21.9 115 1 21.3
ndc_direct 11.1 115 1 21.3
ndc_direct 40.98 10 1 1.9
ndc_direct 38.7 10 1 1.9
ndc_direct 32.58 10 1 1.9
ndc_direct 30.3 10 1 1.9
ndc_direct 26.58 10 1 1.9
ndc_direct 24.3 10 1 1.9
ndc_direct 15.78 10 1 1.9
ndc_direct 13.5 10 1 1.9

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 RZE ndc_direct 540 540 100 11.1 40.98
JFK RZE amadeus 650 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 RZE 2026-09-22 2026-10-03 LO27-LO3809 / LO3806-LO6 ndc_direct economy 40.98 892.75 4
JFK RZE 2026-09-22 2026-10-03 LO27-LO3809 / LO3804-LO6 ndc_direct economy 40.98 892.75 4
JFK RZE 2026-09-22 2026-10-03 LO27-LO3809 / LO3806-LO26 ndc_direct economy 40.98 892.75 4
JFK RZE 2026-09-22 2026-10-03 LO27-LO3809 / LO3804-LO26 ndc_direct economy 40.98 892.75 4
JFK RZE 2026-09-22 2026-10-03 LO27-LO3809 / LO3802-LO26 ndc_direct economy 40.98 892.75 4
JFK RZE 2026-09-23 2026-10-03 LO7-LO3809 / LO3804-LO6 ndc_direct economy 40.98 892.75 4
JFK RZE 2026-09-23 2026-10-03 LO7-LO3809 / LO3806-LO6 ndc_direct economy 40.98 892.75 4
JFK RZE 2026-09-23 2026-10-03 LO7-LO3809 / LO3806-LO26 ndc_direct economy 40.98 892.75 4
JFK RZE 2026-09-23 2026-10-03 LO7-LO3809 / LO3802-LO26 ndc_direct economy 40.98 892.75 4
JFK RZE 2026-09-23 2026-10-03 LO7-LO3809 / LO3804-LO26 ndc_direct economy 40.98 892.75 4
JFK RZE 2026-09-22 2026-10-03 LO27-LO3803 / LO3806-LO6 ndc_direct economy 38.7 857.03 4
JFK RZE 2026-09-22 2026-10-03 LO27-LO3803 / LO3804-LO6 ndc_direct economy 38.7 857.03 4
JFK RZE 2026-09-22 2026-10-03 LO7-LO3803 / LO3802-LO26 ndc_direct economy 38.7 857.03 4
JFK RZE 2026-09-22 2026-10-03 LO7-LO3803 / LO3806-LO6 ndc_direct economy 38.7 857.03 4
JFK RZE 2026-09-22 2026-10-03 LO27-LO3803 / LO3806-LO26 ndc_direct economy 38.7 857.03 4
JFK RZE 2026-09-22 2026-10-03 LO7-LO3803 / LO3806-LO26 ndc_direct economy 38.7 857.03 4
JFK RZE 2026-09-22 2026-10-03 LO7-LO3803 / LO3804-LO26 ndc_direct economy 38.7 857.03 4
JFK RZE 2026-09-22 2026-10-03 LO27-LO3803 / LO3802-LO26 ndc_direct economy 38.7 857.03 4
JFK RZE 2026-09-22 2026-10-03 LO27-LO3803 / LO3804-LO26 ndc_direct economy 38.7 857.03 4
JFK RZE 2026-09-22 2026-10-03 LO7-LO3803 / LO3804-LO6 ndc_direct economy 38.7 857.03 4
JFK RZE 2026-09-21 2026-10-03 LO7-LO3801 / LO3804-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-21 2026-10-03 LO27-LO3803 / LO3806-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-21 2026-10-03 LO7-LO3807 / LO3802-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-21 2026-10-03 LO7-LO3805 / LO3806-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-21 2026-10-03 LO7-LO3805 / LO3804-LO6 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-21 2026-10-03 LO7-LO3803 / LO3804-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-21 2026-10-03 LO7-LO3805 / LO3802-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-21 2026-10-03 LO27-LO3805 / LO3804-LO6 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-21 2026-10-03 LO27-LO3809 / LO3806-LO6 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-21 2026-10-03 LO27-LO3809 / LO3802-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-21 2026-10-03 LO7-LO3803 / LO3806-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-21 2026-10-03 LO7-LO3809 / LO3806-LO6 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-21 2026-10-03 LO7-LO3801 / LO3802-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-21 2026-10-03 LO7-LO3801 / LO3806-LO6 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-21 2026-10-03 LO27-LO3807 / LO3804-LO6 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-21 2026-10-03 LO27-LO3803 / LO3804-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-21 2026-10-03 LO7-LO3801 / LO3804-LO6 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-21 2026-10-03 LO27-LO3803 / LO3802-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-21 2026-10-03 LO7-LO3801 / LO3806-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-21 2026-10-03 LO7-LO3807 / LO3804-LO6 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-21 2026-10-03 LO27-LO3807 / LO3804-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-21 2026-10-03 LO7-LO3803 / LO3804-LO6 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-21 2026-10-03 LO7-LO3803 / LO3802-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-21 2026-10-03 LO7-LO3807 / LO3804-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-21 2026-10-03 LO27-LO3805 / LO3802-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-21 2026-10-03 LO27-LO3805 / LO3806-LO6 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-21 2026-10-03 LO7-LO3807 / LO3806-LO6 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-21 2026-10-03 LO7-LO3805 / LO3804-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-21 2026-10-03 LO27-LO3809 / LO3804-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-21 2026-10-03 LO27-LO3805 / LO3804-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-21 2026-10-03 LO27-LO3809 / LO3806-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-21 2026-10-03 LO27-LO3809 / LO3804-LO6 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-21 2026-10-03 LO27-LO3805 / LO3806-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-21 2026-10-03 LO7-LO3805 / LO3806-LO6 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-21 2026-10-03 LO7-LO3803 / LO3806-LO6 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-21 2026-10-03 LO27-LO3803 / LO3804-LO6 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-21 2026-10-03 LO7-LO3807 / LO3806-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-21 2026-10-03 LO27-LO3803 / LO3806-LO6 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-21 2026-10-03 LO7-LO3809 / LO3804-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-21 2026-10-03 LO7-LO3809 / LO3802-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-21 2026-10-03 LO27-LO3807 / LO3806-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-21 2026-10-03 LO27-LO3807 / LO3806-LO6 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-21 2026-10-03 LO7-LO3809 / LO3804-LO6 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-21 2026-10-03 LO7-LO3809 / LO3806-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-21 2026-10-03 LO27-LO3807 / LO3802-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-22 2026-10-03 LO7-LO3809 / LO3806-LO6 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-22 2026-10-03 LO7-LO3809 / LO3802-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-22 2026-10-03 LO27-LO3805 / LO3804-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-22 2026-10-03 LO27-LO3805 / LO3802-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-22 2026-10-03 LO7-LO3807 / LO3804-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-22 2026-10-03 LO7-LO3801 / LO3804-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-22 2026-10-03 LO7-LO3807 / LO3806-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-22 2026-10-03 LO27-LO3807 / LO3806-LO6 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-22 2026-10-03 LO27-LO3805 / LO3806-LO6 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-22 2026-10-03 LO7-LO3809 / LO3806-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-22 2026-10-03 LO7-LO3809 / LO3804-LO6 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-22 2026-10-03 LO7-LO3805 / LO3804-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-22 2026-10-03 LO7-LO3805 / LO3806-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-22 2026-10-03 LO7-LO3805 / LO3804-LO6 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-22 2026-10-03 LO27-LO3805 / LO3806-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-22 2026-10-03 LO7-LO3805 / LO3806-LO6 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-22 2026-10-03 LO7-LO3805 / LO3802-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-22 2026-10-03 LO27-LO3805 / LO3804-LO6 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-22 2026-10-03 LO7-LO3807 / LO3806-LO6 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-22 2026-10-03 LO27-LO3807 / LO3804-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-22 2026-10-03 LO7-LO3801 / LO3804-LO6 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-22 2026-10-03 LO7-LO3807 / LO3804-LO6 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-22 2026-10-03 LO7-LO3809 / LO3804-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-22 2026-10-03 LO7-LO3801 / LO3806-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-22 2026-10-03 LO27-LO3807 / LO3806-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-22 2026-10-03 LO7-LO3807 / LO3802-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-22 2026-10-03 LO27-LO3807 / LO3804-LO6 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-22 2026-10-03 LO7-LO3801 / LO3806-LO6 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-22 2026-10-03 LO27-LO3807 / LO3802-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-22 2026-10-03 LO7-LO3801 / LO3802-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-23 2026-10-03 LO7-LO3807 / LO3802-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-23 2026-10-03 LO27-LO3807 / LO3806-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-23 2026-10-03 LO7-LO3801 / LO3804-LO6 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-23 2026-10-03 LO27-LO3807 / LO3804-LO6 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-23 2026-10-03 LO27-LO3803 / LO3806-LO6 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-23 2026-10-03 LO27-LO3807 / LO3806-LO6 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-23 2026-10-03 LO27-LO3803 / LO3804-LO6 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-23 2026-10-03 LO7-LO3803 / LO3802-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-23 2026-10-03 LO7-LO3803 / LO3806-LO6 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-23 2026-10-03 LO27-LO3805 / LO3802-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-23 2026-10-03 LO7-LO3803 / LO3806-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-23 2026-10-03 LO27-LO3809 / LO3802-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-23 2026-10-03 LO7-LO3805 / LO3802-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-23 2026-10-03 LO27-LO3809 / LO3804-LO6 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-23 2026-10-03 LO27-LO3809 / LO3804-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-23 2026-10-03 LO7-LO3805 / LO3804-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-23 2026-10-03 LO27-LO3807 / LO3802-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-23 2026-10-03 LO7-LO3807 / LO3806-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-23 2026-10-03 LO7-LO3807 / LO3804-LO6 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-23 2026-10-03 LO7-LO3801 / LO3806-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-23 2026-10-03 LO7-LO3801 / LO3806-LO6 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-23 2026-10-03 LO7-LO3807 / LO3806-LO6 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-23 2026-10-03 LO27-LO3803 / LO3802-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-23 2026-10-03 LO27-LO3807 / LO3804-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-23 2026-10-03 LO7-LO3801 / LO3804-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-23 2026-10-03 LO7-LO3807 / LO3804-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-23 2026-10-03 LO27-LO3803 / LO3806-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-23 2026-10-03 LO27-LO3803 / LO3804-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-23 2026-10-03 LO27-LO3805 / LO3806-LO6 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-23 2026-10-03 LO27-LO3809 / LO3806-LO6 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-23 2026-10-03 LO27-LO3805 / LO3804-LO6 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-23 2026-10-03 LO7-LO3803 / LO3804-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-23 2026-10-03 LO7-LO3805 / LO3806-LO6 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-23 2026-10-03 LO27-LO3805 / LO3806-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-23 2026-10-03 LO27-LO3809 / LO3806-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-23 2026-10-03 LO7-LO3805 / LO3804-LO6 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-23 2026-10-03 LO27-LO3805 / LO3804-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-23 2026-10-03 LO7-LO3805 / LO3806-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-23 2026-10-03 LO7-LO3801 / LO3802-LO26 ndc_direct economy 36.3 819.43 4
JFK RZE 2026-09-23 2026-10-03 LO7-LO3803 / LO3804-LO6 ndc_direct economy 36.3 819.43 4

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 75 15.93 11.57 27.51 0

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 650 846.53 1000.54 1009.53 1
ndc_direct published 540 819.43 1034.45 1072.29 1

download this table as CSV

Download raw data (parquet)