3 ms·
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 ht
by 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