tweets
18 rows where favorited = 0, in_reply_to_screen_name = "buildsghost" and retweeted = 0
This data as json, CSV (advanced)
Suggested facets: source, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1432787641892700161 | swyx 33521530 | 2021-08-31T19:29:28+00:00 | @buildsghost just curious why did you pick the 🍤 emoji? wondering if its a joke im not getting | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 94] | 1432786307969814532 | 1175464650395111424 | buildsghost | 0 | 0 | 3 | 0 | 0 | en | ||||||||
| 1432788499523014658 | swyx 33521530 | 2021-08-31T19:32:52+00:00 | @buildsghost i swear to god if 🍤 shows up in my node_modules i will… be highly entertained | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 90] | 1432787824630063114 | 1175464650395111424 | buildsghost | 0 | 0 | 13 | 0 | 0 | en | ||||||||
| 1432864758869356546 | swyx 33521530 | 2021-09-01T00:35:54+00:00 | @buildsghost @paulbiggar @darklang from what i heard, he already cut back a lot on his original vision 😂 i think Dark was even supposed to handle the frontend originally! but honestly, the sheer ambition is refreshing. too much incrementalism in tech. as i'm sure you no doubt feel. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [35, 282] | 1432855994766217218 | 1175464650395111424 | buildsghost | 0 | 0 | 3 | 0 | 0 | en | ||||||||
| 1433328362429181953 | swyx 33521530 | 2021-09-02T07:18:06+00:00 | @buildsghost thanks, first i am hearing of this perspective. got a good alternative for what you would say instead? | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 115] | 1433295830547505153 | 1175464650395111424 | buildsghost | 0 | 0 | 1 | 0 | 0 | en | ||||||||
| 1433616749694373893 | swyx 33521530 | 2021-09-03T02:24:03+00:00 | @buildsghost petition to use 👆 as topic variable | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [13, 48] | 1433487820132270081 | 1175464650395111424 | buildsghost | 0 | 0 | 21 | 0 | 0 | en | ||||||||
| 1434793287655829511 | swyx 33521530 | 2021-09-06T08:19:11+00:00 | @buildsghost i mean i enjoyed it but best is a very high bar, wow | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 65] | 1434674938762301443 | 1175464650395111424 | buildsghost | 0 | 0 | 0 | 0 | 0 | en | ||||||||
| 1434795731383107591 | swyx 33521530 | 2021-09-06T08:28:54+00:00 | @buildsghost i mean idk what this says about me but ive always put Cap 1, 2 and 3 up there. Cap 2 pretty often regarded as the best solo film. agree on your two too (i have trouble playing favorites lol). i think for this one, boss fight let it down. it was good tho i am not complaining | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 289] | 1434794206501879813 | 1175464650395111424 | buildsghost | 0 | 0 | 0 | 0 | 0 | en | ||||||||
| 1434798078037565441 | swyx 33521530 | 2021-09-06T08:38:13+00:00 | @buildsghost i have a thing for people standing up to bullies 🤷♂️ even if, as ive said before, i dont actually agree with deontology. makes for fun hero fantasy. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 162] | 1434796817804267525 | 1175464650395111424 | buildsghost | 0 | 0 | 1 | 0 | 0 | en | ||||||||
| 1435176665957683201 | swyx 33521530 | 2021-09-07T09:42:36+00:00 | @buildsghost @nbashaw did this when he got married! he has a writeup somewhere on the name merge but i cannot find | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 114] | 1435132107139866629 | 1175464650395111424 | buildsghost | 0 | 0 | 1 | 0 | 0 | en | ||||||||
| 1436410434211483648 | swyx 33521530 | 2021-09-10T19:25:09+00:00 | @buildsghost Smaller than 50 devs? sure. I'd honestly maybe draw the line at 20 devs but just splitting hairs at that point. I notice you left out "prod -> dev" productivity. Observability, monitoring, alerting. worthwhile category even at small sizes? | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [13, 256] | 1436404964541145091 | 1175464650395111424 | buildsghost | 0 | 0 | 9 | 0 | 0 | en | ||||||||
| 1441860508013903877 | swyx 33521530 | 2021-09-25T20:21:48+00:00 | @buildsghost see where you went wrong is you didnt use all caps https://twitter.com/lottelydia/status/1441335975867682817 | 1441335975867682817 1441335975867682817 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 63] | 1441514727654318083 | 1175464650395111424 | buildsghost | 1 | 0 | 3 | 0 | 0 | 0 | en | ||||||
| 1457460664230834176 | swyx 33521530 | 2021-11-07T21:31:15+00:00 | @buildsghost @floydophone @sebmck even the thing about checked-in source is controversial - i saw a thoughtleader™ on here a month or so ago passionately arguing for only publishing dist (not src) files because something something size of node modules | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [34, 251] | 1457448799928926212 | 1175464650395111424 | buildsghost | 0 | 0 | 1 | 0 | 0 | en | ||||||||
| 1463322071987941379 | swyx 33521530 | 2021-11-24T01:42:23+00:00 | @buildsghost @benadam11 i know its important but goodness that is a ton of time when you could otherwise be coding. makes me think a VC that is just insanely good at eliminating as many of the recruiting steps as possible for their founders should win. but even sequoia/a16z arent that full service | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [24, 298] | 1463264865049460737 | 1175464650395111424 | buildsghost | 0 | 0 | 1 | 0 | 0 | en | ||||||||
| 1465806937111416836 | swyx 33521530 | 2021-11-30T22:16:21+00:00 | @buildsghost someone shop this in pls https://twitter.com/swyx/status/1465806937111416836/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 37] | 1465799694177607681 | 1175464650395111424 | buildsghost | 0 | 0 | 6 | 0 | 0 | 0 | en | |||||||
| 1469527631187963905 | swyx 33521530 | 2021-12-11T04:41:04+00:00 | @buildsghost maybe not so weird if you consider Hamlet married his aunt and Lion King is basically animal themed Hamlet? | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 120] | 1469176320877903873 | 1175464650395111424 | buildsghost | 0 | 0 | 0 | 0 | 0 | en | ||||||||
| 1473024862721802240 | swyx 33521530 | 2021-12-20T20:17:49+00:00 | @buildsghost @tmcw its the most often used coded gatekeeping i see from people who would normally despite gatekeeping. ironic, but to be hypocritical is human i guess. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [19, 167] | 1473023692221206530 | 1175464650395111424 | buildsghost | 0 | 0 | 4 | 0 | 0 | en | ||||||||
| 1473026177833275392 | swyx 33521530 | 2021-12-20T20:23:02+00:00 | @buildsghost @tmcw https://twitter.com/swyx/status/1142025639744008194 | 1142025639744008194 1142025639744008194 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [19, 42] | 1473025536419004416 | 1175464650395111424 | buildsghost | 1 | 0 | 0 | 0 | 0 | 0 | und | ||||||
| 1473026573792325632 | swyx 33521530 | 2021-12-20T20:24:37+00:00 | @buildsghost @tmcw i think my framing of it couldve been better but i made an attempt at visualizing this in my book https://twitter.com/swyx/status/1473026573792325632/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [19, 116] | 1473026068206403584 | 1175464650395111424 | buildsghost | 0 | 0 | 7 | 0 | 0 | 0 | en |
Advanced export
JSON shape: default, array, newline-delimited, object
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]);