tweets

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

8 rows where in_reply_to_user_id = 1909232666 and source = "1f89d6a41b1505a3071169f8d0d028ba9ad6f952"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: favorite_count, created_at (date)

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
1421276174764843008 swyx 33521530 2021-07-31T01:07:00+00:00 @fortelabs Simon Sinek taught me to start WITH why       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [11, 50] 1421275014217691138 1909232666 fortelabs       0 0 70 0 0   en  
1424180666250395649 swyx 33521530 2021-08-08T01:28:25+00:00 @fortelabs IT'S TIME TO BASB       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [11, 28] 1424168537053007873 1909232666 fortelabs       0 0 1 0 0   en  
1428398804932259852 swyx 33521530 2021-08-19T16:49:48+00:00 @fortelabs checks out (chinese names often work best in groups of 4, i might market test 打造二脑 to see how people react. 打造外脑 might be more self evident at the cost of compromising "Second" for "External") https://twitter.com/swyx/status/1428398804932259852/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [11, 204] 1428397878154698752 1909232666 fortelabs       0 0 2 0 0 0 en  
1463228475926401024 swyx 33521530 2021-11-23T19:30:28+00:00 @fortelabs not at all, what gives you that impression       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [11, 53] 1463033004557692930 1909232666 fortelabs       0 0 0 0 0   en  
1463246126509801475 swyx 33521530 2021-11-23T20:40:37+00:00 @fortelabs email is enough, no confirm needed unless the organizer opts for it. here, sign up for my company's workshop next week and experience it yourself https://lu.ma/temporalintro it sends a thing straight to your calendar, its perfect       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [11, 238] 1463242691311857664 1909232666 fortelabs       0 0 0 0 0 0 en  
1463249154809819140 swyx 33521530 2021-11-23T20:52:39+00:00 @fortelabs yup you can email everyone who joined at any time https://lu.ma/sveltenyc https://twitter.com/swyx/status/1463249154809819140/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [11, 85] 1463247759448834048 1909232666 fortelabs       0 0 1 0 0 0 en  
1465489233620058112 swyx 33521530 2021-11-30T01:13:55+00:00 @fortelabs just as long as you never see his mouth you're good https://twitter.com/swyx/status/1465489233620058112/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [11, 62] 1465487179791028225 1909232666 fortelabs       0 0 8 0 0 0 en  
1468157881962745856 swyx 33521530 2021-12-07T09:58:10+00:00 @fortelabs @PostScanMail this tweet helped me decide on postscanmail. thanks!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [25, 77] 1346838271666503680 1909232666 fortelabs       0 0 2 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]);