tweets
12 rows where favorite_count = 11, source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20" and user = 33521530
This data as json, CSV (advanced)
Suggested facets: in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, retweet_count, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1431472542141894666 | swyx 33521530 | 2021-08-28T04:23:44+00:00 | @mipsytipsy only two ways of building software teams: breaking down silos and then realizing why you had them in the first place | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [12, 128] | 1431397419850162179 | 90488576 | mipsytipsy | 0 | 0 | 11 | 0 | 0 | en | ||||||||
| 1437134330615173123 | swyx 33521530 | 2021-09-12T19:21:39+00:00 | @markdalgleish web apps were the original decentralized apps | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [15, 60] | 1436874489816510465 | 257765996 | markdalgleish | 0 | 0 | 11 | 0 | 0 | en | ||||||||
| 1446666565445767170 | swyx 33521530 | 2021-10-09T02:39:21+00:00 | @reactjs @brian_d_vaughn @_jstejada @lunaruan 🎉 congrats team!! really cool to see devtools get its own team, such a small team helping millions nbd | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [46, 148] | 1446571618113839112 | 1566463268 | reactjs | 0 | 0 | 11 | 0 | 0 | en | ||||||||
| 1451459461109846020 | swyx 33521530 | 2021-10-22T08:04:36+00:00 | i think ive taken like 9. when i was an options trader in London we had TWENTY EIGHT days vacation, including mandatory 2 week block vacation. i think that was my peak work life balance. i have so many things i would go back and do differently. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 246] | 1451412869065547777 | 33521530 | swyx | 0 | 0 | 11 | 0 | 0 | en | ||||||||
| 1451461828819652612 | swyx 33521530 | 2021-10-22T08:14:01+00:00 | @AntWilson try to make more friends outside of work. #learninpublic. force myself to date more. recognize that i was really freaking good at coding compared to most people and believe that i could change careers despite not having a degree. learn guitar/piano. buy bitcoin. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [11, 273] | 1451460743459577862 | 22399680 | AntWilson | 0 | 1 | 11 | 0 | 0 | en | ||||||||
| 1452409867138785281 | swyx 33521530 | 2021-10-24T23:01:11+00:00 | Tailwind is Optimized for Change. https://twitter.com/dan_abramov/status/1452326610904961032 | 1452326610904961032 1452326610904961032 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 33] | 1437132448798806017 | 33521530 | swyx | 1 | 0 | 11 | 0 | 0 | 0 | en | ||||||
| 1452490390871822342 | swyx 33521530 | 2021-10-25T04:21:09+00:00 | @dr IMO Ikigai is overrated. People often exoticize Ikigai as the ultimate solution to life, the universe and everything. But long tail creator economy has collapsed “What the world needs” with “What you can be paid for.” And you will come to love what you are good at. KISS. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [4, 279] | 1452476597076783106 | 5264 | dr | 0 | 1 | 11 | 0 | 0 | en | ||||||||
| 1457956188373458945 | swyx 33521530 | 2021-11-09T06:20:17+00:00 | doing my annual watch of Guy Steele’s talk today its got to have the most imbalanced ratio of influential in language design thinking vs actual success in influencing design of the Java Language™ (both his proposals failed) https://twitter.com/swyx/status/1288231120295714816 | 1288231120295714816 1288231120295714816 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 224] | 1 | 0 | 11 | 0 | 0 | 0 | en | |||||||||
| 1465589050652303363 | swyx 33521530 | 2021-11-30T07:50:33+00:00 | The production quality on this one is epic. I don’t think i’ve seen a better conference opener in the last 10 years. congrats @webflow and seriously @mcguirebrannon is a *superstar* 🤯 https://twitter.com/webflow/status/1461052708400549891 | 1461052708400549891 1461052708400549891 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 184] | 1 | 1 | 11 | 0 | 0 | 0 | en | |||||||||
| 1465807409335521287 | swyx 33521530 | 2021-11-30T22:18:14+00:00 | @threepointone higher order drama is so 2018, get on my level and use drama props | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [15, 81] | 1465776314955280394 | 1593171 | threepointone | 0 | 0 | 11 | 0 | 0 | en | ||||||||
| 1466996913153007617 | swyx 33521530 | 2021-12-04T05:04:54+00:00 | Relay compiler has been completely rewritten in Rust. “TL;DR: The main goal was drastically improve the speed of the build step.” https://twitter.com/RelayFramework/status/1466875921818861577 | 1466875921818861577 1466875921818861577 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 130] | 1458910483176517632 | 33521530 | swyx | 1 | 1 | 11 | 0 | 0 | 0 | en | ||||||
| 1470582458554802182 | swyx 33521530 | 2021-12-14T02:32:34+00:00 | @mpocock1 @turborepo mildly curious: you probably knew about turborepo before, did the acquisition influence your decision to try it out? it did for me and i’m somewhat struggling with the superficiality of that behavior. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [21, 221] | 1470514714186858499 | 346640777 | mpocock1 | 0 | 0 | 11 | 0 | 0 | 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]);