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

2 rows where "created_at" is on date 2020-05-07 and favorite_count = 10

✎ 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
19099 19099 19098 1258476105230622726 958079839969447937 2020-05-07T19:17:39+00:00 Tomorrow, our @NJTV Learning Live educators include @lezimmaro from @bret_es, Ms. Somer Stanley from Lakehurst Elementary School, @SherrieYvette from @PembertonSchools, and @mynameisEWald from @barnegatschoolsSee you then!#NJTVLearningLive https://twitter.com/NewJerseyDOE/status/1258476105230622726/photo/1 6 10 New Jersey NJ https://www.nj.gov/education/ NewJerseyDOE
43368 43368 43367 1258445238856593410 237885691 2020-05-07T17:15:00+00:00 "Crisis can be a unique opportunity to change your path, to explore new opportunities or to find the person you were meant to be."Congratulations to @FlaglerSchools 2021 Teacher of the Year Michelle Coolican!#distancelearning #FL74Strong https://twitter.com/EducationFL/status/1258445238856593410/photo/1 3 10 Florida FL http://www.fldoe.org/ educationfl

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