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

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: retweet_count

Link rowid ▼ id user created_at full_text retweet_count favorite_count State Abbreviation Website Username
20880 20880 20879 1263578423068262401 22182297 2020-05-21T21:12:26+00:00 Please join us in celebrating Texas’s 2020 U.S. Presidential Scholars! These high-flying high school seniors are excellent examples of some of the best, brightest, and most dynamic students in our state. Find the winners here: http://bit.ly/3e79gwF. Congratulations! #txed https://twitter.com/usedgov/status/1263541633095778304 0 8 Texas TX https://tea.texas.gov/ teainfo
25710 25710 25709 1263464515083141121 22049097 2020-05-21T13:39:49+00:00 🔹For students with 12-month Individualized Education Plan (IEPs) services, there will be no change to the calendar. Students will continue to be expected to participate from Thursday, July 2 to Thursday, August 13. Visit http://schools.nyc.gov/summer to learn more. 8 8 New York NY https://www.schools.nyc.gov/ NYCSchools
38592 38592 38591 1263282589709864960 106549178 2020-05-21T01:36:54+00:00 Congratulations, Drue! Wishing you all the best! #KSClassof2020 https://twitter.com/druedavis6/status/1263281547416875008 0 8 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
);