tweets
5 rows where display_text_range = "[0, 230]" sorted by lang
This data as json, CSV (advanced)
Suggested facets: user, source, is_quote_status, retweet_count, favorite_count
created_at (date) 5 ✖
- 2019-05-31 1
- 2020-05-19 1
- 2021-02-14 1
- 2021-03-04 1
- 2021-09-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1134311153960534016 | Lee Byron 14904098 | 2019-05-31T04:10:28+00:00 | Super curious to see how this works out. Historically I’ve been very skeptical of schema federation and the costs it incurs on an org, so I’m hoping to learn from the community on what works and doesn’t work from this new attempt. https://twitter.com/apollographql/status/1134086759489384449 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 230] | 1 | 11 | 82 | 0 | 0 | 0 | en | ||||||||||
1262696057609187330 | swyx 33521530 | 2020-05-19T10:46:14+00:00 | i'm currently at ~2k visitors/day according to @Netlify Analytics. April data looks suspicious. People really like me in Germany! lol and TIL that Chris Coyier linked me in @Css!!!!!!!!! https://css-tricks.com/react-single-file-components-are-here/ *success kid ✊* https://twitter.com/swyx/status/1262696057609187330/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 230] | 1220372896448700418 | 33521530 | swyx | 0 | 0 | 12 | 0 | 0 | 0 | en | |||||||
1360757289032933378 | swyx 33521530 | 2021-02-14T01:06:34+00:00 | 🚨 Descript's 2 Killer Features for Podcast Editing A quick demo of how @DescriptApp lets you easily remove pauses and filler words. I immediately upgraded to the Pro plan after I saw this. cc @jbrancha https://youtu.be/du8xatGd0zE | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 230] | 1360739396236943360 | 33521530 | swyx | 0 | 1 | 15 | 0 | 0 | 0 | en | |||||||
1367303433015808004 | swyx 33521530 | 2021-03-04T02:38:36+00:00 | 🆕 Short post: Workshopping https://www.swyx.io/workshopping/ Not everything should be public. Sometimes it's better to iterate semi-privately. An idea inspired by Broadway tradition, which helps solve the Consistency vs Quality tradeoff. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 230] | 0 | 3 | 15 | 0 | 0 | 0 | en | ||||||||||
1441000583641673733 | React New York 1074605328694722560 | 2021-09-23T11:24:46+00:00 | So, who’s gonna be talking at #ReactDayNewYork 2021? Well, we’ll have @swyx, @anna_carey, @AtilaFassina, @millicode_, @ianand, @bonniedotdev, @colbyfayock, @deekshasharma25 and Emily Thomas. #SaveTheDate Tuesday 5th, October 2021 | Twitter for Advertisers fbceb240777efd04e705e7d9e72d864f60964124 | 0 | [0, 230] | 0 | 3 | 15 | 0 | 1 | en | {"followers": false} |
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]);