tweets
10 rows where favorite_count = 36 sorted by lang
This data as json, CSV (advanced)
Suggested facets: is_quote_status, retweet_count, favorited, retweeted
created_at (date) 9 ✖
- 2021-11-05 2
- 2021-01-06 1
- 2021-09-15 1
- 2021-09-19 1
- 2021-10-03 1
- 2021-10-31 1
- 2021-11-02 1
- 2021-11-09 1
- 2021-11-16 1
user 5 ✖
- swyx 6
- Cedric Chin 1
- Beyang Liu 1
- Ron Au 🦆 1
- Coding Career Community 1
quoted_status 1 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1346652236378566657 | Beyang Liu 16520821 | 2021-01-06T02:58:07+00:00 | Sourcegraph raised a lot of money in 2020 and in 2021, we're putting that to work by investing in features for open-source authors, maintainers, and users. I'd love to hear from folks who have thoughts on how we can better serve open source through our product. Current ideas👇 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 276] | 0 | 11 | 36 | 0 | 0 | en | |||||||||||
| 1437938458786471938 | swyx 33521530 | 2021-09-15T00:36:58+00:00 | @youyuxi i’m 1000% sure this tweet is being pasted in a dozen internal slack rooms right now haha | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [9, 97] | 1437865824690319366 | 182821975 | youyuxi | 0 | 0 | 36 | 0 | 0 | en | ||||||||
| 1439740066415321089 | swyx 33521530 | 2021-09-19T23:55:55+00:00 | Every time Pomp opens his mouth I lose 10 IQ points https://twitter.com/swyx/status/1439740066415321089/video/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 51] | 0 | 1 | 36 | 0 | 0 | 0 | en | ||||||||||
| 1444542756647419909 | Coding Career Community 1249002899897647105 | 2021-10-03T06:00:06+00:00 | "This career feels like a few key hours every year with a few near mandatory year-long cool-down periods in between where what you do barely matters." 😬 Who else has felt like this and what did you do about it? https://old.reddit.com/r/cscareerquestions/comments/pzofk7/this_career_feels_like_a_few_key_hours_every_year/ https://twitter.com/Coding_Career/status/1444542756647419909/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 236] | 0 | 6 | 36 | 0 | 0 | 0 | en | ||||||||||
| 1454871289643032580 | swyx 33521530 | 2021-10-31T18:02:00+00:00 | Surprising consensus from the smartest devtools people I talk to: San Francisco is still the place to be. You’d think that this group is the most inclined to remote life and distributed companies. None of them have offices anymore. But enough is IRL they have no hesitation. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 275] | 0 | 0 | 36 | 0 | 0 | en | |||||||||||
| 1455340970053013508 | swyx 33521530 | 2021-11-02T01:08:20+00:00 | There’s nothing more wince inducing than listening to podcasters honestly review a product you worked on 3 years after launch and having them call out obviously bad ideas that should’ve never seen the light of day 😬☠️ my defense is i didnt know better!! now i do!! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 265] | 0 | 0 | 36 | 0 | 0 | en | |||||||||||
| 1456447836803854336 | Cedric Chin 14243237 | 2021-11-05T02:26:38+00:00 | “In reality, a mentor is mostly just somebody that answers questions more than once. That’s it. It’s not cinematic.” https://staysaasy.com/career/2021/10/16/mentorship.html | Tweetbot for iΟS 85449edeaa7f6ae7eddac4a17a652ba08b5f536a | 0 | [0, 140] | 0 | 4 | 36 | 1 | 1 | 0 | en | ||||||||||
| 1456718364252934147 | swyx 33521530 | 2021-11-05T20:21:37+00:00 | @amacarthur @BrendanEich i was reminded of the move back to JS by @jeanqasaur and @Rich_Harris's livestream today https://twitter.com/swyx/status/1350427690814251010 | 1350427690814251010 1350427690814251010 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [25, 137] | 1456713650962673672 | 30416123 | amacarthur | 1 | 4 | 36 | 0 | 0 | 0 | en | ||||||
| 1458221287428427778 | swyx 33521530 | 2021-11-09T23:53:42+00:00 | Give all @TwitterBlue users a blue checkmark and your revenue 2x's overnight, just sayin, @Twitter | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 98] | 1458219955539742724 | 33521530 | swyx | 0 | 0 | 36 | 0 | 0 | en | ||||||||
| 1460615907139411970 | Ron Au 🦆 18333169 | 2021-11-16T14:29:03+00:00 | Keen on developer productivity and wellbeing? r/webdev + r/web_design are officially running a 6-week talk series on exactly that 🙌 Kindly sponsored by @Reddit, the theme is "Ingenious ways to work smarter, faster and healthier" and we begin next week! https://redditweb.dev | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 278] | 0 | 8 | 36 | 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]);