tweets
15 rows where "created_at" is on date 2021-10-31 sorted by lang
This data as json, CSV (advanced)
Suggested facets: in_reply_to_screen_name, retweet_count, favorite_count, created_at (date)
source 1 ✖
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
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]);