tweets
8 rows where favorite_count = 19 and is_quote_status = 1 sorted by truncated
This data as json, CSV (advanced)
Suggested facets: source, display_text_range, in_reply_to_user_id, in_reply_to_screen_name, retweet_count
created_at (date) 8 ✖
- 2021-09-02 1
- 2021-09-07 1
- 2021-10-06 1
- 2021-10-15 1
- 2021-10-30 1
- 2021-11-12 1
- 2021-11-13 1
- 2021-12-01 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1433218630745948160 | swyx 33521530 | 2021-09-02T00:02:04+00:00 | @TkDodo yes! illustrated: https://twitter.com/swyx/status/1010922550912802816?s=20 | 1010922550912802816 1010922550912802816 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [8, 49] | 1433096271443775494 | 44217212 | TkDodo | 1 | 2 | 19 | 0 | 0 | 0 | en | ||||||
1435232963600556041 | swyx 33521530 | 2021-09-07T13:26:18+00:00 | 34 days until I saw my own meme on a conference stage in person! enjoying this talk by @tlakomy about executing untrusted code atop a fullstack @typescript + AWS stack! however there is a surprising lack of jQuery, unclear if real @tlakomy was kidnapped https://twitter.com/tlakomy/status/1434969999572094983 https://twitter.com/swyx/status/1435232963600556041/photo/1 | 1434969999572094983 1434969999572094983 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 278] | 1426638568714227712 | 33521530 | swyx | 1 | 1 | 19 | 0 | 0 | 0 | en | ||||||
1445817426558402561 | swyx 33521530 | 2021-10-06T18:25:11+00:00 | Congrats to the @FlutterFlow team for launching on Product Hunt! Excited to be an early investor in the team that is changing how mobile applications are built. Their email product updates are some of the best emails I get. Check them out on PH 👇 https://www.producthunt.com/posts/flutterflow-2-0 https://twitter.com/flutterflow/status/1445765439993171972 https://twitter.com/swyx/status/1445817426558402561/video/1 | 1445765439993171972 1445765439993171972 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 295] | 1 | 0 | 19 | 0 | 0 | 0 | en | |||||||||
1449066344918372356 | swyx 33521530 | 2021-10-15T17:35:13+00:00 | I love and respect Jim, but this is bullshit. There are a lot of Twitter thinkfluencers saying Twitter is worth more than OLD_WAY_OF_LEARNING. Keep in mind they have a vested interest in convincing you that you can learn everything just following them. https://twitter.com/swyx/status/1387487111964626945 https://twitter.com/swyx/status/1449066344918372356/photo/1 | 1387487111964626945 1387487111964626945 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 278] | 1 | 0 | 19 | 0 | 0 | 0 | en | |||||||||
1454251874849202185 | swyx 33521530 | 2021-10-30T01:00:40+00:00 | Cloudflare rounding up the Jobs to Be Done of Cloud (i have a separate post on that) https://twitter.com/cloudflaredev/status/1454092772177235972 | 1454092772177235972 1454092772177235972 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 109] | 1450539279973699586 | 33521530 | swyx | 1 | 2 | 19 | 0 | 0 | 0 | en | ||||||
1459227112577986561 | swyx 33521530 | 2021-11-12T18:30:29+00:00 | "Red is about to be mine again, but it has always been ours." Scooter Braun becomes the dictionary definition of what happens when you try to NFT an artist against their will. Streaming #RedTaylorsVersion now and forever. https://twitter.com/taylorswift13/status/1459023801480474632 | 1459023801480474632 1459023801480474632 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 222] | 1 | 1 | 19 | 0 | 0 | 0 | en | |||||||||
1459327954794647556 | swyx 33521530 | 2021-11-13T01:11:12+00:00 | Huge shout out @BrittneyPostma for #FollowFriday! On top of running a podcast, blog, merch, and her own freelance dev/design business, she's led the creation of @SvelteSirens and galvanized the @SvelteSociety in a whole new way with her talents. Follow @BrittneyPostma!! https://twitter.com/BrittneyPostma/status/1412032180465831939 https://twitter.com/swyx/status/1459327954794647556/photo/1 | 1412032180465831939 1412032180465831939 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 296] | 1 | 2 | 19 | 0 | 0 | 0 | en | |||||||||
1465917129954234371 | swyx 33521530 | 2021-12-01T05:34:13+00:00 | Ok I finally made a private alt: @swyxio If you want the no-filter firehose from me, that's gonna be the outlet. No need to be mutuals just be a non-crazy person with an open mind. profile pic is from my fraternity days when i used to be fun https://twitter.com/qoouep/status/1465237879693590532 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 243] | 1 | 1 | 19 | 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]);