Name: Sovereign States Dataset
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Sovereign States Dataset

Membership in the UN system, sovereignty disputes, and statehood by century

About this dataset

This dataset contains a list of sovereign states, as well as some basic information about each state. The data includes the country's membership in the UN system, any sovereignty disputes they are involved in, and a list of sovereign states by century

How to use the dataset

In order to use this dataset, you will need to first download it onto your computer. After that, you can open it in Excel or a similar program. The columns in this dataset represent different aspects of each sovereign state. The first two columns represent the country's name and its membership in the UN system. The next column represents any sovereignty disputes the country is involved in. The last four columns represent different lists of sovereign states by century

Research Ideas

To find out which states are members of the UN, and which are not.

To study the sovereignty disputes of different states.

To find out which states have limited recognition

Acknowledgements

License

> License: CC0 1.0 Universal (CC0 1.0) - Public Domain Dedication
> No Copyright - You can copy, modify, distribute and perform the work, even for commercial purposes, all without asking permission. See Other Information.

Columns

File: df_11.csv

Column name	Description
0
1

File: df_1.csv

Column name	Description
Common and formal names	The common name and formal name of the country. (String)
Membership within the UN System[b]	The country's membership in the UN system. (String)
Sovereignty dispute[c]	Any sovereignty disputes the country is involved in. (String)

File: df_4.csv

File: df_9.csv

Column name	Description
0
1

File: df_10.csv

Column name	Description
0
1

File: df_3.csv

File: df_2.csv

Column name	Description
0
1

File: df_6.csv

Column name	Description
0
1

File: df_7.csv

Column name	Description
0
1

File: df_8.csv

Column name	Description
vteStates with limited recognition	This column contains a list of sovereign states that are not recognized by the UN. (String)
vteStates with limited recognition.1	This column contains a list of sovereign states that are not recognized by the UN. (String)

File: df_5.csv

Column name	Description
vteLists of political entities by century	This column contains a list of sovereign states by century. (String)
vteLists of political entities by century.1	This column contains information about each sovereign state, including their membership in the UN, sovereignty disputes, and whether or not the state is recognized by the UN. (String)

Tables

Df 1

@kaggle.thedevastator_list_of_sovereign_states_a_comprehensive_study.df_1

11.62 kB
244 rows
4 columns

CREATE TABLE df_1 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "common_and_formal_names" VARCHAR,
  "membership_within_the_un_system_b" VARCHAR  -- Membership Within The UN System[b],
  "sovereignty_dispute_c" VARCHAR  -- Sovereignty Dispute[c]
);

Df 10

@kaggle.thedevastator_list_of_sovereign_states_a_comprehensive_study.df_10

2.99 kB
1 row
3 columns

CREATE TABLE df_10 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "n_0" VARCHAR  -- 0,
  "n_1" VARCHAR  -- 1
);

Df 11

@kaggle.thedevastator_list_of_sovereign_states_a_comprehensive_study.df_11

3.88 kB
3 rows
3 columns

CREATE TABLE df_11 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "n_0" VARCHAR  -- 0,
  "n_1" VARCHAR  -- 1
);

Df 2

@kaggle.thedevastator_list_of_sovereign_states_a_comprehensive_study.df_2

6.21 kB
1 row
3 columns

CREATE TABLE df_2 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "n_0" VARCHAR  -- 0,
  "n_1" VARCHAR  -- 1
);

Df 5

@kaggle.thedevastator_list_of_sovereign_states_a_comprehensive_study.df_5

5.55 kB
8 rows
3 columns

CREATE TABLE df_5 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "vtelists_of_political_entities_by_century" VARCHAR,
  "vtelists_of_political_entities_by_century_1" VARCHAR
);

Df 6

@kaggle.thedevastator_list_of_sovereign_states_a_comprehensive_study.df_6

3.64 kB
4 rows
3 columns

CREATE TABLE df_6 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "n_0" VARCHAR  -- 0,
  "n_1" VARCHAR  -- 1
);

Df 7

@kaggle.thedevastator_list_of_sovereign_states_a_comprehensive_study.df_7

3.33 kB
2 rows
3 columns

CREATE TABLE df_7 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "n_0" VARCHAR  -- 0,
  "n_1" VARCHAR  -- 1
);

Df 9

@kaggle.thedevastator_list_of_sovereign_states_a_comprehensive_study.df_9

4.1 kB
1 row
3 columns

CREATE TABLE df_9 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "n_0" VARCHAR  -- 0,
  "n_1" VARCHAR  -- 1
);