Apparently it's not possible since they're all archived, because reddit constantly regenerate its webpages.
Apparently it's not possible since they're all archived, because reddit constantly regenerate its webpages.
https://bigquery.cloud.google.com/table/fh-bigquery:reddit_c...
Run an SQL over all comments of everyone
edit: so only comments till october. 6 months old, that is when they become archived. Guess google has only the archived comments.
PS: that BQ you linked is maintained by fhoffa[2]
The uploader of that BQ has cited Pushshift as their source[1].
PS: In the next couple of days the batched archive data for Q4 of 2019 as well as Q1 of 2020 will be available[2]
0: https://github.com/pushshift/api
1: https://www.reddit.com/r/bigquery/comments/fcyu4m/extended_o...
2: https://www.reddit.com/r/pushshift/comments/fuoe2d/september...