Twitter Followers

The City uses Twitter to share news and information about programs and services with citizens. This measure tracks the number of followers on the City's Twitter account.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"janesville-data-socrata/twitter-followers-ks5z-p4vi\".\"twitter_followers\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.