How can I see the list of questions that were removed by a mod from the list of hot network questions on a given SE website?

Question

How can I see the list of questions that were manually removed (= removed by a mod) from the list of hot network questions on a given SE website?

Answer 1

You can do so using this SEDE query.

This should give you a list of all moderator-removed hot network questions only, along with other details (date and time of removal, number of hours on the HNQ list, etc.).

Here is an example query with a list of questions from English Language & Usage that were manually removed by moderators in the past 360 days:

Answer 2

Another SEDE query to list questions that were manually removed (= removed by a mod) from the list of hot network questions on a given SE website, by Glorfindel:

SELECT h53.PostId AS [Post Link],
  h52.CreationDate AS [Became hot],
  h53.CreationDate AS [Removed],
  h53.UserId AS [User Link],
  'site://posts/' + CAST(h53.PostId AS NVARCHAR) + '/revisions|Revisions'
  FROM PostHistory AS h53
  LEFT OUTER JOIN PostHistory AS h52
    ON h52.PostId = h53.PostId
   AND h52.PostHistoryTypeId = 52 -- became HNQ
  WHERE h53.PostHistoryTypeId = 53 -- removed from HNQ
  ORDER BY h53.CreationDate DESC

This fork by an anonymous user adds to the list all other HNQs:

SELECT h52.PostId AS [Post Link],
  h52.CreationDate AS [Became hot],
  h53.CreationDate AS [Removed],
  h53.UserId AS [User Link],
  'site://posts/' + CAST(h52.PostId AS NVARCHAR) + '/revisions|Revisions'
  FROM PostHistory AS h52
  LEFT OUTER JOIN PostHistory AS h53
    ON h52.PostId = h53.PostId
   AND h53.PostHistoryTypeId = 53 -- removed from HNQ
 WHERE h52.PostHistoryTypeId = 52 -- became HNQ
  ORDER BY h52.CreationDate DESC