edu_tweets
Data source: Big Local News · About: big-local-datasette
1 row where "created_at" is on date 2020-05-21 and favorite_count = 510
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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
38548 | 38548 | 38547 | 1263457291094851585 | 106549178 | 2020-05-21T13:11:06+00:00 | Wow! What a major announcement. We are so excited that @TabathaRosproy was announced as the 2020 National Teacher of the year by @CCSSO. Tabatha, what an accomplishment. We are so proud of you. @465USD #NTOY20 https://twitter.com/ksdehq/status/1263457291094851585/photo/1 | 111 | 510 | 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 );