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

1 row where "created_at" is on date 2020-04-02 and favorite_count = 375

View and edit SQL

Link rowid ▼ id user created_at full_text retweet_count favorite_count State Abbreviation Website Username
11338 11337 1245522301757652994 216215913 2020-04-02T01:23:52+00:00 Fake letter circulating on social media, saying DESE will not allow students to move on to the next grade level. NOT TRUE. Disappointed someone chose to joke about something this serious given the anxiety & uncertainty so many students & families are dealing with right now. https://twitter.com/MOEducation/status/1245522301757652994/photo/1 314 375 Missouri MO https://dese.mo.gov/ MOEducation

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
);