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

10 rows where "created_at" is on date 2020-04-02 and favorite_count = 2

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: user, retweet_count, Abbreviation, Website, Username, created_at (date)

Link rowid ▼ id user created_at full_text retweet_count favorite_count State Abbreviation Website Username
4406 4406 4405 1245747293107761158 2319382922 2020-04-02T16:17:54+00:00 Happy belated #Paraeducator Appreciation Day to the educators providing the foundation for safe, supportive & engaging learning environments in our schools! CT Paraeducator of the Year @RESRedding Jamie Bairaktaris, aka “Mr. B”, shares words of inspiration for these trying times: https://twitter.com/EducateCT/status/1245747293107761158/video/1 1 2 Connecticut CT https://portal.ct.gov/SDE EducateCT
17268 17268 17267 1245501316232876032 123944252 2020-04-02T00:00:28+00:00 Some things never change! Teachers = Heroes. 🙌 #oklaed https://stateimpact.npr.org/oklahoma/2020/03/31/during-spanish-flu-pandemic-oklahoma-citys-teachers-were-true-heroes/ 1 2 Oklahoma OK https://sde.ok.gov/ oksde
18291 18291 18290 1245740155031285761 2533050750 2020-04-02T15:49:32+00:00 Lessons will also post on APS YouTube channel so that you can watch the lessons at the time that works best for your family. Videos are ASL accessible & available in English & Spanish. New Mexicans are collaborating to make quality instruction accessible to all students! https://twitter.com/NMPED/status/1245738219418710016 1 2 New Mexico NM https://webnew.ped.state.nm.us/ nmped
21677 21677 21676 1245759949013225473 188060534 2020-04-02T17:08:11+00:00 From Sesame Street to Mr. Rogers, public television has helped shaped the lives of so many children in our state and country. Thank you to the TN @PBS stations for jumping in to help our students continue learning during school closures. #LearningInPlaceTN https://www.tennessean.com/story/opinion/columnists/david-plazas/2020/04/02/coronavirus-public-television-childrens-education-pbs-digital-divide/5104806002/?utm_source=tennessean-Daily%20Briefing&utm_medium=email&utm_campaign=daily_briefing&utm_term=list_article_headline 1 2 Tennessee TN https://www.tn.gov/education.html TNedu
29435 29435 29434 1245741858883584000 3352227515 2020-04-02T15:56:18+00:00 Thanks for joining in, Carl! #RIReadsAtHome https://twitter.com/PVCougars/status/1245740100727832576 1 2 Rhode Island RI https://www.ride.ri.gov/ RIDeptEd
33073 33073 33072 1245800330903851008 20202335 2020-04-02T19:48:39+00:00 @BroadAndHigh @KingArtsComplex @WOSU @OhioPOL @OhioArtsCouncil @piquacityschool @BexleySchools @SFDStallions Congratulations to each of the nine Poetry Out Loud state finalists. ✨📓📝💫Your work is already among the classics!#ArtsInEducation #OhioEd 0 2 Ohio OH http://education.ohio.gov/ OHEducation
36799 36799 36798 1245807746013945856 87008467 2020-04-02T20:18:07+00:00 Especially during times of stress and (let's face it) less movement than usual, physical health is IMPORTANT! Check out this PE schedule by Regional Teacher of the Year Lisa Summers (@IvaluePhysEd): http://bit.ly/34gBgdP #WAedu #WeGotThisWA #COVID19 @ESD113 @TumwaterSDNews https://twitter.com/IvaluePhysEd/status/1245805083377291264 1 2 Washington WA https://www.k12.wa.us/ waOSPI
36812 36812 36811 1245714791152234497 87008467 2020-04-02T14:08:45+00:00 .@AWSLeaders and @WashingtonLYAC: So far, we haven’t heard questions from any students! Can you help us spread the word? 1 2 Washington WA https://www.k12.wa.us/ waOSPI
38785 38785 38784 1245744824201949186 106549178 2020-04-02T16:08:05+00:00 Okay, Kansas! Submit your nominations for the KS State Treasurer's "Surprise a Senior" scholarship contest! Nominations are due by April 30, 2020. Twenty lucky high school seniors will be awarded $2,500 scholarships! Check it out! https://www.kansasstatetreasurer.com/sas.html #KansansCan https://twitter.com/wibw/status/1245460931708170240 3 2 Kansas KS https://www.ksde.org/ ksdehq
46167 46167 46166 1245797800136314882 39562251 2020-04-02T19:38:36+00:00 Wow, this is awesome. We are amazed at your creativity! Your masks will help our healthcare workers stay safe. You are indeed #ncschoolheroes!!!!!! https://twitter.com/SLHS_AofE/status/1245684311140925443 1 2 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
);