How to distinguish between gold, silver, and bronze tag badges on SEDE?

Question

How can I distinguish between the levels of badges for a particular tag, say linq, 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 c# badge)?

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

Community · Accepted Answer · 2021-01-18 12:14:37Z

The Badges table now has a column named Class, which is enumerated as follows:

Here are some example queries:

1 Answer 1