tweets
9 rows where "created_at" is on date 2021-09-25, is_quote_status = 0, retweeted = 0 and source = "1f89d6a41b1505a3071169f8d0d028ba9ad6f952" sorted by lang
This data as json, CSV (advanced)
Suggested facets: user, retweet_count, favorite_count, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1441635264003284997 | swyx 33521530 | 2021-09-25T05:26:45+00:00 | @MathCrln @beyang actually read the textbooks and share what you learn :) | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [18, 73] | 1441626005609725957 | 369219338 | MathCrln | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1441794957543608324 | Angie Jones 2932738834 | 2021-09-25T16:01:19+00:00 | The problem with learning from experts is that they are so far removed from square one. Their material assumes some foundational knowledge. Newbies, don't be afraid to share what you're learning. From the beginning. We - even the experts - need your fresh perspective! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 269] | 0 | 470 | 2330 | 0 | 0 | en | |||||||||||
1441818486636888066 | swyx 33521530 | 2021-09-25T17:34:49+00:00 | I had a wonderful chat with @liormech and @pgupta about @getamberflo and how AWS does Usage Metering and Billing! https://www.youtube.com/watch?v=zelDLiG4SLE | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 138] | 1429888354192019476 | 33521530 | swyx | 0 | 3 | 4 | 0 | 0 | 0 | en | |||||||
1441836267092709382 | swyx 33521530 | 2021-09-25T18:45:28+00:00 | Recorded next podcast with @mhevery 🔥 its a banger We talked: - @BuilderIO vs #Jamstack CMSes - @adamdbradley's Partytown - @QwikDev - Lessons from @Angular - Metabolic Health! so grateful to @ivanburazin for connecting us at @InfobipShift! Subscribe: http://youtube.com/swyxTV | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 279] | 0 | 7 | 50 | 0 | 0 | 0 | en | ||||||||||
1441866360313634823 | Shreyas Doshi 2048741 | 2021-09-25T20:45:03+00:00 | How to pick a North Star Metric? Start with the chemical(s) your product deals with & consider the associated metric: Oxytocin - Brand metric Cortisol - Revenue metric Dopamine - Usage Frequency metric Adrenaline - Session Duration metric Endorphins - Freemium Conversion metric | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 284] | 0 | 219 | 1389 | 0 | 0 | en | |||||||||||
1441903939855781891 | swyx 33521530 | 2021-09-25T23:14:23+00:00 | @Dingman @tailwindcss cool! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [22, 27] | 1441885913580195843 | 7765902 | Dingman | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1441906183363829761 | swyx 33521530 | 2021-09-25T23:23:18+00:00 | @OphiraE @NPRAskMeAnother @jonathancoulton thank you both so, so much for 9 years of laughs and joy 🧡 Congrats on an incredible run and I will drop everything to see whatever you two get up to next | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [43, 197] | 1441083393467301888 | 302765767 | OphiraE | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1441915035194908676 | swyx 33521530 | 2021-09-25T23:58:28+00:00 | @Swizec whoo congrats swiz!! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [8, 28] | 1439272771586904065 | 15353121 | Swizec | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1441635007899049992 | swyx 33521530 | 2021-09-25T05:25:44+00:00 | @flyin1501 @tailwindcss yes | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [24, 27] | 1441631459865874439 | 2684994602 | flyin1501 | 0 | 0 | 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]);