edu_tweets
Data source: Big Local News · About: big-local-datasette
1 row where "created_at" is on date 2020-04-02 and favorite_count = 26
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | user | created_at | full_text | retweet_count | favorite_count | State | Abbreviation | Website | Username | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
19209 | 19209 | 19208 | 1245750148787044353 | 958079839969447937 | 2020-04-02T16:29:15+00:00 | 📚@NewJerseyDOE, @NJTV, and @NJEA have partnered to create NJTV Learning Live!📝Starting April 6th, children in grades 3-6 will be able to tune in each weekday to lessons taught by New Jersey teachers👩🏫Learn more: https://bit.ly/39EmH4w #JerseyStrong #NJTVLearningLive https://twitter.com/NewJerseyDOE/status/1245750148787044353/photo/1 | 10 | 26 | New Jersey | NJ | https://www.nj.gov/education/ | NewJerseyDOE |
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 );