tweets
3 rows where favorited = 1 and source = "574fe4fa937eeb131136f7e3678f32d4ff3078d5" sorted by lang
This data as json, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1451287571481325569 | Mitchell Hashimoto 12819682 | 2021-10-21T20:41:35+00:00 | I love this “Willingness to look stupid” post. For me, I’d also flip this and say that people who go out of their way to be the smartest person in the room are a huge red flag. I’ve had an almost universally bad experience with those types of people. https://danluu.com/look-stupid/ | Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 | 0 | [0, 274] | 0 | 56 | 451 | 1 | 1 | 0 | en | ||||||||||
1457002741113319430 | swyx 33521530 | 2021-11-06T15:11:37+00:00 | RT @loujaybee: In some senses, I do think he's right ✅ @swyx did a good job of outlining the problem. When we're new to content and/or tec… | 1456915351241990145 1456915351241990145 | Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 | 0 | [0, 140] | 0 | 2 | 0 | 1 | 1 | en | ||||||||||
1474316991645245441 | Gwen (Chen) Shapira 9462812 | 2021-12-24T09:52:16+00:00 | “Your North Star metric is ‘monthly active developers’”. https://pocket.co/xhme3G @swyx is laying down the law for DevRel. Love the bold clarity. | Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 | 0 | [0, 146] | 0 | 17 | 84 | 1 | 1 | 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]);