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 = 42
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | user | created_at | full_text | retweet_count | favorite_count | State | Abbreviation | Website | Username | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
11146 | 11146 | 11145 | 1263283420312023041 | 216215913 | 2020-05-21T01:40:12+00:00 | .@MoCommissioner stopped by the Governor’s Mansion earlier this evening to celebrate the #Classof2020! A special thanks to @GovParsonMO and @FirstLadyTeresa for lighting up the Mansion for 20 minutes tonight to recognize MO grads! #ShowMeSuccess https://twitter.com/MOEducation/status/1263283420312023041/photo/1 | 7 | 42 | Missouri | MO | https://dese.mo.gov/ | MOEducation |
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 );