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-04-02 and favorite_count = 4

✎ 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
4407 4407 4406 1245701791595012099 2319382922 2020-04-02T13:17:05+00:00 Given the many challenges #COVID19 is presenting for PK-12, our educational partners reached out to us in solidarity to offer support for districts; please contact them directly if they can be of assistance. Remember, if CT remains united as one educational community, #WeGotThis! https://twitter.com/EducateCT/status/1245701791595012099/photo/1 2 4 Connecticut CT https://portal.ct.gov/SDE EducateCT
20519 20519 20518 1245706078773444611 43333663 2020-04-02T13:34:07+00:00 Governor Holcomb will be discussing education-related matters during his 2:30 ET press conference today, where Dr. McCormick will be joining him live. You can view the press conference here: https://livestream.com/accounts/18256195/events/9054752/player?width=960&height=540&enableInfoAndActivity=true&defaultDrawer=feed&autoPlay=true&mute=false#_blank 5 4 Indiana IN https://www.doe.in.gov/ EducateIN
21674 21674 21673 1245845687062769666 188060534 2020-04-02T22:48:53+00:00 We are so inspired by the resiliency of our students across the state that are continuing to support each other during these challenging times. #LearningInPlaceTN #BetterTogetherTN https://twitter.com/BlueRaidersLive/status/1245345709995503616 1 4 Tennessee TN https://www.tn.gov/education.html TNedu

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