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

4 rows where "created_at" is on date 2020-04-02 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
18292 18292 18291 1245738219418710016 2533050750 2020-04-02T15:41:50+00:00 Beginning on Monday, @NMPBS channels will air instructional content to support families and K-5 students learning at home. @ABQschools has taken the lead in producing the lessons, but you do not need to be an APS student to benefit! https://twitter.com/NMPED/status/1245738219418710016/photo/1 6 7 New Mexico NM https://webnew.ped.state.nm.us/ nmped
26073 26073 26072 1245769762057183233 22049097 2020-04-02T17:47:11+00:00 Our Regional Enrichment Centers (RECs) provide care for the children of essential workers who are NYC residents. If you think you qualify, please visit http://schools.nyc.gov/recs to learn more and apply. https://twitter.com/NYCSchools/status/1245769762057183233/photo/1 5 7 New York NY https://www.schools.nyc.gov/ NYCSchools
40646 40646 40645 1245819971390726144 229380911 2020-04-02T21:06:42+00:00 State Superintendent of Public Instruction @TonyThurmond announced that the CDE and the @SBECalifornia have issued new guidance on graduation requirements and grading for seniors. Read more: https://www.cde.ca.gov/nr/ne/yr20/yr20rel18.asp. https://twitter.com/CADeptEd/status/1245819971390726144/photo/1 8 7 California CA https://www.cde.ca.gov/ cadepted
43626 43626 43625 1245748411699286019 237885691 2020-04-02T16:22:20+00:00 We are so proud of our 67 school districts for their tremendous work over the past few weeks to not only set the pace for #distancelearning, but for every single one being up & running by March 30. #educationWILLcontinue #COVID19 @richardcorcoran https://twitter.com/EducationFL/status/1245748411699286019/photo/1 2 7 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
);