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

✎ 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
15669 15669 15668 1258368712605827076 277068270 2020-05-07T12:10:55+00:00 🎓 | The Kentucky Department of Education would like to give a #KDEclassof2020shoutout to the senior class at Lawrence County High School! #KyEd #TeamKDE #TeamKentucky #TogetherKY #Classof2020 https://twitter.com/KyDeptofEd/status/1258368712605827076/photo/1 2 5 Kentucky KY https://education.ky.gov/Pages/default.aspx KyDeptofEd
19100 19100 19099 1258455282960797707 958079839969447937 2020-05-07T17:54:55+00:00 Completing the #2020Census is an investment in our students & the resources they need to succeed. We are empowered now to help shape the future for the next generation of learners!Thank you, teachers, for your investment in New Jersey's students! #ThankATeacherNJ #NJCensus2020 https://twitter.com/NewJerseyDOE/status/1258455282960797707/photo/1 3 5 New Jersey NJ https://www.nj.gov/education/ NewJerseyDOE
19103 19103 19102 1258393143944380419 958079839969447937 2020-05-07T13:47:59+00:00 If you could only use one word to describe your teachers, what would it be?#ThanksATeacherNJ#TeacherAppreciationWeek https://twitter.com/NewJerseyDOE/status/1258393143944380419/photo/1 4 5 New Jersey NJ https://www.nj.gov/education/ NewJerseyDOE
25809 25809 25808 1258459198536507392 22049097 2020-05-07T18:10:28+00:00 We are pleased that, following several weeks of collaboration with the company, we were able to address security and privacy concerns for our students and staff, and @Zoom_us is now a safe, secure platform for use across the DOE. 0 5 New York NY https://www.schools.nyc.gov/ NYCSchools
32831 32831 32830 1258486592718733314 20202335 2020-05-07T19:59:19+00:00 "We are able to adapt to change and rise above the challenges."@KubeschLeila, Ohio's 2020 Teacher of the Year and National Teacher of the Year Finalist, shares words of comfort and hope with our state's educators.Leila is a remarkable reason why #OhioLovesTeachers! https://twitter.com/OHEducation/status/1258486592718733314/video/1 0 5 Ohio OH http://education.ohio.gov/ OHEducation

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