What's the reopen rate for closed questions on Programmers?

Question

Inspired by "How often are closed questions re-opened?" on MSO, I wanted to find out how often questions on Programmers get re-opened.

One of the answers there provided two queries to get fairly close to the answer. Query One and Query Two brought back 8783 closed questions and 743 reopened questions.

That gives Programmers a ~8.5% reopen rate for closed questions.

However, the super sneaky and amazing Shog9♦ used his super-duper developer powers and came up with much more detailed numbers since his developer access gives him more details than what us mere mortals can glean from data explorer.

So, inquiring minds want to know. What's the real reopen rate for Programmers?

---

_{Bootnote: Shog specifically asked me to open this question here on MPSE}

Answer 1

First, the all-time stats:

Closed Closed then Edited Closed then Reopened Closed then Edited then Reopened 
------ ------------------ -------------------- -------------------------------- 
34567  4388               1174                 545                              

So, slightly over 3%, jumping to 12% for edited questions. For the past 365 days, we see:

Closed Closed then Edited Closed then Reopened Closed then Edited then Reopened 
------ ------------------ -------------------- -------------------------------- 
11824  1084               263                  140                              

Or roughly 2%, jumping to just shy of 13% again for edited questions.

The more interesting breakdown by close reason follows, again looking only at questions closed within the past 365 days:

Name                       Closed Closed then Edited Closed then Reopened Closed then Edited then Reopened 
-------------------------- ------ ------------------ -------------------- -------------------------------- 
duplicate                  713    49                 22                   10                               
off-topic                  6257   406                103                  48                               
primarily opinion-based    1598   187                53                   29                               
too broad                  1761   185                33                   15                               
unclear what you're asking 1494   257                52                   38                               

Expressed as percentages:

Name                       Closed then Edited Closed then Reopened Closed then Edited then Reopened 
-------------------------- ------------------ -------------------- -------------------------------- 
duplicate                  6.9 %              3.1 %                20.4 %                           
off-topic                  6.5 %              1.6 %                11.8 %                           
primarily opinion-based    11.7 %             3.3 %                15.5 %                           
too broad                  10.5 %             1.9 %                8.1 %                            
unclear what you're asking 17.2 %             3.5 %                14.8 %                           

This is mostly in keeping with what we observed on Stack Overflow, but it's worth noting that both duplicates and opinion-based questions stand a slightly better chance of being reopened, particularly if they're edited.