tweets
21 rows where "created_at" is on date 2021-08-15 sorted by lang
This data as json, CSV (advanced)
Suggested facets: user, in_reply_to_user_id, in_reply_to_screen_name, retweet_count, favorite_count, retweeted, lang
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1426711010291847170 | swyx 33521530 | 2021-08-15T01:03:06+00:00 | anonymized DM https://twitter.com/swyx/status/1426711010291847170/photo/1 | Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 | 0 | [0, 13] | 1426672482975551490 | 33521530 | swyx | 0 | 0 | 109 | 0 | 0 | 0 | en | |||||||
1426715351446736899 | swyx 33521530 | 2021-08-15T01:20:21+00:00 | @Julian @amandanat @jwmares @DruRly @Backlinko @fadeke_adegbuyi @lennysan @packyM @ali_montag @MorningBrew @theskimm @JamesClear @scottsflights wait what? james clear is link roundups? did you mean to tag someone else? his newsletter is just quotes | Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 | 0 | [144, 248] | 1426614458495901700 | 293815131 | Julian | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1426720722940960776 | swyx 33521530 | 2021-08-15T01:41:42+00:00 | @Julian @amandanat @jwmares @DruRly @Backlinko @fadeke_adegbuyi @lennysan @packyM @ali_montag @MorningBrew @theskimm @JamesClear @scottsflights i mean i can think of dozens of link roundup letters but nothing with james comes to mind haha i’ll throw in a free plug for @litcapital’s letter. its the kind of daily financial markets link roundup i used to get from sellside brokers. very good for skimming thru datapoints. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [144, 421] | 1426716246813200391 | 293815131 | Julian | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1426723425565876230 | swyx 33521530 | 2021-08-15T01:52:26+00:00 | @iansu glad you got it haha | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [7, 27] | 1426722986782969857 | 15755614 | iansu | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1426729722319282182 | swyx 33521530 | 2021-08-15T02:17:27+00:00 | @Mike_Andreuzza saw you are shutting down TUF. looking fwd to whats next, pls send major updates on email | Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 | 0 | [16, 105] | 1426428704884994054 | 953420111305760769 | Mike_Andreuzza | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1426730661721776134 | swyx 33521530 | 2021-08-15T02:21:11+00:00 | RT @ppk: Breaking the web forward https://www.quirksmode.org/blog/archives/2021/08/breaking_the_we.html | 1425825423837974545 1425825423837974545 | Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 | 0 | [0, 58] | 0 | 45 | 0 | 0 | 1 | 0 | en | |||||||||
1426749508524797952 | swyx 33521530 | 2021-08-15T03:36:05+00:00 | Random idea: “Information Dietician” Studies the difference between what you consume and what you want to produce and gives you a plan for diet change, with weekly group checkins. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 180] | 0 | 3 | 74 | 0 | 0 | en | |||||||||||
1426918866052132870 | Big Tech Alert 1042038539800731650 | 2021-08-15T14:49:03+00:00 | 👥 @uber is now following @ponyheadson | Stuff F e5f554c6214aad6e1c1eda8f85df8098e77da7c3 | 0 | [0, 37] | 0 | 0 | 3 | 0 | 0 | en | |||||||||||
1426937335460114441 | Maggie Appleton 🧭 1343443016 | 2021-08-15T16:02:26+00:00 | @swyx 17. This collection has now matured into a full grown essay documenting the history of "digital gardening" as an ethos 🌲 https://maggieappleton.com/garden-history | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [6, 150] | 1260966673714221056 | 1343443016 | Mappletons | 0 | 16 | 64 | 0 | 1 | 0 | en | |||||||
1426944198519885824 | swyx 33521530 | 2021-08-15T16:29:42+00:00 | RT @Mappletons: @swyx 17. This collection has now matured into a full grown essay documenting the history of "digital gardening" as an etho… | 1426937335460114441 1426937335460114441 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 16 | 0 | 0 | 1 | en | ||||||||||
1426949687714598919 | swyx 33521530 | 2021-08-15T16:51:31+00:00 | @shreyas Most people are presented with ladders and their entire goal in life is to climb to the next rung. Smart people make the ladders. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [9, 139] | 1426946595677872133 | 2048741 | shreyas | 0 | 9 | 78 | 0 | 0 | en | ||||||||
1426955362507231232 | swyx 33521530 | 2021-08-15T17:14:04+00:00 | @kevinakwok I've been trying to articulate a "Dunbar Limit of Giving a Crap" - below which, people feel overall ownership of the product - above which, agency is separated from execution to the point that "if it doesnt impact a metric it doesn't matter" | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [12, 256] | 1426953742377701377 | 169791252 | kevinakwok | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1426955859238608897 | swyx 33521530 | 2021-08-15T17:16:03+00:00 | @rosiesherry @patrickjwoods i really really like this one | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [13, 57] | 1423625567820083203 | 2204961 | rosiesherry | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1426972669468045318 | hiten.eth 3382 | 2021-08-15T18:22:50+00:00 | Every piece of business advice should have a label that includes what stage of a startup it’s applicable for. Since these labels don’t exist today, your job is to filter the advice against whether it’s relevant at your current stage and for your startup. This is learned by doing. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 280] | 1426971885628116994 | 3382 | hnshah | 0 | 20 | 223 | 0 | 0 | en | ||||||||
1427006487503597568 | swyx 33521530 | 2021-08-15T20:37:13+00:00 | @VinnyLingham i see it's A/B testing day https://twitter.com/swyx/status/1427006487503597568/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [14, 40] | 1426998497237094403 | 1854401 | VinnyLingham | 0 | 0 | 23 | 0 | 0 | 0 | en | |||||||
1427008742797709312 | swyx 33521530 | 2021-08-15T20:46:11+00:00 | All metrics have exceptions but you can roughly break up startups into stages by employee count: 2 founders 20 employees 200 employees 2,000 employees <- probably a unicorn 20k employees 200k employees All advice has a relevance interval and it's possible to learn the tells. https://twitter.com/hnshah/status/1426972669468045318 | 1426972669468045318 1426972669468045318 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 281] | 1 | 0 | 18 | 0 | 0 | 0 | en | |||||||||
1427008893784236033 | swyx 33521530 | 2021-08-15T20:46:47+00:00 | @abhhnv honestly i was just subtweeting like 10 people at once i didnt think that this would register on the Twitter "startups" topic lol | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [8, 137] | 1426817785242345473 | 1135196462772416513 | abhhnv | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1427011360383115266 | swyx 33521530 | 2021-08-15T20:56:35+00:00 | @spitleaf should have posed on the right, then it would say "leet coder" | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [10, 72] | 1427008273274843141 | 357427736 | spitleaf | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1427011786331484161 | swyx 33521530 | 2021-08-15T20:58:17+00:00 | @jmj wow am i really the first person to suggest the OG collectibles stamps coins comic books rare books treasure maps on the back of the Declaration of Independence | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [5, 166] | 1427007636004773890 | 11922492 | jmj | 0 | 0 | 8 | 0 | 0 | en | ||||||||
1427019802430754819 | swyx 33521530 | 2021-08-15T21:30:08+00:00 | This week's newsletter will have a preview of my next post: "Measuring Developer Relations" https://www.swyx.io/subscribe/ I started out writing an "Advice for New Devrels" article for @willjohnsonio, @jkup, @kevmodrome, @Nutlope and others but it just blew up into a whole series 😅 https://twitter.com/swyx/status/1427019802430754819/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 277] | 0 | 3 | 27 | 0 | 0 | 0 | en | ||||||||||
1426951029052956673 | swyx 33521530 | 2021-08-15T16:56:51+00:00 | @stefanjudis https://twitter.com/swyx/status/1426951029052956673/video/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [12, 12] | 1426950409629937669 | 380616577 | stefanjudis | 0 | 0 | 22 | 0 | 0 | 0 | und |
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]);