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 = 35
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | user | created_at | full_text | retweet_count | favorite_count | State | Abbreviation | Website | Username | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
7951 | 7951 | 7950 | 1258100464249450501 | 67012353 | 2020-05-06T18:24:59+00:00 | We thank @GovPritzker for sharing his message of gratitude for all Illinois teachers and school staff. How are YOU celebrating #TeacherAppreciationWeek? Reach out and thank an educator today! #AllInIllinois #ILSchoolsStepUp https://twitter.com/ISBEnews/status/1258100464249450501/video/1 | 35 | 118 | Illinois | IL | https://www.isbe.net/ | ISBEnews |
40271 | 40271 | 40270 | 1258160886134394881 | 229380911 | 2020-05-06T22:25:05+00:00 | RT @CAgovernor: CA is working with agencies and cities to bridge the digital divide.@CA_Trans_Agency has partner with the City of Sacrame… | 35 | 0 | California | CA | https://www.cde.ca.gov/ | cadepted |
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 );