tweets
12 rows where "created_at" is on date 2021-10-25 and retweet_count = 0 sorted by lang
This data as json, CSV (advanced)
Suggested facets: in_reply_to_user_id, in_reply_to_screen_name, favorite_count, lang
source 2 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1452436475430064135 | swyx 33521530 | 2021-10-25T00:46:55+00:00 | @acemarke @ProvablyFlarnie ya basically. and my impression was you had to self host mastodon, and switch between networks, which is probably not true but by then i had lost interest | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [27, 181] | 1452358332392644614 | 727704217012604928 | acemarke | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1452487403889836036 | swyx 33521530 | 2021-10-25T04:09:17+00:00 | @xjamundx it was pretty rad! altho honestly i felt like they skimmed over the unbalanced brackets bit and that was the hard part in my eyes | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [10, 139] | 1452468628771643396 | 119903601 | xjamundx | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1452487937694658566 | swyx 33521530 | 2021-10-25T04:11:24+00:00 | @acemarke yes and love you for that! 🔥 i think there’s an unsolved “part two” which is the “okay you want to be an artist and play an infinite game, how do you get paid to do it” and i feel like the creator/crypto economy is unfortunately the best answer humanity has come up with | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [10, 280] | 1452475566863626249 | 727704217012604928 | acemarke | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1452521988291903492 | swyx 33521530 | 2021-10-25T06:26:43+00:00 | @leereilly congrats! page not found... can someone restore it?! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [11, 63] | 1452311303196921861 | 26900242 | leereilly | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1452522488022200328 | swyx 33521530 | 2021-10-25T06:28:42+00:00 | @triptych @Netlify yay! if you want >1% of power i did an "overview" tutorial here a couple years ago: https://www.youtube.com/watch?v=mT5siI19gtc and its only added functionality since then! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [19, 174] | 1452305754208231440 | 811530 | triptych | 0 | 0 | 4 | 0 | 0 | 0 | en | |||||||
1452704978934505476 | swyx 33521530 | 2021-10-25T18:33:51+00:00 | @PeerReynders @jensimmons 🔥 thanks for the shoutout! yes absolutely applies here. altho i regret the wordiness of the phrasing haha | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [26, 131] | 1452704118229848066 | 4624048794 | PeerReynders | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1452711199913635840 | swyx 33521530 | 2021-10-25T18:58:34+00:00 | @jh3yy @reactjs very nice!! for the audio whimsy you may want use-sound from @JoshWComeau https://www.joshwcomeau.com/react/announcing-use-sound-react-hook/ | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [16, 113] | 1452709779885932546 | 2396811776 | jh3yy | 0 | 0 | 5 | 0 | 0 | 0 | en | |||||||
1452717511087046657 | swyx 33521530 | 2021-10-25T19:23:39+00:00 | @threepointone *takes long sip of water* | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [15, 40] | 1452693953493487617 | 1593171 | threepointone | 0 | 0 | 3 | 0 | 0 | en | ||||||||
1452772078390689792 | swyx 33521530 | 2021-10-25T23:00:29+00:00 | @bramusblog ha thanks Bramus! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [12, 29] | 1452770915662635011 | 380852968 | bramusblog | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1452775662570274823 | swyx 33521530 | 2021-10-25T23:14:43+00:00 | @threepointone when video sir | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [15, 29] | 1451580547461963776 | 1593171 | threepointone | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1452782685504491521 | swyx 33521530 | 2021-10-25T23:42:38+00:00 | @noahsussman @sophaskins hey @kentcdodds this story is exactly on point for your "Dont Solve Problems" talk | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [25, 107] | 1310951946690465792 | 6331142 | noahsussman | 0 | 0 | 5 | 0 | 0 | en | ||||||||
1452717725353066496 | swyx 33521530 | 2021-10-25T19:24:30+00:00 | @ricmac @jquery @m_gol @jeresig @simonw @tlakomy | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [40, 48] | 1452692657151508480 | 105895323 | ricmac | 0 | 0 | 1 | 0 | 0 | und |
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]);