tweets

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

4 rows where "created_at" is on date 2021-09-12 and favorite_count = 2 sorted by lang descending

✎ View and edit SQL

This data as json, CSV (advanced)

is_quote_status 1 ✖

  • 0 4

favorite_count 1 ✖

created_at (date) 1 ✖

  • 2021-09-12 · 4 ✖
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
1437025662603341829 swyx 33521530 2021-09-12T12:09:51+00:00 @simonw @pradyunsg to me, that is @anacondainc - i know it has its drawbacks, but it’s so nice living in Anaconda’s world. I’m unclear about how the larger Python community feels about it (similar to how Apollo dominates GraphQL) but they’ve certainly done a better job than anyone else i know       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [19, 293] 1436728586669477894 12497 simonw       0 0 2 0 0   en  
1437115127006912514 swyx 33521530 2021-09-12T18:05:21+00:00 @simonplend lol wow that is such amateur hour. thanks! will need to fix. i dont really like convertkit tbh. think i need to switch to revue.       TweetDeck 9335de48b3673c3f69433a34861c115d1d382be3 0 [12, 140] 1437114001851359235 34583 simonplend       0 0 2 0 0   en  
1437116007026499587 swyx 33521530 2021-09-12T18:08:51+00:00 @KennethCassel @reactjs ironic that your more secure calls are done clientside, whereas general calls are serverside. not what i would have expected! i'd love to read an analysis of RLS vs other authz methods you considered, i'm not well versed enough to decide       TweetDeck 9335de48b3673c3f69433a34861c115d1d382be3 0 [24, 262] 1437113888093442050 1319269656264409088 KennethCassel       0 0 2 0 0   en  
1437120500594003968 swyx 33521530 2021-09-12T18:26:42+00:00 @gusfune @reactjs "kill" is a tricky word.. i really mean "abstract over", but its less of a punchy title tbh       TweetDeck 9335de48b3673c3f69433a34861c115d1d382be3 0 [18, 109] 1437119299014037508 15359622 gusfune       0 0 2 0 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]);