European overseas colonies by colonizer

About this data
More Data on State Capacity
Sources and processing
This data is based on the following sources
How we process data at Our World in Data
All data and visualizations on Our World in Data rely on data sourced from one or several original data providers. Preparing this original data involves several processing steps. Depending on the data, this can include standardizing country names and world region definitions, converting units, calculating derived indicators such as per capita measures, as well as adding or adapting metadata such as the name or the description given to an indicator.
At the link below you can find a detailed description of the structure of our data pipeline, including links to all the code used to prepare data across Our World in Data.
Notes on our processing step for this indicator
This is the count of countries each European colonial power colonized each year. Colonized countries or countries not colonized show a null value.
A total for each year is estimated with the country (entity) "World".
Years are defined from last date aggregations available in the Colonial Dates Dataset. This means that when sources differ, years of colonization are defined from the last date between them. This is different from mean date aggregations (also available), which averages the dates of colonization across the original sources.
Years have been expanded to show the full range of years in the dataset, from 1462 to 2022. The original dataset only includes the years where a country was colonized.
Reuse this work
Citations
How to cite this page
To cite this page overall, including any descriptions, FAQs or explanations of the data authored by Our World in Data, please use the following citation:
“Data Page: European overseas colonies by colonizer”, part of the following publication: Bastian Herre and Pablo Arriagada (2023) - “State Capacity”. Data adapted from Bastian Becker, Gapminder. Retrieved from https://archive.ourworldindata.org/20260304-094028/grapher/european-overseas-colonies-by-colonizer.html [online resource] (archived on March 4, 2026).How to cite this data
In-line citationIf you have limited space (e.g. in data visualizations), you can use this abbreviated in-line citation:
Bastian Becker (2023); Gapminder, Population v7 (2022) – with major processing by Our World in DataFull citation
Bastian Becker (2023); Gapminder, Population v7 (2022) – with major processing by Our World in Data. “European overseas colonies by colonizer” [dataset]. Bastian Becker, “Colonial Dates Dataset (COLDAT) 3.0”; Gapminder, “Population v7” [original data]. Retrieved April 3, 2026 from https://archive.ourworldindata.org/20260304-094028/grapher/european-overseas-colonies-by-colonizer.html (archived on March 4, 2026).Download
Quick download
Download the data shown in this chart as a ZIP file containing a CSV file, metadata in JSON format, and a README. The CSV file can be opened in Excel, Google Sheets, and other data analysis tools.
Data API
Use these URLs to programmatically access this chart's data and configure your requests with the options below. Our documentation provides more information on how to use the API, and you can find a few code examples below.
Data URL (CSV format)
https://ourworldindata.org/grapher/european-overseas-colonies-by-colonizer.csv?v=1&csvType=full&useColumnShortNames=falseMetadata URL (JSON format)
https://ourworldindata.org/grapher/european-overseas-colonies-by-colonizer.metadata.json?v=1&csvType=full&useColumnShortNames=falseExcel / Google Sheets
=IMPORTDATA("https://ourworldindata.org/grapher/european-overseas-colonies-by-colonizer.csv?v=1&csvType=full&useColumnShortNames=false")Python with Pandas
import pandas as pd
import requests
# Fetch the data.
df = pd.read_csv("https://ourworldindata.org/grapher/european-overseas-colonies-by-colonizer.csv?v=1&csvType=full&useColumnShortNames=false", storage_options = {'User-Agent': 'Our World In Data data fetch/1.0'})
# Fetch the metadata
metadata = requests.get("https://ourworldindata.org/grapher/european-overseas-colonies-by-colonizer.metadata.json?v=1&csvType=full&useColumnShortNames=false").json()R
library(jsonlite)
# Fetch the data
df <- read.csv("https://ourworldindata.org/grapher/european-overseas-colonies-by-colonizer.csv?v=1&csvType=full&useColumnShortNames=false")
# Fetch the metadata
metadata <- fromJSON("https://ourworldindata.org/grapher/european-overseas-colonies-by-colonizer.metadata.json?v=1&csvType=full&useColumnShortNames=false")Stata
import delimited "https://ourworldindata.org/grapher/european-overseas-colonies-by-colonizer.csv?v=1&csvType=full&useColumnShortNames=false", encoding("utf-8") clear