tweets
18 rows where "created_at" is on date 2021-12-07 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20" sorted by lang
This data as json, CSV (advanced)
Suggested facets: in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, retweet_count, favorited, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1468185206628642816 | swyx 33521530 | 2021-12-07T11:46:45+00:00 | @peer_rich https://airbyte.io/connectors/google-analytics cc @AVaidyanatha gotchu fam | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [11, 62] | 1468182970750185477 | 1004742187 | peer_rich | 0 | 0 | 6 | 0 | 0 | 0 | cy | |||||||
1468106726163447809 | swyx 33521530 | 2021-12-07T06:34:54+00:00 | and then there’s a whole nother tier to this game practiced by the elite - short (33char) titles with specific numbers and “You” - incomplete thumbnail - sound pings - story: relatable situation -> clash/misunderstanding-> new chars enter -> punchline https://youtu.be/c5-3gotpgz8 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 287] | 1462659131815477252 | 33521530 | swyx | 0 | 0 | 8 | 0 | 0 | 0 | en | |||||||
1468154498761650177 | swyx 33521530 | 2021-12-07T09:44:44+00:00 | @jakobgreenfeld got a chart for this but for product hunt? | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [16, 58] | 1468143869426606081 | 1285142519525892098 | jakobgreenfeld | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1468156417248923650 | swyx 33521530 | 2021-12-07T09:52:21+00:00 | Excellent answer from @yongfook on why too many people “building an audience first” w/o making anything of substance on @IndieHackers. Like most writers, I also don’t have a problem with the audience first approach. But it’s easy to overdo the “in public” and forget the “build”. https://twitter.com/jakobgreenfeld/status/1468143869426606081 https://twitter.com/swyx/status/1468156417248923650/photo/1 | 1468143869426606081 1468143869426606081 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 304] | 1 | 6 | 35 | 0 | 0 | 0 | en | |||||||||
1468157229664591875 | swyx 33521530 | 2021-12-07T09:55:35+00:00 | @nextjs thank god how long did it take you to get this handle lmao from now on only OG nextjs users remember searching for nextjs twitter handle and coming up blank and dejectedly settling for #nextjs | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [8, 202] | 1468044361082580995 | 1467726470533754880 | nextjs | 0 | 0 | 73 | 0 | 0 | en | ||||||||
1468163148809048069 | swyx 33521530 | 2021-12-07T10:19:06+00:00 | @naz_avo @jakobgreenfeld evidently not true going by gumroad gmv probably more like ppl have caught on that shipping > talking https://twitter.com/swyx/status/1468163148809048069/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [25, 130] | 1468162122387447811 | 1335444805241896961 | naz_avo | 0 | 0 | 5 | 0 | 0 | 0 | en | |||||||
1468179322296942592 | swyx 33521530 | 2021-12-07T11:23:22+00:00 | @tmcw @reactjs could be topic for a good blogpost! havent messed around with it yet either. intrigued by the screenshots | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [15, 120] | 1467888510967459847 | 1458271 | tmcw | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1468181148971024384 | swyx 33521530 | 2021-12-07T11:30:38+00:00 | @dqmonn @peer_rich @CalcoM does business trademark + ad spend not help? | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [27, 71] | 1468179795129376769 | 3097332387 | dqmonn | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1468183578357874690 | swyx 33521530 | 2021-12-07T11:40:17+00:00 | @terribledustin @MarvelAssist @Polymail @typeform @stripe @Google @vercel first time hearing about it: - can you share some example posts on the landing page? - can you pin a “marvelassist tldr” tweet to the @MarvelAssist page? right now the bio is just marketing fluff, doesnt explain what you actually do (unsolicited so feel free to ignore) | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [74, 345] | 1467920938368966659 | 832314788487196672 | terribledustin | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1468282142048206851 | swyx 33521530 | 2021-12-07T18:11:56+00:00 | RT @jhooks: these 20 awesome courses are free for the month https://egghead.io/20-days | 1467892371480186886 1467892371480186886 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 83] | 0 | 66 | 0 | 1 | 1 | 0 | en | |||||||||
1468290789683851264 | swyx 33521530 | 2021-12-07T18:46:18+00:00 | @abadir_ @harisvsulaiman @temporalio i dont know agendajs well but yeah what he said | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [37, 84] | 1468257419956469768 | 14335431 | abadir_ | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1468339703237599233 | swyx 33521530 | 2021-12-07T22:00:40+00:00 | Replay seems to have identified the biggest opportunity to improve the state of browser devtools and is just going for it. If you ever had feature requests for any tab in your dev tools, join their discord (https://discord.gg/F5a4kvb6wu) and chat with their engineers! https://twitter.com/jasonlaster11/status/1468330375881510916 | 1468330375881510916 1468330375881510916 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 263] | 1 | 1 | 16 | 0 | 0 | 0 | en | |||||||||
1468340554534567941 | swyx 33521530 | 2021-12-07T22:04:03+00:00 | @jeffbcross love it! will take you up on that someday. in the meantime.. kudos for shaping the company you wanted! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [12, 114] | 1468112478630342656 | 16616694 | jeffbcross | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1468340794067021828 | swyx 33521530 | 2021-12-07T22:05:00+00:00 | @JoshuaOgundu your sweater has arm sleeves, this totally breaks immersion | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [14, 73] | 1468339675660099584 | 1599986989 | JoshuaOgundu | 0 | 0 | 4 | 0 | 0 | en | ||||||||
1468118101598162946 | swyx 33521530 | 2021-12-07T07:20:06+00:00 | @dhaiwat10 🔥 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [11, 12] | 1468105564848672771 | 1025757442594889734 | dhaiwat10 | 0 | 0 | 0 | 0 | 0 | und | ||||||||
1468156519808131075 | swyx 33521530 | 2021-12-07T09:52:46+00:00 | @jakobgreenfeld ☠️ | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [16, 18] | 1468155042813419520 | 1285142519525892098 | jakobgreenfeld | 0 | 0 | 1 | 0 | 0 | und | ||||||||
1468157512490700804 | swyx 33521530 | 2021-12-07T09:56:42+00:00 | @cherthedev 👋 https://jobs.lever.co/temporal/19d191e0-69bb-4d06-933d-deecb51176a8 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [12, 37] | 1468057406601003010 | 15790639 | cherthedev | 0 | 0 | 0 | 0 | 0 | 0 | und | |||||||
1468188704120336385 | swyx 33521530 | 2021-12-07T12:00:39+00:00 | @THyasser1 https://twitter.com/swyx/status/1468188704120336385/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [10, 10] | 1468188083246047234 | 876463068653510656 | THyasser1 | 0 | 0 | 3 | 0 | 0 | 0 | und |
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]);