Name: UN General Assembly Votes, 1946-2015
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

UN General Assembly Votes, 1946-2015

Content

This dataset documents all United Nations General Assembly votes since its establishment in 1946. The data is broken into three different files: the first lists each UN resolution, subject, and vote records; the second records individual member state votes per resolution; and the third provides an annual summary of member state voting records with affinity scores and an ideal point estimate in relation to the United States.

Acknowledgements

The UN General Assembly voting data was compiled and published by Professor Erik Voeten of Georgetown University.

Tables

Resolutions

@kaggle.unitednations_general_assembly.resolutions

107.11 kB
5,429 rows
15 columns

CREATE TABLE resolutions (
  "assembly_session" BIGINT,
  "vote_id" BIGINT,
  "resolution" VARCHAR,
  "amendment" DOUBLE,
  "vote_date" TIMESTAMP,
  "significant_vote" BIGINT,
  "yes_votes" BIGINT,
  "no_votes" BIGINT,
  "abstain" BIGINT,
  "colonization" DOUBLE,
  "human_rights" DOUBLE,
  "israel_palestine" DOUBLE,
  "disarmament" DOUBLE,
  "nuclear_weapons" DOUBLE,
  "economic_development" DOUBLE
);

States

@kaggle.unitednations_general_assembly.states

272.53 kB
9,705 rows
15 columns

CREATE TABLE states (
  "year" DOUBLE,
  "assembly_session" DOUBLE,
  "state_code" BIGINT,
  "state_name" VARCHAR,
  "all_votes" DOUBLE,
  "yes_votes" DOUBLE,
  "no_votes" DOUBLE,
  "abstain" DOUBLE,
  "idealpoint_estimate" DOUBLE,
  "affinityscore_usa" DOUBLE,
  "affinityscore_russia" DOUBLE,
  "affinityscore_china" DOUBLE,
  "affinityscore_india" DOUBLE,
  "affinityscore_brazil" DOUBLE,
  "affinityscore_israel" DOUBLE
);

Votes

@kaggle.unitednations_general_assembly.votes

469.19 kB
1,066,613 rows
7 columns

CREATE TABLE votes (
  "assembly_session" BIGINT,
  "vote_id" BIGINT,
  "resolution" VARCHAR,
  "state_code" BIGINT,
  "state_name" VARCHAR,
  "member" BIGINT,
  "vote" BIGINT
);