DataBrighten

    Lead time to import, median case (days)

    632 × 6rows × columns: 154 countries, 2007 to 2018

    Real data: World Bank, World Development Indicators, indicator LP.IMP.DURS.MD, retrieved 19 November 2026. Values are as published; we only reshaped the file.

    textnumberdateyes/no
    Rows632country-year values
    Countries154with at least one value
    Years2007 – 20186 years with data
    LicenceCC BY 4.0credit the World Bank

    What it measures

    Lead time to import is the median time (the value for 50 percent of shipments) from port of discharge to arrival at the consignee. Data are from the Logistics Performance Index survey. Respondents provided separate values for the best case (10 percent of shipments) and the median case (50 percent of shipments). The data are exponentiated averages of the logarithm of single value responses and of midpoint values of range responses for the median case.

    Limits and exceptions (World Bank note)

    The Logistics Performance Index is an interactive benchmarking tool created to help countries identify the challenges and opportunities they face in their performance on trade logistics and what they can do to improve their performance. Feedback from operators is supplemented with quantitative data on the performance of key components of the logistics chain in the country of work. Thus, the LPI consists of both qualitative and quantitative measures. In addition, despite being the most comprehensive data source for country logistics and trade facilitation, the LPI has two important limitations. First, the experience of international freight forwarders might not represent the broader logistics environment in poor countries, which often rely on traditional operators. And the international and traditional operators might differ in their interactions with government agencies - and in their service levels. Second, for landlocked countries and small-island states, the LPI might reflect access problems outside the country assessed, such as transit difficulties. The low rating of a landlocked country might not adequately reflect its trade facilitation efforts, which depend on the workings

    The numbers in 2018

    In 2018, 90 countries have a value. The highest is Gabon (25); at the bottom, 8 countries tie at 1 (e.g. Australia, Brunei Darussalam, Ghana). The median country value is 3. The World Bank's World aggregate for 2018 is 4.02.

    Top 10 countries, 2018

    days

    Source: World Bank, LP.IMP.DURS.MD, retrieved 19 November 2026. Computed from lead-time-to-import-median-case-days.csv.

    Highest, 2018

    #CountryValue
    1Gabon25
    2Albania14
    3Malawi14
    4Uganda14
    5Venezuela, RB12
    6Benin10
    7Ethiopia10
    8Pakistan8
    9Qatar7
    10Senegal7

    Lowest, 2018

    Ties are listed A to Z.

    #CountryValue
    1Poland1
    2Netherlands1
    3Malta1
    4Madagascar1
    5Latvia1
    6Ghana1
    7Brunei Darussalam1
    8Australia1
    9United States2
    10United Arab Emirates2
    How many countries report, by decade
    DecadeMost countries in one year
    2000s102
    2010s116

    World aggregate by year

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

    YearWorld
    20184.02
    20164.94
    20143.1
    20125.89
    20104.62
    20075.5

    By region, 2018

    World Bank regionValue
    Sub-Saharan Africa 6.76
    Latin America & Caribbean 5.2
    South Asia4.25
    Middle East, North Africa, Afghanistan & Pakistan3.8
    North America3.5
    Europe & Central Asia2.91
    East Asia & Pacific2.73

    First rows

    lead-time-to-import-median-case-days.csv

    countrytextiso3textregiontextincome_grouptextyearnumbervaluenumber
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income200720.7
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income20104
    AlbaniaALBEurope & Central AsiaUpper middle income20102
    AlbaniaALBEurope & Central AsiaUpper middle income20141
    AlbaniaALBEurope & Central AsiaUpper middle income201814
    AlgeriaDZAMiddle East, North Africa, Afghanistan & PakistanUpper middle income20107.07
    AlgeriaDZAMiddle East, North Africa, Afghanistan & PakistanUpper middle income201239
    AlgeriaDZAMiddle East, North Africa, Afghanistan & PakistanUpper middle income20144

    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
    valuenumberLead time to import, median case (days), 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 2018?

    Gabon, with 25.

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

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

    SQL (table wb = the CSV)

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

    pandas (df = pd.read_csv("lead-time-to-import-median-case-days.csv"))

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

    File: lead-time-to-import-median-case-days.csv

    How many countries report a value for 2018?

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

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

    =COUNTIF(E2:E100000,2018)

    SQL (table wb = the CSV)

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

    pandas (df = pd.read_csv("lead-time-to-import-median-case-days.csv"))

    (df.year == 2018).sum()

    File: lead-time-to-import-median-case-days.csv

    What is the median across countries in 2018?

    3 (median of the 90 country values; not a World Bank aggregate).

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

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

    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 = 2018 ORDER BY value
      LIMIT 2 - (SELECT COUNT(*) FROM wb WHERE year = 2018) % 2
      OFFSET (SELECT (COUNT(*) - 1) / 2 FROM wb WHERE year = 2018));

    pandas (df = pd.read_csv("lead-time-to-import-median-case-days.csv"))

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

    File: lead-time-to-import-median-case-days.csv

    Which country rose the most between 2010 and 2018?

    Albania: from 2 to 14, a rise of 12 (out of 71 countries with both years).

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

    Use the wide file (lead-time-to-import-median-case-days-wide.csv): add a column = [2018] - [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 = 2018 ORDER BY rise DESC LIMIT 1;

    pandas (df = pd.read_csv("lead-time-to-import-median-case-days.csv"))

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

    File: lead-time-to-import-median-case-days.csv

    Which year has the most countries reporting?

    2016, with 116 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("lead-time-to-import-median-case-days.csv"))

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

    File: lead-time-to-import-median-case-days.csv