What is meta? ×
Meta Stack Exchange is where users like you discuss bugs, features, and support issues that affect the software powering all 134 Stack Exchange communities.

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

1 Answer 1

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 .