tweets
7 rows where retweet_count = 23 and source = "1f89d6a41b1505a3071169f8d0d028ba9ad6f952" sorted by coordinates
This data as json, CSV (advanced)
Suggested facets: user, display_text_range, is_quote_status, retweeted, created_at (date)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1390082681753374723 | Svelte Society 🧡 1176969867733479424 | 2021-05-05T23:15:12+00:00 | Interesting point here: Svelte's ecosystem is larger than React's... if you consider that vanilla JS libraries (e.g. D3) "just work" with Svelte 🎯 https://twitter.com/DanaWoodman/status/1390030682789859329 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 148] | 1 | 23 | 116 | 0 | 0 | 0 | en | ||||||||||
| 1420584976576286722 | kennethcassel.eth 🍊 1319269656264409088 | 2021-07-29T03:20:26+00:00 | I'm building a new course on @SlipApp! If you've ever wanted to go the extra mile and delight your users, If you've ever wanted someone to share your website because the experience made them happy, This is the course for you. I'm calling it "Animated Applications" https://twitter.com/KennethCassel/status/1420584976576286722/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 271] | 0 | 23 | 159 | 0 | 1 | 0 | en | ||||||||||
| 1443026395832127496 | 𝚍𝚊𝚛𝚔𝚜𝚝𝚊𝚛 256053691 | 2021-09-29T01:34:37+00:00 | 6 months of @darkstardao. 12 essays on Web3. In order-- March 1, 2021: A New Media Structure: The Ownership Economy by @jarroddicker @Flynnjamm @patrickxrivera https://darkstar.mirror.xyz/srmoGiN_1pg_toQGzCupkjWFOaf8xi0mM60zYpn_pwI /1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 192] | 0 | 23 | 122 | 0 | 1 | 0 | en | ||||||||||
| 1460519255573766147 | Budibase 1040931421022560256 | 2021-11-16T08:05:00+00:00 | Budibase is live on @ProductHunt 🥳 We've also released a new promo video which you can watch on our Product Hunt post 🎉 Check us out: https://www.producthunt.com/posts/budibase | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 161] | 0 | 23 | 82 | 0 | 0 | 0 | en | ||||||||||
| 1463151477174714373 | Kevin A. K. 37845634 | 2021-11-23T14:24:30+00:00 | Today I'm announcing that going forward I'll be working as the Technical Community Builder at @SvelteSociety. What's it mean?👇 - In-person Svelte Summit conferences🥳 - Regular hangouts on Discord📻 - A refreshed website with up-to-date content📚 - Faster community growth📈 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 271] | 0 | 23 | 352 | 1 | 1 | en | |||||||||||
| 1463166092713635849 | swyx 33521530 | 2021-11-23T15:22:35+00:00 | RT @kevmodrome: Today I'm announcing that going forward I'll be working as the Technical Community Builder at @SvelteSociety. What's it mea… | 1463151477174714373 1463151477174714373 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 23 | 0 | 1 | 1 | en | ||||||||||
| 1474267015334752257 | swyx 33521530 | 2021-12-24T06:33:41+00:00 | Embarrassed to learn about the :target pseudoselector so late in my webdev journey. I've written JS code to implement this exact feature when I could've just #useThePlatform'ed it 🤦🏽♂️ https://twitter.com/css/status/1354887812676546560 https://twitter.com/swyx/status/1474267015334752257/photo/1 | 1354887812676546560 1354887812676546560 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 209] | 1 | 23 | 255 | 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]);