edu_tweets

Table actions
The full text of tweets and selected Twitter metadata from the Twitter accounts of state and local public officials, as well as education and health agencies, since the beginning of the COVID-19 pandemic. We begin with state governors with more data to come. Where possible, please cite Big Local News as collecting and disseminating this information. We ask because it helps us show the impact we can have and that makes it easier to create ongoing support for Big Local News.

Data source: Big Local News · About: big-local-datasette

1 row where "created_at" is on date 2020-05-21 and favorite_count = 47

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ id user created_at full_text retweet_count favorite_count State Abbreviation Website Username
21252 21252 21251 1263522189296513024 188060534 2020-05-21T17:28:59+00:00 8K+ teachers have registered for the free, optional training on digital learning & teaching, made possible through a partnership with @Trevecca. Hear from teachers who have already participated and learn how to register: https://www.tn.gov/education/news/2020/5/21/8-000--teachers-register-for-free-training-on-digital-learning-and-teaching.html 22 47 Tennessee TN https://www.tn.gov/education.html TNedu

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [edu_tweets] (
   [] INTEGER,
   [id] INTEGER,
   [user] INTEGER,
   [created_at] TEXT,
   [full_text] TEXT,
   [retweet_count] INTEGER,
   [favorite_count] INTEGER,
   [State] TEXT,
   [Abbreviation] TEXT,
   [Website] TEXT,
   [Username] TEXT
);