tweets

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

14 rows where "created_at" is on date 2021-08-26, retweeted = 0 and user = 33521530

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source, in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, retweet_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
1430729864743579651 swyx 33521530 2021-08-26T03:12:36+00:00 @jcreamer898 @commandodev @kylewelch they are going to have trouble with @amandaksilver’s DevDiv at Microsoft!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [37, 110] 1430666275768999938 52417305 jcreamer898       0 0 3 0 0   en  
1430735259486748676 swyx 33521530 2021-08-26T03:34:02+00:00 @ForbesLindesay thats AMAZING. what kind of access points are we talking here, like the wall ports? did you just buy them off amazon and replace em yourself?       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [16, 157] 1430686968522985473 65652445 ForbesLindesay       0 0 0 0 0   en  
1430781576842027008 swyx 33521530 2021-08-26T06:38:05+00:00 @supabase https://twitter.com/swyx/status/1430781576842027008/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [9, 9] 1430779307803226113 1219566488325017602 supabase       0 1 54 0 0 0 und  
1430788664439701505 swyx 33521530 2021-08-26T07:06:15+00:00 @czue yeah you’re right on the 2FA. however i do see passwordless implementations just leak the login code in the email which pops up even on locked screens, which presumably password managers are immune to       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [6, 206] 1430786719335469056 19680386 czue       0 0 1 0 0   en  
1430946768577990656 swyx 33521530 2021-08-26T17:34:29+00:00 @QuinnyPig @StackOverflow omg the Azure avatar won       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [26, 50] 1430934767118131200 97114171 QuinnyPig       0 0 4 0 0   en  
1430949616371961862 swyx 33521530 2021-08-26T17:45:48+00:00 i often hear that indie hackers have little to learn from working at bigco or venture track startups. The resource limitations, interpersonal management, product timeline, and transparency lessons are at minimum irrelevant, at worst totally inverse! this is the norm, but       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 274]             0 0 14 0 0   en  
1430949617928048646 swyx 33521530 2021-08-26T17:45:49+00:00 There are exceptions to every rule, a synthesis to be drawn from every dialectic. I think founders who can blend the strategy of scale and the tactics of scrappiness do very well. People like @callmevlad, @agazdecki, the @supabase team, everyone in the @tylertringas portfolio.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 279] 1430949616371961862 33521530 swyx       0 0 15 0 0   en  
1430991697513619456 swyx 33521530 2021-08-26T20:33:01+00:00 apparently access points are a big bottleneck too! https://twitter.com/ForbesLindesay/status/1430989747829284865?s=20   1430989747829284865 1430989747829284865   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 74] 1428861510164520960 33521530 swyx       1 0 0 0 0 0 en  
1431000287884439555 swyx 33521530 2021-08-26T21:07:09+00:00 @bcomnes you and your beloved windows smh       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [9, 41] 1430997015434076163 2149850018 bcomnes       0 0 0 0 0   en  
1431029754652553216 swyx 33521530 2021-08-26T23:04:15+00:00 @jonasby character limits!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [9, 26] 1430997315880378370 19073529 jonasby       0 0 1 0 0   en  
1431039186799263744 swyx 33521530 2021-08-26T23:41:44+00:00 @ken_wheeler @AdamRackis that’s basically her entire job description in Ken’s stories       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [25, 85] 1430986611039346688 167193309 ken_wheeler       0 0 6 0 0   en  
1431040477483061249 swyx 33521530 2021-08-26T23:46:51+00:00 @chriscoyier happy birthday Chris!!! 🎉       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [13, 38] 1431008275630379010 793830 chriscoyier       0 0 1 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  
1431043718052818950 swyx 33521530 2021-08-26T23:59:44+00:00 @drikerf Nice       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [9, 13] 1430824981269712897 1227758149 drikerf       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]);