tweets
17 rows where "created_at" is on date 2021-08-18 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20" sorted by lang
This data as json, CSV (advanced)
Suggested facets: user, display_text_range, in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, retweet_count, retweeted, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1427787386080034823 | swyx 33521530 | 2021-08-18T00:20:14+00:00 | @clemmihai @fullstack podcast is still cached in some services if you ever need it! i think i offered it to David to take it over when i left but no momentum on their end | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [22, 170] | 1427786239378223107 | 4796832195 | clemmihai | 0 | 0 | 2 | 0 | 0 | en | ||||||||
1427791147728920576 | swyx 33521530 | 2021-08-18T00:35:11+00:00 | @BrantApps @Hicksyfern @JustEatUK hmm so.. was the 6th star a failure? is it still in place today? | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [34, 98] | 1427790695960559624 | 345246419 | BrantApps | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1427792224859746305 | swyx 33521530 | 2021-08-18T00:39:28+00:00 | There’s a significant “it just works” premium built into everything from Apple. Every time I try to leave the Apple ecosystem in some way the thesis is invariably some version of “you get the same for less”. Every time I crawl back to Apple because the extra $ is worth it. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 275] | 0 | 7 | 155 | 0 | 0 | en | |||||||||||
1427792566922010626 | swyx 33521530 | 2021-08-18T00:40:49+00:00 | @BrantApps @Hicksyfern @JustEatUK add one star per year, simple | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [34, 63] | 1427792321970638850 | 345246419 | BrantApps | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1427794159520256002 | swyx 33521530 | 2021-08-18T00:47:09+00:00 | I’ve been wearing fitness trackers for years. First night of wearing it, my $229 @fitbit Versa 3 did this to my hand. also music controls were just buggy (pause, cant restart). watchface doesnt activate when i raise my hand. headed back in for the $329 Apple Watch. https://twitter.com/swyx/status/1427794159520256002/video/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 267] | 1427792224859746305 | 33521530 | swyx | 0 | 0 | 24 | 0 | 0 | 0 | en | |||||||
1427794789508939778 | swyx 33521530 | 2021-08-18T00:49:39+00:00 | @Swizec @Chris2Brooks but Apple doesnt make webcams? | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [22, 52] | 1427793494857244672 | 15353121 | Swizec | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1427795748842733568 | swyx 33521530 | 2021-08-18T00:53:28+00:00 | @jdeisenberg i was purely on windows til 2015 so there’s a strong familiarity bias there. the one time i tried ubuntu i struggled too much with device drivers and some basic programs i was used to didnt have a Linux port | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 220] | 1427794095825510401 | 14947707 | jdeisenberg | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1427798652018257923 | swyx 33521530 | 2021-08-18T01:05:00+00:00 | @chriscoyier the people who get this spend too much time online and should call their parents more often | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 104] | 1427798104422723591 | 793830 | chriscoyier | 0 | 0 | 12 | 0 | 0 | en | ||||||||
1427810778283794439 | swyx 33521530 | 2021-08-18T01:53:11+00:00 | @taddeusz2002 @AdamRackis there are a surprising amount of iPhone-Android marriages in the replies | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [26, 98] | 1427809121764528130 | 35821019 | taddeusz2002 | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1427866714482429961 | swyx 33521530 | 2021-08-18T05:35:27+00:00 | Snorkel is now a unicorn! https://twitter.com/SnorkelAI/status/1424724444048658436 | 1424724444048658436 1424724444048658436 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 25] | 1417746151411879938 | 33521530 | swyx | 1 | 0 | 2 | 0 | 0 | 0 | en | ||||||
1427871806879199232 | swyx 33521530 | 2021-08-18T05:55:41+00:00 | @tarungangwani tuning in to the recording now but yeah how the heck do you have a Metaverse podcast without the guy who wrote the definitive Metaverse blog series | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [15, 162] | 1423033413213167620 | 23854138 | tarungangwani | 0 | 0 | 0 | 0 | 0 | en | ||||||||
1427909000285200386 | swyx 33521530 | 2021-08-18T08:23:29+00:00 | @avaitla16 what even is the source of this beef? feel like Sam is responding to something i didnt see | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [11, 101] | 1427745539848818688 | 859749975999127552 | avaitla16 | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1427988073292476418 | Emelia 👸🏻 14063149 | 2021-08-18T13:37:42+00:00 | @JessTelford JWTs for external use tend not to solve the problems people think they do; for internal use, or cross authorisation boundaries, they can be good because then you can assert using public/private key cryptography that the token your presented really came from the authorising server | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 293] | 1427986367905161221 | 14063149 | ThisIsMissEm | 0 | 1 | 14 | 0 | 0 | en | ||||||||
1428028645755416589 | swyx 33521530 | 2021-08-18T16:18:55+00:00 | RT @tina_cms: We just launched our public beta: - Brand new dashboard - Media Manager with @cloudinary - Command line quickstart - And mu… | 1428016338371452930 1428016338371452930 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 52 | 0 | 0 | 1 | en | ||||||||||
1428113221236363267 | swyx 33521530 | 2021-08-18T21:54:59+00:00 | @lillichoung gotta look at who is doing the recommending. JWT is very convenient for serverless and vendors. meanwhile everyone running rails and django set up sessions, send httponly cookies and carry on with their day. the only vendor who does it right is @begin https://twitter.com/swyx/status/1254871936514969600?s=21 | 1254871936514969600 1254871936514969600 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 289] | 1428111899502288902 | 2336043613 | lillichoung | 1 | 0 | 3 | 0 | 0 | 0 | en | ||||||
1428114812249071618 | swyx 33521530 | 2021-08-18T22:01:18+00:00 | RT @sugarpirate_: I'm sorta back from a long twitter break! I've been spending my free time slowly getting through @thorstenball's excellen… | 1428061205902630916 1428061205902630916 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 4 | 0 | 0 | 1 | en | ||||||||||
1427804453462110222 | swyx 33521530 | 2021-08-18T01:28:03+00:00 | @ferreiracoder @RegalizDev 🤗 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [27, 28] | 1427803823444217863 | 1255874155792216070 | ferreiracoder | 0 | 0 | 1 | 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]);