twitter: tweets: 14 rows where "created_at" is on date 2021-10-31 and retweet

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

14 rows where "created_at" is on date 2021-10-31 and retweet_count = 0

Search:

descending

id ▼	user	created_at	full_text	source	display_text_range	in_reply_to_status_id	in_reply_to_user_id	in_reply_to_screen_name	favorite_count	possibly_sensitive	lang
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	[14, 112]	1454608210917167107	33521530	swyx	3	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	[24, 195]	1454636236359061506	19004992	jimbolla	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	[25, 183]	1454610181183180801	10364832	ralex1993	0		en
1454675632294543361	swyx 33521530	2021-10-31T05:04:31+00:00	@alfred_lua @factoriogame oh no not another one!	Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952	[26, 48]	1454611689815433218	1303155157	alfred_lua	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	[24, 65]	1454609909807472641	201138895	ericzedd	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	[30, 73]	1454616056371154948	1090798273	connor_lindsey	1		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	[27, 139]	1454648971868004359	520276345	_SreetamDas	3		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, 280]	1454613301736837120	33521530	swyx	3	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, 116]	1454710611539943424	33521530	swyx	1	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, 275]				36		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	[13, 173]	1454720769674539009	45847554	thenodester	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	[37, 293]	1454855818260717575	19004992	jimbolla	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	[11, 124]	1454874181187751945	40419118	debnilsur	2		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	[10, 277]	1454873541455884298	15103611	maxlynch	1		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]);