11

A typical child of the users.xml looks as follows:

<row Id="2"
     Reputation="101"
     CreationDate="2010-07-19T14:01:36.697"
     DisplayName="Geoff Dalgas"
     LastAccessDate="2013-11-12T22:07:23.783"
     WebsiteUrl="http://stackoverflow.com"
     Location="Corvallis, OR"
     AboutMe="Wondering why the HTML in here isn't escaped, frankly." 
     Views="25" UpVotes="3" DownVotes="0" Age="37" AccountId="2"/>

My questions are

1) What is "UpVotes"? Is it the number of upvotes the user contributes or the number of upvotes he/she receives?

2) How do I find out the number of upvotes a post receives? I checked posts.xml and the answer is definitely not there.

1
  • 1) It's the number of upvotes that the user contributes. 2) I think it should be in PostFeedback , VoteTypeId=3 , well at least that's how it is in SEDE
    – CRABOLO
    Jul 17, 2015 at 17:40

1 Answer 1

7

In the Users.xml the row holds in UpVotes the number of up votes on posts that the user contributes (as indicated by @dronehinge).

You'll find up- and downvotes in the Votes.xml.

A typical row looks like this:

 <row Id="4422" 
      PostId="858" 
      VoteTypeId="2" 
      CreationDate="2013-11-04T00:00:00.000" />

You are interested in

  • VoteTypeId="2" for up votes
  • VoteTypeId="3" for down votes

for a specific PostId

The datadump is a subset of the data available in SEDE but the Database schema documentation for the public data dump and SEDE has extra information on the entities and attributes that do match.

6
  • Great to know that UpMod=UpVote; DownMod=DownVote! Thank you very much!
    – Ye Tian
    Jul 18, 2015 at 16:30
  • What kinds of votes does it consider? Question / answer / comments / others? Jan 1, 2016 at 12:13
  • Only votes on posts but it also includes accept, favorite. For the complete list see the doc. @CiroSantilli六四事件法轮功包卓轩
    – rene
    Jan 1, 2016 at 12:49
  • @rene where are the docs? I can only find meta.stackexchange.com/questions/2677/… Jan 1, 2016 at 13:53
  • @CiroSantilli六四事件法轮功包卓轩 that is the documentation we have
    – rene
    Jan 1, 2016 at 14:33
  • I couldn't find it explained there, and linked to here. Thanks. Jan 1, 2016 at 14:36

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .