tweets
2 rows where source = "1f89d6a41b1505a3071169f8d0d028ba9ad6f952" and user = 1331053779341348864 sorted by lang
This data as json, CSV (advanced)
created_at (date) 2 ✖
- 2021-10-08 1
- 2021-11-29 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1446268135078699012 | Common Room 1331053779341348864 | 2021-10-08T00:16:08+00:00 | It's @swyx! Head of Developer Experience at @temporalio and tech meetup connoisseur. We asked Shawn everything from his favorite part of working in community (it's an "infinite game") to advice he'd give now, and none of the answers disappoint. https://www.commonroom.io/uncommon/blog/the-rise-of-the-community-leader-meet-shawn-wang/?utm_medium=social&utm_source=twitter&utm_campaign=TL&utm_content=rise-of-the-community-leader | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 269] | 0 | 5 | 18 | 0 | 1 | 0 | en | ||||||||||
1465442383294652420 | Common Room 1331053779341348864 | 2021-11-29T22:07:45+00:00 | It's time! Welcome to the 13 Days of Community, a two-week adventure celebrating our favorite content covering growth, engagement, and all the good bits in between. Up first? DevRel expert @swyx, of course, talking "Why You Should Get Good at Events" 🔥 https://www.commonroom.io/uncommon/blog/community-heat/ | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 277] | 1465069236188024847 | 1331053779341348864 | CommonRoomHQ | 0 | 1 | 2 | 1 | 1 | 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]);