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

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: user, retweet_count, Abbreviation

Link rowid ▼ id user created_at full_text retweet_count favorite_count State Abbreviation Website Username
4337 4337 4336 1258465952850731011 2319382922 2020-05-07T18:37:18+00:00 PK-12 continues to change & evolve as a result of the #COVID19 pandemic. Today, @teachcardona & @ceajeff joined @LucyVN to discuss the adjustments underway within our education system. Listen at http://tinyurl.com/yajvhsbc.@AFTCT @CAS_ct @CTAssocBdsofEd @capssct @ceanews @Covid19Ct https://twitter.com/wherewelive/status/1258374537223254016 4 6 Connecticut CT https://portal.ct.gov/SDE EducateCT
20393 20393 20392 1258390767032303617 43333663 2020-05-07T13:38:33+00:00 IDOE's number of STEM Certified Schools continues to climb. Check out the latest cohort of schools to earn this honor. https://www.doe.in.gov/news/indiana-department-education-announces-number-stem-certified-schools-continues-climb https://twitter.com/EducateIN/status/1258390767032303617/photo/1 3 6 Indiana IN https://www.doe.in.gov/ EducateIN
32834 32834 32833 1258386707164147712 20202335 2020-05-07T13:22:25+00:00 Forever Stamp. 📮💌 Forever connected.Ohio’s teachers are filling envelopes with inspiration and sending kind and encouraging words to their students.Check out this collection of messages landing in mailboxes...more reasons why #OhioLovesTeachers! https://twitter.com/i/moments/1256636406027386881 2 6 Ohio OH http://education.ohio.gov/ OHEducation
32836 32836 32835 1258191862155935744 20202335 2020-05-07T00:28:10+00:00 While this school year was shaped by unprecedented challenges, it will be defined by memories of individuals who ensured students remained supported and teaching and learning continued.@OHEducationSupt DeMaria applauds Ohio's educators. Now more than ever, #OhioLovesTeachers! https://twitter.com/OHEducation/status/1258191862155935744/video/1 2 6 Ohio OH http://education.ohio.gov/ OHEducation
40266 40266 40265 1258448461768167424 229380911 2020-05-07T17:27:48+00:00 Thanks @RocklinUSD teachers, for: social distance-appropriate photos, a positive outlook, teaching (and learning about tech from students), virtual pet day, handing out learning kits, and all you're doing right now!🍎 #TeacherAppreciationWeek #ThankATeacher #StrongerTogether https://twitter.com/CADeptEd/status/1258448461768167424/photo/1 2 6 California CA https://www.cde.ca.gov/ cadepted
41549 41549 41548 1258505779138576385 749523404 2020-05-07T21:15:34+00:00 It’s National Teacher Appreciation Day! Thank you to all of our wonderful educators! We appreciate all that you do for the children of Maryland. 2 6 Maryland MD http://marylandpublicschools.org/Pages/default.aspx MdPublicSchools

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