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 = 1593
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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
26063 | 26063 | 26062 | 1245822243445211136 | 22049097 | 2020-04-02T21:15:43+00:00 | NEWS: starting tomorrow, Friday, April 3, 2020 three free meals will be available daily for ALL New Yorkers in more than 400 Meal Hubs across the 5 boroughs. To find a location near you visit http://schools.nyc.gov/freemeals or text "NYC FOOD" to 877-877. https://twitter.com/NYCSchools/status/1245822243445211136/photo/1 | 794 | 1593 | New York | NY | https://www.schools.nyc.gov/ | NYCSchools |
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 );