tweets

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

23 rows where "created_at" is on date 2021-10-29 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: is_quote_status, retweet_count, favorite_count, retweeted, lang

created_at (date) 1 ✖

  • 2021-10-29 · 23 ✖
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
1454228901740220421 swyx 33521530 2021-10-29T23:29:23+00:00 @mpocock1 more like SVG rekt width amirite       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [10, 42] 1454221828415795204 346640777 mpocock1       0 0 7 0 0   de  
1453895441569837059 swyx 33521530 2021-10-29T01:24:19+00:00 RIP @Facebook’s twitter account 🔒 https://twitter.com/swyx/status/1453895441569837059/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 33]             0 0 32 0 0 0 en  
1453900479071543305 swyx 33521530 2021-10-29T01:44:21+00:00 @danielbayerlein @kentcdodds @angular fun fact... she grew up and she is lovely! https://www.youtube.com/watch?v=zB2FEttIoTg       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [38, 104] 1453790386464374790 58160689 danielbayerlein       0 0 3 0 0 0 en  
1453930581226450947 swyx 33521530 2021-10-29T03:43:57+00:00 @threepointone @reactjs @temporalio @statelyai @Shopify omg sunil when you wanted to talk about the Meta was this what you meant       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [56, 131] 1439702355553886211 33521530 swyx       0 0 13 0 0   en  
1453937679049977868 swyx 33521530 2021-10-29T04:12:10+00:00 @dcorbacho @NodeConfRemote @matteocollina @jasnell @Cloudflare @threepointone gave it a watch. its nice work but wew there's lots of work left to do!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [78, 149] 1453809388498661378 19149515 dcorbacho       0 1 3 0 0   en  
1454092772177235972 Cloudflare Developers 300637864 2021-10-29T14:28:27+00:00 me in 2020 vs me in 2021 https://twitter.com/CloudflareDev/status/1454092772177235972/photo/1       TweetDeck 9335de48b3673c3f69433a34861c115d1d382be3 0 [0, 24]             0 58 583 0 0 0 en  
1454103068841156609 Supabase 1219566488325017602 2021-10-29T15:09:22+00:00 We're excited to announce that we just raised $30m Series A funding 🙂 Led by Coatue, with participation from some of the best operators in the game 👁️⚡️👁️ Check out our blog post - breaking down the numbers behind the round and whats next for us 👇👇👇 https://supabase.io/blog/2021/10/28/supabase-series-a       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 276]             0 61 695 1 1 0 en  
1454126293943918594 swyx 33521530 2021-10-29T16:41:39+00:00 @Rich_Harris @nytgraphics what a run, Rich. 👏 👏 👏 👏       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [26, 51] 1454088761852276749 19487837 Rich_Harris       0 0 12 0 0   en  
1454133696617869313 swyx 33521530 2021-10-29T17:11:04+00:00 @taniarascia best wrist rest! good for ergonomics       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [13, 49] 1454131881016954882 3580004117 taniarascia       0 0 3 0 0   en  
1454161672449318915 swyx 33521530 2021-10-29T19:02:14+00:00 @rothgar what i wouldnt give for the kubecon sponsor floor to have looked exactly like this       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [9, 91] 1454161147569983490 14361975 rothgar       0 0 3 0 0   en  
1454205465827549188 swyx 33521530 2021-10-29T21:56:15+00:00 Your Halloween name is Spooky + last bug you faced       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 50]             0 0 30 0 0   en  
1454207215267500032 swyx 33521530 2021-10-29T22:03:12+00:00 @DavidKPiano aww thats a cute bug!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [13, 34] 1454206717806403596 992126114 DavidKPiano       0 0 2 0 0   en  
1454208483528626177 swyx 33521530 2021-10-29T22:08:15+00:00 @shaidvck whoa wait does that really happen!? 😱       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [10, 47] 1454208293992165376 14363988 shaidvck       0 0 0 0 0   en  
1454210028374614016 swyx 33521530 2021-10-29T22:14:23+00:00 @KennethCassel well that seems like an easy fix!... i hope       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [15, 58] 1454209766612406275 1319269656264409088 KennethCassel       0 0 1 0 0   en  
1454211652002353158 swyx 33521530 2021-10-29T22:20:50+00:00 Just had a wonderful coaching call with Cristina, strongly recommend for startup folks who may be at an inflection in your career (if you can find a slot 😅) (read up on her before you do: https://www.linkedin.com/in/cristinajcordova/) https://twitter.com/cjc/status/1432467587095359489   1432467587095359489 1432467587095359489   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 213]             1 0 8 0 0 0 en  
1454211768192958467 swyx 33521530 2021-10-29T22:21:18+00:00 @Jennabot5000 all bugs are equally feared in this house no worries       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [14, 66] 1454211279682510856 1293902268979445761 Jennabot5000       0 0 4 0 0   en  
1454212032207618052 swyx 33521530 2021-10-29T22:22:21+00:00 @djwyatt man i really hope that error message spells out what the offending entry is right there in the message or i'm gonna have to send someone my blogpost about doing errors right       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [9, 182] 1454210440452526082 17595855 djwyatt       0 0 3 0 0   en  
1454212219210645504 swyx 33521530 2021-10-29T22:23:05+00:00 @kevinakwok Godwin's Law but wholesome       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [12, 38] 1454210650830426117 169791252 kevinakwok       0 0 1 0 0   en  
1454234168800415755 Cristina Cordova 26895943 2021-10-29T23:50:18+00:00 In joining a startup, you are choosing how to invest your most valuable asset—your time. ⏰ I had a few career chats this afternoon and was asked how I’ve chosen startups to work for. Here’s my answer in hopes it might be helpful to more of you out there🧵     San Francisco 5a110d312052166f Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 256]             0 78 570 1 1   en  
1454234569855553539 swyx 33521530 2021-10-29T23:51:54+00:00 RT @cjc: In joining a startup, you are choosing how to invest your most valuable asset—your time. ⏰ I had a few career chats this afterno… 1454234168800415755 1454234168800415755     Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 140]             0 78 0 1 1   en  
1453894452435513348 swyx 33521530 2021-10-29T01:20:24+00:00 @ReactMiamiConf 👀       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [16, 17] 1453737749450612746 1394306514282848260 ReactMiamiConf       0 0 3 0 0   und  
1454132887058468869 swyx 33521530 2021-10-29T17:07:51+00:00 @loujaybee @andrewbrown 👏👏👏👏👏👏👏👏       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [24, 32] 1454128766666543109 1290693397 loujaybee       0 0 1 0 0   und  
1454208230008053761 swyx 33521530 2021-10-29T22:07:14+00:00 @himynameisdave noooooooo       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [16, 25] 1454207414304079874 2290190784 himynameisdave       0 0 2 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]);