tweets

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

10 rows where "created_at" is on date 2021-11-14, retweeted = 0, source = "1f89d6a41b1505a3071169f8d0d028ba9ad6f952" and user = 33521530 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, retweet_count, favorite_count, lang

is_quote_status 2 ✖

user 1 ✖

  • swyx · 10 ✖

source 1 ✖

  • Twitter Web App · 10 ✖

created_at (date) 1 ✖

  • 2021-11-14 · 10 ✖
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
1459679612242259981 swyx 33521530 2021-11-14T00:28:33+00:00 Tried to fly @JetBlue because I always liked their marketing and experience, plus JFK is near Brooklyn. But I couldn't. You ever experience a website so extremely bad that you just up and go to their competitor? Hope this is temporary, otherwise, short $JBLU https://twitter.com/swyx/status/1459679612242259981/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 262] 1459667585272713218 33521530 swyx       0 0 3 0 0 0 en  
1459698081688010755 swyx 33521530 2021-11-14T01:41:57+00:00 lol @spacehey replicated MySpace right down to the downtime https://twitter.com/swyx/status/1459698081688010755/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 59] 1459696420160638977 33521530 swyx       0 0 6 0 0 0 en  
1459750702800986115 swyx 33521530 2021-11-14T05:11:03+00:00 @rakyll yes! this is why I was extremely inspired when Sarah implemented product rotations for us at @Netlify. It meant that we literally spent 3 months each year as engineers, not as developer advocates. Huge investment from both eng and DX, was very grateful. https://twitter.com/sarah_edo/status/1346842506722308099   1346842506722308099 1346842506722308099   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [8, 286] 1459640319352344576 10809412 rakyll       1 1 20 0 0 0 en  
1459941287121985539 swyx 33521530 2021-11-14T17:48:21+00:00 @shreyas The "I want to be in the Zoom Where It Happens" to "ugggh I have Zoom fatigue" pipeline       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [9, 96] 1459931369019035649 2048741 shreyas       0 0 5 0 0   en  
1459945207097556994 swyx 33521530 2021-11-14T18:03:56+00:00 @Nutlope @ChrisSamiullah great minds https://twitter.com/david_perell/status/1261851180881174529?s=20   1261851180881174529 1261851180881174529   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [25, 60] 1459932508129222662 3246815913 Nutlope       1 1 6 0 0 0 en  
1459979460397068295 swyx 33521530 2021-11-14T20:20:03+00:00 Super underrated way to level up: 1. Find an industry leader who has more ideas than bandwidth (read: all of them) 2. Do something small for them 3. Do something bigger with them 4. Start something with them 5. Realize you now have more ideas than bandwidth       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 258]             0 36 306 0 0   en  
1459979930041675780 swyx 33521530 2021-11-14T20:21:55+00:00 @seldo nooo justice for figcaption! footer plebs dont understand the beauty of a good figcaption       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [7, 96] 1459960085816360962 15453 seldo       0 0 2 0 0   en  
1459980089878220806 swyx 33521530 2021-11-14T20:22:33+00:00 @seldo i bet you could use @typedreamHQ to scaffold these out real quick, in case you are manually typing these out       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [7, 115] 1459960481754456068 15453 seldo       0 0 0 0 0   en  
1459985522114260993 swyx 33521530 2021-11-14T20:44:08+00:00 In other words: Pick Up What Others Put Down :) https://twitter.com/swyx/status/1212439325104726018   1212439325104726018 1212439325104726018   Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 72] 1459979460397068295 33521530 swyx       1 0 38 0 0 0 en  
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  

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