tweets
8 rows where "created_at" is on date 2021-12-21 and possibly_sensitive = 0
This data as json, CSV (advanced)
Suggested facets: user, is_quote_status, retweet_count, favorite_count, favorited, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1473098503169912835 | swyx 33521530 | 2021-12-21T01:10:26+00:00 | Happy 1st anniversary to the React Server Components demo 👀 Never would have imagined how the past year played out, with Shopify running full steam putting them into production, Next.js 12 shipping them in alpha, but Remix/Blitz/Redwood etc taking a more cautious approach. https://twitter.com/swyx/status/1341122002866749440 | 1341122002866749440 1341122002866749440 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 274] | 1 | 0 | 38 | 0 | 0 | 0 | en | |||||||||
| 1473099096601034753 | swyx 33521530 | 2021-12-21T01:12:48+00:00 | @EssentialRandom if you care to go *even further* back, Jeff Barr initially called it "Muck", way back when: https://twitter.com/swyx/status/1374085674005983233 @mjasay can correct me but UHL as a term only came into vogue in the last 5ish years, dont know the exact origin | 1374085674005983233 1374085674005983233 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [17, 246] | 1473097945637552130 | 1069017063111282689 | EssentialRandom | 1 | 0 | 0 | 0 | 0 | 0 | en | ||||||
| 1473192929414070273 | Nina 1354787371494084612 | 2021-12-21T07:25:39+00:00 | Great article by @swyx on the API Economy. I like how he describes the usage of APIs in the following economic terms: "what we're really talking about here is turning fixed costs to variable costs which makes sense for a startup getting off the ground." https://twitter.com/briansowards/status/1472731566732414979 | 1472731566732414979 1472731566732414979 | Twitter for Android f0976f342215a984184a13a54b26877ece8cebba | 0 | [0, 255] | 1 | 2 | 12 | 1 | 1 | 0 | en | |||||||||
| 1473316076893081602 | Coding Career Community 1249002899897647105 | 2021-12-21T15:35:00+00:00 | "The best places to grow are not the places where everything is peachy. It's the places where there's pressure on you to perform, and there is space for your performance to really make an impact." @li_haoyi with some gold career advice on where to work: https://www.lihaoyi.com/post/ReflectingonFourYearsatDatabricks.html https://twitter.com/Coding_Career/status/1473316076893081602/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 278] | 0 | 4 | 17 | 1 | 1 | 0 | en | ||||||||||
| 1473342134891982852 | swyx 33521530 | 2021-12-21T17:18:32+00:00 | @EmmaBostian mental image of swedish boyfriend https://twitter.com/swyx/status/1473342134891982852/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [13, 46] | 1473331804350341129 | 491821358 | EmmaBostian | 0 | 0 | 30 | 0 | 0 | 0 | en | |||||||
| 1473343859279396864 | swyx 33521530 | 2021-12-21T17:25:24+00:00 | @supabase @zernonia fyi getting this error right now https://twitter.com/swyx/status/1473343859279396864/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [20, 52] | 1473322587472244747 | 1219566488325017602 | supabase | 0 | 0 | 1 | 0 | 0 | 0 | en | |||||||
| 1473344467646414849 | swyx 33521530 | 2021-12-21T17:27:49+00:00 | @zernonia @supabase @PostgreSQL nice job!! wondering if you checked out Supabase Workflows for your usecase, instead of using a cronjob? https://supabase.com/blog/2021/04/02/supabase-workflows | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [32, 160] | 1470947865174310919 | 4798109946 | zernonia | 0 | 0 | 1 | 0 | 0 | 0 | en | |||||||
| 1473423312386928640 | swyx 33521530 | 2021-12-21T22:41:07+00:00 | i think there were 2 causes - Descript's offline helpers were eating up craptons of memory, and also i had a large cursor for accessibility https://twitter.com/dolohov/status/1469853240791642113 | 1469853240791642113 1469853240791642113 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 165] | 1466641806007812098 | 33521530 | swyx | 1 | 0 | 3 | 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]);