tweets
7 rows where favorite_count = 14 and is_quote_status = 1 sorted by truncated
This data as json, CSV (advanced)
Suggested facets: retweet_count
created_at (date) 6 ✖
- 2021-10-03 2
- 2021-07-29 1
- 2021-10-04 1
- 2021-10-11 1
- 2021-10-20 1
- 2021-12-23 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1420635902032846852 | swyx 33521530 | 2021-07-29T06:42:47+00:00 | Today's mixtape: A clip from 1984, inspired by the Loki TV Series https://swyx.transistor.fm/episodes/1984-vs-brave-new-world-pt-1-intelligence-squared https://twitter.com/swyx/status/1419128271799656449 https://twitter.com/swyx/status/1420635902032846852/photo/1 | 1419128271799656449 1419128271799656449 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 114] | 1 | 0 | 14 | 0 | 0 | 0 | en | |||||||||
1444556693673701378 | swyx 33521530 | 2021-10-03T06:55:28+00:00 | @jlengstorf @astrodotbuild right here with ya :) https://twitter.com/swyx/status/1172690454363672577?s=20 | 1172690454363672577 1172690454363672577 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [27, 72] | 1442707241627385860 | 15668072 | jlengstorf | 1 | 1 | 14 | 0 | 0 | 0 | en | ||||||
1444560899797176321 | swyx 33521530 | 2021-10-03T07:12:11+00:00 | Unsolicited compliment: I am enjoying watching along how @9ranty is building his Loom competitor in public. Lots of little gems and the video result looks great! Worth checking out http://tella.tv Am not a regular user yet but #BuildInPublic updates keep me interested. https://twitter.com/TellaHQ/status/1443129037854019589 | 1443129037854019589 1443129037854019589 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 1 | 0 | 14 | 0 | 0 | 0 | en | |||||||||
1445111500931153922 | swyx 33521530 | 2021-10-04T19:40:05+00:00 | Events are underrated for community building 🔥 Find ways to get off Slack! All year we've been hosting @temporalio meetups with a good mix of users and employees speaking. Most recently we've been really ramping up guest speakers, from @Bolt to @AirbyteHQ and now @NetflixEng 🚀 https://twitter.com/temporalio/status/1445091864244207618 | 1445091864244207618 1445091864244207618 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 278] | 1 | 1 | 14 | 0 | 0 | 0 | en | |||||||||
1447688291818508296 | swyx 33521530 | 2021-10-11T22:19:20+00:00 | One of my favorite things at work is flipping low-trust situations into high-trust ones. Teams move at the speed of trust. I think it is one of the most critical things you can do early on in any job. RTing this bc first time I've seen Trust broken down to an equation! https://twitter.com/ryan_caldbeck/status/1013626221601738754 | 1013626221601738754 1013626221601738754 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 270] | 1 | 1 | 14 | 0 | 0 | 0 | en | |||||||||
1450648649747222534 | swyx 33521530 | 2021-10-20T02:22:44+00:00 | @stephsmithio do i get a bingo https://twitter.com/swyx/status/1426672482975551490 | 1426672482975551490 1426672482975551490 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [14, 54] | 1450646128416854018 | 626691391 | stephsmithio | 1 | 0 | 14 | 0 | 0 | 0 | en | ||||||
1474097799491112960 | swyx 33521530 | 2021-12-23T19:21:17+00:00 | Extremely impressed by @AirbyteHQ's 2021: Mar: 5m Seed @Accel May: 26m Series A @Benchmark Dec: 150m Series B @altcap + Coatue Took 1 yr to get to 1/4 of Fivetran (founded 2012) 🤯 Was only tipped off by @roopakv + case study with @temporalio, but have to pay close attn now. https://twitter.com/MichelTricot/status/1474055955734319112 https://twitter.com/swyx/status/1474097799491112960/photo/1 | 1474055955734319112 1474055955734319112 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 302] | 1 | 1 | 14 | 0 | 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]);