tweets
4 rows where retweet_count = 1 and source = "574fe4fa937eeb131136f7e3678f32d4ff3078d5" sorted by scopes
This data as json, CSV (advanced)
Suggested facets: user, 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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1316808667925082112 | Guillermo Rauch 15540222 | 2020-10-15T18:30:26+00:00 | Temporal's engine is quite complex, much like React's, but the surface exposed to the developer is a beautiful "render()" function to organize your backend workflows. Check it out: https://docs.temporal.io | Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 | 0 | [0, 205] | 1316808667304390657 | 15540222 | rauchg | 0 | 1 | 28 | 0 | 0 | 0 | en | |||||||
1427149449105534976 | swyx 33521530 | 2021-08-16T06:05:18+00:00 | Ah time for the weekly passive aggressive attack from my iPad https://twitter.com/swyx/status/1427149449105534976/photo/1 | Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 | 0 | [0, 61] | 0 | 1 | 81 | 0 | 0 | 0 | en | ||||||||||
1434809253152362496 | swyx 33521530 | 2021-09-06T09:22:38+00:00 | @markdalgleish @rainbowdotme congrats! if you get the time i’d really love a good ol’ blogpost on what specifically draws you to crypto in general, and Rainbow in particular. this space is full of hucksters so always meaningful to have perspectives from “real” folks | Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 | 0 | [29, 266] | 1434677066692116483 | 257765996 | markdalgleish | 0 | 1 | 26 | 0 | 0 | en | ||||||||
1445886812279300101 | swyx 33521530 | 2021-10-06T23:00:53+00:00 | This is the closest thing to a Director’s commentary I’ve found and it’s fantastic. they put so much thought into the games, the set and costume design. the show’s Art Director is incredible, I hope she wins an award or something https://youtu.be/xc61U1aFkik | Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 | 0 | [0, 254] | 1443997105790459905 | 33521530 | swyx | 0 | 1 | 8 | 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]);