May-18-2024, 06:13 AM
Hi, I haven't done any programming in 20 years (last did DB2 and Teradata) but an urgent task has emerged and I am not sure how to complete it
Basically, I want to create a spreadsheet listing the results of every United Nations General Assembly and United Nations Security Council resolution that was put to vote since 2022. Each row would have the title of the resolution, the resolution number, the date of the vote and how each of the 193 members voted (yes, no, abstain or absent).
The data is available through the search page of the UN digital library (accessible here: https://digitallibrary.un.org/search?cc=...oting+Data). However I can only read one resolution at a time (there were 288 votes in 2023 alone).
A typical page for a vote is here: https://digitallibrary.un.org/record/4045078?ln=en. It includes various formats like BibTex, MARC and MARCXML.
Any ideas if a Python script might solve this problem? Welcome ideas!
Many thanks in advance.
Basically, I want to create a spreadsheet listing the results of every United Nations General Assembly and United Nations Security Council resolution that was put to vote since 2022. Each row would have the title of the resolution, the resolution number, the date of the vote and how each of the 193 members voted (yes, no, abstain or absent).
The data is available through the search page of the UN digital library (accessible here: https://digitallibrary.un.org/search?cc=...oting+Data). However I can only read one resolution at a time (there were 288 votes in 2023 alone).
A typical page for a vote is here: https://digitallibrary.un.org/record/4045078?ln=en. It includes various formats like BibTex, MARC and MARCXML.
Any ideas if a Python script might solve this problem? Welcome ideas!
Many thanks in advance.