tweets

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

11 rows where is_quote_status = 1 and source = "574fe4fa937eeb131136f7e3678f32d4ff3078d5" sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: display_text_range, retweet_count, favorite_count, retweeted, lang

source 1 ✖

  • Twitter for iPad · 11 ✖

is_quote_status 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
1435895069098356736 swyx 33521530 2021-09-09T09:17:16+00:00 @dunkhippo33 devtools angels! https://twitter.com/swyx/status/1357105644810063873?s=21   1357105644810063873 1357105644810063873   Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [13, 53] 1435829987366506496 14756283 dunkhippo33       1 0 2 0 0 0 de  
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  
1423138872884535298 swyx 33521530 2021-08-05T04:28:42+00:00 @MrLeebo thanks for asking :) here’s the state of things as of today. https://twitter.com/kentcdodds/status/1247905817342312449   1247905817342312449 1247905817342312449   Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [9, 69] 1423128272074940417 1107163664 MrLeebo       1 0 2 0 0 0 en  
1424444934476599296 swyx 33521530 2021-08-08T18:58:31+00:00 @bravelyjake devto and my site are one and the same. i didn’t particularly care about direct traffic for this one o didnt bother with the build time https://twitter.com/swyx/status/1231493665144688647   1231493665144688647 1231493665144688647   Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [13, 148] 1424431422727626757 1050397340056444928 bravelyjake       1 0 1 0 0 0 en  
1425559768039510021 swyx 33521530 2021-08-11T20:48:28+00:00 @dabit3 obnoxious startup bros be like https://twitter.com/swyx/status/1423327998556606464   1423327998556606464 1423327998556606464   Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [8, 38] 1425430853518340099 17189394 dabit3       1 0 9 0 0 0 en  
1432636294555791362 swyx 33521530 2021-08-31T09:28:04+00:00 @tlakomy actually understanding charts like these and how much youre not doing! https://twitter.com/swyx/status/1423025792783568899   1423025792783568899 1423025792783568899   Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [9, 79] 1432420643853713411 1903060381 tlakomy       1 0 5 0 0 0 en  
1434818980439592966 swyx 33521530 2021-09-06T10:01:17+00:00 GPTs contrasted with “Management Technologies”, like the assembly line, and possibly software? Software internally has GPTs too, though i am not very convinced by the ones listed here. https://twitter.com/Vernon3Austin/status/1425462308105564168 https://twitter.com/swyx/status/1434818980439592966/photo/1       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [0, 209] 1362333935322075139 33521530 swyx       1 0 3 0 0 0 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  
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  
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  
1427158370650230787 swyx 33521530 2021-08-16T06:40:45+00:00 @AdamRackis @chantastic @sveltejs 😎 https://twitter.com/swyx/status/1254508357227933696   1254508357227933696 1254508357227933696   Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [34, 35] 1427109635421519874 68567860 AdamRackis       1 0 7 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]);