tweets

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

13 rows where "created_at" is on date 2021-09-09, is_quote_status = 0 and possibly_sensitive = 0

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user, source, in_reply_to_user_id, in_reply_to_screen_name, retweet_count, retweeted, 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
1435768792395681796 swyx 33521530 2021-09-09T00:55:30+00:00 @DannPetty @designfulltime hey Dann idk if this is still in the 24 hour limit — i assume it has expired — but down here it still says $179! https://twitter.com/swyx/status/1435768792395681796/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [27, 139] 1435377045404635138 22708585 DannPetty       0 0 3 0 0 0 en  
1435793597870321674 swyx 33521530 2021-09-09T02:34:04+00:00 Today' clip: React Native's Near Death Experience, according to @Vjeux! https://share.transistor.fm/s/ee467824 I was surprised to learn on the @sourcegraph podcast that the initial impl of Facebook Photos with RN flopped! Sometimes entire industries pivot by the decisions of a few key people.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 280] 1435387866079694849 33521530 swyx       0 1 7 0 0 0 en  
1435801431978635267 swyx 33521530 2021-09-09T03:05:11+00:00 1/ I'm excited to announce a new learning experience I’m launching today with @chapter_HQ. My 4 week long “chapter” includes curated content, in-depth discussion and private Q&A for your own #LearnInPublic journey! https://getchapter.app/@swyx/learn       Typefully 295366d0fb34352a1961af2413827f072adefdb9 0 [0, 243]             0 12 72 0 0 0 en  
1435801439331241987 swyx 33521530 2021-09-09T03:05:13+00:00 3/ I’ve handpicked 4 weeks of content, and you can expect about 90 mins/week in total. The interactions are asynchronous, which allows me to answer more of your questions. I’d love for you to join me! https://twitter.com/swyx/status/1435801439331241987/photo/1       Typefully 295366d0fb34352a1961af2413827f072adefdb9 0 [0, 200] 1435801433253695491 33521530 swyx       0 0 5 0 0 0 en  
1435801442145554443 swyx 33521530 2021-09-09T03:05:14+00:00 5/ If you like the work I do, I’d appreciate a retweet of this thread. Again, here is the invite link to register: https://getchapter.app/@swyx/learn Looking forward to seeing you in my chapter!       Typefully 295366d0fb34352a1961af2413827f072adefdb9 0 [0, 185] 1435801440929427456 33521530 swyx       0 1 4 0 0 0 en  
1435934910125158407 swyx 33521530 2021-09-09T11:55:35+00:00 gm https://twitter.com/swyx/status/1435934910125158407/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 2]             0 0 151 0 0 0 und  
1435971765000417281 swyx 33521530 2021-09-09T14:22:02+00:00 @livelovegeek @gurlcode doesnt get enough love for the sheer amount of storytelling work that goes into her talks https://youtu.be/U_ABIfnsVU4       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [14, 137] 1435725632319606786 119275747 livelovegeek       0 0 13 0 0 0 en  
1435995667516821505 Dan Ciupuliga 12036572 2021-09-09T15:57:01+00:00 Highly recommend this course by @swyx (@eggheadio) on building a CLI with the Open CLI framework. I was able to POC a quick cli for our design system just while taking the course. https://egghead.io/courses/build-custom-command-line-interface-cli-tooling-with-oclif-and-typescript       TweetDeck 9335de48b3673c3f69433a34861c115d1d382be3 0 [0, 204]             0 2 10 0 1 0 en  
1436002996660363267 devtools.fm 1389094644328271872 2021-09-09T16:26:08+00:00 How do you view software? @swyx approaches tools with a "Would I Invest in this thing" mindset! https://twitter.com/DevtoolsFM/status/1436002996660363267/video/1       LaterMedia e5057be9f0fb05c9d0d7206d7e0b388a4067eb68 0 [0, 95]             0 2 17 0 1 0 en  
1436008517845008388 swyx 33521530 2021-09-09T16:48:05+00:00 RT @DevtoolsFM: How do you view software? @swyx approaches tools with a "Would I Invest in this thing" mindset! https://twitter.com/DevtoolsFM/status/1436002996660363267/video/1 1436002996660363267 1436002996660363267     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 135]             0 2 0 0 1 0 en  
1436011709865603075 TechCrunch 816653 2021-09-09T17:00:46+00:00 Open source backend-as-a-service startup Supabase raises $30M https://tcrn.ch/2YLJkEJ by @grg       SocialFlow 99073d76dd39fa0b448b0d78765cf615980271d1 0 [0, 93]             0 96 529 0 0 0 en  
1436028541498368017 Jason Laster 312750384 2021-09-09T18:07:39+00:00 Oh snap! @replayio is launching next Wednesday 🚀 https://twitter.com/jasonlaster11/status/1436028541498368017/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 48]             0 20 120 0 1 0 en  
1436104144801067033 Couch Nish 1012721484412801024 2021-09-09T23:08:04+00:00 A person called OwlKitty changed the Business Card scene from “American Psycho” to the guys showing each other pictures of their cats on their phones… and it could possibly be the greatest masterpiece ever 😂 https://twitter.com/CouchNish/status/1436104144801067033/video/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 207]             0 49409 153007 0 1 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]);