tweets
7 rows where favorite_count = 24, retweeted = 0 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20"
This data as json, CSV (advanced)
Suggested facets: user, in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, retweet_count, created_at (date)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1158920626272268289 | joel ⛈ 12087242 | 2019-08-07T01:59:43+00:00 | @swyx Make 5 millionaires. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [6, 26] | 1158902677289472001 | 33521530 | swyx | 0 | 1 | 24 | 0 | 0 | en | ||||||||
| 1420211877276049408 | swyx 33521530 | 2021-07-28T02:37:52+00:00 | @matiasfha @Rich_Harris @stolinski @gndx Svelte also has one way data flow under the hood, but uses binding and syntax sugar to simulate LOCAL two way data flow. its not that different. data propagation with stores vs context however are very different. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [41, 255] | 1420201456108441603 | 12816182 | matiasfha | 0 | 2 | 24 | 0 | 0 | en | ||||||||
| 1424953927426928646 | swyx 33521530 | 2021-08-10T04:41:05+00:00 | @moretothat’s unification of the power and money divides into a single bell curve dimension is indirectly an incredible rebuttal of the Michael Scott Theory of Social Class - arguing FOR being peak Michael Scott! https://twitter.com/alex_danco/status/1352701338833072135?s=21 https://twitter.com/swyx/status/1424953927426928646/photo/1 | 1352701338833072135 1352701338833072135 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 237] | 1424951893864816644 | 33521530 | swyx | 1 | 4 | 24 | 0 | 0 | 0 | en | ||||||
| 1427794159520256002 | swyx 33521530 | 2021-08-18T00:47:09+00:00 | I’ve been wearing fitness trackers for years. First night of wearing it, my $229 @fitbit Versa 3 did this to my hand. also music controls were just buggy (pause, cant restart). watchface doesnt activate when i raise my hand. headed back in for the $329 Apple Watch. https://twitter.com/swyx/status/1427794159520256002/video/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 267] | 1427792224859746305 | 33521530 | swyx | 0 | 0 | 24 | 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 | |||||||
| 1445494914150662157 | swyx 33521530 | 2021-10-05T21:03:38+00:00 | @threepointone imagine being in middle management 😂 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [15, 51] | 1445475178054488072 | 1593171 | threepointone | 0 | 1 | 24 | 0 | 0 | en | ||||||||
| 1464843618670104576 | swyx 33521530 | 2021-11-28T06:28:28+00:00 | @rishmishra @eyemightbewrong is this trickle down economics? | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [29, 60] | 1464729220618371080 | 331639736 | rishmishra | 0 | 0 | 24 | 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]);