Image:Userbox profiles.png

From Wikipedia, the free encyclopedia

Image
File history
File links

Download high-resolution version (868x445, 12 KB)

[edit] Summary

Profile of users who have created userboxes. Basically, this chart tries to describe whether userboxes are primarily created by relative newcomers or not.

The date shown is the date that the user's account was created. That is, if a specific user created an account in November, 2004, and created 50 userboxes in January 2006, those 50 userboxes are counted towards November 2004.

The "# users" bar tries to demonstrate whether newcomers tend to create more userboxes than older users, or visa versa. For instance, the chart shows that 53 different users who registered an account in November 2004 went on to later create userboxes.

Quick statistics from the data:

Of the userboxes created, the vast majority (72%) were created by users who created their accounts before September, 2005
Users who started editing in Nov, 2004 were as likely to create userboxes as users who started editing in Nov, 2005.

[edit] Source of the data

Some data details are available in the Excel spreadsheet.

The query used is below, however, some post-processing was performed to sort the data into specific months.

SELECT rev_user,
        (SELECT r2.rev_timestamp FROM revision AS r2 WHERE r2.rev_user = r1.rev_user ORDER BY rev_timestamp LIMIT 1) AS user_create, cnt
FROM
        (SELECT rev_user, COUNT(*) as cnt
        FROM page LEFT JOIN revision ON page_id=rev_page
        WHERE page_namespace=10 AND CONVERT(page_title USING utf8) REGEXP "^User[-_]"
          AND rev_timestamp = (SELECT min(rev_timestamp) FROM revision WHERE rev_page=page_id)
          AND page_restrictions=""
          AND page_is_redirect=0
        GROUP BY rev_user) AS r1
WHERE r1.rev_user > 0;

For this graph, I ignored userboxes that are redirects, or which have been protected. Also, due to technical expediency, I didn't include deleted userboxes. So the total number of userboxes for this sample, as of Feb 23, is 4866, which is lower than other userbox counts which include redirects and protected userboxes.

[edit] Licensing

I, the creator of this work, hereby release it into the public domain. This applies worldwide.
In case this is not legally possible,
I grant any entity the right to use this work for any purpose, without any conditions, unless such conditions are required by law.

File history

Legend: (cur) = this is the current file, (del) = delete this old version, (rev) = revert to this old version.
Click on date to download the file or see the image uploaded on that date.

(del) (cur) 05:30, 23 February 2006 . . Interiot (Talk | contribs) . . 868×445 (12,631 bytes) (Profile of users who have created userboxes. Basically, this chart tries to describe whether userboxes are primarily created by relative newcomers or not. The date shown is the date that the user's account was created. That is, if a specific user creat)