tweets
8 rows where "created_at" is on date 2021-11-29, is_quote_status = 0, retweeted = 0 and source = "1f89d6a41b1505a3071169f8d0d028ba9ad6f952" sorted by lang
This data as json, CSV (advanced)
Suggested facets: retweet_count, favorite_count
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1465230968143237124 | swyx 33521530 | 2021-11-29T08:07:40+00:00 | Every so often I realize someone hasn't tweeted in a while, check their profile and realize they've become disillusioned with social media and just peaced out. On one hand, I'm happy for them. On the other, I miss them. On my third hand, I wonder when it will be my turn. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 274] | 0 | 6 | 133 | 0 | 0 | en | |||||||||||
1465234641820872706 | swyx 33521530 | 2021-11-29T08:22:16+00:00 | @genuinfo and now it's a 🦄. Can't believe this was in Feb. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [10, 58] | 1362145090840391680 | 1223560622828224513 | genuinfo | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1465239261783810050 | swyx 33521530 | 2021-11-29T08:40:37+00:00 | A great brief history of the humble Command Palette here: https://capiche.com/e/consumer-dev-tools-command-palette | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 81] | 1453408357935583234 | 33521530 | swyx | 0 | 4 | 18 | 0 | 0 | 0 | en | |||||||
1465250791392907269 | swyx 33521530 | 2021-11-29T09:26:26+00:00 | @spitleaf @qoouep my idiot overoptimising self wants to set it up with some automation such that it also adds a private discord for "group texting" lol may just wire it up to my reading list and misc blog updates too. just like opt in to "full firehose neurosis swyx" | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [18, 268] | 1465249413031411714 | 357427736 | spitleaf | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1465250913585537033 | swyx 33521530 | 2021-11-29T09:26:55+00:00 | @qoouep @spitleaf i'd -also- love that. i do admire folks like @punk6529 and @orangebook_ | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [18, 89] | 1465250515697033220 | 1350890383 | qoouep | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1465371380233347074 | swyx 33521530 | 2021-11-29T17:25:36+00:00 | @RozenMD thats hot... did you use @CommandBar or were you already rolling your own? | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [9, 83] | 1465266059091615749 | 276480142 | RozenMD | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1465384630920486913 | swyx 33521530 | 2021-11-29T18:18:16+00:00 | @BrittneyPostma nice work Brittney!! will catch up on the full stream in a bit! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [16, 79] | 1465379229470760964 | 36686876 | BrittneyPostma | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1465437074849361923 | swyx 33521530 | 2021-11-29T21:46:39+00:00 | @LeighNeys thanks Leigh! yeah part time isn't easy but it is so rewarding when done well! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [11, 89] | 1465432143375577098 | 1435354155674128391 | LeighNeys | 0 | 0 | 0 | 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]);