tweets

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

11 rows where "created_at" is on date 2021-12-02, 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

source 1 ✖

  • Twitter Web App · 11 ✖

retweeted 1 ✖

is_quote_status 1 ✖

  • 0 11

created_at (date) 1 ✖

  • 2021-12-02 · 11 ✖
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
1466195579822694404 swyx 33521530 2021-12-02T00:00:41+00:00 @ShaneaLeven @jeanqasaur naw salesforce tracks sales just pointing out that this data often integrates faster into salesforce than salesforce integrates into other tools, therefore salesforce de facto is the eventual center of gravity for all CRM data unless of course you use @sgrove's @onegraph 😉       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [25, 300] 1466194337088385025 89629801 ShaneaLeven       0 0 1 0 0   en  
1466198865061707776 swyx 33521530 2021-12-02T00:13:44+00:00 @litcapital instant unfollow for not listening to @TheStalwart and @tracyalloway's Odd Lots       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [12, 91] 1466198086473166852 932630991298007041 litcapital       0 0 9 0 0   en  
1466219481965809664 swyx 33521530 2021-12-02T01:35:40+00:00 @beyang @sourcegraph set some measurable level of "truly mainstream"?       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [21, 69] 1466213645872816128 16520821 beyang       0 0 1 0 0   en  
1466223179643318274 swyx 33521530 2021-12-02T01:50:21+00:00 @ThePracticalDev @pimterry Nov 2021: 141k views, 41k uniques Only one blogpost this month (https://swyx.io/community-heat/), so no surprise at all at the big drop. Twitter also not really doing that great vs my usual. Shipping things took its toll but being honest I also got lazy. YouTube did decent. https://twitter.com/swyx/status/1466223179643318274/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [27, 294] 1455777335014084609 33521530 swyx       0 0 7 0 0 0 en  
1466252159721218080 swyx 33521530 2021-12-02T03:45:31+00:00 @jestrux @argyleink @tailwindcss i basically have a professional crush on the entire Google/Chrome devrel team they are all incredible       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [33, 134] 1466247001884999684 2456069708 jestrux       0 0 5 0 0   en  
1466430577947594762 swyx 33521530 2021-12-02T15:34:29+00:00 @beyang @sourcegraph oh wow, that's a big "and" in there. well... good luck :)       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [21, 78] 1466409946002591744 16520821 beyang       0 0 1 0 0   en  
1466430772349386761 swyx 33521530 2021-12-02T15:35:15+00:00 @julioxavierr @sseraphini haha he has followed me for so long im pretty sure he knows everything i say       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [26, 102] 1466387202632564741 1020795691994697730 julioxavierr       0 0 5 0 0   en  
1466475407826292739 swyx 33521530 2021-12-02T18:32:37+00:00 Our meetup video with our launch and two TS SDK examples from @BDevessier (Temporal + XState) and @abadir_ (Temporal + @FlightControlHQ) is live! https://www.youtube.com/watch?v=GpbOkDjpeYU       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 170] 1463283116030652416 33521530 swyx       0 1 6 0 0 0 en  
1466486286437412873 swyx 33521530 2021-12-02T19:15:51+00:00 @supabase @logflare_logs @chasers wowww congrats both!!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [34, 55] 1466435011666759696 1219566488325017602 supabase       0 0 5 0 0   en  
1466486562145726466 swyx 33521530 2021-12-02T19:16:57+00:00 @supabase @logflare_logs @chasers note to self: make brand color of next startup vivid green       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [34, 92] 1466486286437412873 33521530 swyx       0 0 5 0 0   en  
1466512153691652097 swyx 33521530 2021-12-02T20:58:38+00:00 @flybayer @kentcdodds look at you fancy fellas wearing pants at all       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [22, 67] 1466510526889005062 2826554209 flybayer       0 0 5 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]);