tweets

This is data scraped from swyx's timeline! See blog post

5 rows where "created_at" is on date 2021-08-31 and retweet_count = 1 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: in_reply_to_user_id, in_reply_to_screen_name, created_at (date)

is_quote_status 2 ✖

retweet_count 1 ✖

id user created_at full_text retweeted_status quoted_status place source truncated display_text_range in_reply_to_status_id in_reply_to_user_id in_reply_to_screen_name geo coordinates contributors is_quote_status retweet_count favorite_count favorited retweeted possibly_sensitive lang ▼ scopes
1432508202050994177 swyx 33521530 2021-08-31T00:59:04+00:00 Heard some ugly workplace stories today. Lots of things that people can't say out loud, but there's no stronger signal than employees voting with their feet. Departure of any one person isn't concerning, it's the trendline - and whether or not management takes it seriously.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 275]             0 1 51 0 0   en  
1432583994441297924 swyx 33521530 2021-08-31T06:00:15+00:00 Added a new question to my @savvycal_ - Can I record our conversation? Stealing a page from @sytses, I want to share as many of my conversations as possible and it's awkward to ask "can I record this" at the start of the convo. This way, open-minded people can opt in. https://twitter.com/swyx/status/1432583994441297924/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 271]             0 1 19 0 0 0 en  
1432598502060675073 swyx 33521530 2021-08-31T06:57:53+00:00 here's 91 quotes from Warren Buffett, who just turned 91. https://twitter.com/GRDecter/status/1432365846438027276?s=20 This one stuck out given my recent blogpost on devrel metrics: "Games are won by players who focus on the playing field –- not by those whose eyes are glued to the scoreboard." 🎯   1432365846438027276 1432365846438027276   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 265] 1386482851026112515 33521530 swyx       1 1 7 0 0 0 en  
1432848799353819138 swyx 33521530 2021-08-31T23:32:29+00:00 @jrhunt “full stack” https://twitter.com/swyx/status/1432848799353819138/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [8, 20] 1432821139978403845 14157064 jrhunt       0 1 85 0 0 0 en  
1432848974902284289 swyx 33521530 2021-08-31T23:33:11+00:00 @jrhunt “full stack #jamstack” https://twitter.com/swyx/status/1432848974902284289/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [8, 30] 1432848799353819138 33521530 swyx       0 1 24 0 0 0 en  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE [tweets] (
   [id] INTEGER PRIMARY KEY,
   [user] INTEGER REFERENCES [users]([id]),
   [created_at] TEXT,
   [full_text] TEXT,
   [retweeted_status] INTEGER,
   [quoted_status] INTEGER,
   [place] TEXT REFERENCES [places]([id]),
   [source] TEXT REFERENCES [sources]([id]), [truncated] INTEGER, [display_text_range] TEXT, [in_reply_to_status_id] INTEGER, [in_reply_to_user_id] INTEGER, [in_reply_to_screen_name] TEXT, [geo] TEXT, [coordinates] TEXT, [contributors] TEXT, [is_quote_status] INTEGER, [retweet_count] INTEGER, [favorite_count] INTEGER, [favorited] INTEGER, [retweeted] INTEGER, [possibly_sensitive] INTEGER, [lang] TEXT, [scopes] TEXT,
   FOREIGN KEY([retweeted_status]) REFERENCES [tweets]([id]),
   FOREIGN KEY([quoted_status]) REFERENCES [tweets]([id])
);
CREATE INDEX [idx_tweets_source]
    ON [tweets] ([source]);