DataBrighten

    World population by country

    5,208 × 6rows × columns in the file

    Updated 3 November 2026. Real data: World Bank, World Development Indicators, SP.POP.TOTL (Population, total).

    CSV XLSX JSON SQL
    textnumberdateyes/no
    Rows5,208in the file
    Columns6with a data dictionary below
    Dates2000 – 2023range in the file
    LicenceCC BY 4.0credit the source

    What is in it

    Total population by country and year from the World Bank's World Development Indicators, in tidy long format: one row per country per year, with region and income group.

    Countries and economies only: regional and income aggregates are removed. Blank = no value published for that year.

    First rows

    point at a column to light it up

    countrytextiso3textregiontextincome_grouptextyearnumberpopulationnumber
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income200020130327
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income200120284307
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income200221378117
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income200322733049
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income200423560654
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income200524404567
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income200625424094
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income200725909852
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income200826482622
    AfghanistanAFGMiddle East, North Africa, Afghanistan & PakistanLow income200927466101

    Ten most populous countries, 2023

    people

    India1,438,069,596China1,410,710,000United States336,755,052Indonesia281,190,067Pakistan247,504,495Nigeria227,882,945Brazil211,140,729Bangladesh171,466,990Russian Federation143,826,130Mexico129,739,759
    Show as a table
    iso3value
    India1,438,069,596
    China1,410,710,000
    United States336,755,052
    Indonesia281,190,067
    Pakistan247,504,495
    Nigeria227,882,945
    Brazil211,140,729
    Bangladesh171,466,990
    Russian Federation143,826,130
    Mexico129,739,759
    Source: World Bank, World Development Indicators, SP.POP.TOTL (Population, total).

    Data dictionary

    ColumnTypeMeaning
    countrytextCountry or economy (World Bank name)
    iso3textISO 3166-1 alpha-3 code
    regiontextWorld Bank region
    income_grouptextWorld Bank income group
    yearintegerYear
    populationintegerTotal population (mid-year estimate)

    Practice questions

    answers checked in SQL and in Python

    The five most populous countries in 2023?

    India 1,438,069,596; China 1,410,710,000; United States 336,755,052; Indonesia 281,190,067; Pakistan 247,504,495

    SQL

    SELECT country, population FROM world_population WHERE year=2023 AND population IS NOT NULL ORDER BY population DESC LIMIT 5

    File: world-population

    Sum of all countries' population, 2000 vs 2023?

    2000: 6,139,355,967; 2023: 8,039,550,134

    SQL

    SELECT year, SUM(population) FROM world_population WHERE year IN (2000,2023) GROUP BY year ORDER BY year

    This is the sum of the countries in the file, which can differ slightly from the World Bank's own 'World' aggregate.

    File: world-population