home / twitter

tweets

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

15 rows where in_reply_to_screen_name = "fortelabs" sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: is_quote_status, favorite_count

created_at (date) 11 ✖

  • 2021-11-23 5
  • 2021-07-31 1
  • 2021-08-08 1
  • 2021-08-17 1
  • 2021-08-19 1
  • 2021-08-26 1
  • 2021-09-02 1
  • 2021-09-05 1
  • 2021-09-29 1
  • 2021-11-30 1
  • 2021-12-07 1

source 2 ✖

  • Twitter Web App 8
  • Twitter for iPhone 7

in_reply_to_screen_name 1 ✖

  • fortelabs · 15 ✖
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
1421276174764843008 swyx 33521530 2021-07-31T01:07:00+00:00 @fortelabs Simon Sinek taught me to start WITH why       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [11, 50] 1421275014217691138 1909232666 fortelabs       0 0 70 0 0   en  
1424180666250395649 swyx 33521530 2021-08-08T01:28:25+00:00 @fortelabs IT'S TIME TO BASB       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [11, 28] 1424168537053007873 1909232666 fortelabs       0 0 1 0 0   en  
1427640343034482704 swyx 33521530 2021-08-17T14:35:56+00:00 @fortelabs i thought this might have been a Succession parody       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [11, 61] 1427357032609304587 1909232666 fortelabs       0 0 7 0 0   en  
1428398804932259852 swyx 33521530 2021-08-19T16:49:48+00:00 @fortelabs checks out (chinese names often work best in groups of 4, i might market test 打造二脑 to see how people react. 打造外脑 might be more self evident at the cost of compromising "Second" for "External") https://twitter.com/swyx/status/1428398804932259852/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [11, 204] 1428397878154698752 1909232666 fortelabs       0 0 2 0 0 0 en  
1431041197179510784 swyx 33521530 2021-08-26T23:49:43+00:00 @fortelabs hard to do this KNOWING you open yourself up to criticism that you are just recycling preexisting ideas. but you’ll be laughing all the way to the bank and they’ll stew in their salty superiority complex       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [11, 214] 1430908796948279300 1909232666 fortelabs       0 0 1 0 0   en  
1433330202612879367 swyx 33521530 2021-09-02T07:25:24+00:00 @fortelabs “unproductivity guru” has a nice ring to it?       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [11, 55] 1433289263202783234 1909232666 fortelabs       0 0 4 0 0   en  
1434533320554131462 swyx 33521530 2021-09-05T15:06:10+00:00 @fortelabs TED main stage - positive “TEDx speaker” in bio - ok buddy keep going Casually omitting the “x” to make themselves sound important - unforgivable, banish to nether realms       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [11, 183] 1434532211634499592 1909232666 fortelabs       0 0 26 0 0   en  
1443051720104316934 swyx 33521530 2021-09-29T03:15:15+00:00 @fortelabs you managed to squeeze a book into that subtitle huh that said, the pple following you here are likely to buy your book or just know your deal already; you may want to discount our opinions to reach the really mass market who dont know you from adam.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [11, 262] 1442970778157281282 1909232666 fortelabs       0 0 7 0 0   en  
1463030661254561793 swyx 33521530 2021-11-23T06:24:26+00:00 @fortelabs used http://lu.ma as well for the recent #SvelteSummit NYC event https://twitter.com/swyx/status/1462323377553694722?s=21   1462323377553694722 1462323377553694722   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [11, 110] 1462992587246030855 1909232666 fortelabs       1 0 1 0 0 0 en  
1463032809094725635 swyx 33521530 2021-11-23T06:32:58+00:00 @fortelabs yep. i run my company meetups and workshops on it too. considered investing but didnt really see the vision beyond “eventbrite that doesnt suck”       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [11, 155] 1463031322276859904 1909232666 fortelabs       0 0 1 0 0   en  
1463228475926401024 swyx 33521530 2021-11-23T19:30:28+00:00 @fortelabs not at all, what gives you that impression       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [11, 53] 1463033004557692930 1909232666 fortelabs       0 0 0 0 0   en  
1463246126509801475 swyx 33521530 2021-11-23T20:40:37+00:00 @fortelabs email is enough, no confirm needed unless the organizer opts for it. here, sign up for my company's workshop next week and experience it yourself https://lu.ma/temporalintro it sends a thing straight to your calendar, its perfect       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [11, 238] 1463242691311857664 1909232666 fortelabs       0 0 0 0 0 0 en  
1463249154809819140 swyx 33521530 2021-11-23T20:52:39+00:00 @fortelabs yup you can email everyone who joined at any time https://lu.ma/sveltenyc https://twitter.com/swyx/status/1463249154809819140/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [11, 85] 1463247759448834048 1909232666 fortelabs       0 0 1 0 0 0 en  
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  
1468157881962745856 swyx 33521530 2021-12-07T09:58:10+00:00 @fortelabs @PostScanMail this tweet helped me decide on postscanmail. thanks!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [25, 77] 1346838271666503680 1909232666 fortelabs       0 0 2 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]);
Powered by Datasette · Queries took 747.57ms