UN General Assembly Votes, 1946-2015
Votes by member states on individual resolutions and specific issues
@kaggle.unitednations_general_assembly
Resolutions
@kaggle.unitednations_general_assembly.resolutions
- 104.59 KB
- 5429 rows
- 15 columns
assembly_sessionAssembly Session | vote_idVote Id | resolutionResolution | amendmentAmendment | vote_dateVote Date | significant_voteSignificant Vote | yes_votesYes Votes | no_votesNo Votes | abstainAbstain | colonizationColonization | human_rightsHuman Rights | israel_palestineIsrael Palestine | disarmamentDisarmament | nuclear_weaponsNuclear Weapons | economic_developmentEconomic 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
);