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

2 rows where "created_at" is on date 2020-05-06 and retweet_count = 10

✎ 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
15672 15672 15671 1258154610843320320 277068270 2020-05-06T22:00:09+00:00 RT @LtGovColeman: As a teacher, I know that educators are lifelines for our kids. Due to #COVID19, the sacrifices our teachers make have be… 10 0 Kentucky KY https://education.ky.gov/Pages/default.aspx KyDeptofEd
15677 15677 15676 1258079117498613761 277068270 2020-05-06T17:00:10+00:00 🎓 | The Kentucky Department of Education would like to give a #KDEclassof2020shoutout to the senior class at Murray High School! #KyEd #TeamKDE #TeamKentucky #TogetherKY #Classof2020 https://twitter.com/KyDeptofEd/status/1258079117498613761/photo/1 10 23 Kentucky KY https://education.ky.gov/Pages/default.aspx KyDeptofEd

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
);