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

5 rows where "created_at" is on date 2020-05-21 and favorite_count = 7

✎ 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
19058 19058 19057 1263557762593837058 958079839969447937 2020-05-21T19:50:21+00:00 Tomorrow, our @NJTV Learning Live educators include @kmuck28 from @glotwp, @MusicWithMrR1 from @MineHillCAS, @kathygigs from @MTPSSchools, and @artsymrsV from @braggschoolcsdSee you then!#NJTVLearningLive https://twitter.com/NewJerseyDOE/status/1263557762593837058/photo/1 3 7 New Jersey NJ https://www.nj.gov/education/ NewJerseyDOE
31215 31215 31214 1263503187744440320 93914412 2020-05-21T16:13:29+00:00 Class of 2020🎓- Congratulations, we are so proud of you! 🎉Colorado and our nation need you now more than ever; you are the future leaders that will help us overcome challenges like this pandemic. Stay focused and hopeful! #classof2020strong #edcolo https://www.cde.state.co.us/communications/graduation-2020 https://twitter.com/codepted/status/1263503187744440320/photo/1 6 7 Colorado CO https://www.cde.state.co.us/ codepted
38580 38580 38579 1263288306005151744 106549178 2020-05-21T01:59:37+00:00 Congratulations, Hadley! Looks like @KState is getting another good one! #KSClassof2020 https://twitter.com/KimmerP2/status/1263178063841501184 1 7 Kansas KS https://www.ksde.org/ ksdehq
40128 40128 40127 1263275837366951938 229380911 2020-05-21T01:10:04+00:00 Join State Superintendent @TonyThurmond and the Closing the Digital Divide Task Force at the group's next hearing on Friday, May 22, at 4 p.m., on Facebook Live (http://Facebook.com/CAeducation). https://twitter.com/CADeptEd/status/1263275837366951938/photo/1 4 7 California CA https://www.cde.ca.gov/ cadepted
43254 43254 43253 1263494257496604672 237885691 2020-05-21T15:38:00+00:00 "My goal has always been to teach my students to problem solve & think critically through real-world challenges."Congratulations to Devon LaMonica, the 2021 Teacher of the Year for @OCSD1!#FL74strong #distancelearning https://twitter.com/EducationFL/status/1263494257496604672/photo/1 2 7 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
);