by Mike Shea on 19 August 2013
Twitter's recent Twitter archive feature makes it much easier to download and process our entire twitter postings.
Sly Flourish has over four years of daily #dnd tips and now, using this archive feature, they are all available to you in a single handy package. You can download the entire archive here:
Download the complete #dnd Tip Tweet Archive (500k zip)
This zip file contains a set of files, each of which contains over a thousand Sly Flourish "#dnd tip" tweets beginning on 17 May 2009. These tweets have been pulled from the Twitter archive of Sly Flourish and will be updated every six months.
See Your Twitter Archive to learn more about the Twitter archive.
Here is a list of the specific files in this archive:
dm_tip_tweets.txt: A simple text file containing all of the tweets with the tweet id, created_at, and text on separate lines.
dm_tip_tweets.html: An HTML5 version of the tweets. Each tweet's HTML contains the tweet id embedded in the <li> tag and the created_at date within a <date> tag. Each URL contained within the tweet has been hyperlinked. It has no associated stylesheet. You are free to design any stylesheet you prefer.
dm_tip_tweets.sqlite: A SQLite3 database containing each tweet. The schema includes the id, text, and created_at for each tweet.
dm_tip_tweets.csv: A comma separated value file of each tweet. It contains the id, created_at, and text. All items have been wrapped in quotes and quotes contained within the text have been escaped with "". It imports directly into Excel.
You are free to use this archive in many new and interesting ways. Maybe you want to put a random tip up on your blog once a day. Maybe you want to quote it in your new free ebook. Maybe you'd just like to set them up as a daily koan to ponder. As an example, the D&D Tweets Twitter account posts new random tweets from the archive every day using the sf_twitter_bot. I'm hoping you will find all new and great ways to use these D&D tips beyond what I've done here.
If you have an idea on using these in your commercial product, send an email to firstname.lastname@example.org to discuss your idea.
This archive will be updated every six months and will replace the monthly Twitter archives previously published.
These tweets and the Python source code for parsing the Twitter archive is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 3.0 License. You are free to share, copy, distribute, transmit, remix, and adapt the work as long as you attribute it to Michael E. Shea at http://slyflourish.com/, share the work under the same license, and do so for non-commercial purposes. If you have a commercial idea, a note to email@example.com to discuss it. To view a copy of this license, visit http://creativecommons.org/licenses/by-nc-sa/3.0/.