tweets

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

9 rows where favorite_count = 45 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, retweet_count, retweeted

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
1349271110492196870 swyx 33521530 2021-01-13T08:24:35+00:00 @krtierney @mipsytipsy I collect questions as a hobby. one of my dreams is to build a search engine for better questions instead of better answers. we have too many answers. we're not being trained to ask the right questions.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [23, 226] 1349270238399905793 33521530 swyx       0 5 45 0 0   en  
1360316059987808256 swyx 33521530 2021-02-12T19:53:16+00:00 🆕 quick post: The Simple Magic of Prefixed URLs https://dev.to/swyx/the-simple-magic-of-prefixed-urls-46l1 It's amazing that you can enhance the open web by just accepting URLs and doing something interesting with it!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 184]             0 6 45 0 0 0 en  
1424801181973434380 swyx 33521530 2021-08-09T18:34:07+00:00 @emailisgood @chriscoyier positive examples that do not involve lying to users as your first interaction https://twitter.com/swyx/status/1424801181973434380/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [26, 104] 1424795734201839616 990633912425738241 emailisgood       0 3 45 0 0 0 en  
1433117669591433216 swyx 33521530 2021-09-01T17:20:53+00:00 This is why I also dislike the term “self taught” - it diminishes the hard work of docs writers, bloggers, YouTubers, and community volunteers who pave the way for you without expecting anything in return. No dev is an island.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 227] 1433117668156928004 33521530 swyx       0 5 45 0 0   en  
1452871438826807297 swyx 33521530 2021-10-26T05:35:18+00:00 holy shit, answered in 6 minutes, thanks to anonymous DM answer https://stackoverflow.com/a/50537414/1106414       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 88] 1452869503876956161 33521530 swyx       0 2 45 0 0 0 en  
1457887975115612164 Chris DiBona 44423 2021-11-09T01:49:14+00:00 Hey, I did a thing. I'm about to hate listen to myself and be super judgemental. Gotta lance that boil! It's the only way to get better..... https://twitter.com/thenewstack/status/1457830540011245572       Twitter for Android f0976f342215a984184a13a54b26877ece8cebba 0 [0, 140]             1 5 45 0 0 0 en  
1462113564429361156 Svelte Society 🧡 1176969867733479424 2021-11-20T17:40:13+00:00 🏔 #SvelteSummit is happening now! Make sure you don't miss it! Catch it live 📺👇 http://youtu.be/1Df-9EKvZr0 16 talks from all over the world!👇🤯       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [0, 142]             0 13 45 1 1 0 en  
1462132521139937286 Gen Ashley 32330308 2021-11-20T18:55:32+00:00 Great to see people IRL here at #SvelteSummit Watch Party in Brooklyn - @AdamRackis @swyx @BrittneyPostma @SvelteSociety @SvelteSirens @sveltejs #javascript #typescript #webdev #webdevelopment #sveltejs #svelte #womenintech https://twitter.com/coderinheels/status/1462132521139937286/photo/1       Twitter for Android f0976f342215a984184a13a54b26877ece8cebba 0 [0, 225]             0 14 45 1 1 0 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  

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