tweets

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

6 rows where in_reply_to_user_id = 2048741 and retweeted = 0

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source, is_quote_status, retweet_count, favorite_count

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
1426949687714598919 swyx 33521530 2021-08-15T16:51:31+00:00 @shreyas Most people are presented with ladders and their entire goal in life is to climb to the next rung. Smart people make the ladders.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [9, 139] 1426946595677872133 2048741 shreyas       0 9 78 0 0   en  
1432504165440184321 swyx 33521530 2021-08-31T00:43:02+00:00 @shreyas “Good Enough” is better than “Best”: https://twitter.com/swyx/status/1221129594146840577?s=21   1221129594146840577 1221129594146840577   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [9, 70] 1432501769989357568 2048741 shreyas       1 0 4 0 0 0 en  
1459941287121985539 swyx 33521530 2021-11-14T17:48:21+00:00 @shreyas The "I want to be in the Zoom Where It Happens" to "ugggh I have Zoom fatigue" pipeline       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [9, 96] 1459931369019035649 2048741 shreyas       0 0 5 0 0   en  
1464724371038040065 swyx 33521530 2021-11-27T22:34:37+00:00 @shreyas also has a whiff of taking credit and not acknowledging others who worked hard to solve this emergency without making noise about it. part of good PMing is giving recognition.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [9, 185] 1464721736109203460 2048741 shreyas       0 0 9 0 0   en  
1464843139416346629 swyx 33521530 2021-11-28T06:26:34+00:00 @shreyas i am liking this genre https://twitter.com/shreyas/status/1459931369019035649   1459931369019035649 1459931369019035649   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [9, 31] 1464832326483939329 2048741 shreyas       1 0 4 0 0 0 en  
1471980286921564167 swyx 33521530 2021-12-17T23:07:03+00:00 @shreyas @adanisaureen you can prototype it by putting it in your Twitter location like @jsjoeio did https://twitter.com/dr/status/1374247809730318336   1374247809730318336 1374247809730318336   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [23, 124] 1471964790012612608 2048741 shreyas       1 0 2 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]);