http://meta.stackexchange.com/questions/144716/reputation-history-from-data-explorer
Q&A about the site for enthusiasts and scholars of mythology and folklore
-- uid:Enter your UserId "As found in the url of your profile" select YEAR(v.creationdate), sum(count(*)*10) over (order by YEAR(v.creationdate)) as score from posts p inner join votes v on v.postid = p.id where v.votetypeid = 2 --UpVote and p.posttypeid in (1, 2) and p.owneruserid = ##uid## group by YEAR(v.creationdate) union select YEAR(v.creationdate), sum(count(*)*-2) over (order by YEAR(v.creationdate)) as score from posts p inner join votes v on v.postid = p.id where v.votetypeid = 3 --DownVote and p.posttypeid in (1,2) -- Q and A and p.owneruserid = ##uid## group by YEAR(v.creationdate) union select YEAR(v.creationdate), sum(count(*) * 15) over (order by YEAR(v.creationdate)) as score -- every accepted answer 15 fep from posts p inner join votes v on v.postid = p.id where v.votetypeid = 1 -- Accept and p.posttypeid = 2 -- Answer and p.owneruserid = ##uid## group by YEAR(v.creationdate)