edu_tweets
Data source: Big Local News · About: big-local-datasette
2 rows where "created_at" is on date 2020-04-02 and favorite_count = 5
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | user | created_at | full_text | retweet_count | favorite_count | State | Abbreviation | Website | Username | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
40636 | 40636 | 40635 | 1245834964454608896 | 229380911 | 2020-04-02T22:06:16+00:00 | Our Distance Learning Innovations for Special Education Webinar is live now: https://www.facebook.com/CAEducation/videos/883505795446617/ | 8 | 5 | California | CA | https://www.cde.ca.gov/ | cadepted |
43623 | 43623 | 43622 | 1245810980933775363 | 237885691 | 2020-04-02T20:30:58+00:00 | In an unprecedented world, it is important to remember to show every person compassion and grace. Let's stand together today to raise awareness for autism and those with unique talents, abilities, and personalities. #WorldAutismDay#FLedu https://twitter.com/EducationFL/status/1245810980933775363/photo/1 | 1 | 5 | Florida | FL | http://www.fldoe.org/ | educationfl |
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 );