tweets
17 rows where "created_at" is on date 2021-09-03, is_quote_status = 0 and retweeted = 0 sorted by lang
This data as json, CSV (advanced)
Suggested facets: in_reply_to_user_id, in_reply_to_screen_name, retweet_count, favorite_count, lang, created_at (date)
user 4 ✖
- swyx 14
- Peter Yang 1
- podrocketpod 1
- Internal Tech Emails 1
source 3 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||
1433623144212828185 | swyx 33521530 | 2021-09-03T02:49:27+00:00 | @gkoberger @daniel_levine @CockroachDB @dbcicero i'd love to! didn't get very far in my initial exploration of Clickhouse. @dbcicero if you're up for it you can DM me! (i cant DM you) or email swyx @ temporal . io | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [49, 213] | 1433280217485774848 | 14591604 | gkoberger | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1433631625301028866 | swyx 33521530 | 2021-09-03T03:23:09+00:00 | Today's clip: looking into @vitessio and sharing my discover of @MYonkovit's excellently named HOSS talks FOSS podcast! https://share.transistor.fm/s/74707fd2 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 144] | 1433277854406438913 | 33521530 | swyx | 0 | 1 | 2 | 0 | 0 | 0 | en | |||||||
1433717372339179521 | swyx 33521530 | 2021-09-03T09:03:53+00:00 | @cassiecodes awww congrats!! everyone looks so happy! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 53] | 1433709515497689113 | 758598429115310080 | cassiecodes | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1433717538165198852 | swyx 33521530 | 2021-09-03T09:04:32+00:00 | @ryanchenkie looking a great 35 my dude. we’re the same age! happy birthday!! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 77] | 1433435987443601408 | 30654945 | ryanchenkie | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1433807042590875654 | Peter Yang 84490044 | 2021-09-03T15:00:12+00:00 | You look more into this space and realize it's the opposite of your job. There are no OKRs, no metrics, no career ladders, not even that many PMs. People are just building stuff because they're passionate about it. | Typefully 295366d0fb34352a1961af2413827f072adefdb9 | 0 | [0, 216] | 1433807041403916296 | 84490044 | petergyang | 0 | 27 | 431 | 0 | 0 | en | ||||||||
1433823619671633923 | podrocketpod 1372248310904455178 | 2021-09-03T16:06:04+00:00 | In this episode, @RyanCarniato tells us all about @solid_js, a declarative, efficient, and flexible JavaScript library for building user interfaces. Listen here https://podrocket.logrocket.com/solidjs #podcast #javascript #webdevelopment #tech https://twitter.com/PodRocketpod/status/1433823619671633923/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 228] | 0 | 16 | 44 | 0 | 0 | 0 | en | ||||||||||
1433835933736919049 | swyx 33521530 | 2021-09-03T16:55:00+00:00 | @photon_garden @b0rk i do! i really enjoyed her post on this last year as well! https://jvns.ca/blog/2020/12/05/how-i-write-useful-programming-comics/ | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [21, 103] | 1433833142109016064 | 185437205 | photon_garden | 0 | 0 | 1 | 0 | 0 | 0 | en | |||||||
1433837480449613839 | Internal Tech Emails 1396491776739905542 | 2021-09-03T17:01:09+00:00 | Larry Page: "I think we should look into acquiring [YouTube]" November 8, 2005 https://twitter.com/TechEmails/status/1433837480449613839/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 79] | 0 | 1119 | 7175 | 0 | 0 | 0 | en | ||||||||||
1433840748588195841 | swyx 33521530 | 2021-09-03T17:14:08+00:00 | @NHeinDev @AngelaRiggs_ seconded. @freeCodeCamp let me dip my toe in the water before deciding on my career change. https://medium.com/hackernoon/no-zero-days-my-path-from-code-newbie-to-full-stack-developer-in-12-months-214122a8948f | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [24, 140] | 1433840277505052675 | 1333059155154907138 | NHeinDev | 0 | 0 | 3 | 0 | 0 | 0 | en | |||||||
1433875979852652545 | swyx 33521530 | 2021-09-03T19:34:08+00:00 | @forrestbrazeal oh. my. god. https://twitter.com/swyx/status/1433875979852652545/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [16, 30] | 1433873790564454401 | 3239330680 | forrestbrazeal | 0 | 0 | 5 | 0 | 0 | 0 | en | |||||||
1433881895796756481 | swyx 33521530 | 2021-09-03T19:57:38+00:00 | @Swizec @forrestbrazeal yes exactly | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [24, 35] | 1433879235374899201 | 15353121 | Swizec | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1433910190466736134 | swyx 33521530 | 2021-09-03T21:50:04+00:00 | I gotta hand it to Aldo Bucchi (not on Twitter) for leaving the best blogpost comment I've had all year 🙇♂️ https://dev.to/aldonline/comment/1hln8 Even if its an exaggeration (it probably is?) it captured my attention and left me no choice but to check out his product 👏 https://twitter.com/swyx/status/1433910190466736134/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 258] | 0 | 2 | 24 | 0 | 0 | 0 | en | ||||||||||
1433915176776962050 | swyx 33521530 | 2021-09-03T22:09:53+00:00 | @jpsimons DOM has 30 year head start. what evidence of trend are you thinking of? 4 isolated examples? a google flutter demo? | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [10, 125] | 1433913908989874179 | 32165130 | jpsimons | 0 | 0 | 5 | 0 | 0 | en | ||||||||
1433919649075240962 | swyx 33521530 | 2021-09-03T22:27:39+00:00 | @seldo reading this in Werner Herzog voice | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [7, 42] | 1433824330899607552 | 15453 | seldo | 0 | 0 | 12 | 0 | 0 | en | ||||||||
1433939106459885570 | swyx 33521530 | 2021-09-03T23:44:58+00:00 | Self Provisioning Runtimes are the “Level 5 Self Driving Cars” of developer platforms. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 86] | 1432864050895994890 | 33521530 | swyx | 0 | 0 | 4 | 0 | 0 | en | ||||||||
1433682486106542088 | swyx 33521530 | 2021-09-03T06:45:15+00:00 | 我吃的盐比你吃的饭还要多😱🤯 You could tell who spoke Chinese by the audible gasps in the room. Tony Leung owned every goddamn second he was onscreen in #shangchi https://twitter.com/swyx/status/1433682486106542088/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 149] | 0 | 0 | 14 | 0 | 0 | 0 | zh |
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]);