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 = 12

✎ 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
25811 25811 25810 1258437016557150213 22049097 2020-05-07T16:42:20+00:00 We are grateful to City teachers for all that they do to guide, motivate, and support New York’s students, especially during these challenging times. 🧡 Let us all show our teachers just how much we appreciate their work! #ThankATeacherNYC: http://schools.nyc.gov/thankateachernyc https://twitter.com/NYCSchools/status/1258437016557150213/photo/1 1 12 New York NY https://www.schools.nyc.gov/ NYCSchools
40265 40265 40264 1258472243849355264 229380911 2020-05-07T19:02:18+00:00 TODAY at 4pm: Watch the Virtual Support Circle for Educators, hear directly from educators across California. This virtual event will be an opportunity to share experiences, resources, and encouragement as schools and families navigate next steps together: http://Facebook.com/CAEducation https://twitter.com/CADeptEd/status/1258472243849355264/photo/1 10 12 California CA https://www.cde.ca.gov/ cadepted

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