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-07 and favorite_count = 21

✎ 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
30424 30424 30423 1258396166804377607 82933637 2020-05-07T14:00:00+00:00 Since the distance learning period began, our school-age care workers have cared for thousands of children of critical workers each day. Their service has helped build Minnesota’s health care capacity. Thank you to our school-age care workers for going above and beyond. https://twitter.com/MnDeptEd/status/1258396166804377607/photo/1 5 21 Minnesota MN https://education.mn.gov/MDE/index.html MnDeptEd
36718 36718 36717 1258188383815446528 87008467 2020-05-07T00:14:21+00:00 It’s #TeacherAppreciationWeek and we're showcasing our amazing teachers in a new video series featuring our 2020 Regional Teachers of the Year. The first video spotlights our State Teacher of the Year Amy Campbell. Note: filming was done pre-COVID. WATCH: https://youtu.be/ZBTcERT0k4s https://twitter.com/waOSPI/status/1258188383815446528/photo/1 9 21 Washington WA https://www.k12.wa.us/ waOSPI

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