edu_tweets
Data source: Big Local News · About: big-local-datasette
1 row where "created_at" is on date 2020-05-07 and favorite_count = 48
This data as json, copyable, CSV (advanced)
Suggested facets: created_at (date)
Link | rowid ▼ | id | user | created_at | full_text | retweet_count | favorite_count | State | Abbreviation | Website | Username | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1737 | 1737 | 1736 | 1258413246140354561 | 20196909 | 2020-05-07T15:07:52+00:00 | Meet the new student member on the Iowa State Board of Education, Hannah Groos! @NorwalkSchools @Norwalk_HS @norwalkch #iaedchat #GirlsWhoCodehttps://educateiowa.gov/article/2020/05/07/student-member-joins-state-board | 13 | 48 | Iowa | IA | https://educateiowa.gov/ | IADeptofEd |
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 );