edu_tweets
Data source: Big Local News · About: big-local-datasette
1 row where "created_at" is on date 2020-04-02 and favorite_count = 39
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | user | created_at | full_text | retweet_count | favorite_count | State | Abbreviation | Website | Username | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
12609 | 12609 | 12608 | 1245713130698801153 | 3762413663 | 2020-04-02T14:02:09+00:00 | Together we can slow the spread of #COVID19 using these 6 simple steps:🧼 Wash your hands🤧 Cover coughs + sneezes🤭 Don’t touch eyes, nose, or mouth🧽 Clean surfaces frequently🤒 Avoid people who are sick🏠 Stay homeInfo: http://on.pa.gov/coronavirushttps://twitter.com/PennsylvaniaGov/status/1241394134377811968/video/1 | 25 | 39 | Pennsylvania | PA | https://www.education.pa.gov/Pages/default.aspx | PennsylvaniaGov |
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 );