tweets
20 rows where retweet_count = 11 sorted by coordinates
This data as json, CSV (advanced)
Suggested facets: user, display_text_range, in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, favorite_count, favorited, retweeted, created_at (date)
source 6 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1010677126897504256 | swyx 33521530 | 2018-06-24T00:12:59+00:00 | Ever wondered what the @gatsbyjs bootstrap output means every time you type `gatsby develop`? I went code spelunking today and wrote them up in this gist: 👉🏼 https://gist.github.com/sw-yx/09306ec03df7b4cd8e7469bb74c078fb 👈🏼 there's a lifecycle chart to be made somewhere here but this is the primary sequence. https://twitter.com/swyx/status/1010677126897504256/photo/1 | Twitter Web Client 887710c0899816dfe9fb0176eb05d760cbe15732 | 0 | [0, 273] | 0 | 11 | 72 | 0 | 0 | 0 | en | ||||||||||
| 1134311153960534016 | Lee Byron 14904098 | 2019-05-31T04:10:28+00:00 | Super curious to see how this works out. Historically I’ve been very skeptical of schema federation and the costs it incurs on an org, so I’m hoping to learn from the community on what works and doesn’t work from this new attempt. https://twitter.com/apollographql/status/1134086759489384449 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 230] | 1 | 11 | 82 | 0 | 0 | 0 | en | ||||||||||
| 1346652236378566657 | Beyang Liu 16520821 | 2021-01-06T02:58:07+00:00 | Sourcegraph raised a lot of money in 2020 and in 2021, we're putting that to work by investing in features for open-source authors, maintainers, and users. I'd love to hear from folks who have thoughts on how we can better serve open source through our product. Current ideas👇 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 276] | 0 | 11 | 36 | 0 | 0 | en | |||||||||||
| 1431061845947805706 | swyx 33521530 | 2021-08-27T01:11:46+00:00 | Underrated form of wealth: the Bad Idea Budget. You can afford to make bad decisions if: - you admit them fast - you use this information to improve future decisions - you’ve invested in making them cheaply reversible Small & cheap mistakes > Research & high stakes | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 278] | 0 | 11 | 105 | 0 | 0 | en | |||||||||||
| 1434106223721426945 | Svelte Society 🧡 1176969867733479424 | 2021-09-04T10:49:02+00:00 | Svelte Summit Fall 2021 is happening on November 20th! CFPs are open as well! https://twitter.com/kevmodrome/status/1434105682077364224 | 1434105682077364224 1434105682077364224 | Tweetbot for Mac 2d56427825d31a620d10acb51615805f894c90f6 | 0 | [0, 77] | 1 | 11 | 49 | 0 | 1 | 0 | en | |||||||||
| 1434242885893844992 | swyx 33521530 | 2021-09-04T19:52:05+00:00 | RT @SvelteSociety: Svelte Summit Fall 2021 is happening on November 20th! CFPs are open as well! | 1434106223721426945 1434106223721426945 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 96] | 1 | 11 | 0 | 0 | 1 | en | ||||||||||
| 1442926717635477504 | Hassan El Mghari 3246815913 | 2021-09-28T18:58:32+00:00 | Incredibly excited to announce I've joined @vercel as a Developer Advocate! 🎉 I've been so impressed with Vercel as a company and their focus on great developer experience. Can't wait to contribute and help grow the Next.js and Vercel communities! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 250] | 0 | 11 | 489 | 0 | 0 | en | |||||||||||
| 1444725115766415364 | Thunder Nerds ⚡️ 4323721815 | 2021-10-03T18:04:43+00:00 | ⚠️ NEW EPISODE 🧠 Learning in Public with @swyx Watch 👉👉👉 https://buff.ly/3hQoTNf 🎙️ Hosts: @FrederickWeiss, & @AritDeveloper 🔗 #DX #DeveloperExperience @Coding_Career #javascript #LearnInPublic https://twitter.com/thundernerds/status/1444725115766415364/video/1 | Buffer 169a89a27ef3ad2a4af15851e3f6452bfeb0ef67 | 0 | [0, 199] | 0 | 11 | 11 | 0 | 1 | 0 | en | ||||||||||
| 1444758173227700225 | swyx 33521530 | 2021-10-03T20:16:05+00:00 | RT @thundernerds: ⚠️ NEW EPISODE 🧠 Learning in Public with @swyx Watch 👉👉👉 https://buff.ly/3hQoTNf 🎙️ Hosts: @FrederickWeiss, & @AritDeve… | 1444725115766415364 1444725115766415364 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 144] | 0 | 11 | 0 | 0 | 1 | 0 | en | |||||||||
| 1445299225974095877 | swyx 33521530 | 2021-10-05T08:06:02+00:00 | Here's @Spolsky explaining how hard it was to write the Amazon One Click Buy button, because it turned a sync shopping cart experience into an async timer-based model: https://youtu.be/-QqIyICyXbU UX is often improved by async, but infra + complexity means people dont do it.. til now https://twitter.com/swyx/status/1445299225974095877/video/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 1443024483170729989 | 33521530 | swyx | 0 | 11 | 70 | 0 | 0 | 0 | en | |||||||
| 1445373456162381827 | swyx 33521530 | 2021-10-05T13:01:00+00:00 | Live footage of what REALLY happened yesterday (h/t @threehourcoffee) https://twitter.com/swyx/status/1445373456162381827/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 70] | 0 | 11 | 148 | 0 | 0 | 0 | en | ||||||||||
| 1448024106633363456 | swyx 33521530 | 2021-10-12T20:33:44+00:00 | This year I've done a total 180 on open source strategy. Remember Elastic making a fuss with "Amazon: NOT OK"? I was quite persuaded. If MongoDB, Redis, Cockroach, Confluent relicensed and do fine, maybe SSPL just becomes acceptable "open source". Now I think MIT is just fine. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 279] | 0 | 11 | 99 | 0 | 0 | en | |||||||||||
| 1457730231301705730 | Katie Sylor-Miller 23232640 | 2021-11-08T15:22:25+00:00 | Another great Frontend-focused @Etsy @codeascraft blog post for y'all about how we migrated to Typescript by the amazing @technoheads - this was a massive undertaking to roll out and provide training timelines for engineers. https://codeascraft.com/2021/11/08/etsys-journey-to-typescript/ | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 248] | 0 | 11 | 47 | 0 | 0 | 0 | en | ||||||||||
| 1460291937412521997 | Rich Harris 19487837 | 2021-11-15T17:01:43+00:00 | for the @brooklyn_js family, this is taking place at the event space right next to 61 local. this saturday, 12-4pm it's shaping up to be a fun event with good people and i can't wait to hang out with you all IRL https://twitter.com/SvelteSociety/status/1457844600236699648 | 1457844600236699648 1457844600236699648 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 237] | 1 | 11 | 62 | 1 | 1 | 0 | en | |||||||||
| 1460327694801850368 | swyx 33521530 | 2021-11-15T19:23:48+00:00 | RT @Rich_Harris: for the @brooklyn_js family, this is taking place at the event space right next to 61 local. this saturday, 12-4pm it's s… | 1460291937412521997 1460291937412521997 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 1 | 11 | 0 | 1 | 1 | en | ||||||||||
| 1462142750296530956 | Gen Ashley 32330308 | 2021-11-20T19:36:11+00:00 | #SvelteSummit Watch Party in Brooklyn, New York @SvelteSociety @SvelteSirens @sveltejs #svelte #sveltejs #javascript #typescript #webdevelopment https://twitter.com/coderinheels/status/1462142750296530956/video/1 | Twitter for Android f0976f342215a984184a13a54b26877ece8cebba | 0 | [0, 145] | 1462130634835513367 | 32330308 | coderinheels | 0 | 11 | 28 | 1 | 1 | 0 | en | |||||||
| 1462159781855125509 | swyx 33521530 | 2021-11-20T20:43:52+00:00 | RT @coderinheels: #SvelteSummit Watch Party in Brooklyn, New York @SvelteSociety @SvelteSirens @sveltejs #svelte #sveltejs #javascript #ty… | 1462142750296530956 1462142750296530956 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 11 | 0 | 1 | 1 | en | ||||||||||
| 1462323377553694722 | swyx 33521530 | 2021-11-21T07:33:56+00:00 | ✅ #SvelteSummit🏔️ is a wrap! Huge thank you to @Rich_Harris, @kevmodrome, @antony, @coderinheels, @BrittneyPostma, @rauchg, @rts_rob, our speakers, and thousands of developers who joined us today, both online and in person. What a way to celebrate @Sveltejs' fifth birthday! 🎂 https://twitter.com/swyx/status/1462323377553694722/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 278] | 0 | 11 | 138 | 0 | 0 | 0 | en | ||||||||||
| 1465635073319849985 | swyx 33521530 | 2021-11-30T10:53:26+00:00 | @johnspurlock @eastdakota @QuinnyPig just caught up with this now. audibly LOLed at the idea that the cheapest way to get data out of AWS is to sue them and then get it through discovery 😹 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [37, 188] | 1462473358944186370 | 12961272 | johnspurlock | 0 | 11 | 42 | 0 | 0 | en | ||||||||
| 1470791843222753280 | swyx 33521530 | 2021-12-14T16:24:36+00:00 | Everybody making @vercel comparisons to avengers is thinking too small Vercel Class of 2021 looks more like https://twitter.com/swyx/status/1470791843222753280/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 108] | 1470789190417719303 | 33521530 | swyx | 0 | 11 | 158 | 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]);