tweets
18 rows where "created_at" is on date 2021-10-15, retweet_count = 0 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20"
This data as json, CSV (advanced)
Suggested facets: display_text_range, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1448826049102376963 | swyx 33521530 | 2021-10-15T01:40:22+00:00 | @PaulYacoubian @shreyas stunning, yet also completely not surprised. congrats!!! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [24, 80] | 1448696042770337798 | 175934436 | PaulYacoubian | 0 | 0 | 3 | 0 | 0 | en | ||||||||
1448827354306867200 | swyx 33521530 | 2021-10-15T01:45:33+00:00 | @RobAWilkinson @ken_wheeler https://youtu.be/3_ee6aZObyI | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [28, 51] | 1448782623212462080 | 2496511 | RobAWilkinson | 0 | 0 | 0 | 0 | 0 | 0 | und | |||||||
1448832401858170883 | swyx 33521530 | 2021-10-15T02:05:37+00:00 | @dabit3 https://youtu.be/mwq-T2CrJRU | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [8, 31] | 1448645926327783443 | 17189394 | dabit3 | 0 | 0 | 1 | 0 | 0 | 0 | und | |||||||
1448893200588951553 | swyx 33521530 | 2021-10-15T06:07:12+00:00 | @zahrakhadijha this is a wonderful way to test your learning :) good luck, im sure @acemarke and many webdevs will be here for you if you get stuck! you got this! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [15, 162] | 1448806283272916993 | 2606183113 | zahrakhadijha | 0 | 0 | 4 | 0 | 0 | en | ||||||||
1448893892816871425 | swyx 33521530 | 2021-10-15T06:09:57+00:00 | @geddski *puts down pitchfork* good. gooooood | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [9, 45] | 1448777252015992844 | 39607761 | geddski | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1448894109716922373 | swyx 33521530 | 2021-10-15T06:10:49+00:00 | @ASpittel ALI HAVE YOU TRIED `GH PR CHECKOUT` IT IS AMAZING | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [10, 59] | 1448752696371015681 | 3092104835 | ASpittel | 0 | 0 | 17 | 0 | 0 | en | ||||||||
1448894705912086540 | swyx 33521530 | 2021-10-15T06:13:11+00:00 | @shanselman he DOES have beautiful hair you speak no lies | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [12, 57] | 1448778431110389760 | 5676102 | shanselman | 0 | 0 | 23 | 0 | 0 | en | ||||||||
1448895918518898690 | swyx 33521530 | 2021-10-15T06:18:00+00:00 | @rickhanlonii - step three: look up to the skies | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [14, 48] | 1448801459278073859 | 244965762 | rickhanlonii | 0 | 0 | 4 | 0 | 0 | en | ||||||||
1448896200132812801 | swyx 33521530 | 2021-10-15T06:19:07+00:00 | @MarkLeuchter i feel like @david_perell would have something to say to your students! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [14, 85] | 1448429055557218309 | 1315999090925281280 | MarkLeuchter | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1448896630153904131 | swyx 33521530 | 2021-10-15T06:20:50+00:00 | @geoffreylitt blue green refactor | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [14, 33] | 1448768703185788930 | 221658618 | geoffreylitt | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1449012418621833227 | swyx 33521530 | 2021-10-15T14:00:56+00:00 | @boop seriously i JUST quit my AWS job in Feb and y’all are making me think i missed out on the crazy hot hiring market | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [6, 119] | 1448829597764636675 | 14782048 | boop | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1449013481580105732 | swyx 33521530 | 2021-10-15T14:05:10+00:00 | This became my second conference talk ever, given at @forwardJS way back when! just linking up the talk video https://twitter.com/mweststrate/status/1108746837685501953 | 1108746837685501953 1108746837685501953 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 109] | 1330494937486397440 | 33521530 | swyx | 1 | 0 | 2 | 0 | 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 | ||||||
1449013954345259011 | swyx 33521530 | 2021-10-15T14:07:02+00:00 | @tlakomy you wouldnt want me to be familiar with your entire body | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [9, 65] | 1448978911422042118 | 1903060381 | tlakomy | 0 | 0 | 8 | 0 | 0 | en | ||||||||
1449014942493917187 | swyx 33521530 | 2021-10-15T14:10:58+00:00 | @levelsio i feel like people who voted for #2 have no idea how attractive @stolinski is when he busts a move https://twitter.com/swyx/status/1449014942493917187/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [10, 108] | 1448927903635279875 | 1577241403 | levelsio | 0 | 0 | 13 | 0 | 0 | 0 | en | |||||||
1449142794988048386 | swyx 33521530 | 2021-10-15T22:39:00+00:00 | @rothgar it isnt over yet we are still presenting our last talk!! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [9, 65] | 1449140640479002629 | 14361975 | rothgar | 0 | 0 | 3 | 0 | 0 | en | ||||||||
1449143399659892736 | swyx 33521530 | 2021-10-15T22:41:24+00:00 | @jkup @Cloudflare ah love it when good ideas get great execution https://twitter.com/netlify/status/1115638145725403136?s=21 | 1115638145725403136 1115638145725403136 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [18, 88] | 1448790326215389190 | 255634108 | jkup | 1 | 0 | 5 | 0 | 0 | 0 | en | ||||||
1449162952251043842 | swyx 33521530 | 2021-10-15T23:59:06+00:00 | @masylum @sugarpirate_ every release somehow 70% faster than the last | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [23, 69] | 1449153824539783169 | 2475601 | masylum | 0 | 0 | 6 | 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]);