tweets

This is data scraped from swyx's timeline! See blog post

7 rows where "created_at" is on date 2021-08-28, favorite_count = 1 and user = 33521530 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: in_reply_to_user_id, in_reply_to_screen_name, lang, created_at (date)

user 1 ✖

  • swyx · 7 ✖

favorite_count 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
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

CSV options: 

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]);