Toolserver:User:LA2

LA2 is the username of Lars Aronsson, Sweden.

December 3, 2011: You can download historic linkstats, based on database dumps for svwiki, commonswiki. Each line contains the count of external links from the Article, File, Author, Index, and Portal namespaces, a comma, and the domain.

November 29, 2011: My link statistics have evolved to include some more namespaces (File, Author, Index, Portal) and all available websites. This runs as an SQL query on the toolserver for all databases (~la2/linkstats.sh), except for commons.wikimedia and en.wikipedia, where it times out. For these and for historic data, I have a different script (~la2/dumplinks.pl) that can parse the database dumps (page.sql and externallinks.sql). This is fine as a proof of concept. Now, in what format should these data be made available? And what kinds of reports are useful?

November 25, 2011: You can download linkstats.csv, containing statistics on external links for a number of Wikimedia projects. This is based on the following query:

select count(*), trim(leading 'www.' from substring_index(substring_index(el_to, '/', 3),'/',-1)) as site from externallinks, page where el_from = page_id and page_namespace=0 group by 2 having count(*) >= 10;

en:User:LA2 sv:Användare:LA2