tweets
116 rows where favorite_count = 5 sorted by lang
This data as json, CSV (advanced)
created_at (date) 13 ✖
- 2021-12-07 3
- 2021-12-02 2
- 2021-07-28 1
- 2021-11-14 1
- 2021-11-16 1
- 2021-12-05 1
- 2021-12-09 1
- 2021-12-10 1
- 2021-12-11 1
- 2021-12-12 1
- 2021-12-17 1
- 2021-12-23 1
- 2021-12-26 1
quoted_status 3 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1466501437127495680 | swyx 33521530 | 2021-12-02T20:16:03+00:00 | @ChaiWithJai @kentcdodds oh wow.. my talk is linked in Epic React?? that’s so cool :) i learned so much from Kent in my early days! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [25, 131] | 1466500331760758785 | 896059763129298953 | ChaiWithJai | 0 | 0 | 5 | 0 | 0 | en | ||||||||
| 1466512153691652097 | swyx 33521530 | 2021-12-02T20:58:38+00:00 | @flybayer @kentcdodds look at you fancy fellas wearing pants at all | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [22, 67] | 1466510526889005062 | 2826554209 | flybayer | 0 | 0 | 5 | 0 | 0 | en | ||||||||
| 1467290326578577408 | swyx 33521530 | 2021-12-05T00:30:49+00:00 | @RandallKanna there should be a podcast that expands upon this 😄 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [14, 64] | 1467287803629244416 | 206918128 | RandallKanna | 0 | 0 | 5 | 0 | 0 | en | ||||||||
| 1468035881583853570 | swyx 33521530 | 2021-12-07T01:53:23+00:00 | @DennisCode @Netlify @Box @contentful @onegraph when you integrate OneGraph Studio i will go on campaign tour for you. that shit is magical. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [48, 140] | 1468034987823812613 | 47547933 | DennisCode | 0 | 0 | 5 | 0 | 0 | en | ||||||||
| 1468163148809048069 | swyx 33521530 | 2021-12-07T10:19:06+00:00 | @naz_avo @jakobgreenfeld evidently not true going by gumroad gmv probably more like ppl have caught on that shipping > talking https://twitter.com/swyx/status/1468163148809048069/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [25, 130] | 1468162122387447811 | 1335444805241896961 | naz_avo | 0 | 0 | 5 | 0 | 0 | 0 | en | |||||||
| 1468288839831617540 | swyx 33521530 | 2021-12-07T18:38:33+00:00 | @ardakuyumcu @internetofshit bike stopped working because amazon cloud is down | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [13, 78] | 1468288137281474562 | 181902124 | ardakuyumcu | 0 | 0 | 5 | 0 | 0 | en | ||||||||
| 1468757809437151235 | swyx 33521530 | 2021-12-09T01:42:04+00:00 | @acdlite @trueadm fixins gang represent | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [18, 39] | 1468737891631349761 | 21782915 | acdlite | 0 | 0 | 5 | 0 | 0 | en | ||||||||
| 1469129935373496322 | swyx 33521530 | 2021-12-10T02:20:46+00:00 | @flybayer @Flightcontrolhq check out @budibase - open source retool! (#disclosure: investor. but was really impressed by it) | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [27, 125] | 1469108096152875011 | 2826554209 | flybayer | 0 | 0 | 5 | 0 | 0 | en | ||||||||
| 1469803081206415361 | swyx 33521530 | 2021-12-11T22:55:36+00:00 | @techgirl1908 wouldve loooved to talk to you about joining @temporalio but figured you already had your next thing tied up + you’d be swamped. gotta follow my own rule of thumb here 😱 https://twitter.com/swyx/status/1383101776627331072?s=21 | 1383101776627331072 1383101776627331072 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [14, 209] | 1469354511865196544 | 2932738834 | techgirl1908 | 1 | 0 | 5 | 0 | 0 | 0 | en | ||||||
| 1469861433256992769 | swyx 33521530 | 2021-12-12T02:47:29+00:00 | I have substantial philosophical differences with the way “Twitter Growth” is framed here, but have to give credit to @tdinh_me for actually building a decent iOS app. Excited to take it for a spin! https://twitter.com/tdinh_me/status/1469706551157919746 | 1469706551157919746 1469706551157919746 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 198] | 1462569053420244992 | 33521530 | swyx | 1 | 1 | 5 | 0 | 0 | 0 | en | ||||||
| 1471975416747499528 | swyx 33521530 | 2021-12-17T22:47:41+00:00 | @jamessocol @jasonlaster11 @notdetails Sufficiently advanced fooling about is indistinguishable from genius | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [39, 107] | 1471956603758911504 | 8298342 | jamessocol | 0 | 0 | 5 | 0 | 0 | en | ||||||||
| 1474102328844185600 | swyx 33521530 | 2021-12-23T19:39:17+00:00 | @hayatrachi @threepointone @jevakallio put a mic between then and hit record pls 🙏 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [39, 82] | 1474069459811852291 | 424959867 | hayatrachi | 0 | 0 | 5 | 0 | 0 | en | ||||||||
| 1475138273899323393 | swyx 33521530 | 2021-12-26T16:15:45+00:00 | For those who like economics: High luck industries have a huge amount of deadweight loss from all the people trying their luck (call it search/friction cost). Who's working on better models of industrial organization that more quickly identifies talent and incentivizes work? | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 277] | 1475112373283598346 | 33521530 | swyx | 0 | 0 | 5 | 0 | 0 | en | ||||||||
| 1420433131895623684 | swyx 33521530 | 2021-07-28T17:17:03+00:00 | @TylertheHaas @mark_volkmann @kentcdodds @matiasfha @sergiodxa @goncy @stolinski @LevelUpTuts @sveltejs https://twitter.com/swyx/status/1420211877276049408?s=20 | 1420211877276049408 1420211877276049408 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [104, 127] | 1420429733427257344 | 43845766 | TylertheHaas | 1 | 0 | 5 | 0 | 0 | 0 | und | ||||||
| 1459980833306001410 | swyx 33521530 | 2021-11-14T20:25:30+00:00 | @seldo @typedreamHQ https://twitter.com/swyx/status/1459980833306001410/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [19, 19] | 1459980364781211652 | 15453 | seldo | 0 | 0 | 5 | 0 | 0 | 0 | und | |||||||
| 1460742353509961734 | swyx 33521530 | 2021-11-16T22:51:31+00:00 | @__jrm_filipe https://www.washingtonpost.com/business/2021/11/10/cpi-inflation-october/ | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [14, 37] | 1460741925078810624 | 416590894 | __jrm_filipe | 0 | 0 | 5 | 0 | 0 | 0 | und |
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]);