http://meta.stackexchange.com/questions/144716/reputation-history-from-data-explorer
Q&A for professionals, academics, and students working within the systems development life cycle
-- uid:Enter your UserId "As found in the url of your profile" select YEAR(v.creationdate), 'UP', 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), 'DOWN', 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), 'ACC', 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) union select YEAR(approvaldate), 'EDS', sum(count(*) * 2) over (order by YEAR(approvaldate)) as score from suggestededits where approvaldate is not null and owneruserid = ##uid## group by YEAR(approvaldate)