edu_tweets
Data source: Big Local News · About: big-local-datasette
2 rows where "created_at" is on date 2020-05-06 and retweet_count = 10
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | user | created_at | full_text | retweet_count | favorite_count | State | Abbreviation | Website | Username | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
15672 | 15672 | 15671 | 1258154610843320320 | 277068270 | 2020-05-06T22:00:09+00:00 | RT @LtGovColeman: As a teacher, I know that educators are lifelines for our kids. Due to #COVID19, the sacrifices our teachers make have be… | 10 | 0 | Kentucky | KY | https://education.ky.gov/Pages/default.aspx | KyDeptofEd |
15677 | 15677 | 15676 | 1258079117498613761 | 277068270 | 2020-05-06T17:00:10+00:00 | 🎓 | The Kentucky Department of Education would like to give a #KDEclassof2020shoutout to the senior class at Murray High School! #KyEd #TeamKDE #TeamKentucky #TogetherKY #Classof2020 https://twitter.com/KyDeptofEd/status/1258079117498613761/photo/1 | 10 | 23 | Kentucky | KY | https://education.ky.gov/Pages/default.aspx | KyDeptofEd |
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 );