tweets

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

17 rows where favorite_count = 0 and source = "574fe4fa937eeb131136f7e3678f32d4ff3078d5" sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: display_text_range, retweet_count, retweeted, lang

is_quote_status 2 ✖

  • 0 14
  • 1 3

favorited 2 ✖

  • 0 16
  • 1 1

source 1 ✖

  • Twitter for iPad · 17 ✖

favorite_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
1421277387413606403 swyx 33521530 2021-07-31T01:11:49+00:00 RT @jhooks: a couple of years ago @swyx asked us what our big hairy audacious goal was... this is still my answer I am super motivated to… 1421273039648399364 1421273039648399364     Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [0, 140]             1 3 0 0 1   en  
1422853734900453378 swyx 33521530 2021-08-04T09:35:40+00:00 @kageman @tsriram @ponnappa thanks for reading :)       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [28, 49] 1422849412821254149 9496932 kageman       0 0 0 0 0   en  
1424389025746411522 swyx 33521530 2021-08-08T15:16:22+00:00 @xdg 🔥 well put       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [5, 15] 1424340141490020353 20618252 xdg       0 0 0 0 0   en  
1426730661721776134 swyx 33521530 2021-08-15T02:21:11+00:00 RT @ppk: Breaking the web forward https://www.quirksmode.org/blog/archives/2021/08/breaking_the_we.html 1425825423837974545 1425825423837974545     Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [0, 58]             0 45 0 0 1 0 en  
1427157532351492100 swyx 33521530 2021-08-16T06:37:25+00:00 @serrynaimo wtf how       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [12, 19] 1427150065211109379 14838594 serrynaimo       0 0 0 0 0   en  
1427231910405705729 swyx 33521530 2021-08-16T11:32:58+00:00 @oneindiancoder thanks Arun! :) you can get the Community tier, email me the receipt and i can manually upgrade you?       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [16, 116] 1427172342535376896 1219823333287460867 oneindiancoder       0 0 0 0 0   en  
1428210178424406019 swyx 33521530 2021-08-19T04:20:16+00:00 @AyushCodes @ReactRally @Rich_Harris that is some lofty comparison! thanks for watching and glad you liked it 🤗       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [37, 111] 1428206538708033541 1261649364184956929 AyushCodes       0 0 0 0 0   en  
1437498030840762377 swyx 33521530 2021-09-13T19:26:52+00:00 RT @redpointvc: Join us for our next Redpoint Office Hours on September 22; investor @SaiVC_ will host special guest @swyx, Head of Develop… 1437459469261279232 1437459469261279232     Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [0, 140]             0 3 0 0 1   en  
1441519278235082753 swyx 33521530 2021-09-24T21:45:52+00:00 RT @simonw: This right here is why I've invested so much of my career learning (and building) tools that enable really rapid prototyping I… 1441502655021387790 1441502655021387790     Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [0, 140]             1 15 0 0 1   en  
1442904394886889472 swyx 33521530 2021-09-28T17:29:50+00:00 RT @LitAnscombe: I moderate /r/kafka and people often mistake for a subreddit about the programming language. Our users have almost spontan… 1442683658951802882 1442683658951802882     Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [0, 140]             0 1412 0 0 1   en  
1442904700387356674 swyx 33521530 2021-09-28T17:31:03+00:00 RT @protsaq: Currently reading @swyx's 'The Coding Career Handbook' (which is a great resource - helps very much with programmer's anxiety)… 1442885004284026893 1442885004284026893     Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [0, 140]             0 4 0 0 1   en  
1445537727131176967 swyx 33521530 2021-10-05T23:53:45+00:00 RT @ritakozlov_: A+ write up from @swyx. the great thing about “from the outside in” metaphor is that it works figuratively and literally —… 1445533835945414662 1445533835945414662     Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [0, 140]             1 3 0 0 1   en  
1451546462169427970 swyx 33521530 2021-10-22T13:50:19+00:00 @plusequals1 infinity* *”unlimited vacation” despite everyone knowing that this results in less days off.       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [13, 106] 1451468659445182464 1124734959867109390 plusequals1       0 0 0 0 0   en  
1455427803097145347 swyx 33521530 2021-11-02T06:53:23+00:00 @Idered @elgato @github ah nice call. but i associate it with sped up video..       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [24, 77] 1455423950524194818 49586611 Idered       0 0 0 0 0   en  
1457002741113319430 swyx 33521530 2021-11-06T15:11:37+00:00 RT @loujaybee: In some senses, I do think he's right ✅ @swyx did a good job of outlining the problem. When we're new to content and/or tec… 1456915351241990145 1456915351241990145     Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [0, 140]             0 2 0 1 1   en  
1460882858789146627 swyx 33521530 2021-11-17T08:09:50+00:00 @theptrk aww thanks man! its a great book you wont regret it       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [9, 60] 1460815988392296448 30587765 theptrk       0 0 0 0 0   en  
1440333166284140553 swyx 33521530 2021-09-21T15:12:41+00:00 @AdamTuttle @WorkingCodePod 🎉       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [28, 29] 1440310595283079172 9686352 AdamTuttle       0 0 0 0 0   und  

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