tweets
142 rows where is_quote_status = 0 and lang = "und" sorted by lang
This data as json, CSV (advanced)
created_at (date) 24 ✖
- 2021-12-07 6
- 2021-12-24 4
- 2021-11-23 3
- 2021-12-03 3
- 2021-11-18 2
- 2021-12-01 2
- 2021-12-10 2
- 2021-12-11 2
- 2021-12-18 2
- 2021-12-19 2
- 2021-11-14 1
- 2021-11-16 1
- 2021-11-17 1
- 2021-11-21 1
- 2021-11-26 1
- 2021-11-28 1
- 2021-11-30 1
- 2021-12-02 1
- 2021-12-04 1
- 2021-12-05 1
- 2021-12-20 1
- 2021-12-21 1
- 2021-12-25 1
- 2021-12-26 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||
1461113510927077380 | swyx 33521530 | 2021-11-17T23:26:21+00:00 | @_jayphelps @Netlify https://twitter.com/swyx/status/1461113510927077380/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [20, 20] | 1271518329526779904 | 29961025 | _jayphelps | 0 | 0 | 3 | 0 | 0 | 0 | und | |||||||
1461399254950318080 | swyx 33521530 | 2021-11-18T18:21:48+00:00 | @supabase https://twitter.com/swyx/status/1461399254950318080/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [9, 9] | 1461396811315298313 | 1219566488325017602 | supabase | 0 | 0 | 8 | 0 | 0 | 0 | und | |||||||
1461458923425185792 | swyx 33521530 | 2021-11-18T22:18:54+00:00 | @andrewingram https://www.youtube.com/watch?v=vDp-08uNH0Y | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [14, 37] | 1461448407126528009 | 9164512 | andrewingram | 0 | 0 | 1 | 0 | 0 | 0 | und | |||||||
1462318808950054916 | swyx 33521530 | 2021-11-21T07:15:47+00:00 | @jasonlaster11 https://twitter.com/swyx/status/1462318808950054916/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [14, 14] | 1462298784595996673 | 312750384 | jasonlaster11 | 0 | 0 | 6 | 0 | 0 | 0 | und | |||||||
1462993642839101440 | swyx 33521530 | 2021-11-23T03:57:20+00:00 | @jkup @threepointone https://github.com/sw-yx/technical-artists | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [21, 44] | 1462853649424605186 | 255634108 | jkup | 0 | 0 | 4 | 0 | 0 | 0 | und | |||||||
1463029177150369795 | swyx 33521530 | 2021-11-23T06:18:32+00:00 | @auchenberg @oxidecomputer | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [12, 26] | 1463009800535433222 | 14810761 | auchenberg | 0 | 0 | 3 | 0 | 0 | und | ||||||||
1463258218193305602 | swyx 33521530 | 2021-11-23T21:28:39+00:00 | @tlakomy @eggheadio jquery gRPC on GCP | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [20, 38] | 1463257480566390788 | 1903060381 | tlakomy | 0 | 1 | 6 | 0 | 0 | und | ||||||||
1464071770143698997 | Zilla Saldana 25393058 | 2021-11-26T03:21:25+00:00 | https://twitter.com/kyonzilllla/status/1464071770143698997/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 0] | 0 | 19798 | 106492 | 1 | 1 | 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 | |||||||
1466139598812188674 | swyx 33521530 | 2021-12-01T20:18:14+00:00 | @acdlite https://twitter.com/swyx/status/1466139598812188674/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [8, 8] | 1466137489337466880 | 21782915 | acdlite | 0 | 0 | 10 | 0 | 0 | 0 | und | |||||||
1466203212977885189 | swyx 33521530 | 2021-12-02T00:31:01+00:00 | @statelyai https://twitter.com/swyx/status/1466203212977885189/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [10, 10] | 1466069029966295041 | 1214951331942850562 | statelyai | 0 | 0 | 2 | 0 | 0 | 0 | und | |||||||
1466652061802516481 | swyx 33521530 | 2021-12-03T06:14:35+00:00 | @jasonlaster11 🚀 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [15, 16] | 1466647442523258881 | 312750384 | jasonlaster11 | 0 | 0 | 1 | 0 | 0 | und | ||||||||
1466654853506088960 | swyx 33521530 | 2021-12-03T06:25:40+00:00 | @pacman326 ty! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [11, 14] | 1466653894046588937 | 28897143 | pacman326 | 0 | 0 | 1 | 0 | 0 | und | ||||||||
1466836389765402624 | swyx 33521530 | 2021-12-03T18:27:02+00:00 | @markdalgleish https://twitter.com/swyx/status/1466836389765402624/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [14, 14] | 1466623507165417473 | 257765996 | markdalgleish | 0 | 0 | 4 | 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 | ||||||||
1467417453815013377 | swyx 33521530 | 2021-12-05T08:55:58+00:00 | @BrittneyPostma @SvelteSirens 🔥 🔥🔥🔥 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [30, 35] | 1467136805560631297 | 36686876 | BrittneyPostma | 0 | 0 | 3 | 0 | 0 | und | ||||||||
1468087567358648320 | swyx 33521530 | 2021-12-07T05:18:46+00:00 | @acemarke @sarah_edo https://twitter.com/swyx/status/1468087567358648320/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [20, 20] | 1468066773752811520 | 727704217012604928 | acemarke | 0 | 3 | 92 | 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 | ||||||||
1468156519808131075 | swyx 33521530 | 2021-12-07T09:52:46+00:00 | @jakobgreenfeld ☠️ | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [16, 18] | 1468155042813419520 | 1285142519525892098 | jakobgreenfeld | 0 | 0 | 1 | 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 | |||||||
1468159004132052992 | swyx 33521530 | 2021-12-07T10:02:38+00:00 | @jakobgreenfeld https://twitter.com/swyx/status/1468159004132052992/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [15, 15] | 1468154599290949638 | 1285142519525892098 | jakobgreenfeld | 0 | 0 | 2 | 0 | 0 | 0 | und | |||||||
1468188704120336385 | swyx 33521530 | 2021-12-07T12:00:39+00:00 | @THyasser1 https://twitter.com/swyx/status/1468188704120336385/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [10, 10] | 1468188083246047234 | 876463068653510656 | THyasser1 | 0 | 0 | 3 | 0 | 0 | 0 | und | |||||||
1469137533250387970 | swyx 33521530 | 2021-12-10T02:50:57+00:00 | @PierreNick @onlydole @armon @HashiCorp https://slate.com/human-interest/2015/02/jony-ives-motivational-poster-from-gfda-on-his-office-wall-in-the-apple-design-studio.amp https://twitter.com/swyx/status/1469137533250387970/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [40, 63] | 1469017792003383300 | 5676562 | PierreNick | 0 | 0 | 1 | 0 | 0 | 0 | und | |||||||
1469183195375562752 | swyx 33521530 | 2021-12-10T05:52:24+00:00 | @bdougieYO http://github.com/sw-yx :) | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [11, 37] | 1467928190416932864 | 111217362 | bdougieYO | 0 | 0 | 4 | 0 | 0 | 0 | und | |||||||
1469612074665869317 | swyx 33521530 | 2021-12-11T10:16:37+00:00 | @nikhilshisode #SEO | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [15, 19] | 1469612012061659136 | 3184015729 | nikhilshisode | 0 | 0 | 1 | 0 | 0 | und | ||||||||
1469727686826160128 | swyx 33521530 | 2021-12-11T17:56:01+00:00 | @nickytonline @tanoaksam 🔥 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [25, 26] | 1469716799306489863 | 425485945 | nickytonline | 0 | 0 | 1 | 0 | 0 | und | ||||||||
1472140930627284992 | swyx 33521530 | 2021-12-18T09:45:23+00:00 | @docusaurus 👏 👏👏👏 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [12, 17] | 1468938703854841856 | 894986942638546944 | docusaurus | 0 | 0 | 1 | 0 | 0 | und | ||||||||
1472230116281491464 | ∆V🌻 890230529659949056 | 2021-12-18T15:39:47+00:00 | https://twitter.com/solarpunkgirl/status/1472230116281491464/video/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 0] | 0 | 456 | 2370 | 1 | 1 | 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 | |||||||||
1472626052656603137 | swyx 33521530 | 2021-12-19T17:53:05+00:00 | @anthonycook https://youtu.be/M6S8MMI9lko | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 36] | 1472583261964668941 | 1435674938313170944 | anthonycook | 0 | 0 | 1 | 0 | 0 | 0 | und | |||||||
1472731566732414979 | Brian Sowards 15054324 | 2021-12-20T00:52:22+00:00 | https://www.swyx.io/api-economy/ | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 23] | 0 | 0 | 3 | 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 | ||||||||
1474297110598422530 | swyx 33521530 | 2021-12-24T08:33:16+00:00 | @mxstbr @calcsam @magicbell_io @ClerkDev @liveblocks #MaxStack | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [53, 62] | 1474295510777409536 | 2451223458 | mxstbr | 0 | 0 | 3 | 0 | 0 | und | ||||||||
1474433436400033794 | swyx 33521530 | 2021-12-24T17:34:59+00:00 | @vcarl_ 🔥 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [8, 9] | 1474373249848983592 | 72621018 | vcarl_ | 0 | 0 | 1 | 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 | ||||||||
1474628922004623360 | swyx 33521530 | 2021-12-25T06:31:46+00:00 | @ken_wheeler https://twitter.com/swyx/status/1474628922004623360/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [12, 12] | 1474394277077831686 | 167193309 | ken_wheeler | 0 | 0 | 4 | 0 | 0 | 0 | und | |||||||
1475149420962656256 | swyx 33521530 | 2021-12-26T17:00:03+00:00 | @missingfaktor https://en.wikipedia.org/wiki/Real_options_valuation | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [15, 38] | 1475139372458647562 | 56127471 | missingfaktor | 0 | 0 | 1 | 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]);