edu_tweets
Data source: Big Local News · About: big-local-datasette
2 rows where "created_at" is on date 2020-05-07 and favorite_count = 12
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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
25811 | 25811 | 25810 | 1258437016557150213 | 22049097 | 2020-05-07T16:42:20+00:00 | We are grateful to City teachers for all that they do to guide, motivate, and support New York’s students, especially during these challenging times. 🧡 Let us all show our teachers just how much we appreciate their work! #ThankATeacherNYC: http://schools.nyc.gov/thankateachernyc https://twitter.com/NYCSchools/status/1258437016557150213/photo/1 | 1 | 12 | New York | NY | https://www.schools.nyc.gov/ | NYCSchools |
40265 | 40265 | 40264 | 1258472243849355264 | 229380911 | 2020-05-07T19:02:18+00:00 | TODAY at 4pm: Watch the Virtual Support Circle for Educators, hear directly from educators across California. This virtual event will be an opportunity to share experiences, resources, and encouragement as schools and families navigate next steps together: http://Facebook.com/CAEducation https://twitter.com/CADeptEd/status/1258472243849355264/photo/1 | 10 | 12 | 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 );