edu_tweets

Table actions
The full text of tweets and selected Twitter metadata from the Twitter accounts of state and local public officials, as well as education and health agencies, since the beginning of the COVID-19 pandemic. We begin with state governors with more data to come. Where possible, please cite Big Local News as collecting and disseminating this information. We ask because it helps us show the impact we can have and that makes it easier to create ongoing support for Big Local News.

Data source: Big Local News · About: big-local-datasette

3 rows where "created_at" is on date 2020-05-07 and favorite_count = 9

✎ View and edit SQL

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

CSV options: 

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
);