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 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! Commented Jul 18, 2015 at 16:30
  • What kinds of votes does it consider? Question / answer / comments / others? 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六四事件法轮功包卓轩 Commented Jan 1, 2016 at 12:49
  • @rene where are the docs? I can only find meta.stackexchange.com/questions/2677/… Commented Jan 1, 2016 at 13:53
  • @CiroSantilli六四事件法轮功包卓轩 that is the documentation we have Commented Jan 1, 2016 at 14:33
  • I couldn't find it explained there, and linked to here. Thanks. Commented Jan 1, 2016 at 14:36

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.