tweets
5 rows where "created_at" is on date 2021-08-28 and favorite_count = 2 sorted by contributors
This data as json, CSV (advanced)
Suggested facets: in_reply_to_status_id, in_reply_to_user_id, in_reply_to_screen_name
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1431682207446413313 | swyx 33521530 | 2021-08-28T18:16:52+00:00 | @dan_abramov seems remarkably close to de Bono’s 6 Thinking Hats, in the off chance you havent come across it yet. corny, but effective. I wish more people were aware of ways to shake themselves out of a thinking rut. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 217] | 1431675083442036743 | 70345946 | dan_abramov | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1431682620836958208 | swyx 33521530 | 2021-08-28T18:18:30+00:00 | i guess i should drop the link here: https://www.temporal.io its literally on the front page, we hope to directly anticipate the top 5-6 questions people have. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 161] | 1431399776952610820 | 33521530 | swyx | 0 | 0 | 2 | 0 | 0 | 0 | en | |||||||
1431686864570826753 | Kilian Valkhof 9335882 | 2021-08-28T18:35:22+00:00 | @swyx @temporalio So cool to see. I’ve had this on my backlog for ages, a “Things Polypane is bad at” list*, but several people told me it was a bad look. Might have to rethink this! * badly codes websites. Polypane doesnt work well if your site is garbage. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [18, 258] | 1431399776952610820 | 33521530 | swyx | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1431728032167903237 | swyx 33521530 | 2021-08-28T21:18:57+00:00 | @sheldon_hull @temporalio ive never used Systems Manager! write that post! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [26, 74] | 1431724797269004298 | 247477081 | sheldon_hull | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1431729765879275527 | swyx 33521530 | 2021-08-28T21:25:51+00:00 | @tmcw there’s something about having a heterodox mind that it opens you up both to inconvenient truths and to intriguing lies. Not saying cant have one without the other but theres got to be some correlation. its the un-self-aware, religiously uncritical mind i fear. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [6, 267] | 1431718410841477120 | 1458271 | tmcw | 0 | 0 | 2 | 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]);