tweets

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

3 rows where favorite_count = 28, in_reply_to_screen_name = "swyx" and retweeted = 0 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: is_quote_status

created_at (date) 3 ✖

retweeted 1 ✖

favorite_count 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
1417165280522821632 swyx 33521530 2021-07-19T16:51:47+00:00 Why Orchestration: Every time you cross service boundaries, the probability of network or system failure increases. Instead of having every team write their own retries and timeouts and provisioning infrastructure, give them "reliability on rails". https://twitter.com/swyx/status/1417165280522821632/photo/1       Typefully 295366d0fb34352a1961af2413827f072adefdb9 0 [0, 251] 1417165272008433682 33521530 swyx       0 4 28 0 0 0 en  
1434281732833005570 swyx 33521530 2021-09-04T22:26:27+00:00 for what its worth: I ask because I'm on my 2nd or 3rd "last job". I'm enjoying it, paycheck is addictive as heroin, but also working for/with others diffuses responsibility and there's some strange psychological block to my creativity when anyone can veto me       TweetDeck 9335de48b3673c3f69433a34861c115d1d382be3 0 [0, 259] 1434278725210841095 33521530 swyx       0 0 28 0 0   en  
1450740609656901639 swyx 33521530 2021-10-20T08:28:09+00:00 Signal boost to the interesting work that Nicole and team are doing at Chrome with http://open-ui.org! imagine having alll these built in to the browser, its like Christmas morning https://twitter.com/stubbornella/status/1450702539347750917?s=21 https://twitter.com/swyx/status/1450740609656901639/photo/1   1450702539347750917 1450702539347750917   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 210] 1450406508559101959 33521530 swyx       1 6 28 0 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]);