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

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

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: user, retweet_count, State, Abbreviation, Website, Username, created_at (date)

Link rowid ▼ id user created_at full_text retweet_count favorite_count State Abbreviation Website Username
17104 17104 17103 1263470076952543244 123944252 2020-05-21T14:01:55+00:00 #oklaed https://twitter.com/oksde/status/1263470076952543244/photo/1 3 5 Oklahoma OK https://sde.ok.gov/ oksde
19059 19059 19058 1263515276315951105 958079839969447937 2020-05-21T17:01:31+00:00 Congratulations to @TabathaRosproy, the 2020 National Teacher of the Year! To learn more about Tabatha, click here: https://ntoy.ccsso.org/tabatha-rosproy @CCSSO #NTOY20 https://twitter.com/NewJerseyDOE/status/1263515276315951105/photo/1 0 5 New Jersey NJ https://www.nj.gov/education/ NewJerseyDOE
22196 22196 22195 1263569320577286149 151885972 2020-05-21T20:36:16+00:00 Tune in now to watch @DrJamesLane live on @CNN to discuss the future of public education as we navigate the reopening schools in the Commonwealth following the #covid19 pandemic! #VAis4Learners 1 5 Virginia VA http://www.doe.virginia.gov/ VDOE_News
43252 43252 43251 1263532434211119105 237885691 2020-05-21T18:09:42+00:00 With the push to quickly switch most things to virtual platforms due to #COVID19, the need for accessible hardware, software & digital sites has never been greater. Understanding the need for accessibility is on the rise, which is why we observe #GlobalAccessibilityAwareness Day. https://twitter.com/EducationFL/status/1263532434211119105/photo/1 1 5 Florida FL http://www.fldoe.org/ educationfl
43255 43255 43254 1263483436309905408 237885691 2020-05-21T14:55:00+00:00 "It is important to highlight student growth and success, even while teaching remotely!"Congratulations to Whitney Jones, the 2021 Teacher of the Year for @NassauSchoolsFL!#FL74strong #distancelearning https://twitter.com/EducationFL/status/1263483436309905408/photo/1 2 5 Florida FL http://www.fldoe.org/ educationfl
44997 44997 44996 1263443224036851713 39562251 2020-05-21T12:15:12+00:00 #OurNCHeroes shoutouts today recognize Dr. Travis Reeves, Superintendent, @SurryCoSchools and Donnie Lynthacum, Director of Child Nutrition for Montgomery County Schools. Thank you for all you do to ensure the needs of staff, students and families are met! https://twitter.com/ncpublicschools/status/1263443224036851713/photo/1 2 5 North Carolina NC https://www.dpi.nc.gov/ ncpublicschools

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