UN General Assembly Votes, 1946-2015

Votes by member states on individual resolutions and specific issues

@kaggle.unitednations_general_assembly

Table List

3 tables(828.93 KB)

Resolutions

States

Votes

Votes

@kaggle.unitednations_general_assembly.votes

458.19 KB
1066613 rows
7 columns

assembly_session Assembly Session	vote_id Vote Id	resolution Resolution	state_code State Code	state_name State Name	member Member	vote Vote
1	3	R/1/66	2	United States of America	1	1
1	3	R/1/66	20	Canada	1	3
1	3	R/1/66	31	Bahamas		9
1	3	R/1/66	40	Cuba	1	1
1	3	R/1/66	41	Haiti	1	1
1	3	R/1/66	42	Dominican Republic	1	1
1	3	R/1/66	51	Jamaica		9
1	3	R/1/66	52	Trinidad and Tobago		9
1	3	R/1/66	53	Barbados		9
1	3	R/1/66	54	Dominica		9


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