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

Resolutions

@kaggle.unitednations_general_assembly.resolutions

104.59 KB
5429 rows
15 columns

assembly_session Assembly Session	vote_id Vote Id	resolution Resolution	amendment Amendment	vote_date Vote Date	yes_votes Yes Votes	no_votes No Votes	abstain Abstain	colonization Colonization	human_rights Human Rights	economic_development Economic Development
1	3	R/1/66	1	Tue Jan 01 1946 00:00:00 GMT+0000 (Coordinated Universal Time)	29	18	4
1	4	R/1/79		Wed Jan 02 1946 00:00:00 GMT+0000 (Coordinated Universal Time)	9	34	8
1	5	R/1/98		Fri Jan 04 1946 00:00:00 GMT+0000 (Coordinated Universal Time)	28	22	1
1	6	R/1/107		Fri Jan 04 1946 00:00:00 GMT+0000 (Coordinated Universal Time)	12	27	10		1
1	7	R/1/295	1	Wed Jan 02 1946 00:00:00 GMT+0000 (Coordinated Universal Time)	25	18
1	8	R/1/297	1	Sat Jan 05 1946 00:00:00 GMT+0000 (Coordinated Universal Time)	38	1	2			1
1	9	R/1/329		Tue Feb 05 1946 00:00:00 GMT+0000 (Coordinated Universal Time)	45		2
1	10	R/1/361	1	Tue Feb 05 1946 00:00:00 GMT+0000 (Coordinated Universal Time)	46	2
1	11	R/1/376		Tue Feb 05 1946 00:00:00 GMT+0000 (Coordinated Universal Time)	41			1
1	12	R/1/394	1	Wed Feb 06 1946 00:00:00 GMT+0000 (Coordinated Universal Time)	21	22	3


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
);