tweets
8 rows where "created_at" is on date 2021-11-23, favorite_count = 1 and retweeted = 0 sorted by lang
This data as json, CSV (advanced)
Suggested facets: in_reply_to_user_id, in_reply_to_screen_name, is_quote_status, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1462991909756956673 | swyx 33521530 | 2021-11-23T03:50:27+00:00 | @afit @ananbatra @benbarbersmith @arvidkahl @reincubate i have to confess i tried using Camo but the phone kept turning off. i dont want to have to get up and turn the thing on whenever i jump on a call, and yet i dont want an always on phone burning its screen for no reason. is there an auto wake option? | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [56, 306] | 1462832200177664010 | 19658693 | afit | 0 | 0 | 1 | 0 | 0 | en | ||||||||
| 1463005926386896902 | swyx 33521530 | 2021-11-23T04:46:08+00:00 | @SloanCam @_alex_buzin i’ve just gone ahead and blocked him, thank you | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [23, 70] | 1462834672363192321 | 502208743 | SloanCam | 0 | 0 | 1 | 0 | 0 | en | ||||||||
| 1463030661254561793 | swyx 33521530 | 2021-11-23T06:24:26+00:00 | @fortelabs used http://lu.ma as well for the recent #SvelteSummit NYC event https://twitter.com/swyx/status/1462323377553694722?s=21 | 1462323377553694722 1462323377553694722 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [11, 110] | 1462992587246030855 | 1909232666 | fortelabs | 1 | 0 | 1 | 0 | 0 | 0 | en | ||||||
| 1463032809094725635 | swyx 33521530 | 2021-11-23T06:32:58+00:00 | @fortelabs yep. i run my company meetups and workshops on it too. considered investing but didnt really see the vision beyond “eventbrite that doesnt suck” | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [11, 155] | 1463031322276859904 | 1909232666 | fortelabs | 0 | 0 | 1 | 0 | 0 | en | ||||||||
| 1463069720802783244 | swyx 33521530 | 2021-11-23T08:59:38+00:00 | @gr2m @temporalio we frame it as “It is designed with TypeScript-first developer experience in mind, but works equally well with JavaScript.” in our docs this is because the team feels strongly that type safety should be heavily recommended as part of the DX of using Temporal. Eliminates footguns | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [18, 298] | 1462998929562214404 | 11754732 | gr2m | 0 | 0 | 1 | 0 | 0 | en | ||||||||
| 1463222745978736641 | swyx 33521530 | 2021-11-23T19:07:42+00:00 | @lorendsr @temporalio thanks Loren its been great working on it with you! | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [22, 73] | 1463197242572132352 | 215488966 | lorendsr | 0 | 0 | 1 | 0 | 0 | en | ||||||||
| 1463249154809819140 | swyx 33521530 | 2021-11-23T20:52:39+00:00 | @fortelabs yup you can email everyone who joined at any time https://lu.ma/sveltenyc https://twitter.com/swyx/status/1463249154809819140/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [11, 85] | 1463247759448834048 | 1909232666 | fortelabs | 0 | 0 | 1 | 0 | 0 | 0 | en | |||||||
| 1463031773919465473 | swyx 33521530 | 2021-11-23T06:28:51+00:00 | @galeforceVC - Entertain! | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 25] | 1462956203902918658 | 41519559 | galeforceVC | 0 | 0 | 1 | 0 | 0 | fr |
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]);