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-05-06 and retweet_count = 7

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: favorite_count, created_at (date)

Link rowid ▼ id user created_at full_text retweet_count favorite_count State Abbreviation Website Username
18115 18115 18114 1258158336941322240 2533050750 2020-05-06T22:14:57+00:00 RT @Deb4CongressNM: It’s #TeacherAppreciationWeek. I remember my kindergarten teacher Ms. Taylor, on the 1st day of school, let me sit on… 7 0 New Mexico NM https://webnew.ped.state.nm.us/ nmped
25819 25819 25818 1258071284849704960 22049097 2020-05-06T16:29:02+00:00 During this uncertain time, the upcoming Parent Teacher Conference is an important opportunity for teachers to hear from you about how your student is doing and how remote learning supports are working for them. 7 29 New York NY https://www.schools.nyc.gov/ NYCSchools
37265 37265 37264 1258079338244775939 54279993 2020-05-06T17:01:02+00:00 RT @WVGovernor: LIVE: Justice Administration holds press briefing on COVID-19 response - May 6, 2020. For more information about #COVID19,… 7 0 West Virginia WV https://wvde.us/ WVeducation
45365 45365 45364 1257962615114010625 39562251 2020-05-06T09:17:13+00:00 RT @DHCATHLETICS: 2020 D.H. Conley Teacher Appreciation Celebration!! #PittCountySchoolsStrong #NCLighthouseLeaders https://twitter.com/DHCATHLETICS/status/1257840780074508290/photo/1 7 0 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
);