edu_tweets
Data source: Big Local News · About: big-local-datasette
4 rows where "created_at" is on date 2020-04-02 and favorite_count = 8
This data as json, copyable, CSV (advanced)
Suggested facets: user, State, Abbreviation, Website, Username, created_at (date)
Link | rowid ▼ | id | user | created_at | full_text | retweet_count | favorite_count | State | Abbreviation | Website | Username | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
16003 | 16003 | 16002 | 1245833023804903424 | 277068270 | 2020-04-02T21:58:33+00:00 | .@GovAndyBeshear recommends recommends school closure period be extended through May 1. More info from the call to public/private superintendents today: Full recap/story: http://bit.ly/KYSchoolClosure0501 #TeamKDE #TeamKentucky #TogetherKY https://twitter.com/KyDeptofEd/status/1245833023804903424/photo/1 | 16 | 8 | Kentucky | KY | https://education.ky.gov/Pages/default.aspx | KyDeptofEd |
16007 | 16007 | 16006 | 1245785935700164611 | 277068270 | 2020-04-02T18:51:27+00:00 | .@KyDeptofEd facilitated a 2pm phone conversation with @GovAndyBeshear & our school superintendents. During the call, he asked that he be able to announce details from that conversation at 5pm ET. We are respecting that request. #TeamKentucky Watch here: http://youtube.com/GovAndyBeshear | 4 | 8 | Kentucky | KY | https://education.ky.gov/Pages/default.aspx | KyDeptofEd |
26077 | 26077 | 26076 | 1245705420120952832 | 22049097 | 2020-04-02T13:31:30+00:00 | NYC’s 1,800+ public schools, 150,000 staff, and hundreds of thousands of families are working together to transform education as we know it in the nation's largest school system. We couldn't be prouder! https://twitter.com/i/events/1245379046558531584 | 1 | 8 | New York | NY | https://www.schools.nyc.gov/ | NYCSchools |
37526 | 37526 | 37525 | 1245724463112564736 | 54279993 | 2020-04-02T14:47:11+00:00 | Thank you to @BerkCoSchoolsWV for donating 3D printers to the FASTENeR Lab at @ShepherdU to make protective face shields for health care workers. #WVHeroesofEd https://twitter.com/WVeducation/status/1245724463112564736/photo/1 | 2 | 8 | West Virginia | WV | https://wvde.us/ | WVeducation |
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 );