Baselight

Colonial Dates Dataset (COLDAT)

@owid.colonial_dates_dataset

Loading...
Loading...

About this Dataset

Colonial Dates Dataset (COLDAT)

The Colonial Dates Dataset (COLDAT) aggregates information on the reach and duration of European colonial empires from renowned secondary sources. By aggregating secondary sources, rather than collecting from primary sources, the new dataset reflects the accumulated knowledge in the discipline and relieves researchers from making hard to justify choices between different historical datasets.
The dataset only considers the colonial status of countries that are independent today. It also includes overseas colonies only.

Tables

Population

@owid.colonial_dates_dataset.owid_colonial_dates_dataset
  • 111.27 KB
  • 116127 rows
  • 15 columns
Loading...

CREATE TABLE owid_colonial_dates_dataset (
  "country" VARCHAR,
  "year" INTEGER,
  "colonizer" VARCHAR,
  "total_colonies" INTEGER,
  "total_colonies_pop" UINTEGER,
  "colonizer_grouped" VARCHAR,
  "years_colonized" INTEGER,
  "last_colonizer" VARCHAR,
  "last_colonizer_grouped" VARCHAR,
  "colony_number" INTEGER,
  "colony_pop" UINTEGER,
  "colonizer_number" INTEGER,
  "colonizer_pop" UINTEGER,
  "not_colonized_nor_colonizer_number" INTEGER,
  "not_colonized_nor_colonizer_pop" BIGINT
);

Share link

Anyone who has the link will be able to view this.