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 = 168

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
26062 26061 1245822390610755584 22049097 2020-04-02T21:16:18+00:00 Meal Hubs sites operate from 7:30AM-11:30AM for children and families and 11:30AM-1:30PM for adults. Vegetarian and halal options are available at all sites. All adults and children can pick up three meals at one time. No one will be turned away. No registration or ID required. https://twitter.com/NYCSchools/status/1245822243445211136 155 168 New York NY https://www.schools.nyc.gov/ NYCSchools

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