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

✎ 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
11140 11140 11139 1263559253190680581 216215913 2020-05-21T19:56:16+00:00 Missouri high school seniors Rahul Kanna (Lafayette High School; @rockwoodschools) and Jordan Tierney (Visitation Academy) were selected as members of the 56th class of U.S. Presidential Scholars on Thursday by @usedgov! #ShowMeSuccess Read more: https://dese.mo.gov/communications/news-releases/us-presidential-scholars-program-honors-two-missouri-seniors https://twitter.com/MOEducation/status/1263559253190680581/photo/1 2 6 Missouri MO https://dese.mo.gov/ MOEducation
13322 13322 13321 1263475721525174272 759896773 2020-05-21T14:24:20+00:00 First meeting of school building reopening working groups is at 2 p.m. today. You also can email your ideas to reopeningideas@doe.k12.de.us. Find meeting details here: https://publicmeetings.delaware.gov/Meeting/66051?fbclid=IwAR2YDrzEhgIEpACremj1nDfG9P4jsT36rv5oTtb0yWIkZ9lhLTXH5cgnjck #netde #edude 6 6 Delaware DE https://www.doe.k12.de.us/# DEDeptofEd
19060 19060 19059 1263507916809740289 958079839969447937 2020-05-21T16:32:16+00:00 It's #GlobalAccessibilityAwarenessDay!Today, we recognize the importance of digital access & inclusion for the more than one billion people with disabilities & impairments. If you're interested in participating in or spreading awareness on #GAAD2020: https://bit.ly/2WTkvTT https://twitter.com/NewJerseyDOE/status/1263507916809740289/photo/1 2 6 New Jersey NJ https://www.nj.gov/education/ NewJerseyDOE
21246 21246 21245 1263592958332293120 188060534 2020-05-21T22:10:12+00:00 Thank you to Filip Forsberg of the @PredsNHL for sharing a message of encouragement and congratulations to the class of 2020. You can still share your own congratulatory message and show your support using #Classof2020TN. https://youtu.be/-VDb-UDI_68 0 6 Tennessee TN https://www.tn.gov/education.html TNedu
37165 37165 37164 1263565161878732801 54279993 2020-05-21T20:19:45+00:00 "The #COVID19 pandemic has brought with it challenges, yet for each one of you, it's also going to bring about opportunity...You are well on your way to being the next great generation." Superintendent Burch congratulates the class of 2020 & sends a message of hope to graduates. https://twitter.com/WVeducation/status/1263565161878732801/video/1 2 6 West Virginia WV https://wvde.us/ WVeducation
38543 38543 38542 1263497359490678786 106549178 2020-05-21T15:50:19+00:00 ❤️ @MOEducation https://twitter.com/MOEducation/status/1263462716888494080 0 6 Kansas KS https://www.ksde.org/ ksdehq

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