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 = 53
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | user | created_at | full_text | retweet_count | favorite_count | State | Abbreviation | Website | Username | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
20907 | 20907 | 20906 | 1258154356081393666 | 22182297 | 2020-05-06T21:59:08+00:00 | RT @GovAbbott: This week is #TeacherAppreciationWeek. Thank you to our teachers for stepping up with innovative solutions to educate our… | 53 | 0 | Texas | TX | https://tea.texas.gov/ | teainfo |
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 );