How can we find posts deleted by their author that deleted their own account later?

  • If you're talking about finding all such posts (posted by any deleted user), I'm not sure whether that is possible. If you're talking about finding all of a specific deleted user's posts (and you know the user's ID), that feature does exist for mods and staff.
    – V2Blast StaffMod
    Feb 19 at 21:16

1 Answer 1


You can't.

SEDE only keeps very limited fields for deleted posts. When you query PostsWithDeleted where the deletiondate is not null you will find that OwnerUserId and OwnerDisplayname are always null. So there is no convenient way to obtain that data from the public sources.

You'll need SE staff to run such query, assuming its results serve a legit goal.

  • 1
    A "legit goal" would be to find instances of this bug. Feb 18 at 11:04
  • 2
    @Sonic I don't see just looking for instances of that issue to be an inherently legit goal for looking for such content. The desire to find some additional questions fitting that criteria could be legit, but it would, IMO, depend on why the person wanted to go looking for more examples. The bug report question you linked already links to an example question. Why is there a need/desire to look for more? What benefit might be gained? I'm not actually asking you those questions. I'm saying that those are some of the considerations as to a request now for that data being legitimate.
    – Makyen
    Feb 18 at 19:15

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .