tweets
7 rows where "created_at" is on date 2021-08-28 and favorite_count = 1 sorted by lang
This data as json, CSV (advanced)
Suggested facets: in_reply_to_screen_name
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1431469774874218501 | swyx 33521530 | 2021-08-28T04:12:44+00:00 | @ibnuhx @temporalio hmm will investigate. thanks! we just switched to self hosted video and may have unexpected issues | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [20, 118] | 1431465851861884932 | 98195924 | ibnuhx | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1431480120447942658 | swyx 33521530 | 2021-08-28T04:53:50+00:00 | Nice chart here from @devadvocado showing where people really think DevRel lives (and therefore what it ends up shipping, via Conway’s law) https://interconnected.blog/surfing-the-wave-of-developer-relations-part-i/ https://twitter.com/swyx/status/1431480120447942658/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 164] | 1427353055519920136 | 33521530 | swyx | 0 | 0 | 1 | 0 | 0 | 0 | en | |||||||
1431703997312749569 | swyx 33521530 | 2021-08-28T19:43:27+00:00 | @arvidkahl you know i JUST realized there is a boot in the logo haha. great episode! lucky to have 4 years of elixir experience, i hear it is a great stack | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [11, 155] | 1431240334550392839 | 343990983 | arvidkahl | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1431713847128301576 | swyx 33521530 | 2021-08-28T20:22:35+00:00 | @cyber_badger___ yeah very loosely, except you write software in Go/Java/PHP/TypeScript instead of JSON, plus a dozen other smaller but important differences in features and service limitations. our CEO was tech lead of Step Functions’ predecessor. happy to answer any specific qtns you may have! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [17, 297] | 1431689377214836736 | 1063498567824957442 | cyber_badger___ | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1431715428045295618 | swyx 33521530 | 2021-08-28T20:28:52+00:00 | @RealNeilC @temporalio you know where to find us if you need us! 🙏 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [23, 66] | 1431714808856993797 | 1388591018505904134 | RealNeilC | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1431717342539563011 | swyx 33521530 | 2021-08-28T20:36:29+00:00 | @ibnuhx @temporalio fixed! we switched back to youtube. more views! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [20, 67] | 1431469774874218501 | 33521530 | swyx | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1431490652542435330 | swyx 33521530 | 2021-08-28T05:35:42+00:00 | @RandallKanna @temporalio https://twitter.com/swyx/status/1431490652542435330/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [25, 25] | 1431490150345834497 | 206918128 | RandallKanna | 0 | 0 | 1 | 0 | 0 | 0 | und |
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]);