tweets
10 rows where "created_at" is on date 2021-08-08 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20" sorted by lang
This data as json, CSV (advanced)
Suggested facets: in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, retweet_count, favorite_count, lang
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1424173432539811845 | swyx 33521530 | 2021-08-08T00:59:40+00:00 | @KentonVarda @DavidKPiano @threepointone @sergeybykov yes i thought very Black Mirror-ey but seems to have caught on | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [54, 116] | 1424170425102307331 | 17459118 | KentonVarda | 0 | 0 | 0 | 0 | 0 | en | ||||||||
| 1424198548720029698 | swyx 33521530 | 2021-08-08T02:39:29+00:00 | useful taxonomy of approaches to naming things: - Functional / Descriptive (BMW) - Invented (eg Agilent) - Experiential (eg Infoseek) - Evocative (eg Uber) With the same note on Apple https://www.igorinternational.com/process/i/Igor-naming-guide-AugustP-1-2021.pdf https://twitter.com/swyx/status/1424198548720029698/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 211] | 1418034673150685185 | 33521530 | swyx | 0 | 0 | 7 | 0 | 0 | 0 | en | |||||||
| 1424199362024931328 | swyx 33521530 | 2021-08-08T02:42:42+00:00 | i really like the “Name Evaluation” and “Happy Idiot” sections of this guide. https://twitter.com/swyx/status/1424198548720029698 https://twitter.com/swyx/status/1424199362024931328/photo/1 | 1424198548720029698 1424198548720029698 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 101] | 1383881255264034820 | 33521530 | swyx | 1 | 0 | 10 | 0 | 0 | 0 | en | ||||||
| 1424275234555715589 | swyx 33521530 | 2021-08-08T07:44:12+00:00 | @FredKSchott instant bucket list addition | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 41] | 1424050022505582595 | 1308732128 | FredKSchott | 0 | 0 | 2 | 0 | 0 | en | ||||||||
| 1424282103127019521 | swyx 33521530 | 2021-08-08T08:11:29+00:00 | @SRuhleder thanks Sebastian :) yeah i try to introduce stuff from my Chinese heritage where i can. Western folks usually enjoy it as they have never heard this stuff that has been around for like 4000 years | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [11, 206] | 1424278395739910145 | 1298880717749997570 | SRuhleder | 0 | 0 | 2 | 0 | 0 | en | ||||||||
| 1424282248396697606 | swyx 33521530 | 2021-08-08T08:12:04+00:00 | @SRuhleder another concept if you are interested https://twitter.com/suolaric/status/1333068794881859585 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [11, 48] | 1424282103127019521 | 33521530 | swyx | 1 | 0 | 1 | 0 | 0 | 0 | en | |||||||
| 1424283657049579523 | swyx 33521530 | 2021-08-08T08:17:40+00:00 | @TikTokInvestors @BillSPACman pet rock was the original nft craze | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [30, 65] | 1424114476169768962 | 1295428909538906115 | TikTokInvestors | 0 | 0 | 0 | 0 | 0 | en | ||||||||
| 1424284656074039296 | swyx 33521530 | 2021-08-08T08:21:38+00:00 | @stephsmithio Otter - live closed captioning + notetaking @excalidraw - collaborative virtual whiteboard @streamyardapp - superimpose banners, highlight comments, stream to other social platforms | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [14, 197] | 1424063610402185219 | 626691391 | stephsmithio | 0 | 0 | 6 | 0 | 0 | en | ||||||||
| 1424310472350654464 | swyx 33521530 | 2021-08-08T10:04:13+00:00 | @simonw tragedy of the critical bug commons: if everyone waits a few weeks before upgrades then the purpose of waiting a few weeks before upgrades is defeated! optimal - round robin upgrades to share bug discovery load? | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [8, 220] | 1424078556406042625 | 12497 | simonw | 0 | 1 | 3 | 0 | 0 | en | ||||||||
| 1424310756678402053 | swyx 33521530 | 2021-08-08T10:05:21+00:00 | @dabit3 @ken_wheeler https://twitter.com/swyx/status/1424310756678402053/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [20, 20] | 1424099739176521735 | 17189394 | dabit3 | 0 | 0 | 0 | 0 | 0 | 0 | und |
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]);