2 ms·

/Disclaimer/Disclosure/ (Unless you're suggesting that working for Google Cloud means you're not qualified to comment, which I doubt! :) ) This really is the H

• fhoffa 10y ago
  Whoa, you're right. To prove the point to myself I went to search on all reddit comments during 2016-11 (waiting for 2016-12 now). http://imgur.com/a/W1JuE http://imgur.com/a/W1JuE The most popular "disclaimer:" was "Disclaimer: This user cannot verify whether or not this comment has been edited by /u/spez", as /r/the_donald reacted to /u/spez revelation of editing comments. October had more regular disclaimers, like "I am not ..." (most popular, 181), "I'm not a" (88), "I have no" (69), "I do not" (52). Further down, 7th place, "I work for" (30). There were less "disclosures", but when used they said "I am a" (31), "I work for" (29), "I'm not a" (25). So in an absolute count for "I work for" there were virtually the same number for both, but "I work for" is less relevant in the "disclaimer" space than the "disclosure" one. (thanks for the tip) SELECT COUNT(*) c, word, word1, word2, word3 FROM ( SELECT id, offset, word, LEAD(word) OVER(PARTITION BY id ORDER BY offset) word1, LEAD(word, 2) OVER(PARTITION BY id ORDER BY offset) word2, LEAD(word, 3) OVER(PARTITION BY id ORDER BY offset) word3 FROM ( SELECT id, SPLIT(REGEXP_REPLACE(LOWER(body), r'\s', ',')) words FROM `fh-bigquery.reddit_comments.2016_11` WHERE LOWER(body) LIKE '%disclaimer%' ) a, a.words AS word WITH OFFSET offset ) WHERE word='disclaimer:' GROUP BY 2,3,4,5 ORDER BY c DESC LIMIT 30