tweets
24 rows where "created_at" is on date 2021-09-03 sorted by lang
This data as json, CSV (advanced)
Suggested facets: user, display_text_range, in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, retweet_count, favorite_count, retweeted, lang
| 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 | |||||||
| 1433716826660167680 | swyx 33521530 | 2021-09-03T09:01:43+00:00 | Aug 2021: 126k views, 28k uniques Exactly one hit post on Measuring DevRel: https://mobile.twitter.com/swyx/status/1427351638872772633 The world seems to want me to write more about DevRel, which I struggle with bc I'm not thaat much of an expert and I have mixed feelings about the career path. Tweets way down. https://twitter.com/swyx/status/1433716826660167680/photo/1 | 1427351638872772633 1427351638872772633 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 1422264774327300097 | 33521530 | swyx | 1 | 0 | 3 | 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 | ||||||||
| 1433718525420470279 | swyx 33521530 | 2021-09-03T09:08:28+00:00 | If you work in Silicon Valley, or in the technology world, and you can explain complex topics / terms in an easy to understand* way, that’s an INSANELY valuable skill. *But don’t gloss over the details! All the good stuff is in the details - develop a keen eye for those! https://twitter.com/BullandBaird/status/1433424538025349120 | 1433424538025349120 1433424538025349120 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 272] | 1 | 2 | 30 | 0 | 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 | ||||||||
| 1433822284435705862 | swyx 33521530 | 2021-09-03T16:00:46+00:00 | @BenAPatton @SvelteSociety @sveltejs yes! all the above https://twitter.com/swyx/status/1221586490674696193 | 1221586490674696193 1221586490674696193 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [37, 55] | 1433792422044110851 | 999866712739676160 | BenAPatton | 1 | 0 | 8 | 0 | 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 | |||||||
| 1433880742682112001 | David Pullara 16657019 | 2021-09-03T19:53:03+00:00 | Let me get this straight... @jhuber had the GENIUS idea to buy @YouTube, debated internally for a bit, got pushback... ... and then instead of giving up, says, "F*ck it" and forwards the email thread to Page with his reco. And Page agrees in minutes! If true, that's #epic. https://twitter.com/TechEmails/status/1433837480449613839 | 1433837480449613839 1433837480449613839 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 279] | 1 | 12 | 90 | 0 | 1 | 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 | ||||||||
| 1433918146348343297 | swyx 33521530 | 2021-09-03T22:21:41+00:00 | I think why I struggle with OKRs so much: Suits set them as a system of external control, a way to manage by spreadsheet rather than get hands dirty, defining quality as quantity, when the best work of knowledge workers and creatives comes from doing epic shit for the sake of it. https://twitter.com/petergyang/status/1433807042590875654 | 1433807042590875654 1433807042590875654 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 280] | 1 | 1 | 30 | 0 | 0 | 0 | en | |||||||||
| 1433919002355507201 | swyx 33521530 | 2021-09-03T22:25:05+00:00 | casual reminder that extrinsic motivation isn’t harmless, nice to have, or ignorable. They *actively destroy* intrinsic drive. https://twitter.com/swyx/status/968688836468453376?s=21 | 968688836468453376 968688836468453376 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 151] | 1433918146348343297 | 33521530 | swyx | 1 | 0 | 15 | 0 | 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
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]);