tweets
10 rows where "created_at" is on date 2021-09-30, source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20" and user = 33521530
This data as json, CSV (advanced)
Suggested facets: in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, favorite_count, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1443437632067813377 | swyx 33521530 | 2021-09-30T04:48:43+00:00 | @geddski join us, we need you, it would be helluva lot of fun https://twitter.com/swyx/status/1440389897336938502?s=21 | 1440389897336938502 1440389897336938502 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [9, 86] | 1443225300901507075 | 39607761 | geddski | 1 | 0 | 4 | 0 | 0 | 0 | en | ||||||
| 1443448964737486848 | swyx 33521530 | 2021-09-30T05:33:45+00:00 | @TheEhsanSarshar it would break the comparison with the poll i did last year which is the main point of asking again this year :) 1 year ago nobody was considering anything but btc | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [17, 180] | 1443448568996581376 | 1269951243272806401 | TheEhsanSarshar | 0 | 0 | 3 | 0 | 0 | en | ||||||||
| 1443449499817447427 | swyx 33521530 | 2021-09-30T05:35:53+00:00 | @dabit3 @jkup nader’s magic internet money is no more real than my pretend shares in startup equity, respect (actually arguably more real since he can sell it whenever he wants and i have to wait for exit, however, another way to look at it, i have legally enforced diamond hands) | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [14, 281] | 1443448390671650816 | 17189394 | dabit3 | 0 | 0 | 9 | 0 | 0 | en | ||||||||
| 1443449763555209218 | swyx 33521530 | 2021-09-30T05:36:56+00:00 | @kpk @jkup defaults matter bc people are lazy :) also fiat-crypto conversion is a nonzero cost it would be a no for both of you and thats ok! just wanted to see the year on year shift | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [11, 184] | 1443448951047217152 | 22915745 | kpk | 0 | 0 | 1 | 0 | 0 | en | ||||||||
| 1443450015280615427 | swyx 33521530 | 2021-09-30T05:37:56+00:00 | @jcsrb oof. how much has that accountant cost you so far? | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [7, 57] | 1443449777027489792 | 35193525 | jcsrb | 0 | 0 | 1 | 0 | 0 | en | ||||||||
| 1443597354322460676 | swyx 33521530 | 2021-09-30T15:23:24+00:00 | @venikunche @webflow @canva @Netlify @temporalio here’s my blogpost about it! https://twitter.com/swyx/status/1417165270641045505 | 1417165270641045505 1417165270641045505 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [49, 77] | 1443591935025942528 | 297102985 | venikunche | 1 | 0 | 1 | 0 | 0 | 0 | en | ||||||
| 1443598625867644938 | swyx 33521530 | 2021-09-30T15:28:27+00:00 | @venikunche @webflow @canva @Netlify @temporalio haha thank you! 😇 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [49, 66] | 1443598155308847116 | 297102985 | venikunche | 0 | 0 | 1 | 0 | 0 | en | ||||||||
| 1443603816247529473 | swyx 33521530 | 2021-09-30T15:49:05+00:00 | @Swizec @webflow @canva @Netlify @temporalio i tried to answer here, let me know if helps or something not clear https://twitter.com/swyx/status/1438939235801653249?s=21 | 1438939235801653249 1438939235801653249 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [45, 137] | 1443601072602243072 | 15353121 | Swizec | 1 | 0 | 0 | 0 | 0 | 0 | en | ||||||
| 1443604241927397379 | swyx 33521530 | 2021-09-30T15:50:46+00:00 | @mxstbr @webflow @canva @Netlify @temporalio @GraphCDN CDNs are an interesting thing to pitch. i think about Cloudflare: come for the performance, stay for the security. the closer you can tune to “painkiller” problems over “vitamin” the better | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [55, 245] | 1443592026491027468 | 2451223458 | mxstbr | 0 | 0 | 4 | 0 | 0 | en | ||||||||
| 1443662436419047424 | swyx 33521530 | 2021-09-30T19:42:01+00:00 | @ByrneHobart @sriramk “Persona uncertainty tax” or “Focus dividend” | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [22, 67] | 1443651110279987205 | 2723411 | ByrneHobart | 0 | 0 | 2 | 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]);