Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 158 Stack Exchange communities.

What is meta?
Here's how it works:
  1. Any Stack Exchange user can ask a question
  2. The community provides support, votes on ideas, and reports bugs
  3. Your voice helps shape the way Stack Exchange operates

Maybe I'm going crazy, but I can't find a UserId column in the Votes table in the Data Explorer, even though it's listed as part of the schema here. Was this missed, omitted on purpose, or ...?

share|improve this question
    
As jeff commented, we did put this file in the data dump, FYI -- so please add more if you want to see additional stuff next time. – Andreas Bonini Jun 12 '10 at 16:01
    
@Kop: Huh? I know the data exists in the data dump already, I'm just wondering why it's not in the Data Explorer. – Jon Seigel Jun 12 '10 at 16:12
1  
ill get this sorted (keep in mind its only there for vote type 5) – waffles Jun 12 '10 at 22:59
    
@waffles: Awesome, thanks! – Jon Seigel Jun 13 '10 at 16:32
    
@waffles Any chance of a UserHash column (say) that anonymises users, but allows us to get statistics on voting patterns? (Of course you couldn't have this field and a valid UserId for vote type 5, or the anonymous hash suddenly isn't anonymous any more.) – Mark Hurd Jun 23 '10 at 10:23
2  
@Mark Im a bit afraid that would end up de-anonymizing stuff, meaning if somebody had 312 upvotes and 96 downvotes (via the User table) you could possibly correlate with the hash. – waffles Jun 23 '10 at 10:36
    
@waffles Yeah, fair enough. I can't think of a way of providing useful data with complete anonymity ensured. – Mark Hurd Jun 25 '10 at 5:40
    
@waffles sorry, could you clarify "only there fore vote type 5"? ANSWER - It's only available for favourite votes...i.e. VOTETYPE 5. – slotishtype Jul 29 '10 at 16:54
    
@slotishtype Now it's also available for BountyStart votes (with VoteTypeId = 8): meta.stackexchange.com/q/110182/158912 – Idolon May 3 '12 at 8:29
up vote 2 down vote accepted

completed upvote so its not kicked anymore

share|improve this answer

You must log in to answer this question.

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