Is there any way to search closed questions with reasons of "primarily opinion-based" or "too broad"?

Question

I know I can use closed:1 to search closed questions and migrated:1 to search migrated questions on Stack Exchange sites.

Is there any way to search closed questions with reasons of primarily opinion-based, too broad and unclear what you're asking which are three major close reasons on SE sites?

Answer 1

You can only use SEDE for that. For a specific site the following query lists closed questions with the close reasons you asked:

select p.id as [Post Link]
     , crt.Name
     , crt.Description
from posts p 
inner join posthistory ph on ph.postid = p.id
inner join closereasontypes crt on crt.id = cast(ph.comment as tinyint)
where ph.posthistorytypeid = 10 -- Close event
and p.closeddate is not null  -- question is still closed
and p.posttypeid = 1 -- Question
and crt.id in 
    ( 103 -- unclear
    , 104 -- too broad
    , 105 -- POB
    )
order by closeddate desc

The query joins the posts table with posthistory and then filters on posthistorytypeid = 10 which indicates a closed event. In that row the comment field holds the foreignkey to the closereasonttypes. For Stack Overflow I had to add a top instruction to limit the number of results. Otherwise the query processor runs out of resources.

If you are unfamiliar with databases and SQL queries make sure to check out the SEDE Tutorial.

Keep in mind that SEDE is only updated updated once a week.