This workflow examines a sample of tweets from the days surrounding the scottisch referendum for independence in 2014 . After reading the data from a local database, basic text processing is used to extract hashtags from the dataset and term frequencies calculated and used to build a tag cloud. Subsequently, hashtag trending is examined over time, with a notable post election surge in the #the45 movement. Additionally, network analysis is performed in order to look at the most influential social graph surrounding this issue.
This workflow is designed to collect and store a sample of tweets on a particular search term. With each execution of the workflow, tweets are collected, favorite and retweet numbers are updated in existing records in a SQLite Database and new tweets are written to that same table.
For longitudinal data collection, the workflow may be periodically executed manually, run via command line using the batch executor or optimally scheduled for regular execution via the KNIME Server (https://www.knime.org/knime-server)