Using the master archive of social media outlinks found in worldwide news coverage monitored by GDELT 2016-2019, a single SQL query was all it took in BigQuery to compile a ranked list of the 1,742,760 distinct Twitter accounts whose posts were linked to by news coverage over that time period. The list contains a mixture of politicians, celebrities, businesspersons and social-friendly news outlets.
The full list can be downloaded:
Here is a preview of the top 15 entries:
It took just a single SQL query and 13 seconds to compile the list above:
SELECT CONCAT('https://twitter.com/',LOWER(REGEXP_EXTRACT(SocialLink, r'twitter.com/([^/]+)/status'))) TwitterUser, count(1) Count FROM `gdelt-bq.gdeltv2.gkg_socialoutlinks` where REGEXP_CONTAINS(SocialLink, r'twitter.com/[^/]+/status') group by TwitterUser order by Count desc