tweets

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

15 rows where "created_at" is on date 2021-10-31 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

created_at (date) 1 ✖

  • 2021-10-31 · 15 ✖
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
1454608210917167107 swyx 33521530 2021-10-31T00:36:37+00:00 Trying out @factoriogame for the first time this weekend If you don't hear from me... you'll know its going well https://twitter.com/swyx/status/1454608210917167107/photo/1       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 113]             0 1 108 0 0 0 en  
1454613301736837120 swyx 33521530 2021-10-31T00:56:51+00:00 @factoriogame streaming it actually DM to jump on stream and chat if we know each other https://www.youtube.com/watch?v=kU1feDz0OdI       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [14, 112] 1454608210917167107 33521530 swyx       0 0 3 0 0 0 en  
1454674810487730177 swyx 33521530 2021-10-31T05:01:16+00:00 @jimbolla @factoriogame Jim your tips were ESSENTIAL. wish they had a little more handholding in the tutorial. thanks for the help!!! i bet there's a dependency tree that someone has somewhere...       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [24, 195] 1454636236359061506 19004992 jimbolla       0 0 0 0 0   en  
1454675569174482944 swyx 33521530 2021-10-31T05:04:16+00:00 @ralex1993 @factoriogame i tried to set up some wall mazes for them to pathfind thru and they completely failed lol.. .just attacked the walls... too stupid to fall for clever tricks!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [25, 183] 1454610181183180801 10364832 ralex1993       0 0 0 0 0   en  
1454675632294543361 swyx 33521530 2021-10-31T05:04:31+00:00 @alfred_lua @factoriogame oh no not another one!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [26, 48] 1454611689815433218 1303155157 alfred_lua       0 0 0 0 0   en  
1454675674447286274 swyx 33521530 2021-10-31T05:04:42+00:00 @ericzedd @factoriogame only 4 hours on first try.. not too bad!!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [24, 65] 1454609909807472641 201138895 ericzedd       0 0 0 0 0   en  
1454675771444785154 swyx 33521530 2021-10-31T05:05:05+00:00 @connor_lindsey @factoriogame i went in doubtful but... yeah i love it 😹.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [30, 73] 1454616056371154948 1090798273 connor_lindsey       0 0 1 0 0   en  
1454675881243205632 swyx 33521530 2021-10-31T05:05:31+00:00 @_SreetamDas @factoriogame man, when @jimbolla guided me through my first factory refactor i felt like a new programmer all over again haha       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [27, 139] 1454648971868004359 520276345 _SreetamDas       0 0 3 0 0   en  
1454710611539943424 swyx 33521530 2021-10-31T07:23:31+00:00 Before I attempt the last tutorial I'm checking out a few tips and tricks videos to see what I'm doing suboptimally and there's a LOT! man, tutorial was good but I was doing so much manually that they could've just told me outright... this is the best one https://www.youtube.com/watch?v=zS4YFApM8q4       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 280] 1454613301736837120 33521530 swyx       0 0 3 0 0 0 en  
1454744376165367813 swyx 33521530 2021-10-31T09:37:41+00:00 ok i have some notes and am going live with the last tutorial - this time - far less nooby! https://www.youtube.com/watch?v=PUIn10Josfo       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 116] 1454710611539943424 33521530 swyx       0 0 1 0 0 0 en  
1454871289643032580 swyx 33521530 2021-10-31T18:02:00+00:00 Surprising consensus from the smartest devtools people I talk to: San Francisco is still the place to be. You’d think that this group is the most inclined to remote life and distributed companies. None of them have offices anymore. But enough is IRL they have no hesitation.       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [0, 275]             0 0 36 0 0   en  
1454871936085884934 swyx 33521530 2021-10-31T18:04:34+00:00 @thenodester i mean yeah i get you but also i was feeling extremely unproductive because i didnt know the right keyboard shortcuts and was just clicking in and out of menus!       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [13, 173] 1454720769674539009 45847554 thenodester       0 0 0 0 0   en  
1454875933853159430 swyx 33521530 2021-10-31T18:20:27+00:00 @jimbolla @_SreetamDas @factoriogame thats a nice trick there with the filters for iron ore and the underground belt + filters for coal! super neat! brings up a qtn tho - is it better to smelt at source or at point of consumption? bc you could have the drills directly output into furnaces...       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [37, 293] 1454855818260717575 19004992 jimbolla       0 0 0 0 0   en  
1454885013426561027 swyx 33521530 2021-10-31T18:56:32+00:00 @debnilsur not sure but follow @heavybit and perhaps some YC alum groups? maybe @patrickjwoods or @dzello would know as well       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [11, 124] 1454874181187751945 40419118 debnilsur       0 0 2 0 0   en  
1454885687912644611 swyx 33521530 2021-10-31T18:59:13+00:00 @maxlynch to be fair i am yeah but that just means they walk their talk i've fled SF myself but for sure i had an extreme density of high quality meetings when i visited SF recently. probably could just visit once a quarter but then you miss out on casual "friend group" stuff       Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 0 [10, 277] 1454873541455884298 15103611 maxlynch       0 0 1 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]);