tweets
116 rows where retweet_count = 3 sorted by lang
This data as json, CSV (advanced)
created_at (date) 9 ✖
- 2021-12-07 3
- 2021-10-04 2
- 2021-12-02 2
- 2021-12-03 2
- 2021-12-09 2
- 2021-12-12 2
- 2021-09-10 1
- 2021-12-10 1
- 2021-12-21 1
user 6 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1466846573078487043 | CoRecursive Podcast 947150325424803840 | 2021-12-03T19:07:30+00:00 | A great list to be a part of! 🏆 https://twitter.com/swyx/status/1466447829149237249 | 1466447829149237249 1466447829149237249 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 31] | 1 | 3 | 18 | 1 | 1 | 0 | en | |||||||||
1466847530872762370 | swyx 33521530 | 2021-12-03T19:11:18+00:00 | RT @corecursive: A great list to be a part of! 🏆 | 1466846573078487043 1466846573078487043 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 48] | 1 | 3 | 0 | 1 | 1 | en | ||||||||||
1468143869426606081 | Jakob Greenfeld 1285142519525892098 | 2021-12-07T09:02:29+00:00 | I'm not sure what's going on over at Indie Hackers but this doesn't look good to me. https://twitter.com/jakobgreenfeld/status/1468143869426606081/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 84] | 0 | 3 | 161 | 0 | 0 | 0 | en | ||||||||||
1468312602761592834 | swyx 33521530 | 2021-12-07T20:12:59+00:00 | Twitter acquiring Smyte in 2018 vs Twitter acquiring Quill in 2021 https://twitter.com/swyx/status/1468312602761592834/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 68] | 0 | 3 | 33 | 0 | 0 | 0 | en | ||||||||||
1468996525653209094 | italianCoders 1349817381657444360 | 2021-12-09T17:30:39+00:00 | Few minutes and we will be live with @swyx to talk about #React #FrontEnd Here the link 🎉🚀https://youtu.be/b1FXpOExLQw | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 114] | 0 | 3 | 3 | 0 | 0 | 0 | en | ||||||||||
1469025856878268416 | swyx 33521530 | 2021-12-09T19:27:12+00:00 | gave this talk again thanks to @giorgio_boa! https://twitter.com/italian_coders/status/1468996525653209094?s=20 | 1468996525653209094 1468996525653209094 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 68] | 1442647414326714370 | 33521530 | swyx | 1 | 3 | 3 | 0 | 0 | 0 | en | ||||||
1469166647562756099 | swyx 33521530 | 2021-12-10T04:46:39+00:00 | omg this is the first talk I've ever seen by @delba_oliveira and my mind is blown 🤯 So much packed into this 9 minute overview of the State of the Art in Interactive Playgrounds - @worrydream would be proud! and... The examples The backdrop THE BABY https://youtu.be/zL8cz2W0z34 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 277] | 1469163411531513857 | 33521530 | swyx | 0 | 3 | 33 | 0 | 0 | 0 | en | |||||||
1469880889312104449 | swyx 33521530 | 2021-12-12T04:04:47+00:00 | @t3dotgg uh wow what? you are super underfollowed, how do i buy stock in your follower count lol | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [9, 96] | 1469858072843620352 | 786375418685165568 | t3dotgg | 0 | 3 | 25 | 0 | 0 | en | ||||||||
1470146931263299586 | swyx 33521530 | 2021-12-12T21:41:57+00:00 | Best <$100 Christmas gift you’ve gotten recently? | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 52] | 0 | 3 | 61 | 0 | 0 | en | |||||||||||
1473190888499458049 | swyx 33521530 | 2021-12-21T07:17:33+00:00 | @amasad that sounds like The Future According to Frontend Devs but i think there are some genuinely interesting things going on in the data (@getdbt) lowcode (@webflow, @flutterflow), PaaS (@flydotio, @cloudflare) and orchestration (@temporalio) world. too small for Next Big Thing? | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [8, 282] | 1473181494508097542 | 166138615 | amasad | 0 | 3 | 23 | 0 | 0 | en | ||||||||
1445112871424339974 | Osman Cea 120550262 | 2021-10-04T19:45:32+00:00 | Dudes, esta conversación entre @swyx y @threepointone es puro oro. https://www.youtube.com/watch?v=H3h1WICelqs | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 91] | 0 | 3 | 17 | 0 | 1 | 0 | es | ||||||||||
1445115297065693198 | swyx 33521530 | 2021-10-04T19:55:10+00:00 | RT @daslaf: Dudes, esta conversación entre @swyx y @threepointone es puro oro. https://www.youtube.com/watch?v=H3h1WICelqs | 1445112871424339974 1445112871424339974 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 103] | 0 | 3 | 0 | 0 | 1 | 0 | es | |||||||||
1466386204346175493 | Sibelius Seraphini 2313873457 | 2021-12-02T12:38:09+00:00 | Learn in Public é minha religião https://twitter.com/sseraphini/status/1466386204346175493/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 32] | 0 | 3 | 33 | 1 | 1 | 0 | pt | ||||||||||
1466430676136300552 | swyx 33521530 | 2021-12-02T15:34:52+00:00 | RT @sseraphini: Learn in Public é minha religião https://twitter.com/sseraphini/status/1466386204346175493/photo/1 | 1466386204346175493 1466386204346175493 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 72] | 0 | 3 | 0 | 1 | 1 | 0 | pt | |||||||||
1436324319504711683 | swyx 33521530 | 2021-09-10T13:42:58+00:00 | gm https://twitter.com/swyx/status/1436324319504711683/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 2] | 0 | 3 | 75 | 0 | 0 | 0 | und | ||||||||||
1468087567358648320 | swyx 33521530 | 2021-12-07T05:18:46+00:00 | @acemarke @sarah_edo https://twitter.com/swyx/status/1468087567358648320/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [20, 20] | 1468066773752811520 | 727704217012604928 | acemarke | 0 | 3 | 92 | 0 | 0 | 0 | und |
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]);