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-04-02 and favorite_count = 18

✎ 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
20978 20978 20977 1245792388179787777 22182297 2020-04-02T19:17:05+00:00 To avoid the spread of COVID-19 in our community, practice social distancing:✅Avoid going out in public ✅When in public, keep six feet of distance between you and others✅Follow guidance provided by local and state officials.More information https://texas.gov/covid19 https://twitter.com/teainfo/status/1245792388179787777/photo/1 17 18 Texas TX https://tea.texas.gov/ teainfo
35559 35559 35558 1245795514966331393 2359982887 2020-04-02T19:29:31+00:00 Thanks to all our hard-working school districts; the WDE Approves all 48 School District Adapted Learning Plans:https://edu.wyoming.gov/blog/2020/04/02/wde-approves-all-48-school-district-adapted-learning-plans/ 3 18 Wyoming WY https://edu.wyoming.gov/ WYOEducation

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