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

✎ 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
1741 1741 1740 1258375929547689984 20196909 2020-05-07T12:39:35+00:00 Especially relevant today. We have some resources for you: https://bit.ly/3dmCoQc #IaEdChat https://twitter.com/IADeptofEd/status/1258375929547689984/photo/1 6 8 Iowa IA https://educateiowa.gov/ IADeptofEd
19102 19102 19101 1258422364653735936 958079839969447937 2020-05-07T15:44:06+00:00 “...Through this partnership with @montclairstateu & @NJCIE, educators & families will get the support they need to increase the number of fully inclusive NJ schools." - @DrLRepollet https://bit.ly/2WzN3jL https://twitter.com/NewJerseyDOE/status/1258422364653735936/photo/1 3 8 New Jersey NJ https://www.nj.gov/education/ NewJerseyDOE
43373 43373 43372 1258392823038201857 237885691 2020-05-07T13:46:43+00:00 "Make your distance learning exciting & engaging. Keep it fun, active & interesting!" Congratulations to the 2021 Florida A&M University Teacher of the Year Leah Coleman!#distancelearning #FL74strong https://twitter.com/EducationFL/status/1258392823038201857/photo/1 1 8 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
);