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

States

@kaggle.unitednations_general_assembly.states

266.14 KB
9705 rows
15 columns

year Year	assembly_session Assembly Session	state_code State Code	state_name State Name	all_votes All Votes	yes_votes Yes Votes	no_votes No Votes	abstain Abstain	idealpoint_estimate Idealpoint Estimate	affinityscore_usa Affinityscore Usa	affinityscore_russia Affinityscore Russia	affinityscore_india Affinityscore India	affinityscore_brazil Affinityscore Brazil	affinityscore_israel Affinityscore Israel
1946	1	2	United States of America	42	25	15	2	1.7377	1	0.2143	0.4762	0.6429
1947	2	2	United States of America	38	27	10	1	1.8417	1	0.2632	0.2973	0.8421
1948	3	2	United States of America	103	46	54	3	1.9909	1	0.1275	0.37	0.7767	0.1667
1949	4	2	United States of America	63	17	33	13	1.9395	1	0.1111	0.3651	0.5397	0.5161
1950	5	2	United States of America	53	26	25	2	1.8651	1	0.1731	0.5094	0.8113	0.6042
1951	6	2	United States of America	25	10	11	4	1.8919	1	0.12	0.36	0.64	0.6522
1952	7	2	United States of America	49	25	19	5	1.9617	1	0.1429	0.3061	0.6531	0.6327
1953	8	2	United States of America	25	12	6	7	1.7707	1	0.2	0.3333	0.64	0.52
1954	9	2	United States of America	30	18	3	9	1.5565	1	0.2	0.3	0.6333	0.4333
1955	10	2	United States of America	27	13	8	6	1.8166	1	0.1481	0.1111	0.7778	0.4815


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