edu_tweets
Data source: Big Local News · About: big-local-datasette
1 row where "created_at" is on date 2020-05-21 and favorite_count = 11
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | user | created_at | full_text | retweet_count | favorite_count | State | Abbreviation | Website | Username | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
20881 | 20881 | 20880 | 1263498012799782912 | 22182297 | 2020-05-21T15:52:55+00:00 | Did COVID-19 impact your child’s learning this school year? Know for sure. Register today for a free, at-home academic checkup to learn if your child is on track in key subject areas heading into the fall. Registration ends Jun 5: http://bit.ly/3cxLZnl https://twitter.com/teainfo/status/1263498012799782912/photo/1 | 13 | 11 | 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 );