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

5 rows where "created_at" is on date 2020-05-07 and favorite_count = 7

✎ 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
25807 25807 25806 1258459200943947776 22049097 2020-05-07T18:10:29+00:00 All @NYCschools students or staff will be able to sign onto http://nycdoe.zoom.us with their DOE email and password, and will be able to use the full complement of features @Zoom_us offers. We will add Zoom to all DOE-issued iPads. 1 7 New York NY https://www.schools.nyc.gov/ NYCSchools
39235 39235 39234 1258384878967676928 60102515 2020-05-07T13:15:09+00:00 Thank you Jennifer Williams, 2019 @Milken Educator Award Winner, for all that you do! John Q Adams Middle School in @JPschools is lucky to have you! #LaEd #ThankATeacher #BeATeacherLA https://twitter.com/La_Believes/status/1258384878967676928/photo/1 2 7 Louisiana LA https://www.louisianabelieves.com/ la_believes
40264 40264 40263 1258498553917304832 229380911 2020-05-07T20:46:51+00:00 TONIGHT at 6 p.m.: State Superintendent @TonyThurmond will join a teleconference town hall with Assemblymember Tasha Boerner Horvath (@AsmTbh), two local educators, and a child psychiatrist, to speak about supporting students during COVID-19.Read more: https://a76.asmdc.org/tele-town-halls https://twitter.com/CADeptEd/status/1258498553917304832/photo/1 8 7 California CA https://www.cde.ca.gov/ cadepted
41547 41547 41546 1258542449514786816 749523404 2020-05-07T23:41:17+00:00 "A very special 'thank you' to our teachers this year," said Karen B. Salmon, Ph.D., State Schools Superintendent. "You are on the front lines of learning and engagement during these most difficult times." #TeacherAppreciationWeek https://youtu.be/QIkAg1mqHzI 0 7 Maryland MD http://marylandpublicschools.org/Pages/default.aspx MdPublicSchools
45285 45285 45284 1258499076926177288 39562251 2020-05-07T20:48:56+00:00 NCDPI is partnering with @CabCoSchools and @CLTMotorSpdwy to provide an unforgettable graduation for seniors from 10 Cabarrus County high schools - https://bit.ly/2SLNC8X. https://twitter.com/ncpublicschools/status/1258499076926177288/photo/1 3 7 North Carolina NC https://www.dpi.nc.gov/ ncpublicschools

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