tweets
5 rows where "created_at" is on date 2021-08-15 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20" sorted by lang
This data as json, CSV (advanced)
Suggested facets: user, retweet_count, favorite_count, retweeted
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1426720722940960776 | swyx 33521530 | 2021-08-15T01:41:42+00:00 | @Julian @amandanat @jwmares @DruRly @Backlinko @fadeke_adegbuyi @lennysan @packyM @ali_montag @MorningBrew @theskimm @JamesClear @scottsflights i mean i can think of dozens of link roundup letters but nothing with james comes to mind haha i’ll throw in a free plug for @litcapital’s letter. its the kind of daily financial markets link roundup i used to get from sellside brokers. very good for skimming thru datapoints. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [144, 421] | 1426716246813200391 | 293815131 | Julian | 0 | 0 | 1 | 0 | 0 | en | ||||||||
| 1426723425565876230 | swyx 33521530 | 2021-08-15T01:52:26+00:00 | @iansu glad you got it haha | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [7, 27] | 1426722986782969857 | 15755614 | iansu | 0 | 0 | 1 | 0 | 0 | en | ||||||||
| 1426749508524797952 | swyx 33521530 | 2021-08-15T03:36:05+00:00 | Random idea: “Information Dietician” Studies the difference between what you consume and what you want to produce and gives you a plan for diet change, with weekly group checkins. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 180] | 0 | 3 | 74 | 0 | 0 | en | |||||||||||
| 1426944198519885824 | swyx 33521530 | 2021-08-15T16:29:42+00:00 | RT @Mappletons: @swyx 17. This collection has now matured into a full grown essay documenting the history of "digital gardening" as an etho… | 1426937335460114441 1426937335460114441 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 16 | 0 | 0 | 1 | en | ||||||||||
| 1426972669468045318 | hiten.eth 3382 | 2021-08-15T18:22:50+00:00 | Every piece of business advice should have a label that includes what stage of a startup it’s applicable for. Since these labels don’t exist today, your job is to filter the advice against whether it’s relevant at your current stage and for your startup. This is learned by doing. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 280] | 1426971885628116994 | 3382 | hnshah | 0 | 20 | 223 | 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]);