100 days of COVID-19 in the Australian Twittersphere

The is a database of tweets from identified Australian accounts, originally set up through the , and now managed by the . This dataset includes 3.7 million Australian Twitter accounts, with 1.8 billion tweets captured to date. Since the beginning of 2019, there have been about 800,000 new tweets per day, from 100,000 daily active users. The 100 days of COVID-19 in the Australian Twittersphere dataset consists of 2.8 million tweet IDs corresponding to tweets from the Australian Twittersphere that mention the COVID-19 pandemic, either through Coronavirus specific hashtags or keywords. The tweets were created on or after 20 January 2020, and up until 23 May 2020 (the 15 weeks that form the first ‘100 days’ of COVID-19 in Australia). This dataset provides a glimpse of the experiences and attitudes of Australians presently living through this global pandemic. We are all in this together and as such this dataset has been released as rapidly as possible to enable use by the broader research community.

The SQL used to extract the tweets from the Australian Twittersphere database is as follows:

SELECT tweet_id
FROM oz_twitter.tweet
WHERE created_at >= '2020-01-19 14:00:00' -- corresponds to >= '2020-01-20 00:00:00' in Brisbane time
AND created_at < &#39;2020-05-03 14:00:00&#39; -- corresponds to < &#39;2020-05-04 00:00:00&#39; in Brisbane time
AND multiMatchAny(lower(text), [&#39;covid&#39;, &#39;corona&#39;, &#39;flattenthecurve&#39;, &#39;socialdistancing&#39;, &#39;stayhome&#39;, &#39;lockdown&#39;, &#39;wuhan&#39;, &#39;pandemic&#39;])
AND notEmpty(hashtags) = 1;

Access to the Australian Twittersphere database is managed by the QUT Digital Observatory.

澳大利亚推特社区（Australian Twittersphere）数据集为收录经认证澳大利亚账号推文（tweet）的数据库，最初由[原发起方]搭建，现由[现管理方]运营。本数据集涵盖370万个澳大利亚推特账号，截至目前已累计收录18亿条推文。自2019年初以来，每日新增推文约80万条，每日活跃用户达10万。

“澳大利亚推特社区新冠疫情百日数据集”包含280万个推文ID，对应澳大利亚推特社区内提及新冠疫情的推文——此类提及通过新冠特定话题标签（hashtags）或关键词实现。推文发布时间为2020年1月20日及之后，至2020年5月23日，覆盖构成澳大利亚新冠疫情首个“百日”的15周周期。本数据集可窥见身处此次全球疫情中的澳大利亚民众的经历与态度。吾辈与全球民众同处此艰局，故本数据集已以最快速度发布，以供更广泛的科研社群使用。

用于从澳大利亚推特社区数据库中提取目标推文的SQL语句如下：
SELECT tweet_id
FROM oz_twitter.tweet
WHERE created_at >= '2020-01-19 14:00:00' -- 对应布里斯班时间的2020年1月20日00:00:00及以后
AND created_at < '2020-05-03 14:00:00' -- 对应布里斯班时间的2020年5月4日00:00:00以前
AND multiMatchAny(lower(text), ['covid', 'corona', 'flattenthecurve', 'socialdistancing', 'stayhome', 'lockdown', 'wuhan', 'pandemic'])
AND notEmpty(hashtags) = 1;

澳大利亚推特社区数据库的访问权限由昆士兰科技大学数字观测站（QUT Digital Observatory）管理。