tweets

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

6 rows where "created_at" is on date 2021-11-23, favorite_count = 1 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20"

✎ 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)

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
1462991909756956673 swyx 33521530 2021-11-23T03:50:27+00:00 @afit @ananbatra @benbarbersmith @arvidkahl @reincubate i have to confess i tried using Camo but the phone kept turning off. i dont want to have to get up and turn the thing on whenever i jump on a call, and yet i dont want an always on phone burning its screen for no reason. is there an auto wake option?       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [56, 306] 1462832200177664010 19658693 afit       0 0 1 0 0   en  
1463005926386896902 swyx 33521530 2021-11-23T04:46:08+00:00 @SloanCam @_alex_buzin i’ve just gone ahead and blocked him, thank you       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [23, 70] 1462834672363192321 502208743 SloanCam       0 0 1 0 0   en  
1463030661254561793 swyx 33521530 2021-11-23T06:24:26+00:00 @fortelabs used http://lu.ma as well for the recent #SvelteSummit NYC event https://twitter.com/swyx/status/1462323377553694722?s=21   1462323377553694722 1462323377553694722   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [11, 110] 1462992587246030855 1909232666 fortelabs       1 0 1 0 0 0 en  
1463031773919465473 swyx 33521530 2021-11-23T06:28:51+00:00 @galeforceVC - Entertain!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [13, 25] 1462956203902918658 41519559 galeforceVC       0 0 1 0 0   fr  
1463032809094725635 swyx 33521530 2021-11-23T06:32:58+00:00 @fortelabs yep. i run my company meetups and workshops on it too. considered investing but didnt really see the vision beyond “eventbrite that doesnt suck”       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [11, 155] 1463031322276859904 1909232666 fortelabs       0 0 1 0 0   en  
1463069720802783244 swyx 33521530 2021-11-23T08:59:38+00:00 @gr2m @temporalio we frame it as “It is designed with TypeScript-first developer experience in mind, but works equally well with JavaScript.” in our docs this is because the team feels strongly that type safety should be heavily recommended as part of the DX of using Temporal. Eliminates footguns       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [18, 298] 1462998929562214404 11754732 gr2m       0 0 1 0 0   en  

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