3

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 ...?

  • 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. – Thomas 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
  • 2
    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
  • 1
    @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
2

completed upvote so its not kicked anymore

You must log in to answer this question.

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