tweets

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

21 rows where in_reply_to_screen_name = "acemarke" sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source, display_text_range, retweet_count, favorite_count, favorited, retweeted, lang

user 2 ✖

is_quote_status 2 ✖

  • 0 20
  • 1 1

in_reply_to_screen_name 1 ✖

  • acemarke · 21 ✖
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
1420469338973216768 swyx 33521530 2021-07-28T19:40:56+00:00 @acemarke @DNeighly @richardiii @threepointone @DavidKPiano when do we get to the broadway rap musical       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [60, 102] 1420458734812205056 727704217012604928 acemarke       0 0 6 0 0   en  
1428412406909136897 swyx 33521530 2021-08-19T17:43:51+00:00 @acemarke @beyang @github i do wonder at the logistics of essentially scraping github/gitlab.. seems inefficient, I hope you can do a deal with them to get all this data directly @beyang       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [26, 186] 1428403711936798723 727704217012604928 acemarke       0 0 1 0 0   en  
1436336842194837509 swyx 33521530 2021-09-10T14:32:43+00:00 @acemarke i like turtles       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [10, 24] 1436126021640769537 727704217012604928 acemarke       0 0 6 0 0   en  
1440846833014566912 swyx 33521530 2021-09-23T01:13:49+00:00 @acemarke awww thank you Mark!! we should do the same one of these days when my social bar is back up, also i have a backlog of like 5 guests to record with rn haha       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [10, 164] 1440821566439186433 727704217012604928 acemarke       0 0 3 0 0   en  
1449013555257217028 swyx 33521530 2021-10-15T14:05:27+00:00 @acemarke Immer explained! https://twitter.com/swyx/status/1039903000511143936?s=21   1039903000511143936 1039903000511143936   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [10, 50] 1448696463496605697 727704217012604928 acemarke       1 0 0 0 0 0 en  
1449815785086459905 swyx 33521530 2021-10-17T19:13:14+00:00 @acemarke @shanselman underrated       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [22, 32] 1449508831323643904 727704217012604928 acemarke       0 0 2 0 0   en  
1450335259959050241 swyx 33521530 2021-10-19T05:37:26+00:00 @acemarke honestly i could probably get funding for that       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [10, 56] 1450334764213448709 727704217012604928 acemarke       0 1 87 0 0   en  
1452436475430064135 swyx 33521530 2021-10-25T00:46:55+00:00 @acemarke @ProvablyFlarnie ya basically. and my impression was you had to self host mastodon, and switch between networks, which is probably not true but by then i had lost interest       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [27, 181] 1452358332392644614 727704217012604928 acemarke       0 0 1 0 0   en  
1452487937694658566 swyx 33521530 2021-10-25T04:11:24+00:00 @acemarke yes and love you for that! 🔥 i think there’s an unsolved “part two” which is the “okay you want to be an artist and play an infinite game, how do you get paid to do it” and i feel like the creator/crypto economy is unfortunately the best answer humanity has come up with       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [10, 280] 1452475566863626249 727704217012604928 acemarke       0 0 2 0 0   en  
1455009274661249026 swyx 33521530 2021-11-01T03:10:18+00:00 @acemarke i know but like today i wanted to try being a Real Programmer who knows sed/awk/grep lol       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [10, 98] 1455008937967820803 727704217012604928 acemarke       0 0 13 0 0   en  
1457535874837749765 Mark Erikson 727704217012604928 2021-11-08T02:30:06+00:00 The "workflow support" comes from adding a new `condition` option that's `(predicate) => Promise<boolean>`. It's based off of http://Temporal.io's https://docs.temporal.io/docs/typescript/workflows/#condition API. You can now wait for actions, state diffs, etc. Thanks to @swyx for suggesting this!       TweetDeck 9335de48b3673c3f69433a34861c115d1d382be3 0 [0, 276] 1457535446674718725 727704217012604928 acemarke       0 1 7 1 1 0 en  
1457835502556512256 swyx 33521530 2021-11-08T22:20:43+00:00 @acemarke @JoshuaKGoldberg nahh i dm'ed him after his excellent @cascadiajs talk and then one thing led to another..       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [27, 116] 1457834066976313348 727704217012604928 acemarke       0 0 4 0 0   en  
1458659990219018245 swyx 33521530 2021-11-11T04:56:56+00:00 @acemarke any way you can record this in video form? show the use cases you want and the stuff you tried so far. kinda hard to follow from just this description. last resort is to change the api. generally subscribe to the idea that if its too hard to type you’re prob being too fancy       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [10, 285] 1458632138278899715 727704217012604928 acemarke       0 0 0 0 0   en  
1459253063726682114 swyx 33521530 2021-11-12T20:13:36+00:00 @acemarke im in a rut, i know i should watch Succession or White Lotus but am afraid to commit       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [10, 94] 1459250580719816712 727704217012604928 acemarke       0 0 4 0 0   en  
1463304446415302659 swyx 33521530 2021-11-24T00:32:21+00:00 @acemarke @jasonclarkedev @freeCodeCamp what! i thought i updated it!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [40, 69] 1463301457814470661 727704217012604928 acemarke       0 1 2 0 0   en  
1463704111602233351 swyx 33521530 2021-11-25T03:00:29+00:00 @acemarke i hope you use textexpander or something for the amount of canned answers you do       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [10, 90] 1463684133218050051 727704217012604928 acemarke       0 0 2 0 0   en  
1464297735343915011 swyx 33521530 2021-11-26T18:19:20+00:00 @acemarke congrats Mark!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [10, 24] 1464293199543943174 727704217012604928 acemarke       0 0 1 0 0   en  
1467348146866982914 swyx 33521530 2021-12-05T04:20:34+00:00 @acemarke thanks for the very kind words Mark!! let’s do a chat sometime when you have a meta rant to mouthblog!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [10, 112] 1467343720936792071 727704217012604928 acemarke       0 0 3 0 0   en  
1469169682770845701 swyx 33521530 2021-12-10T04:58:42+00:00 @acemarke @delba_oliveira @worrydream *note to self* have baby so i can make great talk intros       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [38, 94] 1469168818593357824 727704217012604928 acemarke       0 0 4 0 0   en  
1432801930175156226 swyx 33521530 2021-08-31T20:26:14+00:00 @acemarke bro       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [10, 13] 1432801733802070025 727704217012604928 acemarke       0 0 1 0 0   und  
1468087567358648320 swyx 33521530 2021-12-07T05:18:46+00:00 @acemarke @sarah_edo https://twitter.com/swyx/status/1468087567358648320/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [20, 20] 1468066773752811520 727704217012604928 acemarke       0 3 92 0 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]);