tweets
19 rows where "created_at" is on date 2021-09-01 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20" sorted by lang
This data as json, CSV (advanced)
Suggested facets: user, in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1432895757812518914 | swyx 33521530 | 2021-09-01T02:39:05+00:00 | @preetster brb raising 5m on 50 post | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [11, 36] | 1432894058821656577 | 16343912 | preetster | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1432898918589763587 | swyx 33521530 | 2021-09-01T02:51:38+00:00 | @beyang YES. PLEASE. ESP IF IT LETS ME SEARCH WITHIN FOLDERS URGH | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [8, 65] | 1432894718266986499 | 16520821 | beyang | 0 | 0 | 7 | 0 | 0 | en | ||||||||
1432899310635544578 | swyx 33521530 | 2021-09-01T02:53:12+00:00 | @lesliecdubs @jamstackconf ong this looks AMAZING, kudos whoever coded this up! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [27, 79] | 1432860023475118082 | 22217773 | lesliecdubs | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1432901153931464707 | swyx 33521530 | 2021-09-01T03:00:31+00:00 | @shaundai @netflix @burgessdryan holy crap, that’s amazing!!!!! congrats to you AND ryan AND netflix!!!! wow 🤩 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [33, 110] | 1432728448062132224 | 1004483816 | shaundai | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1432901738923651074 | swyx 33521530 | 2021-09-01T03:02:51+00:00 | @willjohnsonio @GatsbyJS one of the very best parts of tech networking is seeing friends glow up in their own way and knowing you have that special bond because you knew each other before they “made it”! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [25, 203] | 1432753753992663044 | 917069583097397248 | willjohnsonio | 0 | 0 | 5 | 0 | 0 | en | ||||||||
1432902144139558917 | swyx 33521530 | 2021-09-01T03:04:27+00:00 | @mitchellh @JordiMonPMM if you’re interested i made an alternative query builder UI for Twitter: https://bettertwitter.netlify.app/ | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [24, 120] | 1432769589516009472 | 12819682 | mitchellh | 0 | 0 | 8 | 0 | 0 | 0 | en | |||||||
1432902470418661381 | swyx 33521530 | 2021-09-01T03:05:45+00:00 | @oldmanuk @mitchellh i made an alternative twitter query builder UI as well, in case this question comes up again in future https://bettertwitter.netlify.app/ | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [21, 148] | 1432813730690179073 | 7969342 | oldmanuk | 0 | 1 | 7 | 0 | 0 | 0 | en | |||||||
1432906359121403904 | swyx 33521530 | 2021-09-01T03:21:12+00:00 | @_SreetamDas @lesliecdubs @jamstackconf @zachleat ah nice! was talking more about the ogimage “badge” but literally everyone on Zach’s team is top shelf | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [50, 152] | 1432904504488259584 | 520276345 | _SreetamDas | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1432906565804199944 | swyx 33521530 | 2021-09-01T03:22:02+00:00 | @paulbiggar @buildsghost @darklang i see the @edith_h influence haha | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [35, 68] | 1432905149308153860 | 86938585 | paulbiggar | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1432909493805981699 | Beyang Liu 16520821 | 2021-09-01T03:33:40+00:00 | It’s time to speak the truth plainly: @github code search is terrible and the dev world deserves so much better. If you believe this is true, then I invite you to try @sourcegraph. You’ll never look back—I promise. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 214] | 0 | 30 | 241 | 0 | 1 | en | |||||||||||
1432945962255728640 | swyx 33521530 | 2021-09-01T05:58:34+00:00 | @umanagineer 2007 here! there were so many golden opportunities i slept right through 😂 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 87] | 1432942187524681734 | 938901720016363520 | umachingunde | 0 | 0 | 3 | 0 | 0 | en | ||||||||
1432963851780177932 | swyx 33521530 | 2021-09-01T07:09:40+00:00 | @embano1 @eoinbrazil @joe_hellerstein oh wow. thank you for sharing this!!! will take a while to go through 👀 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [38, 109] | 1432961975462637568 | 122923515 | embano1 | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1433107396839100420 | swyx 33521530 | 2021-09-01T16:40:03+00:00 | this was the post: https://twitter.com/swyx/status/1432864028842356736?s=21 | 1432864028842356736 1432864028842356736 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 42] | 1432602694758273025 | 33521530 | swyx | 1 | 0 | 2 | 0 | 0 | 0 | en | ||||||
1433107445996392448 | swyx 33521530 | 2021-09-01T16:40:15+00:00 | @ArNazeh this! https://twitter.com/swyx/status/1432864028842356736 | 1432864028842356736 1432864028842356736 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [9, 14] | 1432608901430657027 | 176229420 | ArNazeh | 1 | 0 | 0 | 0 | 0 | 0 | en | ||||||
1433111522230734850 | swyx 33521530 | 2021-09-01T16:56:27+00:00 | @3rdGenNuke 100% was channeling that quote! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [12, 43] | 1433017373066469376 | 367845362 | 3rdGenNuke | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1433117668156928004 | swyx 33521530 | 2021-09-01T17:20:52+00:00 | This is not to say that if you can’t figure it out, it’s not your fault: we are tremendously bad at documenting our code, and documenting our journeys. Seek out your dev community for help, and remember how this feels when its your turn to see newer devs struggling. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 267] | 1432977957388120064 | 33521530 | swyx | 0 | 1 | 8 | 0 | 0 | en | ||||||||
1433117669591433216 | swyx 33521530 | 2021-09-01T17:20:53+00:00 | This is why I also dislike the term “self taught” - it diminishes the hard work of docs writers, bloggers, YouTubers, and community volunteers who pave the way for you without expecting anything in return. No dev is an island. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 227] | 1433117668156928004 | 33521530 | swyx | 0 | 5 | 45 | 0 | 0 | en | ||||||||
1433123612899229698 | swyx 33521530 | 2021-09-01T17:44:30+00:00 | @flybayer @blitz_js @rudiyardley hot take: those people never needed graphql in the first place 🤷♂️ but congrats 🎉 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [33, 115] | 1433087810320355339 | 2826554209 | flybayer | 0 | 0 | 14 | 0 | 0 | en | ||||||||
1432886704667447296 | swyx 33521530 | 2021-09-01T02:03:06+00:00 | @secos https://youtu.be/BzAdXyPYKQo | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [7, 30] | 1432879787840782343 | 14494227 | secos | 0 | 0 | 3 | 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]);