10

How can I distinguish between the levels of badges for a particular tag, say , querying SEDE?

For example, Mr. Jon Skeet has all the gold, silver and bronze badges for LINQ, so the query

select *
from Badges b with (nolock)
where
    b.Name = 'linq'
and b.UserId = 22656

returns 3, with no distinction between them.

Is it possible to include such information into the dump, for example, keep a unique badge ID (40 for the gold badge)?

  • 6
    You can deduce that he earned the bronze badge first and the gold one last. – NullUserException อ_อ Dec 2 '11 at 22:45
  • But yeah, currently there's no distinction between them in the datadump. – NullUserException อ_อ Dec 2 '11 at 22:45