tweets

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

6 rows where "created_at" is on date 2021-08-17, favorite_count = 4 and is_quote_status = 0 sorted by lang

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user, retweet_count, retweeted

favorite_count 1 ✖

created_at (date) 1 ✖

  • 2021-08-17 · 6 ✖
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
1427461696734449666 swyx 33521530 2021-08-17T02:46:04+00:00 @MathCrln right, some people really treat 3 as “normal” and others wont give anything less than a 5, need to give guidelines to norm everyone. then again theyd probably ignore it unless you make it in-your-face       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [10, 212] 1427459133419229189 369219338 MathCrln       0 0 4 0 0   en  
1427466290923409410 swyx 33521530 2021-08-17T03:04:19+00:00 @mike_hasarms @Daniel0x6019 whats in my mind https://twitter.com/swyx/status/1427466290923409410/photo/1       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [28, 44] 1427465581293309953 123131219 mike_hasarms       0 0 4 0 0 0 en  
1427669027913015300 swyx 33521530 2021-08-17T16:29:55+00:00 @andrewingram @_philpl i have historically underestimated how crazy things can get but my sense is this would not be feasible given how Apollo relies on interop with the rest of the GraphQL ecosystem. More likely that they define a proprietary superset, which effectively each vendor needs to do anyway.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [23, 303] 1427667480139403265 9164512 andrewingram       0 0 4 0 0   en  
1427673244358774786 Jamund Ferguson 119903601 2021-08-17T16:46:40+00:00 Been learning more about dev-rel lately and this article from @swyx was incredible! https://www.swyx.io/measuring-devrel       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 107]             0 2 4 0 1 0 en  
1427775806223257600 swyx 33521530 2021-08-17T23:34:13+00:00 @clemmihai and doing it so well 👏 you make it look easy even tho i know it couldnt be easy. come so far from your @fullstack days!       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [11, 130] 1427732369876807687 4796832195 clemmihai       0 0 4 0 0   en  
1427776791762984967 swyx 33521530 2021-08-17T23:38:08+00:00 @EugeneNg_VCap ambition and vision is good and all but i really wish he had talked about serving customers or community instead of being so fixated on valuation. down that path lies a lot of corpses of companies ruined by giant egos putting money over people.       Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 0 [15, 259] 1427734201017589763 915576521129041920 EugeneNg_VCap       0 0 4 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]);