The Twitter Parliamentarian Database

<br>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 (<i>all_tweet_ids.csv</i>). 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 <i>readme.txt.</i>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 <i>Database codebook.pdf.</i><i>Update:</i>The tweet ids for 2021 have been added as <i>'2021.csv'</i><i>Update #2:</i>The tweet ids for 2020 have been added as<i> '2020.csv'</i>The last party table has been added as<i> 'parties_2021_04_28.csv'</i>The last members table has been added as <i>'members_2021_04_28.csv'</i><br><br>

本数据集为议员推特数据库（Twitter Parliamentarian Database），收录了奥地利、比利时、法国、丹麦、西班牙、芬兰、德国、希腊、意大利、马耳他、波兰、荷兰、英国、爱尔兰、瑞典、新西兰、土耳其、美国、加拿大、澳大利亚、冰岛、挪威、瑞士、卢森堡、拉脱维亚以及斯洛文尼亚等国的议员姓名、所属党派与推特账号ID。此外，该数据库还涵盖欧洲议会相关数据。

该数据库中政客推文的推文ID采集时段为2017年9月至2019年10月31日，相关数据存储于`all_tweet_ids.csv`文件中。依据推特（Twitter）平台的政策要求，本数据库仅存储推文ID，用户可通过现有工具将其还原为完整推文内容。

有关该数据库的详细使用方法，请参阅`readme.txt`文件。建议优先使用CSV格式文件处理数据，而非SQL数据表。SQL数据库的表结构与关联关系说明可参见`Database codebook.pdf`。

**更新说明**：
1. 已将2021年的推文ID新增至`2021.csv`文件中；
2. 已将2020年的推文ID新增至`2020.csv`文件中；
3. 最新党派数据表`parties_2021_04_28.csv`已正式发布；
4. 最新议员数据表`members_2021_04_28.csv`已正式发布。