tweets
22 rows where display_text_range = "[0, 140]" and retweet_count = 1
This data as json, CSV (advanced)
Suggested facets: source, is_quote_status, favorited
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1421693412441395205 | swyx 33521530 | 2021-08-01T04:44:57+00:00 | RT @radenagus17_: “It is always going to be a truth that the more you know, the more you also learn about that stuff that you didn’t know t… | 1421686377670856704 1421686377670856704 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 1 | 0 | 0 | 1 | en | ||||||||||
| 1421981745625276419 | swyx 33521530 | 2021-08-01T23:50:41+00:00 | RT @jsjoeio: 🎙️ jsjoeio's mixtape Alright, trying out this podcast/mixtape thing as a hobby and an excuse to meet cool people. First segm… | 1421968022814658561 1421968022814658561 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 1 | 0 | 0 | 1 | en | ||||||||||
| 1427393308997783602 | swyx 33521530 | 2021-08-16T22:14:19+00:00 | RT @andyhattemer: Lots of great info in this post! @swyx categorizes devrel programs into "Community", "Content" and "Product". For me, he… | 1427370301495652354 1427370301495652354 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 1 | 1 | 0 | 0 | 1 | en | ||||||||||
| 1429727373503524864 | swyx 33521530 | 2021-08-23T08:49:03+00:00 | RT @CookieDuster_N: Another awesome read from @swyx https://www.swyx.io/measuring-devrel/ Best bit: Traditional marketing advice says people have to hea… | 1429725966335713281 1429725966335713281 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 1 | 0 | 0 | 1 | 0 | en | |||||||||
| 1440745728595271684 | swyx 33521530 | 2021-09-22T18:32:04+00:00 | RT @lucasbernalte: I just read about the Four Gears of Learning in Public by @swyx and it clicked. I have only been trying to use the Conne… | 1440741221236764674 1440741221236764674 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 1 | 0 | 0 | 1 | en | ||||||||||
| 1441070950208913413 | swyx 33521530 | 2021-09-23T16:04:22+00:00 | RT @ReactAdvanced: He's the head of #developer experience, author of a bestselling book on progressing career in IT, and a sought-after men… | 1441069852127543299 1441069852127543299 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 1 | 0 | 0 | 1 | en | ||||||||||
| 1443977557859180548 | swyx 33521530 | 2021-10-01T16:34:12+00:00 | RT @CascadiaJS: Announcing the second of 3 lightning ⚡️ talks for the official #CascadiaJS pre-conference meetup on Oct 14! Temporal: Reac… | 1443976506858823683 1443976506858823683 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 1 | 0 | 0 | 1 | en | ||||||||||
| 1449105641797128192 | swyx 33521530 | 2021-10-15T20:11:22+00:00 | RT @ChibuzorObilom: I've always believed that the 80/20 rule is grossly misunderstood or misrepresented. There's nothing like doing only 2… | 1449103297839763459 1449103297839763459 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 1 | 1 | 0 | 0 | 1 | en | ||||||||||
| 1449117060265492481 | swyx 33521530 | 2021-10-15T20:56:45+00:00 | RT @threepointone: Really good talk. This is a great slide demonstrating their programming model; to do a recurring subscription, you liter… | 1449112317917110276 1449112317917110276 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 1 | 1 | 0 | 0 | 1 | en | ||||||||||
| 1451089293565325315 | swyx 33521530 | 2021-10-21T07:33:42+00:00 | RT @IrevDev: Trust @swyx to have incredible "birds eye view" insights of the industry. I'm a little late, but this is really great talk: h… | 1451086357732855810 1451086357732855810 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 1 | 0 | 1 | 1 | en | ||||||||||
| 1451289107863269394 | swyx 33521530 | 2021-10-21T20:47:41+00:00 | RT @thenewstack: What It Takes to Become a Senior Engineer https://bit.ly/3pplucR @bcamerongain @darrylktaft @Swizec @swyx #SeniorEngineer | 1451276860172738563 1451276860172738563 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 1 | 0 | 1 | 1 | 0 | en | |||||||||
| 1456089620051939330 | swyx 33521530 | 2021-11-04T02:43:12+00:00 | RT @josephflaherty: Love the craft displayed on this page. Who cares about scroll bar aesthetics in 2021? @swyx does and it is glorious. ht… | 1456078047501852680 1456078047501852680 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 1 | 0 | 1 | 1 | en | ||||||||||
| 1456388798019878931 | swyx 33521530 | 2021-11-04T22:32:02+00:00 | RT @Coding_Career: Poll: Is it a good idea to look at open source contributions when hiring? No "it depends" - there's always pros and con… | 1456368848634986508 1456368848634986508 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 1 | 0 | 1 | 1 | en | ||||||||||
| 1457028453333491715 | swyx 33521530 | 2021-11-06T16:53:48+00:00 | RT @httpJunkie: Another great podcast with @swyx on @GatsbyJS with Abhi Ayer and Ward Peeters! Love the long form format! https://t.co/De4… | 1457020940345229314 1457020940345229314 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 1 | 0 | 1 | 1 | en | ||||||||||
| 1459285436816261121 | swyx 33521530 | 2021-11-12T22:22:15+00:00 | RT @zaiste: Tomorrow (Nov 13) at 11am PT / 8pm CET together with @swyx we will be discussing React Server Components in Next.js 12 (a featu… | 1459274455583281160 1459274455583281160 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 1 | 0 | 1 | 1 | en | ||||||||||
| 1462854647891197954 | swyx 33521530 | 2021-11-22T18:45:01+00:00 | RT @ronvoluted: "Productivity through Product Focus" by Reddit's @volanStudio is about to begin! Tune in: https://youtube.com/watch?v=0g0BQex8fyo and joi… | 1462840959427772418 1462840959427772418 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 1 | 1 | 0 | 1 | 1 | 0 | en | |||||||||
| 1465145505055313924 | swyx 33521530 | 2021-11-29T02:28:04+00:00 | RT @geoffrich_: .@swyx's tips on precording talks were also very helpful! As was the speaker prep session he hosted for Svelte Summit speak… | 1465117279339696136 1465117279339696136 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 1 | 0 | 1 | 1 | en | ||||||||||
| 1465444016179146752 | swyx 33521530 | 2021-11-29T22:14:14+00:00 | RT @CommonRoomHQ: It's time! Welcome to the 13 Days of Community, a two-week adventure celebrating our favorite content covering growth, en… | 1465442383294652420 1465442383294652420 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 1 | 0 | 1 | 1 | en | ||||||||||
| 1466984868319928325 | swyx 33521530 | 2021-12-04T04:17:02+00:00 | RT @turborepo: We think these kinds of packages are only getting more and more popular as we continue toward the next generation of JS buil… | 1466091140868886536 1466091140868886536 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 1 | 0 | 1 | 1 | en | ||||||||||
| 1468710357472452608 | swyx 33521530 | 2021-12-08T22:33:31+00:00 | RT @rblalock: Quote of the day goes to @swyx : "You can learn a lot on the internet for the low low price of your ego" 🔥 https://t.co/jZXKx… | 1468703734062624773 1468703734062624773 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 1 | 0 | 1 | 1 | en | ||||||||||
| 1469727766308286473 | swyx 33521530 | 2021-12-11T17:56:20+00:00 | RT @rahulnpadalkar: Was searching for videos that explain React Hooks. Came across @swyx 's "Getting Closure on React Hooks", from @jsconfa… | 1469677279315959810 1469677279315959810 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 1 | 0 | 1 | 1 | en | ||||||||||
| 1470900644055711747 | swyx 33521530 | 2021-12-14T23:36:56+00:00 | RT @beyang: The amazing thing about @swyx is he got into programming not too long ago after making a big career pivot from finance. It's aw… | 1470874194283884545 1470874194283884545 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 1 | 1 | 0 | 1 | 1 | en |
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]);