tweets
10 rows where "created_at" is on date 2021-09-03 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20" sorted by lang
This data as json, CSV (advanced)
Suggested facets: in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, retweet_count, favorite_count, lang
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1433717372339179521 | swyx 33521530 | 2021-09-03T09:03:53+00:00 | @cassiecodes awww congrats!! everyone looks so happy! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 53] | 1433709515497689113 | 758598429115310080 | cassiecodes | 0 | 0 | 1 | 0 | 0 | en | ||||||||
| 1433717538165198852 | swyx 33521530 | 2021-09-03T09:04:32+00:00 | @ryanchenkie looking a great 35 my dude. we’re the same age! happy birthday!! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 77] | 1433435987443601408 | 30654945 | ryanchenkie | 0 | 0 | 2 | 0 | 0 | en | ||||||||
| 1433718525420470279 | swyx 33521530 | 2021-09-03T09:08:28+00:00 | If you work in Silicon Valley, or in the technology world, and you can explain complex topics / terms in an easy to understand* way, that’s an INSANELY valuable skill. *But don’t gloss over the details! All the good stuff is in the details - develop a keen eye for those! https://twitter.com/BullandBaird/status/1433424538025349120 | 1433424538025349120 1433424538025349120 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 272] | 1 | 2 | 30 | 0 | 0 | 0 | en | |||||||||
| 1433822284435705862 | swyx 33521530 | 2021-09-03T16:00:46+00:00 | @BenAPatton @SvelteSociety @sveltejs yes! all the above https://twitter.com/swyx/status/1221586490674696193 | 1221586490674696193 1221586490674696193 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [37, 55] | 1433792422044110851 | 999866712739676160 | BenAPatton | 1 | 0 | 8 | 0 | 0 | 0 | en | ||||||
| 1433915176776962050 | swyx 33521530 | 2021-09-03T22:09:53+00:00 | @jpsimons DOM has 30 year head start. what evidence of trend are you thinking of? 4 isolated examples? a google flutter demo? | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [10, 125] | 1433913908989874179 | 32165130 | jpsimons | 0 | 0 | 5 | 0 | 0 | en | ||||||||
| 1433918146348343297 | swyx 33521530 | 2021-09-03T22:21:41+00:00 | I think why I struggle with OKRs so much: Suits set them as a system of external control, a way to manage by spreadsheet rather than get hands dirty, defining quality as quantity, when the best work of knowledge workers and creatives comes from doing epic shit for the sake of it. https://twitter.com/petergyang/status/1433807042590875654 | 1433807042590875654 1433807042590875654 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 280] | 1 | 1 | 30 | 0 | 0 | 0 | en | |||||||||
| 1433919002355507201 | swyx 33521530 | 2021-09-03T22:25:05+00:00 | casual reminder that extrinsic motivation isn’t harmless, nice to have, or ignorable. They *actively destroy* intrinsic drive. https://twitter.com/swyx/status/968688836468453376?s=21 | 968688836468453376 968688836468453376 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 151] | 1433918146348343297 | 33521530 | swyx | 1 | 0 | 15 | 0 | 0 | 0 | en | ||||||
| 1433919649075240962 | swyx 33521530 | 2021-09-03T22:27:39+00:00 | @seldo reading this in Werner Herzog voice | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [7, 42] | 1433824330899607552 | 15453 | seldo | 0 | 0 | 12 | 0 | 0 | en | ||||||||
| 1433939106459885570 | swyx 33521530 | 2021-09-03T23:44:58+00:00 | Self Provisioning Runtimes are the “Level 5 Self Driving Cars” of developer platforms. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 86] | 1432864050895994890 | 33521530 | swyx | 0 | 0 | 4 | 0 | 0 | en | ||||||||
| 1433682486106542088 | swyx 33521530 | 2021-09-03T06:45:15+00:00 | 我吃的盐比你吃的饭还要多😱🤯 You could tell who spoke Chinese by the audible gasps in the room. Tony Leung owned every goddamn second he was onscreen in #shangchi https://twitter.com/swyx/status/1433682486106542088/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 149] | 0 | 0 | 14 | 0 | 0 | 0 | zh |
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]);