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

104.59 KB
5429 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

266.14 KB
9705 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

458.19 KB
1066613 rows
7 columns


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