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

2 rows where "created_at" is on date 2020-05-21 and favorite_count = 13

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: created_at (date)

Link rowid ▼ id user created_at full_text retweet_count favorite_count State Abbreviation Website Username
38542 38542 38541 1263502077441040384 106549178 2020-05-21T16:09:04+00:00 When @TrooperBenKHP gives you a "shout out" in your rear-view mirror on i70, that's generally not a good sign. But when Trooper Ben gives you a shout out on social media, you know you've arrived! Well done, @TabathaRosproy! #KansansCan #NTOY20 https://twitter.com/TrooperBenKHP/status/1263471705877622785 3 13 Kansas KS https://www.ksde.org/ ksdehq
40125 40125 40124 1263516004031709184 229380911 2020-05-21T17:04:25+00:00 Webinar for local educational agencies (LEAs) | Fall 2020: A Discussion on Safe Re-Opening of California SchoolsLive now: https://www.facebook.com/CAEducation/videos/245170253456765/ 11 13 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
);