tweets

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

8 rows where in_reply_to_user_id = 255634108 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: is_quote_status, favorite_count, 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
1436214845641220098 swyx 33521530 2021-09-10T06:27:57+00:00 @jkup “it gets the people going!” haha thanks dude. its a humbling experience that anyone reads my stuff. always happy to take topic requests!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [6, 143] 1436136933437153285 255634108 jkup       0 0 5 0 0   en  
1441908391211716608 swyx 33521530 2021-09-25T23:32:04+00:00 @jkup my site is still under construction with over a million visitors per year       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [6, 79] 1441872380016701440 255634108 jkup       0 0 14 0 0   en  
1449143399659892736 swyx 33521530 2021-10-15T22:41:24+00:00 @jkup @Cloudflare ah love it when good ideas get great execution https://twitter.com/netlify/status/1115638145725403136?s=21   1115638145725403136 1115638145725403136   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [18, 88] 1448790326215389190 255634108 jkup       1 0 5 0 0 0 en  
1461420430137257986 swyx 33521530 2021-11-18T19:45:57+00:00 @jkup tried it, for me its just not worth it unless you are literally not paying attention to the stream. standard twitch streaming is full of interruptions, because naturally viewers want to interact with you live for it to be a good stream, but its terrible for focus       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [6, 269] 1461403751516971008 255634108 jkup       0 0 19 0 0   en  
1462993642839101440 swyx 33521530 2021-11-23T03:57:20+00:00 @jkup @threepointone https://github.com/sw-yx/technical-artists       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [21, 44] 1462853649424605186 255634108 jkup       0 0 4 0 0 0 und  
1463315760260915208 swyx 33521530 2021-11-24T01:17:18+00:00 @jkup @alexellisuk @Netlify @vercel @remix_run @rometools @replayio @Replit this is @supabase erasure and i wont stand for it       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [76, 125] 1463218621455425547 255634108 jkup       0 0 6 0 0   en  
1463718231454011393 swyx 33521530 2021-11-25T03:56:35+00:00 @jkup @AdamRackis finding so many people to mute, this is bliss       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [18, 63] 1463676727431946241 255634108 jkup       0 0 14 0 0   en  
1466312826507563009 swyx 33521530 2021-12-02T07:46:35+00:00 @jkup @buildsghost @LilNasX you look like you might be a belieber       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [28, 65] 1466299174727651330 255634108 jkup       0 0 0 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]);