tweets

This is data scraped from swyx's timeline! See blog post

32 rows where favorite_count = 0, lang = "und" and user = 33521530 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source, display_text_range, is_quote_status, retweet_count, favorited, retweeted

user 1 ✖

  • swyx · 32 ✖

lang 1 ✖

  • und · 32 ✖

favorite_count 1 ✖

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
1424310756678402053 swyx 33521530 2021-08-08T10:05:21+00:00 @dabit3 @ken_wheeler https://twitter.com/swyx/status/1424310756678402053/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [20, 20] 1424099739176521735 17189394 dabit3       0 0 0 0 0 0 und  
1425123109032513549 swyx 33521530 2021-08-10T15:53:21+00:00 @chaseadamsio @rothgar @vercel @darklang       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [31, 40] 1425121027562999812 20705255 chaseadamsio       0 0 0 0 0   und  
1426651460901642242 swyx 33521530 2021-08-14T21:06:28+00:00 @theshteves https://knowyourmeme.com/memes/deep-fried-memes       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [12, 35] 1426642548492222465 805074422 theshteves       0 0 0 0 0 0 und  
1428869838991028226 swyx 33521530 2021-08-21T00:01:31+00:00 @sjroot @WaveConnects       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [8, 21] 1428864630093398019 1624166100 sjroot       0 0 0 0 0   und  
1429673075054768130 swyx 33521530 2021-08-23T05:13:17+00:00 @DavidWells 😍       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [12, 13] 1429555410487312389 13638932 DavidWells       0 0 0 0 0   und  
1430018964764069892 swyx 33521530 2021-08-24T04:07:44+00:00 RT @SlamsFist: @SpiderManMovie https://twitter.com/SlamsFist/status/1429981875259514883/photo/1 1429981875259514883 1429981875259514883     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 54]             0 839 0 0 1 0 und  
1432796518281453570 swyx 33521530 2021-08-31T20:04:44+00:00 @CntrvaslDev it's @temporalio ! https://twitter.com/swyx/status/1417165270641045505   1417165270641045505 1417165270641045505   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [13, 56] 1432791593396936704 930727203876364289 CntrvaslDev       1 0 0 0 0 0 und  
1433173897646645259 swyx 33521530 2021-09-01T21:04:18+00:00 @whatwind101 gm       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [13, 15] 1433146824047611904 982927232627822592 whatwind101       0 0 0 0 0   und  
1435182234667978762 swyx 33521530 2021-09-07T10:04:43+00:00 @mattstratton sup       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [14, 17] 1435029345706418182 46113 mattstratton       0 0 0 0 0   und  
1436216892306436096 swyx 33521530 2021-09-10T06:36:05+00:00 @msnegurski https://poets.org/poem/howl-parts-i-ii       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [12, 35] 1436184882309443586 1150317717733425152 msnegurski       0 0 0 0 0 0 und  
1439749000505307136 swyx 33521530 2021-09-20T00:31:25+00:00 @JU4NMEND0Z4 yes       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [13, 16] 1439740986045829129 822755599775432704 JU4NMEND0Z4       0 0 0 0 0   und  
1440333166284140553 swyx 33521530 2021-09-21T15:12:41+00:00 @AdamTuttle @WorkingCodePod 🎉       Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 0 [28, 29] 1440310595283079172 9686352 AdamTuttle       0 0 0 0 0   und  
1441635007899049992 swyx 33521530 2021-09-25T05:25:44+00:00 @flyin1501 @tailwindcss yes       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [24, 27] 1441631459865874439 2684994602 flyin1501       0 0 0 0 0   und  
1443315520749510658 swyx 33521530 2021-09-29T20:43:30+00:00 @tylermcginnis @_jayphelps few       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [27, 30] 1443313666024112132 380724965 tylermcginnis       0 0 0 0 0   und  
1443648184400502785 swyx 33521530 2021-09-30T18:45:23+00:00 @analyseian @wongmjane @SlackHQ hmm... https://twitter.com/search?q=slack%20down&src=typed_query       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [32, 62] 1443645544879075336 1017496907013394432 analyseian       0 0 0 0 0 0 und  
1444097579331964928 swyx 33521530 2021-10-02T00:31:07+00:00 @searls @testdouble @hashrockettil @thoughtbot @atomicobject 🙏 😹       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [61, 64] 1444095095721152513 9038902 searls       0 0 0 0 0   und  
1445065976454606852 swyx 33521530 2021-10-04T16:39:11+00:00 @kpk ä       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [5, 6] 1445062589520629766 22915745 kpk       0 0 0 0 0   und  
1448827354306867200 swyx 33521530 2021-10-15T01:45:33+00:00 @RobAWilkinson @ken_wheeler https://youtu.be/3_ee6aZObyI       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [28, 51] 1448782623212462080 2496511 RobAWilkinson       0 0 0 0 0 0 und  
1451316964408774659 swyx 33521530 2021-10-21T22:38:23+00:00 @coreyhainesco @usepunchlist http://temporal.io       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [29, 52] 1451209196435755015 2480319486 coreyhainesco       0 0 0 0 0 0 und  
1455760420719906817 swyx 33521530 2021-11-03T04:55:05+00:00 @Swizec 🔥 🔥 🔥       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [8, 13] 1455758906697793544 15353121 Swizec       0 0 0 0 0   und  
1464847686792716294 swyx 33521530 2021-11-28T06:44:38+00:00 RT @kyonzilllla: https://twitter.com/kyonzilllla/status/1464071770143698997/photo/1 1464071770143698997 1464071770143698997     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 40]             0 19798 0 1 1 0 und  
1465500077426835463 swyx 33521530 2021-11-30T01:57:00+00:00 @baggerholder1 -60% :sus: https://twitter.com/swyx/status/1465500077426835463/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [15, 25] 1402152638087536653 1391625634611224578 baggerholder1       0 0 0 0 0 0 und  
1465887910662606850 swyx 33521530 2021-12-01T03:38:07+00:00 @mschoening https://news.ycombinator.com/item?id=13426494       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [12, 35] 1465783958835277837 14239565 mschoening       0 0 0 0 0 0 und  
1467213782787117056 swyx 33521530 2021-12-04T19:26:39+00:00 @manuelalferez @StackOverflow @Reddit 🔥🔥🔥🔥       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [38, 42] 1467172061684854784 900809431377747968 manuelalferez       0 0 0 0 0   und  
1468118101598162946 swyx 33521530 2021-12-07T07:20:06+00:00 @dhaiwat10 🔥       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [11, 12] 1468105564848672771 1025757442594889734 dhaiwat10       0 0 0 0 0   und  
1468157512490700804 swyx 33521530 2021-12-07T09:56:42+00:00 @cherthedev 👋 https://jobs.lever.co/temporal/19d191e0-69bb-4d06-933d-deecb51176a8       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [12, 37] 1468057406601003010 15790639 cherthedev       0 0 0 0 0 0 und  
1472471158926630913 swyx 33521530 2021-12-19T07:37:36+00:00 RT @solarpunkgirl: https://twitter.com/solarpunkgirl/status/1472230116281491464/video/1 1472230116281491464 1472230116281491464     Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 42]             0 456 0 1 1 0 und  
1473026177833275392 swyx 33521530 2021-12-20T20:23:02+00:00 @buildsghost @tmcw https://twitter.com/swyx/status/1142025639744008194   1142025639744008194 1142025639744008194   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [19, 42] 1473025536419004416 1175464650395111424 buildsghost       1 0 0 0 0 0 und  
1473336492575846402 swyx 33521530 2021-12-21T16:56:07+00:00 @jonbretman 💯       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [12, 13] 1473327040568905736 482366126 jonbretman       0 0 0 0 0   und  
1474064373823856643 swyx 33521530 2021-12-23T17:08:28+00:00 @BronGondwana @nick_beauchamp @drewtoothpaste https://twitter.com/nick_beauchamp/status/1473695980604305409   1473695980604305409 1473695980604305409   Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [46, 69] 1473609584514199554 624472937 BronGondwana       1 0 0 0 0 0 und  
1474446755521466368 swyx 33521530 2021-12-24T18:27:55+00:00 @jim_ej @BrandonByars @temporalio 💯       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [34, 35] 1474444594234499072 65615053 jim_ej       0 0 0 0 0   und  
1474447267004174336 swyx 33521530 2021-12-24T18:29:57+00:00 @lewisvrobinson til!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [16, 20] 1474366604368482305 413206572 lewisvrobinson       0 0 0 0 0   und  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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]);