tweets
5 rows where in_reply_to_screen_name = "kpk" and user = 33521530 sorted by lang
This data as json, CSV (advanced)
Suggested facets: favorite_count, lang
created_at (date) 5 ✖
- 2021-09-15 1
- 2021-09-30 1
- 2021-10-04 1
- 2021-10-14 1
- 2021-11-19 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1438096989653188609 | swyx 33521530 | 2021-09-15T11:06:55+00:00 | @kpk i actually changed my mind on bubble view… tried the list view and it sucked bc of aforementioned list of useless apps… with bubble view at least you can use spatial memory | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [5, 177] | 1437999771852034051 | 22915745 | kpk | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1443449763555209218 | swyx 33521530 | 2021-09-30T05:36:56+00:00 | @kpk @jkup defaults matter bc people are lazy :) also fiat-crypto conversion is a nonzero cost it would be a no for both of you and thats ok! just wanted to see the year on year shift | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [11, 184] | 1443448951047217152 | 22915745 | kpk | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1448706274716123137 | swyx 33521530 | 2021-10-14T17:44:26+00:00 | @kpk love how vocal you are about how things are going. keep it up!! millions of happy daily users, its an awesome seat to be in. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [5, 129] | 1448666579399430150 | 22915745 | kpk | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1461501344540344320 | swyx 33521530 | 2021-11-19T01:07:28+00:00 | @kpk ooh holiday? enjoy! 🏝 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [5, 26] | 1461190455522050054 | 22915745 | kpk | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1445065976454606852 | swyx 33521530 | 2021-10-04T16:39:11+00:00 | @kpk ä | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [5, 6] | 1445062589520629766 | 22915745 | kpk | 0 | 0 | 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]);