DataBrighten

    International tourism, expenditures for passenger transport items (current US$)

    3,709 × 6rows × columns: 185 countries, 1995 to 2020

    Real data: World Bank, World Development Indicators, indicator ST.INT.TRNX.CD, retrieved 19 November 2026. Values are as published; we only reshaped the file.

    textnumberdateyes/no
    Rows3,709country-year values
    Countries185with at least one value
    Years1995 – 202026 years with data
    LicenceCC BY 4.0credit the World Bank

    What it measures

    International tourism expenditures for passenger transport items are expenditures of international outbound visitors in other countries for all services provided during international transportation by nonresident carriers. Also included are passenger services performed within an economy by nonresident carriers. Excluded are passenger services provided to nonresidents by resident carriers within the resident economies; these are included in travel items. In addition to the services covered by passenger fares--including fares that are a part of package tours but excluding cruise fares, which…

    Read the full definition

    International tourism expenditures for passenger transport items are expenditures of international outbound visitors in other countries for all services provided during international transportation by nonresident carriers. Also included are passenger services performed within an economy by nonresident carriers. Excluded are passenger services provided to nonresidents by resident carriers within the resident economies; these are included in travel items. In addition to the services covered by passenger fares--including fares that are a part of package tours but excluding cruise fares, which are included in travel--passenger services include such items as charges for excess baggage, vehicles, or other personal accompanying effects and expenditures for food, drink, or other items for which passengers make expenditures while on board carriers. Data are in current U.S. dollars.

    The numbers in 2020

    In 2020, 131 countries have a value. The highest is United States (13.03 billion); the lowest is Solomon Islands (10,000). The median country value is 65.00 million. The World Bank's World aggregate for 2019 is 249.92 billion.

    Top 10 countries, 2020

    current US$

    Source: World Bank, ST.INT.TRNX.CD, retrieved 19 November 2026. Computed from international-tourism-expenditures-for-passenger-transport-items-current-usd.csv.

    Highest, 2020

    #CountryValue
    1United States13.03 billion
    2Qatar4.76 billion
    3France3.44 billion
    4India3.20 billion
    5Italy2.11 billion
    6Russian Federation1.66 billion
    7Japan1.29 billion
    8Australia1.17 billion
    9Brazil1.10 billion
    10Guinea1.07 billion

    Lowest, 2020

    #CountryValue
    1Solomon Islands10,000
    2Gambia, The200,000
    3Eswatini400,000
    4Samoa500,000
    5Ethiopia500,000
    6Lesotho1.00 million
    7Belize1.49 million
    8Sint Maarten (Dutch part)2.00 million
    9Fiji2.00 million
    10Botswana2.80 million
    How many countries report, by decade
    DecadeMost countries in one year
    1990s126
    2000s154
    2010s159
    2020s131

    World aggregate by year

    As published by the World Bank (in the regions file, not the country file).

    YearWorld
    2019249.92 billion
    2018247.82 billion
    2017222.82 billion
    2016207.77 billion
    2015209.78 billion
    2014230.50 billion
    2013231.41 billion
    2012240.30 billion
    2011230.69 billion
    2010203.71 billion
    2009174.46 billion
    2008202.20 billion

    First rows

    international-tourism-expenditures-for-passenger-transport-items-current-usd.csv

    countrytextiso3textregiontextincome_grouptextyearnumbervaluenumber
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20082000000
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20092000000
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20103000000
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20119000000
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20125000000
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20136000000
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20143000000
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20154000000

    Data dictionary

    ColumnTypeMeaning
    countrytextCountry or economy, World Bank name
    iso3textISO 3166-1 alpha-3 code
    regiontextWorld Bank region
    income_grouptextWorld Bank income group
    yearnumberCalendar year of the value
    valuenumberInternational tourism, expenditures for passenger transport items (current US$), exactly as the World Bank API returns it (not rounded)

    Only country-years with a value are in the long file; blank cells in the wide file mean no value was published.

    Practice questions

    answers computed from the file

    Which country has the highest value in 2020?

    United States, with 13.03 billion.

    Excel (on the long CSV: E = year, F = value)

    =FILTER(A2:A100000,(E2:E100000=2020)*(F2:F100000=MAXIFS(F2:F100000,E2:E100000,2020)))

    SQL (table wb = the CSV)

    SELECT country, value FROM wb WHERE year = 2020
      AND value = (SELECT MAX(value) FROM wb WHERE year = 2020);

    pandas (df = pd.read_csv("international-tourism-expenditures-for-passenger-transport-items-current-usd.csv"))

    y = df[df.year == 2020]
    y[y.value == y.value.max()][["country", "value"]]

    File: international-tourism-expenditures-for-passenger-transport-items-current-usd.csv

    How many countries report a value for 2020?

    131 of the 217 economies in the file's country list.

    Excel (on the long CSV: E = year, F = value)

    =COUNTIF(E2:E100000,2020)

    SQL (table wb = the CSV)

    SELECT COUNT(*) FROM wb WHERE year = 2020;

    pandas (df = pd.read_csv("international-tourism-expenditures-for-passenger-transport-items-current-usd.csv"))

    (df.year == 2020).sum()

    File: international-tourism-expenditures-for-passenger-transport-items-current-usd.csv

    What is the median across countries in 2020?

    65.00 million (median of the 131 country values; not a World Bank aggregate).

    Excel (on the long CSV: E = year, F = value)

    =MEDIAN(FILTER(F2:F100000,E2:E100000=2020))

    SQL (table wb = the CSV)

    -- SQLite has no MEDIAN(); this picks the middle value(s)
    SELECT AVG(value) FROM (SELECT value FROM wb WHERE year = 2020 ORDER BY value
      LIMIT 2 - (SELECT COUNT(*) FROM wb WHERE year = 2020) % 2
      OFFSET (SELECT (COUNT(*) - 1) / 2 FROM wb WHERE year = 2020));

    pandas (df = pd.read_csv("international-tourism-expenditures-for-passenger-transport-items-current-usd.csv"))

    df[df.year == 2020]["value"].median()

    File: international-tourism-expenditures-for-passenger-transport-items-current-usd.csv

    Which country rose the most between 2010 and 2020?

    Guinea: from 8.50 million to 1.07 billion, a rise of 1.06 billion (out of 114 countries with both years).

    Excel (on the long CSV: E = year, F = value)

    Use the wide file (international-tourism-expenditures-for-passenger-transport-items-current-usd-wide.csv): add a column = [2020] - [2010], then sort it largest to smallest.

    SQL (table wb = the CSV)

    SELECT a.country, b.value - a.value AS rise FROM wb a JOIN wb b ON a.iso3 = b.iso3
    WHERE a.year = 2010 AND b.year = 2020 ORDER BY rise DESC LIMIT 1;

    pandas (df = pd.read_csv("international-tourism-expenditures-for-passenger-transport-items-current-usd.csv"))

    w = df.pivot(index="country", columns="year", values="value")
    (w[2020] - w[2010]).dropna().nlargest(1)

    File: international-tourism-expenditures-for-passenger-transport-items-current-usd.csv

    Which year has the most countries reporting?

    2015, with 159 countries. (Later years are still filling in as countries report.)

    Excel (on the long CSV: E = year, F = value)

    Make a pivot table: year in Rows, Count of value in Values, then sort by the count.

    SQL (table wb = the CSV)

    SELECT year, COUNT(*) AS n FROM wb GROUP BY year ORDER BY n DESC, year DESC LIMIT 1;

    pandas (df = pd.read_csv("international-tourism-expenditures-for-passenger-transport-items-current-usd.csv"))

    df.groupby("year").size().sort_values(ascending=False).head(1)

    File: international-tourism-expenditures-for-passenger-transport-items-current-usd.csv