tweets

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

18 rows where "created_at" is on date 2021-09-03 and is_quote_status = 0 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user, in_reply_to_screen_name, retweet_count, favorite_count, lang

retweeted 2 ✖

  • 0 17
  • 1 1

is_quote_status 1 ✖

created_at (date) 1 ✖

  • 2021-09-03 · 18 ✖
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
1433595892557225984 jonwu.eth 15809138 2021-09-03T01:01:10+00:00 I was stunned. 1st reaction: "Me?? A newly minted business school graduate? To functionally be CFO?" 2nd reaction: "But...why not me? I can save this company." 3rd reaction: "Holy fuck this person is a sociopath." 4th reaction: "...I want her powers."       Typefully 295366d0fb34352a1961af2413827f072adefdb9 0 [0, 255] 1433595891256991745 15809138 jonwu_       0 72 1614 0 1   en  
1433616749694373893 swyx 33521530 2021-09-03T02:24:03+00:00 @buildsghost petition to use 👆 as topic variable       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [13, 48] 1433487820132270081 1175464650395111424 buildsghost       0 0 21 0 0   en  
1433623144212828185 swyx 33521530 2021-09-03T02:49:27+00:00 @gkoberger @daniel_levine @CockroachDB @dbcicero i'd love to! didn't get very far in my initial exploration of Clickhouse. @dbcicero if you're up for it you can DM me! (i cant DM you) or email swyx @ temporal . io       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [49, 213] 1433280217485774848 14591604 gkoberger       0 0 1 0 0   en  
1433631625301028866 swyx 33521530 2021-09-03T03:23:09+00:00 Today's clip: looking into @vitessio and sharing my discover of @MYonkovit's excellently named HOSS talks FOSS podcast! https://share.transistor.fm/s/74707fd2       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 144] 1433277854406438913 33521530 swyx       0 1 2 0 0 0 en  
1433717372339179521 swyx 33521530 2021-09-03T09:03:53+00:00 @cassiecodes awww congrats!! everyone looks so happy!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [13, 53] 1433709515497689113 758598429115310080 cassiecodes       0 0 1 0 0   en  
1433717538165198852 swyx 33521530 2021-09-03T09:04:32+00:00 @ryanchenkie looking a great 35 my dude. we’re the same age! happy birthday!!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [13, 77] 1433435987443601408 30654945 ryanchenkie       0 0 2 0 0   en  
1433807042590875654 Peter Yang 84490044 2021-09-03T15:00:12+00:00 You look more into this space and realize it's the opposite of your job. There are no OKRs, no metrics, no career ladders, not even that many PMs. People are just building stuff because they're passionate about it.       Typefully 295366d0fb34352a1961af2413827f072adefdb9 0 [0, 216] 1433807041403916296 84490044 petergyang       0 27 431 0 0   en  
1433823619671633923 podrocketpod 1372248310904455178 2021-09-03T16:06:04+00:00 In this episode, @RyanCarniato tells us all about @solid_js, a declarative, efficient, and flexible JavaScript library for building user interfaces. Listen here https://podrocket.logrocket.com/solidjs #podcast #javascript #webdevelopment #tech https://twitter.com/PodRocketpod/status/1433823619671633923/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 228]             0 16 44 0 0 0 en  
1433835933736919049 swyx 33521530 2021-09-03T16:55:00+00:00 @photon_garden @b0rk i do! i really enjoyed her post on this last year as well! https://jvns.ca/blog/2020/12/05/how-i-write-useful-programming-comics/       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [21, 103] 1433833142109016064 185437205 photon_garden       0 0 1 0 0 0 en  
1433837480449613839 Internal Tech Emails 1396491776739905542 2021-09-03T17:01:09+00:00 Larry Page: "I think we should look into acquiring [YouTube]" November 8, 2005 https://twitter.com/TechEmails/status/1433837480449613839/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 79]             0 1119 7175 0 0 0 en  
1433840748588195841 swyx 33521530 2021-09-03T17:14:08+00:00 @NHeinDev @AngelaRiggs_ seconded. @freeCodeCamp let me dip my toe in the water before deciding on my career change. https://medium.com/hackernoon/no-zero-days-my-path-from-code-newbie-to-full-stack-developer-in-12-months-214122a8948f       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [24, 140] 1433840277505052675 1333059155154907138 NHeinDev       0 0 3 0 0 0 en  
1433875979852652545 swyx 33521530 2021-09-03T19:34:08+00:00 @forrestbrazeal oh. my. god. https://twitter.com/swyx/status/1433875979852652545/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [16, 30] 1433873790564454401 3239330680 forrestbrazeal       0 0 5 0 0 0 en  
1433881895796756481 swyx 33521530 2021-09-03T19:57:38+00:00 @Swizec @forrestbrazeal yes exactly       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [24, 35] 1433879235374899201 15353121 Swizec       0 0 0 0 0   en  
1433910190466736134 swyx 33521530 2021-09-03T21:50:04+00:00 I gotta hand it to Aldo Bucchi (not on Twitter) for leaving the best blogpost comment I've had all year 🙇‍♂️ https://dev.to/aldonline/comment/1hln8 Even if its an exaggeration (it probably is?) it captured my attention and left me no choice but to check out his product 👏 https://twitter.com/swyx/status/1433910190466736134/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 258]             0 2 24 0 0 0 en  
1433915176776962050 swyx 33521530 2021-09-03T22:09:53+00:00 @jpsimons DOM has 30 year head start. what evidence of trend are you thinking of? 4 isolated examples? a google flutter demo?       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [10, 125] 1433913908989874179 32165130 jpsimons       0 0 5 0 0   en  
1433919649075240962 swyx 33521530 2021-09-03T22:27:39+00:00 @seldo reading this in Werner Herzog voice       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [7, 42] 1433824330899607552 15453 seldo       0 0 12 0 0   en  
1433939106459885570 swyx 33521530 2021-09-03T23:44:58+00:00 Self Provisioning Runtimes are the “Level 5 Self Driving Cars” of developer platforms.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 86] 1432864050895994890 33521530 swyx       0 0 4 0 0   en  
1433682486106542088 swyx 33521530 2021-09-03T06:45:15+00:00 我吃的盐比你吃的饭还要多😱🤯 You could tell who spoke Chinese by the audible gasps in the room. Tony Leung owned every goddamn second he was onscreen in #shangchi https://twitter.com/swyx/status/1433682486106542088/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 149]             0 0 14 0 0 0 zh  

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]);