tweets
11 rows where retweet_count = 23 sorted by coordinates
This data as json, CSV (advanced)
Suggested facets: is_quote_status, favorite_count, retweeted
created_at (date) 7 ✖
- 2021-07-29 2
- 2021-09-29 2
- 2021-11-16 2
- 2021-11-23 2
- 2021-05-05 1
- 2021-12-10 1
- 2021-12-24 1
user 6 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||||||||
1420825810877915136 | swyx 33521530 | 2021-07-29T19:17:25+00:00 | RT @KennethCassel: 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⦠| 1420584976576286722 1420584976576286722 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 139] | 0 | 23 | 0 | 0 | 1 | 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 | ||||||||||
1443046610963865601 | swyx 33521530 | 2021-09-29T02:54:57+00:00 | RT @jarroddicker: 6 months of @darkstardao. 12 essays on Web3. In order-- March 1, 2021: A New Media Structure: The Ownership Economy b⦠| 1443026395832127496 1443026395832127496 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 23 | 0 | 0 | 1 | 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 | ||||||||||
1460736959060451330 | swyx 33521530 | 2021-11-16T22:30:04+00:00 | due to inflation ES6 is now ES2015 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 34] | 0 | 23 | 609 | 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 | ||||||||||
1469212999713845249 | swyx 33521530 | 2021-12-10T07:50:50+00:00 | Imma let you finish but @simonswissβ new Tailwind 3.0 walkthru is one of the best CSS tutorial + major version launches of all time. OF ALL TIME!! https://youtu.be/mSC6GwizOag If you only have 3 minutes skip ahead to the 20:50 mark and check out the arbitrary properties feature π€― | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 277] | 0 | 23 | 147 | 0 | 0 | 0 | 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]);