Conversation

Hi Jason! I have a quick question I was hoping you could help me with. On the following page - pushshift.io/using-bigquery (1/)

Replying to

and

you have a query under the heading "Extracting Significant Subreddit Words". Could you help me understand the difference between (2/)

Replying to

and

s_count and g_count in that query? Thanks! (3/3)

Replying to

and

the s_count is the number of times it appears in the subreddit and the g_count is the number of times it appears globally.

Replying to

Thanks! If I search without time restrictions, how far back am I going?

Replying to

and

December, 2005 for comments and January, 2006 for submissions. There are some earlier submissions currently absent from the very early

Replying to

and

history that will eventually be added (but there aren't many missing compared to the overall amount -- like a fraction of a percent)