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

2 rows where "created_at" is on date 2020-05-06 and retweet_count = 35

View and edit SQL

Link rowid ▼ id user created_at full_text retweet_count favorite_count State Abbreviation Website Username
7951 7950 1258100464249450501 67012353 2020-05-06T18:24:59+00:00 We thank @GovPritzker for sharing his message of gratitude for all Illinois teachers and school staff. How are YOU celebrating #TeacherAppreciationWeek? Reach out and thank an educator today! #AllInIllinois #ILSchoolsStepUp https://twitter.com/ISBEnews/status/1258100464249450501/video/1 35 118 Illinois IL https://www.isbe.net/ ISBEnews
40271 40270 1258160886134394881 229380911 2020-05-06T22:25:05+00:00 RT @CAgovernor: CA is working with agencies and cities to bridge the digital divide.@CA_Trans_Agency has partner with the City of Sacrame… 35 0 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
);