tweets
11 rows where "created_at" is on date 2021-08-05 and source = "1f89d6a41b1505a3071169f8d0d028ba9ad6f952"
This data as json, CSV (advanced)
Suggested facets: user, display_text_range, retweet_count, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1423301730184269826 | swyx 33521530 | 2021-08-05T15:15:50+00:00 | RT @munificentbob: Today is the day! Crafting Interpreters is available for purchase in print, Kindle, ebook, and PDF! Behold: https://t.co… | 1420758051049459725 1420758051049459725 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 492 | 0 | 0 | 1 | en | ||||||||||
| 1423313808525824000 | ʙɪᴀ 🎄 1338510819743719424 | 2021-08-05T16:03:50+00:00 | Life can be so much wider when you discover a simple fact: Everything around you that you call life was made by people who weren't smarter than you. https://dev.to/swyx/memento-vivere-5eak | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 173] | 0 | 3 | 12 | 0 | 1 | 0 | en | ||||||||||
| 1423326500787408896 | swyx 33521530 | 2021-08-05T16:54:16+00:00 | RT @biantris_: Life can be so much wider when you discover a simple fact: Everything around you that you call life was made by people who w… | 1423313808525824000 1423313808525824000 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 140] | 0 | 3 | 0 | 0 | 1 | en | ||||||||||
| 1423326514393669632 | swyx 33521530 | 2021-08-05T16:54:19+00:00 | @biantris_ thank you! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [11, 21] | 1423314547847409677 | 1338510819743719424 | biantris_ | 0 | 0 | 1 | 0 | 0 | en | ||||||||
| 1423327998556606464 | swyx 33521530 | 2021-08-05T17:00:13+00:00 | *starts startup* "well as you know all the legacy solutions are slow, insecure and expensive" | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 95] | 0 | 2 | 70 | 0 | 0 | en | |||||||||||
| 1423354263686631425 | swyx 33521530 | 2021-08-05T18:44:35+00:00 | Great "You may not need a dropdown" reminder from @erikdkennedy: https://learnui.design/blog/4-rules-intuitive-ux.html Who ever at @Twitter designed Scheduled Tweets should take note of the last one https://twitter.com/swyx/status/1423354263686631425/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 171] | 0 | 34 | 282 | 0 | 0 | 0 | en | ||||||||||
| 1423361516082847747 | swyx 33521530 | 2021-08-05T19:13:24+00:00 | @JustJake thats awful i'm so sorry. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [10, 35] | 1423274062940237824 | 607528502 | JustJake | 0 | 0 | 1 | 0 | 0 | en | ||||||||
| 1423365577091866626 | swyx 33521530 | 2021-08-05T19:29:33+00:00 | @maxlynch i know but i just love the shameless superiority complex of an early stage startup making ~$0 just shitting on stable, moneymaking incumbents while downplaying their own flaws | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [10, 185] | 1423344700640145417 | 15103611 | maxlynch | 0 | 1 | 12 | 0 | 0 | en | ||||||||
| 1423387793175113730 | swyx 33521530 | 2021-08-05T20:57:49+00:00 | Thread of things and tips I ran into as I learn @Figmadesign: | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 61] | 0 | 2 | 40 | 0 | 0 | en | |||||||||||
| 1423388158746451970 | swyx 33521530 | 2021-08-05T20:59:16+00:00 | How to make things float in Figma https://twitter.com/swyx/status/1423388158746451970/video/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 33] | 1423387793175113730 | 33521530 | swyx | 0 | 1 | 27 | 0 | 0 | 0 | en | |||||||
| 1423393466902482944 | swyx 33521530 | 2021-08-05T21:20:22+00:00 | @samseely i just tried it and that didn't work at all, it just switched to the "move canvas" hand. is there some setting that you had or are we talking about the same mode? | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [10, 172] | 1423391229593759747 | 29101388 | samseely | 0 | 0 | 0 | 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]);