tweets

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

8 rows where "created_at" is on date 2021-11-14, is_quote_status = 0, retweeted = 0 and source = "1f89d6a41b1505a3071169f8d0d028ba9ad6f952" 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

user 2 ✖

source 1 ✖

  • Twitter Web App · 8 ✖

retweeted 1 ✖

is_quote_status 1 ✖

created_at (date) 1 ✖

  • 2021-11-14 · 8 ✖
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  
1459931369019035649 Shreyas Doshi 2048741 2021-11-14T17:08:57+00:00 A hilarious fact of corporate life is that we prefer smaller meetings, while being quite certain that we should be invited to each and every one of them.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 153]             0 88 1431 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  
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  
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]);