tweets

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

17 rows where "created_at" is on date 2021-11-30, retweet_count = 0 and source = "1f89d6a41b1505a3071169f8d0d028ba9ad6f952"

✎ 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, 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
1465489233620058112 swyx 33521530 2021-11-30T01:13:55+00:00 @fortelabs just as long as you never see his mouth you're good https://twitter.com/swyx/status/1465489233620058112/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [11, 62] 1465487179791028225 1909232666 fortelabs       0 0 8 0 0 0 en  
1465491518496464905 swyx 33521530 2021-11-30T01:23:00+00:00 @ASpittel break a leg Ali!!!!! go @AWSAmplify!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [10, 46] 1465489421910745095 3092104835 ASpittel       0 0 3 0 0   en  
1465492498977939459 swyx 33521530 2021-11-30T01:26:53+00:00 @LucasMinter2 hey Lucas! if youre just getting your first job, focus on the first part. the rest can come later when you've started work. Getting that job is a lot more mechanical and i describe the various elements I paid attention to during my own job search process. good luck!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [14, 280] 1465491610519543810 1215752268160499712 LucasMinter2       0 0 1 0 0   en  
1465500077426835463 swyx 33521530 2021-11-30T01:57:00+00:00 @baggerholder1 -60% :sus: https://twitter.com/swyx/status/1465500077426835463/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [15, 25] 1402152638087536653 1391625634611224578 baggerholder1       0 0 0 0 0 0 und  
1465524682376069129 Hassan El Mghari 3246815913 2021-11-30T03:34:47+00:00 @swyx I honestly think the highest ROI thing I ever did on Twitter was following you a year and a half ago       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [6, 106] 1465524651719897089 3246815913 Nutlope       0 0 8 0 0   en  
1465526012767203331 swyx 33521530 2021-11-30T03:40:04+00:00 new pinned tweet https://twitter.com/Nutlope/status/1465524682376069129   1465524682376069129 1465524682376069129   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 16]             1 0 26 0 0 0 en  
1465526450119856133 swyx 33521530 2021-11-30T03:41:48+00:00 @umachingunde @dan_abramov the question assumes that my library has tests 😈       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [27, 75] 1465525155158011915 938901720016363520 umachingunde       0 0 31 0 0   en  
1465526977666826246 swyx 33521530 2021-11-30T03:43:54+00:00 @seldo @cullend fwiw i think yours are all very well deserved https://twitter.com/swyx/status/1465526977666826246/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [16, 61] 1465524733529649160 15453 seldo       0 0 3 0 0 0 en  
1465528159017725961 swyx 33521530 2021-11-30T03:48:35+00:00 @shreshthmohan product ends up very different for each of these       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [15, 63] 1465527641595789315 36378967 shreshthmohan       0 0 0 0 0   en  
1465528353025265668 swyx 33521530 2021-11-30T03:49:22+00:00 @seldo @cullend ah i am very happy to introduce you to @TwemexApp this blessed day by the inimitable @geoffreylitt       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [16, 114] 1465528076360585219 15453 seldo       0 0 3 0 0   en  
1465557935354904579 swyx 33521530 2021-11-30T05:46:55+00:00 @IGN FOUR MORE MOVIES       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [5, 21] 1465327444102205444 18927441 IGN       0 0 0 0 0   en  
1465559133214568451 swyx 33521530 2021-11-30T05:51:40+00:00 @jayacunzo @CastosHQ @UnthinkableShow so shocked/sad to hear you are moving on! 3 Clips was a delight to find and you were amazing in it. thanks for a great run and congrats on successfully handing off your podcast!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [38, 215] 1465299734378291210 112596381 jayacunzo       0 0 2 0 0   en  
1465602795734634497 swyx 33521530 2021-11-30T08:45:10+00:00 @remotion_dev Hi! I checked you out today and was very impressed by the examples, however felt a huge gap between the starting point and the end result. maybe im just bad at this but more open source examples to copy from would be helpful! not really useful to just have the video.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [14, 281] 1465229912474894340 1422895361178447878 remotion_dev       0 0 4 0 0   en  
1465604176453378055 swyx 33521530 2021-11-30T08:50:39+00:00 @AntWilson @ImnNazri @supabase Ant host meme review on supabase youtube       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [31, 71] 1465543672737398786 22399680 AntWilson       0 0 5 0 0   en  
1465611368178978817 swyx 33521530 2021-11-30T09:19:14+00:00 @sebastienlorber @remotion_dev youtube intros for work and personal, maaaaybe full tutorials, IF the coding portion is not too heavy (i am not yet convinced... i always say we should not use code tools to make code presentations, because we often end up wasting a lot of time fixing the code tools)       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [31, 298] 1465606845863706624 40663578 sebastienlorber       0 0 3 0 0   en  
1465643918268137473 swyx 33521530 2021-11-30T11:28:35+00:00 @lesley_pizza @Cloudflare dont play play k       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [26, 42] 1465638636905328641 17828291 lesley_pizza       0 0 2 0 0   en  
1465776961892978692 swyx 33521530 2021-11-30T20:17:15+00:00 @sohcfst yup! just finished       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [9, 27] 1465745926513840129 1413675741019926531 sohcfst       0 0 1 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]);