More useless/useful* Bitcointalk user data

Background
I was asked to collect some data on users above Newbie.

The data
A few days ago, I took a snapshot of "my" 53M unedited/deleted posts. This includes 2 categories:

All older posts scraped recently
All unedited posts scraped since the end of July 2019

From this, I checked how many unique users had at least 30 posts (including all posts that can be deleted by now), so I for sure exclude all users lower than Jr. Member (but include some false positives). Result: 153,116 users.

I've scraped the profile of those 153,116 users. This took a few days, so very recent changes aren't included.
I checked the actual forum Rank, so no "Founder", "Administrator", "Staff", "Global Moderator", "VIP", "Donator" or "Copper Member".
It turns out 76,250 users are still Newbies and 802 users are "Brand new", those aren't what I was looking for.

That leaves:
Jr. Member: 12,973 users
Member: 29,259 users
Full member: 18,215 users
Sr. Member: 9,038 users
Hero Member: 4,138 users
Legendary: 2,441 users
Total: 76,064 users above Newbie.

See the full list in CSV-format.
Sample (userID,Activity,Merit,Rank,username):

Code:

3,364,2598,Full Member,satoshi
4,429,268,Sr. Member,sirius
10,132,101,Full Member,Xunie
12,662,251,Sr. Member,nanaimogold
13,875,1014,Legendary,SmokeTooMuch
14,490,504,Hero Member,The Madhatter
23,237,100,Full Member,1 currency now
24,202,106,Full Member,dwdollar

Some users have a comma in their name. I put the username on the last column, so pay extra attention to those usernames:

Code:

epi 1:10,000
Brunt, FCA
batman, not crabman
3a6aukaJIeU,
,./,./
Kostolany, Jr.
Robin,Hood
Mirror, Mirror, on the Wa
MR,bon
Stop talking, start minin
I, Karus
fq,frHUxP*joE
,f,ekbr
Buk,uk
sasakinto,
putri,biuty
coin,maker
A, AL
bram,s
Mr,harry
Mr,Harry210

I don't think there's much to discuss here, so I'll lock this topic soon.

Topic: More useless/useful* Bitcointalk user data (Read 195 times)