-8

Using the Stack Exchange Data Explorer (SEDE), Google, or another tool, how can I search for posts, comments, and other content I've written over the last 11 years for common English pronouns?

Additionally, it would be nice if this were a network wide search because less than 25% of my posts are on any one SE site.

  • Searching for posts is easy enough using the normal search function. Comments, not so easy. But why bother? – Raedwald Oct 30 at 13:52
  • 2
    You can use this query to get a list of comments, or this query to see your gendered language percentage. Taken from this answer – Grumpy says Reinstate Monica Oct 30 at 14:00
  • 2
    This is a possible duplicate for this question. (I cannot flag because I have suspended all moderator activities) – Grumpy says Reinstate Monica Oct 30 at 14:02
  • Eh, there's not really any tools for global search. Google doesn't let you find your own posts, and the global SE search doesn't cover user IDs too well. I can't search for my network ID anyway. SEDE might be applied, but that requires high-level SQL skills and knowing the database system as well as rene does, and for that bug that prevents cross-site queries from being executed. – Zoe Oct 30 at 14:03
8

I've written a SEDE template for network-wide search a while ago. I guess this version is a reasonable approximation for your request.

Some caveats:

  • only does common English (third-person) pronouns, as requested
  • doesn't account for pronouns used in quoted text (this is one of the first hits when running it for my account)
  • may yield false positives when you've posted content in another language than English
  • SEDE is updated once a week, on Sunday morning, so the results might be a little bit outdated
  • Might want to also add to the caveats that since LIKE is case sensitive, you won't get any pronouns with capital letters (like at the beginning of a sentence). – scohe001 Oct 30 at 14:40
  • 1
    @scohe001 LIKE is usually case sensitive but I've specified a case-insensitive collation with COLLATE SQL_Latin1_General_CP1_CI_AS so that's not a problem right now :) – Glorfindel Oct 30 at 14:43
  • Ahh I was wondering what the point of those were. TIL. :) – scohe001 Oct 30 at 14:46
  • As I am sure you know if the OP posts on language sites there will be false drops like 'he' in Spanish. I imagine the OP knows too but it can bite you. – mdewey Oct 30 at 14:51

You must log in to answer this question.

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