{"id":29552,"date":"2024-07-17T03:27:20","date_gmt":"2024-07-17T01:27:20","guid":{"rendered":"https:\/\/www.graviton.at\/letterswaplibrary\/twitter-count-of-posts-containing-specific-keywords\/"},"modified":"2024-07-17T03:27:20","modified_gmt":"2024-07-17T01:27:20","slug":"twitter-count-of-posts-containing-specific-keywords","status":"publish","type":"post","link":"https:\/\/www.graviton.at\/letterswaplibrary\/twitter-count-of-posts-containing-specific-keywords\/","title":{"rendered":"Twitter Count Of Posts Containing Specific Keywords"},"content":{"rendered":"<p><!-- SC_OFF --><\/p>\n<div class=\"md\">\n<p>I&#8217;m very confused by what API access is now needed to do this since it seems like this has changed. I&#8217;ve searched this sub and googled a ton and haven&#8217;t been able to come up with a good answer. If the $100 basic tier would allow me to scrape the data I need for a month to do this analysis I&#8217;m okay with that, but I can&#8217;t even tell if that access would allow me to comb through the tweets in the way I&#8217;m looking to. I&#8217;m basically just looking to do something as simple as this (obviously not in SQL language but easiest to explain this way):<\/p>\n<p>SELECT Day, count(distinct tweets) from twitter WHERE tweet like &#8216;%keywords%&#8217; and date_range between x AND y<\/p>\n<p> Thanks for any help!<\/p>\n<\/div>\n<p><!-- SC_ON -->   submitted by   <a href=\"https:\/\/www.reddit.com\/user\/BachShitCrazy\"> \/u\/BachShitCrazy <\/a> <br \/> <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1e55qj7\/twitter_count_of_posts_containing_specific\/\">[link]<\/a><\/span>   <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1e55qj7\/twitter_count_of_posts_containing_specific\/\">[comments]<\/a><\/span><\/p><div class='watch-action'><div class='watch-position align-right'><div class='action-like'><a class='lbg-style1 like-29552 jlk' href='javascript:void(0)' data-task='like' data-post_id='29552' data-nonce='65e0e39b87' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.graviton.at\/letterswaplibrary\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-29552 lc'>0<\/span><\/a><\/div><\/div> <div class='status-29552 status align-right'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>I&#8217;m very confused by what API access is now needed to do this since it seems like&#8230;<\/p>\n","protected":false},"author":0,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[85],"tags":[],"class_list":["post-29552","post","type-post","status-publish","format-standard","hentry","category-datatards","wpcat-85-id"],"_links":{"self":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/29552","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/types\/post"}],"replies":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/comments?post=29552"}],"version-history":[{"count":0,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/29552\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/media?parent=29552"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/categories?post=29552"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/tags?post=29552"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}