tweets
6 rows where "created_at" is on date 2021-10-17 and favorite_count = 2 sorted by lang
This data as json, CSV (advanced)
Suggested facets: source
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1449562639433023491 | swyx 33521530 | 2021-10-17T02:27:19+00:00 | @elyktrix … shit, should i unfollow so i can follow again | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [10, 57] | 1449365847504470017 | 223739217 | elyktrix | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1449612480372568066 | swyx 33521530 | 2021-10-17T05:45:22+00:00 | @coreyhainesco @ndwignall this one was a surprisingly good convo, i started picking up interest around 30-45 min mark, by 1hr mark i was taking notes. solid perspective on writing informed by psychology. appreciate it! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [26, 219] | 1448701019957964805 | 2480319486 | coreyhainesco | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1449800380804517888 | swyx 33521530 | 2021-10-17T18:12:01+00:00 | @harisvsulaiman @reactjs @taillogs still ongoing hahah. beta coming soon. http://temporal.io/node | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [35, 97] | 1316799481543684096 | 33521530 | swyx | 0 | 0 | 2 | 0 | 0 | 0 | en | |||||||
1449815785086459905 | swyx 33521530 | 2021-10-17T19:13:14+00:00 | @acemarke @shanselman underrated | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [22, 32] | 1449508831323643904 | 727704217012604928 | acemarke | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1449883363095891970 | swyx 33521530 | 2021-10-17T23:41:45+00:00 | @VicVijayakumar @StripeDev yes! and i shared with @cjav_dev why i couldnt adopt Payment Links, which is that I need to send customers to a secret url based on the product purchased and they didnt support that yet without bringing in another dependency like Zapier. I hope theyve fixed that. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [27, 291] | 1449830857817079808 | 15433238 | VicVijayakumar | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1449886584241721348 | swyx 33521530 | 2021-10-17T23:54:33+00:00 | @threepointone @jonnykim aspirational timeout lol workflows should never timeout.. if temporal ever becomes mainstream i have a bunch of detailed blogposts i need to do on best practices | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [25, 187] | 1449479462052114432 | 1593171 | threepointone | 0 | 0 | 2 | 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]);