Count tweets per day

tweet-archive-date.js

#!/usr/bin/env node

// download: https://twitter.com/settings/your_twitter_data/data
// run in twitter-archive/data/

window = {}
window.YTD = {}
window.YTD.tweet = {}

require('./tweet.js')

require('fs').writeFileSync('tweets.csv',
  window.YTD.tweet.part0
    .map(t => ({ text: t.tweet.full_text, date: new Date(t.tweet.created_at) }))
    .map(({ text, date }) => `${text}\t${date.toISOString().split('T')[0]}\t${date.toISOString().split('T')[1].slice(0, 5)}`)
    .join('\n').toString())

tweets-by-date.sh

#!/bin/bash

# requires https://harelba.github.io/q/

q -t 'SELECT c2, count(*) FROM ./tweets.csv WHERE c2 IS NOT NULL GROUP BY c2' > tweets-by-date.csv