tweets
5 rows where is_quote_status = 1 and retweet_count = 11 sorted by lang
This data as json, CSV (advanced)
Suggested facets: user, source, favorited, created_at (date)
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 | ||||||||||
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 | |||||||||
1434242885893844992 | swyx 33521530 | 2021-09-04T19:52:05+00:00 | RT @SvelteSociety: Svelte Summit Fall 2021 is happening on November 20th! CFPs are open as well! | 1434106223721426945 1434106223721426945 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 96] | 1 | 11 | 0 | 0 | 1 | en | ||||||||||
1460291937412521997 | Rich Harris 19487837 | 2021-11-15T17:01:43+00:00 | for the @brooklyn_js family, this is taking place at the event space right next to 61 local. this saturday, 12-4pm it's shaping up to be a fun event with good people and i can't wait to hang out with you all IRL https://twitter.com/SvelteSociety/status/1457844600236699648 | 1457844600236699648 1457844600236699648 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 237] | 1 | 11 | 62 | 1 | 1 | 0 | en | |||||||||
1460327694801850368 | swyx 33521530 | 2021-11-15T19:23:48+00:00 | RT @Rich_Harris: for the @brooklyn_js family, this is taking place at the event space right next to 61 local. this saturday, 12-4pm it's s… | 1460291937412521997 1460291937412521997 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 1 | 11 | 0 | 1 | 1 | 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]);