tweets
15 rows where "created_at" is on date 2021-09-09, retweet_count = 0 and retweeted = 0 sorted by lang
This data as json, CSV (advanced)
Suggested facets: in_reply_to_user_id, is_quote_status, favorite_count, lang
in_reply_to_screen_name 12 ✖
- swyx 3
- CraigCav 1
- DannPetty 1
- GeoffreyHuntley 1
- TechCrunch 1
- TikTokInvestors 1
- _phosphoricons 1
- danciupuliga 1
- dotproto 1
- dunkhippo33 1
- livelovegeek 1
- millertime802_ 1
source 4 ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1435895069098356736 | swyx 33521530 | 2021-09-09T09:17:16+00:00 | @dunkhippo33 devtools angels! https://twitter.com/swyx/status/1357105644810063873?s=21 | 1357105644810063873 1357105644810063873 | Twitter for iPad 574fe4fa937eeb131136f7e3678f32d4ff3078d5 | 0 | [13, 53] | 1435829987366506496 | 14756283 | dunkhippo33 | 1 | 0 | 2 | 0 | 0 | 0 | de | ||||||
| 1435759393396641798 | swyx 33521530 | 2021-09-09T00:18:09+00:00 | @DotProto @timdorr yeah so lets say ownership has two levels, L1: Account owns Extension (trackable), and L2: Person/Company owns Account (not trackable). You will have notification of L1 ownership changes. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [19, 206] | 1435755027004416002 | 380741910 | dotproto | 0 | 0 | 0 | 0 | 0 | en | ||||||||
| 1435759523722113024 | swyx 33521530 | 2021-09-09T00:18:40+00:00 | @DotProto @timdorr as for L2, basically nothing short of periodic security review and Manifest v3 will do; maybe also crowdsourced (perhaps partnership) with bug bounty providers like @Hacker0x01 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [19, 195] | 1435759393396641798 | 33521530 | swyx | 0 | 0 | 0 | 0 | 0 | en | ||||||||
| 1435768792395681796 | swyx 33521530 | 2021-09-09T00:55:30+00:00 | @DannPetty @designfulltime hey Dann idk if this is still in the 24 hour limit — i assume it has expired — but down here it still says $179! https://twitter.com/swyx/status/1435768792395681796/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [27, 139] | 1435377045404635138 | 22708585 | DannPetty | 0 | 0 | 3 | 0 | 0 | 0 | en | |||||||
| 1435796785323200516 | swyx 33521530 | 2021-09-09T02:46:44+00:00 | @TikTokInvestors he said he was just gonna check the price, ended up levering up at the highs, he done fucked up. intervention time IMO | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [17, 135] | 1435746451347234816 | 1295428909538906115 | TikTokInvestors | 0 | 0 | 2 | 0 | 0 | en | ||||||||
| 1435801439331241987 | swyx 33521530 | 2021-09-09T03:05:13+00:00 | 3/ I’ve handpicked 4 weeks of content, and you can expect about 90 mins/week in total. The interactions are asynchronous, which allows me to answer more of your questions. I’d love for you to join me! https://twitter.com/swyx/status/1435801439331241987/photo/1 | Typefully 295366d0fb34352a1961af2413827f072adefdb9 | 0 | [0, 200] | 1435801433253695491 | 33521530 | swyx | 0 | 0 | 5 | 0 | 0 | 0 | en | |||||||
| 1435801440929427456 | swyx 33521530 | 2021-09-09T03:05:14+00:00 | 4/ I've enjoyed working with Chapter to set this up. @KyleLadewig and @stflory have an admirable mission to make learning more accessible...chapters are 99% cheaper than other premium online cohort based courses. | Typefully 295366d0fb34352a1961af2413827f072adefdb9 | 0 | [0, 212] | 1435801439331241987 | 33521530 | swyx | 0 | 0 | 3 | 0 | 0 | en | ||||||||
| 1435871588495286272 | swyx 33521530 | 2021-09-09T07:43:58+00:00 | @GeoffreyHuntley @gitpod hey Geoff very nice!! i realize you are focused on internal DX, whereas i do external facing DX. quite some overlaps, of course! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [25, 153] | 1435857873620197381 | 14961859 | GeoffreyHuntley | 0 | 0 | 0 | 0 | 0 | en | ||||||||
| 1435970058921066497 | swyx 33521530 | 2021-09-09T14:15:15+00:00 | @CraigCav @koop @jlongster @SlexAxton @stripe whoa amazing!! well deserved, congrats! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [46, 85] | 1435741761255653384 | 70438825 | CraigCav | 0 | 0 | 2 | 0 | 0 | en | ||||||||
| 1435971765000417281 | swyx 33521530 | 2021-09-09T14:22:02+00:00 | @livelovegeek @gurlcode doesnt get enough love for the sheer amount of storytelling work that goes into her talks https://youtu.be/U_ABIfnsVU4 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [14, 137] | 1435725632319606786 | 119275747 | livelovegeek | 0 | 0 | 13 | 0 | 0 | 0 | en | |||||||
| 1435996032748429318 | swyx 33521530 | 2021-09-09T15:58:28+00:00 | @danciupuliga @eggheadio thanks for the shoutout!! i was expecting that this would be super niche (who builds CLIs that often?), but i keep getting nice shoutouts from folks like you that it is really encouraging :) | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [25, 215] | 1435995667516821505 | 12036572 | danciupuliga | 0 | 0 | 1 | 0 | 0 | en | ||||||||
| 1436017409538854913 | swyx 33521530 | 2021-09-09T17:23:25+00:00 | @_phosphoricons @mhevery @QwikDev @InfobipShift here is React saying the opposite: https://twitter.com/acdlite/status/977291318324948992?s=21 the real problem is taking for granted that “X is slow” everywhere in all contexts. performance is relative and conditional. if you arent clear on your assumptions you won’t know when your conclusions are invalid. | 977291318324948992 977291318324948992 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [48, 321] | 1436016082347872257 | 1305300579804119046 | _phosphoricons | 1 | 0 | 3 | 0 | 0 | 0 | en | ||||||
| 1436022859797782528 | swyx 33521530 | 2021-09-09T17:45:04+00:00 | @TechCrunch @supabase @Grg huge congrats team!! still Day 1. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [27, 60] | 1436011709865603075 | 816653 | TechCrunch | 0 | 0 | 8 | 0 | 0 | en | ||||||||
| 1436033040938147843 | swyx 33521530 | 2021-09-09T18:25:31+00:00 | @millertime802_ @VictorPontis @LumaHQ same here. on ios safari. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [38, 63] | 1436021436439842819 | 341898673 | millertime802_ | 0 | 0 | 0 | 0 | 0 | en | ||||||||
| 1435934910125158407 | swyx 33521530 | 2021-09-09T11:55:35+00:00 | gm https://twitter.com/swyx/status/1435934910125158407/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 2] | 0 | 0 | 151 | 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]);