edu_tweets
Data source: Big Local News · About: big-local-datasette
1 row where "created_at" is on date 2020-05-06 and retweet_count = 70
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | user | created_at | full_text | retweet_count | favorite_count | State | Abbreviation | Website | Username | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
28357 | 28357 | 28356 | 1258158705188564992 | 833778992612274176 | 2020-05-06T22:16:25+00:00 | RT @BetsyDeVosED: To all of our outstanding teachers across the country, Happy National #TeacherAppreciationWeek! This Administration is so… | 70 | 0 | New Hampshire | NH | https://www.education.nh.gov/ | NHEdCommr |
Advanced export
JSON shape: default, array, newline-delimited
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 );