tweets

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

7 rows where in_reply_to_screen_name = "GergelyOrosz" sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user, source, is_quote_status, retweet_count, favorite_count, retweeted

place 0 ✖

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
1442271902295154688 swyx 33521530 2021-09-26T23:36:32+00:00 @GergelyOrosz really seems like there is an institutional bias to Not Invented Here syndrome. makes you appreciate companies that don’t DIY, for example Shopify always makes a big splash when they adopt an external technology. who else celebrates adopting other companies’ tech?       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [14, 282] 1442162670753431559 30192824 GergelyOrosz       0 0 65 0 0   en  
1447483728691810306 swyx 33521530 2021-10-11T08:46:28+00:00 @GergelyOrosz i want to trust him and he seems knowledgeable about everything else but the fact that he says this with a straight face makes him either suspect or that he’s really talking about a special class of systems engineers that is not in the normal SWE pool. seems like the latter tbh       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [14, 292] 1447479139385085953 30192824 GergelyOrosz       0 0 1 0 0   en  
1449977842004074500 Gergely Orosz 30192824 2021-10-18T05:57:11+00:00 The sensible approach is not to delete one or the other. To maximize your "luck surface area" so opportunities find you, use both. They are very different networks. And one more on creating luck from @swyx: https://www.swyx.io/create-luck/       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 231] 1449976861967147011 30192824 GergelyOrosz       0 10 71 0 1 0 en  
1455430112967495685 swyx 33521530 2021-11-02T07:02:34+00:00 @GergelyOrosz one of mine that people seemed to like recently https://twitter.com/swyx/status/1451309430830612495   1451309430830612495 1451309430830612495   Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [14, 61] 1454444182068768769 30192824 GergelyOrosz       1 0 12 0 0 0 en  
1462557246735409157 swyx 33521530 2021-11-21T23:03:15+00:00 @GergelyOrosz they *swear* this time is different…       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [14, 50] 1462555224258891779 30192824 GergelyOrosz       0 0 3 0 0   en  
1462559566886014980 swyx 33521530 2021-11-21T23:12:28+00:00 @GergelyOrosz their ceo is ideologically aligned though. @bluesky is evidence. of course the execution has been unexciting thus far.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [14, 132] 1462557916368670727 30192824 GergelyOrosz       0 0 1 0 0   en  
1469881727464062979 swyx 33521530 2021-12-12T04:08:07+00:00 @GergelyOrosz im doing my best with @Coding_Career!!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [14, 52] 1469696174630354945 30192824 GergelyOrosz       0 0 13 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]);