tweets

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

13 rows where "created_at" is on date 2021-08-29 and source = "1f89d6a41b1505a3071169f8d0d028ba9ad6f952" sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user, retweet_count, favorite_count

in_reply_to_screen_name 7 ✖

is_quote_status 2 ✖

  • 0 12
  • 1 1

created_at (date) 1 ✖

  • 2021-08-29 · 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
1431829714671476737 𝚂𝚆𝙸𝙽𝙳𝙻𝙴𝙳 877551680451162112 2021-08-29T04:03:00+00:00 S05E09: The Scheme (Bernie Madoff) // A Wall Street tycoon's money management firm is revealed to be the world's largest Ponzi scheme. Listen: https://swindledpodcast.com/podcasts/season-5/69-the-scheme/ https://twitter.com/SwindledPodcast/status/1431829714671476737/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 167]             0 8 65 0 0 0 en  
1431855446386638854 swyx 33521530 2021-08-29T05:45:15+00:00 @chrismessina @Goopt @brianmcc @bretkinsella @otter_ai @MicrosoftTeams @Webex just caught up on it - congrats on 1000 episodes!! the part about keeping non-insiders informed about tech is so true and y'all have done an amazing job at it 👏       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [78, 238] 1430645500550602757 1186 chrismessina       0 0 3 0 0   en  
1431871302864752640 swyx 33521530 2021-08-29T06:48:16+00:00 @jhooks @dabit3 i meaaaaan you dont see me putting any money into NFTs, this one is all Nader haha       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [16, 98] 1431869427667009536 12087242 jhooks       0 0 8 0 0   en  
1431884181982695435 swyx 33521530 2021-08-29T07:39:26+00:00 was browsing through the CAST handbook (http://psas.scripts.mit.edu/home/get_file4.php?name=CAST_handbook.pdf) and found this note on "Root Cause Seduction". The proposed alternative model to RCAs is something called STAMP. https://twitter.com/swyx/status/1431884181982695435/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 179] 1340833140470779906 33521530 swyx       0 1 3 0 0 0 en  
1431889441447022593 swyx 33521530 2021-08-29T08:00:20+00:00 nice breakdown of Packy so far here from @jakesing_ https://theflywheel.substack.com/p/not-boring-packy-m incidentally this is inspiring me toward taking editorial newsletters far, far more seriously than I have been doing.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 195] 1431486611296964611 33521530 swyx       0 0 9 0 0 0 en  
1432042759901245443 swyx 33521530 2021-08-29T18:09:34+00:00 “Faced with the choice between changing one’s mind and proving that there is no need to do so, almost everyone gets busy on the proof.” — John Kenneth Galbraith       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 161]             0 0 19 0 0   en  
1432046947888553987 swyx 33521530 2021-08-29T18:26:13+00:00 @KodiDriver Yes! I did an episode on Cialdini's Consistency principle last week: https://swyx.transistor.fm/episodes/commitment-and-consistency-robert-cialdini       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [12, 104] 1432044865911656449 366700914 KodiDriver       0 0 1 0 0 0 en  
1432060194696019970 swyx 33521530 2021-08-29T19:18:51+00:00 @paul_griffiths @beondeck for those who want context - no snitch tagging! https://twitter.com/swyx/status/1432060194696019970/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [26, 74] 1431763937171853312 11037862 paul_griffiths       0 0 1 0 0 0 en  
1432107933026848772 swyx 33521530 2021-08-29T22:28:33+00:00 @izs im here for the Frozen disses but somehow i feel strangely protective of Moana.. pls justify!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [5, 98] 1432023612467208199 8038312 izs       0 0 0 0 0   en  
1432108101440733184 swyx 33521530 2021-08-29T22:29:13+00:00 DevOps theory: We wanted Devs to do more Ops We got Ops being forced into Dev       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 79]             0 6 101 0 0   en  
1432122467707805700 swyx 33521530 2021-08-29T23:26:18+00:00 Preview of next blogpost: The Self-Provisioning Runtime! Sending out to subscribers tonight: https://swyx.io/subscribe Looking forward to your comments! https://twitter.com/swyx/status/1432122467707805700/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 152]             0 1 23 0 0 0 en  
1432127335445135366 swyx 33521530 2021-08-29T23:45:39+00:00 I think I have the solution https://twitter.com/swyx/status/1432122467707805700   1432122467707805700 1432122467707805700   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 51] 1432108101440733184 33521530 swyx       1 0 11 0 0 0 en  
1432127667772420097 swyx 33521530 2021-08-29T23:46:58+00:00 @KhromeDotDev no, just more detailed!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [14, 37] 1432123837857030146 14223187 KhromeDotDev       0 0 3 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]);