tweets
5 rows where favorite_count = 68 sorted by lang
This data as json, CSV (advanced)
created_at (date) 5 ✖
- 2019-02-06 1
- 2021-02-12 1
- 2021-09-01 1
- 2021-09-06 1
- 2021-12-07 1
source 4 ✖
user 3 ✖
- swyx 3
- Baldur Bjarnason 1
- Jason Laster 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1093200303254466561 | swyx 33521530 | 2019-02-06T17:30:37+00:00 | Presenting... `useCreateClass` https://codesandbox.io/s/j2z6q89zq3 MIXINS ARE BACK | Twitter Web Client 887710c0899816dfe9fb0176eb05d760cbe15732 | 0 | [0, 72] | 1093187003032600576 | 33521530 | swyx | 0 | 13 | 68 | 0 | 0 | 0 | en | |||||||
1360373746897326081 | swyx 33521530 | 2021-02-12T23:42:30+00:00 | re: techronym for “coveted bigco jobs” 🙅🏽♂️ Instead of: FAANG 💁🏻♀️ I submit: MANGA | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 86] | 0 | 0 | 68 | 0 | 0 | en | |||||||||||
1432977957388120064 | swyx 33521530 | 2021-09-01T08:05:43+00:00 | Sometimes it can be super frustrating when the machine just refuses to do what you want despite trying everything. But eventually you see that you just didn't understand the machine well enough. Humans made that machine, and there's always something you can do to take it apart. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 279] | 1432977956259778565 | 33521530 | swyx | 0 | 5 | 68 | 0 | 0 | en | ||||||||
1434873556903636996 | Baldur Bjarnason 805850 | 2021-09-06T13:38:09+00:00 | I just published "The Single-Page-App Morality Play" https://www.baldurbjarnason.com/2021/single-page-app-morality-play/ | FeedPress Publisher b79f2560c2a67cfe3c4fa1bdb0d056e6f2410096 | 0 | [0, 76] | 0 | 19 | 68 | 0 | 1 | 0 | en | ||||||||||
1468330375881510916 | Jason Laster 312750384 | 2021-12-07T21:23:36+00:00 | http://Replay.io is shipping Network Monitor V0.5 today. It’s not quite V1, but it’s definitely not V0 🚀 If you see any bugs, send us a replay! https://twitter.com/jasonlaster11/status/1468330375881510916/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 151] | 0 | 10 | 68 | 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]);