Table 2 Example entity database entries.

From: Cliopatria - A geospatial database of world-wide political entities from 3400BCE to 2024CE

Name

FromYear

ToYear

Area

Type

Wikipedia

SeshatID

MemberOf

geometry

a)

Middle Kingdom of Egypt

−1800

−1701

395596.2

POLITY

Middle Kingdom of Egypt

eg_middle_k

 

POLYGON ((33.07 30.43,…

Hyksos

−1800

−1701

61952.4

POLITY

Hyksos

  

MULTIPOLYGON (((36.38 33.65,…

Middle Kingdom of Egypt

−1700

−1601

395596.2

POLITY

Middle Kingdom of Egypt

eg_middle_k

 

POLYGON ((33.07 30.43,…

Hyksos

−1700

−1601

91750.7

POLITY

Hyksos

  

POLYGON ((36.75 32.75,…

Fifteenth Dynasty of Egypt

−1600

−1501

34021.2

POLITY

Fifteenth Dynasty of Egypt

eg_thebes_hyksos

 

POLYGON ((30.64 27.54,…

Seventeenth Dynasty of Egypt

−1600

−1501

26544.0

POLITY

Seventeenth Dynasty of Egypt

eg_thebes_hyksos

 

POLYGON ((33.07 26.64,…

Sixteenth Dynasty of Egypt

−1600

−1501

22477.6

POLITY

Sixteenth Dynasty of Egypt

eg_thebes_hyksos

 

MULTIPOLYGON (((31.48 30.43,…

Hyksos

−1600

−1501

139092.8

POLITY

Hyksos

  

POLYGON ((36.75 32.75,…

New Kingdom of Egypt

−1500

−1401

634954.2

POLITY

New Kingdom of Egypt

eg_new_k_1

 

POLYGON ((34.35 31.30,…

Hyksos

−1500

−1401

66824.4

POLITY

Hyksos

  

POLYGON ((36.56 32.23,…

b)

(British Empire)

1859

1859

10352664.6

POLITY

British Empire

gb_british_emp_2

 

MULTIPOLYGON (((−144.38 67.36,…

Kingdom of Great Britain

1856

1869

348055.9

POLITY

Great Britain

gb_british_emp_2

(British Empire)

MULTIPOLYGON (((−1.34 60.06,…

British Raj

1859

1867

4180749.1

POLITY

British Raj

gb_british_emp_2

(British Empire)

MULTIPOLYGON (((70.44 22.78,…

Trucial States

1856

1869

72118.9

POLITY

Trucial States

gb_british_emp_2

(British Empire)

POLYGON ((52.61 22.91,…

British Cape Colony

1856

1860

627919.5

POLITY

Cape Colony

gb_british_emp_2

(British Empire)

MULTIPOLYGON (((−16.67 13.07,…

British Colonial Empire

1859

1859

5124124.1

POLITY

British Empire

gb_british_emp_2

(British Empire)

MULTIPOLYGON (((−144.38 67.36,…

c)

(Holy Roman Empire)

1305

1313

1047948.7

POLITY

Holy Roman Empire

de_empire_3

 

MULTIPOLYGON (((22.37 59.01,…

(Personal union of Kingdom of Bohemia with Kingdom of Poland)

1305

1313

305777.0

POLITY

Wenceslaus II of Bohemia

cz_bohemian_k_1; pl_piast_dyn_2

 

MULTIPOLYGON (((17.00 50.77,…

(Kingdom of Bohemia)

1305

1313

151557.3

POLITY

Kingdom of Bohemia

cz_bohemian_k_1

 

MULTIPOLYGON (((17.00 50.77,…

(Kingdom of Poland)

1305

1313

154219.6

POLITY

Kingdom of Poland

pl_piast_dyn_2

 

MULTIPOLYGON (((16.52 51.37,…

House of Luxembourg

1260

1362

7763.5

POLITY

House of Luxembourg

de_empire_3

(Holy Roman Empire)

MULTIPOLYGON (((4.56 50.37,…

County of Savoy

1260

1384

14693.8

POLITY

County of Savoy

de_empire_3

(Holy Roman Empire)

POLYGON ((6.66 45.10,…

Principality of Orange

1260

1458

233.8

POLITY

Principality of Orange

de_empire_3

(Holy Roman Empire)

POLYGON ((4.83 44.12,…

Patriarchate of Aquileia

1260

1313

9013.8

POLITY

Patriarchate of Aquileia

de_empire_3

(Holy Roman Empire)

MULTIPOLYGON (((13.73 46.34,…

Republic of Florence

1279

1401

9996.3

POLITY

Republic of Florence

it_florence_rep

(Holy Roman Empire)

POLYGON ((10.64 43.34,…

County of Brabant

1294

1401

13075.7

POLITY

Landgraviate of Brabant

de_empire_3

(Holy Roman Empire)

MULTIPOLYGON (((4.19 51.04,…

Swiss Confederation

1294

1325

2828.9

POLITY

Switzerland

de_empire_3

(Holy Roman Empire)

POLYGON ((8.89 47.26,…

House of Habsburg

1305

1313

60523.9

POLITY

House of Habsburg

de_empire_3

(Holy Roman Empire)

MULTIPOLYGON (((10.11 48.52,…

Duchy of Bavaria

1305

1325

35993.4

POLITY

Duchy of Bavaria

de_empire_3

(Holy Roman Empire)

MULTIPOLYGON (((7.02 49.51,…

Kingdom of Bohemia

1305

1313

151557.3

POLITY

Kingdom of Bohemia

cz_bohemian_k_1

(Holy Roman Empire); (Kingdom of Bohemia)

MULTIPOLYGON (((17.00 50.77,…

House of Ascania

1305

1332

28649.3

POLITY

House of Ascania

de_empire_3

(Holy Roman Empire)

POLYGON ((12.79 50.37,…

Holy Roman Empire Minor States

1305

1313

533920.4

POLITY

Holy Roman Empire

de_empire_3

(Holy Roman Empire)

MULTIPOLYGON (((11.95 51.04,…

Teutonic Order

1305

1313

111807.9

POLITY

Teutonic Order

pl_teutonic_order

(Holy Roman Empire)

MULTIPOLYGON (((22.37 59.01,…

County of Holland

1305

1351

11694.7

POLITY

County of Holland

de_empire_3

(Holy Roman Empire)

MULTIPOLYGON (((3.82 51.78,…

Margraviate of Brandenburg

1305

1313

41213.1

POLITY

Margraviate of Brandenburg

de_empire_3

(Holy Roman Empire)

POLYGON ((14.70 52.45,…

House of Wittelsbach

1305

1325

17716.5

POLITY

House of Wittelsbach

de_empire_3

(Holy Roman Empire)

POLYGON ((13.35 48.85,…

Duchy of Jawor

1305

1313

3556.1

POLITY

Duchy of Jawor

pl_piast_dyn_2

(Kingdom of Poland)

POLYGON ((16.50 50.97,…

Duchy of Legnica

1305

1313

4876.8

POLITY

Duchy of Legnica

pl_piast_dyn_2

(Kingdom of Poland)

POLYGON ((16.65 50.44,…

Duchy of Głogów

1305

1313

12372.0

POLITY

Duchy of Głogów

pl_piast_dyn_2

(Kingdom of Poland)

POLYGON ((16.52 51.37,…

Kingdom of Poland

1305

1313

133414.5

POLITY

Kingdom of Poland

pl_piast_dyn_2

(Kingdom of Poland)

MULTIPOLYGON (((17.75 53.73,…

  1. Each row describes a polity over a range of years, its associated Wikipedia page, Seshat ID if any, and which composite polity the entity is a member of, if any. Area in km2. Geometry polygons are abbreviated. Components column is elided. (a) A subset of the sequence for ancient Egypt reflecting the invasion of the Hyksos and the collapse of the Middle Kingdom into the Second Intermediate Period, marked by several dynasties before the consolidation into the New Kingdom. (b) The major political constituents of the British Empire composite entity in the year 1859CE. (c) The entities associated with the Holy Roman Empire, the Kingdom of Poland, the Kingdom of Bohemia and the Personal Union between them under Wenceslaus II in 1305CE.