edu_tweets
Data source: Big Local News · About: big-local-datasette
3 rows where "created_at" is on date 2020-05-07 and favorite_count = 9
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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|
12432 | 12432 | 12431 | 1258367306079576065 | 3762413663 | 2020-05-07T12:05:19+00:00 | #COVID19 has taken a financial toll on many Pennsylvanians. Apply for benefits at http://uc.pa.gov. https://twitter.com/PennsylvaniaGov/status/1258367306079576065/photo/1 | 8 | 9 | Pennsylvania | PA | https://www.education.pa.gov/Pages/default.aspx | PennsylvaniaGov |
18112 | 18112 | 18111 | 1258461455147401216 | 2533050750 | 2020-05-07T18:19:26+00:00 | If you have questions about #Census2020 and why it's so important for New Mexico, there's a great opportunity to join a virtual Town Hall with @RepDebHaaland this evening. Enjoy live entertainment while you fill out your form! @ICountNM https://twitter.com/HakimBe/status/1258460118003249152 | 4 | 9 | New Mexico | NM | https://webnew.ped.state.nm.us/ | nmped |
40254 | 40254 | 40253 | 1258542224037384192 | 229380911 | 2020-05-07T23:40:23+00:00 | "At first I thought how was I going to teach without my space. And then I realized that I didn't need a space to maintain the established bond I had with my students." Mandy Kelly @SVUSDSchools | 6 | 9 | California | CA | https://www.cde.ca.gov/ | cadepted |
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 );