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

3 rows where "created_at" is on date 2020-05-21 and favorite_count = 9

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: created_at (date)

Link rowid ▼ id user created_at full_text retweet_count favorite_count State Abbreviation Website Username
15485 15485 15484 1263530037082493024 277068270 2020-05-21T18:00:10+00:00 🎓 | The Kentucky Department of Education would like to give a #KDEclassof2020shoutout to the senior class at @GCMusketeers! #KyEd #TeamKDE #TeamKentucky #TogetherKY #ClassOf2020 https://twitter.com/KyDeptofEd/status/1263530037082493024/photo/1 5 9 Kentucky KY https://education.ky.gov/Pages/default.aspx KyDeptofEd
38593 38593 38592 1263278334609367040 106549178 2020-05-21T01:20:00+00:00 It's 8:20 p.m. on May 20, 2020. That means it's officially time to celebrate the #KSClassof2020. @KsCommissioner Dr. Randy Watson has a special message for this amazing group of seniors! #KansansCan https://bit.ly/2WMzEpY 4 9 Kansas KS https://www.ksde.org/ ksdehq
43256 43256 43255 1263467078406660096 237885691 2020-05-21T13:50:00+00:00 "In these unprecedented times, compassion should be at the forefront of every decision that we, as educators, make in regard to our students."Congratulations to the 2021 District Teacher of the Year for @keysschools, Jacob Poelma!#FL74strong #distancelearning https://twitter.com/EducationFL/status/1263467078406660096/photo/1 1 9 Florida FL http://www.fldoe.org/ educationfl

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