tweets

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

13 rows where "created_at" is on date 2021-08-18, retweet_count = 0 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, 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
1427787386080034823 swyx 33521530 2021-08-18T00:20:14+00:00 @clemmihai @fullstack podcast is still cached in some services if you ever need it! i think i offered it to David to take it over when i left but no momentum on their end       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [22, 170] 1427786239378223107 4796832195 clemmihai       0 0 2 0 0   en  
1427791147728920576 swyx 33521530 2021-08-18T00:35:11+00:00 @BrantApps @Hicksyfern @JustEatUK hmm so.. was the 6th star a failure? is it still in place today?       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [34, 98] 1427790695960559624 345246419 BrantApps       0 0 0 0 0   en  
1427792566922010626 swyx 33521530 2021-08-18T00:40:49+00:00 @BrantApps @Hicksyfern @JustEatUK add one star per year, simple       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [34, 63] 1427792321970638850 345246419 BrantApps       0 0 1 0 0   en  
1427794159520256002 swyx 33521530 2021-08-18T00:47:09+00:00 I’ve been wearing fitness trackers for years. First night of wearing it, my $229 @fitbit Versa 3 did this to my hand. also music controls were just buggy (pause, cant restart). watchface doesnt activate when i raise my hand. headed back in for the $329 Apple Watch. https://twitter.com/swyx/status/1427794159520256002/video/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 267] 1427792224859746305 33521530 swyx       0 0 24 0 0 0 en  
1427794789508939778 swyx 33521530 2021-08-18T00:49:39+00:00 @Swizec @Chris2Brooks but Apple doesnt make webcams?       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [22, 52] 1427793494857244672 15353121 Swizec       0 0 1 0 0   en  
1427795748842733568 swyx 33521530 2021-08-18T00:53:28+00:00 @jdeisenberg i was purely on windows til 2015 so there’s a strong familiarity bias there. the one time i tried ubuntu i struggled too much with device drivers and some basic programs i was used to didnt have a Linux port       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [13, 220] 1427794095825510401 14947707 jdeisenberg       0 0 0 0 0   en  
1427798652018257923 swyx 33521530 2021-08-18T01:05:00+00:00 @chriscoyier the people who get this spend too much time online and should call their parents more often       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [13, 104] 1427798104422723591 793830 chriscoyier       0 0 12 0 0   en  
1427804453462110222 swyx 33521530 2021-08-18T01:28:03+00:00 @ferreiracoder @RegalizDev 🤗       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [27, 28] 1427803823444217863 1255874155792216070 ferreiracoder       0 0 1 0 0   und  
1427810778283794439 swyx 33521530 2021-08-18T01:53:11+00:00 @taddeusz2002 @AdamRackis there are a surprising amount of iPhone-Android marriages in the replies       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [26, 98] 1427809121764528130 35821019 taddeusz2002       0 0 1 0 0   en  
1427866714482429961 swyx 33521530 2021-08-18T05:35:27+00:00 Snorkel is now a unicorn! https://twitter.com/SnorkelAI/status/1424724444048658436   1424724444048658436 1424724444048658436   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 25] 1417746151411879938 33521530 swyx       1 0 2 0 0 0 en  
1427871806879199232 swyx 33521530 2021-08-18T05:55:41+00:00 @tarungangwani tuning in to the recording now but yeah how the heck do you have a Metaverse podcast without the guy who wrote the definitive Metaverse blog series       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [15, 162] 1423033413213167620 23854138 tarungangwani       0 0 0 0 0   en  
1427909000285200386 swyx 33521530 2021-08-18T08:23:29+00:00 @avaitla16 what even is the source of this beef? feel like Sam is responding to something i didnt see       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [11, 101] 1427745539848818688 859749975999127552 avaitla16       0 0 1 0 0   en  
1428113221236363267 swyx 33521530 2021-08-18T21:54:59+00:00 @lillichoung gotta look at who is doing the recommending. JWT is very convenient for serverless and vendors. meanwhile everyone running rails and django set up sessions, send httponly cookies and carry on with their day. the only vendor who does it right is @begin https://twitter.com/swyx/status/1254871936514969600?s=21   1254871936514969600 1254871936514969600   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [13, 289] 1428111899502288902 2336043613 lillichoung       1 0 3 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]);