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-06 and retweet_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
9156 9156 9155 1258156076123525120 137435775 2020-05-06T22:05:58+00:00 State Superintendent of Education @Molly_Spearman shares a special message of appreciation for South Carolina's teachers who have gone above and beyond to support students during #COVID19 school closures. https://twitter.com/EducationSC/status/1258156076123525120/video/1 8 21 South Carolina SC https://ed.sc.gov/ EducationSC
20400 20400 20399 1257998532755292160 43333663 2020-05-06T11:39:57+00:00 Happy Nurses Day! Today, as we recognize all nurses for serving their communities, IDOE would like to specifically recognize Indiana's school nurses for serving Hoosier students and school communities. https://twitter.com/EducateIN/status/1257998532755292160/photo/1 8 17 Indiana IN https://www.doe.in.gov/ EducateIN
37268 37268 37267 1258042712990892035 54279993 2020-05-06T14:35:30+00:00 RT @PutnamWVSchools: Putnam County Schools Updated Graduation Dates for the Class of 2020! 🎓#PutnamProud #PutnamWV #LoveMyWVSchool #WVHer… 8 0 West Virginia WV https://wvde.us/ WVeducation
43387 43387 43386 1258020585034129408 237885691 2020-05-06T13:07:35+00:00 RT @volusiaschools: Teachers, here is a thank you message from students across the district! #TeacherAppreciationWeek #VCSTeachersAreSuperh… 8 0 Florida FL http://www.fldoe.org/ educationfl
45343 45343 45342 1257964901039030272 39562251 2020-05-06T09:26:18+00:00 RT @ncvps: NCVirtual Teachers, you make a difference every day! Thank you for your personal touches and continuous encouragement for our st… 8 0 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
);