tweets

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

18 rows where "created_at" is on date 2021-10-25 and favorited = 0

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user, source, in_reply_to_user_id, in_reply_to_screen_name, retweet_count, favorite_count, lang, 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
1452436475430064135 swyx 33521530 2021-10-25T00:46:55+00:00 @acemarke @ProvablyFlarnie ya basically. and my impression was you had to self host mastodon, and switch between networks, which is probably not true but by then i had lost interest       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [27, 181] 1452358332392644614 727704217012604928 acemarke       0 0 1 0 0   en  
1452445875159044098 Lívia Labate 769920 2021-10-25T01:24:16+00:00 A screw it, let's do it: TL,DR: AMP format doesn't support JavaScript in the way you can use it on regular web pages. This prevents publishers from using header bidding with AMP (limits how many ad exchanges one can connect to @ a time, making it less desirable/useful; see doc)       Twitter for Android f0976f342215a984184a13a54b26877ece8cebba 0 [0, 280] 1452430810880122885 769920 livlab       0 48 251 0 0   en  
1452464233996853249 swyx 33521530 2021-10-25T02:37:13+00:00 Read my latest: “[http://swyx.io] When You Stop Counting” https://www.getrevue.co/profile/swyx/archive/794799       Revue e01d36c55a12ec4cf389049ec42665dce335b54e 0 [0, 90]             0 2 37 0 0 0 en  
1452487403889836036 swyx 33521530 2021-10-25T04:09:17+00:00 @xjamundx it was pretty rad! altho honestly i felt like they skimmed over the unbalanced brackets bit and that was the hard part in my eyes       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [10, 139] 1452468628771643396 119903601 xjamundx       0 0 0 0 0   en  
1452487937694658566 swyx 33521530 2021-10-25T04:11:24+00:00 @acemarke yes and love you for that! 🔥 i think there’s an unsolved “part two” which is the “okay you want to be an artist and play an infinite game, how do you get paid to do it” and i feel like the creator/crypto economy is unfortunately the best answer humanity has come up with       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [10, 280] 1452475566863626249 727704217012604928 acemarke       0 0 2 0 0   en  
1452490390871822342 swyx 33521530 2021-10-25T04:21:09+00:00 @dr IMO Ikigai is overrated. People often exoticize Ikigai as the ultimate solution to life, the universe and everything. But long tail creator economy has collapsed “What the world needs” with “What you can be paid for.” And you will come to love what you are good at. KISS.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [4, 279] 1452476597076783106 5264 dr       0 1 11 0 0   en  
1452521988291903492 swyx 33521530 2021-10-25T06:26:43+00:00 @leereilly congrats! page not found... can someone restore it?!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [11, 63] 1452311303196921861 26900242 leereilly       0 0 0 0 0   en  
1452522488022200328 swyx 33521530 2021-10-25T06:28:42+00:00 @triptych @Netlify yay! if you want >1% of power i did an "overview" tutorial here a couple years ago: https://www.youtube.com/watch?v=mT5siI19gtc and its only added functionality since then!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [19, 174] 1452305754208231440 811530 triptych       0 0 4 0 0 0 en  
1452658640809197569 Vincent Woo 918426768 2021-10-25T15:29:43+00:00 After some time, I'm pleased to release an update on Lambda School. Leaked internal documents show that the school has been performing even worse than I had previously written. Lambda has managed to place less than 30% of its *graduates* in 2020. 🧵🧵🧵 https://www.businessinsider.com/lambda-school-promised-lucrative-tech-coding-career-low-job-placement-2021-10 https://twitter.com/fulligin/status/1452658640809197569/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 276]             0 125 860 0 0 0 en  
1452704978934505476 swyx 33521530 2021-10-25T18:33:51+00:00 @PeerReynders @jensimmons 🔥 thanks for the shoutout! yes absolutely applies here. altho i regret the wordiness of the phrasing haha       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [26, 131] 1452704118229848066 4624048794 PeerReynders       0 0 1 0 0   en  
1452711199913635840 swyx 33521530 2021-10-25T18:58:34+00:00 @jh3yy @reactjs very nice!! for the audio whimsy you may want use-sound from @JoshWComeau https://www.joshwcomeau.com/react/announcing-use-sound-react-hook/       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [16, 113] 1452709779885932546 2396811776 jh3yy       0 0 5 0 0 0 en  
1452717511087046657 swyx 33521530 2021-10-25T19:23:39+00:00 @threepointone *takes long sip of water*       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [15, 40] 1452693953493487617 1593171 threepointone       0 0 3 0 0   en  
1452717725353066496 swyx 33521530 2021-10-25T19:24:30+00:00 @ricmac @jquery @m_gol @jeresig @simonw @tlakomy       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [40, 48] 1452692657151508480 105895323 ricmac       0 0 1 0 0   und  
1452745670071250944 swyx 33521530 2021-10-25T21:15:33+00:00 Advice that changed my writing forever: It’s not about sitting down every week and coming up with an idea each time. It’s about working on 50 different potential ideas at once, and publishing the most-ready one each week. https://www.swyx.io/writing-mise-en-place/       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 248]             0 16 148 0 0 0 en  
1452772078390689792 swyx 33521530 2021-10-25T23:00:29+00:00 @bramusblog ha thanks Bramus!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [12, 29] 1452770915662635011 380852968 bramusblog       0 0 0 0 0   en  
1452772699512524800 swyx 33521530 2021-10-25T23:02:57+00:00 Looking forward to host the 7th @temporalio meetup tomorrow at 9am PT! Presenting: 💰 Temporal at @Stripe 🗺️ Temporal Feature Map 🎉 2 Year Anniversary Q&A Signup at https://temporal.io/meetup!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 196]             0 5 15 0 0 0 en  
1452775662570274823 swyx 33521530 2021-10-25T23:14:43+00:00 @threepointone when video sir       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [15, 29] 1451580547461963776 1593171 threepointone       0 0 1 0 0   en  
1452782685504491521 swyx 33521530 2021-10-25T23:42:38+00:00 @noahsussman @sophaskins hey @kentcdodds this story is exactly on point for your "Dont Solve Problems" talk       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [25, 107] 1310951946690465792 6331142 noahsussman       0 0 5 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]);