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.

Improve this question
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
    Commented Jul 17, 2015 at 17:40

1 Answer 1

Reset to default
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.

Improve this answer
6
  • Great to know that UpMod=UpVote; DownMod=DownVote! Thank you very much!
    – Ye Tian
    Commented Jul 18, 2015 at 16:30
  • What kinds of votes does it consider? Question / answer / comments / others?
    – Ciro Santilli OurBigBook.com
    Commented 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
    Commented Jan 1, 2016 at 12:49
  • @rene where are the docs? I can only find meta.stackexchange.com/questions/2677/…
    – Ciro Santilli OurBigBook.com
    Commented Jan 1, 2016 at 13:53
  • @CiroSantilli六四事件法轮功包卓轩 that is the documentation we have
    – rene
    Commented Jan 1, 2016 at 14:33
  • I couldn't find it explained there, and linked to here. Thanks.
    – Ciro Santilli OurBigBook.com
    Commented 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 .