tweets

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

21 rows where "created_at" is on date 2021-08-12, retweet_count = 0 and user = 33521530

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source, 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
1425624206524379136 swyx 33521530 2021-08-12T01:04:32+00:00 @temporalio something we debated at work that @martinfowler's Event Sourcing article leaves unclear: does Event Sourcing require you to fully reapply each function, or is it enough to just "dedupe" and restore state? https://news.ycombinator.com/item?id=28140598       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [12, 242] 1422424339589189633 33521530 swyx       0 0 2 0 0 0 en  
1425634237361754117 swyx 33521530 2021-08-12T01:44:23+00:00 @rachelnabors this piece by @wes_kao nails how the CBC trend solves for completion https://future.a16z.com/cohort-based-courses/       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [14, 106] 1425505298337370112 9550352 rachelnabors       0 0 6 0 0 0 en  
1425648105647607812 swyx 33521530 2021-08-12T02:39:30+00:00 @LinkofHyrule89 @dalmaer @slightlylate i tried building a small IDE with the filesystem API and immediately ran into this: https://github.com/WICG/file-system-access/issues/301 unfortunately i think the security priorities of the browser trump the UX we have come to expect from an Electron app with access to Node.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [39, 286] 1425640090533982213 290147834 LinkofHyrule89       0 0 4 0 0 0 en  
1425648784738983937 swyx 33521530 2021-08-12T02:42:12+00:00 @mjasay @deltajulyhotel “easy to gauge that” severely underestimates how hard it is to assess and attribute output.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [24, 115] 1425613270732267524 7617702 mjasay       0 0 2 0 0   en  
1425650503615008777 swyx 33521530 2021-08-12T02:49:02+00:00 @DavidWells @bcomnes https://twitter.com/swyx/status/1425650503615008777/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [20, 20] 1425645160457641986 13638932 DavidWells       0 0 1 0 0 0 und  
1425654856862167043 swyx 33521530 2021-08-12T03:06:19+00:00 @StringStory @TrungTPhan thats cause he part of the Trung T Fam       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [25, 63] 1425650012415954947 220496287 StringStory       0 0 1 0 0   en  
1425677272644677633 swyx 33521530 2021-08-12T04:35:24+00:00 At what point did we stop having fires in fireside chats and when do we get them back       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 85]             0 0 39 0 0   en  
1425684712542982147 swyx 33521530 2021-08-12T05:04:58+00:00 @SoccerMomTrades where were you when i was deep in the ZH rabbit hole in 2011       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [17, 77] 1425683479304491013 1116467354643255296 SoccerMomTrades       0 0 1 0 0   en  
1425685372793618437 swyx 33521530 2021-08-12T05:07:35+00:00 @codechaos_io @github i think it will happen slowly and then quickly. this is the most aggressive move ive seen in a while, remains to be seen if others will jump in with github. habits shift slowly. likely will be generational as well, the younger kids may only ever code on their ipads       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [22, 287] 1425544006163832834 930147194056867842 codechaos_io       0 0 3 0 0   en  
1425689351913021444 swyx 33521530 2021-08-12T05:23:24+00:00 @kwuchu daaaaaamn what a flex       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [8, 29] 1425655874794754058 291911739 kwuchu       0 0 1 0 0   en  
1425706688607260681 swyx 33521530 2021-08-12T06:32:17+00:00 @drikerf @coreyhainesco side note its pretty cool that your URL unfurls to a video!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [24, 83] 1425702492596224002 1227758149 drikerf       0 0 2 0 0   en  
1425707376414392321 swyx 33521530 2021-08-12T06:35:01+00:00 @visakanv @boop Tech specific media sequence for the uninitiated https://medium.com/backchannel/how-the-tech-press-forces-a-narrative-on-companies-it-covers-5f89fdb7793e       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [16, 90] 1425490068274225155 16884623 visakanv       0 0 3 0 0 0 en  
1425707553929908238 swyx 33521530 2021-08-12T06:35:43+00:00 @boop oh so you make product demo videos? Name a background musical instrument that isn't the ukelele       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [6, 101] 1425565963986952193 14782048 boop       0 0 19 0 0   en  
1425714540159791105 swyx 33521530 2021-08-12T07:03:29+00:00 @mrmrs_ ooh @JoshWComeau       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [8, 24] 1425595423469752327 316589445 mrmrs_       0 0 1 0 0   und  
1425716946977185793 swyx 33521530 2021-08-12T07:13:03+00:00 Every few months I marvel at the perfect timing of the releases of AWS Lambda (max lock in) and Kubernetes (min lock in) and how they make total sense given each cloud’s position. Behind the scenes tech strategists are playing a giant game of 4D chess and we are the pawns.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 274]             0 0 15 0 0   en  
1425739640040947712 swyx 33521530 2021-08-12T08:43:13+00:00 @microsleeep @vorcigernix @vercel markov chain based generation of a single word?! how does this thing work 👀       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [34, 109] 1425738626487435264 2980522001 microsleeep       0 0 0 0 0   en  
1425835851146088460 swyx 33521530 2021-08-12T15:05:32+00:00 @rafahari you are amazing 😻 keep it up!!!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [10, 41] 1425814260865658905 42387965 rafahari       0 0 1 0 0   en  
1425877825165221889 swyx 33521530 2021-08-12T17:52:19+00:00 @trivikram @reactjs @sveltejs @solid_js its great. its supporters get very mad when i say anything else       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [40, 103] 1425865149085224965 21297217 trivikram       0 0 9 0 0   en  
1425894798477594626 swyx 33521530 2021-08-12T18:59:46+00:00 @QuinnyPig @dabit3 @undef_obj ayy this podcast finally happened!!!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [30, 66] 1344467557428809728 97114171 QuinnyPig       0 0 0 0 0   en  
1425924210602352640 swyx 33521530 2021-08-12T20:56:38+00:00 @mscccc i tried it but it seemed too inconvenient to keep standing up and going round to wake it up every time i wanted to webcam. did i do it wrong? does your iphone just always stay on?       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [8, 187] 1425917300570460160 99121168 mscccc       0 0 2 0 0   en  
1425924327027838977 swyx 33521530 2021-08-12T20:57:06+00:00 @_developit @jlongster when i grow up i want to be half as cool as jlongster       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [23, 76] 1425880247799517189 16495353 _developit       0 0 15 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]);