edu_tweets
Data source: Big Local News · About: big-local-datasette
3 rows where "created_at" is on date 2020-05-21 and favorite_count = 8
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | user | created_at | full_text | retweet_count | favorite_count | State | Abbreviation | Website | Username | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
20880 | 20880 | 20879 | 1263578423068262401 | 22182297 | 2020-05-21T21:12:26+00:00 | Please join us in celebrating Texas’s 2020 U.S. Presidential Scholars! These high-flying high school seniors are excellent examples of some of the best, brightest, and most dynamic students in our state. Find the winners here: http://bit.ly/3e79gwF. Congratulations! #txed https://twitter.com/usedgov/status/1263541633095778304 | 0 | 8 | Texas | TX | https://tea.texas.gov/ | teainfo |
25710 | 25710 | 25709 | 1263464515083141121 | 22049097 | 2020-05-21T13:39:49+00:00 | 🔹For students with 12-month Individualized Education Plan (IEPs) services, there will be no change to the calendar. Students will continue to be expected to participate from Thursday, July 2 to Thursday, August 13. Visit http://schools.nyc.gov/summer to learn more. | 8 | 8 | New York | NY | https://www.schools.nyc.gov/ | NYCSchools |
38592 | 38592 | 38591 | 1263282589709864960 | 106549178 | 2020-05-21T01:36:54+00:00 | Congratulations, Drue! Wishing you all the best! #KSClassof2020 https://twitter.com/druedavis6/status/1263281547416875008 | 0 | 8 | Kansas | KS | https://www.ksde.org/ | ksdehq |
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 );