9

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) 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 '15 at 17:40
6

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.

You must log in to answer this question.

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