tweets
2 rows where favorite_count = 49 and is_quote_status = 1 sorted by truncated
This data as json, CSV (advanced)
user 2 ✖
- swyx 1
- Svelte Society 🧡 1
created_at (date) 2 ✖
- 2021-09-04 1
- 2021-10-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1434106223721426945 | Svelte Society 🧡 1176969867733479424 | 2021-09-04T10:49:02+00:00 | Svelte Summit Fall 2021 is happening on November 20th! CFPs are open as well! https://twitter.com/kevmodrome/status/1434105682077364224 | 1434105682077364224 1434105682077364224 | Tweetbot for Mac 2d56427825d31a620d10acb51615805f894c90f6 | 0 | [0, 77] | 1 | 11 | 49 | 0 | 1 | 0 | en | |||||||||
1452046180683161609 | swyx 33521530 | 2021-10-23T22:56:01+00:00 | it worries me that there’s an uncritical acceptance of @Reactjs conclusions without examining if those assumptions apply to you. React is verbose React is successful Must be verbose to be successful Here’s my attempt to articulate more timeless lessons than “2 way binding bad”: https://twitter.com/swyx/status/1383516418205835264 | 1383516418205835264 1383516418205835264 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 280] | 1 | 2 | 49 | 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]);