To make some statistics, i want to use https://data.stackexchange.com/ to find for example:

  • Who have the most Hats until now,
  • Who have this or that Hat,
  • How many Hat used,
  • How many one wear Hat,
  • and and,

But i can't find in the Database Schema something about the winter-bash, someone help me to solve this problem?


I'm new in data.stackexchange.com.

Thank you.


1 Answer 1


The database schema doesn't include hats. Also, even if it did, the data is only refeshed once a week, so for something that moves as quickly as hats, you'd almost never have current information.

It would be possible to write queries for some of the conditions that lead to hats, like gold/silver badges awarded within the right date range, hats involving post timing and scores, and some others. Some hats depend on private information like the votes you cast, though, and that data isn't in the data dumps.

You must log in to answer this question.

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