tweets

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

9 rows where "created_at" is on date 2021-10-25 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20" sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: in_reply_to_user_id, in_reply_to_screen_name, retweet_count, favorite_count, lang

created_at (date) 1 ✖

  • 2021-10-25 · 9 ✖
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
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  
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  
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  
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  
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  

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