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

8 rows where "created_at" is on date 2020-04-02 and favorite_count = 3

View and edit SQL

Suggested facets: created_at (date)

Link rowid ▼ id user created_at full_text retweet_count favorite_count State Abbreviation Website Username
6800 6799 1245508158543413248 933271290 2020-04-02T00:27:40+00:00 Mahalo to our schools, teachers and students involved with this effort including @jeffersonsurfer @stevensonbuccs @IlimaSchool @HTAcharter @KapoleiHigh @Kaimukimiddle @KaneoheEl @NVMSLancers ! #PublicSchoolProud#Hi4PublicEd https://twitter.com/Jess_Mariela/status/1245207851536011264 0 3 Hawaii HI http://www.hawaiipublicschools.org/Pages/Home.aspx HIDOE808
16014 16013 1245682410416746496 277068270 2020-04-02T12:00:04+00:00 ✋ | @GoTeachKY has a great idea for #ThankATeacherKY Thursday! Today, we challenge @AugustaSchools, @knoxkyschools, @covkyschools, @AllenCoSchools and @OneTeamFCS to give your teachers a BIG virtual high five to thank them for their continued efforts during #MyNTIKy! #TogetherKy https://twitter.com/GoTeachKY/status/1245659741587554304 3 3 Kentucky KY https://education.ky.gov/Pages/default.aspx KyDeptofEd
19208 19207 1245799011392552960 958079839969447937 2020-04-02T19:43:24+00:00 Today is #WorldAutismAwarenessDay!We hope you'll join us in recognizing this important day for its mission of spreading awareness, fostering support, and creating a more inclusive society for people of all abilities. https://twitter.com/NewJerseyDOE/status/1245799011392552960/photo/1 3 3 New Jersey NJ https://www.nj.gov/education/ NewJerseyDOE
29433 29432 1245766962791227392 3352227515 2020-04-02T17:36:03+00:00 Tip of the day: Writing is a great way to support literacy. Find a spare notebook, or staple papers together to create your own writer’s notebook! Kids can write all kinds of things: ideas, questions, thoughts, true stories, invented stories, rough drafts for poems, and more. 1 3 Rhode Island RI https://www.ride.ri.gov/ RIDeptEd
30602 30601 1245746801535303681 82933637 2020-04-02T16:15:56+00:00 Thank you to Minnesota’s families. We see you. We hear you. We value you. Thank you for your patience and your commitment to education. Keep up the good work. https://twitter.com/MnDeptEd/status/1245746801535303681/photo/1 1 3 Minnesota MN https://education.mn.gov/MDE/index.html MnDeptEd
33076 33075 1245741959353958400 20202335 2020-04-02T15:56:42+00:00 The inspiration we all need! ✨💙💫Logan, a Wade Park School student in @CLEMetroSchools, offers words of encouragement, suggestions for helping others and a reminder that we’re all #InThisTogetherOhio.Thank you for inspiring us, Logan! #OhioEd https://twitter.com/principalbuddy/status/1245507613766430727 0 3 Ohio OH http://education.ohio.gov/ OHEducation
33078 33077 1245726218554691588 20202335 2020-04-02T14:54:09+00:00 This is the definition of #InThisTogetherOhio! ✨❤️✨ Bravo to the @DaytonSchools community for everything you are doing to support students and ensure they continue to receive nutritious meals. Outstanding! #OhioEd https://twitter.com/daytonschools/status/1245420649780215810 0 3 Ohio OH http://education.ohio.gov/ OHEducation
40648 40647 1245766201113858048 229380911 2020-04-02T17:33:02+00:00 @CAgovernor Newsom, State Superintendent @TonyThurmond announced a major agreement between teachers, classified employees, school boards, superintendents & principals to work together, provide distance learning to CA students due to the COVID-19 outbreak: https://www.gov.ca.gov/2020/04/01/governor-newsom-announces-agreement-between-teachers-classified-employees-and-school-system-management-to-support-student-instruction-during-covid-19-outbreak/ https://twitter.com/CADeptEd/status/1245766201113858048/photo/1 3 3 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
);