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

✎ 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
1654 1654 1653 1263521720780103682 20196909 2020-05-21T17:27:07+00:00 A BIG congrats to you three! https://bit.ly/2WURjvP #IaEdChat @JohnstonCSD @pcmcsd @BishopHeelanSch 4 10 Iowa IA https://educateiowa.gov/ IADeptofEd
25706 25706 25705 1263523842498191363 22049097 2020-05-21T17:35:33+00:00 Use these quick links to learn more about:🔸How to navigate @Google Classroom: http://on.nyc.gov/3djnyKZ🔸How to get started learning in @MicrosoftTeams: http://on.nyc.gov/3dgCvxH🔸How to use the NYCDOE @Zoom_us account: http://on.nyc.gov/3cf7UiS https://twitter.com/NYCSchools/status/1263523842498191363/photo/1 6 10 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
);