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

4 rows where "created_at" is on date 2020-04-02 and favorite_count = 8

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ id user created_at full_text retweet_count favorite_count State Abbreviation Website Username
16003 16003 16002 1245833023804903424 277068270 2020-04-02T21:58:33+00:00 .@GovAndyBeshear recommends recommends school closure period be extended through May 1. More info from the call to public/private superintendents today: Full recap/story: http://bit.ly/KYSchoolClosure0501 #TeamKDE #TeamKentucky #TogetherKY https://twitter.com/KyDeptofEd/status/1245833023804903424/photo/1 16 8 Kentucky KY https://education.ky.gov/Pages/default.aspx KyDeptofEd
16007 16007 16006 1245785935700164611 277068270 2020-04-02T18:51:27+00:00 .@KyDeptofEd facilitated a 2pm phone conversation with @GovAndyBeshear & our school superintendents. During the call, he asked that he be able to announce details from that conversation at 5pm ET. We are respecting that request. #TeamKentucky Watch here: http://youtube.com/GovAndyBeshear 4 8 Kentucky KY https://education.ky.gov/Pages/default.aspx KyDeptofEd
26077 26077 26076 1245705420120952832 22049097 2020-04-02T13:31:30+00:00 NYC’s 1,800+ public schools, 150,000 staff, and hundreds of thousands of families are working together to transform education as we know it in the nation's largest school system. We couldn't be prouder! https://twitter.com/i/events/1245379046558531584 1 8 New York NY https://www.schools.nyc.gov/ NYCSchools
37526 37526 37525 1245724463112564736 54279993 2020-04-02T14:47:11+00:00 Thank you to @BerkCoSchoolsWV for donating 3D printers to the FASTENeR Lab at @ShepherdU to make protective face shields for health care workers. #WVHeroesofEd https://twitter.com/WVeducation/status/1245724463112564736/photo/1 2 8 West Virginia WV https://wvde.us/ WVeducation

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