The Twitter Parliamentarian Database

This is the Twitter Parliamentarian Database: a database consisting of parliamentarian names, parties and twitter ids from the following countries: Austria, Belgium, France, Denmark, Spain, Finland, Germany, Greece, Italy, Malta, Poland, Netherlands, United Kingdom, Ireland, Sweden, New Zealand, Turkey, United States, Canada, Australia, Iceland, Norway, Switzerland, Luxembourg, Latvia and Slovenia. In addition, the database includes the European Parliament.The tweet ids from the politicans' tweets have been collected from September 2017 - 31 October 2019 (all_tweet_ids.csv). In compliance with Twitter's policy, we only store tweet ids, which can be re-hydrated into full tweets using existing tools. More information on how to use the database can be found in the readme.txt.It is recommended that you use the .csv files to work with the data, rather than the SQL tables. Information on the relations in the SQL database can be found in the Database codebook.pdf.Update:The tweet ids for 2021 have been added as '2021.csv'Update #2:The tweet ids for 2020 have been added as '2020.csv'The last party table has been added as 'parties_2021_04_28.csv'The last members table has been added as 'members_2021_04_28.csv'

本数据集名为Twitter议会数据库，系由以下国家议会成员的姓名、所属政党及Twitter ID所构成的数据库：奥地利、比利时、法国、丹麦、西班牙、芬兰、德国、希腊、意大利、马耳他、波兰、荷兰、英国、爱尔兰、瑞典、新西兰、土耳其、美国、加拿大、澳大利亚、冰岛、挪威、瑞士、卢森堡、拉脱维亚和斯洛文尼亚。此外，该数据库亦囊括了欧洲议会成员的信息。自2017年9月起至2019年10月31日，政客们的推文ID（存于all_tweet_ids.csv文件中）已被搜集。遵循Twitter的相关政策，我们仅存储推文ID，这些ID可借助现有工具重新组合为完整的推文。关于如何使用该数据库的详细信息，请参阅readme.txt文件。建议使用.csv文件而非SQL表来处理数据。SQL数据库中关系的信息可在Database codebook.pdf文件中找到。更新：2021年的推文ID已添加至'2021.csv'文件。更新#2：2020年的推文ID已添加至'2020.csv'文件。最新政党信息表已添加至'parties_2021_04_28.csv'文件，最新成员信息表已添加至'members_2021_04_28.csv'文件。