tweets

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

17 rows where "created_at" is on date 2021-08-18 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20" sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: display_text_range, in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, retweet_count, lang, created_at (date)

favorite_count 8 ✖

user 2 ✖

retweeted 2 ✖

  • 0 15
  • 1 2

source 1 ✖

  • Twitter for iPhone · 17 ✖
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  
1427792224859746305 swyx 33521530 2021-08-18T00:39:28+00:00 There’s a significant “it just works” premium built into everything from Apple. Every time I try to leave the Apple ecosystem in some way the thesis is invariably some version of “you get the same for less”. Every time I crawl back to Apple because the extra $ is worth it.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 275]             0 7 155 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  
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  
1427988073292476418 Emelia 👸🏻 14063149 2021-08-18T13:37:42+00:00 @JessTelford JWTs for external use tend not to solve the problems people think they do; for internal use, or cross authorisation boundaries, they can be good because then you can assert using public/private key cryptography that the token your presented really came from the authorising server       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [13, 293] 1427986367905161221 14063149 ThisIsMissEm       0 1 14 0 0   en  
1428028645755416589 swyx 33521530 2021-08-18T16:18:55+00:00 RT @tina_cms: We just launched our public beta: - Brand new dashboard - Media Manager with @cloudinary - Command line quickstart - And mu… 1428016338371452930 1428016338371452930     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 52 0 0 1   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  
1428114812249071618 swyx 33521530 2021-08-18T22:01:18+00:00 RT @sugarpirate_: I'm sorta back from a long twitter break! I've been spending my free time slowly getting through @thorstenball's excellen… 1428061205902630916 1428061205902630916     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 140]             0 4 0 0 1   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  

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