tweets
5 rows where "created_at" is on date 2021-07-27 and is_quote_status = 1 sorted by lang
This data as json, CSV (advanced)
Suggested facets: display_text_range, retweeted
user 2 ✖
- swyx 4
- Cindy Sridharan 1
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1419836176681213952 | swyx 33521530 | 2021-07-27T01:44:58+00:00 | Suddenly reminded of this @bcantrill talk: https://youtu.be/30jNsCVLpAE and I think I have my answer - If it takes you 2 days to chase down an intermittent bug, perhaps that *IS* the bug. Even though this talk is 4 years old but feels like @mipsytipsy is beating the same drum today. https://twitter.com/swyx/status/1419434119319093250 | 1419434119319093250 1419434119319093250 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 280] | 1 | 3 | 15 | 0 | 0 | 0 | en | |||||||||
| 1420050980310183936 | swyx 33521530 | 2021-07-27T15:58:31+00:00 | This is an incredible video: https://twitter.com/discord/status/1418617539404308482?s=20 Writeup: https://blog.discord.com/meet-the-discord-users-who-imagined-a-place-657325b75fa6 It's a quirky amalgam of Discord memes with Awkwafina, Danny Devito, Grimes, MKBHD, flying flaming cows, and eggs. Totally ineffective at explaining what Discord is, but captures how it FEELS. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 1378408503597965316 | 33521530 | swyx | 1 | 1 | 8 | 0 | 0 | 0 | en | |||||||
| 1420086929261961217 | swyx 33521530 | 2021-07-27T18:21:22+00:00 | Feeling this again. Really humbling to interview people (eg early Google and Docker) and understanding how great problems attract great talent. https://twitter.com/swyx/status/1189555830544355330 | 1189555830544355330 1189555830544355330 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 143] | 1 | 0 | 26 | 0 | 0 | 0 | en | |||||||||
| 1420135785987117060 | Cindy Sridharan 161667651 | 2021-07-27T21:35:30+00:00 | Instant buy!! The first edition is one of my all time favorite books! Everyone writing software should read it! Even if the second edition just had minor typo fixes, I’d buy it and read it all over again! https://twitter.com/JohnOusterhout/status/1420053240717086721 | 1420053240717086721 1420053240717086721 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 207] | 1 | 6 | 86 | 0 | 1 | 0 | en | |||||||||
| 1420136685472342016 | swyx 33521530 | 2021-07-27T21:39:05+00:00 | RT @copyconstruct: Instant buy!! The first edition is one of my all time favorite books! Everyone writing software should read it! Even… | 1420135785987117060 1420135785987117060 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 139] | 1 | 6 | 0 | 0 | 1 | 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]);