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 = 13

✎ 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
21422 21422 21421 1258374704580177923 188060534 2020-05-07T12:34:43+00:00 Thank you to all the district staff and teachers for helping assemble and distribute meals to students and supporting the community. Share examples of these #TNTeacherHeroes with us. #TeacherAppreciationWeek https://twitter.com/TNedu/status/1258374704580177923/photo/1 2 13 Tennessee TN https://www.tn.gov/education.html TNedu
32833 32833 32832 1258421352274501635 20202335 2020-05-07T15:40:05+00:00 "When Ohio needed its educators to step up the most, you answered the call."We join @OHEducationSupt Paolo DeMaria to give a standing ovation to Ohio's educators!Now more than ever, #OhioLovesTeachers! ❤️#ThankATeacher #TeacherAppreciationWeek https://twitter.com/OHEducation/status/1258191862155935744/video/1 8 13 Ohio OH http://education.ohio.gov/ OHEducation
40253 40253 40252 1258547033763274752 229380911 2020-05-07T23:59:30+00:00 "We are not just educators. We are parents, caregivers, spouses, etc. And we are taking care of our students. Important to take a moment to pause to avoid getting overwhelmed." Mara Madrigal-Weiss @sandiegoCOE 4 13 California CA https://www.cde.ca.gov/ cadepted

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