tweets
11 rows where "created_at" is on date 2021-09-25, is_quote_status = 0 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20"
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)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1441569415917678592 | swyx 33521530 | 2021-09-25T01:05:06+00:00 | 🤘🏽 Today’s mixtape clip covers the 6 year formation story of Adam and the Metal Hawks! http://share.transistor.fm/s/56304829 Rock on your weekend everyone! https://twitter.com/AMHband/status/1398777575514771459/video/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 169] | 0 | 2 | 6 | 0 | 0 | 0 | en | ||||||||||
1441578413437841420 | swyx 33521530 | 2021-09-25T01:40:51+00:00 | @Contextify1 @tlakomy @mthenw @cloudashdev ouch wtf | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [43, 51] | 1441567963002261509 | 1032371837974396928 | Contextify1 | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1441597202959421441 | swyx 33521530 | 2021-09-25T02:55:31+00:00 | @monicalimco music. wanna perform in a bar band before i die | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 60] | 1441579301262872581 | 1265436714136297473 | monicalimco | 0 | 0 | 7 | 0 | 0 | en | ||||||||
1441597923771523072 | swyx 33521530 | 2021-09-25T02:58:23+00:00 | @beyang 1. learning how compilers work 2. learning how operating systems work 3. learning how networks work 4. learning how databases work basically all the shit people complain about in cs undergrad becomes very real very fast the second you try to do something nontrivial | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [8, 274] | 1441558898012422146 | 16520821 | beyang | 0 | 1 | 20 | 0 | 0 | en | ||||||||
1441604190472638464 | swyx 33521530 | 2021-09-25T03:23:17+00:00 | @QuinnyPig who ever wrote that needs their twitter access revoked good god | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [11, 74] | 1441399535054376966 | 97114171 | QuinnyPig | 0 | 0 | 5 | 0 | 0 | en | ||||||||
1441605814414766083 | swyx 33521530 | 2021-09-25T03:29:44+00:00 | @dprophecyguy @beyang theyd have to be self interested in learning it which is kind of where i am. but cant begrudge people for taking a 3 month bootcamp, getting a 6 figure job, and considering themselves done learning | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [22, 219] | 1441604919698419712 | 3314336580 | dprophecyguy | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1441606638075404288 | swyx 33521530 | 2021-09-25T03:33:00+00:00 | @boop @ariel_n if i animate scrolling down between your two profile pics its like watching one person bop back and forth | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [15, 120] | 1441591451054325766 | 14782048 | boop | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1441815757847887879 | swyx 33521530 | 2021-09-25T17:23:58+00:00 | @supaspoida @tailwindcss WIP https://github.com/temporalio/samples-node/pull/15 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [25, 52] | 1441803246343843847 | 14205289 | supaspoida | 0 | 0 | 2 | 0 | 0 | 0 | und | |||||||
1441865756187234311 | swyx 33521530 | 2021-09-25T20:42:39+00:00 | @boop @roonmate …shit | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [16, 21] | 1441860697588002818 | 14782048 | boop | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1441869112804839426 | swyx 33521530 | 2021-09-25T20:55:59+00:00 | @sompylasar @tailwindcss html structure had the pre tag in front of the buttons. so space inserted and then the block wrapped around i didnt really set up the demo to be cross scrutinized by 1500 people haha i was just tweeting a quick screenshot of my work in progress | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [25, 270] | 1441868370928812038 | 701571650 | sompylasar | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1441908391211716608 | swyx 33521530 | 2021-09-25T23:32:04+00:00 | @jkup my site is still under construction with over a million visitors per year | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [6, 79] | 1441872380016701440 | 255634108 | jkup | 0 | 0 | 14 | 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]);