tweets

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

11 rows where "created_at" is on date 2021-09-04, lang = "en", source = "1f89d6a41b1505a3071169f8d0d028ba9ad6f952" and user = 33521530 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, retweet_count, favorite_count

display_text_range 11 ✖

source 1 ✖

  • Twitter Web App · 11 ✖

lang 1 ✖

created_at (date) 1 ✖

  • 2021-09-04 · 11 ✖
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
1434182551422210051 swyx 33521530 2021-09-04T15:52:20+00:00 @steveruizok @dabit3 @mpocock1 @loom @Yozobi doubling back to say i missed this the first time, it looks very cool!!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [45, 116] 1408480348736983042 122246321 steveruizok       0 0 1 0 0   en  
1434183926868635648 swyx 33521530 2021-09-04T15:57:48+00:00 Just got a preview of @IncredibleDevHQ from @jerriclynsjohn. If you want an integrated, collaborative platform for dev video content, hit him up for a demo! Related tools in dev/video space: @loom, @TellaHQ, @mmhmmapp, @replayio, @usebubbles, @GetShareX, @birdeatsbug, @iterspace https://twitter.com/swyx/status/1434183926868635648/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 280]             0 6 26 0 0 0 en  
1434206569881694210 swyx 33521530 2021-09-04T17:27:47+00:00 New: The Swipe Files Strategy for Part Time Creators https://www.swyx.io/swipe-files-strategy/ What if I told you there was a simple strategy that can help you slow-cook a $300,000 a year side project and kickstart your @IndieHackers career, on a few hours a week? Build a Swipe File.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 269]             0 2 62 0 0 0 en  
1434206572608049156 swyx 33521530 2021-09-04T17:27:47+00:00 A "swipe file" is a collection of examples for inspiration. These screenshots are all real life examples of how Part Time Creators can build a newsletter, build a brand, and get good at their craft, without reputation, expertise, or large upfront expenditure in time or money. https://twitter.com/swyx/status/1434206572608049156/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 276] 1434206569881694210 33521530 swyx       0 0 7 0 0 0 en  
1434206574055022592 swyx 33521530 2021-09-04T17:27:48+00:00 The Strategy: 1. Start a Swipe File 2. Collect examples 3. Offer newsletter signup 4. Offer login + faving 5. Build a Community 6. Hit the Media Circuit 7. Make Generators 8: Monetize - Ads - Workshop - Book - Course https://youtu.be/2r7fSeMCcK8       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 258] 1434206572608049156 33521530 swyx       0 1 9 0 0 0 en  
1434234495708774400 swyx 33521530 2021-09-04T19:18:45+00:00 @drikerf @IndieHackers of course i had to!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [23, 42] 1434222996705759233 1227758149 drikerf       0 0 1 0 0   en  
1434237502982815745 swyx 33521530 2021-09-04T19:30:42+00:00 Update: if you want to try self-provisioning runtimes, these are the top 3 so far: - http://Serverless.com/cloud contact @jeremy_daly and @dougmoscrop - http://CloudCompiler.run contact @AlaShiban - http://Lambdragon.com contact @aldonline All need serious design partners! https://twitter.com/swyx/status/1432864028842356736   1432864028842356736 1432864028842356736   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 275]             1 6 25 0 0 0 en  
1434248052898820100 swyx 33521530 2021-09-04T20:12:37+00:00 My Chat with @vladchers on Enterprise DevRel! https://youtu.be/9zrKMoOw5VI       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 70]             0 2 6 0 0 0 en  
1434276119839129601 swyx 33521530 2021-09-04T22:04:09+00:00 @spitleaf but also sometimes realizing that 1. you cant make everyone happy 2. making them happy makes yourself unhappy 3. that flaw you have is a strength to others 4. maybe you should double down i think anyone with compelling flaws-that-are-strengths should just be founders       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [10, 279] 1434273767749046273 357427736 spitleaf       0 0 1 0 0   en  
1434276399951618050 swyx 33521530 2021-09-04T22:05:15+00:00 @stephsmithio i dont know if this thread was intentional podcast marketing or not, or just opportunistically appended as a "see my soundcloud" plug, but either way this was brilliant 👏🏽       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [14, 185] 1434234900530425858 626691391 stephsmithio       0 0 1 0 0   en  
1434278725210841095 swyx 33521530 2021-09-04T22:14:30+00:00 Just curious: those of you who are employees — how many more employers do you think you will work for in your career? (traditional fulltime employment setup)       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 159]             0 1 23 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]);