tweets

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

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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user, in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, retweet_count, favorite_count, retweeted, lang

created_at (date) 1 ✖

  • 2021-10-12 · 13 ✖
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
1447731092144869376 swyx 33521530 2021-10-12T01:09:24+00:00 RT @patio11: Understanding difference between O(N^2) vs. O(n) is indistinguishable from magic at least some of the time, like all good tech… 1447414882081521665 1447414882081521665     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             1 145 0 0 1   en  
1447731998412324866 swyx 33521530 2021-10-12T01:13:00+00:00 RT @pablostanley: probably nothing https://twitter.com/pablostanley/status/1447435624064106499/video/1 1447435624064106499 1447435624064106499     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 58]             0 438 0 0 1 0 en  
1447768315024216066 swyx 33521530 2021-10-12T03:37:19+00:00 @tylermcginnis @remix_run @Netlify @vercel Netlify’s greatest strength is that it is framework agnostic. Netlify’s greatest weakness is that it is framework agnostic.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [43, 167] 1447751618758201344 380724965 tylermcginnis       0 1 40 0 0   en  
1447782020860375040 swyx 33521530 2021-10-12T04:31:46+00:00 @tylermcginnis @remix_run @Netlify @vercel lately ive been wondering if i’m being grossly underpaid https://twitter.com/swyx/status/1447477307141079040?s=21   1447477307141079040 1447477307141079040   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [43, 123] 1447771655334338565 380724965 tylermcginnis       1 0 3 0 0 0 en  
1447785276395253765 swyx 33521530 2021-10-12T04:44:43+00:00 Twitter be like “You are unable to view this tweet because this person is either very private or hates your guts but we’re going to tease you anyway because curiosity = time on site”       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 183]             0 2 121 0 0   en  
1447785811882102786 swyx 33521530 2021-10-12T04:46:50+00:00 @jlongster is it ridiculous tho? after every meal seems like it makes sense       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [11, 75] 1447765155773812739 14615235 jlongster       0 0 2 0 0   en  
1447786244658778113 swyx 33521530 2021-10-12T04:48:33+00:00 @tannerlinsley @kentcdodds @remix_run worst kept secret haha if ive learned anything it is not to tell any secrets to react devs unless you WANT everyone to know       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [38, 162] 1447647706906710016 50136899 tannerlinsley       0 0 3 0 0   en  
1447803435160457220 swyx 33521530 2021-10-12T05:56:52+00:00 @techgirl1908 haha amazing that even someone as well known as you gets upset over a good ol’ “You are unable to view this tweet”       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [14, 128] 1447794738095132673 2932738834 techgirl1908       0 0 1 0 0   en  
1447803849712947205 swyx 33521530 2021-10-12T05:58:31+00:00 @wongmjane also probably lots of bots 🤖       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [11, 39] 1447796953186664449 337119125 wongmjane       0 0 2 0 0   en  
1447988170293923841 Domitrius 857629786650357761 2021-10-12T18:10:56+00:00 I’m so proud to announce I’ve accepted a role with the absolutely mind blowing team that is @Netlify 😭 I’ve received the honor to take over the Jamstack ecosystem as the new Jamstack Community Engineer 🎉 As of Monday expect to see much more of me 👀       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 250]             0 10 620 0 0   en  
1447763660982546437 Dalton 64015831 2021-10-12T03:18:49+00:00 https://twitter.com/ParentsDome/status/1346823887422676992/video/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 23]             0 876 8306 0 0 0 und  
1447783075820158985 swyx 33521530 2021-10-12T04:35:58+00:00 @adrian_twarog https://twitter.com/swyx/status/1234181016367063040?s=21   1234181016367063040 1234181016367063040   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [15, 38] 1447762596774363140 945877361844568064 adrian_twarog       1 0 3 0 0 0 und  
1448056349485457409 swyx 33521530 2021-10-12T22:41:51+00:00 @grahamneray @ZisserZappy https://twitter.com/swyx/status/1448056349485457409/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [25, 25] 1447746509601230848 389779048 grahamneray       0 0 1 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]);