tweets
11 rows where "created_at" is on date 2021-10-03 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20" sorted by lang
This data as json, CSV (advanced)
Suggested facets: is_quote_status, retweet_count, favorite_count
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1444498121854124035 | swyx 33521530 | 2021-10-03T03:02:44+00:00 | this is a worthwhile talk (direct link https://youtu.be/hV3dJur69SU) We are dealing w/ similar issues at @temporalio: how to guide someone to learn your system and be able to find the answer to every important question in the shortest time? Docs, like the SDLC, should be nonlinear. https://twitter.com/editingemily/status/1443381760935534592 | 1443381760935534592 1443381760935534592 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 280] | 1 | 0 | 5 | 0 | 0 | 0 | en | |||||||||
| 1444498974283423746 | swyx 33521530 | 2021-10-03T03:06:07+00:00 | @threehourcoffee @MeetKevon fwiw i watched on 1.5x and aggressively used the time skip button. life is too short for slow pacing! but episode 6 is worth taking slow | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [28, 164] | 1444476922474352643 | 28257675 | threehourcoffee | 0 | 0 | 4 | 0 | 0 | en | ||||||||
| 1444500678806630402 | swyx 33521530 | 2021-10-03T03:12:54+00:00 | @lucperkins @cohix @planetscaledata @Cloudflare @CivoCloud @PulumiCorp @SuborbitalDev @temporalio what techs would you use if you didnt have Temporal? just trying to see where it sits in your mind | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [98, 196] | 1444388249338662914 | 68474641 | lucperkins | 0 | 0 | 0 | 0 | 0 | en | ||||||||
| 1444503472699707395 | swyx 33521530 | 2021-10-03T03:24:00+00:00 | @ken_wheeler have i introduced you to the “Mystery Recapped” and “Movie Recapped” channels on youtube yet? just browse the most popular videos | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 142] | 1444440727115665420 | 167193309 | ken_wheeler | 0 | 0 | 2 | 0 | 0 | en | ||||||||
| 1444511985832382468 | swyx 33521530 | 2021-10-03T03:57:49+00:00 | @tannerlinsley @kentcdodds tanner i was only joking | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [27, 51] | 1444482851160817674 | 50136899 | tannerlinsley | 0 | 0 | 7 | 0 | 0 | en | ||||||||
| 1444513081564930052 | swyx 33521530 | 2021-10-03T04:02:11+00:00 | RT @1scrummymummy: I love this kid. She’s got it absolutely figured out. Emma aged 8 ❤️ https://twitter.com/1scrummymummy/status/1444024564921638917/photo/1 | 1444024564921638917 1444024564921638917 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 111] | 0 | 20929 | 0 | 0 | 1 | 0 | en | |||||||||
| 1444532242655498242 | swyx 33521530 | 2021-10-03T05:18:19+00:00 | RT @jaltma: This is probably somewhat of a golden age of startup creation: - we more or less know how to build startups now. Almost a scie… | 1444371187203641346 1444371187203641346 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 147 | 0 | 0 | 1 | en | ||||||||||
| 1444577475552432131 | swyx 33521530 | 2021-10-03T08:18:03+00:00 | @dtinth this would be a good talk/blogpost, in case you ever want content ideas :) | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [8, 82] | 1444576307786883072 | 12740012 | dtinth | 0 | 0 | 3 | 0 | 0 | en | ||||||||
| 1444793748110512131 | swyx 33521530 | 2021-10-03T22:37:27+00:00 | RT @swyx: 🔥 Excited to share my podcast with @mhevery today! We talked: - @BuilderIO & Headless CMSes - @adamdbradley's Partytown - @QwikD… | 1444726528395210756 1444726528395210756 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 144] | 0 | 15 | 0 | 0 | 1 | en | ||||||||||
| 1444477575401590787 | swyx 33521530 | 2021-10-03T01:41:05+00:00 | @suiteasdesign yup http://swyx.transistor.fm | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [15, 42] | 1444475505638449157 | 1223050713674027008 | suiteasdesign | 0 | 0 | 1 | 0 | 0 | 0 | und | |||||||
| 1444500886546305033 | swyx 33521530 | 2021-10-03T03:13:43+00:00 | @flybayer @cohix @planetscaledata @Cloudflare @CivoCloud @PulumiCorp @SuborbitalDev @Flightcontrolhq @temporalio https://twitter.com/swyx/status/1444500886546305033/photo/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [112, 112] | 1444313802162454532 | 2826554209 | flybayer | 0 | 0 | 1 | 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]);