tweets
16 rows where favorited = 1 and retweet_count = 5
This data as json, CSV (advanced)
Suggested facets: display_text_range, is_quote_status, favorite_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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1453546267116703745 | emnul.eth 1379874346005635074 | 2021-10-28T02:16:50+00:00 | Every single software team with a SDK needs to watch this video by @swyx . Wow!! So many insights. https://youtu.be/ddKDPikKbNk | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 122] | 0 | 5 | 10 | 1 | 1 | 0 | en | ||||||||||
| 1453644616461271041 | swyx 33521530 | 2021-10-28T08:47:38+00:00 | RT @emanuel__sol: Every single software team with a SDK needs to watch this video by @swyx . Wow!! So many insights. https://youtu.be/ddKDPikKbNk | 1453546267116703745 1453546267116703745 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 5 | 0 | 1 | 1 | 0 | en | |||||||||
| 1455955781317132295 | Lucas Minter 1215752268160499712 | 2021-11-03T17:51:23+00:00 | @swyx has inspired me to make a public commitment: Next Friday, I'm going to kick off a book club with friends. We are going to read the @Coding_Career Handbook. We will meet once a week over zoom to discuss our takeaways. If anyone wants to join, send me a dm. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 264] | 33521530 | swyx | 0 | 5 | 25 | 1 | 1 | en | |||||||||
| 1455957502697213956 | swyx 33521530 | 2021-11-03T17:58:13+00:00 | RT @LucasMinter2: @swyx has inspired me to make a public commitment: Next Friday, I'm going to kick off a book club with friends. We are g… | 1455955781317132295 1455955781317132295 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 5 | 0 | 1 | 1 | en | ||||||||||
| 1456712851104559105 | swyx 33521530 | 2021-11-05T19:59:42+00:00 | I had a wonderful time talking through this blogpost with @adamstac and @jerodsanto on The Changelog! Life achievement unlocked ✅ https://twitter.com/changelog/status/1456689893694976006?s=20 | 1456689893694976006 1456689893694976006 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 154] | 1326558340541939712 | 33521530 | swyx | 1 | 5 | 20 | 1 | 1 | 0 | en | ||||||
| 1457037645570199555 | swyx 33521530 | 2021-11-06T17:30:19+00:00 | RT @swyx: I had a wonderful time talking through this blogpost with @adamstac and @jerodsanto on The Changelog! Life achievement unlocked ✅… | 1456712851104559105 1456712851104559105 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 1 | 5 | 0 | 1 | 1 | en | ||||||||||
| 1462123847390576648 | JR Beaudoin 948563334 | 2021-11-20T18:21:04+00:00 | Sveltception! @rauchg bragging about hiring @Rich_Harris and how they are changing the internet. Very happy to attend #SvelteSummit Watch live: http://youtu.be/1Df-9EKvZr0 https://twitter.com/jiherr/status/1462123847390576648/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 170] | 0 | 5 | 93 | 1 | 1 | 0 | en | ||||||||||
| 1462128802759385098 | swyx 33521530 | 2021-11-20T18:40:46+00:00 | RT @jiherr: Sveltception! @rauchg bragging about hiring @Rich_Harris and how they are changing the internet. Very happy to attend #Svelte… | 1462123847390576648 1462123847390576648 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 5 | 0 | 1 | 1 | en | ||||||||||
| 1462208114753691648 | Gen Ashley 32330308 | 2021-11-20T23:55:55+00:00 | Lots of fun earlier at the #SvelteSummit Watch Party New York! @SvelteSociety @SvelteSirens @sveltejs #svelte #sveltejs #webdev #webdevelopment https://twitter.com/coderinheels/status/1462208114753691648/video/1 | Twitter for Android f0976f342215a984184a13a54b26877ece8cebba | 0 | [0, 144] | 0 | 5 | 35 | 1 | 1 | 0 | en | ||||||||||
| 1462519879857328134 | swyx 33521530 | 2021-11-21T20:34:46+00:00 | RT @coderinheels: Lots of fun earlier at the #SvelteSummit Watch Party New York! @SvelteSociety @SvelteSirens @sveltejs #svelte #sveltejs… | 1462208114753691648 1462208114753691648 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 139] | 0 | 5 | 0 | 1 | 1 | en | ||||||||||
| 1466473939543199756 | Temporal 1204202807298969600 | 2021-12-02T18:26:47+00:00 | Our monthly meetup recording is up! Featuring: - Temporalite @Datadog - Temporal @TypeScript SDK - Temporal + XState @BDevessier @StatelyAI - Building @FlightControlHQ with Temporal! @abadir_ A packed hour of fun and distributed systems! https://youtu.be/GpbOkDjpeYU | Agorapulse app 86e9766d5e36b5847fe04f82904117b15d8fde9c | 0 | [0, 263] | 0 | 5 | 26 | 1 | 1 | 0 | en | ||||||||||
| 1466475039054708737 | swyx 33521530 | 2021-12-02T18:31:09+00:00 | RT @temporalio: Our monthly meetup recording is up! Featuring: - Temporalite @Datadog - Temporal @TypeScript SDK - Temporal + XState @BDev… | 1466473939543199756 1466473939543199756 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 5 | 0 | 1 | 1 | en | ||||||||||
| 1467343720936792071 | Mark Erikson 727704217012604928 | 2021-12-05T04:02:59+00:00 | I'm not a frequent podcast listener, but I am _loving_ these deep-dive discussions that Swyx is recording. Great guests, thorough discussion of meaningful topics, and some really good insight into the state of our industry. https://twitter.com/swyx/status/1467304180003917824 | 1467304180003917824 1467304180003917824 | TweetDeck 9335de48b3673c3f69433a34861c115d1d382be3 | 0 | [0, 223] | 1 | 5 | 45 | 1 | 1 | 0 | en | |||||||||
| 1467347814686416898 | swyx 33521530 | 2021-12-05T04:19:15+00:00 | RT @acemarke: I'm not a frequent podcast listener, but I am _loving_ these deep-dive discussions that Swyx is recording. Great guests, thor… | 1467343720936792071 1467343720936792071 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 1 | 5 | 0 | 1 | 1 | en | ||||||||||
| 1467947006911864832 | Jason Laster 312750384 | 2021-12-06T20:00:14+00:00 | http://Replay.io just shipped a new Outline View that can easily show ~50k functions in a file 🚀 If you’re looking to add a print statement in a file, the Outline View is your friend! 1/3 https://twitter.com/jasonlaster11/status/1467947006911864832/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 196] | 0 | 5 | 73 | 1 | 1 | 0 | en | ||||||||||
| 1467958083007565826 | swyx 33521530 | 2021-12-06T20:44:14+00:00 | RT @jasonlaster11: http://Replay.io just shipped a new Outline View that can easily show ~50k functions in a file 🚀 If you’re looki… | 1467947006911864832 1467947006911864832 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 5 | 0 | 1 | 1 | 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]);