---

---

Permanent links (updated weekly):
theymos' raw data (format: time    amount    msg    user_from    user_to)
Full list (full data since January 24, 2018; not limited to 120 days).

theymos' data (human readable format, including usernames and post titles)
Full list (big file!)

Usernames to go with theymos' data:
Full list

---

---

Theymos made raw Merit data available:
I've been playing around a bit with the data, and in this topic I'll post anything worth noting. I would like to update this continuously from Recent merits, but that's for another day.

Usernames
See pastebin for usernames to go with theymos' userIDs.

Total number of users who earned 1 or more Merit: 10382
Click for the full list (format: "Merit username (#userID)")

Total number of users who gave away 1 or more sMerit: 9725
Click for the full list (format: "sMerit username (#userID)")

Occasions where the same user merited the same post twice at the exact same time
26 posts received the same number of Merit from the same user in the same second. This is caused by double clicking the Send button:
Two times 1 Merit from Syndikat to undercomander13 for this post.
Two times 4 Merit from minerbro to Piston_82 for this post.
Two times 1 Merit from newegggo to moonriver for this post.
Two times 4 Merit from aTriz to killyou72 for this post.
Two times 1 Merit from johhnyUA to Gerhald for this post.
Two times 1 Merit from TMAN to Lauda for this post.
Two times 1 Merit from TK14 to John(JohnK.) for this post.
Two times 1 Merit from JCbtc to 1Referee for this post.
Two times 1 Merit from Anna505 to Krjkee for this post.
Two times 1 Merit from Alluro to Smpdytz for this post.
Two times 1 Merit from AlexLvov to svv for this post.
Two times 1 Merit from williamevanl to centralbanksequalsbombs for this post.
Two times 1 Merit from n00bby to Undland for this post.
Two times 1 Merit from soy to Becassine for this post.
Two times 1 Merit from Dvach to AlexZHankok for this post.
Two times 1 Merit from miha74 to klim75 for this post.
Two times 6 Merit from pisston to ckorbba for this post.
Two times 1 Merit from sheamus10 to Asyifiah for this post.
Two times 5 Merit from SmartIphone to vlad230 for this post.
Two times 5 Merit from SmartIphone to hugeblack for this post.
Two times 5 Merit from SmartIphone to 01BTC for this post.
Two times 2 Merit from mellorbo to zzxswqq for this post.
Two times 5 Merit from julian071 to BTCMILLIONAIRE for this post.
Two times 1 Merit from siti25 to vlad230 for this post.
Two times 1 Merit from teddy5145 to marlboroza for this post.
Two times 1 Merit from aTriz to Craige288 for this post.

But, what I really wanted to create, is a list of users who earned (or bought) enough Merits to reach the next rank. This is also an indication of how well the Merit system performs.

---

TODO

Users who have already ranked up after earning Merits
Starting Rank (Merit), Current Rank (Merit), Current Activity

Users who have enough Merit to rank up once they get enough Activity
Current Rank, Current Merit, Current Activity

Users who received Merit, but not enough to reach the rank that fits their Activity

Total Merit received per Rank

Number of users per Rank who have received at least 1 Merit

---

---

See [overview] LoyceV's useful data on Bitcointalk for more of my forum-related topics

Thanks for creating this, it's interesting reading, although I haven't looked in depth.

I haven't heard of most of the top awarders - are they active on the  alt coin and bounty boards.

Would it be possible to provide information on awards on specific boards, such as the Beginners and the Frog Pond. Wasn't the merit system designed to encourage quality posting on the information and help boards about Bitcoin.

I've seen that bug before, but I doubt that happens at the same second. User "bitart" isn't in my list of people who sent Merit twice in one second.

Double-clicking the button perhaps?

I've done it a few times I think. If memory serves me right I actually did it with 10 merits. Easily done

I can help you to do statistical analysis for your objectives if I can get datasets. I am not familiar (actually don't know how to get data from the forum). Raw dataset contains very little information. We need more variables to do analysis. 

This is a bit tricky, as I can't have real-time Merit data. I'm still trying to figure out the best way to determine how many "free" Merits an account had received.

For this, I'll have to download all posts and check the board they're on. It's on my list.

I already did that:

I'm also curious to see what percentage of Merit is given to the first post of threads, and what percentage to posts inside threads.

Since I'm digging through the data anyways... - https://pastebin.com/Cf8PDFAg

This is a list of first posts in merited threads. The ones marked with "off limits" are either deleted posts or posts in "privileged" areas (e.g. Ivory Tower) that require to be logged in. Can't vouch for 100% accuracy but I spot checked a few and it looked ok. So if the "msg" field in the merit export matches one of those then it's the first post in the thread.

Based on that:


Edited 2020-11-29 to fix a broken image

To be fair, this is heavily skewed due to people meriting theymos' merit announcement thread, satoshi's thread, HODL thread etc.