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 = 19
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | user | created_at | full_text | retweet_count | favorite_count | State | Abbreviation | Website | Username | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
4339 | 4339 | 4338 | 1258356838904496133 | 2319382922 | 2020-05-07T11:23:44+00:00 | It's Throwback Thursday! Post a #TBT photo that brings back memories of your favorite teacher, first year teaching, and/or very first day of school. We'll get the ball rolling with these fun #TBT photos of our @EducateCT colleagues...#ThankATeacher #TeacherAppreciationWeek https://twitter.com/EducateCT/status/1258356838904496133/photo/1 | 3 | 19 | Connecticut | CT | https://portal.ct.gov/SDE | EducateCT |
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 );