tweets
12 rows where retweet_count = 11 and source = "1f89d6a41b1505a3071169f8d0d028ba9ad6f952" sorted by coordinates
This data as json, CSV (advanced)
Suggested facets: user, favorite_count, retweeted
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||||||||||
| 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 | |||||||||||
| 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 | ||||||||||
| 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 |
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]);