tweets

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

17 rows where "created_at" is on date 2021-09-01, is_quote_status = 0 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20" sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user, retweeted, lang

favorite_count 10 ✖

source 1 ✖

  • Twitter for iPhone · 17 ✖

created_at (date) 1 ✖

  • 2021-09-01 · 17 ✖
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
1432895757812518914 swyx 33521530 2021-09-01T02:39:05+00:00 @preetster brb raising 5m on 50 post       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [11, 36] 1432894058821656577 16343912 preetster       0 0 2 0 0   en  
1432898918589763587 swyx 33521530 2021-09-01T02:51:38+00:00 @beyang YES. PLEASE. ESP IF IT LETS ME SEARCH WITHIN FOLDERS URGH       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [8, 65] 1432894718266986499 16520821 beyang       0 0 7 0 0   en  
1432899310635544578 swyx 33521530 2021-09-01T02:53:12+00:00 @lesliecdubs @jamstackconf ong this looks AMAZING, kudos whoever coded this up!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [27, 79] 1432860023475118082 22217773 lesliecdubs       0 0 2 0 0   en  
1432901153931464707 swyx 33521530 2021-09-01T03:00:31+00:00 @shaundai @netflix @burgessdryan holy crap, that’s amazing!!!!! congrats to you AND ryan AND netflix!!!! wow 🤩       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [33, 110] 1432728448062132224 1004483816 shaundai       0 0 1 0 0   en  
1432901738923651074 swyx 33521530 2021-09-01T03:02:51+00:00 @willjohnsonio @GatsbyJS one of the very best parts of tech networking is seeing friends glow up in their own way and knowing you have that special bond because you knew each other before they “made it”!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [25, 203] 1432753753992663044 917069583097397248 willjohnsonio       0 0 5 0 0   en  
1432902144139558917 swyx 33521530 2021-09-01T03:04:27+00:00 @mitchellh @JordiMonPMM if you’re interested i made an alternative query builder UI for Twitter: https://bettertwitter.netlify.app/       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [24, 120] 1432769589516009472 12819682 mitchellh       0 0 8 0 0 0 en  
1432902470418661381 swyx 33521530 2021-09-01T03:05:45+00:00 @oldmanuk @mitchellh i made an alternative twitter query builder UI as well, in case this question comes up again in future https://bettertwitter.netlify.app/       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [21, 148] 1432813730690179073 7969342 oldmanuk       0 1 7 0 0 0 en  
1432906359121403904 swyx 33521530 2021-09-01T03:21:12+00:00 @_SreetamDas @lesliecdubs @jamstackconf @zachleat ah nice! was talking more about the ogimage “badge” but literally everyone on Zach’s team is top shelf       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [50, 152] 1432904504488259584 520276345 _SreetamDas       0 0 2 0 0   en  
1432906565804199944 swyx 33521530 2021-09-01T03:22:02+00:00 @paulbiggar @buildsghost @darklang i see the @edith_h influence haha       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [35, 68] 1432905149308153860 86938585 paulbiggar       0 0 0 0 0   en  
1432909493805981699 Beyang Liu 16520821 2021-09-01T03:33:40+00:00 It’s time to speak the truth plainly: @github code search is terrible and the dev world deserves so much better. If you believe this is true, then I invite you to try @sourcegraph. You’ll never look back—I promise.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 214]             0 30 241 0 1   en  
1432945962255728640 swyx 33521530 2021-09-01T05:58:34+00:00 @umanagineer 2007 here! there were so many golden opportunities i slept right through 😂       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [13, 87] 1432942187524681734 938901720016363520 umachingunde       0 0 3 0 0   en  
1432963851780177932 swyx 33521530 2021-09-01T07:09:40+00:00 @embano1 @eoinbrazil @joe_hellerstein oh wow. thank you for sharing this!!! will take a while to go through 👀       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [38, 109] 1432961975462637568 122923515 embano1       0 0 0 0 0   en  
1433111522230734850 swyx 33521530 2021-09-01T16:56:27+00:00 @3rdGenNuke 100% was channeling that quote!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [12, 43] 1433017373066469376 367845362 3rdGenNuke       0 0 2 0 0   en  
1433117668156928004 swyx 33521530 2021-09-01T17:20:52+00:00 This is not to say that if you can’t figure it out, it’s not your fault: we are tremendously bad at documenting our code, and documenting our journeys. Seek out your dev community for help, and remember how this feels when its your turn to see newer devs struggling.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 267] 1432977957388120064 33521530 swyx       0 1 8 0 0   en  
1433117669591433216 swyx 33521530 2021-09-01T17:20:53+00:00 This is why I also dislike the term “self taught” - it diminishes the hard work of docs writers, bloggers, YouTubers, and community volunteers who pave the way for you without expecting anything in return. No dev is an island.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 227] 1433117668156928004 33521530 swyx       0 5 45 0 0   en  
1433123612899229698 swyx 33521530 2021-09-01T17:44:30+00:00 @flybayer @blitz_js @rudiyardley hot take: those people never needed graphql in the first place 🤷‍♂️ but congrats 🎉       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [33, 115] 1433087810320355339 2826554209 flybayer       0 0 14 0 0   en  
1432886704667447296 swyx 33521530 2021-09-01T02:03:06+00:00 @secos https://youtu.be/BzAdXyPYKQo       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [7, 30] 1432879787840782343 14494227 secos       0 0 3 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]);