tweets
5 rows where "created_at" is on date 2021-08-31 and retweet_count = 1 sorted by lang
This data as json, CSV (advanced)
Suggested facets: in_reply_to_user_id, in_reply_to_screen_name, is_quote_status
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1432508202050994177 | swyx 33521530 | 2021-08-31T00:59:04+00:00 | Heard some ugly workplace stories today. Lots of things that people can't say out loud, but there's no stronger signal than employees voting with their feet. Departure of any one person isn't concerning, it's the trendline - and whether or not management takes it seriously. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 275] | 0 | 1 | 51 | 0 | 0 | en | |||||||||||
1432583994441297924 | swyx 33521530 | 2021-08-31T06:00:15+00:00 | Added a new question to my @savvycal_ - Can I record our conversation? Stealing a page from @sytses, I want to share as many of my conversations as possible and it's awkward to ask "can I record this" at the start of the convo. This way, open-minded people can opt in. https://twitter.com/swyx/status/1432583994441297924/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 271] | 0 | 1 | 19 | 0 | 0 | 0 | en | ||||||||||
1432598502060675073 | swyx 33521530 | 2021-08-31T06:57:53+00:00 | here's 91 quotes from Warren Buffett, who just turned 91. https://twitter.com/GRDecter/status/1432365846438027276?s=20 This one stuck out given my recent blogpost on devrel metrics: "Games are won by players who focus on the playing field –- not by those whose eyes are glued to the scoreboard." 🎯 | 1432365846438027276 1432365846438027276 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 265] | 1386482851026112515 | 33521530 | swyx | 1 | 1 | 7 | 0 | 0 | 0 | en | ||||||
1432848799353819138 | swyx 33521530 | 2021-08-31T23:32:29+00:00 | @jrhunt “full stack” https://twitter.com/swyx/status/1432848799353819138/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [8, 20] | 1432821139978403845 | 14157064 | jrhunt | 0 | 1 | 85 | 0 | 0 | 0 | en | |||||||
1432848974902284289 | swyx 33521530 | 2021-08-31T23:33:11+00:00 | @jrhunt “full stack #jamstack” https://twitter.com/swyx/status/1432848974902284289/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [8, 30] | 1432848799353819138 | 33521530 | swyx | 0 | 1 | 24 | 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]);